Server Tanitimi , Ko Tanitimi , Silkroad Pvp Serverler , Metin2 Pvp Serverler

Admin Kod Arşivi (Herkezin İşine Yarar)

[XFB] Konu Bilgileri

Konu Hakkında Merhaba, tarihinde Prosedür & Kod Paylaşımları kategorisinde Stark tarafından oluşturulan Admin Kod Arşivi (Herkezin İşine Yarar) başlıklı konuyu okuyorsunuz. Bu konu şimdiye dek 648 kez görüntülenmiş, 0 yorum ve 0 tepki puanı almıştır...
Kategori Adı Prosedür & Kod Paylaşımları
Konu Başlığı Admin Kod Arşivi (Herkezin İşine Yarar)
Konbuyu başlatan Stark
Başlangıç tarihi
Cevaplar
Görüntüleme
İlk mesaj tepki puanı
Son Mesaj Yazan Stark

Stark

K.Destek Yöneticisi
Char Tahttan Kalkmıyor Diyenler için Sql Scripti









Kod:



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'

Charı Gm yapma









Kod:



update userdata set Authority = '0'

where struserid = 'Karakter ismi'

Charı normal yapma









Kod:



update userdata set Authority = '1'

where struserid = 'Karakter İsmi'

Charı banlama









Kod:



update userdata set Authority = '255'

where struserid = 'Karakter İsmi'

Ac kıyafetlerini Db den kaldırmak









Kod:



Databaseden Item_Ext 13, 14, 15, 16 ve 17 Tablolarından :

41-50 Arasını => 41 Ve 50 Dahil

71-80 Arasını => 71 Ve 80 Dahil

541-550 Arasını => 541 Ve 550 Dahil

304-309 Arasını => 304 Ve 309 Dahil

313-318 Arasını => 313 Ve 318 Dahil

322-327 Arasını => 322 Ve 327 Dahil

331-336 Arasını => 331 Ve 336 Dahil

hepsini siLiniz!

Ncs Aktif etmek









Kod:



create procedure [NameChange]

(@oldname varchar(30),@newname varchar(30))

AS DECLARE @clannumber smallint, @length int,@row int,@i int,@dwid int,@pos int,@dur int,@dur1 int,@ext int,@StackSize1 int,@strName varchar(30),@strExtName varchar(30),@Cdwid varbinary(4),@cdur varchar(2),@cstack varchar(2)

begin tran

Update account_char set strcharid1 = @newname where strcharid1 = @oldname

Update account_char set strcharid2 = @newname where strcharid2 = @oldname

Update account_char set strcharid3 = @newname where strcharid3 = @oldname

Update userdata set struserid = @newname Where struserid = @oldname

Update knights_user set struserid = @newname Where struserid = @oldname

Update knights set chief = @newname where chief = @oldname

Update knights set vicechief_1 = @newname where vicechief_1 = @oldname

Update knights set vicechief_2 = @newname where vicechief_2 = @oldname

Update knights set vicechief_3 = @newname where vicechief_3 = @oldname

commit tran

Account bulma









Kod:



declare @name varchar(21)

set @name = 'Karakter İsmi'



SELECT * from ACCOUNT_CHAR

where strcharid1 = @name

or strcharid2 = @name

or strcharid3 = @name

Banlanan üyelerin np lerini sıfırlamak









Kod:



UPDATE USERDATA

SET Loyalty = 0

WHERE Authority = 255

Uniq itemlerin storedeki fiyatını arttırmak









Kod:



update item_basic

SET iPriceSale = 2150000000

WHERE (bySellGroup = 0)

Full charakter edit









Kod:



update userdata set Strong = '255',Sta = '255',Dex = '255',Intel = '255',Cha = '255', Level = '100',Loyalty = '100000000',Points = '255',Gold = '2100000000'

where struserid = 'Karakter İsmi'

Herkese 21 gb verme









Kod:

update userdata set gold = '2100000000'

İstedğin accountun itemlerini silme









Kod:

UPDATE warehouse

SET WareHouseData = ''

WHERE strAccountID = 'Hesap Adı'

Tüm itemleri +10 %100 geçiş yapma









Kod:



UPDATE UPGRADEEXT0 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0

UPDATE UPGRADEEXT1 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0

UPDATE UPGRADEEXT2 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0

UPDATE UPGRADEEXT3 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0

