network4.h

国内著名网络游戏dragon的服务端完整源码 内附完整数据库结构

#ifndef NW_PACKET_DEFINE_
#define NW_PACKET_DEFINE_

// Packet Define _________________________________________

#define		CMD_REQUEST_CHECK_VOTE					26001
#define		CMD_ANSWER_CHECK_VOTE					26002
#define		CMD_WARFIELD_STATUS						26003
#define		CMD_WAR_BBS								26004
#define		CMD_REQUEST_WARFIELD_STATUS				26005
#define		CMD_ANSWER_WARFIELD_STATUS				26006
#define		CMD_REQUEST_VOTE_DATA					26007
#define		CMD_ANSWER_VOTE_DATA					26008
#define		CMD_VOTING_DATA							26009 
#define		CMD_REQUEST_VOTE_RESULT					26010
#define		CMD_ANSWER_VOTE_RESULT					26011
#define		CMD_REQUEST_SQUAD_INFO					26012
#define		CMD_ANSWER_SQUAD_INFO					26013
#define		CMD_REQUEST_COMMANDER_VOTE_DATA			26014
#define		CMD_ANSWER_COMMANDER_VOTE_DATA			26015
#define		CMD_REQUEST_COMMANDER_VOTING_RESULT		26016
#define		CMD_ANSWER_COMMANDER_VOTING_RESULT		26017
#define		CMD_COMMANDER_VOTING_DATA				26018
#define		CMD_COMMANDER_DATA						26019
#define		CMD_CHANGE_SQUAD						26020
#define		CMD_FAME_DATA							26021
//#define		CMD_WARFIELD_STATUS_CHANGE_RESULT		26022
#define     CMD_CHECK_WARFIELD_STATUS				26023
#define		CMD_CHECK_WARFIELD_STATUS_RESULT		26024
#define		CMD_REQUEST_DELIVERY					26029
#define		CMD_ANSWER_DELIVERY						26030
#define		CMD_REQUEST_COMMANDER_REG_DATA			26031
#define		CMD_JOIN_SQUAD							26032
#define		CMD_SET_SQUAD_LOADING_POINT				26033
#define		CMD_ANSWER_COMMANDER_REG_DATA			26034
#define		CMD_YOU_ARE_SQUAD_COMMANDER				26035
#define		CMD_YOU_ARE_SQUAD_LEADER				26036
#define		CMD_CHANGE_LOADING_POINT				26037
#define     CMD_REQUEST_NATION_WAR_COUNT			26038			// Compare Nation War Count For Dirty Player
#define     CMD_ANSWER_NATION_WAR_COUNT				26039
#define		CMD_NW_MAP_MOVE							26040
#define		CMD_CHANGED_WARFIELD_STATUS				26041			// ManageServer to Other MapServer 
#define		CMD_NW_MAP_MOVE_FAIL					26042
#define		CMD_MAP_NATION_CODE_CHANGED				26043
#define		CMD_REQUEST_TILE_DONT					26044
#define		CMD_ANSWER_TILE_DONT					26045
#define		CMD_TILE_DONT_CHANGED					26046
#define		CMD_SQUAD_CHAT							26047
#define		CMD_CLEAR_SQUAD_DATA					26048			// 何措加己 努府绢 
#define		CMD_REQUEST_WARFIELD_INFO				26049			// 傍拜磊客 规绢磊狼 犬牢 
#define		CMD_ANSWER_WARFIELD_INFO				26050
#define		CMD_WAR_BEGIN							26051			// 傈里甘俊 乐绰 荤恩狼 傈里矫累 皋技瘤..
#define		CMD_WAR_END								26052			// 规价档 乐瘤父.. 救等促.
#define		CMD_REG_SQUAD_LEADER					26053			// 辑滚埃 
#define		CMD_REQUEST_CHECK_WARFIELD_POSSESSION	26054
#define		CMD_ANSWER_CHECK_WARFIELD_POSSESSION	26055
#define		CMD_FREELANCER_SQUAD_JOIN				26056
#define		CMD_REQUEST_WARFIELD_POSSESSION			26057
#define		CMD_ANSWER_WARFIELD_POSSESSION			26058
#define		CMD_REQUEST_WARFIELD_WAR_DATA			26059
#define		CMD_WARFIELD_WAR_DATA1					26060			// 己巩 荐龋籍 单捞鸥
#define		CMD_WARFIELD_WAR_DATA2					26061			// 巢篮矫埃, 糕滚墨款飘 
#define		CMD_WARFIELD_WAR_DATA3					26062			// 规绢何措 沥焊
#define		CMD_WARFIELD_WAR_DATA4					26063			// 傍拜何措 沥焊
#define		CMD_WARFIELD_WAR_DATA5					26064			// 瘤盔焙 何措 沥焊
#define		CMD_REQUEST_CHECK_WARNO					26065			// 傈里锅龋甫 魄窜茄促.
#define		CMD_ANSWER_CHECK_WARNO					26066
#define		CMD_CLEAR_WAR_CHARACTER_DATA			26067			// 努扼捞攫飘
#define		CMD_SET_COMMANDER						26068			// DB单阁 
#define		CMD_STARTUP_NATION_CODE_CHANGE			26069			// 傈里辑滚->包府辑滚->甘辑滚
#define		CMD_ANSWER_SQUAD_INFO2					26070			// 何措沥焊 颇飘2
#define		CMD_ANSWER_COMMANDER_VOTE_DATA2			26071
#define		CMD_SET_WARFIELD_POSSESSION				26072			// 020115 LTS
#define		CMD_REQUEST_SUBSTRACT_MONEY				26073			// 傈里 辆丰矫.. 捣 冻扁.
#define		CMD_ANSWER_SUBSTRACT_MONEY				26074			// 傈里 辆丰矫 捣冻扁 菩哦
#define		CMD_SQUAD_JOIN_RESULT					26075			// 何措 钦幅角菩 

