#include <a_mysql>
#include <ocmd>
#include <sscanf2>
#include <a_samp>

#define host "localhost" //Das dürfte eigentlich bei jedem so sein. wenn nicht das localhost ändern!
#define mysqluser "root" //Der Username den ihr als Loginname benutzt um ins Control Panel zu kommen. (z.B. phpMyAdmin)
#define mysqlpass "" //Das dazugehörige Passwort
#define database "samp_db" // Der name der erstellten DATENBANK!!! (NICHT TABELLE!!)

#define SCRIPT_CARS 100 // You could also #undef MAX_VEHICLES and define it once again.. that's really up to you.
#define DEFAULT_VEHICLE_OWNER "Dealership"
#define DEFAULT_SELL_PRICE 50000
#define DEFAULT_VEHICLE_PRICE 500000

new sql[1024];

enum posInfo
{
    Float: X,
    Float: Y,
    Float: Z,
    Float: R,
}
enum vInfo
{
     Id,
     Owner[25],
     Model,
     Price,
     Float:Pos[posInfo],
}
new VehicleInfo[SCRIPT_CARS][vInfo];
main()
{
	print("\n----------------------------------");
	print(" Blank Gamemode by your name here");
	print("----------------------------------\n");
}
public OnGameModeInit()
{
	mysql_debug(true);
	SetGameModeText("Blank Script");
	AddPlayerClass(0, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0);
	Connect_to_Database();
	ACC_MySQLCreateTables();
	Autosladen();
	return 1;
}

public OnGameModeExit()
{
	return 1;
}

public OnPlayerRequestClass(playerid, classid)
{
	SetPlayerPos(playerid, 1958.3783, 1343.1572, 15.3746);
	SetPlayerCameraPos(playerid, 1958.3783, 1343.1572, 15.3746);
	SetPlayerCameraLookAt(playerid, 1958.3783, 1343.1572, 15.3746);
	return 1;
}

public OnPlayerConnect(playerid)
{
	return 1;
}

public OnPlayerDisconnect(playerid, reason)
{
	return 1;
}

public OnPlayerSpawn(playerid)
{
	return 1;
}

public OnPlayerDeath(playerid, killerid, reason)
{
	return 1;
}

public OnVehicleSpawn(vehicleid)
{
	return 1;
}

public OnVehicleDeath(vehicleid, killerid)
{
	return 1;
}

public OnPlayerText(playerid, text[])
{
	return 1;
}

public OnPlayerCommandText(playerid, cmdtext[])
{
	if (strcmp("/mycommand", cmdtext, true, 10) == 0)
	{
		// Do something here
		return 1;
	}
	return 0;
}

public OnPlayerEnterVehicle(playerid, vehicleid, ispassenger)
{
	return 1;
}

public OnPlayerExitVehicle(playerid, vehicleid)
{
	return 1;
}

public OnPlayerStateChange(playerid, newstate, oldstate)
{
	return 1;
}

public OnPlayerEnterCheckpoint(playerid)
{
	return 1;
}

public OnPlayerLeaveCheckpoint(playerid)
{
	return 1;
}

public OnPlayerEnterRaceCheckpoint(playerid)
{
	return 1;
}

public OnPlayerLeaveRaceCheckpoint(playerid)
{
	return 1;
}

public OnRconCommand(cmd[])
{
	return 1;
}

public OnPlayerRequestSpawn(playerid)
{
	return 1;
}

public OnObjectMoved(objectid)
{
	return 1;
}

public OnPlayerObjectMoved(playerid, objectid)
{
	return 1;
}

public OnPlayerPickUpPickup(playerid, pickupid)
{
	return 1;
}

public OnVehicleMod(playerid, vehicleid, componentid)
{
	return 1;
}

public OnVehiclePaintjob(playerid, vehicleid, paintjobid)
{
	return 1;
}

public OnVehicleRespray(playerid, vehicleid, color1, color2)
{
	return 1;
}

public OnPlayerSelectedMenuRow(playerid, row)
{
	return 1;
}

public OnPlayerExitedMenu(playerid)
{
	return 1;
}

public OnPlayerInteriorChange(playerid, newinteriorid, oldinteriorid)
{
	return 1;
}

public OnPlayerKeyStateChange(playerid, newkeys, oldkeys)
{
	return 1;
}

