[C++]Mysql_select quest function

[Randomize 17]

Hello!

I try to make a quest function for mysql_select, but I don't know how can I get the SELECT Query's result and bring it to the quest. Anyone can help?

[Denis 1627]

Take a look at this example:

std::auto_ptr<SQLMsg> msg(DBManager::instance().DirectQuery("SELECT coins FROM account.account WHERE id = 1"));

if (msg->Get()->uiNumRows == 0)
{
	return 0;
}

int coins = 0;

MYSQL_ROW row = mysql_fetch_row(msg->Get()->pSQLResult);
str_to_number(coins, row[0]);

[Ken 1034]

 

Take a look at this example:

std::auto_ptr<SQLMsg> msg(DBManager::instance().DirectQuery("SELECT coins FROM account.account WHERE id = 1"));

if (msg->Get()->uiNumRows == 0)
{
	return 0;
}

int coins = 0;

MYSQL_ROW row = mysql_fetch_row(msg->Get()->pSQLResult);
str_to_number(coins, row[0]);

char szQuery[512];
snprintf(szQuery,sizeof(szQuery),"SELECT coins FROM account WHERE id = %u",ch->GetAID());
std::auto_ptr<SQLMsg> pMsg(CDBManager::instance().DirectQuery(szQuery,SQL_ACCOUNT));

if(pMsg->Get()->uiNumRows > 0)
{
	int iCoins = 0;
	MYSQL_ROW row = mysql_fetch_row(pMsg->Get()->pSQLResult);
	str_to_number(iCoins,row[0]);
}

Kind Regards

Zerelth ~ Ellie

[Denis 1627]

 

 

Take a look at this example:

std::auto_ptr<SQLMsg> msg(DBManager::instance().DirectQuery("SELECT coins FROM account.account WHERE id = 1"));

if (msg->Get()->uiNumRows == 0)
{
	return 0;
}

int coins = 0;

MYSQL_ROW row = mysql_fetch_row(msg->Get()->pSQLResult);
str_to_number(coins, row[0]);

char szQuery[512];
snprintf(szQuery,sizeof(szQuery),"SELECT coins FROM account WHERE id = %u",ch->GetAID());
std::auto_ptr<SQLMsg> pMsg(CDBManager::instance().DirectQuery(szQuery,SQL_ACCOUNT));

if(pMsg->Get()->uiNumRows > 0)
{
	int iCoins = 0;
	MYSQL_ROW row = mysql_fetch_row(pMsg->Get()->pSQLResult);
	str_to_number(iCoins,row[0]);
}

Kind Regards

Zerelth ~ Ellie

 

 

Your point?

[Ken 1034]

 

 

 

Take a look at this example:

std::auto_ptr<SQLMsg> msg(DBManager::instance().DirectQuery("SELECT coins FROM account.account WHERE id = 1"));

if (msg->Get()->uiNumRows == 0)
{
	return 0;
}

int coins = 0;

MYSQL_ROW row = mysql_fetch_row(msg->Get()->pSQLResult);
str_to_number(coins, row[0]);

char szQuery[512];
snprintf(szQuery,sizeof(szQuery),"SELECT coins FROM account WHERE id = %u",ch->GetAID());
std::auto_ptr<SQLMsg> pMsg(CDBManager::instance().DirectQuery(szQuery,SQL_ACCOUNT));

if(pMsg->Get()->uiNumRows > 0)
{
	int iCoins = 0;
	MYSQL_ROW row = mysql_fetch_row(pMsg->Get()->pSQLResult);
	str_to_number(iCoins,row[0]);
}

Kind Regards

Zerelth ~ Ellie

 

 

Your point?

 

 

Second way

[Randomize 17]

This returns only numbers, but I need it as an array so I can print it in quest like query[row][field]
I want one built-in function like it was in LUA. Is it possible?

[Sanchez 2975]

Sure It's possible.

// Get the current character
LPCHARACTER ch = CQuestManager::instance().GetCurrentCharacterPtr();

// Something wen't wrong, character does not exist
if (!ch)
{
	// Push back -1 to the quest, which means there was an error
	lua_pushnumber(L, -1);
	return 1;
}

// Character don't have desc
if (!ch->GetDesc())
{
	// Push back -1 to the quest, which means there was an error
	lua_pushnumber(L, -1);
	return 1;
}

// Execute the query
std::auto_ptr<SQLMsg> msg(DBManager::instance().DirectQuery("SELECT something FROM account.account WHERE id = %lu", ch->GetDesc()->GetAccountTable().id));

// Something was wrong with the query
if (msg->Get()->uiNumRows <= 0 || msg->uiSQLErrno != 0)
{
	// Push back -1 to the quest, which means there was an error
	lua_pushnumber(L, -1);
	return 1;
}

// Create a new lua table
lua_newtable(L);

// Row will contains the current line of data
MYSQL_ROW row;

// Lua indexing starts from 1, so the first index of the array should be 1
int idx   = 1;
// value contains the data of current field
int value = 0;
// While we have available data
while ((row = mysql_fetch_row(msg->Get()->pSQLResult)))
{
	if (!row[0])
		continue;

	// Push the index to the table
	lua_pushnumber(L, idx);
	// Convert the data of the field to number
	str_to_number(value, row[0]);
	// Push the data to the table
	lua_pushnumber(L, value);
	// We are pushing back a one dimensional array, so set the index of the table to -3
	lua_settable(L, -3);
	// Add +1 to the index
	idx++;
}

return 1;

[Randomize 17]

Thank you Sanchez, I'll try it soon.