riky_lin riky_lin
关注数: 0 粉丝数: 12 发帖数: 445 关注贴吧数: 4
千级系统自动送生化 aSET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO /****** Object: Stored Procedure dbo.RMS_LEVEL1000MAIL Script Date: 2004-5-13 11:21:09 ******/ ALTER PROCEDURE RMS_LEVEL1000MAIL @GameID varchar(14), @Time datetime AS set nocount on declare @MailCount int, @InsertMailError int, @InsertTickError int , @level int , @face int,@WindowKind int,@WindowIndex int,@permission int set @MailCount = 0 set @InsertMailError = 1 set @InsertTickError = 1 begin transaction select @MailCount = count(*) from tblMail1 where Recipient = @GameID and Time = @Time while @MailCount > 0 begin set @MailCount = 0 set @Time = dateadd(second, 1, @Time) select @MailCount = count(*) from tblMail1 where Recipient = @GameID and Time = @Time end insert tblMail1 (Time, Recipient, Sender, ReadOrNot, Title, Line, Content, Item) values(@Time, @GameID, *Redmoon*, 0, *千级奖励*, 20, *通过艰苦的旅程 自我发现和个人发展 磨练技能水平的完善。 但现在你必须集中精神和体能 开发“人工丹药” 增强实力让属性更进一步。 相信可以实现! 如果需要帮助,请找卡森博士*, **) select @InsertMailError = @@ERROR select @Level=lvl from tblGameID1 where @GameID=GameID begin begin select @face=face from tblGameID1 where @GameID=GameID if @face=0 insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime, AttackGrade, StrengthGrade, SpiritGrade, DexterityGrade, PowerGrade) values (6, 107, 4, 2, 1, 100, 100, 1, @GameID, 100, 0, @Time, 0,0,0,0,0) if @face=1 insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime, AttackGrade, StrengthGrade, SpiritGrade, DexterityGrade, PowerGrade) values (6, 108, 4, 2, 1, 100, 100, 1, @GameID, 100, 0, @Time, 0,0,0,0,0) if @face=2 insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime, AttackGrade, StrengthGrade, SpiritGrade, DexterityGrade, PowerGrade) values (6, 110, 4, 2, 1, 100, 100, 1, @GameID, 100, 0, @Time, 0,0,0,0,0) if @face=3 insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime, AttackGrade, StrengthGrade, SpiritGrade, DexterityGrade, PowerGrade) values (6, 110, 4, 2, 1, 100, 100, 1, @GameID, 100, 0, @Time, 0,0,0,0,0) if @face=4 insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime, AttackGrade, StrengthGrade, SpiritGrade, DexterityGrade, PowerGrade) values (6, 112, 4, 2, 1, 100, 100, 1, @GameID, 100, 0, @Time, 0,0,0,0,0) if @face=5 insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime, AttackGrade, StrengthGrade, SpiritGrade, DexterityGrade, PowerGrade) values (6, 114, 4, 2, 1, 100, 100, 1, @GameID, 100, 0, @Time, 0,0,0,0,0) if @face=6 insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime, AttackGrade, StrengthGrade, SpiritGrade, DexterityGrade, PowerGrade) values (6, 111, 4, 2, 1, 100, 100, 1, @GameID, 100, 0, @Time, 0,0,0,0,0) if @face=7 insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime, AttackGrade, StrengthGrade, SpiritGrade, DexterityGrade, PowerGrade) values (6, 110, 4, 2, 1, 100, 100, 1, @GameID, 100, 0, @Time, 0,0,0,0,0) if @face=8 insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime, AttackGrade, StrengthGrade, SpiritGrade, DexterityGrade, PowerGrade) values (6, 113, 4, 2, 1, 100, 100, 1, @GameID, 100, 0, @Time, 0,0,0,0,0) end end select @InsertTickError = @@ERROR If @InsertMailError = 0 and @InsertTickError = 0 begin commit transaction end else begin rollback transaction end GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO
数据库关键数据 角色表:tblGameID1 名称:GameID 帐号:BillID 等级:lvl 名誉:fame 地图:map 任务:StoryQuestState=131071任务全完成(3.8版) 力量:Strength 意志:Spirit 敏捷: Dexterity 骨气:Power 黑名:PKTimer=0不黑 钱:momey 帐号表:tblBillID 无非就是些账号密码之类,这个表没什么介绍的. 装备表:tblSpecialItem1 物品类别:ItemKind (6是特殊装备) 物品索引ItemIndex(详情参考物品索引代码) 物品耐久度:ItemDurability(一般是0,最高是4,对于特装来说,白色是0红色 -1) 未知:Position 地图编号:Map 坐标:X 坐标Y 这个,不清楚:TileKind 角色名称:GameID 这个是装备所处的窗口类别:WindowKind(0表示物品在邮箱,1是F3,2是F8) 窗口索引号:WindowIndex(各个窗口的索引从0开始,比如邮箱就是0-4) 物品得到时间:MiscTime(如果默认为空就是 1990-1-1) 变形次数:AttackGrade (对升华有用,其余装备为0) 力量:StrengthGrade (对升华有用,其余装备为0) 意志:SpiritGrade (对升华有用,其余装备为0) 敏捷:DexterityGrade (对升华有用,其余装备为0) 骨气: PowerGrade (对升华有用,其余装备为0) 邮箱表:tblMail1 发件时间:Time 回复人:Recipient 发件人:Sender 是否已读:ReadOrNot(0是未读) 邮件标题:Title 邮件行数:Line 邮件内容:Content 邮件类别:Item(可以在此存放普通物品.类似代码如0:5-111/100.1:5-149/100.2:5-113/100.) 那行红色的代码表示在邮件的0号索引窗口放入类别为 5 ,索引为 111 的物品100个,在1号索引窗口放入类别为 5 索引号为149的物品 100个.以此类推....
1 下一页