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

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

模拟服务器

开发平台：

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