Query Analyzer Girin..Üstten Db’nizi Seçin .. Kodları yapıştırıp F5 yapın çıkın.!
Oto g1 yapma
Kod:
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 İÇİN
Kod:
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 İÇİN
Kod:
update k_monster
set iexp = iexp*5
CHARIN STATLARINI FULL 255 YAPMAK İÇİN
Kod:
update Userdata set strskill = 'ÿ'where struserid = 'Char Nick'
BİR CHARI GM YAPMAK İÇİN
Kod:
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 İÇİN
Kod:
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 İÇİN
Kod:
UPDATE USERDATA
SET Loyalty = 0
WHERE Authority = 1
BANLANAN OYUNCULARIN NP LERINI 0 LAMAK İÇİN
Kod:
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 İÇİN
Kod:
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)
Kayıtlar
Hiç yorum yok:
Yorum Gönder