Author Topic: AoC bot issue (Read 16078 times)

meatshield · « **on:** July 02, 2008, 07:14:00 am »

I know it? an alpha, but i figured i post the error message I got. I running this on both Vista 64bit and WMWare Player--Ubuntu.

Guildadmin [BUDDY]   [LOG]   Satch logged [on] (MEMBER)
MySQL error (# 0) on query: INSERT INTO whois (id, nickname, level, class, craft1, craft2, location, online, updated) VALUES ('67178806', 'Satch', '44', 'Assassin', '', '', 1154213, 1, '1214974967') ON DUPLICATE KEY UPDATE id = VALUES(id), level = VALUES(level), class = VALUES(class), craft1 = VALUES(craft1), craft2 = VALUES(craft2), online = VALUES(online), location = VALUES(location), updated = VALUES(updated)
Unknown column 'class' in 'field list'
Guildadmin [GETUID]   [FAILED]   I was unable to get the user id for user:
Guildadmin [Whois]   [Update]    had an invalid user ID! UID:
Guildadmin [GETUID]   [FAILED]   I was unable to get the user id for user:
Guildadmin [GROUP]   [MSG]   [~Guild] Guildadmin: "Satch" (Lvl ) Logged On :: [link]Details[/link]
Guildadmin [PGRP]   [MSG]   [Guildadmin] Guildadmin: "Satch" (Lvl ) Logged On :: [link]Details[/link]

I was using a different bot that had a lot of these commands working. Of course it wasnt using mySQL like this one. Since this is the only chatbot for AoC that I found that? using ´sql, i going to put my all into it.

Thanks for providing the app for us.

Noer · « **Reply #1 on:** July 02, 2008, 10:18:57 am »

Hrm that error looks a bit strange. Are you running this on top of an old Bebot install? If that is the case the table structure is not compatible and you need to start from scratch.

meatshield · « **Reply #2 on:** July 02, 2008, 08:19:58 pm »

I actually deleted all the files out of the bebot folder and installed the new files in there. I also using the Bebot Hyborian that was posted on the funcom EU server.

To answer the question -- It was installed ontop of the old bebop... but not really. Since everything was deleted.

meatshield · « **Reply #3 on:** July 02, 2008, 08:22:48 pm »

ok... answer this. I noticed that it had a mySQL error in there... if Im using the same database ... could that be the issue?

I gonna test that theory out.

Yup... Im a mySQL and just plain old php aoc chatbot newb. Id get list in a pile of my own dirty stuff. So I removed the database and rebuilt it. Works great!

Heres my update to the issues I noticed:
When you click on the nice little script that is called !whois name -- it provides a link for ¨Details¨. When you select this theres an option to add buddy. When I click this it sends me a tell from the bot saying cc addbuddy ¨name¨.

Another issue is the !online :: This is what I get (only two members online)
<img src=tdb://id:GFX_GUI_FRIENDLIST_SPLITTER>

<img src=tdb://id:GFX_GUI_FRIENDLIST_SPLITTER>
- Lvl 44 Bohica

<img src=tdb://id:GFX_GUI_FRIENDLIST_SPLITTER>

<img src=tdb://id:GFX_GUI_FRIENDLIST_SPLITTER>
- Lvl 69 Dalri

Yay, Ive got another potential issue or question

When I do !buddylist I get (below). Is that how its supposed to look or should I be getting information?
Bohica (ID: 67122783)
Dalri (ID: 6726747)

When I type !member I get the member count page It shows 2 buddylist count. Below that the classes are listed and they all have 0s. Since i deleted the bebot database and restarted everything I should be fine. I really hope I dont have to delete any old files

There are some more questions and issues, but I think this is long enough. I know it? in alpha and I dont want to seem like an SoB. I ReALLY REALLY enjoy it and ive spent hours just learning linux so I can run this stuff better.

Thanks again!

Noer · « **Reply #4 on:** July 02, 2008, 08:49:00 pm »

You need a fresh install for Bebot Hyborian. That means - no old files and no old mysql stuff. Start from scratch.

meatshield · « **Reply #5 on:** July 02, 2008, 11:18:16 pm »

haha, well - it seems a lot of stuff is working now

Ok quick question then. In /extra/whois-update there's a readme with instructions relating to the whois-update.php and .conf. // Do i have to do any of this? I think the module whois-update overrides it?

I lied - another questions.

***When a member logs in it shows the guildbot update showing them online then a clicky for Details -- In that clicky there's a Location: 261. Is that suppoed to be an actual location?? And is there a way to maybe add their crafting professions to the details button?

Noer · « **Reply #6 on:** July 02, 2008, 11:44:31 pm »

The whois-update stuff is just something I havn't removed yet. I will go through it and remove obsolete stuff when I get the time to do it.

The location stuff was something I was researching on. But currently there is no way to translate the ID to an actual location as the ID is not static and changes everytime the zone is recreated.

The crafting-information can be added easily to details - its on the todo list.

meatshield · « **Reply #7 on:** July 02, 2008, 11:55:00 pm »

Awsome - I wasn't sure if the crafting was a todo. I was more then willing to do that myself with a little (lot) of direction.

I really appreciate you reading and responding to all my questions and comments. I really do enjoy this app. With the mySQL bit, you've turned this into an extremely powerful tool.

Thanks again