4,012
社区成员
发帖
与我相关
我的任务
分享
//取值代码
m_LogonSuccess.dwUserID=m_GameDBAide.GetValue_DWORD(TEXT("UserID"));
m_LogonSuccess.dwCustomID=m_GameDBAide.GetValue_DWORD(TEXT("CustomID"));
// GetValue的具体操作
DWORD CDataBaseAide::GetValue_DWORD(LPCTSTR pszItem)
{
DWORD ulValue;
if (m_pIDataBase != NULL)
{
((CDataBase*)m_pIDataBase)->GetFieldValue(pszItem, ulValue);
return ulValue;
}
return 0;
}
----------------------------------------------------------------------------------------------------
-- I D 登录
ALTER PROC [dbo].[GSP_GR_EfficacyUserID]
@dwUserID INT -- 用户 I D
--@strPassword NCHAR(32), -- 用户密码
--@strClientIP NVARCHAR(15), -- 连接地址
--@strMachineID NVARCHAR(32), -- 机器标识
--@wKindID SMALLINT, -- 游戏 I D
--@wServerID SMALLINT, -- 房间 I D
--@strErrorDescribe NVARCHAR(127) OUTPUT -- 输出信息
--WITH ENCRYPTION
AS
-- 属性设置
SET NOCOUNT ON
-- 基本信息
DECLARE @UserID INT
DECLARE @FaceID SMALLINT
DECLARE @CustomID INT
DECLARE @NickName NVARCHAR(31)
DECLARE @UnderWrite NVARCHAR(63)
-- 扩展信息
DECLARE @GameID INT
DECLARE @GroupID INT
DECLARE @UserRight INT
DECLARE @Gender TINYINT
DECLARE @MasterRight INT
DECLARE @MasterOrder SMALLINT
DECLARE @MemberOrder SMALLINT
DECLARE @GroupName NVARCHAR(31)
-- 积分变量
DECLARE @Score BIGINT
DECLARE @Grade BIGINT
DECLARE @Insure BIGINT
DECLARE @WinCount INT
DECLARE @LostCount INT
DECLARE @DrawCount INT
DECLARE @FleeCount INT
DECLARE @UserMedal INT
DECLARE @Experience INT
DECLARE @LoveLiness INT
-- 执行逻辑
BEGIN
-- 辅助变量
DECLARE @EnjoinLogon INT
-- 查询用户
DECLARE @Nullity BIT
DECLARE @StunDown BIT
DECLARE @LogonPass AS NCHAR(32)
DECLARE @MachineID NVARCHAR(32)
DECLARE @MoorMachine AS TINYINT
SELECT @UserID=UserID, @GameID=GameID, @NickName=NickName, @UnderWrite=UnderWrite, @LogonPass=LogonPass, @FaceID=FaceID, @CustomID=CustomID,
@Gender=Gender, @Nullity=Nullity, @StunDown=StunDown, @UserMedal=UserMedal, @Experience=Experience, @LoveLiness=LoveLiness, @UserRight=UserRight,
@MasterRight=MasterRight, @MasterOrder=MasterOrder, @MemberOrder=MemberOrder, @MoorMachine=MoorMachine, @MachineID=LastLogonMachine
FROM QPAccountsDBLink.QPAccountsDB.dbo.AccountsInfo WHERE UserID=@dwUserID
-- 输出变量
SELECT @UserID AS UserID, @CustomID AS CustomID
END
RETURN 0
CString strVal;
((CRecordset *)p)->SetRowsetCursorPosition(1)
((CRecordset *)p)->GetFieldValue(sName, strVal);
return _tcstoul(strVal, NULL, 10);