mirror of
https://github.com/therealKyp/Earth-and-Beyond-server
synced 2026-08-13 22:23:03 -04:00
94 lines
2 KiB
C++
94 lines
2 KiB
C++
// AssetDatabaseSQL.cpp
|
|
|
|
#include "Net7.h"
|
|
|
|
#ifdef USE_MYSQL_SECTOR
|
|
|
|
#include "AssetDatabase.h"
|
|
#include "mysql/mysqlplus.h"
|
|
#include "StringManager.h"
|
|
|
|
|
|
AssetContent::AssetContent()
|
|
{
|
|
m_highest_id = 0;
|
|
m_Asset.clear();
|
|
}
|
|
|
|
AssetContent::~AssetContent()
|
|
{
|
|
m_Asset.clear();
|
|
}
|
|
|
|
bool AssetContent::LoadAssetContent()
|
|
{
|
|
long current_asset_id;
|
|
AssetData *current_asset;
|
|
char QueryString[1024];
|
|
|
|
if(!g_MySQL_User || !g_MySQL_Pass)
|
|
{
|
|
printf("You need to set a mysql user/pass in the net7.cfg\n");
|
|
return false;
|
|
}
|
|
|
|
sql_connection_c connection( "net7", g_MySQL_Host, g_MySQL_User, g_MySQL_Pass);
|
|
sql_query_c AssetTable( &connection );
|
|
sql_result_c result;
|
|
sql_result_c *asset_result = &result;
|
|
|
|
sprintf(QueryString, "SELECT * FROM `assets`");
|
|
|
|
if ( !AssetTable.execute( QueryString ) )
|
|
{
|
|
LogMessage( "MySQL Login error/Database error: (User: %s Pass: %s)\n", g_MySQL_User, g_MySQL_Pass );
|
|
return false;
|
|
}
|
|
|
|
AssetTable.store(asset_result);
|
|
|
|
if (!asset_result->n_rows() || !asset_result->n_fields())
|
|
{
|
|
LogMessage("Error loading rows/fields\n");
|
|
return false;
|
|
}
|
|
|
|
LogMessage("Loading Assets from SQL (%d)\n", (int)asset_result->n_rows());
|
|
|
|
sql_row_c AssetSQLData;
|
|
for(unsigned int x=0;x<asset_result->n_rows();x++)
|
|
{
|
|
asset_result->fetch_row(&AssetSQLData);
|
|
current_asset_id = (long)AssetSQLData["base_id"];
|
|
const char *name = AssetSQLData["descr"];
|
|
|
|
if (stricmp(name, "NULL") != 0)
|
|
{
|
|
current_asset = new AssetData;
|
|
|
|
current_asset->m_Name = g_StringMgr->GetStr(name);
|
|
current_asset->m_CatName = g_StringMgr->GetStr(AssetSQLData["main_cat"]);
|
|
current_asset->m_SubCatName = g_StringMgr->GetStr(AssetSQLData["sub_cat"]);
|
|
|
|
m_Asset[current_asset_id] = current_asset; //add to asset map
|
|
|
|
if (current_asset_id > m_highest_id)
|
|
{
|
|
m_highest_id = current_asset_id;
|
|
}
|
|
}
|
|
}
|
|
return true;
|
|
}
|
|
|
|
AssetData * AssetContent::GetAssetData(long asset_id)
|
|
{
|
|
return (m_Asset[asset_id]);
|
|
}
|
|
|
|
long AssetContent::GetAssetCount()
|
|
{
|
|
return (m_highest_id);
|
|
}
|
|
|
|
#endif
|