Sorunlar & Hileler - Fix Arşivi

  • Konbuyu başlatan Konbuyu başlatan Admin
  • Başlangıç tarihi Başlangıç tarihi
  • Cevaplar Cevaplar 0
  • Görüntüleme Görüntüleme 70
Admin

Admin

Knight Lobby
Yönetici
Founder
Katılım
6 Mayıs 2022
Mesajlar
45,967
30 Görevi Bugu​

Kod: 
delete from K_NPCPOS where NpcID = '21044'



50 Görevi Bugu
Kod: 
delete from K_NPCPOS where NpcID = '16051' delete from K_NPCPOS where NpcID = '16052' delete from K_NPCPOS where NpcID = '16053' delete from K_NPCPOS where NpcID = '16054' delete from K_NPCPOS where NpcID = '16055' delete from K_NPCPOS where NpcID = '16056' delete from K_NPCPOS where NpcID = '16057'



AI Server Açılmama 2 Yol Birden
Kod: 
delete from K_NPCPOS where npcid not in (Select ssid from K_NPC) and npcid not in (Select ssid from K_MONSTER)   --------------------------------------- delete from K_NPCPOS where NpcID not in (Select sSid from K_NPC) and ActType >= 100 delete from K_NPCPOS where NpcID not in (Select sSid from K_MONSTER) and ActType <=99



Beast Hiding 72 Skill Bugu
Kod: 
UPDATE MAGIC_TYPE9 SET TargetChange = 0 WHERE iNum IN(108680, 208680)



