Adream Eklemek Sorunsuz

-- Update SMD Name

DELETE FROM ZONE_INFO WHERE ZoneNo = 202

INSERT INTO ZONE_INFO VALUES (1,202,'freezone_1021.smd',1000,1000,0,2,0,'Ardream')



-- Update Start Position

DELETE FROM START_POSITION WHERE ZoneID = 202

INSERT INTO START_POSITION VALUES(202,848,129,183,898,5,5,0,0,0,0)



-- Add New Guard Tower

DELETE FROM K_NPC WHERE sSid = 5600

DELETE FROM K_NPC WHERE sSid = 5700



INSERT INTO K_NPC VALUES (5600,'Guard Tower',5301,100,0,0,2,0,62,1,1,1,0,90,0,0,100000,0,0,15000,497,497,0,1500,0,0,1000,300139,0,0,255,255,255,255,255,255,255,200,30,35,35,0,0,1,1,0)

INSERT INTO K_NPC VALUES (5700,'Guard Tower',5401,100,0,0,1,0,62,1,1,1,0,90,0,0,100000,0,0,15000,497,497,0,1500,0,0,1000,300139,0,0,255,255,255,255,255,255,255,200,30,35,35,0,0,1,1,0)



-- Add New Damage Skills for New Guard Tower

UPDATE MAGIC_TYPE3 SET FirstDamage = -15000,EndDamage = 0,DirectType = 1,Radius = 20,TimeDamage = 0,Duration = 0,Attribute = 1 WHERE iNum = 300139



-- Add NPC Location's

DELETE FROM K_NPCPOS WHERE ZoneId = 202

INSERT INTO K_NPCPOS VALUES (202,5600,104,0,0,0,0,190,947,190,947,190,947,190,947,1,90,0,0,'')

INSERT INTO K_NPCPOS VALUES (202,5700,104,0,0,0,0,874,114,874,114,874,114,874,114,1,90,0,0,'')

INSERT INTO K_NPCPOS VALUES (202,2801,1,0,0,0,0,578,510,590,490,510,578,590,490,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2801,1,0,0,0,0,536,514,544,506,514,536,544,506,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2801,1,0,0,0,0,504,510,512,502,510,504,512,502,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2801,1,0,0,0,0,514,538,522,534,538,514,522,534,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2801,1,0,0,0,0,530,544,538,536,544,530,538,536,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2807,1,0,0,0,0,532,510,546,506,510,532,546,506,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2807,1,0,0,0,0,484,542,488,534,542,484,488,534,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2807,1,0,0,0,0,542,504,548,496,504,542,548,496,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2807,1,0,0,0,0,530,546,536,530,546,530,536,530,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2807,1,0,0,0,0,494,530,508,520,530,494,508,520,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2807,1,0,0,0,0,506,528,516,514,528,506,516,514,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2807,1,0,0,0,0,536,530,544,516,530,536,544,516,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2807,1,0,0,0,0,558,532,576,516,532,558,576,516,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2807,1,0,0,0,0,566,516,570,504,516,566,570,504,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2807,1,0,0,0,0,498,524,500,520,524,498,500,520,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2807,1,0,0,0,0,506,554,508,544,554,506,508,544,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,22120,140,0,0,0,0,874,127,874,127,874,127,874,127,1,90,0,0,'')

INSERT INTO K_NPCPOS VALUES (202,5401,1,0,0,0,0,804,578,818,572,578,804,818,572,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,5600,104,0,0,0,0,161,894,161,894,161,894,161,894,1,90,0,0,'')

INSERT INTO K_NPCPOS VALUES (202,5600,104,0,0,0,0,149,914,149,914,149,914,149,914,1,90,0,0,'')

INSERT INTO K_NPCPOS VALUES (202,5600,104,0,0,0,0,113,883,113,883,113,883,113,883,1,90,0,0,'')

INSERT INTO K_NPCPOS VALUES (202,5600,104,0,0,0,0,222,900,222,900,222,900,222,900,1,90,0,0,'')

INSERT INTO K_NPCPOS VALUES (202,5600,104,0,0,0,0,219,913,219,913,219,913,219,913,1,90,0,0,'')

INSERT INTO K_NPCPOS VALUES (202,5600,104,0,0,0,0,138,870,138,870,138,870,138,870,1,90,0,0,'')

INSERT INTO K_NPCPOS VALUES (202,5600,104,0,0,0,0,213,872,213,872,213,872,213,872,1,90,0,0,'')

