[ADDED] NPC Table

Submit code for osProse project.

Moderators: osRose dev team, ospRose dev team, osiRose dev team, Moderators

[ADDED] NPC Table

Postby Drakia on Sun May 11, 2008 10:38 pm

Here is an NPC table dump directly from the client, all positions and directions seem accurate. Reply if there's any problems

I updated this to the latest dump from my tool. It now has about 50 more NPC's, clan NPC's, event NPC's, etc.

Update #2:
Rounding errors were bothering me, so I decided to just leave the values un-rounded, they're floats after all.

  1. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Sikuku Warrior] Ruduck', '1254', '62', '118.186729', '5746.770000', '4776.180000');
  2. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Sikuku Warrior] Yak', '1255', '62', '298.186829', '5761.610000', '4779.420000');
  3. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Sikuku Warrior] Seka', '1256', '62', '189.227707', '5773.050000', '4732.450000');
  4. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Sikuku Chief] Namiel Char', '1252', '62', '311.683746', '5807.890000', '4714.390000');
  5. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Sikuku Warrior] Wounded Soldier', '1262', '62', '337.957367', '5854.030000', '4685.470000');
  6. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Sikuku Warrior] Wounded Soldier', '1262', '62', '179.999939', '5822.890000', '4683.300000');
  7. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Cleric] Jude', '1251', '62', '153.435089', '5767.720000', '4687.550000');
  8. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Sikuku Resident] Parah', '1260', '62', '17.988810', '5819.410000', '4634.660000');
  9. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Station Guide] Chacha', '1219', '61', '12.550213', '5226.600000', '4452.720000');
  10. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Raknu Warrior] Toanu', '1229', '61', '180.000061', '5433.180000', '4671.450000');
  11. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Raknu Warrior] Guanu', '1230', '61', '178.499039', '5425.000000', '4671.480000');
  12. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Elder of Junon Order] Oscar Patrick', '1214', '61', '157.957489', '5371.180000', '4546.510000');
  13. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Righteous Crusader] Harold Evan', '1211', '61', '14.292793', '5369.750000', '4575.290000');
  14. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Smith] Nel Eldora', '1223', '61', '14.292793', '5395.550000', '4614.050000');
  15. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Akram Ambassador] Jacklyn Cooper', '1215', '61', '179.999939', '5430.000000', '4483.790000');
  16. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Patrol Dog] Stephen', '1244', '61', '180.000061', '5427.520000', '4482.430000');
  17. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Raknu Warrior] Jeffrey Lloyd', '1221', '61', '180.000061', '5434.010000', '4595.870000');
  18. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Arumic Researcher] Catherine Clara', '1212', '61', '330.956299', '5473.370000', '4618.790000');
  19. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Ferrell Guild Staff] Gilbert', '1213', '61', '217.593918', '5474.350000', '4513.740000');
  20. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Storage Keeper] Dustin Leta', '1222', '61', '197.988708', '5489.630000', '4553.050000');
  21. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Patrol Dog] Max', '1243', '61', '199.964691', '5487.270000', '4550.960000');
  22. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Raknu Resident] Netty', '1237', '61', '328.306793', '5494.830000', '4593.460000');
  23. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Raknu Chief] Darka Khan', '1220', '61', '352.369263', '5650.090000', '4464.730000');
  24. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Chef] Peppie', '1224', '61', '192.550278', '5627.370000', '4436.050000');
  25. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Raknu Resident] Jerrita', '1236', '61', '303.017059', '5657.170000', '4455.980000');
  26. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Clan House Soldier] Jason', '1162', '15', '183.008301', '5205.790000', '5129.920000');
  27. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Clan House Manager] Kushard', '1161', '15', '0.000000', '5200.160000', '5209.810000');
  28. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Clan House Soldier] Jason', '1162', '15', '181.501083', '5204.570000', '4970.370000');
  29. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Clan House Manager] Kushard', '1161', '15', '0.000000', '5200.130000', '5051.790000');
  30. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Clan House Soldier] Jason', '1162', '15', '181.501083', '5203.890000', '4809.550000');
  31. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Clan House Manager] Kushard', '1161', '15', '0.000000', '5200.160000', '4890.670000');
  32. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Clan House Manager] Kushard', '1161', '15', '0.000000', '5360.210000', '5210.150000');
  33. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Clan House Soldier] Jason', '1162', '15', '180.000061', '5363.940000', '5130.380000');
  34. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Clan House Soldier] Jason', '1162', '15', '180.000061', '5364.040000', '4970.330000');
  35. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Clan House Manager] Kushard', '1161', '15', '0.000000', '5360.200000', '5051.410000');
  36. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Clan House Soldier] Jason', '1162', '15', '183.008301', '5363.850000', '4810.420000');
  37. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Clan House Manager] Kushard', '1161', '15', '0.000000', '5360.250000', '4890.300000');
  38. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Clan House Soldier] Jason', '1162', '15', '183.008301', '5524.300000', '5129.460000');
  39. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Clan House Manager] Kushard', '1161', '15', '0.000000', '5520.190000', '5211.310000');
  40. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Clan House Soldier] Jason', '1162', '15', '183.008301', '5523.830000', '4970.150000');
  41. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Clan House Manager] Kushard', '1161', '15', '0.000000', '5520.180000', '5051.410000');
  42. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Clan House Soldier] Jason', '1162', '15', '181.501083', '5523.670000', '4810.610000');
  43. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Clan House Manager] Kushard', '1161', '15', '0.000000', '5520.160000', '4891.070000');
  44. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Arumic Resercher] Lutis', '1051', '21', '160.035309', '5118.140000', '5374.910000');
  45. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Cleric] Karitte', '1053', '21', '95.983589', '5112.440000', '5385.080000');
  46. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Mountain Guide] Shannon', '1052', '21', '353.933472', '5357.266836', '5282.186543');
  47. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Ferrell Guild Merchant] Lina', '1071', '24', '293.031006', '5567.262305', '4927.030996');
  48. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Gypsy Merchant] Methio', '1072', '24', '192.550278', '5563.129648', '4895.445313');
  49. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Ikaness Staff] Orias', '1073', '24', '95.983589', '5515.264746', '4925.138398');
  50. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Ferrell Guild Merchant] Med', '1151', '28', '127.514427', '5587.089922', '4732.285547');
  51. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Livestock Farmer] Lampa', '1016', '1', '173.933548', '5109.424814', '5363.676201');
  52. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Ferrell Guild Staff] Crow', '1004', '1', '6.066525', '5094.376074', '5259.903071');
  53. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Ferrell Guild Staff] Ulysses', '1012', '1', '84.016289', '5071.262881', '5206.916473');
  54. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Co-Founder of the Junon Order] Francis', '1003', '1', '157.957306', '5080.304102', '5066.277432');
  55. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Righteous Crusader] Leonard', '1005', '1', '16.102114', '5261.083027', '5166.958972');
  56. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Designer] Keenu', '1010', '1', '343.897888', '5273.496030', '5256.832769');
  57. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Eccentric Inventor] Spero', '1011', '1', '14.292793', '5212.363158', '5254.664468');
  58. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Tavern Owner] Sharlin', '1013', '1', '333.434937', '5131.564331', '5218.138055');
  59. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Resident] Luth', '1015', '1', '270.000061', '5130.607100', '5154.577861');
  60. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Guide] Lena', '1014', '1', '169.135178', '5240.400000', '5124.570000');
  61. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Event Info] Judy', '1201', '1', '162.011124', '5261.880000', '5212.970000');
  62. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Teleporter] Selladin', '1017', '1', '162.011292', '5247.240000', '5222.580000');
  63. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Akram Kingdom Minister] Warren', '1002', '1', '178.499039', '5208.782952', '5112.937686');
  64. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Village Chief] Cornell', '1001', '1', '183.008301', '5217.514548', '5113.184551');
  65. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Cornell's Grandson] Cheney', '1018', '1', '34.535397', '5438.630000', '5492.200000');
  66. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Arumic Merchant] Tryteh', '1006', '1', '258.128845', '5313.257969', '5153.735098');
  67. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Gypsy Jewel Seller] Mina', '1007', '1', '197.988876', '5292.562041', '5127.662778');
  68. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Weapon Seller] Raffle', '1008', '1', '322.406158', '5302.316357', '5232.337769');
  69. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Armor Seller] Carrion', '1009', '1', '275.983704', '5313.533750', '5198.140495');
  70. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Keenu's Daughter] Arisa', '1020', '1', '214.535477', '5428.750000', '5084.200000');
  71. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Lena's Sister] Shirley', '1019', '1', '333.434937', '5510.140000', '5293.330000');
  72. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Little Street Vendor] Pony', '1035', '22', '165.707153', '5751.580000', '5189.860000');
  73. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Ferrell Guild Staff] Peron', '1511', '22', '9.227651', '5832.200000', '5315.540000');
  74. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Akram Minister] Mairard', '1032', '22', '333.434937', '5882.360000', '5263.180000');
  75. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Old Fisherman] Myad', '1037', '22', '252.423492', '5868.200000', '5137.120000');
  76. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Smith] Ronk', '1034', '22', '16.102114', '5779.710000', '5276.760000');
  77. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Ferrell Guild Staff] Seyon', '1036', '22', '342.011200', '5796.580000', '5278.060000');
  78. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Visitor Guide] Ronway', '1031', '22', '153.434875', '5763.280000', '5169.430000');
  79. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Village Chief] Gray', '1038', '22', '275.983704', '5879.090000', '5105.120000');
  80. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Ferrell Guild Staff] Belz', '1061', '23', '270.000061', '5358.633291', '5058.990859');
  81. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Smith] Punwell', '1062', '23', '24.237373', '5340.650684', '5070.257188');
  82. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Little Street Vendor] Mile', '1063', '23', '307.514465', '5356.411504', '5043.277236');
  83. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Weapon Craftsman] Mairath', '1064', '23', '179.999939', '5349.023828', '5033.946934');
  84. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Ikaness Staff] Shroon', '1121', '25', '9.227651', '5375.777070', '5188.330280');
  85. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Guide of Plain] Pein', '1122', '25', '307.514465', '5503.220762', '5350.929072');
  86. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Gypsy Seller] Edone', '1123', '25', '187.630798', '5448.138984', '4976.374844');
  87. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Mountain Guide] Kay', '1131', '26', '22.042633', '5669.158516', '5105.235225');
  88. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Ferrell Guild Merchant ] Bith', '1143', '27', '197.988876', '5259.718745', '5147.638218');
  89. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Ferrell Guild Staff] Robin', '1512', '27', '264.016418', '5239.230000', '5040.740000');
  90. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Residents] Hotch', '1144', '27', '189.227707', '5384.230547', '5180.101659');
  91. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Righteous Crusader] Gallahad', '1141', '27', '178.499039', '5345.199346', '5047.711201');
  92. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Akram Minister] Luce', '1142', '27', '101.871147', '5320.524238', '5081.271387');
  93. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Ferrell Guild Staff] Rooen', '1513', '3', '0.000000', '5104.481689', '5019.705684');
  94. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Visitor Guide] Arua's Fairy', '1030', '20', '29.043478', '5030.740000', '5136.110000');
  95. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Visitor Guide] Arua's Fairy', '1030', '20', '160.035492', '5141.140000', '4730.240000');
  96. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Visitor Guide] Arua's Fairy', '1030', '20', '52.485519', '5341.630000', '5382.600000');
  97. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Visitor Guide] Arua's Fairy', '1030', '20', '359.999878', '5695.390000', '5166.660000');
  98. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Visitor Guide] Arua's Fairy', '1030', '20', '204.237442', '5652.450000', '4761.480000');
  99. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Akram Minister] Nell', '1085', '11', '84.016289', '4953.370000', '4992.350000');
  100. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Akram Minister] Nell', '1085', '11', '10.864777', '4978.480000', '5478.600000');
  101. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Akram Minister] Nell', '1085', '11', '337.957367', '5455.570000', '5478.990000');
  102. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Akram Minister] Nell', '1085', '11', '335.762634', '5521.940000', '5020.660000');
  103. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Akram Minister] Nell', '1085', '12', '84.016289', '4953.370000', '4992.350000');
  104. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Akram Minister] Nell', '1085', '12', '10.864777', '4978.480000', '5478.600000');
  105. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Akram Minister] Nell', '1085', '12', '337.957367', '5455.570000', '5478.990000');
  106. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Akram Minister] Nell', '1085', '12', '335.762634', '5521.940000', '5020.660000');
  107. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Akram Minister] Nell', '1085', '13', '84.016289', '4953.370000', '4992.350000');
  108. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Akram Minister] Nell', '1085', '13', '10.864777', '4978.480000', '5478.600000');
  109. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Akram Minister] Nell', '1085', '13', '337.957367', '5455.570000', '5478.990000');
  110. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Akram Minister] Nell', '1085', '13', '335.762634', '5521.940000', '5020.660000');
  111. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Righteous Crusader] Gawain', '1090', '2', '84.016289', '5334.580000', '5353.910000');
  112. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Righteous Crusader] Huffe', '1111', '2', '89.999947', '5334.840000', '5345.810000');
  113. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Clan Owner] Burtland', '1115', '2', '89.999947', '5289.100000', '5264.100000');
  114. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Teleporter] Idiosel', '1119', '2', '270.000061', '5343.670000', '5177.360000');
  115. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Founder of Junon Order] Raw', '1088', '2', '181.501083', '5319.270000', '5095.360000');
  116. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Elder of Junon Order] Gorthein', '1109', '2', '181.500961', '5325.540000', '5095.310000');
  117. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Guide] Eva', '1082', '2', '153.434875', '5505.780000', '5346.090000');
  118. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Soldier] Odelo', '1116', '2', '0.000000', '5507.310000', '5397.400000');
  119. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Soldier] Winters', '1117', '2', '0.000000', '5522.990000', '5397.750000');
  120. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Mayor] Darren', '1081', '2', '178.499039', '5514.480000', '5238.200000');
  121. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Event Info] Felice Fete', '1202', '2', '206.565125', '5562.000000', '5164.830000');
  122. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Guide] Alphonso', '1118', '2', '178.499039', '5520.560000', '5063.660000');
  123. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Historian] Jones', '1104', '2', '162.011292', '5578.190000', '4890.440000');
  124. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Manager of Ferrell] Arothel', '1089', '2', '270.000061', '5713.430000', '5360.160000');
  125. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Armor Merchant] Saki', '1094', '2', '258.128845', '5721.800000', '5290.790000');
  126. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Ferrell Guild Staff] Charrs', '1110', '2', '270.000061', '5713.380000', '5368.710000');
  127. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Gypsy Jewel Seller] Bellia', '1092', '2', '217.593918', '5725.110000', '5199.040000');
  128. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Weapon Merchant] Crune', '1093', '2', '335.762634', '5728.670000', '5224.890000');
  129. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Designer] Lisa', '1095', '2', '220.893463', '5729.060000', '5136.330000');
  130. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Ferrell Guild Merchant] Mildun', '1096', '2', '165.707306', '5673.160000', '5193.890000');
  131. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Tavern Owner] Harin', '1097', '2', '89.999947', '5681.790000', '5131.110000');
  132. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Arumic Merchant] Chester', '1091', '2', '211.693268', '5723.960000', '5087.240000');
  133. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Ferrell Guild Staff] Kiroth', '1098', '2', '275.983704', '5603.580000', '5058.100000');
  134. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Ferrell Guild Staff] Hayen', '1099', '2', '258.128845', '5603.770000', '5046.120000');
  135. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Ferrell Guild Staff] Itz', '1100', '2', '270.000061', '5603.690000', '5034.520000');
  136. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Arumic Researcher] Carasia', '1112', '2', '197.988876', '5730.570000', '5094.060000');
  137. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Livestock Farmer] Sicru', '1107', '2', '187.630798', '5818.020000', '5487.590000');
  138. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Akram Minister] Rodath', '1086', '5', '89.999947', '5155.070000', '5279.920000');
  139. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Akram Minister] Mel', '1087', '5', '270.000061', '5247.070000', '5279.960000');
  140. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Akram Minister] Gamp', '1084', '6', '270.000061', '5248.140000', '5279.200000');
  141. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Referee] Leum', '1113', '9', '0.000000', '5199.990000', '5390.040000');
  142. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Referee] Pirre', '1114', '9', '180.000061', '5201.590000', '4765.690000');
  143. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Event Info] Lucielle Fete', '1203', '40', '333.434937', '5254.640000', '5216.390000');
  144. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Event Info] Judith', '1204', '37', '358.498962', '5115.680000', '5324.150000');
  145. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Station Guide] Illiya', '1188', '51', '148.306732', '5107.240000', '4996.570000');
  146. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Tavern Owner] Anzhelika', '1186', '51', '139.106537', '5263.610000', '5079.490000');
  147. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Ferrell Guild Banker] Andre', '1180', '51', '0.000000', '5414.860000', '5114.410000');
  148. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Magic Goods Seller] Pabel', '1185', '51', '3.008247', '5298.980000', '5105.030000');
  149. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Arumic Prophet] Olleck Basilasi', '1173', '51', '178.499039', '5359.620000', '5085.720000');
  150. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Akram Ambassador] Eliot', '1172', '51', '157.957306', '5285.690000', '4940.950000');
  151. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Eucar Judge] Ishtal', '1171', '51', '206.565125', '5430.090000', '4937.960000');
  152. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Smith] Pavrick', '1181', '51', '335.762634', '5440.450000', '5103.410000');
  153. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Ferrell Trader] Sergei', '1184', '51', '258.128845', '5452.580000', '5077.110000');
  154. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Shamanist] Est', '1191', '54', '84.016289', '5088.260000', '4257.840000');
  155. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Event Info] Santa Claus', '1205', '38', '3.012369', '5069.180000', '5362.510000');
  156. INSERT INTO `list_npcs` (name, type, map, dir, x, y) values ('[Event Info] Loelsch', '1206', '38', '66.940689', '5057.190000', '5351.610000');
  157.  
