Missing 'isbot' Field

[Kilralpine]

I keep getting the Message:

Missing 'isbot' Field -- Please Add the SQL to creat Bots First

I have Sourced in the tables and the 'isbot' field more than 5 times....i have read the installation guide out on eqoffline's site as well

Im not quite sure what step to take next, it is not a mysql connection error, all the other programs run fine

Is there a way around the error or perhaps someone has an idea that i may have missed??

I Do NOT plan to use this for bots yet....

Any Help is Great Thanks!! and Thx George

[trevius]

http://www.eqemulator.net/forums/showthread.php?t=26111

That thread help at all?

[Kilralpine]

Not at all im afraid, i already ran that bit of code successfully with no errors, i know the tables are there and i KNOW the column is there...the tables however are empty; as they should be if i have no bots correct???

Im unsure what to do at this point, ive read a ton of threads and all of his tutorial/readme stuff

Ive done everything it asks of, yet i still get that it cant find them???? i dunno what to do

[Kilralpine]

Just Backed up my normal sql and loaded up a fresh PEQ db, tables inserted, isbot inserted....SAME ERROR

Im not sure wtf is going on still, every tool i have from georgeS works except this one, info in the config is the exact same to the letter as the other tools....it should work; its almost as if it doesnt see the 'isbot' column....

Could this be a vista issue?

[trevius]

I am guessing you are referring to the Item Editor, but I don't see anywhere that you actually mentioned which tool it was that you are having the problem with. I think the item editor is the only one that has anything to do with Bots though.

Have you tried downloading and installing the ODBC drivers from GeorgeS' website? Also, have you ran the register_ocx.bat file in the resources directory? If so, then most likely your problem is in fact Vista related. These tools were designed on XP for XP. I believe GeorgeS has put some work into getting some Vista compatible, so maybe if this is a Vista issue, he can resolve it eventually.

[GeorgeS]

Sorry for the mess-up -had to change the startup sql query a bit.
This should fix the error.


NPC and Loot Editor
ver 08.21.08 - Changed the sql to query for isbot differently. Should prevent the error some people get when no bots have been made


The tools are made on a Vista32 machine and compiled for XP and Vista, so compatibility should be fine.

GeorgeS

[Kilralpine]

sweet thanks man, when will the fix be downloadable?

Edit: Nvm Website lists 8.21.08 Thanks again man :-)

[Babul]

Where are the instruction to make this tool work?

I am gettin the Db connection problem aswell but is not a connection problem

I have run the .ocx register what else is needed what need to be sourced and how

When i launche the npc_loot tool I get this text file pop

CREATE TABLE `botinventory` (
`npctypeid` int(11) NOT NULL default '0',
`botslotid` int(11) default NULL,
`itemid` int(11) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `botleader` (
`botid` int(11) NOT NULL default '0',
`leaderid` int(11) default NULL,
PRIMARY KEY (`botid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE npc_types add `isbot` tinyint(4) NOT NULL;

http://66.159.225.58/eqemu/GeorgeS_EqEmu_Files.zip

[Babul]

Ok NM I figured out that the myodbc i had installed was 5.1 and was not good with your tool i got the 3.51 and now is ok.

Where i can find info on how to create Bots?

[trevius]

In the custom code section here:

http://www.eqemulator.net/forums/forumdisplay.php?f=665

Most of the questions you have been asking today are answered if you do a little forum searching. It doesn't hurt to ask, but in many cases it would take us as long to answer (or longer) than it would for you to search and find it yourself. Try checking each section of the forums. Read the stickies. And check out the Wiki. There is so much information in these forums and in the wiki that almost any question has already been answered at least once.

[Angelox]

Yea, and I hope he doesn't still hate Seinfeld, it really wasn't his fault his mail got thrown away :).