My first attempt at Blackburrow.

[meliudaj]

Could I get you to take a look at this and see what all I'm doing wrong.

(just assumeing I am

I had to do ALOT more manual then I expected to do in this. With all the logs and other DB's around that have Blackburrow done. But that is my own doing I suppose.

[Lurker_005]

Just glancing at it, you need to captalize Warrior Drawde's program is very picky regarding the zone and class strings you use, they must be exact.

Make sure you put the exact number of lines for EQNPC to parse (total lines munus 1 for the NumNPC line) Otherwise it puts some bogus entries in one of the tables.

You have to divide Z by 10 :( throwing it into excel is the easiest way for me. Plus I then set the HP in there too. Be sure to round these values.

And reverse the X and Y values.

There I think that covers it...

[Lurker_005]

Here is a corrected version.

To use it with the 3.1.1 db.sql you will need to do a search and replace on the spawns2.txt file

search for );
replace with ,0,0,0,0,0);

That adds the new columns to that table

[meliudaj]

Ok the X, Y switch I was aware of... Also the Z / 10. I just forgot to do them.. was a bit to friggin tired.

Any way did you build your Blackburrow off mine, or did you have one?

Also too, So far I have found a way to do almost EVERY thing inside Access. I'm not sure why, I'm shooting for that goal. Personally I hate Access.... I just know how to use it


I tried to make up HP, and Class, useing averages,and guestimates from like Drawde's DB. Is this a good way to do it?

Oh yeah... one more big question... How does the DB handle things like size. In so many places I just saw it left at zero. Is this default size, or just a REALLY small gnoll?

Same question for things like faction, lootable. Unset = DB crash, or some Default?

[Lurker_005]

The blackburrow I posted is a copy of yours, with the changes i mentioned.

If you can get Access to do everything you need, then use it

For HP I played around till I found a formula I liked for level 1 thru 100 but with close attention to 1 thru 60 This works fine for your average mobs, but usually won't be that great for "epic" mobs and his minions around him.

Size seems to be 0 for a default, I think this is the same a s 6... I havn't really tested it :p

You can't leave anything empty. If in doubt use 0, and for the usedspells and specialattack fields use '' or ' ' (2 single quotes with or without a space between them)

[meliudaj]

Here it is again... EQSpawn.txt for Blackburrow.

Much cleaner...
Fixed:
Most all Textures.
All known spawn spots (just a couple rares may be missing)
Added the Rat and Bear spawn.

Walked threw alot and found NO out of place spawns.

This is still in DB 0.3.0 format. If you still have that around you wana take a bit to look at it and tell me if you see anything wack.

also a BIG question... How can I do the equivalent to these commands from a dos promt???

mysql>drop database test;
mysql>create database test;
mysql>use test (have an idea on this one.. but please clarify)
mysql>source db.sql (have an idea on this one.. but please clarify)


Thanks again.

[Baron Sprite]

YES BLACKBURROW!!!! I love that zone so much... can you tell my first char was a barb nothing quite topped the tension entering bb for the first time... those were the days, when everything was new :( ok time for me to stop being nostalgic, good work

[Trumpcard]

Me too, blackburrow has a soft spot in my heart, as does everfrost.. I wish I could go back to those days, when every new piece of patchwork armor was a true treasure!

I remember tiptoing into blackburrow at level 5 for the 1st time with my 1st character, a barbarian warrior, thinking I was the meanest guy on the planet because someone had just given me a Tarnished 2 hander.

I think thats what I miss most, those early days of discovery,when every new monument or piece of the landscape was a discovery.. Thats also one of the things that Im really looking forward to with all the alternate ideas that are coming around , new worlds, new quests, new things to discover.

Ive been toying around with basing my server around the Sword of Shannara series by Terry Brooks.. I think what Jay's doing with the Tolkien based server is great, Im really looking forward to seeing how it turns out!

Ive gone WAY offtopic, sorry about that.. Blackburrow is making me go wayyyy back.

Back on topic, great job M ! Im looking forward to loading this up when I get home and checking out your Object d'arte!

[meliudaj]

Your in luck Trump... Everfrost is one of my next 2 targets

[Drawde]

My latest DB release has a lot of improvements in Blackburrow with Z fixes (thanks to Trumpcard's spawnlog) and a few missing spawns added. Haven't checked it out in-game yet though.

[meliudaj]

I build mine off his SEQ loggs as well... so I'm willing to bet they are very much alike.. The only diff I can think is what spawns did you manualy add?


Also did you change the gnolls to texture 2 so they look like good old Blackburrow gnolls?

That and gnoll pup sizes I took to 4.


Thats they only thing I can imagine different.

[Lurker_005]

meliudaj,

Just put command you would want to run many times in a file

drop database test; 
create database test; 
use test
source db.sql

Then mysql -f mysql < resource-db.sql


I am pretty sure you have to specify a DB in the last line there. But you can't specify the one you want to drop. You can try it without listing the DB, but i don't know if that works.

[Lurker_005]

also here is a batch file you cn put in your EQNPC output dir, and run from there. You can hardcode the DB name if you want, or just call it with a shortcut, and add the db name to the command line there.

*deleted atachment, see post further down for a newer copy*

[meliudaj]

echo off
cd \
echo "Copying c:\online\worldshare\output\* to c:\mysql\bin\*"

echo on
copy /Y \online\worldshare\output \mysql\bin
echo off


cd C:\mysql\bin

REM Exporting tables account, authentication, and character_
mysqldump test account > account.txt
mysqldump test authentication > authentication.txt
mysqldump test character_ > character_.txt

echo "Please Drop, Re-create, and Re-souce db.sql into database test"
echo "mysql>drop database test;"
echo "myswl>create database test;"
echo "mysql>use test"
echo "mysql>source db.sql"
echo "mysql>exit"

c:\mysql\bin\mysql.exe

Problem spot

echo "Sourceing in faction_list.txt, loot.txt, merchantlist.txt, npc_faction.txt, npc_types.txt, sawn2.txt, spawnentry.txt, and spawngroup.txt"

mysql -f test < faction_list.txt
mysql -f test < loot.txt
mysql -f test < merchantlist.txt
mysql -f test < npc_faction.txt
mysql -f test < npc_types.txt
mysql -f test < spawn2.txt
mysql -f test < spawnentry.txt
mysql -f test < spawngroup.txt
mysql -f test < account.txt
mysql -f test < authentication.txt
mysql -f test < character_.txt

echo "There test DB is now updated with your most resent EQSpawn output data from the worldshare directory"

cd \mysql\bin

[meliudaj]

Drawde:

Got a chance to load your 0.85 over lunch here. Your right you did get a fe changes made. But you still have about 10-15 safe spoted mob's.

If you get a chance take a look in there. As well take a look in mine if you have time.