Author Topic: Online members in web page (Read 1831 times)

bl81 · « **on:** June 08, 2010, 04:05:35 am »

Trying to display which members are online in webpage. Everything is set up, but it's showing members that are not online. What do I need to verify that someone is actually online, or does the bot take awhile to update this?

Code: [Select]

$sql = 'SELECT DISTINCT online.nickname, online.status_gc, whois.level, whois.class
FROM online, whois
WHERE online.status_gc = 1 AND online.nickname = whois.nickname
ORDER BY online.nickname ASC, whois.class ASC, whois.level DESC';

Thanks for any thoughts/suggestions.

Slacklin · « **Reply #1 on:** June 08, 2010, 08:22:07 am »

This is the query that I use.

Code: [Select]

SELECT online.nickname, whois.profession, whois.level
FROM online, whois
WHERE online.status_gc = 1 AND online.nickname = whois.nickname
ORDER BY whois.profession ASC, whois.level DESC, online.nickname ASC

It works for me. Not sure why yours isn't updating.

I posted my entire online script at http://bebot.link/ao-0-6-support/online-query/msg12818/#msg12818

bl81 · « **Reply #2 on:** June 08, 2010, 05:27:45 pm »

Yeah, I used your code as the base for mine with some minor changes. Thank you.

I should clarify a bit, it's not showing all offline members, only a select few. Perhaps there's something up with these particular members as I am using your condition for checking online status which should work fine.

Anyone else ran across this?

Khalem · « **Reply #3 on:** June 08, 2010, 05:55:48 pm »

Sounds like you might have some entries in your online table from other bots.

You probably want to add an WHERE botname check or just clear the online table of any old data.

bl81 · « **Reply #4 on:** June 08, 2010, 07:57:45 pm »

Quote from: Khalem on June 08, 2010, 05:55:48 pm

Sounds like you might have some entries in your online table from other bots.

You probably want to add an WHERE botname check or just clear the online table of any old data.

You know, I think that's exactly right. Switched bot names, and deleted all the old_botname_tables but there's only one whois/online table.

Thanks a lot.

Edit: Was exactly the problem, thanks Khalem.