MySQL Question.

[Karna]

Sorry for posting in here so much lately, but I'm trying my hardest to get a grasp of how the emulator works.

I had been wondering why NPCs didn't cast so I did a search on the forums and learned that I needed to set a variable in the database called AILevel to 6 if I wanted casting NPCs, which I do, very much so.

I'm not very good with MySQL, I know just enough to usually make my way around it. So, with what knowledge I had I began to look through the 'eq' database and I saw the 'variables' table. I looked through it and assumed that that was where I needed to set AILevel.

There was no AILevel variable in that table, however, and I can't for the life of me figure out how to add a new row called AILevel. :/ I've consulted several sites and even a MySQL book and I can't find anything..

Am I just going about this entire thing all wrong?

[Trumpcard]

insert into <tablename> values ('value1', 'value2');

should do it...

No offense, but if your mysql book doesnt tell you how to do a simple insert, you really need a better book...

lol

[singalots]

what the HE|| is a mysql???

[Trumpcard]

Its a database

Its where all data for eqemu is stored... mobs, items , characters, accounts, etc...