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

源码开发语言/平台
当前位置：首页 > 源码/资料 > 游戏 > 模拟服务器 > 查看源码
Handler_CommonDB.cpp
资源名称：LegendOfMir2_Server020418.zip　[点击查看]
上传用户：szopptop
上传日期：2013-04-23
资源大小：1047k
文件大小：17k
源码类别：

模拟服务器

开发平台：

Visual C++

Handler_CommonDB.cpp：源码内容
  1. #include "stdafx.h"
  3. void SendRDBSocket(int nCertification, char *pszData1, char *pszData2, int nData2Len);
  5. CMapInfo* InitMapInfo(int nServerIndex)
  6. {
  7. char szQuery[1024];
  9. CRecordset *pRec = g_pConnCommon->CreateRecordset();
  10. sprintf( szQuery, "SELECT COUNT(*) AS FLD_COUNT FROM TBL_MAPINFO WHERE FLD_SERVERINDEX = %d", nServerIndex );
  12. if (pRec->Execute( szQuery ))
  13. {
  14. if (pRec->Fetch())
  15. g_nNumOfMapInfo = atoi( pRec->Get( "FLD_COUNT" ) );
  16. }
  18. g_pConnCommon->DestroyRecordset( pRec );
  20. if (g_nNumOfMapInfo < 0) return NULL;
  22. CMapInfo* pMapInfo = new CMapInfo[g_nNumOfMapInfo];
  24. sprintf( szQuery, "SELECT * FROM TBL_MAPINFO WHERE FLD_SERVERINDEX = %d", nServerIndex );
  26. pRec = g_pConnCommon->CreateRecordset();
  28. if (pRec->Execute( szQuery ))
  29. {
  30. for (int i = 0; i < g_nNumOfMapInfo; i++)
  31. {
  32. if (pRec->Fetch())
  33. {
  34. strcpy(pMapInfo[i].szMapFileName, pRec->Get( "FLD_MAPFILENAME" ) );
  35. ChangeSpaceToNull(pMapInfo[i].szMapFileName);
  36. strcpy(pMapInfo[i].szMapName, pRec->Get( "FLD_MAPNAME" ) );
  37. ChangeSpaceToNull(pMapInfo[i].szMapName);
  39. pMapInfo[i].dwAttribute = atoi( pRec->Get( "FLD_ATTRIBUTE" ) );
  41. pMapInfo[i].btMapSeries = atoi( pRec->Get( "FLD_MAPSERIES" ) );
  42. pMapInfo[i].btMapSeriesValue = atoi( pRec->Get( "FLD_MAPSERIESVAL" ) );
  43. }
  44. }
  45. }
  47. g_pConnCommon->DestroyRecordset( pRec );
  49. return pMapInfo;
  50. }
  52. void InitStdItemEtcInfo()
  53. {
  54. char szQuery[1024];
  56. CRecordset *pRec;
  58. pRec= g_pConnCommon->CreateRecordset();
  60. sprintf( szQuery, "SELECT COUNT(*) AS FLD_COUNT FROM TBL_STDITEM_ETC");
  62. if (pRec->Execute( szQuery ))
  63. {
  64. if (pRec->Fetch())
  65. g_nStdItemEtc = atoi( pRec->Get( "FLD_COUNT" ) );
  66. }
  68. g_pConnCommon->DestroyRecordset( pRec );
  70. if (g_nStdItemEtc < 0) return;
  72. g_pStdItemEtc = new CStdItem[g_nStdItemEtc];
  74. sprintf( szQuery, "SELECT * FROM TBL_STDITEM_ETC ORDER BY FLD_INDEX");
  76. pRec = g_pConnCommon->CreateRecordset();
  78. if (pRec->Execute( szQuery ))
  79. {
  80. for (int i = 0; i < g_nStdItemEtc; i++)
  81. {
  82. if (pRec->Fetch())  
  83. {
  84. strcpy(g_pStdItemEtc[i].szName, pRec->Get( "FLD_NAME" ) );
  86. g_pStdItemEtc[i].wStdMode = atoi( pRec->Get( "FLD_STDMODE" ) );
  87. g_pStdItemEtc[i].wShape = atoi( pRec->Get( "FLD_SHAPE" ) );
  88. g_pStdItemEtc[i].wWeight = atoi( pRec->Get( "FLD_WEIGHT" ) );
  89. g_pStdItemEtc[i].dwLooks = atoi( pRec->Get( "FLD_LOOKS" ) );
  90. g_pStdItemEtc[i].wDuraMax = atoi( pRec->Get( "FLD_VAL1" ) );
  91. g_pStdItemEtc[i].dwRSource = atoi( pRec->Get( "FLD_VAL2" ) );
  92. g_pStdItemEtc[i].dwPrice = atoi( pRec->Get( "FLD_PRICE" ) );
  93. }
  94. }
  96. InsertLogMsgParam(IDS_FETCH_STDITEMETC, &g_nStdItemEtc, LOGPARAM_INT);
  97. }
  99. g_pConnCommon->DestroyRecordset( pRec );
  100. }
  102. void InitStdItemSpecial()
  103. {
  104. char szQuery[1024];
  106. CRecordset *pRec = g_pConnCommon->CreateRecordset();
  107. sprintf( szQuery, "SELECT COUNT(*) AS FLD_COUNT FROM TBL_STDITEM");
  109. if (pRec->Execute( szQuery ))
  110. {
  111. if (pRec->Fetch())
  112. g_nStdItemSpecial = atoi( pRec->Get( "FLD_COUNT" ) );
  113. }
  115. g_pConnCommon->DestroyRecordset( pRec );
  117. if (g_nStdItemSpecial < 0) return;
  119. g_pStdItemSpecial = new CStdItemSpecial[g_nStdItemSpecial];
  121. sprintf( szQuery, "SELECT * FROM TBL_STDITEM ORDER BY FLD_INDEX");
  123. pRec = g_pConnCommon->CreateRecordset();
  125. if (pRec->Execute( szQuery ))
  126. {
  127. for (int i = 0; i < g_nStdItemSpecial; i++)
  128. {
  129. if (pRec->Fetch())  
  130. {
  131. strcpy(g_pStdItemSpecial[i].szName, pRec->Get( "FLD_NAME" ) );
  133. g_pStdItemSpecial[i].wStdMode = (SHORT)atoi( pRec->Get( "FLD_STDMODE" ) );
  134. g_pStdItemSpecial[i].btType = (BYTE)atoi( pRec->Get( "FLD_TYPE" ) );
  135. g_pStdItemSpecial[i].wShape = (SHORT)atoi( pRec->Get( "FLD_SHAPE" ) );
  136. g_pStdItemSpecial[i].wWeight = (SHORT)atoi( pRec->Get( "FLD_WEIGHT" ) );
  137. g_pStdItemSpecial[i].wAniCount = (SHORT)atoi( pRec->Get( "FLD_ANICOUNT" ) );
  138. g_pStdItemSpecial[i].wSource = (SHORT)atoi( pRec->Get( "FLD_SOURCE" ) );
  139. g_pStdItemSpecial[i].dwLooks = (LONG)atoi( pRec->Get( "FLD_LOOKS" ) );
  140. g_pStdItemSpecial[i].wDuraMax = (WORD)atoi( pRec->Get( "FLD_DURAMAX" ) );
  141. g_pStdItemSpecial[i].wAC = (BYTE)atoi( pRec->Get( "FLD_AC" ) );
  142. g_pStdItemSpecial[i].wAC2 = (BYTE)atoi( pRec->Get( "FLD_AC2" ) );
  143. g_pStdItemSpecial[i].wMAC = (BYTE)atoi( pRec->Get( "FLD_MAC" ) );
  144. g_pStdItemSpecial[i].wMAC2 = (BYTE)atoi( pRec->Get( "FLD_MAC2" ) );
  145. g_pStdItemSpecial[i].wDC = (BYTE)atoi( pRec->Get( "FLD_DC" ) );
  146. g_pStdItemSpecial[i].wDC2 = (BYTE)atoi( pRec->Get( "FLD_DC2" ) );
  147. g_pStdItemSpecial[i].wMC = (BYTE)atoi( pRec->Get( "FLD_MC" ) );
  148. g_pStdItemSpecial[i].wMC2 = (BYTE)atoi( pRec->Get( "FLD_MC2" ) );
  149. g_pStdItemSpecial[i].wSC = (BYTE)atoi( pRec->Get( "FLD_SC" ) );
  150. g_pStdItemSpecial[i].wSC2 = (BYTE)atoi( pRec->Get( "FLD_SC2" ) );
  151. g_pStdItemSpecial[i].wNeed = (SHORT)atoi( pRec->Get( "FLD_NEED" ) );
  152. g_pStdItemSpecial[i].wNeedLevel = (SHORT)atoi( pRec->Get( "FLD_NEEDLEVEL" ) );
  153. g_pStdItemSpecial[i].dwPrice = (LONG)atoi( pRec->Get( "FLD_PRICE" ) );
  154. g_pStdItemSpecial[i].dwStock = (LONG)atoi( pRec->Get( "FLD_STOCK" ) );
  156. g_pStdItemSpecial[i].m_btWater = (BYTE)atoi( pRec->Get( "FLD_WATER1" ) );
  157. g_pStdItemSpecial[i].m_btWater2 = (BYTE)atoi( pRec->Get( "FLD_WATER2" ) );
  158. g_pStdItemSpecial[i].m_btFire = (BYTE)atoi( pRec->Get( "FLD_FIRE1" ) );
  159. g_pStdItemSpecial[i].m_btFire2 = (BYTE)atoi( pRec->Get( "FLD_FIRE2" ) );
  160. g_pStdItemSpecial[i].m_btWind = (BYTE)atoi( pRec->Get( "FLD_WIND1" ) );
  161. g_pStdItemSpecial[i].m_btWind2 = (BYTE)atoi( pRec->Get( "FLD_WIND2" ) );
  162. g_pStdItemSpecial[i].m_btLight = (BYTE)atoi( pRec->Get( "FLD_LIGHT1" ) );
  163. g_pStdItemSpecial[i].m_btLight2 = (BYTE)atoi( pRec->Get( "FLD_LIGHT2" ) );
  164. g_pStdItemSpecial[i].m_btEarth = (BYTE)atoi( pRec->Get( "FLD_EARTH1" ) );
  165. g_pStdItemSpecial[i].m_btEarth2 = (BYTE)atoi( pRec->Get( "FLD_EARTH2" ) );
  166. }
  167. }
  169. InsertLogMsgParam(IDS_FETCH_STDITEMACCESSORY, &g_nStdItemSpecial, LOGPARAM_INT);
  170. }
  172. g_pConnCommon->DestroyRecordset( pRec );
  173. }
  175. void InitMonsterGenInfo()
  176. {
  177. char szQuery[1024];
  179. CRecordset *pRec = g_pConnCommon->CreateRecordset();
  180. sprintf( szQuery, "SELECT COUNT(*) AS FLD_COUNT FROM TBL_MONGEN");
  182. if (pRec->Execute( szQuery ))
  183. {
  184. if (pRec->Fetch())
  185. g_nNumOfMonGenInfo = atoi( pRec->Get( "FLD_COUNT" ) );
  186. }
  188. g_pConnCommon->DestroyRecordset( pRec );
  190. if (g_nNumOfMonGenInfo < 0) return;
  192. g_pMonGenInfo = new CMonsterGenInfo[g_nNumOfMonGenInfo + 1];
  194. sprintf( szQuery, "SELECT * FROM TBL_MONGEN ORDER BY FLD_MAPNAME");
  196. pRec = g_pConnCommon->CreateRecordset();
  198. if (pRec->Execute( szQuery ))
  199. {
  200. for (int i = 0; i < g_nNumOfMonGenInfo; i++)
  201. {
  202. if (pRec->Fetch())  
  203. {
  204. strcpy(g_pMonGenInfo[i].szMapName, pRec->Get( "FLD_MAPNAME" ) );
  205. strcpy(g_pMonGenInfo[i].szMonName, pRec->Get( "FLD_MONNAME" ) );
  207. g_pMonGenInfo[i].dwZenTime = atoi( pRec->Get( "FLD_GENTIME" ) ) * 60000;
  208. g_pMonGenInfo[i].dwStartTime = 0;
  210. g_pMonGenInfo[i].nMonIndex = atoi( pRec->Get( "FLD_MONINDEX" ) );
  212. g_pMonGenInfo[i].nCount = atoi( pRec->Get( "FLD_COUNT" ) );
  214. g_pMonGenInfo[i].nX = atoi( pRec->Get( "FLD_X" ) );
  215. g_pMonGenInfo[i].nY = atoi( pRec->Get( "FLD_Y" ) );
  217. g_pMonGenInfo[i].nAreaX = atoi( pRec->Get( "FLD_AREA_X" ) );
  218. g_pMonGenInfo[i].nAreaY = atoi( pRec->Get( "FLD_AREA_Y" ) );
  219. }
  220. }
  222. InsertLogMsgParam(IDS_FETCH_MONGEN, &g_nNumOfMonGenInfo, LOGPARAM_INT);
  223. }
  225. g_pConnCommon->DestroyRecordset( pRec );
  226. }
  228. // **************************************************************************************
  229. //
  230. // Initializing Monster Item Generate Information
  231. //
  232. // **************************************************************************************
  234. void InitMonItemInfo()
  235. {
  236. int nMonIndex;
  237. char szQuery[1024];
  238. CRecordset *pRec = g_pConnCommon->CreateRecordset();
  240. sprintf( szQuery, "SELECT * FROM TBL_MONITEM");
  242. if (pRec->Execute( szQuery ))
  243. {
  244. while (pRec->Fetch())
  245. {
  246. nMonIndex = atoi( pRec->Get( "FLD_MONSTER" ));
  248. CMonItem* pMonItem = new CMonItem;
  250. if (pMonItem)
  251. {
  252. pMonItem->m_btItemType = atoi( pRec->Get( "FLD_TYPE" ));
  253. pMonItem->m_wItemIndex = atoi( pRec->Get( "FLD_ITEM" ));
  254. pMonItem->m_nPoint = atoi( pRec->Get( "FLD_PROBABLY" ));
  255. pMonItem->m_wCount = atoi( pRec->Get( "FLD_COUNT" ));
  257. if (g_pMonRaceInfo && (nMonIndex <= g_nNumOfMonRaceInfo))
  258. g_pMonRaceInfo[nMonIndex].m_xMonItemList.AddNewNode(pMonItem);
  259. }
  260. }
  261. }
  263. g_pConnCommon->DestroyRecordset( pRec );
  264. }
  266. // **************************************************************************************
  267. //
  268. // Initializing Monster Information
  269. //
  270. // **************************************************************************************
  272. void InitMonRaceInfo()
  273. {
  274. char szQuery[1024];
  276. CRecordset *pRec = g_pConnCommon->CreateRecordset();
  277. sprintf( szQuery, "SELECT COUNT(*) AS FLD_COUNT FROM TBL_MONSTER");
  279. if (pRec->Execute( szQuery ))
  280. {
  281. if (pRec->Fetch())
  282. g_nNumOfMonRaceInfo = atoi( pRec->Get( "FLD_COUNT" ) );
  283. }
  285. g_pConnCommon->DestroyRecordset( pRec );
  287. if (g_nNumOfMonRaceInfo < 0) return;
  289. g_pMonRaceInfo = new CMonRaceInfo[g_nNumOfMonRaceInfo];
  291. sprintf( szQuery, "SELECT * FROM TBL_MONSTER ORDER BY FLD_INDEX");
  293. pRec = g_pConnCommon->CreateRecordset();
  295. if (pRec->Execute( szQuery ))
  296. {
  297. for (int i = 0; i < g_nNumOfMonRaceInfo; i++)
  298. {
  299. if (pRec->Fetch())  
  300. {
  301. g_pMonRaceInfo[i].nIndex = i;
  303. strcpy(g_pMonRaceInfo[i].szMonName, pRec->Get( "FLD_NAME" ) );
  304. ChangeSpaceToNull(g_pMonRaceInfo[i].szMonName);
  306. g_pMonRaceInfo[i].nMonRace = atoi( pRec->Get( "FLD_RACE" ) );
  307. g_pMonRaceInfo[i].nAppear = atoi( pRec->Get( "FLD_APPR" ) );
  309. g_pMonRaceInfo[i].btUndead = (BYTE)atoi( pRec->Get( "FLD_UNDEAD" ) );
  310. g_pMonRaceInfo[i].Level = (BYTE)atoi( pRec->Get( "FLD_LEVEL" ) );
  312. g_pMonRaceInfo[i].HP = atoi( pRec->Get( "FLD_HP" ) );
  313. g_pMonRaceInfo[i].MP = atoi( pRec->Get( "FLD_MP" ) );
  315. g_pMonRaceInfo[i].AC = atoi( pRec->Get( "FLD_AC" ) );
  316. g_pMonRaceInfo[i].MAC = atoi( pRec->Get( "FLD_MAC" ) );
  317. g_pMonRaceInfo[i].DC =  MAKEWORD((BYTE)atoi( pRec->Get( "FLD_DC" ) ), (BYTE)atoi( pRec->Get( "FLD_MAXDC" ) ));
  319. g_pMonRaceInfo[i].dwAttackSpeed = atoi( pRec->Get( "FLD_ATTACKSPEED" ) );
  320. g_pMonRaceInfo[i].dwWalkSpeed = atoi( pRec->Get( "FLD_WALKSPEED" ) );
  322. g_pMonRaceInfo[i].Speed = atoi( pRec->Get( "FLD_SPEED" ) );
  323. g_pMonRaceInfo[i].Hit = atoi( pRec->Get( "FLD_HIT" ) );
  325. g_pMonRaceInfo[i].ViewRange = (BYTE)atoi( pRec->Get( "FLD_VIEWRANGE" ) );
  327. g_pMonRaceInfo[i].wRaceIndex = atoi( pRec->Get( "FLD_RACEINDEX" ) );
  329. g_pMonRaceInfo[i].Exp = atoi( pRec->Get( "FLD_EXP" ) );
  331. g_pMonRaceInfo[i].wEscape = atoi( pRec->Get( "FLD_ESCAPE" ) );
  333. g_pMonRaceInfo[i].m_wWater = MAKEWORD((BYTE)atoi( pRec->Get( "FLD_WATER1" ) ), (BYTE)atoi( pRec->Get( "FLD_WATER2" ) ));
  334. g_pMonRaceInfo[i].m_wFire = MAKEWORD((BYTE)atoi( pRec->Get( "FLD_FIRE1" ) ), (BYTE)atoi( pRec->Get( "FLD_FIRE2" ) ));
  335. g_pMonRaceInfo[i].m_wWind = MAKEWORD((BYTE)atoi( pRec->Get( "FLD_WIND1" ) ), (BYTE)atoi( pRec->Get( "FLD_WIND2" ) ));
  336. g_pMonRaceInfo[i].m_wLight = MAKEWORD((BYTE)atoi( pRec->Get( "FLD_LIGHT1" ) ), (BYTE)atoi( pRec->Get( "FLD_LIGHT2" ) ));
  337. g_pMonRaceInfo[i].m_wEarth = MAKEWORD((BYTE)atoi( pRec->Get( "FLD_EARTH1" ) ), (BYTE)atoi( pRec->Get( "FLD_EARTH2" ) ));
  338. }
  339. }
  341. InsertLogMsgParam(IDS_FETCH_MONSTER, &g_nNumOfMonRaceInfo, LOGPARAM_INT);
  342. }
  344. g_pConnCommon->DestroyRecordset( pRec );
  346. InitMonItemInfo();
  347. }
  349. void InitMerchantInfo()
  350. {
  351. char szQuery[1024];
  353. CRecordset *pRec = g_pConnCommon->CreateRecordset();
  354. sprintf( szQuery, "SELECT COUNT(*) AS FLD_COUNT FROM TBL_MERCHANT");
  356. if (pRec->Execute( szQuery ))
  357. {
  358. if (pRec->Fetch())
  359. g_nNumOfMurchantInfo = atoi( pRec->Get( "FLD_COUNT" ) );
  360. }
  362. g_pConnCommon->DestroyRecordset( pRec );
  364. if (g_nNumOfMurchantInfo < 0) return;
  366. g_pMerchantInfo = new CMerchantInfo[g_nNumOfMurchantInfo];
  368. sprintf( szQuery, "SELECT * FROM TBL_MERCHANT ORDER BY FLD_ID");
  370. pRec = g_pConnCommon->CreateRecordset();
  372. if (pRec->Execute( szQuery ))
  373. {
  374. for (int i = 0; i < g_nNumOfMurchantInfo; i++)
  375. {
  376. if (pRec->Fetch())  
  377. {
  378. strcpy(g_pMerchantInfo[i].szNPCName, pRec->Get( "FLD_NPCNAME" ) );
  379. ChangeSpaceToNull(g_pMerchantInfo[i].szNPCName);
  380. strcpy(g_pMerchantInfo[i].szMapName, pRec->Get( "FLD_MAPNAME" ) );
  381. ChangeSpaceToNull(g_pMerchantInfo[i].szMapName);
  383. g_pMerchantInfo[i].nPosX = atoi( pRec->Get( "FLD_POSX" ) );
  384. g_pMerchantInfo[i].nPosY = atoi( pRec->Get( "FLD_POSY" ) );
  385. g_pMerchantInfo[i].sFace = atoi( pRec->Get( "FLD_FACE" ) );
  386. g_pMerchantInfo[i].sBody = atoi( pRec->Get( "FLD_BODY" ) );
  387. g_pMerchantInfo[i].sGender = atoi( pRec->Get( "FLD_GENDER" ) );
  388. }
  389. }
  391. InsertLogMsgParam(IDS_FETCH_MERCHANT, &g_nNumOfMurchantInfo, LOGPARAM_INT);
  392. }
  394. g_pConnCommon->DestroyRecordset( pRec );
  395. }
  397. void InitMagicInfo()
  398. {
  399. char szQuery[1024];
  401. CRecordset *pRec = g_pConnCommon->CreateRecordset();
  402. sprintf( szQuery, "SELECT COUNT(*) AS FLD_COUNT FROM TBL_MAGIC");
  404. if (pRec->Execute( szQuery ))
  405. {
  406. if (pRec->Fetch())
  407. g_nNumOfMagicInfo = atoi( pRec->Get( "FLD_COUNT" ) );
  408. }
  410. g_pConnCommon->DestroyRecordset( pRec );
  412. if (g_nNumOfMagicInfo < 0) return;
  414. g_pMagicInfo = new CMagicInfo[g_nNumOfMagicInfo];
  416. sprintf( szQuery, "SELECT * FROM TBL_MAGIC ORDER BY FLD_INDEX");
  418. pRec = g_pConnCommon->CreateRecordset();
  420. if (pRec->Execute( szQuery ))
  421. {
  422. for (int i = 0; i < g_nNumOfMagicInfo; i++)
  423. {
  424. if (pRec->Fetch())  
  425. {
  426. g_pMagicInfo[i].nIndex = atoi( pRec->Get( "FLD_INDEX" ) );
  428. strcpy(g_pMagicInfo[i].szName, pRec->Get( "FLD_NAME" ) );
  429. ChangeSpaceToNull(g_pMagicInfo[i].szName);
  431. g_pMagicInfo[i].sEffectType = atoi( pRec->Get( "FLD_EFFECTTYPE" ) );
  432. g_pMagicInfo[i].sEffect = atoi( pRec->Get( "FLD_EFFECT" ) );
  433. g_pMagicInfo[i].sSpell = atoi( pRec->Get( "FLD_SPELL" ) );
  434. g_pMagicInfo[i].sPower = atoi( pRec->Get( "FLD_POWER" ) );
  435. g_pMagicInfo[i].sMaxPower = atoi( pRec->Get( "FLD_MAXPOWER" ) );
  436. g_pMagicInfo[i].sDefSpell = atoi( pRec->Get( "FLD_DEFSPELL" ) );
  437. g_pMagicInfo[i].sDefPower = atoi( pRec->Get( "FLD_DEFPOWER" ) );
  438. g_pMagicInfo[i].sDefMaxPower = atoi( pRec->Get( "FLD_DEFMAXPOWER" ) );
  439. g_pMagicInfo[i].sJob = atoi( pRec->Get( "FLD_JOB" ) );
  440. g_pMagicInfo[i].sNeed[0] = atoi( pRec->Get( "FLD_NEEDL1" ) );
  441. g_pMagicInfo[i].nTrain[0] = atoi( pRec->Get( "FLD_L1TRAIN" ) );
  442. g_pMagicInfo[i].sNeed[1] = atoi( pRec->Get( "FLD_NEEDL2" ) );
  443. g_pMagicInfo[i].nTrain[1] = atoi( pRec->Get( "FLD_L2TRAIN" ) );
  444. g_pMagicInfo[i].sNeed[2] = atoi( pRec->Get( "FLD_NEEDL3" ) );
  445. g_pMagicInfo[i].nTrain[2] = atoi( pRec->Get( "FLD_L3TRAIN" ) );
  446. g_pMagicInfo[i].sDelay = atoi( pRec->Get( "FLD_DELAY" ) );
  447. }
  448. }
  450. InsertLogMsgParam(IDS_FETCH_MAGICDATA, &g_nNumOfMagicInfo, LOGPARAM_INT);
  451. }
  453. g_pConnCommon->DestroyRecordset( pRec );
  454. }
  456. void InitMoveMapEventInfo()
  457. {
  458. char szQuery[1024];
  460. CRecordset *pRec = g_pConnCommon->CreateRecordset();
  461. sprintf( szQuery, "SELECT COUNT(*) AS FLD_COUNT FROM TBL_MOVEMAPEVENT");
  463. if (pRec->Execute( szQuery ))
  464. {
  465. if (pRec->Fetch())
  466. g_nNumOfMoveMapEventInfo = atoi( pRec->Get( "FLD_COUNT" ) );
  467. }
  469. g_pConnCommon->DestroyRecordset( pRec );
  471. if (g_nNumOfMoveMapEventInfo < 0) return;
  473. g_pMoveMapEventInfo = new CMoveMapEventInfo[g_nNumOfMoveMapEventInfo];
  475. sprintf( szQuery, "SELECT * FROM TBL_MOVEMAPEVENT ORDER BY FLD_INDEX");
  477. pRec = g_pConnCommon->CreateRecordset();
  479. if (pRec->Execute( szQuery ))
  480. {
  481. for (int i = 0; i < g_nNumOfMoveMapEventInfo; i++)
  482. {
  483. if (pRec->Fetch())  
  484. {
  485. strcpy(g_pMoveMapEventInfo[i].szSMapFileName, pRec->Get( "FLD_SMAPFILENAME" ) );
  486. strcpy(g_pMoveMapEventInfo[i].szDMapFileName, pRec->Get( "FLD_DMAPFILENAME" ) );
  488. g_pMoveMapEventInfo[i].nSX = atoi( pRec->Get( "FLD_SX" ) );
  489. g_pMoveMapEventInfo[i].nSY = atoi( pRec->Get( "FLD_SY" ) );
  490. g_pMoveMapEventInfo[i].nDX = atoi( pRec->Get( "FLD_DX" ) );
  491. g_pMoveMapEventInfo[i].nDY = atoi( pRec->Get( "FLD_DY" ) );
  493. g_pMoveMapEventInfo[i].fIsOpen = FALSE;
  494. }
  495. }
  497. InsertLogMsgParam(IDS_FETCH_MOVEMAPEVENT, &g_nNumOfMoveMapEventInfo, LOGPARAM_INT);
  498. }
  500. g_pConnCommon->DestroyRecordset( pRec );
  501. }
  503. CMagicInfo* GetMagicInfo(int nMagicID)
  504. {
  505.   if (g_pMagicInfo[nMagicID].nIndex == nMagicID)
  506. return &g_pMagicInfo[nMagicID];
  508. for (int i = 0; i < g_nNumOfMagicInfo; i++)
  509. {
  510. if (g_pMagicInfo[i].nIndex == nMagicID)
  511. return &g_pMagicInfo[i];
  512. }
  514. return NULL;
  515. }
  517. CMonsterGenInfo* GetMonGenInfo(char *pszMonName)
  518. {
  519. int nCmpLen;
  520. int nLen = memlen(pszMonName) - 1;
  522. for (int i = 0; i < g_nNumOfMonGenInfo; i++)
  523. {
  524. nCmpLen = memlen(g_pMonGenInfo[i].szMonName) - 1;
  526. if (nCmpLen == nLen)
  527. {
  528. if (memcmp(g_pMonGenInfo[i].szMonName, pszMonName, nLen) == 0)
  529. return &g_pMonGenInfo[i];
  530. }
  531. }
  533. return NULL;
  534. }
  536. CMonRaceInfo* GetMonRaceInfo(char *pszMonName)
  537. {
  538. int nCmpLen;
  539. int nLen = memlen(pszMonName) - 1;
  541. for (int i = 0; i < g_nNumOfMonRaceInfo; i++)
  542. {
  543. nCmpLen = memlen(g_pMonRaceInfo[i].szMonName) - 1;
  545. if (nCmpLen == nLen)
  546. {
  547. if (memcmp(g_pMonRaceInfo[i].szMonName, pszMonName, nLen) == 0)
  548. return &g_pMonRaceInfo[i];
  549. }
  550. }
  552. return NULL;
  553. }