Knight Paylaşımının adresi

Sizleri Neler Bekliyor ?
-Foruma Üye Olarak Yeni Arkadaşlıklar Edineceksiniz.
-İnternette Zaman Geçirecek Bir Alanınız Olucak Ve Eğleneceksiniz.
-PvP Server Tutkunuysanız Pvp Serverlerde Yenilikleri Takip Ediceksiniz.
-Yeni Açılan Serverleri Anında Bulacaksınız .
-Gmlik Adaylığı Koyacaksınız.Serverinizi Tanıtacaksınız.
-Pvp Serverler Hakkında Herşey Bu Forumda Olucak.
-ÜYE OLURSANIZ FORUMDAKİ REKLAMLAR GÖZÜKMEZ
Bunlardan Yararlanmak İçin Sizden Tek İsteyimiz Üye Olmanız Yada Giriş Yapmanız.

Knight Paylaşımının adresi

Pvp Tanıtım,PvP Serverler
 
AnasayfaTakvimSSSAramaKayıt OlGiriş yap

Paylaş | 
 

 1299 Butun QA kodLari

Önceki başlık Sonraki başlık Aşağa gitmek 
YazarMesaj
LeGenD
Kurucu
Kurucu


Erkek Mesaj Sayısı : 255
Rep : 2360
Doğum tarihi : 15/04/88
Kayıt tarihi : 14/11/09
Yaş : 28

MesajKonu: 1299 Butun QA kodLari   Çarş. Kas. 18, 2009 4:20 pm

KraL Ekleme

PHP- Kodu:
EXEC KRAL_EKLE CharınADI

Oto G1 Yapma

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

İlk 5 cLan g0 yapma

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

Res Kodu

PHP- Kodu:
exec imbacodermyst
exec otonpsimgesi
exec np_icon
exec Rank_Knights

1440 Pot ve Abys bles silmek icin

PHP- Kodu:
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')


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


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.



+9]-[+10] İtemleri Silmek


PHP- Kodu:
DELETE from ITEM
WHERE strName LIKE '%+9%'
DELETE from ITEM
WHERE strName LIKE %+10%


1-74 LeveLLeri Clana Almamak


PHP- Kodu:
update userdata set Knights = '0'where Level = '1'





50 Görevini DB'den Kaldırmak



PHP- Kodu:
delete from K_NPCPOS where NpcID = '16051'
delete from K_NPCPOS where NpcID = '16052'
delete from K_NPCPOS where NpcID = '16053'
delete from K_NPCPOS where NpcID = '16054'
delete from K_NPCPOS where NpcID = '16055'
delete from K_NPCPOS where NpcID = '16056'
delete from K_NPCPOS where NpcID = '16057'


74 LeveL ve İtemli Başlamayı Kaldırmak

Öncelikle Tables kısmında baslangic tablosunu siliyoruz, Stored Procedures kısmında baslangicitem prosedürünü siliyoruz.
Stored Procedures kısmında LOAD_USER_DATA'ya çift tıklıyoruz ve aşağıdaki kodu bulup siliyoruz:


PHP- Kodu:
DECLARE @itemaldimi int
select @itemaldimi = [level] FROM USERDATA WHERE StrUserID = @id
if @itemaldimi = '1'
begin
exec baslangicitem @id
update userdata set [level] = '74' ,[strSkill] = '<<<<<<<<<<', [Points] = '255' where strUserID = @id
end

Aynı ID İle Tekrar Girmeme Sorunu (Çözüm)


PHP- Kodu:
CREATE PROCEDURE ACCOUNT_LOGIN
-- Edit Voix
@AccountID varchar(21),
@Password varchar(13),
@nRet smallint OUTPUT
AS

select @nRet=count(*) from tb_user where straccountid=@AccountID
if @nRet=0
begin
insert into tb_user values (@AccountID , @Password , 1 , 6 , 1 ,1)
set @nRet=1
RETURN
end

DECLARE @tahsin tinyint, @myko smallint, @account int, @login int , @procedure int
SET @tahsin = 0
SET @myko = 0
DECLARE @pwd varchar(13)
SET @pwd = null
IF @pwd <> @Password
BEGIN
SET @nRet = 3
RETURN
END
IF @login=0
begin
set @nRet=11
RETURN
end
IF @account = 0
begin
set @nRet=12
RETURN
end
IF @procedure=0
begin
set @nRet=4
RETURN
end
select @nRet=count(*) from currentuser where straccountid=@AccountID
IF @nRet>0
begin
set @nRet=5
RETURN
end

SELECT @tahsin = bNation, @myko = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
IF @@ROWCOUNT = 0
BEGIN
SET @nRet = 1
RETURN
END
IF @myko = 0
BEGIN
SET @nRet = 1
RETURN
END
ELSE
BEGIN
SET @nRet = 1
RETURN
END
GO

Bayrak Ve Cadılar Bayramı İtemleri ekle[Flag]


