rpgdatabasetableschar.cc

五行MMORPG引擎系统V1.0

//RPGDatabaseTables.cc
/*/////////////////////////////////////////////////////////////////
	数据库模拟管理
	故所有数据关系皆为关系型结构

   李亦
	[e-mail] 4040719
	2006-7-20
/*/////////////////////////////////////////////////////////////////
#include "rpg/cmd/RPGDatabase.h"
//#include "rpg/cmd/RPGDatabaseDefine.h"
#include "rpg/RPGDataMan.h"
#include "rpg/cmd/DBProxy.h"
#include "rpg/cmd/RPGDatabaseTables.h"
#include "rpg/ui/gameIconDefine.h"

namespace RPG
{

namespace DB
{





//////////////////////////////////////////////////////////////
BEGIN_DBTABLE(GPLAYER,Player)
//{
	//	ID  Name			Level		exp			gender		career		clan			zone		bodyType		HP	 MP	  HPMax	MPMax Attack Defence aSTR aINT aCON aDEX aWIT		eMagic eStamina eLuck eMoveSpeed eMoveRate  nMoney		x		y			z   rot			MapIDName	LetSP Weight WeightMax	 EquipmentsID BagGoodsID SkillsID ActionsID KeyCellsID
	{0,	{"展昭",		5,			6000,		GG_MALE,		GCR_FIGHTER,	GC_HUMAN,	GC_ASIA,	GBT_NORMAL,	{500,	400,	500,	400,	100,	 80,		{65,  20,	 34,  20,  20},	  200,	100,		50,	1.2f,		0.f},		100,	  182.0f,	68.0f, 0.f, 30.f},		{"lakecity",		5,		100,		100},			0,				0,				0,				0,				0},
	{1,	{"怪坦",		5,			6000,		GG_MALE,		GCR_FIGHTER,	GC_TITAN,	GC_ASIA,	GBT_NORMAL,	{500,	400,	500,	400,	100,	 80,		{65,  20,	 34,  20,  20},	  200,	100,		50,	0.5f,		0.f},		1000,	  165.0f,	60.0f, 0.f, 0.f}	,		{"lakecity",		5,		100,		100},			DBNUL,		DBNUL,		DBNUL,		DBNUL,		DBNUL},
	{2,	{"怪怪",		5,			6000,		GG_MALE,		GCR_FIGHTER,	GC_HUMAN,	GC_ASIA,	GBT_NORMAL,	{500,	400,	500,	400,	100,	 80,		{65,  20,	 34,  20,  20},	  200,	100,		50,	0.8f,		0.f},		1000,	  182.0f,	70.0f, 0.f, 0.f}	,		{"lakecity",		5,		100,		100},			DBNUL,		DBNUL,		DBNUL,		DBNUL,		DBNUL}
//};
END_DBTABLE(GPLAYER,Player)



//////////////////////////////////////////////////////////////
//NPC数据
BEGIN_DBTABLE(GNPC,Npc)
//{
	//ID  Name				Level		exp			gender			career		clan			zone		bodyType		HP	 MP	HPMax	MPMax Attack Defence aSTR aINT aCON aDEX aWIT		eMagic eStamina eLuck eMoveSpeed eMoveRate nMoney		x			y			z	rot		ai		kind	 EquipmentsID BagGoodsID
	{0,	{"启蒙先生",		5,			6000,		GG_MALE,		GCR_FIGHTER,	GC_HUMAN,	GC_ASIA,	GBT_NORMAL,	{500,	400,	500,	400,	100,	 80,		{65,  20,	 34,  20,  20},	  200,	100,		50,	1.f,		0.f},		1000,	  185.0f,	65.0f, 0.f, 180.f},	{GAI_TALK,	0},		1,		DBNUL},
	{1,	{"美芝",				5,			6000,		GG_FEMALE,	GCR_FIGHTER,	GC_HUMAN,	GC_ASIA,	GBT_NORMAL,	{500,	400,	500,	400,	100,	 80,		{65,  20,	 34,  20,  20},	  200,	100,		50,	1.f,		0.f},		1000,	  180.0f,	72.0f, 0.f, 120.f},	{GAI_TALK,	0},		1,		DBNUL},
	{2,	{"保安阿刚",		5,			6000,		GG_MALE,		GCR_FIGHTER,	GC_HUMAN,	GC_ASIA,	GBT_NORMAL,	{500,	400,	500,	400,	100,	 80,		{65,  20,	 34,  20,  20},	  200,	100,		50,	1.f,		0.f},		1000,	  190.0f,	50.0f, 0.f, 0.f},		{GAI_TALK,	0},		1,		DBNUL},
	{3,	{"门卫阿强",		5,			6000,		GG_MALE,		GCR_FIGHTER,	GC_HUMAN,	GC_ASIA,	GBT_NORMAL,	{500,	400,	500,	400,	100,	 80,		{65,  20,	 34,  20,  20},	  200,	100,		50,	1.f,		0.f},		1000,	  190.0f,	90.0f, 0.f, 0.f},	{GAI_TALK,	0},			1,		DBNUL},
	{4,	{"工匠钳",			5,			6000,		GG_MALE,		GCR_FIGHTER,	GC_DRAKKEN,	GC_ASIA,	GBT_NORMAL,	{500,	400,	500,	400,	100,	 80,		{65,  20,	 34,  20,  20},	  200,	100,		50,	1.f,		0.f},		1000,	  215.0f,	90.0f, 0.f, 50.f},	{GAI_TALK,	0},		1,		DBNUL},
	{5,	{"巨坦",				5,			6000,		GG_MALE,		GCR_FIGHTER,	GC_TITAN,	GC_ASIA,	GBT_NORMAL,	{500,	400,	500,	400,	100,	 80,		{65,  20,	 34,  20,  20},	  200,	100,		50,	1.f,		0.f},		1000,	  200.0f,	80.0f, 0.f, 80.f},	{GAI_TALK,	0},	DBNUL,	DBNUL},
//};
END_DBTABLE(GNPC,Npc)

