Dr.Deft
Ученик
Из названия темы думаю понятно в чем проблема.
Это пишет в логах MySQL
А это код сохранения
При mysql_log(LOG_ALL); в консоли сервера ошибок нет.
---------- Post added at 21:06 ---------- Previous post was at 20:03 ----------
Решено.
Это пишет в логах MySQL
PHP:
[17:25:24] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `atm` SET `owner` = '19', `int` = '0', `pos` = '0.000000|", callback: "(null)", format: "(null)"
[17:25:24] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `atm` SET `owner` = '21', `int` = '0', `pos` = '1055.7285", callback: "(null)", format: "(null)"
[17:25:24] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `atm` SET `owner` = '19', `int` = '0', `pos` = '-2046.097", callback: "(null)", format: "(null)"
[17:25:24] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `atm` SET `owner` = '19', `int` = '0', `pos` = '491.65213", callback: "(null)", format: "(null)"
[17:25:24] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `atm` SET `owner` = '19', `int` = '0', `pos` = '1548.4997", callback: "(null)", format: "(null)"
[17:25:24] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `atm` SET `owner` = '19', `int` = '0', `pos` = '1172.4459", callback: "(null)", format: "(null)"
[17:25:24] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[17:25:24] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `atm` SET `owner` = '19', `int` = '0', `pos` = '469.95980", callback: "(null)", format: "(null)"
[17:25:24] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `atm` SET `owner` = '19', `int` = '0', `pos` = '1350.2935", callback: "(null)", format: "(null)"
[17:25:24] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 3.961 milliseconds
[17:25:24] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[17:25:24] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[17:25:24] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 2.138 milliseconds
[17:25:24] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[17:25:24] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[17:25:24] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 1.737 milliseconds
[17:25:24] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[17:25:24] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[17:25:24] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 3.498 milliseconds
[17:25:24] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[17:25:24] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[17:25:24] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 2.116 milliseconds
[17:25:24] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[17:25:24] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[17:25:24] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 1.556 milliseconds
[17:25:24] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[17:25:24] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[17:25:24] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 1.618 milliseconds
[17:25:24] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[17:25:24] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[17:25:24] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 2.942 milliseconds
[17:25:24] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
PHP:
stock SaveATM()
{
new query[512], to_query[512];
for(new i = 0; i < MAX_ATM; i++)
{
echo(query, "UPDATE `atm` SET ");
echo(to_query,
"`owner` = '%d', \
`int` = '%d', \
`pos` = '%f|%f|%f', \
`rpos` = '%f|%f|%f' \
WHERE `id` = '%d' LIMIT 1",
ATMINFO[i][OWNER],
ATMINFO[i][INT],
ATMINFO[i][aPos][0],
ATMINFO[i][aPos][1],
ATMINFO[i][aPos][2],
ATMINFO[i][aRPos][0],
ATMINFO[i][aRPos][1],
ATMINFO[i][aRPos][2],
ATMINFO[i][MYSQL_ID]);
strcat(query, to_query);
mysql_function_query(dbHandle, query, false, "", "");
}
print("Банкоматы сохранены");
return 1;
}
При mysql_log(LOG_ALL); в консоли сервера ошибок нет.
---------- Post added at 21:06 ---------- Previous post was at 20:03 ----------
Решено.
