RMS_LEVEL1000MAIL

deepinet

1000级发信存储解析

1. ALTER PROCEDURE [dbo].[RMS_LEVEL1000MAIL]
   
2.         @GameID varchar(14),
   
3.         @Time datetime
   
4. AS
   
5. 
   
6. set nocount on
   
7. 
   
8. declare @updatestoryqueststate_error int, @insertmail_error int
   
9. 
   
10. insert tblMail1 (Time, Recipient, Sender, ReadOrNot, Title, Line, Content, Item) values(@Time, @GameID, '[RedMoon]', 0, '[奖励]恭喜您达到1000级！', 13, '
    
11. 你已经通过重重考验达到1000级，
    
12. 如果想继续提升，需要借助于神秘丹药。
    
13. 它能够帮助你到达新的高度。
    
14. 
    
15. 你知道在哪能找到我，我在等你.
    
16. 
    
17. 卡森', '')
    
18. 
    
19. --1000级奖励：生命水X10，钥匙X5，生化箱子X5，毒药X3，石头X1
    
20. insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime) values (6, 197, 4, 2, 1000, 1000, 1000, 1, @GameID, 100, 0, @Time)
    
21. insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime) values (6, 197, 4, 2, 1000, 1000, 1000, 1, @GameID, 100, 0, @Time)
    
22. insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime) values (6, 197, 4, 2, 1000, 1000, 1000, 1, @GameID, 100, 0, @Time)
    
23. 
    
24. insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime) values (6, 214, 4, 2, 1000, 1000, 1000, 1, @GameID, 100, 1, @Time)
    
25. insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime) values (6, 214, 4, 2, 1000, 1000, 1000, 1, @GameID, 100, 1, @Time)
    
26. insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime) values (6, 214, 4, 2, 1000, 1000, 1000, 1, @GameID, 100, 1, @Time)
    
27. 
    
28. insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime) values (6, 213, 4, 2, 1000, 1000, 1000, 1, @GameID, 100, 2, @Time)
    
29. insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime) values (6, 213, 4, 2, 1000, 1000, 1000, 1, @GameID, 100, 2, @Time)
    
30. insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime) values (6, 213, 4, 2, 1000, 1000, 1000, 1, @GameID, 100, 2, @Time)
    
31. insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime) values (6, 213, 4, 2, 1000, 1000, 1000, 1, @GameID, 100, 2, @Time)
    
32. insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime) values (6, 213, 4, 2, 1000, 1000, 1000, 1, @GameID, 100, 2, @Time)
    
33. 
    
34. insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime) values (6, 67, 4, 2, 1000, 1000, 1000, 1, @GameID, 100, 3, @Time)
    
35. insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime) values (6, 67, 4, 2, 1000, 1000, 1000, 1, @GameID, 100, 3, @Time)
    
36. insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime) values (6, 67, 4, 2, 1000, 1000, 1000, 1, @GameID, 100, 3, @Time)
    
37. 
    
38. insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime) values (6, 196, 4, 2, 1000, 1000, 1000, 1, @GameID, 100, 4, @Time)
    
39. 
    
40.         select @insertmail_error = @@ERROR
    
41. 
    
42.         if @updatestoryqueststate_error = 0 AND @insertmail_error = 0
    
43.         begin
    
44. 
    
45.                 commit transaction
    
46. 
    
47.         end
    
48.         else
    
49.         begin
    
50. 
    
51.                 rollback transaction
    
52. 
    
53.         end
    

复制代码

目前在用的版本，汉化了信件内容，并增加了随邮件发送千级奖励的Insert语句。

1. insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime) values (6, 196, 4, 2, 1000, 1000, 1000, 1, @GameID, 100, 4, @Time)

复制代码

借这个语句看一下随信发特的要点：
1.物品MiscTime与发信时间一致，此处用了Time变量统一赋值。
2.邮件附件栏的WindowKind是100，WindowIndex从左到右依次为01234共5个格子，如果多种物品刷到一个格子里，会出现叠放，取出一种还有一种的效果。
3.建议用Map,X,Y值来标记所发物品，数据中以用来区分掉落和发放。

最后，再贴个原版。

1. /****** Object:  Stored Procedure dbo.RMS_LEVEL1000MAIL    Script Date: 2004-5-13 11:21:09 ******/
   
2. 
   
3. 
   
4. ALTER PROCEDURE [dbo].[RMS_LEVEL1000MAIL]
   
5.         @GameID varchar(14),
   
6.         @Time datetime
   
7. AS
   
8. 
   
9. set nocount on
   
10. 
    
11. declare @updatestoryqueststate_error int, @insertmail_error int
    
12. 
    
13. insert tblMail1 (Time, Recipient, Sender, ReadOrNot, Title, Line, Content, Item) values(@Time, @GameID, '[Kasham]', 0, 'Legendary Medicine', 13, '
    
14. You have struggled through an arduous journey
    
15. of self-discovery and personal development that
    
16. has honed your skills to a Level of perfection.
    
17. But now you must focus your body and spirit into
    
18. finding what can only be described as "Legendary
    
19. Medicine"; a pill that when taken by one
    
20. enlightened as you allows you to develop your
    
21. attributes even further. Who knows what you
    
22. can achieve!
    
23. 
    
24. You know where I am if you need me.
    
25. 
    
26. Kasham', '')
    
27. 
    
28. 
    
29.         select @insertmail_error = @@ERROR
    
30. 
    
31.         if @updatestoryqueststate_error = 0 AND @insertmail_error = 0
    
32.         begin
    
33. 
    
34.                 commit transaction
    
35. 
    
36.         end
    
37.         else
    
38.         begin
    
39. 
    
40.                 rollback transaction
    
41. 
    
42.         end
    

复制代码

China娃娃

好好学习,天天向上!