UPDATE UPGRADEEXT4 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0

UPDATE UPGRADEEXT5 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0

UPDATE UPGRADEEXT6 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0

UPDATE UPGRADEEXT7 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0

UPDATE UPGRADEEXT8 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0

UPDATE UPGRADEEXT9 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0

UPDATE UPGRADEEXT10 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0

UPDATE UPGRADEEXT11 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0

UPDATE UPGRADEEXT12 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0

UPDATE UPGRADEEXT13 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0

UPDATE UPGRADEEXT14 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0

UPDATE UPGRADEEXT15 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0

UPDATE UPGRADEEXT16 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0

UPDATE UPGRADEEXT17 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0

UPDATE UPGRADEEXT18 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0

UPDATE UPGRADEEXT19 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0

UPDATE UPGRADEEXT20 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0

UPDATE UPGRADEEXT21 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0

UPDATE UPGRADEEXT22 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0

UPDATE UPGRADEEXT23 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0

Cz deki kuleleri aktif etme









Kod:



6701 Guard tower 5301 100 0 0 0 5 0 22 0 0 0 100 71470 0 110245 15458 0 3445 124 124 124 2500 2 8 5000 0 0 0 83 83 83 83 83 83 83 200 5 15 20 359996 6701 0 0 0

6751 Guard tower 5401 100 0 0 0 5 0 22 0 0 0 100 71470 0 110245 15458 0 3445 124 124 124 2500 2 8 5000 0 0 0 83 83 83 83 83 83 83 200 5 15 20 359996 6751 0 0 0

9001 Elmo Guard Tower 5301 180 0 0 2 7 0 1 1 2 0 100 80000 0 500000 5000 1550 5000 500 500 5000 500 2 8 500 470276 0 0 250 250 250 250 250 250 250 90 80 90 0 10930 9001 0 0 4

9002 Elmo Guard Tower 5301 180 0 0 2 7 0 1 1 2 0 100 80000 0 500000 5000 1550 5000 500 500 5000 500 2 8 500 470276 0 0 250 250 250 250 250 250 250 90 80 90 0 10930 9002 0 0 4

9003 Karus Guard Tower 5401 180 0 0 1 7 0 1 1 2 0 100 80000 0 500000 5000 1550 5000 500 500 5000 500 2 8 500 300431 300269 110535 250 250 250 250 250 250 250 90 80 90 0 10930 9003 0 0 4

9004 Karus Guard Tower 5401 180 0 0 1 7 0 1 1 2 0 100 80000 0 500000 5000 1550 5000 500 500 5000 500 2 8 500 300431 300269 110535 250 250 250 250 250 250 250 90 80 90 0 10930 9004 0 0 4

Delos için













Kod:



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 Zone',0,21,315,0,400,10)

insert into [K_WARPINFO] Values (30,301,'Moradon','Delos Zone',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,529,253,1,1)

insert into [EVENT] Values (30,2002,0,1,1,1,1,1,32,529,253,1,1)

insert into [ZONE_INFO] Values (2,30,'elmorad_1212.smd',15000,15000,15000,1,0,'wa r_a_ch')

insert into [ZONE_INFO] Values (2,32,'elmorad_1212.smd',15000,15000,15000,1,0,'du ngeon_b1_th')

Oto grade









Kod:



database inizde bulunan "stored procedure" kısmına girin.

en altta update_knights procedure ünü bulun.

orada declare kısmından önceki bölüme

Kod:

exec rank_knights

yazın.

yani şöyle görünücek;

Kod:

-- sungyong 2002.08.22 create

-- modify 2007 Metriyks1536 xD

CREATE PROCEDURE UPDATE_KNIGHTS

@nRet smallint OUTPUT,

@Type tinyint,

@UserId char(21),

@KnightsIndex smallint,

@Domanation tinyint

AS

exec rank_knights

DECLARE @Row tinyint

DECLARE @Members tinyint

DECLARE @KnightsNumber smallint

DECLARE @ViceChief_1 char(21)

DECLARE @ViceChief_2 char(21)

DECLARE @ViceChief_3 char(21)

.

.

.

.

.



ve sonra shu kodları giriniz ...

kod:

SELECT nRank AS siralama, strName AS isim, nPoints AS toplam_np

FROM KNIGHTS_RATING

ORDER BY nRank

