-- 查询角色地图索引
SELECT @wMapIndex = wMapIndex
FROM Character.dbo.USER_CHARACTER
WHERE character_no = @i_user_no; -- 假设character_no和user_no关联
-- 检查查询是否返回结果
IF @@ROWCOUNT = 0
BEGIN
SET @wMapIndex = NULL; -- 未找到记录时设置为NULL
SET @o_sp_rtn = -98; -- 未找到角色记录的特殊返回码
END
ELSE
BEGIN
-- 判断地图索引并设置返回值 (修改为判断wMapIndex是否等于61)
IF @wMapIndex = 61
SET @o_sp_rtn = 0;
ELSE
SET @o_sp_rtn = -99;
END
发表于 2025-6-8 16:30:16
