Select value in DB c++

[EnKor 42]

How to make it right?

Any help please.

 

Spoiler

total = DBManager::Instance().Query("SELECT infernus FROM player.player WHERE name='%s'", GetName());
	
	if (total >= 3 ){
		ChatPacket(CHAT_TYPE_INFO,"linha de teste");
	}

 

[ridetpro 116]

std::unique_ptr<SQLMsg> pSelectMsg(DBManager::instance().DirectQuery("SELECT infernus FROM player.player WHERE name='%s'", GetName());
BYTE count = pSelectMsg->Get()->uiNumRows;

if (count >= 3)
	ChatPacket(CHAT_TYPE_INFO,"Total count is %d", count);

 

[EnKor 42]

1 hour ago, ridetpro said:

std::unique_ptr<SQLMsg> pSelectMsg(DBManager::instance().DirectQuery("SELECT infernus FROM player.player WHERE name='%s'", GetName());
BYTE count = pSelectMsg->Get()->uiNumRows;

if (count >= 3)
	ChatPacket(CHAT_TYPE_INFO,"Total count is %d", count);

 

That way, count is allways "1"   

 

that way do not get invernus table value

[ridetpro 116]

char szQuery[QUERY_MAX_LEN];
snprintf(szQuery, sizeof(szQuery), "SELECT infernus FROM player.player WHERE name='%s'", GetName());
std::unique_ptr<SQLMsg> pSelectMsg(DBManager::instance().DirectQuery(szQuery);

SQLResult* pRes = pSelectMsg->Get();
	
if (pRes->uiNumRows > 0)
{
	MYSQL_ROW row = mysql_fetch_row(pRes->pSQLResult);
		
	DWORD GetVal = 0;
	str_to_number(GetVal, row[0]);

	ch->ChatPacket(CHAT_TYPE_INFO, LC_TEXT("Total count is %d"), GetVal);
}

It should work now. 

[EnKor 42]

5* Perfect. Ty!

[EnKor 42]

Solved