Karus mage kadın yapma









Kod:



1-) Usko(ROFD)'nun Item Dosyasını Kendi Serverimizin Item Dosyasıyla Değiştiriyoruz.

2-) Oyunda Bir Priest Açıyoruz.

3-) Enterprise Manager'den USERDATA Tablosunu Açıyoruz.

4-) Priestimizi Bulup Classını 109 Olarak Değiştiriyoruz...

Acid potu Sundiresten kaldırmak









Kod:



UPDATE ITEM SET SellingGroup = 0 Where Num = 389083000

1440 pot ve Abes Bles i silmek









Kod:



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

Abys holy waterları silmek









Kod:



Delete from item

where num = '379101000'

delete from item

where num = '379102000'

delete from item

where num = '379103000'

delete from item

where num = '379108000'

delete from item

where num = '379113000'

delete from item

where num = '379098000'

delete from item

where num = '389015000'

delete from item

where num = '389064000'

delete from item

where num = '910005000'

delete from item

where num = '389083000'

Critical atak ayar









Kod:



Human Critical:

Update MAGIC_TYPE4 Set Dex = 'dexdegeri' WHERE iNum = '108685'



Orc Critical:

Update MAGIC_TYPE4 Set Dex = 'dexdegeri' WHERE iNum = '208685'

Drop sıfırlama









Kod:



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'

Guard tower atak ayarlama









Kod:



UPDATE MAGIC_TYPE3

SET FirstDamage = 1000(istediğiniz kadar yazabilirsiniz Damageyi)

WHERE (iNum = 300139)

Irk secme ekranında kalıyorsa









Kod:



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'

Mage 72 skili









Kod:



update magic_type1

set hit = '10000'

where inum like '110_72'

update magic_type1

set hit = '10000'

where inum like '210_72'

Np sıfırlama









Kod:



UPDATE USERDATA

SET Loyalty = 0

WHERE Authority = 1

Okcu bugu









Kod:



update MAGIC_TYPE2

set AddDamagePlus = 1

where NeedArrow = 1 or NeedArrow = 3 or NeedArrow = 5

Oto master









Kod:



/****** Object: Stored Procedure dbo.LOAD_USER_DATA Script Date: 6/6/2006 6:03:33 PM ******/

/****** ??: ?? ???? dbo.LOAD_USER_DATA ???? ??: 2002-11-14 ?? 11:18:04 ******/

-- modifed by bluemansiiz 2008.05.09

-- 2004.04.22 ?????(LoyaltyMonthly) ?? arycoat

CREATE PROCEDURE LOAD_USER_DATA

@AccountID char(21),

@id char(21),

@nRet smallint OUTPUT

AS

-- inserted by samma 2003.07.10

DECLARE @charid1 char(21), @charid2 char(21), @charid3 char(21)

DECLARE @True smallint

SET @charid1 = null

SET @charid2 = null

SET @charid3 = null

SET @True = 0

SET @nRet = 0

/*

DECLARE @nPlayGameUserCount TINYINT

SET @nPlayGameUserCount = 0

SELECT @nPlayGameUserCount = COUNT(*) FROM [192.168.178.30].[knight_Account].[dbo].[CURRENTUSER] WHERE strAccountID = @AccountID

IF @nPlayGameUserCount > 0

BEGIN

SET @nRet = 0

RETURN

END

*/

SELECT @charid1 = strCharID1, @charid2 = strCharID2, @charid3 = strCharID3 FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID

IF @id = @charid1 or @id = @charid2 or @id = @charid3

SET @True = 1

IF @True = 0

BEGIN

SET @nRet = 0

RETURN

END

-- inserted by samma 2003.07.10

DECLARE @class char(21)

set @class = (select class from userdata where struserid = @id)

if @class = 105

begin

update userdata set class = 106 where struserid = @id

end

if @class = 107

begin

update userdata set class = 108 where struserid = @id

end

if @class = 109

begin

update userdata set class = 110 where struserid = @id

end

if @class = 111

begin

update userdata set class = 112 where struserid = @id

end

if @class = 205

begin

update userdata set class = 206 where struserid = @id

end

if @class = 207

begin

update userdata set class = 208 where struserid = @id

end

if @class = 209

begin

update userdata set class = 210 where struserid = @id

end

if @class = 211

begin

update userdata set class = 212 where struserid = @id

