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 546 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 TheJackal

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','15000','2','101','Dark Lunar')

Kod:
insert into [ZONE_INFO] Values ('1','102','battle_0516.smd','15000','15000','15000','2','0','BATTLE_ZONE???')
insert into [ZONE_INFO] Values ('1','201','free_0810.smd','15000','15000','15000','2','0','Colony Zone')
update ZONE_INFO set ServerNo = '1'

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 = 'qwertyuopasdfghjklizxcvbnmQWERTYUIOPASDFGHJKLZXCVBNM1234567890_'
SET @SDataLen = LEN(@SData)
SET @Loop = 1
SET @Match = 0

WHILE @Loop < (@SDataLen + 1)
BEGIN

SET @Letter = RTRIM(LTRIM(SUBSTRING(@SData,@Loop,1)))
IF CHARINDEX(@Letter,@RXLetters) = 0
BEGIN
SET @Match = 1
BREAK
END

SET @Loop = @Loop + 1
END

RETURN @Match
END

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

Kod:

Şimdilik bu kadar... Yenileri eklenecektir.
 
Üst
Silkroad Serverler