bool CDBProcess::LoadServerList()
{
	unique_ptr<OdbcCommand> dbCommand(m_dbConnection.CreateCommand());
	if (dbCommand.get() == nullptr)
		return false;

	if (!dbCommand->Execute(_T("SELECT * FROM SERVER_LIST")))
	{
		g_pMain->ReportSQLError(m_dbConnection.GetError());
		return false;
	}

	if(g_pMain->m_ServerList.GetSize() > 0)
		g_pMain->m_ServerList.DeleteAllData();

	if (dbCommand->hasData())
	{
		int nServerCount = 0;
		do
		{
			_SERVER_INFO* pInfo = new _SERVER_INFO();

			int i = 1;
			dbCommand->FetchInt16(i++, pInfo->sServerID);
			dbCommand->FetchInt16(i++, pInfo->sGroupID);
			dbCommand->FetchString(i++, pInfo->strServerName);
			dbCommand->FetchString(i++, pInfo->strServerIP);
			dbCommand->FetchString(i++, pInfo->strLanIP);
			dbCommand->FetchInt16(i++, pInfo->sPlayerCap);
			dbCommand->FetchInt16(i++, pInfo->sFreePlayerCap);
			dbCommand->FetchString(i++, pInfo->strKarusKingName);
			dbCommand->FetchString(i++, pInfo->strKarusNotice);
			dbCommand->FetchString(i++, pInfo->strElMoradKingName);
			dbCommand->FetchString(i++, pInfo->strElMoradNotice);		
			g_pMain->m_ServerList.PutData(pInfo->sServerID, pInfo);
			nServerCount++;

		} while (dbCommand->MoveNext());
	}

	return true;
}