<?php
$conect = mysql_connect('***', "***", "***");
mysql_select_db("***", $conect);
if (!$conect) {
die('Ошибка подключения к базе: '.mysql_error());
} else {
function st32to64($steam_id)
{
list( , $m1, $m2) = explode(':', $steam_id, 3);
list($steam_cid, ) = explode('.', bcadd((((int) $m2 * 2) + $m1), '76561197960265728'), 2);
return $steam_cid;
}
$imguri = " <img src=\"components/com_xmap/assets/images/img_blue.gif\" border=\"0\"/>";
$i = 1;
$html = "";
$html.= "<table class=\"table table-bordered table-striped\" width=\"99%\" border=\"0\" cellspacing=\"2\" cellpadding=\"2\">";
$html.= "<thead><tr>";
$html.= "<th scope=\"col\">#</th>";
$html.= "<th scope=\"col\">Ник</th>";
$html.= "<th scope=\"col\">SteamId</th>";
$html.= "<th scope=\"col\">E-mail</th>";
//$html.= "<th scope=\"col\">Группа</th>";
$html.= "<th scope=\"col\">Посл. визит</th>";
$html.= "</tr></thead><tbody>";
$sb = mysql_query("SELECT `user`, authid, email, srv_group, lastvisit FROM sb_admins WHERE sb_admins.authid LIKE '%STEAM_0%' ORDER BY lastvisit DESC");
while ($res = mysql_fetch_assoc($sb))
{
$html.= "<tr>";
$html.= "<td>".$i++."</td>";
$html.= "<td><a href=\"sb_search_stat.php?sb_steam=".$res['authid']."\" target=\"_blank\">".$res['user'].$imguri."</a></td>";
$html.= "<td><a href=\"http://steamcommunity.com/profiles/".st32to64($res['authid'])."\" target=\"_blank\">".$res['authid'].$imguri ."</a></td>";
$html.= "<td><a href=\"mailto:".$res['email']."\">".$res['email'].$imguri ."</a></td>";
//$html.= "<td>".$res['srv_group']."</td>";
$html.= "<td>".date("Y-m-d H:i",$res['lastvisit'])."</td>";
$html.= "</tr>";
}
$html.= "</tbody></table>";
echo $html;
}
?>