new input_name[MAX_PLAYER_NAME];
new minute;
if(sscanf(params
, "s[20]is[128]", input_name
, minute
, params
)) {
SendClientMessage(playerid
, 0xbfc0c2FF, "Используйте: /prison [playerid / username] [minutes] [reason]"); return 1;
}
new target_id = -1;
if(sscanf(input_name
, "i", target_id
)) {
foreach(new i: Player)
{
if(!strcmp(getName
(i
), input_name
)) {
target_id = i;
break;
}
}
}
if(target_id >= 0)
{
{
SendClientMessage(playerid
, 0xbfc0c2FF, "Игрок с указанным ID не найден на сервере."); return 1;
}
input_name[0] = '\0';
strcat(input_name
, getName
(target_id
)); }
if(target_id != -1)
{
playerInfo[target_id][jailTime] = minute * 60;
}
else
{
new query_string[47+MAX_PLAYER_NAME+1];
mysql_format(dbHandle, query_string, sizeof(query_string), "SELECT id FROM players WHERE Username='%e' LIMIT 1", input_name);
new Cache:r = mysql_query(dbHandle, query_string);
if(cache_num_rows())
{
new id;
cache_get_value_name_int(0, "id");
cache_delete(r);
mysql_format(dbHandle, query_string, sizeof(query_string),
"UPDATE players SET Jail=%d WHERE id=%i", minute, id);
mysql_query(dbHandle, query_string);
}
else
{
return 1;
}
}