İlk olarak :
Sonraki :
Buraya bak [Resimleri görebilmek için üye olun veya giriş yapın.]:
- Kod:
DELETE FROM K_NPC WHERE sSid IN(601, 602, 603, 604, 605, 16095)
DELETE FROM K_NPCPOS WHERE NpcId IN(601, 602, 603, 604, 605, 16095, 15012)
-- delete if you have these rows 601, 602, 603, 604, 605, and 16095
Sonraki :
- Kod:
INSERT INTO K_NPC
VALUES(601, 'Bi-Frost Monument', 30020, 100, 0, 0, 0, 0, 154, 1, 1, 1, 0, 100, 10000, 1200, 700000, 0, 0, 15000, 642, 842, 0, 1000, 0, 0, 1000, 0, 0, 0, 30000, 30000, 30000, 30000, 30000, 30000, 30000, 100, 5, 5, 5, 0, 0, 0, 0, 0)
INSERT INTO K_NPC
VALUES(602, 'Bi-frost Gate', 30100, 100, 0, 0, 1, 0, 150, 1, 1, 1, 0, 80, 0, 0, 10000, 0, 0, 480, 375, 375, 0, 1000, 0, 0, 1000, 0, 0, 0, 250, 250, 250, 250, 250, 250, 250, 100, 5, 5, 5, 0, 0, 0, 0, 0)
INSERT INTO K_NPC
VALUES(603, 'Chaotic Generator', 30200, 100, 0, 0, 1, 0, 162, 1, 1, 1, 0, 100, 0, 0, 700000, 0, 0, 15000, 642, 842, 0, 1000, 0, 0, 1000, 0, 0, 0, 30000, 30000, 30000, 30000, 30000, 30000, 30000, 100, 5, 5, 5, 0, 0, 0, 0, 0)
INSERT INTO K_NPC
VALUES(604, 'The Gate of Greed', 604, 100, 0, 0, 1, 0, 50, 1, 1, 1, 0, 100, 0, 0, 20000, 0, 0, 600, 642, 642, 0, 1000, 0, 0, 1000, 0, 0, 0, 250, 250, 250, 250, 250, 250, 250, 100, 5, 5, 5, 0, 0, 0, 0, 0)
INSERT INTO K_NPC
VALUES(605, 'Lever', 605, 100, 0, 0, 1, 0, 55, 1, 1, 1, 0, 60, 0, 0, 10000, 0, 0, 360, 194, 194, 0, 1000, 0, 0, 1000, 0, 0, 0, 250, 250, 250, 250, 250, 250, 250, 100, 5, 5, 5, 0, 0, 0, 0, 0)
INSERT INTO K_NPC
VALUES(16095, '[Gatekeeper of Lost Room]', 11510, 100, 0, 0, 1, 1, 163, 1, 0, 1, 0, 60, 0, 0, 30000, 0, 0, 5000, 194, 194, 1000, 1500, 2, 5, 1000, 0, 0, 0, 250, 250, 250, 250, 250, 250, 250, 90, 7, 14, 25, 0, 16095, 0, 0, 1)
Buraya bak [Resimleri görebilmek için üye olun veya giriş yapın.]:
- Kod:
INSERT INTO K_NPCPOS
VALUES(201, 601, 100, 0, 0, 0, 0, 1015, 1003, 1015, 1003, 1015, 1003, 1015, 1003, 1, 200, 0, 0, NULL)
INSERT INTO K_NPCPOS
VALUES(201, 602, 100, 0, 0, 0, 0, 1020, 1010, 1020, 1010, 1020, 1010, 1020, 1010, 1, 20, 0, 0, NULL)
INSERT INTO K_NPCPOS
VALUES(21, 603, 100, 0, 0, 0, 0, 273, 453, 273, 453, 273, 453, 273, 453, 1, 10, 0, 2, NULL)
INSERT INTO K_NPCPOS
VALUES(31, 16095, 100, 0, 0, 0, 0, 884, 185, 884, 185, 884, 185, 884, 185, 1, 200, 0, 0, NULL)