1299 Butun QA kodLari

Stark · 23 Haz 2013

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

Stark · 23 Haz 2013

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

Ara

1299 Butun QA kodLari

[XFB] Konu Bilgileri

Stark

K.Destek Yöneticisi

Users Who Are Viewing This Konu (Users: 0, Guests: 1)

1299 Butun QA kodLari

[XFB] Konu Bilgileri

Stark

K.Destek Yöneticisi

Users Who Are Viewing This Konu (Users: 0, Guests: 1)