Хранилища Subversion ant

Редакция

Редакция 83 | Редакция 93 | К новейшей редакции | Содержимое файла | Сравнить с предыдущей | Последнее изменение | Открыть журнал | RSS

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