Редакция 83 | Только различия | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
Редакция 83 | Редакция 87 | ||
---|---|---|---|
1 | <?php
|
1 | <?php
|
2 | 2 | ||
3 | /**
|
3 | /**
|
4 | * Project: Ant: sources.list generator
|
4 | * Project: Ant: sources.list generator
|
5 | * File: process.php
|
5 | * File: process.php
|
6 | *
|
6 | *
|
7 | * This application is free software; you can redistribute it and/or
|
7 | * This application is free software; you can redistribute it and/or
|
8 | * modify it under the terms of the GNU Lesser General Public
|
8 | * modify it under the terms of the GNU Lesser General Public
|
9 | * License as published by the Free Software Foundation; either
|
9 | * License as published by the Free Software Foundation; either
|
10 | * version 2.1 of the License, or (at your option) any later version.
|
10 | * version 2.1 of the License, or (at your option) any later version.
|
11 | *
|
11 | *
|
12 | * This application is distributed in the hope that it will be useful,
|
12 | * This application is distributed in the hope that it will be useful,
|
13 | * but WITHOUT ANY WARRANTY; without even the implied warranty of
|
13 | * but WITHOUT ANY WARRANTY; without even the implied warranty of
|
14 | * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
|
14 | * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
|
15 | * Lesser General Public License for more details.
|
15 | * Lesser General Public License for more details.
|
16 | *
|
16 | *
|
17 | * You should have received a copy of the GNU Lesser General Public
|
17 | * You should have received a copy of the GNU Lesser General Public
|
18 | * License along with this library; if not, write to the Free Software
|
18 | * License along with this library; if not, write to the Free Software
|
19 | * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
|
19 | * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
|
20 | *
|
20 | *
|
21 | */
|
21 | */
|
22 | 22 | ||
23 | 23 | ||
24 | require_once "./sign-valid.php"; |
24 | require_once "./sign-valid.php"; |
25 | 25 | ||
26 | $mode = abs(intval($_POST["mode"])); |
26 | $mode = abs(intval($_POST["mode"])); |
27 | 27 | ||
28 | $go = "./admin.php"; |
28 | $go = "./admin.php"; |
29 | 29 | ||
30 | switch ($mode) { |
30 | switch ($mode) { |
31 | case '0': |
31 | case '0': |
32 | break; |
32 | break; |
33 | case '1': |
33 | case '1': |
34 | // Добавление нового дистрибутива
|
34 | // Добавление нового дистрибутива
|
35 | $distname = mysql_real_escape_string($_POST["distName"]); |
35 | $distname = mysql_real_escape_string($_POST["distName"]); |
36 | $distua = mysql_real_escape_string($_POST["distUA"]); |
36 | $distua = mysql_real_escape_string($_POST["distUA"]); |
37 | $disttype = abs(intval($_POST["distType"])); |
37 | $disttype = abs(intval($_POST["distType"])); |
38 | 38 | ||
39 | $distlogo = 0; |
39 | $distlogo = 0; |
40 | if ($_FILES["distLOGO"]["type"]!=0) { |
40 | if ($_FILES["distLOGO"]["type"]!=0) { |
41 | $folder = dirname(__FILE__)."/img/logo/".stripslashes($distua)."-orig.png"; |
41 | $folder = dirname(__FILE__)."/img/logo/".stripslashes($distua)."-orig.png"; |
42 | $folderN = dirname(__FILE__)."/img/logo/".stripslashes($distua).".png"; |
42 | $folderN = dirname(__FILE__)."/img/logo/".stripslashes($distua).".png"; |
43 | $folderEM = dirname(__FILE__)."/img/logo/".stripslashes($distua)."-em.png"; |
43 | $folderEM = dirname(__FILE__)."/img/logo/".stripslashes($distua)."-em.png"; |
44 | if (move_uploaded_file($_FILES["distLOGO"]["tmp_name"],$folder)) { |
44 | if (move_uploaded_file($_FILES["distLOGO"]["tmp_name"],$folder)) { |
45 | chmod($folder, 0644); |
45 | chmod($folder, 0644); |
46 | list($width, $height) = GetImageSize($folder); |
46 | list($width, $height) = GetImageSize($folder); |
47 | $percent = 32/$height; |
47 | $percent = 32/$height; |
48 | $newwidth = $width * $percent; |
48 | $newwidth = $width * $percent; |
49 | $newheight = $height * $percent; |
49 | $newheight = $height * $percent; |
50 | 50 | ||
51 | $output = ImageCreateTrueColor($newwidth, $newheight); |
51 | $output = ImageCreateTrueColor($newwidth, $newheight); |
52 | $source = ImageCreateFromPNG($folder); |
52 | $source = ImageCreateFromPNG($folder); |
53 | 53 | ||
54 | ImageCopyResized($output, $source, 0, 0, 0, 0, $newwidth, $newheight, $width, $height); |
54 | ImageCopyResized($output, $source, 0, 0, 0, 0, $newwidth, $newheight, $width, $height); |
55 | ImagePNG($output, $folderEM); |
55 | ImagePNG($output, $folderEM); |
56 | 56 | ||
57 | $percent = 15/$height; |
57 | $percent = 15/$height; |
58 | $newwidth = $width * $percent; |
58 | $newwidth = $width * $percent; |
59 | $newheight = $height * $percent; |
59 | $newheight = $height * $percent; |
60 | 60 | ||
61 | $output = ImageCreateTrueColor($newwidth, $newheight); |
61 | $output = ImageCreateTrueColor($newwidth, $newheight); |
62 | 62 | ||
63 | ImageCopyResized($output, $source, 0, 0, 0, 0, $newwidth, $newheight, $width, $height); |
63 | ImageCopyResized($output, $source, 0, 0, 0, 0, $newwidth, $newheight, $width, $height); |
64 | ImagePNG($output, $folderN); |
64 | ImagePNG($output, $folderN); |
65 | 65 | ||
66 | unlink($folder); |
66 | unlink($folder); |
67 | $distlogo = 1; |
67 | $distlogo = 1; |
68 | }
|
68 | }
|
69 | }
|
69 | }
|
70 | 70 | ||
71 | $res =& $db->query("INSERT INTO distribution SET distname='$distname', distua='$distua', disttype='$disttype', distlogo='$distlogo'"); |
71 | $res =& $db->query("INSERT INTO distribution SET distname='$distname', distua='$distua', disttype='$disttype', distlogo='$distlogo'"); |
72 | 72 | ||
73 | break; |
73 | break; |
74 | case '2': |
74 | case '2': |
75 | // Правка существующего дистрибутива
|
75 | // Правка существующего дистрибутива
|
76 | $distname = mysql_real_escape_string($_POST["distName"]); |
76 | $distname = mysql_real_escape_string($_POST["distName"]); |
77 | $distua = mysql_real_escape_string($_POST["distUA"]); |
77 | $distua = mysql_real_escape_string($_POST["distUA"]); |
78 | $disttype = abs(intval($_POST["distType"])); |
78 | $disttype = abs(intval($_POST["distType"])); |
79 | $distID = abs(intval($_POST["distID"])); |
79 | $distID = abs(intval($_POST["distID"])); |
80 | 80 | ||
81 | if ($_FILES["distLOGO"]["type"]!='') { |
81 | if ($_FILES["distLOGO"]["type"]!='') { |
82 | $folder = dirname(__FILE__)."/img/logo/".$distua."-orig.png"; |
82 | $folder = dirname(__FILE__)."/img/logo/".$distua."-orig.png"; |
83 | $folderN = dirname(__FILE__)."/img/logo/".$distua.".png"; |
83 | $folderN = dirname(__FILE__)."/img/logo/".$distua.".png"; |
84 | $folderEM = dirname(__FILE__)."/img/logo/".$distua."-em.png"; |
84 | $folderEM = dirname(__FILE__)."/img/logo/".$distua."-em.png"; |
85 | if (move_uploaded_file($_FILES["distLOGO"]["tmp_name"],$folder)) { |
85 | if (move_uploaded_file($_FILES["distLOGO"]["tmp_name"],$folder)) { |
86 | chmod ($folder, 0644); |
86 | chmod ($folder, 0644); |
87 | list($width, $height) = GetImageSize($folder); |
87 | list($width, $height) = GetImageSize($folder); |
88 | $percent = 32/$height; |
88 | $percent = 32/$height; |
89 | $newwidth = $width * $percent; |
89 | $newwidth = $width * $percent; |
90 | $newheight = $height * $percent; |
90 | $newheight = $height * $percent; |
91 | 91 | ||
92 | $output = ImageCreateTrueColor($newwidth, $newheight); |
92 | $output = ImageCreateTrueColor($newwidth, $newheight); |
93 | $black = ImageColorAllocate($output, 0, 0, 0); |
93 | $black = ImageColorAllocate($output, 0, 0, 0); |
94 | $source = ImageCreateFromPNG($folder); |
94 | $source = ImageCreateFromPNG($folder); |
95 | 95 | ||
96 | ImageCopyResized($output, $source, 0, 0, 0, 0, $newwidth, $newheight, $width, $height); |
96 | ImageCopyResized($output, $source, 0, 0, 0, 0, $newwidth, $newheight, $width, $height); |
97 | ImageColorTransparent($output, $black); |
97 | ImageColorTransparent($output, $black); |
98 | ImagePNG($output, $folderEM); |
98 | ImagePNG($output, $folderEM); |
99 | 99 | ||
100 | $percent = 15/$height; |
100 | $percent = 15/$height; |
101 | $newwidth = $width * $percent; |
101 | $newwidth = $width * $percent; |
102 | $newheight = $height * $percent; |
102 | $newheight = $height * $percent; |
103 | 103 | ||
104 | $output = ImageCreateTrueColor($newwidth, $newheight); |
104 | $output = ImageCreateTrueColor($newwidth, $newheight); |
105 | $black = ImageColorAllocate($output, 0, 0, 0); |
105 | $black = ImageColorAllocate($output, 0, 0, 0); |
106 | 106 | ||
107 | ImageCopyResized($output, $source, 0, 0, 0, 0, $newwidth, $newheight, $width, $height); |
107 | ImageCopyResized($output, $source, 0, 0, 0, 0, $newwidth, $newheight, $width, $height); |
108 | ImageColorTransparent($output, $black); |
108 | ImageColorTransparent($output, $black); |
109 | ImagePNG($output, $folderN); |
109 | ImagePNG($output, $folderN); |
110 | 110 | ||
111 | unlink($folder); |
111 | unlink($folder); |
112 | 112 | ||
113 | $res =& $db->query("UPDATE distribution SET distlogo='1' WHERE dist_id='$distID'"); |
113 | $res =& $db->query("UPDATE distribution SET distlogo='1' WHERE dist_id='$distID'"); |
114 | 114 | ||
115 | }
|
115 | }
|
116 | }
|
116 | }
|
117 | 117 | ||
118 | $res =& $db->query("UPDATE distribution SET distname='$distname', distua='$distua', disttype='$disttype', WHERE dist_id='$distID'"); |
118 | $res =& $db->query("UPDATE distribution SET distname='$distname', distua='$distua', disttype='$disttype', WHERE dist_id='$distID'"); |
119 | 119 | ||
120 | break; |
120 | break; |
121 | case '3': |
121 | case '3': |
122 | // Удаление существующего дистрибутива
|
122 | // Удаление существующего дистрибутива
|
123 | $distID = abs(intval($_POST["distID"])); |
123 | $distID = abs(intval($_POST["distID"])); |
124 | $distUA = $_POST["distUA"]; |
124 | $distUA = $_POST["distUA"]; |
125 | 125 | ||
126 | $folder1 = "./img/logo/".$distUA."-em.gif"; |
126 | $folder1 = "./img/logo/".$distUA."-em.gif"; |
127 | $folder2 = "./img/logo/".$distUA.".gif"; |
127 | $folder2 = "./img/logo/".$distUA.".gif"; |
128 | 128 | ||
129 | if (file_exsists($folder1)) { unlink($folder1); } |
129 | if (file_exsists($folder1)) { unlink($folder1); } |
130 | if (file_exsists($folder2)) { unlink($folder2); } |
130 | if (file_exsists($folder2)) { unlink($folder2); } |
131 | 131 | ||
132 | $res =& $db->query("DELETE FROM distribution WHERE dist_id='$distID'"); |
132 | $res =& $db->query("DELETE FROM distribution WHERE dist_id='$distID'"); |
133 | $res =& $db->query("DELETE FROM sect2dist WHERE dist_id='$distID'"); |
133 | $res =& $db->query("DELETE FROM sect2dist WHERE dist_id='$distID'"); |
134 | 134 | ||
135 | break; |
135 | break; |
136 | case '4': |
136 | case '4': |
137 | // Добавление новой версии дистрибутива
|
137 | // Добавление новой версии дистрибутива
|
138 | $versname = mysql_real_escape_string($_POST["versNam"]); |
138 | $versname = mysql_real_escape_string($_POST["versNam"]); |
139 | $versnumb = mysql_real_escape_string($_POST["versNum"]); |
139 | $versnumb = mysql_real_escape_string($_POST["versNum"]); |
140 | $verscode = mysql_real_escape_string($_POST["versCN"]); |
140 | $verscode = mysql_real_escape_string($_POST["versCN"]); |
141 | $distname = abs(intval($_POST["distName"])); |
141 | $distname = abs(intval($_POST["distName"])); |
142 | 142 | ||
143 | $res =& $db->query("INSERT INTO version SET dist_id='$distname', vname='$versname', version='$versnumb', vcodename='$verscode'"); |
143 | $res =& $db->query("INSERT INTO version SET dist_id='$distname', vname='$versname', version='$versnumb', vcodename='$verscode'"); |
144 | 144 | ||
145 | break; |
145 | break; |
146 | case '5': |
146 | case '5': |
147 | // Правка имеющейся версии дистрибутива
|
147 | // Правка имеющейся версии дистрибутива
|
148 | $versname = mysql_real_escape_string($_POST["versNam"]); |
148 | $versname = mysql_real_escape_string($_POST["versNam"]); |
149 | $versnumb = mysql_real_escape_string($_POST["versNum"]); |
149 | $versnumb = mysql_real_escape_string($_POST["versNum"]); |
150 | $verscode = mysql_real_escape_string($_POST["versCN"]); |
150 | $verscode = mysql_real_escape_string($_POST["versCN"]); |
151 | $distname = abs(intval($_POST["distName"])); |
151 | $distname = abs(intval($_POST["distName"])); |
152 | $versID = abs(intval($_POST["versID"])); |
152 | $versID = abs(intval($_POST["versID"])); |
153 | 153 | ||
154 | $res =& $db->query("UPDATE version SET dist_id='$distname', vname='$versname', version='$versnumb', vcodename='$verscode' WHERE version_id='$versID'"); |
154 | $res =& $db->query("UPDATE version SET dist_id='$distname', vname='$versname', version='$versnumb', vcodename='$verscode' WHERE version_id='$versID'"); |
155 | 155 | ||
156 | break; |
156 | break; |
157 | case '6': |
157 | case '6': |
158 | // Удаление существующей версии дистрибутива
|
158 | // Удаление существующей версии дистрибутива
|
159 | $versID = abs(intval($_POST["versID"])); |
159 | $versID = abs(intval($_POST["versID"])); |
160 | 160 | ||
161 | $res =& $db->query("DELETE FROM version WHERE version_id='$versID'"); |
161 | $res =& $db->query("DELETE FROM version WHERE version_id='$versID'"); |
162 | $res =& $db->query("DELETE FROM ver2rep WHERE ver_id='$versID'"); |
162 | $res =& $db->query("DELETE FROM ver2rep WHERE ver_id='$versID'"); |
163 | 163 | ||
164 | break; |
164 | break; |
165 | case '7': |
165 | case '7': |
166 | // Добавление нового репозитория
|
166 | // Добавление нового репозитория
|
167 | $versID = abs(intval($_POST["vers"])); |
167 | $versID = abs(intval($_POST["vers"])); |
168 | $repname = mysql_real_escape_string($_POST["repName"]); |
168 | $repname = mysql_real_escape_string($_POST["repName"]); |
169 | $repinfo = mysql_real_escape_string($_POST["repInfo"]); |
169 | $repinfo = mysql_real_escape_string($_POST["repInfo"]); |
170 | $repsche = abs(intval($_POST["scheme"])); |
170 | $repsche = abs(intval($_POST["scheme"])); |
171 | $reptype = abs(intval($_POST["rtype"])); |
171 | $reptype = abs(intval($_POST["rtype"])); |
172 | 172 | ||
173 | $res =& $db->query("INSERT INTO repository SET repname='$repname', repdescribe='$repinfo', scheme_id='$repsche', rtype_id='$reptype'"); |
173 | $res =& $db->query("INSERT INTO repository SET repname='$repname', repdescribe='$repinfo', scheme_id='$repsche', rtype_id='$reptype'"); |
174 | $res =& $db->query("SELECT rep_id FROM repository ORDER BY rep_id DESC LIMIT 1"); |
174 | $res =& $db->query("SELECT rep_id FROM repository ORDER BY rep_id DESC LIMIT 1"); |
175 | $res->fetchInto($rep, DB_FETCHMODE_ASSOC); |
175 | $res->fetchInto($rep, DB_FETCHMODE_ASSOC); |
176 | $rep_id = $rep["rep_id"]; |
176 | $rep_id = $rep["rep_id"]; |
177 | 177 | ||
178 | $res =& $db->query("INSERT INTO ver2rep SET ver_id='$versID', rep_id='$rep_id'"); |
178 | $res =& $db->query("INSERT INTO ver2rep SET ver_id='$versID', rep_id='$rep_id'"); |
179 | 179 | ||
180 | for ($i=0;$i<count($_POST["sect"]);$i++) { |
180 | for ($i=0;$i<count($_POST["sect"]);$i++) { |
181 | $res =& $db->query("INSERT INTO sect2rep SET sect_id='".$_POST["sect"][$i]."', rep_id='$rep_id'"); |
181 | $res =& $db->query("INSERT INTO sect2rep SET sect_id='".$_POST["sect"][$i]."', rep_id='$rep_id'"); |
182 | }
|
182 | }
|
183 | break; |
183 | break; |
184 | case '8': |
184 | case '8': |
185 | // Правка репозитория
|
185 | // Правка репозитория
|
186 | $repID = abs(intval($_POST["rep"])); |
186 | $repID = abs(intval($_POST["rep"])); |
187 | $repname = mysql_real_escape_string($_POST["repName"]); |
187 | $repname = mysql_real_escape_string($_POST["repName"]); |
188 | $repinfo = mysql_real_escape_string($_POST["repInfo"]); |
188 | $repinfo = mysql_real_escape_string($_POST["repInfo"]); |
189 | $repsche = abs(intval($_POST["scheme"])); |
189 | $repsche = abs(intval($_POST["scheme"])); |
190 | $reptype = abs(intval($_POST["rtype"])); |
190 | $reptype = abs(intval($_POST["rtype"])); |
191 | 191 | ||
192 | $res =& $db->query("UPDATE repository SET repname='$repname', repdescribe='$repinfo', scheme_id='$repsche', rtype_id='$reptype' WHERE rep_id='$repID'"); |
192 | $res =& $db->query("UPDATE repository SET repname='$repname', repdescribe='$repinfo', scheme_id='$repsche', rtype_id='$reptype' WHERE rep_id='$repID'"); |
193 | $res =& $db->query("DELETE FROM sect2rep WHERE rep_id='$repID'"); |
193 | $res =& $db->query("DELETE FROM sect2rep WHERE rep_id='$repID'"); |
194 | for ($i=0;$i<count($_POST["sect"]);$i++) { |
194 | for ($i=0;$i<count($_POST["sect"]);$i++) { |
195 | $res =& $db->query("INSERT INTO sect2rep SET sect_id='".$_POST["sect"][$i]."', rep_id='$repID'"); |
195 | $res =& $db->query("INSERT INTO sect2rep SET sect_id='".$_POST["sect"][$i]."', rep_id='$repID'"); |
196 | }
|
196 | }
|
197 | break; |
197 | break; |
198 | case '9': |
198 | case '9': |
199 | // Удаление репозитория
|
199 | // Удаление репозитория
|
200 | $repID = abs(intval($_POST["rep"])); |
200 | $repID = abs(intval($_POST["rep"])); |
201 | 201 | ||
202 | $res =& $db->query("DELETE FROM repository WHERE rep_id='$repID'"); |
202 | $res =& $db->query("DELETE FROM repository WHERE rep_id='$repID'"); |
203 | $res =& $db->query("DELETE FROM sect2rep WHERE rep_id='$repID'"); |
203 | $res =& $db->query("DELETE FROM sect2rep WHERE rep_id='$repID'"); |
204 | $res =& $db->query("DELETE FROM ver2rep WHERE rep_id='$repID'"); |
204 | $res =& $db->query("DELETE FROM ver2rep WHERE rep_id='$repID'"); |
205 | 205 | ||
206 | break; |
206 | break; |
207 | case '10': |
207 | case '10': |
208 | // Создание секции
|
208 | // Создание секции
|
209 | $sectname = mysql_real_escape_string($_POST["sectName"]); |
209 | $sectname = mysql_real_escape_string($_POST["sectName"]); |
210 | $sectinfo = mysql_real_escape_string($_POST["sectInfo"]); |
210 | $sectinfo = mysql_real_escape_string($_POST["sectInfo"]); |
211 | 211 | ||
212 | $req =& $db->query("INSERT INTO section SET sectname='$sectname', sectinfo='$sectinfo'"); |
212 | $req =& $db->query("INSERT INTO section SET sectname='$sectname', sectinfo='$sectinfo'"); |
213 | $req =& $db->query("SELECT sect_id FROM section ORDER BY sect_id DESC LIMIT 1"); |
213 | $req =& $db->query("SELECT sect_id FROM section ORDER BY sect_id DESC LIMIT 1"); |
214 | $req->fetchInto($sect, DB_FETCHMODE_ASSOC); |
214 | $req->fetchInto($sect, DB_FETCHMODE_ASSOC); |
215 | 215 | ||
216 | for($i=0;$i<count($_POST["dist"]);$i++) { |
216 | for($i=0;$i<count($_POST["dist"]);$i++) { |
217 | $req =& $db->query("INSERT INTO sect2dist SET dist_id='".$_POST["dist"][$i]."', sect_id='".$sect["sect_id"]."'"); |
217 | $req =& $db->query("INSERT INTO sect2dist SET dist_id='".$_POST["dist"][$i]."', sect_id='".$sect["sect_id"]."'"); |
218 | }
|
218 | }
|
219 | 219 | ||
220 | break; |
220 | break; |
221 | case '11': |
221 | case '11': |
222 | // Правка секции
|
222 | // Правка секции
|
223 | $sectID = abs(intval($_POST["sectID"])); |
223 | $sectID = abs(intval($_POST["sectID"])); |
224 | $sectname = mysql_real_escape_string($_POST["sectName"]); |
224 | $sectname = mysql_real_escape_string($_POST["sectName"]); |
225 | $sectinfo = mysql_real_escape_string($_POST["sectInfo"]); |
225 | $sectinfo = mysql_real_escape_string($_POST["sectInfo"]); |
226 | 226 | ||
227 | $req =& $db->query("UPDATE section SET sectname='$sectname', sectinfo='$sectinfo' WHERE sect_id='$sectID'"); |
227 | $req =& $db->query("UPDATE section SET sectname='$sectname', sectinfo='$sectinfo' WHERE sect_id='$sectID'"); |
228 | $req =& $db->query("DELETE FROM sect2dist WHERE sect_id='$sectID'"); |
228 | $req =& $db->query("DELETE FROM sect2dist WHERE sect_id='$sectID'"); |
229 | 229 | ||
230 | for($i=0;$i<count($_POST["dist"]);$i++) { |
230 | for($i=0;$i<count($_POST["dist"]);$i++) { |
231 | $req =& $db->query("INSERT INTO sect2dist SET dist_id='".$_POST["dist"][$i]."', sect_id='".$sectID."'"); |
231 | $req =& $db->query("INSERT INTO sect2dist SET dist_id='".$_POST["dist"][$i]."', sect_id='".$sectID."'"); |
232 | }
|
232 | }
|
233 | 233 | ||
234 | break; |
234 | break; |
235 | case '12': |
235 | case '12': |
236 | // Удаление секции
|
236 | // Удаление секции
|
237 | $sectID = abs(intval($_POST["sectID"])); |
237 | $sectID = abs(intval($_POST["sectID"])); |
238 | 238 | ||
239 | $req =& $db->query("DELETE FROM section WHERE sect_id='$sectID'"); |
239 | $req =& $db->query("DELETE FROM section WHERE sect_id='$sectID'"); |
240 | $req =& $db->query("DELETE FROM sect2dist WHERE sect_id='$sectID'"); |
240 | $req =& $db->query("DELETE FROM sect2dist WHERE sect_id='$sectID'"); |
241 | $req =& $db->query("DELETE FROM sect2rep WHERE sect_id='$sectID'"); |
241 | $req =& $db->query("DELETE FROM sect2rep WHERE sect_id='$sectID'"); |
242 | 242 | ||
243 | break; |
243 | break; |
244 | case '13': |
244 | case '13': |
245 | // Добавление новой схемы
|
245 | // Добавление новой схемы
|
246 | $scheme = mysql_real_escape_string($_POST["scheme"]); |
246 | $scheme = mysql_real_escape_string($_POST["scheme"]); |
247 | 247 | ||
248 | $req =& $db->query("INSERT INTO scheme SET scheme='$scheme'"); |
248 | $req =& $db->query("INSERT INTO scheme SET scheme='$scheme'"); |
249 | 249 | ||
250 | break; |
250 | break; |
251 | case '14': |
251 | case '14': |
252 | // Правка схемы
|
252 | // Правка схемы
|
253 | $schemeID = abs(intval($_POST["schemeID"])); |
253 | $schemeID = abs(intval($_POST["schemeID"])); |
254 | $scheme = mysql_real_escape_string($_POST["scheme"]); |
254 | $scheme = mysql_real_escape_string($_POST["scheme"]); |
255 | 255 | ||
256 | $req =& $db->query("UPDATE scheme SET scheme='$scheme' WHERE scheme_id='$schemeID'"); |
256 | $req =& $db->query("UPDATE scheme SET scheme='$scheme' WHERE scheme_id='$schemeID'"); |
257 | 257 | ||
258 | break; |
258 | break; |
259 | case '15': |
259 | case '15': |
260 | // Удаление схемы
|
260 | // Удаление схемы
|
261 | $schemeID = abs(intval($_POST["schemeID"])); |
261 | $schemeID = abs(intval($_POST["schemeID"])); |
262 | 262 | ||
263 | $req =& $db->query("DELETE FROM scheme WHERE scheme_id='$schemeID'"); |
263 | $req =& $db->query("DELETE FROM scheme WHERE scheme_id='$schemeID'"); |
264 | 264 | ||
265 | break; |
265 | break; |
266 | case '16': |
266 | case '16': |
267 | // Добавление новой настройки Ant
|
267 | // Добавление новой настройки Ant
|
268 | $option = mysql_real_escape_string($_POST["setoption"]); |
268 | $option = mysql_real_escape_string($_POST["setoption"]); |
269 | $value = mysql_real_escape_string($_POST["setvalue"]); |
269 | $value = mysql_real_escape_string($_POST["setvalue"]); |
270 | 270 | ||
271 | $req =& $db->query("INSERT INTO settings SET opt='$option', optvalue='$value'"); |
271 | $req =& $db->query("INSERT INTO settings SET opt='$option', optvalue='$value'"); |
272 | 272 | ||
273 | break; |
273 | break; |
274 | case '17': |
274 | case '17': |
275 | // Правка настройки Ant
|
275 | // Правка настройки Ant
|
276 | $optID = abs(intval($_POST["optID"])); |
276 | $optID = abs(intval($_POST["optID"])); |
277 | $option = mysql_real_escape_string($_POST["setoption"]); |
277 | $option = mysql_real_escape_string($_POST["setoption"]); |
278 | $value = mysql_real_escape_string($_POST["setvalue"]); |
278 | $value = mysql_real_escape_string($_POST["setvalue"]); |
279 | 279 | ||
280 | $req =& $db->query("UPDATE settings SET opt='$option', optvalue='$value' WHERE opt_id='$optID'"); |
280 | $req =& $db->query("UPDATE settings SET opt='$option', optvalue='$value' WHERE opt_id='$optID'"); |
281 | 281 | ||
282 | break; |
282 | break; |
283 | case '18': |
283 | case '18': |
284 | // Удаление настройки
|
284 | // Удаление настройки
|
285 | $optID = abs(intval($_POST["optID"])); |
285 | $optID = abs(intval($_POST["optID"])); |
286 | 286 | ||
287 | $req =& $db->query("DELETE FROM settings WHERE opt_id='$optID'"); |
287 | $req =& $db->query("DELETE FROM settings WHERE opt_id='$optID'"); |
288 | 288 | ||
289 | break; |
289 | break; |
290 | case '19': |
290 | case '19': |
291 | // Добавление нового типа репозитория
|
291 | // Добавление нового типа репозитория
|
292 | $rtype = mysql_real_escape_string($_POST["rtype"]); |
292 | $rtype = mysql_real_escape_string($_POST["rtype"]); |
293 | 293 | ||
294 | $req =& $db->query("INSERT INTO rtype SET rtype='$rtype'"); |
294 | $req =& $db->query("INSERT INTO rtype SET rtype='$rtype'"); |
295 | 295 | ||
296 | break; |
296 | break; |
297 | case '20': |
297 | case '20': |
298 | // Правка существующего типа репозитория
|
298 | // Правка существующего типа репозитория
|
299 | $rtypeID = abs(intval($_POST["rtypeID"])); |
299 | $rtypeID = abs(intval($_POST["rtypeID"])); |
300 | $rtype = mysql_real_escape_string($_POST["rtype"]); |
300 | $rtype = mysql_real_escape_string($_POST["rtype"]); |
301 | 301 | ||
302 | $req =& $db->query("UPDATE rtype SET rtype='$rtype' WHERE rtype_id='$rtypeID'"); |
302 | $req =& $db->query("UPDATE rtype SET rtype='$rtype' WHERE rtype_id='$rtypeID'"); |
303 | 303 | ||
304 | break; |
304 | break; |
305 | case '21': |
305 | case '21': |
306 | // Удаление типа репозитория
|
306 | // Удаление типа репозитория
|
307 | $rtypeID = abs(intval($_POST["rtypeID"])); |
307 | $rtypeID = abs(intval($_POST["rtypeID"])); |
308 | 308 | ||
309 | $req =& $db->query("DELETE FROM rtype WHERE rtype_id='$rtypeID'"); |
309 | $req =& $db->query("DELETE FROM rtype WHERE rtype_id='$rtypeID'"); |
310 | 310 | ||
311 | break; |
311 | break; |
312 | case '22': |
312 | case '22': |
313 | // Смена пароля
|
313 | // Смена пароля
|
314 | // $OID = abs(intval($_POST["OID"]));
|
314 | // $OID = abs(intval($_POST["OID"]));
|
315 | $oldpass = mysql_real_escape_string($_POST["oldPW"]); |
315 | $oldpass = mysql_real_escape_string($_POST["oldPW"]); |
316 | $newpass1 = mysql_real_escape_string($_POST["newPW1"]); |
316 | $newpass1 = mysql_real_escape_string($_POST["newPW1"]); |
317 | $newpass2 = mysql_real_escape_string($_POST["newPW2"]); |
317 | $newpass2 = mysql_real_escape_string($_POST["newPW2"]); |
318 | 318 | ||
319 | $errpwd = 0; |
319 | $errpwd = 0; |
320 | $spass = md5($newpass1."ANT"); |
320 | $spass = md5($newpass1."ANT"); |
321 | $soldpass = md5($oldpass."ANT"); |
321 | $soldpass = md5($oldpass."ANT"); |
322 | if ($soldpass != $_COOKIE[$CookiePasswd]) { |
322 | if ($soldpass != $_COOKIE[$CookiePasswd]) { |
323 | $go .= "?error=1"; |
323 | $go .= "?error=1"; |
324 | $errpwd = 1; |
324 | $errpwd = 1; |
325 | }
|
325 | }
|
326 | if ($newpass1 != $newpass2) { |
326 | if ($newpass1 != $newpass2) { |
327 | $go .= "?error=2"; |
327 | $go .= "?error=2"; |
328 | $errpwd = 2; |
328 | $errpwd = 2; |
329 | }
|
329 | }
|
330 | 330 | ||
331 | if ($errpwd==0) { |
331 | if ($errpwd==0) { |
332 | // fix: Для многопользовательского варианта придется запрос переписать
|
332 | // fix: Для многопользовательского варианта придется запрос переписать
|
333 | $req =& $db->query("UPDATE owner SET passwd='$spass' WHERE login='admin'"); |
333 | $req =& $db->query("UPDATE owner SET passwd='$spass' WHERE login='admin'"); |
334 | }
|
334 | }
|
335 | 335 | ||
336 | break; |
336 | break; |
337 | case '23': |
337 | case '23': |
338 | // Добавление интерфейса
|
338 | // Добавление интерфейса
|
339 | $ifname = mysql_real_escape_string($_POST["ifname"]); |
339 | $ifname = mysql_real_escape_string($_POST["ifname"]); |
340 | $ifinfo = mysql_real_escape_string($_POST["ifinfo"]); |
340 | $ifinfo = mysql_real_escape_string($_POST["ifinfo"]); |
341 | $ifname = str_replace(".php","",$ifname); |
341 | $ifname = str_replace(".php","",$ifname); |
342 | $req =& $db->query("INSERT INTO interfaces SET interface='$ifname', interfaceinfo='$ifinfo'"); |
342 | $req =& $db->query("INSERT INTO interfaces SET interface='$ifname', interfaceinfo='$ifinfo'"); |
343 | break; |
343 | break; |
344 | case '24': |
344 | case '24': |
345 | // Правка интерфейса
|
345 | // Правка интерфейса
|
346 | $ifname = mysql_real_escape_string($_POST["ifname"]); |
346 | $ifname = mysql_real_escape_string($_POST["ifname"]); |
347 | $ifinfo = mysql_real_escape_string($_POST["ifinfo"]); |
347 | $ifinfo = mysql_real_escape_string($_POST["ifinfo"]); |
348 | $if = abs(intval($_POST["if"])); |
348 | $if = abs(intval($_POST["if"])); |
349 | $ifname = str_replace(".php","",$ifname); |
349 | $ifname = str_replace(".php","",$ifname); |
350 | $req =& $db->query("UPDATE interfaces SET interface='$ifname', interfaceinfo='$ifinfo' WHERE if_id='$if'"); |
350 | $req =& $db->query("UPDATE interfaces SET interface='$ifname', interfaceinfo='$ifinfo' WHERE if_id='$if'"); |
351 | break; |
351 | break; |
352 | case '25': |
352 | case '25': |
353 | // Удаление интерфейса
|
353 | // Удаление интерфейса
|
354 | $if = abs(intval($_POST["if"])); |
354 | $if = abs(intval($_POST["if"])); |
355 | $req =& $db->query("DELETE FROM interfaces WHERE if_id='$if'"); |
355 | $req =& $db->query("DELETE FROM interfaces WHERE if_id='$if'"); |
356 | break; |
356 | break; |
357 | }
|
357 | }
|
358 | 358 | ||
359 | header("Location: $go\n\n"); |
359 | header("Location: $go\n\n"); |
360 | 360 | ||
361 | ?>
|
361 | ?>
|
362 | 362 |