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

源码开发语言/平台
当前位置：首页 > 源码/资料 > 游戏 > 模拟服务器 > 查看源码
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. #define SAVE_ITEM_MAGICATTRIB_TO_DB
  11. #ifndef MAGICATTRIB
  12. #define MAGICATTRIB
  13. struct KMagicAttrib
  14. {
  15. int nAttribType; //属性类型
  16. int nValue[3]; //属性参数
  17. KMagicAttrib(){nValue[0] = nValue[1] = nValue[2] = nAttribType = 0;};
  18. };
  19. #else
  20. struct KMagicAttrib;
  21. #endif
  23. class KTabFileCtrl;
  24. class KIniFile;
  27. struct TIntDBValue
  28. {
  29. BYTE btUnitType;
  31. };
  33. struct TRoleBaseInfo
  34. {
  35. //RoleBaseInfo
  36. DWORD dwId;
  37. char szName[100];
  38. bool bSex;
  39. char szAlias[100];
  40. char caccname[100]                   ;
  41. BYTE nFirstSect;
  42. BYTE nSect;
  43. int ijoincount                     ;
  44. int isectrole                      ;
  45. int igroupcode                     ;
  46. int igrouprole                     ;
  47. int irevivalid                     ;
  48. char cpartnercode[100]                   ;
  49. int isavemoney                                     ;
  50. int imoney                                         ;
  51. int ifiveprop                      ;
  52. int iteam                          ;
  53. int ifightlevel                    ;
  54. int fightexp                      ;
  55. int ileadlevel                     ;
  56. int ileadexp                       ;
  57. int iliveexp                       ;
  58. int ipower                         ;
  59. int iagility                       ;
  60. int iouter                         ;
  61. int iinside                        ;
  62. int iluck                          ;
  63. int imaxlife                       ;
  64. int imaxstamina                    ;
  65. int imaxinner                      ;
  66. int ileftprop                      ;
  67. int ileftfight                     ;
  68. int ileftlife                      ;
  69. int ifinishgame                    ;
  70. int irevivalx                      ;
  71. int irevivaly                      ;
  72. short iarmorres                      ;
  73. short iweaponres                     ;
  74. short ihelmres                       ;
  75. };
  77. struct TRoleData
  78. {
  79. TRoleBaseInfo BaseInfo;
  80. bool bBaseNeedUpdate;//通知是否需要更新
  81. //当存取时如果Offset等于-1，表示不更新该数据
  82. //Additional Info
  83. short nFightSkillCount;
  84. short nLiveSkillCount;
  85. BYTE nTaskCount;
  86. short nItemCount;
  87. short nFriendCount;
  88. int dwTaskOffset;
  89. int dwLSkillOffset;
  90. int dwFSkillOffset;
  91. int dwItemOffset;
  92. int dwFriendOffset;
  93. int dwDataLen;
  94. BYTE pBuffer[1];
  95. };
  97. struct TDBTaskData
  98. {
  99. BYTE m_nTaskId;
  100. short m_nTaskValue;
  101. };
  103. struct TDBItemData
  104. {
  105. //BaseInfo
  106. int iid;
  107. char cusercode[100];
  108. int iequipclasscode;
  109. int ilocal                                      ;
  110. int ix                                            ;
  111. int iy                                            ;
  112. int iequipcode                                     ;
  113. int idetailtype                    ;
  114. int iparticulartype                ;
  115. int ilevel                         ;
  116. int iseries                        ;
  117. int iequipversion                  ;
  118. int irandseed                      ;
  119. int iparam2                        ;
  120. int iparam3                        ;
  121. int iparam5                        ;
  122. int iparam4                        ;
  123. int iparam6                        ;
  124. int iparam1                        ;
  125. int ilucky                         ;
  126. #ifdef SAVE_ITEM_MAGICATTRIB_TO_DB
  127. BYTE BaseInfoCount;
  128. BYTE EfficCount;
  129. BYTE RequireInfoCount;
  130. BYTE pBuffer[1];
  131. #endif
  132. };
  134. struct TDBFriendsData
  135. {
  136. short FriendCount;
  137. void * pBuffer;
  138. short Offset[1];
  139. };
  141. struct TDBSkillData
  142. {
  143. short m_nSkillId;
  144. short m_nSkillLevel;
  145. };
  147. enum 
  148. {
  149. /*==============================================================*/
  150. /* Table: EquipBaseInfo                                         */
  151. /*==============================================================*/
  152.    EQUIPBASEINFO_IID                                             ,
  153.    EQUIPBASEINFO_IMAINID                                        ,
  154.    EQUIPBASEINFO_ICLASS                                      ,
  155.    EQUIPBASEINFO_IVALUE1                        ,
  156.    EQUIPBASEINFO_IVALUE2                        ,
  157.    EQUIPBASEINFO_IVALUE3                        ,
  158. /*==============================================================*/
  159. /* TABLE: EQUIPEFFICINFO_                                        */
  160. /*==============================================================*/
  161.    EQUIPEFFICINFO_IID                                             ,
  162.    EQUIPEFFICINFO_IMAINID                                        ,
  163.    EQUIPEFFICINFO_ICLASS                                      ,
  164.    EQUIPEFFICINFO_IVALUE1                        ,
  165.    EQUIPEFFICINFO_IVALUE2                        ,
  166.    EQUIPEFFICINFO_IVALUE3                        ,
  168. /*==============================================================*/
  169. /* TABLE: EQUIPREQUIREINFO_                                     */
  170. /*==============================================================*/
  171.    EQUIPREQUIREINFO_IID                                             ,
  172.    EQUIPREQUIREINFO_IMAINID                                        ,
  173.    EQUIPREQUIREINFO_ICLASS                                      ,
  174.    EQUIPREQUIREINFO_IVALUE1                        ,
  175.    EQUIPREQUIREINFO_IVALUE2                        ,
  176.    EQUIPREQUIREINFO_IVALUE3                        ,
  177. /*==============================================================*/
  178. /* TABLE: EQUIPMENTS                                            */
  179. /*==============================================================*/
  180.    EQUIPMENTS_IID                                             ,
  181.    EQUIPMENTS_CUSERCODE                                         ,
  182.    EQUIPMENTS_IEQUIPCLASSCODE                                   ,
  183.    EQUIPMENTS_ILOCAL                                      ,
  184.    EQUIPMENTS_IX                                            ,
  185.    EQUIPMENTS_IY                                            ,
  186.    EQUIPMENTS_IEQUIPCODE                                     ,
  187.    EQUIPMENTS_IDETAILTYPE                    ,
  188.    EQUIPMENTS_IPARTICULARTYPE                ,
  189.    EQUIPMENTS_ILEVEL                         ,
  190.    EQUIPMENTS_ISERIES                        ,
  191.    EQUIPMENTS_IEQUIPVERSION                  ,
  192.    EQUIPMENTS_IRANDSEED                      ,
  193.    EQUIPMENTS_IPARAM2                        ,
  194.    EQUIPMENTS_IPARAM3                        ,
  195.    EQUIPMENTS_IPARAM5                        ,
  196.    EQUIPMENTS_IPARAM4                        ,
  197.    EQUIPMENTS_IPARAM6                        ,
  198.    EQUIPMENTS_IPARAM1                        ,
  199.    EQUIPMENTS_ILUCKY                         ,
  200.  
  201. /*==============================================================*/
  202. /* TABLE: FIGHTSKILL                                            */
  203. /*==============================================================*/
  204.    FIGHTSKILL_IID                                             ,
  205.    FIGHTSKILL_CUSERCODE                                         ,
  206.    FIGHTSKILL_IFIGHTSKILL                                 ,
  207.    FIGHTSKILL_IFIGHTSKILLLEVEL                            ,
  209. /*==============================================================*/
  210. /* TABLE: FRIENDLIST_                                           */
  211. /*==============================================================*/
  212.    FRIENDLIST_IID                                             ,
  213.    FRIENDLIST_CUSERCODE                                         ,
  214.    FRIENDLIST_CFRIENDCODE                                       ,
  217. /*==============================================================*/
  218. /* TABLE: LIFESKILL                                             */
  219. /*==============================================================*/
  221.    LIFESKILL_IID                                             ,
  222.    LIFESKILL_CUSERCODE                                         ,
  223.    LIFESKILL_ILIFESKILL                                  ,
  224.    LIFESKILL_ILIFESKILLLEVEL                             ,
  225. /*==============================================================*/
  226. /* TABLE: ROLEINFO                                             */
  227. /*==============================================================*/
  228.    ROLEINFO_IID                                             ,
  229.    ROLEINFO_CUSERCODE                                         ,
  230.    ROLEINFO_BSEX                                            ,
  231.    ROLEINFO_CALIAS                         ,
  232.    ROLEINFO_IFIRSTSECT                     ,
  233.    ROLEINFO_ISECT                          ,
  234.    ROLEINFO_IJOINCOUNT                     ,
  235.    ROLEINFO_ISECTROLE                      ,
  236.    ROLEINFO_IGROUPCODE                     ,
  237.    ROLEINFO_IGROUPROLE                     ,
  238.    ROLEINFO_IREVIVALID                     ,
  239.    ROLEINFO_CPARTNERCODE                   ,
  240.    ROLEINFO_ISAVEMONEY                                     ,
  241.    ROLEINFO_IMONEY                                         ,
  242.    ROLEINFO_IFIVEPROP                      ,
  243.    ROLEINFO_ITEAM                          ,
  244.    ROLEINFO_IFIGHTLEVEL                    ,
  245.    ROLEINFO_FIGHTEXP                      ,
  246.    ROLEINFO_ILEADLEVEL                     ,
  247.    ROLEINFO_ILEADEXP                       ,
  248.    ROLEINFO_ILIVEEXP                       ,
  249.    ROLEINFO_IPOWER                         ,
  250.    ROLEINFO_IAGILITY                       ,
  251.    ROLEINFO_IOUTER                         ,
  252.    ROLEINFO_IINSIDE                        ,
  253.    ROLEINFO_ILUCK                          ,
  254.    ROLEINFO_IMAXLIFE                       ,
  255.    ROLEINFO_IMAXSTAMINA                    ,
  256.    ROLEINFO_IMAXINNER                      ,
  257.    ROLEINFO_ILEFTPROP                      ,
  258.    ROLEINFO_ILEFTFIGHT                     ,
  259.    ROLEINFO_ILEFTLIFE                      ,
  260.    ROLEINFO_CACCNAME                       ,
  261.    ROLEINFO_IFINISHGAME                    ,
  262.    ROLEINFO_DLOGINTIME                     ,
  263.    ROLEINFO_DBEGINDATE                     ,
  264.    ROLEINFO_DENDDATE                       ,
  265.    ROLEINFO_IREVIVALX                      ,
  266.    ROLEINFO_IREVIVALY                      ,
  267.    ROLEINFO_IARMORRES                      ,
  268.    ROLEINFO_IWEAPONRES                     ,
  269.    ROLEINFO_IHELMRES                       ,
  271. /*==============================================================*/
  272. /* TABLE: TASKLIST                                             */
  273. /*==============================================================*/
  274.    TASKLIST_IID                                             ,
  275.    TASKLIST_CUSERCODE                                         ,
  276.    TASKLIST_ITASKCODE                                   ,
  277.    TASKLIST_IDEGREE                                     ,
  279. };
  283. // Ini文件各字段定义---------------------------------------------------
  284. #define SECTION_ROLE "ROLE"
  286. #define SECTION_ITEMLIST "ITEMS"
  287. #define SECTION_ITEM "ITEM" // + id
  288. #define KEY_COUNT "COUNT"
  289. #define KEY_BASELIST "BLISTS"
  290. #define KEY_EFFICLIST "ELISTS"
  291. #define KEY_REQUIRELIST "RLISTS"
  293. #define SECTION_BASEINFO "IB" //IB1_2
  294. #define SECTION_EFFICEINFO "IE"
  295. #define SECTION_REQUIREINFO "IR"
  298. #define SECTION_FRIENDLIST "FRIENDS"
  299. #define KEY_FRIEND "F" // + id
  301. #define SECTION_TASKLIST "TASKS"
  302. #define KEY_TASKID "T" // + id
  303. #define KEY_TASKVALUE "V" // + id
  305. #define SECTION_FIGHTSKILLLIST "FSKILLS"
  306. #define KEY_FIGHTSKILL "S"
  307. #define KEY_FIGHTSKILLLEVEL "L"
  309. #define SECTION_LIFESKILLLIST "LSKILLS"
  310. #define KEY_LIFESKILL "S" // + id
  311. #define KEY_LIFESKILLLEVEL "L" // + id
  312. //------------------------------------------------------------------------------
  313. #pragma warning (disable: 4512)
  314. #pragma warning (disable: 4786)
  316. #ifdef S3DBINTERFACE_EXPORTS
  317. #define S3DBI_API __declspec(dllexport)
  318. #else
  319. #define S3DBI_API __declspec(dllimport)
  320. #endif
  322. //
  323. struct S3DBI_RoleBaseInfo
  324. {
  325. char szRoleName[32];
  326. int  nSex;
  327. int  nHelmType;
  328. int  nArmorType;
  329. int  nWeaponType;
  330. int  nLevel;
  331. };
  334. struct S3DBI_DATAS
  335. {
  336. char * strNames;
  337. char * strValues;
  338. int    nDataNum;
  339. };
  342. enum  S3DBI_TABLENAME
  343. {
  344. TABLE_ACCOUNT,
  345. TABLE_CARD,
  346. TABLE_EQUIPBASEINFO,
  347. TABLE_EQUIPEFFICINFO,
  348. TABLE_EQUIPMENT,
  349. TABLE_EQUIPREQUIREINFO,
  350. TABLE_FIGHTSKILL,
  351. TABLE_FRIEND,
  352. TABLE_LIFESKILL,
  353. TABLE_LIST,
  354. TABLE_ROLE,
  355. TABLE_TASK,
  356. TABLE_TASK_LIST,
  357. };
  359. enum S3DBI_LISTNAME
  360. {
  361. LIST_TASK,
  362. LIST_FRIEND,
  363. LIST_FIGHT,
  364. LIST_LIFESKILL,
  365. LIST_EQUIPMENT,
  366. LIST_EQUIPMENTREQINFO,
  367. LIST_EQUIPMENTBASEINFO,
  368. LIST_EQUIPMENTEFFICINFO,
  369. };
  370. /*
  371. extern DBTableKeyMap  g_RoleTableKeyMap;
  373. typedef std::map<std::string, int> DBTableKeyMap;
  375. typedef std::map<int, std::string> DBStringMap;
  376. typedef std::map<int, int> DBIntegerMap;
  377. */
  378. /*struct TDBTaskData
  379. {
  380. int m_nTaskId;
  381. int m_nTaskValue;
  382. };
  385. struct TDBTableData
  386. {
  387. DBStringMap m_StringDatas;
  388. DBIntegerMap m_IntegerDatas;
  389. };
  390. struct TDBEquiptData;
  391. typedef std::vector<KMagicAttrib> TMagicAttribArray;
  392. typedef std::vector<TDBEquiptData> TDBEquiptArray;
  393. typedef std::vector<TDBSkillData> TDBSkillArray;
  394. typedef std::vector<std::string> TDBFriendArray;
  395. typedef std::vector<TDBTaskData> TDBTaskArray;
  397. extern DBTableKeyMap g_TableIntegerKeyMap;
  398. extern DBTableKeyMap g_TableStringKeyMap;
  399. struct TDBEquiptData : TDBTableData
  400. {
  401. TMagicAttribArray m_mapRequestInfo;
  402. TMagicAttribArray m_mapBaseInfo;
  403. TMagicAttribArray m_mapEfficInfo;
  404. };
  406. struct TDBPlayerData :TDBTableData
  407. {
  408. TDBEquiptArray m_mapEquipt;
  409. TDBSkillArray m_mapFightSkill;
  410. TDBSkillArray m_mapLiveSkill;
  411. TDBFriendArray m_mapFriend;
  412. TDBTaskArray m_mapTask;
  413. };
  415. */
  416. #define S3_DB_TABLENAME  S3DBI_TABLENAME
  417. S3DBI_API int S3DBI_InitDBInterface(); //初始化数据库引擎
  418. S3DBI_API void S3DBI_ReleaseDBInterface(); //释放数据库引擎
  420. //获得角色的信息并以Ini文件的格式放置
  421. //S3DBI_API int S3DBI_GetRoleInfo(IN char * strUser, IN OUT KIniFile * pIniFile);
  422. S3DBI_API void * S3DBI_GetRoleInfo(IN OUT BYTE * pRoleBuffer, IN char * strUser, IN OUT int &nBufLen);
  424. //保存角色的信息，如果数据库不存在该玩家，则增加该玩家
  425. //bAutoInsertWhenNoExistUser 设为TRUE时表示，如果需要保存的该玩家在数据库中并不存在则自动加入到数据库中，FALSE则不增加直接返回错误
  426. //注意INI文件只须存放将需要改动的数据，不需改动的数据将自动保存原状。
  427. S3DBI_API int S3DBI_SaveRoleInfo(IN BYTE * pRoleBuffer, IN char * strUser, BOOL bAutoInsertWhenNoExistUser);
  428. S3DBI_API void S3DBI_ShowDebugInfo(IN BYTE * pRoleBuffer, char * pShowString);
  430. S3DBI_API int S3DBI_GetRoleListOfAccount(char * szAccountName, S3DBI_RoleBaseInfo * RoleBaseList, int nMaxCount);
  432. //删除角色
  433. S3DBI_API int S3DBI_DeleteRole(char * strUser);
  438. S3DBI_API void* S3DBI_GetList(S3DBI_LISTNAME listname,  char * strUser);
  439. S3DBI_API void* S3DBI_GetList(S3DBI_LISTNAME listname,  int iid);
  442. //S3DBI_API int S3DBI_GetListData(S3DBI_LISTNAME listname, void * pList, int i , ColumnAndValue &cav);
  443. S3DBI_API int S3DBI_GetCountOfList(S3DBI_LISTNAME listname, void * pList);
  444. //S3DBI_API int S3DBI_UpdateDataAtList(S3DBI_LISTNAME listname, void * pList, int i , ColumnAndValue &cav);
  445. S3DBI_API int S3DBI_DeleteDataAtList(S3DBI_LISTNAME listname, void * pList, int i );
  446. //S3DBI_API int S3DBI_InsertDataAtList(S3DBI_LISTNAME listname, void * pList, ColumnAndValue cav);
  447. S3DBI_API void S3DBI_ReleaseListBuffer(S3DBI_LISTNAME listname, void * pList);
  449. S3DBI_API int S3DBI_ClearList(S3DBI_LISTNAME listname, void * pList);
  451. //S3DBI_API int S3DBI_GetData(S3_DB_TABLENAME tablename, int nId, ColumnAndValue *pcav);
  452. //S3DBI_API int S3DBI_GetData(S3_DB_TABLENAME tablename, char * strUser , ColumnAndValue * pCav);
  453. //S3DBI_API int S3DBI_UpdateData(S3_DB_TABLENAME tablename, int nId, ColumnAndValue *pcav);
  454. //S3DBI_API int S3DBI_UpdateData(S3_DB_TABLENAME tablename, char * strUser, ColumnAndValue *pcav);
  455. S3DBI_API int S3DBI_DeleteData(S3_DB_TABLENAME tablename, int nId);
  456. S3DBI_API int S3DBI_DeleteData(S3_DB_TABLENAME tablename, char * strUser);
  457. //S3DBI_API int S3DBI_InsertData(S3_DB_TABLENAME tablename, int nId, ColumnAndValue cav);
  458. //S3DBI_API int S3DBI_InsertData(S3_DB_TABLENAME tablename, char * strUser, ColumnAndValue cav);
  461. S3DBI_API int S3DBI_GetListData(S3DBI_LISTNAME listname, void * pList, int i , KTabFileCtrl *pTabFile);
  462. S3DBI_API int S3DBI_DeleteDataAtList(S3DBI_LISTNAME listname, void * pList, int i );
  463. S3DBI_API int S3DBI_InsertDataAtList(S3DBI_LISTNAME listname, void * pList, KTabFileCtrl *pTabFile);
  464. S3DBI_API int S3DBI_GetData(S3_DB_TABLENAME tablename, int nId, KTabFileCtrl *pTabFile);
  465. S3DBI_API int S3DBI_GetData(S3_DB_TABLENAME tablename, char * strUser, KTabFileCtrl * pTabFile);
  466. S3DBI_API int S3DBI_UpdateData(S3_DB_TABLENAME tablename, int nId, KTabFileCtrl *pTabFile);
  467. S3DBI_API int S3DBI_UpdateData(S3_DB_TABLENAME tablename, char * strUser, KTabFileCtrl *pTabFile);
  468. S3DBI_API int S3DBI_InsertData(S3_DB_TABLENAME tablename,  KTabFileCtrl *pTabFile);
  469. #endif