#define		CMD_REQUEST_WAR_GIVE_LIFE				26076			// 蜡飞 混府扁 夸没	// 011015 LTS
#define		CMD_ANSWER_WAR_GIVE_LIFE				26077			// 蜡飞 混府扁 览翠 
#define		CMD_CHECK_AM_I_DEFEAT					26078			// 傈里捞 场捞 车阑锭 屁扁扁	
#define		CMD_SQUAD_LOADING_POINT					26079			// 包府辑滚 -> 傈里辑滚 肺爹器牢飘 沥焊 
#define		CMD_SQUAD_RARE							26080
#define		CMD_REQUEST_NOTICE						26081
#define		CMD_ANSWER_NOTICE						26082
#define		CMD_REQUEST_DELIVERY_NOTICE				26083
#define		CMD_SET_REMAIN_TIME						26084
#define		CMD_WAR_CONTROL							26085			
#define		CMD_WAR_LOOP_TIME						26086			// 011025 LTS
#define		CMD_SECRET_OPEN							26087			// 011025 LTS

#define		CMD_CHECK_ABILITY_CHANGE_MONEY			26200			// LTSSupport.cpp

#define		CMD_LOCALWAR_STATUS						26300			// LTS LOCALWAR
#define		CMD_REQUEST_LOCALWAR_INFO				26301
#define		CMD_ANSWER_LOCALWAR_INFO				26302
#define		CMD_REQUEST_LOCAL_DELIVERY				26303
#define		CMD_ANSWER_LOCAL_DELIVERY				26304
#define		CMD_LOCALWAR_JOIN						26305
#define		CMD_LOCALWAR_JOIN_RESULT				26306
#define		CMD_REQUEST_COMPARE_PHASE				26307
#define		CMD_INC_USER_LOCALWARFIELD				26308
#define		CMD_DEC_USER_LOCALWARFIELD				26309
#define		CMD_USER_JOIN_LOCALWAR					26310
#define		CMD_LOCALWAR_BEGIN						26311
#define		CMD_LOCALWAR_END						26312
#define		CMD_SEALSTONE_BROKED					26313
#define		CMD_SEALSTONE_ATTACKED					26314
#define		CMD_LOCALWAR_POINT_CHANGED				26315
//#define		CMD_LOCALWAR_RESULT						26316
#define		CMD_LOCALWAR_NATION_POINT_CHANGED		26317
#define		CMD_LOCALWAR_POINT_BBS					26318

