OxyDante
Snake Queen
Ruh Hali : 
Job : 
Mesaj Sayısı : 210
Kayıt tarihi : 18/09/09
 |  Konu: serverın en iyisini belirleme  C.tesi Eyl. 19, 2009 5:50 pm | |
|
|
|
| Bunu Uygulayın :
<table align="center" border="0" cellpadding="0" cellspacing="1"><tr><td>Kod:</td></tr><tr><td class="code">CREATE PROCEDURE Eniyi
@Komut char(21)
AS
-- Prosedür Trayhoper Tarafından Yazılmıştır ..
-- Hatalıysam çaldır kapat,ben seni ararım ::O
DECLARE @EmcWarrior varchar(21),@EmcPriest varchar(21),@EmcMage varchar(21),@EmcRogue varchar(21)
DECLARE
@Barbar varchar(21),@EmcFeMaleWar varchar(21),@EmcFeMalePri
varchar(21),@EmcFeMaleMage varchar(21),@EmcFeMaleRog varchar(21)
DECLARE @OrcWarrior varchar(21),@OrcPriest varchar(21),@OrcMage varchar(21),@OrcRogue varchar(21),@OrcFeMalePri varchar(21)
IF @Komut = 'Warrior'
BEGIN
SELECT @EmcWarrior = strUserID FROM USERDATA WHERE Class = 206 AND Race = 12 ORDER BY Loyalty Asc
print 'En Iyi Elmorad Erkek Warrior : ' + @EmcWarrior
SELECT @Barbar = strUserID FROM USERDATA WHERE Class = 206 AND Race = 11 ORDER BY Loyalty Asc
print 'En iyi Elmorad Barbar Warrior : ' + @Barbar
SELECT @EmcFeMaleWar = strUserID FROM USERDATA WHERE Class = 206 AND Race = 13 ORDER BY Loyalty Asc
print 'En iyi Elmorad Kadın Warrior : ' + @EmcFeMaleWar
SELECT @OrcWarrior = strUserID FROM USERDATA WHERE Class = 106 AND Race = 1 ORDER BY Loyalty Asc
print 'En Iyi Karus Barbar Warrior : ' + @OrcWarrior
RETURN
END
IF @Komut = 'Priest'
BEGIN
SELECT @EmcPriest = strUserID FROM USERDATA WHERE Class = 204 AND Race = 12 ORDER BY Loyalty Asc
print 'En iyi Elmorad Erkek Priest : ' + @EmcPriest
SELECT @EmcFeMalePri = strUserID FROM USERDATA WHERE Class = 204 AND Race = 13 ORDER BY Loyalty Asc
print 'En iyi Elmorad Kadın Priest : ' + @EmcFeMalePri
SELECT @OrcPriest = strUserID FROM USERDATA WHERE Class = 104 AND Race = 2 ORDER BY Loyalty Asc
print 'En iyi Karus Erkek Priest : ' + @OrcPriest
SELECT @OrcFeMalePri = strUserID FROM USERDATA WHERE CLass = 104 AND Race = 4 ORDER BY Loyalty Asc
print 'En iyi Karus Kadın Priest : ' + @OrcFeMalePri
RETURN
END
IF @Komut = 'Mage'
BEGIN
SELECT @EmcMage = strUserID FROM USERDATA WHERE Class = 210 AND Race = 12 ORDER BY Loyalty Asc
print 'En iyi Elmorad Erkek Mage : ' + @EmcMage
SELECT @EmcFeMaleMage = strUserID FROM USERDATA WHERE Class = 210 AND Race = 13 ORDER BY Loyalty Asc
print 'En iyi Elmorad Kadın Mage : ' + @EmcFeMaleMage
SELECT @OrcMage = strUserID FROM USERDATA WHERE Class = 110 AND Race = 3 ORDER BY Loyalty Asc
print 'En iyi Karus Wrinkle Mage : ' + @OrcMage
RETURN
END
IF @Komut = 'Rogue'
BEGIN
SELECT @EmcRogue = strUserID FROM USERDATA WHERE Class = 208 AND Race = 12 ORDER BY Loyalty Asc
print 'En iyi Elmorad Erkek Rogue : ' + @EmcRogue
SELECT @EmcFeMaleRog = strUserID FROM USERDATA WHERE Class = 208 AND Race = 13 ORDER BY Loyalty Asc
print 'En iyi Elmorad Kadın Rogue : ' + @EmcFeMaleRog
SELECT @OrcRogue = strUserID FROM USERDATA WHERE Class = 108 AND Race = 2 ORDER BY Loyalty Asc
print 'En iyi Karus Erkek Rogue : ' + @OrcRogue
RETURN
END
IF @Komut = 'Hepsi'
BEGIN
SELECT @EmcWarrior = strUserID FROM USERDATA WHERE Class = 206 AND Race = 12 ORDER BY Loyalty Asc
print 'En Iyi Elmorad Erkek Warrior : ' + @EmcWarrior
SELECT @Barbar = strUserID FROM USERDATA WHERE Class = 206 AND Race = 11 ORDER BY Loyalty Asc
print 'En iyi Elmorad Barbar Warrior : ' + @Barbar
SELECT @EmcFeMaleWar = strUserID FROM USERDATA WHERE Class = 206 AND Race = 13 ORDER BY Loyalty Asc
print 'En iyi Elmorad Kadın Warrior : ' + @EmcFeMaleWar
SELECT @EmcPriest = strUserID FROM USERDATA WHERE Class = 204 AND Race = 12 ORDER BY Loyalty Asc
print 'En iyi Elmorad Erkek Priest : ' + @EmcPriest
SELECT @EmcFeMalePri = strUserID FROM USERDATA WHERE Class = 204 AND Race = 13 ORDER BY Loyalty Asc
print 'En iyi Elmorad Kadın Priest : ' + @EmcFeMalePri
SELECT @EmcMage = strUserID FROM USERDATA WHERE Class = 210 AND Race = 12 ORDER BY Loyalty Asc
print 'En iyi Elmorad Erkek Mage : ' + @EmcMage
SELECT @EmcFeMaleMage = strUserID FROM USERDATA WHERE Class = 210 AND Race = 13 ORDER BY Loyalty Asc
print 'En iyi Elmorad Kadın Mage : ' + @EmcFeMaleMage
SELECT @EmcRogue = strUserID FROM USERDATA WHERE Class = 208 AND Race = 12 ORDER BY Loyalty Asc
print 'En iyi Elmorad Erkek Rogue : ' + @EmcRogue
SELECT @EmcFeMaleRog = strUserID FROM USERDATA WHERE Class = 208 AND Race = 13 ORDER BY Loyalty Asc
print 'En iyi Elmorad Kadın Rogue : ' + @EmcFeMaleRog
SELECT @OrcWarrior = strUserID FROM USERDATA WHERE Class = 106 AND Race = 1 ORDER BY Loyalty Asc
print 'En Iyi Karus Barbar Warrior : ' + @OrcWarrior
SELECT @OrcPriest = strUserID FROM USERDATA WHERE Class = 104 AND Race = 2 ORDER BY Loyalty Asc
print 'En iyi Karus Erkek Priest : ' + @OrcPriest
SELECT @OrcFeMalePri = strUserID FROM USERDATA WHERE CLass = 104 AND Race = 4 ORDER BY Loyalty Asc
print 'En iyi Karus Kadın Priest : ' + @OrcFeMalePri
SELECT @OrcMage = strUserID FROM USERDATA WHERE Class = 110 AND Race = 3 ORDER BY Loyalty Asc
print 'En iyi Karus Wrinkle Mage : ' + @OrcMage
SELECT @OrcRogue = strUserID FROM USERDATA WHERE Class = 108 AND Race = 2 ORDER BY Loyalty Asc
print 'En iyi Karus Erkek Rogue : ' + @OrcRogue
RETURN
END
GO
</td></tr></table>
Kullanım :
exec Eniyi 'Hepsi'
Bu
prosedür ırka,gender ve np ye göre en iyileri belirliyor.Query Analyser
a yazıp f5 yaparsanız listeyi görebilir ve kopanele
yapıştırabilirsiniz.Tek tek görmek istiyorsanız kullanımda Hepsi yerine
:
Mage,Priest,Warrior,Rogue
yazarak o classların enlerini öğrenebilirsiniz |
| |
|
Anasayfa
