[Paylaşım] Ardream Map,Npc,Guard Tower,Monster - PvP-Kenti

LinkinPark · 01-08-2010, 22:59

1st. Query ( Updating Zone Info )

Kod:

DELETE FROM ZONE_INFO WHERE ZoneNo = 202 
INSERT INTO ZONE_INFO VALUES (1,202,'freezone_1021.smd',1000,1000,0,2,202,'Ardream')

2nd. Query ( Start Position )

Kod:

DELETE FROM START_POSITION WHERE ZoneID = 202 
INSERT INTO START_POSITION VALUES(202,848,129,183,898,5,5,0,0,0,0)

3rd. Query ( Guard Towers )

Kod:

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,25 5,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,25 5,255,255,255,255,255,200,30,35,35,0,0,1,1,0)

4th. Query ( Guard Towers Damage And Skill )

Kod:

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

5th. Query ( NPC Positioning )

Kod:

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,49 0,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2801,1,0,0,0,0,536,514,544,506,514,536,544,50 6,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2801,1,0,0,0,0,504,510,512,502,510,504,512,50 2,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2801,1,0,0,0,0,514,538,522,534,538,514,522,53 4,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2801,1,0,0,0,0,530,544,538,536,544,530,538,53 6,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2807,1,0,0,0,0,532,510,546,506,510,532,546,50 6,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2807,1,0,0,0,0,484,542,488,534,542,484,488,53 4,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2807,1,0,0,0,0,542,504,548,496,504,542,548,49 6,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2807,1,0,0,0,0,530,546,536,530,546,530,536,53 0,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2807,1,0,0,0,0,494,530,508,520,530,494,508,52 0,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2807,1,0,0,0,0,506,528,516,514,528,506,516,51 4,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2807,1,0,0,0,0,536,530,544,516,530,536,544,51 6,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2807,1,0,0,0,0,558,532,576,516,532,558,576,51 6,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2807,1,0,0,0,0,566,516,570,504,516,566,570,50 4,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2807,1,0,0,0,0,498,524,500,520,524,498,500,52 0,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2807,1,0,0,0,0,506,554,508,544,554,506,508,54 4,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,57 2,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,19 4,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,1204,1,0,0,0,0,460,174,490,168,174,460,490,16 8,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,1203,1,0,0,0,0,476,114,502,100,114,476,502,10 0,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,14 0,1,3200,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2401,1,0,0,0,0,330,182,350,166,182,330,350,16 6,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,1303,1,0,0,0,0,270,220,306,210,220,270,306,21 0,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,33 4,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2101,1,0,0,0,0,218,416,242,384,416,218,242,38 4,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,5401,1,0,0,0,0,134,514,184,494,514,134,184,49 4,6,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,5401,1,0,0,0,0,214,538,230,526,538,214,230,52 6,6,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,5401,1,0,0,0,0,208,502,230,498,502,208,230,49 8,6,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,1104,1,0,0,0,0,146,508,162,494,508,146,162,49 4,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,1104,1,0,0,0,0,176,532,186,518,532,176,186,51 8,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,1104,1,0,0,0,0,224,512,238,502,512,224,238,50 2,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,58 8,1,3200,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,5301,1,0,0,0,0,108,608,122,600,608,108,122,60 0,1,30,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,5301,1,0,0,0,0,128,648,154,624,648,128,154,62 4,1,30,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,5301,1,0,0,0,0,174,668,184,642,668,174,184,64 2,1,30,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,5301,1,0,0,0,0,142,620,154,584,620,142,154,58 4,1,30,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,5301,1,0,0,0,0,150,600,162,590,600,150,162,59 0,5,30,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,5301,1,0,0,0,0,172,648,182,636,648,172,182,63 6,5,30,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,5301,1,0,0,0,0,116,634,124,622,634,116,124,62 2,5,30,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,5301,1,0,0,0,0,148,648,154,634,648,148,154,63 4,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,69 4,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,3 00,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2102,1,0,0,0,0,138,336,162,314,336,138,162,31 4,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,1721,1,0,0,0,0,118,286,140,252,286,118,140,25 2,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,6920,1,0,0,0,0,174,152,196,140,152,174,196,14 0,1,3200,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,6920,1,0,0,0,0,220,600,232,588,600,220,232,58 8,1,32000,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,6920,1,0,0,0,0,924,622,934,612,622,924,934,61 2,1,32000,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,6920,1,0,0,0,0,878,410,896,394,410,878,896,39 4,1,32000,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,6920,1,0,0,0,0,320,862,334,854,862,320,334,85 4,1,32000,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,6920,1,0,0,0,0,398,674,410,670,674,398,410,67 0,1,32000,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,6920,1,0,0,0,0,420,520,430,514,520,420,430,51 4,1,32000,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,1311,1,0,0,0,0,378,596,390,586,596,378,390,58 6,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,86 0,1,32000,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,1311,1,0,0,0,0,852,734,860,714,734,852,860,71 4,1,32000,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,1311,1,0,0,0,0,654,498,660,484,498,654,660,48 4,1,32000,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,1311,1,0,0,0,0,398,494,408,492,494,398,408,49 2,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,3 2000,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,44 8,1,32000,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,1306,1,0,0,0,0,524,714,534,706,714,524,534,70 6,1,32000,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,1306,1,0,0,0,0,164,570,170,560,570,164,170,56 0,1,32000,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,1306,1,0,0,0,0,182,174,186,162,174,182,186,16 2,1,32000,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,1306,1,0,0,0,0,810,428,820,420,428,810,820,42 0,1,32000,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,1400,1,0,0,0,0,866,576,878,562,576,866,878,56 2,1,32000,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,1400,1,0,0,0,0,444,462,456,456,462,444,456,45 6,1,32000,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,1205,1,0,0,0,0,234,308,246,296,308,234,246,29 6,1,32000,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,1205,1,0,0,0,0,806,834,814,828,834,806,814,82 8,1,32000,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,1205,1,0,0,0,0,722,362,730,352,362,722,730,35 2,1,32000,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,1206,1,0,0,0,0,624,582,636,578,582,624,636,57 8,1,32000,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,1206,1,0,0,0,0,628,208,632,202,208,628,632,20 2,1,32000,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,1207,1,0,0,0,0,388,660,392,652,660,388,392,65 2,1,32000,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,1207,1,0,0,0,0,130,162,138,152,162,130,138,15 2,1,32000,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,1206,1,0,0,0,0,410,466,422,452,466,410,422,45 2,1,32000,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,1206,1,0,0,0,0,580,888,604,872,888,580,604,87 2,1,32000,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,1207,1,0,0,0,0,184,278,192,264,278,184,192,26 4,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,39 0,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2101,1,0,0,0,0,922,438,940,426,438,922,940,42 6,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,49 6,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,5301,1,0,0,0,0,922,604,944,580,604,922,944,58 0,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,5301,1,0,0,0,0,922,570,938,560,570,922,938,56 0,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,1104,1,0,0,0,0,904,566,924,550,566,904,924,55 0,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,5301,1,0,0,0,0,942,650,956,628,650,942,956,62 8,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2102,1,0,0,0,0,932,638,946,626,638,932,946,62 6,3,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2101,1,0,0,0,0,940,698,948,686,698,940,948,68 6,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,83 4,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2401,1,0,0,0,0,850,858,906,828,858,850,906,82 8,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,1204,1,0,0,0,0,714,910,732,900,910,714,732,90 0,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,1204,1,0,0,0,0,650,906,656,904,906,650,656,90 4,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,88 2,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,1203,1,0,0,0,0,546,888,550,878,888,546,550,87 8,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,1204,1,0,0,0,0,600,878,614,872,878,600,614,87 2,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,1204,1,0,0,0,0,646,866,656,852,866,646,656,85 2,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,1303,1,0,0,0,0,814,756,828,744,756,814,828,74 4,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2001,1,0,0,0,0,856,704,860,698,704,856,860,69 8,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,65 8,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,5401,1,0,0,0,0,760,574,774,564,574,760,774,56 4,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,5401,1,0,0,0,0,860,600,868,592,600,860,868,59 2,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2201,1,0,0,0,0,630,520,638,512,520,630,638,51 2,6,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2202,1,0,0,0,0,610,472,616,468,472,610,616,46 8,1,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2002,1,0,0,0,0,622,472,628,470,472,622,628,47 0,1,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2801,1,0,0,0,0,588,540,594,494,540,588,594,49 4,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2804,1,0,0,0,0,588,540,594,494,540,588,594,49 4,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2807,1,0,0,0,0,584,520,590,506,520,584,590,50 6,3,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2807,1,0,0,0,0,552,510,558,502,510,552,558,50 2,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2804,1,0,0,0,0,556,538,560,526,538,556,560,52 6,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2813,1,0,0,0,0,546,534,556,530,534,546,556,53 0,1,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2813,1,0,0,0,0,520,546,526,542,546,520,526,54 2,1,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2814,1,0,0,0,0,510,514,512,510,514,510,512,51 0,1,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2817,1,0,0,0,0,522,526,530,522,526,522,530,52 2,1,18000,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2807,1,0,0,0,0,486,526,494,524,526,486,494,52 4,1,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2801,1,0,0,0,0,484,514,492,506,514,484,492,50 6,4,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2801,1,0,0,0,0,492,550,498,546,550,492,498,54 6,2,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2804,1,0,0,0,0,500,534,508,530,534,500,508,53 0,3,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2804,1,0,0,0,0,500,534,508,530,534,500,508,53 0,3,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2807,1,0,0,0,0,520,504,530,502,504,520,530,50 2,3,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2807,1,0,0,0,0,456,550,458,508,550,456,458,50 8,2,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2801,1,0,0,0,0,452,524,460,514,524,452,460,51 4,4,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2804,1,0,0,0,0,452,538,462,530,538,452,462,53 0,3,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2401,1,0,0,0,0,430,518,434,508,518,430,434,50 8,2,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2401,1,0,0,0,0,424,554,436,546,554,424,436,54 6,1,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,1722,1,0,0,0,0,432,594,452,582,594,432,452,58 2,2,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2102,1,0,0,0,0,442,580,446,574,580,442,446,57 4,1,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2401,1,0,0,0,0,410,598,424,584,598,410,424,58 4,3,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2422,1,0,0,0,0,436,694,452,684,694,436,452,68 4,2,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,3021,1,0,0,0,0,444,690,458,680,690,444,458,68 0,2,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2202,1,0,0,0,0,434,706,442,702,706,434,442,70 2,1,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2001,1,0,0,0,0,518,652,540,626,652,518,540,62 6,7,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2402,1,0,0,0,0,620,414,640,406,414,620,640,40 6,2,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,2102,1,0,0,0,0,568,430,578,422,430,568,578,42 2,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,1721,1,0,0,0,0,468,428,484,406,428,468,484,40 6,5,300,0,0,NULL)
INSERT INTO K_NPCPOS VALUES (202,3021,1,0,0,0,0,480,414,500,406,414,480,500,40 6,2,300,0,0,NULL)