#define		CMD_ACTION_STATUS						26319
#define		CMD_SITDOWN_DIRECTION_CHANGED			26320
#define		CMD_LOCALWAR_STARTUP_STATUS				26321
#define		CMD_WAR_GIVE_LIFE2						26322
#define		CMD_HERO_ACTION_CHANGED					26323
#define		CMD_CHECK_WARFIELD_NATION_MEMBERCOUNT	26324
#define		CMD_EVENT_LOCALWAR_CONTROL				26325
#define		CMD_EVENT_LOCALWAR_CONTROL_D			26326
#define		CMD_EVENT_LOCALWAR_STATUS_CHANGE		26327
#define		CMD_EVENT_LOCALWAR_JOIN					26328
//#define		CMD_EVENT_LOCALWAR_REMAIN_TIME			26329
#define		CMD_FAME_EXP_CHANGE						26330
#define		CMD_EVENT_LOCALWAR_MESSAGE				26331
#define		CMD_EVENT_LOCALWAR_MOVE					26332
#define		CMD_EVENT_LOCALWAR_JOIN_RESULT			26333
#define		CMD_EVENT_LOCALWAR_MOVE_RESULT			26334
#define		CMD_DELETE_EVENT_JOIN					26335
#define		CMD_EVENT_POINT_CHANGE					26336
#define		CMD_EVENT_REMAIN_TIME					26337		// LTS BUG
#define		CMD_AI_STATUS							26338		// LTS AI2
#define		CMD_AI_DATA_RELOAD						26339		// LTS AI2 TEMP
#define		CMD_EVENT_MONSTER						26340		// LTS AI2 TEMP
#define		CMD_EVENT_MONSTER_CREATED				26341		// LTS AI2
#define		CMD_COMMUNITY_ACTION					26342		// LTS ACTION
#define		CMD_LOCALWAR_NATION_RESULT				26343		// LTS NEW LOCALWAR
#define		CMD_LOCALWAR_MAPMOVE					26344		// LTS NEW LOCALWAR
#define		CMD_LOCALWAR_MAPMOVE_RESULT				26345		// LTS NEW LOCALWAR
#define		CMD_LOCALWAR_CHAT						26346		// LTS NEW LOCALWAR
#define		CMD_LOCALWAR_CHAT_B						26347		// LTS NEW LOCALWAR
#define		CMD_LOCALWAR_FAME_EXP					26348		// LTS NEW LOCALWAR
#define		CMD_LOCALWAR_DEFENCE_POINT				26349		// LTS NEW LOCALWAR

#define		CMD_GOTO_GUILD_HOUSE_RESULT				26350			// 辫康林
#define		CMD_CHECK_GUILD_HOUSE_RESULT			26351			// 辫康林

#define		CMD_AI_FOG								26352		// LTS NEW AI
#define		CMD_AI_SOUND							26353		// LTS NEW AI
#define		CMD_AI_ACTION_TEST						26354		// LTS NEW AI TEST
#define		CMD_AI_MOVE								26355		// LTS NEW AI
#define		CMD_AI_NPC_ACTION						26356		// LTS DRAGON MODIFY
#define		CMD_AI_EARTHQUAKE						26357		// LTS DRAGON MODIFY

#define		CMD_SET_QUESTMODE						26358		// LTS DRAGON MODIFY
#define		CMD_ACTIVE_DRAGONLORD_WAR				26359		// LTS DRAGONLORD	
#define		CMD_DRAGONLORDWAR_TEAM_CHANGE			26360		// LTS DRAGONLORD	


#define		CMD_REQUEST_CHECK_DUAL_FAME				26361   // LTS DUAL FAME
#define		CMD_ANSWER_CHECK_DUAL_FAME				26362

#define		CMD_START_WAR_LOOP						26363	// LTS NEW_NATION_WAR
#define		CMD_SAVE_WARNO							26364	// LTS NEW_NATION_WAR	// DBDEMON
#define		CMD_NWARFIELD_START_WAR					26365
#define		CMD_REQUEST_NEW_WARFIELD_TILE_DONT		26366
#define		CMD_NWARFIELD_END_WAR					26367
#define		CMD_FAME_CHANGE							26368
#define		CMD_WAR_RESULT							26369
#define		CMD_CHECK_DEFEAT						26370
#define		CMD_ANSWER_NEW_WARFIELD_TILE_DONT		26371
#define		CMD_DONT_CHANGE							26372
#define		CMD_GUARD_KILLER						26373
#define		CMD_LOOPTIME_CHANGE						26374	
#define		CMD_NWARFIELD_STATUS_CHANGE				26375		
#define		CMD_REQUEST_NEW_WARFIELD_STATUS			26376
#define		CMD_ANSWER_NEW_WARFIELD_STATUS			26377
#define		CMD_REQUEST_NEW_WARFIELD_DATA			26378
#define		CMD_ANSWER_NEW_WARFIELD_DATA			26379
#define		CMD_WAR_YL_JOIN							26380
#define		CMD_GUARD_BROKE							26381


