点击联系天涯红月客服!
工作时间: 9:00 - 22:00
客服电话:18953313678
客服QQ:5227433
VIP玩家群: 379155573
红月QQ群: 379155573


抵制不良游戏 拒绝盗版游戏
注意自我保护 谨防受骗上当
适度游戏益脑 沉迷游戏伤身
合理安排时间 享受健康生活
天涯红月无论在新开红月,还是老牌红月中均占有一席之地!天涯红月采用双线专业服务器,在这里让您游戏更有保证!游戏中没有GM确保游戏公平运行!
天涯红月会员增值计划:
详情请点击
信息浏览
红月私服按角色发放不同装备!
www.xtyhy.net  2012/5/12   天涯红月(中文)官方网站-红月十年浩劫风云再起

  CREATE 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, '天涯红月', 0, '千级奖励', 20, '恭喜您到千,一份小礼物,请笑纳

天涯红月
http://www.wanhy.com'')



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, 187, 4, 2, 1, 100, 100, 1, @GameID, 100, 0, @Time, 4,0,0,0,0)
insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime, AttackGrade, StrengthGrade, 

SpiritGrade, DexterityGrade, PowerGrade) values (6, 187, 4, 2, 1, 100, 100, 1, @GameID, 100, 0, @Time, 4,0,0,0,0)
insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime, AttackGrade, StrengthGrade, 

SpiritGrade, DexterityGrade, PowerGrade) values (6, 187, 4, 2, 1, 100, 100, 1, @GameID, 100, 0, @Time, 4,0,0,0,0)
insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime, AttackGrade, StrengthGrade, 

SpiritGrade, DexterityGrade, PowerGrade) values (6, 188, 4, 2, 1, 100, 100, 1, @GameID, 100, 1, @Time, 4,0,0,0,0)
insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime, AttackGrade, StrengthGrade, 

SpiritGrade, DexterityGrade, PowerGrade) values (6, 183, 4, 2, 1, 100, 100, 1, @GameID, 100, 2, @Time, 4,0,0,0,0)
insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime, AttackGrade, StrengthGrade, 

SpiritGrade, DexterityGrade, PowerGrade) values (6, 185, 4, 2, 1, 100, 100, 1, @GameID, 100, 3, @Time, 4,0,0,0,0)
insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime, AttackGrade, StrengthGrade, 

SpiritGrade, DexterityGrade, PowerGrade) values (6, 186, 4, 2, 1, 100, 100, 1, @GameID, 100, 4, @Time, 4,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, 187, 4, 2, 1, 100, 100, 1, @GameID, 100, 0, @Time, 4,0,0,0,0)
insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime, AttackGrade, StrengthGrade, 

SpiritGrade, DexterityGrade, PowerGrade) values (6, 187, 4, 2, 1, 100, 100, 1, @GameID, 100, 0, @Time, 4,0,0,0,0)
insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime, AttackGrade, StrengthGrade, 

SpiritGrade, DexterityGrade, PowerGrade) values (6, 187, 4, 2, 1, 100, 100, 1, @GameID, 100, 0, @Time, 4,0,0,0,0)
insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime, AttackGrade, StrengthGrade, 

SpiritGrade, DexterityGrade, PowerGrade) values (6, 188, 4, 2, 1, 100, 100, 1, @GameID, 100, 1, @Time, 4,0,0,0,0)
insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime, AttackGrade, StrengthGrade, 

SpiritGrade, DexterityGrade, PowerGrade) values (6, 183, 4, 2, 1, 100, 100, 1, @GameID, 100, 2, @Time, 4,0,0,0,0)
insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime, AttackGrade, StrengthGrade, 

SpiritGrade, DexterityGrade, PowerGrade) values (6, 185, 4, 2, 1, 100, 100, 1, @GameID, 100, 3, @Time, 4,0,0,0,0)
insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime, AttackGrade, StrengthGrade, 

SpiritGrade, DexterityGrade, PowerGrade) values (6, 186, 4, 2, 1, 100, 100, 1, @GameID, 100, 4, @Time, 4,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, 190, 4, 2, 1, 100, 100, 1, @GameID, 100, 0, @Time, 4,0,0,0,0)
insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime, AttackGrade, StrengthGrade, 

SpiritGrade, DexterityGrade, PowerGrade) values (6, 190, 4, 2, 1, 100, 100, 1, @GameID, 100, 0, @Time, 4,0,0,0,0)
insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime, AttackGrade, StrengthGrade, 

