CREATE PROCEDURE RMS_DOITEMGROWTH
@GameID varchar(14),
@WindowKind int,
@WindowIndex int,
@ItemKind int,
@ItemIndex int,
@AttackGrade int,
@StrengthGrade int,
@SpiritGrade int,
@DexterityGrade int,
@PowerGrade int,
@NextItemKind int,
@NextItemIndex int,
@NextAttackGrade int,
@NextStrengthGrade int,
@NextSpiritGrade int,
@NextDexterityGrade int,
@NextPowerGrade int
AS
set nocount on
begin transaction
DECLARE @ItemID int
SET @ItemID= 0
SELECT TOP 1 @ItemID=ID FROM tblSpecialItem1 WHERE GameID=@GameID AND WindowKind=@WindowKind AND WindowIndex=@WindowIndex AND
ItemKind=@ItemKind AND ItemIndex=@ItemIndex AND AttackGrade=@AttackGrade AND StrengthGrade=@StrengthGrade AND SpiritGrade=@SpiritGrade AND DexterityGrade=@DexterityGrade AND PowerGrade=@PowerGrade AND Position=1
IF (@ItemID > 0) AND (@AttackGrade < 2)
BEGIN
UPDATE tblSpecialItem1 SET ItemKind=@NextItemKind,ItemIndex=@NextItemIndex,AttackGrade=@NextAttackGrade,StrengthGrade=@NextStrengthGrade,SpiritGrade=@NextSpiritGrade,DexterityGrade=@NextDexterityGrade, PowerGrade=@NextPowerGrade WHERE ID=@ItemID
END
ELSE
BEGIN
UPDATE tblSpecialItem1 SET ItemKind=@NextItemKind,ItemIndex=@ItemIndex,AttackGrade=@AttackGrade,StrengthGrade=@NextStrengthGrade,SpiritGrade=@NextSpiritGrade,DexterityGrade=@NextDexterityGrade, PowerGrade=@NextPowerGrade WHERE ID=@ItemID
END
commit transaction
GO
修改红色的数字，2为生化最多能改到G，3为最多能改到S，依次类推……(不能大于4)
浏览次数:139
最新文章
· 红月私服管理员命令大全...
· 红月魔法药水使用代码...
· SF端口映射的方法...
· 如何修改客户端游戏IP...
· 下载完整客户端后为何还进不了游戏而是提示错误(原创...
· 生化及兰特的改出方法及代码(原创)...
· 红月地图代码(原创)...
· 人手加帐号...
· 升级及其相关过程(RMS_BONUSPOINT_A...
· 生成并发送邀请Key(D9TX_SENDKEY)...
热门文章
· 购买红月服务端...
· 红月资料(一)...
· 红月私服管理员命令大全...
· 红月单机版制作...
· 红月开区一条龙服务...
· 架设红月服务器步骤...
· 按要求定制红月网站系统...
· 生化变形控制代码(一)...
· 生化及兰特的改出方法及代码(原创)...
· 3.8C红月限制部分外挂的方法...
（本文已被浏览 510 次）
|
|
|
文章评论