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

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

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

/trunk/members/index.html
Файл удален
/trunk/img/avatar/firstleon.jpg
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
/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', '&mdash;', 0),
+(3, 'SlipKnoT8', './img/avatar/slipknot8.gif', '&mdash;', 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>