Редакция 5 | Редакция 8 | К новейшей редакции | Только различия | Учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
Редакция 5 | Редакция 7 | ||
---|---|---|---|
1 | <?php
|
1 | <?php
|
2 | 2 | ||
3 | include "./sign-valid.php"; |
3 | include "./sign-valid.php"; |
4 | 4 | ||
5 | $mode = abs(intval($_POST["mode"])); |
5 | $mode = abs(intval($_POST["mode"])); |
6 | 6 | ||
7 | $go = "./admin.php"; |
7 | $go = "./admin.php"; |
8 | 8 | ||
9 | switch ($mode) { |
9 | switch ($mode) { |
10 | case '0': |
10 | case '0': |
11 | break; |
11 | break; |
12 | case '1': |
12 | case '1': |
13 | // Добавление нового дистрибутива
|
13 | // Добавление нового дистрибутива
|
14 | $distname = mysql_real_escape_string($_POST["distName"]); |
14 | $distname = mysql_real_escape_string($_POST["distName"]); |
15 | $disttype = abs(intval($_POST["distType"])); |
15 | $disttype = abs(intval($_POST["distType"])); |
16 | 16 | ||
17 | $res =& $db->query("INSERT INTO distribution SET distname='$distname', disttype='$disttype'"); |
17 | $res =& $db->query("INSERT INTO distribution SET distname='$distname', disttype='$disttype'"); |
18 | 18 | ||
19 | break; |
19 | break; |
20 | case '2': |
20 | case '2': |
21 | // Правка существующего дистрибутива
|
21 | // Правка существующего дистрибутива
|
22 | $distname = mysql_real_escape_string($_POST["distName"]); |
22 | $distname = mysql_real_escape_string($_POST["distName"]); |
23 | $disttype = abs(intval($_POST["distType"])); |
23 | $disttype = abs(intval($_POST["distType"])); |
24 | $distID = abs(intval($_POST["distID"])); |
24 | $distID = abs(intval($_POST["distID"])); |
25 | 25 | ||
26 | $res =& $db->query("UPDATE distribution SET distname='$distname', disttype='$disttype' WHERE dist_id='$distID'"); |
26 | $res =& $db->query("UPDATE distribution SET distname='$distname', disttype='$disttype' WHERE dist_id='$distID'"); |
27 | 27 | ||
28 | break; |
28 | break; |
29 | case '3': |
29 | case '3': |
30 | // Удаление существующего дистрибутива
|
30 | // Удаление существующего дистрибутива
|
31 | $distID = abs(intval($_POST["distID"])); |
31 | $distID = abs(intval($_POST["distID"])); |
32 | 32 | ||
33 | $res =& $db->query("DELETE FROM distribution WHERE dist_id='$distID'"); |
33 | $res =& $db->query("DELETE FROM distribution WHERE dist_id='$distID'"); |
34 | $res =& $db->query("DELETE FROM sect2dist WHERE dist_id='$distID'"); |
34 | $res =& $db->query("DELETE FROM sect2dist WHERE dist_id='$distID'"); |
35 | 35 | ||
36 | break; |
36 | break; |
37 | case '4': |
37 | case '4': |
38 | // Добавление новой версии дистрибутива
|
38 | // Добавление новой версии дистрибутива
|
39 | $versname = mysql_real_escape_string($_POST["versNam"]); |
39 | $versname = mysql_real_escape_string($_POST["versNam"]); |
40 | $versnumb = mysql_real_escape_string($_POST["versNum"]); |
40 | $versnumb = mysql_real_escape_string($_POST["versNum"]); |
41 | $verscode = mysql_real_escape_string($_POST["versCN"]); |
41 | $verscode = mysql_real_escape_string($_POST["versCN"]); |
42 | $distname = abs(intval($_POST["distName"])); |
42 | $distname = abs(intval($_POST["distName"])); |
43 | 43 | ||
44 | $res =& $db->query("INSERT INTO version SET dist_id='$distname', vname='$versname', version='$versnumb', vcodename='$verscode'"); |
44 | $res =& $db->query("INSERT INTO version SET dist_id='$distname', vname='$versname', version='$versnumb', vcodename='$verscode'"); |
45 | 45 | ||
46 | break; |
46 | break; |
47 | case '5': |
47 | case '5': |
48 | // Правка имеющейся версии дистрибутива
|
48 | // Правка имеющейся версии дистрибутива
|
49 | $versname = mysql_real_escape_string($_POST["versNam"]); |
49 | $versname = mysql_real_escape_string($_POST["versNam"]); |
50 | $versnumb = mysql_real_escape_string($_POST["versNum"]); |
50 | $versnumb = mysql_real_escape_string($_POST["versNum"]); |
51 | $verscode = mysql_real_escape_string($_POST["versCN"]); |
51 | $verscode = mysql_real_escape_string($_POST["versCN"]); |
52 | $distname = abs(intval($_POST["distName"])); |
52 | $distname = abs(intval($_POST["distName"])); |
53 | $versID = abs(intval($_POST["versID"])); |
53 | $versID = abs(intval($_POST["versID"])); |
54 | 54 | ||
55 | $res =& $db->query("UPDATE version SET dist_id='$distname', vname='$versname', version='$versnumb', vcodename='$verscode' WHERE version_id='$versID'"); |
55 | $res =& $db->query("UPDATE version SET dist_id='$distname', vname='$versname', version='$versnumb', vcodename='$verscode' WHERE version_id='$versID'"); |
56 | 56 | ||
57 | break; |
57 | break; |
58 | case '6': |
58 | case '6': |
59 | // Удаление существующей версии дистрибутива
|
59 | // Удаление существующей версии дистрибутива
|
60 | $versID = abs(intval($_POST["versID"])); |
60 | $versID = abs(intval($_POST["versID"])); |
61 | 61 | ||
62 | $res =& $db->query("DELETE FROM version WHERE version_id='$versID'"); |
62 | $res =& $db->query("DELETE FROM version WHERE version_id='$versID'"); |
63 | $res =& $db->query("DELETE FROM ver2rep WHERE ver_id='$versID'"); |
63 | $res =& $db->query("DELETE FROM ver2rep WHERE ver_id='$versID'"); |
64 | 64 | ||
65 | break; |
65 | break; |
66 | case '7': |
66 | case '7': |
67 | // Добавление нового репозитория
|
67 | // Добавление нового репозитория
|
68 | $versID = abs(intval($_POST["vers"])); |
68 | $versID = abs(intval($_POST["vers"])); |
69 | $repname = mysql_real_escape_string($_POST["repName"]); |
69 | $repname = mysql_real_escape_string($_POST["repName"]); |
70 | $repinfo = mysql_real_escape_string($_POST["repInfo"]); |
70 | $repinfo = mysql_real_escape_string($_POST["repInfo"]); |
71 | $reptype = abs(intval($_POST["repType"])); |
71 | $reptype = abs(intval($_POST["repType"])); |
72 | 72 | ||
73 | $res =& $db->query("INSERT INTO repository SET repname='$repname', repdescribe='$repinfo', reptype='$reptype'"); |
73 | $res =& $db->query("INSERT INTO repository SET repname='$repname', repdescribe='$repinfo', reptype='$reptype'"); |
74 | $res =& $db->query("SELECT rep_id FROM repository ORDER BY rep_id DESC LIMIT 1"); |
74 | $res =& $db->query("SELECT rep_id FROM repository ORDER BY rep_id DESC LIMIT 1"); |
75 | $res->fetchInto($rep, DB_FETCHMODE_ASSOC); |
75 | $res->fetchInto($rep, DB_FETCHMODE_ASSOC); |
76 | $rep_id = $rep["rep_id"]; |
76 | $rep_id = $rep["rep_id"]; |
77 | 77 | ||
78 | $res =& $db->query("INSERT INTO ver2rep SET ver_id='$versID', rep_id='$rep_id'"); |
78 | $res =& $db->query("INSERT INTO ver2rep SET ver_id='$versID', rep_id='$rep_id'"); |
79 | 79 | ||
80 | for ($i=0;$i<count($_POST["sect"]);$i++) { |
80 | for ($i=0;$i<count($_POST["sect"]);$i++) { |
81 | $res =& $db->query("INSERT INTO sect2rep SET sect_id='".$_POST["sect"][$i]."', rep_id='$rep_id'"); |
81 | $res =& $db->query("INSERT INTO sect2rep SET sect_id='".$_POST["sect"][$i]."', rep_id='$rep_id'"); |
82 | }
|
82 | }
|
83 | break; |
83 | break; |
84 | case '8': |
84 | case '8': |
85 | // Правка репозитория
|
85 | // Правка репозитория
|
86 | $repID = abs(intval($_POST["rep"])); |
86 | $repID = abs(intval($_POST["rep"])); |
87 | $repname = mysql_real_escape_string($_POST["repName"]); |
87 | $repname = mysql_real_escape_string($_POST["repName"]); |
88 | $repinfo = mysql_real_escape_string($_POST["repInfo"]); |
88 | $repinfo = mysql_real_escape_string($_POST["repInfo"]); |
89 | $reptype = abs(intval($_POST["repType"])); |
89 | $reptype = abs(intval($_POST["repType"])); |
90 | 90 | ||
91 | $res =& $db->query("UPDATE repository SET repname='$repname', repdescribe='$repinfo', reptype='$reptype' WHERE rep_id='$repID'"); |
91 | $res =& $db->query("UPDATE repository SET repname='$repname', repdescribe='$repinfo', reptype='$reptype' WHERE rep_id='$repID'"); |
92 | $res =& $db->query("DELETE FROM sect2rep WHERE rep_id='$repID'"); |
92 | $res =& $db->query("DELETE FROM sect2rep WHERE rep_id='$repID'"); |
93 | for ($i=0;$i<count($_POST["sect"]);$i++) { |
93 | for ($i=0;$i<count($_POST["sect"]);$i++) { |
94 | $res =& $db->query("INSERT INTO sect2rep SET sect_id='".$_POST["sect"][$i]."', rep_id='$repID'"); |
94 | $res =& $db->query("INSERT INTO sect2rep SET sect_id='".$_POST["sect"][$i]."', rep_id='$repID'"); |
95 | }
|
95 | }
|
96 | break; |
96 | break; |
97 | case '9': |
97 | case '9': |
98 | // Удаление репозитория
|
98 | // Удаление репозитория
|
99 | $repID = abs(intval($_POST["rep"])); |
99 | $repID = abs(intval($_POST["rep"])); |
100 | 100 | ||
101 | $res =& $db->query("DELETE FROM repository WHERE rep_id='$repID'"); |
101 | $res =& $db->query("DELETE FROM repository WHERE rep_id='$repID'"); |
102 | $res =& $db->query("DELETE FROM sect2rep WHERE rep_id='$repID'"); |
102 | $res =& $db->query("DELETE FROM sect2rep WHERE rep_id='$repID'"); |
103 | $res =& $db->query("DELETE FROM ver2rep WHERE rep_id='$repID'"); |
103 | $res =& $db->query("DELETE FROM ver2rep WHERE rep_id='$repID'"); |
104 | 104 | ||
105 | break; |
105 | break; |
106 | case '10': |
106 | case '10': |
107 | // Создание секции
|
107 | // Создание секции
|
108 | $sectname = mysql_real_escape_string($_POST["sectName"]); |
108 | $sectname = mysql_real_escape_string($_POST["sectName"]); |
109 | $sectinfo = mysql_real_escape_string($_POST["sectInfo"]); |
109 | $sectinfo = mysql_real_escape_string($_POST["sectInfo"]); |
110 | 110 | ||
111 | $req =& $db->query("INSERT INTO section SET sectname='$sectname', sectinfo='$sectinfo'"); |
111 | $req =& $db->query("INSERT INTO section SET sectname='$sectname', sectinfo='$sectinfo'"); |
112 | $req =& $db->query("SELECT sect_id FROM section ORDER BY sect_id DESC LIMIT 1"); |
112 | $req =& $db->query("SELECT sect_id FROM section ORDER BY sect_id DESC LIMIT 1"); |
113 | $req->fetchInto($sect, DB_FETCHMODE_ASSOC); |
113 | $req->fetchInto($sect, DB_FETCHMODE_ASSOC); |
114 | 114 | ||
115 | for($i=0;$i<count($_POST["dist"]);$i++) { |
115 | for($i=0;$i<count($_POST["dist"]);$i++) { |
116 | $req =& $db->query("INSERT INTO sect2dist SET dist_id='".$_POST["dist"][$i]."', sect_id='".$sect["sect_id"]."'"); |
116 | $req =& $db->query("INSERT INTO sect2dist SET dist_id='".$_POST["dist"][$i]."', sect_id='".$sect["sect_id"]."'"); |
117 | }
|
117 | }
|
118 | 118 | ||
119 | break; |
119 | break; |
120 | case '11': |
120 | case '11': |
121 | // Правка секции
|
121 | // Правка секции
|
122 | $sectID = abs(intval($_POST["sectID"])); |
122 | $sectID = abs(intval($_POST["sectID"])); |
123 | $sectname = mysql_real_escape_string($_POST["sectName"]); |
123 | $sectname = mysql_real_escape_string($_POST["sectName"]); |
124 | $sectinfo = mysql_real_escape_string($_POST["sectInfo"]); |
124 | $sectinfo = mysql_real_escape_string($_POST["sectInfo"]); |
125 | 125 | ||
126 | $req =& $db->query("UPDATE section SET sectname='$sectname', sectinfo='$sectinfo' WHERE sect_id='$sectID'"); |
126 | $req =& $db->query("UPDATE section SET sectname='$sectname', sectinfo='$sectinfo' WHERE sect_id='$sectID'"); |
127 | $req =& $db->query("DELETE FROM sect2dist WHERE sect_id='$sectID'"); |
127 | $req =& $db->query("DELETE FROM sect2dist WHERE sect_id='$sectID'"); |
128 | 128 | ||
129 | for($i=0;$i<count($_POST["dist"]);$i++) { |
129 | for($i=0;$i<count($_POST["dist"]);$i++) { |
130 | $req =& $db->query("INSERT INTO sect2dist SET dist_id='".$_POST["dist"][$i]."', sect_id='".$sectID."'"); |
130 | $req =& $db->query("INSERT INTO sect2dist SET dist_id='".$_POST["dist"][$i]."', sect_id='".$sectID."'"); |
131 | }
|
131 | }
|
132 | 132 | ||
133 | break; |
133 | break; |
134 | case '12': |
134 | case '12': |
135 | // Удаление секции
|
135 | // Удаление секции
|
136 | $sectID = abs(intval($_POST["sectID"])); |
136 | $sectID = abs(intval($_POST["sectID"])); |
137 | 137 | ||
138 | $req =& $db->query("DELETE FROM section WHERE sect_id='$sectID'"); |
138 | $req =& $db->query("DELETE FROM section WHERE sect_id='$sectID'"); |
139 | $req =& $db->query("DELETE FROM sect2dist WHERE sect_id='$sectID'"); |
139 | $req =& $db->query("DELETE FROM sect2dist WHERE sect_id='$sectID'"); |
140 | $req =& $db->query("DELETE FROM sect2rep WHERE sect_id='$sectID'"); |
140 | $req =& $db->query("DELETE FROM sect2rep WHERE sect_id='$sectID'"); |
141 | 141 | ||
142 | break; |
142 | break; |
143 | case '13': |
143 | case '13': |
144 | // Добавление новой схемы
|
144 | // Добавление новой схемы
|
145 | $scheme = mysql_real_escape_string($_POST["scheme"]); |
145 | $scheme = mysql_real_escape_string($_POST["scheme"]); |
146 | 146 | ||
147 | $req =& $db->query("INSERT INTO scheme SET scheme='$scheme'"); |
147 | $req =& $db->query("INSERT INTO scheme SET scheme='$scheme'"); |
148 | 148 | ||
149 | break; |
149 | break; |
150 | case '14': |
150 | case '14': |
151 | // Правка схемы
|
151 | // Правка схемы
|
152 | $schemeID = abs(intval($_POST["schemeID"])); |
152 | $schemeID = abs(intval($_POST["schemeID"])); |
153 | $scheme = mysql_real_escape_string($_POST["scheme"]); |
153 | $scheme = mysql_real_escape_string($_POST["scheme"]); |
154 | 154 | ||
155 | $req =& $db->query("UPDATE scheme SET scheme='$scheme' WHERE scheme_id='$schemeID'"); |
155 | $req =& $db->query("UPDATE scheme SET scheme='$scheme' WHERE scheme_id='$schemeID'"); |
156 | 156 | ||
157 | break; |
157 | break; |
158 | case '15': |
158 | case '15': |
159 | // Удаление схемы
|
159 | // Удаление схемы
|
160 | $schemeID = abs(intval($_POST["schemeID"])); |
160 | $schemeID = abs(intval($_POST["schemeID"])); |
161 | 161 | ||
162 | $req =& $db->query("DELETE FROM scheme WHERE scheme_id='$schemeID'"); |
162 | $req =& $db->query("DELETE FROM scheme WHERE scheme_id='$schemeID'"); |
163 | 163 | ||
164 | break; |
164 | break; |
- | 165 | case '16': |
|
- | 166 | // Добавление новой настройки Ant
|
|
- | 167 | $option = mysql_real_escape_string($_POST["setoption"]); |
|
- | 168 | $value = mysql_real_escape_string($_POST["setvalue"]); |
|
- | 169 | ||
- | 170 | $req =& $db->query("INSERT INTO settings SET opt='$option', optvalue='$value'"); |
|
- | 171 | ||
- | 172 | break; |
|
- | 173 | case '17': |
|
- | 174 | // Правка настройки Ant
|
|
- | 175 | $optID = abs(intval($_POST["optID"])); |
|
- | 176 | $option = mysql_real_escape_string($_POST["setoption"]); |
|
- | 177 | $value = mysql_real_escape_string($_POST["setvalue"]); |
|
- | 178 | ||
- | 179 | $req =& $db->query("UPDATE settings SET opt='$option', optvalue='$value' WHERE opt_id='$optID'"); |
|
- | 180 | ||
- | 181 | break; |
|
- | 182 | case '18': |
|
- | 183 | // Удаление настройки
|
|
- | 184 | $optID = abs(intval($_POST["optID"])); |
|
- | 185 | ||
- | 186 | $req =& $db->query("DELETE FROM settings WHERE opt_id='$optID'"); |
|
- | 187 | ||
- | 188 | break; |
|
165 | }
|
189 | }
|
166 | 190 | ||
167 | header("Location: $go\n\n"); |
191 | header("Location: $go\n\n"); |
168 | 192 | ||
169 | ?>
|
193 | ?>
|