Ayın Serverı
DeathKO | v1453 Fire Drake | Official Açılış: 12 HAZİRAN - 21:00 GMT+3
12 gün 5 saat önce açıldı
Server'a Göz At
Symbol - Grade reset, Database sıfırlama, Kral ekleme, Gm komutları
-- Önce 2 Prosedurler ekliyoruz. Diğer Prosedürler ekli zaten.
DECLARE @IsValidCount tinyint
DECLARE @RankName varchar(30)
DECLARE @DifferenceBetweenUser int
SELECT @IsValidCount = Count(*) FROM USER_PERSONAL_RANK
IF @IsValidCount < 200
BEGIN
SET @Index = 1
WHILE @Index < 201
BEGIN
IF @Index = 1
BEGIN
SET @RankName = 'Gold Knight'
END
IF @Index > 1 AND @Index <= 4
BEGIN
SET @RankName = 'Silver Knight'
END
IF @Index > 4 AND @Index <= 9
BEGIN
SET @RankName = 'Mirage Knight'
END
IF @Index > 9 AND @Index <= 25
BEGIN
SET @RankName = 'Shadow Knight'
END
IF @Index > 25 AND @Index <= 100
BEGIN
SET @RankName = 'Mist Knight'
END
IF @Index > 100 AND @Index <= 200
BEGIN
SET @RankName = 'Training Knight'
END
INSERT INTO USER_PERSONAL_RANK (nRank,strPosition,nElmoUP,strElmoUserID,nElmoLoyaltyMonthly,nElmoCheck,nKarusUP,strKarusUserID,nKarusLoyaltyMonthly,nKarusCheck,nSalary) VALUES (@Index,@RankName,0,NULL,0,1000000,0,NULL,0,1000000,1000000)
SET @Index = @Index + 1
END
END
SET @Index = 1
SET @strUserId = NULL
SET @LoyaltyMonthly = 0
DECLARE RANKING_CRS CURSOR FOR
SELECT TOP 200 strUserId,LoyaltyMonthly FROM USERDATA WHERE Nation = 1 AND Authority = 1 ORDER BY LoyaltyMonthly DESC
OPEN RANKING_CRS
FETCH NEXT FROM RANKING_CRS INTO @strUserId,@LoyaltyMonthly
WHILE @@FETCH_STATUS = 0
BEGIN
UPDATE USER_PERSONAL_RANK SET strKarusUserID = @strUserId, nKarusUP = @Index, nKarusLoyaltyMonthly = @LoyaltyMonthly WHERE nRank = @Index
SET @DifferenceBetweenUser = 0
IF @Index = 1
BEGIN
UPDATE USER_PERSONAL_RANK SET nKarusCheck = 0 WHERE nRank = @Index
END
ELSE
BEGIN
SELECT @DifferenceBetweenUser = nKarusLoyaltyMonthly FROM USER_PERSONAL_RANK WHERE nRank = @Index + 1
SET @DifferenceBetweenUser = @LoyaltyMonthly - @DifferenceBetweenUser
UPDATE USER_PERSONAL_RANK SET nKarusCheck = @DifferenceBetweenUser WHERE nRank = @Index + 1
END
SET @Index = @Index + 1
FETCH NEXT FROM RANKING_CRS INTO @strUserId,@LoyaltyMonthly
END
CLOSE RANKING_CRS
DEALLOCATE RANKING_CRS
SET @Index = 1
SET @strUserId = NULL
SET @LoyaltyMonthly = 0
DECLARE RANKING_CRS CURSOR FOR
SELECT TOP 200 strUserId,LoyaltyMonthly FROM USERDATA WHERE Nation = 2 AND Authority = 1 ORDER BY LoyaltyMonthly DESC
OPEN RANKING_CRS
FETCH NEXT FROM RANKING_CRS INTO @strUserId,@LoyaltyMonthly
WHILE @@FETCH_STATUS = 0
BEGIN
UPDATE USER_PERSONAL_RANK SET strElmoUserID = @strUserId, nElmoUP = @Index, nElmoLoyaltyMonthly = @LoyaltyMonthly WHERE nRank = @Index
SET @DifferenceBetweenUser = 0
IF @Index = 1
BEGIN
UPDATE USER_PERSONAL_RANK SET nElmoCheck = 0 WHERE nRank = @Index
END
ELSE
BEGIN
SELECT @DifferenceBetweenUser = nElmoLoyaltyMonthly FROM USER_PERSONAL_RANK WHERE nRank = @Index + 1
SET @DifferenceBetweenUser = @LoyaltyMonthly - @DifferenceBetweenUser
UPDATE USER_PERSONAL_RANK SET nElmoCheck = @DifferenceBetweenUser WHERE nRank = @Index + 1
END
SET @Index = @Index + 1
FETCH NEXT FROM RANKING_CRS INTO @strUserId,@LoyaltyMonthly
END
CLOSE RANKING_CRS
DEALLOCATE RANKING_CRS
UPDATE USER_PERSONAL_RANK SET nSalary = REPLACE(nElmoLoyaltyMonthly - nKarusLoyaltyMonthly,'-','')
COMMIT TRAN
CREATE PROCEDURE OYUNCU_SIRALAMA_Reset
AS
DECLARE @strUserId char(21)
DECLARE @Loyalty int
DECLARE @Knights int
DECLARE @KnightName char(50)
DECLARE @IsValidKnight int
DECLARE @Index smallint
DECLARE @IsValidCount tinyint
DECLARE @RankName varchar(30)
SELECT @IsValidCount = Count(*) FROM USER_KNIGHTS_RANK
IF @IsValidCount < 100
BEGIN
SET @Index = 1
WHILE @Index < 101
BEGIN
IF @Index = 1
BEGIN
SET @RankName = 'Gold Knight'
END
IF @Index > 1 AND @Index <= 4
BEGIN
SET @RankName = 'Silver Knight'
END
IF @Index > 4 AND @Index <= 9
BEGIN
SET @RankName = 'Mirage Knight'
END
IF @Index > 9 AND @Index <= 25
BEGIN
SET @RankName = 'Shadow Knight'
END
IF @Index > 25 AND @Index <= 50
BEGIN
SET @RankName = 'Mist Knight'
END
IF @Index > 50 AND @Index <= 100
BEGIN
SET @RankName = 'Training Knight'
END
INSERT INTO USER_KNIGHTS_RANK (shIndex,strName,strElmoUserID,strElmoKnightsName,nElmoLoyalty,strKarusUserID,strKarusKnightsName,nKarusLoyalty,nMoney) VALUES (@Index,@RankName,NULL,NULL,0,NULL,NULL,0,1000000)
SET @Index = @Index + 1
END
END
SET @Index = 1
SET @strUserId = NULL
SET @Loyalty = 0
SET @Knights = 0
DECLARE RANKING_CRS CURSOR FOR
SELECT TOP 100 strUserId,Loyalty,Knights FROM USERDATA WHERE Nation = 1 AND Authority = 1 ORDER BY Loyalty DESC
OPEN RANKING_CRS
FETCH NEXT FROM RANKING_CRS INTO @strUserId,@Loyalty,@Knights
WHILE @@FETCH_STATUS = 0
BEGIN
SET @KnightName = NULL
SET @IsValidKnight = 0
IF @Knights <> 0
BEGIN
SELECT @IsValidKnight = COUNT(IDName) FROM KNIGHTS WHERE IDNum = @Knights
IF @IsValidKnight <> 0
BEGIN
SELECT @KnightName = IDName FROM KNIGHTS WHERE IDNum = @Knights
END
END
UPDATE USER_KNIGHTS_RANK SET strKarusUserID = @strUserId, strKarusKnightsName = @KnightName, nKarusLoyalty = @Loyalty WHERE shIndex = @Index
SET @Index = @Index + 1
FETCH NEXT FROM RANKING_CRS INTO @strUserId,@Loyalty,@Knights
END
CLOSE RANKING_CRS
DEALLOCATE RANKING_CRS
SET @Index = 1
SET @strUserId = NULL
SET @Loyalty = 0
SET @Knights = 0
DECLARE RANKING_CRS CURSOR FOR
SELECT TOP 100 strUserId,Loyalty,Knights FROM USERDATA WHERE Nation = 2 AND Authority = 1 ORDER BY Loyalty DESC
OPEN RANKING_CRS
FETCH NEXT FROM RANKING_CRS INTO @strUserId,@Loyalty,@Knights
WHILE @@FETCH_STATUS = 0
BEGIN
SET @KnightName = NULL
SET @IsValidKnight = 0
IF @Knights <> 0
BEGIN
SELECT @IsValidKnight = COUNT(IDName) FROM KNIGHTS WHERE IDNum = @Knights
IF @IsValidKnight <> 0
BEGIN
SELECT @KnightName = IDName FROM KNIGHTS WHERE IDNum = @Knights
END
END
UPDATE USER_KNIGHTS_RANK SET strElmoUserID = @strUserId, strElmoKnightsName = @KnightName, nElmoLoyalty = @Loyalty WHERE shIndex = @Index
SET @Index = @Index + 1
FETCH NEXT FROM RANKING_CRS INTO @strUserId,@Loyalty,@Knights
END
CLOSE RANKING_CRS
DEALLOCATE RANKING_CRS
DB Temizleme
truncate table account_char
go
truncate table currentuser
go
truncate table knights
go
truncate table knights_rating
go
truncate table knights_user
go
truncate table tb_user
go
truncate table userdata
go
truncate table warehouse
go
Son olarak aşağıdaki kodları query analyser yapıştırıp f5 yapıyoruz
exec UPDATE_KNIGHTS_RATING
exec UPDATE_USER_KNIGHTS_RANK
exec UPDATE_USER_PERSONAL_RANK
exec OYUNCU_IRK_SIRALAMASI_Reset
exec OYUNCU_SIRALAMA_Reset
exec KRAL_EKLE @CharID=KarusGameMaster ----- "KarusGameMaster" yazan yere kral yapıcağınız kişinin nicki yazılcak.
GM Kodları ve Bazı Komutlar
G (Basılı Tutarsanız Çok Hızlı Bi Şekilde Hareket Edersiniz
+open2 ---------- 2 numaralı savaşı başlatır değerler= 1 - 2 -3 - 4- 5 - 6
+close ---------- Savaşı kapatır.
+exp_add 255% ---------- Exp event başlatır maxdeğer=255
+money_add 255% ---------- Para event başlatır maxdeğer=255
+monsummon 1250 ---------- Boss atar..
+zonechange 21 ---------- Numaralı zoneye gider..
/ATTACKDISABLE Seçtiğiniz Kullanıcıya Atack İzni Vermez
/ATTAKCENABLE Seçtiğiniz Kullanıcıya Atack İzni Verir
/forbidconnect Ahmet ---------- Ahmet İsimli Kullanıcıyı banlar.
/summonuser Ahmet ---------- Kullanıcıyı Yanına Çeker..
/notice Selam ---------- Alttan yazı yazar..
/Noticeall Selam ---------- Üstten yazı yazar..
/time 10 ---------- (0-24)(Oyun saatini ayarlarsınız mesela 24 yapınca gece olur)
---- Zone ----
Lufer -- 1
Elmorad -- 2
Karus Eslant -- 11
Elmorad Eslant -- 12
Maradon -- 21
Battle1 -- 61 64
Battle2 -- 62 65
Battle3 -- 63 66
Andream -- 72
RonarkLandBase -- 73
---- Bifrost Canavarlar ---
Ego -- 5851
Glutton -- 5951
Wratch -- 6051
Sloth -- 6151
Lust -- 6251
Envy -- 6351
Greed -- 6451
---- Juraid Mountain Canavarlar ----
Deva. Bird 8106
---- Bosslar ----
İsiloon -- 5501
Felankor -- 7035
Ultima -- 6551
Volcanic Rock -- 3891
Diğer
Hell Fire -- 8401
Enigma -- 8402
Havoc -- 8403
Cruel -- 8404
Pelerin Görevleri
Caitharos(Görev) -- 2690
İsilonn(Görev) -- 5701
Felankor(Görev) -- 5702
Ebenzer Komutları
/Open2 ---------- 2 numaralı savaşı başlatır değerler= 1 - 2 -3 - 4- 5 - 6
/Close ---------- Savaşı Kapatır.
/kill Ahmet ---------- Nickli oyuncuyu server'dan dc eder.
/captain <-- savas taki kaptani belirler
Orjinal Konu Url : https://www.ko-cuce.net/konular/symbol-grade-reset-database-sifirlama-kral-ekleme-gm-komutlari.10746
Kayıt: 2026
Mesaj: 0
İtibar: 0
Cevap yazabilmek için giriş yapmalısınız.