I want to do my part.

[meliudaj]

So far I'm very impressed with all that is done here.... I'm a big EQ fan and I'm well diversed in puters. so I wana see if I can help this project out... problem is as many things as I have done in puters of the years Databases are not a fav of mine by far.

Any way I'm going to use blackburrow as my first attemt. From what i see most all the spawn points for most mobs are rather well known, or easilly found. But it is the Z cordinate that keeps putting them threw the floor.

First question: Is it true that if something is spawned into an invalid spot it is sent to a so called "Safe Cordinate"?

Second question: Is it true that this is primarially caused by the Z cordinate being off?

Third question: Would it be benificial to the world builders to have some one go threw and acctually walk a char to the exact spawn spots and get the /loc from those cordinates so that the "Z" can be correctly set?

Fourth question: What would be the easiest way for me to get my new cordinates for the spawns into either A data base or Your data base so that You can incorperate this info into your realeses?

Fith question: Useing Blackburrow as an example again. How come /loc doesn't give a "Z" cordinate?

Sixth question: This is where my lack of SQL knowledge have a learning curve. What is the best way for me to input this data into the data base. (eg. right now I'm running emu on a different system then EQ client. I have the program of "Mycc" My SQL Control Center. I use this to look up the input /loc's for mobs.
Is this a good tool for inputting data?
FYI I'm presently using Drawde's (sp) db.sql .08 to edit into.

I know that these are a good number of rather newbie questions, but I just figure I can do some of this "Q/A" of zones I know, or would learn, to save some of the world builders some busy work.

Thanks ahead of time and I hope I can be a help not a hinder :-)

[meliudaj]

Answered my my /loc question.

just do #loc instead.

[meliudaj]

I also now see that the program MyCC is just for query's! :(


So is there a tool that is all nice for pulling stuff up like this that also will let me edit? EQ Admin??

[meliudaj]

OUCH EQ Admin can edit but painfully slow!

Any way present eg. Just to kinda show what I mean incase all my babling didn't makes sence


NPC 1766 (a_giant_snake01) that is part of spawngroup 13766, has a spawn pint of -14 253 3 Where it should be -14 253 -93 (down on snake ledge)

I'm just looking for a fast way to change these numbers.

Also Question: Why is it that eqemu has the X, Y backwards from the EQ X, Y?

[Shawn319]

FQAdmin (Aka EQEmu Admin Tool 2.4), is missing a LOT of data it should have (like missing 1/2 of the playerprofile). This can cause databses to become corrupt and unusable.

Wait for Lyenu's Admin Tool..

[Lurker_005]

1) If the spawn does not land on any part of the map (below it or off the edge then it is put at a "safe point" Usually 0,0,0 BUT I have seen spawns grouped at several spots. So it may not be just 1 safe point... you can use #goto to check if a spot is valid. If it isn't you will get sent to a safe spot yourself.

2) well, yes but not always. A bad X or Y could put it off the map or in a hill (below the worlds skin) Use #flymode 1 and then a #goto Z-10 from wher you are to check it out. If you fall below a pre-determined Z level that is when your sent to the safe spot.

3) For the most part, no, at least not how your your question seamed to mean. It is needed to verify spawned content at some point though. Mob heading, Skin, Race, decide if that is really where the mob should be... The easiest way to get valid X Y Z locs is to use ShowEQ to get a spawn log and then cut and paste (or convert) to Drawde's EQSpawns.txt See some of my posts in the dev forum *EDIT: Err... Shawn is moving all the worldbuilder type stuff to it's own forum* for some unedited results from this.

4) Drawde uses a file called eqspawns.txt and it is included with his program EQNPC that takes a single line from eqspawns.txt and creates the needed 5 SQL tables data. Probably the best way is to edit that file, run the program and import the dat to verify it and send a differance file to drawde (what I am doing anyhow)

5)...

6)Using a good text editer (ultraedit) EQNPC and mysql is working pretty good for me.

[meliudaj]

if EQNPC is grabbing all this data out of this eqspawns.txt file... Then where are all these bogus Z cordanits coming from?

[meliudaj]

And here is a "I'm A SQL Database newbie" question


Could you by chance just post a few of the simple sql command line commands?

Eg.
use eq = use the database named eq
source db.sql = import the data & tables into the database named eq

xxxx = import texfile Blah.txt (data) into table (table & or Database in general) Blah.

xxxx = export database Blah out db.sql

xxxx = dump db.sql out to blah.txt


If it not to much to ask.. just a quick and easy, cut to the point command list of the simple data in data out basics.

Puter Xpert... Database Newbie :-) "Honest.. I fear them :P"

[Lurker_005]

They are bad in EQSpawns The data was initally collected from web pages of spawns, some without Z locs some with bad locs....
Drawde has gone through and put generic Z values in for what he didn't have, but they aren't always right. If you had X and Y for spawns in a 2 story building... set the Z value for something that keeps them out of the safe spot... That is where some zones are now. I am going through the zones I have showEQ spawn logs for and setting the Z based on that. Oh, almost forgot showEQ reports Z as 10* the EQEmu value and X Y is swaped, so make those adjustments if you use that source.

[Lurker_005]

From dos, replace anthing in () including the ()'s
To save SQL databases or just tables to a file:
mysqldump (database) (optional table) > (output file)
To import a SQL file from the command line:
mysql (database) < (source file)
an optional -f after mysql will suppress beeps if duplicate entries or other errors.

Check your mysql dir for the html based help file, it has lots of good stuff in there. Probably start with the index file.

[Trumpcard]

1) xxxx = import texfile Blah.txt (data) into table (table & or Database in general) Blah.

2) xxxx = export database Blah out db.sql

3) xxxx = dump db.sql out to blah.txt


Answers:

1) mysql -f [databasename] < [filename]

2) mysqldump [databasename] > [filename]
or mysqldump [databasename] [tablename] > [filename]

3) db.sql is a txt file, so no need to convert it to anything..

[Lurker_005]

Man Trumpcards post looks a lot better than mine :eek:

See what an extra 100+ posts will do for ya ;)

[meliudaj]

LOL!!

Thanks much for the info guys! That should be the majority of what I will need to get Blackburrow fixed! Don't ask me why I chose blackburrow to start :p You never know when you might have the erge to be lvl 5 again :-)


Oh yeah one last thing... I notice like in Blackburrow the aggro range on stuff is outrageous!.... is that a simple variable to change radius?

[Lurker_005]

I think it is a DB value.... or was that a request for it to be a DB value...
ARRRGH!! My head is gonna explode ;)

Check the npc_types table The field names are pretty explanitory.

I guess I should post the zones I have and intend to work on the Z value ect... Look for it in the worldbuilder forum.