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 03-16-2019, 03:05 AM
Huppy's Avatar
Huppy
Demi-God
 
Join Date: Oct 2010
Posts: 1,152
Default Classic Doors/Zones Pack

If anyone wants to be lazy in setting up their classic doors, zone_points, etc., I dumped some tables from an older database that was using most of the older versions of (available) zones, along with character creation, start zones and starting items.(Frogloks, Drakkins and Beserkers have been removed from character creation choices).
Patronizing reminder: BACKUP YOUR DATABASE BEFORE SOURCING THESE IN! Zip download includes the following files:

README.txt
char_create_combinations.sql
doors.sql
start_zones.sql
starting_items.sql
zone_points.sql

http://tinyurl.com/ClassicPackTables

If you've taken the initiative to learn about running sql queries, it can speed some tasks up in a big way. For example, if you wanted to temporarily disable all the PoK books in all the classic zones, you could run this query, changing the name to something unique to disable it. (POKTELE500 is the original working name) This will disable all 31 classic PoK books around Norrath.(They won't show up in client).

Code:
UPDATE doors SET name = 'POKTELE500NULL' WHERE name LIKE 'POKTELE500';
Then, when you want to enable them again, you revert the names back to original.

Code:
UPDATE doors SET name = 'POKTELE500' WHERE name LIKE 'POKTELE500NULL';
Reply With Quote
  #2  
Old 11-15-2020, 11:58 PM
freezerburn26
Fire Beetle
 
Join Date: Mar 2010
Posts: 1
Default

Is there anyone with a working link to this anymore?
Reply With Quote
  #3  
Old 07-15-2021, 02:29 AM
Vire70
Fire Beetle
 
Join Date: Apr 2010
Posts: 25
Default

Ditto on above... does this exist anymore? I'm starting work on a QoL velious era server and this stuff would be helpful. In fact your code was already helpful for the books, so big thanks to Huppy.
Reply With Quote
  #4  
Old 07-16-2021, 07:14 PM
Huppy's Avatar
Huppy
Demi-God
 
Join Date: Oct 2010
Posts: 1,152
Default

Quote:
Originally Posted by Vire70 View Post
does this exist anymore?
Sorry about the dead link, but I've been off the grid for awhile, dealing with RL, which is imminent until next Feb. I trashed a lot of old unused files I had. Maybe I can throw something together later and post it, but it will be from a luclin era setup, on a private server, i have running, using the old bazaar, etc.
__________________
Come on over to Huppy's House (personal/resource forums)
I can also be reached through gmail, at huppyscorner.
Reply With Quote
  #5  
Old 07-16-2021, 08:32 PM
Huppy's Avatar
Huppy
Demi-God
 
Join Date: Oct 2010
Posts: 1,152
Default

Quote:
Originally Posted by Vire70 View Post
does this exist anymore?
Quote:
Originally Posted by Huppy View Post
Sorry about the dead link, but I've been off the grid for awhile, dealing with RL, which is imminent until next Feb. I trashed a lot of old unused files I had. Maybe I can throw something together later and post it, but it will be from a luclin era setup, on a private server, i have running, using the old bazaar, etc.
Here's an updated link, but keep in mind, this is from a server built around the Titanium client and using older (9159) code.

https://tinyurl.com/classic-zone-pack
__________________
Come on over to Huppy's House (personal/resource forums)
I can also be reached through gmail, at huppyscorner.
Reply With Quote
  #6  
Old 07-20-2021, 04:02 AM
Vire70
Fire Beetle
 
Join Date: Apr 2010
Posts: 25
Default

Quote:
Originally Posted by Huppy View Post
Here's an updated link, but keep in mind, this is from a server built around the Titanium client and using older (9159) code.

https://tinyurl.com/classic-zone-pack
Thanks very much! I am using Titanium so it's perfect. Er, that said, your new link is also dead.
Reply With Quote
  #7  
Old 07-21-2021, 01:30 AM
Huppy's Avatar
Huppy
Demi-God
 
Join Date: Oct 2010
Posts: 1,152
Default

Quote:
Originally Posted by Vire70 View Post
Thanks very much! I am using Titanium so it's perfect. Er, that said, your new link is also dead.
Sorry, (again) haha, was busy trying to clean up my google drive with no sleep.

https://tinyurl.com/classic-doors-zones-pack
__________________
Come on over to Huppy's House (personal/resource forums)
I can also be reached through gmail, at huppyscorner.
Reply With Quote
  #8  
Old 07-21-2021, 09:35 AM
Vire70
Fire Beetle
 
Join Date: Apr 2010
Posts: 25
Default

Quote:
Originally Posted by Huppy View Post
Sorry, (again) haha, was busy trying to clean up my google drive with no sleep.

https://tinyurl.com/classic-doors-zones-pack
Thanks again!
Reply With Quote
  #9  
Old 07-26-2021, 06:36 AM
Huppy's Avatar
Huppy
Demi-God
 
Join Date: Oct 2010
Posts: 1,152
Default

I also have the link for these (and others) posted on a new personal forum site, which i will try to keep updated from time to time. It's also open for others to share resources/links.

You can find it HERE (https://huppyshouse.boards.net/)
__________________
Come on over to Huppy's House (personal/resource forums)
I can also be reached through gmail, at huppyscorner.
Reply With Quote
Reply

Thread Tools
Display Modes

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 12:34 AM.


 

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 - 2021, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3