6th. Query ( Repair Monsters )

Kod:

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

~~EveryBodyFooL~~ · 01-08-2010, 23:20

Onaylanmıştır.

~~-b0Ni~~ · 08-08-2010, 12:19

Teşekkürler İşe Yarar Paylaşım

Heavily · 08-08-2010, 22:14

Teşekkürler

LinkinPark · 09-08-2010, 03:10

Yorumlar İçin Teşekkürler

~~-b0Ni~~ · 12-08-2010, 18:24

Bunları Yaptığımda Human Inn Hostes Karusların Townunda Oluyor.
Ne İş ?

~~ByHasan_01~~ · 13-08-2010, 08:56

teşekkürler

Dombra · 30-08-2010, 23:28

teşekkürler.

TireSome · 03-09-2010, 02:14

iyide bu x-skip te yokmuydu

ceronimo004 · 11-09-2010, 08:18

Teşekkürler.

01-08-2010, 23:20	#2 (permalink)
~~EveryBodyFooL~~ Banned Üyelik tarihi: Nov 2009 Bulunduğu Yer: C:\WINDOWS\system32 Yaş: 16 Mesajlar: 863 Oyun Parası: $212374 Teşekkür : 125 133 Konusuna 1.618 teşekkür almış P-K Puan: 0 Tecrübe Puanı: 13	Cevap: [Paylaşım] Ardream Map,Npc,Guard Tower,Monster Onaylanmıştır. Notice: This Ad only show to guest, please register now to disappear !

