/trunk/sql/ant.sql |
---|
725,37 → 725,50 |
(9, 1, 'Squeeze', '6.0', 'squeeze'), |
(10, 2, 'Jaunty Jackalope', '9.04', 'jaunty'); |
-- -------------------------------------------------------- |
-- |
-- Структура таблицы `origin` |
-- |
CREATE TABLE IF NOT EXISTS `origin` ( |
`id` int(5) NOT NULL auto_increment, |
`origin` varchar(25) default NULL, |
`orig_id` int(5) NOT NULL auto_increment, |
`origin` varchar(30) default NULL, |
`desk` text NOT NULL, |
`basedir` varchar(50) NOT NULL, |
`homeurl` varchar(50) NOT NULL, |
`keyurl` varchar(50) NOT NULL, |
PRIMARY KEY (`id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ; |
PRIMARY KEY (`orig_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ; |
-- |
-- Дамп данных таблицы `origin` |
-- |
INSERT INTO `origin` (`orig_id`, `origin`, `desk`, `basedir`, `homeurl`, `keyurl`) VALUES |
(1, 'Debian', 'Официальный репозиторий Debian', 'debian', 'http://archive.debian.org/', ''), |
(2, 'Unofficial Multimedia Packages', 'Неофициальные мультимедийные пакеты ', 'debian-multimedia', 'http://www.debian-multimedia.org', ''), |
(3, 'Opera Software ASA', 'Web-браузер Opera', 'opera', 'http://deb.opera.com/', 'http://deb.opera.com/archive.key'), |
(4, 'Ubuntu', 'Официальный репозиторий Ubuntu', 'ubuntu', 'http://archive.ubuntu.com/', ''), |
(5, 'LP-PPA-kubuntu-experimental', 'Экспериментальные пакеты для Kubuntu', 'kubuntu-experimental', 'https://launchpad.net/~kubuntu-experimental', ''), |
(6, 'PlayOnLinux', 'PlayOnLinux vous permetra installer des jeux windows sous un environnement linux', 'playonlinux', 'http://www.playonlinux.com', ''); |
-- -------------------------------------------------------- |
-- |
-- Структура таблицы `orig2rep` |
-- Структура таблицы `orig2dist` |
-- |
CREATE TABLE IF NOT EXISTS `orig2reps` ( |
CREATE TABLE IF NOT EXISTS `orig2dist` ( |
`id` int(11) NOT NULL auto_increment, |
`orig_id` int(5) default NULL, |
`dist_id` int(5) default NULL, |
`ver_id` int(5) default NULL, |
`rep_id` int(5) default NULL, |
PRIMARY KEY (`id`), |
KEY `orig_id` (`orig_id`), |
KEY `dist_id` (`dist_id`), |
KEY `ver_id` (`ver_id`), |
KEY `rep_id` (`rep_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; |
KEY `dist_id` (`dist_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; |
-- |
-- Дамп данных таблицы `orig2dist` |
-- |
INSERT INTO `orig2dist` (`id`, `orig_id`, `dist_id`) VALUES |
(1, 1, 1); |
/trunk/sql/ant-scheme.sql |
---|
255,37 → 255,32 |
KEY `dist_id` (`dist_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ; |
-- -------------------------------------------------------- |
-- |
-- Структура таблицы `origin` |
-- |
CREATE TABLE IF NOT EXISTS `origin` ( |
`id` int(5) NOT NULL auto_increment, |
`origin` varchar(25) default NULL, |
`orig_id` int(5) NOT NULL auto_increment, |
`origin` varchar(30) default NULL, |
`desk` text NOT NULL, |
`basedir` varchar(50) NOT NULL, |
`homeurl` varchar(50) NOT NULL, |
`keyurl` varchar(50) NOT NULL, |
PRIMARY KEY (`id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ; |
PRIMARY KEY (`orig_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ; |
-- -------------------------------------------------------- |
-- |
-- Структура таблицы `orig2rep` |
-- Структура таблицы `orig2dist` |
-- |
CREATE TABLE IF NOT EXISTS `orig2reps` ( |
CREATE TABLE IF NOT EXISTS `orig2dist` ( |
`id` int(11) NOT NULL auto_increment, |
`orig_id` int(5) default NULL, |
`dist_id` int(5) default NULL, |
`ver_id` int(5) default NULL, |
`rep_id` int(5) default NULL, |
PRIMARY KEY (`id`), |
KEY `orig_id` (`orig_id`), |
KEY `dist_id` (`dist_id`), |
KEY `ver_id` (`ver_id`), |
KEY `rep_id` (`rep_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; |
KEY `dist_id` (`dist_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; |
/trunk/sql/install.sql |
---|
348,37 → 348,31 |
KEY `dist_id` (`dist_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; |
-- -------------------------------------------------------- |
-- |
-- Структура таблицы `origin` |
-- |
CREATE TABLE IF NOT EXISTS `origin` ( |
`id` int(5) NOT NULL auto_increment, |
`origin` varchar(25) default NULL, |
`orig_id` int(5) NOT NULL auto_increment, |
`origin` varchar(30) default NULL, |
`desk` text NOT NULL, |
`basedir` varchar(50) NOT NULL, |
`homeurl` varchar(50) NOT NULL, |
`keyurl` varchar(50) NOT NULL, |
PRIMARY KEY (`id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ; |
PRIMARY KEY (`orig_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; |
-- -------------------------------------------------------- |
-- |
-- Структура таблицы `orig2rep` |
-- Структура таблицы `orig2dist` |
-- |
CREATE TABLE IF NOT EXISTS `orig2reps` ( |
CREATE TABLE IF NOT EXISTS `orig2dist` ( |
`id` int(11) NOT NULL auto_increment, |
`orig_id` int(5) default NULL, |
`dist_id` int(5) default NULL, |
`ver_id` int(5) default NULL, |
`rep_id` int(5) default NULL, |
PRIMARY KEY (`id`), |
KEY `orig_id` (`orig_id`), |
KEY `dist_id` (`dist_id`), |
KEY `ver_id` (`ver_id`), |
KEY `rep_id` (`rep_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; |
KEY `dist_id` (`dist_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; |
/trunk/admin_ng.php |
---|
37,38 → 37,71 |
case '0': |
switch ($cat) { |
case '0': |
// Список всех источников |
$display = "<a href='".$admin."?mode=0'>Управление</a><br><br><br>"; |
$orig =& $db->query("SELECT * FROM origin"); |
$display .= "<table><tr><td>Источник</td><td>Дистрибутивы</td>"; |
while ($orig->fetchInto($info, DB_FETCHMODE_ASSOC)) { |
$display .= "<tr><td><a href='".$admin."?mode=0&cat=1&uid=".stripslashes($info["id"])."'>".stripslashes($info["origin"])."</a></td>"; |
$display .= "<td>"; |
// --- replace to join |
// meybe it? select 2value from 2table where 2id in(select 2id from 3table where 1id=$peremenaya) |
$dist =& $db->query("SELECT distribution.distname |
FROM distribution, orig2dist |
WHERE '".stripslashes($info["id"])."' = orig2dist.orig_id |
AND orig2dist.dist_id = distribution.dist_id"); |
// --- |
while ($dist->fetchInto($info2, DB_FETCHMODE_ASSOC)) { |
$display .= stripslashes($info2["distname"])." | "; |
} |
$display .=" </td>"; |
} |
$display .= "</table>"; |
// Список всех источников |
$display = "<a href='".$admin."?mode=0'>Управление</a><br><br><br>"; |
$orig =& $db->query("SELECT * FROM origin"); |
$display .= "<table><tr><td>Источник</td><td>Дистрибутивы</td></tr>"; |
while ($orig->fetchInto($info, DB_FETCHMODE_ASSOC)) { |
$display .= "<tr><td><a href='".$admin."?mode=0&cat=1&orig=".stripslashes($info["orig_id"])."'>".stripslashes($info["origin"])."</a></td>"; |
$display .= "<td>"; |
// --- replace to join |
//$dist =& $db->query("SELECT distribution.distname |
//FROM distribution, orig2dist |
//WHERE '".stripslashes($info["id"])."' = orig2dist.orig_id |
//AND orig2dist.dist_id = distribution.dist_id"); |
// --- |
//while ($dist->fetchInto($info2, DB_FETCHMODE_ASSOC)) { |
//$display .= stripslashes($info2["distname"])." | "; |
//} |
$display .=" </td></tr>"; |
} |
$display .= "</table>"; |
break; |
case '1': |
//Список дистрибутивов для источника |
$orig =& $db->query("SELECT * FROM origin WHERE origin.id=$uid"); |
$orig->fetchInto($info, DB_FETCHMODE_ASSOC); |
$display = "<a href='".$admin."?mode=0'>Управление</a> - <a href='".$admin."?mode=1'>Источник: ".$info["origin"]."</a><br><br><br>"; |
$distr =& $db->query("SELECT * FROM distribution,orig2dist,origin WHERE distribution.dist_id=orig2dist.dist_id AND orig2dist.orig_id='16'"); |
$display .= "<table><tr><td>Дистрибутив</td><td>Секции</td></tr>"; |
while ($distr->fetchInto($info, DB_FETCHMODE_ASSOC)) { |
$display .= "<tr><td><a href='".$admin."?mode=0&cat=1&uid=".stripslashes($info["id"])."'>".stripslashes($info["distname"])."</td>"; |
} |
$display .= "</table>"; |
//Список дистрибутивов для источника |
$orig = abs(intval($_GET["orig"])); |
$origname = $db->getOne("SELECT origin FROM origin WHERE origin.orig_id=$orig"); |
$display = "<a href='".$admin."?mode=0'>Управление</a> - <a href='".$admin."?mode=0&cat=$cat&orig=$orig'>Источник: ".$origname."</a><br><br><br>"; |
$distr =& $db->query("SELECT * FROM distribution"); |
$display .= "<table><tr><td></td><td>Дистрибутив</td><td>Версии</td></tr>"; |
while ($distr->fetchInto($info, DB_FETCHMODE_ASSOC)) { |
$count = $db->getOne("SELECT COUNT(*) FROM orig2dist WHERE orig2dist.orig_id='$orig' AND orig2dist.dist_id='".stripslashes($info["dist_id"])."'"); |
$display .= "<tr>"; |
$display .= "<td><input type='checkbox' name='nam1' value='val'"; |
if ($count>0) { $display .= " checked"; } |
$display .= "></td>"; |
$display .= "<td><a href='".$admin."?mode=0&cat=2&orig=$orig&dist=".stripslashes($info["dist_id"])."'>".stripslashes($info["distname"])."</td>"; |
$display .= "<td></td></tr>"; |
} |
$display .= "</table>"; |
$display .= "<form><button>Применить</button></form>"; |
break; |
case '2': |
//Список версий для дистрибутива |
$orig = abs(intval($_GET["orig"])); |
$origname = $db->getOne("SELECT origin FROM origin WHERE origin.orig_id=$orig"); |
$dist = abs(intval($_GET["dist"])); |
$distname = $db->getOne("SELECT distname FROM distribution WHERE dist_id=$dist"); |
$display = "<a href='".$admin."?mode=0'>Управление</a> - <a href='".$admin."?mode=0&cat=$cat&orig=$orig'>Источник: ".$origname."</a>"; |
$display .= " - <a href='".$admin."?mode=0&cat=$cat&orig=$orig&dist=$dist'>Дистрибутив: ".$distname."</a><br><br><br>"; |
$distr =& $db->query("SELECT * FROM version"); |
$display .= "<table><tr><td></td><td>Версии</td><td>Секции</td></tr>"; |
while ($distr->fetchInto($info, DB_FETCHMODE_ASSOC)) { |
//$count = $db->getOne("SELECT COUNT(*) FROM orig2dist WHERE orig2dist.orig_id='$uid' AND orig2dist.dist_id='".stripslashes($info["dist_id"])."'"); |
$display .= "<tr>"; |
$display .= "<td><input type='checkbox' name='nam1' value='val'"; |
//if ($count>0) { $display .= " checked"; } |
$display .= "></td>"; |
$display .= "<td><a href='".$admin."?mode=0&cat=2&orig=$orig&dist=".stripslashes($info["ver_id"])."'>".stripslashes($info["vname"])."</td>"; |
$display .= "<td></td></tr>"; |
} |
$display .= "</table>"; |
$display .= "<form><button>Применить</button></form>"; |
break; |
} |
break; |
case '1': |