/trunk/members_admin.php |
---|
Новый файл |
0,0 → 1,92 |
<?php |
require_once dirname(__FILE__)."/lib/init.php"; |
include "./inc/header.htm"; |
$act = $_GET["act"]; |
$resource_id = $_GET["res"]; |
$network_id = $_GET["net"]; |
switch ($act) { |
case 0: |
// table header |
$nets =& $db->query("SELECT * FROM networks"); |
echo "<table>"; |
echo "<tr>"; |
echo "<th> </th><th> </th><th>Ресурс</th>"; |
$netlist = array(); |
$netcount = $nets->numRows(); |
$n = 0; |
while ($nets->fetchInto($info_nets, DB_FETCHMODE_ASSOC)) { |
// network name & link |
if ($info_nets['link']=="") { echo "<th>".$info_nets['network']."</th>"; } |
else { echo "<th><a href='".$info_nets['link']."'>".$info_nets['network']."</a></th>"; } |
// netlist |
$netlist[$n] = $info_nets['id']; |
$n++; |
} |
echo "</tr>"; |
// table body |
$cats =& $db->query("SELECT * FROM categories"); |
while ($cats->fetchInto($info_cats, DB_FETCHMODE_ASSOC)) { |
$res =& $db->query("SELECT * FROM resources WHERE category_id=".$info_cats['id']); |
$first = true; |
while ($res->fetchInto($info_res, DB_FETCHMODE_ASSOC)) { |
echo "<tr>"; |
// add rowspan on first resource on category |
if ($first) { |
echo "<td rowspan='".$res->numRows()."'>".$info_cats['category']."</td>"; |
$first = false; |
} |
// resource picture |
echo "<td><img src='".$info_res['picture']."' alt='".$info_res['resource']."'></td>"; |
// resource name & link |
if ($info_res['link_talk']=="") { echo "<td>".$info_res['resource']."</td>"; } |
else { echo "<td><a href='".$info_res['link_talk']."'>".$info_res['resource']."</a></td>"; } |
// resource state by network |
for ($i=0;$i<$netcount;$i++) { |
///////////////////// |
$mems =& $db->query("SELECT * FROM members JOIN res_mem_rank ON res_mem_rank.member_id=members.id WHERE resource_id=".$info_res['id']." AND network_id=".$netlist[$i]); |
echo "<td>"; |
while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) { |
echo $info_mems['nick']; |
echo "<a href='./members_admin.php?act=2&id=".$info_mems['id']."'><img src='./img/act/edit.png' alt='edit'></a>"; |
echo "<a href='./members_admin.php?act=3&id=".$info_mems['id']."'><img src='./img/act/delete.png' alt='delete'></a>"; |
} |
echo "<br><a href='./members_admin.php?act=1&res=".$info_res['id']."&net=".$netlist[$i]."'><img src='./img/act/add.png' alt='add'></a>"; |
echo "</td>"; |
///////////////////// |
} |
echo "</tr>"; |
} |
} |
// table footer |
echo "</table>"; |
break; |
case 1: |
// Добавление нового дистрибутива |
$mems =& $db->query("SELECT * FROM members"); |
echo "<form action='./members_admin_p.php' method='POST' enctype='multipart/form-data'>\n"; |
echo "<input type='hidden' name='act' value='".$act."'>\n"; |
echo "<input type='hidden' name='resource_id' value='".$resource_id."'>\n"; |
echo "<input type='hidden' name='network_id' value='".$network_id."'>\n"; |
echo "Ник: "; |
echo "<select name='member_id'>"; |
while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) { |
echo "<option value='".$info_mems['id']."'>".$info_mems['nick']."</option>"; |
}; |
echo "</select><br>\n"; |
echo "<input type='submit' value='Добавить'></form>\n"; |
break; |
case 2: |
break; |
case 3: |
break; |
} |
?> |
/trunk/img/act/edit.png |
---|
Cannot display: file marked as a binary type. |
svn:mime-type = application/octet-stream |
/trunk/img/act/edit.png |
---|
Новый файл |
Изменения свойств: |
Added: svn:mime-type |
## -0,0 +1 ## |
+application/octet-stream |
\ No newline at end of property |
Index: trunk/img/act/add.png |
=================================================================== |
Cannot display: file marked as a binary type. |
svn:mime-type = application/octet-stream |
Index: trunk/img/act/add.png |
=================================================================== |
--- trunk/img/act/add.png (revision 0) |
+++ trunk/img/act/add.png (revision 5) |
/trunk/img/act/add.png |
---|
Изменения свойств: |
Added: svn:mime-type |
## -0,0 +1 ## |
+application/octet-stream |
\ No newline at end of property |
Index: trunk/img/act/delete.png |
=================================================================== |
Cannot display: file marked as a binary type. |
svn:mime-type = application/octet-stream |
Index: trunk/img/act/delete.png |
=================================================================== |
--- trunk/img/act/delete.png (revision 0) |
+++ trunk/img/act/delete.png (revision 5) |
/trunk/img/act/delete.png |
---|
Изменения свойств: |
Added: svn:mime-type |
## -0,0 +1 ## |
+application/octet-stream |
\ No newline at end of property |
Index: trunk/members.php |
=================================================================== |
--- trunk/members.php (revision 4) |
+++ trunk/members.php (revision 5) |
@@ -13,9 +13,9 @@ |
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 |
+ JOIN resources ON resources.id = res_mem_rank.resource_id |
+ JOIN networks ON networks.id = res_mem_rank.network_id |
+ JOIN members ON members.id = res_mem_rank.member_id |
WHERE member_id=".$info_mems['id']); |
$ranklist = ""; |
while ($ranks->fetchInto($info_ranks, DB_FETCHMODE_ASSOC)) { |
Index: trunk/db/nix-files.sql |
=================================================================== |
--- trunk/db/nix-files.sql (revision 4) |
+++ trunk/db/nix-files.sql (revision 5) |
@@ -1,20 +1,29 @@ |
-- phpMyAdmin SQL Dump |
--- version 2.9.2-rc1 |
+-- version 3.2.0.1deb1 |
-- http://www.phpmyadmin.net |
--- |
+-- |
-- Хост: localhost |
--- Время создания: Авг 03 2009 г., 17:28 |
--- Версия сервера: 5.0.51 |
--- Версия PHP: 4.4.7 |
--- |
+-- Время создания: Авг 03 2009 г., 22:02 |
+-- Версия сервера: 5.0.83 |
+-- Версия PHP: 5.2.10-1ubuntu1 |
+ |
+SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; |
+ |
+ |
+/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; |
+/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; |
+/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; |
+/*!40101 SET NAMES utf8 */; |
+ |
+-- |
-- База данных: `nix-files` |
--- |
+-- |
-- -------------------------------------------------------- |
--- |
+-- |
-- Структура таблицы `categories` |
--- |
+-- |
DROP TABLE IF EXISTS `categories`; |
CREATE TABLE IF NOT EXISTS `categories` ( |
@@ -23,11 +32,11 @@ |
PRIMARY KEY (`id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ; |
--- |
+-- |
-- Дамп данных таблицы `categories` |
--- |
+-- |
-INSERT INTO `categories` (`id`, `category`) VALUES |
+INSERT INTO `categories` (`id`, `category`) VALUES |
(1, 'file'), |
(2, 'repo'), |
(3, 'info'); |
@@ -34,9 +43,33 @@ |
-- -------------------------------------------------------- |
--- |
+-- |
+-- Структура таблицы `details` |
+-- |
+ |
+DROP TABLE IF EXISTS `details`; |
+CREATE TABLE IF NOT EXISTS `details` ( |
+ `id` int(2) NOT NULL auto_increment, |
+ `title` varchar(50) collate utf8_unicode_ci NOT NULL, |
+ `description` text collate utf8_unicode_ci NOT NULL, |
+ `link` varchar(50) collate utf8_unicode_ci NOT NULL, |
+ `talklink` varchar(50) collate utf8_unicode_ci NOT NULL, |
+ PRIMARY KEY (`id`), |
+ KEY `resource_id` (`title`) |
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ; |
+ |
+-- |
+-- Дамп данных таблицы `details` |
+-- |
+ |
+INSERT INTO `details` (`id`, `title`, `description`, `link`, `talklink`) VALUES |
+(1, 'ftp.niX-FILES', 'Файлопомойко', 'ftp://ftp.nix-files.org.ru', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1846'); |
+ |
+-- -------------------------------------------------------- |
+ |
+-- |
-- Структура таблицы `members` |
--- |
+-- |
DROP TABLE IF EXISTS `members`; |
CREATE TABLE IF NOT EXISTS `members` ( |
@@ -48,11 +81,11 @@ |
PRIMARY KEY (`id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ; |
--- |
+-- |
-- Дамп данных таблицы `members` |
--- |
+-- |
-INSERT INTO `members` (`id`, `nick`, `avatar`, `jabber`, `icq`) VALUES |
+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); |
@@ -59,9 +92,9 @@ |
-- -------------------------------------------------------- |
--- |
+-- |
-- Структура таблицы `networks` |
--- |
+-- |
DROP TABLE IF EXISTS `networks`; |
CREATE TABLE IF NOT EXISTS `networks` ( |
@@ -71,11 +104,11 @@ |
PRIMARY KEY (`id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ; |
--- |
+-- |
-- Дамп данных таблицы `networks` |
--- |
+-- |
-INSERT INTO `networks` (`id`, `network`, `link`) VALUES |
+INSERT INTO `networks` (`id`, `network`, `link`) VALUES |
(1, 'Глоб', ''), |
(2, 'Интелби', 'http://www.intelbi.ru/'), |
(3, 'Интелека', 'http://www.inteleca.ru/'), |
@@ -84,34 +117,71 @@ |
-- -------------------------------------------------------- |
--- |
+-- |
+-- Структура таблицы `resources` |
+-- |
+ |
+DROP TABLE IF EXISTS `resources`; |
+CREATE TABLE IF NOT EXISTS `resources` ( |
+ `id` int(2) NOT NULL auto_increment, |
+ `category_id` int(2) NOT NULL, |
+ `resource` varchar(15) collate utf8_unicode_ci NOT NULL, |
+ `picture` varchar(50) collate utf8_unicode_ci NOT NULL, |
+ `link_talk` varchar(50) collate utf8_unicode_ci NOT NULL, |
+ `link_res` varchar(50) collate utf8_unicode_ci NOT NULL, |
+ PRIMARY KEY (`id`), |
+ KEY `category_id` (`category_id`) |
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=10 ; |
+ |
+-- |
+-- Дамп данных таблицы `resources` |
+-- |
+ |
+INSERT INTO `resources` (`id`, `category_id`, `resource`, `picture`, `link_talk`, `link_res`) VALUES |
+(1, 1, 'ftp', './img/logo/ftp.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1846', 'ftp://ftp.nix-files.org.ru'), |
+(2, 2, 'apt', './img/logo/debian.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1370', 'http://apt.nix-files.org.ru'), |
+(3, 3, 'dicts', './img/logo/kdict.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1432', 'http://dicts.nix-files.org.ru'), |
+(4, 3, 'mans', './img/logo/khelpcenter.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1449', 'http://mans.nix-files.org.ru'), |
+(5, 2, 'gentoo', './img/logo/gentoo.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1860', 'http://gentoo.nix-files.org.ru'), |
+(6, 2, 'mandriva', './img/logo/mandrake.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=2005', 'http://mandriva.nix-files.org.ru'), |
+(7, 2, 'arch', './img/logo/archlinux.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1884', 'http://arch.nix-files.org.ru'), |
+(8, 2, 'alt', './img/logo/altlinux.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=2009', 'http://alt.nix-files.org.ru'), |
+(9, 2, 'freebsd', './img/logo/freebsd.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1990', 'http://freebsd.nix-files.org.ru'); |
+ |
+-- -------------------------------------------------------- |
+ |
+-- |
-- Структура таблицы `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, |
+ `resource_id` int(2) NOT NULL, |
+ `network_id` int(2) NOT NULL, |
`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 ; |
+ KEY `resource_id` (`rank_id`), |
+ KEY `member_id` (`member_id`), |
+ KEY `network_id` (`network_id`), |
+ KEY `resource_id_2` (`resource_id`) |
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; |
--- |
+-- |
-- Дамп данных таблицы `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); |
+INSERT INTO `res_mem_rank` (`id`, `resource_id`, `network_id`, `member_id`, `rank_id`) VALUES |
+(1, 1, 2, 3, 1), |
+(2, 1, 3, 3, 1), |
+(3, 1, 5, 2, 0); |
-- -------------------------------------------------------- |
--- |
+-- |
-- Структура таблицы `res_net_stat` |
--- |
+-- |
DROP TABLE IF EXISTS `res_net_stat`; |
CREATE TABLE IF NOT EXISTS `res_net_stat` ( |
@@ -123,11 +193,11 @@ |
KEY `resource_id` (`resource_id`,`network_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=32 ; |
--- |
+-- |
-- Дамп данных таблицы `res_net_stat` |
--- |
+-- |
-INSERT INTO `res_net_stat` (`id`, `resource_id`, `network_id`, `state_id`) VALUES |
+INSERT INTO `res_net_stat` (`id`, `resource_id`, `network_id`, `state_id`) VALUES |
(1, 1, 2, 1), |
(2, 1, 3, 1), |
(3, 1, 4, 4), |
@@ -159,36 +229,3 @@ |
(29, 9, 2, 1), |
(30, 9, 3, 1), |
(31, 9, 5, 2); |
- |
--- -------------------------------------------------------- |
- |
--- |
--- Структура таблицы `resources` |
--- |
- |
-DROP TABLE IF EXISTS `resources`; |
-CREATE TABLE IF NOT EXISTS `resources` ( |
- `id` int(2) NOT NULL auto_increment, |
- `category_id` int(2) NOT NULL, |
- `resource` varchar(15) collate utf8_unicode_ci NOT NULL, |
- `picture` varchar(50) collate utf8_unicode_ci NOT NULL, |
- `link_talk` varchar(50) collate utf8_unicode_ci NOT NULL, |
- `link_res` varchar(50) collate utf8_unicode_ci NOT NULL, |
- PRIMARY KEY (`id`), |
- KEY `category_id` (`category_id`) |
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=10 ; |
- |
--- |
--- Дамп данных таблицы `resources` |
--- |
- |
-INSERT INTO `resources` (`id`, `category_id`, `resource`, `picture`, `link_talk`, `link_res`) VALUES |
-(1, 1, 'ftp', './img/logo/ftp.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1846', 'ftp://ftp.nix-files.org.ru'), |
-(2, 2, 'apt', './img/logo/debian.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1370', 'http://apt.nix-files.org.ru'), |
-(3, 3, 'dicts', './img/logo/kdict.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1432', 'http://dicts.nix-files.org.ru'), |
-(4, 3, 'mans', './img/logo/khelpcenter.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1449', 'http://mans.nix-files.org.ru'), |
-(5, 2, 'gentoo', './img/logo/gentoo.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1860', 'http://gentoo.nix-files.org.ru'), |
-(6, 2, 'mandriva', './img/logo/mandrake.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=2005', 'http://mandriva.nix-files.org.ru'), |
-(7, 2, 'arch', './img/logo/archlinux.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1884', 'http://arch.nix-files.org.ru'), |
-(8, 2, 'alt', './img/logo/altlinux.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=2009', 'http://alt.nix-files.org.ru'), |
-(9, 2, 'freebsd', './img/logo/freebsd.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1990', 'http://freebsd.nix-files.org.ru'); |
/trunk/members_admin_p.php |
---|
Новый файл |
0,0 → 1,12 |
<?php |
require_once dirname(__FILE__)."/lib/init.php"; |
include "./inc/header.htm"; |
$act = $_POST["act"]; |
switch($act) { |
case 1: |
$res =& $db->query("INSERT INTO res_mem_rank SET resource_id='".$_POST['resource_id']."', network_id='".$_POST['network_id']."', member_id='".$_POST['member_id']."'"); |
break; |
} |
?> |