Ebenezer C++ Sorunu
Kod: 
INSERT INTO USER_KNIGHTS_RANK VALUES ( 1, 'Gold', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 2, 'Silver', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 3, 'Silver', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 4, 'Silver', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 5, 'Mirage', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 6, 'Mirage', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 7, 'Mirage', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 8, 'Mirage', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 9, 'Mirage', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 10, 'Shadow', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 11, 'Shadow', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 12, 'Shadow', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 13, 'Shadow', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 14, 'Shadow', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 15, 'Shadow', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 16, 'Shadow', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 17, 'Shadow', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 18, 'Shadow', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 19, 'Shadow', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 20, 'Shadow', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 21, 'Shadow', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 22, 'Shadow', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 23, 'Shadow', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 24, 'Shadow', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 25, 'Shadow', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 26, 'Mist', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 27, 'Mist', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 28, 'Mist', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 29, 'Mist', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 30, 'Mist', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 31, 'Mist', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 32, 'Mist', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 33, 'Mist', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 34, 'Mist', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 35, 'Mist', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 36, 'Mist', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 37, 'Mist', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 38, 'Mist', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 39, 'Mist', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 40, 'Mist', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 41, 'Mist', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 42, 'Mist', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 43, 'Mist', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 44, 'Mist', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 45, 'Mist', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 46, 'Mist', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 47, 'Mist', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 48, 'Mist', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 49, 'Mist', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 50, 'Mist', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 51, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 52, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 53, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 54, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 55, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 56, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 57, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 58, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 59, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 60, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 61, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 62, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 63, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 64, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 65, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 66, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 67, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 68, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 69, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 70, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 71, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 72, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 73, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 74, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 75, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 76, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 77, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 78, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 79, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 80, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 81, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 82, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 83, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 84, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 85, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 86, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 87, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 88, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 89, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 90, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 91, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 92, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 93, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 94, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 95, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 96, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 97, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 98, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 99, 'Training', null, null, 0, null, null, 0, 0, getdate() ); INSERT INTO USER_KNIGHTS_RANK VALUES ( 100, 'Training', null, null, 0, null, null, 0, 0, getdate() );  INSERT INTO USER_PERSONAL_RANK VALUES ( 1, 'Gold',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 2, 'Silver',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 3, 'Silver',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 4, 'Silver',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 5, 'Mirage',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 6, 'Mirage',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 7, 'Mirage',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 8, 'Mirage',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 9, 'Mirage',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 10, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 11, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 12, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 13, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 14, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 15, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 16, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 17, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 18, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 19, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 20, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 21, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 22, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 23, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 24, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 25, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 26, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 27, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 28, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 29, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 30, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 31, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 32, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 33, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 34, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 35, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 36, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 37, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 38, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 39, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 40, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 41, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 42, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 43, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 44, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 45, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 46, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 47, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 48, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 49, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 50, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 51, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 52, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 53, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 54, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 55, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 56, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 57, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 58, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 59, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 60, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 61, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 62, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 63, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 64, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 65, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 66, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 67, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 68, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 69, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 70, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 71, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 72, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 73, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 74, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 75, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 76, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 77, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 78, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 79, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 80, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 81, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 82, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 83, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 84, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 85, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 86, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 87, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 88, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 89, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 90, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 91, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 92, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 93, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 94, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 95, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 96, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 97, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 98, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 99, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ; INSERT INTO USER_PERSONAL_RANK VALUES ( 100, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate()) ;



IlIlIl Gibi Nickleri Engelleme
Kod: 
not @struserid LIKE 'IlIl%' and not @struserid LIKE 'lIlI%' and not @struserid LIKE '%lIlI' and not @struserid LIKE '%IlIl' Rulese Giriyosunuz  > New Rules  > Rule Ismi > Kodu Yapıştır  > Tamam > Tekrar Aç  > Blin... Tıkla  > Userdata Seç > Soldan da Struserid Seç Add Bas  > Tamam.



Panelde Internal Error Hatası
Kod: 
"C:\AppServ\Apache2.2\conf\httpd.conf" bu dosyayı not defteri ile açın ve "#LoadModule rewrite_module modules/mod_rewrite.so" yi bulun ( "" ler yok tabiki ) ve # 'yi silin sonra "C:\AppServ\Apache2.2\apache_servicefix.bat" çalıştırın. Şimdi Panelinize girmeyi deneyin Kolay gelsin..



Invalid Password Hatası (Account_Login prosedürünü bununla değiştirin)
Kod: 
CREATE PROCEDURE ACCOUNT_LOGIN @AccountID varchar(21), @Password varchar(13), @nRet smallint OUTPUT AS delete from currentuser where straccountid = @AccountID ---Coded By ShellX--- declare @cnt BigInt declare @nDays smallint select @nRet = count(straccountid) from tb_user where straccountid = @AccountID if @nRet = 0 begin insert into tb_user (straccountid, strpasswd, strSocNo, idays) values (@AccountID, @password, 1, '6') end select @cnt = count(straccountid) from currentuser select @nDays = count(nDays) from PREMIUM_SERVICE where straccountid = @AccountID if @cnt > 40 and @nDays = '0' begin set @nRet = 0 end if @cnt > 40 and @nDays = null begin set @nRet = 0 end DECLARE @Nation tinyint SET @Nation = 0 -- tid login method by samma 2004.02.24 DECLARE @pwd varchar(13) SET @pwd = null SELECT @pwd = strPasswd FROM TB_USER WHERE strAccountID = @AccountID IF @pwd IS null BEGIN SET @nRet = 0 RETURN END ELSE IF @pwd <> @Password BEGIN SET @nRet = 0 RETURN END SELECT @Nation = bNation FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID IF @@ROWCOUNT = 0 BEGIN SET @nRet = 1 RETURN END BEGIN SET @nRet = 1 RETURN END BEGIN SET @nRet = @Nation+1 RETURN END GO



Irk Seçme Ekranın Takılma Sorunu
Kod: 
insert into [ZONE_INFO] Values ('1','101','battle_0516.smd','15000','15000','15000','2','101','Dark Lunar') insert into [ZONE_INFO] Values ('1','102','battle_0516.smd','15000','15000','15000','2','0','BATTLE_ZONE???') insert into [ZONE_INFO] Values ('1','201','free_0810.smd','15000','15000','15000','2','0','Colony Zone') update ZONE_INFO set ServerNo = '1'



Item Takılmama Sorunu
Kod: 
update item set reqlevel = '1'



Okçu 30k Bugu
Kod: 
update MAGIC_TYPE2 set AddDamagePlus = 1 where NeedArrow = 1 or NeedArrow = 3 or NeedArrow = 5



Seri R Bugu
Kod: 
delete from magic where magicnum = '105720'  delete from magic where magicnum = '105755'  delete from magic where magicnum = '106720'  delete from magic where magicnum = '106755'  delete from magic where magicnum = '106770'  delete from magic where magicnum = '205720'  delete from magic where magicnum = '205755' delete from magic where magicnum = '206720'  delete from magic where magicnum = '206755'  delete from magic where magicnum = '206770'



Seri Sc Fix
Kod: 
update MAGIC set ReCastTime= '255'  where MagicNum = 'Scroll Kodu'



Seri Skill Fix
Kod: 
update MAGIC set ReCastTime='60' where MagicNum='101001' update MAGIC set ReCastTime='31' where MagicNum='101003' update MAGIC set ReCastTime='31' where MagicNum='101005' update MAGIC set ReCastTime='100' where MagicNum='101007' update MAGIC set ReCastTime='31' where MagicNum='101009' update MAGIC set ReCastTime='255' where MagicNum='101010' update MAGIC set ReCastTime='60' where MagicNum='102001' update MAGIC set ReCastTime='0' where MagicNum='102003' update MAGIC set ReCastTime='52' where MagicNum='102005' update MAGIC set ReCastTime='255' where MagicNum='102006' update MAGIC set ReCastTime='43' where MagicNum='103001' update MAGIC set ReCastTime='43' where MagicNum='103003' update MAGIC set ReCastTime='43' where MagicNum='103005' update MAGIC set ReCastTime='43' where MagicNum='103007' update MAGIC set ReCastTime='43' where MagicNum='103009' update MAGIC set ReCastTime='255' where MagicNum='103010' update MAGIC set ReCastTime='54' where MagicNum='104002' update MAGIC set ReCastTime='54' where MagicNum='104007' update MAGIC set ReCastTime='255' where MagicNum='104009' update MAGIC set ReCastTime='52' where MagicNum='104010' update MAGIC set ReCastTime='54' where MagicNum='104011' update MAGIC set ReCastTime='54' where MagicNum='104012' update MAGIC set ReCastTime='60' where MagicNum='105001' update MAGIC set ReCastTime='31' where MagicNum='105003' update MAGIC set ReCastTime='31' where MagicNum='105005' update MAGIC set ReCastTime='100' where MagicNum='105007' update MAGIC set ReCastTime='31' where MagicNum='105009' update MAGIC set ReCastTime='255' where MagicNum='105010' update MAGIC set ReCastTime='31' where MagicNum='105500' update MAGIC set ReCastTime='5' where MagicNum='105505' update MAGIC set ReCastTime='31' where MagicNum='105510' update MAGIC set ReCastTime='5' where MagicNum='105515' update MAGIC set ReCastTime='51' where MagicNum='105520' update MAGIC set ReCastTime='5' where MagicNum='105525' update MAGIC set ReCastTime='31' where MagicNum='105530' update MAGIC set ReCastTime='5' where MagicNum='105535' update MAGIC set ReCastTime='31' where MagicNum='105540' update MAGIC set ReCastTime='5' where MagicNum='105545' update MAGIC set ReCastTime='31' where MagicNum='105550' update MAGIC set ReCastTime='5' where MagicNum='105555' update MAGIC set ReCastTime='5' where MagicNum='105557' update MAGIC set ReCastTime='5' where MagicNum='105560' update MAGIC set ReCastTime='65' where MagicNum='105630' update MAGIC set ReCastTime='150' where MagicNum='105645' update MAGIC set ReCastTime='91' where MagicNum='105650' update MAGIC set ReCastTime='255' where MagicNum='105660' update MAGIC set ReCastTime='91' where MagicNum='105705' update MAGIC set ReCastTime='45' where MagicNum='105710' update MAGIC set ReCastTime='255' where MagicNum='105720' update MAGIC set ReCastTime='51' where MagicNum='105725' update MAGIC set ReCastTime='255' where MagicNum='105730' update MAGIC set ReCastTime='65' where MagicNum='105731' update MAGIC set ReCastTime='91' where MagicNum='105735' update MAGIC set ReCastTime='51' where MagicNum='105740' update MAGIC set ReCastTime='255' where MagicNum='105750' update MAGIC set ReCastTime='255' where MagicNum='105755' update MAGIC set ReCastTime='51' where MagicNum='105760' update MAGIC set ReCastTime='60' where MagicNum='106001' update MAGIC set ReCastTime='31' where MagicNum='106003' update MAGIC set ReCastTime='31' where MagicNum='106005' update MAGIC set ReCastTime='100' where MagicNum='106007' update MAGIC set ReCastTime='31' where MagicNum='106009' update MAGIC set ReCastTime='255' where MagicNum='106010' update MAGIC set ReCastTime='31' where MagicNum='106500' update MAGIC set ReCastTime='5' where MagicNum='106505' update MAGIC set ReCastTime='31' where MagicNum='106510' update MAGIC set ReCastTime='5' where MagicNum='106515' update MAGIC set ReCastTime='51' where MagicNum='106520' update MAGIC set ReCastTime='5' where MagicNum='106525' update MAGIC set ReCastTime='31' where MagicNum='106530' update MAGIC set ReCastTime='5' where MagicNum='106535' update MAGIC set ReCastTime='31' where MagicNum='106540' update MAGIC set ReCastTime='5' where MagicNum='106545' update MAGIC set ReCastTime='31' where MagicNum='106550' update MAGIC set ReCastTime='5' where MagicNum='106555' update MAGIC set ReCastTime='5' where MagicNum='106557' update MAGIC set ReCastTime='5' where MagicNum='106560' update MAGIC set ReCastTime='8' where MagicNum='106570' update MAGIC set ReCastTime='210' where MagicNum='106575' update MAGIC set ReCastTime='8' where MagicNum='106580' update MAGIC set ReCastTime='65' where MagicNum='106630' update MAGIC set ReCastTime='150' where MagicNum='106645' update MAGIC set ReCastTime='91' where MagicNum='106650' update MAGIC set ReCastTime='255' where MagicNum='106660' update MAGIC set ReCastTime='101' where MagicNum='106670' update MAGIC set ReCastTime='200' where MagicNum='106675' update MAGIC set ReCastTime='101' where MagicNum='106680' update MAGIC set ReCastTime='91' where MagicNum='106705' update MAGIC set ReCastTime='45' where MagicNum='106710' update MAGIC set ReCastTime='91' where MagicNum='106715' update MAGIC set ReCastTime='255' where MagicNum='106720' update MAGIC set ReCastTime='51' where MagicNum='106725' update MAGIC set ReCastTime='255' where MagicNum='106730' update MAGIC set ReCastTime='65' where MagicNum='106731' update MAGIC set ReCastTime='91' where MagicNum='106735' update MAGIC set ReCastTime='51' where MagicNum='106740' update MAGIC set ReCastTime='255' where MagicNum='106750' update MAGIC set ReCastTime='255' where MagicNum='106755' update MAGIC set ReCastTime='51' where MagicNum='106760' update MAGIC set ReCastTime='101' where MagicNum='106770' update MAGIC set ReCastTime='255' where MagicNum='106775' update MAGIC set ReCastTime='255' where MagicNum='106780' update MAGIC set ReCastTime='101' where MagicNum='106802' update MAGIC set ReCastTime='255' where MagicNum='106815' update MAGIC set ReCastTime='255' where MagicNum='106820' update MAGIC set ReCastTime='60' where MagicNum='107001' update MAGIC set ReCastTime='52' where MagicNum='107005' update MAGIC set ReCastTime='255' where MagicNum='107031' update MAGIC set ReCastTime='32' where MagicNum='107505' update MAGIC set ReCastTime='32' where MagicNum='107510' update MAGIC set ReCastTime='42' where MagicNum='107530' update MAGIC set ReCastTime='42' where MagicNum='107535' update MAGIC set ReCastTime='42' where MagicNum='107545' update MAGIC set ReCastTime='42' where MagicNum='107550' update MAGIC set ReCastTime='255' where MagicNum='107552' update MAGIC set ReCastTime='52' where MagicNum='107600' update MAGIC set ReCastTime='255' where MagicNum='107610' update MAGIC set ReCastTime='102' where MagicNum='107615' update MAGIC set ReCastTime='52' where MagicNum='107620' update MAGIC set ReCastTime='102' where MagicNum='107630' update MAGIC set ReCastTime='102' where MagicNum='107635' update MAGIC set ReCastTime='52' where MagicNum='107640' update MAGIC set ReCastTime='90' where MagicNum='107645' update MAGIC set ReCastTime='255' where MagicNum='107650' update MAGIC set ReCastTime='112' where MagicNum='107655' update MAGIC set ReCastTime='55' where MagicNum='107700' update MAGIC set ReCastTime='255' where MagicNum='107710' update MAGIC set ReCastTime='40' where MagicNum='107715' update MAGIC set ReCastTime='102' where MagicNum='107725' update MAGIC set ReCastTime='255' where MagicNum='107730' update MAGIC set ReCastTime='90' where MagicNum='107735' update MAGIC set ReCastTime='12' where MagicNum='107736' update MAGIC set ReCastTime='12' where MagicNum='107748' update MAGIC set ReCastTime='255' where MagicNum='107760' update MAGIC set ReCastTime='60' where MagicNum='108001' update MAGIC set ReCastTime='52' where MagicNum='108005' update MAGIC set ReCastTime='255' where MagicNum='108031' update MAGIC set ReCastTime='32' where MagicNum='108505' update MAGIC set ReCastTime='32' where MagicNum='108510' update MAGIC set ReCastTime='42' where MagicNum='108530' update MAGIC set ReCastTime='42' where MagicNum='108535' update MAGIC set ReCastTime='255' where MagicNum='108552' update MAGIC set ReCastTime='60' where MagicNum='108562' update MAGIC set ReCastTime='60' where MagicNum='108566' update MAGIC set ReCastTime='255' where MagicNum='108580' update MAGIC set ReCastTime='255' where MagicNum='108585' update MAGIC set ReCastTime='52' where MagicNum='108600' update MAGIC set ReCastTime='255' where MagicNum='108610' update MAGIC set ReCastTime='102' where MagicNum='108615' update MAGIC set ReCastTime='52' where MagicNum='108620' update MAGIC set ReCastTime='102' where MagicNum='108630' update MAGIC set ReCastTime='102' where MagicNum='108635' update MAGIC set ReCastTime='52' where MagicNum='108640' update MAGIC set ReCastTime='90' where MagicNum='108645' update MAGIC set ReCastTime='255' where MagicNum='108650' update MAGIC set ReCastTime='112' where MagicNum='108655' update MAGIC set ReCastTime='52' where MagicNum='108670' update MAGIC set ReCastTime='255' where MagicNum='108675' update MAGIC set ReCastTime='255' where MagicNum='108680' update MAGIC set ReCastTime='255' where MagicNum='108685' update MAGIC set ReCastTime='55' where MagicNum='108700' update MAGIC set ReCastTime='255' where MagicNum='108710' update MAGIC set ReCastTime='40' where MagicNum='108715' update MAGIC set ReCastTime='102' where MagicNum='108725' update MAGIC set ReCastTime='255' where MagicNum='108730' update MAGIC set ReCastTime='90' where MagicNum='108735' update MAGIC set ReCastTime='12' where MagicNum='108736' update MAGIC set ReCastTime='12' where MagicNum='108748' update MAGIC set ReCastTime='255' where MagicNum='108760' update MAGIC set ReCastTime='255' where MagicNum='108770' update MAGIC set ReCastTime='255' where MagicNum='108775' update MAGIC set ReCastTime='255' where MagicNum='108780' update MAGIC set ReCastTime='255' where MagicNum='108802' update MAGIC set ReCastTime='255' where MagicNum='108815' update MAGIC set ReCastTime='255' where MagicNum='108820' update MAGIC set ReCastTime='43' where MagicNum='109001' update MAGIC set ReCastTime='43' where MagicNum='109003' update MAGIC set ReCastTime='43' where MagicNum='109005' update MAGIC set ReCastTime='43' where MagicNum='109007' update MAGIC set ReCastTime='43' where MagicNum='109009' update MAGIC set ReCastTime='100' where MagicNum='109015' update MAGIC set ReCastTime='255' where MagicNum='109035' update MAGIC set ReCastTime='255' where MagicNum='109036' update MAGIC set ReCastTime='53' where MagicNum='109509' update MAGIC set ReCastTime='43' where MagicNum='109515' update MAGIC set ReCastTime='43' where MagicNum='109527' update MAGIC set ReCastTime='43' where MagicNum='109535' update MAGIC set ReCastTime='43' where MagicNum='109539' update MAGIC set ReCastTime='153' where MagicNum='109545' update MAGIC set ReCastTime='53' where MagicNum='109551' update MAGIC set ReCastTime='60' where MagicNum='109554' update MAGIC set ReCastTime='203' where MagicNum='109557' update MAGIC set ReCastTime='153' where MagicNum='109560' update MAGIC set ReCastTime='53' where MagicNum='109609' update MAGIC set ReCastTime='43' where MagicNum='109615' update MAGIC set ReCastTime='43' where MagicNum='109627' update MAGIC set ReCastTime='43' where MagicNum='109635' update MAGIC set ReCastTime='43' where MagicNum='109639' update MAGIC set ReCastTime='53' where MagicNum='109651' update MAGIC set ReCastTime='203' where MagicNum='109657' update MAGIC set ReCastTime='153' where MagicNum='109660' update MAGIC set ReCastTime='53' where MagicNum='109709' update MAGIC set ReCastTime='43' where MagicNum='109715' update MAGIC set ReCastTime='43' where MagicNum='109727' update MAGIC set ReCastTime='43' where MagicNum='109735' update MAGIC set ReCastTime='43' where MagicNum='109739' update MAGIC set ReCastTime='153' where MagicNum='109745' update MAGIC set ReCastTime='53' where MagicNum='109751' update MAGIC set ReCastTime='60' where MagicNum='109754' update MAGIC set ReCastTime='203' where MagicNum='109757' update MAGIC set ReCastTime='153' where MagicNum='109760' update MAGIC set ReCastTime='43' where MagicNum='110001' update MAGIC set ReCastTime='43' where MagicNum='110003' update MAGIC set ReCastTime='43' where MagicNum='110005' update MAGIC set ReCastTime='43' where MagicNum='110007' update MAGIC set ReCastTime='43' where MagicNum='110009' update MAGIC set ReCastTime='255' where MagicNum='110035' update MAGIC set ReCastTime='255' where MagicNum='110036' update MAGIC set ReCastTime='53' where MagicNum='110509' update MAGIC set ReCastTime='43' where MagicNum='110515' update MAGIC set ReCastTime='43' where MagicNum='110527' update MAGIC set ReCastTime='43' where MagicNum='110535' update MAGIC set ReCastTime='43' where MagicNum='110539' update MAGIC set ReCastTime='153' where MagicNum='110545' update MAGIC set ReCastTime='53' where MagicNum='110551' update MAGIC set ReCastTime='60' where MagicNum='110554' update MAGIC set ReCastTime='203' where MagicNum='110557' update MAGIC set ReCastTime='153' where MagicNum='110560' update MAGIC set ReCastTime='213' where MagicNum='110570' update MAGIC set ReCastTime='183' where MagicNum='110571' update MAGIC set ReCastTime='255' where MagicNum='110573' update MAGIC set ReCastTime='255' where MagicNum='110574' update MAGIC set ReCastTime='213' where MagicNum='110575' update MAGIC set ReCastTime='53' where MagicNum='110609' update MAGIC set ReCastTime='43' where MagicNum='110615' update MAGIC set ReCastTime='43' where MagicNum='110627' update MAGIC set ReCastTime='43' where MagicNum='110635' update MAGIC set ReCastTime='43' where MagicNum='110639' update MAGIC set ReCastTime='153' where MagicNum='110645' update MAGIC set ReCastTime='53' where MagicNum='110651' update MAGIC set ReCastTime='203' where MagicNum='110657' update MAGIC set ReCastTime='153' where MagicNum='110660' update MAGIC set ReCastTime='213' where MagicNum='110670' update MAGIC set ReCastTime='183' where MagicNum='110671' update MAGIC set ReCastTime='255' where MagicNum='110673' update MAGIC set ReCastTime='255' where MagicNum='110674' update MAGIC set ReCastTime='53' where MagicNum='110709' update MAGIC set ReCastTime='43' where MagicNum='110715' update MAGIC set ReCastTime='43' where MagicNum='110727' update MAGIC set ReCastTime='43' where MagicNum='110735' update MAGIC set ReCastTime='153' where MagicNum='110745' update MAGIC set ReCastTime='53' where MagicNum='110751' update MAGIC set ReCastTime='60' where MagicNum='110754' update MAGIC set ReCastTime='203' where MagicNum='110757' update MAGIC set ReCastTime='153' where MagicNum='110760' update MAGIC set ReCastTime='255' where MagicNum='110762' update MAGIC set ReCastTime='213' where MagicNum='110770' update MAGIC set ReCastTime='183' where MagicNum='110771' update MAGIC set ReCastTime='255' where MagicNum='110773' update MAGIC set ReCastTime='255' where MagicNum='110774' update MAGIC set ReCastTime='255' where MagicNum='110802' update MAGIC set ReCastTime='255' where MagicNum='110815' update MAGIC set ReCastTime='255' where MagicNum='110820' update MAGIC set ReCastTime='255' where MagicNum='110825' update MAGIC set ReCastTime='54' where MagicNum='111002' update MAGIC set ReCastTime='54' where MagicNum='111007' update MAGIC set ReCastTime='255' where MagicNum='111009' update MAGIC set ReCastTime='52' where MagicNum='111010' update MAGIC set ReCastTime='54' where MagicNum='111011' update MAGIC set ReCastTime='54' where MagicNum='111012' update MAGIC set ReCastTime='2' where MagicNum='111520' update MAGIC set ReCastTime='15' where MagicNum='111525' update MAGIC set ReCastTime='10' where MagicNum='111529' update MAGIC set ReCastTime='15' where MagicNum='111535' update MAGIC set ReCastTime='20' where MagicNum='111542' update MAGIC set ReCastTime='20' where MagicNum='111542' update MAGIC set ReCastTime='30' where MagicNum='111551' update MAGIC set ReCastTime='54' where MagicNum='111554' update MAGIC set ReCastTime='54' where MagicNum='111557' update MAGIC set ReCastTime='64' where MagicNum='111560' update MAGIC set ReCastTime='2' where MagicNum='111620' update MAGIC set ReCastTime='10' where MagicNum='111629' update MAGIC set ReCastTime='20' where MagicNum='111641' update MAGIC set ReCastTime='30' where MagicNum='111650' update MAGIC set ReCastTime='74' where MagicNum='111700' update MAGIC set ReCastTime='74' where MagicNum='111703' update MAGIC set ReCastTime='74' where MagicNum='111709' update MAGIC set ReCastTime='74' where MagicNum='111715' update MAGIC set ReCastTime='2' where MagicNum='111721' update MAGIC set ReCastTime='74' where MagicNum='111724' update MAGIC set ReCastTime='94' where MagicNum='111727' update MAGIC set ReCastTime='10' where MagicNum='111729' update MAGIC set ReCastTime='74' where MagicNum='111730' update MAGIC set ReCastTime='250' where MagicNum='111733' update MAGIC set ReCastTime='20' where MagicNum='111739' update MAGIC set ReCastTime='250' where MagicNum='111742' update MAGIC set ReCastTime='74' where MagicNum='111745' update MAGIC set ReCastTime='30' where MagicNum='111750' update MAGIC set ReCastTime='94' where MagicNum='111751' update MAGIC set ReCastTime='250' where MagicNum='111754' update MAGIC set ReCastTime='94' where MagicNum='111757' update MAGIC set ReCastTime='104' where MagicNum='111760' update MAGIC set ReCastTime='54' where MagicNum='112002' update MAGIC set ReCastTime='54' where MagicNum='112007' update MAGIC set ReCastTime='255' where MagicNum='112009' update MAGIC set ReCastTime='25' where MagicNum='112010' update MAGIC set ReCastTime='31' where MagicNum='112011' update MAGIC set ReCastTime='37' where MagicNum='112012' update MAGIC set ReCastTime='2' where MagicNum='112020' update MAGIC set ReCastTime='15' where MagicNum='112025' update MAGIC set ReCastTime='15' where MagicNum='112025' update MAGIC set ReCastTime='10' where MagicNum='112029' update MAGIC set ReCastTime='15' where MagicNum='112035' update MAGIC set ReCastTime='20' where MagicNum='112042' update MAGIC set ReCastTime='30' where MagicNum='112051' update MAGIC set ReCastTime='54' where MagicNum='112054' update MAGIC set ReCastTime='54' where MagicNum='112057' update MAGIC set ReCastTime='64' where MagicNum='112060' update MAGIC set ReCastTime='255' where MagicNum='112080' update MAGIC set ReCastTime='2' where MagicNum='112620' update MAGIC set ReCastTime='10' where MagicNum='112629' update MAGIC set ReCastTime='20' where MagicNum='112641' update MAGIC set ReCastTime='30' where MagicNum='112650' update MAGIC set ReCastTime='255' where MagicNum='112676' update MAGIC set ReCastTime='74' where MagicNum='112700' update MAGIC set ReCastTime='74' where MagicNum='112703' update MAGIC set ReCastTime='74' where MagicNum='112709' update MAGIC set ReCastTime='74' where MagicNum='112715' update MAGIC set ReCastTime='74' where MagicNum='112724' update MAGIC set ReCastTime='94' where MagicNum='112727' update MAGIC set ReCastTime='10' where MagicNum='112729' update MAGIC set ReCastTime='74' where MagicNum='112730' update MAGIC set ReCastTime='250' where MagicNum='112733' update MAGIC set ReCastTime='74' where MagicNum='112736' update MAGIC set ReCastTime='20' where MagicNum='112739' update MAGIC set ReCastTime='250' where MagicNum='112742' update MAGIC set ReCastTime='74' where MagicNum='112745' update MAGIC set ReCastTime='30' where MagicNum='112750' update MAGIC set ReCastTime='94' where MagicNum='112751' update MAGIC set ReCastTime='250' where MagicNum='112754' update MAGIC set ReCastTime='94' where MagicNum='112757' update MAGIC set ReCastTime='104' where MagicNum='112760' update MAGIC set ReCastTime='154' where MagicNum='112770' update MAGIC set ReCastTime='255' where MagicNum='112771' update MAGIC set ReCastTime='255' where MagicNum='112772' update MAGIC set ReCastTime='5' where MagicNum='112802' update MAGIC set ReCastTime='5' where MagicNum='112815' update MAGIC set ReCastTime='255' where MagicNum='112820' update MAGIC set ReCastTime='255' where MagicNum='112825' update MAGIC set ReCastTime='60' where MagicNum='201001' update MAGIC set ReCastTime='31' where MagicNum='201003' update MAGIC set ReCastTime='31' where MagicNum='201005' update MAGIC set ReCastTime='100' where MagicNum='201007' update MAGIC set ReCastTime='31' where MagicNum='201009' update MAGIC set ReCastTime='255' where MagicNum='201010' update MAGIC set ReCastTime='60' where MagicNum='202001' update MAGIC set ReCastTime='0' where MagicNum='202003' update MAGIC set ReCastTime='52' where MagicNum='202005' update MAGIC set ReCastTime='255' where MagicNum='202006' update MAGIC set ReCastTime='43' where MagicNum='203001' update MAGIC set ReCastTime='43' where MagicNum='203003' update MAGIC set ReCastTime='43' where MagicNum='203005' update MAGIC set ReCastTime='43' where MagicNum='203007' update MAGIC set ReCastTime='43' where MagicNum='203009' update MAGIC set ReCastTime='255' where MagicNum='203010' update MAGIC set ReCastTime='54' where MagicNum='204002' update MAGIC set ReCastTime='54' where MagicNum='204007' update MAGIC set ReCastTime='255' where MagicNum='204009' update MAGIC set ReCastTime='52' where MagicNum='204010' update MAGIC set ReCastTime='54' where MagicNum='204011' update MAGIC set ReCastTime='54' where MagicNum='204012' update MAGIC set ReCastTime='60' where MagicNum='205001' update MAGIC set ReCastTime='31' where MagicNum='205003' update MAGIC set ReCastTime='31' where MagicNum='205005' update MAGIC set ReCastTime='100' where MagicNum='205007' update MAGIC set ReCastTime='31' where MagicNum='205009' update MAGIC set ReCastTime='255' where MagicNum='205010' update MAGIC set ReCastTime='31' where MagicNum='205500' update MAGIC set ReCastTime='5' where MagicNum='205505' update MAGIC set ReCastTime='31' where MagicNum='205510' update MAGIC set ReCastTime='5' where MagicNum='205515' update MAGIC set ReCastTime='51' where MagicNum='205520' update MAGIC set ReCastTime='5' where MagicNum='205525' update MAGIC set ReCastTime='31' where MagicNum='205530' update MAGIC set ReCastTime='5' where MagicNum='205535' update MAGIC set ReCastTime='31' where MagicNum='205540' update MAGIC set ReCastTime='5' where MagicNum='205545' update MAGIC set ReCastTime='31' where MagicNum='205550' update MAGIC set ReCastTime='5' where MagicNum='205555' update MAGIC set ReCastTime='5' where MagicNum='205557' update MAGIC set ReCastTime='5' where MagicNum='205560' update MAGIC set ReCastTime='65' where MagicNum='205630' update MAGIC set ReCastTime='150' where MagicNum='205645' update MAGIC set ReCastTime='91' where MagicNum='205650' update MAGIC set ReCastTime='255' where MagicNum='205660' update MAGIC set ReCastTime='91' where MagicNum='205705' update MAGIC set ReCastTime='45' where MagicNum='205710' update MAGIC set ReCastTime='255' where MagicNum='205720' update MAGIC set ReCastTime='51' where MagicNum='205725' update MAGIC set ReCastTime='255' where MagicNum='205730' update MAGIC set ReCastTime='65' where MagicNum='205731' update MAGIC set ReCastTime='91' where MagicNum='205735' update MAGIC set ReCastTime='51' where MagicNum='205740' update MAGIC set ReCastTime='255' where MagicNum='205750' update MAGIC set ReCastTime='255' where MagicNum='205755' update MAGIC set ReCastTime='51' where MagicNum='205760' update MAGIC set ReCastTime='60' where MagicNum='206001' update MAGIC set ReCastTime='31' where MagicNum='206003' update MAGIC set ReCastTime='31' where MagicNum='206005' update MAGIC set ReCastTime='100' where MagicNum='206007' update MAGIC set ReCastTime='31' where MagicNum='206009' update MAGIC set ReCastTime='255' where MagicNum='206010' update MAGIC set ReCastTime='31' where MagicNum='206500' update MAGIC set ReCastTime='5' where MagicNum='206505' update MAGIC set ReCastTime='31' where MagicNum='206510' update MAGIC set ReCastTime='5' where MagicNum='206515' update MAGIC set ReCastTime='51' where MagicNum='206520' update MAGIC set ReCastTime='5' where MagicNum='206525' update MAGIC set ReCastTime='31' where MagicNum='206530' update MAGIC set ReCastTime='5' where MagicNum='206535' update MAGIC set ReCastTime='31' where MagicNum='206540' update MAGIC set ReCastTime='5' where MagicNum='206545' update MAGIC set ReCastTime='31' where MagicNum='206550' update MAGIC set ReCastTime='5' where MagicNum='206555' update MAGIC set ReCastTime='5' where MagicNum='206557' update MAGIC set ReCastTime='5' where MagicNum='206560' update MAGIC set ReCastTime='8' where MagicNum='206570' update MAGIC set ReCastTime='210' where MagicNum='206575' update MAGIC set ReCastTime='8' where MagicNum='206580' update MAGIC set ReCastTime='65' where MagicNum='206630' update MAGIC set ReCastTime='150' where MagicNum='206645' update MAGIC set ReCastTime='91' where MagicNum='206650' update MAGIC set ReCastTime='255' where MagicNum='206660' update MAGIC set ReCastTime='101' where MagicNum='206670' update MAGIC set ReCastTime='200' where MagicNum='206675' update MAGIC set ReCastTime='101' where MagicNum='206680' update MAGIC set ReCastTime='91' where MagicNum='206705' update MAGIC set ReCastTime='45' where MagicNum='206710' update MAGIC set ReCastTime='91' where MagicNum='206715' update MAGIC set ReCastTime='255' where MagicNum='206720' update MAGIC set ReCastTime='51' where MagicNum='206725' update MAGIC set ReCastTime='255' where MagicNum='206730' update MAGIC set ReCastTime='65' where MagicNum='206731' update MAGIC set ReCastTime='91' where MagicNum='206735' update MAGIC set ReCastTime='51' where MagicNum='206740' update MAGIC set ReCastTime='255' where MagicNum='206750' update MAGIC set ReCastTime='255' where MagicNum='206755' update MAGIC set ReCastTime='51' where MagicNum='206760' update MAGIC set ReCastTime='101' where MagicNum='206770' update MAGIC set ReCastTime='255' where MagicNum='206775' update MAGIC set ReCastTime='255' where MagicNum='206780' update MAGIC set ReCastTime='101' where MagicNum='206802' update MAGIC set ReCastTime='255' where MagicNum='206815' update MAGIC set ReCastTime='255' where MagicNum='206820' update MAGIC set ReCastTime='60' where MagicNum='207001' update MAGIC set ReCastTime='52' where MagicNum='207005' update MAGIC set ReCastTime='255' where MagicNum='207031' update MAGIC set ReCastTime='32' where MagicNum='207505' update MAGIC set ReCastTime='32' where MagicNum='207510' update MAGIC set ReCastTime='42' where MagicNum='207530' update MAGIC set ReCastTime='42' where MagicNum='207535' update MAGIC set ReCastTime='42' where MagicNum='207545' update MAGIC set ReCastTime='42' where MagicNum='207550' update MAGIC set ReCastTime='255' where MagicNum='207552' update MAGIC set ReCastTime='52' where MagicNum='207600' update MAGIC set ReCastTime='255' where MagicNum='207610' update MAGIC set ReCastTime='102' where MagicNum='207615' update MAGIC set ReCastTime='52' where MagicNum='207620' update MAGIC set ReCastTime='102' where MagicNum='207630' update MAGIC set ReCastTime='102' where MagicNum='207635' update MAGIC set ReCastTime='52' where MagicNum='207640' update MAGIC set ReCastTime='90' where MagicNum='207645' update MAGIC set ReCastTime='255' where MagicNum='207650' update MAGIC set ReCastTime='112' where MagicNum='207655' update MAGIC set ReCastTime='55' where MagicNum='207700' update MAGIC set ReCastTime='255' where MagicNum='207710' update MAGIC set ReCastTime='40' where MagicNum='207715' update MAGIC set ReCastTime='102' where MagicNum='207725' update MAGIC set ReCastTime='255' where MagicNum='207730' update MAGIC set ReCastTime='90' where MagicNum='207735' update MAGIC set ReCastTime='12' where MagicNum='207736' update MAGIC set ReCastTime='12' where MagicNum='207748' update MAGIC set ReCastTime='255' where MagicNum='207760' update MAGIC set ReCastTime='60' where MagicNum='208001' update MAGIC set ReCastTime='52' where MagicNum='208005' update MAGIC set ReCastTime='255' where MagicNum='208031' update MAGIC set ReCastTime='32' where MagicNum='208505' update MAGIC set ReCastTime='32' where MagicNum='208510' update MAGIC set ReCastTime='42' where MagicNum='208530' update MAGIC set ReCastTime='42' where MagicNum='208535' update MAGIC set ReCastTime='255' where MagicNum='208552' update MAGIC set ReCastTime='60' where MagicNum='208562' update MAGIC set ReCastTime='60' where MagicNum='208566' update MAGIC set ReCastTime='255' where MagicNum='208580' update MAGIC set ReCastTime='255' where MagicNum='208585' update MAGIC set ReCastTime='52' where MagicNum='208600' update MAGIC set ReCastTime='255' where MagicNum='208610' update MAGIC set ReCastTime='102' where MagicNum='208615' update MAGIC set ReCastTime='52' where MagicNum='208620' update MAGIC set ReCastTime='102' where MagicNum='208630' update MAGIC set ReCastTime='102' where MagicNum='208635' update MAGIC set ReCastTime='52' where MagicNum='208640' update MAGIC set ReCastTime='90' where MagicNum='208645' update MAGIC set ReCastTime='255' where MagicNum='208650' update MAGIC set ReCastTime='112' where MagicNum='208655' update MAGIC set ReCastTime='52' where MagicNum='208670' update MAGIC set ReCastTime='255' where MagicNum='208675' update MAGIC set ReCastTime='255' where MagicNum='208680' update MAGIC set ReCastTime='255' where MagicNum='208685' update MAGIC set ReCastTime='55' where MagicNum='208700' update MAGIC set ReCastTime='255' where MagicNum='208710' update MAGIC set ReCastTime='40' where MagicNum='208715' update MAGIC set ReCastTime='102' where MagicNum='208725' update MAGIC set ReCastTime='255' where MagicNum='208730' update MAGIC set ReCastTime='90' where MagicNum='208735' update MAGIC set ReCastTime='12' where MagicNum='208736' update MAGIC set ReCastTime='12' where MagicNum='208748' update MAGIC set ReCastTime='255' where MagicNum='208760' update MAGIC set ReCastTime='255' where MagicNum='208770' update MAGIC set ReCastTime='255' where MagicNum='208775' update MAGIC set ReCastTime='255' where MagicNum='208780' update MAGIC set ReCastTime='255' where MagicNum='208802' update MAGIC set ReCastTime='255' where MagicNum='208815' update MAGIC set ReCastTime='255' where MagicNum='208820' update MAGIC set ReCastTime='43' where MagicNum='209001' update MAGIC set ReCastTime='43' where MagicNum='209003' update MAGIC set ReCastTime='43' where MagicNum='209005' update MAGIC set ReCastTime='43' where MagicNum='209007' update MAGIC set ReCastTime='43' where MagicNum='209009' update MAGIC set ReCastTime='100' where MagicNum='209015' update MAGIC set ReCastTime='255' where MagicNum='209035' update MAGIC set ReCastTime='255' where MagicNum='209036' update MAGIC set ReCastTime='53' where MagicNum='209509' update MAGIC set ReCastTime='43' where MagicNum='209515' update MAGIC set ReCastTime='43' where MagicNum='209527' update MAGIC set ReCastTime='43' where MagicNum='209535' update MAGIC set ReCastTime='43' where MagicNum='209539' update MAGIC set ReCastTime='153' where MagicNum='209545' update MAGIC set ReCastTime='53' where MagicNum='209551' update MAGIC set ReCastTime='60' where MagicNum='209554' update MAGIC set ReCastTime='203' where MagicNum='209557' update MAGIC set ReCastTime='153' where MagicNum='209560' update MAGIC set ReCastTime='53' where MagicNum='209609' update MAGIC set ReCastTime='43' where MagicNum='209615' update MAGIC set ReCastTime='43' where MagicNum='209627' update MAGIC set ReCastTime='43' where MagicNum='209635' update MAGIC set ReCastTime='43' where MagicNum='209639' update MAGIC set ReCastTime='53' where MagicNum='209651' update MAGIC set ReCastTime='203' where MagicNum='209657' update MAGIC set ReCastTime='153' where MagicNum='209660' update MAGIC set ReCastTime='53' where MagicNum='209709' update MAGIC set ReCastTime='43' where MagicNum='209715' update MAGIC set ReCastTime='43' where MagicNum='209727' update MAGIC set ReCastTime='43' where MagicNum='209735' update MAGIC set ReCastTime='43' where MagicNum='209739' update MAGIC set ReCastTime='153' where MagicNum='209745' update MAGIC set ReCastTime='53' where MagicNum='209751' update MAGIC set ReCastTime='60' where MagicNum='209754' update MAGIC set ReCastTime='203' where MagicNum='209757' update MAGIC set ReCastTime='153' where MagicNum='209760' update MAGIC set ReCastTime='43' where MagicNum='210001' update MAGIC set ReCastTime='43' where MagicNum='210003' update MAGIC set ReCastTime='43' where MagicNum='210005' update MAGIC set ReCastTime='43' where MagicNum='210007' update MAGIC set ReCastTime='43' where MagicNum='210009' update MAGIC set ReCastTime='255' where MagicNum='210035' update MAGIC set ReCastTime='255' where MagicNum='210036' update MAGIC set ReCastTime='53' where MagicNum='210509' update MAGIC set ReCastTime='43' where MagicNum='210515' update MAGIC set ReCastTime='43' where MagicNum='210527' update MAGIC set ReCastTime='43' where MagicNum='210535' update MAGIC set ReCastTime='43' where MagicNum='210539' update MAGIC set ReCastTime='153' where MagicNum='210545' update MAGIC set ReCastTime='53' where MagicNum='210551' update MAGIC set ReCastTime='60' where MagicNum='210554' update MAGIC set ReCastTime='203' where MagicNum='210557' update MAGIC set ReCastTime='153' where MagicNum='210560' update MAGIC set ReCastTime='213' where MagicNum='210570' update MAGIC set ReCastTime='183' where MagicNum='210571' update MAGIC set ReCastTime='255' where MagicNum='210573' update MAGIC set ReCastTime='255' where MagicNum='210574' update MAGIC set ReCastTime='213' where MagicNum='210575' update MAGIC set ReCastTime='53' where MagicNum='210609' update MAGIC set ReCastTime='43' where MagicNum='210615' update MAGIC set ReCastTime='43' where MagicNum='210627' update MAGIC set ReCastTime='43' where MagicNum='210635' update MAGIC set ReCastTime='43' where MagicNum='210639' update MAGIC set ReCastTime='153' where MagicNum='210645' update MAGIC set ReCastTime='53' where MagicNum='210651' update MAGIC set ReCastTime='203' where MagicNum='210657' update MAGIC set ReCastTime='153' where MagicNum='210660' update MAGIC set ReCastTime='213' where MagicNum='210670' update MAGIC set ReCastTime='183' where MagicNum='210671' update MAGIC set ReCastTime='255' where MagicNum='210673' update MAGIC set ReCastTime='255' where MagicNum='210674' update MAGIC set ReCastTime='53' where MagicNum='210709' update MAGIC set ReCastTime='43' where MagicNum='210715' update MAGIC set ReCastTime='43' where MagicNum='210727' update MAGIC set ReCastTime='43' where MagicNum='210735' update MAGIC set ReCastTime='153' where MagicNum='210745' update MAGIC set ReCastTime='53' where MagicNum='210751' update MAGIC set ReCastTime='60' where MagicNum='210754' update MAGIC set ReCastTime='203' where MagicNum='210757' update MAGIC set ReCastTime='153' where MagicNum='210760' update MAGIC set ReCastTime='255' where MagicNum='210762' update MAGIC set ReCastTime='213' where MagicNum='210770' update MAGIC set ReCastTime='183' where MagicNum='210771' update MAGIC set ReCastTime='255' where MagicNum='210773' update MAGIC set ReCastTime='255' where MagicNum='210774' update MAGIC set ReCastTime='255' where MagicNum='210802' update MAGIC set ReCastTime='255' where MagicNum='210815' update MAGIC set ReCastTime='255' where MagicNum='210820' update MAGIC set ReCastTime='255' where MagicNum='210825' update MAGIC set ReCastTime='54' where MagicNum='211002' update MAGIC set ReCastTime='54' where MagicNum='211007' update MAGIC set ReCastTime='255' where MagicNum='211009' update MAGIC set ReCastTime='52' where MagicNum='211010' update MAGIC set ReCastTime='54' where MagicNum='211011' update MAGIC set ReCastTime='54' where MagicNum='211012' update MAGIC set ReCastTime='2' where MagicNum='211520' update MAGIC set ReCastTime='15' where MagicNum='211525' update MAGIC set ReCastTime='10' where MagicNum='211529' update MAGIC set ReCastTime='15' where MagicNum='211535' update MAGIC set ReCastTime='20' where MagicNum='211542' update MAGIC set ReCastTime='20' where MagicNum='211542' update MAGIC set ReCastTime='30' where MagicNum='211551' update MAGIC set ReCastTime='54' where MagicNum='211554' update MAGIC set ReCastTime='54' where MagicNum='211557' update MAGIC set ReCastTime='64' where MagicNum='211560' update MAGIC set ReCastTime='2' where MagicNum='211620' update MAGIC set ReCastTime='10' where MagicNum='211629' update MAGIC set ReCastTime='20' where MagicNum='211641' update MAGIC set ReCastTime='30' where MagicNum='211650' update MAGIC set ReCastTime='74' where MagicNum='211700' update MAGIC set ReCastTime='74' where MagicNum='211703' update MAGIC set ReCastTime='74' where MagicNum='211709' update MAGIC set ReCastTime='74' where MagicNum='211715' update MAGIC set ReCastTime='2' where MagicNum='211721' update MAGIC set ReCastTime='74' where MagicNum='211724' update MAGIC set ReCastTime='94' where MagicNum='211727' update MAGIC set ReCastTime='10' where MagicNum='211729' update MAGIC set ReCastTime='74' where MagicNum='211730' update MAGIC set ReCastTime='250' where MagicNum='211733' update MAGIC set ReCastTime='20' where MagicNum='211739' update MAGIC set ReCastTime='250' where MagicNum='211742' update MAGIC set ReCastTime='74' where MagicNum='211745' update MAGIC set ReCastTime='30' where MagicNum='211750' update MAGIC set ReCastTime='94' where MagicNum='211751' update MAGIC set ReCastTime='250' where MagicNum='211754' update MAGIC set ReCastTime='94' where MagicNum='211757' update MAGIC set ReCastTime='104' where MagicNum='211760' update MAGIC set ReCastTime='54' where MagicNum='212002' update MAGIC set ReCastTime='54' where MagicNum='212007' update MAGIC set ReCastTime='255' where MagicNum='212009' update MAGIC set ReCastTime='25' where MagicNum='212010' update MAGIC set ReCastTime='31' where MagicNum='212011' update MAGIC set ReCastTime='37' where MagicNum='212012' update MAGIC set ReCastTime='2' where MagicNum='212020' update MAGIC set ReCastTime='15' where MagicNum='212025' update MAGIC set ReCastTime='15' where MagicNum='212025' update MAGIC set ReCastTime='10' where MagicNum='212029' update MAGIC set ReCastTime='15' where MagicNum='212035' update MAGIC set ReCastTime='20' where MagicNum='212042' update MAGIC set ReCastTime='30' where MagicNum='212051' update MAGIC set ReCastTime='54' where MagicNum='212054' update MAGIC set ReCastTime='54' where MagicNum='212057' update MAGIC set ReCastTime='64' where MagicNum='212060' update MAGIC set ReCastTime='255' where MagicNum='212080' update MAGIC set ReCastTime='2' where MagicNum='212620' update MAGIC set ReCastTime='10' where MagicNum='212629' update MAGIC set ReCastTime='20' where MagicNum='212641' update MAGIC set ReCastTime='30' where MagicNum='212650' update MAGIC set ReCastTime='255' where MagicNum='212676' update MAGIC set ReCastTime='74' where MagicNum='212700' update MAGIC set ReCastTime='74' where MagicNum='212703' update MAGIC set ReCastTime='74' where MagicNum='212709' update MAGIC set ReCastTime='74' where MagicNum='212715' update MAGIC set ReCastTime='74' where MagicNum='212724' update MAGIC set ReCastTime='94' where MagicNum='212727' update MAGIC set ReCastTime='10' where MagicNum='212729' update MAGIC set ReCastTime='74' where MagicNum='212730' update MAGIC set ReCastTime='250' where MagicNum='212733' update MAGIC set ReCastTime='74' where MagicNum='212736' update MAGIC set ReCastTime='20' where MagicNum='212739' update MAGIC set ReCastTime='250' where MagicNum='212742' update MAGIC set ReCastTime='74' where MagicNum='212745' update MAGIC set ReCastTime='30' where MagicNum='212750' update MAGIC set ReCastTime='94' where MagicNum='212751' update MAGIC set ReCastTime='250' where MagicNum='212754' update MAGIC set ReCastTime='94' where MagicNum='212757' update MAGIC set ReCastTime='104' where MagicNum='212760' update MAGIC set ReCastTime='154' where MagicNum='212770' update MAGIC set ReCastTime='255' where MagicNum='212771' update MAGIC set ReCastTime='255' where MagicNum='212772' update MAGIC set ReCastTime='5' where MagicNum='212802' update MAGIC set ReCastTime='5' where MagicNum='212815' update MAGIC set ReCastTime='255' where MagicNum='212820' update MAGIC set ReCastTime='255' where MagicNum='212825'



Speed Hack Fix
Kod: 
Speed Hackçileri Oyuna Almama aşağıdaki kodu LOAD_USER_DATA da SET @nRet = @@RowCount altına ekleyin ve speed hack kullananları oyuna almayın! Kod: DECLARE @speedhack varchar(250) select @speedhack = strHackToolName from HACKTOOL_USERLOG where strCharID = @id if @speedhack='Something that resembles Speedhack has been detected on this PC. (Code = 10303)' begin Set @nRet = 0 end



Stat Bugu Fix
Kod: 
CREATE PROCEDURE [dbo].[REPAIR_USER_STAT_POINTS] @strUserID varchar(21) AS /* Author : SirReaL */ DECLARE @Level int, @Point tinyint, @Class int,@NewPoint int SELECT @Level = Level,@Class = Class,@Point = Points FROM USERDATA WHERE strUserId = @strUserID IF @Level >= 74 AND @Point = 31 BEGIN /*     IF @Level = 71     BEGIN     SET @NewPoint =  210     END     ELSE IF @Level = 72     BEGIN     SET @NewPoint =  215     END     ELSE IF @Level = 73     BEGIN     SET @NewPoint =  220     END     ELSE IF @Level = 74 */     IF @Level = 74     BEGIN     SET @NewPoint =  225     END     ELSE IF @Level = 75     BEGIN     SET @NewPoint =  230     END     ELSE IF @Level = 76     BEGIN     SET @NewPoint =  235     END     ELSE IF @Level = 77     BEGIN     SET @NewPoint =  240     END     ELSE IF @Level = 78     BEGIN     SET @NewPoint =  245     END     ELSE IF @Level = 79     BEGIN     SET @NewPoint =  250     END     ELSE IF @Level = 80     BEGIN     SET @NewPoint =  255     END          IF @Class = 201 OR @Class = 205 OR @Class = 206 OR @Class = 101 OR @Class = 105 OR @Class = 106     BEGIN         UPDATE USERDATA Set Strong = '97',Dex = '60',Sta = '65',Intel = '50',Cha = '50',Points = @NewPoint WHERE strUserId = @strUserId     END     ELSE IF @Class = 202 OR @Class = 207 OR @Class = 208 OR @Class = 102 OR @Class = 107 OR @Class = 108     BEGIN         UPDATE USERDATA Set Strong = '60',Dex = '102',Sta = '60',Intel = '50',Cha = '50',Points = @NewPoint WHERE strUserId = @strUserId     END     ELSE IF @Class = 203 OR @Class = 209 OR @Class = 210 OR @Class = 103 OR @Class = 109 OR @Class = 110     BEGIN         UPDATE USERDATA Set Strong = '50',Dex = '70',Sta = '50',Intel = '70',Cha = '82',Points = @NewPoint WHERE strUserId = @strUserId     END     ELSE IF @Class = 204 OR @Class = 211 OR @Class = 212 OR @Class = 104 OR @Class = 111 OR @Class = 112     BEGIN         UPDATE USERDATA Set Strong = '65',Dex = '60',Sta = '65',Intel = '82',Cha = '50',Points = @NewPoint WHERE strUserId = @strUserId     END END GO -------------------------------- LOAD_USER_DATA Prosedürüne SELECT Nation, Race, Class, HairColor, Rank, Title, [Level], [Exp], Loyalty, Face, City, Knights, Fame,      Hp, Mp, Sp, Strong, Sta, Dex, Intel, Cha, Authority, Points, Gold, [Zone], Bind, PX, PZ, PY, dwTime, strSkill, strItem,strSerial, sQuestCount, strQuest, MannerPoint, LoyaltyMonthly     FROM    USERDATA WHERE strUserId = @id -- # Repair Stat Start # EXEC REPAIR_USER_STAT_POINTS @id -- # Repair Stat End # --------------------------------



TR Karakteri Tek Kodla Engelleme
Kod: 
CREATE FUNCTION [dbo].[IsValidCharacters](@SData varchar(8000)) RETURNS INT  AS BEGIN     DECLARE @SDataLen int     DECLARE @Loop int     DECLARE @Letter varchar(1)     DECLARE @RXLetters varchar(8000)     DECLARE @Match tinyint          SET @RXLetters = 'qwertyuopasdfghjklizxcvbnmQWERTYUIOPASDFGHJKLZXCVBNM1234567890_'     SET @SDataLen = LEN(@SData)     SET @Loop = 1     SET @Match = 0          WHILE @Loop < (@SDataLen + 1)     BEGIN              SET @Letter = RTRIM(LTRIM(SUBSTRING(@SData,@Loop,1)))         IF CHARINDEX(@Letter,@RXLetters) = 0         BEGIN             SET @Match = 1             BREAK         END              SET @Loop = @Loop + 1     END          RETURN @Match END



Yan Char Fix
Kod: 
update account_char set strcharid2 = 'XirTR', strcharid3 = 'XirTR'



Şimdilik bu kadar... Yenileri eklenecektir.
Sorunlar & Hileler - Fix Arşivi | KnightLobby

Knight Online Private Server dünyasında aktif olan oyuncular için önemli bir konu olan sorunlar ve hileler, zamanla gelişen sistemlerle birlikte değişiklik gösterebilmektedir. Bu bağlamda, KO Private Server geliştiricileri ve oyuncuları için Fix Arşivi oluşturulmuştur. Bu arşiv, hem KO Development süreçlerinde karşılaşılan teknik sorunların çözümünü hem de KO Emulator üzerinde çalışan sunucularda meydana gelen hataların giderilmesini sağlar.

Knight Online özel sunucularında yaşanan yaygın sorunlar, genellikle emulator ile ilgilidir. Örneğin, USKO veya ROFD tabanlı sistemlerde zaman zaman KnightOnLine.exe ile ilgili hatalar ortaya çıkabilir. Bu tür durumlar, genellikle client edit işlemleri sırasında yanlış dosya değişiklikleriyle oluşur. Bu nedenle, KO Client üzerinde yapılan tüm düzenlemeler dikkatli yapılmalıdır.

KO Bot geliştirme sürecinde de birtakım sorunlar yaşanabilmektedir. Özellikle macro bot sistemlerinde KO Filter veya Knight Online Guard gibi koruma mekanizmalarına takılmadan çalışmak oldukça zordur. Ancak doğru bot development teknikleriyle bu tür sistemler bypass edilebilir. Kobot veya Kowotd gibi botlar için source kodların sürekli güncellenmesi önemlidir.

KO Server Files içinde yer alan item.bin, mob.bin, npc.bin gibi dosyaların eksik ya da hatalı yapılandırılması da birçok runtime hatasına sebep olabilir. Özellikle zone server ile ilgili problemlerde bu dosyaların doğru yapılandırılmış olması şarttır. Cap 83 ve Cap 70 gibi seviye sınırlamaları, KO Cap ayarlarıyla birlikte doğru entegre edilmelidir.

Knight Online Database[/B] (KO DB) ile ilgili sorunlar da sıkça karşılaşılan konulardan biridir. Sunucu veritabanında meydana gelen eksiklikler, karakter kayıplarına veya envanter hatalarına yol açabilir. KO Source Code üzerinde yapılan değişikliklerde, veritabanı yapılandırmasının da güncellenmesi gereklidir.

KO Addon ve Myko gibi ekstra sistemler, oyun deneyimini artırmak için kullanılır ancak bazen uyumsuzluklardan dolayı hata verebilirler. Bu tür hatalar genellikle KO PVP veya PvE sistemlerinde performans düşüklüğüne neden olur. KO Myko entegrasyonlarında dikkat edilmesi gereken detaylar vardır.

Knight Online karakter sınıfları arasında Warrior, Rogue, Mage, Priest gibi temel sınıflar yer alırken, Lycaon, Felankor, Ultima, Juraid, Apostle, Berserker gibi üst sınıf karakterler de mevcuttur. Bu sınıflarla ilgili dengesizlikler, özellikle KO PvP sunucularında ciddi sorunlara yol açabilir. Bu nedenle, sınıf dengesi ayarları yapılmadan sunucu açılmamalıdır.

KO Private Server tanıtımı ve tanıtım reklamları yapılırken, sunulan hizmetin kalitesi önemlidir. Luferson, Ronark, Delos, Pathos, Karus, El Morad gibi harita sistemlerindeki hatalar, oyuncu memnuniyetini doğrudan etkiler. KO 3DMax gibi modelleme araçları ile sunucuya özel içerik eklemek isteyenler, bunu profesyonelce yapmalıdır.

Sonuç olarak, Knight Online Private Server dünyasında başarılı olmak için hem teknik bilgi hem de sabır gerekmektedir. Fix Arşivi, bu yolda yardımcı olacak en değerli kaynaklardan biridir. KnightLobby, bu alanda oyunculara sunduğu kapsamlı veritabanıyla destek sağlamaya devam etmektedir.

Issues & Hacks - Fix Archive | KnightLobby

Knight Online Private Server players face common challenges related to issues and hacks. As systems evolve, these topics continue to change. In this context, the Fix Archive has been created for KO Private Server developers and players alike. This archive provides solutions for technical issues encountered during KO Development and fixes for errors occurring on servers running KO Emulator.

Common issues experienced in Knight Online private servers are often related to the emulator. For instance, errors involving KnightOnLine.exe can arise in USKO or ROFD based systems. These usually occur due to incorrect file modifications during client edit processes. Therefore, all modifications made on the KO Client should be handled with care.

Problems may also occur during KO Bot development. Specifically, macro bots often struggle to operate without being caught by protection mechanisms such as KO Filter or Knight Online Guard. However, with correct bot development techniques, these systems can be bypassed. Source codes for bots like Kobot or Kowotd must be updated regularly.

Misconfigurations in files like item.bin, mob.bin, npc.bin within KO Server Files can lead to numerous runtime errors. Particularly for zone server related problems, it's crucial that these files are configured correctly. Level limitations such as Cap 83 and Cap 70 must be properly integrated with KO Cap settings.

Issues related to the Knight Online Database (KO DB) are also frequently encountered. Missing configurations in the server database may result in character losses or inventory errors. When making changes to the KO Source Code, the database configuration must also be updated accordingly.

KO Addon and Myko extensions enhance gameplay but may sometimes cause errors due to compatibility issues. Such errors often lead to performance drops in KO PVP or PvE systems. Attention to detail is essential during KO Myko integrations.

Among Knight Online character classes, basic classes like Warrior, Rogue, Mage, Priest exist, alongside advanced classes such as Lycaon, Felankor, Ultima, Juraid, Apostle, Berserker. Imbalances related to these classes can cause serious problems, especially in KO PvP servers. Thus, class balance settings must be configured before launching a server.

When advertising KO Private Servers, the quality of service provided is crucial. Errors in map systems like Luferson, Ronark, Delos, Pathos, Karus, El Morad directly impact player satisfaction. Those wishing to add custom content via tools like KO 3DMax must do so professionally.

In conclusion, success in the Knight Online Private Server world requires both technical knowledge and patience. The Fix Archive is one of the most valuable resources available along this journey. KnightLobby continues to provide support through its comprehensive database.​
 
Cevap yazmak için giriş yap yada kayıt ol.
Tablolardaki Duplicate Sorununa Çözüm [Örnek Paylaşım] 1299 Bugsuz Hellbreaker

Şuan Bu Konuyu Görüntüleyen Kullanıcılar (Toplam : 0, Üye : 0, Misafir : 0)

Benzer konular Forum Tarih
Admin 3 Adet Ufak Sorunlarım Var Yardımcı Olabilecek Varsa Çok Sevinirim.. Knight Online Paylaşımları
Admin Seven Panel v8 License / Saldırı Yemeyen Panel / Tüm Sorunlar Fix / Açık Yok ! Knight Online Paylaşımları
Admin MAGIC_TYPE3 sorunlarını düzeltme Knight Online Paylaşımları
Admin SLOT SORUNLARI Knight Online Paylaşımları
Admin MysteriouS - DB 1.1 62/1 Unikler Bosslarda | Sorunlar Giderildi - Farkı Yakalayın [31-08-2013] Knight Online Paylaşımları
Admin 1397 X-Laz Database [Şimdi Benim Zamanım] Büyük Çaplı Sorunlar Halledildi. Knight Online Paylaşımları
Admin NERONLINEWORLD 1886 Server Files (Büyük oranda sorunlar çözülmüştür) Knight Online Paylaşımları
Admin 19xx Server Files + Database + Client + Oto DBC ( Büyük Oranda Sorunlar Giderilmiştir ) Knight Online Paylaşımları

Benzer konular

Geri
Üst Alt