MySQL query passing problem.
#1

Why the correct values (for example PaskutinisIsemimas - 2012-05-11 01:54:23) not being shown, but %e instead? And because of that the row I want to update is not being updated.

pawn Код:
mysql_format(Handle, saveData, "UPDATE `zaidejai` SET `SukurimoData` = '%e', `PaskutinisIsemimas` = '%e', `IsvisoPadeta` = '%d', `LygioTaskai` = '%d' WHERE `Vardas` = '%e'", pInfo[playerid][statsRegistrationDate], pInfo[playerid][statsLastWithdrawDate], pInfo[playerid][statsTotalMoneyInBank], pInfo[playerid][statsLevelPoints], GetPlayerNameEx(playerid));
    mysql_function_query(Handle, saveData, false, "", "");
Quote:

[01:51:17] ProcessQueryThread() - Query was successful. (UPDATE `zaidejai` SET `SukurimoData` = '%e', `PaskutinisIsemimas` = '%e', `IsvisoPadeta` = '0', `LygioTaskai` = '110' WHERE `Vardas` = '%e')
[01:51:17] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()

In other queries, its okay. (code is totally the same)

Quote:
Quote:

[01:51:17] ProcessQueryThread() - Query was successful. (UPDATE `zaidejai` SET `Slaptazodis` = 'x', `Email` = 'dafuqtest@inbox.lt' <...>

Reply


Messages In This Thread
MySQL query passing problem. - by BaubaS - 10.05.2013, 22:56
Re: MySQL query passing problem. - by Vince - 10.05.2013, 23:16
Re: MySQL query passing problem. - by BaubaS - 10.05.2013, 23:22
Re: MySQL query passing problem. - by BaubaS - 10.05.2013, 23:39
Re: MySQL query passing problem. - by BaubaS - 11.05.2013, 07:46

Forum Jump:


Users browsing this thread: 1 Guest(s)