item editing through MySql

[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

[klinzhai]

I think they're talking about if your game is running live. Once it's up and running, it won't update the database in-game. If you reload the world.exe, then it should reload the database. Remember, if you restart the world.exe, you need to restart the zones also.

I could be wrong, but I think that's what they're talking about. You might be able to 'serialize' to reimport the items from the database while the game is running live.

[sesmar]

There is a file called serialize_items.pl in the utils directory of the source code. You need to run this perl script after making changes to your items in order for them show up in the game.

[fathernitwit]

serialize items is not needed with 7.0+, since we have to do it at send time to support different patches.

[daemonreaver]

Another way is with Excel.

Create a spreadsheet (I'll link the blank one) and pretty simply fill in the blanks.

There's 2 ways to use the spreadsheet. 1) Use the MyODBC driver for Office 2000 (not Office XP) and insert the entries, 2) Simply copy the rows and paste them into eq.items in Navicat.

At this time, I would suggest that you *DO NOT* try to make bags. It seems that EQ doesn't like custom bags, as it appearantly ties the IDFILE and Icon/Graphical with actual data embedded and can lock the EQ client when attempting to open the bags.

Examples of Items Created...
http://eq.boxarray.com:82/charSelect.php?char=TestGM
All of this character's gear (minus the jewelry) was made with the spreadsheet trick and Navicat.

NOTE: do not update or edit the DB with EQLauncher, World or Zone running, as they cache the item table in shared memory mode and can crash if you summon the new item.

http://gpl.boxarray.com/tempdump/EQ_Item_Maker.xls (43kb) Contains Nameless GM gear as example.

The DB on BoxArray won't be updated till tomorrow (THursday night DB mirror). The Items in the Excel spreadsheet are current and contain several Skillmods and a few changes (they are ALL/ALL for equipable and no longer attunable).