vehicleinfo

#include <YSI_Coding\y_hooks>
#include <YSI_Coding\y_timers>

new CheckVehID[MAX_PLAYERS];

enum vinfo
{
    ID,
    v_model,
    Float:v_Pos[4],
    v_color1,
    v_color2,

}
new VehicleInfo[MAX_VEHICLES_INFO][vinfo];

public OnGameModeInit(){

    mysql_tquery(g_SQL, "SELECT * FROM `vehicleinfo`", "Load_Vehicleinfo");
    return 1;
}
forward Load_Vehicleinfo();
public Load_Vehicleinfo()
{
    new rows = cache_num_rows();
    new id,loaded;
    if(rows)
    {
        while(loaded < rows)
        {

            cache_get_value_name_int(loaded,"ID",id);
            cache_get_value_name_int(loaded,"v_model",VehicleInfo[id][v_model]);

            cache_get_value_name_float(loaded,"v_Posx",VehicleInfo[id][v_Pos][0]);
            cache_get_value_name_float(loaded,"v_Posy",VehicleInfo[id][v_Pos][1]);
            cache_get_value_name_float(loaded,"v_Posz",VehicleInfo[id][v_Pos][2]);
            cache_get_value_name_float(loaded,"v_Posa",VehicleInfo[id][v_Pos][3]);

            cache_get_value_name_int(loaded,"v_color1",VehicleInfo[id][v_color1]);
            cache_get_value_name_int(loaded,"v_color2",VehicleInfo[id][v_color2]);

            VehicleInfo[id][ID] = CreateVehicle(VehicleInfo[id][v_model], VehicleInfo[id][v_Pos][0], VehicleInfo[id][v_Pos][1],VehicleInfo[id][v_Pos][2], VehicleInfo[id][v_Pos][3], VehicleInfo[id][v_color1], VehicleInfo[id][v_color2], 0);
            if(!VehicleInfo[id][ID])
            {
                VehicleInfo[id][ID] = true;
            }
            loaded ++;
        }

    }
    printf("[SERVER]: %i VehicleInfo were loaded from \"%s\" database...", rows, MYSQL_DATABASE);
}


CMD:savevehinfo(playerid, cmdtext[])
{
    new vehicleid = GetPlayerVehicleID(playerid);
    if(Player[playerid][Admins] <= 0)
        return SendClientMessage(playerid, YELLOW, "[!]: {F81414}คุณไม่ใช่แอดมิน");
    new string[256];
    if(IsPlayerConnected(playerid))
    {
        if(IsPlayerInAnyVehicle(playerid)){
            new Float:X,Float:Y,Float:Z, Float:A;
            GetVehiclePos(vehicleid, X, Y, Z);
            GetVehicleZAngle(vehicleid, A);
            for(new i = 1; i < MAX_VEHICLES_INFO; i++)
            {
                if(!VehicleInfo[i][ID])
                {
                    VehicleInfo[i][ID] = true;
                    VehicleInfo[i][v_model] = GetVehicleModel(GetPlayerVehicleID(playerid));
                    VehicleInfo[i][v_Pos][0] = X;
                    VehicleInfo[i][v_Pos][1] = Y;
                    VehicleInfo[i][v_Pos][2] = Z;
                    VehicleInfo[i][v_Pos][3] = A;
                    VehicleInfo[i][v_color1] = 1;
                    VehicleInfo[i][v_color2] = 2;
                    format(string, sizeof(string), "คุณได้ซื้อรถ (%d)",i);
                    SendClientMessage(playerid, ORANGE, string);


                    new query[256];
                    mysql_format(g_SQL, query, sizeof(query), "INSERT INTO vehicleinfo (ID, v_model, v_Posx, v_Posy, v_Posz, v_Posa, v_color1, v_color2) VALUES (%d,%d, %f, %f, %f,%f,%d,%d)", i, VehicleInfo[i][v_model],
                    VehicleInfo[i][v_Pos][0],
                    VehicleInfo[i][v_Pos][1],
                    VehicleInfo[i][v_Pos][2],
                    VehicleInfo[i][v_Pos][3],
                    VehicleInfo[i][v_color1],
                    VehicleInfo[i][v_color2]);
                    mysql_tquery(g_SQL, query);


                    DestroyVehicle(vehicleid);
                    VehicleInfo[i][ID] =  CreateVehicle(VehicleInfo[i][v_model], VehicleInfo[i][v_Pos][0], VehicleInfo[i][v_Pos][1],VehicleInfo[i][v_Pos][2], VehicleInfo[i][v_Pos][3], 1, 1, 0);
                    PutPlayerInVehicle(playerid, VehicleInfo[i][ID], 0);
                    return 1;
                }
            }
        }
        else SendClientMessage(playerid, YELLOW, "[!]: {F81414}คุณไม่ได้อยู่บนรถ");
    }
    return 1;
}

