Updated Tool - EqItems Item Editor

[Emmeric]

Originally Posted by lerxst2112

To edit items in the MySQL database you can use the item editor you're already using, or you will need something like HeidiSQL or Navicat.

As an example, if you used HeidiSQL or Navicat you would be able to execute queries on your database to change items.

Depending on the tool you use you can also edit things in a grid like a spreadsheet and then save those changes back to the database.

Ok, so there isn't really a file I could just pop open with Notepad and create fire-breathing earrings...

Using the editor in this thread seems simpler than typing commands as you listed. Just opened the db items list with navicat. A bit clunky, but that answers my question nicely.

Thank you so much for your help

[Emmeric]

Edit - I feel stupid... there are pages in the db tables...

Does it matter if I load Titanium or SoF in the spell tool?

[Emmeric]

Hmm, ran into a problem using the spell editor. It ran fine yesterday.

Today, I get:

Loaded DB.INI
Connected to Database OK

SPELL TABLE contains: 14799 spells
SPELL TABLE contains: 215 FIELDS!
Your file is MISSING/WRONG FOLDER

1 or more errors Prevent IMPORT



I know the answer must be obvious, but I haven't started drinking yet today, so I haven't figured out why the spell editor can't find my spell files today when it did just fine yesterday.

Any suggestions on this one?

[Emmeric]

Please....?

[GeorgeS]

Ok, your spells_us.txt has some problem with it regarding field count or a extra "^" delimmeter somewhere.
My spellfilehandler (this tool) has an extra copy. If it's knackered, then redownload another copy.

Ti uses 200 fields and SoF has 215 fields

GeorgeS

[Emmeric]

Originally Posted by GeorgeS

Ok, your spells_us.txt has some problem with it regarding field count or a extra "^" delimmeter somewhere.
My spellfilehandler (this tool) has an extra copy. If it's knackered, then redownload another copy.

Ti uses 200 fields and SoF has 215 fields

GeorgeS

Redownload? Ok, thanks. Will downloading again effect any of my new spells added?

[GeorgeS]

Originally Posted by Emmeric

Redownload? Ok, thanks. Will downloading again effect any of my new spells added?

I would think your back up plan sounds good. When you are ready to export the EQ spell file, then just make copies of the text spell file and the spell table.

I should think your new custom spells are fine. Just import them in as usual.