INSERT INTO K_NPCPOS VALUES (202,5600,104,0,0,0,0,193,871,193,871,193,871,193,871,1,90,0,0,'')

INSERT INTO K_NPCPOS VALUES (202,5600,104,0,0,0,0,182,873,182,873,182,873,182,873,1,90,0,0,'')

INSERT INTO K_NPCPOS VALUES (202,12120,140,0,0,0,0,179,942,179,942,179,942,179,942,1,90,0,0,'')

INSERT INTO K_NPCPOS VALUES (202,5700,104,0,0,0,0,788,82,788,82,788,82,788,82,1,90,0,0,'')

INSERT INTO K_NPCPOS VALUES (202,5700,104,0,0,0,0,799,130,799,130,799,130,799,130,1,90,0,0,'')

INSERT INTO K_NPCPOS VALUES (202,5700,104,0,0,0,0,785,115,785,115,785,115,785,115,1,90,0,0,'')

INSERT INTO K_NPCPOS VALUES (202,5700,104,0,0,0,0,803,113,803,113,803,113,803,113,1,90,0,0,'')

INSERT INTO K_NPCPOS VALUES (202,5700,104,0,0,0,0,821,150,821,150,821,150,821,150,1,90,0,0,'')

INSERT INTO K_NPCPOS VALUES (202,5700,104,0,0,0,0,831,161,831,161,831,161,831,161,1,90,0,0,'')

INSERT INTO K_NPCPOS VALUES (202,5700,104,0,0,0,0,848,154,848,154,848,154,848,154,1,90,0,0,'')

INSERT INTO K_NPCPOS VALUES (202,5700,104,0,0,0,0,871,148,871,148,871,148,871,148,1,90,0,0,'')

INSERT INTO K_NPCPOS VALUES (202,22000,140,0,0,0,0,860,114,860,114,860,114,860,114,1,90,0,0,'')

INSERT INTO K_NPCPOS VALUES (202,16096,140,0,0,0,0,200,942,200,942,200,942,200,942,1,90,0,0,'')

INSERT INTO K_NPCPOS VALUES (202,5600,104,0,0,0,0,174,904,174,904,174,904,174,904,1,90,0,0,'')

INSERT INTO K_NPCPOS VALUES (202,5600,104,0,0,0,0,159,873,159,873,159,873,159,873,1,90,0,0,'')

INSERT INTO K_NPCPOS VALUES (202,5600,104,0,0,0,0,208,934,208,934,208,934,208,934,1,90,0,0,'')

INSERT INTO K_NPCPOS VALUES (202,5600,104,0,0,0,0,173,934,173,934,173,934,173,934,1,90,0,0,'')

INSERT INTO K_NPCPOS VALUES (202,5600,104,0,0,0,0,207,889,207,889,207,889,207,889,1,90,0,0,'')

INSERT INTO K_NPCPOS VALUES (202,5600,104,0,0,0,0,128,896,128,896,128,896,128,896,1,90,0,0,'')

INSERT INTO K_NPCPOS VALUES (202,5700,104,0,0,0,0,818,96,818,96,818,96,818,96,1,90,0,0,'')

INSERT INTO K_NPCPOS VALUES (202,5700,104,0,0,0,0,847,116,847,116,847,116,847,116,1,90,0,0,'')

INSERT INTO K_NPCPOS VALUES (202,5700,104,0,0,0,0,843,131,843,131,843,131,843,131,1,90,0,0,'')

INSERT INTO K_NPCPOS VALUES (202,5700,104,0,0,0,0,841,177,841,177,841,177,841,177,1,90,0,0,'')

INSERT INTO K_NPCPOS VALUES (202,5700,104,0,0,0,0,887,152,887,152,887,152,887,152,1,90,0,0,'')

INSERT INTO K_NPCPOS VALUES (202,5700,104,0,0,0,0,817,125,817,125,817,125,817,125,1,90,0,0,'')

INSERT INTO K_NPCPOS VALUES (202,5700,104,0,0,0,0,765,110,765,110,765,110,765,110,1,90,0,0,'')

