[danielpalade]

So, whenever I try and join my server I get this mysql popup with an error.
I check mysql.log and I see this.

Код:

[21:15:52] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`0', name = '' WHERE carID = '218'' at line 1
[21:15:52] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`0', name = '' WHERE carID = '219'' at line 1
[21:15:52] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`0', name = '' WHERE carID = '220'' at line 1
[21:15:52] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`0', name = '' WHERE carID = '221'' at line 1
[21:15:52] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`0', name = '' WHERE carID = '222'' at line 1
[21:15:52] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`0', name = '' WHERE carID = '223'' at line 1
[21:15:52] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`0', name = '' WHERE carID = '224'' at line 1
[21:15:52] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`0', name = '' WHERE carID = '225'' at line 1
[21:15:53] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`0', name = '' WHERE carID = '226'' at line 1
[21:15:53] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`0', name = '' WHERE carID = '227'' at line 1
[21:15:53] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`0', name = '' WHERE carID = '228'' at line 1
[21:15:53] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`0', name = '' WHERE carID = '229'' at line 1

So I checked:

Код:

stock saveDealer(const id)
{
	format(szLargeString, sizeof(szLargeString), "UPDATE dealer SET stock = '%d', price = '%d', Pprice = `%d', name = '%s' WHERE carID= '%d'", vehSlots[id],vehPrice[id],vehPprice[id],vehName[id],id);
	mysql_tquery(handle,szLargeString);
	return 1;
}

But I couldn't find the error. Can you guys help me?

[zPain]

Here:

Код:

Pprice = `%d'