生化培养

whongyue · 发表于 2024-4-29 19:38:31

改进了的生化培养存储过程

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 @NextLevel real
DECLARE @ItemID int
SET @ItemID= 0
SET @NextLevel= @NextAttackGrade+@NextStrengthGrade+@NextSpiritGrade+@NextDexterityGrade+@NextPowerGrade
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
BEGIN
IF (@NextLevel/20=Round(@NextLevel/20,0,1)) AND (@NextAttackGrade<4)
BEGIN
UPDATE tblSpecialItem1 SET ItemKind=@NextItemKind,ItemIndex=@NextItemIndex+20,AttackGrade=@AttackGrade+1 WHERE ID=@ItemID
END
ELSE
BEGIN
UPDATE tblSpecialItem1 SET ItemKind=@NextItemKind,ItemIndex=@NextItemIndex,AttackGrade=@NextAttackGrade,StrengthGrade=@NextStrengthGrade,SpiritGrade=@NextSpiritGrade,DexterityGrade=@NextDexterityGrade,PowerGrade=@NextPowerGrade WHERE ID=@ItemID
END
END
commit transaction
GO

复制代码

为了替换现有存储过程，请按照以下步骤操作：

关于升级机制的调整：

在存储过程中，有一部分代码如下：

复制代码

里的20是说升到20次一定改。改成10就是每10次一定改，至于改成1我就没试了，我改成10在我自己的单机上就升了N多生化才一身P的

fsf1982 · 发表于 2024-5-1 15:28:08

个人觉得生化还是随机好，改率稍微高点就ok。固定多少次变有点不好玩

liangxw520 · 发表于 2024-5-1 20:45:21

感谢楼主的分享!很实用，学到很多东西！！楼主加油多分享点使用的东西哦！！加油加油！！

Chinese.Doll · 发表于 2024-5-2 00:06:59

！上向天天，习学好好

		自动登录	找回密码
密码			立即注册

[脚本] 生化培养