远征ol御兽存储
本帖最后由 bfdz49 于 2025-5-9 15:51 编辑-- 创建宠物装备表
CREATE TABLE .
(
-- 主键字段
INT NOT NULL, -- 角色ID
TINYINT NOT NULL, -- 宠物ID
CHAR(32) NOT NULL, -- 宠物名称，固定32字符
-- 基础状态字段
TINYINT NOT NULL DEFAULT(0), -- 状态
TINYINT NOT NULL DEFAULT(0), -- 攻击状态
TINYINT NOT NULL DEFAULT(0), -- 蛋数量
INT NOT NULL DEFAULT(0), -- 宠物类型
-- 等级和属性相关
INT NOT NULL DEFAULT(1), -- 等级
INT NOT NULL DEFAULT(0), -- 资质
INT NOT NULL DEFAULT(0), -- 能量
INT NOT NULL DEFAULT(0), -- 能量经验
INT NOT NULL DEFAULT(0), -- 喂养次数
INT NOT NULL DEFAULT(0), -- 蛋开始时间
INT NOT NULL DEFAULT(0), -- 疲劳度
INT NOT NULL DEFAULT(0), -- 经验值
-- 基础属性
INT NOT NULL DEFAULT(0), -- 力量
INT NOT NULL DEFAULT(0), -- 智力
INT NOT NULL DEFAULT(0), -- 当前血量
INT NOT NULL DEFAULT(0), -- 最大血量
INT NOT NULL DEFAULT(0), -- 物理攻击
INT NOT NULL DEFAULT(0), -- 魔法攻击
INT NOT NULL DEFAULT(0), -- 物理防御
INT NOT NULL DEFAULT(0), -- 魔法防御
-- 技能相关
INT NOT NULL DEFAULT(0), -- 技能槽数量
-- PK相关数据
INT NOT NULL DEFAULT(0), -- 胜利次数
INT NOT NULL DEFAULT(0), -- 失败次数
INT NOT NULL DEFAULT(0), -- PK次数
INT NOT NULL DEFAULT(0), -- 剩余PK次数
INT NOT NULL DEFAULT(0), -- 邀请PK
-- 武器装备相关
INT NOT NULL DEFAULT(0), -- 当前武器
BINARY(40) NULL DEFAULT(0x), -- 武器数据
BINARY(20) NULL DEFAULT(0x), -- 武器HP加成
BINARY(20) NULL DEFAULT(0x), -- 武器物理攻击加成
BINARY(20) NULL DEFAULT(0x), -- 武器魔法攻击加成
BINARY(20) NULL DEFAULT(0x), -- 武器物理防御加成
BINARY(20) NULL DEFAULT(0x), -- 武器魔法防御加成
BINARY(60) NULL DEFAULT(0x), -- 当前技能
-- 创建时间
DATETIME NOT NULL DEFAULT(GETDATE()),
DATETIME NOT NULL DEFAULT(GETDATE()),
-- 主键约束
CONSTRAINT PRIMARY KEY CLUSTERED
(
ASC,
ASC
)
)
GO
-- 创建索引
CREATE NONCLUSTERED INDEX
ON .()
GO
CREATE NONCLUSTERED INDEX
ON .()
GO
-- 添加表说明
EXEC sp_addextendedproperty
@name = N'MS_Description',
@value = N'角色宠物装备信息表',
@level0type = N'SCHEMA',
@level0name = N'dbo',
@level1type = N'TABLE',
@level1name = N'Actor_Pet_Equipment'
GO
-- 添加字段说明
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'角色ID', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Actor_Pet_Equipment', @level2type = N'COLUMN', @level2name = N'ActorID'
GO
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'宠物ID', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Actor_Pet_Equipment', @level2type = N'COLUMN', @level2name = N'PetID'
GO
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'宠物名称', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Actor_Pet_Equipment', @level2type = N'COLUMN', @level2name = N'PetName'
GO
-------------------------------------------------------------------------------------------------------------
-- 创建宠物封印表
CREATE TABLE .
(
-- 基础标识字段
BINARY(21) NOT NULL, -- 宠物唯一标识
INT NOT NULL, -- 角色ID
TINYINT NOT NULL DEFAULT(0),-- 攻击状态
-- 等级和基础属性
INT NOT NULL DEFAULT(1), -- 等级
INT NOT NULL DEFAULT(0), -- 资质
INT NOT NULL DEFAULT(0), -- 能量
INT NOT NULL DEFAULT(0), -- 能量经验
INT NOT NULL DEFAULT(0), -- 喂养次数
INT NOT NULL DEFAULT(0), -- 疲劳度
INT NOT NULL DEFAULT(0), -- 经验值
-- 战斗属性
INT NOT NULL DEFAULT(0), -- 力量
INT NOT NULL DEFAULT(0), -- 智力
INT NOT NULL DEFAULT(0), -- 当前血量
INT NOT NULL DEFAULT(0), -- 最大血量
INT NOT NULL DEFAULT(0), -- 物理攻击
INT NOT NULL DEFAULT(0), -- 魔法攻击
INT NOT NULL DEFAULT(0), -- 物理防御
INT NOT NULL DEFAULT(0), -- 魔法防御
-- 武器装备相关
INT NOT NULL DEFAULT(0), -- 当前武器
BINARY(40) NULL DEFAULT(0x), -- 武器数据
BINARY(20) NULL DEFAULT(0x), -- 武器HP加成
BINARY(20) NULL DEFAULT(0x), -- 武器物理攻击加成
BINARY(20) NULL DEFAULT(0x), -- 武器魔法攻击加成
BINARY(20) NULL DEFAULT(0x), -- 武器物理防御加成
BINARY(20) NULL DEFAULT(0x), -- 武器魔法防御加成
-- 技能数据
BINARY(60) NULL DEFAULT(0x), -- 当前技能
-- 系统字段
DATETIME NOT NULL DEFAULT(GETDATE()), -- 创建时间
DATETIME NOT NULL DEFAULT(GETDATE()), -- 最后更新时间
-- 主键约束
CONSTRAINT PRIMARY KEY CLUSTERED
(
ASC
)
)
GO
-- 创建索引
CREATE NONCLUSTERED INDEX
ON .()
GO
-- 添加表说明
EXEC sp_addextendedproperty
@name = N'MS_Description',
@value = N'宠物封印信息表',
@level0type = N'SCHEMA',
@level0name = N'dbo',
@level1type = N'TABLE',
@level1name = N'Actor_Pet_Seal'
GO
-- 添加重要字段说明
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'宠物唯一标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Actor_Pet_Seal', @level2type = N'COLUMN', @level2name = N'IDCard'
GO
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'角色ID', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Actor_Pet_Seal', @level2type = N'COLUMN', @level2name = N'ActorID'
GO
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'攻击状态', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Actor_Pet_Seal', @level2type = N'COLUMN', @level2name = N'AttackStatus'
GO
-- 创建更新触发器
CREATE TRIGGER .
ON .
AFTER UPDATE
AS
BEGIN
SET NOCOUNT ON;
UPDATE .
SET = GETDATE()
FROM . t
INNER JOIN inserted i ON t. = i.
END
GO
-- 添加触发器说明
EXEC sp_addextendedproperty
@name = N'MS_Description',
@value = N'自动更新LastUpdateTime触发器',
@level0type = N'SCHEMA',
@level0name = N'dbo',
@level1type = N'TABLE',
@level1name = N'Actor_Pet_Seal',
@level2type = N'TRIGGER',
@level2name = N'TR_Actor_Pet_Seal_Update'
GO
---------------------------------------------------------------------------------------------------------
CREATE PROCEDURE .
@IDCard BINARY(21), -- 宠物唯一标识
@AttackStatus TINYINT, -- 攻击状态
@ActorID INT, -- 角色ID
@nLevel INT, -- 等级
@Qualification INT, -- 资质
@energy INT, -- 能量
@EnergyExp INT, -- 能量经验
@FeedTimes INT, -- 喂养次数
@Tired INT, -- 疲劳度
@experience INT, -- 经验值
@power INT, -- 力量
@Intelligence INT, -- 智力
@CurHP INT, -- 当前血量
@HP INT, -- 最大血量
@PAttackValue INT, -- 物理攻击
@MAttackValue INT, -- 魔法攻击
@PDefenceValue INT, -- 物理防御
@MDefenceValue INT, -- 魔法防御
@CurWeapon INT, -- 当前武器
@Weapons BINARY(40), -- 武器数据
@WeaponsHPEx BINARY(20), -- 武器HP加成
@WeaponsPAEx BINARY(20), -- 武器物理攻击加成
@WeaponsMAEx BINARY(20), -- 武器魔法攻击加成
@WeaponsPDEx BINARY(20), -- 武器物理防御加成
@WeaponsMDEx BINARY(20), -- 武器魔法防御加成
@CurSkills BINARY(60), -- 当前技能
@ResultCode TINYINT OUTPUT -- 输出结果码
AS
BEGIN
SET NOCOUNT ON;
BEGIN TRY
-- 初始化输出参数
SET @ResultCode = 0;
-- 检查必要参数
IF @IDCard IS NULL OR @ActorID = 0
BEGIN
SET @ResultCode = 2;-- 参数错误
RETURN 1;
END
-- 检查是否已存在相同IDCard的记录
IF EXISTS (SELECT 1 FROM . WHERE = @IDCard)
BEGIN
SET @ResultCode = 3;-- 宠物封印已存在
RETURN 1;
END
-- 插入新的宠物封印数据
INSERT INTO .
(
, , ,
, , ,
, , ,
, , ,
, , ,
, , ,
, , ,
, , ,
,
)
VALUES
(
@IDCard, @AttackStatus, @ActorID,
@nLevel, @Qualification, @Energy,
@EnergyExp, @FeedTimes, @Tired,
@Experience, @Power, @Intelligence,
@CurHP, @HP, @PAttackValue,
@MAttackValue, @PDefenceValue, @MDefenceValue,
@CurWeapon, @Weapons, @WeaponsHPEx,
@WeaponsPAEx, @WeaponsMAEx, @WeaponsPDEx,
@WeaponsMDEx, @CurSkills
);
-- 检查插入是否成功
IF @@ROWCOUNT > 0
BEGIN
SET @ResultCode = 1;-- 成功
RETURN 0;
END
ELSE
BEGIN
SET @ResultCode = 4;-- 插入失败
RETURN 1;
END
END TRY
BEGIN CATCH
-- 错误处理
SET @ResultCode = 255;-- 系统错误
-- 记录错误信息
DECLARE @ErrorMessage NVARCHAR(4000) = ERROR_MESSAGE();
DECLARE @ErrorSeverity INT = ERROR_SEVERITY();
DECLARE @ErrorState INT = ERROR_STATE();
-- 可以在这里添加错误日志记录
RAISERROR (@ErrorMessage, @ErrorSeverity, @ErrorState);
RETURN -1;
END CATCH
END
GO
-- 添加存储过程说明
EXEC sp_addextendedproperty
@name = N'MS_Description',
@value = N'添加宠物封印信息',
@level0type = N'SCHEMA',
@level0name = N'dbo',
@level1type = N'PROCEDURE',
@level1name = N'PrGs_Actor_PetSeal_Add_20110824';
GO
-- 添加结果码说明
EXEC sp_addextendedproperty
@name = N'MS_Description',
@value = N'结果码说明：
1 - 成功
2 - 参数错误
3 - 宠物封印已存在
4 - 插入失败
255 - 系统错误',
@level0type = N'SCHEMA',
@level0name = N'dbo',
@level1type = N'PROCEDURE',
@level1name = N'PrGs_Actor_PetSeal_Add_20110824',
@level2type = N'PARAMETER',
@level2name = N'@ResultCode';
GO
-------------------------------------------------------------------------
CREATE PROCEDURE .
@ActorID INT, -- 输入参数
@PetCount BINARY(1) OUTPUT -- 输出参数，使用BINARY(1)替代TINYINT
AS
BEGIN
SET NOCOUNT ON;
-- 初始化输出参数
SET @PetCount = 0x00;
-- 返回ActorID
SELECT @ActorID AS ActorID;
-- 返回宠物详细信息结果集
SELECT
CAST(PetName AS CHAR(32)) AS PetName, -- 宠物名称，固定32字符
CAST(PetID AS BINARY(1)) AS PetID, -- 宠物ID，1字节二进制
CAST(Status AS BINARY(1)) AS Status, -- 状态，1字节二进制
CAST(AttackStatus AS BINARY(1)) AS AttackStatus, -- 攻击状态，1字节二进制
CAST(EggNum AS BINARY(1)) AS EggNum, -- 蛋数量，1字节二进制
CAST(PetType AS INT) AS PetType, -- 宠物类型
CAST(nLevel AS INT) AS nLevel, -- 等级
CAST(Qualification AS INT) AS Qualification, -- 资质
CAST(Energy AS INT) AS Energy, -- 能量
CAST(EnergyExp AS INT) AS EnergyExp, -- 能量经验
CAST(FeedTimes AS INT) AS FeedTimes, -- 喂养次数
CAST(EggBeginTime AS INT) AS EggBeginTime, -- 蛋开始时间
CAST(Tired AS INT) AS Tired, -- 疲劳度
CAST(Experience AS INT) AS Experience, -- 经验
CAST(Power AS INT) AS Power, -- 力量
CAST(Intelligence AS INT) AS Intelligence,-- 智力
CAST(CurHP AS INT) AS CurHP, -- 当前血量
CAST(HP AS INT) AS HP, -- 最大血量
CAST(PAttackValue AS INT) AS PAttackValue, -- 物理攻击
CAST(MAttackValue AS INT) AS MAttackValue, -- 魔法攻击
CAST(PDefenceValue AS INT) AS PDefenceValue, -- 物理防御
CAST(MDefenceValue AS INT) AS MDefenceValue, -- 魔法防御
CAST(SkillsSlotNum AS INT) AS SkillsSlotNum, -- 技能槽数量
CAST(WinNum AS INT) AS WinNum, -- 胜利次数
CAST(LoseNum AS INT) AS LoseNum, -- 失败次数
CAST(PKNum AS INT) AS PKNum, -- PK次数
CAST(PKNumLeave AS INT) AS PKNumLeave, -- 剩余PK次数
CAST(InvitePK AS INT) AS InvitePK, -- 邀请PK
CAST(CurWeapon AS INT) AS CurWeapon, -- 当前武器
-- 二进制数据字段，使用0x作为默认值
CAST(Weapons AS BINARY(40)) AS Weapons, -- 武器数据
CAST(WeaponsHPEx AS BINARY(20)) AS WeaponsHPEx,-- 武器HP加成
CAST(WeaponsPAEx AS BINARY(20)) AS WeaponsPAEx,-- 武器物理攻击加成
CAST(WeaponsMAEx AS BINARY(20)) AS WeaponsMAEx,-- 武器魔法攻击加成
CAST(WeaponsPDEx AS BINARY(20)) AS WeaponsPDEx,-- 武器物理防御加成
CAST(WeaponsMDEx AS BINARY(20)) AS WeaponsMDEx,-- 武器魔法防御加成
CAST(CurSkills AS BINARY(60)) AS CurSkills -- 当前技能
FROM .
WHERE ActorID = @ActorID;
-- 设置返回的宠物数量
SET @PetCount = (
SELECT CAST(COUNT(*) AS BINARY(1))
FROM .
WHERE ActorID = @ActorID
);
RETURN 0;
END
GO
-- 添加存储过程说明
EXEC sp_addextendedproperty
@name = N'MS_Description',
@value = N'获取角色宠物信息',
@level0type = N'SCHEMA',
@level0name = N'dbo',
@level1type = N'PROCEDURE',
@level1name = N'PrGs_Actor_PetPart_Get_20111217';
GO
--------------------------------------------------------------------------------------
CREATE PROCEDURE .
@ActorID INT -- 角色ID
AS
BEGIN
SET NOCOUNT ON;
BEGIN TRY
-- 查询宠物封印信息
SELECT
CAST( AS BINARY(21)) AS , -- 宠物唯一标识
CAST( AS TINYINT) AS ,-- 攻击状态
CAST( AS INT) AS , -- 角色ID
CAST( AS INT) AS , -- 等级
CAST( AS INT) AS , -- 资质
CAST( AS INT) AS , -- 能量
CAST( AS INT) AS , -- 能量经验
CAST( AS INT) AS , -- 喂养次数
CAST( AS INT) AS , -- 疲劳度
CAST( AS INT) AS , -- 经验值
CAST( AS INT) AS , -- 力量
CAST( AS INT) AS , -- 智力
CAST( AS INT) AS , -- 当前血量
CAST( AS INT) AS , -- 最大血量
CAST( AS INT) AS , -- 物理攻击
CAST( AS INT) AS , -- 魔法攻击
CAST( AS INT) AS ,-- 物理防御
CAST( AS INT) AS ,-- 魔法防御
CAST( AS INT) AS , -- 当前武器
CAST( AS BINARY(40)) AS , -- 武器数据
CAST( AS BINARY(20)) AS , -- 武器HP加成
CAST( AS BINARY(20)) AS , -- 武器物理攻击加成
CAST( AS BINARY(20)) AS , -- 武器魔法攻击加成
CAST( AS BINARY(20)) AS , -- 武器物理防御加成
CAST( AS BINARY(20)) AS , -- 武器魔法防御加成
CAST( AS BINARY(60)) AS -- 当前技能
FROM .
WHERE = @ActorID;
-- 如果没有找到记录，返回0
IF @@ROWCOUNT = 0
RETURN 0;
RETURN 1;-- 成功找到记录
END TRY
BEGIN CATCH
-- 错误处理
DECLARE @ErrorMessage NVARCHAR(4000) = ERROR_MESSAGE();
DECLARE @ErrorSeverity INT = ERROR_SEVERITY();
DECLARE @ErrorState INT = ERROR_STATE();
-- 可以在这里添加错误日志记录
RAISERROR (@ErrorMessage, @ErrorSeverity, @ErrorState);
RETURN -1;-- 发生错误
END CATCH
END
GO
-- 添加存储过程说明
EXEC sp_addextendedproperty
@name = N'MS_Description',
@value = N'获取角色宠物封印信息',
@level0type = N'SCHEMA',
@level0name = N'dbo',
@level1type = N'PROCEDURE',
@level1name = N'PrGs_Actor_PetSeal_Get';
GO
-- 添加返回值说明
EXEC sp_addextendedproperty
@name = N'MS_Description',
@value = N'返回值说明：
1 - 成功找到记录
0 - 未找到记录
-1 - 系统错误',
@level0type = N'SCHEMA',
@level0name = N'dbo',
@level1type = N'PROCEDURE',
@level1name = N'PrGs_Actor_PetSeal_Get';
GO
-----------------------------------------------------------------------------------
CREATE PROCEDURE .
@IDCard BINARY(21), -- 宠物唯一标识
@ResultCode TINYINT OUTPUT-- 输出结果码
AS
BEGIN
SET NOCOUNT ON;
BEGIN TRY
-- 初始化输出参数
SET @ResultCode = 0;
-- 检查参数
IF @IDCard IS NULL
BEGIN
SET @ResultCode = 2;-- 参数错误
RETURN 1;
END
-- 检查记录是否存在
IF NOT EXISTS (SELECT 1 FROM . WHERE = @IDCard)
BEGIN
SET @ResultCode = 3;-- 记录不存在
RETURN 1;
END
-- 删除宠物封印记录
DELETE FROM .
WHERE = @IDCard;
-- 检查删除是否成功
IF @@ROWCOUNT > 0
BEGIN
SET @ResultCode = 1;-- 删除成功
RETURN 0;
END
ELSE
BEGIN
SET @ResultCode = 4;-- 删除失败
RETURN 1;
END
END TRY
BEGIN CATCH
-- 错误处理
SET @ResultCode = 255;-- 系统错误
-- 记录错误信息
DECLARE @ErrorMessage NVARCHAR(4000) = ERROR_MESSAGE();
DECLARE @ErrorSeverity INT = ERROR_SEVERITY();
DECLARE @ErrorState INT = ERROR_STATE();
-- 可以在这里添加错误日志记录
RAISERROR (@ErrorMessage, @ErrorSeverity, @ErrorState);
RETURN -1;
END CATCH
END
GO
-- 添加存储过程说明
EXEC sp_addextendedproperty
@name = N'MS_Description',
@value = N'删除宠物封印信息',
@level0type = N'SCHEMA',
@level0name = N'dbo',
@level1type = N'PROCEDURE',
@level1name = N'PrGs_Actor_PetSeal_Del';
GO
-- 添加结果码说明
EXEC sp_addextendedproperty
@name = N'MS_Description',
@value = N'结果码说明：
1 - 删除成功
2 - 参数错误
3 - 记录不存在
4 - 删除失败
255 - 系统错误',
@level0type = N'SCHEMA',
@level0name = N'dbo',
@level1type = N'PROCEDURE',
@level1name = N'PrGs_Actor_PetSeal_Del',
@level2type = N'PARAMETER',
@level2name = N'@ResultCode';
GO创建表Actor_Pet
创建表PetPart这个我还没有认真去改 他自动记录玩家信息
启动成功 ERROR: 读取御兽信息成功
存储PrGs_Actor_PetPart_Get_20111217跟服务端一致，例如
<config spname = 'PrGs_Actor_PetPart_Get_20111217' level = '10' databaseid = '1'></config>
<inputdata variablename = 'ActorID' size = '4'></inputdata>
<param paramname = '@ActorID' datatype = 'int' size = '4' dirtype = 'input' inputdataname = 'ActorID'></param>
<param paramname = '@PetCount' datatype = 'byte' size = '1' dirtype = 'output' inputdataname = '-'></param>
<outputdata variablename = 'ActorID' size = '4' source = 'dd' datatype = 'int'></outputdata>
<outputdata variablename = '@PetCount' size = '1' source = 'sp' datatype = 'byte'></outputdata>
<resultset variablename = 'PetName' size = '32' source = 'sp' datatype = 'char'></resultset>
<resultset variablename = 'PetID' size = '1' source = 'sp' datatype = 'byte'></resultset>
<resultset variablename = 'Status' size = '1' source = 'sp' datatype = 'byte'></resultset>
<resultset variablename = 'AttackStatus' size = '1' source = 'sp' datatype = 'byte'></resultset>
<resultset variablename = 'EggNum' size = '1' source = 'sp' datatype = 'byte'></resultset>
<resultset variablename = 'PetType' size = '4' source = 'sp' datatype = 'int'></resultset>
<resultset variablename = 'nLevel' size = '4' source = 'sp' datatype = 'int'></resultset>
<resultset variablename = 'Qualification' size = '4' source = 'sp' datatype = 'int'></resultset>
<resultset variablename = 'Energy' size = '4' source = 'sp' datatype = 'int'></resultset>
<resultset variablename = 'EnergyExp' size = '4' source = 'sp' datatype = 'int'></resultset>
<resultset variablename = 'FeedTimes' size = '4' source = 'sp' datatype = 'int'></resultset>
<resultset variablename = 'EggBeginTime' size = '4' source = 'sp' datatype = 'int'></resultset>
<resultset variablename = 'Tired' size = '4' source = 'sp' datatype = 'int'></resultset>
<resultset variablename = 'Experience' size = '4' source = 'sp' datatype = 'int'></resultset>
<resultset variablename = 'Power' size = '4' source = 'sp' datatype = 'int'></resultset>
<resultset variablename = 'Intelligence' size = '4' source = 'sp' datatype = 'int'></resultset>
<resultset variablename = 'CurHP' size = '4' source = 'sp' datatype = 'int'></resultset>
<resultset variablename = 'HP' size = '4' source = 'sp' datatype = 'int'></resultset>
<resultset variablename = 'PAttackValue' size = '4' source = 'sp' datatype = 'int'></resultset>
<resultset variablename = 'MAttackValue' size = '4' source = 'sp' datatype = 'int'></resultset>
<resultset variablename = 'PDefenceValue' size = '4' source = 'sp' datatype = 'int'></resultset>
<resultset variablename = 'MDefenceValue' size = '4' source = 'sp' datatype = 'int'></resultset>
<resultset variablename = 'SkillsSlotNum' size = '4' source = 'sp' datatype = 'int'></resultset>
<resultset variablename = 'WinNum' size = '4' source = 'sp' datatype = 'int'></resultset>
<resultset variablename = 'LoseNum' size = '4' source = 'sp' datatype = 'int'></resultset>
<resultset variablename = 'PKNum' size = '4' source = 'sp' datatype = 'int'></resultset>
<resultset variablename = 'PKNumLeave' size = '4' source = 'sp' datatype = 'int'></resultset>
<resultset variablename = 'InvitePK' size = '4' source = 'sp' datatype = 'int'></resultset>
<resultset variablename = 'CurWeapon' size = '4' source = 'sp' datatype = 'int'></resultset>
<resultset variablename = 'Weapons' size = '40' source = 'sp' datatype = 'bin'></resultset>
<resultset variablename = 'WeaponsHPEx' size = '20' source = 'sp' datatype = 'bin'></resultset>
<resultset variablename = 'WeaponsPAEx' size = '20' source = 'sp' datatype = 'bin'></resultset>
<resultset variablename = 'WeaponsMAEx' size = '20' source = 'sp' datatype = 'bin'></resultset>
<resultset variablename = 'WeaponsPDEx' size = '20' source = 'sp' datatype = 'bin'></resultset>
<resultset variablename = 'WeaponsMDEx' size = '20' source = 'sp' datatype = 'bin'></resultset>
<resultset variablename = 'CurSkills' size = '60' source = 'sp' datatype = 'bin'><
谢谢分享 大佬，出个整合吧。我看你发的教程很多 大佬牛逼，谢谢分享 为大佬的坚持精神点赞
页:
[1]