<html>
<head>
<style>
#name3 {
color: red;}
#name2 {
color: blue;}
</style>
</head>
<form action='' method='post'>
<center><h2>Поиск Тренера:</h2></center><br>
<input name='TrenName' type='text' value='' style="width:50%; height:20px;">
<input type='submit' name='submit' value='Поиск'>
</form> <br>
<h2>Тренеры:</h2>
<font size="2">
<center><a href="game.php?go=users">Весь список</a> | <a href="game.php?go=users&online=1">Только онлайн</a> | <a href="game.php?go=users&online=3">По Покедексу</a> | <a href="game.php?go=users&online=4">По рангу</a> | <a href="game.php?go=users&online=2">Забаненных</a> </center> <br>
<table width="680" align="center">
<tr><td width=75%><font size="5" color=Cyan><b><i>Имя</i></b></font></td><td width=25% align=center><font size="5" color=Cyan><b><i>Ранг</i></b></font></td></tr>
<?php
function rus2translit($string)
{
$converter = array(
'а' => 'a', 'б' => 'b', 'в' => 'v',
'г' => 'g', 'д' => 'd', 'е' => 'e',
'ё' => 'e', 'ж' => 'zh', 'з' => 'z',
'и' => 'i', 'й' => 'y', 'к' => 'k',
'л' => 'l', 'м' => 'm', 'н' => 'n',
'о' => 'o', 'п' => 'p', 'р' => 'r',
'с' => 's', 'т' => 't', 'у' => 'u',
'ф' => 'f', 'х' => 'h', 'ц' => 'c',
'ч' => 'ch', 'ш' => 'sh', 'щ' => 'sch',
'ь' => "'", 'ы' => 'y', 'ъ' => "'",
'э' => 'e', 'ю' => 'yu', 'я' => 'ya',
'А' => 'A', 'Б' => 'B', 'В' => 'V',
'Г' => 'G', 'Д' => 'D', 'Е' => 'E',
'Ё' => 'E', 'Ж' => 'Zh', 'З' => 'Z',
'И' => 'I', 'Й' => 'Y', 'К' => 'K',
'Л' => 'L', 'М' => 'M', 'Н' => 'N',
'О' => 'O', 'П' => 'P', 'Р' => 'R',
'С' => 'S', 'Т' => 'T', 'У' => 'U',
'Ф' => 'F', 'Х' => 'H', 'Ц' => 'C',
'Ч' => 'Ch', 'Ш' => 'Sh', 'Щ' => 'Sch',
'Ь' => "'", 'Ы' => 'Y', 'Ъ' => "'",
'Э' => 'E', 'Ю' => 'Yu', 'Я' => 'Ya',
);
return strtr($string, $converter);
}
function color_group($group) {
if ($group == 1) $color_gr = "#B22222";
elseif ($group == 2) $color_gr = "#87CEFF";
elseif ($group == 3) $color_gr = "#000000";
elseif ($group == 4) $color_gr = "#000000";
elseif ($group == 5) $color_gr = "#68228B";
elseif ($group == 6) $color_gr = "#8B4513";
elseif ($group == 10) $color_gr = "#A52A2A";
else { $color_gr = "#000000"; }
return $color_gr;}
$rrrr = "Новичок";
$result5 = mysql_query("UPDATE users SET Rang='$rrrr' WHERE id='1'",$db);
function rang_group($id,$group,$rang) {
if ($group == 1 AND $id != 1) $rang2 = "<font color=#000000><b>Администратор</b></font>";
elseif ($group == 2) $rang2 = "<font color=#000000><b>Супермодератор</b></font>";
elseif ($group == 3) $rang2 = "<font color=#000000><b>Модератор</b></font>";
elseif ($group == 4) $rang2 = "<font color=#000000><b>$rang</b></font>";
elseif ($group == 5) $rang2 = "<font color=#000000><b>Наставник</b></font>";
elseif ($group == 6) $rang2 = "<font color=#000000><b>Полицейский</b></font>";
elseif ($group == 10) $rang2 = "<font color=#000000><b>$rang</b></font>";
elseif ($id == 1 AND $group == 1) $rang2 = "<font color=#000000><b>Главный Администратор</b></font>";
else { $rang2 = "<font color=#000000><b>$rang</b></font>"; }
return $rang2;}
if (isset($_POST['TrenName'])){
$tr_name = $_POST['TrenName'];
$tr_name = stripslashes($tr_name);$ban = htmlspecialchars($tr_name);$tr_name = trim($tr_name);
$tr_name = rus2translit($tr_name);
$myrow = first('SELECT * FROM users WHERE login="%s"',$tr_name);
unset($_POST['TrenName']);
if(!$myrow){ echo "<center><h2><font color=gold>Такого тренера не существует.</font></h2></center>";} else {
print '<TR onmouseover=\'this.bgColor="#838B83"\' onmouseout=\'this.bgColor=""\' onclick="window.open(\'page.php?id='.$myrow['id'].'\', \'info\', \'fullscreen=no,scrollbars=yes,width=560,height=560\'); return false;"><TD><B><span style=\'color:'.color_group($myrow['groups']).'\'>'.$myrow['login'].'</B></TD><TD>'.rang_group($myrow['id'],$myrow['groups'],$myrow['Rang']).'</TD></TR>';
}} else {
include('include/itemsinpage.class2.php');
if (isset($_GET['online'])) {
$go=$_GET['online'];
if ($go=="1") {
$dat_ctrok = "&online=1";
$totalpages = first('SELECT COUNT(*) as Total FROM users WHERE activation=1 AND Online=1');
$itemsinpage = new Itemsinpage($totalpages['Total']);
$res_user = select('SELECT login,id,Rang,groups FROM users WHERE activation=1 AND Online=1 ORDER BY groups,login ASC LIMIT %d,%d',$itemsinpage->get('Start'),$itemsinpage->get('Limit'));
foreach($res_user as $myrow){
print '<TR onmouseover=\'this.bgColor="#838B83"\' onmouseout=\'this.bgColor=""\' onclick="window.open(\'page.php?id='.$myrow['id'].'\', \'info\', \'fullscreen=no,scrollbars=yes,width=560,height=560\'); return false;"><TD><B><span style=\'color:'.color_group($myrow['groups']).'\'>'.$myrow['login'].'</B></TD><TD>'.rang_group($myrow['id'],$myrow['groups'],$myrow['Rang']).'</TD></TR>';}}
elseif ($go=="2") {
$dat_ctrok = "&online=2";
$totalpages = first('SELECT COUNT(*) as Total FROM users WHERE activation=0');
$itemsinpage = new Itemsinpage($totalpages['Total']);
$res_user = select('SELECT login,id,Rang,groups FROM users WHERE activation=0 ORDER BY login ASC LIMIT %d,%d',$itemsinpage->get('Start'),$itemsinpage->get('Limit'));
foreach($res_user as $myrow){
print '<TR onmouseover=\'this.bgColor="#838B83"\' onmouseout=\'this.bgColor=""\' onclick="window.open(\'page.php?id='.$myrow['id'].'\', \'info\', \'fullscreen=no,scrollbars=yes,width=560,height=560\'); return false;"><TD><B><span style=\'color:'.color_group($myrow['groups']).'\'>'.$myrow['login'].'</B></TD><TD>'.rang_group($myrow['id'],$myrow['groups'],$myrow['Rang']).'</TD></TR>';
}}
elseif ($go=="3") {
$dat_ctrok = "&online=3";
$totalpages = first('SELECT COUNT(*) as Total FROM users WHERE activation=1 AND id != 285');
$itemsinpage = new Itemsinpage($totalpages['Total']);
$res_user = select('SELECT login,id,Rang,groups,count_poke FROM users WHERE activation=1 AND id != 285 ORDER BY count_poke DESC LIMIT %d,%d',$itemsinpage->get('Start'),$itemsinpage->get('Limit'));
foreach($res_user as $myrow){
print '<TR onmouseover=\'this.bgColor="#838B83"\' onmouseout=\'this.bgColor=""\' onclick="window.open(\'page.php?id='.$myrow['id'].'\', \'info\', \'fullscreen=no,scrollbars=yes,width=560,height=560\'); return false;"><TD><B><span style=\'color:'.color_group($myrow['groups']).'\'>'.$myrow['login'].'</B></TD><TD>'.rang_group($myrow['id'],$myrow['groups'],$myrow['Rang']).'</TD></TR>';
}}
elseif ($go=="4") {
$dat_ctrok = "&online=4";
$totalpages = first('SELECT COUNT(*) as Total FROM users WHERE activation=1');
$itemsinpage = new Itemsinpage($totalpages['Total']);
$res_user = select('SELECT login,id,Rang,groups,reputation FROM users WHERE activation=1 ORDER BY reputation DESC LIMIT %d,%d',$itemsinpage->get('Start'),$itemsinpage->get('Limit'));
foreach($res_user as $myrow){
print '<TR onmouseover=\'this.bgColor="#838B83"\' onmouseout=\'this.bgColor=""\' onclick="window.open(\'page.php?id='.$myrow['id'].'\', \'info\', \'fullscreen=no,scrollbars=yes,width=560,height=560\'); return false;"><TD><B><span style=\'color:'.color_group($myrow['groups']).'\'>'.$myrow['login'].'</B></TD><TD>'.rang_group($myrow['id'],$myrow['groups'],$myrow['Rang']).'</TD></TR>';
}}else { echo"<script>location.href='game.php?go=users'</script>";}}
if(!$_GET['online']){
$totalpages = first('SELECT COUNT(*) as Total FROM users WHERE activation=1 AND arest < now()');
$itemsinpage = new Itemsinpage($totalpages['Total']);
$result = select('SELECT login,id,Rang,groups FROM users WHERE activation=1 AND arest < now()ORDER BY groups,id ASC LIMIT %d,%d',$itemsinpage->get('Start'),$itemsinpage->get('Limit'));
foreach($result as $myrow){
print '<TR onmouseover=\'this.bgColor="#838B83"\' onmouseout=\'this.bgColor=""\' onclick="window.open(\'page.php?id='.$myrow['id'].'\', \'info\', \'fullscreen=no,scrollbars=yes,width=560,height=560\'); return false;"><TD><B><span style=\'color:'.color_group($myrow['groups']).'\'>'.$myrow['login'].'</B></TD><TD>'.rang_group($myrow['id'],$myrow['groups'],$myrow['Rang']).'</TD></TR>';
}}
?>
<?php
$data = $itemsinpage->SmartyArr();
?>
<table>
<tr>
<td>Страница
<?php for($i=0,$n=sizeof($data['Count']);$i<$n;$i++): ?>
<?php if($data['Count'][$i][1]!=$_GET['page']): ?>
<a href="game.php?go=users<?php print $dat_ctrok; ?>&page=<?php print $data['Count'][$i][1];?>"><?php print $data['Count'][$i][0];?></a>
<?php else: ?>
<?php print $data['Count'][$i][0];?>
<?php endif; ?>
<?php endfor; ?>
</td>
</tr>
</table>
<?php }?>
</table>
Собственно решил возобновить темку 
