WebSVN - ant - Авторство - Редакция 671

Редакция	Автор	№ строки	Строка
304	alex-w	1	<?php
		2
		3	/**
		4	*
554	alex-w	5	* Codename: ant-ng - generator of sources.list for apt-distributives
304	alex-w	6	* http://alex-w.org.ru/p/antng/
		7	*
		8	* Copyright (c) 2009 Alexander Wolf
		9	* Dual licensed under the MIT and GNU LGPL licenses.
		10	* http://alex-w.org.ru/p/antng/license
		11	*
		12	*/
		13
		14	class Core {
308	alex-w	15	protected $db = NULL;
		16	protected $prefix = NULL;
313	alex-w	17	protected $secure = NULL;
359	alex-w	18	protected $cookie = NULL;
304	alex-w	19
463	alex-w	20	/**
		21	* Конструктор класса Core - ядро генератора
		22	*
		23	* @author Alexander Wolf
		24	* @category Core
		25	*
		26	* @param string $database
		27	* @param string $prefix
		28	* @param object $secure
		29	* @param string $cookie
		30	*/
368	alex-w	31	public function __construct($database, $prefix, $secure, $cookie) {
308	alex-w	32	$this->db = $database;
		33	$this->prefix = $prefix;
359	alex-w	34	$this->secure = $secure;
		35	$this->cookie = $cookie;
307	alex-w	36	}
		37
463	alex-w	38	/**
		39	* Получение данных о настройке
		40	*
		41	* @author Alexander Wolf
		42	* @category Core
		43	*
		44	* @param string $attr
		45	* @return array
		46	*/
368	alex-w	47	public function getOption($attr) {
308	alex-w	48	$result = array();
315	alex-w	49	$query = "SELECT optvalue FROM ".$this->prefix."settings WHERE opt='".$this->secure->checkStr($attr)."'";
314	alex-w	50	$rq =& $this->db->query($query);
308	alex-w	51	if ($rq->numRows()!=0) {
		52	$rq->fetchInto($element);
		53	$result["ERR"] = 0;
		54	$result["OptValue"] = $element["optvalue"];
		55	} else {
		56	$result["ERR"] = 1;
		57	$result["ERRINFO"] = "Empty result";
		58	}
		59	return $result;
		60	}
		61
463	alex-w	62	/**
		63	* Установка данных о настройке
		64	*
		65	* @author Alexander Wolf
		66	* @category Core
		67	*
		68	* @param string $attr
		69	* @param string $value
		70	* @return array
		71	*/
368	alex-w	72	public function setOption($attr, $value) {
359	alex-w	73	$result = array();
		74
		75	if ($attr != "passwd") {
		76	$sValue = $this->secure->checkStr($value);
		77	} else {
		78	$sValue = $value;
		79	}
		80
		81	$query = "UPDATE ".$this->prefix."settings SET optvalue='".$sValue."' WHERE opt='".$attr."'";
		82	$rq =& $this->db->query($query);
		83	if (PEAR::isError($this->db)) {
		84	$result["ERR"] = 1;
		85	$result["ERRINFO"] = $this->db->getMessage();
		86	} else {
		87	$result["ERR"] = 0;
		88	}
		89
		90	return $result;
		91	}
		92
463	alex-w	93	/**
		94	* Создание настройки
		95	*
		96	* @author Alexander Wolf
		97	* @category Core
		98	*
		99	* @param string $attr
		100	* @param string $value
		101	* @return array
		102	*/
368	alex-w	103	public function addOption($attr, $value) {
359	alex-w	104	$result = array();
		105	$sValue = $this->secure->checkStr($value);
		106
		107	$query = "INSERT INTO ".$this->prefix."settings SET opt='".$attr."', optvalue='".$sValue."'";
		108	$rq =& $this->db->query($query);
		109	if (PEAR::isError($this->db)) {
		110	$result["ERR"] = 1;
		111	$result["ERRINFO"] = $this->db->getMessage();
		112	} else {
		113	$result["ERR"] = 0;
		114	}
		115
		116	return $result;
		117	}
463	alex-w	118
		119	/**
467	alex-w	120	* Получение и отображение списка дистрибутвов
463	alex-w	121	*
		122	* @author Alexander Wolf
		123	* @category Core
		124	* @deprecated may be deprecated XXX
		125	*
		126	* @param string $name
		127	* @param string $heads
		128	* @param string $info
		129	* @param string $format
		130	* @return string
		131	*/
393	alex-w	132	public function showDistributionList($name, $heads = "", $info = "", $format = 'html') {
315	alex-w	133	$query = "SELECT * FROM ".$this->prefix."distribution ORDER BY dist_id ASC";
317	alex-w	134	$rq =& $this->db->query($query);
315	alex-w	135	switch ($format) {
		136	case 'html':
394	alex-w	137	$show = "<fieldset><legend>".$heads."</legend>\n<select id='".$name."' name='".$name."'>\n";
390	alex-w	138	$show .= "<option value=''>".$info."</option>\n";
315	alex-w	139	while ($rq->fetchInto($element)) {
		140	$show .= "<option value='".$this->secure->checkInt($element["dist_id"])."'>".$this->secure->checkStr($element["distname"],1)."</option>\n";
		141	}
317	alex-w	142	$show .= "</select></fieldset>";
315	alex-w	143	break;
		144	case 'json':
317	alex-w	145	$show = '[{value:"",text:"'.$info.'"}';
315	alex-w	146	while ($rq->fetchInto($element)) {
		147	$show .= ',{value:"'.$this->secure->checkInt($element["dist_id"]).'",text:"'.$this->secure->checkStr($element["distname"],1).'"}';
		148	}
		149	$show .= ']';
		150	break;
504	alex-w	151	case 'innerhtml':
		152	$show = "<select id='".$name."' name='".$name."'>\n";
		153	while ($rq->fetchInto($element)) {
		154	$show .= "<option value='".$this->secure->checkInt($element["dist_id"])."'>".$this->secure->checkStr($element["distname"],1)."</option>\n";
		155	}
		156	$show .= "</select>";
		157	break;
506	alex-w	158	case 'list':
		159	$show = "<ul>";
		160	while ($rq->fetchInto($element)) {
546	alex-w	161	$show .= "<li>[<a href='".$heads."?mode=".$name."&action=edit&uuid=".$this->secure->checkInt($element["dist_id"])."' class='edit'>править</a>][<a href='".$heads."?mode=".$name."&action=delete&uuid=".$this->secure->checkInt($element["dist_id"])."' class='delete'>удалить</a>] ".$this->secure->checkStr($element["distname"],1)."</li>\n";
506	alex-w	162	}
		163	$show .= "</ul>";
		164	break;
315	alex-w	165	}
		166	return $show;
		167	}
		168
463	alex-w	169	/**
		170	* Получение названия дистрибутива
		171	*
		172	* @author Alexander Wolf
		173	* @category Core
		174	*
		175	* @param integer $distID
		176	* @return array
		177	*/
368	alex-w	178	public function getDistName($distID) {
315	alex-w	179	$result = array();
		180	$query = "SELECT distname FROM ".$this->prefix."distribution WHERE dist_id='".$this->secure->checkInt($distID)."'";
		181	$rq =& $this->db->query($query);
		182	if (PEAR::isError($this->db)) {
		183	$result["ERR"] = 1;
		184	$result["ERRINFO"] = $this->db->getMessage();
		185	} else {
		186	$rq->fetchInto($element);
		187	$result["ERR"] = 0;
		188	$result["DistName"] = $this->secure->checkStr($element["distname"],1);
		189	}
		190
		191	return $result;
		192	}
		193
463	alex-w	194	/**
		195	* Получение названия программы, ее версии и описания
		196	*
		197	* @author Alexander Wolf
		198	* @category Core
		199	*
		200	* @param string $attr
		201	* @return string
		202	*/
383	alex-w	203	public function getEngineAttr($attr = 'codename') {
		204	$cname = $this->getOption($attr);
382	alex-w	205	return $this->secure->checkStr($cname["OptValue"],1);
381	alex-w	206	}
		207
463	alex-w	208	/**
		209	* Получение и отображение списка версий дистрибутива
		210	*
		211	* @author Alexander Wolf
		212	* @category Core
		213	*
		214	* @param string $name
		215	* @param integer $distID
		216	* @param string $format
		217	* @return string
		218	*/
509	alex-w	219	public function showDistVersionsList($name, $distID, $format = 'html', $actor = '') {
316	alex-w	220	$distname = $this->getDistName($distID);
509	alex-w	221	if ($distID == 0) {
		222	$query = "SELECT * FROM ".$this->prefix."version v JOIN ".$this->prefix."distribution d ON v.dist_id=d.dist_id ORDER BY d.dist_id,v.version ASC";
		223	} else {
		224	$query = "SELECT * FROM ".$this->prefix."version WHERE dist_id='".$this->secure->checkInt($distID)."' ORDER BY version ASC";
		225	}
317	alex-w	226	$rq =& $this->db->query($query);
315	alex-w	227	switch ($format) {
		228	case 'html':
394	alex-w	229	$show = "<fieldset><legend>Версии ".$distname["DistName"]."</legend>\n<select id='".$name."' name='".$name."'>\n";
		230	$show .= "<option value=''>Выбери версию ".$distname["DistName"]."</option>\n";
315	alex-w	231	while ($rq->fetchInto($element)) {
316	alex-w	232	$show .= "<option value='".$this->secure->checkInt($element["version_id"])."'>".$this->secure->checkStr($element["version"],1)." ".$this->secure->checkStr($element["vname"],1)."</option>\n";
315	alex-w	233	}
317	alex-w	234	$show .= "</select></fieldset>";
315	alex-w	235	break;
		236	case 'json':
317	alex-w	237	$show = '[{value:"",text:"Выбери версию '.$distname["DistName"].'"}';
315	alex-w	238	while ($rq->fetchInto($element)) {
316	alex-w	239	$show .= ',{value:"'.$this->secure->checkInt($element["version_id"]).'",text:"'.$this->secure->checkStr($element["version"],1).' '.$this->secure->checkStr($element["vname"],1).'"}';
315	alex-w	240	}
		241	$show .= ']';
		242	break;
509	alex-w	243	case 'list':
		244	$show = "<ul>\n";
		245	while ($rq->fetchInto($element)) {
545	alex-w	246	$show .= "<li>[<a href='".$actor."?mode=".$name."&action=edit&uuid=".$this->secure->checkInt($element["version_id"])."' class='edit'>править</a>][<a href='".$actor."?mode=".$name."&action=delete&uuid=".$this->secure->checkInt($element["version_id"])."' class='delete'>удалить</a>] ".$this->secure->checkStr($element["distname"],1)." ".$this->secure->checkStr($element["version"],1)." “<em>".$this->secure->checkStr($element["vname"],1)."</em>”</li>\n";
509	alex-w	247	}
		248	$show .= "</ul>";
		249	break;
315	alex-w	250	}
		251	return $show;
		252	}
		253
463	alex-w	254	/**
		255	* Получение и отображение списка секций основного (официального) репозитория
		256	*
		257	* @author Alexander Wolf
		258	* @category Core
		259	*
		260	* @param integer $version
		261	* @param string $format
		262	* @return string
		263	*/
368	alex-w	264	public function showBranchesList($version, $format = 'html') {
317	alex-w	265	$query = "SELECT rtype FROM ".$this->prefix."rtype WHERE rtype_id='1'";
		266	$rq =& $this->db->query($query);
		267	$rq->fetchInto($types);
		268	$query = "SELECT s.*,t.rtype FROM ".$this->prefix."section s ";
		269	$query .= "JOIN ".$this->prefix."sect2rep l ON s.sect_id=l.sect_id ";
		270	$query .= "JOIN ".$this->prefix."repository r ON r.rep_id=l.rep_id ";
		271	$query .= "JOIN ".$this->prefix."rtype t ON r.rtype_id=t.rtype_id ";
627	alex-w	272	$query .= "WHERE t.rtype_id='1' AND r.version='".$this->secure->checkInt($version)."' ";
		273	$query .= "ORDER BY s.sect_id ASC";
317	alex-w	274	$rq =& $this->db->query($query);
		275	switch ($format) {
		276	case 'html':
		277	$show = "<fieldset><legend>".$this->secure->checkStr($types["rtype"],1)."</legend>\n";
		278	while ($rq->fetchInto($element)) {
493	alex-w	279	$show .= "<div class='sections'><input type='checkbox' name='section[]' value='".$element["sect_id"]."'> ".$this->secure->checkStr($element["secname"],1)." — ".$this->secure->checkStr($element["sectinfo"],1)."</div>\n";
317	alex-w	280	}
		281	$show .= "</fieldset>\n";
		282	break;
		283	case 'json':
		284	//TODO Доделать JSON-вывод списка секций основного репозитория
		285	break;
		286	}
318	alex-w	287
		288	return $show;
317	alex-w	289	}
		290
463	alex-w	291	/**
		292	* Получение и отображение списка репозиториев
		293	*
		294	* @author Alexander Wolf
		295	* @category Core
		296	*
		297	* @param integer $version
		298	* @param integer $reptype
		299	* @param string $format
		300	* @return string
		301	*/
368	alex-w	302	public function showRepList($version, $reptype, $format = 'html') {
606	alex-w	303	$query = "SELECT rtype FROM ".$this->prefix."rtype WHERE rtype_id='".$this->secure->checkInt($reptype)."'";
		304	$rq =& $this->db->query($query);
		305	$rq->fetchInto($types);
317	alex-w	306	$query = "SELECT * FROM ".$this->prefix."repository WHERE version='".$this->secure->checkInt($version)."' AND rtype_id='".$this->secure->checkInt($reptype)."'";
		307	$rq =& $this->db->query($query);
		308	switch ($format) {
		309	case 'html':
607	alex-w	310	$show = "<fieldset><legend>".$this->secure->checkStr($types["rtype"],1)."</legend>\n";
		311	while ($rq->fetchInto($element)) {
320	alex-w	312	$show .= "<div class='repository'><input type='checkbox' name='repository[]' value='".$element["rep_id"]."'> ".$this->secure->checkStr($element["repname"],1)." — ".$this->secure->checkStr($element["repinfo"],1)."</div>\n";
317	alex-w	313	}
		314	$show .= "</fieldset>\n";
		315	break;
		316	case 'json':
		317	//TODO Доделать JSON-вывод списка репозиториев
		318	break;
		319	}
318	alex-w	320
		321	return $show;
317	alex-w	322	}
		323
463	alex-w	324	/**
		325	* Добавление поддержки нового apt-дистрибутива
		326	*
		327	* @author Alexander Wolf
		328	* @category Core
		329	*
		330	* @param string $distname
		331	* @param integer $disttype
		332	* @param string $distua
		333	* @param byte $distlogo
		334	* @return array
		335	*/
514	alex-w	336	public function addDistribution($distname, $disttype, $distua = '', $distlogo = 0) {
321	alex-w	337	$result = array();
582	alex-w	338	$sDName = $this->secure->checkStr($distname);
321	alex-w	339	$sDType = $this->secure->checkInt($disttype);
582	alex-w	340	$sDUAgt = $this->secure->checkStr($distua);
514	alex-w	341	$sDLogo = $this->secure->checkInt($distlogo);
321	alex-w	342
		343	$query = "INSERT INTO ".$this->prefix."distribution SET distname='".$sDName."', distua='".$sDUAgt."', disttype='".$sDType."', distlogo='".$sDLogo."'";
		344	$rq =& $this->db->query($query);
		345	if (PEAR::isError($this->db)) {
		346	$result["ERR"] = 1;
		347	$result["ERRINFO"] = $this->db->getMessage();
515	alex-w	348	} else {
321	alex-w	349	$result["ERR"] = 0;
		350	}
		351
		352	return $result;
		353	}
		354
463	alex-w	355	/**
514	alex-w	356	* Обновление информации о дистрибутиве
		357	*
		358	* @author Alexander Wolf
		359	* @category Core
		360	*
		361	* @param integer $distID
		362	* @param string $distname
		363	* @param integer $disttype
		364	* @param string $distua
		365	* @param integer $distlogo
		366	* @return array
		367	*/
538	alex-w	368	public function updateDistribution($distID, $distname, $disttype, $distua, $distlogo = 0) {
514	alex-w	369	$result = array();
		370	$sDID = $this->secure->checkInt($distID);
579	alex-w	371	$sDName = $this->secure->checkStr($distname);
514	alex-w	372	$sDType = $this->secure->checkInt($disttype);
579	alex-w	373	$sDUAgt = $this->secure->checkStr($distua);
514	alex-w	374	$sDLogo = $this->secure->checkInt($distlogo);
		375
538	alex-w	376	if ($sDLogo!=0) {
		377	$query = "UPDATE ".$this->prefix."distribution SET distname='".$sDName."', distua='".$sDUAgt."', disttype='".$sDType."', distlogo='".$sDLogo."' WHERE dist_id='".$sDID."'";
		378	} else {
		379	$query = "UPDATE ".$this->prefix."distribution SET distname='".$sDName."', distua='".$sDUAgt."', disttype='".$sDType."' WHERE dist_id='".$sDID."'";
		380	}
514	alex-w	381	$rq =& $this->db->query($query);
		382	if (PEAR::isError($this->db)) {
		383	$result["ERR"] = 1;
		384	$result["ERRINFO"] = $this->db->getMessage();
515	alex-w	385	} else {
514	alex-w	386	$result["ERR"] = 0;
		387	}
		388
		389	return $result;
		390	}
		391
		392	/**
		393	* Удаление информации о дистрибутиве
		394	*
		395	* @author Alexander Wolf
		396	* @category Core
		397	*
		398	* @param integer $distID
		399	* @return array
		400	*/
		401	public function dropDistribution($distID) {
		402	$result = array();
		403	$sDID = $this->secure->checkInt($distID);
		404
		405	// Удаление дистрибутива
		406	$query = "DELETE FROM ".$this->prefix."distribution WHERE dist_id='".$sDID."'";
		407	$rq =& $this->db->query($query);
		408	if (PEAR::isError($this->db)) {
		409	$result["ERR"] = 1;
		410	$result["ERRINFO"] = $this->db->getMessage();
519	alex-w	411	} else {
514	alex-w	412	$result["ERR"] = 0;
		413	}
		414
		415	// Удаление версий дистрибутива
		416	$query = "DELETE FROM ".$this->prefix."version WHERE dist_id='".$sDID."'";
		417	$rq =& $this->db->query($query);
		418	if (PEAR::isError($this->db)) {
		419	$result["ERR"] = 1;
		420	$result["ERRINFO"] = $this->db->getMessage();
519	alex-w	421	} else {
514	alex-w	422	$result["ERR"] = 0;
		423	}
		424
		425	return $result;
		426	}
		427
		428	/**
463	alex-w	429	* Добавление поддержки новой версии apt-дистрибутива
		430	*
		431	* @author Alexander Wolf
		432	* @category Core
		433	*
		434	* @param integer $distID
		435	* @param integer $version
		436	* @param string $vname
		437	* @param integer $vcodename
		438	* @return array
		439	*/
368	alex-w	440	public function addDistVersion($distID, $version, $vname = "", $vcodename = "") {
356	alex-w	441	$result = array();
463	alex-w	442	$sDistID = $this->secure->checkInt($distID);
582	alex-w	443	$sDVersion = $this->secure->checkStr($version);
		444	$sDVName = $this->secure->checkStr($vname);
		445	$sDVCName = $this->secure->checkStr($vcodename);
356	alex-w	446
		447	$query = "INSERT INTO ".$this->prefix."version SET dist_id='".$sDistID."', vname='".$sDVName."', version='".$sDVersion."', vcodename='".$sDVCName."'";
		448	$rq =& $this->db->query($query);
		449	if (PEAR::isError($this->db)) {
		450	$result["ERR"] = 1;
		451	$result["ERRINFO"] = $this->db->getMessage();
515	alex-w	452	} else {
356	alex-w	453	$result["ERR"] = 0;
		454	}
		455
		456	return $result;
		457	}
358	alex-w	458
463	alex-w	459	/**
514	alex-w	460	* Редактирование информации о версии дистрибутива
		461	*
		462	* @author Alexander Wolf
		463	* @category Core
		464	*
		465	* @param integer $versionID
		466	* @param string $version
		467	* @param string $vname
		468	* @param string $vcodename
		469	* @return array
		470	*/
		471	public function updateDistVersion($versionID, $version, $vname = "", $vcodename = "") {
		472	$result = array();
		473	$sVersID = $this->secure->checkInt($versionID);
516	alex-w	474	$sDVersion = $this->secure->checkStr($version,1);
		475	$sDVName = $this->secure->checkStr($vname,1);
		476	$sDVCName = $this->secure->checkStr($vcodename,1);
514	alex-w	477
		478	$query = "UPDATE ".$this->prefix."version SET vname='".$sDVName."', version='".$sDVersion."', vcodename='".$sDVCName."' WHERE version_id='".$sVersID."'";
		479	$rq =& $this->db->query($query);
		480	if (PEAR::isError($this->db)) {
		481	$result["ERR"] = 1;
		482	$result["ERRINFO"] = $this->db->getMessage();
515	alex-w	483	} else {
514	alex-w	484	$result["ERR"] = 0;
		485	}
		486
		487	return $result;
		488	}
		489
		490	/**
		491	* Удаление информации о версии дистрибутива
		492	*
		493	* @author Alexander Wolf
		494	* @category Core
		495	*
		496	* @param integer $versionID
		497	* @return array
		498	*/
		499	public function dropDistVersion($versionID) {
		500	$result = array();
		501	$sVersID = $this->secure->checkInt($versionID);
		502
		503	// Удаление версии дистрибутива
		504	$query = "DELETE FROM ".$this->prefix."version WHERE version_id='".$sVersID."'";
		505	$rq =& $this->db->query($query);
		506	if (PEAR::isError($this->db)) {
		507	$result["ERR"] = 1;
		508	$result["ERRINFO"] = $this->db->getMessage();
515	alex-w	509	} else {
514	alex-w	510	$result["ERR"] = 0;
		511	}
		512
		513	// Удаление репозиториев этой версии дистрибутива
		514	$query = "DELETE FROM ".$this->prefix."repository WHERE version='".$sVersID."'";
		515	$rq =& $this->db->query($query);
		516	if (PEAR::isError($this->db)) {
		517	$result["ERR"] = 1;
		518	$result["ERRINFO"] = $this->db->getMessage();
517	alex-w	519	} else {
514	alex-w	520	$result["ERR"] = 0;
		521	}
		522
		523	return $result;
		524	}
		525
		526	/**
463	alex-w	527	* Отображение типа дистрибутива
		528	*
		529	* @author Alexander Wolf
		530	* @category Core
		531	*
		532	* @param string $name
		533	* @param byte $type
		534	* @return string
		535	*/
368	alex-w	536	public function showDistTypeForm($name = "dtype",$type = 0) {
329	alex-w	537	$query = "SELECT * FROM ".$this->prefix."dtype";
		538	$rq =& $this->db->query($query);
		539	$show = "<select name='".$name."' id='".$name."'>\n";
		540	while ($rq->fetchInto($element)) {
347	alex-w	541	if ($element["type_id"] == $type) {
		542	$show .= "<option value='".$element["type_id"]."' selected>".$this->secure->checkStr($element["type"],1)."</option>\n";
329	alex-w	543	} else {
347	alex-w	544	$show .= "<option value='".$element["type_id"]."'>".$this->secure->checkStr($element["type"],1)."</option>\n";
329	alex-w	545	}
		546	}
		547	$show .= "</select>";
		548
		549	return $show;
		550	}
		551
463	alex-w	552	/**
		553	* Отображение формы создания и редактирования apt-дистрибутива
		554	*
		555	* @author Alexander Wolf
		556	* @category Core
		557	*
		558	* @param integer $distID
		559	* @return string
		560	*/
511	alex-w	561	public function showDistributionForm($distID = 0, $info = '') {
329	alex-w	562	$sDistID = $this->secure->checkInt($distID);
511	alex-w	563	$sInfo = $this->secure->checkStr($info, 1);
		564	if ($sInfo == "") {
		565	$sInfo = "Дистрибутив";
		566	}
329	alex-w	567	if ($sDistID != 0) {
		568	// Режим редактирования
		569	$query = "SELECT * FROM ".$this->prefix."distribution WHERE dist_id='".$sDistID."'";
		570	$rq =& $this->db->query($query);
		571	$rq->fetchInto($element);
		572	}
		573
		574	if ($element["distlogo"] == 1) {
380	alex-w	575	$image = "<img src='./img/d/".$this->secure->checkStr($element["distua"],1).".png' width='32' height='32' id='adm-dist-logo' alt='Логотип дистрибутива ".$this->secure->checkStr($element["distname"],1)."' title='Логотип дистрибутива ".$this->secure->checkStr($element["distname"],1)."'>";
329	alex-w	576	} else {
380	alex-w	577	$image = "<img src='./img/d/empty-logo.png' width='32' height='32' id='adm-dist-logo' alt='Логотип дистрибутива' title='Логотип дистрибутива не загружен'>";
329	alex-w	578	}
		579
511	alex-w	580	$show = "<fieldset><legend>".$sInfo."</legend>\n";
350	alex-w	581	$show .= "<div class='inputbox'><label for='dname'>Название дистрибутива:</label> <input type='text' name='dname' id='dname' value='".$this->secure->checkStr($element["distname"],1)."'></div>\n";
		582	$show .= "<div class='inputbox'><label for='dua'>UA дистрибутива:</label> <input type='text' name='dua' id='dua' value='".$this->secure->checkStr($element["distua"],1)."'></div>\n";
518	alex-w	583	$show .= "<div class='inputbox'><label for='dtype'>Тип дистрибутива:</label> ".$this->showDistTypeForm("dtype",$element["disttype"])."</div>\n";
348	alex-w	584	$show .= "<div class='inputbox'><table><tr><td class='td-name'>Логотип дистрибутива:</td>\n";
329	alex-w	585	$show .= "<td>".$image."</td>\n<td><input type='file' name='distlogo'></td>\n</tr></table>\n</div>\n";
350	alex-w	586	$show .= "<div class='inputbox'><input type='submit' value=' Отправить данные '></div>\n</fieldset>\n";
329	alex-w	587
		588	return $show;
		589	}
		590
628	alex-w	591	/**
		592	* Генератор sources.list
		593	*
		594	* @author Alexander Wolf
		595	* @category Core
		596	* @version 1.0
		597	*
		598	* @param array $data
		599	* @return string
		600	*/
668	alex-w	601	public function showSourcesList($data) {
646	alex-w	602	// Извлекаем информацию о дистрибутиве и его версии
		603	$query = "SELECT * FROM ".$this->prefix."distribution d ";
649	alex-w	604	$query .= "JOIN ".$this->prefix."version v ON v.dist_id=d.dist_id ";
646	alex-w	605	$query .= "JOIN ".$this->prefix."dtype t ON d.disttype=t.type_id ";
648	alex-w	606	$query .= "WHERE d.dist_id='".$data["dist_id"]."' AND v.version_id='".$data["version_id"]."'";
646	alex-w	607	$rq =& $this->db->query($query);
		608	$rq->fetchInto($dist);
663	alex-w	609
653	alex-w	610	$show = "# Список репозиториев для ".$this->secure->checkStr($dist["distname"],1)." ".$this->secure->checkStr($dist["version"],1)." ".$this->secure->checkStr($dist["vname"],1)."\n\n";
646	alex-w	611
		612	// Извлекаем информацию о репозиториях и строим sources.list
		613	if ($dist["type"]=="deb") {
		614	// Базовый репозиторий
		615	$query = "SELECT * FROM ".$this->prefix."repository r ";
		616	$query .= "JOIN ".$this->prefix."protos p ON r.proto_id=p.proto_id ";
		617	$query .= "JOIN ".$this->prefix."rephost h ON r.rhost_id=h.rhost_id ";
651	alex-w	618	$query .= "JOIN ".$this->prefix."repfolder f ON r.rfolder_id=f.rfolder_id ";
646	alex-w	619	$query .= "JOIN ".$this->prefix."version v ON r.version=v.version_id ";
		620	$query .= "JOIN ".$this->prefix."rtype t ON r.rtype_id=t.rtype_id ";
		621	$query .= "JOIN ".$this->prefix."repscheme s ON r.scheme_id=s.scheme_id ";
650	alex-w	622	$query .= "WHERE v.version_id='".$data["version_id"]."' AND r.rtype_id='1'";
646	alex-w	623	$rq =& $this->db->query($query);
		624	$rq->fetchInto($base);
		625	// Формируем type proto://host/folder
659	alex-w	626	$show .= "# ".$this->secure->checkStr($base["repinfo"],1)."\n";
670	alex-w	627	if ($base["repkey"]!="") {
		628	$show .= "# Установка ключа: ".$this->secure->checkStr($base["repkey"],1)."\n";
		629	}
654	alex-w	630	$show .= $this->secure->checkStr($dist["type"],1)." ".$this->secure->checkStr($base["proto"],1).$this->secure->checkStr($base["rhost"],1).$this->secure->checkStr($base["rfolder"],1);
		631	$dvname = str_replace("{DIST}",$this->secure->checkStr($dist["vcodename"],1),$this->secure->checkStr($base["scheme"],1));
646	alex-w	632	// Формируем distname
		633	$show .= " ".$dvname." ";
		634	// Формируем sections
		635	$query = "SELECT * FROM ".$this->prefix."section s ";
		636	$query .= "JOIN ".$this->prefix."sect2rep r ON s.sect_id=r.sect_id ";
		637	$query .= "WHERE r.rep_id='".$base["rep_id"]."' AND (";
		638	for($i=0;$i<count($data["section"]);$i++) {
652	alex-w	639	$query .= "s.sect_id='".$data["section"][$i]."' ";
646	alex-w	640	if ($i<count($data["section"])-1) {
		641	$query .= " OR ";
		642	}
		643	}
		644	$query .= ")";
		645	$rq =& $this->db->query($query);
		646	while ($rq->fetchInto($sections)) {
		647	$show .= $sections["secname"]." ";
		648	}
655	alex-w	649	$show .= "\n\n";
		650
658	alex-w	651	// Репозитории обновлений и третьих лиц
655	alex-w	652	$query = "SELECT * FROM ".$this->prefix."repository r ";
		653	$query .= "JOIN ".$this->prefix."protos p ON r.proto_id=p.proto_id ";
		654	$query .= "JOIN ".$this->prefix."rephost h ON r.rhost_id=h.rhost_id ";
		655	$query .= "JOIN ".$this->prefix."repfolder f ON r.rfolder_id=f.rfolder_id ";
		656	$query .= "JOIN ".$this->prefix."version v ON r.version=v.version_id ";
		657	$query .= "JOIN ".$this->prefix."rtype t ON r.rtype_id=t.rtype_id ";
		658	$query .= "JOIN ".$this->prefix."repscheme s ON r.scheme_id=s.scheme_id ";
658	alex-w	659	$query .= "WHERE r.rtype_id>'1' AND (";
656	alex-w	660	for($i=0;$i<count($data["repository"]);$i++) {
		661	$query .= "r.rep_id='".$data["repository"][$i]."' ";
		662	if ($i<count($data["repository"])-1) {
		663	$query .= " OR ";
		664	}
		665	}
666	alex-w	666	$query .= ") ORDER BY r.rtype_id ASC";
667	alex-w	667	$req =& $this->db->query($query);
		668	while ($req->fetchInto($updates)) {
655	alex-w	669	// Формируем type proto://host/folder
659	alex-w	670	$show .= "# ".$this->secure->checkStr($updates["repinfo"],1)."\n";
670	alex-w	671	if ($updates["repkey"]!="") {
		672	$show .= "# Установка ключа: ".$this->secure->checkStr($updates["repkey"],1)."\n";
		673	}
655	alex-w	674	$show .= $this->secure->checkStr($dist["type"],1)." ".$this->secure->checkStr($updates["proto"],1).$this->secure->checkStr($updates["rhost"],1).$this->secure->checkStr($updates["rfolder"],1);
		675	$dvname = str_replace("{DIST}",$this->secure->checkStr($dist["vcodename"],1),$this->secure->checkStr($updates["scheme"],1));
		676	// Формируем distname
		677	$show .= " ".$dvname." ";
		678	// Формируем sections
		679	$query = "SELECT * FROM ".$this->prefix."section s ";
		680	$query .= "JOIN ".$this->prefix."sect2rep r ON s.sect_id=r.sect_id ";
661	alex-w	681	$query .= "WHERE r.rep_id='".$updates["rep_id"]."'";
655	alex-w	682	$rq =& $this->db->query($query);
		683	while ($rq->fetchInto($sections)) {
		684	$show .= $sections["secname"]." ";
		685	}
668	alex-w	686	$show .= "\n\n";
655	alex-w	687	}
646	alex-w	688	$show .= "\n";
668	alex-w	689	} else {
		690	// Базовый репозиторий
		691	$query = "SELECT * FROM ".$this->prefix."repository r ";
		692	$query .= "JOIN ".$this->prefix."protos p ON r.proto_id=p.proto_id ";
		693	$query .= "JOIN ".$this->prefix."rephost h ON r.rhost_id=h.rhost_id ";
		694	$query .= "JOIN ".$this->prefix."repfolder f ON r.rfolder_id=f.rfolder_id ";
		695	$query .= "JOIN ".$this->prefix."version v ON r.version=v.version_id ";
		696	$query .= "JOIN ".$this->prefix."rtype t ON r.rtype_id=t.rtype_id ";
		697	$query .= "JOIN ".$this->prefix."repscheme s ON r.scheme_id=s.scheme_id ";
		698	$query .= "WHERE v.version_id='".$data["version_id"]."' AND r.rtype_id='1'";
		699	$rq =& $this->db->query($query);
		700	$rq->fetchInto($base);
		701	// Формируем type proto://host/folder
		702	$show .= "# ".$this->secure->checkStr($base["repinfo"],1)."\n";
		703	$show .= $this->secure->checkStr($dist["type"],1)." ";
		704	if ($base["sign_id"]!=0) {
		705	$query = "SELECT * FROM ".$this->prefix."signs WHERE sign_id='".$base["sign_id"]."'";
		706	$rq =& $this->db->query($query);
		707	$rq->fetchInto($sign);
671	alex-w	708	$show .= "[".$this->secure->checkStr($sign["sname"],1)."] ";
668	alex-w	709	}
		710	$show .= $this->secure->checkStr($base["proto"],1).$this->secure->checkStr($base["rhost"],1).$this->secure->checkStr($base["rfolder"],1)." ";
671	alex-w	711	$show .= $this->secure->checkStr($base["scheme"],1)." ";
646	alex-w	712
668	alex-w	713	// Формируем sections
		714	$query = "SELECT * FROM ".$this->prefix."section s ";
		715	$query .= "JOIN ".$this->prefix."sect2rep r ON s.sect_id=r.sect_id ";
		716	$query .= "WHERE r.rep_id='".$base["rep_id"]."' AND (";
		717	for($i=0;$i<count($data["section"]);$i++) {
		718	$query .= "s.sect_id='".$data["section"][$i]."' ";
		719	if ($i<count($data["section"])-1) {
		720	$query .= " OR ";
		721	}
		722	}
		723	$query .= ")";
		724	$rq =& $this->db->query($query);
		725	while ($rq->fetchInto($sections)) {
		726	$show .= $sections["secname"]." ";
		727	}
		728	$show .= "\n\n";
		729
		730	// Репозитории обновлений и третьих лиц
		731	$query = "SELECT * FROM ".$this->prefix."repository r ";
		732	$query .= "JOIN ".$this->prefix."protos p ON r.proto_id=p.proto_id ";
		733	$query .= "JOIN ".$this->prefix."rephost h ON r.rhost_id=h.rhost_id ";
		734	$query .= "JOIN ".$this->prefix."repfolder f ON r.rfolder_id=f.rfolder_id ";
		735	$query .= "JOIN ".$this->prefix."version v ON r.version=v.version_id ";
		736	$query .= "JOIN ".$this->prefix."rtype t ON r.rtype_id=t.rtype_id ";
		737	$query .= "JOIN ".$this->prefix."repscheme s ON r.scheme_id=s.scheme_id ";
		738	$query .= "WHERE r.rtype_id>'1' AND (";
		739	for($i=0;$i<count($data["repository"]);$i++) {
		740	$query .= "r.rep_id='".$data["repository"][$i]."' ";
		741	if ($i<count($data["repository"])-1) {
		742	$query .= " OR ";
		743	}
		744	}
		745	$query .= ") ORDER BY r.rtype_id ASC";
		746	$req =& $this->db->query($query);
		747	while ($req->fetchInto($updates)) {
		748	// Формируем type proto://host/folder
		749	$show .= "# ".$this->secure->checkStr($updates["repinfo"],1)."\n";
		750	$show .= $this->secure->checkStr($dist["type"],1)." ";
		751	if ($updates["sign_id"]!=0) {
		752	$query = "SELECT * FROM ".$this->prefix."signs WHERE sign_id='".$base["sign_id"]."'";
		753	$rqs =& $this->db->query($query);
		754	$rqs->fetchInto($sign);
671	alex-w	755	$show .= "[".$this->secure->checkStr($sign["sname"],1)."] ";
668	alex-w	756	}
		757	$show .= $this->secure->checkStr($updates["proto"],1).$this->secure->checkStr($updates["rhost"],1).$this->secure->checkStr($updates["rfolder"],1)." ";
671	alex-w	758	$show .= $this->secure->checkStr($updates["scheme"],1)." ";
668	alex-w	759	// Формируем sections
		760	$query = "SELECT * FROM ".$this->prefix."section s ";
		761	$query .= "JOIN ".$this->prefix."sect2rep r ON s.sect_id=r.sect_id ";
		762	$query .= "WHERE r.rep_id='".$updates["rep_id"]."'";
		763	$rq =& $this->db->query($query);
		764	while ($rq->fetchInto($sections)) {
		765	$show .= $sections["secname"]." ";
		766	}
		767	$show .= "\n\n";
		768	}
		769	$show .= "\n";
646	alex-w	770	}
		771
668	alex-w	772	$HTTPHeader1 = "Content-length: ".strlen($show);
		773	$HTTPHeader2 = "Content-disposition: attachment; filename=sources.list\n\n";
		774
		775	header($HTTPHeader1);
		776	header($HTTPHeader2);
628	alex-w	777	return $show;
358	alex-w	778	}
522	alex-w	779
463	alex-w	780	/**
522	alex-w	781	* Показывает список секций
		782	*
		783	* @author Alexander Wolf
		784	* @category Core
		785	*
		786	* @param string $name
		787	* @param string $actor
561	alex-w	788	* @param string $format
522	alex-w	789	* @return string
		790	*/
560	alex-w	791	public function showSectionsList($name, $actor, $format = 'html') {
		792	switch($format) {
		793	case 'html':
561	alex-w	794	$query = "SELECT * FROM ".$this->prefix."section";
		795	$rq =& $this->db->query($query);
560	alex-w	796	$show = "<ul>\n";
		797	while ($rq->fetchInto($element)) {
		798	$show .= "<li>[<a href='".$actor."?mode=".$name."&action=edit&uuid=".$element["sect_id"]."' class='edit'>править</a>][<a href='".$actor."?mode=".$name."&action=delete&uuid=".$element["sect_id"]."' class='delete'>удалить</a>] ".$this->secure->checkStr($element["secname"],1)."</li>\n";
		799	}
		800	$show .= "</ul>";
		801	break;
		802	case 'innerhtml':
		803	$show = "";
561	alex-w	804	$repID = $this->secure->checkInt($actor);
		805	if ($repID==0) {
		806	$query = "SELECT * FROM ".$this->prefix."section";
		807	$rq =& $this->db->query($query);
		808	while ($rq->fetchInto($element)) {
567	alex-w	809	$show .= "<input type='checkbox' name='".$name."[]' value='".$element["sect_id"]."'> ".$this->secure->checkStr($element["secname"],1)." ";
561	alex-w	810	}
		811	} else {
		812	$query = "SELECT * FROM ".$this->prefix."section s JOIN ".$this->prefix."sect2rep r ON s.sect_id=r.sect_id WHERE r.rep_id='$repID'";
		813	$rq =& $this->db->query($query);
		814	while ($rq->fetchInto($element)) {
567	alex-w	815	$show .= "<input type='checkbox' name='".$name."[]' value='".$element["sect_id"]."' checked> ".$this->secure->checkStr($element["secname"],1)." ";
561	alex-w	816	}
		817	$query = "SELECT s.* FROM ".$this->prefix."section s WHERE s.sect_id NOT IN (SELECT sect_id FROM ".$this->prefix."sect2rep WHERE rep_id='$repID')";
563	alex-w	818	$rq =& $this->db->query($query);
561	alex-w	819	while ($rq->fetchInto($element)) {
567	alex-w	820	$show .= "<input type='checkbox' name='".$name."[]' value='".$element["sect_id"]."'> ".$this->secure->checkStr($element["secname"],1)." ";
561	alex-w	821	}
		822	}
		823
560	alex-w	824	break;
522	alex-w	825	}
		826
		827	return $show;
		828	}
		829
523	alex-w	830	/**
		831	* Вывод формы редактирования/добавления секций
		832	*
		833	* @author Alexander Wolf
		834	* @category Core
		835	*
		836	* @param integer $sectionID
		837	* @param string $info
		838	* @return string
		839	*/
		840	public function showSectionsForm($sectionID = 0, $info = "") {
522	alex-w	841	$sSectID = $this->secure->checkInt($sectionID);
		842	$sInfo = $this->secure->checkStr($info, 1);
		843	if ($sInfo == "") {
		844	$sInfo = "Секция";
		845	}
		846	if ($sSectID != 0) {
		847	// Режим редактирования
		848	$query = "SELECT * FROM ".$this->prefix."section WHERE sect_id='".$sSectID."'";
		849	$rq =& $this->db->query($query);
		850	$rq->fetchInto($element);
		851	}
		852
		853	$show = "<fieldset><legend>".$sInfo."</legend>\n";
		854	$show .= "<div class='inputbox'><label for='sname'>Название секции:</label> <input type='text' name='sname' id='sname' value='".$this->secure->checkStr($element["secname"],1)."'></div>\n";
		855	$show .= "<div class='inputbox'><label for='sinfo'>Описание секции:</label> <input type='text' name='sinfo' id='sinfo' value='".$this->secure->checkStr($element["sectinfo"],1)."'></div>\n";
		856	$show .= "<div class='inputbox'><input type='submit' value=' Отправить данные '></div>\n</fieldset>\n";
		857
		858	return $show;
		859	}
		860
		861	/**
523	alex-w	862	* Обновление информации о секции
		863	*
		864	* @author Alexander Wolf
		865	* @category Core
		866	*
		867	* @param integer $sectionID
		868	* @param string $sname
		869	* @param string $sinfo
		870	* @return array
		871	*/
		872	public function updateSection($sectionID, $sname, $sinfo = "") {
		873	$result = array();
		874	$sSectID = $this->secure->checkInt($sectionID);
579	alex-w	875	$sSName = $this->secure->checkStr($sname);
		876	$sSInfo = $this->secure->checkStr($sinfo);
523	alex-w	877
		878	$query = "UPDATE ".$this->prefix."section SET secname='".$sSName."', sectinfo='".$sSInfo."' WHERE sect_id='".$sSectID."'";
		879	$rq =& $this->db->query($query);
		880	if (PEAR::isError($this->db)) {
		881	$result["ERR"] = 1;
		882	$result["ERRINFO"] = $this->db->getMessage();
		883	} else {
		884	$result["ERR"] = 0;
		885	}
		886
		887	return $result;
		888	}
		889
		890	/**
		891	* Удаление информации о секции
		892	*
		893	* @author Alexander Wolf
		894	* @category Core
		895	*
		896	* @param integer $sectionID
		897	* @return array
		898	*/
		899	public function dropSection($sectionID) {
		900	$result = array();
		901	$sSectID = $this->secure->checkInt($sectionID);
		902
		903	// Удаление секции
		904	$query = "DELETE FROM ".$this->prefix."section WHERE sect_id='".$sSectID."'";
		905	$rq =& $this->db->query($query);
		906	if (PEAR::isError($this->db)) {
		907	$result["ERR"] = 1;
		908	$result["ERRINFO"] = $this->db->getMessage();
		909	} else {
		910	$result["ERR"] = 0;
		911	}
		912
		913	return $result;
		914	}
		915
		916	/**
		917	* Добавление новой секции
		918	*
		919	* @author Alexander Wolf
		920	* @category Core
		921	*
		922	* @param string $sname
		923	* @param string $sinfo
		924	* @return array
		925	*/
		926	public function addSection($sname, $sinfo = "") {
		927	$result = array();
582	alex-w	928	$sSName = $this->secure->checkStr($sname);
		929	$sSInfo = $this->secure->checkStr($sinfo);
523	alex-w	930
		931	$query = "INSERT INTO ".$this->prefix."section SET secname='".$sSName."', sectinfo='".$sSInfo."'";
		932	$rq =& $this->db->query($query);
		933	if (PEAR::isError($this->db)) {
		934	$result["ERR"] = 1;
		935	$result["ERRINFO"] = $this->db->getMessage();
		936	} else {
		937	$result["ERR"] = 0;
		938	}
		939
		940	return $result;
		941	}
		942
		943	/**
568	alex-w	944	* Вывод списка поддерживаемых архитектур
		945	*
		946	* @author Alexander Wolf
		947	* @category Core
		948	*
		949	* @param string $name
		950	* @param string $actor
		951	* @param string $format
		952	* @return string
		953	*/
		954	public function showArchList($name, $actor, $format = 'list') {
		955	switch($format) {
		956	case 'list':
		957	$query = "SELECT * FROM ".$this->prefix."arch";
		958	$rq =& $this->db->query($query);
		959	$show = "<ul>\n";
		960	while ($rq->fetchInto($element)) {
		961	$show .= "<li>[<a href='".$actor."?mode=".$name."&action=edit&uuid=".$element["arch_id"]."' class='edit'>править</a>][<a href='".$actor."?mode=".$name."&action=delete&uuid=".$element["arch_id"]."' class='delete'>удалить</a>] ".$this->secure->checkStr($element["arch"],1)."</li>\n";
		962	}
		963	$show .= "</ul>";
		964	break;
		965	case 'innerhtml':
		966	$show = "";
		967	$repID = $this->secure->checkInt($actor);
614	alex-w	968	if ($repID==0) {
568	alex-w	969	$query = "SELECT * FROM ".$this->prefix."arch";
		970	$rq =& $this->db->query($query);
		971	while ($rq->fetchInto($element)) {
		972	$show .= "<input type='checkbox' name='".$name."[]' value='".$element["arch_id"]."'> ".$this->secure->checkStr($element["arch"],1)." ";
		973	}
		974	} else {
		975	$query = "SELECT * FROM ".$this->prefix."arch a JOIN ".$this->prefix."arch2rep r ON a.arch_id=r.arch_id WHERE r.rep_id='$repID'";
		976	$rq =& $this->db->query($query);
		977	while ($rq->fetchInto($element)) {
		978	$show .= "<input type='checkbox' name='".$name."[]' value='".$element["arch_id"]."' checked> ".$this->secure->checkStr($element["arch"],1)." ";
		979	}
		980	$query = "SELECT a.* FROM ".$this->prefix."arch a WHERE a.arch_id NOT IN (SELECT arch_id FROM ".$this->prefix."arch2rep WHERE rep_id='$repID')";
		981	$rq =& $this->db->query($query);
610	alex-w	982	if ($rq->numRows()>0) {
		983	while ($rq->fetchInto($element)) {
		984	$show .= "<input type='checkbox' name='".$name."[]' value='".$element["arch_id"]."'> ".$this->secure->checkStr($element["arch"],1)." ";
		985	}
568	alex-w	986	}
		987	}
		988	break;
		989	}
		990	return $show;
		991	}
		992
		993	/**
		994	* Добавление новой архитектуры
		995	*
		996	* @author Alexander Wolf
		997	* @category Core
		998	*
		999	* @param string $arch
		1000	* @return array
		1001	*/
		1002	public function addArch($arch) {
		1003	$result = array();
582	alex-w	1004	$sArch = $this->secure->checkStr($arch);
568	alex-w	1005
		1006	$query = "INSERT INTO ".$this->prefix."arch SET arch='".$sArch."'";
		1007	$rq =& $this->db->query($query);
		1008	if (PEAR::isError($this->db)) {
		1009	$result["ERR"] = 1;
		1010	$result["ERRINFO"] = $this->db->getMessage();
		1011	} else {
		1012	$result["ERR"] = 0;
		1013	}
		1014
		1015	return $result;
		1016	}
		1017
		1018	/**
		1019	* Удаление информации об архитектуре
		1020	*
		1021	* @author Alexander Wolf
		1022	* @category Core
		1023	*
		1024	* @param integer $archID
		1025	* @return array
		1026	*/
		1027	public function dropArch($archID) {
		1028	$result = array();
		1029	$sArchID = $this->secure->checkInt($archID);
		1030
		1031	// Удаление архитектуры
		1032	$query = "DELETE FROM ".$this->prefix."arch WHERE arch_id='".$sArchID."'";
		1033	$rq =& $this->db->query($query);
		1034	if (PEAR::isError($this->db)) {
		1035	$result["ERR"] = 1;
		1036	$result["ERRINFO"] = $this->db->getMessage();
		1037	} else {
		1038	$result["ERR"] = 0;
		1039	}
		1040
		1041	// Удаление архитектуры из списка репозиториев
		1042	$query = "DELETE FROM ".$this->prefix."arch2rep WHERE arch_id='".$sArchID."'";
		1043	$rq =& $this->db->query($query);
		1044	if (PEAR::isError($this->db)) {
		1045	$result["ERR"] = 1;
		1046	$result["ERRINFO"] = $this->db->getMessage();
		1047	} else {
		1048	$result["ERR"] = 0;
		1049	}
		1050	return $result;
		1051	}
		1052
		1053	/**
		1054	* Обновление информации об архитектуре
		1055	*
		1056	* @author Alexander Wolf
		1057	* @category Core
		1058	*
		1059	* @param integer $archID
		1060	* @param string $arch
		1061	* @return array
		1062	*/
		1063	public function updateArch($archID, $arch) {
		1064	$result = array();
		1065	$sArchID = $this->secure->checkInt($archID);
579	alex-w	1066	$sArch = $this->secure->checkStr($arch);
568	alex-w	1067
		1068	$query = "UPDATE ".$this->prefix."arch SET arch='".$sArch."' WHERE arch_id='".$sArchID."'";
		1069	$rq =& $this->db->query($query);
		1070	if (PEAR::isError($this->db)) {
		1071	$result["ERR"] = 1;
		1072	$result["ERRINFO"] = $this->db->getMessage();
		1073	} else {
		1074	$result["ERR"] = 0;
		1075	}
		1076
		1077	return $result;
		1078	}
		1079
		1080	/**
		1081	* Вывод формы редактирования/добавления архитектур
		1082	*
		1083	* @author Alexander Wolf
		1084	* @category Core
		1085	*
		1086	* @param integer $archID
		1087	* @param string $info
		1088	* @return string
		1089	*/
		1090	public function showArchForm($archID = 0, $info = "") {
		1091	$sArchID = $this->secure->checkInt($archID);
		1092	$sInfo = $this->secure->checkStr($info, 1);
		1093	if ($sInfo == "") {
		1094	$sInfo = "Архитектура";
		1095	}
		1096	if ($sArchID != 0) {
		1097	// Режим редактирования
		1098	$query = "SELECT * FROM ".$this->prefix."arch WHERE arch_id='".$sArchID."'";
		1099	$rq =& $this->db->query($query);
		1100	$rq->fetchInto($element);
		1101	}
		1102
		1103	$show = "<fieldset><legend>".$sInfo."</legend>\n";
		1104	$show .= "<div class='inputbox'><label for='arch'>Архитектура:</label> <input type='text' name='arch' id='arch' value='".$this->secure->checkStr($element["arch"],1)."'></div>\n";
		1105	$show .= "<div class='inputbox'><input type='submit' value=' Отправить данные '></div>\n</fieldset>\n";
		1106
		1107	return $show;
		1108	}
		1109
		1110	/**
570	alex-w	1111	* Вывод списка схем репозиториев
		1112	*
		1113	* @author Alexander Wolf
		1114	* @category Core
		1115	*
		1116	* @param string $name
		1117	* @param string $actor
		1118	* @param string $format
		1119	* @return string
		1120	*/
		1121	public function showSchemeList($name, $actor, $format = 'list') {
		1122	switch($format) {
		1123	case 'list':
		1124	$query = "SELECT * FROM ".$this->prefix."repscheme";
		1125	$rq =& $this->db->query($query);
		1126	$show = "<ul>\n";
		1127	while ($rq->fetchInto($element)) {
		1128	$show .= "<li>[<a href='".$actor."?mode=".$name."&action=edit&uuid=".$element["scheme_id"]."' class='edit'>править</a>][<a href='".$actor."?mode=".$name."&action=delete&uuid=".$element["scheme_id"]."' class='delete'>удалить</a>] ".$this->secure->checkStr($element["scheme"],1)."</li>\n";
		1129	}
		1130	$show .= "</ul>";
		1131	break;
		1132	case 'innerhtml':
611	alex-w	1133	$schemeID = $this->secure->checkInt($actor);
570	alex-w	1134	$query = "SELECT * FROM ".$this->prefix."repscheme";
		1135	$rq =& $this->db->query($query);
		1136	$show = "<select name='".$name."' id='".$name."'>\n";
		1137	while ($rq->fetchInto($element)) {
611	alex-w	1138	if ($element["scheme_id"]==$schemeID) {
570	alex-w	1139	$show .= "<option value='".$this->secure->checkInt($element["scheme_id"])."' selected>".$this->secure->checkStr($element["scheme"],1)."</option>\n";
		1140	} else {
611	alex-w	1141	$show .= "<option value='".$this->secure->checkInt($element["scheme_id"])."'>".$this->secure->checkStr($element["scheme"],1)."</option>\n";
570	alex-w	1142	}
		1143	}
		1144	$show .= "</select>";
		1145	break;
		1146	}
		1147	return $show;
		1148	}
		1149
		1150	/**
		1151	* Добавление новой схемы репозитория
		1152	*
		1153	* @author Alexander Wolf
		1154	* @category Core
		1155	*
		1156	* @param string $scheme
		1157	* @return array
		1158	*/
		1159	public function addScheme($scheme) {
		1160	$result = array();
582	alex-w	1161	$sScheme = $this->secure->checkStr($scheme);
570	alex-w	1162
		1163	$query = "INSERT INTO ".$this->prefix."repscheme SET scheme='".$sScheme."'";
		1164	$rq =& $this->db->query($query);
		1165	if (PEAR::isError($this->db)) {
		1166	$result["ERR"] = 1;
		1167	$result["ERRINFO"] = $this->db->getMessage();
		1168	} else {
		1169	$result["ERR"] = 0;
		1170	}
		1171
		1172	return $result;
		1173	}
		1174
		1175	/**
		1176	* Удаление информации о схеме репозитория
		1177	*
		1178	* @author Alexander Wolf
		1179	* @category Core
		1180	*
		1181	* @param integer $schemeID
		1182	* @return array
		1183	*/
		1184	public function dropScheme($schemeID) {
		1185	$result = array();
		1186	$sSchemeID = $this->secure->checkInt($schemeID);
		1187
		1188	// Удаление схемы
		1189	$query = "DELETE FROM ".$this->prefix."repscheme WHERE scheme_id='".$sSchemeID."'";
		1190	$rq =& $this->db->query($query);
		1191	if (PEAR::isError($this->db)) {
		1192	$result["ERR"] = 1;
		1193	$result["ERRINFO"] = $this->db->getMessage();
		1194	} else {
		1195	$result["ERR"] = 0;
		1196	}
		1197
		1198	return $result;
		1199	}
		1200
		1201	/**
		1202	* Обновление информации о схеме репозитория
		1203	*
		1204	* @author Alexander Wolf
		1205	* @category Core
		1206	*
		1207	* @param integer $schemeID
		1208	* @param string $info
		1209	* @return array
		1210	*/
		1211	public function updateScheme($schemeID, $info) {
		1212	$result = array();
		1213	$sSchemeID = $this->secure->checkInt($schemeID);
579	alex-w	1214	$sScheme = $this->secure->checkStr($info);
570	alex-w	1215
		1216	$query = "UPDATE ".$this->prefix."repscheme SET scheme='".$sScheme."' WHERE scheme_id='".$sSchemeID."'";
		1217	$rq =& $this->db->query($query);
		1218	if (PEAR::isError($this->db)) {
		1219	$result["ERR"] = 1;
		1220	$result["ERRINFO"] = $this->db->getMessage();
		1221	} else {
		1222	$result["ERR"] = 0;
		1223	}
		1224
		1225	return $result;
		1226	}
		1227
		1228	/**
		1229	* Вывод формы редактирования/добавления схем репозиториев
		1230	*
		1231	* @author Alexander Wolf
		1232	* @category Core
		1233	*
		1234	* @param integer $schemeID
		1235	* @param string $info
		1236	* @return string
		1237	*/
		1238	public function showSchemeForm($schemeID = 0, $info = "") {
		1239	$sSchemeID = $this->secure->checkInt($schemeID);
		1240	$sInfo = $this->secure->checkStr($info, 1);
		1241	if ($sInfo == "") {
		1242	$sInfo = "Схема репозитория";
		1243	}
571	alex-w	1244	$show = "<fieldset><legend>".$sInfo."</legend>\n";
570	alex-w	1245	if ($sSchemeID != 0) {
		1246	// Режим редактирования
		1247	$query = "SELECT * FROM ".$this->prefix."repscheme WHERE scheme_id='".$sSchemeID."'";
		1248	$rq =& $this->db->query($query);
573	alex-w	1249	$rq->fetchInto($element);
		1250	}
571	alex-w	1251
573	alex-w	1252	$show .= "<div class='inputbox'><label for='scheme'>Схема репозитория:</label> <input type='text' name='scheme' id='scheme' value='".$this->secure->checkStr($element["scheme"],1)."'></div>\n";
570	alex-w	1253	$show .= "<div class='inputbox'><input type='submit' value=' Отправить данные '></div>\n</fieldset>\n";
		1254
		1255	return $show;
		1256	}
		1257
		1258	/**
574	alex-w	1259	* Вывод списка протоколов
		1260	*
		1261	* @author Alexander Wolf
		1262	* @category Core
		1263	*
		1264	* @param string $name
		1265	* @param string $actor
		1266	* @param string $format
		1267	* @return string
		1268	*/
		1269	public function showProtoList($name, $actor, $format = 'list') {
		1270	switch($format) {
		1271	case 'list':
		1272	$query = "SELECT * FROM ".$this->prefix."protos";
		1273	$rq =& $this->db->query($query);
		1274	$show = "<ul>\n";
		1275	while ($rq->fetchInto($element)) {
		1276	$show .= "<li>[<a href='".$actor."?mode=".$name."&action=edit&uuid=".$element["proto_id"]."' class='edit'>править</a>][<a href='".$actor."?mode=".$name."&action=delete&uuid=".$element["proto_id"]."' class='delete'>удалить</a>] ".$this->secure->checkStr($element["proto"],1)."</li>\n";
		1277	}
		1278	$show .= "</ul>";
		1279	break;
		1280	case 'innerhtml':
		1281	$protoID = $this->secure->checkInt($actor);
		1282	$query = "SELECT * FROM ".$this->prefix."protos";
		1283	$rq =& $this->db->query($query);
		1284	$show = "<select name='".$name."' id='".$name."'>\n";
		1285	while ($rq->fetchInto($element)) {
		1286	if ($element["proto_id"]==$protoID) {
		1287	$show .= "<option value='".$this->secure->checkInt($element["proto_id"])."' selected>".$this->secure->checkStr($element["proto"],1)."</option>\n";
		1288	} else {
580	alex-w	1289	$show .= "<option value='".$this->secure->checkInt($element["proto_id"])."'>".$this->secure->checkStr($element["proto"],1)."</option>\n";
574	alex-w	1290	}
		1291	}
		1292	$show .= "</select>";
		1293	break;
		1294	}
		1295	return $show;
		1296	}
		1297
		1298	/**
		1299	* Добавление нового протокола
		1300	*
		1301	* @author Alexander Wolf
		1302	* @category Core
		1303	*
		1304	* @param string $proto
		1305	* @return array
		1306	*/
		1307	public function addProto($proto) {
		1308	$result = array();
582	alex-w	1309	$sProto = $this->secure->checkStr($proto);
574	alex-w	1310
		1311	$query = "INSERT INTO ".$this->prefix."protos SET proto='".$sProto."'";
		1312	$rq =& $this->db->query($query);
		1313	if (PEAR::isError($this->db)) {
		1314	$result["ERR"] = 1;
		1315	$result["ERRINFO"] = $this->db->getMessage();
		1316	} else {
		1317	$result["ERR"] = 0;
		1318	}
		1319
		1320	return $result;
		1321	}
		1322
		1323	/**
		1324	* Удаление информации о протоколе
		1325	*
		1326	* @author Alexander Wolf
		1327	* @category Core
		1328	*
		1329	* @param integer $protoID
		1330	* @return array
		1331	*/
		1332	public function dropProto($protoID) {
		1333	$result = array();
		1334	$sProtoID = $this->secure->checkInt($protoID);
		1335
		1336	// Удаление протокола
		1337	$query = "DELETE FROM ".$this->prefix."protos WHERE proto_id='".$sProtoID."'";
		1338	$rq =& $this->db->query($query);
		1339	if (PEAR::isError($this->db)) {
		1340	$result["ERR"] = 1;
		1341	$result["ERRINFO"] = $this->db->getMessage();
		1342	} else {
		1343	$result["ERR"] = 0;
		1344	}
		1345
		1346	return $result;
		1347	}
		1348
		1349	/**
		1350	* Обновление информации о протоколе
		1351	*
		1352	* @author Alexander Wolf
		1353	* @category Core
		1354	*
		1355	* @param integer $protoID
		1356	* @param string $info
		1357	* @return array
		1358	*/
		1359	public function updateProto($protoID, $info) {
		1360	$result = array();
		1361	$sProtoID = $this->secure->checkInt($protoID);
579	alex-w	1362	$sProto = $this->secure->checkStr($info);
574	alex-w	1363
		1364	$query = "UPDATE ".$this->prefix."protos SET proto='".$sProto."' WHERE proto_id='".$sProtoID."'";
		1365	$rq =& $this->db->query($query);
		1366	if (PEAR::isError($this->db)) {
		1367	$result["ERR"] = 1;
		1368	$result["ERRINFO"] = $this->db->getMessage();
		1369	} else {
		1370	$result["ERR"] = 0;
		1371	}
		1372
		1373	return $result;
		1374	}
		1375
		1376	/**
		1377	* Вывод формы редактирования/добавления протоколов
		1378	*
		1379	* @author Alexander Wolf
		1380	* @category Core
		1381	*
		1382	* @param integer $protoID
		1383	* @param string $info
		1384	* @return string
		1385	*/
		1386	public function showProtoForm($protoID = 0, $info = "") {
		1387	$sProtoID = $this->secure->checkInt($protoID);
		1388	$sInfo = $this->secure->checkStr($info, 1);
		1389	if ($sInfo == "") {
		1390	$sInfo = "Протокол доступа";
		1391	}
		1392	$show = "<fieldset><legend>".$sInfo."</legend>\n";
		1393	if ($sProtoID != 0) {
		1394	// Режим редактирования
		1395	$query = "SELECT * FROM ".$this->prefix."protos WHERE proto_id='".$sProtoID."'";
		1396	$rq =& $this->db->query($query);
		1397	$rq->fetchInto($element);
		1398	}
		1399
		1400	$show .= "<div class='inputbox'><label for='proto'>Протокол доступа:</label> <input type='text' name='proto' id='proto' value='".$this->secure->checkStr($element["proto"],1)."'></div>\n";
		1401	$show .= "<div class='inputbox'><input type='submit' value=' Отправить данные '></div>\n</fieldset>\n";
		1402
		1403	return $show;
		1404	}
		1405
		1406	/**
582	alex-w	1407	* Вывод списка хостов
		1408	*
		1409	* @author Alexander Wolf
		1410	* @category Core
		1411	*
		1412	* @param string $name
		1413	* @param string $actor
		1414	* @param string $format
		1415	* @return string
		1416	*/
		1417	public function showHostsList($name, $actor, $format = 'list') {
		1418	switch($format) {
		1419	case 'list':
		1420	$query = "SELECT * FROM ".$this->prefix."rephost";
		1421	$rq =& $this->db->query($query);
		1422	$show = "<ul>\n";
		1423	while ($rq->fetchInto($element)) {
		1424	$show .= "<li>[<a href='".$actor."?mode=".$name."&action=edit&uuid=".$element["rhost_id"]."' class='edit'>править</a>][<a href='".$actor."?mode=".$name."&action=delete&uuid=".$element["rhost_id"]."' class='delete'>удалить</a>] ".$this->secure->checkStr($element["rhost"],1)."</li>\n";
		1425	}
		1426	$show .= "</ul>";
		1427	break;
		1428	case 'innerhtml':
		1429	$hostID = $this->secure->checkInt($actor);
		1430	$query = "SELECT * FROM ".$this->prefix."rephost";
		1431	$rq =& $this->db->query($query);
		1432	$show = "<select name='".$name."' id='".$name."'>\n";
		1433	while ($rq->fetchInto($element)) {
		1434	if ($element["rhost_id"]==$hostID) {
		1435	$show .= "<option value='".$this->secure->checkInt($element["rhost_id"])."' selected>".$this->secure->checkStr($element["rhost"],1)."</option>\n";
		1436	} else {
		1437	$show .= "<option value='".$this->secure->checkInt($element["rhost_id"])."'>".$this->secure->checkStr($element["rhost"],1)."</option>\n";
		1438	}
		1439	}
		1440	$show .= "</select>";
		1441	break;
		1442	}
		1443	return $show;
		1444	}
		1445
		1446	/**
		1447	* Добавление нового хоста
		1448	*
		1449	* @author Alexander Wolf
		1450	* @category Core
		1451	*
		1452	* @param string $host
		1453	* @return array
		1454	*/
		1455	public function addHost($host) {
		1456	$result = array();
		1457	$sHost = $this->secure->checkStr($host);
		1458
586	alex-w	1459	$query = "INSERT INTO ".$this->prefix."rephost SET rhost='".$sHost."'";
582	alex-w	1460	$rq =& $this->db->query($query);
		1461	if (PEAR::isError($this->db)) {
		1462	$result["ERR"] = 1;
		1463	$result["ERRINFO"] = $this->db->getMessage();
		1464	} else {
		1465	$result["ERR"] = 0;
		1466	}
		1467
		1468	return $result;
		1469	}
		1470
		1471	/**
		1472	* Удаление информации о хосте
		1473	*
		1474	* @author Alexander Wolf
		1475	* @category Core
		1476	*
		1477	* @param integer $hostID
		1478	* @return array
		1479	*/
		1480	public function dropHost($hostID) {
		1481	$result = array();
		1482	$sHostID = $this->secure->checkInt($hostID);
		1483
		1484	// Удаление хоста
		1485	$query = "DELETE FROM ".$this->prefix."rephost WHERE rhost_id='".$sHostID."'";
		1486	$rq =& $this->db->query($query);
		1487	if (PEAR::isError($this->db)) {
		1488	$result["ERR"] = 1;
		1489	$result["ERRINFO"] = $this->db->getMessage();
		1490	} else {
		1491	$result["ERR"] = 0;
		1492	}
		1493
		1494	return $result;
		1495	}
		1496
		1497	/**
		1498	* Обновление информации о хосте
		1499	*
		1500	* @author Alexander Wolf
		1501	* @category Core
		1502	*
		1503	* @param integer $hostID
		1504	* @param string $info
		1505	* @return array
		1506	*/
		1507	public function updateHost($hostID, $info) {
		1508	$result = array();
		1509	$sHostID = $this->secure->checkInt($hostID);
		1510	$sHost = $this->secure->checkStr($info);
		1511
		1512	$query = "UPDATE ".$this->prefix."rephost SET rhost='".$sHost."' WHERE rhost_id='".$sHostID."'";
		1513	$rq =& $this->db->query($query);
		1514	if (PEAR::isError($this->db)) {
		1515	$result["ERR"] = 1;
		1516	$result["ERRINFO"] = $this->db->getMessage();
		1517	} else {
		1518	$result["ERR"] = 0;
		1519	}
		1520
		1521	return $result;
		1522	}
		1523
		1524	/**
		1525	* Вывод формы редактирования/добавления хостов
		1526	*
		1527	* @author Alexander Wolf
		1528	* @category Core
		1529	*
		1530	* @param integer $hostID
		1531	* @param string $info
		1532	* @return string
		1533	*/
		1534	public function showHostForm($hostID = 0, $info = "") {
		1535	$sHostID = $this->secure->checkInt($hostID);
		1536	$sInfo = $this->secure->checkStr($info, 1);
		1537	if ($sInfo == "") {
		1538	$sInfo = "Хост репозитория";
		1539	}
		1540	$show = "<fieldset><legend>".$sInfo."</legend>\n";
		1541	if ($sHostID != 0) {
		1542	// Режим редактирования
		1543	$query = "SELECT * FROM ".$this->prefix."rephost WHERE rhost_id='".$sHostID."'";
		1544	$rq =& $this->db->query($query);
		1545	$rq->fetchInto($element);
		1546	}
		1547
		1548	$show .= "<div class='inputbox'><label for='rhost'>Хост репозитория:</label> <input type='text' name='rhost' id='rhost' value='".$this->secure->checkStr($element["rhost"],1)."'></div>\n";
		1549	$show .= "<div class='inputbox'><input type='submit' value=' Отправить данные '></div>\n</fieldset>\n";
		1550
		1551	return $show;
		1552	}
		1553
		1554	/**
589	alex-w	1555	* Вывод списка корневых папок
		1556	*
		1557	* @author Alexander Wolf
		1558	* @category Core
		1559	*
		1560	* @param string $name
		1561	* @param string $actor
		1562	* @param string $format
		1563	* @return string
		1564	*/
		1565	public function showFoldersList($name, $actor, $format = 'list') {
		1566	switch($format) {
		1567	case 'list':
		1568	$query = "SELECT * FROM ".$this->prefix."repfolder";
		1569	$rq =& $this->db->query($query);
		1570	$show = "<ul>\n";
		1571	while ($rq->fetchInto($element)) {
		1572	$show .= "<li>[<a href='".$actor."?mode=".$name."&action=edit&uuid=".$element["rfolder_id"]."' class='edit'>править</a>][<a href='".$actor."?mode=".$name."&action=delete&uuid=".$element["rfolder_id"]."' class='delete'>удалить</a>] ".$this->secure->checkStr($element["rfolder"],1)."</li>\n";
		1573	}
		1574	$show .= "</ul>";
		1575	break;
		1576	case 'innerhtml':
		1577	$folderID = $this->secure->checkInt($actor);
		1578	$query = "SELECT * FROM ".$this->prefix."repfolder";
		1579	$rq =& $this->db->query($query);
		1580	$show = "<select name='".$name."' id='".$name."'>\n";
		1581	while ($rq->fetchInto($element)) {
		1582	if ($element["rfolder_id"]==$folderID) {
		1583	$show .= "<option value='".$this->secure->checkInt($element["rfolder_id"])."' selected>".$this->secure->checkStr($element["rfolder"],1)."</option>\n";
		1584	} else {
		1585	$show .= "<option value='".$this->secure->checkInt($element["rfolder_id"])."'>".$this->secure->checkStr($element["rfolder"],1)."</option>\n";
		1586	}
		1587	}
		1588	$show .= "</select>";
		1589	break;
		1590	}
		1591	return $show;
		1592	}
		1593
		1594	/**
		1595	* Добавление нового корневого каталога
		1596	*
		1597	* @author Alexander Wolf
		1598	* @category Core
		1599	*
		1600	* @param string $flder
		1601	* @return array
		1602	*/
		1603	public function addFolder($folder) {
		1604	$result = array();
		1605	$sFolder = $this->secure->checkStr($folder);
		1606
		1607	$query = "INSERT INTO ".$this->prefix."repfolder SET rfolder='".$sFolder."'";
		1608	$rq =& $this->db->query($query);
		1609	if (PEAR::isError($this->db)) {
		1610	$result["ERR"] = 1;
		1611	$result["ERRINFO"] = $this->db->getMessage();
		1612	} else {
		1613	$result["ERR"] = 0;
		1614	}
		1615
		1616	return $result;
		1617	}
		1618
		1619	/**
		1620	* Удаление информации о корневой папке
		1621	*
		1622	* @author Alexander Wolf
		1623	* @category Core
		1624	*
		1625	* @param integer $folderID
		1626	* @return array
		1627	*/
		1628	public function dropFolder($folderID) {
		1629	$result = array();
		1630	$sFolderID = $this->secure->checkInt($folderID);
		1631
		1632	// Удаление корневой папки
		1633	$query = "DELETE FROM ".$this->prefix."repfolder WHERE rfolder_id='".$sFolderID."'";
		1634	$rq =& $this->db->query($query);
		1635	if (PEAR::isError($this->db)) {
		1636	$result["ERR"] = 1;
		1637	$result["ERRINFO"] = $this->db->getMessage();
		1638	} else {
		1639	$result["ERR"] = 0;
		1640	}
		1641
		1642	return $result;
		1643	}
		1644
		1645	/**
		1646	* Обновление информации о корневой папки
		1647	*
		1648	* @author Alexander Wolf
		1649	* @category Core
		1650	*
		1651	* @param integer $folderID
		1652	* @param string $info
		1653	* @return array
		1654	*/
		1655	public function updateFolder($folderID, $info) {
		1656	$result = array();
		1657	$sFolderID = $this->secure->checkInt($folderID);
		1658	$sFolder = $this->secure->checkStr($info);
		1659
		1660	$query = "UPDATE ".$this->prefix."repfolder SET rfolder='".$sFolder."' WHERE rfolder_id='".$sFolderID."'";
		1661	$rq =& $this->db->query($query);
		1662	if (PEAR::isError($this->db)) {
		1663	$result["ERR"] = 1;
		1664	$result["ERRINFO"] = $this->db->getMessage();
		1665	} else {
		1666	$result["ERR"] = 0;
		1667	}
		1668
		1669	return $result;
		1670	}
		1671
		1672	/**
		1673	* Вывод формы редактирования/добавления корневых папок
		1674	*
		1675	* @author Alexander Wolf
		1676	* @category Core
		1677	*
		1678	* @param integer $folderID
		1679	* @param string $info
		1680	* @return string
		1681	*/
		1682	public function showFolderForm($folderID = 0, $info = "") {
		1683	$sFolderID = $this->secure->checkInt($folderID);
		1684	$sInfo = $this->secure->checkStr($info, 1);
		1685	if ($sInfo == "") {
		1686	$sInfo = "Корневая папка";
		1687	}
		1688	if ($sFolderID != 0) {
		1689	// Режим редактирования
		1690	$query = "SELECT * FROM ".$this->prefix."repfolder WHERE rfolder_id='".$sFolderID."'";
		1691	$rq =& $this->db->query($query);
		1692	$rq->fetchInto($element);
		1693	}
		1694
		1695	$show = "<fieldset><legend>".$sInfo."</legend>\n";
		1696	$show .= "<div class='inputbox'><label for='rfolder'>Корневая папка:</label> <input type='text' name='rfolder' id='rfolder' value='".$this->secure->checkStr($element["rfolder"],1)."'></div>\n";
		1697	$show .= "<div class='inputbox'><input type='submit' value=' Отправить данные '></div>\n</fieldset>\n";
		1698
		1699	return $show;
		1700	}
		1701
		1702	/**
539	alex-w	1703	* Показывает список подписей
		1704	*
		1705	* @author Alexander Wolf
		1706	* @category Core
		1707	*
		1708	* @param string $name
		1709	* @param string $actor
596	alex-w	1710	* @param string $format
539	alex-w	1711	* @return string
		1712	*/
594	alex-w	1713	public function showSignsList($name, $actor, $format = 'list') {
539	alex-w	1714	$query = "SELECT * FROM ".$this->prefix."signs";
		1715	$rq =& $this->db->query($query);
594	alex-w	1716	switch ($format) {
		1717	case 'list':
		1718	$show = "<ul>\n";
		1719	while ($rq->fetchInto($element)) {
		1720	$show .= "<li>[<a href='".$actor."?mode=".$name."&action=edit&uuid=".$element["sign_id"]."' class='edit'>править</a>][<a href='".$actor."?mode=".$name."&action=delete&uuid=".$element["sign_id"]."' class='delete'>удалить</a>] ".$this->secure->checkStr($element["sname"],1)."</li>\n";
		1721	}
		1722	$show .= "</ul>";
		1723	break;
		1724	case 'innerhtml':
		1725	$signID = $this->secure->checkInt($actor);
		1726	$show = "<select name='".$name."' id='".$name."'>\n";
		1727	$show .= "<option value='0'>Подписи нет</option>\n";
		1728	while ($rq->fetchInto($element)) {
		1729	if ($element["sign_id"]==$signID) {
		1730	$show .= "<option value='".$this->secure->checkInt($element["sign_id"])."' selected>".$this->secure->checkStr($element["sname"],1)."</option>\n";
		1731	} else {
		1732	$show .= "<option value='".$this->secure->checkInt($element["sign_id"])."'>".$this->secure->checkStr($element["sname"],1)."</option>\n";
		1733	}
		1734	}
		1735	$show .= "</select>\n";
		1736	break;
539	alex-w	1737	}
		1738
		1739	return $show;
		1740	}
		1741
		1742	/**
		1743	* Вывод формы редактирования/добавления подписей
		1744	*
		1745	* @author Alexander Wolf
		1746	* @category Core
		1747	*
		1748	* @param integer $sectionID
		1749	* @param string $info
		1750	* @return string
		1751	*/
		1752	public function showSignsForm($signID = 0, $info = "") {
		1753	$sSignID = $this->secure->checkInt($signID);
		1754	$sInfo = $this->secure->checkStr($info, 1);
		1755	if ($sInfo == "") {
		1756	$sInfo = "Подписи";
		1757	}
		1758	if ($sSignID != 0) {
		1759	// Режим редактирования
		1760	$query = "SELECT * FROM ".$this->prefix."signs WHERE sign_id='".$sSignID."'";
		1761	$rq =& $this->db->query($query);
		1762	$rq->fetchInto($element);
		1763	}
		1764
		1765	$show = "<fieldset><legend>".$sInfo."</legend>\n";
		1766	$show .= "<div class='inputbox'><label for='sname'>Название подписи:</label> <input type='text' name='sname' id='sname' value='".$this->secure->checkStr($element["sname"],1)."'></div>\n";
		1767	$show .= "<div class='inputbox'><label for='sinfo'>Описание подписи:</label> <input type='text' name='sinfo' id='sinfo' value='".$this->secure->checkStr($element["sinfo"],1)."'></div>\n";
		1768	$show .= "<div class='inputbox'><input type='submit' value=' Отправить данные '></div>\n</fieldset>\n";
		1769
		1770	return $show;
		1771	}
		1772
		1773	/**
		1774	* Обновление информации о секции
		1775	*
		1776	* @author Alexander Wolf
		1777	* @category Core
		1778	*
		1779	* @param integer $sectionID
		1780	* @param string $sname
		1781	* @param string $sinfo
		1782	* @return array
		1783	*/
		1784	public function updateSign($signID, $sname, $sinfo = "") {
		1785	$result = array();
		1786	$sSignID = $this->secure->checkInt($signID);
579	alex-w	1787	$sSName = $this->secure->checkStr($sname);
		1788	$sSInfo = $this->secure->checkStr($sinfo);
539	alex-w	1789
		1790	$query = "UPDATE ".$this->prefix."signs SET sname='".$sSName."', sinfo='".$sSInfo."' WHERE sign_id='".$sSignID."'";
		1791	$rq =& $this->db->query($query);
		1792	if (PEAR::isError($this->db)) {
		1793	$result["ERR"] = 1;
		1794	$result["ERRINFO"] = $this->db->getMessage();
		1795	} else {
		1796	$result["ERR"] = 0;
		1797	}
		1798
		1799	return $result;
		1800	}
		1801
		1802	/**
		1803	* Удаление информации о подписи
		1804	*
		1805	* @author Alexander Wolf
		1806	* @category Core
		1807	*
		1808	* @param integer $sectionID
		1809	* @return array
		1810	*/
540	alex-w	1811	public function dropSign($signID) {
539	alex-w	1812	$result = array();
		1813	$sSignID = $this->secure->checkInt($signID);
		1814
		1815	// Удаление подписи
		1816	$query = "DELETE FROM ".$this->prefix."signs WHERE sign_id='".$sSignID."'";
		1817	$rq =& $this->db->query($query);
		1818	if (PEAR::isError($this->db)) {
		1819	$result["ERR"] = 1;
		1820	$result["ERRINFO"] = $this->db->getMessage();
		1821	} else {
		1822	$result["ERR"] = 0;
		1823	}
		1824
		1825	return $result;
		1826	}
		1827
		1828	/**
540	alex-w	1829	* Добавление новой подписи
539	alex-w	1830	*
		1831	* @author Alexander Wolf
		1832	* @category Core
		1833	*
		1834	* @param string $sname
		1835	* @param string $sinfo
		1836	* @return array
		1837	*/
540	alex-w	1838	public function addSign($sname, $sinfo = "") {
539	alex-w	1839	$result = array();
582	alex-w	1840	$sSName = $this->secure->checkStr($sname);
		1841	$sSInfo = $this->secure->checkStr($sinfo);
539	alex-w	1842
540	alex-w	1843	$query = "INSERT INTO ".$this->prefix."signs SET sname='".$sSName."', sinfo='".$sSInfo."'";
539	alex-w	1844	$rq =& $this->db->query($query);
		1845	if (PEAR::isError($this->db)) {
		1846	$result["ERR"] = 1;
		1847	$result["ERRINFO"] = $this->db->getMessage();
		1848	} else {
		1849	$result["ERR"] = 0;
		1850	}
		1851
		1852	return $result;
		1853	}
540	alex-w	1854
539	alex-w	1855	/**
463	alex-w	1856	* Проверка пароля (из формы авторизации)
		1857	*
		1858	* @author Alexander Wolf
		1859	* @category Core
		1860	*
		1861	* @param string $word
		1862	* @return array
		1863	*/
368	alex-w	1864	public function checkSign($word) {
359	alex-w	1865	$result = array();
		1866
		1867	$sHash = $this->secure->encryptStr($word);
		1868	$pwd = $this->getOption("passwd");
		1869	if ($sHash == $pwd["OptValue"]) {
		1870	$result["ERR"] = 0;
		1871	$result["Location"] = "manager.php";
		1872	setcookie($this->cookie, $sHash);
		1873	} else {
		1874	$result["ERR"] = 1;
		1875	$result["ERRINFO"] = "Password not valid";
368	alex-w	1876	$result["Location"] = "manager.php?error=1";
359	alex-w	1877	}
		1878
		1879	return $result;
358	alex-w	1880	}
357	alex-w	1881
463	alex-w	1882	/**
		1883	* Проверка пароля (из cookies)
		1884	*
		1885	* @author Alexander Wolf
		1886	* @category Core
		1887	*
		1888	* @param string $hash
		1889	* @return array
		1890	*/
368	alex-w	1891	public function checkCookieSign($hash) {
359	alex-w	1892	$result = array();
		1893
		1894	$pwd = $this->getOption("passwd");
		1895	if ($hash == $pwd["OptValue"]) {
		1896	$result["ERR"] = 0;
		1897	} else {
		1898	$result["ERR"] = 1;
		1899	$result["ERRINFO"] = "Hash not valid";
368	alex-w	1900	$result["Location"] = "manager.php";
359	alex-w	1901	}
		1902
		1903	return $result;
		1904	}
		1905
463	alex-w	1906	/**
		1907	* Форма ввода пароля
		1908	*
		1909	* @author Alexander Wolf
		1910	* @category Core
		1911	*
		1912	* @return string
		1913	*/
368	alex-w	1914	public function showSigninForm() {
425	alex-w	1915	$show = "<div id='regform'>";
		1916	$show .= "<form action='process.php' method='post'>\n";
368	alex-w	1917	$show .= "<fieldset><legend>Пароль</legend>\n";
		1918	$show .= "<input type='hidden' name='mode' value='authorize'>\n";
427	alex-w	1919	$show .= "<input type='password' name='word' value=''>\n";
368	alex-w	1920	$show .= "<input type='submit' value=' Войти '>\n";
425	alex-w	1921	$show .= "</fieldset>\n</form></div>\n";
368	alex-w	1922
		1923	return $show;
		1924	}
		1925
463	alex-w	1926	/**
		1927	* Обновление пароля
		1928	*
		1929	* @author Alexander Wolf
		1930	* @category Core
		1931	*
		1932	* @param string $word1
		1933	* @param string $word2
		1934	* @return array
		1935	*/
368	alex-w	1936	public function updatePassword($word1, $word2) {
359	alex-w	1937	$result = array();
		1938
		1939	if ($word1 == $word2) {
		1940	$sWord = $this->secure->encryptStr($word1);
		1941	$r = $this->setOption("passwd", $sWord);
		1942	$result = $r;
		1943	} else {
		1944	$result["ERR"] = 1;
		1945	$result["ERRINFO"] = "Passwords is mismatch";
		1946	}
		1947
		1948	return $result;
		1949	}
		1950
504	alex-w	1951	/**
509	alex-w	1952	* Отображение формы создания и редактирования версии apt-дистрибутива
504	alex-w	1953	*
		1954	* @author Alexander Wolf
		1955	* @category Core
		1956	*
		1957	* @param string $name
		1958	* @param string $actor
		1959	* @param integer $versionID
		1960	* @return string
		1961	*/
511	alex-w	1962	public function showDistVersionsForm($versionID = 0, $info = '') {
509	alex-w	1963	$sVersionID = $this->secure->checkInt($versionID);
511	alex-w	1964	$sInfo = $this->secure->checkStr($info, 1);
		1965	if ($sInfo == "") {
		1966	$sInfo = "Версия дистрибутива";
		1967	}
509	alex-w	1968	if ($sVersionID != 0) {
		1969	// Режим редактирования
556	alex-w	1970	$query = "SELECT * FROM ".$this->prefix."version v JOIN ".$this->prefix."distribution d ON v.dist_id=d.dist_id WHERE v.version_id='".$sVersionID."'";
497	alex-w	1971	$rq =& $this->db->query($query);
		1972	$rq->fetchInto($element);
509	alex-w	1973	}
		1974
511	alex-w	1975	$show = "<fieldset><legend>".$sInfo."</legend>\n";
510	alex-w	1976	if ($sVersionID != 0) {
		1977	$show .= "<div class='inputbox'><label for='distname'>Дистрибутив:</label> <input type='text' name='distname' value='".$this->secure->checkStr($element["distname"],1)."' readonly='readonly'></div>\n";
		1978	} else {
		1979	$show .= "<div class='inputbox'><label for='distname'>Дистрибутив:</label> ".$this->showDistributionList("distname", "", "", "innerhtml")."</div>\n";
		1980	}
509	alex-w	1981	$show .= "<div class='inputbox'><label for='vname'>Название версии:</label> <input type='text' name='vname' value='".$this->secure->checkStr($element["vname"],1)."'></div>\n";
		1982	$show .= "<div class='inputbox'><label for='version'>Номер версии:</label> <input type='text' name='version' value='".$this->secure->checkStr($element["version"],1)."'></div>\n";
		1983	$show .= "<div class='inputbox'><label for='vcodename'>Кодовое имя версии:</label> <input type='text' name='vcodename' value='".$this->secure->checkStr($element["vcodename"],1)."'></div>\n";
		1984	$show .= "<div class='inputbox'><input type='submit' value=' Отправить данные '></div></fieldset>\n";
495	alex-w	1985
504	alex-w	1986	return $show;
509	alex-w	1987	}
504	alex-w	1988
520	alex-w	1989	/**
		1990	* Парсер схемы адреса репозитория
		1991	* FIXME Возможно не потребуется
		1992	*
		1993	* @author Alexander Wolf
		1994	* @category Core
		1995	*
		1996	* @param string $repstring
		1997	* @return integer
		1998	*/
		1999	public function repositoryParser($repstring) {
		2000	$tokens = array();
		2001	$sections = array();
		2002	$tokens = split(" ",$repstring);
		2003
		2004	if ($tokens[0] == "deb") {
		2005	// debian/ubuntu репозиторий "type proto://host/folder distr sections"
		2006	$url = parse_url($tokens[1]);
		2007	$distr = $tokens[2];
		2008
		2009	for($i=3;$i<count($tokens);$i++) {
		2010	$sections[] = $tokens[$i];
		2011	}
		2012	} else {
		2013	// altlinux репозиторий "type [sign] proto://host/folder base repname"
		2014	if (stripos($tokens[1],"]")!=0) {
		2015	$sign = $tokens[1];
		2016	$url = parse_url($tokens[2]);
		2017	$base = $tokens[3];
		2018	$repname = $tokens[4];
		2019	} else {
		2020	$url = parse_url($tokens[1]);
		2021	$base = $tokens[2];
		2022	$repname = $tokens[3];
		2023	}
		2024	}
		2025
		2026	$proto = $url["scheme"]."://";
		2027	$addr = $url["host"];
		2028	if ($url["port"]!="") {
		2029	$addr .= ":".$url["port"];
		2030	}
		2031	$path = $url["path"];
		2032
		2033	return 0;
		2034	}
		2035
539	alex-w	2036	/**
		2037	* Выгрузка картинок логотипов дистрибутивов
		2038	*
		2039	* @author Alexander Wolf
		2040	* @category Core
		2041	*
		2042	* @param string $path
		2043	* @param string $dist
		2044	* @param array $datafile
		2045	* @return integer
		2046	*/
535	alex-w	2047	public function uploadPicture($path, $dist, $datafile) {
		2048	$folder = $path.$dist."-orig.png";
		2049	$folderN = $path.$dist.".png";
		2050	$folderEM = $path.$dist."-em.png";
		2051
		2052	$distlogo = 0;
		2053	if (move_uploaded_file($datafile["distlogo"]["tmp_name"],$folder)) {
		2054	chmod($folder, 0644);
		2055	list($width, $height) = GetImageSize($folder);
		2056	$percent = 32/$height;
		2057	$newwidth = $width * $percent;
		2058	$newheight = $height * $percent;
		2059
		2060	$output = ImageCreateTrueColor($newwidth, $newheight);
		2061	$source = ImageCreateFromPNG($folder);
		2062
		2063	ImageCopyResampled($output, $source, 0, 0, 0, 0, $newwidth, $newheight, $width, $height);
		2064	ImagePNG($output, $folderEM);
		2065
		2066	$percent = 15/$height;
		2067	$newwidth = $width * $percent;
		2068	$newheight = $height * $percent;
		2069
		2070	$output = ImageCreateTrueColor($newwidth, $newheight);
		2071
		2072	ImageCopyResized($output, $source, 0, 0, 0, 0, $newwidth, $newheight, $width, $height);
		2073	ImagePNG($output, $folderN);
		2074
		2075	unlink($folder);
		2076	$distlogo = 1;
		2077	}
		2078	return $distlogo;
		2079	}
547	alex-w	2080
		2081	/**
		2082	* Показ списка репозиториев
		2083	*
		2084	* @author Alexander Wolf
		2085	* @category Core
		2086	*
		2087	* @param string $name
		2088	* @param string $actor
		2089	* @param string $format
		2090	* @return string
		2091	*/
548	alex-w	2092	public function showRepositoriesList($name, $actor, $format = 'list') {
643	alex-w	2093	$query = "SELECT r.,rt.,v.version_id,CONCAT(d.distname,' ',v.version,' “',v.vname,'”') AS fullname FROM ".$this->prefix."repository r ";
548	alex-w	2094	$query .= "JOIN ".$this->prefix."rtype rt ON rt.rtype_id=r.rtype_id ";
629	alex-w	2095	$query .= "JOIN ".$this->prefix."version v ON v.version_id=r.version ";
641	alex-w	2096	$query .= "JOIN ".$this->prefix."distribution d ON d.dist_id=v.dist_id ";
629	alex-w	2097	$query .= "ORDER BY v.version_id,r.rep_id ASC";
548	alex-w	2098	$rq =& $this->db->query($query);
639	alex-w	2099	$show = "<ul><li class='nomarker'></li>";
630	alex-w	2100	$splitter = 0;
548	alex-w	2101	while ($rq->fetchInto($element)) {
630	alex-w	2102	if ($splitter != $this->secure->checkInt($element["version_id"])) {
		2103	$splitter = $this->secure->checkInt($element["version_id"]);
645	alex-w	2104	$show .= "</ul><ul><li class='nomarker'><strong>Репозитории для ".$this->secure->checkStr($element["fullname"],1)."</strong></li>";
630	alex-w	2105	}
634	alex-w	2106	$show .= "<li>[<a href='".$actor."?mode=".$name."&action=edit&uuid=".$this->secure->checkInt($element["rep_id"])."' class='edit'>править</a>][<a href='".$actor."?mode=".$name."&action=delete&uuid=".$this->secure->checkInt($element["rep_id"])."' class='delete'>удалить</a>] ".$this->secure->checkStr($element["repname"],1)." (<em>".$this->secure->checkStr($element["rtype"],1)."</em>)</li>\n";
548	alex-w	2107	}
		2108	$show .= "</ul>";
547	alex-w	2109	return $show;
		2110	}
		2111
		2112	/**
558	alex-w	2113	* Вывод списка типов репозиториев
		2114	*
		2115	* @author Alexander Wolf
		2116	* @category Core
		2117	*
		2118	* @param integer $reptype
		2119	* @param string $name
		2120	* @return string
		2121	*/
		2122	public function showRepType($reptype = 0, $name = "") {
		2123	$sRT = $this->secure->checkInt($reptype);
		2124	$sNM = $this->secure->checkStr($name,1);
559	alex-w	2125	$query = "SELECT * FROM ".$this->prefix."rtype";
558	alex-w	2126	$rq =& $this->db->query($query);
		2127	$show = "<select name='".$sNM."' id='".$sNM."'>\n";
		2128	while ($rq->fetchInto($element)) {
		2129	if ($element["rtype_id"]==$sRT) {
		2130	$show .= "<option value='".$this->secure->checkInt($element["rtype_id"])."' selected>".$this->secure->checkStr($element["rtype"],1)."</option>\n";
		2131	} else {
		2132	$show .= "<option value='".$this->secure->checkInt($element["rtype_id"])."'>".$this->secure->checkStr($element["rtype"],1)."</option>\n";
		2133	}
		2134	}
		2135	$show .= "</select>";
		2136
		2137	return $show;
		2138	}
		2139
623	alex-w	2140	/**
		2141	* Вывод списка версий дистрибутивов
		2142	*
		2143	* @author Alexander Wolf
		2144	* @category Core
		2145	*
		2146	* @param string $name
		2147	* @param integer $versionID
		2148	* @return string
		2149	*/
591	alex-w	2150	public function showVDList($name, $versionID = 0) {
592	alex-w	2151	$query = "SELECT v.version_id, CONCAT(d.distname, ' ', v.version, ' ', v.vname) AS fullname FROM ".$this->prefix."version v ";
591	alex-w	2152	$query .= "JOIN ".$this->prefix."distribution d ON v.dist_id=d.dist_id";
		2153	$rq =& $this->db->query($query);
		2154	$show = "<select name='".$name."' id='".$name."'>\n";
		2155	while ($rq->fetchInto($element)) {
592	alex-w	2156	if ($element["version_id"]==$versionID) {
		2157	$show .= "<option value='".$this->secure->checkInt($element["version_id"])."' selected>".$this->secure->checkStr($element["fullname"],1)."</option>\n";
		2158	} else {
		2159	$show .= "<option value='".$this->secure->checkInt($element["version_id"])."'>".$this->secure->checkStr($element["fullname"],1)."</option>\n";
		2160	}
591	alex-w	2161	}
		2162	$show .= "</select>";
		2163	return $show;
		2164	}
		2165
558	alex-w	2166	/**
547	alex-w	2167	* Форма создания/редактирвоания репозиториев
		2168	*
		2169	* @author Alexander Wolf
		2170	* @category Core
		2171	*
		2172	* @param integer $repID
		2173	* @param string $info
		2174	* @param string $reptype
		2175	* @return string
		2176	*/
594	alex-w	2177	public function showRepositoriesForm($repID = 0, $info = "") {
556	alex-w	2178	$sRepID = $this->secure->checkInt($repID);
594	alex-w	2179	$sInfo = $this->secure->checkStr($info, 1);
556	alex-w	2180	if ($sInfo == "") {
		2181	$sInfo = "Репозиторий";
		2182	}
		2183	if ($sRepID != 0) {
		2184	// Режим редактирования
591	alex-w	2185	$query = "SELECT r.,v.,d.dist_id,dt.type FROM ".$this->prefix."repository r ";
556	alex-w	2186	$query .= "JOIN ".$this->prefix."version v ON r.version=v.version_id ";
		2187	$query .= "JOIN ".$this->prefix."distribution d ON v.dist_id=d.dist_id ";
		2188	$query .= "JOIN ".$this->prefix."dtype dt ON d.disttype=dt.type_id ";
		2189	$query .= "WHERE r.rep_id='".$sRepID."'";
		2190	$rq =& $this->db->query($query);
594	alex-w	2191	$rq->fetchInto($element);
556	alex-w	2192	}
		2193
594	alex-w	2194	$show = "<fieldset><legend>".$sInfo."</legend>\n";
609	alex-w	2195	$show .= "<div class='inputbox'><label for='rdist'>Дистрибутив:</label> ".$this->showVDList("rdist",$this->secure->checkInt($element["version_id"]),"innerhtml")."</div>\n";
626	alex-w	2196	$show .= "<div class='inputbox'><label for='rname'>Название репозитория:</label> <input type='text' name='rname' value=\"".$this->secure->checkStr($element["repname"],1)."\"></div>\n";
		2197	$show .= "<div class='inputbox'><label for='rinfo'>Описание репозитория:</label> <input type='text' name='rinfo' value=\"".$this->secure->checkStr($element["repinfo"],1)."\"></div>\n";
		2198	$show .= "<div class='inputbox'><label for='rkey'>Ключ подписи репозитория:</label> <input type='text' name='rkey' value=\"".$this->secure->checkStr($element["repkey"],1)."\"></div>\n";
576	alex-w	2199	$show .= "<div class='inputbox'><label for='rproto'>Протокол доступа:</label> ".$this->showProtoList("rproto",$this->secure->checkInt($element["proto_id"]),"innerhtml")."</div>\n";
588	alex-w	2200	$show .= "<div class='inputbox'><label for='rhost'>Хост репозитория:</label> ".$this->showHostsList("rhost",$this->secure->checkInt($element["rhost_id"]),"innerhtml")."</div>\n";
604	alex-w	2201	$show .= "<div class='inputbox'><label for='rfolder'>Корневая папка:</label> ".$this->showFoldersList("rfolder",$this->secure->checkInt($element["rfolder_id"]),"innerhtml")."</div>\n";
558	alex-w	2202	$show .= "<div class='inputbox'><label for='rtype'>Тип репозитория:</label> ".$this->showRepType($this->secure->checkInt($element["rtype_id"]), "rtype")."</div>\n";
564	alex-w	2203	$show .= "<div class='inputbox'><label for='rsects'>Секции репозитория:</label> <div class='formwrapper'>".$this->showSectionsList("rsects",$sRepID,"innerhtml")."</div></div>\n";
569	alex-w	2204	$show .= "<div class='inputbox'><label for='rarchs'>Архитектуры:</label> <div class='formwrapper'>".$this->showArchList("rarchs",$sRepID,"innerhtml")."</div></div>\n";
613	alex-w	2205	$show .= "<div class='inputbox'><label for='rscheme'>Схема репозитория:</label> ".$this->showSchemeList("rscheme",$this->secure->checkInt($element["scheme_id"]),"innerhtml")."</div>\n";
595	alex-w	2206	$show .= "<div class='inputbox'><label for='rsign'>Подпись репозитория:</label> ".$this->showSignsList("rsign",$this->secure->checkInt($element["sign_id"]),"innerhtml")."</div>\n";
556	alex-w	2207	$show .= "<div class='inputbox'><input type='submit' value=' Отправить данные '></div></fieldset>\n";
593	alex-w	2208
547	alex-w	2209	return $show;
		2210	}
598	alex-w	2211
		2212	/**
		2213	* Добавление нового репозитория
		2214	*
		2215	* @author Alexander Wolf
		2216	* @category Core
		2217	*
		2218	* @param integer $verionID
		2219	* @param string $rname
		2220	* @param string $rinfo
		2221	* @param string $rkey
		2222	* @param integer $proto
		2223	* @param integer $rhost
		2224	* @param integer $rfolder
		2225	* @param integer $rtype
		2226	* @param array $sections
		2227	* @param array $arch
		2228	* @param integer $scheme
		2229	* @param integer $sign
		2230	* @return array
		2231	*/
612	alex-w	2232	public function addRepository($verionID, $rname, $rinfo, $rkey, $proto, $rhost, $rfolder, $rtype, $scheme, $sign, $sections, $arch) {
598	alex-w	2233	$result = array();
		2234	$sVersionID = $this->secure->checkInt($verionID);
		2235	$sRName = $this->secure->checkStr($rname);
		2236	$sRInfo = $this->secure->checkStr($rinfo);
		2237	$sRKey = $this->secure->checkStr($rkey);
		2238	$sProto = $this->secure->checkInt($proto);
		2239	$sRHost = $this->secure->checkInt($rhost);
		2240	$sRFolder = $this->secure->checkInt($rfolder);
		2241	$sRType = $this->secure->checkInt($rtype);
		2242	$sRScheme = $this->secure->checkInt($scheme);
		2243	$sRSign = $this->secure->checkInt($sign);
		2244
602	alex-w	2245	$query = "INSERT INTO ".$this->prefix."repository SET proto_id='".$sProto."', rhost_id='".$sRHost."', rfolder_id='".$sRFolder."', version='".$sVersionID."', rtype_id='".$sRType."', scheme_id='".$sRScheme."', sign_id='".$sRSign."', repname='".$sRName."', repinfo='".$sRInfo."', repkey='".$sRKey."'";
598	alex-w	2246	$rq =& $this->db->query($query);
		2247
		2248	$query = "SELECT rep_id FROM ".$this->prefix."repository ORDER BY rep_id DESC LIMIT 0, 1";
		2249	$rq =& $this->db->query($query);
		2250	$rq->fetchInto($repository);
		2251
		2252	for($i=0;$i<count($sections);$i++) {
		2253	$query = "INSERT INTO ".$this->prefix."sect2rep SET rep_id='".$repository["rep_id"]."', sect_id='".$sections[$i]."'";
		2254	$rq =& $this->db->query($query);
		2255	}
		2256
		2257	for($i=0;$i<count($arch);$i++) {
		2258	$query = "INSERT INTO ".$this->prefix."arch2rep SET rep_id='".$repository["rep_id"]."', arch_id='".$arch[$i]."'";
		2259	$rq =& $this->db->query($query);
		2260	}
		2261
		2262	if (PEAR::isError($this->db)) {
		2263	$result["ERR"] = 1;
		2264	$result["ERRINFO"] = $this->db->getMessage();
		2265	} else {
		2266	$result["ERR"] = 0;
		2267	}
		2268
		2269	return $result;
		2270	}
618	alex-w	2271
		2272	/**
		2273	* Обновление информации о репозитории
		2274	*
		2275	* @author Alexander Wolf
		2276	* @category Core
		2277	*
		2278	* @param integer $repID
		2279	* @param integer $verionID
		2280	* @param string $rname
		2281	* @param string $rinfo
		2282	* @param string $rkey
		2283	* @param integer $proto
		2284	* @param integer $rhost
		2285	* @param integer $rfolder
		2286	* @param integer $rtype
		2287	* @param array $sections
		2288	* @param array $arch
		2289	* @param integer $scheme
		2290	* @param integer $sign
		2291	* @return array
		2292	*/
		2293	public function updateRepository($repID, $verionID, $rname, $rinfo, $rkey, $proto, $rhost, $rfolder, $rtype, $scheme, $sign, $sections, $arch) {
		2294	$result = array();
		2295	$sRepID = $this->secure->checkInt($repID);
		2296	$sVersionID = $this->secure->checkInt($verionID);
		2297	$sRName = $this->secure->checkStr($rname);
		2298	$sRInfo = $this->secure->checkStr($rinfo);
		2299	$sRKey = $this->secure->checkStr($rkey);
		2300	$sProto = $this->secure->checkInt($proto);
		2301	$sRHost = $this->secure->checkInt($rhost);
		2302	$sRFolder = $this->secure->checkInt($rfolder);
		2303	$sRType = $this->secure->checkInt($rtype);
		2304	$sRScheme = $this->secure->checkInt($scheme);
		2305	$sRSign = $this->secure->checkInt($sign);
		2306
		2307	$query = "UPDATE ".$this->prefix."repository SET proto_id='".$sProto."', rhost_id='".$sRHost."', rfolder_id='".$sRFolder."', version='".$sVersionID."', rtype_id='".$sRType."', scheme_id='".$sRScheme."', sign_id='".$sRSign."', repname='".$sRName."', repinfo='".$sRInfo."', repkey='".$sRKey."' WHERE rep_id='".$sRepID."'";
		2308	$rq =& $this->db->query($query);
		2309
		2310	$query = "DELETE FROM ".$this->prefix."sect2rep WHERE rep_id='".$sRepID."'";
		2311	$rq =& $this->db->query($query);
		2312	for($i=0;$i<count($sections);$i++) {
		2313	$query = "INSERT INTO ".$this->prefix."sect2rep SET rep_id='".$sRepID."', sect_id='".$sections[$i]."'";
		2314	$rq =& $this->db->query($query);
		2315	}
		2316
		2317	$query = "DELETE FROM ".$this->prefix."arch2rep WHERE rep_id='".$sRepID."'";
		2318	$rq =& $this->db->query($query);
		2319	for($i=0;$i<count($arch);$i++) {
		2320	$query = "INSERT INTO ".$this->prefix."arch2rep SET rep_id='".$sRepID."', arch_id='".$arch[$i]."'";
		2321	$rq =& $this->db->query($query);
		2322	}
		2323
		2324	if (PEAR::isError($this->db)) {
		2325	$result["ERR"] = 1;
		2326	$result["ERRINFO"] = $this->db->getMessage();
		2327	} else {
		2328	$result["ERR"] = 0;
		2329	}
		2330
		2331	return $result;
		2332	}
		2333
		2334	/**
		2335	* Удаление информации о репозитории
		2336	*
		2337	* @author Alexander Wolf
		2338	* @category Core
		2339	*
		2340	* @param integer $repID
		2341	* @return array
		2342	*/
		2343	public function dropRepository($repID) {
		2344	$result = array();
		2345	$sRepID = $this->secure->checkInt($repID);
		2346
		2347	// Удаление репозитория
		2348	$query = "DELETE FROM ".$this->prefix."repository WHERE rep_id='".$sRepID."'";
		2349	$rq =& $this->db->query($query);
		2350	if (PEAR::isError($this->db)) {
		2351	$result["ERR"] = 1;
		2352	$result["ERRINFO"] = $this->db->getMessage();
		2353	} else {
		2354	$result["ERR"] = 0;
		2355	}
		2356
		2357	// Удаление секций репозитория
		2358	$query = "DELETE FROM ".$this->prefix."sect2rep WHERE rep_id='".$sRepID."'";
		2359	$rq =& $this->db->query($query);
		2360	if (PEAR::isError($this->db)) {
		2361	$result["ERR"] = 1;
		2362	$result["ERRINFO"] = $this->db->getMessage();
		2363	} else {
		2364	$result["ERR"] = 0;
		2365	}
		2366
		2367	// Удаление архитектур репозитория
		2368	$query = "DELETE FROM ".$this->prefix."arch2rep WHERE rep_id='".$sRepID."'";
		2369	$rq =& $this->db->query($query);
		2370	if (PEAR::isError($this->db)) {
		2371	$result["ERR"] = 1;
		2372	$result["ERRINFO"] = $this->db->getMessage();
		2373	} else {
		2374	$result["ERR"] = 0;
		2375	}
		2376
		2377	return $result;
		2378	}
560	alex-w	2379
304	alex-w	2380	}
		2381
356	alex-w	2382	?>

Хранилища Subversion ant

(root)/branches/ant/0.9.x/lib/core.php - Редакция 671