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 07-30-2006, 01:50 AM
Belfedia
Demi-God
 
Join Date: Jan 2005
Posts: 1,109
Default

Quote:
Originally Posted by hayward6
Does anyone have the book from Tranquility to Knowledge?
Code:
INSERT INTO `doors` VALUES (10766, 62, 'poknowledge', 'POKPTPORT500', -147.699, -332.22, -155.998, 0, 58, 0, 0, 0, 0, 0, 0, 11, 'potranquility', -1463, 774, -877, 131, 0, 0, 100);
INSERT INTO `doors` VALUES (9209, 1, 'potranquility', 'POKTELE500', 774.53, -1439.2, -876.76, 384, 58, 0, 0, 0, 0, 0, 0, 0, 'poknowledge', -296.43, -147.05, -157.25, 384, 0, 0, 100);
__________________
__________________________________________________ _____________________________________
I speak english like a spanish cow..., I speak spanish like a english pudding...
But I try to speak good french !!! (Non au langage SMS sur forum)
http://eqfroggy.new.fr : Froggy French Server Website.
Reply With Quote
  #2  
Old 07-30-2006, 06:41 AM
hayward6
Forum Guide
 
Join Date: Jul 2005
Posts: 473
Default

Quote:
Originally Posted by Belfedia
Code:
INSERT INTO `doors` VALUES (10766, 62, 'poknowledge', 'POKPTPORT500', -147.699, -332.22, -155.998, 0, 58, 0, 0, 0, 0, 0, 0, 11, 'potranquility', -1463, 774, -877, 131, 0, 0, 100);
INSERT INTO `doors` VALUES (9209, 1, 'potranquility', 'POKTELE500', 774.53, -1439.2, -876.76, 384, 58, 0, 0, 0, 0, 0, 0, 0, 'poknowledge', -296.43, -147.05, -157.25, 384, 0, 0, 100);
Thats strange... I get duplicate entry errors. I better go make sure I didn't just miss the book, or do I need to somehow remove the entries I have?
Reply With Quote
  #3  
Old 07-30-2006, 06:50 AM
Aramid
Discordant
 
Join Date: May 2006
Posts: 356
Default

Quote:
Originally Posted by hayward6
Thats strange... I get duplicate entry errors. I better go make sure I didn't just miss the book, or do I need to somehow remove the entries I have?
The POK to Tranquility SHOULD be there if you have pok mobs installed. The other one from Tranquility to POK, at least in my case, is using a duplicate ID number 9209. You will have to put it in manually with a new id.
Reply With Quote
  #4  
Old 07-30-2006, 10:05 PM
Belfedia
Demi-God
 
Join Date: Jan 2005
Posts: 1,109
Default

My sql command allow

Teleport Pok to tranquility (first line)
Teleport Tranquility to pok (Second line)

If this tp already exist, you must delete them before use my commands...
or use REPLACE in place of INSERT.
__________________
__________________________________________________ _____________________________________
I speak english like a spanish cow..., I speak spanish like a english pudding...
But I try to speak good french !!! (Non au langage SMS sur forum)
http://eqfroggy.new.fr : Froggy French Server Website.
Reply With Quote
  #5  
Old 08-12-2006, 06:45 AM
vales
Discordant
 
Join Date: May 2006
Posts: 458
Default

Thanks a bunch, Thristam.
Reply With Quote
  #6  
Old 11-07-2006, 08:43 AM
Rhodan
Hill Giant
 
Join Date: Oct 2006
Posts: 179
Default

Would anyone have the books that are supposed to be in PoK itself? Its great having all the books in outlying zones to get to PoK but, once there, ya can't get out

Or, could anyone give a blurb on how to create books? I tried to create stone for halas on the halas platform by copying the data from the tranquility portal and giving it a new ID etc, but that doesn't appear to do anything (nothing there after a server reboot).

Oh and also, do door changes require a server reboot or just a zone reboot to take effect?

Thanks!
Reply With Quote
  #7  
Old 11-07-2006, 12:34 PM
sdabbs65
Dragon
 
Join Date: Dec 2003
Location: Earth
Posts: 818
Default ..

Quote:
Originally Posted by Rhodan
Would anyone have the books that are supposed to be in PoK itself? Its great having all the books in outlying zones to get to PoK but, once there, ya can't get out

Or, could anyone give a blurb on how to create books? I tried to create stone for halas on the halas platform by copying the data from the tranquility portal and giving it a new ID etc, but that doesn't appear to do anything (nothing there after a server reboot).

Oh and also, do door changes require a server reboot or just a zone reboot to take effect?

Thanks!
Angelox has them in his database.
and I would do a server reboot anytime you mess with npc's or the database.even tho it's not really required they say.
__________________
hosting Eqemu/Runuo/wow Emulators.

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