Oto Np Sembol

tarafından **NuLLMasTer99** C.tesi Mayıs 30, 2009 4:18 pm

NuLLMasTer99

NuLLMasTer99: Bronze Master; Mesaj Sayısı : 187
Kayıt tarihi : 14/05/09

Post n°1

Oto Np Sembol

Mesaj tarafından NuLLMasTer99 C.tesi Mayıs 30, 2009 4:18 pm

Kod:: [b][b]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[/b][/b]

Oto Np Sembolu (Adım 2)

Kod:: [b][b][b][b]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, ) [/b][/b][/b][/b]