1. CREATE PROCEDURE REPAIR_USER_STAT_POINT
   
2. @strUserID varchar(21)
   
3. AS
   
4. /*
   
5. Author : AKUMA
   
6. 
   
7. */
   
8. DECLARE @Level int,@Class int,@Race int,@NewPoint int,@STR int,@HP int, @DEX int,@INT int,@MP int
   
9. DECLARE @StatTotal int
   
10. 
    
11. SELECT @Level = Level,@Class = Class,@Race = Race,@STR = Strong,@HP = Sta,@DEX = Dex,@INT = Intel,@MP = Cha FROM USERDATA WHERE strUserId = @strUserID
    
12. 
    
13. SET @StatTotal = @STR + @HP + @DEX + @INT + @MP
    
14. 
    
15. 
    
16. IF @Level >= 74 AND @StatTotal <= 350
    
17. BEGIN
    
18. 
    
19.     IF @Level = 74
    
20.         SET @NewPoint = 225
    
21.     IF @Level = 75
    
22.         SET @NewPoint = 230
    
23.     IF @Level = 76
    
24.         SET @NewPoint = 235
    
25.     IF @Level = 77
    
26.         SET @NewPoint = 240
    
27.     IF @Level = 78
    
28.         SET @NewPoint = 245
    
29.     IF @Level = 79
    
30.         SET @NewPoint = 250
    
31.     IF @Level = 80
    
32.         SET @NewPoint = 255
    
33. 
    
34.     IF (@Class = 201) OR (@Class = 205) OR (@Class = 206) OR (@Class = 101) OR (@Class = 105) OR (@Class = 106)
    
35.     BEGIN
    
36. 
    
37.         IF @Race = 1
    
38.             UPDATE USERDATA Set Strong = 65 + 42,Sta = 60,Dex = 65,Intel = 50,Cha = 50,Points = @NewPoint WHERE strUserId = @strUserId
    
39.         ELSE IF @Race = 12
    
40.             UPDATE USERDATA Set Strong = 60 + 42,Sta = 70,Dex = 60,Intel = 50,Cha = 50,Points = @NewPoint WHERE strUserId = @strUserId
    
41.         ELSE IF @Race = 13
    
42.             UPDATE USERDATA Set Strong = 50 + 42,Sta = 70,Dex = 50,Intel = 70,Cha = 50,Points = @NewPoint WHERE strUserId = @strUserId
    
43. 
    
44.     END
    
45.     ELSE IF (@Class = 202) OR (@Class = 207) OR (@Class = 208) OR (@Class = 102) OR (@Class = 107) OR (@Class = 108)
    
46.     BEGIN
    
47.         
    
48.         IF @Race = 2
    
49.             UPDATE USERDATA Set Strong = 60,Sta = 70,Dex = 60 + 42,Intel = 50,Cha = 50,Points = @NewPoint WHERE strUserId = @strUserId
    
50.         ELSE IF @Race = 12
    
51.             UPDATE USERDATA Set Strong = 60,Sta = 70,Dex = 60 + 42,Intel = 50,Cha = 50,Points = @NewPoint WHERE strUserId = @strUserId
    
52.         ELSE IF @Race = 13
    
53.             UPDATE USERDATA Set Strong = 50,Sta = 70,Dex = 50 + 42,Intel = 70,Cha = 50,Points = @NewPoint WHERE strUserId = @strUserId
    
54. 
    
55.     END
    
56.     ELSE IF (@Class = 203) OR (@Class = 209) OR (@Class = 210) OR (@Class = 103) OR (@Class = 109) OR (@Class = 110)
    
57.     BEGIN
    
58. 
    
59.         IF @Race = 3
    
60.             UPDATE USERDATA Set Strong = 50,Sta = 70,Dex = 50,Intel = 70 + 10,Cha = 50 + ***Points = @NewPoint WHERE strUserId = @strUserId
    
61.         ELSE IF @Race = 12
    
62.             UPDATE USERDATA Set Strong = 60,Sta = 70,Dex = 60,Intel = 50 + 10,Cha = 50 + ***Points = @NewPoint WHERE strUserId = @strUserId
    
63.         ELSE IF @Race = 13
    
64.             UPDATE USERDATA Set Strong = 50,Sta = 70,Dex = 50,Intel = 70 + 10,Cha = 50 + ***Points = @NewPoint WHERE strUserId = @strUserId
    
65. 
    
66.     END
    
67.     ELSE IF (@Class = 204) OR (@Class = 211) OR (@Class = 212) OR (@Class = 104) OR (@Class = 111) OR (@Class = 112)
    
68.     BEGIN
    
69. 
    
70.         IF @Race = 4
    
71.             UPDATE USERDATA Set Strong = 60 + 12,Sta = 70 + 10,Dex = 60,Intel = 50 + 20,Cha = 50,Points = @NewPoint WHERE strUserId = @strUserId
    
72.         ELSE IF @Race = 2
    
73.             UPDATE USERDATA Set Strong = 50 + 12,Sta = 60 + 10,Dex = 60,Intel = 70 + 20,Cha = 50,Points = @NewPoint WHERE strUserId = @strUserId
    
74.         ELSE IF @Race = 12
    
75.             UPDATE USERDATA Set Strong = 60 + 12,Sta = 70 + 10,Dex = 60,Intel = 50 + 20,Cha = 50,Points = @NewPoint WHERE strUserId = @strUserId
    
76.         ELSE IF @Race = 13
    
77.             UPDATE USERDATA Set Strong = 50 + 12,Sta = 70 + 10,Dex = 50,Intel = 70 + 20,Cha = 50,Points = @NewPoint WHERE strUserId = @strUserId
    
78. 
    
79.     END
    
80. 
    
81. END

复制代码

1. EXEC REPAIR_USER_STAT_POINT @id -- where @id is a character name variable.

复制代码

确定能用?

试试不就知道了。。。

确定能用?
xy305173481 发表于 2009-6-27 19:51

你看下存储写的是啥撒，搞懂了再搬才行哦