BeBot - An Anarchy Online and Age Of Conan chat automaton
Archive => Anarchy Online Archive => BeBot 0.2 support => Topic started by: Aesgaard on June 21, 2007, 07: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 ?
-
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.
-
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.
-
Indeed using a charmed mob or a pet to attack is an old trick.
-
easy thing is just make the mysql field bigger
-
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.
-
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 :o 2.11 running on 6.0 mysql
-
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.
-
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.
-
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
-
Maybe ur running Local Whois but arnt Getting Name for ur Local Database?
-
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
-
How do I disable Local Whois if that's what my bot is doing ?
-
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.
-
Does bebot need port forwarding ?
-
No, it just needs to be able to do HTTP requests (outgoing port 80) and receive the returning answers.
It does HTTP requests for whois lookups, org roster, items and history.
-
all that should work perfectly, is there any way to check if I'm running local checkup etc ?
-
There is no purely local lookup, only the whois cache (http://bebot.link/index.php/topic,223.0.html), which buffers whois requests in a table. But the information is still gained of the FC sites.