View Single Post
  #13  
Old 11-08-2006, 01:10 PM
John Adams
Demi-God
 
Join Date: Jul 2006
Posts: 1,552
Default

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
Reply With Quote