agentserverquery.h

奇迹世界data 服务器代码,研究游戏的朋友有帮助

#ifndef __AGENT_SERVER_QUERY_H__
#define __AGENT_SERVER_QUERY_H__

#pragma once
#pragma pack(push, 1)

#include "StructInQuery.h"
#include "QueryPoolFactoryDefine.h"

//=======================================================================================================================
/// 孽府甫 眠啊且 锭 秦具 且 老!
/// 1. 孽府 努贰胶甫 父电促.
/// 2. 孽府 钱 努贰胶俊促啊 胶农赋飘俊 嘎眠绢 殿废茄促.
/// 3. 秦歹颇老阑 父甸菌阑 版快 -> Stdafx.h俊 孽府 努贰胶 颇老 庆歹甫 殿废茄促.
//=======================================================================================================================

//=======================================================================================================================
/// 某腐磐 府胶飘 沥焊 佬绢 坷绰 孽府
//=======================================================================================================================
// 2005/12/28 (taiyo)
// 干滚眠啊 : height, face, hair, 辨靛包访
// 捞抚函版 : CharacterListQuery -> SelectUserQuery
// 俺喊 POOL 备炼肺 函版
class SelectUserQuery : public QueryForUser
{
	_DECLARE_QUERY_POOL(SelectUserQuery)
public:
	enum
	{ 
		RESULT_ROW_NUM = 5,				//< Account Table狼 某腐磐 俺荐
		RESULT_COL_NUM = 17,
	};

	struct sRESULT
	{
		USERGUID	m_UserGuid;
		CHARGUID	m_CharGuid;
		BYTE		m_bySlot;
		TCHAR		m_tszCharName[MAX_CHARNAME_LENGTH];
		BYTE		m_byHeight;
		BYTE		m_byFace;
		BYTE		m_byHair;
		BYTE		m_byClass;
		LEVELTYPE	m_LV;
		DWORD		m_dwRegion;
		WORD		m_wX;
		WORD		m_wY;
		WORD		m_wZ;
		BYTE		m_pEquipItem[MAX_EQUIPITEMSTREAM_SIZE];
		GUILDGUID	m_GuildGuid;
		BYTE		m_GuildPosition;
		TCHAR		m_tszGuildNicName[MAX_CHARNAME_LENGTH];
	} pResult[RESULT_ROW_NUM];

	ULONG uLength[RESULT_COL_NUM];

	_INIT_PARAM_DATA()

	/// 荤侩窍绰 荤恩捞 累己秦具 窍绰 内靛
	_BEGIN_BINDING_DATA( sRESULT, pResult, uLength, RESULT_ROW_NUM, RESULT_COL_NUM )
		_BINDING_COLUMN(0, m_UserGuid)
		_BINDING_COLUMN(1, m_CharGuid)
		_BINDING_COLUMN(2, m_bySlot)
		_BINDING_COLUMN_PTR(3, m_tszCharName)
		_BINDING_COLUMN(4, m_byHeight)
		_BINDING_COLUMN(5, m_byFace)
		_BINDING_COLUMN(6, m_byHair)
		_BINDING_COLUMN(7, m_byClass)
		_BINDING_COLUMN(8, m_LV)
		_BINDING_COLUMN(9, m_dwRegion)
		_BINDING_COLUMN(10, m_wX)
		_BINDING_COLUMN(11, m_wY)
		_BINDING_COLUMN(12, m_wZ)
		_BINDING_COLUMN_PTR(13, m_pEquipItem)
		_BINDING_COLUMN(14, m_GuildGuid)
		_BINDING_COLUMN(15, m_GuildPosition)
		_BINDING_COLUMN_PTR(16, m_tszGuildNicName)
	_END_BINDING_DATA()
};

// 2005/12/28 (taiyo)
// 俺喊 POOL 备炼肺 函版
class CreateCharQuery : public QueryForUser
{
	_DECLARE_QUERY_POOL(CreateCharQuery)
	enum
	{ 
		UPDATE_PARAM_ROW_NUM	= 1,
		UPDATE_PARAM_COL_NUM	= 1,

		SELECT_ROW_NUM	= 1,
		SELECT_COL_NUM	= 14,
	};
public:
	
	struct sRESULT
	{
		USERGUID	m_UserGuid;
		CHARGUID	m_CharGuid;
		BYTE		m_bySlot;
		TCHAR		m_tszCharName[MAX_CHARNAME_LENGTH];
		BYTE		m_byHeight;
		BYTE		m_byFace;
		BYTE		m_byHair;
		BYTE		m_byClass;
		LEVELTYPE	m_LV;
		INT			m_iRegion;
		SHORT		m_sX;
		SHORT		m_sY;
		SHORT		m_sZ;
		BYTE		m_pEquipItem[MAX_EQUIPITEMSTREAM_SIZE];
	} pResult[SELECT_ROW_NUM];
	ULONG uLength[SELECT_COL_NUM];

	struct tag_PARAM
	{
		INT		m_Result;
	} pParam[UPDATE_PARAM_ROW_NUM];
public:
	_BEGIN_PARAM_DATA(tag_PARAM, pParam, UPDATE_PARAM_COL_NUM)
	_BINDING_PARAM( 0, m_Result, SQL_PARAM_OUTPUT )
	_END_PARAM_DATA()

	_BEGIN_BINDING_DATA( sRESULT, pResult, uLength, SELECT_ROW_NUM, SELECT_COL_NUM )
		_BINDING_COLUMN(0, m_UserGuid)
		_BINDING_COLUMN(1, m_CharGuid)
		_BINDING_COLUMN(2, m_bySlot)
		_BINDING_COLUMN_PTR(3, m_tszCharName)
		_BINDING_COLUMN(4, m_byHeight)
		_BINDING_COLUMN(5, m_byFace)
		_BINDING_COLUMN(6, m_byHair)
		_BINDING_COLUMN(7, m_byClass)
		_BINDING_COLUMN(8, m_LV)
		_BINDING_COLUMN(9, m_iRegion)
		_BINDING_COLUMN(10, m_sX)
		_BINDING_COLUMN(11, m_sY)
		_BINDING_COLUMN(12, m_sZ)
		_BINDING_COLUMN_PTR(13, m_pEquipItem)
	_END_BINDING_DATA()

	inline INT GetResult() { return pParam[0].m_Result;	}
};

class DestroyCharQuery : public QueryForUser
{
	enum
	{ 
		UPDATE_DELETE_PARAM_ROW_NUM	= 1,
		UPDATE_DELETE_PARAM_COL_NUM	= 1,
	};
	_DECLARE_QUERY_POOL(DestroyCharQuery)
public:
	struct sQUERY_DELETE_PARAM
	{
		INT		m_Result;
	} pParam[UPDATE_DELETE_PARAM_ROW_NUM];
public:
	_BEGIN_PARAM_DATA(sQUERY_DELETE_PARAM, pParam, UPDATE_DELETE_PARAM_COL_NUM)
	_BINDING_PARAM( 0, m_Result, SQL_PARAM_OUTPUT )
	_END_PARAM_DATA()

	_INIT_BINDING_DATA()

	inline INT GetResult()				{ return pParam[0].m_Result; }
	inline VOID SetSlotIndex( BYTE v )	{ m_bySlotIndex = v; }
	inline BYTE GetSlotIndex()			{ return m_bySlotIndex;	}
private:
	BYTE m_bySlotIndex;
};

#pragma pack(pop, 1)

#endif // __AGENT_SERVER_QUERY_H__