Merhaba Ziyaretçi
Forumumuza hoşgeldiniz.Sitemizi daha yararlı şekilde kullanabilmek için lütfen kayıt olun veya giriş yapın.

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

D3aG1.gif
ÜCRETSİZ 1299 TEKNİK DESTEK ALMAK İÇİN TIKLAYINIZ

[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 817 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
27 May 2013
2,664
0
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 Alt