Редакция 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': |