[ReneG]

This way of loading vehicles defeats the whole purpose of using MySQL! (no offense) You're supposed to fetch all matching records and then loop through them. Also, you should look into upgrading to R7, taking advantage of the cache_functions, and implementing a primary key for each user so your database only has to compare integers instead of strings.

Anyways, I haven't tested this code, but try it.

pawn Code:

stock LoadPlayerVehicles(playerid) 
{ 
    new query[400]; 
    format(query, sizeof(query), "SELECT * FROM `playervehicles` WHERE `OwnerName` = '%s'", PlayerName(playerid)); 
    mysql_query(query); 
    mysql_store_result();

    new i;

    whie(i < MAX_PLAYER_OWNED_CARS && mysql_retrieve_row())
    { 
        mysql_fetch_row(query);
        sscanf(query, "p<|>e<sdffffdddddddddddddddddddddddddddddddddddd>", PlayerOwnedVehicles[playerid][i]); 
        PlayerOwnedVehicles[playerid][i][pCarID] = CreateVehicle(PlayerOwnedVehicles[playerid][i][pCarModel], PlayerOwnedVehicles[playerid][i][pCarX], PlayerOwnedVehicles[playerid][i][pCarY], PlayerOwnedVehicles[playerid][i][pCarZ], PlayerOwnedVehicles[playerid][i][pCarRot], PlayerOwnedVehicles[playerid][i][pCarColor1], PlayerOwnedVehicles[playerid][i][pCarColor2], -1); 
        AddVehicleMods(playerid, i);
        i++;
    }
    mysql_free_result(); 
    return true; 
}