Редакция 157 | Весь файл | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
| Редакция 157 | Редакция 158 | ||
|---|---|---|---|
| Строка 35... | Строка 35... | ||
| 35 | 35 | ||
| 36 | switch ($mode) { |
36 | switch ($mode) { |
| 37 | case '0': |
37 | case '0': |
| 38 | switch ($cat) { |
38 | switch ($cat) { |
| 39 | case '0': |
39 | case '0': |
| 40 | // Список всех источников
|
40 | // Список всех источников
|
| 41 | $display = "<a href='".$admin."?mode=0'>Управление</a><br><br><br>"; |
41 | $display = "<a href='".$admin."?mode=0'>Управление</a><br><br><br>"; |
| 42 | $orig =& $db->query("SELECT * FROM origin"); |
42 | $orig =& $db->query("SELECT * FROM origin"); |
| 43 | $display .= "<table><tr><td>Источник</td><td>Дистрибутивы</td>"; |
43 | $display .= "<table><tr><td>Источник</td><td>Дистрибутивы</td></tr>"; |
| 44 | while ($orig->fetchInto($info, DB_FETCHMODE_ASSOC)) { |
44 | while ($orig->fetchInto($info, DB_FETCHMODE_ASSOC)) { |
| 45 | $display .= "<tr><td><a href='".$admin."?mode=0&cat=1&uid=".stripslashes($info["id"])."'>".stripslashes($info["origin"])."</a></td>"; |
45 | $display .= "<tr><td><a href='".$admin."?mode=0&cat=1&orig=".stripslashes($info["orig_id"])."'>".stripslashes($info["origin"])."</a></td>"; |
| 46 | $display .= "<td>"; |
46 | $display .= "<td>"; |
| 47 | // --- replace to join
|
47 | // --- replace to join
|
| 48 | // meybe it? select 2value from 2table where 2id in(select 2id from 3table where 1id=$peremenaya)
|
- | |
| 49 | $dist =& $db->query("SELECT distribution.distname |
48 | //$dist =& $db->query("SELECT distribution.distname
|
| 50 | FROM distribution, orig2dist
|
49 | //FROM distribution, orig2dist
|
| 51 | WHERE '".stripslashes($info["id"])."' = orig2dist.orig_id |
50 | //WHERE '".stripslashes($info["id"])."' = orig2dist.orig_id
|
| 52 | AND orig2dist.dist_id = distribution.dist_id"); |
51 | //AND orig2dist.dist_id = distribution.dist_id");
|
| 53 | // ---
|
52 | // ---
|
| 54 | while ($dist->fetchInto($info2, DB_FETCHMODE_ASSOC)) { |
53 | //while ($dist->fetchInto($info2, DB_FETCHMODE_ASSOC)) {
|
| 55 | $display .= stripslashes($info2["distname"])." | "; |
54 | //$display .= stripslashes($info2["distname"])." | ";
|
| 56 | }
|
55 | //}
|
| 57 | $display .=" </td>"; |
56 | $display .=" </td></tr>"; |
| 58 | }
|
57 | }
|
| 59 | $display .= "</table>"; |
58 | $display .= "</table>"; |
| 60 | break; |
59 | break; |
| 61 | case '1': |
60 | case '1': |
| 62 | //Список дистрибутивов для источника
|
61 | //Список дистрибутивов для источника
|
| - | 62 | $orig = abs(intval($_GET["orig"])); |
|
| 63 | $orig =& $db->query("SELECT * FROM origin WHERE origin.id=$uid"); |
63 | $origname = $db->getOne("SELECT origin FROM origin WHERE origin.orig_id=$orig"); |
| - | 64 | $display = "<a href='".$admin."?mode=0'>Управление</a> - <a href='".$admin."?mode=0&cat=$cat&orig=$orig'>Источник: ".$origname."</a><br><br><br>"; |
|
| - | 65 | ||
| - | 66 | $distr =& $db->query("SELECT * FROM distribution"); |
|
| - | 67 | $display .= "<table><tr><td></td><td>Дистрибутив</td><td>Версии</td></tr>"; |
|
| 64 | $orig->fetchInto($info, DB_FETCHMODE_ASSOC); |
68 | while ($distr->fetchInto($info, DB_FETCHMODE_ASSOC)) { |
| - | 69 | $count = $db->getOne("SELECT COUNT(*) FROM orig2dist WHERE orig2dist.orig_id='$orig' AND orig2dist.dist_id='".stripslashes($info["dist_id"])."'"); |
|
| - | 70 | $display .= "<tr>"; |
|
| - | 71 | $display .= "<td><input type='checkbox' name='nam1' value='val'"; |
|
| - | 72 | if ($count>0) { $display .= " checked"; } |
|
| - | 73 | $display .= "></td>"; |
|
| - | 74 | $display .= "<td><a href='".$admin."?mode=0&cat=2&orig=$orig&dist=".stripslashes($info["dist_id"])."'>".stripslashes($info["distname"])."</td>"; |
|
| - | 75 | $display .= "<td></td></tr>"; |
|
| - | 76 | }
|
|
| - | 77 | $display .= "</table>"; |
|
| - | 78 | $display .= "<form><button>Применить</button></form>"; |
|
| - | 79 | break; |
|
| - | 80 | case '2': |
|
| - | 81 | //Список версий для дистрибутива
|
|
| - | 82 | $orig = abs(intval($_GET["orig"])); |
|
| - | 83 | $origname = $db->getOne("SELECT origin FROM origin WHERE origin.orig_id=$orig"); |
|
| - | 84 | $dist = abs(intval($_GET["dist"])); |
|
| - | 85 | $distname = $db->getOne("SELECT distname FROM distribution WHERE dist_id=$dist"); |
|
| 65 | $display = "<a href='".$admin."?mode=0'>Управление</a> - <a href='".$admin."?mode=1'>Источник: ".$info["origin"]."</a><br><br><br>"; |
86 | $display = "<a href='".$admin."?mode=0'>Управление</a> - <a href='".$admin."?mode=0&cat=$cat&orig=$orig'>Источник: ".$origname."</a>"; |
| 66 | $distr =& $db->query("SELECT * FROM distribution,orig2dist,origin WHERE distribution.dist_id=orig2dist.dist_id AND orig2dist.orig_id='16'"); |
87 | $display .= " - <a href='".$admin."?mode=0&cat=$cat&orig=$orig&dist=$dist'>Дистрибутив: ".$distname."</a><br><br><br>"; |
| - | 88 | ||
| - | 89 | $distr =& $db->query("SELECT * FROM version"); |
|
| 67 | $display .= "<table><tr><td>Дистрибутив</td><td>Секции</td></tr>"; |
90 | $display .= "<table><tr><td></td><td>Версии</td><td>Секции</td></tr>"; |
| 68 | while ($distr->fetchInto($info, DB_FETCHMODE_ASSOC)) { |
91 | while ($distr->fetchInto($info, DB_FETCHMODE_ASSOC)) { |
| - | 92 | //$count = $db->getOne("SELECT COUNT(*) FROM orig2dist WHERE orig2dist.orig_id='$uid' AND orig2dist.dist_id='".stripslashes($info["dist_id"])."'");
|
|
| - | 93 | $display .= "<tr>"; |
|
| - | 94 | $display .= "<td><input type='checkbox' name='nam1' value='val'"; |
|
| - | 95 | //if ($count>0) { $display .= " checked"; }
|
|
| - | 96 | $display .= "></td>"; |
|
| 69 | $display .= "<tr><td><a href='".$admin."?mode=0&cat=1&uid=".stripslashes($info["id"])."'>".stripslashes($info["distname"])."</td>"; |
97 | $display .= "<td><a href='".$admin."?mode=0&cat=2&orig=$orig&dist=".stripslashes($info["ver_id"])."'>".stripslashes($info["vname"])."</td>"; |
| - | 98 | $display .= "<td></td></tr>"; |
|
| 70 | }
|
99 | }
|
| 71 | $display .= "</table>"; |
100 | $display .= "</table>"; |
| - | 101 | $display .= "<form><button>Применить</button></form>"; |
|
| - | 102 | ||
| - | 103 | ||
| - | 104 | break; |
|
| 72 | }
|
105 | }
|
| 73 | break; |
106 | break; |
| 74 | case '1': |
107 | case '1': |
| 75 | switch ($cat) { |
108 | switch ($cat) { |
| 76 | case '0': |
109 | case '0': |