/trunk/img/srv/cpu.png |
Новый файл |
Изменения свойств: |
Added: svn:mime-type |
## -0,0 +1 ## |
+application/octet-stream |
\ No newline at end of property |
Index: trunk/img/srv/hdd.png |
=================================================================== |
Cannot display: file marked as a binary type. |
svn:mime-type = application/octet-stream |
Index: trunk/img/srv/hdd.png |
=================================================================== |
--- trunk/img/srv/hdd.png (revision 0) |
+++ trunk/img/srv/hdd.png (revision 56) |
/trunk/img/srv/hdd.png |
Изменения свойств: |
Added: svn:mime-type |
## -0,0 +1 ## |
+application/octet-stream |
\ No newline at end of property |
Index: trunk/img/srv/ram.png |
=================================================================== |
Cannot display: file marked as a binary type. |
svn:mime-type = application/octet-stream |
Index: trunk/img/srv/ram.png |
=================================================================== |
--- trunk/img/srv/ram.png (revision 0) |
+++ trunk/img/srv/ram.png (revision 56) |
/trunk/img/srv/ram.png |
Изменения свойств: |
Added: svn:mime-type |
## -0,0 +1 ## |
+application/octet-stream |
\ No newline at end of property |
Index: trunk/servers.php |
=================================================================== |
--- trunk/servers.php (revision 55) |
+++ trunk/servers.php (revision 56) |
@@ -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>"; |
Index: trunk/db/nix-files.sql |
=================================================================== |
--- trunk/db/nix-files.sql (revision 55) |
+++ trunk/db/nix-files.sql (revision 56) |
@@ -3,7 +3,7 @@ |
-- http://www.phpmyadmin.net |
-- |
-- Хост: localhost |
--- Время создания: Окт 23 2009 г., 23:48 |
+-- Время создания: Окт 24 2009 г., 12:01 |
-- Версия сервера: 5.1.37 |
-- Версия PHP: 5.2.10-2ubuntu5 |
@@ -390,6 +390,9 @@ |
CREATE TABLE IF NOT EXISTS `servers` ( |
`id` int(5) NOT NULL AUTO_INCREMENT, |
`server` varchar(50) COLLATE utf8_unicode_ci NOT NULL, |
+ `cpu` varchar(50) COLLATE utf8_unicode_ci NOT NULL, |
+ `ram` varchar(50) COLLATE utf8_unicode_ci NOT NULL, |
+ `hdd` varchar(50) COLLATE utf8_unicode_ci NOT NULL, |
`member_id` int(2) NOT NULL, |
PRIMARY KEY (`id`), |
KEY `member_id` (`member_id`) |
@@ -399,11 +402,11 @@ |
-- Дамп данных таблицы `servers` |
-- |
|
-INSERT INTO `servers` (`id`, `server`, `member_id`) VALUES |
-(1, 'diffor', 1), |
-(2, 'leon', 2), |
-(3, 'Frosia', 3), |
-(4, 'fail', 7); |
+INSERT INTO `servers` (`id`, `server`, `cpu`, `ram`, `hdd`, `member_id`) VALUES |
+(1, 'diffor', 'Intel(R) Celeron(TM) CPU 1200MHz', '512Mb SDRAM', 'RAID1 320Gb ()', 1), |
+(2, 'leon', '', '', '', 2), |
+(3, 'Frosia', 'Intel(R) Pentium(R) 4 CPU 2.80GHz', '512Mb DDR', '640Gb (WD6401AALS) + 750Gb (WD7501AALS)', 3), |
+(4, 'fail', '', '', '', 7); |
|
-- -------------------------------------------------------- |
|