VERY good work!! I just LOVE the new mob aggro
Finally able to actually try to get some good pulls and similar..
I did have to use some time tho.. hehe.. This is what i did to have a very good and easy setup of the database WITH loads of spawns as well (from Telmet)
1. Backup your characters by : mysqldump.exe -t eq account character_ > charbackup.sql
2. Drop database
3. Create new database eq
4. Download 44dr1.zip, items_44dr1.zip and worlddata1.1beta5.zip (see above)
5. Download Telmet's EQEmu-0.4.3+Telmet-DB-Test.zip
6. Source db.sql, then items from items_44dr1.zip and worlddata1.1beta5 (follow instructions in readme)
7. So.. to use the spawn entries from Telmet's database, you have to add a field in spawn2 table : ALTER TABLE `Spawn2` ADD `Temp` INT DEFAULT "0" NOT NULL
Next take the "spawns.sql" file from telmet's db, and edit it. Delete everything in the file EXEPT the lines that start with :
INSERT INTO spawn2 VALUES ..
INSERT INTO lootdrop VALUES..
INSERT INTO loottable VALUES..
INSERT INTO merchantlist VALUES..
INSERT INTO npc_types VALUES..
INSERT INTO spawnentry VALUES..
INSERT INTO spawngroup VALUES..
EDIT: INSERT INTO lootdrop_entries VALUES..
The file should then contain ONLY a shitload of lines starting with the above.. (ie. no lines with "DROP..." and similar)
This will create some "duplicate entry" errors, but just let it keep going.
8. When the above is sourced, delete the "Temp" entry you made earlier by : ALTER TABLE `spawn2` DROP `Temp`
9. Import any character backup you made in point 1, and you should be GOOD TO GO!!
This is a rather "brute force" way to add Telmet's spawns database, AND use the new setup, but hopefully Drawde will complete his DB, and we all be rocking with a more complete db than this..
ADD: After a small bit of testing in the zones that were empty with Drawde's database, it seems that the "new" mobs does not have the functioning faction.. Perhaps sumtin can be done with the EQEmuAdmin tool tho.. Well..
Happy hunting!!
Threaded Mode