PHP- Kodu:
insert into [ITEM] Values (135820000,'Turkish Flag',97,0,0,0,0,109,0,1,20000,10000,0,0,0,0,0,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
insert into [ITEM] Values (135830000,'American Flag',97,0,0,0,0,109,0,1,20000,10000,0,0,0,0,0,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
insert into [ITEM] Values (135840000,'Canadian Flag',97,0,0,0,0,109,0,1,20000,10000,0,0,0,0,0,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
insert into [ITEM] Values (135850000,'German Flag',97,0,0,0,0,109,0,1,20000,10000,0,0,0,0,0,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
insert into [ITEM] Values (135860000,'Danish Flag',97,0,0,0,0,109,0,1,20000,10000,0,0,0,0,0,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
insert into [ITEM] Values (135870000,'Polish Flag',97,0,0,0,0,109,0,1,20000,10000,0,0,0,0,0,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
insert into [ITEM] Values (135880000,'Korean Flag',97,0,0,0,0,109,0,1,20000,10000,0,0,0,0,0,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
insert into [ITEM] Values (135890000,'Chinese Flag',97,0,0,0,0,109,0,1,20000,10000,0,0,0,0,0,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
insert into [ITEM] Values (135900000,'Japanese Flag',97,0,0,0,0,109,0,1,20000,10000,0,0,0,0,0,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
insert into [ITEM] Values (379199000,'Lantern',41,0,0,0,10,150,10,50,4000,10000,0,0,0,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
insert into [ITEM] Values (191610316,'Halloween Spear',51,0,0,0,1,200,10,10,5000,100,0,0,0,0,0,0,100,0,0,0,0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
insert into [ITEM] Values (191600881,'Halloween Cane',110,0,0,0,1,200,10,10,5000,100,0,0,0,0,0,0,100,0,0,0,0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)


Bowl Lari KaLdiR


PHP- Kodu:
delete from item where strname like '%bow%'

Bütün İtemlerin Ağırlık İstememesi


PHP- Kodu:
update ITEM set Weight = '0'

Char Tahttan Kalkmıyor Diyenler için Sql Scripti (1098)


PHP- Kodu:
insert into [ZONE_INFO] Values ('1','101','battle_0516.smd','15000','15000','1500 0','2','101','Dark Lunar')
insert into [ZONE_INFO] Values ('1','102','battle_0516.smd','15000','15000','1500 0','2','0','BATTLE_ZONE???')
insert into [ZONE_INFO] Values ('1','201','free_0810.smd','15000','15000','15000' ,'2','0','Colony Zone')
update ZONE_INFO set ServerNo = 1



Christmas Tree Eklemek


PHP- Kodu:
INSERT INTO [K_MONSTER] Values (4001,'Christmas tree',25003,20,0,0,0,5,2,40,0,0,0,30,0,0,400,5492,1,720,28,69,249,1500,4,4,3000,0,0,0,178,178,178,178,178,178,178,250,5,15,45,373,4001,0,0,0
INSERT INTO [K_NPCPOS] Values (21,4001,1,0,0,0,0,263,161,263,161,263,161,263,161,1,40,0,0,NULL)
INSERT INTO [K_NPCPOS] Values (21,4001,1,0,0,0,0,239,116,239,116,239,116,239,116,1,40,0,0,NULL)
INSERT INTO [K_NPCPOS] Values (21,4001,1,0,0,0,0,276,84,276,84,276,84,276,84,1,40,0,0,NULL)
INSERT INTO [K_NPCPOS] Values (21,4001,1,0,0,0,0,321,70,321,70,321,70,321,70,1,40,0,0,NULL)
INSERT INTO [K_NPCPOS] Values (21,4001,1,0,0,0,0,387,63,387,63,387,63,387,63,1,40,0,0,NULL)
INSERT INTO [K_NPCPOS] Values (21,4001,1,0,0,0,0,440,80,440,80,440,80,440,80,1,40,0,0,NULL)
INSERT INTO [K_NPCPOS] Values (21,4001,1,0,0,0,0,470,140,470,140,470,140,470,140,1,40,0,0,NULL)
INSERT INTO [K_NPCPOS] Values (21,4001,1,0,0,0,0,419,185,419,185,419,185,419,185,1,40,0,0,NULL)
INSERT INTO [K_NPCPOS] Values (21,4001,1,0,0,0,0,247,299,247,299,247,299,247,299,1,40,0,0,NULL)
INSERT INTO [K_NPCPOS] Values (21,4001,1,0,0,0,0,331,163,331,163,331,163,331,163,1,40,0,0,NULL)
INSERT INTO [K_NPCPOS] Values (21,4001,1,0,0,0,0,369,123,369,123,369,123,369,123,1,40,0,0,NULL)


CZ den Çıkanları Kendi Ülkelerine Işınlama


PHP- Kodu:
CREATE PROCEDURE MAINLAND
AS
BEGIN
-- El Morad'lar için
update USERDATA set Zone = '2', PX = '159609', PZ = '42089', PY= '1569' where Zone = '201' and Nation = '2'
-- Karus'lar için
update USERDATA set Zone = '1', PX = '44600', PZ = '163100', PY = '1240' where Zone = '201' and Nation = '1'
END
GO

Query Analyzer'a yapıştırıp üstten DB'nizi seçin ve F5'e basın.
Stored Procedures kısmında ACCOUNT_LOGOUT ve ACCOUNT_LOGOUT2 (varsa) şu kodu GO'dan önce ekleyin:

exec MAINLAND

Databaseden İtem Sil


PHP- Kodu:
Delete from item where num = 'İtem Kodu'


DB'ye Ardream TowerLarı ve NPC'sini EkLemek.txt


PHP- Kodu:
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 16096, 140, 0, 0, 0, 0, 193, 910, 193, 910, 193, 910, 193, 910, 1, 90, 0, 0, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 5300, 104, 0, 0, 0, 0, 161, 894, 161, 894, 161, 894, 161, 894, 1, 90, 0, 0, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 5300, 104, 0, 0, 0, 0, 149, 914, 149, 914, 149, 914, 149, 914, 1, 90, 0, 0, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 5300, 104, 0, 0, 0, 0, 113, 883, 113, 883, 113, 883, 113, 883, 1, 90, 0, 0, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 5300, 104, 0, 0, 0, 0, 222, 900, 222, 900, 222, 900, 222, 900, 1, 90, 0, 0, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 5300, 104, 0, 0, 0, 0, 219, 913, 219, 913, 219, 913, 219, 913, 1, 90, 0, 0, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 5300, 104, 0, 0, 0, 0, 138, 870, 138, 870, 138, 870, 138, 870, 1, 90, 0, 0, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 5300, 104, 0, 0, 0, 0, 213, 872, 213, 872, 213, 872, 213, 872, 1, 90, 0, 0, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 5300, 104, 0, 0, 0, 0, 193, 871, 193, 871, 193, 871, 193, 871, 1, 90, 0, 0, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 5300, 104, 0, 0, 0, 0, 182, 873, 182, 873, 182, 873, 182, 873, 1, 90, 0, 0, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 12120, 140, 0, 0, 0, 0, 187, 910, 187, 910, 187, 910, 187, 910, 1, 90, 0, 0, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 5400, 104, 0, 0, 0, 0, 788, 82, 788, 82, 788, 82, 788, 82, 1, 90, 0, 0, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 5400, 104, 0, 0, 0, 0, 799, 130, 799, 130, 799, 130, 799, 130, 1, 90, 0, 0, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 5400, 104, 0, 0, 0, 0, 785, 115, 785, 115, 785, 115, 785, 115, 1, 90, 0, 0, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 5400, 104, 0, 0, 0, 0, 803, 113, 803, 113, 803, 113, 803, 113, 1, 90, 0, 0, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 5400, 104, 0, 0, 0, 0, 821, 150, 821, 150, 821, 150, 821, 150, 1, 90, 0, 0, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 5400, 104, 0, 0, 0, 0, 831, 161, 831, 161, 831, 161, 831, 161, 1, 90, 0, 0, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 5400, 104, 0, 0, 0, 0, 848, 154, 848, 154, 848, 154, 848, 154, 1, 90, 0, 0, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 5400, 104, 0, 0, 0, 0, 871, 148, 871, 148, 871, 148, 871, 148, 1, 90, 0, 0, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 22120, 140, 0, 0,0, 0, 855, 137, 855, 137, 855, 137, 855, 137, 1, 90, 0, 0, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 16096, 140, 0, 0, 0, 0, 850, 132, 850, 132, 850, 132, 850, 132, 1, 90, 0, 0, '' );

Delosa Clan Bayrağı Ekle


PHP- Kodu:
select idnum from knights where idname = 'ClanAdı'

Drop Eklemek ( X=İtem Y=Oran Z=Monster Ssid )


PHP- Kodu:
nsert into [K_MONSTER_ITEM] values (Z,0,0,0,0,X,Y,X,Y,X,Y)


Drop Sıfırla


PHP- Kodu:
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'

Tum Userlere 21 gb Verme


PHP- Kodu:
update userdata set gold = '2100000000'

Irk Seçme Ekranında Fixed Kod


PHP- Kodu:
insert into [ZONE_INFO] Values ('1','101','battle_0516.smd','15000','15000','15000','2','101','Dark Lunar')
insert into [ZONE_INFO] Values ('1','102','battle_0516.smd','15000','15000','15000','2','0','BATTLE_ZONE???')
insert into [ZONE_INFO] Values ('1','201','free_0810.smd','15000','15000','15000','2','0','Colony Zone')
update ZONE_INFO set ServerNo = '1'

İron Neck Gibi Defans Veren Takıları Kaldır


PHP- Kodu:
DELETE FROM ITEMEXT13 WHERE (dwID > 40) AND (dwID < 51)
DELETE FROM ITEMEXT13 WHERE (dwID > 70) AND (dwID < 81)
DELETE FROM ITEMEXT13 WHERE (dwID > 303) AND (dwID < 310)
DELETE FROM ITEMEXT13 WHERE (dwID > 312) AND (dwID < 319)
DELETE FROM ITEMEXT13 WHERE (dwID > 321) AND (dwID < 328)
DELETE FROM ITEMEXT13 WHERE (dwID > 330) AND (dwID < 337)
DELETE FROM ITEMEXT13 WHERE (dwID > 540) AND (dwID < 551)
DELETE FROM ITEMEXT14 WHERE (dwID > 40) AND (dwID < 51)
DELETE FROM ITEMEXT14 WHERE (dwID > 70) AND (dwID < 81)
DELETE FROM ITEMEXT14 WHERE (dwID > 303) AND (dwID < 310)
DELETE FROM ITEMEXT14 WHERE (dwID > 312) AND (dwID < 319)
DELETE FROM ITEMEXT14 WHERE (dwID > 321) AND (dwID < 328)
DELETE FROM ITEMEXT14 WHERE (dwID > 330) AND (dwID < 337)
DELETE FROM ITEMEXT14 WHERE (dwID > 540) AND (dwID < 551)
DELETE FROM ITEMEXT15 WHERE (dwID > 40) AND (dwID < 51)
DELETE FROM ITEMEXT15 WHERE (dwID > 70) AND (dwID < 81)
DELETE FROM ITEMEXT15 WHERE (dwID > 303) AND (dwID < 310)
DELETE FROM ITEMEXT15 WHERE (dwID > 312) AND (dwID < 319)
DELETE FROM ITEMEXT15 WHERE (dwID > 321) AND (dwID < 328)
DELETE FROM ITEMEXT15 WHERE (dwID > 330) AND (dwID < 337)
DELETE FROM ITEMEXT15 WHERE (dwID > 540) AND (dwID < 551)
DELETE FROM ITEMEXT16 WHERE (dwID > 40) AND (dwID < 51)
DELETE FROM ITEMEXT16 WHERE (dwID > 70) AND (dwID < 81)
DELETE FROM ITEMEXT16 WHERE (dwID > 303) AND (dwID < 310)
DELETE FROM ITEMEXT16 WHERE (dwID > 312) AND (dwID < 319)
DELETE FROM ITEMEXT16 WHERE (dwID > 321) AND (dwID < 328)
DELETE FROM ITEMEXT16 WHERE (dwID > 330) AND (dwID < 337)
DELETE FROM ITEMEXT16 WHERE (dwID > 540) AND (dwID < 551)
DELETE FROM ITEMEXT17 WHERE (dwID > 40) AND (dwID < 51)
DELETE FROM ITEMEXT17 WHERE (dwID > 70) AND (dwID < 81)
DELETE FROM ITEMEXT17 WHERE (dwID > 303) AND (dwID < 310)
DELETE FROM ITEMEXT17 WHERE (dwID > 312) AND (dwID < 319)
DELETE FROM ITEMEXT17 WHERE (dwID > 321) AND (dwID < 328)
DELETE FROM ITEMEXT17 WHERE (dwID > 330) AND (dwID < 337)
DELETE FROM ITEMEXT17 WHERE (dwID > 540) AND (dwID < 551)


Kullanıcının Account tunun İtemlerini Silme



PHP- Kodu:
UPDATE warehouse SET WareHouseData = '' WHERE strAccountID = 'Hesap Adı'


İtemin Basılmasını Engelle



PHP- Kodu:
update ITEM set ReqTitle = '100' , ReqLevel = '81', ReqRank = '1' where Num = 'İtem Kodu'


Userlere Np Ekleme


PHP- Kodu:
UPDATE USERDATA SET Loyalty = Loyalty + Sayı

Mage Riote


PHP- Kodu:
insert into k_monster values (8931 , 'Ultra Riote' , 1310 , 140 , 131510000 , 0 , 0 , 1 , 0 , 13 , 0 , 0 , 0 , 70 , 45690 , 7500 , 350931 , 8527 , 0 , 2000 , 165 , 822 , 3000 , 7500 , 2 , 8 , 5000 , 6914 , 110571 , 110571 , 110571 , 300 , 300 , 300 , 300 , 300 , 300 , 300 , 200 , 5 , 10 , 45 , 95097 , 0 , 0 , 0)


Boss atma kodu +monsummon 8931


Okcu 32 K Bugu


PHP- Kodu:
update MAGIC_TYPE2 set AddDamagePlus = 1 where NeedArrow = 1 or NeedArrow = 3 or NeedArrow = 5


Ke Orjinal Lwl Up Oranı Yapma



PHP- Kodu:
LEVEL_UP tablosunu boşaltalım

TRUNCATE TABLE LEVEL_UP

Ardından şu kodları Query Analyzer'a yazıp F5'e basın

INSERT INTO LEVEL_UP VALUES (1, 50)
INSERT INTO LEVEL_UP VALUES (2, 100)
INSERT INTO LEVEL_UP VALUES (3, 190)
INSERT INTO LEVEL_UP VALUES (4, 342)
INSERT INTO LEVEL_UP VALUES (5, 581)
INSERT INTO LEVEL_UP VALUES (6, 929)
INSERT INTO LEVEL_UP VALUES (7, 1393)
INSERT INTO LEVEL_UP VALUES (8, 1950)
INSERT INTO LEVEL_UP VALUES (9, 2535)
INSERT INTO LEVEL_UP VALUES (10, 5070)
INSERT INTO LEVEL_UP VALUES (11, 6084)
INSERT INTO LEVEL_UP VALUES (12, 7300)
INSERT INTO LEVEL_UP VALUES (13, 8760)
INSERT INTO LEVEL_UP VALUES (14, 10512)
INSERT INTO LEVEL_UP VALUES (15, 12614)
INSERT INTO LEVEL_UP VALUES (16, 15136)
INSERT INTO LEVEL_UP VALUES (17, 18163)
INSERT INTO LEVEL_UP VALUES (18, 21795)
INSERT INTO LEVEL_UP VALUES (19, 26154)
INSERT INTO LEVEL_UP VALUES (20, 52308)
INSERT INTO LEVEL_UP VALUES (21, 60154)
INSERT INTO LEVEL_UP VALUES (22, 69177)
INSERT INTO LEVEL_UP VALUES (23, 79553)
INSERT INTO LEVEL_UP VALUES (24, 91485)
INSERT INTO LEVEL_UP VALUES (25, 105207)
INSERT INTO LEVEL_UP VALUES (26, 120988)
INSERT INTO LEVEL_UP VALUES (27, 139136)
INSERT INTO LEVEL_UP VALUES (28, 160006)
INSERT INTO LEVEL_UP VALUES (29, 184006)
INSERT INTO LEVEL_UP VALUES (30, 368012)
INSERT INTO LEVEL_UP VALUES (31, 404813)
INSERT INTO LEVEL_UP VALUES (32, 445294)
INSERT INTO LEVEL_UP VALUES (33, 489823)
INSERT INTO LEVEL_UP VALUES (34, 538805)
INSERT INTO LEVEL_UP VALUES (35, 808207)
INSERT INTO LEVEL_UP VALUES (36, 889027)
INSERT INTO LEVEL_UP VALUES (37, 977929)
INSERT INTO LEVEL_UP VALUES (38, 1075721)
INSERT INTO LEVEL_UP VALUES (39, 1183293)
INSERT INTO LEVEL_UP VALUES (40, 2366586)
INSERT INTO LEVEL_UP VALUES (41, 2603244)
INSERT INTO LEVEL_UP VALUES (42, 2863568)
INSERT INTO LEVEL_UP VALUES (43, 3149924)
INSERT INTO LEVEL_UP VALUES (44, 3464916)
INSERT INTO LEVEL_UP VALUES (45, 5197374)
INSERT INTO LEVEL_UP VALUES (46, 5717111)
INSERT INTO LEVEL_UP VALUES (47, 6288822)
INSERT INTO LEVEL_UP VALUES (48, 6917704)
INSERT INTO LEVEL_UP VALUES (49, 7609474)
INSERT INTO LEVEL_UP VALUES (50, 15218948)
INSERT INTO LEVEL_UP VALUES (51, 16740842)
INSERT INTO LEVEL_UP VALUES (52, 18414926)
INSERT INTO LEVEL_UP VALUES (53, 20256418)
INSERT INTO LEVEL_UP VALUES (54, 22282059)
INSERT INTO LEVEL_UP VALUES (55, 33423088)
INSERT INTO LEVEL_UP VALUES (56, 36765396)
INSERT INTO LEVEL_UP VALUES (57, 40441935)
INSERT INTO LEVEL_UP VALUES (58, 44486128)
INSERT INTO LEVEL_UP VALUES (59, 48934740)
INSERT INTO LEVEL_UP VALUES (60, 73402110)
INSERT INTO LEVEL_UP VALUES (61, 132123798)
INSERT INTO LEVEL_UP VALUES (62, 145336177)
INSERT INTO LEVEL_UP VALUES (63, 159869794)
INSERT INTO LEVEL_UP VALUES (64, 175856773)
INSERT INTO LEVEL_UP VALUES (65, 193442450)
INSERT INTO LEVEL_UP VALUES (66, 212786695)
INSERT INTO LEVEL_UP VALUES (67, 234065364)
INSERT INTO LEVEL_UP VALUES (68, 257471900)
INSERT INTO LEVEL_UP VALUES (69, 283219090)
INSERT INTO LEVEL_UP VALUES (70, 2100000000)

Oto Üyeliği Kaldırma



PHP- Kodu:
Login' e Girip
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
bunu kaldır


Para Ekleme Sistemi


PHP- Kodu:
exec paraekle 'Char ADI ' , 'Para Miktarı'
Create Procedure paraekle
@userid varchar,
@para int
as
update userdata set gold = @para where struserid = @userid
GO


Server Pelerin Atına Girişi Kapatma


PHP- Kodu:
delete zone_info where zoneno = '54'




Rague 75 skill Bug Fixi


PHP- Kodu:
update MAGIC_TYPE2
set AddDamagePlus = 1
where NeedArrow = 1 or NeedArrow = 3 or NeedArrow = 5

Santa Ekle


PHP- Kodu:
INSERT INTO [K_MONSTER] Values(27577,'Cursed Santa',2700,550,0,0,0,5,2,27,0,0,0,70,10000000,0,500000,0,492,200,720,28,69,249,0,0,10,3000,0,0,0,178,178,178,178,178,178,250,5,15,45,19401,2701,0,0,0)

Seri Scroll Engellemek (255 Sn ye geçtikten sonra tekrar basılabilir)


PHP- Kodu:
update MAGIC set ReCastTime= '255'
where MagicNum = 'Scroll Kodu'


Servera Delos Ekleme


PHP- Kodu:
insert into [K_WARPINFO] Values (21,316,'Delos','Delos Desert',5000,30,529,5,253,5) insert into [K_WARPINFO] Values (21,416,'Delos','Delos Desert',5000,30,529,5,253,5) insert into [K_WARPINFO] Values (30,321,'Moradon','Delos Desert',0,21,315,0,400,10) insert into [K_WARPINFO] Values (30,301,'Moradon','Delos Desert',0,21,315,0,400,10) insert into [K_OBJECTEVENT] Values (30,4030,1,0,5,30,1,650,0,650) insert into [K_OBJECTEVENT] Values (30,4031,1,0,5,32,1,550,0,255) insert into [EVENT] Values (30,2001,0,1,1,1,1,1,32,50,30,1,1) insert into [ZONE_INFO] Values (2,30,elmorad_1212.


Pot Mana Sınırsız Yapma



PHP- Kodu:
Sınırsız 720 Hp Pot
update magic set useitem='0' where useitem='389014000'
Sınırsız 1920 Mana Pot
update magic set useitem='0' where useitem=389082000



Clan Kollugunu Yakma(Tek Clan)



PHP- Kodu:
update Knights set Ranking = '1'where IDName = 'Clan Adı'




Uniqe itemlerin storedaki fıyatını arttırma.



PHP- Kodu:
update item_basic
SET iPriceSale = 2150000000
WHERE (bySellGroup = 0)

Butun Charların Np Sıfırlama


PHP- Kodu:
UPDATE USERDATA
SET Loyalty = 0
WHERE Authority = 1


Char Banlanınca Id Banlama


PHP- Kodu:
Hemen ACCOUNT_LOGIN prosedürünü acın sonra aşağıdaki kodu bulun..
1 - 2 Satır altına bunu ekleyin

CREATE PROCEDURE ACCOUNT_LOGIN
@AccountID varchar(21),
@Password varchar(13),
@nRet smallint OUTPUT
AS

-----------------
1 - 2 Satır altına bunu ekleyin:


*/
declare @ban int , @ban1 int, @ban2 int
select @nRet = count(straccountid) from currentuser
select @ban = authority from userdata where struserid = (select strcharid1 from account_char where straccountid = @AccountID and strcharid1 is not null )
select @ban1 = authority from userdata where struserid = (select strcharid2 from account_char where straccountid = @AccountID and strcharid1 is not null )
select @ban2 = authority from userdata where struserid = (select strcharid3 from account_char where straccountid = @AccountID and strcharid1 is not null )
if @ban = 255 or @ban1 = 255 or @ban2 = 255
begin
Set @nRet = 4
RETURN
end

Keeper KEsınce Isınlanma Sorunu


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

Warder KEsınce Savası Kaybetmeme


PHP- Kodu:
DELETE
FROM K_NPC
WHERE (strName = 'warder 1') OR
(strName = 'warder 2') OR
(strName = 'keeper')
DELETE
FROM K_NPCPOS
WHERE (ZoneID = 102) AND (NpcID = 21045) OR
(ZoneID = 102) AND (NpcID = 21041) OR
(ZoneID = 102) AND (NpcID = 21042) OR
(ZoneID = 102) AND (NpcID = 11041) OR
(ZoneID = 102) AND (NpcID = 11042) OR
(ZoneID = 102) AND (NpcID = 11047)

Her Irktan Giren İlk 5 Toplamda 10 Kişiyi At Yapmak!


PHP- Kodu:
Update_User_Datayı Açın Ve İçinde Arayın
WHERE strUserId = @id
Altına Ekleyin

DECLARE @Neo
Select @Neo = Count(*) From USERDATA Where Zone = @Zone
IF @Zone = 102 and @Nation = 1 and @Neo < 6
BEGIN
Exec WAR_CAPITAN @id , '1'
END
ELSE IF @Zone = 102 and @Nation = 2 and @Neo < 6
BEGIN
Exec WAR_CAPITAN @id , '1'
END

Kill The Gm Event


PHP- Kodu:
UPDATE USERDATA
SET Authority = 9
WHERE strUserId = [NİCK]

Tower Damage Arttırma


PHP- Kodu:
UPDATE MAGIC_TYPE3
SET FirstDamage = - 10000
WHERE (iNum = 300139)


Ordaki -10000 towerlarin 1000 - 2000 vurmasini saglar.
Kendinize göre editleyebilirsiniz.


Giriş Id sini Değiştirme


PHP- Kodu:
CREATE Procedure AccChange
@OldAcc varchar(50),
@NewAcc varchar(50)
as
update tb_user set straccountid = @NewAcc where straccountid = @OldAcc
update account_char set straccountid = @NewAcc where straccountid = @OldAcc
print 'Degistirilen Hesap : ' + @OldAcc
print 'Yeni Hesabiniz : ' + @NewAcc
print 'Başarıyla değiştirildi'
GO

Kullanım:
exec AccChange 'hesap adi' , 'yeni hesap adi'


Sh cileri Oyuna Almama


PHP- Kodu:
aşağıdaki kodu LOAD_USER_DATA da
SET @nRet = @@RowCount
altına ekleyin ve speed hack kullananları oyuna almayın!

Kod:
DECLARE @speedhack varchar(250)
select @speedhack = strHackToolName from HACKTOOL_USERLOG where strCharID = @id
if @speedhack='Something that resembles Speedhack has been detected on this PC. (Code = 10303)'
begin
Set @nRet = 0
end


Aynı Id Ile Tekrar Girememe Sorunu


PHP- Kodu:
CREATE PROCEDURE ACCOUNT_LOGIN
-- Edit Voix
@AccountID varchar(21),
@Password varchar(13),
@nRet smallint OUTPUT
AS

select @nRet=count(*) from tb_user where straccountid=@AccountID
if @nRet=0
begin
insert into tb_user values (@AccountID , @Password , 1 , 6 , 1 ,1)
set @nRet=1
RETURN
end

DECLARE @tahsin tinyint, @myko smallint, @account int, @login int , @procedure int
SET @tahsin = 0
SET @myko = 0
DECLARE @pwd varchar(13)
SET @pwd = null
IF @pwd <> @Password
BEGIN
SET @nRet = 3
RETURN
END
IF @login=0
begin
set @nRet=11
RETURN
end
IF @account = 0
begin
set @nRet=12
RETURN
end
IF @procedure=0
begin
set @nRet=4
RETURN
end
select @nRet=count(*) from currentuser where straccountid=@AccountID
IF @nRet>0
begin
set @nRet=5
RETURN
end

SELECT @tahsin = bNation, @myko = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
IF @@ROWCOUNT = 0
BEGIN
SET @nRet = 1
RETURN
END
IF @myko = 0
BEGIN
SET @nRet = 1
RETURN
END
ELSE
BEGIN
SET @nRet = 1
RETURN
END
GO

Banlananların Npsını Otomatık Sılme


PHP- Kodu:
Update userdata set Level = '0' ,Gold = '31' ,Zone = '21', Dex = '0', Sta= '0',Strong = '0' ,Cha = '0' ,Intel = '0' ,loyaltyMonthly = '0' ,Loyalty = '0' ,Knights = '0' where Authority = '255'

Gm Yapınca Starların Vs. Otomatık Ayarlanması

[PHP]Update userdata set Level = '80' ,Gold = '21000000000' ,Zone = '21', Dex = '255', Sta= '255',Strong = '255' ,Cha = '255' ,Intel = '255' ,loyaltyMonthly = '1' ,Loyalty = '1' ,Knights = '0' where Authority = '0'[/
PHP]


Andream Monsterleri


PHP- Kodu:
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 2023, 1, 0, 0, 0, 0, 369, 489, 489, 509, 0, 0, 0, 0, 5, 40, 0, 2, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 2021, 1, 0, 0, 0, 0, 527, 644, 538, 679, 0, 0, 0, 0, 5, 40, 0, 2, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 2021, 1, 0, 0, 0, 0, 504, 619, 524, 639, 0, 0, 0, 0, 5, 40, 0, 2, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 1821, 1, 0, 0, 0, 0, 590, 721, 610, 742, 0, 0, 0, 0, 5, 40, 0, 2, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 1821, 1, 0, 0, 0, 0, 575, 689, 589, 710, 0, 0, 0, 0, 5, 40, 0, 2, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 1821, 1, 0, 0, 0, 0, 606, 688, 626, 710, 0, 0, 0, 0, 5, 40, 0, 2, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 1901, 1, 0, 0, 0, 0, 633, 659, 653, 679, 0, 0, 0, 0, 5, 40, 0, 2, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 1901, 1, 0, 0, 0, 0, 632, 620, 649, 639, 0, 0, 0, 0, 5, 40, 0, 2, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 1901, 1, 0, 0, 0, 0, 618, 630, 638, 650, 0, 0, 0, 0, 5, 40, 0, 2, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 1823, 1, 0, 0, 0, 0, 580, 621, 599, 642, 0, 0, 0, 0, 5, 40, 0, 2, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 1823, 1, 0, 0, 0, 0, 603, 606, 628, 626, 0, 0, 0, 0, 5, 40, 0, 2, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 1696, 1, 0, 0, 0, 0, 437, 571, 451, 591, 0, 0, 0, 0, 5, 40, 0, 2, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 1696, 1, 0, 0, 0, 0, 410, 570, 426, 592, 0, 0, 0, 0, 5, 40, 0, 2, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 1696, 1, 0, 0, 0, 0, 401, 597, 412, 619, 0, 0, 0, 0, 3, 40, 0, 2, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 1744, 1, 0, 0, 0, 0, 427, 628, 442, 643, 0, 0, 0, 0, 5, 40, 0, 2, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 1744, 1, 0, 0, 0, 0, 486, 652, 512, 673, 0, 0, 0, 0, 5, 40, 0, 2, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 1743, 1, 0, 0, 0, 0, 384, 726, 410, 742, 0, 0, 0, 0, 5, 40, 0, 2, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 1743, 1, 0, 0, 0, 0, 414, 700, 436, 721, 0, 0, 0, 0, 5, 40, 0, 2, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 1743, 1, 0, 0, 0, 0, 439, 729, 461, 749, 0, 0, 0, 0, 5, 40, 0, 2, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 1742, 1, 0, 0, 0, 0, 315, 646, 335, 666, 0, 0, 0, 0, 5, 40, 0, 2, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 1742, 1, 0, 0, 0, 0, 359, 640, 372, 662, 0, 0, 0, 0, 5, 40, 0, 2, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 1742, 1, 0, 0, 0, 0, 375, 669, 389, 681, 0, 0, 0, 0, 5, 40, 0, 2, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 1695, 1, 0, 0, 0, 0, 561, 454, 571, 474, 0, 0, 0, 0, 4, 40, 0, 2, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 1695, 1, 0, 0, 0, 0, 562, 425, 579, 442, 0, 0, 0, 0, 4, 40, 0, 2, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 6924, 1, 1, 0, 0, 0, 651, 128, 653, 126, 0, 0, 0, 0, 5, 40, 0, 2, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 503, 1, 1, 0, 0, 0, 573, 150, 575, 148, 0, 0, 0, 0, 5, 40, 0, 2, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 1210, 1, 1, 0, 0, 0, 463, 161, 465, 159, 0, 0, 0, 0, 5, 40, 0, 2, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 1211, 1, 1, 0, 0, 0, 391, 93, 393, 91, 0, 0, 0, 0, 5, 40, 0, 2, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 2451, 1, 1, 0, 0, 0, 327, 171, 329, 169, 0, 0, 0, 0, 5, 40, 0, 2, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 1310, 1, 1, 0, 0, 0, 245, 223, 247, 221, 0, 0, 0, 0, 5, 40, 0, 2, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 609, 1, 1, 0, 0, 0, 230, 331, 232, 329, 0, 0, 0, 0, 5, 40, 0, 2, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 202, 1701, 1, 1, 0, 0, 0, 122, 304, 120, 302, 0, 0, 0, 0, 5, 40, 0, 2, '' );




Savaş Bugunu Fixleme


PHP- Kodu:
TYPE 0

ROOM 01
NATION 2
POS 275 570 325 600
A 2 0 0
E 100 1 12
END

ROOM 02
NATION 2
POS 195 119 273 139
A 2 0 0
E 100 1 11
END

ROOM 03
NATION 1
POS 912 772 933 790
A 2 0 0
E 100 1 1
END

ROOM 04
NATION 1
POS 635 308 665 355
A 2 0 0
E 100 1 2
END

ROOM 05
NATION 2
POS 163 860 200 890
A 1 11041 0
E 100 0 0
END

ROOM 06
NATION 1
POS 784 81 805 159
A 1 21041 0
E 100 0 0
END

Kareli ve Karesiz NP Simgesi %100 Garanti


PHP- Kodu:
TRUNCATE TABLE USER_KNIGHTS_RANK
TRUNCATE TABLE USER_PERSONAL_RANK

UPDATE_PERSONAL_RANK Proceduresi

Kod:
CREATE PROCEDURE UPDATE_PERSONAL_RANK
AS
/*
Author : AKUMA
E-Mail : akuma@knightonlineturkiye.web.tr
*/
SET NOCOUNT ON
IF EXISTS (select * from sysobjects where id = object_id(N'[dbo].[KUSER_RATING_MONTHLY]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[KUSER_RATING_MONTHLY]
IF EXISTS (select * from sysobjects where id = object_id(N'[dbo].[EUSER_RATING_MONTHLY]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[EUSER_RATING_MONTHLY]
CREATE TABLE [dbo].[KUSER_RATING_MONTHLY] (
[nRank] [int] IDENTITY (1, 1) NOT NULL ,
[strUserID] [char] (21) NULL,
[strKnightsName] [char] (21) NULL ,
[nLoyaltyMonthly] [int] NULL ,
) ON [PRIMARY]
CREATE TABLE [dbo].[EUSER_RATING_MONTHLY] (
[nRank] [int] IDENTITY (1, 1) NOT NULL ,
[strUserID] [char] (21) NULL,
[strKnightsName] [char] (21) NULL ,
[nLoyaltyMonthly] [int] NULL ,
) ON [PRIMARY]
INSERT INTO KUSER_RATING_MONTHLY
SELECT TOP 100 USERDATA.strUserId, KNIGHTS.IDName, USERDATA.LoyaltyMonthly FROM USERDATA INNER JOIN KNIGHTS ON USERDATA.Knights = KNIGHTS.IDNum
WHERE (USERDATA.Nation = 1) AND (USERDATA.City <> 255 ) AND (Authority = 1)
ORDER BY USERDATA.LoyaltyMonthly DESC
INSERT INTO EUSER_RATING_MONTHLY
SELECT TOP 100 USERDATA.strUserId, KNIGHTS.IDName, USERDATA.LoyaltyMonthly FROM USERDATA INNER JOIN KNIGHTS ON USERDATA.Knights = KNIGHTS.IDNum
WHERE (USERDATA.Nation = 2) AND (USERDATA.City <> 255 ) AND (Authority = 1)
ORDER BY USERDATA.LoyaltyMonthly DESC
CREATE INDEX [IX_RATING_RANK] ON [dbo].[KUSER_RATING_MONTHLY]([nRank]) ON [PRIMARY]
CREATE INDEX [IX_RATING_RANK] ON [dbo].[EUSER_RATING_MONTHLY]([nRank]) ON [PRIMARY]

DECLARE @CheckUserPersonalRankTable tinyint
SELECT @CheckUserPersonalRankTable = Count(*) FROM USER_PERSONAL_RANK
IF @CheckUserPersonalRankTable < 100
BEGIN
DECLARE @RankName varchar(30)
DECLARE @I int

SET @I = 1
WHILE @I < 101
BEGIN
IF @I = 1
BEGIN
SET @RankName = 'Gold Knight'
END
IF @I > 1 AND @I <= 4
BEGIN
SET @RankName = 'Silver Knight'
END
IF @I > 4 AND @I <= 9
BEGIN
SET @RankName = 'Mirage Knight'
END
IF @I > 9 AND @I <= 10
BEGIN
SET @RankName = 'Shadow Knight'
END
IF @I > 25 AND @I <= 50
BEGIN
SET @RankName = 'Mist Knight'
END
IF @I > 50 AND @I <= 100
BEGIN
SET @RankName = 'Training Knight'
END

INSERT INTO USER_PERSONAL_RANK VALUES (@I,@RankName,0,NULL,0,1000000,0,NULL,NULL,1000000 ,1000000,GETDATE())

SET @I = @I + 1
END
END

DECLARE @strCharID char(21)
DECLARE @strKnightsID char(21)
DECLARE @nIndex smallint
DECLARE @nLoyaltyMonthly int
SET @strCharID = NULL
SET @strKnightsID = NULL
SET @nIndex = 0
SET @nLoyaltyMonthly = 0
DECLARE CRS_KARUS CURSOR FOR
SELECT nRank, strUserID, strKnightsName, nLoyaltyMonthly FROM KUSER_RATING_MONTHLY
OPEN CRS_KARUS
FETCH NEXT FROM CRS_KARUS
INTO @nIndex, @strCharID, @strKnightsID, @nLoyaltyMonthly
WHILE @@FETCH_STATUS = 0
BEGIN

UPDATE USER_PERSONAL_RANK SET strKarusUserID = @strCharID, nKarusLoyaltyMonthly = @nLoyaltyMonthly WHERE nRank = @nIndex

FETCH NEXT FROM CRS_KARUS
INTO @nIndex, @strCharID, @strKnightsID, @nLoyaltyMonthly
END
CLOSE CRS_KARUS
DEALLOCATE CRS_KARUS
DECLARE CRS_HUMAN CURSOR FOR
SELECT nRank, strUserID, strKnightsName, nLoyaltyMonthly FROM EUSER_RATING_MONTHLY
OPEN CRS_HUMAN
FETCH NEXT FROM CRS_HUMAN
INTO @nIndex, @strCharID, @strKnightsID, @nLoyaltyMonthly
WHILE @@FETCH_STATUS = 0
BEGIN

UPDATE USER_PERSONAL_RANK SET strElmoUserID = @strCharID, nElmoLoyaltyMonthly = @nLoyaltyMonthly WHERE nRank = @nIndex

FETCH NEXT FROM CRS_HUMAN
INTO @nIndex, @strCharID, @strKnightsID, @nLoyaltyMonthly
END
CLOSE CRS_HUMAN
DEALLOCATE CRS_HUMAN
IF EXISTS (select * from sysobjects where id = object_id(N'[dbo].[KUSER_RATING_MONTHLY]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[KUSER_RATING_MONTHLY]
IF EXISTS (select * from sysobjects where id = object_id(N'[dbo].[EUSER_RATING_MONTHLY]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[EUSER_RATING_MONTHLY]

USER_KNIGHTS_RATING_UPDATE Procedüresi

Kod:
CREATE PROCEDURE USER_KNIGHTS_RATING_UPDATE
AS
/*
Author : AKUMA
E-Mail : akuma@knightonlineturkiye.web.tr
*/
SET NOCOUNT ON
IF EXISTS (select * from sysobjects where id = object_id(N'[dbo].[KUSER_RATING]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[KUSER_RATING]
IF EXISTS (select * from sysobjects where id = object_id(N'[dbo].[EUSER_RATING]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[EUSER_RATING]
CREATE TABLE [dbo].[KUSER_RATING] (
[nRank] [int] IDENTITY (1, 1) NOT NULL ,
[strUserID] [char] (21) NULL,
[strKnightsName] [char] (21) NULL ,
[nLoyalty] [int] NULL ,
) ON [PRIMARY]
CREATE TABLE [dbo].[EUSER_RATING] (
[nRank] [int] IDENTITY (1, 1) NOT NULL ,
[strUserID] [char] (21) NULL,
[strKnightsName] [char] (21) NULL ,
[nLoyalty] [int] NULL ,
) ON [PRIMARY]
INSERT INTO KUSER_RATING
SELECT TOP 100 USERDATA.strUserId, KNIGHTS.IDName, USERDATA.Loyalty FROM USERDATA INNER JOIN KNIGHTS ON USERDATA.Knights = KNIGHTS.IDNum
WHERE (USERDATA.Nation = 1) AND (USERDATA.City <> 255 ) AND (Authority = 1)
ORDER BY USERDATA.Loyalty DESC
INSERT INTO EUSER_RATING
SELECT TOP 100 USERDATA.strUserId, KNIGHTS.IDName, USERDATA.Loyalty FROM USERDATA INNER JOIN KNIGHTS ON USERDATA.Knights = KNIGHTS.IDNum
WHERE (USERDATA.Nation = 2) AND (USERDATA.City <> 255 ) AND (Authority = 1)
ORDER BY USERDATA.Loyalty DESC
CREATE INDEX [IX_RATING_RANK] ON [dbo].[KUSER_RATING]([nRank]) ON [PRIMARY]
CREATE INDEX [IX_RATING_RANK] ON [dbo].[EUSER_RATING]([nRank]) ON [PRIMARY]
DECLARE @CheckUserKnightsRankTable tinyint
SELECT @CheckUserKnightsRankTable = Count(*) FROM USER_KNIGHTS_RANK
IF @CheckUserKnightsRankTable < 100
BEGIN
DECLARE @RankName varchar(30)
DECLARE @I int

SET @I = 1
WHILE @I < 101
BEGIN
IF @I = 1
BEGIN
SET @RankName = 'Gold Knight'
END
IF @I > 1 AND @I <= 4
BEGIN
SET @RankName = 'Silver Knight'
END
IF @I > 4 AND @I <= 9
BEGIN
SET @RankName = 'Mirage Knight'
END
IF @I > 9 AND @I <= 10
BEGIN
SET @RankName = 'Shadow Knight'
END
IF @I > 25 AND @I <= 50
BEGIN
SET @RankName = 'Mist Knight'
END
IF @I > 50 AND @I <= 100
BEGIN
SET @RankName = 'Training Knight'
END

INSERT INTO USER_KNIGHTS_RANK VALUES (@I,@RankName,NULL,NULL,0,NULL,NULL,0,1000000)

SET @I = @I + 1
END
END
DECLARE @strCharID char(21)
DECLARE @strKnightsID char(21)
DECLARE @nIndex smallint
DECLARE @nLoyalty int
SET @strCharID = NULL
SET @strKnightsID = NULL
SET @nIndex = 0
SET @nLoyalty = 0
DECLARE CRS_KARUS CURSOR FOR
SELECT nRank, strUserID, strKnightsName, nLoyalty FROM KUSER_RATING
OPEN CRS_KARUS
FETCH NEXT FROM CRS_KARUS
INTO @nIndex, @strCharID, @strKnightsID, @nLoyalty
WHILE @@FETCH_STATUS = 0
BEGIN

UPDATE USER_KNIGHTS_RANK SET strKarusUserID = @strCharID, strKarusKnightsName = @strKnightsID, nKarusLoyalty = @nLoyalty WHERE shIndex = @nIndex

FETCH NEXT FROM CRS_KARUS
INTO @nIndex, @strCharID, @strKnightsID, @nLoyalty
END
CLOSE CRS_KARUS
DEALLOCATE CRS_KARUS
DECLARE CRS_HUMAN CURSOR FOR
SELECT nRank, strUserID, strKnightsName, nLoyalty FROM EUSER_RATING
OPEN CRS_HUMAN
FETCH NEXT FROM CRS_HUMAN
INTO @nIndex, @strCharID, @strKnightsID, @nLoyalty
WHILE @@FETCH_STATUS = 0
BEGIN

UPDATE USER_KNIGHTS_RANK SET strElmoUserID = @strCharID, strElmoKnightsName = @strKnightsID, nElmoLoyalty = @nLoyalty WHERE shIndex = @nIndex

FETCH NEXT FROM CRS_HUMAN
INTO @nIndex, @strCharID, @strKnightsID, @nLoyalty
END
CLOSE CRS_HUMAN
DEALLOCATE CRS_HUMAN
IF EXISTS (select * from sysobjects where id = object_id(N'[dbo].[KUSER_RATING]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[KUSER_RATING]
IF EXISTS (select * from sysobjects where id = object_id(N'[dbo].[EUSER_RATING]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[EUSER_RATING]
SET NOCOUNT OFF



Irk Deistirme



PHP- Kodu:
EXEC ACCOUNT_NATION_CHANGE 'HESABIDSI','IRKNUMARASI'

Not:Elimden GeLdigi KadaR eklicem ' Emege Saygi'
Sayfa başına dön Aşağa gitmek
http://ko-cular.forumn.org
 
1299 Butun QA kodLari
Önceki başlık Sonraki başlık Sayfa başına dön 
1 sayfadaki 1 sayfası
 Similar topics
-
» Engin Nurşani ''''3'''' FuLL ALbüm

Bu forumun müsaadesi var:Bu forumdaki mesajlara cevap veremezsiniz
Knight Paylaşımının adresi :: Paylaşımlar :: Prosedürler & Kodlar-
Buraya geçin: