Aesgaard
Rookie
 Offline
Gender: 
Posts: 73
.:.Alpha.:.
|
 |
« on: June 21, 2007, 12:23:25 AM » |
|
[2007-06-21 04:02:45] [GROUP] [MSG] [All Towers] 0: Cyborg Lieutenant Genera
l just attacked the omni organization Transcendence's tower in Perpetual Wastela
nds at location (3796, 2559).
MySQL error (# 0) on query: INSERT INTO tower_attack (time, off_guild, off_side,
off_player, off_level, off_profession,
def_guild, def_side, zone, x_coord, y_coor
d) VALUES ('1182398566', '', '',
'Cyborg Lieutenant General', '0', 'Unknown
', 'Transcendence', 'Omni',
'Perpetual Wastelands', '3796', '2559')
Data too long for column 'off_player' at row 1
what the heckler ?
|
|
|
|
|
Logged
|
-*tinkers*-
|
|
|
|
Alreadythere
|
|
« Reply #1 on: June 21, 2007, 02:20:25 AM » |
|
off_player can hold 20 letters. The mob name was longer. Anyways, it's no character so I doubt it should be entered into the table anyways.
|
|
|
|
|
Logged
|
|
|
|
|
Glarawyn
|
|
« Reply #2 on: June 21, 2007, 10:45:45 AM » |
|
off_player can hold 20 letters. The mob name was longer. Anyways, it's no character so I doubt it should be entered into the table anyways.
Or we should trim the input before inserting as mob attacks on towers happen often enough. |
|
|
|
|
Logged
|
|
|
|
|
Ebag333
|
|
« Reply #3 on: June 21, 2007, 11:02:40 AM » |
|
Indeed using a charmed mob or a pet to attack is an old trick.
|
|
|
|
|
Logged
|
|
|
|
|
Temar
|
|
« Reply #4 on: June 21, 2007, 02:20:53 PM » |
|
easy thing is just make the mysql field bigger
|
|
|
|
|
Logged
|
MSN messenger: chris_smith96 at hotmain dot com
Xfire: chriss96
|
|
|
|
Khalem
|
|
« Reply #5 on: June 21, 2007, 03:13:10 PM » |
|
And even simpler, just check if its a valid character name (ie, if it contains spaces, its a mob) and if not, insert just NPCMonster as the attacker in the database.
|
|
|
|
|
Logged
|
BeBot Founder and Fixer Kingpin
Madman coder and destroyer of good code
|
|
|
Aesgaard
Rookie
Offline
Gender:
Posts: 73
.:.Alpha.:.
|
|
« Reply #6 on: June 22, 2007, 08:26:38 AM » |
|
How about : [Helpbot]: Moqtada (L 24/AL 0), opifex Fixer, Clan, Applicant of Good Spirits while my bot goes : www.anarchy-online.com was too slow to respond ? xD mine goes like that even with my guildies  2.11 running on 6.0 mysql |
|
|
|
|
Logged
|
-*tinkers*-
|
|
|
|
Khalem
|
|
« Reply #7 on: June 22, 2007, 10:03:59 AM » |
|
Sounds like your bot is unable to connect to Funcom servers at all if you never get a response, you have been blocked by Funcom (not all that likely), or MySQL 6 which is Alpha software is causing issues.
|
|
|
|
|
Logged
|
BeBot Founder and Fixer Kingpin
Madman coder and destroyer of good code
|
|
|
|
tonyuh
|
|
« Reply #8 on: June 22, 2007, 11:13:23 AM » |
|
I do have that problem sometimes when the character has been created on the same day. So I assume FC's database hasn't been updated to include that char yet.
|
|
|
|
|
Logged
|
|
|
|
Aesgaard
Rookie
Offline
Gender:
Posts: 73
.:.Alpha.:.
|
|
« Reply #9 on: June 22, 2007, 12:15:15 PM » |
|
Nope had same problem with bot pre upgrade to 2.11 and mysql -> 6.0
also then it didnt show who attacked what where, and went completely boinkers when we got attacked
|
|
|
|
|
Logged
|
-*tinkers*-
|
|
|
|
Temar
|
|
« Reply #10 on: June 22, 2007, 01:21:32 PM » |
|
Maybe ur running Local Whois but arnt Getting Name for ur Local Database?
|
|
|
|
|
Logged
|
MSN messenger: chris_smith96 at hotmain dot com
Xfire: chriss96
|
|
|
Aesgaard
Rookie
Offline
Gender:
Posts: 73
.:.Alpha.:.
|
|
« Reply #11 on: July 05, 2007, 12:12:04 PM » |
|
Maybe ur running Local Whois but arnt Getting Name for ur Local Database?
Maybe I'm running what ? It says Anarchy online's database aint working not mine lol |
|
|
|
|
Logged
|
-*tinkers*-
|
|
|
Aesgaard
Rookie
Offline
Gender:
Posts: 73
.:.Alpha.:.
|
|
« Reply #12 on: July 12, 2007, 04:47:29 AM » |
|
How do I disable Local Whois if that's what my bot is doing ?
|
|
|
|
|
Logged
|
-*tinkers*-
|
|
|
|
Alreadythere
|
|
« Reply #13 on: July 12, 2007, 05:14:21 AM » |
|
If you haven't installed the whois cache module you got no lookup cache at all in 0.2.
Otherwise it does look like you got some connection problems to the FC website.
|
|
|
|
|
Logged
|
|
|
|
Aesgaard
Rookie
Offline
Gender:
Posts: 73
.:.Alpha.:.
|
|
« Reply #14 on: July 12, 2007, 05:35:24 AM » |
|
Does bebot need port forwarding ?
|
|
|
|
|
Logged
|
-*tinkers*-
|
|
|
|
Content
Total Members: 1243
