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

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