[iPhone5]

So i created this marketplace script where you do /marketplace and shows vehicles that players want to sell. When i create vehicle in the db for me to sell it gives me but when i try to find it on the map it's not there and i put coords. When i try to spawn the ID it does not come to me it says it doesn't exist

[Pottus]

Post your code.

[iPhone5]

Код:

stock AddPlayerVehicles()
{
	new Str[750], vTotal, vehID, vehModel, Float:vehX, Float:vehY, Float:vehZ, Float:vehA, vehC1, vehC2, vehOwnedBy[24], ForSale, DefaultPrice, Price, Locked;
	new carmod[17];
	mysql_reconnect();
	mysql_query("SELECT * FROM `pvehicles`");
	mysql_store_result();
	vTotal = mysql_num_rows();
	new carid = 0;
	if(vTotal > 0)
	{
	    while(mysql_fetch_row(Str))
	    {
	        sscanf(Str, "p<|>dds[24]ffffddddddddddddddddddddddd",
			vehID,vehModel,vehOwnedBy,vehX,vehY,vehZ,vehA,vehC1,vehC2,ForSale,DefaultPrice,Price,Locked,carmod[0],carmod[1],carmod[2],carmod[3],carmod[4],carmod[5],carmod[6],carmod[7],carmod[8],carmod[9],carmod[10],carmod[11],carmod[12],carmod[13],carmod[14],carmod[15],carmod[16]);
   			carid=vehID;
	        new carid2 = CreateVehicle(vehModel, vehX, vehY, vehZ, vehA, vehC1, vehC2, (30 * 60));
			PVInfo[carid][vpID] = vehID;
			PVInfo[carid][vpPosX] = vehX;
			PVInfo[carid][vpPosY] = vehY;
			PVInfo[carid][vpPosZ] = vehZ;
			PVInfo[carid][vpPosA] = vehA;
			PVInfo[carid][vpColor1] = vehC1;
			PVInfo[carid][vpColor2] = vehC2;
			PVInfo[carid][vpModel] = vehModel;
			PVInfo[carid][vpForSale] = ForSale;
			PVInfo[carid][vpDefaultPrice] = DefaultPrice;
			PVInfo[carid][vpPrice] = Price;
			PVInfo[carid][vpLocked] = Locked;
			PVInfo[carid2][mod1] = carmod[0];
			PVInfo[carid2][mod2] = carmod[1];
			PVInfo[carid2][mod3] = carmod[2];
			PVInfo[carid2][mod4] = carmod[3];
			PVInfo[carid2][mod5] = carmod[4];
			PVInfo[carid2][mod6] = carmod[5];
			PVInfo[carid2][mod7] = carmod[6];
			PVInfo[carid2][mod8] = carmod[7];
			PVInfo[carid2][mod9] = carmod[8];
			PVInfo[carid2][mod10] = carmod[9];
			PVInfo[carid2][mod11] = carmod[10];
			PVInfo[carid2][mod12] = carmod[11];
			PVInfo[carid2][mod13] = carmod[12];
			PVInfo[carid2][mod14] = carmod[13];
			PVInfo[carid2][mod15] = carmod[14];
			PVInfo[carid2][mod16] = carmod[15];
			PVInfo[carid2][mod17] = carmod[16];
			PVInfo[carid][vpVehicleSpawned] = carid2;
	        if(ForSale == 1)
	        {
				format(Str, sizeof(Str), "%s for sale!\nPrice: $%d (Seller: %s)\n/marketplace to purchase!", GetVehicleFriendlyName(carid2),Price, vehOwnedBy);
				PVInfo[carid][vpVehicleText] = Create3DTextLabel(Str, 0xFF8400FF, vehX, vehY, vehZ, 50.0, 0, 1);
	        }
	        else
	        {
	            format(Str, sizeof(Str), "%s\nOwner: %s", GetVehicleFriendlyName(carid2),vehOwnedBy);
	            PVInfo[carid][vpVehicleText] = Create3DTextLabel(Str, 0xFF8400FF, vehX, vehY, vehZ, 50.0, 0, 1);
	        }
	        Attach3DTextLabelToVehicle(PVInfo[carid][vpVehicleText], carid2, 0.0, 0.0, 0.0);
	        new string[64];
  			format(string,sizeof(string),"%s",vehOwnedBy);
			strmid(PVInfo[carid][vpOwnedBy], string, 0, strlen(string), 128);
			new engine,lights,alarm,doors,bonnet,boot,objective;
			GetVehicleParamsEx(carid2,engine,lights,alarm,doors,bonnet,boot,objective);
			if(Locked == 1) { SetVehicleParamsEx(carid2,engine,lights,alarm,1,bonnet,boot,objective); }
			else if(Locked == 0) { SetVehicleParamsEx(carid2,engine,lights,alarm,0,bonnet,boot,objective); }
	    }
	}
	mysql_free_result();
}

public ShowMarketplace(playerid)
{
new query[250],results[500],title[64];
format(title,sizeof(title),"{1B8AE4}Vehicle Marketplace");
Num1[playerid] = 0;
Num2[playerid] = 10;
format(query,sizeof(query),"SELECT VehicleID,VehicleModel,VehiclePrice,OwnedBy FROM `pvehicles` WHERE `VehicleForSale`= 1 ORDER BY `VehiclePrice` DESC LIMIT %d, %d", Num1[playerid],Num2[playerid]);
mysql_query(query);
mysql_store_result();
new tRows = mysql_num_rows();
if(tRows == 0) { SendClientMessage(playerid, COLOR_ERROR, "No vehicles are currently for sale!"); return 1; }
new vID, vModel, vOwnedBy[24], vPrice;
while(mysql_fetch_row(query))
{
sscanf(query, "p<|>ddds[24]", vID, vModel, vPrice, vOwnedBy);
format(results,sizeof(results),"%s%d | %s($%d) | Seller: %s\n", results,vID,VehicleFriendlyNames[vModel-400],vPrice,vOwnedBy);
}
if(tRows >= 10) { format(results,sizeof(results), "%sNext Page", results); }
ShowPlayerDialog(playerid, marketplace1, DIALOG_STYLE_LIST,title,results,"Select", "Close");
mysql_free_result();
return 1;
}