Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Database/World Building

Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.

Reply
 
Thread Tools Display Modes
  #1  
Old 09-28-2008, 10:35 PM
Sylaei
Hill Giant
 
Join Date: Jan 2007
Posts: 124
Default Changing Starting Locations

I am checking/changing the starting locations of all the chars. I have found that the evil gnome wizard, enchanter, magician all spawn upstairs in the library. I found the GM's for each class, evil, and did a /loc command. I added the results of the /loc to the start_zones table. Now my 3 start right by the zone to steamfont. I assume it is because the /loc was bad and the server couldn't place them there.

I feel like I am missing something but gets me what it is.

One more thing, I noticed they are spawing with both notes, the good and the evil ones. When I look in the starting_items table it lists one with the deity_id of 201, bertox, and the other of 0. Does the 0 mean that all chars of the class/race get it? Also is it part of the client to give the backpack, food, drink and starting weapon. I was thinking I'd want to change that in the future.

Lots of question, I did a search and didn't find anything. Forgive me if I missed something.

Thanks,
__________________
Syl

"The significant problems we have cannot be solved at the same level of thinking with which we created them."
Albert Einstein
Reply With Quote
  #2  
Old 10-03-2008, 02:38 PM
Skizoke
Sarnak
 
Join Date: Sep 2008
Location: Alabama
Posts: 70
Default

I'm very new at this so forgive me if what I am about to say sounds stupid.

From my few days of messing around I have noticed when you target an npc and do #spawnfix and #repop zone it will move the npc to where you want it and it will update the X, Y, Z coordinates in the database.

Could you perhaps use this method to accomplish what you are trying to do instead of /loc since you think /loc may be giving you bad data?
Reply With Quote
  #3  
Old 10-03-2008, 02:53 PM
ChaosSlayer
Demi-God
 
Join Date: May 2007
Posts: 1,032
Default

I want to note that when you do
/loc you given coordinates in a format Y, X, Z

when you do
#loc you given X, Y, Z

in Db depending on table data mayby stored in either pattern
so you need to pay attention if ist Y, X or X, Y
Reply With Quote
  #4  
Old 10-03-2008, 04:06 PM
Andrew80k
Dragon
 
Join Date: Feb 2007
Posts: 659
Default

Quote:
Originally Posted by ChaosSlayer View Post
I want to note that when you do
/loc you given coordinates in a format Y, X, Z

when you do
#loc you given X, Y, Z

in Db depending on table data mayby stored in either pattern
so you need to pay attention if ist Y, X or X, Y
Chaos is correct, if you mess with the database make sure you are getting your coords through #loc and not /loc, or pay attention to the X,Y.
Reply With Quote
  #5  
Old 10-06-2008, 09:36 PM
Sylaei
Hill Giant
 
Join Date: Jan 2007
Posts: 124
Default

That was it guys, I didn't realize the x and y were swapped. Thanks
__________________
Syl

"The significant problems we have cannot be solved at the same level of thinking with which we created them."
Albert Einstein
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 05:23 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3