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 11-06-2004, 08:32 PM
1010101
Sarnak
 
Join Date: Mar 2002
Posts: 63
Default PEQ Kunark... Opening all zones?

For reference, I'm using the PEQ Kunark database on a 6.0 DR2 server (configured for use with minilogin).

Anyone got an sql handy that I can source into my database that'll open up every zone and get rid of that pesky "Invalid zone name" message when someone tries to enter a zone that's not been populated yet? Even without any spawns, having the realistate available would be handy .

Sure, I could do it myself, but why waste the time and effort when someone else probably already has what I need handy?

Thanks in advance.
Reply With Quote
  #2  
Old 11-09-2004, 06:17 PM
1010101
Sarnak
 
Join Date: Mar 2002
Posts: 63
Default

Since no one was forthcoming with anything here, I went ahead and assembled an sql to do it myself. For anyone else interested, I'll provide what you need here. This comes from three different sources, so that's why the formatting is a little different in each section. I'm fairly certain this includes every zone (Old World, all expansions, the patched in zones like the Warrens, Marauder's Mire, etc., as well as the tutorial, cshome, and the load zones). If anyone notices something missing, feel free to chime in .

*Edit* - Had posted it here, but the forum cut it off... I'll get it up online somewhere shortly for anyone that wants to download it.
__________________
- 1010101
Reply With Quote
  #3  
Old 11-09-2004, 07:38 PM
wize_one
Dragon
 
Join Date: Jan 2004
Location: LasShithole, NV
Posts: 520
Default

http://www.projecteq.net/phpBB2/viewtopic.php?t=16

has the zone data.. not sure if the zone table has changed since i made that though
__________________
Perfect quote from another site: it's immature pricks who refuse to read the numerous stickies in every forum pointing out what to do and what not to do that get flamed. Grow up and learn to do your fucking homework before opening your cake hole, junior. EQEmu doesn't like you anymore, and that's why you're getting errors. So go away.
__________________
Reply With Quote
  #4  
Old 11-10-2004, 03:50 AM
1010101
Sarnak
 
Join Date: Mar 2002
Posts: 63
Default

I get a 404 error when I try to follow that link... Seems like the projecteq website is down alot lately.

Anyway, I've uploaded my own sql for opening all of the zones. This'll be the first new file for download from my site in several years

http://www.gameroom.com/1010101/all_zones.html

*** EDIT ***

Uploaded the wrong file, so if you somehow downloaded this thing during the first 30 seconds it was up, you got the wrong thing. It's fixed now.
__________________
- 1010101
Reply With Quote
  #5  
Old 11-10-2004, 06:01 AM
wize_one
Dragon
 
Join Date: Jan 2004
Location: LasShithole, NV
Posts: 520
Default

it's got to be your machine blocking thr site.. projecteq.net has not been down.
__________________
Perfect quote from another site: it's immature pricks who refuse to read the numerous stickies in every forum pointing out what to do and what not to do that get flamed. Grow up and learn to do your fucking homework before opening your cake hole, junior. EQEmu doesn't like you anymore, and that's why you're getting errors. So go away.
__________________
Reply With Quote
  #6  
Old 11-10-2004, 06:07 AM
Laviathon
Sarnak
 
Join Date: Aug 2003
Location: NY
Posts: 78
Default

so i would just stick this in my C:\mysql\bin folder and goto cmd and source it in ? just want to make sure hehe
__________________
Reply With Quote
  #7  
Old 11-10-2004, 06:10 AM
1010101
Sarnak
 
Join Date: Mar 2002
Posts: 63
Default

Quote:
Originally Posted by Laviathon
so i would just stick this in my C:\mysql\bin folder and goto cmd and source it in ? just want to make sure hehe
Exactly. Just make sure you do it after you've sourced in the PEQ database.

Regarding my not being able to get to projecteq.net, I'm suspecting that it might be my ISP. I've tried three machines this morning and not one of them could get there. It worked fine a couple days ago, though. Time to make a phone call, I guess .
__________________
- 1010101
Reply With Quote
  #8  
Old 11-10-2004, 08:49 AM
wize_one
Dragon
 
Join Date: Jan 2004
Location: LasShithole, NV
Posts: 520
Default

the one i linked on projecteq.net is old.. the zone table has changed.. so not to sure what ya can do with it..
:( :(
__________________
Perfect quote from another site: it's immature pricks who refuse to read the numerous stickies in every forum pointing out what to do and what not to do that get flamed. Grow up and learn to do your fucking homework before opening your cake hole, junior. EQEmu doesn't like you anymore, and that's why you're getting errors. So go away.
__________________
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 02:56 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