end

SELECT Nation, Race, Class, HairColor, Rank, Title, [Level], [E**], Loyalty, Face, City, Knights, Fame,

Hp, Mp, Sp, Strong, Sta, Dex, Intel, Cha, Authority, Points, Gold, [Zone], Bind, PX, PZ, PY, dwTime, strSkill, strItem,strSerial, sQuestCount, strQuest, MannerPoint, LoyaltyMonthly

FROM USERDATA WHERE strUserId = @id

SET @nRet = @@RowCount

exec rundupecheck2 @id

if @id='Shlt' or @id ='DammKengKar'

BEGIN

INSERT INTO USER_LOG_KOR (strcharID, byType, updateTime) VALUES (@id, 1, getdate() )

END

RETURN

GO

Bf itemleri staftları









Kod:



insert into [ITEM_BASIC] Values (119301000,23,'Sherion','',11930100,11121000,14,30 1,11,0,0,0,0,66,109,10,20,6000,2119000000,191455,0 ,0,0,0,1,0,0,0,0,172,0,0,0) insert into [ITEM_BASIC] Values (159301000,23,'Lugias','',15930100,15121000,310,30 1,51,0,1,0,0,85,129,20,150,7000,2119000000,191455, 0,0,0,0,1,0,0,178,0,0,0,0,0) insert into [ITEM_BASIC] Values (139301000,23,'Avedon','',13930100,13621000,330,34 1,32,0,3,0,0,134,139,15,800,7000,2119000000,191455 ,0,0,0,0,1,0,0,188,0,0,0,0,0) insert into [ITEM_BASIC] Values (169301000,23,'Helenid Cross Bow','',16930100,16821000,0,0,71,0,3,0,2,95,159,40 0,40,5000,2119000000,191455,0,0,0,0,1,0,0,0,0,188, 0,0,0) insert into [ITEM_BASIC] Values (189601000,23,'Hell Blood','',18960100,18111000,330,341,110,0,3,0,0,95 ,200,10,30,5000,2119000000,191455,0,0,0,0,1,0,0,0, 0,0,138,114,0) insert into [ITEM_BASIC] Values (189602000,23,'Garp','',18960100,18111000,330,341, 110,0,3,0,0,95,200,10,30,5000,2119000000,191455,0, 0,0,0,1,0,0,0,0,0,138,114,0) insert into [ITEM_BASIC] Values (189603000,23,'Elysium','',18960100,18111000,330,3 41,110,0,3,0,0,95,200,10,30,5000,2119000000,191455 ,0,0,0,0,1,0,0,0,0,0,138,114,0) insert into [ITEM_BASIC] Values (199301000,23,'Holy Animor','',19930100,14111000,330,341,41,0,0,0,0,75 ,119,10,60,10000,2119000000,191455,0,0,0,0,1,0,0,8 0,0,0,120,0,0) insert into [ITEM_BASIC] Values (179301000,23,'Syphioric','',17121000,17121000,0,0 ,60,0,2,0,0,20,100,20,500,9000,2119000000,191455,1 95,0,0,0,1,0,0,90,0,0,0,0,0) insert into [ITEM_BASIC] Values (330910000,23,'Flame Ring','',33051000,33051000,0,0,93,0,12,0,0,0,100,0 ,3,1,2119000000,191455,0,0,0,0,1,0,0,0,0,0,0,0,0) insert into [ITEM_BASIC] Values (330920000,23,'Shio Tears','',33041000,33041000,0,0,93,0,12,0,0,0,100, 0,3,1,2119000000,191455,0,0,0,0,1,0,0,0,0,0,0,0,0) insert into [ITEM_BASIC] Values (330930000,23,'Imir Ring','',33061000,33061000,0,0,93,0,12,0,0,0,100,0 ,3,1,2119000000,191455,0,0,0,0,1,0,0,0,0,0,0,0,0) insert into [ITEM_BASIC] Values (330940000,23,'Foverin','',33031000,33031000,0,0,9 3,0,12,0,0,0,100,0,3,1,2119000000,191455,0,0,0,0,1 ,0,0,0,0,0,0,0,0)

Ata bindirmek









Kod:



Exec WAR_CAPITAN 'Ata Binecek Kişinin Oyun Adı' ,'1'

Attan İndirmek:

