Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- new userVeh[MAX_PLAYERS] = 0;
- function LoadPVeh(playerid) {
- gQuery[0] = EOS;
- mysql_format(SQL, gQuery, sizeof(gQuery), "SELECT * FROM `player_vehs` WHERE `vOwnerSQL`='%d'", PlayerInfo[playerid][pID]);
- new Cache: db = mysql_query(SQL, gQuery);
- new x,result[256];
- for (new i, j = cache_num_rows(); i != j; ++i) {
- userVeh[playerid]++;
- // ints
- cache_get_value_name_int(i, "vID", VehicleInfo[x][vID]);
- cache_get_value_name_int(i, "vOwnerSQL", VehicleInfo[x][vOwnerSQL]);
- cache_get_value_name_int(i, "vModel", VehicleInfo[x][vModel]);
- cache_get_value_name_int(i, "vColor1", VehicleInfo[x][vColor1]);
- cache_get_value_name_int(i, "vColor2", VehicleInfo[x][vColor2]);
- // vars
- cache_get_value_name(i, "vOwnerName", result); format(VehicleInfo[x][vOwnerName], MAX_PLAYER_NAME, result);
- cache_get_value_name(i, "vPlate", result); format(VehicleInfo[x][vPlate], 18, result);
- // floats
- cache_get_value_name_float(i, "vPosX", VehicleInfo[x][vPosX]);
- cache_get_value_name_float(i, "vPosY", VehicleInfo[x][vPosY]);
- cache_get_value_name_float(i, "vPosZ", VehicleInfo[x][vPosZ]);
- cache_get_value_name_float(i, "vPosA", VehicleInfo[x][vPosA]);
- CreateVehicle(VehicleInfo[x][vModel], VehicleInfo[x][vPosX], VehicleInfo[x][vPosY], VehicleInfo[x][vPosZ], VehicleInfo[x][vPosA], VehicleInfo[x][vColor1], VehicleInfo[x][vColor2], -1);
- SetVehicleToRespawn(VehicleInfo[x][vID]);
- SetVehicleNumberPlate(VehicleInfo[x][vID], VehicleInfo[x][vPlate]);
- }
- printf("[MySQL] P-Vehs for %s: %d.", GetName(playerid), userVeh[playerid]);
- cache_delete(db);
- return 1;
- }
- public OnPlayerSpawn(playerid) {
- LoadPVeh(playerid);
- return 1;
- }
- CMD:givecar(playerid, params[]) {
- if(PlayerInfo[playerid][pAdmin] <= 4) return StaffOnly(playerid, 5);
- new target, model;
- if(sscanf(params, "ui", target, model)) return Usage(playerid, "/givecar <playername> <model>");
- gString[0] = EOS;
- format(gString, sizeof(gString), "Admin %s[%d] gave to %s[%d] car model: %d.", GetName(playerid), playerid, GetName(target), target, model);
- SendAdminMessage(COLOR_ORANGE, gString, 1);
- SCMx(playerid, -1, "Admin %s[%d] gave you car model:%d.",GetName(playerid), playerid, model);
- gQuery[0] = EOS;
- mysql_format(SQL, gQuery, sizeof(gQuery), "INSERT INTO `player_vehs` (`vOwnerSQL`,`vOwnerName`,`vModel`) VALUES ('%d','%s','%d')", PlayerInfo[target][pID], GetName(target), model);
- mysql_query(SQL, gQuery);
- return 1;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement