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

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

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

/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', '&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>
/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";
?>