	///////////////////////////////////
	//NPC对话
	BEGIN_DBTABLE(GNPCDIALOG,NpcDialog)
	//{
		//id	npc				dialog
		{0,	"启蒙先生",		0},
		//{1,	"启蒙先生",		1},
		{2,	"门卫阿强",		0},
		{3,	"保安阿刚",		0},
		{4,	"工匠钳",		0},
		{5,	"巨坦",			0},

		{6,	"美芝",			0},
		{7,	"美芝",			140},
	//};
	END_DBTABLE(GNPCDIALOG,NpcDialog)

	///////////////////////////////////
	//NPC任务
	BEGIN_DBTABLE(GNPCTASK,NpcTask)
	//{
		//id		npc			task
		{0,	"启蒙先生",		1},
		{1,	"门卫阿强",		2},
		//{2,	"门卫阿强",		3},
	//};
	END_DBTABLE(GNPCTASK,NpcTask)





//////////////////////////////////////////////////////////////
BEGIN_DBTABLE(GPLAYERTASKSTATE,	PlayerTaskState)
//{
	//ID	player	taskState
	{0,	"展昭",	0},	//拜见启蒙
	{1,	"怪怪",	1},	//拜见启蒙
//};
END_DBTABLE(GPLAYERTASKSTATE,	PlayerTaskState)


//////////////////////////////////////////////////////////////
BEGIN_DBTABLE(GTASKSTATE, TaskState)
//{
	//ID	NpcName			TaskID	nState			pieceStates
	{0,	"启蒙先生",		0,			GTS_RUNNING,	GTS_FREE},	//拜见启蒙
	{1,	"启蒙先生",		0,			GTS_RUNNING,	GTS_FREE},	//拜见启蒙
	//{1,	"启蒙先生",		1,			GTS_FREE,		GTS_FREE,	GTS_FREE},	//帮启蒙送信
//};
END_DBTABLE(GTASKSTATE, TaskState)



//////////////////////////////////////////////////////////////
BEGIN_DBTABLE(GEQUIPMENTS,Equipments)
//{
	//ID	arEquipments[EQUIP_SLOTNUM]
	//		shoulder	helmet	mantle		arms		armor		shield	glove		pants		boot		headgear	necklace	lace		lace2		ring		ring2
	{0,	DBNUL,	DBNUL,	DBNUL,		DBNUL,		0,		DBNUL,	DBNUL,	DBNUL,DBNUL,		DBNUL,	DBNUL,	DBNUL,	DBNUL,	DBNUL,	DBNUL	},
	//{0,	DBNUL,	DBNUL,	DBNUL,		50,			0,			DBNUL,	30,		20,	10,		DBNUL,	DBNUL,	DBNUL,	DBNUL,	DBNUL,	DBNUL	},
	{1,	DBNUL,	DBNUL,	DBNUL,		81,			1,			DBNUL,	DBNUL,	DBNUL,DBNUL,	DBNUL,	DBNUL,	DBNUL,	DBNUL,	DBNUL,	DBNUL	}
//};
END_DBTABLE(GEQUIPMENTS,Equipments)



//////////////////////////////////////////////////////////////
BEGIN_DBTABLE(GBAGGOODS,BagGoods)
//{
	//ID	arUnits[BAG_SLOTNUM]
	{0,	DBNUL,DBNUL,DBNUL,DBNUL,DBNUL,		DBNUL,DBNUL,DBNUL,DBNUL,DBNUL,		DBNUL,DBNUL,DBNUL,DBNUL,DBNUL,	DBNUL,DBNUL,DBNUL,DBNUL,DBNUL,		DBNUL,DBNUL,DBNUL,DBNUL	}
	//{0,	101,100,	DBNUL,500,501,		DBNUL,11,21,31,51,		60,61,70,71,80,	DBNUL,DBNUL,DBNUL,DBNUL,DBNUL,		DBNUL,DBNUL,DBNUL,DBNUL	}
//};
END_DBTABLE(GBAGGOODS,BagGoods)



//////////////////////////////////////////////////////////////
BEGIN_DBTABLE(GSKILLS,Skills)
//{
	//ID	arUnits[SKILL_SLOTNUM]
	{0,	DBNUL,DBNUL,DBNUL,DBNUL,DBNUL,	DBNUL,DBNUL,DBNUL,DBNUL,DBNUL,	DBNUL,DBNUL,DBNUL,DBNUL,DBNUL,	DBNUL,DBNUL,DBNUL,DBNUL,DBNUL,	DBNUL,DBNUL,DBNUL,DBNUL	}
//};
END_DBTABLE(GSKILLS,Skills)



//////////////////////////////////////////////////////////////
BEGIN_DBTABLE(GACTIONS,Actions)
//{
	//ID	[ACTION_BASE_AMOUNT	= 12]	[ACTION_TEAM_AMOUNT	= 6]	[ACTION_MOTION_AMOUNT	= 18]
	{0,	
			200,201,DBNUL,202,DBNUL,DBNUL,	DBNUL,DBNUL,DBNUL,DBNUL,DBNUL,DBNUL,
			220,221,222,223,224,225,
			230,231,232,233,DBNUL,DBNUL,			234,235,DBNUL,DBNUL,DBNUL,DBNUL,	DBNUL,DBNUL,DBNUL,	DBNUL,DBNUL,DBNUL
	}
//};
END_DBTABLE(GACTIONS,Actions)



//////////////////////////////////////////////////////////////
BEGIN_DBTABLE(GKEYCELLS,KeyCells)
///*static*/ GKEYCELLS Tables::ms_arKeyCells[]=
//{
	//ID	[FUNC_CELL_AMOUNT	= 8]	[NUMBER_CELL_AMOUNT	= 6]
	{0,	
			230,231,DBNUL,DBNUL,DBNUL,DBNUL,DBNUL,DBNUL,
			234,235,230,231,DBNUL,DBNUL
	}
//};
END_DBTABLE(GKEYCELLS,KeyCells)



};//namespace DB




};//namespace RPG