/trunk/img/avatar/firstleon.jpg |
Новый файл |
Изменения свойств: |
Added: svn:mime-type |
## -0,0 +1 ## |
+application/octet-stream |
\ No newline at end of property |
Index: img/avatar/diffor.jpg |
=================================================================== |
Cannot display: file marked as a binary type. |
svn:mime-type = application/octet-stream |
Index: img/avatar/diffor.jpg |
=================================================================== |
--- img/avatar/diffor.jpg (revision 0) |
+++ img/avatar/diffor.jpg (revision 4) |
/img/avatar/diffor.jpg |
Изменения свойств: |
Added: svn:mime-type |
## -0,0 +1 ## |
+application/octet-stream |
\ No newline at end of property |
Index: img/avatar/slipknot8.gif |
=================================================================== |
Cannot display: file marked as a binary type. |
svn:mime-type = application/octet-stream |
Index: img/avatar/slipknot8.gif |
=================================================================== |
--- img/avatar/slipknot8.gif (revision 0) |
+++ img/avatar/slipknot8.gif (revision 4) |
/img/avatar/slipknot8.gif |
Изменения свойств: |
Added: svn:mime-type |
## -0,0 +1 ## |
+application/octet-stream |
\ No newline at end of property |
Index: index.php |
=================================================================== |
--- index.php (revision 3) |
+++ index.php (revision 4) |
@@ -77,5 +77,15 @@ |
} |
// table footer |
echo "</table>"; |
+?> |
+ <br> |
+ <table id="legend"> |
+ <tr><td><img src="./img/state/main.png" alt="main"></td><td>Основной ресурс.</td></tr> |
+ <tr><td><img src="./img/state/mirror.png" alt="mirror"></td><td>Зеркало ресурса.</td></tr> |
+ <tr><td><img src="./img/state/access.png" alt="access"></td><td>Есть свободный высокоскоростной доступ к ресурсу.</td></tr> |
+ <tr><td><img src="./img/state/freeze.png" alt="freeze"></td><td>Проект временно недоступен.</td></tr> |
+ </table> |
+ |
+<?php |
include "./inc/footer.htm"; |
?> |
Index: members.php |
=================================================================== |
--- members.php (revision 0) |
+++ members.php (revision 4) |
@@ -0,0 +1,29 @@ |
+<?php |
+ require_once dirname(__FILE__)."/lib/init.php"; |
+ include "./inc/header.htm"; |
+?> |
+ <h2>niX-FILES</h2> |
+ <h1>Участники проекта</h1> |
+<?php |
+ // table header |
+ $mems =& $db->query("SELECT * FROM members"); |
+ echo "<table>"; |
+ echo "<tr>"; |
+ echo "<th>Ник</th><th>Аватар</th><th>Контакты</th><th>Ресурсы</th>"; |
+ while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) { |
+ $ranks =& $db->query("SELECT * |
+ FROM res_mem_rank |
+ JOIN res_net_stat ON res_mem_rank.res_net_id = res_net_stat.id |
+ JOIN networks ON networks.id = res_net_stat.network_id |
+ JOIN resources ON resources.id = res_net_stat.resource_id |
+ WHERE member_id=".$info_mems['id']); |
+ $ranklist = ""; |
+ while ($ranks->fetchInto($info_ranks, DB_FETCHMODE_ASSOC)) { |
+ $ranklist .= $info_ranks['resource']." ".$info_ranks['network']."<br>"; |
+ } |
+ echo "<tr><td>".$info_mems['nick']."</td><td><img src='".$info_mems['avatar']."'</td><td>".$info_mems['jabber']."</td><td>".$ranklist."</td></tr>"; |
+ } |
+ // table footer |
+ echo "</table>"; |
+ include "./inc/footer.htm"; |
+?> |
Index: db/nix-files.sql |
=================================================================== |
--- db/nix-files.sql (revision 3) |
+++ db/nix-files.sql (revision 4) |
@@ -3,7 +3,7 @@ |
-- http://www.phpmyadmin.net |
-- |
-- Хост: localhost |
--- Время создания: Авг 03 2009 г., 15:02 |
+-- Время создания: Авг 03 2009 г., 17:28 |
-- Версия сервера: 5.0.51 |
-- Версия PHP: 4.4.7 |
-- |
@@ -41,14 +41,21 @@ |
DROP TABLE IF EXISTS `members`; |
CREATE TABLE IF NOT EXISTS `members` ( |
`id` int(2) NOT NULL auto_increment, |
- `member` varchar(50) collate utf8_unicode_ci NOT NULL, |
+ `nick` varchar(50) collate utf8_unicode_ci NOT NULL, |
+ `avatar` varchar(50) collate utf8_unicode_ci NOT NULL, |
+ `jabber` varchar(50) collate utf8_unicode_ci NOT NULL, |
+ `icq` int(15) NOT NULL, |
PRIMARY KEY (`id`) |
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; |
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ; |
-- |
-- Дамп данных таблицы `members` |
-- |
|
+INSERT INTO `members` (`id`, `nick`, `avatar`, `jabber`, `icq`) VALUES |
+(1, 'Diffor', './img/avatar/diffor.jpg', 'diffor@jabber.ru', 0), |
+(2, 'firstleon', './img/avatar/firstleon.jpg', '—', 0), |
+(3, 'SlipKnoT8', './img/avatar/slipknot8.gif', '—', 0); |
|
-- -------------------------------------------------------- |
|
@@ -78,6 +85,31 @@ |
-- -------------------------------------------------------- |
|
-- |
+-- Структура таблицы `res_mem_rank` |
+-- |
+ |
+DROP TABLE IF EXISTS `res_mem_rank`; |
+CREATE TABLE IF NOT EXISTS `res_mem_rank` ( |
+ `id` int(5) NOT NULL auto_increment, |
+ `member_id` int(2) NOT NULL, |
+ `res_net_id` int(5) NOT NULL, |
+ `rank_id` int(2) NOT NULL, |
+ PRIMARY KEY (`id`), |
+ KEY `resource_id` (`res_net_id`,`rank_id`), |
+ KEY `member_id` (`member_id`) |
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ; |
+ |
+-- |
+-- Дамп данных таблицы `res_mem_rank` |
+-- |
+ |
+INSERT INTO `res_mem_rank` (`id`, `member_id`, `res_net_id`, `rank_id`) VALUES |
+(1, 3, 1, 1), |
+(2, 3, 2, 1); |
+ |
+-- -------------------------------------------------------- |
+ |
+-- |
-- Структура таблицы `res_net_stat` |
-- |
|
/trunk/inc/footer.htm |
1,10 → 1,3 |
<br> |
<table id="legend"> |
<tr><td><img src="./img/state/main.png" alt="main"></td><td>Основной ресурс.</td></tr> |
<tr><td><img src="./img/state/mirror.png" alt="mirror"></td><td>Зеркало ресурса.</td></tr> |
<tr><td><img src="./img/state/access.png" alt="access"></td><td>Есть свободный высокоскоростной доступ к ресурсу.</td></tr> |
<tr><td><img src="./img/state/freeze.png" alt="freeze"></td><td>Проект временно недоступен.</td></tr> |
</table> |
<p id="info"> |
<a href="http://validator.w3.org/check?uri=referer"><img src="./valid-html40-blue.png" alt="Valid HTML 4.0 Transitional" height="31" width="88"></a> |
<a href="http://jigsaw.w3.org/css-validator/validator?uri=http://www.nix-files.intelbi.ru"><img src="./vcss-blue.png" alt="Valid CSS!" height="31" width="88"></a> |