| Author |
 Topic  |
|
Bezo
Starting Member
6 Posts |
 Posted - 09 March 2003 : 10:34:42
|
I have searched and yet i have not found.
I downloaded this mod for my forum , but it was not the one i wanted ....
The one i am searching for looks like this one:
and this one ...shows online status
(hunting high and low A-HA) .
|
Edited by - Bezo on 09 March 2003 18:05:36 |
|
|
PeeWee.Inc
Senior Member
United Kingdom
1893 Posts |
Posted - 09 March 2003 : 10:54:06
|
That mod is not yet ready for 3.4.03.
The shading is done via CSS |
De Priofundus Calmo Ad Te Damine |
 |
|
|
Bezo
Starting Member
6 Posts |
Posted - 09 March 2003 : 11:13:01
|
Ok thank you for quick reply .
But that makes me ask ; what version do i need if i want that online mod working ? |
Edited by - Bezo on 09 March 2003 11:26:07 |
|
|
|
DavidRhodes
Senior Member
United Kingdom
1222 Posts |
Posted - 09 March 2003 : 13:08:16
|
| That should be an easy enough mod to implement if you have the Active Users mod installed. |
The UK MkIVs Forum |
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 09 March 2003 : 13:22:08
|
quote:
Originally posted by PeeWee.Inc
That mod is not yet ready for 3.4.03.
Maybe I am looking at the question the wrong way, but the feature is already part of the Active Users Mod.
 |
 |
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 09 March 2003 : 13:23:20
|
| oh, the one in the topic.asp ... yeah, I have the code for that, I'll post it here in a second. I did this in my members.asp and in the past did it for my topic.asp which I forgot to bring back, but is simple enough to add. |
|
Edited by - dayve on 09 March 2003 13:24:41 |
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 09 March 2003 : 13:41:17
|
Depending on where you want to place the status (under avatar assumed) find your code for your avatar mod and right below that segment add the following for Topics and Replies.
Replies Section:
strSql ="SELECT " & strTablePrefix & "ACTIVE_USERS.MEMBER_ID "
strSql = strSql & " FROM " & strTablePrefix & "ACTIVE_USERS "
strSql = strSql & " WHERE " & strTablePrefix & "ACTIVE_USERS.MEMBER_ID = '" & Reply_MemberID & "'"
set rsOnline = Server.CreateObject("ADODB.Recordset")
rsOnline.open strSql, my_Conn, 3
response.write "Status: "
if rsOnline.EOF or rsOnline.BOF then
' do nothing
else
if Reply_MemberID = rsOnline("MEMBER_ID") then
response.write "Online"
else
response.write "Offline"
end if
end if
rsOnline.close
set rsOnline = nothing
Topic Section (First Post):
strSql ="SELECT " & strTablePrefix & "ACTIVE_USERS.MEMBER_ID "
strSql = strSql & " FROM " & strTablePrefix & "ACTIVE_USERS "
strSql = strSql & " WHERE " & strTablePrefix & "ACTIVE_USERS.MEMBER_ID = '" & TMember_ID & "'"
set rsOnline = Server.CreateObject("ADODB.Recordset")
rsOnline.open strSql, my_Conn, 3
response.write "Status: "
if rsOnline.EOF or rsOnline.BOF then
' do nothing
else
if Members_MemberID = rsOnline("MEMBER_ID") then
response.write "Online"
else
response.write "Offline"
end if
end if
rsOnline.close
set rsOnline = nothing
admitting-ly this could be better. I use graphics in place of text myself. If you find that you are having difficult implementing this, then I'd be willing to have you email me your code and I will add it for you.
these are the icons that I use to display online status:
Online: 
Offline: 
|
|
Edited by - dayve on 09 March 2003 13:45:06 |
|
|
|
Bezo
Starting Member
6 Posts |
Posted - 09 March 2003 : 14:40:36
|
Thanks !
I have tried to apply the code but i get this message :
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
topic.asp, line 1041
ps : i have had the file uploaded here http://home.c2i.net/bentchr/zippz/topic.asp
|
Edited by - Bezo on 09 March 2003 14:49:28 |
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 09 March 2003 : 15:08:20
|
| I will look at it now, but have you installed the Active Users Mod yet? I guess I assumed that you had that mod installed. |
|
|
|
|
DavidRhodes
Senior Member
United Kingdom
1222 Posts |
Posted - 09 March 2003 : 15:21:45
|
| dayve, wouldn't it be more efficient to do a join with FORUM_ACTIVE_USERS when you get the initial recordset for topic.asp rather than getting a new recordset on each loop? |
The UK MkIVs Forum |
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 09 March 2003 : 15:58:00
|
quote:
Originally posted by DavidRhodes
dayve, wouldn't it be more efficient to do a join with FORUM_ACTIVE_USERS when you get the initial recordset for topic.asp rather than getting a new recordset on each loop?
yes it would, same thing that was just pointed out to me here 
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=42419 |
|
|
|
|
DavidRhodes
Senior Member
United Kingdom
1222 Posts |
Posted - 09 March 2003 : 16:03:26
|
lol, just read that myself!
How about you use the GetRows then use the function InArray() that is in inc_func_common.asp. As you don't need to determine a position it should be easy 
|
The UK MkIVs Forum |
|
|
|
Bezo
Starting Member
6 Posts |
Posted - 09 March 2003 : 16:53:13
|
"That should be an easy enough mod to implement if you have the Active Users mod installed"...and if i dont have installed it ?What then ?
|
|
|
|
PeeWee.Inc
Senior Member
United Kingdom
1893 Posts |
Posted - 09 March 2003 : 16:58:47
|
quote:
Originally posted by Bezo
"That should be an easy enough mod to implement if you have the Active Users mod installed"...and if i dont have installed it ?What then ?
You will need it installed as it calls from one of the tables in the DB that is used by AU |
De Priofundus Calmo Ad Te Damine |
|
|
|
Bezo
Starting Member
6 Posts |
Posted - 09 March 2003 : 17:18:40
|
SO i have to install Active Users mod ,
What Active Users mod is that ?
|
|
|
|
PeeWee.Inc
Senior Member
United Kingdom
1893 Posts |
Posted - 09 March 2003 : 17:23:58
|
| look on snitzbitz.com |
De Priofundus Calmo Ad Te Damine |
|
|
|
Topic |
|
Topic Locked