08-08-2010, 12:19	#3 (permalink)
~~-b0Ni~~ Banned Üyelik tarihi: May 2010 Bulunduğu Yer: Manisa Mesajlar: 1.743 Oyun Parası: $77009 Teşekkür : 244 316 Konusuna 2.442 teşekkür almış P-K Puan: 0 Tecrübe Puanı: 13	Cevap: [Paylaşım] Ardream Map,Npc,Guard Tower,Monster Teşekkürler İşe Yarar Paylaşım Notice: This Ad only show to guest, please register now to disappear !

08-08-2010, 22:14	#4 (permalink)
Heavily [ - What is life a game? - ] Üyelik tarihi: Feb 2010 Bulunduğu Yer: Adana Mesajlar: 953 Oyun Parası: $16357 Teşekkür : 73 68 Konusuna 851 teşekkür almış P-K Puan: 15 Tecrübe Puanı: 12	Cevap: [Paylaşım] Ardream Map,Npc,Guard Tower,Monster Teşekkürler Notice: This Ad only show to guest, please register now to disappear ! __________________ İletişim İÇİN : Heavily@Turk.TC

09-08-2010, 03:10	#5 (permalink)
LinkinPark ۞ Ʒмяé ॐ Üyelik tarihi: Apr 2010 Bulunduğu Yer: Why Mesajlar: 1.552 Oyun Parası: $52234 Teşekkür : 68 431 Konusuna 2.046 teşekkür almış P-K Puan: 430 Tecrübe Puanı: 13	Cevap: [Paylaşım] Ardream Map,Npc,Guard Tower,Monster Yorumlar İçin Teşekkürler Notice: This Ad only show to guest, please register now to disappear ! __________________ Ölen Linklerin Yenilenmesi için Bildiriniz [Üye olmadan linki göremezsiniz.. Üye olmak için tıklayınız...] [Üye olmadan linki göremezsiniz.. Üye olmak için tıklayınız...]

