#include <a_samp>

#define MAXIMAL_PRIVATE_VEHICLES 100
#define MAXIMAL_PLAYERS 100

new DB:Database;
new DBResult:DatabaseResult;
new Query[500];
enum PrivateVehicleMain
{
    PrivateVehicleId,
    PrivateVehiclePrice,
    PrivateVehicleOwner[25],
    PrivateVehicleInterior,
    PrivateVehicleModelId,
    Float:PrivateVehiclePositionX,
    Float:PrivateVehiclePositionY,
    Float:PrivateVehiclePositionZ,
    Float:PrivateVehiclePositionA,
    PrivateVehicleColor1,
    PrivateVehicleColor2
};
new PrivateVehicle[MAXIMAL_PRIVATE_VEHICLES][PrivateVehicleMain];
enum PlayerMain
{
    PlayerName[25]
};
new Player[MAXIMAL_PLAYERS][PlayerMain];

public OnGameModeInit()
{
    new String[150];
    Database = db_open("Server.db");
    DatabaseResult = db_query(Database,"CREATE TABLE IF NOT EXISTS `Private Vehicles` (`Id` INT(5),`Price` INT(10),`Owner` CHAR(25),`Interior` INT(5),`ModelId` INT(5),`PositionX` FLOAT(10,5),`PositionY` FLOAT(10,5),`PositionZ` FLOAT(10,5),`PositionA` FLOAT(10,5),`Color1` INT(5),`Color2` INT(5))");
    db_free_result(DatabaseResult);
    for(new PV = 0; PV < MAXIMAL_PRIVATE_VEHICLES; PV++)
    {
        format(Query,500,"SELECT * FROM `Private Vehicles` WHERE `Id` = '%d'",PV);
        DatabaseResult = db_query(Database,Query);
        if(db_num_rows(DatabaseResult))
        {
            db_get_field_assoc(DatabaseResult,"Id",String,5);
            PrivateVehicle[PV][PrivateVehicleId] = strval(String);
            db_get_field_assoc(DatabaseResult,"Price",String,10);
            PrivateVehicle[PV][PrivateVehiclePrice] = strval(String);
            db_get_field_assoc(DatabaseResult,"Owner",String,25);
            format(PrivateVehicle[PV][PrivateVehicleOwner],25,"%s",String);
            db_get_field_assoc(DatabaseResult,"Interior",String,5);
            PrivateVehicle[PV][PrivateVehicleInterior] = strval(String);
            db_get_field_assoc(DatabaseResult,"ModelId",String,5);
            PrivateVehicle[PV][PrivateVehicleModelId] = strval(String);
            db_get_field_assoc(DatabaseResult,"PositionX",String,20);
            PrivateVehicle[PV][PrivateVehiclePositionX] = floatstr(String);
            db_get_field_assoc(DatabaseResult,"PositionY",String,20);
            PrivateVehicle[PV][PrivateVehiclePositionY] = floatstr(String);
            db_get_field_assoc(DatabaseResult,"PositionZ",String,20);
            PrivateVehicle[PV][PrivateVehiclePositionZ] = floatstr(String);
            db_get_field_assoc(DatabaseResult,"PositionA",String,20);
            PrivateVehicle[PV][PrivateVehiclePositionA] = floatstr(String);
            db_get_field_assoc(DatabaseResult,"Color1",String,5);
            PrivateVehicle[PV][PrivateVehicleColor1] = strval(String);
            db_get_field_assoc(DatabaseResult,"Color2",String,5);
            PrivateVehicle[PV][PrivateVehicleColor2] = strval(String);
            db_free_result(DatabaseResult);
            PrivateVehicle[PV][PrivateVehicleId] = AddStaticVehicle(PrivateVehicle[PV][PrivateVehicleModelId],PrivateVehicle[PV][PrivateVehiclePositionX],PrivateVehicle[PV][PrivateVehiclePositionY],PrivateVehicle[PV][PrivateVehiclePositionZ],PrivateVehicle[PV][PrivateVehiclePositionA],PrivateVehicle[PV][PrivateVehicleColor1],PrivateVehicle[PV][PrivateVehicleColor2]);
        }
        if(!db_num_rows(DatabaseResult))
        {
            db_free_result(DatabaseResult);
            continue;
        }
    }
    return 1;
}

public OnGameModeExit()
{
    db_close(Database);
    return 1;
}

public OnPlayerConnect(playerid)
{
    GetPlayerName(playerid,Player[playerid][PlayerName],25);
    return 1;
}