BeBot - An Anarchy Online and Age Of Conan chat automaton

Archive => Age of Conan Archive => AoC 0.6 support => Topic started by: bl81 on June 08, 2010, 04:05:35 am

Title: Online members in web page
Post by: 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.

Title: Re: Online members in web page
Post by: Slacklin 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

Title: Re: Online members in web page
Post by: bl81 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?

Title: Re: Online members in web page
Post by: 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.

Title: Re: Online members in web page
Post by: bl81 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.