Anasayfa
Oto Üyeliği Kaldırma
[PHP]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[/PHP]Para Ekleme Sistemi
[PHP]exec paraekle 'Char ADI ' , 'Para Miktarı'
Create Procedure paraekle
@userid varchar,
@para int
as
update userdata set gold = @para where struserid = @userid
GO[/PHP]Server Pelerin Atına Girişi Kapatma
[PHP]delete zone_info where zoneno = '54'[/PHP]Rague 75 skill Bug Fixi
[PHP]update MAGIC_TYPE2
set AddDamagePlus = 1
where NeedArrow = 1 or NeedArrow = 3 or NeedArrow = 5[/PHP]Santa Ekle
[PHP]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)[/PHP]Seri
Scroll Engellemek (255 Sn ye geçtikten sonra tekrar basılabilir)
[PHP]update MAGIC set ReCastTime= '255'
where MagicNum = 'Scroll Kodu'[/PHP]Servera Delos Ekleme
[PHP]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.[/PHP]Pot Mana Sınırsız Yapma
[PHP]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[/PHP]Clan Kollugunu Yakma(Tek Clan)
[PHP]update Knights set Ranking = '1'where IDName = 'Clan
Adı'[/PHP]Uniqe itemlerin storedaki fıyatını arttırma.
[PHP]update item_basic
SET iPriceSale = 2150000000
WHERE (bySellGroup = 0)[/PHP] Butun Charların Np Sıfırlama
[PHP]UPDATE USERDATA
SET Loyalty = 0
WHERE Authority = 1[/PHP]Char Banlanınca Id Banlama
[PHP]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[/PHP]Keeper KEsınce Isınlanma Sorunu
[PHP]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[/PHP]Warder KEsınce Savası Kaybetmeme
[PHP]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)[/PHP]Her Irktan Giren İlk 5 Toplamda 10 Kişiyi At Yapmak!
[PHP]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[/PHP]Kill The Gm Event
[PHP]UPDATE USERDATA
SET Authority = 9
WHERE strUserId = [NİCK][/PHP]Tower Damage Arttırma
[PHP]UPDATE MAGIC_TYPE3
SET FirstDamage = - 10000
WHERE (iNum = 300139)
Ordaki -10000 towerlarin 1000 - 2000 vurmasini saglar.
Kendinize göre editleyebilirsiniz.[/PHP]Giriş Id sini Değiştirme
[PHP]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'[/PHP]Sh cileri Oyuna Almama
[PHP]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[/PHP]Aynı Id Ile Tekrar Girememe Sorunu
[PHP]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[/PHP]Banlananların Npsını Otomatık Sılme
[PHP]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'[/PHP]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]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, '' );[/PHP]Savaş Bugunu Fixleme
[PHP]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[/PHP]Kareli ve Karesiz NP Simgesi 0 Garanti
[PHP]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 : [Linkleri görebilmek için üye olun veya giriş yapın.]
*/
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 : [Linkleri görebilmek için üye olun veya giriş yapın.]
*/
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[/PHP]Irk Deistirme
[PHP]EXEC ACCOUNT_NATION_CHANGE 'HESABIDSI','IRKNUMARASI'[/PHP]
[/code]
[PHP]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[/PHP]Para Ekleme Sistemi
[PHP]exec paraekle 'Char ADI ' , 'Para Miktarı'
Create Procedure paraekle
@userid varchar,
@para int
as
update userdata set gold = @para where struserid = @userid
GO[/PHP]Server Pelerin Atına Girişi Kapatma
[PHP]delete zone_info where zoneno = '54'[/PHP]Rague 75 skill Bug Fixi
[PHP]update MAGIC_TYPE2
set AddDamagePlus = 1
where NeedArrow = 1 or NeedArrow = 3 or NeedArrow = 5[/PHP]Santa Ekle
[PHP]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)[/PHP]Seri
Scroll Engellemek (255 Sn ye geçtikten sonra tekrar basılabilir)
[PHP]update MAGIC set ReCastTime= '255'
where MagicNum = 'Scroll Kodu'[/PHP]Servera Delos Ekleme
[PHP]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.[/PHP]Pot Mana Sınırsız Yapma
[PHP]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[/PHP]Clan Kollugunu Yakma(Tek Clan)
[PHP]update Knights set Ranking = '1'where IDName = 'Clan
Adı'[/PHP]Uniqe itemlerin storedaki fıyatını arttırma.
[PHP]update item_basic
SET iPriceSale = 2150000000
WHERE (bySellGroup = 0)[/PHP] Butun Charların Np Sıfırlama
[PHP]UPDATE USERDATA
SET Loyalty = 0
WHERE Authority = 1[/PHP]Char Banlanınca Id Banlama
[PHP]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[/PHP]Keeper KEsınce Isınlanma Sorunu
[PHP]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[/PHP]Warder KEsınce Savası Kaybetmeme
[PHP]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)[/PHP]Her Irktan Giren İlk 5 Toplamda 10 Kişiyi At Yapmak!
[PHP]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[/PHP]Kill The Gm Event
[PHP]UPDATE USERDATA
SET Authority = 9
WHERE strUserId = [NİCK][/PHP]Tower Damage Arttırma
[PHP]UPDATE MAGIC_TYPE3
SET FirstDamage = - 10000
WHERE (iNum = 300139)
Ordaki -10000 towerlarin 1000 - 2000 vurmasini saglar.
Kendinize göre editleyebilirsiniz.[/PHP]Giriş Id sini Değiştirme
[PHP]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'[/PHP]Sh cileri Oyuna Almama
[PHP]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[/PHP]Aynı Id Ile Tekrar Girememe Sorunu
[PHP]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[/PHP]Banlananların Npsını Otomatık Sılme
[PHP]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'[/PHP]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]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, '' );[/PHP]Savaş Bugunu Fixleme
[PHP]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[/PHP]Kareli ve Karesiz NP Simgesi 0 Garanti
[PHP]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 : [Linkleri görebilmek için üye olun veya giriş yapın.]
*/
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 : [Linkleri görebilmek için üye olun veya giriş yapın.]
*/
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[/PHP]Irk Deistirme
[PHP]EXEC ACCOUNT_NATION_CHANGE 'HESABIDSI','IRKNUMARASI'[/PHP]
[/code]
