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-14-2006, 05:29 AM
Thristam
Hill Giant
 
Join Date: Jun 2006
Posts: 117
Default need the POK books?

I tracked down the pok books on the different zones and have added them for eqemu 7.0 here or just copy text below.

I think the only one currently missing is the tranquility one and the arena. If you see anything or have suggestions, by all means, make them

You might have to change the first set of numbers in the values to fit them into your db.

Code:
INSERT INTO doors VALUES (5337,77,'feerrott','POKTELE500',867.158,-161.403,-9.75448,504,58,0,0,0,0,0,0,0,'poknowledge',444,-844,-157,255,0,0,100);
INSERT INTO doors VALUES (5783,177,'freportw','POKTELE500',-682.064,77.3664,-34.8048,0,58,0,0,0,0,0,0,0,'poknowledge',-234,-406,-157,258,0,0,100);
INSERT INTO doors VALUES (5996,77,'qeynos2','POKTELE500',183.698,484.484,0.002,3,58,0,0,0,0,0,0,0,'poknowledge',-289,147,-157,383,0,0,100);
INSERT INTO doors VALUES (6623,77,'fieldofbone','POKTELE500',-3010.88,1843.5,8.377,0,58,0,0,0,0,0,0,0,'poknowledge',36,-655,-157,1,0,0,100);
INSERT INTO doors VALUES (6624,77,'firiona','POKTELE500',-455.367,4717.31,10.1273,384,58,0,0,0,0,0,0,0,'poknowledge',-279,-363,-157,383,0,0,100);
INSERT INTO doors VALUES (7123,77,'overthere','POKTELE500',3134.56,1937.59,-53.3417,384,58,0,0,0,0,0,0,0,'poknowledge',884,-840,-157,254,0,0,100);
INSERT INTO doors VALUES (8046,77,'greatdivide','POKTELE500',14.5537,-1811.42,389.439,272,58,0,0,0,0,0,0,0,'poknowledge',-235,393,-157,810,0,0,100);
INSERT INTO doors VALUES (9363,78,'shadeweaver','POKTELE500',-3011.8,-2425.1,-218.342,494,58,0,0,0,0,0,0,77,'poknowledge',364,-293,-157,383,0,511,100);
INSERT INTO doors VALUES (2409,77,'tox','POKTELE500',2321.27,-592.09,-44.48,504,58,0,0,0,0,0,0,0,'poknowledge',444,-844,-157,255,0,0,100);
INSERT INTO doors VALUES (4446,2,'Nexus','POKTELE500',44.9147,481.664,-30.8975,384,58,0,0,0,0,0,0,0,'poknowledge',-76.3714,460.965,-145,128,0,0,100);
INSERT INTO doors VALUES (5069,108,'gfaydark','POKTELE500',-2256.54,-1821.84,1.12,504,58,0,0,0,0,0,0,0,'poknowledge',444,-844,-157,255,0,0,100);
INSERT INTO doors VALUES (3415,1,'Everfrost','POKTELE500',2887.25,-78.1207,-64.1542,238.73,58,0,0,0,0,0,0,0,'poknowledge',132.109,908.6,-145,128,0,0,100);
INSERT INTO doors VALUES (5070,1,'Innothule','POKTELE500',-729.133,-29.9866,-29.2157,477.21,58,0,0,0,0,0,0,0,'poknowledge',120.984,-801.225,-145,0,0,0,100);
INSERT INTO doors VALUES (5071,109,'gfaydark','POKTELE500',-167.8,-760.54,-0.53,504,58,0,0,0,0,0,0,0,'poknowledge',444,-844,-157,255,0,0,100);
INSERT INTO doors VALUES (9761,1,'nektulos','POKTELE500',710.63,-185.86,-35.4,504,58,0,0,0,0,0,0,0,'poknowledge',129,-870,-157.7,255,0,0,100);
INSERT INTO doors VALUES (9762,78,'tox','POKTELE500',-2351.65,-269.28,-46.19,504,58,0,0,0,0,0,0,0,'poknowledge',1227,-864,-157.7,255,0,0,100);
INSERT INTO doors VALUES (9763,78,'steamfont','POKTELE500',-1358.23,926.95,-108.36,504,58,0,0,0,0,0,0,0,'poknowledge',-73,-419,-157.7,255,0,0,100);
Reply With Quote
  #2  
Old 07-15-2006, 09:55 AM
Angelox
AX Classic Developer
 
Join Date: May 2006
Location: filler
Posts: 2,049
Default

Got these too, thanks
Now i just need to figure out how to make the LoY book/PoK stone work.
Reply With Quote
  #3  
Old 07-21-2006, 02:07 AM
Thristam
Hill Giant
 
Join Date: Jun 2006
Posts: 117
Default

Found a POK book missing for Misty Ticket. Here is the insert for it.

Code:
INSERT INTO doors VALUES (9765,77,'misty','POKTELE500',-528.88,-1268.26,11.00,504.00,58,0,0,0,0,0,0,0,'poknowledge',-73.00,-419.000,-157.70,255.00,0,0,100);
Reply With Quote
  #4  
Old 07-27-2006, 11:29 AM
hayward6
Forum Guide
 
Join Date: Jul 2005
Posts: 473
Default

Does anyone have the book from Tranquility to Knowledge?
Reply With Quote
  #5  
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
  #6  
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
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 04:44 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