| Knight Online Sayfalar |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
Alıntı Olduğunu biliyorsunuz zaten
2000 Buff 350 Ac
PHP Code:
INSERT INTO [ITEM] Values (800003000,'Scroll of Strength(L) (+0)',255,15,0,0,0,0,0,1,30,2000,0,0,0,500023,0,1, 99,0,0,15,0,0,0,0,0,0,0,0,0,0,0,0,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 (800004000,'Scroll of Health(L) (+0)',255,15,0,0,0,0,0,1,30,2000,0,0,0,500024,0,1, 99,0,0,0,15,0,0,0,0,0,0,0,0,0,0,0,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 (800005000,'Scroll of Dexterity(L) (+0)',255,15,0,0,0,0,0,1,30,2000,0,0,0,500025,0,1, 99,0,0,0,0,15,0,0,0,0,0,0,0,0,0,0,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 (800006000'Scroll of inteligence(L) (+0)',255,15,0,0,0,0,0,1,30,2000,0,0,0,500026,0,1, 99,0,0,0,0,0,15,0,0,0,0,0,0,0,0,0,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 (800007000'Scroll of Magic power(L) (+0)',255,15,0,0,0,0,0,1,30,2000,0,0,0,500027,0,1, 99,0,0,0,0,0,0,15,0,0,0,0,0,0,0,0,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 (800078000,'HP Scroll 2000(L) (+0)',255,15,0,0,0,0,0,1,30,2000,0,0,0,500031,0,2, 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 (800076000,'Scroll of Armor 350 (+0)',255,15,0,0,0,0,0,1,30,2000,0,300,0,500030,0, 30,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 (910126303,'Shield of <selfname>(+3)',60,2,0,0,0,100,20,200,10000,84974, 0,197,0,0,0,1,99,0,0,98,0,0,0,0,0,4,0,0,0,26,26,26 ,26,0,0,0,0,0,0,0,0,0,0,3,3,3,3,0,0,0,6,6,6,0,0,0)
INSERT INTO [ITEM] Values (800015000,'Speed-Up Potion (+0)',255,15,0,0,0,0,0,1,30,2000,0,0,0,500035,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 (800014000',Scroll of Attack (+0)',255,15,0,0,0,0,0,1,30,2000,0,0,0,500034,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)
İstediğiniz Pot Vb İtem'i Sınırsız Yapma (389014000 Kod'unu Değiştirip İstediğiniz Kod'u Yazın Ve Sınırsız oLur 1 Tane aLın Kullanın )
PHP Code:
update magic set useitem='0' where useitem='389014000'
BifrosT İtemLeri Staff'ları
PHP Code:
insert into [ITEM_BASIC] Values (119301000,23,'Sherion','',11930100,11121000,14,301,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,301,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,341,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,400,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,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 (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,80,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,195,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,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)
Ata Bindirmek
PHP Code:
Exec WAR_CAPITAN 'Ata Binecek Kişinin Oyun Adı' ,'1'
Attan İndirmek:
PHP Code:
Exec WAR_CAPITAN 'Attan İnecek Kişinin Oyun Adı',2
PHP Code:
CREATE PROCEDURE WAR_CAPITAN
@UserId varchar(21),
@Nrow int
AS
DECLARE @Race int,@Nation int
Select @Race = Race From USERDATA Where strUserId = @UserId
Select @Nation = Nation From USERDATA Where strUserId = @UserId
--Ata Bin
IF @Race = 1 and @Nrow = 1
BEGIN
Update USERDATA Set Race = 5 Where strUserId = @UserId
END
ELSE IF @Race = 2 and @Nrow = 1
BEGIN
Update USERDATA Set Race = 6 Where strUserId = @UserId
END
ELSE IF @Race = 3 and @Nrow = 1
BEGIN
Update USERDATA Set Race = 7 Where strUserId = @UserId
END
ELSE IF @Race = 4 and @Nrow = 1
BEGIN
Update USERDATA Set Race = 8 Where strUserId = @UserId
END
ELSE IF @Race = 11 and @Nrow = 1
BEGIN
Update USERDATA Set Race = 14 Where strUserId = @UserId
END
ELSE IF @Race = 12 and @Nrow = 1
BEGIN
Update USERDATA Set Race = 15 Where strUserId = @UserId
END
ELSE IF @Race = 13 and @Nrow = 1
BEGIN
Update USERDATA Set Race = 16 Where strUserId = @UserId
END
--Attan İn
IF @Race = 5 and @Nrow = 2
BEGIN
Update USERDATA Set Race = 1 Where strUserId = @UserId
END
ELSE IF @Race = 6 and @Nrow = 2
BEGIN
Update USERDATA Set Race = 2 Where strUserId = @UserId
END
ELSE IF @Race = 7 and @Nrow = 2
BEGIN
Update USERDATA Set Race = 3 Where strUserId = @UserId
END
ELSE IF @Race = 8 and @Nrow = 2
BEGIN
Update USERDATA Set Race = 4 Where strUserId = @UserId
END
ELSE IF @Race = 14 and @Nrow = 2
BEGIN
Update USERDATA Set Race = 11 Where strUserId = @UserId
END
ELSE IF @Race = 15 and @Nrow = 2
BEGIN
Update USERDATA Set Race = 12 Where strUserId = @UserId
END
ELSE IF @Race = 16 and @Nrow = 2
BEGIN
Update USERDATA Set Race = 13 Where strUserId = @UserId
END
GO
Her Irktan Giren İlk 5 Toplamda 10 Kişiyi At Yapmak!
Update_User_Datayı Açın Ve İçinde Arayın
WHERE strUserId = @id
Altına Ekleyin
PHP Code:
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
Oto Np SymboL 1 . Adım
PHP Code:
CREATE PROCEDURE otonpsimgesi AS
/* webmsn */
declare @KNP int,
@HNP int
select @KNP = nKarusLoyalty from user_knights_rank where shindex = 6
select @HNP = nElmoLoyalty from user_knights_rank where shindex = 6
truncate table npkarus
insert npkarus
select top 30 strUserID, Loyalty, LoyaltyMonthly
from USERDATA
where Nation = 1 and Loyalty < @KNP
order by LoyaltyMonthly desc
truncate table nphuman
insert nphuman
select top 30 strUserID, Loyalty, LoyaltyMonthly
from USERDATA
where Nation = 2 and Loyalty < @HNP
order by LoyaltyMonthly desc
declare @Karusa varchar(21),
@Karusb varchar(21),
@Karusc varchar(21),
@Karusd varchar(21),
@Karuse varchar(21),
@Karusf varchar(21),
@Karusg varchar(21),
@Karush varchar(21),
@Karusi varchar(21),
@Karusj varchar(21),
@Karusk varchar(21),
@Karusl varchar(21),
@Karusm varchar(21),
@Karusn varchar(21),
@Karusu varchar(21),
@Karusv varchar(21),
@Karusy varchar(21),
@Karusx varchar(21),
@Karusw varchar(21),
@Karusz varchar(21),
@Karusab varchar(21),
@Karusac varchar(21),
@Karusad varchar(21),
@Karusae varchar(21),
@Karusaf varchar(21),
@Karusag varchar(21),
@Karusah varchar(21),
@Karusai varchar(21),
@Karusaj varchar(21),
@Karusak varchar(21),
@Elmoa varchar(21),
@Elmob varchar(21),
@Elmoc varchar(21),
@Elmod varchar(21),
@Elmoe varchar(21),
@Elmof varchar(21),
@Elmog varchar(21),
@Elmoh varchar(21),
@Elmoi varchar(21),
@Elmoj varchar(21),
@Elmok varchar(21),
@Elmol varchar(21),
@Elmom varchar(21),
@Elmon varchar(21),
@Elmou varchar(21),
@Elmov varchar(21),
@Elmoy varchar(21),
@Elmox varchar(21),
@Elmow varchar(21),
@Elmoz varchar(21),
@Elmoab varchar(21),
@Elmoac varchar(21),
@Elmoad varchar(21),
@Elmoae varchar(21),
@Elmoaf varchar(21),
@Elmoag varchar(21),
@Elmoah varchar(21),
@Elmoai varchar(21),
@Elmoaj varchar(21),
@Elmoak varchar(21)
select @Karusa = strUserID from npkarus where nRank = 1
select @Karusb = strUserID from npkarus where nRank = 2
select @Karusc = strUserID from npkarus where nRank = 3
select @Karusd = strUserID from npkarus where nRank = 4
select @Karuse = strUserID from npkarus where nRank = 5
select @Karusf = strUserID from npkarus where nRank = 6
select @Karusg = strUserID from npkarus where nRank = 7
select @Karush = strUserID from npkarus where nRank = 8
select @Karusi = strUserID from npkarus where nRank = 9
select @Karusj = strUserID from npkarus where nRank = 10
select @Karusk = strUserID from npkarus where nRank = 11
select @Karusl = strUserID from npkarus where nRank = 12
select @Karusm = strUserID from npkarus where nRank = 13
select @Karusn = strUserID from npkarus where nRank = 14
select @Karusu = strUserID from npkarus where nRank = 15
select @Karusv = strUserID from npkarus where nRank = 16
select @Karusy = strUserID from npkarus where nRank = 17
select @Karusx = strUserID from npkarus where nRank = 18
select @Karusw = strUserID from npkarus where nRank = 19
select @Karusz = strUserID from npkarus where nRank = 20
select @Karusab = strUserID from npkarus where nRank = 21
select @Karusac = strUserID from npkarus where nRank = 22
select @Karusad = strUserID from npkarus where nRank = 23
select @Karusae = strUserID from npkarus where nRank = 24
select @Karusaf = strUserID from npkarus where nRank = 25
select @Karusag = strUserID from npkarus where nRank = 26
select @Karusah = strUserID from npkarus where nRank = 27
select @Karusai = strUserID from npkarus where nRank = 28
select @Karusaj = strUserID from npkarus where nRank = 29
select @Karusak = strUserID from npkarus where nRank = 30
select @Elmoa = strUserID from nphuman where nRank = 1
select @Elmob = strUserID from nphuman where nRank = 2
select @Elmoc = strUserID from nphuman where nRank = 3
select @Elmod = strUserID from nphuman where nRank = 4
select @Elmoe = strUserID from nphuman where nRank = 5
select @Elmof = strUserID from nphuman where nRank = 6
select @Elmog = strUserID from nphuman where nRank = 7
select @Elmoh = strUserID from nphuman where nRank = 8
select @Elmoi = strUserID from nphuman where nRank = 9
select @Elmoj = strUserID from nphuman where nRank = 10
select @Elmok = strUserID from nphuman where nRank = 11
select @Elmol = strUserID from nphuman where nRank = 12
select @Elmom = strUserID from nphuman where nRank = 13
select @Elmon = strUserID from nphuman where nRank = 14
select @Elmou = strUserID from nphuman where nRank = 15
select @Elmov = strUserID from nphuman where nRank = 16
select @Elmoy = strUserID from nphuman where nRank = 17
select @Elmox = strUserID from nphuman where nRank = 18
select @Elmow = strUserID from nphuman where nRank = 19
select @Elmoz = strUserID from nphuman where nRank = 20
select @Elmoab = strUserID from nphuman where nRank = 21
select @Elmoac = strUserID from nphuman where nRank = 22
select @Elmoad = strUserID from nphuman where nRank = 23
select @Elmoae = strUserID from nphuman where nRank = 24
select @Elmoaf = strUserID from nphuman where nRank = 25
select @Elmoag = strUserID from nphuman where nRank = 26
select @Elmoah = strUserID from nphuman where nRank = 27
select @Elmoai = strUserID from nphuman where nRank = 28
select @Elmoaj = strUserID from nphuman where nRank = 29
select @Elmoak = strUserID from nphuman where nRank = 30
PHP Code:
/* Güncelleme Yapıyoruz */
update user_personal_rank set strElmoUserID = @Elmoa, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoa), strKarusUserID = @karusa, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusa) where nRank = 1
update user_personal_rank set strElmoUserID = @Elmob, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmob), strKarusUserID = @karusb, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusb) where nRank = 2
update user_personal_rank set strElmoUserID = @Elmoc, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoc), strKarusUserID = @karusc, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusc) where nRank = 3
update user_personal_rank set strElmoUserID = @Elmod, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmod), strKarusUserID = @karusd, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusd) where nRank = 4
update user_personal_rank set strElmoUserID = @Elmoe, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoe), strKarusUserID = @karuse, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuse) where nRank = 5
update user_personal_rank set strElmoUserID = @Elmof, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmof), strKarusUserID = @karusf, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusf) where nRank = 6
update user_personal_rank set strElmoUserID = @Elmog, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmog), strKarusUserID = @karusg, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusg) where nRank = 7
update user_personal_rank set strElmoUserID = @Elmoh, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoh), strKarusUserID = @karush, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karush) where nRank = 8
update user_personal_rank set strElmoUserID = @Elmoi, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoi), strKarusUserID = @karusi, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusi) where nRank = 9
update user_personal_rank set strElmoUserID = @Elmoj, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoj), strKarusUserID = @karusj, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusj) where nRank = 10
update user_personal_rank set strElmoUserID = @Elmok, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmok), strKarusUserID = @karusk, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusk) where nRank = 11
update user_personal_rank set strElmoUserID = @Elmol, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmol), strKarusUserID = @karusl, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusl) where nRank = 12
update user_personal_rank set strElmoUserID = @Elmom, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmom), strKarusUserID = @karusm, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusm) where nRank = 13
update user_personal_rank set strElmoUserID = @Elmon, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmon), strKarusUserID = @karusn, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusn) where nRank = 14
update user_personal_rank set strElmoUserID = @Elmou, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmou), strKarusUserID = @karusu, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusu) where nRank = 15
update user_personal_rank set strElmoUserID = @Elmov, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmov), strKarusUserID = @karusv, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusv) where nRank = 16
update user_personal_rank set strElmoUserID = @Elmoy, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoy), strKarusUserID = @karusy, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusy) where nRank = 17
update user_personal_rank set strElmoUserID = @Elmox, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmox), strKarusUserID = @karusx, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusx) where nRank = 18
update user_personal_rank set strElmoUserID = @Elmow, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmow), strKarusUserID = @karusw, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusw) where nRank = 19
update user_personal_rank set strElmoUserID = @Elmoz, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoz), strKarusUserID = @karusz, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusz) where nRank = 20
update user_personal_rank set strElmoUserID = @Elmoab, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoab), strKarusUserID = @karusab, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusab) where nRank = 21
update user_personal_rank set strElmoUserID = @Elmoac, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoac), strKarusUserID = @karusac, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusac) where nRank = 22
update user_personal_rank set strElmoUserID = @Elmoad, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoad), strKarusUserID = @karusad, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusad) where nRank = 23
update user_personal_rank set strElmoUserID = @Elmoae, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoae), strKarusUserID = @karusae, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusae) where nRank = 24
update user_personal_rank set strElmoUserID = @Elmoaf, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoaf), strKarusUserID = @karusaf, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusaf) where nRank = 25
update user_personal_rank set strElmoUserID = @Elmoag, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoag), strKarusUserID = @karusag, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusag) where nRank = 26
update user_personal_rank set strElmoUserID = @Elmoah, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoah), strKarusUserID = @karusah, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusah) where nRank = 27
update user_personal_rank set strElmoUserID = @Elmoai, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoai), strKarusUserID = @karusai, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusai) where nRank = 28
update user_personal_rank set strElmoUserID = @Elmoaj, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoaj), strKarusUserID = @karusaj, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusaj) where nRank = 29
update user_personal_rank set strElmoUserID = @Elmoak, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoak), strKarusUserID = @karusak, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusak) where nRank = 30
GO
PHP Code:
Oto Np SymboL 2 . Adım
create table [nphuman]
(
[nRank] [int] IDENTITY (1, 1) NOT NULL ,
[strUserID] char(21) NOT NULL,
[Loyalty] int NOT NULL,
[LoyaltyMonthly] int NOT NULL,
)
create table [npkarus]
(
[nRank] [int] IDENTITY (1, 1) NOT NULL ,
[strUserID] char(21) NOT NULL,
[Loyalty] int NOT NULL,
[LoyaltyMonthly] int NOT NULL,
)
Oto SymboL 3 . Adım
PHP Code:
exec imbacodermyst
exec Rank_Knights
exec np_icon
Oto Ban Sistemi
PHP Code:
--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
Server'e DeLos Eklemek
PHP Code:
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.smd',15000,15000,15000,1,0,'war_a_ch') insert into [ZONE_INFO] Values (2,32,'elmorad_1212.smd',15000,15000,15000,1,0,'dungeon_b1_th')
Stat SıfırLama Relogla
PHP Code:
CREATE PROCEDURE statduzelt
@oyunid varchar(21)
AS
Declare @lvl int, @point tinyint, @class int, @str int , @mp int, @hp int, @dex int
select @lvl = level, @point = points, @class = class, @str = Strong, @dex = Dex, @hp = Sta, @mp = Cha from userdata where StrUserID = @oyunid
--Warriorlar için..
IF ((@class = 106 or @class = 206) and @lvl >= 74 and @lvl <= 80 and @point >= 1 and @point <= 31 and @str < 71 and @hp < 71 and @Dex < 71 and @mp < 71)
Begin
Update Userdata Set Strong = Strong + @point + 1 , Points = 255 Where struserid = @oyunid
END
--Rogueler için..
PHP Code:
IF ((@class = 108 or @class = 208) and @lvl >= 74 and @lvl <= 80 and @point >= 1 and @point <= 31 and @str < 71 and @hp < 71 and @Dex < 71 and @mp < 71)
Begin
Update Userdata Set Dex = Dex + @point + 1 , Points = 255 Where struserid = @oyunid
END
--Mageler için..
PHP Code:
IF ((@class = 110 or @class = 210) and @lvl >= 74 and @lvl <= 80 and @point >= 1 and @point <= 31 and @str < 71 and @hp < 71 and @Dex < 71 and @mp < 71)
Begin
Update Userdata Set Cha = Cha + @point + 1 , Points = 255 Where struserid = @oyunid
END
--Priestler için..
PHP Code:
IF ((@class = 112 or @class = 212) and @lvl >= 74 and @lvl <= 80 and @point >= 1 and @point <= 31 and @str < 71 and @hp < 71 and @Dex < 71 and @mp < 71)
Begin
Update Userdata Set Strong = Strong + @point + 1 , Points = 255 Where struserid = @oyunid
END
GO
Bunu yaptıktan sonra "exec statduzelt 'nick" yazdıktan sonra düzeliyor.
Biz relogda olsun istediğimiz için;
LOAD_USER_DATA da.
Alıntı:
SELECT Nation, Race, Class, HairColor, Rank, Title, [Level], [Exp], 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
Bu kodların üstüne yani oto masterın altına |
PHP Code:
exec statduzelt @id
Tüm Char'ları Moradona Atmak
PHP Code:
update Userdata set zone = '21'
Np İşareTi Ekleme
PHP Code:
CREATE PROCEDURE np_icon
AS
DECLARE
--This script has been made by BERKİN GÜLER in 12.09.2007
--Bu script KOLTEAMSTS Tarafından 09.07.2008 Tarihinde YapıLmıştır
@berkin varchar(100),
@cigdm varchar(100),
@i int
BEGIN TRANSACTION
SELECT @berkin=strUserID FROM USERDATA WHERE Nation = '1' ORDER BY Loyalty
UPDATE USERDATA SET strUserID = '[D]' + @berkin WHERE strUserID = @berkin
SELECT @cigdm=strUserID FROM USERDATA WHERE Nation = '2' ORDER BY Loyalty
UPDATE USERDATA SET strUserID = '[D]' + @cigdm WHERE strUserID = @cigdm
IF @@error<>0
begin
rollback transaction
print 'Hata oluştu!'
end
else
begin
print 'ICON EKLEME ISLEMI BASARILI.'
print @berkin + 've' + @cigdm + ',' + '[D]' + @berkin + 've' + '[D]' + @cigdm + 'olarak degistirildi!'
end
COMMIT TRANSACTION
GO
User'lerin Tüm Np'sini Silme Kod'u
PHP Code:
UPDATE USERDATA
SET Loyalty = 0
WHERE Authority = 1
Npc'de +9 İtem Satmak İstiyorsanız..!
PHP Code:
update K_NPC set iSellingGroup = '199009'
where strName = 'Npc İsmi'
PHP Code:
Dagger Defance İtemLeri Kaldırma
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)
Walkry Ekleme Kod'u
PHP Code:
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,210,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,124,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,100,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,134,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,200,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,110,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,90,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,118,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,182,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,91,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,75,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,93,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,160,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,75,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,60,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,78,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,157,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,71,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,56,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,75,4200,144000,2,101,0,0,0,80,0,0,88,0,0,164,0,1)
Rogue 75 Skill Bugu Fixed
PHP Code:
update MAGIC_TYPE2
set AddDamagePlus = 1
where NeedArrow = 1 or NeedArrow = 3 or NeedArrow = 5
Npc Silme Kod'u
PHP Code:
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
(NpcID = 16011)
DELETE FROM K_NPCPOS
WHERE (NpcID = 16086) OR
(NpcID = 16086)
DELETE FROM K_NPCPOS
WHERE (NpcID = 26011) OR
(NpcID = 26011)
DELETE FROM K_NPCPOS
WHERE (NpcID = 13014) OR
(NpcID = 13014)
DELETE FROM K_NPCPOS
WHERE (NpcID = 14301) OR
(NpcID = 14301)
2000 Buff 350 Ac Kullanmak İçin Bu Kodlarıda Ekleyiniz
MAGIC Tablosuna Eklenecek Kod:
PHP Code:
500068 2000 HP Áõ°¡ ÁÖ¹®¼* HP Scroll 2000(L) Increase HP by 2000 0 0 0 1 702 1 0 0 0 0 9 810081000 0 1 100 4 0 25 1 0
500130 2000 HP Áõ°¡ ÁÖ¹®¼* HP Scroll 2000(L) Increase HP by 2000 0 0 0 1 702 1 0 0 0 0 9 900176000 0 1 100 4 0 25 1 0
500055 350 ¹æ¾î·Â »ó½Â ÁÖ¹®¼*(´ë) Scroll of Armor 350(L) Increase Defense by 350 0 0 0 1 702 1 0 0 0 0 9 800076000 0 1 100 4 0 0 1 0
500129 350 ¹æ¾î·Â »ó½Â ÁÖ¹®¼* Scroll of Armor 350(L) Increase Defense by 350 0 0 0 1 702 1 0 0 0 0 9 900175000 0 1 100 4 0 0 1 0
500053 2000 HP Áõ°¡ ÁÖ¹®¼*(´ë) HP Scroll 2000(L) Increase HP by 2000 0 0 0 1 702 1 0 0 0 0 9 800078000 0 1 100 4 0 25 1 0
500067 350 ¹æ¾î·Â »ó½Â ÁÖ¹®¼* Scroll of Armor 350(L)
MAGI_TYPE4 tablsounada Bu Kodu:
PHP Code:
500053 ttt ttt 1 0 1800 100 100 0 100 100 100 2000 100 0 100 100 100 0 0 0 0 0 0 0 0 0 0 0 0
500055 ttt ttt 2 0 1800 100 100 350 100 100 100 0 100 0 100 100 100 0 0 0 0 0 0 0 0 0 0 0 0
500067 ttt ttt 2 0 1800 100 100 350 100 100 100 0 100 0 100 100 100 0 0 0 0 0 0 0 0 0 0 0 0
500068 ttt ttt 1 0 1800 100 100 0 100 100 100 2000 100 0 100 100 100 0 0 0 0 0 0 0 0 0 0 0 0
500129 ttt ttt 2 0 1800 100 100 350 100 100 100 0 100 0 100 100 100 0 0 0 0 0 0 0 0 0 0 0 0
500130 ttt ttt 1 0 1800 100 100 0 100 100 100 2000 100 0 100 100 100 0 0 0 0 0 0 0 0 0 0 0 0
500053 ttt ttt 1 0 1800 100 100 0 100 100 100 2000 100 0 100 100 100 0 0 0 0 0 0 0 0 0 0 0 0
500055 ttt ttt 2 0 1800 100 100 350 100 100 100 0 100 0 100 100 100 0 0 0 0 0 0 0 0 0 0 0 0
500067 ttt ttt 2 0 1800 100 100 350 100 100 100 0 100 0 100 100 100 0 0 0 0 0 0 0 0 0 0 0 0
500068 ttt ttt 1 0 1800 100 100 0 100 100 100 2000 100 0 100 100 100 0 0 0 0 0 0 0 0 0 0 0 0
500129 ttt ttt 2 0 1800 100 100 350 100 100 100 0 100 0 100 100 100 0 0 0 0 0 0 0 0 0 0 0 0
500130 ttt ttt
İtemi Tradeye Kapatma
Alıntı:
Buff Scyi Tradeye Kapatıcaz Kıssa Qeery Analyzer Kodu Örneğin İtemin Kodu 11111111 ve Bunu Tradeye Engellemeyi İstiyorsun 11111111 Başındaki Rakamı Silip 9 Koyun
Sonra İtem_org_us.tbl Tblyi Tbl Editörle Açın Ordanda Başındaki Rakamı Sil 9 Koyun |
PHP Code:
update ITEM set Num = '91111111'
where Num = '11111111'
Sıra Geldi Magic Tablosuna Aynısını Bundada Yapıyoruz
PHP Code:
update MAGIC set UseItem = '91111111'
where UseItem = '11111111'
Alıntı:
| Bunuda Değiştirince Gelelim Skill_Magic_Main_us.tbl Ordada Use İtem Kodunu Bulup Başındaki Rakamı 9 Yapın Sonra Sc Tekrar Aktif Tradeye Kapalı |
|
|
|
|
|
|
|
|
|
|
|
|
|