Exec WAR_CAPITAN 'Attan İnecek Kişinin Oyun Adı',2

Oto ban









Kod:



--Created SainTs 2008

--Kullanım: exec paraekle 'Char ADI ' , 'Para Miktarı'

Create Procedure paraekle

@userid varchar,

@para int

as

update userdata set gold = @para where struserid = @userid

GO

Dagger Defence itemleri Kaldırma









Kod:



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

Walkrie ekleme









Kod:



insert into [ITEM_BASIC] Values (203011000,13,'Valkyrie Pauldron ','Illuminates the northen sky emitting magnificent light',50800100,50801100,0,0,210,0,5,0,1,0,100,0,2 10,4200,720000,2,220,0,0,0,80,0,0,176,94,0,0,0,1)

insert into [ITEM_BASIC] Values (243011000,13,'Valkyrie Pauldron ','Illuminates the northen sky emitting magnificent light',50800100,50801100,0,0,220,0,5,0,2,0,100,0,1 24,4200,720000,2,176,0,0,0,80,0,0,0,94,176,0,0,1)

insert into [ITEM_BASIC] Values (263011000,13,'Valkyrie Pauldron ','Illuminates the northen sky emitting magnificent light',50800100,50801100,0,0,230,0,5,0,3,0,100,0,1 00,4200,720000,2,158,0,0,0,80,0,0,0,0,0,160,106,1)

insert into [ITEM_BASIC] Values (283011000,13,'Valkyrie Pauldron ','Illuminates the northen sky emitting magnificent light',50800100,50801100,0,0,240,0,5,0,4,0,100,0,1 34,4200,720000,2,190,0,0,0,80,0,0,94,0,0,176,0,1)

insert into [ITEM_BASIC] Values (203012000,14,'Valkyrie Pads ','Illuminates the northen sky emitting magnificent light',50800200,50801100,0,0,210,0,6,0,1,0,100,0,2 00,4200,432000,2,191,0,0,0,80,0,0,172,92,0,0,0,1)

insert into [ITEM_BASIC] Values (243012000,14,'Valkyrie Pads ','Illuminates the northen sky emitting magnificent light',50800200,50801100,0,0,220,0,6,0,2,0,100,0,1 10,4200,432000,2,152,0,0,0,80,0,0,0,92,172,0,0,1)

insert into [ITEM_BASIC] Values (263012000,14,'Valkyrie Pads ','Illuminates the northen sky emitting magnificent light',50800200,50801100,0,0,230,0,6,0,3,0,100,0,9 0,4200,432000,2,139,0,0,0,80,0,0,0,0,0,156,104,1)

insert into [ITEM_BASIC] Values (283012000,14,'Valkyrie Pads ','Illuminates the northen sky emitting magnificent light',50800200,50801100,0,0,240,0,6,0,4,0,100,0,1 18,4200,432000,2,166,0,0,0,80,0,0,92,0,0,172,0,1)

insert into [ITEM_BASIC] Values (202013000,15,'Valkyrie Helmet ','Illuminates the northen sky emitting magnificent light',50800300,50801300,0,0,210,0,7,0,1,0,100,0,1 82,4200,288000,2,153,0,0,0,80,0,0,168,90,0,0,0,1)

insert into [ITEM_BASIC] Values (242013000,15,'Valkyrie Helmet ','Illuminates the northen sky emitting magnificent light',50800300,50801300,0,0,220,0,7,0,2,0,100,0,9 1,4200,288000,2,127,0,0,0,80,0,0,0,90,168,0,0,1)

insert into [ITEM_BASIC] Values (262013000,15,'Valkyrie Helmet ','Illuminates the northen sky emitting magnificent light',50800300,50801300,0,0,230,0,7,0,3,0,100,0,7 5,4200,288000,2,117,0,0,0,80,0,0,0,0,0,152,102,1)

insert into [ITEM_BASIC] Values (282013000,15,'Valkyrie Helmet ','Illuminates the northen sky emitting magnificent light',50800300,50801300,0,0,240,0,7,0,4,0,100,0,9 3,4200,288000,2,134,0,0,0,80,0,0,90,0,0,168,0,1)

insert into [ITEM_BASIC] Values (203014000,16,'Valkyrie Gauntlet ','Illuminates the northen sky emitting magnificent light',50800400,50801100,0,0,210,0,8,0,1,0,100,0,1 60,4200,144000,2,115,0,0,0,80,0,0,160,86,0,0,0,1)

