Anasayfa
Giriş yap
Mesaj Sayısı
tarafından 1299 Private Serverlarda, krallık seçimli olan serverlarda ezik çarlarla oy kullanmayı aşağıdaki procedure ile engel olabilirsiniz. Procedure ¢нιgιтα'dan alıntıdır.
Procedurenin Amacı
Serverda aşağıdaki procedureye göre 1K NP'si olmayan (değiştirebilirsiniz) playerlar krallığa oy vermesini engellemek.
Kullanım:
PHP- Kodu:
Procedurenin Amacı
Serverda aşağıdaki procedureye göre 1K NP'si olmayan (değiştirebilirsiniz) playerlar krallığa oy vermesini engellemek.
Kullanım:
- Başlat > Tüm Programlar > Microsoft SQL Server > Query Analyzer ‘ a giriyoruz.
- SQL Server’ a bağlanıyoruz ve açılan ekranda ” master ” yerine ” DBmizi ” seçiyoruz.
- Seçtikten sonra aşağıdaki kodu kopyalayıp , yapıştırıyoruz ve F5 yaparak kodumuzu uyguluyoruz.
PHP- Kodu:
- Kod:
[color=#000000][font=Courier New][color=#FF8000]/****** Object: Stored Procedure dbo.KING_ELECTION_PROC Script Date: 6/6/2006 6:03:33 PM ******/
[/color][color=#007700]-- [/color][color=#0000BB]2004.07.07[/color][color=#007700]. [/color][/font][font=Courier New][color=#DD0000]"tegmen2828 / chigita / istanbul"
[/color][color=#0000BB]CREATE PROCEDURE [/color][color=#007700][[/color][color=#0000BB]dbo[/color][color=#007700]].[[/color][color=#0000BB]KING_ELECTION_PROC[/color][/font][font=Courier New][color=#007700]]
@[/color][color=#0000BB]strAccountID char[/color][color=#007700]([/color][color=#0000BB]21[/color][color=#007700]), -- [/color][color=#0000BB]Voted man[/color][/font][color=#DD0000][font=Courier New]'s account
@strCharID char(21), -- Nick'[/font][/color][font=Courier New][color=#0000BB]s vote
[/color][color=#007700]@[/color][color=#0000BB]byNation tinyint[/color][/font][font=Courier New][color=#007700],
@[/color][color=#0000BB]strCandidacyID char[/color][color=#007700]([/color][color=#0000BB]21[/color][color=#007700]), -- [/color][/font][font=Courier New][color=#0000BB]Nick chosen people
[/color][color=#007700]@[/color][/font][color=#0000BB][font=Courier New]nRet smallint OUTPUT
[/font][/color][color=#007700][font=Courier New]AS
DECLARE @[/font][/color][font=Courier New][color=#0000BB]nRow smallint
SELECT [/color][color=#007700]@[/color][color=#0000BB]nRow [/color][color=#007700]= [/color][color=#0000BB]Count[/color][color=#007700]([/color][color=#0000BB]strAccountID[/color][color=#007700]) [/color][color=#0000BB]FROM KING_BALLOT_BOX WHERE strAccountID [/color][color=#007700]= @[/color][/font][font=Courier New][color=#0000BB]strAccountID
[/color][color=#007700]IF @[/color][color=#0000BB]nRow [/color][color=#007700]> [/color][color=#0000BB]0 [/color][color=#007700]-- [/color][color=#0000BB]Vote [/color][color=#007700]for [/color][/font][font=Courier New][color=#0000BB]one person
BEGIN
SET [/color][color=#007700]@[/color][color=#0000BB]nRet [/color][color=#007700]= -[/color][/font][color=#0000BB][font=Courier New]3
[/font][/color][color=#007700][font=Courier New]RETURN
[/font][/color][font=Courier New][color=#0000BB]END
[/color][color=#007700]DECLARE @[/color][/font][font=Courier New][color=#0000BB]Loyalty int
SELECT [/color][color=#007700]@[/color][color=#0000BB]Loyalty [/color][color=#007700]= [/color][color=#0000BB]Loyalty FROM USERDATA WHERE strUserID [/color][color=#007700]= @[/color][/font][font=Courier New][color=#0000BB]strCharID
[/color][color=#007700]IF @[/color][color=#0000BB]Loyalty [/color][color=#007700]< [/color][/font][font=Courier New][color=#0000BB]1000
BEGIN
SET [/color][color=#007700]@[/color][color=#0000BB]nRet [/color][color=#007700]= -[/color][/font][color=#0000BB][font=Courier New]3
[/font][/color][color=#007700][font=Courier New]RETURN
[/font][/color][font=Courier New][color=#0000BB]END
INSERT INTO KING_BALLOT_BOX [/color][color=#007700]([/color][color=#0000BB]strAccountID[/color][color=#007700], [/color][color=#0000BB]strCharID[/color][color=#007700], [/color][color=#0000BB]byNation[/color][color=#007700], [/color][color=#0000BB]strCandidacyID [/color][/font][font=Courier New][color=#007700])
[/color][color=#0000BB]VALUES [/color][color=#007700]( @[/color][color=#0000BB]strAccountID[/color][color=#007700], @[/color][color=#0000BB]strCharID[/color][color=#007700], @[/color][color=#0000BB]byNation[/color][color=#007700], @[/color][color=#0000BB]strCandidacyID [/color][/font][font=Courier New][color=#007700])
[/color][color=#0000BB]UPDATE KING_ELECTION_LIST SET nMoney [/color][color=#007700]= [/color][color=#0000BB]nMoney [/color][color=#007700]+ [/color][/font][font=Courier New][color=#0000BB]1
WHERE byType [/color][color=#007700]= [/color][color=#0000BB]4 [/color][color=#007700]and [/color][color=#0000BB]strName [/color][color=#007700]= @[/color][/font][font=Courier New][color=#0000BB]strCandidacyID
SET [/color][color=#007700]@[/color][color=#0000BB]nRet [/color][color=#007700]= [/color][/font][color=#0000BB][font=Courier New]1
[/font][/color][color=#007700][font=Courier New]RETURN
[/font][/color][color=#0000BB][font=Courier New]GO[/font][/color][/color]