Telmet/Drawde Combined Working Database

[Monrezz]

**DOWNLOAD INSTRUCTIONS AT BOTTOM OF POST**

This database is a combination of Drawde's and Telmets. It contains Drawdes spawns and zone points, and all of Telmets spawns / items / npc_types / loots etc etc.

It contains spawns and loots for (Pretty much) every zone. It's got every item (except new PoP ones), and pretty much every #zone command you use takes you to a safe place (No 20k drops or under the world).

I have added a few new items and a few custom spawns.
I recommend you go to The Arena and have a look around :twisted: .

Full credit goes to Drawde and Telmet for their work :o

TO USE: *NOTE* This assumes you have already got EQEmu Installed (to C:\EQEmu) and mySQL Installed (to C:\mysql)

1. Backup your old database! In a command promt type:

cd C:\Mysql\bin
mysqldump eq > OldDatabaseBackup.sql

2. Copy "Working_Database.sql" to your C:\Mysql\bin directory.

3. Go to C:\Mysql\bin and open mysql.exe. Type:

drop database eq;
create database eq;
use eq;
source Working_Database.sql

4. Wait for about 3-5 minutes while it loads all the data into your database. You should see lots of lines that look something like this:
"Query OK, 1 row affected (0.00 sec)"
- there shouldn't be any errors come up (!! :!: !!) Close mysql.exe.

5. Run FQAdmin (I recommend 4.2 - been the most stabe for me :P ).

6. Wait for it to load your database, then click on a few tabs at the top. Make sure the important ones have lots of lines in them. (Especially: Items, NPC's, Spawns, Loot, Variables, Zones, Zonepoints.) If you don't see anything make sure you have set it up to look in your database. Click on "Preferences" on the bottom and make sure everything there is pointing to your database.

7. Go back into your C:\mysql\bin directory and run mysql.exe again. Type in:

use eq
INSERT INTO account SET name='eqemu', password='eqemu', status=200;
GRANT ALL PRIVILEGES ON *.* to '%'@localhost IDENTIFIED BY '%';

Change the first 'eqemu' to what you want the account name to be, and the second one to say what password you want.

10. Close all the open prompts and directories and everything. Go into C:\EQEmu and run MiniLogin.exe, World.exe, Boot5Zones.bat...

11. Log into your server!

*DOWNLOAD INSTRUCTIONS*
Sorry this is a little more complicated then it should be. I had to get a 35Mb file down to 3Mbs!
Step 1 - Download the files:

Working_Database1.zip
Working_Database2.zip
Working_Database3.zip

Step 2 - *Important* Rename the extension of Working_Database1.zip to .exe (i.e. "Working_Database1.exe")

Step 3 - *Important* Rename the extension of Working_Database2.zip to .CAB (i.e. "Working_Database2.CAB")

Step 4 - *Important* Rename the extension of Working_Database3.zip to .CAB (i.e. "Working_Database3.CAB")

Step 5 - Double Click on Working_Database1.exe. A command prompt should pop up, then disapear. Hopefully you'll have a 3Mb zip file called Working_Database.zip on your desktop now.

Step 4 - Use WinZip to extract Working_Database.zip to your desktop.

Step 5 - Copy Working_Database.sql to your C:\mysql\bin directory.