<tr>

  <td>
  <form class="cform" action="index.php" method="get">
  <input type="hidden" name="p" value="users-list" />
  <input type="hidden" name="search"' . _restoreGetValue('search', '') . ' />
  <strong>' . $_lang['admin.users.list.groupfilter'] . ':</strong> ' . _admin_authorSelect("group", $group, "id!=2", null, $_lang['global.all'], true) . '
  </select> <input type="submit" value="' . $_lang['global.apply'] . '" />
  </form>
  </td>

  <td>
  <form class="cform" action="index.php" method="get">
  <input type="hidden" name="p" value="users-list" />
  <input type="hidden" name="group" value="' . $group . '" />
  <strong>' . $_lang['admin.users.list.search'] . ':</strong> <input type="text" name="search" class="inputsmall"' . _restoreGetValue('search') . ' /> <input type="submit" value="' . $_lang['mod.search.submit'] . '" />
  ' . ($search ? '&nbsp;<a href="index.php?p=users-list&amp;group=' . $group . '">' . $_lang['global.cancel'] . '</a>' : '') . '
  </form>
  </td>

  </tr>
  </table>
  ';
// tabulka
// priprava strankovani
if (!$search) {
    $paging = _resultPaging("index.php?p=users-list&amp;group=" . $group, 50, "users", $grouplimit2);
    $output .= $paging[0];
}
// tabulka
$output .= "<br />\n  <table class='list'>\n  <thead><tr><td>ID</td><td>" . $_lang['login.username'] . "</td><td>" . $_lang['global.email'] . "</td><td>" . $_lang['mod.settings.publicname'] . "</td><td colspan='2'>" . $_lang['global.group'] . "</td></tr></thead>\n  <tbody>\n  ";
            }
            $item[$index] = $isub;
        }
        $new_banned[] = implode(".", $item);
    }
    $new_banned = trim(implode("\n", array_unique($new_banned)));
    DB::query("UPDATE `" . _mysql_prefix . "-settings` SET val='" . DB::esc($new_banned) . "' WHERE var='banned'");
    $message = _formMessage(1, $_lang['global.saved']);
    $data = $new_banned;
    unset($new_banned);
} else {
    $data = DB::query_row('SELECT `val` FROM `' . _mysql_prefix . '-settings` WHERE `var`=\'banned\'');
    $data = $data['val'];
}
/* ---  vystup  --- */
$output .= "\n<p>" . $_lang['admin.other.bans.p'] . "</p>\n" . $message . "\n\n<table class='wintable'>\n<tr class='valign-top'>\n\n<td>\n<form action='index.php?p=other-bans' method='post'>\n<textarea rows='25' cols='94' class='areamedium' name='banned'>" . $data . "</textarea><br /><br />\n<input type='submit' value='" . $_lang['global.save'] . "' />\n" . _xsrfProtect() . "</form>\n</td>\n\n<td>\n<h2>" . $_lang['admin.other.bans.getuserip'] . "</h2><br />\n<form action='index.php' method='get'>\n<input type='hidden' name='p' value='other-bans' />\n" . $_lang['global.user'] . ": <input type='text' name='getip' class='inputsmall'" . _restoreGetValue("getip") . " /> <input type='submit' value='" . $_lang['global.do'] . "' />\n</form>\n";
// zjisteni ip adres uzivatele
if (isset($_GET['getip'])) {
    $user = _anchorStr(trim($_GET['getip']), false);
    $query = DB::query("SELECT ip,id FROM `" . _mysql_prefix . "-users` WHERE username='******'");
    if (DB::size($query) != 0) {
        $query = DB::row($query);
        // vyhledani adres
        $ips = array();
        $iquery = DB::query("SELECT DISTINCT ip FROM `" . _mysql_prefix . "-posts` WHERE author=" . $query['id']);
        while ($iip = DB::row($iquery)) {
            $ips[] = $iip['ip'];
        }
        // pridani naposledy pouzite
        if (!in_array($query['ip'], $ips)) {
            $ips[] = $query['ip'];