Хранилища Subversion www_nix-files

Сравнить редакции

Не учитывать пробелы Редакция 162 → Редакция 163

/trunk/servers.php
32,9 → 32,9
while ($srvs->fetchInto($info_srvs, DB_FETCHMODE_ASSOC)) {
echo "<div id='infocard' class='server-ic'><h4>".$info_srvs['server']."</h4>\n";
echo "<p class='admin'><a href='./members.php?memb=".$info_srvs["member_id"]."'>".$info_srvs['nick']."</a></p>";
$ips =& $db->query("SELECT * FROM ips WHERE server_id=".$info_srvs['id']);
$ips =& $db->query("SELECT * FROM ips JOIN networks ON ips.network_id=networks.id WHERE server_id=".$info_srvs['id']);
while ($ips->fetchInto($info_ips, DB_FETCHMODE_ASSOC)) {
echo "<p class='network'>".$info_ips['ip']."</p><br>";
echo "<p class='network'>".$info_ips['ip']." ".$info_ips['network']."</p><br>";
}
echo "<p class='cpu'>".$info_srvs['cpu']."</p>";
echo "<p class='ram'>".$info_srvs['ram']."</p>";
/trunk/db/nix-files.sql
159,7 → 159,7
(4, 'mistiman', 'Кем Станислав', './img/avatar/mistiman.png', 'mistiman@jabber.ru', 0),
(5, 'IK', 'Климентьев Илья', './img/avatar/ik.jpg', 'ik00@jabber.ru', 0),
(7, 'SP|Scream', '', './img/avatar/spscream.png', 'xelnag@jabber.ru', 0),
(8, 'Yamah', '', './img/avatar/yamah.png', '&mdash;', 0);
(8, 'Yamah', '', './img/avatar/yamah.png', 'yamah-byv@jabber.ru', 0);
 
-- --------------------------------------------------------
 
408,7 → 408,7
INSERT INTO `servers` (`id`, `server`, `cpu`, `ram`, `hdd`, `member_id`) VALUES
(1, 'diffor', 'Intel(R) Celeron(TM) CPU 1200MHz', '512Mb SDRAM', 'RAID1 320Gb (ST3250310NS)', 1),
(2, 'leon', 'Intel(R) Pentium(R) III CPU family 1400MHz', '512Mb SDRAM', 'RAID5 551Gb (4 IDE)', 2),
(3, 'Frosia', 'Intel(R) Pentium(R) D CPU 2.80GHz', '2Gb DDR2', '500Gb (WD5000AAKS):640Gb (WD6401AALS):750Gb (WD7501AALS)', 3),
(3, 'Frosya', 'Intel(R) Pentium(R) D CPU 2.80GHz', '2Gb DDR2', '500Gb (WD5000AAKS):640Gb (WD6401AALS):750Gb (WD7501AALS)', 3),
(4, 'fail', '', '', '', 7);
 
-- --------------------------------------------------------