24.12.2013, 10:38
Instead of making a new topic for the same system I'll post my trouble here...
I'm trying to set the plate with the SQLid of the vehicle, I got this 2 queries:
And it works, after that, I do:
But it return 0 rows IG, while if I do the same code, copied by the print on console, on Phpmyadmin it will show the car...
What can I do?
I'm trying to set the plate with the SQLid of the vehicle, I got this 2 queries:
pawn Код:
//Called on the command to create the Vehicle
format(query, sizeof(query), "INSERT INTO car(Owner, Model, Price, Col1, Col2, cLock, cX, cY, cZ, cA, tID) VALUES ('%s', '%d', '%d', '%d', '%d', '%d', '%f', '%f', '%f', '%f', '%d')",
RUS(playerid), //Name w/out '_'
model,
price,
Car[id][cCol1],
Car[id][cCol2],
Car[id][cLock],
Car[id][cX],
Car[id][cY],
Car[id][cZ],
Car[id][cA],
id);
print(query); // DEBUG
mysql_function_query(connection, query, false, "", "");
pawn Код:
//Called when you press ENTER while chosing the colors of vehicle
new query[1024];
format(query, sizeof(query), "SELECT * FROM car WHERE tID = '%s' LIMIT 1", GetPlayerVehicleID(playerid));
mysql_function_query(connection, query, true, "SetPlate", "dd", playerid, GetPlayerVehicleID(playerid));
What can I do?