need the POK books?

[Belfedia]

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]

Thanks a bunch, Thristam.

[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!

[sdabbs65]

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]

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

[John Adams]

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

Query to get data in ax_peq:

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

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

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]

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?