item editing through MySql

[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