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