NPC IDs

Post Reply
Zedingo
Developer
Posts: 85
Joined: Tue Aug 14, 2012 12:24 pm

NPC IDs

Post by Zedingo » Tue Jan 15, 2013 11:24 am

I THINK I got the last of the messed up ones now.

I deleted things that made no sense and had no place. They're here for quick reading:

Code: Select all

INSERT INTO `npc_list` VALUES ('16982058', '_1ef', '0', '-149.25', '-0.2', '-2.349', '1', '40', '40', '8', '0', '0', '0', '6147', 0x0200000000000000000000000000000000000000, '0', '50'); --possibly doors to alzahbi
INSERT INTO `npc_list` VALUES ('16982059', '_1e6', '0', '112.979', '-7.984', '-64.061', '1', '40', '40', '9', '0', '0', '0', '4099', 0x0200000000000000000000000000000000000000, '0', '50'); --door kokba hostel
INSERT INTO `npc_list` VALUES ('17101199', 'NPC[18f]', '0', '0', '0', '0', '0', '40', '40', '0', '0', '0', '2', '3', 0x0000320000000000000000000000000000000000, '0', '79');--this id is a soulflayer, name can't be found
INSERT INTO `npc_list` VALUES ('17101237', 'NPC[190]', '0', '0', '0', '0', '0', '40', '40', '0', '0', '0', '2', '3', 0x0000320000000000000000000000000000000000, '0', '79');--name can't be found, id isn't in polutils
INSERT INTO `npc_list` VALUES ('17101240', 'Peculiar_Plant', '0', '397.899', '-8.557', '0.000', '0', '40', '40', '0', '0', '0', '2', '3', 0x0000340000000000000000000000000000000000, '0', '79');
INSERT INTO `npc_list` VALUES ('17101241', 'Peculiar_Plant', '0', '389.040', '-17.686', '0.000', '0', '40', '40', '0', '0', '0', '2', '3', 0x0000340000000000000000000000000000000000, '0', '79');--only one entry for peculiar plant, these ids are horse prints
INSERT INTO `npc_list` VALUES ('17162296', 'Door_Zonpa-Zippa_s_Manor', '130', '143.019', '0.000', '186.456', '7', '40', '40', '0', '0', '0', '2', '27', 0x01000A0577107820693069406950E96000700000, '32', '94');--this SHOULD BE zonpa-zippa, not his door. it's not even in the right spot for a door.
INSERT INTO `npc_list` VALUES ('17162654', 'Door_Zonpa-Zippa_s_Manor', '0', '0.000', '0.000', '0.000', '0', '40', '40', '0', '0', '0', '6', '27', 0x01000A0577107820693069406950E96000700000, '32', '94');--this also should be zonpa-zippa
INSERT INTO `npc_list` VALUES ('17166834', 'Door_Zonpa-Zippa_s_Manor', '0', '0.000', '0.000', '0.000', '0', '40', '40', '0', '0', '0', '6', '27', 0x01000A0577107820693069406950E96000700000, '32', '95');--and again
INSERT INTO `npc_list` VALUES ('17404384', 'Door_Zonpa-Zippa_s_Manor', '132', '113.789', '8.531', '139.662', '0', '40', '40', '0', '0', '0', '6', '29', 0x0000A30000000000000000000000000000000000, '32', '153');-- and again

