Page 1 of 1

getOnlineList not working right

PostPosted: 26 May 2011, 17:02
by AZilic
Hi there.
I can not seem to get list of current users to show up.
All I see is "Loading..." while if I join a chat room count is correct. In other words, unless I look at the chat rooms it will always show zero logged in members.
All the test users are set to be "available".
Query in getOnlineList function looks little odd (no php guru here though):
Code: Select all
"SELECT DISTINCT ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." userid,....

which should translate into
SELECT DISTINCT pref_Table.Column userid
variables are defined in config.php so what is up wit the "userid"
Not sure if the two are related but could use some direction.
Thank you.

PostPosted: 27 May 2011, 10:36
by AZilic
Perhaps the issues is in the condition?
Code: Select all
      WHERE ('".time()."'-arrowchat_status.session_time - 60 < '".$online_timeout."')
         AND ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." <> '".$userid."'

Anyone?

PostPosted: 27 May 2011, 10:47
by AZilic
Ok so I found the 'fix' to this issue.
You have the have the "Disable Buddy List" checked or the sql does not account for the fact that you have no 'buddy/friends' system.
Leaving the values empty in the config.php should be enough of a trigger for this query to run normally.
A bug in logic?

Thanks.

Topic Closed

PostPosted: 07 Nov 2012, 12:40
by Staff Bot
This thread has been locked because the last post is greater than six months old. There is a good chance that the information in this thread is outdated. Please open a new topic if you wish to discuss this further.