Lurker 0.35 DB

[Lurker_005]

Lurker's EQEmu Database
This is meant to be added to the standard db.sql file that came with EQEmu 0.3.1 If you put db.sql in the same directory as these files it will replace the specified db with a clean one before beginning.

import.bat <database name> <optional mysql path> to import this into your database. Run the import.bat for more usage instructions.

New in 3.5
Updated to Drawde's 0.85
Fixed Kael spawns showing up in ToV (oops) Updated import batch file. This now has a menu and uses choice.com. Nt users will need to get choice.com from a windows machine c:\windows\command\choice.com
Cleaned up spawns in WestFreeport, Paineel, BlackBurrow, Warrens, and StonebruntMountians
Added MarusSeru and DawnshroudPeaks (Spawns as skeletons only, no loot)

Lurker0.35.zip

*edit: sort of forgot to put this in when I posted

Lurker 0.35 for use with EQEmu 0.3.1.1 (or 0.3.1)

NT, 2000, XP users can get choice.com from microsoft

[Trementar]

Is there any way you can build the DB that is Current with your change's as some of us are not able to figure how to add them .Txt file's to the DB.

Only one I been able to use is DwargD's DB which is easy to update since there's no guess work on how to add them .txt file's

Thank's

[just_add_water]

/argee

[meliudaj]

Just loaded it up. Of course I went straight to Blackburrow Some of that looks a little familiar Looks really good acctually but found just 3 errored spawns 2 that are safe spotting, and The one off in the distance in the attatched screen shot.. Thought you might find it interesting to SEE.

Ran to Freeport.. Nice work.. the newbie ground acctually has stuff in it now! (/em checks that off list to do). Same goes for the Acadamey for Archane Science. Merchents are back on the right floor! (/em makes another check)

These guys have a point... I say package up your #.zip just like you are.. but add a built db.sql into the zip as well... for those that don't care about seeing the split out table's.

[meliudaj]

Son-of-a- DOH... Forgot to attatch picture... here it is.

[Baron Sprite]

the bat works good for me, I luv you lurker

[frax]

the bat keeps giving me:
'CHOICE' is not recognized as an internal or external command,
operable program, or batch file.

Right after it lists A, B, C, Z options after running import.bat db.sql c:\mysql2\bin\

[meliudaj]

I'm not sure if This still holds true (hope it does for sake of uniformity) But if so your Way out of wack.

Just a FYI.

[Furinex]

So I chose 'A':

I certainly do get a LOT of "ERROR 1062 at line <line number>: Duplicate Entry yadda yadda" That normal?

[Hardy]

Only one I been able to use is DwargD's DB which is easy to update since there's no guess work on how to add them .txt file's

/agree Use db.sql format :p

[Lurker_005]

I package it this way so that you can replace OR update an existing DB.

Yea there are a couple of duplicate errors in the loot file again, they don't harm anything. I guess I was a bit mind numb after working on the files I didn't even notice em :p

As for choice, I guess I only mentioned it in my batch file for publiclogin :( Anyhow 9x machines have it, but microsoft removed from NT, 2000, xp... Download choice.com from microsoft

If you have an existing DB named eq31 then unzip the download, and run "import eq31" chose B and it will update your database with these spawns and other stuff

If you want to replace a DB named eq31 then unzip the download, drop the original db.sql from the EQEmu 3.1.1 download in the same directory. Run "import eq31" and select A This will completely replace that DB with this.

If you want to create a new DB named eq31 unzip, copy over db.sql, run "import eq31" select A This creates a new DB named eq31

[Calabeth]

Ok I must be a dunce or something. I am getting the import.bat seemingly running fine.

What I did was took the db file from mysql/bin dropped it into the unzipped directory I made and ran it.
Typing import db31 in command.exe mode.
Chose A got a few error lines.
took the db file and placed back into mysql/bin.

Is this the right way to have done that? Because reason I ask is so far I have not seen any newer items or NPC spawns anywhere.

[Trementar]

It don't work either. It just give me a {Y,N} and that's it.

[frax]

Got it to work =) Thx lurker, what you do is you save choice.com somewhere on your computer, i saved it in the lurker folder, then run import.bat and it'll all be good =)

[frax]

Hmmm... except the "new" db file is exactly the same as the old lol... and mysql doesnt want to open it =(