guildserverquery.h

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

#pragma once
#pragma pack(push, 1)

#include <Define.h>
#include "StructInQuery.h"

// 辨靛 沥焊 select
class SelectGuildQuery: public QueryForUser
{
	_DECLARE_QUERY_POOL(SelectGuildQuery)
public:
	enum
	{ 
		PARAM_ROW_NUM	= 1,
		PARAM_COL_NUM	= 1,

		RESULT_ROW_NUM	= 1,
		RESULT_COL_NUM	= 14,
	};
	struct sPARAM
	{
		INT	m_Result;
	} pParam[PARAM_ROW_NUM];

	struct sQUERY
	{
		TCHAR	m_tszGuildName[MAX_GUILDNAME_LENGTH];
		BYTE	m_GuildGrade;
		BYTE	m_MarkBinary[MAX_GUILDMARKSTREAM_SIZE];
		INT		m_MasterCharGuid;
		TCHAR	m_tszMasterCharName[MAX_CHARNAME_LENGTH];
		TCHAR	m_tszGuildNotice[MAX_GUILDNOTICE_LENGTH];
		UPTYPE	m_GuildUserPoint;
		GPTYPE	m_GuildPoint;
		TCHAR	m_tszAgainstGuild[MAX_GUILDNAME_LENGTH];
		TCHAR	m_tszAllianceGuild[MAX_GUILDNAME_LENGTH];
		BYTE	m_pGuildStyle[MAX_GUILDSTYLESTREAM_SIZE];
		INT		m_RestrictedRight;
		BYTE	m_GuildWarehouse[MAX_GUILDWAREHOUSESTREAM_SIZE];
		INT64	m_GuildMoney;
	}pResult[RESULT_ROW_NUM];

	ULONG uLength[RESULT_COL_NUM];

	_BEGIN_PARAM_DATA		(sPARAM, pParam, PARAM_COL_NUM)
		_BINDING_PARAM		(0, m_Result, SQL_PARAM_OUTPUT)
	_END_PARAM_DATA			()

	_BEGIN_BINDING_DATA		(sQUERY, pResult, uLength, RESULT_ROW_NUM, RESULT_COL_NUM)		
		_BINDING_COLUMN_PTR	(0, m_tszGuildName)
		_BINDING_COLUMN		(1, m_GuildGrade)
		_BINDING_COLUMN_PTR	(2, m_MarkBinary)
		_BINDING_COLUMN		(3, m_MasterCharGuid)
		_BINDING_COLUMN_PTR	(4, m_tszMasterCharName);
		_BINDING_COLUMN_PTR	(5, m_tszGuildNotice);
		_BINDING_COLUMN		(6, m_GuildUserPoint)
		_BINDING_COLUMN		(7, m_GuildPoint)
		_BINDING_COLUMN_PTR	(8, m_tszAgainstGuild);
		_BINDING_COLUMN_PTR	(9, m_tszAllianceGuild);
		_BINDING_COLUMN_PTR	(10, m_pGuildStyle);
		_BINDING_COLUMN		(11, m_RestrictedRight)
		_BINDING_COLUMN_PTR	(12, m_GuildWarehouse)
		_BINDING_COLUMN		(13, m_GuildMoney)
	_END_BINDING_DATA		()

	inline BOOL ResultSuccess() { return (pParam[0].m_Result==0); }
public:
	VOID		SetGuildGuid( GUILDGUID GuildGuid ) { m_GuildGuid = GuildGuid;	}
	GUILDGUID	GetGuildGuid()						{ return m_GuildGuid; }
	DWORD		GetSessionIndex()					{ return m_dwSessionIndex; }
	VOID		SetSessionIndex( DWORD idx )		{ m_dwSessionIndex = idx; }
private: 
	GUILDGUID	m_GuildGuid;
	DWORD		m_dwSessionIndex;
};


// 辨靛盔 沥焊 府胶飘 select
class SelectGuildMemberQuery: public QueryForUser
{
	_DECLARE_QUERY_POOL(SelectGuildMemberQuery)
public:
	enum
	{ 
		PARAM_ROW_NUM	= 1,
		PARAM_COL_NUM	= 1,

		RESULT_ROW_NUM	= 60,
		RESULT_COL_NUM	= 5,
	};
	struct sPARAM
	{
		INT	m_Result;
	} pParam[PARAM_ROW_NUM];

	struct sQUERY
	{
		INT			m_CharGUID;
		TCHAR		m_tszCharName[MAX_CHARNAME_LENGTH];
		BYTE		m_byClass;
		LEVELTYPE	m_LV;
		BYTE		m_byPosition;
	}pResult[RESULT_ROW_NUM];

	ULONG uLength[RESULT_COL_NUM];

