CREATE PROCEDURE RMS_LEVEL1000MAIL
@GameID varchar(14),
@Time datetime
AS dedecms.com
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 内容来自dedecms
set @MailCount = 0
set @Time = dateadd(second, 1, @Time)
select @MailCount = count(*) from tblMail1 where Recipient = @GameID and Time = @Time
end
dedecms.com
insert tblMail1 (Time, Recipient, Sender, ReadOrNot, Title, Line, Content, Item) values(@Time, @GameID, '红月', 0, '千级奖励', 20, '恭喜您到千,一份小礼物,请笑纳
红月
'') 织梦内容管理系统
本文来自织梦
select @InsertMailError = @@ERROR
select @Level=lvl from tblGameID1 where @GameID=GameID
begin copyright dedecms
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, 内容来自dedecms
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)
copyright dedecms
织梦内容管理系统
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, copyright dedecms
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, 内容来自dedecms
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, 内容来自dedecms
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, dedecms.com
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, dedecms.com
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, copyright dedecms
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, dedecms.com
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, copyright dedecms
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, dedecms.com
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,
dedecms.com
SpiritGrade, DexterityGrade, PowerGrade) values (6, 186, 4, 2, 1, 100, 100, 1, @GameID, 100, 4, @Time, 4,0,0,0,0)
1.76精品传奇_1.76天下毁灭_1.76复古传奇_英雄合击_中变靓装传奇_无忧传奇
传奇花屏补丁,花屏补丁,土城花屏补丁,盟重土城花屏补丁下载,土城花屏补丁下载,沙巴克花屏补丁,传奇土城花屏补丁下载
网站每天发布最新、最好的传奇版本下载和与传奇服务端配套开区传奇模版,网游技术教程全部免费下载!
无忧网络是目前唯一家所有的传奇服务端,传奇私服花屏补丁,盟重花屏补丁和传奇客户端下载都经过站长亲自测试并配有真实测试图!
所有的工具软件和传奇版本在发布之前,都会经过站长亲自测试,保证chuanqisf可以进入游戏,所有软件都无毒无插件!
本站声明:本站所有技术资料与下载资源均为网络搜集整理,并不代表本站的观点与立场,如有侵犯您的权益,请来信指出,本站将立即改正Copyright © 2002-2014 无忧网络 版权所有蜀ICP备09041899号