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_se t_id=(select*max(backup_set_id)***from*msdb..backu pset*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*











+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]*=***'