adding to database
 

there is no post or readme for this i dl.ed the database and i ran the install bat for the new3.6. to do it do you use mysql.exe and type in use eq then source
name here .sql or is there a another way to do it cause i have no items or spawns ect..... i cant seem to find a step by step or anything.

it seems not all of the sql's are correct. At least it did'nt work for me.

Here's what I did.
(I have all sql files in my mysql\bin directory: db.sql, items.sql and the sqls from the DB addon)

I suggest you delete the eq database with the winadmin programm you created it with and in the same step create a new one.

Then start mysql.exe from the command line.
> use eq
> source db.sql;
> delete from items;
> source hq-items-3.6.sql;
> source hq-spawns-3.6.sql;
> source hq-books-3.6.sql;

the magelo items do not work for me. Maybe someone knows if theres some kind of problem with it.... I am a newbie myself :-)

Still, I got the spawns working that way and there are only some high lvl items missing (most likely those are part of the magelo DB)

hope that helps

ok i will try it thanks i will tell you if it works or not how come there is no sticky on how to use the data base files?

All DB files are just test files with mySQL commands on each line. "Using" them is just standard mySQL commands to load them into a database. The readme tells how to load it, if you want further information, read the mySQL documentation.

what do you mean Delete from items??

that deletes the records in the items table so the mess is gone and then you put a working version in the table.
(everything in my post with a > in front of it is a sql command that you have to type in like I put it here)

Just enter the commands like I said and it should work. I played around with the magelo.sql a bit but I can get it to work. Whatever I try. magelo alone, magelo and hq-items, magelo and items. No combination works.

So you just put the hq-items data into the items table and it works like intended.
You will be missing a few high end items that I have seen working on other servers but they dont show a graphic anyway.
And a full equipped warrior that looks like hes naked because the graphics dont show up sucks hehe

So I think we just wait for the next release which might work with all items and graphics. .... hopefully.....

Data set not in insert mode?
 

Howdy..

I've tried moving characters through zones, and creating my own items, completing EACH record set for the items and all the options, and what not, and I get a Dataset not in insert mode, or something close to that, however, I can bumb stats and what not. Anyone know whats up with this?

Try hittng commit changes 2 ot 3 times in the admin tool. That usually resets the database to a known state that the admin tool will like. The problem has been around for a LONG time...