网站地图 设为首页 加入收藏
 
红月私服中心 下载中心 发布红月 技术资料 发布家族 游戏IP生成   开区服务  
红月私服魔法药水使用代码
文章作者:管理员 文章来源:红月私服中心-Www.hy45.Net 更新时间:2012-5-29 14:25:19 

CREATE PROCEDURE RMS_USEMFYW
 @GameID varchar(14),
 @WindowKind int,
 @WindowIndex int
AS
set nocount on
declare @RemoveMFYWError int
set @RemoveMFYWError = 1

begin transaction
 
delete tblSpecialItem1 where ID in (select top 1 ID from tblSpecialItem1 where ItemKind = 6 AND ItemIndex = 204 AND Position = 1 AND GameID = @GameID AND WindowKind = @WindowKind AND WindowIndex = @WindowIndex)
if @@ROWCOUNT > 0 and @@ERROR = 0
  
begin   set @RemoveMFYWError = 0
 
end

UPDATE TBLGAMEID1 SET SETimer='3:957000.8:932000.17:2062000.25:1979000.26:33532437.33:2468000.42:1967000.44:2036000.45:2016000.53:2079000.58:5000.64:3035000.67:2094000.76:2085000.'  where GameID = @GameID
 
delete tblSpecialItem1 where ID in (select top 1 ID from tblSpecialItem1 where ItemKind = 6 AND ItemIndex = 205 AND Position = 1 AND GameID = @GameID AND WindowKind = @WindowKind AND WindowIndex = @WindowIndex)
if @@ROWCOUNT > 0 and @@ERROR = 0
  
begin   set @RemoveMFYWError = 0
 
end

UPDATE TBLGAMEID1 SET SETimer='3:957000.8:932000.17:2062000.25:1979000.26:33532437.33:2468000.42:1967000.44:2036000.45:2016000.53:2079000.58:5000.64:3035000.67:2094000.76:2085000.'  where GameID = @GameID

delete tblSpecialItem1 where ID in (select top 1 ID from tblSpecialItem1 where ItemKind = 6 AND ItemIndex = 206 AND Position = 1 AND GameID = @GameID AND WindowKind = @WindowKind AND WindowIndex = @WindowIndex)
if @@ROWCOUNT > 0 and @@ERROR = 0
  
begin   set @RemoveMFYWError = 0
 
end

UPDATE TBLGAMEID1 SET SETimer='3:957000.8:932000.17:2062000.25:1979000.26:33532437.33:2468000.42:1967000.44:2036000.45:2016000.53:2079000.58:5000.64:3035000.67:2094000.76:2085000.'  where GameID = @GameID
delete tblSpecialItem1 where ID in (select top 1 ID from tblSpecialItem1 where ItemKind = 6 AND ItemIndex = 207 AND Position = 1 AND GameID = @GameID AND WindowKind = @WindowKind AND WindowIndex = @WindowIndex)
if @@ROWCOUNT > 0 and @@ERROR = 0
  
begin   set @RemoveMFYWError = 0
 
end

UPDATE TBLGAMEID1 SET SETimer='3:957000.8:932000.17:2062000.25:1979000.26:33532437.33:2468000.42:1967000.44:2036000.45:2016000.53:2079000.58:5000.64:3035000.67:2094000.76:2085000.'  where GameID = @GameID

if @RemoveMFYWError = 0
begin
 commit transaction
end
else
begin
 rollback transaction
end

没有测试过,请大家自行测试

浏览次数:1
最新文章
· 用15改生化升级存储过程加入一套K生化...
· 红月私服魔法药水使用代码...
· 空中城市进太阳神殿坐标...
· PHP环境架设...
· 红月私服网站在线会员变角色(三)...
· 红月私服网站在线会员变角色(二)...
· 红月私服网站在线会员变角色(一)...
· 短期内快速提升alexa排名的方法大全...
· 红月私服网站在线洗黑名代码(二)...
· 红月私服网站在线洗黑名代码(一)...
热门文章
· 红月技能点属性上限...
· 红月私服角色之说...
· 3.8C红月私服限制部分外挂的方法...
· 调皮外挂不能正常使用...
· 升华原版升级代码...
· 红月服务器如何做到冲卡的...
· 红月NPC各地点坐标...
· 地图能否PK的设置...
· 积分计算方式...
· 红月外挂不能使用新解决办法...
关于我们 开区服务 网站帮助 全部私服
 
CopyRight @2010 hy45.net, Inc. All Rights Reserved  

备案登记号:苏ICP备11017169号-1