Polemick
Genelmoderatör
Mesaj Sayısı : 53
Kayıt tarihi : 23/11/09
Yaş : 33
Nerden : İstanbul
 | Konu: Serverin En iyisini Belirleme  Ptsi Kas. 23, 2009 2:18 pm | |
| Bunu Uygulayın - Kod:
-
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
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 .. | |
|
