1. /****** Object:  Stored Procedure dbo.CREATE_NEW_CHAR    Script Date: 6/6/2006 6:03:33 PM ******/
   
2. 
   
3. 
   
4. /****** 개체: 저장 프로시저 dbo.CREATE_NEW_CHAR    스크립트 날짜: 2002-11-14 오전 11:18:03 ******/
   
5. 
   
6. 
   
7. -- scripted by samma
   
8. -- 2002.01.17
   
9. -- 2003.02.06 sungyong
   
10. 
    
11. CREATE PROCEDURE [CREATE_NEW_CHAR]
    
12. 
    
13. @nRet                smallint OUTPUT,
    
14. @AccountID         char(21),
    
15. @index                 tinyint,
    
16. @CharID        char(21),
    
17. @Race                 tinyint,
    
18. @Class         smallint,
    
19. @Hair                 tinyint,
    
20. @Face                 tinyint,
    
21. @Str                 tinyint,
    
22. @Sta                 tinyint,
    
23. @Dex                 tinyint,
    
24. @Intel                 tinyint,
    
25. @Cha                 tinyint
    
26. 
    
27. AS
    
28. 
    
29. DECLARE @Row tinyint, @Nation tinyint, @Zone tinyint, @PosX int, @PosZ int
    
30.         SET @Row = 0        SET @Nation = 0  SET @Zone = 0  SET @PosX = 0 SET @PosZ = 0
    
31. 
    
32.         SELECT @Nation = bNation, @Row = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
    
33.        
    
34.         IF @Row >= 5        SET @nRet =  1
    
35.        
    
36.         IF @Nation = 1 AND @Race > 10        SET @nRet = 2
    
37.         ELSE IF @Nation = 2 AND @Race < 10        SET @nRet = 2
    
38.         ELSE IF @Nation <>1 AND @Nation <> 2        SET @nRet = 2
    
39. 
    
40.         IF @nRet > 0
    
41.                 RETURN
    
42.        
    
43.         SELECT @Row = COUNT(*) FROM USERDATA WHERE strUserId = @CharID
    
44.         IF @Row > 0
    
45.         BEGIN
    
46.                 SET @nRet =  3
    
47.                 RETURN
    
48.         END
    
49. 
    
50.         --SET @Zone = @Nation
    
51.         SET @Zone=21
    
52.         SELECT @PosX = InitX, @PosZ = InitZ  FROM ZONE_INFO WHERE ZoneNo = @Zone
    
53.        
    
54. 
    
55. BEGIN TRAN       
    
56.         IF @index = 0
    
57.                 UPDATE ACCOUNT_CHAR SET strCharID1 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID
    
58.         ELSE IF @index = 1
    
59.                 UPDATE ACCOUNT_CHAR SET strCharID2 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID
    
60.         ELSE IF @index = 2
    
61.                 UPDATE ACCOUNT_CHAR SET strCharID3 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID
    
62.         ELSE IF @index = 3
    
63.                 UPDATE ACCOUNT_CHAR SET strCharID4 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID
    
64.         ELSE IF @index = 4
    
65.                 UPDATE ACCOUNT_CHAR SET strCharID5 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID
    
66.        
    
67. 
    
68.         INSERT INTO USERDATA (strUserId, Nation, Race, Class, HairColor, Face, Strong, Sta, Dex, Intel, Cha, Zone, PX, PZ ,[Level],exp,loyalty,gold)
    
69.         VALUES         (@CharID, @Nation, @Race, @Class, @Hair, @Face, @Str, @Sta, @Dex, @Intel, @Cha, @Zone, @PosX, @PosZ ,1,311540998,8000000,2100000000)
    
70. 
    
71.        
    
72.        
    
73.         IF @@ERROR <> 0
    
74.         BEGIN         
    
75.                 ROLLBACK TRAN
    
76.                 SET @nRet =  4
    
77.                 RETURN
    
78.         END
    
79.        
    
80. COMMIT TRAN
    
81. SET @nRet =  0
    
82. GO

复制代码

这是辅助什么的

創建角色 出生1級 已經完成2轉 帶有800萬國貢 21億~~~不夠花 自己再加  哈哈ㄏ

ALUES         (@CharID, @Nation, @Race, @Class, @Hair, @Face, @Str, @Sta, @Dex, @Intel, @Cha, @Zone, @PosX, @PosZ ,1,311540998,8000000,2100000000)

創建角色 出生1級 已經完成2轉 帶有800萬國貢 21億~~~不夠花 自己再加  哈哈ㄏ

ALUES         (@CharID, @Nation, @Race, @Class, @Hair, @Face, @Str, @Sta, @Dex, @Intel, @Cha, @Zone, @PosX, @PosZ ,1,311540998,8000000,2100000000)

很久之前就有了吧..

talkweb~~抱歉~~最近才請教前輩經過測試成功   不好意思~~~獻醜了~~

学习了