//-----------------------------------------------------------------------------//
/*
enum E_DATA_PLAYER
{
	Prison,
	TimePrison,
	ReasonPrison[40],
}
static
	Player[MAX_PLAYERS][E_DATA_PLAYER];

*/
//-----------------------------------------------------------------------------//

CMD:prender(playerid, params[])
{
	if(!Player[playerid][Admin])
		return SendErrorMessage(playerid, "Você não tem permissão para usar o comando!");

	new targetid, tempo;

	if(sscanf(params, "dds[30]", targetid, tempo, params))
		return SendSyntaxMessage(playerid, "/prender [id do player] [tempo] [motivo]");

	else if(!IsPlayerConnected(targetid))
		return SendErrorMessage(playerid, "ID Inválido!");

	SetPlayerPrison(targetid, tempo);
	format(Player[playerid][ReasonPrison], 40, "%s", params);
	return SendClientMessageToAllEx(0xFF7777AA, "[SERVER]: %s foi preso pelo %s %s | Tempo: %d | Motivo: %s", GetName[targetid], GetAdmin(playerid), GetName[playerid], tempo, params);
}

//-----------------------------------------------------------------------------//
// Exemplo de Salvamento
//-----------------------------------------------------------------------------//

SavePlayerAccount(playerid)
{
	mysql_format(ConnectMySQL, String, sizeof String, "UPDATE `contas` SET `Prison` = %d, `TimePrison` = %d, `ReasonPrison` = '%e' WHERE `AccountID` = %d", Player[playerid][Prison], Player[playerid][TimePrison], Player[playerid][ReasonPrison], Player[playerid][AccountID]);
	return mysql_tquery(ConnectMySQL, String);
}

GetPlayerDataAccount(playerid)
{
	mysql_format(ConnectMySQL, String, sizeof String, "SELECT * FROM `contas` WHERE `Nick` = '%e' LIMIT 1", GetName[playerid]);
	return mysql_tquery(ConnectMySQL, String, "OnPlayerDataAccount", "i", playerid);
}

OnPlayerDataAccount(playerid);
public OnPlayerDataAccount(playerid)
{
	if(cache_get_row_count())
	{
		Player[playerid][Prison] = cache_get_field_content_int(0, "Prison");
		Player[playerid][TimePrison] = cache_get_field_content_int(0, "TimePrison");
		cache_get_field_content(0, "ReasonPrison", Player[playerid][ReasonPrison]);
	}
}

//-----------------------------------------------------------------------------//