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

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

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

/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>&nbsp;</th><th>&nbsp;</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', '&mdash;', 0),
(3, 'SlipKnoT8', './img/avatar/slipknot8.gif', '&mdash;', 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;
}
?>