Author Topic: AI levels not showing up on logon (Read 5205 times)

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

dogEATdog · « **Reply #1 on:** September 13, 2006, 04:29:40 pm »

also - is there a way to specify the level of an item you are looking for with the !items module?

lonillen · « **Reply #2 on:** September 13, 2006, 04:51:24 pm »

Quote from: dogEATdog on September 13, 2006, 04:29:40 pm

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

lonillen · « **Reply #3 on:** September 13, 2006, 05:01:38 pm »

Quote from: 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

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

dogEATdog · « **Reply #4 on:** September 13, 2006, 06:17:03 pm »

ok...so MySQL is giving me a headache but this is what I have so far:

Quote

$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

Malosar · « **Reply #5 on:** September 13, 2006, 06:57:31 pm »

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.

dogEATdog · « **Reply #6 on:** September 13, 2006, 07:21:37 pm »

$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

Malosar · « **Reply #7 on:** September 13, 2006, 07:38:20 pm »

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.

dogEATdog · « **Reply #8 on:** September 13, 2006, 07:48:49 pm »

using 0.2.8.....

dogEATdog · « **Reply #9 on:** September 13, 2006, 07:53:52 pm »

ok

<3 SQLyog and <3 you for telling me about it

Malosar · « **Reply #10 on:** September 13, 2006, 08:19:22 pm »

Quote from: dogEATdog on September 13, 2006, 07:48:49 pm

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.

Dabaron · « **Reply #11 on:** September 13, 2006, 08:26:45 pm »

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.

Malosar · « **Reply #12 on:** September 13, 2006, 09:02:41 pm »

Quote from: Dabaron on September 13, 2006, 08:26:45 pm

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.

dogEATdog · « **Reply #13 on:** September 13, 2006, 11:54:43 pm »

Dabaron · « **Reply #14 on:** September 14, 2006, 12:24:36 am »

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.

Use this stuff though... should get you want you want.
http://bebot.link/index.php/topic,135.0.html

Author Topic: AI levels not showing up on logon (Read 5205 times)

dogEATdog

AI levels not showing up on logon

dogEATdog

Re: AI levels not showing up on logon

lonillen

Re: AI levels not showing up on logon

lonillen

Re: AI levels not showing up on logon

dogEATdog

Re: AI levels not showing up on logon

Malosar

Re: AI levels not showing up on logon

dogEATdog

Re: AI levels not showing up on logon

Malosar

Re: AI levels not showing up on logon

dogEATdog

Re: AI levels not showing up on logon

dogEATdog

Re: AI levels not showing up on logon

Malosar

Re: AI levels not showing up on logon

Dabaron

Re: AI levels not showing up on logon

Malosar

Re: AI levels not showing up on logon

dogEATdog

Re: AI levels not showing up on logon

Dabaron

Re: AI levels not showing up on logon