Full Prosedür Kodları Arağıdınız Bütün QA Kodlarını Burada

İlk Olarak Önemli Bazı Kodları Verım

Kral Ekleme

PHP- Kodu:
EXEC KRAL_EKLE CharınADI


Oto G1 Yapma

PHP- Kodu:
update Knights set Points = '999999'


Ilk 5 Clanı G0 Yapma


PHP- Kodu:
update KNIGHTS_RATING set npoints = '999999'


İlk 5 Clanı G0 Yapma


PHP- Kodu:
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:
exec imbacodermyst


PHP- Kodu:
exec otonpsimgesi
exec np_icon
exec Rank_Knights


1440 pot ve abys bles silmek için



PHP- Kodu:
DELETE FROM ITEM


PHP- Kodu:
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:
declare @location varchar(120)


PHP- Kodu:
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, STATS = 10
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N'Kn_Online' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N'Kn_Online' )
if @backupSetId is null begin raiserror(N'Verify failed. Backup information for database ''Kn_Online'' not found.', 16, 1) end
RESTORE VERIFYONLY FROM DISK = @location WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
GO


Oto Uyelık

PHP- Kodu:
CREATE PROCEDURE ACCOUNT_LOGIN
@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


Keeper KEsınce Isınlanma Sorunu



PHP- Kodu:
CREATE PROCEDURE MGAME_LOGIN


PHP- Kodu:
@AccountID varchar(21),
@Password varchar(13),
@nRet smallint OUTPUT
AS

DECLARE @Nation tinyint, @CharNum smallint
SET @Nation = 0
SET @CharNum = 0
DECLARE @pwd varchar(13)
SET @pwd = null
SELECT @pwd = strPasswd FROM [dbo].[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, @CharNum = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
IF @@ROWCOUNT = 0
BEGIN
SET @nRet = 1
RETURN
END
IF @CharNum = 0
BEGIN
SET @nRet = 1
RETURN
END
ELSE
BEGIN
SET @nRet = @Nation+1
RETURN
END
GO


AyLık Np 0'lama Qa Kod

PHP- Kodu:
UPDATE USERDATA
SET LoyaltyMonthly = 0

teskurler..!