1. /****** Object:  Stored Procedure dbo.UPDATE_KNIGHTS_ALLIANCE    Script Date: 6/6/2006 6:03:32 PM ******/
   
2. 
   
3. -- Created By Sungyong 2003.06.18
   
4. 
   
5. CREATE PROCEDURE UPDATE_KNIGHTS_ALLIANCE
   
6. @byType                tinyint,
   
7. @shAlliancIndex                smallint,
   
8. @shKnightsIndex        smallint,
   
9. @byEmptyIndex                tinyint,
   
10. @bySiegeFlag                tinyint
    
11. 
    
12. AS
    
13. 
    
14. DECLARE @SubKnightsIndex smallint
    
15. DECLARE @MercenaryClan_1 smallint
    
16. DECLARE @MercenaryClan_2 smallint
    
17. SET @SubKnightsIndex = 0
    
18. SET @MercenaryClan_1 = 0
    
19. SET @MercenaryClan_2 = 0
    
20. 
    
21. IF @byType = 44               
    
22. BEGIN
    
23.         INSERT INTO KNIGHTS_ALLIANCE (sMainAllianceKnights,sSubAllianceKnights,sMercenaryClan_1,sMercenaryClan_2) VALUES (@shAlliancIndex,0,0,0)
    
24.         UPDATE KNIGHTS SET bySiegeFlag = @bySiegeFlag, sAllianceKnights = @shAlliancIndex WHERE IDNum = @shAlliancIndex
    
25. END
    
26. ELSE IF @byType = 46               
    
27. BEGIN
    
28.         IF @byEmptyIndex = 1       
    
29.         BEGIN
    
30.                 UPDATE KNIGHTS_ALLIANCE SET sSubAllianceKnights = @shKnightsIndex WHERE sMainAllianceKnights = @shAlliancIndex       
    
31.                 UPDATE KNIGHTS SET bySiegeFlag = @bySiegeFlag, sAllianceKnights = @shAlliancIndex WHERE IDNum = @shKnightsIndex       
    
32.         END
    
33.         IF @byEmptyIndex = 2       
    
34.         BEGIN
    
35.                 UPDATE KNIGHTS_ALLIANCE SET sMercenaryClan_1 = @shKnightsIndex WHERE sMainAllianceKnights = @shAlliancIndex       
    
36.                 UPDATE KNIGHTS SET bySiegeFlag = @bySiegeFlag, sAllianceKnights = @shAlliancIndex WHERE IDNum = @shKnightsIndex       
    
37.         END
    
38.         IF @byEmptyIndex = 3       
    
39.         BEGIN
    
40.                 UPDATE KNIGHTS_ALLIANCE SET sMercenaryClan_2 = @shKnightsIndex WHERE sMainAllianceKnights = @shAlliancIndex       
    
41.                 UPDATE KNIGHTS SET bySiegeFlag = @bySiegeFlag, sAllianceKnights = @shAlliancIndex WHERE IDNum = @shKnightsIndex       
    
42.         END
    
43. END
    
44. ELSE IF @byType = 47 or @byType =  48               
    
45. BEGIN
    
46.         SELECT @SubKnightsIndex=sSubAllianceKnights, @MercenaryClan_1= sMercenaryClan_1,  @MercenaryClan_2= sMercenaryClan_2 FROM KNIGHTS_ALLIANCE WHERE sMainAllianceKnights = @shAlliancIndex
    
47.         IF @SubKnightsIndex = @shKnightsIndex       
    
48.         BEGIN
    
49.                 UPDATE KNIGHTS_ALLIANCE SET sSubAllianceKnights = 0 WHERE sMainAllianceKnights = @shAlliancIndex       
    
50.         END
    
51.         IF @MercenaryClan_1 = @shKnightsIndex       
    
52.         BEGIN
    
53.                 UPDATE KNIGHTS_ALLIANCE SET sMercenaryClan_1 = 0 WHERE sMainAllianceKnights = @shAlliancIndex       
    
54.         END
    
55.         IF @MercenaryClan_2 = @shKnightsIndex       
    
56.         BEGIN
    
57.                 UPDATE KNIGHTS_ALLIANCE SET sMercenaryClan_2 = 0 WHERE sMainAllianceKnights = @shAlliancIndex       
    
58.         END
    
59. 
    
60.         UPDATE KNIGHTS SET bySiegeFlag = 0, sAllianceKnights = 0 WHERE IDNum = @shKnightsIndex       
    
61. END
    
62. ELSE IF @byType = 49                -- destory alliance
    
63. BEGIN
    
64.         SELECT @SubKnightsIndex=sSubAllianceKnights, @MercenaryClan_1= sMercenaryClan_1,  @MercenaryClan_2= sMercenaryClan_2 FROM KNIGHTS_ALLIANCE WHERE sMainAllianceKnights = @shAlliancIndex
    
65. 
    
66.         UPDATE KNIGHTS SET bySiegeFlag = 0, sAllianceKnights = 0 WHERE IDNum = @shAlliancIndex       
    
67. 
    
68.         IF @SubKnightsIndex <> 0
    
69.         BEGIN
    
70.                 UPDATE KNIGHTS SET bySiegeFlag = 0, sAllianceKnights = 0 WHERE IDNum = @SubKnightsIndex       
    
71.         END
    
72.         IF @MercenaryClan_1 <> 0
    
73.         BEGIN
    
74.                 UPDATE KNIGHTS SET bySiegeFlag = 0, sAllianceKnights = 0 WHERE IDNum = @MercenaryClan_1
    
75.         END
    
76.         IF @MercenaryClan_2 <> 0
    
77.         BEGIN
    
78.                 UPDATE KNIGHTS SET bySiegeFlag = 0, sAllianceKnights = 0 WHERE IDNum = @MercenaryClan_2
    
79.         END
    
80. 
    
81.         DELETE FROM KNIGHTS_ALLIANCE WHERE sMainAllianceKnights = @shAlliancIndex       
    
82. END
    
83. GO

复制代码

楼主好样的!学习了!!

好好学习，天天向上

好东西，谢谢分享

最近好东西越来越多了啊，谢谢分享！拜领，拜领！