Okay, it's up....
Click here to get it
This is easy to install, and if Rico releases more in the future, I'll mod those as well for general consumption. It's very recommended you have phpMyAdmin installed and run through this process.
- Open up phpMyAdmin (make sure you're web server (I use Apache) and MySQL services are both started) and click on "EQ" in the right hand window.
- Put a check mark in "items" and "zone".
- Click on the "Empty" button near the bottom of the table list.
- A new page, asking if you want to go through with the delete will pop up. Confirm it, then exit phpMyAdmin.
- Extract "items.sql" from "mod-itemsv3.0.zip" to your MySQL bin directory (may be something like "C:\mysql\bin", if you're on Linux, you know where to find it
).
- Run "mysql"
- Type in "use eq;" and hit return.
- Type in "source items.sql;" and hit return. At this point, it will process the file and your screen should get flooded by confirmation of each query in the file "Query Complete. 0 rows affected... blah blah". If it beeps, note what the error was and report it back here. If it says duplicate entry on anything, you did not properly empty your "items" or "zone" table. There's about 7,692 items and zones that get inserted, so if you do not properly follow these instructions, you will get 7,962 beeps. Trust me, it's annoying.
In the future, I may configure the sql file to auto empty the relevant database tables prior to the INSERT queries so you don't have to muck through phpMyAdmin (which is a great tool if you do any PHP/MySQL development).