Sitemizden Yararlanmak İçin

Sitemize Üye Olmalısınız

or Kayıt ol
Server Tanitimi , Ko Tanitimi , Silkroad Pvp Serverler , Metin2 Pvp Serverler

Sorunlar & Hileler - Fix Arşivi

[XFB] Konu Bilgileri

Konu Hakkında Merhaba, tarihinde Knight Online Pvp Prosedür & Kod Paylaşımları kategorisinde Stark tarafından oluşturulan Sorunlar & Hileler - Fix Arşivi başlıklı konuyu okuyorsunuz. Bu konu şimdiye dek 697 kez görüntülenmiş, 1 yorum ve 0 tepki puanı almıştır...
Kategori Adı Knight Online Pvp Prosedür & Kod Paylaşımları
Konu Başlığı Sorunlar & Hileler - Fix Arşivi
Konbuyu başlatan Stark
Başlangıç tarihi
Cevaplar
Görüntüleme
İlk mesaj tepki puanı
Son Mesaj Yazan campos12

Stark

K.Destek Yöneticisi
Katılım
27 May 2013
Mesajlar
2,664
Tepkime puanı
15
Puanları
38
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.
 
Üst
Silkroad Serverler