Log in

View Full Version : Looking for POP books query


aragon
04-09-2005, 04:58 AM
Got my server on 6.0DR2 and dont have any POP book working on it. Can anyone please post any sql that I could source on my database please?

Thanks,

sysadmin
04-09-2005, 05:02 AM
check this link (http://www.eqemulator.net/forums/showthread.php?t=18122) and source in the poknowledge section, then source in this:

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,70,'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,57,0,0,0,0,0,0,0,'poknowled ge',36,-655,-157,1,0,0,100);
INSERT INTO doors VALUES (6624,77,'firiona','POKTELE500',-455.367,4717.31,10.1273,384,57,0,0,0,0,0,0,0,'pokn owledge',-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 (9209,59,'potranquility','POKTELE500',774.53,-1439.2,-879.76,384,58,0,0,0,0,0,0,0,'poknowledge',-148,-285,-159,383,0,0,100);
INSERT INTO doors VALUES (9208,1,'innothule','POKTELE500',-747.56,-13.3,-26.99,0,58,0,0,0,0,0,0,0,'poknowledge',-813.27,70.94,-157.25,384,0,0,100);
INSERT INTO doors VALUES (9207,1,'shadeweaver','POKTELE500',-3006.17,-2417.88,-216.84,0,58,0,0,0,0,0,0,0,'poknowledge',363.25,-292.94,-157.25,255,0,0,100);
INSERT INTO doors VALUES (9201,7,'tox','POKTELE500',2329.86,-581.84,-47.72,256,58,0,0,0,0,0,0,0,'poknowledge',37.91,557 .16,-156.25,0,0,0,100);
INSERT INTO doors VALUES (9202,178,'gfaydark','POKTELE500',-2258.71,-1820.35,-1.11,0,58,0,0,0,0,0,0,0,'poknowledge',73.84,815.52 ,-157.25,0,0,0,100);
INSERT INTO doors VALUES (9203,10,'everfrost','POKTELE500',2879.97,-81.1,-62.15,256,58,0,0,0,0,0,0,0,'poknowledge',876.02,13 3.47,-157.25,0,0,0,100);
INSERT INTO doors VALUES (9204,5,'butcher','POKTELE500',1801.17,-488.92,-3.35,256,58,0,0,0,0,0,0,0,'poknowledge',473,900,-156.25,0,0,0,100);
INSERT INTO doors VALUES (9211,26,'nektulos','POKTELE500',732.91,-358.35,-4.34,255,58,0,0,0,0,0,0,0,'poknowledge',131.49,-869.17,-157.25,255,0,0,100);
INSERT INTO doors VALUES (9206,1,'nexus','POKTELE500',42.51,469.02,-28.73,0,58,0,0,0,0,0,0,0,'poknowledge',-76.85,402.2,-157.25,128,0,0,100);
INSERT INTO doors VALUES (9200,50,'Misty','POKTELE500',-530,-1249,5.65,256,58,0,0,0,0,0,0,0,'poknowledge',900,1 220,-156,0,0,0,100);
INSERT INTO doors VALUES (9212,8,'tox','POKTELE500',-2347.13,284.44,-47.74,255,58,0,0,0,0,0,0,0,'poknowledge',1226.78,-854.3,157.25,255,0,0,100);
INSERT INTO doors VALUES (9213,177,'gfaydark','POKTELE500',-173.59,-757.99,-4.09,163.29,58,0,0,0,0,0,0,0,'poknowledge',883.78, 857.54,-157.25,0,0,0,100);
INSERT INTO doors VALUES (10203,4,'potranquility','POKTELE500',773.06,-1436.7,-880.16,375,58,0,0,0,0,0,0,77,'poknowledge',-148,-285,-159,383,0,0,100);
INSERT INTO doors VALUES (11047,77,'steamfont','POKTELE500',-1373.04,933.79,-111.662,0,57,0,0,0,0,0,0,77,'poknowledge',-76,-401,-156,255,0,0,100);

aragon
04-09-2005, 08:03 AM
It works great, thanks!! Just missing the stones inside POK zone, but all the others work fine. Let me know If you have this code.

sysadmin
04-09-2005, 08:26 AM
check the link I posted above, has the stones and doors.

aragon
04-09-2005, 08:51 AM
Got it! Thank you again!