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