	_BEGIN_PARAM_DATA		(sPARAM, pParam, PARAM_COL_NUM)
		_BINDING_PARAM		(0, m_Result, SQL_PARAM_OUTPUT)
	_END_PARAM_DATA			()

	_BEGIN_BINDING_DATA		(sQUERY, pResult, uLength, RESULT_ROW_NUM, RESULT_COL_NUM)		
		_BINDING_COLUMN		(0, m_CharGUID)
		_BINDING_COLUMN_PTR	(1, m_tszCharName)
		_BINDING_COLUMN		(2, m_byClass)
		_BINDING_COLUMN		(3, m_LV)
		_BINDING_COLUMN		(4, m_byPosition)
	_END_BINDING_DATA		()

	inline BOOL ResultSuccess() { return (pParam[0].m_Result==0); }
public:
	VOID		SetGuildGuid( GUILDGUID GuildGuid ) { m_GuildGuid = GuildGuid;	}
	GUILDGUID	GetGuildGuid()						{ return m_GuildGuid; }
	VOID		SetSelectGuildQuery( SelectGuildQuery * pQuery ) { m_pSelectGuildQuery = pQuery; }
	SelectGuildQuery * GetSelectGuildQuery()		{ return m_pSelectGuildQuery; }
	DWORD		GetSessionIndex()				{ return m_dwSessionIndex; }
	VOID		SetSessionIndex( DWORD idx )	{ m_dwSessionIndex = idx; }
private: 
	GUILDGUID	m_GuildGuid;
	SelectGuildQuery * m_pSelectGuildQuery;
	DWORD		m_dwSessionIndex;
};

// 辨靛 积己 
class CreateGuildQuery: public QueryForUser
{
	_DECLARE_QUERY_POOL(CreateGuildQuery)
public:
	enum
	{ 
		PARAM_ROW_NUM	= 1,
		PARAM_COL_NUM	= 1,

		RESULT_ROW_NUM	= 1,
		RESULT_COL_NUM	= 1,

		RETURNCODE_SUCCESS				= 0,
		RETURNCODE_DUPLICATE_NAME		= 1,
		RETURNCODE_JOIN_ANOTHER_GUILD	= 2,
	};
	struct sPARAM
	{
		INT	m_Result;
	} pParam[PARAM_ROW_NUM];

	struct sQUERY
	{
		INT		m_GuildGuid;
	}pResult[RESULT_ROW_NUM];

	ULONG uLength[RESULT_COL_NUM];

	_BEGIN_PARAM_DATA		(sPARAM, pParam, PARAM_COL_NUM)
		_BINDING_PARAM		(0, m_Result, SQL_PARAM_OUTPUT)
	_END_PARAM_DATA			()

	_BEGIN_BINDING_DATA		(sQUERY, pResult, uLength, RESULT_ROW_NUM, RESULT_COL_NUM)		
		_BINDING_COLUMN		(0, m_GuildGuid)
	_END_BINDING_DATA		()

	inline INT ResultCode() { return pParam[0].m_Result; }
public:
	VOID		SetCharGuid( CHARGUID guid )	{ m_CharGuid = guid;	}
	CHARGUID	GetCharGuid()					{ return m_CharGuid; }
	DWORD		GetSessionIndex()				{ return m_dwSessionIndex; }
	VOID		SetSessionIndex( DWORD idx )	{ m_dwSessionIndex = idx; }
private:
	CHARGUID	m_CharGuid;
	DWORD		m_dwSessionIndex;
};

// 辨靛 秦眉
class DestroyGuildQuery: public QueryForUser
{
	_DECLARE_QUERY_POOL(DestroyGuildQuery)
public:
	enum
	{ 
		PARAM_ROW_NUM	= 1,
		PARAM_COL_NUM	= 1,
	};
	struct sPARAM
	{
		INT	m_Result;
	} pParam[PARAM_ROW_NUM];


	_BEGIN_PARAM_DATA		(sPARAM, pParam, PARAM_COL_NUM)
		_BINDING_PARAM		(0, m_Result, SQL_PARAM_OUTPUT)
	_END_PARAM_DATA			()

	_INIT_BINDING_DATA()

	inline BOOL ResultSuccess() { return (pParam[0].m_Result==0); }
public:
	VOID		SetGuildGuid( GUILDGUID GuildGuid ) { m_GuildGuid = GuildGuid;	}
	GUILDGUID	GetGuildGuid()						{ return m_GuildGuid; }
	DWORD		GetSessionIndex()				{ return m_dwSessionIndex; }
	VOID		SetSessionIndex( DWORD idx )	{ m_dwSessionIndex = idx; }
private:
	GUILDGUID	m_GuildGuid;
	DWORD		m_dwSessionIndex;
};