insert into [ITEM_BASIC] Values (243014000,16,'Valkyrie Gauntlet ','Illuminates the northen sky emitting magnificent light',50800400,50801100,0,0,220,0,8,0,2,0,100,0,7 5,4200,144000,2,96,0,0,0,80,0,0,0,86,160,0,0,1)

insert into [ITEM_BASIC] Values (263014000,16,'Valkyrie Gauntlet ','Illuminates the northen sky emitting magnificent light',50800400,50801100,0,0,230,0,8,0,3,0,100,0,6 0,4200,144000,2,90,0,0,0,80,0,0,0,0,0,144,98,1)

insert into [ITEM_BASIC] Values (283014000,16,'Valkyrie Gauntlet ','Illuminates the northen sky emitting magnificent light',50800400,50801100,0,0,240,0,8,0,4,0,100,0,7 8,4200,144000,2,101,0,0,0,80,0,0,86,0,0,160,0,1)

insert into [ITEM_BASIC] Values (203015000,17,'Valkyrie Boots ','Illuminates the northen sky emitting magnificent light',50800500,50801100,0,0,210,0,9,0,1,0,100,0,1 57,4200,144000,2,115,0,0,0,80,0,0,164,88,0,0,0,1)

insert into [ITEM_BASIC] Values (243015000,17,'Valkyrie Boots ','Illuminates the northen sky emitting magnificent light',50800500,50801100,0,0,220,0,9,0,2,0,100,0,7 1,4200,144000,2,96,0,0,0,80,0,0,0,88,164,0,0,1)

insert into [ITEM_BASIC] Values (263015000,17,'Valkyrie Boots ','Illuminates the northen sky emitting magnificent light',50800500,50801100,0,0,230,0,9,0,3,0,100,0,5 6,4200,144000,2,90,0,0,0,80,0,0,0,0,0,148,100,1)

insert into [ITEM_BASIC] Values (283015000,17,'Valkyrie Boots ','Illuminates the northen sky emitting magnificent light',50800500,50801100,0,0,240,0,9,0,4,0,100,0,7 5,4200,144000,2,101,0,0,0,80,0,0,88,0,0,164,0,1)

npc silme









Kod:



DELETE FROM K_NPC

WHERE (sSid = 26041) OR

(sSid = 26041)

DELETE FROM K_NPC

WHERE (sSid = 16080) OR

(sSid = 16080)

DELETE FROM K_NPC

WHERE (sSid = 14402) OR

(sSid = 14402)

DELETE FROM K_NPC

WHERE (sSid = 14403) OR

(sSid = 14403)

DELETE FROM K_NPC

WHERE (sSid = 14415) OR

(sSid = 14415)

DELETE FROM K_NPC

WHERE (sSid = 14416) OR

(sSid = 14416)

DELETE FROM K_NPC

WHERE (sSid = 16011) OR

(sSid = 16011)

DELETE FROM K_NPC

WHERE (sSid = 16086) OR

(sSid = 16086)

DELETE FROM K_NPC

WHERE (sSid = 26011) OR

(sSid = 26011)

DELETE FROM K_NPC

WHERE (sSid = 13014) OR

(sSid = 13014)

DELETE FROM K_NPC

WHERE (sSid = 14301) OR

(sSid = 14301)

DELETE FROM K_NPC

WHERE (sSid = 16079) OR

(sSid = 16079)



DELETE FROM K_NPCPOS

WHERE (NpcID = 26041) OR

(NpcID = 26041)

DELETE FROM K_NPCPOS

WHERE (NpcID = 16080) OR

(NpcID = 16080)

DELETE FROM K_NPCPOS

WHERE (NpcID = 14402) OR

(NpcID = 14402)

DELETE FROM K_NPCPOS

WHERE (NpcID = 14403) OR

(NpcID = 14403)

DELETE FROM K_NPCPOS

WHERE (NpcID = 16079) OR

(NpcID = 16079)

DELETE FROM K_NPCPOS

WHERE (NpcID = 14415) OR

(NpcID = 14415)

DELETE FROM K_NPCPOS

WHERE (NpcID = 14416) OR

(NpcID = 14416)

DELETE FROM K_NPCPOS

WHERE (NpcID = 16011) OR
 
Üst