need the POK books?

Thristam · #1 07-14-2006, 05:29 AM

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);

Angelox · #2 07-15-2006, 09:55 AM

Got these too, thanks
Now i just need to figure out how to make the LoY book/PoK stone work.

Thristam · #3 07-21-2006, 02:07 AM

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);

**hayward6** · #4 07-27-2006, 11:29 AM

Does anyone have the book from Tranquility to Knowledge?

Belfedia · #5 07-30-2006, 01:50 AM

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);

**hayward6** · #6 07-30-2006, 06:41 AM

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?

Aramid · #7 07-30-2006, 06:50 AM

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.

Belfedia · #8 07-30-2006, 10:05 PM

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.

vales · #9 08-12-2006, 06:45 AM

Thanks a bunch, Thristam.

Rhodan · #10 11-07-2006, 08:43 AM

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!

sdabbs65 · #11 11-07-2006, 12:34 PM

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.

Rhodan · #12 11-07-2006, 02:09 PM

Ah cool. I'll have to download and find the entries. Might give me some idea how to create the things too.

John Adams · #13 11-08-2006, 01:10 PM

I think these are the entries you're looking for.

Query to get data in ax_peq:

Code:

SELECT * 
FROM `doors` 
WHERE `zone` = 'poknowledge'
AND `name` LIKE '%PORT%'

See previous suggestion to use REPLACE instead of INSERT if you get errors.

Code:

