开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 游戏 > 模拟服务器 > 查看源码
S3DBInterface.h
资源名称：SwordOnline.rar　[点击查看]
上传用户：dzyhzl
上传日期：2019-04-29
资源大小：56270k
文件大小：16k
源码类别：

模拟服务器

开发平台：

C/C++

S3DBInterface.h：源码内容
  1. //#include "kstdafx.h"
  2. #ifndef S3DBINTERFACE_H
  3. #define S3DBINTERFACE_H
  4. //#define IN
  5. //#define OUT
  6. //#include <map>
  7. //#include <string>
  8. //#include <vector>
  9. #include "KProtocol.h"
  10. #include <time.h>
  11. //#define SAVE_ITEM_MAGICATTRIB_TO_DB
  13. class KTabFileCtrl;
  14. class KIniFile;
  16. #pragma pack( push, 1 )
  18. enum ROLE_LOG
  19. {
  20. log_create_role = 1,
  21. log_begin_game,
  22. log_save_game,
  23. };
  25. enum 
  26. {
  27. create_role,  //if already have this rolename then msg error!;
  28. save_role,   //if havent this rolename in db ,then msg error!
  29. };
  31. enum
  32. {
  33. must_norole,
  34. must_haverole,
  35. nolimited,
  36. };
  38. struct TIntDBValue
  39. {
  40. BYTE btUnitType;
  41. };
  43. struct TRoleBaseInfo
  44. {
  45. //RoleBaseInfo
  46. DWORD dwId;
  47. char szName[32];
  48. bool bSex;
  49. char szAlias[32];
  50. char caccname[32];
  51. BYTE nFirstSect;
  52. BYTE nSect;
  53. BYTE cFightMode;
  54. BYTE cUseRevive;
  55. BYTE cIsExchange;
  56. // --------------------- add by spe 2003/07/19 -----------------------
  57. BYTE cPkStatus;
  58. // -------------------------------------------------------------------
  59. int ijoincount;
  60. int isectrole;
  61. int igroupcode;
  62. int igrouprole;
  63. int irevivalid;
  64. int irevivalx;
  65. int irevivaly;
  66. int ientergameid;
  67. int ientergamex;
  68. int ientergamey;
  69. char cpartnercode[32];
  70. int isavemoney;
  71. int imoney;
  72. int ifiveprop;
  73. int iteam;
  74. int ifightlevel;
  75. int fightexp;
  76. int ileadlevel;
  77. int ileadexp;
  78. int iliveexp;
  79. int ipower;
  80. int iagility;
  81. int iouter;
  82. int iinside;
  83. int iluck;
  84. int imaxlife;
  85. int imaxstamina;
  86. int imaxinner;
  87. // --------------------- add by spe 2003/07/19 -----------------------
  88. int icurlife;
  89. int icurstamina;
  90. int icurinner;
  91. int ipkvalue;
  92. // -------------------------------------------------------------------
  93. int ileftprop;
  94. int ileftfight;
  95. int ileftlife;
  96. int ifinishgame;
  97. short iarmorres;
  98. short iweaponres;
  99. short ihelmres;
  100. };
  102. struct TRoleData
  103. {
  104. TRoleBaseInfo BaseInfo;
  105. bool bBaseNeedUpdate;//通知是否需要更新
  106. //当存取时如果Offset等于-1，表示不更新该数据
  107. //Additional Info
  108. short nFightSkillCount;
  109. short nLiveSkillCount;
  110. BYTE nTaskCount;
  111. short nItemCount;
  112. short nFriendCount;
  113. int dwTaskOffset;
  114. int dwLSkillOffset;
  115. int dwFSkillOffset;
  116. int dwItemOffset;
  117. int dwFriendOffset;
  118. int dwDataLen;
  119. BYTE pBuffer[1];
  120. };
  122. struct TDBTaskData
  123. {
  124. BYTE m_nTaskId;
  125. int m_nTaskValue;
  126. };
  128. struct TDBItemData
  129. {
  130. //BaseInfo
  131. int iid;
  132. int iequipclasscode;
  133. int ilocal;
  134. int ix;
  135. int iy;
  136. int iequipcode;
  137. int idetailtype;
  138. int iparticulartype;
  139. int ilevel;
  140. int iseries;
  141. int iequipversion;
  142. int irandseed;
  143. int iparam2;
  144. int iparam3;
  145. int iparam5;
  146. int iparam4;
  147. int iparam6;
  148. int iparam1;
  149. int ilucky;
  150. int iidentify;
  151. };
  153. struct TDBFriendsData
  154. {
  155. short FriendCount;
  156. void * pBuffer;
  157. short Offset[1];
  158. };
  160. struct TDBSkillData
  161. {
  162. short m_nSkillId;
  163. short m_nSkillLevel;
  164. };
  166. enum 
  167. {
  168. /*==============================================================*/
  169. /* Table: EquipBaseInfo                                         */
  170. /*==============================================================*/
  171.    EQUIPBASEINFO_IID                                             ,
  172.    EQUIPBASEINFO_IMAINID                                        ,
  173.    EQUIPBASEINFO_ICLASS                                      ,
  174.    EQUIPBASEINFO_IVALUE1                        ,
  175.    EQUIPBASEINFO_IVALUE2                        ,
  176.    EQUIPBASEINFO_IVALUE3                        ,
  177. /*==============================================================*/
  178. /* TABLE: EQUIPEFFICINFO_                                        */
  179. /*==============================================================*/
  180.    EQUIPEFFICINFO_IID                                             ,
  181.    EQUIPEFFICINFO_IMAINID                                        ,
  182.    EQUIPEFFICINFO_ICLASS                                      ,
  183.    EQUIPEFFICINFO_IVALUE1                        ,
  184.    EQUIPEFFICINFO_IVALUE2                        ,
  185.    EQUIPEFFICINFO_IVALUE3                        ,
  187. /*==============================================================*/
  188. /* TABLE: EQUIPREQUIREINFO_                                     */
  189. /*==============================================================*/
  190.    EQUIPREQUIREINFO_IID                                             ,
  191.    EQUIPREQUIREINFO_IMAINID                                        ,
  192.    EQUIPREQUIREINFO_ICLASS                                      ,
  193.    EQUIPREQUIREINFO_IVALUE1                        ,
  194.    EQUIPREQUIREINFO_IVALUE2                        ,
  195.    EQUIPREQUIREINFO_IVALUE3                        ,
  196. /*==============================================================*/
  197. /* TABLE: EQUIPMENTS                                            */
  198. /*==============================================================*/
  199.    EQUIPMENTS_IID                                             ,
  200.    EQUIPMENTS_CUSERCODE                                         ,
  201.    EQUIPMENTS_IEQUIPCLASSCODE                                   ,
  202.    EQUIPMENTS_ILOCAL                                      ,
  203.    EQUIPMENTS_IX                                            ,
  204.    EQUIPMENTS_IY                                            ,
  205.    EQUIPMENTS_IEQUIPCODE                                     ,
  206.    EQUIPMENTS_IDETAILTYPE                    ,
  207.    EQUIPMENTS_IPARTICULARTYPE                ,
  208.    EQUIPMENTS_ILEVEL                         ,
  209.    EQUIPMENTS_ISERIES                        ,
  210.    EQUIPMENTS_IEQUIPVERSION                  ,
  211.    EQUIPMENTS_IRANDSEED                      ,
  212.    EQUIPMENTS_IPARAM2                        ,
  213.    EQUIPMENTS_IPARAM3                        ,
  214.    EQUIPMENTS_IPARAM5                        ,
  215.    EQUIPMENTS_IPARAM4                        ,
  216.    EQUIPMENTS_IPARAM6                        ,
  217.    EQUIPMENTS_IPARAM1                        ,
  218.    EQUIPMENTS_ILUCKY                         ,
  219.  
  220. /*==============================================================*/
  221. /* TABLE: FIGHTSKILL                                            */
  222. /*==============================================================*/
  223.    FIGHTSKILL_IID                                             ,
  224.    FIGHTSKILL_CUSERCODE                                         ,
  225.    FIGHTSKILL_IFIGHTSKILL                                 ,
  226.    FIGHTSKILL_IFIGHTSKILLLEVEL                            ,
  228. /*==============================================================*/
  229. /* TABLE: FRIENDLIST_                                           */
  230. /*==============================================================*/
  231.    FRIENDLIST_IID                                             ,
  232.    FRIENDLIST_CUSERCODE                                         ,
  233.    FRIENDLIST_CFRIENDCODE                                       ,
  236. /*==============================================================*/
  237. /* TABLE: LIFESKILL                                             */
  238. /*==============================================================*/
  240.    LIFESKILL_IID                                             ,
  241.    LIFESKILL_CUSERCODE                                         ,
  242.    LIFESKILL_ILIFESKILL                                  ,
  243.    LIFESKILL_ILIFESKILLLEVEL                             ,
  244. /*==============================================================*/
  245. /* TABLE: ROLEINFO                                             */
  246. /*==============================================================*/
  247.    ROLEINFO_IID                                             ,
  248.    ROLEINFO_CUSERCODE                                         ,
  249.    ROLEINFO_BSEX                                            ,
  250.    ROLEINFO_CALIAS                         ,
  251.    ROLEINFO_IFIRSTSECT                     ,
  252.    ROLEINFO_ISECT                          ,
  253.    ROLEINFO_IJOINCOUNT                     ,
  254.    ROLEINFO_ISECTROLE                      ,
  255.    ROLEINFO_IGROUPCODE                     ,
  256.    ROLEINFO_IGROUPROLE                     ,
  257.    ROLEINFO_IREVIVALID                     ,
  258.    ROLEINFO_CPARTNERCODE                   ,
  259.    ROLEINFO_ISAVEMONEY                                     ,
  260.    ROLEINFO_IMONEY                                         ,
  261.    ROLEINFO_IFIVEPROP                      ,
  262.    ROLEINFO_ITEAM                          ,
  263.    ROLEINFO_IFIGHTLEVEL                    ,
  264.    ROLEINFO_FIGHTEXP                      ,
  265.    ROLEINFO_ILEADLEVEL                     ,
  266.    ROLEINFO_ILEADEXP                       ,
  267.    ROLEINFO_ILIVEEXP                       ,
  268.    ROLEINFO_IPOWER                         ,
  269.    ROLEINFO_IAGILITY                       ,
  270.    ROLEINFO_IOUTER                         ,
  271.    ROLEINFO_IINSIDE                        ,
  272.    ROLEINFO_ILUCK                          ,
  273.    ROLEINFO_IMAXLIFE                       ,
  274.    ROLEINFO_IMAXSTAMINA                    ,
  275.    ROLEINFO_IMAXINNER                      ,
  276.    ROLEINFO_ILEFTPROP                      ,
  277.    ROLEINFO_ILEFTFIGHT                     ,
  278.    ROLEINFO_ILEFTLIFE                      ,
  279.    ROLEINFO_CACCNAME                       ,
  280.    ROLEINFO_IFINISHGAME                    ,
  281.    ROLEINFO_DLOGINTIME                     ,
  282.    ROLEINFO_DBEGINDATE                     ,
  283.    ROLEINFO_DENDDATE                       ,
  284.    ROLEINFO_IREVIVALX                      ,
  285.    ROLEINFO_IREVIVALY                      ,
  286.    ROLEINFO_IARMORRES                      ,
  287.    ROLEINFO_IWEAPONRES                     ,
  288.    ROLEINFO_IHELMRES                       ,
  290. /*==============================================================*/
  291. /* TABLE: TASKLIST                                             */
  292. /*==============================================================*/
  293.    TASKLIST_IID                                             ,
  294.    TASKLIST_CUSERCODE                                         ,
  295.    TASKLIST_ITASKCODE                                   ,
  296.    TASKLIST_IDEGREE                                     ,
  298. };
  302. // Ini文件各字段定义---------------------------------------------------
  303. #define SECTION_ROLE "ROLE"
  305. #define SECTION_ITEMLIST "ITEMS"
  306. #define SECTION_ITEM "ITEM" // + id
  307. #define KEY_COUNT "COUNT"
  308. #define KEY_BASELIST "BLISTS"
  309. #define KEY_EFFICLIST "ELISTS"
  310. #define KEY_REQUIRELIST "RLISTS"
  312. #define SECTION_BASEINFO "IB" //IB1_2
  313. #define SECTION_EFFICEINFO "IE"
  314. #define SECTION_REQUIREINFO "IR"
  317. #define SECTION_FRIENDLIST "FRIENDS"
  318. #define KEY_FRIEND "F" // + id
  320. #define SECTION_TASKLIST "TASKS"
  321. #define KEY_TASKID "T" // + id
  322. #define KEY_TASKVALUE "V" // + id
  324. #define SECTION_FIGHTSKILLLIST "FSKILLS"
  325. #define KEY_FIGHTSKILL "S"
  326. #define KEY_FIGHTSKILLLEVEL "L"
  328. #define SECTION_LIFESKILLLIST "LSKILLS"
  329. #define KEY_LIFESKILL "S" // + id
  330. #define KEY_LIFESKILLLEVEL "L" // + id
  331. //------------------------------------------------------------------------------
  332. #pragma warning (disable: 4512)
  333. #pragma warning (disable: 4786)
  335. #ifndef __linux
  336. #ifdef S3DBINTERFACE_EXPORTS
  337. #define S3DBI_API __declspec(dllexport)
  338. #else
  339. #define S3DBI_API __declspec(dllimport)
  340. #endif
  341. #else
  342. #define S3DBI_API
  343. #endif
  344. //改回使用corekprotocol.h里的S3DBI_RoleBaseInfo
  345. /*struct S3DBI_RoleBaseInfo
  346. {
  347. char szRoleName[32];
  348. int  nSex;
  349. int  nHelmType;
  350. int  nArmorType;
  351. int  nWeaponType;
  352. int  nLevel;
  353. };*/
  356. struct S3DBI_DATAS
  357. {
  358. char * strNames;
  359. char * strValues;
  360. int    nDataNum;
  361. };
  364. enum  S3DBI_TABLENAME
  365. {
  366. TABLE_ACCOUNT,
  367. TABLE_CARD,
  368. TABLE_EQUIPBASEINFO,
  369. TABLE_EQUIPEFFICINFO,
  370. TABLE_EQUIPMENT,
  371. TABLE_EQUIPREQUIREINFO,
  372. TABLE_FIGHTSKILL,
  373. TABLE_FRIEND,
  374. TABLE_LIFESKILL,
  375. TABLE_LIST,
  376. TABLE_ROLE,
  377. TABLE_TASK,
  378. TABLE_TASK_LIST,
  379. };
  381. enum S3DBI_LISTNAME
  382. {
  383. LIST_TASK,
  384. LIST_FRIEND,
  385. LIST_FIGHT,
  386. LIST_LIFESKILL,
  387. LIST_EQUIPMENT,
  388. LIST_EQUIPMENTREQINFO,
  389. LIST_EQUIPMENTBASEINFO,
  390. LIST_EQUIPMENTEFFICINFO,
  391. };
  392. /*
  393. extern DBTableKeyMap  g_RoleTableKeyMap;
  395. typedef std::map<std::string, int> DBTableKeyMap;
  397. typedef std::map<int, std::string> DBStringMap;
  398. typedef std::map<int, int> DBIntegerMap;
  399. */
  400. /*struct TDBTaskData
  401. {
  402. int m_nTaskId;
  403. int m_nTaskValue;
  404. };
  407. struct TDBTableData
  408. {
  409. DBStringMap m_StringDatas;
  410. DBIntegerMap m_IntegerDatas;
  411. };
  412. struct TDBEquiptData;
  413. typedef std::vector<KMagicAttrib> TMagicAttribArray;
  414. typedef std::vector<TDBEquiptData> TDBEquiptArray;
  415. typedef std::vector<TDBSkillData> TDBSkillArray;
  416. typedef std::vector<std::string> TDBFriendArray;
  417. typedef std::vector<TDBTaskData> TDBTaskArray;
  419. extern DBTableKeyMap g_TableIntegerKeyMap;
  420. extern DBTableKeyMap g_TableStringKeyMap;
  421. struct TDBEquiptData : TDBTableData
  422. {
  423. TMagicAttribArray m_mapRequestInfo;
  424. TMagicAttribArray m_mapBaseInfo;
  425. TMagicAttribArray m_mapEfficInfo;
  426. };
  428. struct TDBPlayerData :TDBTableData
  429. {
  430. TDBEquiptArray m_mapEquipt;
  431. TDBSkillArray m_mapFightSkill;
  432. TDBSkillArray m_mapLiveSkill;
  433. TDBFriendArray m_mapFriend;
  434. TDBTaskArray m_mapTask;
  435. };
  437. */
  438. #define S3_DB_TABLENAME  S3DBI_TABLENAME
  439. S3DBI_API int S3DBI_InitDBInterface(); //初始化数据库引擎
  440. S3DBI_API void S3DBI_ReleaseDBInterface(); //释放数据库引擎
  442. //获得角色的信息并以Ini文件的格式放置
  443. //S3DBI_API int S3DBI_GetRoleInfo(IN char * strUser, IN OUT KIniFile * pIniFile);
  444. S3DBI_API void * S3DBI_GetRoleInfo(IN OUT BYTE * pRoleBuffer, IN char * strUser, IN OUT int &nBufLen);
  446. //保存角色的信息，如果数据库不存在该玩家，则增加该玩家
  447. //bAutoInsertWhenNoExistUser 设为TRUE时表示，如果需要保存的该玩家在数据库中并不存在则自动加入到数据库中，FALSE则不增加直接返回错误
  448. //注意INI文件只须存放将需要改动的数据，不需改动的数据将自动保存原状。
  449. S3DBI_API int S3DBI_SaveRoleInfo(IN BYTE * pRoleBuffer, IN char * strUser, BOOL bAutoInsertWhenNoExistUser);
  450. S3DBI_API void S3DBI_ShowDebugInfo(IN BYTE * pRoleBuffer, char * pShowString);
  452. S3DBI_API BOOL S3DBI_IsRoleNameExisted(char * strUser);
  453. S3DBI_API void S3DBI_SaveRoleLogData(const char * strUser, ROLE_LOG eLogType, time_t logtime = 0);
  454. S3DBI_API time_t S3DBI_GetDataBaseSysTime();
  456. //  eLogType标识日志的类型
  457. // log_create_role , 记录角色建立的时间
  458. // log_begin_game,   记录角色本次游戏登入的时间
  459. // log_save_game,   记录角色本次游戏过程中上一次存档的时间
  460. //  数据库保存存档的时间的目的是为了
  462. S3DBI_API int S3DBI_GetRoleListOfAccount(char * szAccountName, S3DBI_RoleBaseInfo * RoleBaseList, int nMaxCount);
  464. //删除角色
  465. S3DBI_API int S3DBI_DeleteRole(char * strUser);
  470. S3DBI_API void* S3DBI_GetList(S3DBI_LISTNAME listname,  char * strUser);
  471. S3DBI_API void* S3DBI_GetList(S3DBI_LISTNAME listname,  int iid);
  474. //S3DBI_API int S3DBI_GetListData(S3DBI_LISTNAME listname, void * pList, int i , ColumnAndValue &cav);
  475. S3DBI_API int S3DBI_GetCountOfList(S3DBI_LISTNAME listname, void * pList);
  476. //S3DBI_API int S3DBI_UpdateDataAtList(S3DBI_LISTNAME listname, void * pList, int i , ColumnAndValue &cav);
  477. S3DBI_API int S3DBI_DeleteDataAtList(S3DBI_LISTNAME listname, void * pList, int i );
  478. //S3DBI_API int S3DBI_InsertDataAtList(S3DBI_LISTNAME listname, void * pList, ColumnAndValue cav);
  479. S3DBI_API void S3DBI_ReleaseListBuffer(S3DBI_LISTNAME listname, void * pList);
  481. S3DBI_API int S3DBI_ClearList(S3DBI_LISTNAME listname, void * pList);
  483. //S3DBI_API int S3DBI_GetData(S3_DB_TABLENAME tablename, int nId, ColumnAndValue *pcav);
  484. //S3DBI_API int S3DBI_GetData(S3_DB_TABLENAME tablename, char * strUser , ColumnAndValue * pCav);
  485. //S3DBI_API int S3DBI_UpdateData(S3_DB_TABLENAME tablename, int nId, ColumnAndValue *pcav);
  486. //S3DBI_API int S3DBI_UpdateData(S3_DB_TABLENAME tablename, char * strUser, ColumnAndValue *pcav);
  487. S3DBI_API int S3DBI_DeleteData(S3_DB_TABLENAME tablename, int nId);
  488. S3DBI_API int S3DBI_DeleteData(S3_DB_TABLENAME tablename, char * strUser);
  489. //S3DBI_API int S3DBI_InsertData(S3_DB_TABLENAME tablename, int nId, ColumnAndValue cav);
  490. //S3DBI_API int S3DBI_InsertData(S3_DB_TABLENAME tablename, char * strUser, ColumnAndValue cav);
  493. S3DBI_API int S3DBI_GetListData(S3DBI_LISTNAME listname, void * pList, int i , KTabFileCtrl *pTabFile);
  494. S3DBI_API int S3DBI_DeleteDataAtList(S3DBI_LISTNAME listname, void * pList, int i );
  495. S3DBI_API int S3DBI_InsertDataAtList(S3DBI_LISTNAME listname, void * pList, KTabFileCtrl *pTabFile);
  496. S3DBI_API int S3DBI_GetData(S3_DB_TABLENAME tablename, int nId, KTabFileCtrl *pTabFile);
  497. S3DBI_API int S3DBI_GetData(S3_DB_TABLENAME tablename, char * strUser, KTabFileCtrl * pTabFile);
  498. S3DBI_API int S3DBI_UpdateData(S3_DB_TABLENAME tablename, int nId, KTabFileCtrl *pTabFile);
  499. S3DBI_API int S3DBI_UpdateData(S3_DB_TABLENAME tablename, char * strUser, KTabFileCtrl *pTabFile);
  500. S3DBI_API int S3DBI_InsertData(S3_DB_TABLENAME tablename,  KTabFileCtrl *pTabFile);
  502. #pragma pack( pop )
  504. #endif