1. CREATE PROCEDURE CREATE_NEW_CHAR
   
2. 
   
3. @nRet smallint OUTPUT,
   
4. @AccountID char(21),
   
5. @index tinyint,
   
6. @CharID char(21),
   
7. @Race tinyint,
   
8. @Class smallint,
   
9. @Hair tinyint,
   
10. @Face tinyint,
    
11. @Str tinyint,
    
12. @Sta tinyint,
    
13. @Dex tinyint,
    
14. @Intel tinyint,
    
15. @Cha tinyint
    
16. 
    
17. AS
    
18. 
    
19. DECLARE @Row tinyint, @Nation tinyint, @Zone tinyint, @PosX int, @PosZ int
    
20. SET @Row = 0 SET @Nation = 0 SET @Zone = 0 SET @PosX = 0 SET @PosZ = 0
    
21. 
    
22. SELECT @Nation = bNation, @Row = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
    
23. 
    
24. IF @Row >= 5 SET @nRet = 1
    
25. 
    
26. IF @Nation = 1 AND @Race > 10 SET @nRet = 2
    
27. ELSE IF @Nation = 2 AND @Race < 10 SET @nRet = 2
    
28. ELSE IF @Nation <>1 AND @Nation <> 2 SET @nRet = 2
    
29. 
    
30. IF @nRet > 0
    
31. RETURN
    
32. 
    
33. SELECT @Row = COUNT(*) FROM USERDATA WHERE strUserId = @CharID
    
34. IF @Row > 0
    
35. BEGIN
    
36. SET @nRet = 3
    
37. RETURN
    
38. END
    
39. 
    
40. 
    
41. SET @Zone=21
    
42. SELECT @PosX = InitX, @PosZ = InitZ FROM ZONE_INFO WHERE ZoneNo = @Zone
    
43. 
    
44. select @row = 3
    
45. if @CharID like '%___%'
    
46. if @CharID like '%_%'
    
47. if @CharID like '%__%'
    
48. if @CharID like '%:%'
    
49. if @CharID like '%::%'
    
50. begin
    
51. SET @nRet = 3
    
52. RETURN
    
53. 
    
54. 
    
55. END
    
56. BEGIN TRAN
    
57. IF @index = 0
    
58. UPDATE ACCOUNT_CHAR SET strCharID1 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID
    
59. ELSE IF @index = 1
    
60. UPDATE ACCOUNT_CHAR SET strCharID2 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID
    
61. ELSE IF @index = 2
    
62. UPDATE ACCOUNT_CHAR SET strCharID3 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID
    
63. ELSE IF @index = 3
    
64. UPDATE ACCOUNT_CHAR SET strCharID4 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID
    
65. ELSE IF @index = 4
    
66. UPDATE ACCOUNT_CHAR SET strCharID5 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID
    
67. 
    
68. 
    
69. INSERT INTO USERDATA (strUserId, Nation, Race, Class, HairColor, Face, Strong, Sta, Dex, Intel, Cha, Zone, PX, PZ )
    
70. VALUES (@CharID, @Nation, @Race, @Class, @Hair, @Face, @Str, @Sta, @Dex, @Intel, @Cha, @Zone, @PosX, @PosZ )
    
71. 
    
72. 
    
73. exec baslangicitem @CharID
    
74. update userdata set Class = 106 , strong = '255' , sta = '180' ,strskill = '?????P<???' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 101
    
75. update userdata set Class = 108 , strong = '71' , dex = '255' , sta = '169' ,strskill ='P<' , [level] = '83' , hp ='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 102
    
76. update userdata set Class = 110 , strong = '71' , sta = '100' , cha = '194' , intel = '162' ,strskill ='P<' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 103
    
77. update userdata set Class = 112 , strong = '110' , sta = '120' , intel = '230' ,strskill ='P<' , [level] = '83' where struserid = @CharID and @Class = 104
    
78. update userdata set Class = 206 , strong = '255' , sta = '180' ,strskill ='P<' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 201
    
79. update userdata set Class = 208 , strong = '71' , dex = '255' , sta = '169' ,strskill ='P<' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 202
    
80. update userdata set Class = 210 , strong = '71' , sta = '100' , cha = '194' , intel = '162' ,strskill ='P<' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 203
    
81. update userdata set Class = 212 , strong = '110' , sta = '120' , intel = '230' ,strskill ='P<' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 204
    
82. 
    
83. 
    
84. update userdata set Class = 106 where struserid = @CharID and @Class = 101
    
85. update userdata set Class = 108 where struserid = @CharID and @Class = 102
    
86. update userdata set Class = 110 where struserid = @CharID and @Class = 103
    
87. update userdata set Class = 112 where struserid = @CharID and @Class = 104
    
88. update userdata set Class = 206 where struserid = @CharID and @Class = 201
    
89. update userdata set Class = 208 where struserid = @CharID and @Class = 202
    
90. update userdata set Class = 210 where struserid = @CharID and @Class = 203
    
91. update userdata set Class = 212 where struserid = @CharID and @Class = 204
    
92. 
    
93. IF @@ERROR <> 0
    
94. BEGIN
    
95. ROLLBACK TRAN
    
96. SET @nRet = 4
    
97. RETURN
    
98. END
    
99. 
    
100. COMMIT TRAN
     
101. SET @nRet = 0
     
102. GO

复制代码

有什么用的，

這個是做什麼用的?　請教一下~~

介绍一下嘛

看樣子好像是自動分配角色能力點數的存儲似的 說

自动分配能力点数的吗？
我现在的建立人物 还不让一个能力点加完 必须 各加5点。。。。

收下了，谢谢

收下先。。谢谢