v1310 QA Bf momument,Gatekeeper of lst rom,Chaotic Generator,bf gate sorunlarını fix

[orhankral]

İlgili npc leri silelim

DELETE FROM K_NPC WHERE sSid IN(601, 602, 603, 604, 605, 16095, 15012)
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, 16095, and 15012

Npc lerimizi ekleyelm

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)

Npc yerlerimizi ayarlayalım

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)

 

[LeqendRuthLesS]

Cevap: v1310 QA Bf momument,Gatekeeper of lst rom,Chaotic Generator,bf gate sorunları

teşekkürler.