Sorunlar & Hileler - Fix Arşivi

XirTR · 22 Ağustos 2012

30 Görevi Bugu

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

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

Okçu 30k Bugu

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

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

Şimdilik bu kadar... Yenileri eklenecektir.

VaLe · 22 Ağustos 2012

Tesekkurler

XirTR · 22 Ağustos 2012

Tesekkurler

MuGiwaRa · 22 Ağustos 2012

teşekkürler delos bugunu fixlemeyi bilen varmı ?

XirTR · 22 Ağustos 2012

o şimdilik sadece beratta var usta... "AndreamTR"

axe0770 · 22 Ağustos 2012

Tesekkurler

IncorrigibLe · 22 Ağustos 2012

Her zaman ki gibi Ellerine Sağlık

QuickSilver · 22 Ağustos 2012

teşekkürler birde şu delos bugunu anlatabilirmisiniz belki çözüm yolu buluruz .

Reallizt · 22 Ağustos 2012

Çogu gereksiz seyler

XirTR · 22 Ağustos 2012

IncorrigibLe' Alıntı:
Her zaman ki gibi Ellerine Sağlık

teşekkürler

QuickSilver' Alıntı:
teşekkürler birde şu delos bugunu anlatabilirmisiniz belki çözüm yolu buluruz .

Usta abyss e giriş gatenin oradan aşağı düşüyorlar sonra kristalin arkasından dolanıp duvarın içinden nova vuruyorlar bu sanırım kast edilen bug.

Reallizt' Alıntı:
Çogu gereksiz seyler

o senin için usta bunların hepsi bana en az 1 kez lazım olmuş kodlar arayanlar olabilir sonuçta sana bana değil herkese hitap etmeye çalışıyoruz

Sth · 22 Ağustos 2012

alayım canım saoolll

bu arada şukunu attım

Aquilo · 22 Ağustos 2012

Teşekkürler.Ellerinize sağlık.

VaLe · 23 Ağustos 2012

XirTR' Alıntı:
Teşekkür bari yazaydın eyiydi.

teşekkürler

heryerde dolandığım için site adına bakmadan yazmış olmalıyım bu forumda flood yapmamaya özen gösteriyorum

)

QuickSilver · 23 Ağustos 2012

XirTR' Alıntı:
Usta abyss e giriş gatenin oradan aşağı düşüyorlar sonra kristalin arkasından dolanıp duvarın içinden nova vuruyorlar bu sanırım kast edilen bug.

ufak bir program ile çözüme kavuşturabiliriz.

ravenharpy · 25 Ağustos 2012

teşekkürler

haci · 25 Ağustos 2012

teşşekürler...

ararim · 25 Ağustos 2012

teşekkürler

adlavci · 25 Ağustos 2012

Ellerine sağlık kardeşiim. !

Development · 25 Ağustos 2012

delos bugu absy arkasından vurmami o ysa onu yapmaya hiç gerek yok adam wurusa Crystal altındadanda wurur.

XagoK · 6 Eylül 2012

saoalsın işime yarar 3 tanesi çıktı eyvallah

Sorunlar & Hileler - Fix Arşivi

Kayıtlı Üye

Kayıtlı Üye

Kayıtlı Üye

Kayıtlı Üye

Kayıtlı Üye

Kayıtlı Üye

Kayıtlı Üye

Yeni Üye

Kayıtlı Üye

Kayıtlı Üye

Kayıtlı Üye

Yeni Üye

Kayıtlı Üye

Yeni Üye

Yeni Üye

Yeni Üye

Yeni Üye

Kayıtlı Üye

Kayıtlı Üye

Kayıtlı Üye

KoCuce Hakkında

Ko-Cuce Links

En yeni üyeler

Sosyal bağlar