//<soto-030417
#define		CMD_SYMBOL_MAKE							26400
#define		CMD_SYMBOL_UPGRADE						26401
//>soto-030417

#define		CMD_OPEN_LUCKY_MENU						26402 //soto-030429
#define		CMD_OPEN_WINNER_MENU					26403 //soto-030502


#define		CMD_INSERT_LOTTO_INFO					26404 //soto-030503 //DB单阁
#define		CMD_DELETE_LOTTO_ALL_USER				26405 //soto-030503 //DB单阁
#define		CMD_CUR_LOTTO_INFO						26406 //soto-030503 //DB单阁
#define		CMD_LOTTERY_INFO						26407 //soto-030503 //DB单阁
#define		CMD_NEW_EVENT							20408 //soto-030504 //DB单阁
#define		CMD_LOTTO_BUY							20409 //soto-030504
#define		CMD_CAN_BUY								20410 //soto-030504
#define		CMD_WINNER_CHECK						20411 //soto-030505
#define		CMD_CHECK_OK							20412 //soto-030505
#define		CMD_DEL_LOTTO_USER						20413 //soto-030505

#define		CMD_CHECK_WINNER_MENU					20414 //soto-030505

#define		CMD_OPEN_LOTTOMENU						20415 //soto-030520
#define		CMD_LOTTERY_BROADCAST					20416 //soto-HK030924
#define		CMD_LOTTO_SEEK							20417 //soto-Lotto眠啊

#define		CMD_DEL_LOTTO_USER_OK					20418	// BBD 040127	肺肚橇肺技胶 函版

//<soto-HK030924
typedef struct	tag_LOTTERY_INFO
{
	int	nLottoID;
	int nWinNumCount;
	int	anWinNumbers[10]; // 寸梅 锅龋.
}t_LOTTERY_INFO;
//>soto-HK030924


typedef	struct tag_OPEN_LOTTO_MENU
{
	int	nMaxNumberCount; //割磊府狼 荐肺 肺肚甫  父靛蠢衬.
}t_OPEN_LOTTO_MENU;

typedef struct tag_CHECK_WINNER
{
	int		nLottoID;//soto-LottoADD
	char	strCharName[21];
	int		nWinItemCount;// 0捞搁 寸梅 登瘤 臼疽娇. -1捞搁 后镑捞 面盒摹 臼澜.
	int		anWinNumbers[10];
	int		anWinItemsCount[5];//咯扁俊 殿荐喊 瘤鞭 登绰 酒捞袍 肮荐啊 甸绢埃促.//soto-Lotto眠啊.
}t_CHECK_WINNER;
//<! BBD 040127	肺肚 橇肺技胶 函版
typedef struct tag_DEL_LOTTO_USER_OK
{
	bool	bIsDelOK;

}t_DEL_LOTTO_USER_OK;
//> BBD 040127	肺肚 橇肺技胶 函版

//<! BBD 040308		捞亥飘 饭绢 酒捞袍 瘤鞭侩 备炼眉
typedef struct tag_EVENT_RARE_ITEM_LIST
{
	int			nCn;
	char		szChrName[21];
	char		szLoginID[21];
	int			nIndex[10];
	ITEMATTR	item[10];

}t_EVENT_RARE_ITEM_LIST;
//> BBD 040308		捞亥飘 饭绢 酒捞袍 瘤鞭侩 备炼眉

typedef	struct tag_BUY_LOTTO
{
	int	nLottoID;//soto-LottoADD
	char strCharName[21];
	int	anLottoNumber[10];
	int	m_nLottoPay;//肺肚俊 瘤阂登绰 捣.
}t_BUY_LOTTO;


//<soto-Lotto眠啊.
typedef struct tag_WINNER_MENU
{
	int	nLottoID;//soto-LottoADD
	int	 nMaxLottoCount;//割磊府 鳖瘤 肺肚 锅龋甫 镜巴捞衬?	
	char strCharName[21];
	int	anWinNumbers[10];
	int	nViewCount;//泅犁 拳搁俊 唱坷绰 肺肚狼 墨款飘. 0檬苞.
	int	anLottoNumber[5][10];
	int	nTotalLottoCount;
}t_WINNER_MENU;
//>soto-Lotto眠啊.

