1. ## ERİC BLOODAXE ##
  3. Game-Db Source/Server/db/src/ClientManagerBoot.cpp
  5. gir ve arat;
  7. if (!MirrorMobTableIntoDB())
  8. {
  9. sys_err("MirrorMobTableIntoDB FAILED");
  10. return false;
  11. }
  12. if (!MirrorItemTableIntoDB())
  13. {
  14. sys_err("MirrorItemTableIntoDB FAILED");
  15. return false;
  16. }
  18. değiştir;
  20. /*if (!MirrorMobTableIntoDB())
  21. {
  22. sys_err("MirrorMobTableIntoDB FAILED");
  23. return false;
  24. }*/
  25. /*if (!MirrorItemTableIntoDB())
  26. {
  27. sys_err("MirrorItemTableIntoDB FAILED");
  28. return false;
  29. }*/
  31. tekrar arat;
  33. bool CClientManager::InitializeMobTable()
  35. fonksiyonu komple değiştir;
  37. bool CClientManager::InitializeMobTable()
  38. {
  39. char query[2048];
  40. fprintf(stderr,"Loading mob_proto from MySQL ");
  41. snprintf(query, sizeof(query),
  42. "SELECT vnum,name,%s,rank,type,battle_type,level,size,ai_flag,mount_capacity,setRaceFlag,setImmuneFlag,"
  43. "empire,folder,on_click,st,dx,ht,iq,damage_min,damage_max,max_hp,regen_cycle,regen_percent,gold_min,"
  44. "gold_max,exp,def,attack_speed,move_speed,aggressive_hp_pct,aggressive_sight,attack_range,drop_item,"
  45. "resurrection_vnum,enchant_curse,enchant_slow,enchant_poison,enchant_stun,enchant_critical,enchant_penetrate,"
  46. "resist_sword,resist_twohand,resist_dagger,resist_bell,resist_fan,resist_bow,resist_fire,resist_elect,"
  47. "resist_magic,resist_wind,resist_poison,dam_multiply,summon,drain_sp,mob_color,polymorph_item,skill_level0,"
  48. "skill_vnum0,skill_level1,skill_vnum1,sp_berserk,sp_stoneskin,sp_godspeed,sp_deathblow,sp_revive,skill_level2,"
  49. "skill_vnum2,skill_level3,skill_vnum3,skill_level4,skill_vnum4 FROM mob_proto%s"
  50. ,g_stLocaleNameColumn.c_str(),
  51. GetTablePostfix());
  53. std::unique_ptr<SQLMsg> pkMsg(CDBManager::instance().DirectQuery(query));
  54. SQLResult * pRes = pkMsg->Get();
  56. if (!pRes->uiNumRows)
  57. return false;
  59. if (!m_vec_mobTable.empty())
  60. {
  61. sys_log(0, "RELOAD: mob_proto");
  62. m_vec_mobTable.clear();
  63. }
  64. int size = pRes->uiNumRows;
  65. m_vec_mobTable.resize(size);
  66. memset(&m_vec_mobTable[0], 0, sizeof(TMobTable) * m_vec_mobTable.size());
  67. TMobTable * mob_table = &m_vec_mobTable[0];
  69. MYSQL_ROW data;
  70. //return true;
  71. set<int> vnumSet;
  72. while ((data = mysql_fetch_row(pRes->pSQLResult)))
  73. {
  75. /*
  76. "SELECT vnum,name,locale_name,rank,type,battle_type,level,size,ai_flag,mount_capacity,setRaceFlag,setImmuneFlag,"
  77. "empire,folder,on_click,st,dx,ht,iq,damage_min,damage_max,max_hp,regen_cycle,regen_percent,gold_min,"
  78. "gold_max,exp,def,attack_speed,move_speed,aggressive_hp_pct,aggressive_sight,attack_range,drop_item,"
  79. "resurrection_vnum,enchant_curse,enchant_slow,enchant_poison,enchant_stun,enchant_critical,enchant_penetrate,"
  80. "resist_sword,resist_twohand,resist_dagger,resist_bell,resist_fan,resist_bow,resist_fire,resist_elect,"
  81. "resist_magic,resist_wind,resist_poison,dam_multiply,summon,drain_sp,mob_color,polymorph_item,skill_level0,"
  82. "skill_vnum0,skill_level1,skill_vnum1,sp_berserk,sp_stoneskin,sp_godspeed,sp_deathblow,sp_revive,skill_level2,"
  83. "skill_vnum2,skill_level3,skill_vnum3,skill_level4,skill_vnum4 FROM mob_proto%s */
  84. int col = 0;
  85. str_to_number(mob_table->dwVnum, data[col++]);
  86. if(mob_table->dwVnum ==0) continue;
  87. strlcpy(mob_table->szName,data[col++] , sizeof(mob_table->szName));
  88. strlcpy(mob_table->szLocaleName, data[col++], sizeof(mob_table->szLocaleName));
  89. str_to_number(mob_table->bRank,data[col++]);
  90. str_to_number(mob_table->bType,data[col++]);
  91. str_to_number(mob_table->bBattleType,data[col++]);
  92. str_to_number(mob_table->bLevel,data[col++]);
  93. str_to_number(mob_table->bSize,data[col++]);
  94. //AI_FLAG
  95. mob_table->dwAIFlag = get_Mob_AIFlag_Value(data[col++]);
  96. //mount_capacity;
  97. col++;
  98. //RACE_FLAG
  99. mob_table->dwRaceFlag = get_Mob_RaceFlag_Value(data[col++]);
  100. //IMMUNE_FLAG
  101. mob_table->dwImmuneFlag = get_Mob_ImmuneFlag_Value(data[col++]);
  102. mob_table->bEmpire = atoi(data[col++]);
  103. strlcpy(mob_table->szFolder, data[col++], sizeof(mob_table->szFolder));
  104. mob_table->bOnClickType = atoi(data[col++]);
  105. mob_table->bStr = atoi(data[col++]);
  106. mob_table->bDex = atoi(data[col++]);
  107. mob_table->bCon = atoi(data[col++]);
  108. mob_table->bInt = atoi(data[col++]);
  109. mob_table->dwDamageRange[0] = atoi(data[col++]);
  110. mob_table->dwDamageRange[1] = atoi(data[col++]);
  111. mob_table->dwMaxHP = atoi(data[col++]);
  112. mob_table->bRegenCycle = atoi(data[col++]);
  113. mob_table->bRegenPercent = atoi(data[col++]);
  114. mob_table->dwGoldMin = atoi(data[col++]);
  115. mob_table->dwGoldMax = atoi(data[col++]);
  116. mob_table->dwExp = atoi(data[col++]);
  117. mob_table->wDef = atoi(data[col++]);
  118. mob_table->sAttackSpeed = atoi(data[col++]);
  119. mob_table->sMovingSpeed = atoi(data[col++]);
  120. mob_table->bAggresiveHPPct = atoi(data[col++]);
  121. mob_table->wAggressiveSight = atoi(data[col++]);
  122. mob_table->wAttackRange = atoi(data[col++]);
  123. str_to_number(mob_table->dwDropItemVnum, data[col++]); //32
  124. str_to_number(mob_table->dwResurrectionVnum, data[col++]);
  125. for (int i = 0; i < MOB_ENCHANTS_MAX_NUM; ++i)
  126. str_to_number(mob_table->cEnchants[i], data[col++]);
  128. for (int i = 0; i < MOB_RESISTS_MAX_NUM; ++i)
  129. str_to_number(mob_table->cResists[i], data[col++]);
  131. str_to_number(mob_table->fDamMultiply, data[col++]);
  132. str_to_number(mob_table->dwSummonVnum, data[col++]);
  133. str_to_number(mob_table->dwDrainSP, data[col++]);
  135. //Mob_Color
  136. ++col;
  138. str_to_number(mob_table->dwPolymorphItemVnum, data[col++]);
  140. str_to_number(mob_table->Skills[0].bLevel, data[col++]);
  141. str_to_number(mob_table->Skills[0].dwVnum, data[col++]);
  142. str_to_number(mob_table->Skills[1].bLevel, data[col++]);
  143. str_to_number(mob_table->Skills[1].dwVnum, data[col++]);
  144. str_to_number(mob_table->Skills[2].bLevel, data[col++]);
  145. str_to_number(mob_table->Skills[2].dwVnum, data[col++]);
  146. str_to_number(mob_table->Skills[3].bLevel, data[col++]);
  147. str_to_number(mob_table->Skills[3].dwVnum, data[col++]);
  148. str_to_number(mob_table->Skills[4].bLevel, data[col++]);
  149. str_to_number(mob_table->Skills[4].dwVnum, data[col++]);
  151. str_to_number(mob_table->bBerserkPoint, data[col++]);
  152. str_to_number(mob_table->bStoneSkinPoint, data[col++]);
  153. str_to_number(mob_table->bGodSpeedPoint, data[col++]);
  154. str_to_number(mob_table->bDeathBlowPoint, data[col++]);
  155. str_to_number(mob_table->bRevivePoint, data[col++]);
  157. //LÂz^ vnum Aß°^
  158. vnumSet.insert(mob_table->dwVnum);
  161. //fprintf(stderr, "MOB #%d %s %s level: %u rank: %u empire: %d\n", mob_table->dwVnum, mob_table->szName, mob_table->szLocaleName, mob_table->bLevel, mob_table->bRank, mob_table->bEmpire);
  162. sys_log(0, "MOB #%-5d %-24s %-24s level: %-3u rank: %u empire: %d", mob_table->dwVnum, mob_table->szName, mob_table->szLocaleName, mob_table->bLevel, mob_table->bRank, mob_table->bEmpire);
  163. ++mob_table;
  164. }
  165. fprintf(stderr," Complete! %d/%d Mobs loaded.\r\n",size,vnumSet.size());
  166. sort(m_vec_mobTable.begin(), m_vec_mobTable.end(), FCompareVnum());
  167. return true;
  169. }
  171. tekrar arat;
  173. bool CClientManager::InitializeItemTable()
  175. fonksiyonu komple değiştir ve derle;
  177. bool CClientManager::InitializeItemTable()
  178. {
  179. char query[2048];
  180. fprintf(stderr,"Loading item_proto from MySQL");
  181. snprintf(query, sizeof(query),
  182. "SELECT vnum,name,%s,type,subtype,weight,size,antiflag,flag,wearflag,immuneflag+0,gold,shop_buy_price,refined_vnum,"
  183. "refine_set,magic_pct,limittype0,limitvalue0,limittype1,limitvalue1,applytype0,applyvalue0,"
  184. "applytype1,applyvalue1,applytype2,applyvalue2,value0,value1,value2,value3,value4,value5,socket_pct,addon_type FROM item_proto%s ORDER BY vnum",
  185. g_stLocaleNameColumn.c_str(),
  186. GetTablePostfix());
  188. std::unique_ptr<SQLMsg> pkMsg(CDBManager::instance().DirectQuery(query));
  189. SQLResult * pRes = pkMsg->Get();
  191. if (!pRes->uiNumRows)
  192. return false;
  193. int addNumber = pRes->uiNumRows;
  194. if (!m_vec_itemTable.empty())
  195. {
  196. sys_log(0, "RELOAD: item_proto");
  197. m_vec_itemTable.clear();
  198. m_map_itemTableByVnum.clear();
  199. }
  201. m_vec_itemTable.resize(addNumber-1);
  202. memset(&m_vec_itemTable[0], 0, sizeof(TItemTable) * m_vec_itemTable.size());
  203. TItemTable * item_table = &m_vec_itemTable[0];
  205. MYSQL_ROW data;
  206. //return true;
  207. set<int> vnumSet;
  208. while ((data = mysql_fetch_row(pRes->pSQLResult)))
  209. {
  210. str_to_number(item_table->dwVnum, data[0]);
  211. strlcpy(item_table->szName,data[1] , sizeof(item_table->szName));
  212. strlcpy(item_table->szLocaleName, data[2], sizeof(item_table->szLocaleName));
  213. str_to_number(item_table->bType, data[3]);
  214. str_to_number(item_table->bSubType, data[4]);
  215. str_to_number(item_table->bWeight, data[5]);
  216. str_to_number(item_table->bSize, data[6]);
  217. str_to_number(item_table->dwAntiFlags, data[7]);
  218. str_to_number(item_table->dwFlags, data[8]);
  219. str_to_number(item_table->dwWearFlags, data[9]);
  220. str_to_number(item_table->dwImmuneFlag, data[10]);
  221. str_to_number(item_table->dwGold, data[11]);
  222. str_to_number(item_table->dwShopBuyPrice, data[12]);
  223. str_to_number(item_table->dwRefinedVnum, data[13]);
  224. str_to_number(item_table->wRefineSet, data[14]);
  225. str_to_number(item_table->bAlterToMagicItemPct, data[15]);
  226. item_table->cLimitRealTimeFirstUseIndex = -1;
  227. item_table->cLimitTimerBasedOnWearIndex = -1;
  229. str_to_number(item_table->aLimits[0].bType, data[16]);
  230. str_to_number(item_table->aLimits[0].lValue, data[17]);
  231. if (LIMIT_REAL_TIME_START_FIRST_USE == item_table->aLimits[0].bType)
  232. item_table->cLimitRealTimeFirstUseIndex = (char)0;
  233. if (LIMIT_TIMER_BASED_ON_WEAR == item_table->aLimits[0].bType)
  234. item_table->cLimitTimerBasedOnWearIndex = (char)0;
  236. str_to_number(item_table->aLimits[1].bType, data[18]);
  237. str_to_number(item_table->aLimits[1].lValue, data[19]);
  238. if (LIMIT_REAL_TIME_START_FIRST_USE == item_table->aLimits[1].bType)
  239. item_table->cLimitRealTimeFirstUseIndex = (char)1;
  240. if (LIMIT_TIMER_BASED_ON_WEAR == item_table->aLimits[1].bType)
  241. item_table->cLimitTimerBasedOnWearIndex = (char)1;
  244. str_to_number(item_table->aApplies[0].bType, data[20]);
  245. str_to_number(item_table->aApplies[0].lValue, data[21]);
  247. str_to_number(item_table->aApplies[1].bType, data[22]);
  248. str_to_number(item_table->aApplies[1].lValue, data[23]);
  250. str_to_number(item_table->aApplies[2].bType, data[24]);
  251. str_to_number(item_table->aApplies[2].lValue, data[25]);
  254. str_to_number(item_table->alValues[0], data[26]);
  255. str_to_number(item_table->alValues[1], data[27]);
  256. str_to_number(item_table->alValues[2], data[28]);
  257. str_to_number(item_table->alValues[3], data[29]);
  258. str_to_number(item_table->alValues[4], data[30]);
  259. str_to_number(item_table->alValues[5], data[31]);
  261. str_to_number(item_table->bGainSocketPct, data[32]);
  262. str_to_number(item_table->sAddonType, data[33]);
  264. vnumSet.insert(item_table->dwVnum);
  265. m_map_itemTableByVnum.insert(std::map<DWORD, TItemTable *>::value_type(item_table->dwVnum, item_table));
  266. sys_log(0, "ITEM: #%-5lu %-24s %-24s VAL: %d %ld %d %d %d %d WEAR %d ANTI %d IMMUNE %d REFINE %lu REFINE_SET %u MAGIC_PCT %u",
  267. item_table->dwVnum,
  268. item_table->szName,
  269. item_table->szLocaleName,
  270. item_table->alValues[0],
  271. item_table->alValues[1],
  272. item_table->alValues[2],
  273. item_table->alValues[3],
  274. item_table->alValues[4],
  275. item_table->alValues[5],
  276. item_table->dwWearFlags,
  277. item_table->dwAntiFlags,
  278. item_table->dwImmuneFlag,
  279. item_table->dwRefinedVnum,
  280. item_table->wRefineSet,
  281. item_table->bAlterToMagicItemPct);
  283. item_table++;
  284. }
  285. fprintf(stderr," Complete! %d Items loaded.\r\n",addNumber);
  286. return true;
  288. }
  290. ## ERİC BLOODAXE ##