8,10 → 8,15 |
$srvs =& $db->query("SELECT * FROM members JOIN servers ON servers.member_id=members.id"); |
echo "<table>"; |
echo "<tr>"; |
echo "<th>Сервер</th><th>Админ</th><th>IP</th>\n"; |
echo "<th>Сервер</th><th>ТТХ</th><th>Админ</th><th>IP</th>\n"; |
while ($srvs->fetchInto($info_srvs, DB_FETCHMODE_ASSOC)) { |
echo "<tr>"; |
echo "<td><a href='./servers.php?srv=".$info_srvs['id']."'>".$info_srvs['server']."</a></td>\n"; |
echo "<td>"; |
echo "<img src='./img/srv/cpu.png' alt='cpu'>".$info_srvs['cpu']."<br>"; |
echo "<img src='./img/srv/ram.png' alt='ram'>".$info_srvs['ram']."<br>"; |
echo "<img src='./img/srv/hdd.png' alt='hdd'>".$info_srvs['hdd']; |
echo "</td>\n"; |
echo "<td><a href='./members.php?memb=".$info_srvs['member_id']."'>".$info_srvs['nick']."</a></td>\n"; |
$ips =& $db->query("SELECT * FROM ips WHERE server_id=".$info_srvs['id']); |
echo "<td>"; |