Hello, im trying to script a roleplay engine system on SQLlite, but doesn't works.
Код:
CMD:Engine(playerid,ispassenger,params[])
{
if(GetPlayerState(playerid)==PLAYER_STATE_DRIVER)
{
new vehicleid = GetPlayerVehicleID(playerid);
new engine,lights,alarm,doors,bonnet,boot,objective;
GetVehicleParamsEx(vehicleid, engine,lights,alarm,doors,bonnet,boot,objective);
new name[MAX_PLAYER_NAME], string[24+MAX_PLAYER_NAME];
GetPlayerName(playerid, name, sizeof(name));
new DBResult:dbresult, szQuery[256];
format(szQuery, sizeof(szQuery), "SELECT * FROM Vehicles WHERE Username = '%s' ", DB_Escape(PlayerInfo[playerid][pUsername]));
dbresult = db_query(Database, szQuery);
if(!strcmp (name,VehicleInfo[playerid][vOwn])) // <<< --------- THIS IS THE PROBLEM
{
enginefunction(playerid);
// db_num_rows(dbresult) > 0
}
else
{
SendClientMessage(playerid,COLOR_GREY,"This isn't your vehicle!");
}
db_free_result(dbresult);
Код:
format(szQuery, sizeof(szQuery), "UPDATE Vehicles SET Username='%s' WHERE Usename='%s'", VehicleInfo[playerid][vOwn], DB_Escape(PlayerInfo[playerid][pUsername]));
db_free_result(db_query(Database, szQuery));