Author Topic: Anyone know how to fix !member adding? (Read 3191 times)

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?

Naturalistic · « **Reply #1 on:** November 09, 2006, 08:35:12 pm »

You need to update the AOChat.php.

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

Swiftgank · « **Reply #2 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?

Naturalistic · « **Reply #3 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

Alreadythere · « **Reply #4 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.

Swiftgank · « **Reply #5 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