06.02.2017, 21:33
Приветствую.
Проблема в запросе
Ошибка:
Отправка запроса в функции оплаты дома:
Сам сток TransferMoney
Проблема в запросе
PHP Code:
format(mysql_query_string, 1000, "INSERT INTO `log_transfer`(`Name`, `Cash`, `Remain`, `Money`, `Action`, `Date`) VALUES ('%s','%d','%d','%d','%s','%02d/%02d/%d â %02d:%02d:%02d')",NamePlayer[playerid],p_info[playerid][pCash],remain,money,action,datatime[0],datatime[1],datatime[2],datatime[3],datatime[4],datatime[5]);
mysql_pquery(connects, mysql_query_string);
PHP Code:
[plugins/mysql] error #2013 while executing query "INSERT INTO `log_transfer`(`Name`, `Cash`, `Remain`, `Money`, `Action`, `Date`) VALUES ('Patrick_Brawo','5915785','5913985','1800','оплатил дом','2017/02/7 в 06:15:09')": Lost connection to MySQL server during query
PHP Code:
TransferMoney(playerid,p_info[playerid][pCash]-oplata,oplata,"оплатил дом");
PHP Code:
stock TransferMoney(playerid,remain,money,action[])
{
/*SendClientMessage(playerid,(p_info[playerid][pCash] > remain) ? (CRED) : (CGREEN),
(p_info[playerid][pCash] > remain) ? ("-") : ("+"));*/
r_getdate(datatime[0], datatime[1], datatime[2]);
r_gettime(datatime[3], datatime[4], datatime[5]);
mysql_query_string[0] = EOS;
format(mysql_query_string, 1000, "INSERT INTO `log_transfer`(`Name`, `Cash`, `Remain`, `Money`, `Action`, `Date`) VALUES ('%s','%d','%d','%d','%s','%02d/%02d/%d в %02d:%02d:%02d')",NamePlayer[playerid],p_info[playerid][pCash],remain,money,action,datatime[0],datatime[1],datatime[2],datatime[3],datatime[4],datatime[5]);
mysql_pquery(connects, mysql_query_string);
return 1;
}