INSERT INTO K_NPCPOS VALUES (202,905,1,0,0,0,0,716,214,746,188,214,716,746,188,5,30,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,905,1,0,0,0,0,682,262,706,240,262,682,706,240,5,30,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,605,1,0,0,0,0,656,124,680,104,124,656,680,104,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,605,1,0,0,0,0,622,228,650,208,228,622,650,208,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,512,1,0,0,0,0,600,228,610,218,228,600,610,218,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,512,1,0,0,0,0,584,152,598,146,152,584,598,146,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,613,1,0,0,0,0,602,142,606,132,142,602,606,132,1,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1203,1,0,0,0,0,510,214,538,194,214,510,538,194,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1204,1,0,0,0,0,460,174,490,168,174,460,490,168,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1203,1,0,0,0,0,476,114,502,100,114,476,502,100,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1204,1,0,0,0,0,404,90,456,84,90,404,456,84,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,6920,1,0,0,0,0,464,144,484,140,144,464,484,140,1,3200,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2401,1,0,0,0,0,330,182,350,166,182,330,350,166,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1303,1,0,0,0,0,270,220,306,210,220,270,306,210,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,612,1,0,0,0,0,214,294,242,272,294,214,242,272,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2102,1,0,0,0,0,228,352,252,334,352,228,252,334,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2101,1,0,0,0,0,218,416,242,384,416,218,242,384,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,5401,1,0,0,0,0,134,514,184,494,514,134,184,494,6,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,5401,1,0,0,0,0,214,538,230,526,538,214,230,526,6,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,5401,1,0,0,0,0,208,502,230,498,502,208,230,498,6,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1104,1,0,0,0,0,146,508,162,494,508,146,162,494,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1104,1,0,0,0,0,176,532,186,518,532,176,186,518,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1104,1,0,0,0,0,224,512,238,502,512,224,238,502,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,504,1,0,0,0,0,184,514,198,498,514,184,198,498,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,504,1,0,0,0,0,170,488,192,472,488,170,192,472,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,504,1,0,0,0,0,232,492,250,480,492,232,250,480,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,6920,1,0,0,0,0,176,612,192,588,612,176,192,588,1,3200,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,5301,1,0,0,0,0,108,608,122,600,608,108,122,600,1,30,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,5301,1,0,0,0,0,128,648,154,624,648,128,154,624,1,30,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,5301,1,0,0,0,0,174,668,184,642,668,174,184,642,1,30,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,5301,1,0,0,0,0,142,620,154,584,620,142,154,584,1,30,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,5301,1,0,0,0,0,150,600,162,590,600,150,162,590,5,30,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,5301,1,0,0,0,0,172,648,182,636,648,172,182,636,5,30,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,5301,1,0,0,0,0,116,634,124,622,634,116,124,622,5,30,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,5301,1,0,0,0,0,148,648,154,634,648,148,154,634,5,30,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,905,1,0,0,0,0,110,688,142,678,688,110,142,678,7,30,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2101,1,0,0,0,0,120,704,132,694,704,120,132,694,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2101,1,0,0,0,0,74,608,86,590,608,74,86,590,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,504,1,0,0,0,0,90,602,104,596,602,90,104,596,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,613,1,0,0,0,0,84,588,98,580,588,84,98,580,1,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2102,1,0,0,0,0,138,336,162,314,336,138,162,314,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1721,1,0,0,0,0,118,286,140,252,286,118,140,252,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,6920,1,0,0,0,0,174,152,196,140,152,174,196,140,1,3200,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,6920,1,0,0,0,0,220,600,232,588,600,220,232,588,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,6920,1,0,0,0,0,924,622,934,612,622,924,934,612,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,6920,1,0,0,0,0,878,410,896,394,410,878,896,394,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,6920,1,0,0,0,0,320,862,334,854,862,320,334,854,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,6920,1,0,0,0,0,398,674,410,670,674,398,410,670,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,6920,1,0,0,0,0,420,520,430,514,520,420,430,514,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1311,1,0,0,0,0,378,596,390,586,596,378,390,586,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1311,1,0,0,0,0,96,538,108,530,538,96,108,530,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1311,1,0,0,0,0,722,864,726,860,864,722,726,860,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1311,1,0,0,0,0,852,734,860,714,734,852,860,714,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1311,1,0,0,0,0,654,498,660,484,498,654,660,484,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1311,1,0,0,0,0,398,494,408,492,494,398,408,492,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,907,1,0,0,0,0,506,626,520,618,626,506,520,618,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,908,1,0,0,0,0,654,428,662,420,428,654,662,420,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,907,1,0,0,0,0,456,390,464,384,390,456,464,384,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,607,1,0,0,0,0,410,618,416,614,618,410,416,614,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,607,1,0,0,0,0,232,230,240,224,230,232,240,224,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,607,1,0,0,0,0,678,478,686,468,478,678,686,468,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,608,1,0,0,0,0,568,444,580,440,444,568,580,440,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,608,1,0,0,0,0,472,94,478,88,94,472,478,88,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,608,1,0,0,0,0,182,104,196,100,104,182,196,100,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,608,1,0,0,0,0,590,132,596,124,132,590,596,124,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,607,1,0,0,0,0,868,756,876,736,756,868,876,736,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,608,1,0,0,0,0,946,766,952,758,766,946,952,758,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,506,1,0,0,0,0,160,524,170,518,524,160,170,518,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,506,1,0,0,0,0,790,506,802,502,506,790,802,502,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,507,1,0,0,0,0,562,608,568,602,608,562,568,602,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,507,1,0,0,0,0,292,248,302,238,248,292,302,238,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,508,1,0,0,0,0,236,370,246,368,370,236,246,368,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,508,1,0,0,0,0,376,112,382,104,112,376,382,104,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1306,1,0,0,0,0,534,454,544,448,454,534,544,448,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1306,1,0,0,0,0,524,714,534,706,714,524,534,706,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1306,1,0,0,0,0,164,570,170,560,570,164,170,560,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1306,1,0,0,0,0,182,174,186,162,174,182,186,162,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1306,1,0,0,0,0,810,428,820,420,428,810,820,420,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1400,1,0,0,0,0,866,576,878,562,576,866,878,562,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1400,1,0,0,0,0,444,462,456,456,462,444,456,456,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1205,1,0,0,0,0,234,308,246,296,308,234,246,296,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1205,1,0,0,0,0,806,834,814,828,834,806,814,828,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1205,1,0,0,0,0,722,362,730,352,362,722,730,352,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1206,1,0,0,0,0,624,582,636,578,582,624,636,578,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1206,1,0,0,0,0,628,208,632,202,208,628,632,202,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1207,1,0,0,0,0,388,660,392,652,660,388,392,652,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1207,1,0,0,0,0,130,162,138,152,162,130,138,152,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1206,1,0,0,0,0,410,466,422,452,466,410,422,452,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1206,1,0,0,0,0,580,888,604,872,888,580,604,872,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1207,1,0,0,0,0,184,278,192,264,278,184,192,264,1,32000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,905,1,0,0,0,0,792,350,812,336,350,792,812,336,5,30,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,905,1,0,0,0,0,812,336,826,318,336,812,826,318,5,30,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,905,1,0,0,0,0,860,340,876,322,340,860,876,322,7,30,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2101,1,0,0,0,0,904,402,914,390,402,904,914,390,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2101,1,0,0,0,0,922,438,940,426,438,922,940,426,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,504,1,0,0,0,0,826,388,874,366,388,826,874,366,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,504,1,0,0,0,0,930,488,940,474,488,930,940,474,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1104,1,0,0,0,0,872,512,906,496,512,872,906,496,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,5301,1,0,0,0,0,922,604,944,580,604,922,944,580,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,5301,1,0,0,0,0,922,570,938,560,570,922,938,560,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1104,1,0,0,0,0,904,566,924,550,566,904,924,550,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,5301,1,0,0,0,0,942,650,956,628,650,942,956,628,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2102,1,0,0,0,0,932,638,946,626,638,932,946,626,3,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2101,1,0,0,0,0,940,698,948,686,698,940,948,686,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,612,1,0,0,0,0,938,766,948,748,766,938,948,748,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1721,1,0,0,0,0,942,852,964,834,852,942,964,834,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2401,1,0,0,0,0,850,858,906,828,858,850,906,828,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1204,1,0,0,0,0,714,910,732,900,910,714,732,900,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1204,1,0,0,0,0,650,906,656,904,906,650,656,904,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,605,1,0,0,0,0,350,918,364,904,918,350,364,904,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,905,1,0,0,0,0,176,796,202,776,796,176,202,776,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,905,1,0,0,0,0,190,748,194,730,748,190,194,730,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,905,1,0,0,0,0,244,780,264,772,780,244,264,772,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,404,1,0,0,0,0,356,866,368,850,866,356,368,850,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,512,1,0,0,0,0,398,872,404,862,872,398,404,862,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,512,1,0,0,0,0,434,882,442,878,882,434,442,878,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1203,1,0,0,0,0,520,892,530,882,892,520,530,882,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1203,1,0,0,0,0,546,888,550,878,888,546,550,878,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1204,1,0,0,0,0,600,878,614,872,878,600,614,872,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1204,1,0,0,0,0,646,866,656,852,866,646,656,852,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1303,1,0,0,0,0,814,756,828,744,756,814,828,744,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2001,1,0,0,0,0,856,704,860,698,704,856,860,698,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,613,1,0,0,0,0,892,706,896,696,706,892,896,696,1,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2102,1,0,0,0,0,834,662,854,658,662,834,854,658,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,5401,1,0,0,0,0,760,574,774,564,574,760,774,564,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,5401,1,0,0,0,0,860,600,868,592,600,860,868,592,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2201,1,0,0,0,0,630,520,638,512,520,630,638,512,6,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2202,1,0,0,0,0,610,472,616,468,472,610,616,468,1,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2002,1,0,0,0,0,622,472,628,470,472,622,628,470,1,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2801,1,0,0,0,0,588,540,594,494,540,588,594,494,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2804,1,0,0,0,0,588,540,594,494,540,588,594,494,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2807,1,0,0,0,0,584,520,590,506,520,584,590,506,3,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2807,1,0,0,0,0,552,510,558,502,510,552,558,502,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2804,1,0,0,0,0,556,538,560,526,538,556,560,526,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2813,1,0,0,0,0,546,534,556,530,534,546,556,530,1,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2813,1,0,0,0,0,520,546,526,542,546,520,526,542,1,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2814,1,0,0,0,0,510,514,512,510,514,510,512,510,1,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2817,1,0,0,0,0,522,526,530,522,526,522,530,522,1,18000,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2807,1,0,0,0,0,486,526,494,524,526,486,494,524,1,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2801,1,0,0,0,0,484,514,492,506,514,484,492,506,4,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2801,1,0,0,0,0,492,550,498,546,550,492,498,546,2,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2804,1,0,0,0,0,500,534,508,530,534,500,508,530,3,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2804,1,0,0,0,0,500,534,508,530,534,500,508,530,3,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2807,1,0,0,0,0,520,504,530,502,504,520,530,502,3,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2807,1,0,0,0,0,456,550,458,508,550,456,458,508,2,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2801,1,0,0,0,0,452,524,460,514,524,452,460,514,4,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2804,1,0,0,0,0,452,538,462,530,538,452,462,530,3,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2401,1,0,0,0,0,430,518,434,508,518,430,434,508,2,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2401,1,0,0,0,0,424,554,436,546,554,424,436,546,1,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1722,1,0,0,0,0,432,594,452,582,594,432,452,582,2,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2102,1,0,0,0,0,442,580,446,574,580,442,446,574,1,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2401,1,0,0,0,0,410,598,424,584,598,410,424,584,3,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2422,1,0,0,0,0,436,694,452,684,694,436,452,684,2,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,3021,1,0,0,0,0,444,690,458,680,690,444,458,680,2,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2202,1,0,0,0,0,434,706,442,702,706,434,442,702,1,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2001,1,0,0,0,0,518,652,540,626,652,518,540,626,7,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2402,1,0,0,0,0,620,414,640,406,414,620,640,406,2,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,2102,1,0,0,0,0,568,430,578,422,430,568,578,422,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,1721,1,0,0,0,0,468,428,484,406,428,468,484,406,5,300,0,0,NULL)

INSERT INTO K_NPCPOS VALUES (202,3021,1,0,0,0,0,480,414,500,406,414,480,500,406,2,300,0,0,NULL)



-- Repair Monsters

DECLARE @sSid int



DECLARE RM_CX CURSOR FOR

SELECT NpcID FROM K_NPCPOS WHERE ZoneID = 202 AND NpcID <> 5600 AND NpcID <> 5700



OPEN RM_CX



FETCH NEXT FROM RM_CX INTO @sSid

WHILE @@FETCH_STATUS = 0

BEGIN



    IF @sSid = 22000

        UPDATE K_NPC SET byActType = 0 WHERE sSid = @sSid

    ELSE IF @sSid = 22120

        UPDATE K_NPC SET byActType = 0 WHERE sSid = @sSid

    ELSE IF @sSid = 12120

        UPDATE K_NPC SET byActType = 0 WHERE sSid = @sSid

    ELSE IF @sSid = 16096

        UPDATE K_NPC SET byActType = 0 WHERE sSid = @sSid

    ELSE

        UPDATE K_MONSTER SET byActType = 7,byType = 12 WHERE sSid = @sSid



FETCH NEXT FROM RM_CX INTO @sSid

END



CLOSE RM_CX

DEALLOCATE RM_CX