1. /****** Object:  Stored Procedure dbo.KING_ELECTION_PROC    Script Date: 6/6/2006 6:03:33 PM ******/
   
2. CREATE PROCEDURE [dbo].[KING_ELECTION_PROC]
   
3. @strAccountID    char(21),        -- Voted man's account
   
4. @strCharID    char(21),        --     Nick's vote
   
5. @byNation    tinyint,
   
6. @strCandidacyID    char(21),        --     Nick chosen people
   
7. @nRet        smallint OUTPUT
   
8. 
   
9. AS
   
10. 
    
11. DECLARE @nRow smallint
    
12. 
    
13. SELECT @nRow = Count(strAccountID) FROM KING_BALLOT_BOX WHERE  strAccountID = @strAccountID
    
14. IF @nRow > 0        -- Vote for one person
    
15. BEGIN
    
16.     SET @nRet = -3
    
17.     RETURN
    
18. END
    
19. 
    
20. DECLARE @Loyalty int
    
21. SELECT @Loyalty = Loyalty FROM USERDATA WHERE strUserID = @strCharID
    
22. IF @Loyalty < 1000
    
23. BEGIN
    
24.     SET @nRet = -3
    
25.     RETURN
    
26. END
    
27. 
    
28. INSERT INTO KING_BALLOT_BOX (strAccountID, strCharID, byNation, strCandidacyID )
    
29.     VALUES ( @strAccountID, @strCharID, @byNation, @strCandidacyID )
    
30. 
    
31. UPDATE KING_ELECTION_LIST SET nMoney = nMoney + 1
    
32. WHERE  byType = 4 and strName = @strCandidacyID
    
33. 
    
34. SET @nRet =  1
    
35. RETURN
    
36. GO
    

复制代码

1# ctgwglzc


哪里控制贡献多少

挨~版本那里还没搞好，国王系统，暂时用不着，先收住先

收藏了！！

谢谢分享