SpiritGrade, DexterityGrade, PowerGrade) values (6, 190, 4, 2, 1, 100, 100, 1, @GameID, 100, 0, @Time, 4,0,0,0,0)
insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime, AttackGrade, StrengthGrade, 

SpiritGrade, DexterityGrade, PowerGrade) values (6, 188, 4, 2, 1, 100, 100, 1, @GameID, 100, 1, @Time, 4,0,0,0,0)
insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime, AttackGrade, StrengthGrade, 

SpiritGrade, DexterityGrade, PowerGrade) values (6, 183, 4, 2, 1, 100, 100, 1, @GameID, 100, 2, @Time, 4,0,0,0,0)
insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime, AttackGrade, StrengthGrade, 

SpiritGrade, DexterityGrade, PowerGrade) values (6, 185, 4, 2, 1, 100, 100, 1, @GameID, 100, 3, @Time, 4,0,0,0,0)
insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime, AttackGrade, StrengthGrade, 

SpiritGrade, DexterityGrade, PowerGrade) values (6, 186, 4, 2, 1, 100, 100, 1, @GameID, 100, 4, @Time, 4,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, 190, 4, 2, 1, 100, 100, 1, @GameID, 100, 0, @Time, 4,0,0,0,0)
insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime, AttackGrade, StrengthGrade, 

SpiritGrade, DexterityGrade, PowerGrade) values (6, 190, 4, 2, 1, 100, 100, 1, @GameID, 100, 0, @Time, 4,0,0,0,0)
insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime, AttackGrade, StrengthGrade, 

SpiritGrade, DexterityGrade, PowerGrade) values (6, 190, 4, 2, 1, 100, 100, 1, @GameID, 100, 0, @Time, 4,0,0,0,0)
insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime, AttackGrade, StrengthGrade, 

SpiritGrade, DexterityGrade, PowerGrade) values (6, 188, 4, 2, 1, 100, 100, 1, @GameID, 100, 1, @Time, 4,0,0,0,0)
insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime, AttackGrade, StrengthGrade, 

SpiritGrade, DexterityGrade, PowerGrade) values (6, 183, 4, 2, 1, 100, 100, 1, @GameID, 100, 2, @Time, 4,0,0,0,0)
insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime, AttackGrade, StrengthGrade, 

SpiritGrade, DexterityGrade, PowerGrade) values (6, 185, 4, 2, 1, 100, 100, 1, @GameID, 100, 3, @Time, 4,0,0,0,0)
insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime, AttackGrade, StrengthGrade, 

SpiritGrade, DexterityGrade, PowerGrade) values (6, 186, 4, 2, 1, 100, 100, 1, @GameID, 100, 4, @Time, 4,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, 192, 4, 2, 1, 100, 100, 1, @GameID, 100, 0, @Time, 4,0,0,0,0)
insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime, AttackGrade, StrengthGrade, 

SpiritGrade, DexterityGrade, PowerGrade) values (6, 192, 4, 2, 1, 100, 100, 1, @GameID, 100, 0, @Time, 4,0,0,0,0)
insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime, AttackGrade, StrengthGrade, 

SpiritGrade, DexterityGrade, PowerGrade) values (6, 192, 4, 2, 1, 100, 100, 1, @GameID, 100, 0, @Time, 4,0,0,0,0)
insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime, AttackGrade, StrengthGrade, 

SpiritGrade, DexterityGrade, PowerGrade) values (6, 188, 4, 2, 1, 100, 100, 1, @GameID, 100, 1, @Time, 4,0,0,0,0)
insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime, AttackGrade, StrengthGrade, 

SpiritGrade, DexterityGrade, PowerGrade) values (6, 183, 4, 2, 1, 100, 100, 1, @GameID, 100, 2, @Time, 4,0,0,0,0)
insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime, AttackGrade, StrengthGrade, 

SpiritGrade, DexterityGrade, PowerGrade) values (6, 185, 4, 2, 1, 100, 100, 1, @GameID, 100, 3, @Time, 4,0,0,0,0)
insert tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime, AttackGrade, StrengthGrade, 

SpiritGrade, DexterityGrade, PowerGrade) values (6, 186, 4, 2, 1, 100, 100, 1, @GameID, 100, 4, @Time, 4,0,0,0,0)




添加:2012/5/12  录入:WanAdmin  人气:6818

返回】 【顶部】 【关闭

红月私服按角色发放不同装备!--天涯红月(中文)官方网站-红月十年浩劫风云再起