OTONP Sembol YAPIMI :
Kutulu Sembol ile Birlikte Sorunsuz Çalışır Çakışma Yaratmaz .
gokhan'ın paylaştığı otomatik kutulu np sembolü ekleme konusundaki kodlardan
yararlanarak normal np sembol'ü nasıl otomatik yapacağınızı gösterecem.
Aşağıdaki işlemleri yaparken Windows Authentication olarak Giriş Yapın .
1. Adım :
Aşağıdaki Kodu Query Anlyzer'a Girin.
PHP Code:
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,
)
Kodu Girdikten sonra
user_personal_rank tablosunu açıyoruz. 1'den 30'a kadar sırayla bilgileri giriyoruz.
Kod:
nRank = 1 - 30 ( 1'den 30'a kadar sayıları sıralı olarak ekliyeceksiniz. )
( Örn :
1
2
3
4
5
6
7
.. diye eklenecek.. )
strPosition = Gold ( Hepsi Standart Gold Olarak Kalacak . )
nElmoUP = 0
strElmoUserID = 1111
nElmoLoyaltyMonthly = 1111
nElmoCheck = 1000000
nKarusUP = 0
strKarusUserID = 1111
nKarusLoyaltyMonthly = 1111
nKarusCheck = 1000000
nSalary = 1000000
UpdateDate = 30.04.2008 21:30:00user_personal_rank bu şekilde bir görüntüye sahip olacaktır kodları eklediğinizde.
Bunlarıda Ekledikten sonra procedure'yi ekleyelim.
HTML 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
/* 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
GOBuraya kadar herşey tamam. Şimdik gelelim otomatik yapmaya diyelimki 20:30 'da simgeler güncellenecek. Resimlerdekini adım adım uygulayın.
Zamanı belirledikten sonra "Tamam" Diyoruz. 2 kez İleri diyoruz . Job ismini belirliyoruz. Son Diyoruz.
Son olarak ;
Başlat > Tüm Programlar > Microsoft SQL Server > Service Manager'den
2.Sekmeden SQLServerAgent'i seçip Start Diyoruz.
ALINTIDIR...
Konu: [PAYLAŞIM]Oto Np Sembolü Yapma... 
