1299 Ful Query Analyzer Kod

Db sıfırlama kodu
[code]
truncate table account_char

go

truncate table currentuser

go

truncate table deleted_userdata

go

truncate table knights

go

truncate table knights_rating

go

truncate table knights_user

go

truncate table tb_user

go

truncate table userdata

go

truncate table warehouse

go

KraL Ekleme
[PHP]EXEC KRAL_EKLE CharınADI[/PHP]Oto G1 Yapma
[PHP]update Knights set Points = '999999'[/PHP]İlk 5 cLan g0 yapma
[PHP]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[/PHP]Res Kodu
[PHP]exec imbacodermyst
exec otonpsimgesi
exec np_icon
exec Rank_Knights[/PHP]1440 Pot ve Abys bles silmek icin
[PHP]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')[/PHP]DB YEDEKLEMEK İÇİN–(Bu Kodu Kopyalamadan
Önce C: Klasöründe KODB Adlı Klasör Oluşturun Oraya DB’Yi Oraya
Kopyalıyacak)

[PHP]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[/PHP]Oto Uyeliq

[PHP]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.[/PHP] 9]-[ 10] İtemleri Silmek

[PHP]DELETE from ITEM
WHERE strName LIKE '% 9%'
DELETE from ITEM
WHERE strName LIKE '% 10%[/PHP]1-74 LeveLLeri Clana Almamak

[PHP]update userdata set Knights = '0'where Level = '1'[/PHP]50 Görevini DB'den Kaldırmak


[PHP]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'[/PHP]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]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[/PHP]Aynı ID İle Tekrar Girmeme Sorunu (Çözüm)

[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]Bayrak Ve Cadılar Bayramı İtemleri ekle[Flag]

[PHP]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)[/PHP]Bowl
Lari KaLdiR

[PHP]delete from item where strname like '%bow%'[/PHP]Bütün İtemlerin Ağırlık İstememesi

[PHP]update ITEM set Weight = '0'[/PHP]Char Tahttan Kalkmıyor
Diyenler için Sql scripti (1098)

[PHP]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[/PHP]Christmas Tree Eklemek

[PHP]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)[/PHP]
CZ den Çıkanları Kendi Ülkelerine Işınlama

[PHP]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[/PHP]Databaseden İtem Sil

[PHP]Delete from item where num = 'İtem Kodu'[/PHP]DB'ye Ardream TowerLarı ve NPC'sini EkLemek.txt

[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, 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, '' );[/PHP]Delosa Clan Bayrağı Ekle

[PHP]select idnum from knights where idname = 'ClanAdı'[/PHP]Drop
Eklemek ( X=İtem Y=Oran Z=Monster Ssid )

[PHP]nsert into [K_MONSTER_ITEM] values (Z,0,0,0,0,X,Y,X,Y,X,Y)[/PHP]Drop Sıfırla

[PHP]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'[/PHP]Tum Userlere 21 gb Verme

[PHP]update userdata set gold = '2100000000'[/PHP]Irk Seçme Ekranında Fixed Kod

[PHP]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'[/PHP]İron Neck Gibi Defans Veren Takıları Kaldır

[PHP]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)[/PHP]Kullanıcının Account tunun İtemlerini Silme


[PHP]UPDATE warehouse SET WareHouseData = '' WHERE strAccountID =
'Hesap Adı'[/PHP]İtemin Basılmasını Engelle


[PHP]update ITEM set ReqTitle = '100' , ReqLevel = '81', ReqRank =
'1' where Num = 'İtem Kodu'[/PHP]Userlere Np Ekleme

[PHP]UPDATE USERDATA SET Loyalty = Loyalty Sayı[/PHP]Mage Riote

[PHP]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[/PHP]Okcu 32 K Bugu

[PHP]update MAGIC_TYPE2 set AddDamagePlus = 1 where NeedArrow = 1
or NeedArrow = 3 or NeedArrow = 5[/PHP]Ke Orjinal Lwl Up Oranı Yapma


[PHP]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)[/PHP]