13.11.2015, 12:09
Hello, im trying to script a roleplay engine system on SQLlite, but doesn't works.
here's the code
The VehicleInfo[playerid][vOwn] equals to the name of the owner
here's the code
Код:
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));