//GAMEMODEINIT
LoadVehicles();
/////////////////////
CMD:vcreate(playerid, params[])
{
    if(P_Info[playerid][N_Admin] >= 3)
    {
        new Float:iX, Float:iY, Float:iZ, Float:iA;
        GetPlayerPos(playerid, iX, iY, iZ);
        GetPlayerFacingAngle(playerid, iA);
        new vehicleid = UnusedVehicle();
        CreateNewVehicle(vehicleid, iX, iY, iZ, iA);
    }
    else return SCM(playerid, -1, #ERROR: You are not a level Three Admin);
    return 1;
}
CMD:vdelete(playerid)
{
    new query[50];
    if(P_Info[playerid][N_Admin] >= 3)
    {
        VehicleLoop(v)
        {
            if(IsPlayerInRangeOfPoint(playerid, 2.0, D_Info[v][v_Z], D_Info[v][v_Y], D_Info[v][v_X]))
            {
                format(query,sizeof(query), "DELETE FROM `vehicles` WHERE `vID` = %d", v);
                mysql_query(query);
                D_Info[v][v_Active] = 0;
                ReloadVehicles(v);
            }
        }
    }
    return 1;
}

stock CreateNewVehicle(vehicle, Float:posX, Float:posY, Float:posZ, Float:posA)
{
    new query[250];
    format(query,sizeof(query),"INSERT INTO `vehicles` (vID) VALUES (%d);", vehicle);
    mysql_query(query);
    format(query, sizeof(query), "UPDATE `vehicles` SET `Owner` = 'None' WHERE `vID`=%d", vehicle);
    mysql_query(query);
    format(query, sizeof(query), "UPDATE `vehicles` SET `Owned` = '0' WHERE `vID`=%d", vehicle);
    mysql_query(query);
    format(query, sizeof(query), "UPDATE `vehicles` SET `Locked` = '0' WHERE `vID`=%d", vehicle);
    mysql_query(query);
    format(query, sizeof(query), "UPDATE `vehicles` SET `Forsale` = '0' WHERE `vID`=%d", vehicle);
    mysql_query(query);
    format(query, sizeof(query), "UPDATE `vehicles` SET `Team` = '0' WHERE `vID`=%d", vehicle);
    mysql_query(query);
    format(query, sizeof(query), "UPDATE `vehicles` SET `Color` = 'None' WHERE `vID`=%d", vehicle);
    mysql_query(query);
    format(query, sizeof(query), "UPDATE `vehicles` SET `Color2` = '0' WHERE `vID`=%d", vehicle);
    mysql_query(query);
    format(query, sizeof(query), "UPDATE `vehicles` SET `X` = '0.0' WHERE `vID`=%d",posX, vehicle);
    mysql_query(query);
    format(query, sizeof(query), "UPDATE `vehicles` SET `Y` = '0.0' WHERE `vID`=%d",posY, vehicle);
    mysql_query(query);
    format(query, sizeof(query), "UPDATE `vehicles` SET `Z` = '0.0' WHERE `vID`=%d",posZ, vehicle);
    mysql_query(query);
    format(query, sizeof(query), "UPDATE `vehicles` SET `FAngle` = '%f' WHERE `vID`=%d",posA, vehicle);
    mysql_query(query);
    format(query, sizeof(query), "UPDATE `vehicles` SET `Price` = '0' WHERE `vID`=%d", vehicle);
    mysql_query(query);
    format(query, sizeof(query), "UPDATE `vehicles` SET `Model` = '250' WHERE `vID`=%d", vehicle);
    mysql_query(query);
    ReloadVehicles(vehicle);
    return 1;
}
stock SaveVehicles(v)
{
    new query[750];
    format(query, sizeof(query), "UPDATE `houseinfo` SET `Owner`='%s' WHERE `vID`=%d", D_Info[v][v_Owner], v);
    mysql_query(query);
    format(query, sizeof(query), "UPDATE `vehicles` SET `Owned`='%d' WHERE `vID`=%d", D_Info[v][v_Owned], v);
    mysql_query(query);
    format(query, sizeof(query), "UPDATE `vehicles` SET `Locked`='%d' WHERE `vID`=%d", D_Info[v][v_Locked], v);
    mysql_query(query);
    format(query, sizeof(query), "UPDATE `vehicles` SET `Forsale`='%d' WHERE `vID`=%d", D_Info[v][v_Forsale], v);
    mysql_query(query);
    format(query, sizeof(query), "UPDATE `vehicles` SET `Team`='%d' WHERE `vID`=%d", D_Info[v][v_Team], v);
    mysql_query(query);
    format(query, sizeof(query), "UPDATE `vehicles` SET `Color`='%d' WHERE `vID`=%d", D_Info[v][v_Color], v);
    mysql_query(query);
    format(query, sizeof(query), "UPDATE `vehicles` SET `Color2`='%d' WHERE `vID`=%d", D_Info[v][v_Color2], v);
    mysql_query(query);
    format(query, sizeof(query), "UPDATE `vehicles` SET `X`='%f' WHERE `vID`=%d", D_Info[v][v_X], v);
    mysql_query(query);
    format(query, sizeof(query), "UPDATE `vehicles` SET `Y`='%f' WHERE `vID`=%d", D_Info[v][v_Y], v);
    mysql_query(query);
    format(query, sizeof(query), "UPDATE `vehicles` SET `Z`='%f' WHERE `vID`=%d", D_Info[v][v_Z], v);
    mysql_query(query);
    format(query, sizeof(query), "UPDATE `vehicles` SET `A`='%f' WHERE `vID`=%d", D_Info[v][v_A], v);
    mysql_query(query);
    format(query, sizeof(query), "UPDATE `vehicles` SET `Price`='%d' WHERE `vID`=%d", D_Info[v][v_Price], v);
    mysql_query(query);
    format(query, sizeof(query), "UPDATE `vehicles` SET `Model`='%d' WHERE `vID`=%d", D_Info[v][v_Model], v);
    mysql_query(query);
    return 1;
}
stock UnusedVehicle()
{
    new Found = -1;
    VehicleLoop(v)
    {
        if(D_Info[v][v_Active] > 0)
        return v;
    }
    return Found;
}

stock LoadVehicles()
{
    VehicleLoop(v)
    {
        new query[250];
        format(query, sizeof(query),"SELECT * FROM `vehicles` WHERE `vID`=%d", h);
        mysql_query(query);
        mysql_store_result();
        new rows = mysql_num_rows();
        if(rows >= 1)
        {
            ReloadVehicles(v);
            D_Info[v][v_Active] = 1;
        }
        else
        {
            D_Info[v][v_Active] = 0;
        }
        mysql_free_result();
    }
}
stock ReloadVehicles(i)
{
    DestroyDynamic3DTextLabel(D_Info[i][PriceLabel]);

    new query[300], savingstring[50];
    format(query, sizeof(query), "SELECT * FROM `vehicles` WHERE `vID`=%d", i);
    mysql_query(query);
    mysql_store_result();
    while(mysql_fetch_row_format(query,"|"))
    {
        mysql_fetch_field_row(savingstring, "vID");
        D_Info[i][v_ID] = strval(savingstring);

        mysql_fetch_field_row(savingstring, "X");
        D_Info[i][v_X] = floatstr(savingstring);
        mysql_fetch_field_row(savingstring, "Y");
        D_Info[i][v_Y] = floatstr(savingstring);
        mysql_fetch_field_row(savingstring, "Z");
        D_Info[i][v_Z] = floatstr(savingstring);
        mysql_fetch_field_row(savingstring, "FAngle");
        D_Info[i][v_A] = floatstr(savingstring);
        mysql_fetch_field_row(savingstring, "Owned");
        D_Info[i][v_Owned] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Owner");
        myStrcpy(D_Info[i][v_Owner], savingstring);
        mysql_fetch_field_row(savingstring, "Locked");
        D_Info[i][v_Locked] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Forsale");
        D_Info[i][v_Forsale] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Team");
        D_Info[i][v_Team] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Color");
        D_Info[i][v_Color] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Color2");
        D_Info[i][v_Color2] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Price");
        D_Info[i][v_Price] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Model");
        D_Info[i][v_Model] = strval(savingstring);
        D_Info[i][closed] = 1;
    }
    mysql_free_result();
    new string[250];
    if(D_Info[i][v_Price] >= 1)
    {
        format(string, sizeof(string), "\n{FFDAB9}For Sale: {FF0000}$%d", D_Info[i][v_Price]);
        D_Info[i][PriceLabel] = Create3DTextLabel(string, -1, D_Info[i][v_X], D_Info[i][v_Y], D_Info[i][v_Z]+0.3, 20.0);
        Attach3DTextLabelToVehicle(D_Info[i][PriceLabel], i, 0, 0, 3.0);
    }
}