// *************************************************************** // Function: ItemDefDatabaseLoading.cpp // *************************************************************** #include "ItemDefManager.h" #include #include "Item.h" //************************************ // Name: LoadArmorSets // // Load all the armor set definitions from the database. // // Parameters: // // Return: // 0 - no errors // -1 - errors //************************************ int ItemDefManager::LoadArmorSets() { char query[95]; sprintf(query, "SELECT Name, Profession, Head, Chest, Arms, Legs, Feet, AdditionalMods FROM sd_armor_sets"); unsigned long qid=gDatabase.Query(query, (long)strlen(query)); QUERY_RESULT *pResult=NULL; while ((pResult=gDatabase.StealResult(qid))==NULL) { gDatabase.Update(); } if (pResult->pResult==NULL) { return -1; } int num_records=(int)mysql_num_rows(pResult->pResult); for (int i=0; ipResult); strcpy(a.name, row[0]); a.profession=atoi(row[1]); strcpy(a.head, row[2]); strcpy(a.chest, row[3]); strcpy(a.arms, row[4]); strcpy(a.legs, row[5]); strcpy(a.feet, row[6]); strcpy(a.addMods, row[7]); armorSets.push_back(a); } gCoreLog.notice("Loaded: %d armor sets.", num_records); gDatabase.FreeResult(qid); return 0; } //************************************ // Name: LoadItems // // Load all the item definitions in the database. // // Parameters: // // Return: // 0 - no errors // -1 - errors //************************************ int ItemDefManager::LoadItems() { ostringstream q; q << "SELECT Name, ItemIdName, Profession, GraphicalOptions, UpgradeComponent, Color, UnknownBlock1, "; q << "UnknownBlock2, UnknownBlock3, Uniqueness, UnknownBlock4, Rarity, UnknownBlock5, UnknownBlock6, "; q << "UnknownBlock7, UnknownBlock8, UnknownBlock9, UnknownBlock10, UnknownBlock11, UnknownBlock12, "; q << "UnknownBlock13, Quantity, ItemNameID, mods FROM sd_item_templates" << ends; unsigned long qid=gDatabase.Query((char*)q.str().c_str(), (long)strlen(q.str().c_str())); QUERY_RESULT *pResult=NULL; while ((pResult=gDatabase.StealResult(qid))==NULL) { gDatabase.Update(); } if (pResult->pResult==NULL) { return -1; } int num_records=(int)mysql_num_rows(pResult->pResult); for (int i=0; ipResult); strcpy(item_def.name, row[0]); strcpy(item_def.itemIdName, row[1]); item_def.profession=atoi(row[2]); memcpy(item_def.graphOpt, row[3], 4); memcpy(item_def.upgradeComp, row[4], 2); memcpy(item_def.color, row[5], 6); memcpy(item_def.u1, row[6], 2); memcpy(item_def.u2, row[7], 2); memcpy(item_def.u3, row[8], 2); memcpy(item_def.uniqueness, row[9], 2); memcpy(item_def.u4, row[10], 2); memcpy(item_def.rarity, row[11], 2); memcpy(item_def.u5, row[12], 2); memcpy(item_def.u6, row[13], 2); memcpy(item_def.u7, row[14], 2); memcpy(item_def.u8, row[15], 2); memcpy(item_def.u9, row[16], 2); memcpy(item_def.u10, row[17], 2); memcpy(item_def.u11, row[18], 2); memcpy(item_def.u12, row[19], 2); memcpy(item_def.u13, row[20], 2); item_def.quantity=atoi(row[21]); strcpy(item_def.itemNameId, row[22]); strcpy(item_def.mods, row[23]); itemDefs.push_back(item_def); } gCoreLog.notice("Loaded: %d item definitions.", num_records); gDatabase.FreeResult(qid); return 0; } //************************************ // Name: LoadMods // // Load all the item mods from the database. // // Parameters: // // Return: // 0 - no errors // -1 - errors //************************************ int ItemDefManager::LoadMods() { char query[38]; sprintf(query, "SELECT Name, ID FROM sd_item_mods"); unsigned long qid=gDatabase.Query(query, (long)strlen(query)); QUERY_RESULT *pResult=NULL; while ((pResult=gDatabase.StealResult(qid))==NULL) { gDatabase.Update(); } if (pResult->pResult==NULL) { return -1; } int num_records=(int)mysql_num_rows(pResult->pResult); for (int i=0; ipResult); strcpy(m.name, row[0]); memcpy(m.id, row[1], 4); mods.push_back(m); } gCoreLog.notice("Loaded: %d item mods.", num_records); gDatabase.FreeResult(qid); return 0; } //************************************ // Name: LoadItemIds // // Load all the item ids from the database. // // Parameters: // // Return: // 0 - no errors // -1 - errors //************************************ int ItemDefManager::LoadItemIds() { char query[50]; sprintf(query, "SELECT Name, Profession, ID FROM sd_item_ids"); unsigned long qid=gDatabase.Query(query, (long)strlen(query)); QUERY_RESULT *pResult=NULL; while ((pResult=gDatabase.StealResult(qid))==NULL) { gDatabase.Update(); } if (pResult->pResult==NULL) { return -1; } int num_records=(int)mysql_num_rows(pResult->pResult); for (int i=0; ipResult); strcpy(m.name, row[0]); m.profession=atoi(row[1]); memcpy(m.id, row[2], 4); itemIds.push_back(m); } gCoreLog.notice("Loaded: %d item ID's.", num_records); gDatabase.FreeResult(qid); return 0; } //************************************ // Name: LoadNames // // Load all the item name ids from the database. // // Parameters: // // Return: // 0 - no errors // -1 - errors //************************************ int ItemDefManager::LoadNames() { //Load all name id's from the database char query[45]; sprintf(query, "SELECT Name, ID FROM sd_item_name_ids"); unsigned long qid=gDatabase.Query(query, (long)strlen(query)); QUERY_RESULT *pResult=NULL; while ((pResult=gDatabase.StealResult(qid))==NULL) { gDatabase.Update(); } if (pResult->pResult==NULL) { return -1; } int num_records=(int)mysql_num_rows(pResult->pResult); for (int i=0; ipResult); strcpy(n.name, row[0]); strcpy(n.id, row[1]); n.idLength=(int)(strlen(n.id)/2); names.push_back(n); } gCoreLog.notice("Loaded: %d Name ID's.", num_records); gDatabase.FreeResult(qid); return 0; }