12-08-2010, 18:24	#6 (permalink)
~~-b0Ni~~ Banned Üyelik tarihi: May 2010 Bulunduğu Yer: Manisa Mesajlar: 1.743 Oyun Parası: $77009 Teşekkür : 244 316 Konusuna 2.442 teşekkür almış P-K Puan: 0 Tecrübe Puanı: 13	Cevap: [Paylaşım] Ardream Map,Npc,Guard Tower,Monster Bunları Yaptığımda Human Inn Hostes Karusların Townunda Oluyor. Ne İş ? Notice: This Ad only show to guest, please register now to disappear !

13-08-2010, 08:56	#7 (permalink)
~~ByHasan_01~~ Banned Üyelik tarihi: Dec 2009 Yaş: 31 Mesajlar: 68 Oyun Parası: $1500 Teşekkür : 75 9 Konusuna 321 teşekkür almış P-K Puan: 0 Tecrübe Puanı: 13	Cevap: [Paylaşım] Ardream Map,Npc,Guard Tower,Monster teşekkürler Notice: This Ad only show to guest, please register now to disappear !

30-08-2010, 23:28	#8 (permalink)
Dombra Yeni Üye Üyelik tarihi: Jul 2010 Yaş: 27 Mesajlar: 12 Oyun Parası: $500 Teşekkür : 8 0 Konusuna 0 teşekkür almış P-K Puan: 0 Tecrübe Puanı: 12	Cevap: [Paylaşım] Ardream Map,Npc,Guard Tower,Monster teşekkürler. Notice: This Ad only show to guest, please register now to disappear !

03-09-2010, 02:14	#9 (permalink)
TireSome Bağımlı Üye Üyelik tarihi: Feb 2010 Yaş: 21 Mesajlar: 432 Oyun Parası: $18565 Teşekkür : 89 38 Konusuna 550 teşekkür almış P-K Puan: 5 Tecrübe Puanı: 13	Cevap: [Paylaşım] Ardream Map,Npc,Guard Tower,Monster iyide bu x-skip te yokmuydu Notice: This Ad only show to guest, please register now to disappear !

11-09-2010, 08:18	#10 (permalink)
ceronimo004 Gelişmiş Üye Üyelik tarihi: May 2010 Yaş: 26 Mesajlar: 58 Oyun Parası: $500 Teşekkür : 30 0 Konusuna 0 teşekkür almış P-K Puan: 0 Tecrübe Puanı: 12	Cevap: [Paylaşım] Ardream Map,Npc,Guard Tower,Monster Teşekkürler. Notice: This Ad only show to guest, please register now to disappear !

Seçenekler
Yazdırılabilir şekli göster Sayfayı E-Mail olarak gönder
Stil
Normal Hybrid-Şeklinde gösterime geç Ağaç şeklinde gösterime geç


		468x60