INSERT INTO `npc_list` VALUES ('17514548', 'CrystalKnight', '0', '0.000', '0.000', '0.000', '0', '40', '40', '0', '0', '0', '6', '27', 0x0000980500000000000000000000000000000000, '32', '180');
INSERT INTO `npc_list` VALUES ('17514549', 'CrystalKnight', '0', '0.000', '0.000', '0.000', '0', '40', '40', '0', '0', '0', '6', '27', 0x0000970500000000000000000000000000000000, '32', '180');
INSERT INTO `npc_list` VALUES ('17514550', 'CrystalKnight', '0', '0.000', '0.000', '0.000', '0', '40', '40', '0', '0', '0', '6', '27', 0x0000990500000000000000000000000000000000, '32', '180');
INSERT INTO `npc_list` VALUES ('17514551', 'CrystalKnight', '0', '0.000', '0.000', '0.000', '0', '40', '40', '0', '0', '0', '6', '27', 0x00009A0500000000000000000000000000000000, '32', '180');
INSERT INTO `npc_list` VALUES ('17514552', 'CrystalKnight', '0', '0.000', '0.000', '0.000', '0', '40', '40', '0', '0', '0', '6', '27', 0x0000960500000000000000000000000000000000, '32', '180');
INSERT INTO `npc_list` VALUES ('17514571', 'CrystalKnight', '0', '0.000', '0.000', '0.000', '0', '40', '40', '0', '0', '0', '6', '27', 0x0000980500000000000000000000000000000000, '32', '180');
INSERT INTO `npc_list` VALUES ('17514572', 'CrystalKnight', '0', '0.000', '0.000', '0.000', '0', '40', '40', '0', '0', '0', '6', '27', 0x0000970500000000000000000000000000000000, '32', '180');
INSERT INTO `npc_list` VALUES ('17514573', 'CrystalKnight', '0', '0.000', '0.000', '0.000', '0', '40', '40', '0', '0', '0', '6', '27', 0x0000990500000000000000000000000000000000, '32', '180');
INSERT INTO `npc_list` VALUES ('17514574', 'CrystalKnight', '0', '0.000', '0.000', '0.000', '0', '40', '40', '0', '0', '0', '6', '27', 0x00009A0500000000000000000000000000000000, '32', '180');
INSERT INTO `npc_list` VALUES ('17514575', 'CrystalKnight', '0', '0.000', '0.000', '0.000', '0', '40', '40', '0', '0', '0', '6', '27', 0x0000960500000000000000000000000000000000, '32', '180');-- i don't even know. these should be shimmering circles and ark angels

INSERT INTO `npc_list` VALUES ('17727637', 'no_name_33', '0', '0.000', '0.000', '0.000', '1', '40', '40', '0', '0', '0', '2', '27', 0x0100000300100020003000400050006000700000, '32', '232');
INSERT INTO `npc_list` VALUES ('17727638', 'no_name_34', '0', '0.000', '0.000', '0.000', '1', '40', '40', '0', '0', '0', '2', '27', 0x0100000400100020003000400050006000700000, '32', '232');--ids are for aspiring adventurer.

INSERT INTO `npc_list` VALUES ('17739898', 'Moogle', '40', '-260.440', '-12.021', '-79.538', '1', '40', '40', '0', '0', '0', '2', '3', 0x0000520000000000000000000000000000000000, '127', '235');
INSERT INTO `npc_list` VALUES ('17739901', 'Moogle', '40', '-260.440', '-12.021', '-79.538', '1', '40', '40', '0', '0', '0', '2', '3', 0x0000520000000000000000000000000000000000, '127', '235');
INSERT INTO `npc_list` VALUES ('17739903', 'Moogle', '15', '-260.029', '-12.021', '-78.386', '1', '40', '40', '0', '0', '0', '2', '3', 0x0000520000000000000000000000000000000000, '127', '235');
INSERT INTO `npc_list` VALUES ('17739905', 'Moogle', '15', '-260.029', '-12.021', '-78.386', '1', '40', '40', '0', '0', '0', '2', '3', 0x0000520000000000000000000000000000000000, '127', '235');--ids are now goblin merrymakers

INSERT INTO `npc_list` VALUES ('17760401', '2', '0', '0.000', '0.000', '0.000', '1', '40', '40', '0', '0', '0', '2', '2051', 0x0000320000000000000000000000000000000000, '0', '240');--id is now drozga

INSERT INTO `npc_list` VALUES ('17772766', 'Magian_Moogle', '0', '0.000', '0.000', '0.000', '0', '40', '40', '0', '0', '0', '6', '3', 0x0000650900000000000000000000000000000000, '0', '243');--id is blank now, not sure where to put this moogle
Attachments
npc_list.sql.patch
(115.29 KiB) Downloaded 175 times

User avatar
whasf
Site Admin
Posts: 1312
Joined: Thu Jul 19, 2012 9:11 pm

Re: NPC IDs

Post by whasf » Tue Jan 15, 2013 7:55 pm

Committed r2263

Thanks!
-- Whasf

PrBlahBlahtson
Developer
Posts: 539
Joined: Sun Jul 22, 2012 12:17 am

Re: NPC IDs

Post by PrBlahBlahtson » Wed Jan 16, 2013 12:33 am

Some of what you're killing are used to display effects and open doors, mainly the "_1ef" style names. You might want to position yourself near them and send some 8/9 animations at them before you declare them useless. ^^; I haven't tested them. Sometimes they're removed from POLUtils, but they're still necessary in the database to make those things work.

Post Reply