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.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #24  
Old 01-04-2007, 07:52 AM
bufferofnewbies
Hill Giant
 
Join Date: Dec 2005
Location: Lurking in KY
Posts: 239
Default

I wasn't sure which mirror went where on the top floor, so I started on the left and sent them to floor 1, floor 2, in that order.. up to floor 6. If that's wrong, just let me know the order and I will change it. I reset the mirrors on the top level to correspond to locations of where the other mirrors send you (except for the first one.. which is at zonein) and locked them with keys also (again, except for the first one).

The master key wont work to open any floors except the first floor one that sends you to the key room. That's a limitation atm with the emu, only 1 key per door as far as I can tell.

I set these as seperate commands, instead of one stream. So you will have to run them individually until I learn more about the limits of mysql.
As always: backup before you try this, as I code like old people f... well, you can fill in the blanks there.

Code:
UPDATE doors SET keyitem = '20039' WHERE zone = 'frozenshadow' AND doorid = '1';
UPDATE doors SET keyitem = '20033' WHERE zone = 'frozenshadow' AND doorid = '2';
UPDATE doors SET keyitem = '20033', dest_zone = 'frozenshadow', dest_x = '660', dest_y = '100', dest_z = '40' WHERE zone = 'frozenshadow' AND doorid = '166';
UPDATE doors SET keyitem = '20034' WHERE zone = 'frozenshadow' AND doorid = '4';
UPDATE doors SET keyitem = '20034', dest_zone = 'frozenshadow', dest_x = '670', dest_y = '750', dest_z = '75' WHERE zone = 'frozenshadow' AND doorid = '167';
UPDATE doors SET keyitem = '20035' WHERE zone = 'frozenshadow' AND doorid = '16';
UPDATE doors SET keyitem = '20035', dest_zone = 'frozenshadow', dest_x = '170', dest_y = '755', dest_z = '175' WHERE zone = 'frozenshadow' AND doorid = '165';
UPDATE doors SET keyitem = '20036' WHERE zone = 'frozenshadow' AND doorid = '27';
UPDATE doors SET keyitem = '20036', dest_zone = 'frozenshadow', dest_x = '-150', dest_y = '160', dest_z = '217' WHERE zone = 'frozenshadow' AND doorid = '169';
UPDATE doors SET keyitem = '20037' WHERE zone = 'frozenshadow' AND doorid = '34';
UPDATE doors SET keyitem = '20037', dest_zone = 'frozenshadow', dest_x = '-320', dest_y = '725', dest_z = '12' WHERE zone = 'frozenshadow' AND doorid = '168';
UPDATE doors SET keyitem = '20038' WHERE zone = 'frozenshadow' AND doorid = '44';
Let me know if anything is screwy, else I'm off to the zonelines to fix them.
edit: spelling errors, argh!
Reply With Quote
 


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