BeBot - An Anarchy Online and Age Of Conan chat automaton

Archive => Anarchy Online Archive => AO 0.6 support => Topic started by: squattinbull on February 24, 2009, 04:43:52 am

Title: whois
Post by: squattinbull on February 24, 2009, 04:43:52 am: Hello everyone,

Loving this bot so far. Just having an issue or two here. The bot won't post anyone's lvl in AOC when anyone logs on. Is this a whois issue?

I see this in the command prompt window:

MySQL error (#0) on query: INSERT INTO whois (id, nickname, level, class, craft1, craft2, location, online, update) VALUES

After VALUES it all seems fine and shows the guild member's information and what not. Is there any resolve to this. I did as the first guy stated re-set up SQL and re-did the bebot and it is still doing this. In game everything apears to be working just fine. However I notice it does not state each character's level when they log on. It will state their name then say
Level ()

Hopefully this gives enough information to work with. If not please let me know what you need and I will add whatever information is needed to resolve this issue for us. Thanks in advance.
Title: Re: whois
Post by: Alreadythere on February 25, 2009, 07:05:19 pm: Which bebot version are you using?
Title: Re: whois
Post by: squattinbull on February 25, 2009, 09:04:34 pm: Quote from: Alreadythere on February 25, 2009, 07:05:19 pm
Which bebot version are you using?

I'm using the 0.6.2 version
Title: Re: whois
Post by: Temar on February 25, 2009, 09:15:55 pm: This issue was Fixed After 0.6.2 and will be in 0.6.3
here is the latest file
put in
core/aoc/

Download
http://www.aofiles.com/index.php?action=user_file&owner=temar&file=core%20Whois.php%20for%20AoC
Title: Re: whois
Post by: squattinbull on February 25, 2009, 09:44:40 pm: Quote from: Temar on February 25, 2009, 09:15:55 pm
This issue was Fixed After 0.6.2 and will be in 0.6.3
here is the latest file
put in
core/aoc/

Download
http://www.aofiles.com/index.php?action=user_file&owner=temar&file=core%20Whois.php%20for%20AoC

Thank you for the response Temar but that core file didn't work. I'm still having the same issues. It's really funky. Don't get it. But you said it should get resolved in the next update right, bro?

Thanks
~Bull~
Title: Re: whois
Post by: Temar on February 25, 2009, 10:41:30 pm: that file i posted was the latest and contained the fix, or so i thought
Title: Re: whois
Post by: squattinbull on February 26, 2009, 12:32:48 am: Quote from: Temar on February 25, 2009, 10:41:30 pm
that file i posted was the latest and contained the fix, or so i thought

Any suggestion then of what to do next? I have the whois.php file in the bebot\core\aoc directory. Or is there another place I need to place this?

Actually I notice there are two Whois.php files. One in Modules and one in Core. I'm wondering if I should just download the newest bebot and start over from scratch. Well I have a lot of information already saved into this bot. If I do this, how do I keep all the data from being erased? Which file stores all the data? I will keep that one file but be gone with the rest.

Thanks,
~Bull~
Title: Re: whois
Post by: Temar on February 26, 2009, 01:39:54 am: there is suppose to be 2

and Data is Stored in MySQL Database, which is completely Seperate
So the only Files with stuff of yours in is the files in /conf/
Title: Re: whois
Post by: squattinbull on February 26, 2009, 04:13:13 am: Thank you Temar,

I did try redoing all of it from scratch. I'm still getting that lovely error MySQL. bleh. Thank you for putting up with me for so long. lol It's a headache, eesh.

No one's lvl is showing up when they log in.
Title: Re: whois
Post by: Temar on February 26, 2009, 05:51:57 am: try going into your MySQL and deleting the whois table
then start bot
it will make the table again hopefully fixing problem
Title: Re: whois
Post by: squattinbull on February 27, 2009, 06:15:33 am: Quote from: Temar on February 26, 2009, 05:51:57 am
try going into your MySQL and deleting the whois table
then start bot
it will make the table again hopefully fixing problem

Thanks, Temar again. :) Still no dice. Still getting that same error.
Title: Re: whois
Post by: squattinbull on March 08, 2009, 12:27:45 am: Wonder if a lil script may help? Would it help if I copy and paste script from any of the php files?
Title: Re: whois
Post by: Temar on March 08, 2009, 04:34:51 pm: it says your whois table doesn't exist, it should get created when bot loads

do you have a log/screen like above of when your bot loads (more important when it loads /core/aoc/whois.php)
Title: Re: whois
Post by: MysterF on March 11, 2009, 12:15:27 pm: I already posted a log here, maybe this 2 topics should merge: click on me (http://bebot.link/aoc-support/!whois-wont-work-for-one-of-my-bot-members/msg12354/?topicseen#new)

LATER EDIT Problem solved by dropping the WhoIS table.
Title: Re: whois
Post by: squattinbull on March 25, 2009, 02:37:12 pm: Last night I re-setup the bot from scratch removing all old files and everything. It now works great and no issues. I really do appreciate all the help everyone has given me on here with this. This bot is a beautiful thing for our guild. A very helpful tool for all of our members. Now we can all use it without flaw.

Thanks everyone,
~Bull~