再要一个角色转换职业的存储,发下,发下.
再要一个角色转换职业的存储,发下,发下.

最好还能来个删除角色的存储.哈哈...

感谢了..

1. CREATE PROCEDURE [dbo].[DELETE_CHAR]
   
2. @AccountID        char(21),
   
3. @index                tinyint,
   
4. @nation_id        tinyint,
   
5. @CharID        char(21),
   
6. @SocNo        char(17),
   
7. @nKnightsIndex  smallint OUTPUT,
   
8. @nRet                 smallint OUTPUT
   
9. AS
   
10. DECLARE @bCharNum        tinyint, @charid1 char(21), @charid2 char(21), @charid3 char(21), @charid4 char(21), @charid5 char(21), @strSocNo char(17)
    
11. DECLARE @knightsindex smallint
    
12. DECLARE @ForbidFreeTime smalldatetime  -- inserted by ZhiChang Peng 204-07-13
    
13.         SET @bCharNum = 0
    
14.         SET @knightsindex = 0
    
15.         SET @nKnightsIndex = 0
    
16.         SET @ForbidFreeTime = '2000-01-01 00:00:00'
    
17. 
    
18. SELECT @ForbidFreeTime = ForbidFreeTime FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
    
19. IF @ForbidFreeTime > GETDATE()
    
20. BEGIN
    
21.         SET @nRet = -1
    
22.         RETURN
    
23. END
    
24. -- inserted by brad 2004.2.17
    
25. SELECT @strSocNo = strWarehousePW FROM WAREHOUSE WHERE strAccountID = @AccountID
    
26. IF @strSocNo <> @SocNo
    
27. BEGIN
    
28.         SET @nRet = -1
    
29.         RETURN
    
30. END
    
31. IF @nation_id <> 3        -- china
    
32. BEGIN
    
33.         SELECT @strSocNo = strSocNo FROM [Knight_Account].[dbo].[TB_USER] WHERE strAccountID = @AccountID
    
34.         IF @SocNo <> @strSocNo
    
35.         BEGIN
    
36.                 SET @nRet = -1
    
37.                 RETURN
    
38.         END
    
39. END
    
40. SELECT * FROM  [Knight_Account].[dbo].[CURRENTUSER] WHERE strAccountID = @AccountID
    
41. IF @@ROWCOUNT <> 0
    
42. BEGIN
    
43.         SET @nRet = -2
    
44.         RETURN
    
45. END
    
46. -- inserted by samma 2003.07.10
    
47. DECLARE @True smallint
    
48. SET @True = 0
    
49.         SELECT @charid1 = strCharID1, @charid2 = strCharID2, @charid3 = strCharID3 FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
    
50.         IF @CharID = @charid1 or @CharID = @charid2 or @CharID = @charid3
    
51.                 SET @True = 1
    
52.         IF @True = 0
    
53.         BEGIN
    
54.                 SET @nRet = 1
    
55.                 RETURN
    
56.         END
    
57. -- inserted by samma 2003.07.10
    
58. DECLARE        @Nation tinyint, @Race        tinyint, @Class        smallint, @HairColor tinyint, @Rank tinyint, @Title        tinyint, @Level tinyint, @Exp int, @Loyalty int
    
59. DECLARE        @Face        tinyint, @City tinyint, @Knights        smallint, @Fame tinyint,        @Hp smallint, @Mp smallint,  @Sp smallint, @Strong tinyint, @Sta tinyint, @Dex tinyint
    
60. DECLARE        @Intel tinyint, @Cha tinyint, @Authority        tinyint, @Points        tinyint,        @Gold int, @Zone tinyint, @Bind        smallint, @PX int, @PZ int, @PY int, @strSkill varchar(20),        @strItem varchar(400), @strSerial varchar(400) -- @strSerial added by ZhiChang Peng 2004-09-10
    
61. DECLARE          @Members smallint
    
62. DECLARE @sQuestCount smallint, @strQuest varchar(400), @MannerPoint int, @LoyaltyMonthly int-- add by zxujie 03.09.17,MannerPoint added by pengzc 040323, LoyaltyMonthly added by pengzc 040529
    
63. BEGIN TRAN
    
64.         IF @index = 0
    
65.                 UPDATE ACCOUNT_CHAR SET strCHARID1 = NULL, bCharNum = bCharNum - 1 WHERE strAccountID = @AccountID
    
66.         IF @index = 1
    
67.                 UPDATE ACCOUNT_CHAR SET strCHARID2 = NULL, bCharNum = bCharNum - 1 WHERE strAccountID = @AccountID
    