// 辨靛盔 啊涝
class JoinGuildMemberQuery: public QueryForUser
{
	_DECLARE_QUERY_POOL(JoinGuildMemberQuery)
public:
	enum
	{ 
		PARAM_ROW_NUM	= 1,
		PARAM_COL_NUM	= 1,

		RETURNCODE_SUCCESS				= 0,
		RETURNCODE_NOT_EXIST_GUILD		= 1,
		RETURNCODE_JOIN_ANOTHER_GUILD	= 2,
	};
	struct sPARAM
	{
		INT	m_Result;
	} pParam[PARAM_ROW_NUM];

	_BEGIN_PARAM_DATA		(sPARAM, pParam, PARAM_COL_NUM)
		_BINDING_PARAM		(0, m_Result, SQL_PARAM_OUTPUT)
	_END_PARAM_DATA			()

	_INIT_BINDING_DATA()

	inline INT ResultCode() { return pParam[0].m_Result; }
public:
	VOID		SetGuildGuid( GUILDGUID GuildGuid ) { m_GuildGuid = GuildGuid;	}
	GUILDGUID	GetGuildGuid()						{ return m_GuildGuid; }
	VOID		SetCharGuid( CHARGUID guid )		{ m_CharGuid = guid;	}
	CHARGUID	GetCharGuid()						{ return m_CharGuid; }
	VOID		SetCharName( TCHAR * tszName )		{ memcpy(m_tszCharName, tszName, MAX_CHARNAME_LENGTH*sizeof(TCHAR));	}
	TCHAR *		GetCharName()						{ return m_tszCharName; }
	DWORD		GetSessionIndex()				{ return m_dwSessionIndex; }
	VOID		SetSessionIndex( DWORD idx )	{ m_dwSessionIndex = idx; }
private:
	CHARGUID	m_CharGuid;
	GUILDGUID	m_GuildGuid;
	TCHAR		m_tszCharName[MAX_CHARNAME_LENGTH];
	DWORD		m_dwSessionIndex;
};

// 辨靛盔 呕硼
class WithdrawGuildMemberQuery: public QueryForUser
{
	_DECLARE_QUERY_POOL(WithdrawGuildMemberQuery)
public:
	enum
	{ 
		PARAM_ROW_NUM	= 1,
		PARAM_COL_NUM	= 1,
	};
	struct sPARAM
	{
		INT	m_Result;
	} pParam[PARAM_ROW_NUM];

	_BEGIN_PARAM_DATA		(sPARAM, pParam, PARAM_COL_NUM)
		_BINDING_PARAM		(0, m_Result, SQL_PARAM_OUTPUT)
	_END_PARAM_DATA			()

	_INIT_BINDING_DATA()

	inline BOOL ResultSuccess() { return (pParam[0].m_Result==0); }
public:
	VOID		SetGuildGuid( GUILDGUID GuildGuid ) { m_GuildGuid = GuildGuid;	}
	GUILDGUID	GetGuildGuid()						{ return m_GuildGuid; }
	VOID		SetCharGuid( CHARGUID guid )		{ m_CharGuid = guid;	}
	CHARGUID	GetCharGuid()						{ return m_CharGuid; }
	DWORD		GetSessionIndex()				{ return m_dwSessionIndex; }
	VOID		SetSessionIndex( DWORD idx )	{ m_dwSessionIndex = idx; }
private:
	CHARGUID	m_CharGuid;
	GUILDGUID	m_GuildGuid;
	DWORD		m_dwSessionIndex;
};



// 辨靛盔 器瘤记 函版
class ChangeGuildPositionQuery : public QueryForUser
{
	_DECLARE_QUERY_POOL(ChangeGuildPositionQuery)
public:
	enum
	{ 
		PARAM_ROW_NUM	= 1,
		PARAM_COL_NUM	= 1,
	};
	struct sPARAM
	{
		INT	m_Result;
	} pParam[PARAM_ROW_NUM];


	_BEGIN_PARAM_DATA		(sPARAM, pParam, PARAM_COL_NUM)
		_BINDING_PARAM		(0, m_Result, SQL_PARAM_OUTPUT)
	_END_PARAM_DATA			()

	_INIT_BINDING_DATA()

	inline BOOL ResultSuccess() { return (pParam[0].m_Result==0); }
public:
	VOID		SetGuildGuid( GUILDGUID GuildGuid ) { m_GuildGuid = GuildGuid;	}
	GUILDGUID	GetGuildGuid()						{ return m_GuildGuid; }
	DWORD		GetSessionIndex()				{ return m_dwSessionIndex; }
	VOID		SetSessionIndex( DWORD idx )	{ m_dwSessionIndex = idx; }
private: 
	GUILDGUID	m_GuildGuid;
	DWORD		m_dwSessionIndex;
};

#pragma pack(pop)