|
|
 |
 |
 |
 |
|
 |
 |
|
 |
 |
|
 |
|
Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc. |
 |
|
 |

07-14-2006, 05:29 AM
|
Hill Giant
|
|
Join Date: Jun 2006
Posts: 117
|
|
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);
|
 |
|
 |

07-15-2006, 09:55 AM
|
AX Classic Developer
|
|
Join Date: May 2006
Location: filler
Posts: 2,049
|
|
Got these too, thanks
Now i just need to figure out how to make the LoY book/PoK stone work.
|

07-21-2006, 02:07 AM
|
Hill Giant
|
|
Join Date: Jun 2006
Posts: 117
|
|
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);
|

07-27-2006, 11:29 AM
|
Forum Guide
|
|
Join Date: Jul 2005
Posts: 473
|
|
Does anyone have the book from Tranquility to Knowledge?
|

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

07-30-2006, 06:41 AM
|
Forum Guide
|
|
Join Date: Jul 2005
Posts: 473
|
|
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?
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 04:44 AM.
|
|
 |
|
 |
|
|
|
 |
|
 |
|
 |