Dynamic spawns

/*
    * Compltte(true/false): true
    * Code: Yes
    * Author: NexuS
*/

#include a_samp
#include zcmd
#include sscanf2
#include mysql

#define host " "
#define root " "
#define password " "
#define user " "

#define MAX_SPAWN 100

enum _spawn_
{
	Spawn_ID,
	Float:spawn_X,
	Float:spawn_Y,
	Float:spawn_Z,
	Float:spawn_A,
}

new SpawnData[MAX_SPAWN][_spawn_], Loadspawn;

public OnGameModeInit()
{
	mysql_init();
	if(mysql_connect(host, root, password, user))
	{
		print("[SQL] successfully combined with database");
	}
	else
	{
		print("[SQL] Not connected to a database");
		SendRconCommand("exit");
	}
	loadDynamicSpawn();
	return 1;
}


public OnPlayerSpawn(playerid)
{
    SetPlayerRandomSpawn(playerid);
	return 1;
}

SetPlayerRandomSpawn(playerid)
{
	new n = random(Loadspawn);
	SetPlayerPos(playerid, SpawnData[n][spawn_X], SpawnData[n][spawn_Y], SpawnData[n][spawn_Z]);
	SetPlayerFacingAngle(playerid, SpawnData[n][spawn_A]);
	SetPlayerInterior(playerid,0);
	SetPlayerVirtualWorld(playerid,0);
	return 1;
}

stock loadDynamicSpawn()
{
	new query[1024];
	Loadspawn = 0;
	mysql_query("select * from bg_Spawn limit "#MAX_SPAWN"");
	mysql_store_result();
	if(!mysql_num_rows())
		print("Can not find any spawn!");
	else
	{
		while(mysql_fetch_row (query))
		{
			sscanf(query, "p<|>dffff", SpawnData[Loadspawn][Spawn_ID], SpawnData[Loadspawn][spawn_X], SpawnData[Loadspawn][spawn_Y], SpawnData[Loadspawn][spawn_Z], SpawnData[Loadspawn][spawn_A]);
            new Float:change = 2.2, model = 1239, type = 1;

			CreatePickup(1314, type, SpawnData[Loadspawn][spawn_X], SpawnData[Loadspawn][spawn_Y], SpawnData[Loadspawn][spawn_Z]);
			CreatePickup(model, type, SpawnData[Loadspawn][spawn_X]+change, SpawnData[Loadspawn][spawn_Y], SpawnData[Loadspawn][spawn_Z]);
			CreatePickup(model, type, SpawnData[Loadspawn][spawn_X]-change, SpawnData[Loadspawn][spawn_Y], SpawnData[Loadspawn][spawn_Z]);
			CreatePickup(model, type, SpawnData[Loadspawn][spawn_X], SpawnData[Loadspawn][spawn_Y]+change, SpawnData[Loadspawn][spawn_Z]);
			CreatePickup(model, type, SpawnData[Loadspawn][spawn_X], SpawnData[Loadspawn][spawn_Y]-change, SpawnData[Loadspawn][spawn_Z]);

			Create3DTextLabel("{59ACFF}Check out the commands by typing {FFFFFF}/Help",0x000000FF, SpawnData[Loadspawn][spawn_X]+change, SpawnData[Loadspawn][spawn_Y], SpawnData[Loadspawn][spawn_Z], 15.0, 0);
			Create3DTextLabel("{59ACFF}Our forums can be found at {FFFFFF}www.Best-Gaming.pl",0x000000FF, SpawnData[Loadspawn][spawn_X]-change, SpawnData[Loadspawn][spawn_Y], SpawnData[Loadspawn][spawn_Z], 15.0, 0);
			Create3DTextLabel("{59ACFF}All telepotru find by typing {FFFFFF}/Teles",0x000000FF, SpawnData[Loadspawn][spawn_X], SpawnData[Loadspawn][spawn_Y]+change, SpawnData[Loadspawn][spawn_Z], 15.0, 0);
			Create3DTextLabel("{59ACFF}Have fun on the server wishes administration {FFFFFF}Best-Gaming.pl",0x000000FF, SpawnData[Loadspawn][spawn_X], SpawnData[Loadspawn][spawn_Y]-change, SpawnData[Loadspawn][spawn_Z], 15.0, 0);
            Loadspawn++;
		}
		printf("[load] loaded spawns:%d", mysql_num_rows());
	}
	mysql_free_result();
}

CMD:newspawn(p, ctext[])
{
	if(!IsPlayerAdmin(p)) return SendClientMessage(p, 0xBB0000FF, "You must be an administrator RCON!");

	if(Loadspawn >= MAX_SPAWN)
	{
	  SendClientMessage(p, 0xBB0000FF, "Limit spawns used!");
	  return 1;
	}
	if(GetPlayerInterior(p) != 0)
	{
		SendClientMessage(p, 0xBB0000FF, "You can not create spawns in the Outback.");
		return 1;
	}
	new Float:Pos[4];
	GetPlayerPos(p, Pos[0], Pos[1], Pos[2]);
	GetPlayerFacingAngle(p, Pos[3]);
	new str[256];
	format(str, sizeof(str), "INSERT INTO bg_Spawn  (`pos_X`, `pos_Y`, `pos_Z`, `pos_A`) VALUES ('%f', '%f', '%f', '%f');", Pos[0], Pos[1], Pos[2], Pos[3]);
	mysql_query(str);
	SendClientMessage(p, 0xBB0000FF, "Spawn was created successfully!");
	loadDynamicSpawn();
	return 1;
}