item editing through MySql

[arcticangel]

This may sound a little stupid but is there a way to create or edit items from cmd > MySql (the source\(file)\document)? like how u edit merchant? i was just curious cuz i keep running into problems with my itemcreator software.

[sonicintuition]

I'll help with this the best I can. The most I've ever attempted is to edit existing items via the mysql command line. Here are some examples. The idea is to pick apart the examples to see why they work and how you can apply those ideas and methods for your own use.

To change the damage rating of an item, such as the Big Soul Devourer:

UPDATE items SET damage=12 WHERE name="Big Soul Devourer";

Note that when entering mysql commands you don't have to capitalize the commands, I only do that for clarity. Okay, so UPDATE is the command that tells mysql what to do, as well as SET. What those do should be self explanatory. Actually that entire line should be pretty self explanatory, so I won't elaborate (unless you need me to).

Here is another example. You would enter this command to change the AC of all items that have an AC of 20 or less, to say, for examples sake, 45:

UPDATE items SET ac=45 WHERE ac<=20;

Here, you're updating the items table, and you're setting AC. This command should also be self explanatory.

The above two lines of code are merely examples. This may not be anything near what you want to do, but hopefully they help you out some.

From what I understand, also, you're wanting to create items via the command line or via a text file. I would highly recommend, if you're creating items from scratch, to use a text file over the command line. Typing in a command to create an item would take a while and could get very confusing, where as using a text file would be much easier because you can go in and change numbers without typing out commands and such.

However, I would recommend a different method over both of these that works well for me - MySQL Front. It's the only editor I've found that is compatible with the database (you don't have to wait around for someone to make a version of an EQ editor that actually works, let alone with the current database), and it's pretty straight forward and easy to setup and use. I use it to edit items, loot tables, NPC stats and more. It's a versatile tool. Google MySQL front to find a version to download.

Good luck.

Regards,
SI

[bloodfiendserver]

wow that explains pretty much everything. thx

[paaco]

You can't edit items from it, but as far as spawns, loot, NPC's, Merchants and things like that I would definately check out the PEQ Editor, thing is great. Unless your just looking to learn a thing or 2 about sql, which would also be good

[klinzhai]

I usually just use MySQLCC, select the table, click on the 'SQL' button (for sql queries). Then I enter:

SELECT * FROM 'items' where ac >= 75;

That brings me back a list of 196 items, then I can search for the item that I want. You can also do the following (if you know the name of the item):

SELECT * FROM 'items' where name = "Thick Basilisk Hide Shield";

Then you scroll over to whatever you want to edit and make it whatever you want it to be. The only bad thing about MySQLCC is that if you try to return more than a few thousand items it kinda bogs down. Even with the 1GB of RAM on my laptop.

[Koshoji]

What about the whole serialization thing? Can mysql do that as well? I thought that now after editing an item in the db that it has to be "serialized" to make it take effect in the game. I was told long ago when asking about this that I had to use pearl to do that but I know nothing at all about pearl.

Soooo, is there an sql statement that will serialize our edits to items in the db?
Yours in newbness,
Koshoji

[hansolojim]

Thanks Sonicintuition for the info. You had exactly what I was searching for.