Belkİ basİt gelebİlİr ama eksİĞİnİz warsa tÜm kodlar

Oto g1 yapma

Kod:
Kod:
update Knights set Points = '999999'

Tek Kodla Kral Yapma.!

Kod:
Kod:
EXEC KRAL_EKLE CharınADI

Bütün Clanların kOlunu yakma.

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

–İlk 5 Clanı G0 Yapma—

Kod:
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:
Kod:
EXEC ACCOUNT_CHAR_NAME_CHANGE 'ESKICHARADI,'YENICHARADI'

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

Kod:
Kod:
EXEC ACCOUNT_NATION_CHANGE 'HESABINIDSI','IRKNUMARASI'

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

Kod:
Kod:
exec imbacodermystexec otonpsimgesiexec np_iconexec Rank_Knights

1440 pot ve abys bles silmek için ;

Kod:
Kod:
DELETE FROM ITEMWHERE (Num = '379102000')DELETE FROM ITEMWHERE (Num = '379103000')DELETE FROM ITEMWHERE (Num = '379105000')DELETE FROM ITEMWHERE (Num = '379104000')DELETE FROM ITEMWHERE (Num = '379102000')DELETE FROM ITEMWHERE (Num = '379101000')

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

Kod:
Kod:
DELETE itemWHERE num = '389015000'goDELETE itemWHERE num = '389064000'goDELETE itemWHERE num = '910005000'

CHARI FULL EDİT YAPMAK İÇİN

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

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

Kod:
Kod:
truncate table account_chartruncate table currentusertruncate table deleted_userdatatruncate table knightstruncate table knights_ratingtruncate table knights_usertruncate table tb_usertruncate table userdatatruncate 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:
Kod:
declare @location varchar(120)set @location = N'c:KoDBGokhantasci-'+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 = 10declare @backupSetId as intselect @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) endRESTORE VERIFYONLY FROM DISK = @location WITH FILE = @backupSetId, NOUNLOAD, NOREWINDGO

DROPLARI 0 LAMAK İÇİN

Kod:
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:
Kod:
update k_monsterset iexp = iexp*5

CHARIN STATLARINI FULL 255 YAPMAK İÇİN

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

BİR CHARI GM YAPMAK İÇİN

Kod:
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:
Kod:
UPDATE MAGIC_TYPE3SET FirstDamage = 1000WHERE (iNum = 300139)

HOLY WATER I DB DEN KALDIRMAK İÇİN

Kod:
Kod:
Delete from itemwhere num = '379101000'delete from itemwhere num = '379102000'delete from itemwhere num = '379103000'Delete from itemwhere num = '379108000'delete from itemwhere num = '379113000'delete from itemwhere num = '379098000'

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

Kod:
Kod:
UPDATE MAGIC_TYPE3SET FirstDamage = - 10000WHERE (iNum = 109551)UPDATE MAGIC_TYPE3SET FirstDamage = - 10000WHERE (iNum = 110551)UPDATE MAGIC_TYPE3SET FirstDamage = - 10000WHERE (iNum = 209551)

USERLARIN NP LERINI 0 LAMAK İÇİN

Kod: Kod:
UPDATE USERDATASET Loyalty = 0WHERE Authority = 1

BANLANAN OYUNCULARIN NP LERINI 0 LAMAK İÇİN

Kod:
Kod:
UPDATE USERDATASET Loyalty = 0WHERE Authority = 255

OKCULARIN 32K DMG BUGU İÇİN;

Kod:
Kod:
update MAGIC_TYPE2set AddDamagePlus = 1where NeedArrow = 1 or NeedArrow = 3 or NeedArrow = 5

OTO ÜYELİK İÇİN

Kod:
Kod:
CREATE PROCEDURE ACCOUNT_LOGIN@AccountID varchar(21),@Password varchar(13),@nRet smallint OUTPUTASdelete from currentuser where straccountid = @AccountID---Coded By ShellX---declare @cnt BigIntdeclare @nDays smallintselect @nRet = count(straccountid) from tb_user where straccountid = @AccountIDif @nRet = 0begininsert into tb_user (straccountid, strpasswd, strSocNo, idays) values (@AccountID, @password, 1, '6')endselect @cnt = count(straccountid) from currentuserselect @nDays = count(nDays) from PREMIUM_SERVICE where straccountid = @AccountIDif @cnt > 40 and @nDays = '0'beginset @nRet = 0endif @cnt > 40 and @nDays = nullbeginset @nRet = 0endDECLARE @Nation tinyintSET @Nation = 0-- tid login method by samma 2004.02.24DECLARE @pwd varchar(13)SET @pwd = nullSELECT @pwd = strPasswd FROM TB_USER WHERE strAccountID = @AccountIDIF @pwd IS nullBEGINSET @nRet = 0RETURNENDELSE IF @pwd <> @PasswordBEGINSET @nRet = 0RETURNENDSELECT @Nation = bNation FROM ACCOUNT_CHAR WHERE strAccountID = @AccountIDIF @@ROWCOUNT = 0BEGINSET @nRet = 1RETURNENDBEGINSET @nRet = 1RETURNENDBEGINSET @nRet = @Nation+1RETURNENDGO

TÜM CHARLARI MARADONA ATMAK İÇİN;

Kod:
Kod:
update Userdata set zone = '21'

SERVERA USKO PELERIN EKLEMEK İÇİN;

Kod:
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)

Bunlar admin mi yapıyo