/trunk/members/index.html |
---|
Файл удален |
/trunk/members.php |
---|
Новый файл |
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"; |
?> |
/trunk/db/nix-files.sql |
---|
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> |
/trunk/img/avatar/diffor.jpg |
---|
Cannot display: file marked as a binary type. |
svn:mime-type = application/octet-stream |
/trunk/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: img/avatar/firstleon.jpg |
=================================================================== |
Cannot display: file marked as a binary type. |
svn:mime-type = application/octet-stream |
Index: img/avatar/firstleon.jpg |
=================================================================== |
--- img/avatar/firstleon.jpg (revision 0) |
+++ img/avatar/firstleon.jpg (revision 4) |
/img/avatar/firstleon.jpg |
---|
Изменения свойств: |
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"; |
?> |