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

牛啊

眼熟