CMD:dvehinfo(playerid, cmdtext[])
{
    if(Player[playerid][Admins] <= 0)
        return SendClientMessage(playerid, YELLOW, "[!]: {F81414}คุณไม่ใช่แอดมิน");
    for(new id = 0; id <MAX_VEHICLES_INFO; id++){
        new vehicleid = GetPlayerVehicleID(playerid);
        if(vehicleid == VehicleInfo[id][ID]){

            new carid;
            carid = VehicleInfo[id][ID];
            if(IsPlayerInVehicle(playerid,carid))
            {
                DestroyVehicle(VehicleInfo[id][ID]);
                SendClientMessageEx(playerid, LIGHTBLUE, "delete Veh (%d)",id);
                new query[2000];
                mysql_format(g_SQL, query, sizeof(query), "DELETE FROM vehicleinfo WHERE ID=%d", id);
                mysql_tquery(g_SQL, query, "", "");
                VehicleInfo[id][ID] = false;
                TogglePlayerControllable(playerid, 1);
                return 1;
            }
        }
    }
    return 1;
}

CMD:editvehinfo(playerid){

    new str[99];
    for(new id = 0; id <MAX_VEHICLES_INFO; id++){
        new vehicleid = GetPlayerVehicleID(playerid);
        if(vehicleid == VehicleInfo[id][ID]){

            new carid;
            carid = VehicleInfo[id][ID];
            if(IsPlayerInVehicle(playerid,carid))
            {
                CheckVehID[playerid] = id;
                format(str, 99, "VehicleInfoID %i", id);
                Dialog_Show(playerid, edit_vehinfo, DIALOG_STYLE_LIST, str, "เปลี่ยนสี\nเปลี่ยนพิกัด","OK","NO");
            }
        }
    }
    return 1;
}

Dialog:edit_vehinfo(playerid, response, listitem, inputtext[]){

    new query[256];
    if(!response) return 1;

    if(listitem == 0){
        Dialog_Show(playerid, edit_colorinfo, DIALOG_STYLE_INPUT, "เปลี่ยนสี", "เปลี่ยนสี","OK","NO");
    }
    if(listitem == 1){
        new vehicleid = GetPlayerVehicleID(playerid);
        new Float:x,Float:y,Float:z,Float:a;
        new id = CheckVehID[playerid];
        GetVehiclePos(vehicleid, x, y, z);
        GetVehicleZAngle(vehicleid, a);
        mysql_format(g_SQL, query, sizeof(query), "UPDATE `vehicleinfo` SET `v_Posx` = '%f',`v_Posy` = '%f',`v_Posz` = '%f',`v_Posa` = '%f' WHERE `ID` = '%d'",x,y,z,a,id);
        mysql_tquery(g_SQL, query);
    }
    return 1;
}

Dialog:edit_colorinfo(playerid, response, listitem, inputtext[]){

    if(!response) return 1;
    new tmp[256];
    new idx = 0;
    new vehcolor1, vehcolor2;
    if(!response){
        return 1;
    }
    tmp = strtok(inputtext, idx);
    vehcolor1 = strval(tmp);
    if(vehcolor1 < 0 || vehcolor1 >= 255)
        return SendClientMessage(playerid,YELLOW,"[!]: {F81414}color1 รหัสสี 1 - 255!");

    tmp = strtok(inputtext, idx);
    vehcolor2 = strval(tmp);
    if(vehcolor2 < 0 || vehcolor2 >= 255)
        return SendClientMessage(playerid,YELLOW,"[!]: {F81414}color2 รหัสสี 1 - 255!");

    new query[256];
    new vehicleid = GetPlayerVehicleID(playerid);
    new id = CheckVehID[playerid];
    VehicleInfo[id][v_color1] = vehcolor1;
    VehicleInfo[id][v_color2] = vehcolor2;
    DestroyVehicle(vehicleid);
    VehicleInfo[id][ID] =  CreateVehicle(VehicleInfo[id][v_model], VehicleInfo[id][v_Pos][0], VehicleInfo[id][v_Pos][1],VehicleInfo[id][v_Pos][2], VehicleInfo[id][v_Pos][3], vehcolor1, vehcolor2, 0);
    mysql_format(g_SQL, query, sizeof(query), "UPDATE `vehicleinfo` SET `v_color1` = '%d',`v_color2` = '%d' WHERE `ID` = '%d'",vehcolor1,vehcolor2,id);
    mysql_tquery(g_SQL, query);
    return 1;
}