Last edited by Drakia on Wed May 14, 2008 4:06 am, edited 4 times in total.
My favorite skill is scaring new users away.
If you haven't SEARCHED expect me to yell at you.
Image
Drakia
ospRose dev team
ospRose dev team
 
Posts: 1614
Joined: Tue Sep 18, 2007 6:53 am
Location: Nanaimo, BC, Canada

Re: NPC Table

Postby Rescudo on Sun May 11, 2008 10:41 pm

I guess you wrote a script to extract the coordinates from .IFO, nice job :) Could we use this to get the exact monster spawns too? And would either work for OsRose (Evo)?
SEARCH - it's there for a reason!
User avatar
Rescudo
El Verloon Marshall
El Verloon Marshall
 
Posts: 872
Joined: Tue Mar 11, 2008 7:20 am

Re: NPC Table

Postby Drakia on Sun May 11, 2008 10:47 pm

Right now I'm converting it to C++ (I wrote it in PHP, it's what I'm best at :D) but it should work with Evo, and also be able to be adapted to monster spawns.
My favorite skill is scaring new users away.
If you haven't SEARCHED expect me to yell at you.
Image
Drakia
ospRose dev team
ospRose dev team
 
Posts: 1614
Joined: Tue Sep 18, 2007 6:53 am
Location: Nanaimo, BC, Canada