public OnRconLoginAttempt(ip[], password[], success)
{
	return 1;
}

public OnPlayerUpdate(playerid)
{
	return 1;
}

public OnPlayerStreamIn(playerid, forplayerid)
{
	return 1;
}

public OnPlayerStreamOut(playerid, forplayerid)
{
	return 1;
}

public OnVehicleStreamIn(vehicleid, forplayerid)
{
	return 1;
}

public OnVehicleStreamOut(vehicleid, forplayerid)
{
	return 1;
}

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
	return 1;
}

public OnPlayerClickPlayer(playerid, clickedplayerid, source)
{
	return 1;
}
ocmd:veh(playerid, params[])
{
    new veh, Query[200];
    if(sscanf(params, "d", veh)) return SendClientMessage(playerid, 0xFFFFFFFF, "Usage: /veh [ ModelID ]");
    new Float:pPOS[4];
    GetPlayerPos(playerid, pPOS[0], pPOS[1], pPOS[2]);
    GetPlayerFacingAngle(playerid , pPOS[3]);
    format(Query, sizeof(Query), "INSERT INTO autos (id, owner, model, price, x, y, z, a) VALUES (NULL, '%s', %d, %d, %f, %f, %f, %f);",DEFAULT_VEHICLE_OWNER,veh, DEFAULT_VEHICLE_PRICE, pPOS[0], pPOS[1], pPOS[2], pPOS[3]);
    mysql_query(Query);
    format(Query, sizeof(Query), "Ersteltest Auto %d bei x: %f y: %f z: %f a: %f);",veh,pPOS[0], pPOS[1], pPOS[2], pPOS[3]);
    SendClientMessage(playerid, 0xFFFFFFFF, Query);
    return 1;
}

ocmd:load(playerid, params[])
{
    for(new i; i < SCRIPT_CARS; i++)
    {
        if(IsVehicleConnected(i)) DestroyVehicle(i);
    }
    Autosladen();
    SendClientMessage(playerid, 0xFFFFFFFF, "Fahrzeugegeladen");
}
stock ACC_MySQLCreateTables()
{

    format(sql,sizeof(sql),"CREATE TABLE IF NOT EXISTS `autos` (`id` int(5) NOT NULL AUTO_INCREMENT,`owner` varchar(25) NOT NULL,`model` int(5) NOT NULL,`price` int(11) NOT NULL,`x` float NOT NULL,`y` float NOT NULL,`z` float NOT NULL,`a` float NOT NULL,PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;");
    mysql_query(sql);
    mysql_free_result();
}
stock Connect_to_Database()
{
        mysql_connect(host,mysqluser,database,mysqlpass);
        if(mysql_ping())
                return print("Verbindung hergestellt.");
        else
        {
                mysql_connect(host,mysqluser,database,mysqlpass);
                if(mysql_ping())
                        return print("Verbindung hergestellt.");
                else
                {
                        print("Es konnte keine Verbindung hergestellt werden. Der Server wird geschlossen.");
                        SendRconCommand("exit");
                        return true;
                }
        }
}
stock Autosladen()
{
    new Query[255], id, i = 0;
    format(Query, sizeof(Query), "SELECT * FROM autos");
    mysql_query(Query);
    mysql_store_result();
    while(mysql_fetch_row_format(Query,"|"))
    {
        id = i;
        sscanf(Query, "p<|>e<is[25]iiffff>", VehicleInfo[id]);
		new Color1 = random(126); new Color2 = random(126);
        CreateVehicle(VehicleInfo[id][Model],VehicleInfo[id][Pos][X],VehicleInfo[id][Pos][Y],VehicleInfo[id][Pos][Z],VehicleInfo[id][Pos][R],Color1,Color2, 60*10000);
        i++;
    }
}
stock IsVehicleConnected(vehicleid)
{
    new Float:x1,Float:y1,Float:z1;
    GetVehiclePos(vehicleid,x1,y1,z1);
    if(x1==0.0 && y1==0.0 && z1==0.0)
    {
       return 0;
    }
    return 1;
}
public OnQueryError(errorid, error[], resultid, extraid, callback[], query[], connectionHandle)
{
    printf("EID: %d | Error: %s | Resultid %d | extraid: %d", errorid, error, resultid, extraid);
	return 1;
}