Хранилища Subversion ant

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

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

/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':