BeBot - An Anarchy Online and Age Of Conan chat automaton
Archive => Anarchy Online Archive => BeBot 0.2 support => Topic started by: dogEATdog on September 13, 2006, 04:08:04 pm
-
I seem to be having a bit of a hiccup in the login notification module. Lists the char's name / lvl / prof / org rank...but no AI level. when i look at console readout it lists Unknown column 'ailevel' - and its a sql error. dont know if it a misprint in code or what. open to suggestions :P
-
also - is there a way to specify the level of an item you are looking for with the !items module?
-
also - is there a way to specify the level of an item you are looking for with the !items module?
as far as i know you can specify ql. syntax would be something like
!items <ql> <item name to search for>
(e.g. "!items 135 per snip" should return a ql135 perennium sniper)
L
-
I seem to be having a bit of a hiccup in the login notification module. Lists the char's name / lvl / prof / org rank...but no AI level. when i look at console readout it lists Unknown column 'ailevel' - and its a sql error. dont know if it a misprint in code or what. open to suggestions :P
the error message suggests there is no column named 'ailevel' in your members table, checking for it (and creating if needed) might be a start. also when the column is there check if it gets populated when a new member is added.
L
-
ok...so MySQL is giving me a headache but this is what I have so far:
$httpqueries++;
$who["nick"] = xmlparse($content, "nick");
$who["firstname"] = xmlparse($content, "firstname");
$who["lastname"] = xmlparse($content, "lastname");
$who["level"] = xmlparse($content, "level");
$who["gender"] = xmlparse($content, "gender");
$who["breed"] = xmlparse($content, "breed");
$who["profession"] = xmlparse($content, "profession");
$who["faction"] = xmlparse($content, "faction");
$who["rank"] = xmlparse($content, "rank");
$who["rank_id"] = xmlparse($content, "rank_id");
$who["org"] = xmlparse($content, "organization_name");
$who["org_id"] = xmlparse($content, "organization_id");
$who["at_name"] = xmlparse($content, "defender_rank");
$who["at"] = xmlparse($content, "defender_rank_id");
note the bold print. should the "at_name" and "at" be something along the lines of "ailevel"? This is the whois-update.php file - the only file I could find with reference to this sort of thing in the MySQL database. If I am way off base here I suppose that means editing MySQL through console >:( don't look forward to that. I am going to try editing the whois-update.php in hopes it will alter the database. perhaps one of you will rescue meh from my madness
BTW thank you for the !items info, worked as u said :)
-
In mysql using the following command to see what your members table contains:
show columns from members;
See if you have an ailevel and aititle in the list. Then do:
select * from members where name like "toonname";
Obviously replace toonname with a name of a character that should be a member and see if there is data for your ailevel and aititle. If your using a mysql front end like sqlyog then simply get the data from the members table and check it there.
If all the data is there in the members table then check your logon_guild to see whether it's pulling the data or not. It should have something like:
$result = $this -> bot -> db -> select("SELECT nickname, firstname, lastname, level, profession, rank_name, ailevel, aititle FROM members WHERE id = " . $id);
You will notice it's pulling the ailevel and aititle as part of the mysql query.
-
$result = $this -> bot -> db -> select("SELECT nickname, firstname, lastname, level, profession, rank_name FROM members WHERE id = " . $id);
that is currently what is being pulled by Logon_GUILD.php - curious - where it is calling ailevels from ???
that leads me to believe I will have to add something for ailevels in roster_GUILD.php as well since there is nothing there that says ailevels verbatum. And, alas, my database is minus a ailevel or aititle column in the members table. I will play with it a bit :P
-
That means your using all old core files and modules. I assume you have like 0.2.3 or earlier? If this is a fresh bot I would advise starting with a new 0.2.8 bot. Hacking the newer versions into your bot would probably create more headaches than just starting one again with a newer version.
-
using 0.2.8.....
-
ok
<3 SQLyog and <3 you for telling me about it :D
-
using 0.2.8.....
oh, maybe they haven't put the ai stuff in the 0.2 series, whereas most of us have put it in from modified versions of rosters, online, logon etc over time. Would probably need to ask Khalem or someone whom knows the respository versions well.
-
it is in the .2 series. But you don't want to look at the whois-update.php because that is just the one that updates your whoiscache. Go into the members tabel in your mysql. There should be ailevel and aititle columns.
-
it is in the .2 series. But you don't want to look at the whois-update.php because that is just the one that updates your whoiscache. Go into the members tabel in your mysql. There should be ailevel and aititle columns.
I just downloaded and checked the 0.2.8 version and none of the modules mentioned have the AI information including roster, logon and online.
-
:'(
-
I may have updated mine since then, its hard to say. I've put in a lot of the custom stuff and then even modified a lot of those even farther. :P
Use this stuff though... should get you want you want.
http://bebot.link/index.php/topic,135.0.html
-
I recently discovered that 0.2 does not have AI level support outside of the whois module O.o.
This was not intentional, however with 0.3 closing in on stable, im hesitant to spend more work than neccecary on the aging 0.2 branch of BeBot.
-
Xenixa's modules ftw on 0.2 ;-)
-jj-
-
I recently discovered that 0.2 does not have AI level support outside of the whois module O.o.
This was not intentional, however with 0.3 closing in on stable, im hesitant to spend more work than neccecary on the aging 0.2 branch of BeBot.
I wouldn't bother personally, keep your time available on 0.3 branch :) Anyone whom really wants ai details in current versions can use the existing modules available on this forum to adjust.
-
Xenixa's modules ftw on 0.2 ;-)
-jj-
Yup, I addressed the AI level stuff for the 0.2.x branch months ago. However since I stopped using that branch back in like March/April of this year I'm not sure the Modules I have on my FTP server for the 0.2.x are still valid for the current version of that branch. If they still work as is then thats great! :)
Just as a reminder they are here:
ftp://xen.afraid.org/bebot_files/Rooster_GUILD.php
ftp://xen.afraid.org/bebot_files/Logon_GUILD.php
ftp://xen.afraid.org/bebot_files/Online.php
BTW, that Online.php works for both 0.2.x and 0.3.x Branches.
-
Yes, they work fine
-
ftp://xen.afraid.org seems to have had a lot of files i'd like to get my hands on. However i keep getting connection refused messages. It is possible to please get these from someone else?