Re: NPC Table

Postby Drakia on Mon May 12, 2008 3:02 am

Here is a simple console program that you can throw into an extracted "3ddata" folder to get a dump of the NPCs. It should get proper x, y and direction, as well as map, name and type. It should work with iRose, Pre-Evo, and Evo VFS dumps.
I compared it to the Evo table included with OSRose, and only things missing were teleporters, which Rob added, Clan House NPCs, and some event NPCs.

I'm aware my code is hideous, I wrote it between 6pm last night, and 6pm tonight, with about 4 hours of sleep in between. It was originally written in PHP (As I find that easiest) and then converted to C++. It's probably not the most efficient program, but it works.

[Edit]
I looked into things a bit more, and it turns out that I'm going to need to add a check with the STB into this for the NPCs ID as well. Stupid TriggerSoft splitting everything up so much.

[Edit #2]
Ok, I edited the dumper so that it will now compare the IFO given NPC id with the STB given STL id, so everything should be named right, and ID'd right in the database. It also now checks all the event directories (Stupid case sensitivity) so there's all those event NPC's loaded now :)

[Edit #3]
I took out the rounding of dir, x and y, since they're floats they can use the extra precision. It was irritating me having things off because of rounding. And to anyone who is going to say it, I know my code is crappy, I don't comment all that well, it's inefficient, blah blah, just be happy I released it ;)

[Edit #4]
These files are outdated, I deleted them and uploaded new versions (With mob dumping) in the OSpRose Support forum.
Last edited by Drakia on Thu May 15, 2008 12:34 am, edited 1 time in total.
My favorite skill is scaring new users away.
If you haven't SEARCHED expect me to yell at you.
Image
Drakia
ospRose dev team
ospRose dev team
 
Posts: 1614
Joined: Tue Sep 18, 2007 6:53 am
Location: Nanaimo, BC, Canada

Re: NPC Table

Postby Rescudo on Mon May 12, 2008 10:29 am

Awesome work :) Now perhaps we can fix the weird Prison spawns in Evo ...
SEARCH - it's there for a reason!
User avatar
Rescudo
El Verloon Marshall
El Verloon Marshall
 
Posts: 872
Joined: Tue Mar 11, 2008 7:20 am

Re: NPC Table

Postby Drakia on Mon May 12, 2008 10:46 am

This only does NPCs as of now, not mobs. I'm going to work on mobs next though.
My favorite skill is scaring new users away.
If you haven't SEARCHED expect me to yell at you.
Image
Drakia
ospRose dev team
ospRose dev team
 
Posts: 1614
Joined: Tue Sep 18, 2007 6:53 am
Location: Nanaimo, BC, Canada

Re: NPC Table

Postby Rescudo on Mon May 12, 2008 11:16 am

As I am fully aware ^^ Thank you for doing this.
SEARCH - it's there for a reason!
User avatar
Rescudo
El Verloon Marshall
El Verloon Marshall
 
Posts: 872
Joined: Tue Mar 11, 2008 7:20 am

Re: NPC Table

Postby Blackdpd on Mon May 12, 2008 9:25 pm

can you use this for osirose ( irose ) too?
( i have the time i always have time because im waiting for everything :P )

Blackdpd `
User avatar
Blackdpd
El Verloon Marshall
El Verloon Marshall
 
Posts: 900
Joined: Sun Jan 27, 2008 10:06 pm
Location: The Netherlands

Re: NPC Table

Postby Drakia on Mon May 12, 2008 9:39 pm

Yes, it should work with all 3 clients (iRose, pre-evo, and evo). It'll give you all stock NPCs (I think it's anything that shows up on the mini map), including event ones.
My favorite skill is scaring new users away.
If you haven't SEARCHED expect me to yell at you.
Image
Drakia
ospRose dev team
ospRose dev team
 
Posts: 1614
Joined: Tue Sep 18, 2007 6:53 am
Location: Nanaimo, BC, Canada

Re: NPC Table

Postby Blackdpd on Mon May 12, 2008 9:53 pm

Nice one drakia ;)

Blackdpd `
User avatar
Blackdpd
El Verloon Marshall
El Verloon Marshall
 
Posts: 900
Joined: Sun Jan 27, 2008 10:06 pm
Location: The Netherlands

Next

Return to Submit Code

Who is online

Users browsing this forum: No registered users and 4 guests