-- neronlineworld.com
--- NPCLERİ TEMİZLEYELİM
DELETE FROM K_NPC WHERE SSiD=16082
DELETE FROM K_NPC WHERE SSiD=16081
DELETE FROM K_NPC WHERE SSiD=16083
DELETE FROM K_NPCPOS WHERE npcid=16082
DELETE FROM K_NPCPOS WHERE npcid=16081
DELETE FROM K_NPCPOS WHERE npcid=16083
--- NPCLERİ EKLEYELİM
INSERT INTO K_NPC VALUES(16082,'[Specials Event] 2',2040,120,0,0,2,7,130,1,1,1,0,50,100,0,30000,0,0,5000,130,130,1000,1500,2,5,32000,0,0,0,250,250,250,250,250,250,250,90,7,14,25,0,16082,0,0,1)
INSERT INTO K_NPC VALUES(16081,'[Specials Event] 3',2060,120,0,0,2,7,131,1,1,1,0,50,100,0,30000,0,0,5000,130,130,1000,1500,2,5,32000,0,0,0,250,250,250,250,250,250,250,90,7,14,25,0,16081,0,0,1)
INSERT INTO K_NPC VALUES(16083,'[Specials Event] 1',11100,120,0,0,2,7,129,1,1,1,0,50,100,0,30000,0,0,5000,130,130,1000,1500,2,5,32000,0,0,0,250,250,250,250,250,250,250,90,7,14,25,0,16083,0,0,1)
INSERT INTO K_NPCPOS VALUES(21,16082,100,0,0,0,0,349,384,349,384,349,384,349,384,1,3600,0,0,'NULL')
INSERT INTO K_NPCPOS VALUES(21,16081,100,0,0,0,0,356,383,356,383,356,383,356,383,1,3600,0,0,'04190477041904770419047704190477')
INSERT INTO K_NPCPOS VALUES(21,16083,100,0,0,0,0,357,391,357,391,357,391,357,391,1,3600,111,0,'NULL')
--- Speacials event saatleri düzenleyelim
update MONSTER_CHALLENGE set bStartTime1 = 11 where sIndex = 0
update MONSTER_CHALLENGE set bStartTime1 = 17 where sIndex = 1
update MONSTER_CHALLENGE set bStartTime1 = 19 where sIndex = 2
update MONSTER_CHALLENGE set bStartTime2 = 2 where sIndex = 0
update MONSTER_CHALLENGE set bStartTime2 = 55 where sIndex = 1
update MONSTER_CHALLENGE set bStartTime2 = 55 where sIndex = 2
update MONSTER_CHALLENGE set bStartTime3 = 55 where sIndex = 0
update MONSTER_CHALLENGE set bStartTime3 = 55 where sIndex = 1
update MONSTER_CHALLENGE set bStartTime3 = 55 where sIndex = 2
--- Bütün minimum giris levelini 50 yapalım
update MONSTER_CHALLENGE set bLevelMin = 50 where sIndex = 0
update MONSTER_CHALLENGE set bLevelMin = 50 where sIndex = 1
update MONSTER_CHALLENGE set bLevelMin = 50 where sIndex = 2
--- Bütün maximum giris levelini 83 yapalım
update MONSTER_CHALLENGE set bLevelMax = 83 where sIndex = 0
update MONSTER_CHALLENGE set bLevelMax = 83 where sIndex = 1
update MONSTER_CHALLENGE set bLevelMax = 83 where SIndex = 2
--- Duyuru bölümünü ayarlayalım
update SERVER_RESOURCE set strResource = 'Specials Events, Saat : %d -da %d~%d Leveller Için Baslayacak.' where strName = 'IDS_MONSTER_CHALLENGE_ANNOUNCEMENT'
update SERVER_RESOURCE set strResource = 'Specials Events Basladi.' where strName = 'IDS_MONSTER_CHALLENGE_OPEN'
update SERVER_RESOURCE set strResource = 'Canavarlar Geliyor. Basarilar' where strName = 'IDS_MONSTER_CHALLENGE_START'
update SERVER_RESOURCE set strResource = 'Canavarlari Yok Ettiniz. Kutuyu Kazandin.' where strName = 'IDS_MONSTER_CHALLENGE_VICTORY'
update SERVER_RESOURCE set strResource = 'Specials Events Sona Erdi, Oyuncular Otomatik Olarak Disari Isinlanacaktir.' where strName = 'IDS_MONSTER_CHALLENGE_CLOSE'
--- Zones Ayarını yapalım
update ZONE_INFO set bz = 'Specials Events Area' where ZoneNO = 55
--- FORGETTEN TEMPLE YARATIKLARINA NP EKLEYELİM
update k_monster set iloyalty =10 where ssid=2903
update k_monster set iloyalty =10 where ssid=1673
update k_monster set iloyalty =10 where ssid=1690
update k_monster set iloyalty =10 where ssid=1210
update k_monster set iloyalty =10 where ssid=1111
update k_monster set iloyalty =10 where ssid=1204
update k_monster set iloyalty =10 where ssid=4301
update k_monster set iloyalty =10 where ssid=1113
update k_monster set iloyalty =10 where ssid=1304
update k_monster set iloyalty =10 where ssid=1743
update k_monster set iloyalty =10 where ssid=2021
update k_monster set iloyalty =10 where ssid=1692
update k_monster set iloyalty =10 where ssid=1114
update k_monster set iloyalty =10 where ssid=1693
update k_monster set iloyalty =10 where ssid=2071
update k_monster set iloyalty =10 where ssid=1309
update k_monster set iloyalty =10 where ssid=2223
update k_monster set iloyalty =10 where ssid=1731
update k_monster set iloyalty =10 where ssid=2022
update k_monster set iloyalty =10 where ssid=512
update k_monster set iloyalty =10 where ssid=1691
update k_monster set iloyalty =10 where ssid=1303
update k_monster set iloyalty =10 where ssid=2121
update k_monster set iloyalty =10 where ssid=2952
update k_monster set iloyalty =10 where ssid=2221
update k_monster set iloyalty =10 where ssid=1201
update k_monster set iloyalty =10 where ssid=1114
update k_monster set iloyalty =10 where ssid=2023
update k_monster set iloyalty =10 where ssid=2122
update k_monster set iloyalty =10 where ssid=4501
update k_monster set iloyalty =10 where ssid=2908
update k_monster set iloyalty =10 where ssid=1694
update k_monster set iloyalty =10 where ssid=1200
update k_monster set iloyalty =10 where ssid=3671
update k_monster set iloyalty =10 where ssid=2121
update k_monster set iloyalty =10 where ssid=2021
update k_monster set iloyalty =10 where ssid=2421
update k_monster set iloyalty =10 where ssid=2222
update k_monster set iloyalty =10 where ssid=4701
update k_monster set iloyalty =10 where ssid=403
update k_monster set iloyalty =10 where ssid=2423
update k_monster set iloyalty =10 where ssid=2904
update k_monster set iloyalty =10 where ssid=1741
update k_monster set iloyalty =10 where ssid=4301
update k_monster set iloyalty =10 where ssid=1823
update k_monster set iloyalty =10 where ssid=612
update k_monster set iloyalty =10 where ssid=2353
update k_monster set iloyalty =10 where ssid=2601
update k_monster set iloyalty =10 where ssid=2221
update k_monster set iloyalty =10 where ssid=2421
update k_monster set iloyalty =10 where ssid=1362
update k_monster set iloyalty =10 where ssid=3771
update k_monster set iloyalty =10 where ssid=2422
update k_monster set iloyalty =10 where ssid=1742
update k_monster set iloyalty =10 where ssid=3021
update k_monster set iloyalty =10 where ssid=3891
update k_monster set iloyalty =10 where ssid=1150
update k_monster set iloyalty =10 where ssid=3451
update k_monster set iloyalty =10 where ssid=1111
update k_monster set iloyalty =10 where ssid=3571
update k_monster set iloyalty =10 where ssid=1114
update k_monster set iloyalty =10 where ssid=1307
update k_monster set iloyalty =10 where ssid=1210
update k_monster set iloyalty =10 where ssid=1671
update k_monster set iloyalty =10 where ssid=2121
update k_monster set iloyalty =10 where ssid=1111
update k_monster set iloyalty =10 where ssid=2221
update k_monster set iloyalty =10 where ssid=4501
update k_monster set iloyalty =10 where ssid=2021
update k_monster set iloyalty =10 where ssid=2421
update k_monster set iloyalty =10 where ssid=655
update k_monster set iloyalty =10 where ssid=1004
update k_monster set iloyalty =10 where ssid=1310
update k_monster set iloyalty =10 where ssid=1690
update k_monster set iloyalty =10 where ssid=2223
update k_monster set iloyalty =10 where ssid=2952
update k_monster set iloyalty =10 where ssid=350
update k_monster set iloyalty =10 where ssid=2122
update k_monster set iloyalty =10 where ssid=1741
update k_monster set iloyalty =10 where ssid=1110
update k_monster set iloyalty =10 where ssid=555
update k_monster set iloyalty =10 where ssid=1742
update k_monster set iloyalty =10 where ssid=2904
update k_monster set iloyalty =10 where ssid=1150
update k_monster set iloyalty =10 where ssid=1731
update k_monster set iloyalty =10 where ssid=2221
update k_monster set iloyalty =10 where ssid=2023
update k_monster set iloyalty =10 where ssid=2421
update k_monster set iloyalty =10 where ssid=2908
update k_monster set iloyalty =10 where ssid=1114
update k_monster set iloyalty =10 where ssid=253
update k_monster set iloyalty =10 where ssid=1693
update k_monster set iloyalty =10 where ssid=806
update k_monster set iloyalty =10 where ssid=2902
update k_monster set iloyalty =10 where ssid=1694
update k_monster set iloyalty =10 where ssid=2222
update k_monster set iloyalty =10 where ssid=2901
update k_monster set iloyalty =10 where ssid=1113
update k_monster set iloyalty =10 where ssid=1742
update k_monster set iloyalty =10 where ssid=2021
update k_monster set iloyalty =10 where ssid=1310
update k_monster set iloyalty =10 where ssid=4351
update k_monster set iloyalty =10 where ssid=3771
update k_monster set iloyalty =10 where ssid=2422
update k_monster set iloyalty =10 where ssid=1362
update k_monster set iloyalty =10 where ssid=2022
update k_monster set iloyalty =10 where ssid=1743
update k_monster set iloyalty =10 where ssid=1671
update k_monster set iloyalty =10 where ssid=3671
update k_monster set iloyalty =10 where ssid=1694
update k_monster set iloyalty =10 where ssid=755
update k_monster set iloyalty =10 where ssid=4591
update k_monster set iloyalty =10 where ssid=2903
update k_monster set iloyalty =10 where ssid=1673
update k_monster set iloyalty =10 where ssid=1690
update k_monster set iloyalty =10 where ssid=1210
update k_monster set iloyalty =10 where ssid=1111
update k_monster set iloyalty =10 where ssid=1204
update k_monster set iloyalty =10 where ssid=4301
update k_monster set iloyalty =10 where ssid=1113
update k_monster set iloyalty =10 where ssid=1304
update k_monster set iloyalty =10 where ssid=1743
update k_monster set iloyalty =10 where ssid=2021
update k_monster set iloyalty =10 where ssid=1692
update k_monster set iloyalty =10 where ssid=1114
update k_monster set iloyalty =10 where ssid=1693
update k_monster set iloyalty =10 where ssid=2071
update k_monster set iloyalty =10 where ssid=1309
update k_monster set iloyalty =10 where ssid=2223
update k_monster set iloyalty =10 where ssid=1731
update k_monster set iloyalty =10 where ssid=2022
update k_monster set iloyalty =10 where ssid=512
update k_monster set iloyalty =10 where ssid=1691
update k_monster set iloyalty =10 where ssid=1303
update k_monster set iloyalty =10 where ssid=2121
update k_monster set iloyalty =10 where ssid=2952
update k_monster set iloyalty =10 where ssid=2221
update k_monster set iloyalty =10 where ssid=1201
update k_monster set iloyalty =10 where ssid=1114
update k_monster set iloyalty =10 where ssid=2023
update k_monster set iloyalty =10 where ssid=2122
update k_monster set iloyalty =10 where ssid=4501
update k_monster set iloyalty =10 where ssid=2908
update k_monster set iloyalty =10 where ssid=1694
update k_monster set iloyalty =10 where ssid=1200
update k_monster set iloyalty =10 where ssid=3671
update k_monster set iloyalty =10 where ssid=2121
update k_monster set iloyalty =10 where ssid=2021
update k_monster set iloyalty =10 where ssid=2421
update k_monster set iloyalty =10 where ssid=2222
update k_monster set iloyalty =10 where ssid=4701
update k_monster set iloyalty =10 where ssid=403
update k_monster set iloyalty =10 where ssid=2423
update k_monster set iloyalty =10 where ssid=2904
update k_monster set iloyalty =10 where ssid=1741
update k_monster set iloyalty =10 where ssid=4301
update k_monster set iloyalty =10 where ssid=1823
update k_monster set iloyalty =10 where ssid=612
update k_monster set iloyalty =10 where ssid=2353
update k_monster set iloyalty =10 where ssid=2601
update k_monster set iloyalty =10 where ssid=2221
update k_monster set iloyalty =10 where ssid=2421
update k_monster set iloyalty =10 where ssid=1362
update k_monster set iloyalty =10 where ssid=3771
update k_monster set iloyalty =10 where ssid=2422
update k_monster set iloyalty =10 where ssid=1742
update k_monster set iloyalty =10 where ssid=3021
update k_monster set iloyalty =10 where ssid=3891
update k_monster set iloyalty =10 where ssid=1673
update k_monster set iloyalty =10 where ssid=2903
update k_monster set iloyalty =10 where ssid=1690
update k_monster set iloyalty =10 where ssid=1692
update k_monster set iloyalty =10 where ssid=1113
update k_monster set iloyalty =10 where ssid=2952
update k_monster set iloyalty =10 where ssid=1210
update k_monster set iloyalty =10 where ssid=1114
update k_monster set iloyalty =10 where ssid=1204
update k_monster set iloyalty =10 where ssid=1693
update k_monster set iloyalty =10 where ssid=1303
update k_monster set iloyalty =10 where ssid=1691
update k_monster set iloyalty =10 where ssid=2021
update k_monster set iloyalty =10 where ssid=2121
update k_monster set iloyalty =10 where ssid=4301
update k_monster set iloyalty =10 where ssid=2908
update k_monster set iloyalty =10 where ssid=403
update k_monster set iloyalty =10 where ssid=2221
update k_monster set iloyalty =10 where ssid=1691
update k_monster set iloyalty =10 where ssid=2023
update k_monster set iloyalty =10 where ssid=1731
update k_monster set iloyalty =10 where ssid=2221
update k_monster set iloyalty =10 where ssid=2223
update k_monster set iloyalty =10 where ssid=2022
update k_monster set iloyalty =10 where ssid=2122
update k_monster set iloyalty =10 where ssid=2904
update k_monster set iloyalty =10 where ssid=1201
update k_monster set iloyalty =10 where ssid=2908
update k_monster set iloyalty =10 where ssid=2021
update k_monster set iloyalty =10 where ssid=1200
update k_monster set iloyalty =10 where ssid=2071
update k_monster set iloyalty =10 where ssid=2422
update k_monster set iloyalty =10 where ssid=4501
update k_monster set iloyalty =10 where ssid=2601
update k_monster set iloyalty =10 where ssid=2222
update k_monster set iloyalty =10 where ssid=1694
update k_monster set iloyalty =10 where ssid=3021
update k_monster set iloyalty =10 where ssid=2421
update k_monster set iloyalty =10 where ssid=1114
update k_monster set iloyalty =10 where ssid=403
update k_monster set iloyalty =10 where ssid=2423
update k_monster set iloyalty =10 where ssid=2904
update k_monster set iloyalty =10 where ssid=1731
update k_monster set iloyalty =10 where ssid=4301
update k_monster set iloyalty =10 where ssid=1823
update k_monster set iloyalty =10 where ssid=612
update k_monster set iloyalty =10 where ssid=2353
update k_monster set iloyalty =10 where ssid=2601
update k_monster set iloyalty =10 where ssid=2221
update k_monster set iloyalty =10 where ssid=2421
update k_monster set iloyalty =10 where ssid=1362
update k_monster set iloyalty =10 where ssid=3771
update k_monster set iloyalty =10 where ssid=2422
update k_monster set iloyalty =10 where ssid=1742
update k_monster set iloyalty =10 where ssid=3021
update k_monster set iloyalty =10 where ssid=3891