Server Tanitimi , Ko Tanitimi , Silkroad Pvp Serverler , Metin2 Pvp Serverler

Sorunlar & Hileler - Fix Arşivi

[XFB] Konu Bilgileri

Konu Hakkında Merhaba, tarihinde 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 383 kez görüntülenmiş, 0 yorum ve 0 tepki puanı almıştır...
Kategori Adı 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 Stark

Stark

K.Destek Yöneticisi
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