Kod:

delete from K_NPCPOS where NpcID = '21044'



Kod:

delete from K_NPCPOS where NpcID = '16051'



Kod:

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'



Kod:

delete from K_NPCPOS where npcid not in (Select ssid from K_NPC) and npcid not in (Select ssid from K_MONSTER)



Kod:

---------------------------------------

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 New Rules

> Rule Ismi

> Kodu Yapıştır

> Tamam

> Tekrar Aç

> Blin... Tıkla

> Userdata Seç

> Soldan da Struserid Seç Add Bas

> Tamam.



Kod:

"C:\AppServ\Apache2.2\conf\httpd.conf" bu dosyayı not defteri ile açın ve



Kod:

"#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..



Kod:

CREATE PROCEDURE ACCOUNT_LOGIN



Kod:

@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



Kod:

insert into [ZONE_INFO] Values ('1','101','battle_0516.smd','15000','15000','1500 0','2','101','Dark Lunar')



Kod:

insert into [ZONE_INFO] Values ('1','102','battle_0516.smd','15000','15000','1500 0','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'



Kod:

update item set reqlevel = '1'







Kod:

update MAGIC_TYPE2



Kod:

set AddDamagePlus = 1

where NeedArrow = 1 or NeedArrow = 3 or NeedArrow = 5



Kod:

delete from magic where magicnum = '105720'



Kod:

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'



Kod:

update MAGIC set ReCastTime= '255'



Kod:

where MagicNum = 'Scroll Kodu'



Kod:

update MAGIC set ReCastTime='60' where MagicNum='101001'



Kod:

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'



Kod:

Speed Hackçileri Oyuna Almama



Kod:

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



Kod:

CREATE PROCEDURE [dbo].[REPAIR_USER_STAT_POINTS]



Kod:

@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 #

--------------------------------



Kod:

CREATE FUNCTION [dbo].[IsValidCharacters](@SData varchar(8000))



Kod:

RETURNS INT

AS

BEGIN

DECLARE @SDataLen int

DECLARE @Loop int

DECLARE @Letter varchar(1)

DECLARE @RXLetters varchar(8000)

DECLARE @Match tinyint



SET @RXLetters = 'qwertyuopasdfghjklizxcvbnmQWERTYUIOPASDFGHJKLZXCV BNM1234567890_'

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



Kod:

update account_char set strcharid2 = 'XirTR', strcharid3 = 'XirTR'



Kod:



Şimdilik bu kadar... Yenileri eklenecektir.