Qa Kodları.! Kral yapma.. Oto G1 vb..

Query Analyzer Girin..Üstten Db’nizi Seçin .. Kodları yapıştırıp F5 yapın çıkın.!
[Resimleri görebilmek için üye olun veya giriş yapın.]
Oto g1 yapmaKod:

update Knights set Points = '999999'


Tek Kodla Kral Yapma.!Kod:

EXEC KRAL_EKLE CharınADI


Bütün Clanların kOlunu yakma.Kod:

update knights set ranking = 1,gold =999999999,domination = 9999,points = 999999999


–İlk 5 Clanı G0 Yapma—Kod:

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


Charın İsmini Değiştirme-Kod:

EXEC ACCOUNT_CHAR_NAME_CHANGE 'ESKICHARADI,'YENICHARADI'


Charın Irkını Değiştirme-(Irk Numaraları = 1 karus 2 human)Kod:

EXEC ACCOUNT_NATION_CHANGE 'HESABINIDSI','IRKNUMARASI'


Symbol Ve Clan Güncellemeleri.(Server Kapalıyken)Kod:

exec imbacodermyst
exec otonpsimgesi
exec np_icon
exec Rank_Knights


1440 pot ve abys bles silmek için ;Kod:

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')


ACİD POTLARI SİLMEK İÇİN;Kod:

DELETE item
WHERE num = '389015000'
go
DELETE item
WHERE num = '389064000'
go
DELETE item
WHERE num = '910005000'


CHARI FULL EDİT YAPMAK İÇİN Kod:

update Userdata set strskill = 'ÿ'where struserid = 'Char Nick'


DB DEN BÜTÜN CHARLARI SİLMEK İÇİN Kod:

truncate table account_char
truncate table currentuser
truncate table deleted_userdata
truncate table knights
truncate table knights_rating
truncate table knights_user
truncate table tb_user
truncate table userdata
truncate table warehouse


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

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, 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


DROPLARI 0 LAMAK İÇİNKod:

update k_monster_item set iItem01 = '0'
update k_monster_item set iItem02 = '0'
update k_monster_item set iItem03 = '0'
update k_monster_item set iItem04 = '0'
update k_monster_item set iItem05 = '0'


EXP ARTTİRMAK İÇİNKod:

update k_monster
set iexp = iexp*5


CHARIN STATLARINI FULL 255 YAPMAK İÇİNKod:

update Userdata set strskill = 'ÿ'where struserid = 'Char Nick'


BİR ÇHARI GM YAPMAK İÇİNKod:

update userdata set Authority = '0'
where struserid = 'Karakter İsmi'


GUARD TOWER DMG AYARI İÇİN-(Set FirstDamageyi 10000 yaparsanız kuleler 1-2 k vurur)Kod:

UPDATE MAGIC_TYPE3
SET FirstDamage = 1000
WHERE (iNum = 300139)


HOLY WATER I DB DEN KALDIRMAK İÇİNKod:

Delete from item
where num = '379101000'
delete from item
where num = '379102000'
delete from item
where num = '379103000'
Delete from item
where num = '379108000'
delete from item
where num = '379113000'
delete from item
where num = '379098000'

MAGE SKİLERİNİ GÜCLENDİRMEK İÇİN-(FirstDamage İle Oynayarak artırabilirsiniz)Kod:

UPDATE MAGIC_TYPE3
SET FirstDamage = - 10000
WHERE (iNum = 109551)
UPDATE MAGIC_TYPE3
SET FirstDamage = - 10000
WHERE (iNum = 110551)
UPDATE MAGIC_TYPE3
SET FirstDamage = - 10000
WHERE (iNum = 209551)


USERLARIN NP LERINI 0 LAMAK İÇİNKod:

UPDATE USERDATA
SET Loyalty = 0
WHERE Authority = 1


BANLANAN OYUNCULARIN NP LERINI 0 LAMAK İÇİNKod:

UPDATE USERDATA
SET Loyalty = 0
WHERE Authority = 255


OKCULARIN 32K DMG BUGU İÇİN;Kod:

update MAGIC_TYPE2
set AddDamagePlus = 1
where NeedArrow = 1 or NeedArrow = 3 or NeedArrow = 5


OTO ÜYELİK İÇİNKod:

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


TÜM CHARLARI MARADONA ATMAK İÇİN;Kod:

update Userdata set zone = '21'


SERVERA USKO PELERIN EKLEMEK İÇİN;Kod:

