public function searchFriend($var)
{
$db = new Database();
$q = "select jr.idJ from jugadorRelacion jr inner join jugador j on (jr.idJ = j.id) \n\t\t\tINNER JOIN relacion r on (jr.idR = r.id)\n\t\t\twhere jr.idR in (select idR from jugadorRelacion where idJ = {$this->id}) \n\t\t\tAND jr.idJ <> {$this->id} AND\n\t\t\t j.nombre like '{$var}%' \n\t\t\tAND r.estado=2";
$r = $db->query($q);
return $db->fetch_array_column($r);
$db->close();
}
public function groupId()
{
$db = new Database();
$q = "select idG from evento where id = {$this->id}";
$r = $db->query($q);
//Al ser siempre un solo valor, devuelvo la posicion 0
return $db->fetch_array_column($r)[0];
$db->close();
}
public function idsAdmins()
{
$db = new Database();
$q = "select idJ from jugadorGrupo where idG = {$this->id} and admin = 1";
$r = $db->query($q);
return $db->fetch_array_column($r);
$db->close();
}