//< soto-030418 // 缴杭 酒捞袍包访 菩哦. 父甸扁客 诀弊贰捞靛俊 静牢促.
typedef struct tag_SYMBOL_ITEM_MSG
{
	int m_nItemNumber;
	int	m_nGrade; // 1捞 绊沥.
} t_SYMBOL_ITEM_MSG;
//> soto-030418

//<soto-Lotto眠啊.
typedef struct tag_LOTTOPAPER_SEEK
{
	char	strChrName[20];
	int		nPage;//盔窍绰 其捞瘤啊 甸绢埃促.
	int		nViewCount;//泅犁 免仿登绰 汗鼻狼 肮荐.
	int		anLottoNumber[5][10];//府胶飘俊 乐绰 肺肚 锅龋甸捞 甸绢埃促.
	int		nLottoID;//肺肚狼 雀瞒啊 甸绢埃促.
}t_LOTTOPAPER_SEEK;
//>soto-Lotto眠啊.



// Packet Define End ____________________________________
 
const int 	NW_NATION_COUNT					=3;
const int 	NW_WARFIELD_COUNT				=3;
const int 	MAX_NEW_WARFIELD				=1;

const int 	NW_NAME_MAX						=31;
const int 	NW_SQUAD_MAX					=5;		// 0何措 : 何措 祈己捞 登瘤 臼篮 牢盔狼 葛烙.
const int 	NW_CANDIDATE_MAX				=6;
const int 	NW_SQUAD_KIND					=3;
const int 	MAX_STRING_PK					=600;
const int 	NW_SQUAD_RARE_MAX				=3;
const int 	FOG_MAX							=30;	// LTS DRAGON MODIFY
const int 	MAX_DONT_DATA					=10;

typedef struct CommonDataC_P
{
	BYTE	Data;
}	t_CommonDataC;

typedef struct CommonDataDw_P
{
	DWORD	Data;
}	t_CommonDataDw;


typedef struct CheckVote_P
{
	char	WarfieldNo;
	char	Status;
}	t_CheckVote;

typedef struct WarfieldStatusChange_P
{
	WORD	WarfieldNo;
	char	Status;
}	t_WarfieldStatusChange;

typedef struct WarBBS_P
{
	char	WarfieldNo;
	char	BBSType;
	char	LanNo;				//珐蓖瘤蒲 锅龋
	char	ArgType;			// 0 :巩磊凯 1: 箭磊 
	char	Size;				// ArgType捞 巩磊凯捞搁 巩磊凯狼 农扁 1:荐磊捞搁 牢磊狼 肮荐 
	char	Arg[MAX_STRING_PK];
}	t_WarBBS;

typedef struct WarfieldStatus_P
{
	BYTE	PacketStatus;
	char	Status[NW_WARFIELD_COUNT];
}	t_WarfieldStatus;

typedef struct WarfieldStatusM_P
{
	char	WarNo;
	char	Status[NW_WARFIELD_COUNT];
	char	Possession[NW_WARFIELD_COUNT];
}	t_WarfieldStatusM;

typedef struct VoteData_P
{
	char	WarfieldNo;
	short	VoteCount;				//况靛唱 沥荐屈栏肺 函券 鞘夸 // 011028 LTS
}	t_VoteData;

typedef struct RequestSquadInfo_P
{
	char	Nation;
	char	WarfieldNo;
	char	SquadNo;
}	t_RequestSquadInfo;

typedef struct SquadInfo_P
{
	char	SquadNo;
	int		ChipID;
	char	ChipName[NW_NAME_MAX];
	int		SoldierCount;
	char	Sok[NW_SQUAD_RARE_MAX];					//饭绢加己 //厚飘楷魂	
	char	LoadingPoint;
}	t_SquadInfo;

typedef struct SquadInfo2_P
{
	char	CommanderName[NW_NAME_MAX];
	short	SquadCount[NW_SQUAD_MAX];				// 011028 LTS
}	t_SquadInfo2;

typedef struct RegSquadLeader_P			// 辑滚埃 菩哦 
{
	char		Nation;
	char		WarfieldNo;
	char		SquadNo;
	int			ChipID;
	char		ChipName[NW_NAME_MAX];
	short		Level;					// 011028 LTS
	short		Fame;
	short int	Face;
	short int	Gender;
	short int	Class;					// 011016 LTS
	__int8		nDual;					// 011020 LTS
	__int8		nStep;					// 011020 LTS
	DWORD		LadderScore;
	
}	t_RegSquadLeader;

typedef struct RequestCommanderVoteData_P
{
	char	Nation;