INSERT INTO `doors` (`id`, `doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`) VALUES 
(2040, 37, 'PoKnowledge', 'POKRVPORT500', 908.668, 1228.06, -156.248, 384, 58, 0, 0, 0, 0, 0, 0, 0, 'Misty', -1262.71, -559.555, 8, 2, 0, 0, 100),
(2041, 36, 'PoKnowledge', 'POKKELPORT500', 908.392, 883.566, -156.248, 384, 58, 0, 0, 0, 0, 0, 0, 0, 'Gfaydark', -1820.6, -2260.51, 1, 17, 0, 0, 100),
(2042, 35, 'PoKnowledge', 'POKKALPORT500', 908.506, 475.293, -156.148, 384, 58, 0, 0, 0, 0, 0, 0, 0, 'Butcher', -506.765, 1754.95, -1, 258.95, 0, 0, 100),
(2043, 34, 'PoKnowledge', 'POKHALPORT500', 908.6, 132.109, -155.998, 128, 58, 0, 0, 0, 0, 0, 0, 0, 'Everfrost', -78.1207, 2887.25, -62, 238.73, 0, 0, 100),
(2044, 33, 'PoKnowledge', 'POKFELPORT500', 811.879, 37.1375, -155.998, 256, 58, 0, 0, 0, 0, 0, 0, 0, 'Gfaydark', -757.995, -173.6, -2, 163.29, 0, 0, 100),
(2045, 32, 'PoKnowledge', 'POKERPORT500', 594.484, 35.9378, -155.998, 384, 58, 0, 0, 0, 0, 0, 0, 0, 'Tox', -582.532, 2324.96, -45, 120, 0, 0, 100),
(2046, 31, 'PoKnowledge', 'POKTNPORT500', 460.965, -76.3714, -156.098, 128, 58, 0, 0, 0, 0, 0, 0, 0, 'Nexus', 364, 75, -45.9, 384, 0, 0, 100),
(2047, 30, 'PoKnowledge', 'POKTGDPORT500', 459.376, -235.678, -156.248, 0, 58, 0, 0, 0, 0, 0, 0, 0, 'Greatdivide', -1811.42, 14.5537, 391, 272, 0, 0, 100),
(2048, 29, 'PoKnowledge', 'POKSHPORT500', 363.598, -332.179, -156.098, 256, 58, 0, 0, 0, 0, 0, 0, 0, 'Shadeweaver', -2425.1, -3011.8, -216, 494, 0, 0, 100),
(2049, 28, 'PoKnowledge', 'POKQNSPORT500', 147.521, -331.698, -156.248, 384, 58, 0, 0, 0, 0, 0, 0, 0, 'Qeynos2', 484.484, 183.698, 2, 3, 0, 0, 100),
(2050, 27, 'PoKnowledge', 'POKPTPORT500', -147.699, -332.22, -155.998, 0, 58, 0, 0, 0, 0, 0, 0, 0, 'PoTranquility', -1436.7, 773.065, -878, 375, 0, 0, 100),
(2051, 26, 'PoKnowledge', 'POKFVPORT500', -364.254, -331.823, -156.348, 384, 58, 0, 0, 0, 0, 0, 0, 0, 'Firiona', 4717.31, -455.367, 12, 384, 0, 0, 100),
(2052, 25, 'PoKnowledge', 'POKFPTPORT500', -461.026, -235.181, -156.148, 128, 58, 0, 0, 0, 0, 0, 0, 0, 'FreportW', 77.3664, -682.064, -32, 0, 0, 0, 100),
(2053, 24, 'PoKnowledge', 'POKAAPORT500', -460.389, -76.4827, -156.248, 256, 58, 0, 0, 0, 0, 0, 0, 0, 'Steamfont', 933.79, -1373.04, -109, 0, 0, 0, 100),
(2054, 23, 'PoKnowledge', 'POKOVPORT500', -897.068, 872.22, -159.348, 384, 58, 0, 0, 0, 0, 0, 0, 0, 'Overthere', 1937.59, 3134.56, -51, 384, 0, 0, 100),
(2055, 18, 'PoKnowledge', 'POKCABPORT500', -596.697, 36.122, -155.998, 0, 58, 0, 0, 0, 0, 0, 0, 0, 'FieldOfBone', 1843.5, -3010.88, 10, 0, 0, 0, 100),
(2056, 19, 'PoKnowledge', 'POKGROPORT500', -801.225, 46.9839, -159.248, 0, 58, 0, 0, 0, 0, 0, 0, 0, 'Innothule', -29.9866, -729.133, -27, 477.21, 0, 0, 100),
(2057, 20, 'PoKnowledge', 'POKNRKPORT500', -909.187, 131.793, -156.148, 256, 58, 0, 0, 0, 0, 0, 0, 0, 'Nektulos', -342.478, 742.973, -6, 267.81, 0, 0, 100),
(2058, 21, 'PoKnowledge', 'POKOGPORT500', -906.998, 443.859, -156.148, 256, 58, 0, 0, 0, 0, 0, 0, 0, 'Feerrott', -161.403, 867.158, -7, 504, 0, 0, 100),
(2059, 22, 'PoKnowledge', 'POKPPORT500', -896.653, 1215.84, -159.348, 384, 58, 0, 0, 0, 0, 0, 0, 0, 'Tox', 295.884, -2344.14, -47, 371.01, 0, 0, 100);

** Check your ID columns! This is from ax_peq.

Also, does anyone have an idea how to stick the Gunthak portal and guild hall / bazaar entrance in PoK? I have no idea how to start looking into adding actual physical objects to the world yet. :( I'm scared. Hold me.

TIA,
J

John Adams · #14 11-11-2006, 11:17 AM

Quote:

Originally Posted by John Adams

Also, does anyone have an idea how to stick the Gunthak portal and guild hall / bazaar entrance in PoK? I have no idea how to start looking into adding actual physical objects to the world yet.

I made a half-ass attempt to browse the eqg and s3d files in Knowledge to see if anything leaped out at me on how to add these building faces. Nothing seems obvious.

Then it dawned on me... If Titanium is OG -> DoDH, why do we not see the guild hall and bazaar (and at least the Gunthak platform) in our Emu PoKs? Anyone at all know? I hate coming up with a workaround of just sticking a clickable object where they should be. Looks so ghetto.

I guess my bigger question is, why are these not present in an expansion CD that is way passed when they were introduced?

Rhodan · #15 11-11-2006, 11:53 AM

I'm guessing they are placable objects in Live - someone didnt want to have to rebuild the zone map...