OnceLikLe Merhaba' Ko-Cuce ailesine slmLaR' Bugun Burda 1299 Query AnalyezeR kodLarinin PayLasmam Uzerine burdayiz YorumLar İcin Simdiden TesekkurleR.....











KraL Ekleme





PHP- Kodu:

<div class="alt2" dir="ltr" style="

margin: 0px;

padding: 6px;

border: 1px inset;

width: 640px;

height: 34px;

text-align: left;

overflow: auto">





EXEC*KRAL_EKLE*CharınADI*











Oto G1 Yapma





PHP- Kodu:

<div class="alt2" dir="ltr" style="

margin: 0px;

padding: 6px;

border: 1px inset;

width: 640px;

height: 34px;

text-align: left;

overflow: auto">





update*Knights*set*Points*=*'999999'*











İlk 5 cLan g0 yapma





PHP- Kodu:

<div class="alt2" dir="ltr" style="

margin: 0px;

padding: 6px;

border: 1px inset;

width: 640px;

height: 194px;

text-align: left;

overflow: auto">





update*KNIGHTS_RATING*set*npoints*=*'999999'

where*nrank*=*'1'

update*KNIGHTS_RATING*set*npoints*=*'999999'

where*nrank*=*'2'

update*KNIGHTS_RATING*set*npoints*=*'999999'

where*nrank*=*'3'

update*KNIGHTS_RATING*set*npoints*=*'999999'

where*nrank*=*'4'

update*KNIGHTS_RATING*set*npoints*=*'999999'

where*nrank*=*'5'

GO*











Res Kodu





PHP- Kodu:

<div class="alt2" dir="ltr" style="

margin: 0px;

padding: 6px;

border: 1px inset;

width: 640px;

height: 82px;

text-align: left;

overflow: auto">





exec*imbacodermyst

exec*otonpsimgesi

exec*np_icon

exec*Rank_Knights*











1440 Pot ve Abys bles silmek icin





PHP- Kodu:

<div class="alt2" dir="ltr" style="

margin: 0px;

padding: 6px;

border: 1px inset;

width: 640px;

height: 210px;

text-align: left;

overflow: auto">





DELETE*FROM*ITEM

WHERE*(Num*=*'379102000')

DELETE*FROM*ITEM

WHERE*(Num*=*'379103000')

DELETE*FROM*ITEM

WHERE*(Num*=*'379105000')

DELETE*FROM*ITEM

WHERE*(Num*=*'379104000')

DELETE*FROM*ITEM

WHERE*(Num*=*'379102000')

DELETE*FROM*ITEM

WHERE*(Num*=*'379101000')*











DB YEDEKLEMEK İÇİN–(Bu Kodu Kopyalamadan Önce C: Klasöründe KODB Adlı Klasör Oluşturun Oraya DB’Yi Oraya Kopyalıyacak)









PHP- Kodu:

<div class="alt2" dir="ltr" style="

margin: 0px;

padding: 6px;

border: 1px inset;

width: 640px;

height: 146px;

text-align: left;

overflow: auto">





declare*@location*varchar(120)

set*@location*=**N'c:\KoDB\Gokhantasci-'+replace(str(year(getdate()))+'-'+str(month(getdate()))+'-'+str(day(getdate())),'**',*'')+'.bak'

BACKUP*DATABASE*[Kn_Online]*TO*DISK*=*@location*WITH*NOFORMAT,*INIT,**NAME*=* N'KO-Full*Database*Backup',*SKIP,*NOREWIND,*NOUNLOAD,*S TATS*=*10

declare*@backupSetId*as*int

select*@backupSetId*=*position*from*msdb..backupse t*where**database_name=N'Kn_Online'*and*backup_set _id=(select*max(backup_set_id)**from*msdb..backups et*where*database_name=N'Kn_Online'*)

if*@backupSetId*is*null*begin*raiserror(N'Verify*f ailed.*Backup*information*for*database*''Kn_Online ''*not*found.',*16,*1)*end

RESTORE*VERIFYONLY*FROM*DISK*=*@location*WITH*FILE *=*@backupSetId,*NOUNLOAD,*NOREWIND

GO*











Oto Uyeliq









PHP- Kodu:

<div class="alt2" dir="ltr" style="

margin: 0px;

padding: 6px;

border: 1px inset;

width: 640px;

height: 450px;

text-align: left;

overflow: auto">





CREATE*PROCEDURE*ACCOUNT_LOGIN

@AccountID*varchar(21),

@Password*varchar(13),

@nRet*smallint*OUTPUT

AS

delete*from*currentuser*where*straccountid*=*@Acco untID

---Coded*By*ShellX---

declare*@cnt*BigInt

declare*@nDays*smallint

select*@nRet*=*count(straccountid)*from*tb_user*wh ere*straccountid*=*@AccountID

if*@nRet*=*0

begin

insert*into*tb_user*(straccountid,*strpasswd,*strS ocNo,*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.*











+9]-[+10] İtemleri Silmek









PHP- Kodu:

<div class="alt2" dir="ltr" style="

margin: 0px;

padding: 6px;

border: 1px inset;

width: 640px;

height: 82px;

text-align: left;

overflow: auto">





DELETE*from*ITEM

WHERE*strName*LIKE*'%+9%'

DELETE*from*ITEM

WHERE*strName*LIKE*'%+10%*











1-74 LeveLLeri Clana Almamak









PHP- Kodu:

<div class="alt2" dir="ltr" style="

margin: 0px;

padding: 6px;

border: 1px inset;

width: 640px;

height: 34px;

text-align: left;

overflow: auto">





update*userdata*set*Knights*=*'0'where*Level*=*'1' *



















50 Görevini DB'den Kaldırmak













PHP- Kodu:

<div class="alt2" dir="ltr" style="

margin: 0px;

padding: 6px;

border: 1px inset;

width: 640px;

height: 130px;

text-align: left;

overflow: auto">





delete*from*K_NPCPOS*where*NpcID*=*'16051'

delete*from*K_NPCPOS*where*NpcID*=*'16052'

delete*from*K_NPCPOS*where*NpcID*=*'16053'

delete*from*K_NPCPOS*where*NpcID*=*'16054'

delete*from*K_NPCPOS*where*NpcID*=*'16055'

delete*from*K_NPCPOS*where*NpcID*=*'16056'

delete*from*K_NPCPOS*where*NpcID*=*'16057'*











74 LeveL ve İtemli Başlamayı Kaldırmak







Öncelikle Tables kısmında baslangic tablosunu siliyoruz, Stored Procedures kısmında baslangicitem prosedürünü siliyoruz.



Stored Procedures kısmında LOAD_USER_DATA'ya çift tıklıyoruz ve aşağıdaki kodu bulup siliyoruz:









PHP- Kodu:

<div class="alt2" dir="ltr" style="

margin: 0px;

padding: 6px;

border: 1px inset;

width: 640px;

height: 130px;

text-align: left;

overflow: auto">





DECLARE*@itemaldimi*int

select*@itemaldimi*=*[level]*FROM*USERDATA*WHERE*StrUserID*=*@id

if*@itemaldimi*=*'1'

begin

exec*baslangicitem*@id

update*userdata*set*[level]*=*'74'*,[strSkill]*=**'