collapse collapse
* User Info
 
 
Welcome, Guest. Please login or register.
* Search

* Board Stats
  • stats Total Members: 989
  • stats Total Posts: 18366
  • stats Total Topics: 2501
  • stats Total Categories: 7
  • stats Total Boards: 35
  • stats Most Online: 1144

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

0 Members and 1 Guest are viewing this topic.

Offline Swiftgank

  • BeBot Rookie
  • *
  • Posts: 8
  • Karma: +0/-0
Anyone know how to fix !member adding?
« 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?

Offline Naturalistic

  • Contributor
  • *******
  • Posts: 221
  • Karma: +0/-0
Re: Anyone know how to fix !member adding?
« 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

220/25 Eternalist Doctor
-----------------------------
Campalot Coding Co-ordinator and Super Admin
http://www.campalot.info/index.php

Offline Swiftgank

  • BeBot Rookie
  • *
  • Posts: 8
  • Karma: +0/-0
Re: Anyone know how to fix !member adding?
« 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?

Offline Naturalistic

  • Contributor
  • *******
  • Posts: 221
  • Karma: +0/-0
Re: Anyone know how to fix !member adding?
« 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
220/25 Eternalist Doctor
-----------------------------
Campalot Coding Co-ordinator and Super Admin
http://www.campalot.info/index.php

Offline Alreadythere

  • BeBot Maintainer
  • BeBot Hero
  • ******
  • Posts: 1288
  • Karma: +0/-0
Re: Anyone know how to fix !member adding?
« 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.

Offline Swiftgank

  • BeBot Rookie
  • *
  • Posts: 8
  • Karma: +0/-0
Re: Anyone know how to fix !member adding?
« 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 :P

Offline Alreadythere

  • BeBot Maintainer
  • BeBot Hero
  • ******
  • Posts: 1288
  • Karma: +0/-0
Re: Anyone know how to fix !member adding?
« Reply #6 on: November 10, 2006, 02:08:33 pm »
Here 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 :)

 

* Recent Posts
Com bot module by bitnykk
[November 25, 2024, 05:36:11 pm ]


0.8.x updates for AO by bitnykk
[June 23, 2024, 03:19:47 pm ]


0.8.x updates for AoC by bitnykk
[June 23, 2024, 03:19:44 pm ]


[AoC] special char for items module by bitnykk
[February 09, 2024, 09:41:18 pm ]


BeBot still alive & kicking ! by bitnykk
[December 17, 2023, 12:58:44 am ]

* Who's Online
  • Dot Guests: 96
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.
* Forum Staff
bitnykk admin bitnykk
Administrator
Khalem admin Khalem
Administrator
WeZoN gmod WeZoN
Global Moderator
SimplePortal 2.3.7 © 2008-2024, SimplePortal