BeBot - An Anarchy Online and Age Of Conan chat automaton

Archive => Anarchy Online Archive => BeBot 0.2 support => Topic started by: Swiftgank on November 09, 2006, 08:23:12 pm

Title: Anyone know how to fix !member adding?
Post by: Swiftgank on November 09, 2006, 08:23:12 pm

[2006-12-09 20:20:21]   [TELL]  [INC]   Swiftgank: !member malik1
MySQL error (# 0) on query: INSERT INTO members (id, nickname, firstname, lastna
me, rank, rank_name, level, profession, gender, breed, pic, guild, lvlrange, upd
ated)
                          VALUES ('1036060347',
                                  'Malik1', 'Lawl',
                                  'Agent', '',
                                  '', '124',
                                  'Agent', 'Male',
                                  'Opifex', 'http://www.anarchy-online.com/chara
cter/photos/40247.jpg',
                                  '', '100-149',

                                                        1165695636)
Incorrect integer value: '' for column 'rank' at row 1
[2006-12-09 20:20:36]   [TELL]  [OUT]   -> Swiftgank: Player malik1 has been add
ed to the bot.
[2006-12-09 20:20:36]   [TELL]  [OUT]   -> malik1: Swiftgank has added you to th
e bot.
[2006-12-09 20:20:36]   [BUDDY] [LOG]   Malik1 logged [off] (not member)


He is still not added as member and cant join the bot. Whats wrong?

Title: Re: Anyone know how to fix !member adding?
Post by: Naturalistic on November 09, 2006, 08:35:12 pm

You need to update the AOChat.php.

See http://bebot.link/index.php/topic,531

Title: Re: Anyone know how to fix !member adding?
Post by: Swiftgank on November 09, 2006, 09:23:51 pm

I downloaded that file with the fix, swapped it with the one i had in my folder (aochat.php), restarted bot. tried adding again. still same error. and hes still not member. Can someone tell me if im doing something wrong or is this some other problem then what was solved at the previous link?

Title: Re: Anyone know how to fix !member adding?
Post by: Naturalistic on November 09, 2006, 09:24:34 pm

Do you use PHP5? PHP4?

PHP4: That topic has it, but you need to scroll down to Nesi's other post with AOChat.rar

PHP5: Check out Neo's fix. http://bebot.link/index.php/topic,530

Title: Re: Anyone know how to fix !member adding?
Post by: Alreadythere on November 09, 2006, 11:21:34 pm

Problem is the '' in an integer field, some mysql versions or setups won't accept that as for 0.

So you have to edit the parsing of the FC XML data, and add a check. Should be something like

Code: [Select]

if ($member["org_rank"] == '')
$member["org_rank"] = 0;I'd guess the true field names are different, not sure which code you are using.

Title: Re: Anyone know how to fix !member adding?
Post by: Swiftgank on November 10, 2006, 01:20:15 pm

Im using the standard download 2.9 from the mainpage of this website. downloaded 3 days ago.
What i wonder is why dont the fixes work for me? i have swapped with noth nesi and neo's none of them work^^ im no php pro so i rather try to stay away from editing codes :P

Title: Re: Anyone know how to fix !member adding?
Post by: Alreadythere on November 10, 2006, 02:08:33 pm

Here (http://www.m8y.de/ao/bebot/Roster0.2.9.zip) is a zip with the modified roster files for 0.2.9. Only difference is the correction I mentioned in my last post.

Try your luck :)