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'