Sitemizden Yararlanmak İçin

Sitemize Üye Olmalısınız

or Kayıt ol
Server Tanitimi , Ko Tanitimi , Silkroad Pvp Serverler , Metin2 Pvp Serverler

Oto Np Sembol kodu

[XFB] Konu Bilgileri

Konu Hakkında Merhaba, tarihinde Knight Online Pvp Prosedür & Kod Paylaşımları kategorisinde Stark tarafından oluşturulan Oto Np Sembol kodu başlıklı konuyu okuyorsunuz. Bu konu şimdiye dek 1,132 kez görüntülenmiş, 0 yorum ve 0 tepki puanı almıştır...
Kategori Adı Knight Online Pvp Prosedür & Kod Paylaşımları
Konu Başlığı Oto Np Sembol kodu
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
Katılım
27 May 2013
Mesajlar
2,664
Tepkime puanı
12
Puanları
38
Kod:
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


/* 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

Oto Np Sembolu (Adım 2)




Kod:
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 Np Sembolu(Adım 3)




Kod:
exec imbacodermyst
exec Rank_Knights
exec np_icon

 
Üst
Silkroad Serverler