how i do that , ?
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=3052
Printed Date: 01 April 2026 at 7:26am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: how i do that , ?
Posted By: zadax
Subject: how i do that , ?
Date Posted: 27 May 2003 at 4:04am
http://www.jbdevstudios.com/forum/pm_buddy_list.asp?name=Joshua">
http://www.jbdevstudios.com/">
http://www.jbdevstudios.com/forum/search_form.asp?search=Joshua&searchIn=Author&forum=10&date=DESC&ReturnPage=Thread&ForumID=10&TopicID=128&PagePosition=1&ThreadPage=1&ThreadPos=1">
Replies:
Posted By: Trevni
Date Posted: 27 May 2003 at 4:15am
|
You're a "Mod Builder" make yourself a mod. You can check the active user table to see who is online and who is offline. Or you can add a true/false row to the users table and when they login update their status to true when they log out update their status to false and you get online and offline users.
Go, go, go, "Mod Builder Group"! It's sad really. ------------- Resident immature brat... |
Posted By: zadax
Date Posted: 27 May 2003 at 4:57am
|
grrrrrrrr i did it in my old forum ... but now i get a lot of erors |
Posted By: PrimeraRacer
Date Posted: 27 May 2003 at 7:58am
|
I'd like this too. if I'm thinking correctly it should be a case of having a bit of code that selects all the active users then references those against the name its displaying. if one = the other then online. if not = the other then offline. I like this very much so I'll have a go at doing it later :) should it be done under a stored procedure do you think or will speed not be too much of an issue? |
Posted By: Trevni
Date Posted: 27 May 2003 at 3:57pm
I don't think so.
Reference against what names displaying? Where and from where are the names being displayed? All the users online are stored in one table. Should we excuse your gibberish? ------------- Resident immature brat... |
PrimeraRacer wrote:Posted By: Gullanian
Date Posted: 27 May 2003 at 6:16pm
|
Not that hard to do! strSQL = "SELECT * from tblActiveUsers where Author_ID = " & intPostersID if rsCommon.eof or rsCommon.bof then rsCommon.close Youll need to change a couple of things in that, cant get the the page right now |
Posted By: zadax
Date Posted: 28 May 2003 at 11:15am
|
well i get this eror
Microsoft VBScript runtime error '800a01f4' Variable is undefined: 'intPostersID'
|
Posted By: Gullanian
Date Posted: 28 May 2003 at 11:23am
| The variable isnt intPostersID i dont have borgs code handy to look it up, hence me saying youll need to change a few bits on it |
Posted By: Norrad
Date Posted: 28 May 2003 at 2:40pm
Try This, you will have to enable active users in your control panel to use it 
<% 'Declaration of variables Dim rsUserOnline Dim rsActiveUsers If NOT strUsername = "Guest" Then Set rsUserOnline = Server.CreateObject("ADODB.Recordset") Set rsActiveUsers = Server.CreateObject("ADODB.Recordset") 'Initalise the strSQL variable with an SQL statement to query the database strSQL = "SELECT " & strDbTable & "activeUser.* FROM " & strDbTable & "ActiveUser WHERE " & strDbTable & "ActiveUser.Author_ID=" & lngUserID rsUserOnline.Open strSQL, strCon rsActiveUsers.Open strSQL, strCon If NOT rsUserOnline.EOF Then blnHideActiveUser = CBool(rsActiveUsers("Hide")) If rsUserOnline.EOF Then Response.Write "<center>Offline</center>" ElseIf blnHideactiveUser = True Then 'display the user as an annoy Response.Write("<center>Offline</center>") Else Response.Write "<center>Online</center>" End If rsUserOnline.Close Set rsUserOnline = Nothing rsActiveUsers.Close Set rsActiveUsers = Nothing End If %> |
Posted By: Gullanian
Date Posted: 28 May 2003 at 2:56pm
| why two recorsets? |
Posted By: vdub
Date Posted: 28 May 2003 at 10:31pm
|
Enter this at line 804 in the forum_posts.asp in ver. 7.0 strSQL = "SELECT * from tblActiveUser where Author_ID = " & lngUserID if rsCommon.eof or rsCommon.bof then
Nice mod I have been looking for a way to do this ------------- http://www.CyberCPU.net - Hardware reviews, Forum, Free advertising!!!! |
Posted By: zadax
Date Posted: 28 May 2003 at 11:20pm
|
vdub did u made it ? .... i am Stuck ... plz help me ... if u know how to do it plz Pm 
|
Posted By: vdub
Date Posted: 28 May 2003 at 11:49pm
|
All I did is mod the OG code. The first reply had some code that would error all I did is change the line in blue. strSQL = "SELECT * from tblActiveUser where Author_ID = " & lngUserID if rsCommon.eof or rsCommon.bof then
------------- http://www.CyberCPU.net - Hardware reviews, Forum, Free advertising!!!! |
Posted By: Allan_Young
Date Posted: 29 May 2003 at 8:35am
|
Message deleted by Allan_Young (cos I'm stupid and didn't read the full thread!) Sorry ------------- Everyone has a photographic memory, its just that some are out of film |
Posted By: vdub
Date Posted: 29 May 2003 at 10:11am
Read the whole post. ------------- http://www.CyberCPU.net - Hardware reviews, Forum, Free advertising!!!! |