INSERT INTO [KNIGHTS_CAPE] Values (10,'black',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (11,'blue',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (12,'red',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (13,'purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (14,'green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (15,'yellow',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (16,'dark purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (17,'orange',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (18,'light green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (29,'¼èâ»ì',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (30,'½ÊÀÚ°¡',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (31,'üŹ«´Ì',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (32,'´ëĪ',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (33,'½Öµ¶¼ö',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (110,'black',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (111,'blue',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (112,'red',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (113,'purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (114,'green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (115,'yellow',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (116,'dark purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (117,'orange',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (118,'light green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (210,'black',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (211,'blue',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (212,'red',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (213,'purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (214,'green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (215,'yellow',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (216,'dark purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (217,'orange',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (218,'light green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (310,'black',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (311,'blue',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (312,'red',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (313,'purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (314,'green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (315,'yellow',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (316,'dark purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (317,'orange',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (318,'light green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (410,'black',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (411,'blue',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (412,'red',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (413,'purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (414,'green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (415,'yellow',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (416,'dark purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (417,'orange',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (418,'light green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (510,'black',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (511,'blue',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (512,'red',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (513,'purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (514,'green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (515,'yellow',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (516,'dark purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (517,'orange',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (518,'light green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (129,'¼èâ»ì',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (130,'½ÊÀÚ°¡',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (131,'üŹ«´Ì',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (132,'´ëĪ',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (133,'½Öµ¶¼ö',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (229,'¼èâ»ì',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (230,'½ÊÀÚ°¡',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (231,'üŹ«´Ì',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (232,'´ëĪ',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (233,'½Öµ¶¼ö',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (329,'¼èâ»ì',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (330,'½ÊÀÚ°¡',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (331,'üŹ«´Ì',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (332,'´ëĪ',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (333,'½Öµ¶¼ö',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (429,'¼èâ»ì',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (430,'½ÊÀÚ°¡',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (431,'üŹ«´Ì',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (432,'´ëĪ',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (433,'½Öµ¶¼ö',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (529,'¼èâ»ì',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (530,'½ÊÀÚ°¡',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (531,'üŹ«´Ì',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (532,'´ëĪ',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (533,'½Öµ¶¼ö',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (40,'black',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (41,'blue',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (42,'red',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (43,'purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (44,'green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (45,'yellow',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (46,'dark purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (47,'orange',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (48,'light green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (140,'black',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (141,'blue',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (142,'red',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (143,'purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (144,'green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (145,'yellow',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (146,'dark purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (147,'orange',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (148,'light green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (240,'black',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (241,'blue',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (242,'red',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (243,'purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (244,'green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (245,'yellow',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (246,'dark purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (247,'orange',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (248,'light green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (340,'black',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (341,'blue',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (342,'red',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (343,'purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (344,'green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (345,'yellow',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (346,'dark purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (347,'orange',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (348,'light green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (440,'black',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (441,'blue',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (442,'red',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (443,'purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (444,'green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (445,'yellow',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (446,'dark purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (447,'orange',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (448,'light green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (540,'black',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (541,'blue',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (542,'red',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (543,'purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (544,'green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (545,'yellow',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (546,'dark purple',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (547,'orange',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (548,'light green',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (60,'¿Õ½Ç5',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (61,'¿Õ½Ç4',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (62,'¿Õ½Ç3',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (63,'¿Õ½Ç2',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (64,'¿Õ½Ç1',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (160,'¿Õ½Ç5',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (161,'¿Õ½Ç4',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (162,'¿Õ½Ç3',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (163,'¿Õ½Ç2',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (164,'¿Õ½Ç1',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (260,'¿Õ½Ç5',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (261,'¿Õ½Ç4',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (262,'¿Õ½Ç3',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (263,'¿Õ½Ç2',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (264,'¿Õ½Ç1',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (360,'¿Õ½Ç5',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (361,'¿Õ½Ç4',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (362,'¿Õ½Ç3',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (363,'¿Õ½Ç2',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (364,'¿Õ½Ç1',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (460,'¿Õ½Ç5',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (461,'¿Õ½Ç4',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (462,'¿Õ½Ç3',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (463,'¿Õ½Ç2',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (464,'¿Õ½Ç1',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (560,'¿Õ½Ç5',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (561,'¿Õ½Ç4',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (562,'¿Õ½Ç3',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (563,'¿Õ½Ç2',200000000,0,1)
INSERT INTO [KNIGHTS_CAPE] Values (564,'¿Õ½Ç1',200000000,0,1)