(error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '` = 0, `GarageOwner` = '-', `GaragePosX` = 248.198, `GaragePosY` = -1361.403, `G' at line 1
new query[2024]; mysql_format(g_iHandle, query, sizeof(query), "INSERT INTO `garages` SET hID` = %d, `GarageOwner` = '%s', `GaragePosX` = %f, `GaragePosY` = %f, `GaragePosZ` = %f, `GaragePosA` = %f, `GarageIntX` = %f,`GarageIntY` = %f, `GarageIntZ` = %f, `GarageIntA` = %f, `VirtualWorld` = %d, `Interior` = %d, `Status` = %d, `ForSale` = %d, `Price` = %d WHERE `gID`=%d", GarageInfo[id][hID], GarageInfo[id][GarageOwner], GarageInfo[id][ExtX], GarageInfo[id][ExtY], GarageInfo[id][ExtZ], GarageInfo[id][ExtA], GarageInfo[id][IntX], GarageInfo[id][IntY], GarageInfo[id][IntZ], GarageInfo[id][IntA], GarageInfo[id][vWorld], GarageInfo[id][IntID], GarageInfo[id][Status], GarageInfo[id][ForSale], GarageInfo[id][Price], id); mysql_tquery(g_iHandle, query, "OnGarageCreated", "i", id);
mysql_format(g_iHandle, query, sizeof(query), "INSERT INTO `garages` SET `hID` = %d, `GarageOwner` = '%s', `GaragePosX` = %f, `GaragePosY` = %f, `GaragePosZ` = %f, `GaragePosA` = %f, `GarageIntX` = %f,`GarageIntY` = %f, `GarageIntZ` = %f, `GarageIntA` = %f, `VirtualWorld` = %d, `Interior` = %d, `Status` = %d, `ForSale` = %d, `Price` = %d WHERE `gID`=%d",
GarageInfo[id][hID],
Wrong statement.
it should be 'INSERT INTO table_name (fields, ...) VALUES(field_values, ...)' |
(error #1054) Unknown column '%d' in 'field list'
mysql_tquery(g_iHandle, "INSERT INTO `garages` (`gID`) VALUES(`%d`)", "OnGarageCreated", "d", id);
mysql_format(g_iHandle, query, sizeof query, "INSERT INTO `garages` (`gID`) VALUES(%d)", id);
mysql_tquery(g_iHandle, query, "OnGarageCreated", "d", id);
well you are not passing any value for %d.
PHP код:
|
(error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''’$' at line 1
mysql_tquery(g_iHandle, "INSERT INTO `garages` (`ForSale`) VALUES(1)", "OnGarageCreated", "d", id);
public OnGarageCreated(gID) { GarageInfo[gID][GID] = cache_insert_id(g_iHandle); Garage_Save(gID); return 1; }
Garage_Save(gID) { static query[2048]; format(query,sizeof(query), "UPDATE `garages` SET `hID` = %d, `GarageOwner` = '%s', `GaragePosX` = %f, `GaragePosY` = %f, `GaragePosZ` = %f, `GaragePosA` = %f, `GarageIntX` = %f,`GarageIntY` = %f, `GarageIntZ` = %f, `GarageIntA` = %f, `VirtualWorld` = %d, `Interior` = %d, `Status` = %d, `ForSale` = %d, `Price` = %d WHERE `gID` = %d", GarageInfo[gID][GarageOwner], GarageInfo[gID][ExtX], GarageInfo[gID][ExtY], GarageInfo[gID][ExtZ], GarageInfo[gID][ExtA], GarageInfo[gID][IntX], GarageInfo[gID][IntY], GarageInfo[gID][IntZ], GarageInfo[gID][IntA], GarageInfo[gID][vWorld], GarageInfo[gID][IntID], GarageInfo[gID][Status], GarageInfo[gID][ForSale], GarageInfo[gID][Price], gID ); return mysql_tquery(g_iHandle, query); }
(error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''Nc' at line 1
Garage_Save(gID)
{
static
query[2048];
format(query,sizeof(query), "UPDATE `garages` SET `hID` = %d, `GarageOwner` = '%s', `GaragePosX` = %f, `GaragePosY` = %f, `GaragePosZ` = %f, `GaragePosA` = %f, `GarageIntX` = %f,`GarageIntY` = %f, `GarageIntZ` = %f, `GarageIntA` = %f, `VirtualWorld` = %d, `Interior` = %d, `Status` = %d, `ForSale` = %d, `Price` = %d WHERE `gID` = %d",
GarageInfo[gID][GarageOwner],
GarageInfo[gID][ExtX],
GarageInfo[gID][ExtY],
GarageInfo[gID][ExtZ],
GarageInfo[gID][ExtA],
GarageInfo[gID][IntX],
GarageInfo[gID][IntY],
GarageInfo[gID][IntZ],
GarageInfo[gID][IntA],
GarageInfo[gID][vWorld],
GarageInfo[gID][IntID],
GarageInfo[gID][Status],
GarageInfo[gID][ForSale],
GarageInfo[gID][Price],
GarageInfo[gID][GID]
);
return mysql_tquery(g_iHandle, query);
}