Print Page | Close Window

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

i hed it in my old ver but now i cant compare the files

 Posted: May/01/2003 at 1:42pm - IP Logged http://www.jbdevstudios.com/forum/post_message_form.asp?mode=quote&threadID=838&ReturnPage=Thread&ForumID=10&TopicID=128&PagePosition=1&ThreadPage=1&ThreadPos=1">Quote Joshua
Avatar

Forum Administrator
United States
Posts: 333 Posts
Member No.: 1
Joined: Dec/20/2002
.
Offline
http://www.jbdevstudios.com/forum/pm_new_message_form.asp?name=Joshua">Send Private Message http://www.jbdevstudios.com/forum/pm_buddy_list.asp?name=Joshua">Add to Buddy List http://www.jbdevstudios.com/">Visit Joshua's Homepage 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">Search for other posts by Joshua

this from http://www.jbdevstudios.com/ - http://www.jbdevstudios.com/

look is status ... OFFLINE ... how i add this to my forum ? i want to show the member status in his posts plz help




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
Originally posted by PrimeraRacer PrimeraRacer wrote:

if I'm thinking correctly

I don't think so.

Originally posted by PrimeraRacer PrimeraRacer wrote:

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.

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...


Posted By: Gullanian
Date Posted: 27 May 2003 at 6:16pm

Not that hard to do!

strSQL = "SELECT * from tblActiveUsers where Author_ID = " & intPostersID
rsCommon.open strSQL, adoCon

if rsCommon.eof or rsCommon.bof then
  Response.write("Offline")
else
  Response.write("Online")
end if

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
rsCommon.open strSQL, adoCon

if rsCommon.eof or rsCommon.bof then
Response.write("<BR><BR><BR><B><FONT COLOR=""#FF0000"">Offline</FONT></B>")
else
Response.write("<BR><BR><BR><B><FONT COLOR=""#0000FF"">Online</FONT></B>")
end if


rsCommon.close

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
rsCommon.open strSQL, adoCon

if rsCommon.eof or rsCommon.bof then
Response.write("<BR><BR><BR><B><FONT COLOR=""#FF0000"">Offline</FONT></B>")
else
Response.write("<BR><BR><BR><B><FONT COLOR=""#0000FF"">Online</FONT></B>")
end if


rsCommon.close



-------------
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
Originally posted by vdub vdub wrote:

Enter this at line 804 in the forum_posts.asp in ver. 7.0

strSQL = "SELECT * from tblActiveUser where Author_ID = " & lngUserID
rsCommon.open strSQL, adoCon

if rsCommon.eof or rsCommon.bof then
Response.write("<BR><BR><BR><B><FONT COLOR=""#FF0000"">Offline</FONT></B>")
else
Response.write("<BR><BR><BR><B><FONT COLOR=""#0000FF"">Online</FONT></B>")
end if


rsCommon.close

Nice mod I have been looking for a way to do this

Read the whole post.



-------------
http://www.CyberCPU.net - Hardware reviews, Forum, Free advertising!!!!



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net