#include <a_samp>
#include <mysql>
#include <sscanf2>
#include <Zcmd>

//definy
#define MAX_SPAWN 200 //można powiększać...
//zmienne
new sprawdzaneid;
//enumy
enum randomspawn { Float: vpos[4] };

//tablice do enumów
new rspawn[MAX_SPAWN][randomspawn];
//
public OnGameModeInit()
{
	new MySQL:connection = mysql_init(LOG_ONLY_ERRORS, 1);
	mysql_connect("192.166.219.226", "Shalp3y", "*******************", "Shalp3y", connection, 1);
	SetGameModeText("Spawnsy");
	LoadSpawn();
	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 OnPlayerSpawn(playerid)
{
	new rand = random(gTotalRandomSpawn);
	if (!rand) rand=1; // aqq
	SetPlayerPosEx( playerid, rspawn[ rand ][ vpos ][ 0 ],
			rspawn[ rand ][ vpos ][ 1 ],
			rspawn[ rand ][ vpos ][ 2 ],
			rspawn[ rand ][ vpos ][ 3 ] );
	return 1;
}

stock LoadSpawn( ) {
	gTotalRandomSpawn = 0;

	new i, query[ 128 ]; // 10000 o_0
	format( query, sizeof( query ), "SELECT x,y,z,rot FROM `rand_spawn`" );
	mysql_query( query );
	mysql_store_result( );
	while( mysql_fetch_row( query, "|" ) ) {
		sscanf( query, "p<|>ffff",
			rspawn[ i ][ vpos ][ 0 ],
			rspawn[ i ][ vpos ][ 1 ],
			rspawn[ i ][ vpos ][ 2 ],
			rspawn[ i ][ vpos ][ 3 ] );
 		i++;
	}
	gTotalRandomSpawn=i+1; // omijamy 0 (wartosc testowa)
	printf( "Zaladowano %d spawnow.", i+1 );
	return i;
}

CMD:dodajspawn( playerid, params[ ] ) {

	new query[ 160 ],
		Float: x,
		Float: y,
		Float: z,
		Float: a
	;

	GetPlayerPos( playerid, x, y, z );
	GetPlayerFacingAngle( playerid, a );
	format( query, sizeof( query ), "INSERT INTO `rand_spawn` ( x,y,z,rot ) VALUES ( '%4.3f', '%4.3f', '%4.2f', '%2.3f' );", x, y, z, a );
	mysql_query(query);
	LoadSpawn();
	return 1;
}

CMD:sprawdz( playerid, params[ ] ) {
	new string[ 64 ];
	format(string, sizeof(string), "%f", rspawn[ strval( params ) ][ vpos ][ 0 ]);
	SendClientMessage(playerid, -1, string);
	return 1;
}

stock SetPlayerPosEx( playerid, Float:x, Float:y, Float:z, Float:ang ) {
	SetPlayerPos( playerid, x, y, z );
	SetPlayerFacingAngle( playerid, ang );
	return 1;
}


/*
	struktura

create table if not exist rand_spawn (
	id int(11) not null auto_increment,
	x varchar(16) not null default '0.0',
	y varchar(16) not null default '0.0',
	z varchar(12) not null default '0.0',
	rot varchar(12) not null default '0.0',
	primary key (`id`)
) engine=myisam auto_increment=0;

insert into rand_spawn ( x,y,z,rot ) values ( '0.0', '0.0', '0.0', '0.0' );

*/