| Author |
 Topic  |
|
crash
Advanced Member
Netherlands
2064 Posts |
 Posted - 10 September 2002 : 09:08:04
|
| well, since you did not give me the correct information, i wasn't able to help out. |
cHosting.nl |
 |
|
|
alex042
Average Member
USA
631 Posts |
Posted - 10 September 2002 : 09:12:40
|
quote:
well, since you did not give me the correct information, i wasn't able to help out.
I'm sure he probably wasn't aware of what the correct information might've been. He assumed, like most people, that the problem was within that section of code when it was actually above it.
|
|
|
|
alex042
Average Member
USA
631 Posts |
Posted - 10 September 2002 : 09:19:59
|
quote:
'### Returns Buddies Who Are Online
strSqlOnline = "SELECT " & strMemberTablePrefix &
"MEMBERS.M_NAME," & strMemberTablePrefix & "ONLINE.M_BROWSE"
strSqlOnline = strSqlOnline & " FROM (" & strMemberTablePrefix &
"ONLINE INNER JOIN " & strMemberTablePrefix & "MEMBERS ON " &
strMemberTablePrefix & "ONLINE.UserID =" & strMemberTablePrefix &
"MEMBERS.M_NAME) INNER JOIN " & strMemberTablePrefix &
"BUDDYS ON " & strMemberTablePrefix & "MEMBERS.MEMBER_ID = "
& strMemberTablePrefix & "BUDDYS.BUDMEMBERID"
rsOnline.open strSqlonline, my_Conn
'###
If you're using the original buddy MOD, try changing that to this:
'### Returns Buddies Who Are Online
strSqlOnline = "SELECT " & strMemberTablePrefix & "MEMBERS.M_NAME," & strMemberTablePrefix & "ACTIVE_USERS.AU_LASTPAGE"
strSqlOnline = strSqlOnline & " FROM (" & strMemberTablePrefix & "ACTIVE_USERS INNER JOIN " & strMemberTablePrefix & "MEMBERS ON " & strMemberTablePrefix & "ACTIVE_USERS.MEMBER_ID =" & strMemberTablePrefix & "MEMBERS.MEMBER_ID) INNER JOIN " & strMemberTablePrefix & "BUDDYS ON " & strMemberTablePrefix & "MEMBERS.MEMBER_ID = " & strMemberTablePrefix & "BUDDYS.BUDMEMBERID"
rsOnline.open strSqlonline, my_Conn
'###
|
Edited by - alex042 on 10 September 2002 09:23:02 |
|
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 10 September 2002 : 09:20:56
|
| that was why i wanted to see the query, to confirm it wasn't that specific one... |
cHosting.nl |
|
|
|
Alex123
Junior Member
Greece
237 Posts |
Posted - 10 September 2002 : 10:02:45
|
Thank you Alex,
After replacing that section I am getting the following:
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/forum/buddy.asp, line 139
I am giving you the section where line 139 is:
132 ' List buddies
133
134
135 do until rs.eof
136
137 if not rsOnline.eof then
138 if rsOnline("M_NAME")= rs("m_name") then
139 onlinestatus = rsonline("M_BROWSE")
140 rsOnline.movenext
141 else
142 onlinestatus = "Offline"
Thank you again. |
Edited by - Alex123 on 10 September 2002 10:04:06 |
|
|
|
alex042
Average Member
USA
631 Posts |
Posted - 10 September 2002 : 10:42:38
|
quote:
139 onlinestatus = rsonline("M_BROWSE")
Change to:
139 onlinestatus = rsonline("AU_LASTPAGE")
|
|
|
|
alex042
Average Member
USA
631 Posts |
Posted - 10 September 2002 : 10:50:21
|
quote:
"BOOKMARKS.BKMRK_EEID"
same for pop_buddy.asp then u won't get only 1 online always!
Good catch. That makes sense. We want to bookmark the bookmarkee not the bookmarker.
|
|
|
|
alex042
Average Member
USA
631 Posts |
Posted - 10 September 2002 : 10:56:16
|
quote:
you
also need some change to take care the M_AUHIDE value. so if
member hide the active user option, he'll not show at buddy list too.
Good idea. I'll have to look into including that in an update.
Something else that was pointed out to me was a defect carried over from the original MOD with memory leaks from unclosed recordsets. This needs to be added to the end of the code right before 'writefooter':
rs.close
set rs = nothing
rs2.close
set rs2 = nothing
rsmember.close
set rsmember = nothing
rsonline.close
set rsOnline = nothing
|
|
|
|
Alex123
Junior Member
Greece
237 Posts |
Posted - 10 September 2002 : 10:59:53
|
Thank you Alex  It works fine.
Only one last thing, (I hope you are not ready to kill me), under the "online status" instead of showing the name of the page, for example: "My Buddy List" (which used to be as a link), it now just says: buddy.asp.
Is there a way to change this, I really don't know where to even look for this.
Thank you again very much for all your help.
Alex |
|
|
|
alex042
Average Member
USA
631 Posts |
Posted - 10 September 2002 : 11:37:31
|
quote:
Cheers, i modified a code a bit since AU_LASTPAGE shows only topic.asp or the name of the page so i just wrote there Online - Send PM.. and link! Simple :)
If you have privatemessages turned on in the code, you should get the PM icon and an link to PM.
|
|
|
|
alex042
Average Member
USA
631 Posts |
Posted - 10 September 2002 : 11:45:59
|
quote:
Only one last thing, (I hope you are not ready to kill me), under the "online status" instead of showing the name of the page, for example: "My Buddy List" (which used to be as a link), it now just says: buddy.asp. Is there a way to change this, I really don't know where to even look for this.
A link to what? The page they're viewing?
|
|
|
|
zoomdubai
Starting Member
25 Posts |
Posted - 10 September 2002 : 11:50:39
|
| i know it already has a Icon, but since it was writing filename.asp so there is no point. Any other better ideas on how can i show complete like active users viewing topic etc.. |
|
|
|
Alex123
Junior Member
Greece
237 Posts |
Posted - 10 September 2002 : 12:03:33
|
Yes Alex, it used to show the name of the page they are viewing, as a link, and also for example if someone was at the buddy.asp page, the name of the page, was not like "buddy.asp" but as "My Buddy List" etc.
Thank you again very much
Alex |
Edited by - Alex123 on 10 September 2002 12:05:34 |
|
|
|
alex042
Average Member
USA
631 Posts |
Posted - 10 September 2002 : 12:26:51
|
quote:
it used to show the name of the page they are
viewing, as a link, and also for example if someone was at the
buddy.asp page, the name of the page, was not like "buddy.asp"
but as "My Buddy List" etc.
Hm, It looks like Active Users 3.5 might've pulled that information, but I don't see it in 4.0. Some old 3.5 code may have to be used to get this to work again.
|
|
|
|
Alex123
Junior Member
Greece
237 Posts |
Posted - 10 September 2002 : 12:51:41
|
Alex,
Couldn't it be that something needs to be changed to the buddy mod, so that it can now go look for that information from the Active Users 4 mod (instead of AU 3.5).
Since on the Active Users 4 Panel, it shows all that information.
For example if you are on the Active Users panel, it says that you are on "Active Users" page and not on "active_users.asp" etc.
Thank again
Alex
P.S Sorry if I said something stupid, I am not an expert  |
|
|
|
Topic |
|
Topic Locked