68.         IF @index = 2
    
69.                 UPDATE ACCOUNT_CHAR SET strCHARID3 = NULL, bCharNum = bCharNum - 1 WHERE strAccountID = @AccountID
    
70.         IF @index = 3
    
71.                 UPDATE ACCOUNT_CHAR SET strCHARID4 = NULL, bCharNum = bCharNum - 1 WHERE strAccountID = @AccountID
    
72.         IF @index = 4
    
73.                 UPDATE ACCOUNT_CHAR SET strCHARID5 = NULL, bCharNum = bCharNum - 1 WHERE strAccountID = @AccountID
    
74.         IF @@ERROR <> 0
    
75.         BEGIN
    
76.                 ROLLBACK TRAN
    
77.                 SET @nRet = -2
    
78.                 RETURN
    
79.         END
    
80.         SELECT @charid1 = strCHARID1, @charid2 = strCHARID2, @charid3 = strCHARID3, @charid4 = strCHARID4, @charid5 = strCHARID5 FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
    
81.         IF @charid1 = NULL and @charid2 = NULL and @charid3 = NULL and @charid4 = NULL and @charid5 = NULL          -- ???? ??? ??? ?? ???? ???.. -> ???? ?? ?? ??
    
82.         BEGIN
    
83.                 DELETE FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
    
84.                 IF @@ERROR <> 0
    
85.                 BEGIN
    
86.                         ROLLBACK TRAN
    
87.                         SET @nRet = -2
    
88.                         RETURN
    
89.                 END
    
90.         END
    
91. -- modify by zxujie  03.09.17
    
92.         SELECT @Nation = Nation, @Race = Race, @Class = Class, @HairColor = HairColor, @Rank = Rank, @Title = Title, @Level = [Level], @Exp = [Exp], @Loyalty = Loyalty, @Face = Face, @City = City, @Knights = Knights, @Fame = Fame,
    
93.                  @Hp = Hp, @Mp = Mp, @Sp = Sp, @Strong = Strong, @Sta = Sta, @Dex = Dex, @Intel = Intel, @Cha = Cha, @Authority = Authority, @Points = Points, @Gold = Gold, @Zone = [Zone], @Bind = Bind, @PX = PX, @PZ = PZ, @PY = PY, @strSkill = strSkill, @strItem = strItem, @strSerial = strSerial, @sQuestCount = sQuestCount, @strQuest = strQuest, @MannerPoint = MannerPoint, @LoyaltyMonthly = LoyaltyMonthly
    
94.         FROM        USERDATA WHERE strUserId = @CharID
    
95.         INSERT INTO DELETED_USERDATA (strAccountID, strUserID, Nation, Race, Class, HairColor, Rank, Title, [Level], [Exp], Loyalty, Face, City, Knights, Fame, Hp, Mp, Sp, Strong, Sta, Dex, Intel, Cha, Authority, Points, Gold, [Zone], Bind, PX, PZ, PY, strSkill, strItem, strSerial, sQuestCount, strQuest, MannerPoint, LoyaltyMonthly)
    
96.         VALUES ( @AccountID, @CharID, @Nation, @Race, @Class, @HairColor, @Rank, @Title, @Level, @Exp, @Loyalty, @Face, @City, @Knights, @Fame, @Hp, @Mp, @Sp, @Strong, @Sta, @Dex, @Intel, @Cha, @Authority, @Points, @Gold, @Zone, @Bind, @PX, @PZ, @PY, @strSkill, @strItem, @strSerial, @sQuestCount, @strQuest, @MannerPoint, @LoyaltyMonthly )
    
97. -- modify by zxujie  03.09.17
    
98.         DELETE FROM USERDATA WHERE strUserId = @CharID
    
99.         IF @@ERROR <> 0
    
100.         BEGIN
     
101.                 ROLLBACK TRAN
     
102.                 SET @nRet = -2
     
103.                 RETURN
     
104.         END
     
105.         DELETE FROM KNIGHTS_USER WHERE strUserId = @CharID
     
106.         SELECT @Members=Members FROM KNIGHTS WHERE IDNum = @Knights
     
107.         IF @Members <= 1
     
108.                 UPDATE KNIGHTS SET Members = 1 WHERE IDNum = @Knights
     
109.         ELSE
     
110.                 UPDATE KNIGHTS SET Members = Members - 1 WHERE IDNum = @Knights
     
111. COMMIT TRAN
     
112. SET @nKnightsIndex  = @Knights
     
113. SET @nRet = 1
     
114. 
     
115. GO
     

复制代码

CT,能否解释下呀？