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

Редакция	Автор	№ строки	Строка
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 ";
		272	$query .= "WHERE t.rtype_id='1' AND r.version='".$this->secure->checkInt($version)."'";
		273	$rq =& $this->db->query($query);
		274	switch ($format) {
		275	case 'html':
		276	$show = "<fieldset><legend>".$this->secure->checkStr($types["rtype"],1)."</legend>\n";
		277	while ($rq->fetchInto($element)) {
493	alex-w	278	$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	279	}
		280	$show .= "</fieldset>\n";
		281	break;
		282	case 'json':
		283	//TODO Доделать JSON-вывод списка секций основного репозитория
		284	break;
		285	}
318	alex-w	286
		287	return $show;
317	alex-w	288	}
		289
463	alex-w	290	/**
		291	* Получение и отображение списка репозиториев
		292	*
		293	* @author Alexander Wolf
		294	* @category Core
		295	*
		296	* @param integer $version
		297	* @param integer $reptype
		298	* @param string $format
		299	* @return string
		300	*/
368	alex-w	301	public function showRepList($version, $reptype, $format = 'html') {
406	alex-w	302	$query = "SELECT rtype FROM ".$this->prefix."rtype WHERE rtype_id='".$this->secure->checkInt($reptype)."'";
317	alex-w	303	$rq =& $this->db->query($query);
		304	$rq->fetchInto($types);
		305	$query = "SELECT * FROM ".$this->prefix."repository WHERE version='".$this->secure->checkInt($version)."' AND rtype_id='".$this->secure->checkInt($reptype)."'";
		306	$rq =& $this->db->query($query);
		307	switch ($format) {
		308	case 'html':
		309	$show = "<fieldset><legend>".$this->secure->checkStr($types["rtype"],1)."</legend>\n";
		310	while ($rq->fetchInto($types)) {
320	alex-w	311	$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	312	}
		313	$show .= "</fieldset>\n";
		314	break;
		315	case 'json':
		316	//TODO Доделать JSON-вывод списка репозиториев
		317	break;
		318	}
318	alex-w	319
		320	return $show;
317	alex-w	321	}
		322
463	alex-w	323	/**
		324	* Добавление поддержки нового apt-дистрибутива
		325	*
		326	* @author Alexander Wolf
		327	* @category Core
		328	*
		329	* @param string $distname
		330	* @param integer $disttype
		331	* @param string $distua
		332	* @param byte $distlogo
		333	* @return array
		334	*/
514	alex-w	335	public function addDistribution($distname, $disttype, $distua = '', $distlogo = 0) {
321	alex-w	336	$result = array();
516	alex-w	337	$sDName = $this->secure->checkStr($distname,1);
321	alex-w	338	$sDType = $this->secure->checkInt($disttype);
516	alex-w	339	$sDUAgt = $this->secure->checkStr($distua,1);
514	alex-w	340	$sDLogo = $this->secure->checkInt($distlogo);
321	alex-w	341
		342	$query = "INSERT INTO ".$this->prefix."distribution SET distname='".$sDName."', distua='".$sDUAgt."', disttype='".$sDType."', distlogo='".$sDLogo."'";
		343	$rq =& $this->db->query($query);
		344	if (PEAR::isError($this->db)) {
		345	$result["ERR"] = 1;
		346	$result["ERRINFO"] = $this->db->getMessage();
515	alex-w	347	} else {
321	alex-w	348	$result["ERR"] = 0;
		349	}
		350
		351	return $result;
		352	}
		353
463	alex-w	354	/**
514	alex-w	355	* Обновление информации о дистрибутиве
		356	*
		357	* @author Alexander Wolf
		358	* @category Core
		359	*
		360	* @param integer $distID
		361	* @param string $distname
		362	* @param integer $disttype
		363	* @param string $distua
		364	* @param integer $distlogo
		365	* @return array
		366	*/
538	alex-w	367	public function updateDistribution($distID, $distname, $disttype, $distua, $distlogo = 0) {
514	alex-w	368	$result = array();
		369	$sDID = $this->secure->checkInt($distID);
516	alex-w	370	$sDName = $this->secure->checkStr($distname,1);
514	alex-w	371	$sDType = $this->secure->checkInt($disttype);
516	alex-w	372	$sDUAgt = $this->secure->checkStr($distua,1);
514	alex-w	373	$sDLogo = $this->secure->checkInt($distlogo);
		374
538	alex-w	375	if ($sDLogo!=0) {
		376	$query = "UPDATE ".$this->prefix."distribution SET distname='".$sDName."', distua='".$sDUAgt."', disttype='".$sDType."', distlogo='".$sDLogo."' WHERE dist_id='".$sDID."'";
		377	} else {
		378	$query = "UPDATE ".$this->prefix."distribution SET distname='".$sDName."', distua='".$sDUAgt."', disttype='".$sDType."' WHERE dist_id='".$sDID."'";
		379	}
514	alex-w	380	$rq =& $this->db->query($query);
		381	if (PEAR::isError($this->db)) {
		382	$result["ERR"] = 1;
		383	$result["ERRINFO"] = $this->db->getMessage();
515	alex-w	384	} else {
514	alex-w	385	$result["ERR"] = 0;
		386	}
		387
		388	return $result;
		389	}
		390
		391	/**
		392	* Удаление информации о дистрибутиве
		393	*
		394	* @author Alexander Wolf
		395	* @category Core
		396	*
		397	* @param integer $distID
		398	* @return array
		399	*/
		400	public function dropDistribution($distID) {
		401	$result = array();
		402	$sDID = $this->secure->checkInt($distID);
		403
		404	// Удаление дистрибутива
		405	$query = "DELETE FROM ".$this->prefix."distribution WHERE dist_id='".$sDID."'";
		406	$rq =& $this->db->query($query);
		407	if (PEAR::isError($this->db)) {
		408	$result["ERR"] = 1;
		409	$result["ERRINFO"] = $this->db->getMessage();
519	alex-w	410	} else {
514	alex-w	411	$result["ERR"] = 0;
		412	}
		413
		414	// Удаление версий дистрибутива
		415	$query = "DELETE FROM ".$this->prefix."version WHERE dist_id='".$sDID."'";
		416	$rq =& $this->db->query($query);
		417	if (PEAR::isError($this->db)) {
		418	$result["ERR"] = 1;
		419	$result["ERRINFO"] = $this->db->getMessage();
519	alex-w	420	} else {
514	alex-w	421	$result["ERR"] = 0;
		422	}
		423
		424	return $result;
		425	}
		426
		427	/**
463	alex-w	428	* Добавление поддержки новой версии apt-дистрибутива
		429	*
		430	* @author Alexander Wolf
		431	* @category Core
		432	*
		433	* @param integer $distID
		434	* @param integer $version
		435	* @param string $vname
		436	* @param integer $vcodename
		437	* @return array
		438	*/
368	alex-w	439	public function addDistVersion($distID, $version, $vname = "", $vcodename = "") {
356	alex-w	440	$result = array();
463	alex-w	441	$sDistID = $this->secure->checkInt($distID);
516	alex-w	442	$sDVersion = $this->secure->checkStr($version,1);
		443	$sDVName = $this->secure->checkStr($vname,1);
		444	$sDVCName = $this->secure->checkStr($vcodename,1);
356	alex-w	445
		446	$query = "INSERT INTO ".$this->prefix."version SET dist_id='".$sDistID."', vname='".$sDVName."', version='".$sDVersion."', vcodename='".$sDVCName."'";
		447	$rq =& $this->db->query($query);
		448	if (PEAR::isError($this->db)) {
		449	$result["ERR"] = 1;
		450	$result["ERRINFO"] = $this->db->getMessage();
515	alex-w	451	} else {
356	alex-w	452	$result["ERR"] = 0;
		453	}
		454
		455	return $result;
		456	}
358	alex-w	457
463	alex-w	458	/**
514	alex-w	459	* Редактирование информации о версии дистрибутива
		460	*
		461	* @author Alexander Wolf
		462	* @category Core
		463	*
		464	* @param integer $versionID
		465	* @param string $version
		466	* @param string $vname
		467	* @param string $vcodename
		468	* @return array
		469	*/
		470	public function updateDistVersion($versionID, $version, $vname = "", $vcodename = "") {
		471	$result = array();
		472	$sVersID = $this->secure->checkInt($versionID);
516	alex-w	473	$sDVersion = $this->secure->checkStr($version,1);
		474	$sDVName = $this->secure->checkStr($vname,1);
		475	$sDVCName = $this->secure->checkStr($vcodename,1);
514	alex-w	476
		477	$query = "UPDATE ".$this->prefix."version SET vname='".$sDVName."', version='".$sDVersion."', vcodename='".$sDVCName."' WHERE version_id='".$sVersID."'";
		478	$rq =& $this->db->query($query);
		479	if (PEAR::isError($this->db)) {
		480	$result["ERR"] = 1;
		481	$result["ERRINFO"] = $this->db->getMessage();
515	alex-w	482	} else {
514	alex-w	483	$result["ERR"] = 0;
		484	}
		485
		486	return $result;
		487	}
		488
		489	/**
		490	* Удаление информации о версии дистрибутива
		491	*
		492	* @author Alexander Wolf
		493	* @category Core
		494	*
		495	* @param integer $versionID
		496	* @return array
		497	*/
		498	public function dropDistVersion($versionID) {
		499	$result = array();
		500	$sVersID = $this->secure->checkInt($versionID);
		501
		502	// Удаление версии дистрибутива
		503	$query = "DELETE FROM ".$this->prefix."version WHERE version_id='".$sVersID."'";
		504	$rq =& $this->db->query($query);
		505	if (PEAR::isError($this->db)) {
		506	$result["ERR"] = 1;
		507	$result["ERRINFO"] = $this->db->getMessage();
515	alex-w	508	} else {
514	alex-w	509	$result["ERR"] = 0;
		510	}
		511
		512	// Удаление репозиториев этой версии дистрибутива
		513	$query = "DELETE FROM ".$this->prefix."repository WHERE version='".$sVersID."'";
		514	$rq =& $this->db->query($query);
		515	if (PEAR::isError($this->db)) {
		516	$result["ERR"] = 1;
		517	$result["ERRINFO"] = $this->db->getMessage();
517	alex-w	518	} else {
514	alex-w	519	$result["ERR"] = 0;
		520	}
		521
		522	return $result;
		523	}
		524
		525	/**
463	alex-w	526	* Отображение типа дистрибутива
		527	*
		528	* @author Alexander Wolf
		529	* @category Core
		530	*
		531	* @param string $name
		532	* @param byte $type
		533	* @return string
		534	*/
368	alex-w	535	public function showDistTypeForm($name = "dtype",$type = 0) {
329	alex-w	536	$query = "SELECT * FROM ".$this->prefix."dtype";
		537	$rq =& $this->db->query($query);
		538	$show = "<select name='".$name."' id='".$name."'>\n";
		539	while ($rq->fetchInto($element)) {
347	alex-w	540	if ($element["type_id"] == $type) {
		541	$show .= "<option value='".$element["type_id"]."' selected>".$this->secure->checkStr($element["type"],1)."</option>\n";
329	alex-w	542	} else {
347	alex-w	543	$show .= "<option value='".$element["type_id"]."'>".$this->secure->checkStr($element["type"],1)."</option>\n";
329	alex-w	544	}
		545	}
		546	$show .= "</select>";
		547
		548	return $show;
		549	}
		550
463	alex-w	551	/**
		552	* Отображение формы создания и редактирования apt-дистрибутива
		553	*
		554	* @author Alexander Wolf
		555	* @category Core
		556	*
		557	* @param integer $distID
		558	* @return string
		559	*/
511	alex-w	560	public function showDistributionForm($distID = 0, $info = '') {
329	alex-w	561	$sDistID = $this->secure->checkInt($distID);
511	alex-w	562	$sInfo = $this->secure->checkStr($info, 1);
		563	if ($sInfo == "") {
		564	$sInfo = "Дистрибутив";
		565	}
329	alex-w	566	if ($sDistID != 0) {
		567	// Режим редактирования
		568	$query = "SELECT * FROM ".$this->prefix."distribution WHERE dist_id='".$sDistID."'";
		569	$rq =& $this->db->query($query);
		570	$rq->fetchInto($element);
		571	}
		572
		573	if ($element["distlogo"] == 1) {
380	alex-w	574	$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	575	} else {
380	alex-w	576	$image = "<img src='./img/d/empty-logo.png' width='32' height='32' id='adm-dist-logo' alt='Логотип дистрибутива' title='Логотип дистрибутива не загружен'>";
329	alex-w	577	}
		578
511	alex-w	579	$show = "<fieldset><legend>".$sInfo."</legend>\n";
350	alex-w	580	$show .= "<div class='inputbox'><label for='dname'>Название дистрибутива:</label> <input type='text' name='dname' id='dname' value='".$this->secure->checkStr($element["distname"],1)."'></div>\n";
		581	$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	582	$show .= "<div class='inputbox'><label for='dtype'>Тип дистрибутива:</label> ".$this->showDistTypeForm("dtype",$element["disttype"])."</div>\n";
348	alex-w	583	$show .= "<div class='inputbox'><table><tr><td class='td-name'>Логотип дистрибутива:</td>\n";
329	alex-w	584	$show .= "<td>".$image."</td>\n<td><input type='file' name='distlogo'></td>\n</tr></table>\n</div>\n";
350	alex-w	585	$show .= "<div class='inputbox'><input type='submit' value=' Отправить данные '></div>\n</fieldset>\n";
329	alex-w	586
		587	return $show;
		588	}
		589
358	alex-w	590	// sourses.list
423	alex-w	591	public function showSourcesList($distID,$versID,$sectIDs,$repIDs) {
		592	//TODO Написать генератор sources.list
358	alex-w	593	}
522	alex-w	594
463	alex-w	595	/**
522	alex-w	596	* Показывает список секций
		597	*
		598	* @author Alexander Wolf
		599	* @category Core
		600	*
		601	* @param string $name
		602	* @param string $actor
561	alex-w	603	* @param string $format
522	alex-w	604	* @return string
		605	*/
560	alex-w	606	public function showSectionsList($name, $actor, $format = 'html') {
		607	switch($format) {
		608	case 'html':
561	alex-w	609	$query = "SELECT * FROM ".$this->prefix."section";
		610	$rq =& $this->db->query($query);
560	alex-w	611	$show = "<ul>\n";
		612	while ($rq->fetchInto($element)) {
		613	$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";
		614	}
		615	$show .= "</ul>";
		616	break;
		617	case 'innerhtml':
		618	$show = "";
561	alex-w	619	$repID = $this->secure->checkInt($actor);
		620	if ($repID==0) {
		621	$query = "SELECT * FROM ".$this->prefix."section";
		622	$rq =& $this->db->query($query);
		623	while ($rq->fetchInto($element)) {
567	alex-w	624	$show .= "<input type='checkbox' name='".$name."[]' value='".$element["sect_id"]."'> ".$this->secure->checkStr($element["secname"],1)." ";
561	alex-w	625	}
		626	} else {
		627	$query = "SELECT * FROM ".$this->prefix."section s JOIN ".$this->prefix."sect2rep r ON s.sect_id=r.sect_id WHERE r.rep_id='$repID'";
		628	$rq =& $this->db->query($query);
		629	while ($rq->fetchInto($element)) {
567	alex-w	630	$show .= "<input type='checkbox' name='".$name."[]' value='".$element["sect_id"]."' checked> ".$this->secure->checkStr($element["secname"],1)." ";
561	alex-w	631	}
		632	$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	633	$rq =& $this->db->query($query);
561	alex-w	634	while ($rq->fetchInto($element)) {
567	alex-w	635	$show .= "<input type='checkbox' name='".$name."[]' value='".$element["sect_id"]."'> ".$this->secure->checkStr($element["secname"],1)." ";
561	alex-w	636	}
		637	}
		638
560	alex-w	639	break;
522	alex-w	640	}
		641
		642	return $show;
		643	}
		644
523	alex-w	645	/**
		646	* Вывод формы редактирования/добавления секций
		647	*
		648	* @author Alexander Wolf
		649	* @category Core
		650	*
		651	* @param integer $sectionID
		652	* @param string $info
		653	* @return string
		654	*/
		655	public function showSectionsForm($sectionID = 0, $info = "") {
522	alex-w	656	$sSectID = $this->secure->checkInt($sectionID);
		657	$sInfo = $this->secure->checkStr($info, 1);
		658	if ($sInfo == "") {
		659	$sInfo = "Секция";
		660	}
		661	if ($sSectID != 0) {
		662	// Режим редактирования
		663	$query = "SELECT * FROM ".$this->prefix."section WHERE sect_id='".$sSectID."'";
		664	$rq =& $this->db->query($query);
		665	$rq->fetchInto($element);
		666	}
		667
		668	$show = "<fieldset><legend>".$sInfo."</legend>\n";
		669	$show .= "<div class='inputbox'><label for='sname'>Название секции:</label> <input type='text' name='sname' id='sname' value='".$this->secure->checkStr($element["secname"],1)."'></div>\n";
		670	$show .= "<div class='inputbox'><label for='sinfo'>Описание секции:</label> <input type='text' name='sinfo' id='sinfo' value='".$this->secure->checkStr($element["sectinfo"],1)."'></div>\n";
		671	$show .= "<div class='inputbox'><input type='submit' value=' Отправить данные '></div>\n</fieldset>\n";
		672
		673	return $show;
		674	}
		675
		676	/**
523	alex-w	677	* Обновление информации о секции
		678	*
		679	* @author Alexander Wolf
		680	* @category Core
		681	*
		682	* @param integer $sectionID
		683	* @param string $sname
		684	* @param string $sinfo
		685	* @return array
		686	*/
		687	public function updateSection($sectionID, $sname, $sinfo = "") {
		688	$result = array();
		689	$sSectID = $this->secure->checkInt($sectionID);
		690	$sSName = $this->secure->checkStr($sname,1);
		691	$sSInfo = $this->secure->checkStr($sinfo,1);
		692
		693	$query = "UPDATE ".$this->prefix."section SET secname='".$sSName."', sectinfo='".$sSInfo."' WHERE sect_id='".$sSectID."'";
		694	$rq =& $this->db->query($query);
		695	if (PEAR::isError($this->db)) {
		696	$result["ERR"] = 1;
		697	$result["ERRINFO"] = $this->db->getMessage();
		698	} else {
		699	$result["ERR"] = 0;
		700	}
		701
		702	return $result;
		703	}
		704
		705	/**
		706	* Удаление информации о секции
		707	*
		708	* @author Alexander Wolf
		709	* @category Core
		710	*
		711	* @param integer $sectionID
		712	* @return array
		713	*/
		714	public function dropSection($sectionID) {
		715	$result = array();
		716	$sSectID = $this->secure->checkInt($sectionID);
		717
		718	// Удаление секции
		719	$query = "DELETE FROM ".$this->prefix."section WHERE sect_id='".$sSectID."'";
		720	$rq =& $this->db->query($query);
		721	if (PEAR::isError($this->db)) {
		722	$result["ERR"] = 1;
		723	$result["ERRINFO"] = $this->db->getMessage();
		724	} else {
		725	$result["ERR"] = 0;
		726	}
		727
		728	return $result;
		729	}
		730
		731	/**
		732	* Добавление новой секции
		733	*
		734	* @author Alexander Wolf
		735	* @category Core
		736	*
		737	* @param string $sname
		738	* @param string $sinfo
		739	* @return array
		740	*/
		741	public function addSection($sname, $sinfo = "") {
		742	$result = array();
		743	$sSName = $this->secure->checkStr($sname,1);
		744	$sSInfo = $this->secure->checkStr($sinfo,1);
		745
		746	$query = "INSERT INTO ".$this->prefix."section SET secname='".$sSName."', sectinfo='".$sSInfo."'";
		747	$rq =& $this->db->query($query);
		748	if (PEAR::isError($this->db)) {
		749	$result["ERR"] = 1;
		750	$result["ERRINFO"] = $this->db->getMessage();
		751	} else {
		752	$result["ERR"] = 0;
		753	}
		754
		755	return $result;
		756	}
		757
		758	/**
568	alex-w	759	* Вывод списка поддерживаемых архитектур
		760	*
		761	* @author Alexander Wolf
		762	* @category Core
		763	*
		764	* @param string $name
		765	* @param string $actor
		766	* @param string $format
		767	* @return string
		768	*/
		769	public function showArchList($name, $actor, $format = 'list') {
		770	switch($format) {
		771	case 'list':
		772	$query = "SELECT * FROM ".$this->prefix."arch";
		773	$rq =& $this->db->query($query);
		774	$show = "<ul>\n";
		775	while ($rq->fetchInto($element)) {
		776	$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";
		777	}
		778	$show .= "</ul>";
		779	break;
		780	case 'innerhtml':
		781	$show = "";
		782	$repID = $this->secure->checkInt($actor);
		783	if ($archID==0) {
		784	$query = "SELECT * FROM ".$this->prefix."arch";
		785	$rq =& $this->db->query($query);
		786	while ($rq->fetchInto($element)) {
		787	$show .= "<input type='checkbox' name='".$name."[]' value='".$element["arch_id"]."'> ".$this->secure->checkStr($element["arch"],1)." ";
		788	}
		789	} else {
		790	$query = "SELECT * FROM ".$this->prefix."arch a JOIN ".$this->prefix."arch2rep r ON a.arch_id=r.arch_id WHERE r.rep_id='$repID'";
		791	$rq =& $this->db->query($query);
		792	while ($rq->fetchInto($element)) {
		793	$show .= "<input type='checkbox' name='".$name."[]' value='".$element["arch_id"]."' checked> ".$this->secure->checkStr($element["arch"],1)." ";
		794	}
		795	$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')";
		796	$rq =& $this->db->query($query);
		797	while ($rq->fetchInto($element)) {
		798	$show .= "<input type='checkbox' name='".$name."[]' value='".$element["arch_id"]."'> ".$this->secure->checkStr($element["arch"],1)." ";
		799	}
		800	}
		801	break;
		802	}
		803	return $show;
		804	}
		805
		806	/**
		807	* Добавление новой архитектуры
		808	*
		809	* @author Alexander Wolf
		810	* @category Core
		811	*
		812	* @param string $arch
		813	* @return array
		814	*/
		815	public function addArch($arch) {
		816	$result = array();
		817	$sArch = $this->secure->checkStr($arch,1);
		818
		819	$query = "INSERT INTO ".$this->prefix."arch SET arch='".$sArch."'";
		820	$rq =& $this->db->query($query);
		821	if (PEAR::isError($this->db)) {
		822	$result["ERR"] = 1;
		823	$result["ERRINFO"] = $this->db->getMessage();
		824	} else {
		825	$result["ERR"] = 0;
		826	}
		827
		828	return $result;
		829	}
		830
		831	/**
		832	* Удаление информации об архитектуре
		833	*
		834	* @author Alexander Wolf
		835	* @category Core
		836	*
		837	* @param integer $archID
		838	* @return array
		839	*/
		840	public function dropArch($archID) {
		841	$result = array();
		842	$sArchID = $this->secure->checkInt($archID);
		843
		844	// Удаление архитектуры
		845	$query = "DELETE FROM ".$this->prefix."arch WHERE arch_id='".$sArchID."'";
		846	$rq =& $this->db->query($query);
		847	if (PEAR::isError($this->db)) {
		848	$result["ERR"] = 1;
		849	$result["ERRINFO"] = $this->db->getMessage();
		850	} else {
		851	$result["ERR"] = 0;
		852	}
		853
		854	// Удаление архитектуры из списка репозиториев
		855	$query = "DELETE FROM ".$this->prefix."arch2rep WHERE arch_id='".$sArchID."'";
		856	$rq =& $this->db->query($query);
		857	if (PEAR::isError($this->db)) {
		858	$result["ERR"] = 1;
		859	$result["ERRINFO"] = $this->db->getMessage();
		860	} else {
		861	$result["ERR"] = 0;
		862	}
		863	return $result;
		864	}
		865
		866	/**
		867	* Обновление информации об архитектуре
		868	*
		869	* @author Alexander Wolf
		870	* @category Core
		871	*
		872	* @param integer $archID
		873	* @param string $arch
		874	* @return array
		875	*/
		876	public function updateArch($archID, $arch) {
		877	$result = array();
		878	$sArchID = $this->secure->checkInt($archID);
		879	$sArch = $this->secure->checkStr($arch,1);
		880
		881	$query = "UPDATE ".$this->prefix."arch SET arch='".$sArch."' WHERE arch_id='".$sArchID."'";
		882	$rq =& $this->db->query($query);
		883	if (PEAR::isError($this->db)) {
		884	$result["ERR"] = 1;
		885	$result["ERRINFO"] = $this->db->getMessage();
		886	} else {
		887	$result["ERR"] = 0;
		888	}
		889
		890	return $result;
		891	}
		892
		893	/**
		894	* Вывод формы редактирования/добавления архитектур
		895	*
		896	* @author Alexander Wolf
		897	* @category Core
		898	*
		899	* @param integer $archID
		900	* @param string $info
		901	* @return string
		902	*/
		903	public function showArchForm($archID = 0, $info = "") {
		904	$sArchID = $this->secure->checkInt($archID);
		905	$sInfo = $this->secure->checkStr($info, 1);
		906	if ($sInfo == "") {
		907	$sInfo = "Архитектура";
		908	}
		909	if ($sArchID != 0) {
		910	// Режим редактирования
		911	$query = "SELECT * FROM ".$this->prefix."arch WHERE arch_id='".$sArchID."'";
		912	$rq =& $this->db->query($query);
		913	$rq->fetchInto($element);
		914	}
		915
		916	$show = "<fieldset><legend>".$sInfo."</legend>\n";
		917	$show .= "<div class='inputbox'><label for='arch'>Архитектура:</label> <input type='text' name='arch' id='arch' value='".$this->secure->checkStr($element["arch"],1)."'></div>\n";
		918	$show .= "<div class='inputbox'><input type='submit' value=' Отправить данные '></div>\n</fieldset>\n";
		919
		920	return $show;
		921	}
		922
		923	/**
570	alex-w	924	* Вывод списка схем репозиториев
		925	*
		926	* @author Alexander Wolf
		927	* @category Core
		928	*
		929	* @param string $name
		930	* @param string $actor
		931	* @param string $format
		932	* @return string
		933	*/
		934	public function showSchemeList($name, $actor, $format = 'list') {
		935	switch($format) {
		936	case 'list':
		937	$query = "SELECT * FROM ".$this->prefix."repscheme";
		938	$rq =& $this->db->query($query);
		939	$show = "<ul>\n";
		940	while ($rq->fetchInto($element)) {
		941	$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";
		942	}
		943	$show .= "</ul>";
		944	break;
		945	case 'innerhtml':
		946	$repID = $this->secure->checkInt($actor);
		947	$query = "SELECT * FROM ".$this->prefix."repscheme";
		948	$rq =& $this->db->query($query);
		949	$show = "<select name='".$name."' id='".$name."'>\n";
		950	while ($rq->fetchInto($element)) {
		951	if ($element["scheme_id"]==$repID) {
		952	$show .= "<option value='".$this->secure->checkInt($element["scheme_id"])."' selected>".$this->secure->checkStr($element["scheme"],1)."</option>\n";
		953	} else {
		954	$show .= "<option value='".$this->secure->checkInt($element["scheme_id"])."'>".$this->secure->checkStr($element["scheme"],1)."</option>\n";
		955	}
		956	}
		957	$show .= "</select>";
		958	break;
		959	}
		960	return $show;
		961	}
		962
		963	/**
		964	* Добавление новой схемы репозитория
		965	*
		966	* @author Alexander Wolf
		967	* @category Core
		968	*
		969	* @param string $scheme
		970	* @return array
		971	*/
		972	public function addScheme($scheme) {
		973	$result = array();
		974	$sScheme = $this->secure->checkStr($scheme,1);
		975
		976	$query = "INSERT INTO ".$this->prefix."repscheme SET scheme='".$sScheme."'";
		977	$rq =& $this->db->query($query);
		978	if (PEAR::isError($this->db)) {
		979	$result["ERR"] = 1;
		980	$result["ERRINFO"] = $this->db->getMessage();
		981	} else {
		982	$result["ERR"] = 0;
		983	}
		984
		985	return $result;
		986	}
		987
		988	/**
		989	* Удаление информации о схеме репозитория
		990	*
		991	* @author Alexander Wolf
		992	* @category Core
		993	*
		994	* @param integer $schemeID
		995	* @return array
		996	*/
		997	public function dropScheme($schemeID) {
		998	$result = array();
		999	$sSchemeID = $this->secure->checkInt($schemeID);
		1000
		1001	// Удаление схемы
		1002	$query = "DELETE FROM ".$this->prefix."repscheme WHERE scheme_id='".$sSchemeID."'";
		1003	$rq =& $this->db->query($query);
		1004	if (PEAR::isError($this->db)) {
		1005	$result["ERR"] = 1;
		1006	$result["ERRINFO"] = $this->db->getMessage();
		1007	} else {
		1008	$result["ERR"] = 0;
		1009	}
		1010
		1011	return $result;
		1012	}
		1013
		1014	/**
		1015	* Обновление информации о схеме репозитория
		1016	*
		1017	* @author Alexander Wolf
		1018	* @category Core
		1019	*
		1020	* @param integer $schemeID
		1021	* @param string $info
		1022	* @return array
		1023	*/
		1024	public function updateScheme($schemeID, $info) {
		1025	$result = array();
		1026	$sSchemeID = $this->secure->checkInt($schemeID);
		1027	$sScheme = $this->secure->checkStr($info,1);
		1028
		1029	$query = "UPDATE ".$this->prefix."repscheme SET scheme='".$sScheme."' WHERE scheme_id='".$sSchemeID."'";
		1030	$rq =& $this->db->query($query);
		1031	if (PEAR::isError($this->db)) {
		1032	$result["ERR"] = 1;
		1033	$result["ERRINFO"] = $this->db->getMessage();
		1034	} else {
		1035	$result["ERR"] = 0;
		1036	}
		1037
		1038	return $result;
		1039	}
		1040
		1041	/**
		1042	* Вывод формы редактирования/добавления схем репозиториев
		1043	*
		1044	* @author Alexander Wolf
		1045	* @category Core
		1046	*
		1047	* @param integer $schemeID
		1048	* @param string $info
		1049	* @return string
		1050	*/
		1051	public function showSchemeForm($schemeID = 0, $info = "") {
		1052	$sSchemeID = $this->secure->checkInt($schemeID);
		1053	$sInfo = $this->secure->checkStr($info, 1);
		1054	if ($sInfo == "") {
		1055	$sInfo = "Схема репозитория";
		1056	}
571	alex-w	1057	$show = "<fieldset><legend>".$sInfo."</legend>\n";
570	alex-w	1058	if ($sSchemeID != 0) {
		1059	// Режим редактирования
		1060	$query = "SELECT * FROM ".$this->prefix."repscheme WHERE scheme_id='".$sSchemeID."'";
		1061	$rq =& $this->db->query($query);
573	alex-w	1062	$rq->fetchInto($element);
		1063	}
571	alex-w	1064
573	alex-w	1065	$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	1066	$show .= "<div class='inputbox'><input type='submit' value=' Отправить данные '></div>\n</fieldset>\n";
		1067
		1068	return $show;
		1069	}
		1070
		1071	/**
574	alex-w	1072	* Вывод списка протоколов
		1073	*
		1074	* @author Alexander Wolf
		1075	* @category Core
		1076	*
		1077	* @param string $name
		1078	* @param string $actor
		1079	* @param string $format
		1080	* @return string
		1081	*/
		1082	public function showProtoList($name, $actor, $format = 'list') {
		1083	switch($format) {
		1084	case 'list':
		1085	$query = "SELECT * FROM ".$this->prefix."protos";
		1086	$rq =& $this->db->query($query);
		1087	$show = "<ul>\n";
		1088	while ($rq->fetchInto($element)) {
		1089	$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";
		1090	}
		1091	$show .= "</ul>";
		1092	break;
		1093	case 'innerhtml':
		1094	$protoID = $this->secure->checkInt($actor);
		1095	$query = "SELECT * FROM ".$this->prefix."protos";
		1096	$rq =& $this->db->query($query);
		1097	$show = "<select name='".$name."' id='".$name."'>\n";
		1098	while ($rq->fetchInto($element)) {
		1099	if ($element["proto_id"]==$protoID) {
		1100	$show .= "<option value='".$this->secure->checkInt($element["proto_id"])."' selected>".$this->secure->checkStr($element["proto"],1)."</option>\n";
		1101	} else {
		1102	$show .= "<option value='".$this->secure->checkInt($element["proto_id"])."'>".$this->secure->checkStr($element["scheme"],1)."</option>\n";
		1103	}
		1104	}
		1105	$show .= "</select>";
		1106	break;
		1107	}
		1108	return $show;
		1109	}
		1110
		1111	/**
		1112	* Добавление нового протокола
		1113	*
		1114	* @author Alexander Wolf
		1115	* @category Core
		1116	*
		1117	* @param string $proto
		1118	* @return array
		1119	*/
		1120	public function addProto($proto) {
		1121	$result = array();
		1122	$sProto = $this->secure->checkStr($proto,1);
		1123
		1124	$query = "INSERT INTO ".$this->prefix."protos SET proto='".$sProto."'";
		1125	$rq =& $this->db->query($query);
		1126	if (PEAR::isError($this->db)) {
		1127	$result["ERR"] = 1;
		1128	$result["ERRINFO"] = $this->db->getMessage();
		1129	} else {
		1130	$result["ERR"] = 0;
		1131	}
		1132
		1133	return $result;
		1134	}
		1135
		1136	/**
		1137	* Удаление информации о протоколе
		1138	*
		1139	* @author Alexander Wolf
		1140	* @category Core
		1141	*
		1142	* @param integer $protoID
		1143	* @return array
		1144	*/
		1145	public function dropProto($protoID) {
		1146	$result = array();
		1147	$sProtoID = $this->secure->checkInt($protoID);
		1148
		1149	// Удаление протокола
		1150	$query = "DELETE FROM ".$this->prefix."protos WHERE proto_id='".$sProtoID."'";
		1151	$rq =& $this->db->query($query);
		1152	if (PEAR::isError($this->db)) {
		1153	$result["ERR"] = 1;
		1154	$result["ERRINFO"] = $this->db->getMessage();
		1155	} else {
		1156	$result["ERR"] = 0;
		1157	}
		1158
		1159	return $result;
		1160	}
		1161
		1162	/**
		1163	* Обновление информации о протоколе
		1164	*
		1165	* @author Alexander Wolf
		1166	* @category Core
		1167	*
		1168	* @param integer $protoID
		1169	* @param string $info
		1170	* @return array
		1171	*/
		1172	public function updateProto($protoID, $info) {
		1173	$result = array();
		1174	$sProtoID = $this->secure->checkInt($protoID);
		1175	$sProto = $this->secure->checkStr($proto,1);
		1176
		1177	$query = "UPDATE ".$this->prefix."protos SET proto='".$sProto."' WHERE proto_id='".$sProtoID."'";
		1178	$rq =& $this->db->query($query);
		1179	if (PEAR::isError($this->db)) {
		1180	$result["ERR"] = 1;
		1181	$result["ERRINFO"] = $this->db->getMessage();
		1182	} else {
		1183	$result["ERR"] = 0;
		1184	}
		1185
		1186	return $result;
		1187	}
		1188
		1189	/**
		1190	* Вывод формы редактирования/добавления протоколов
		1191	*
		1192	* @author Alexander Wolf
		1193	* @category Core
		1194	*
		1195	* @param integer $protoID
		1196	* @param string $info
		1197	* @return string
		1198	*/
		1199	public function showProtoForm($protoID = 0, $info = "") {
		1200	$sProtoID = $this->secure->checkInt($protoID);
		1201	$sInfo = $this->secure->checkStr($info, 1);
		1202	if ($sInfo == "") {
		1203	$sInfo = "Протокол доступа";
		1204	}
		1205	$show = "<fieldset><legend>".$sInfo."</legend>\n";
		1206	if ($sProtoID != 0) {
		1207	// Режим редактирования
		1208	$query = "SELECT * FROM ".$this->prefix."protos WHERE proto_id='".$sProtoID."'";
		1209	$rq =& $this->db->query($query);
		1210	$rq->fetchInto($element);
		1211	}
		1212
		1213	$show .= "<div class='inputbox'><label for='proto'>Протокол доступа:</label> <input type='text' name='proto' id='proto' value='".$this->secure->checkStr($element["proto"],1)."'></div>\n";
		1214	$show .= "<div class='inputbox'><input type='submit' value=' Отправить данные '></div>\n</fieldset>\n";
		1215
		1216	return $show;
		1217	}
		1218
		1219	/**
539	alex-w	1220	* Показывает список подписей
		1221	*
		1222	* @author Alexander Wolf
		1223	* @category Core
		1224	*
		1225	* @param string $name
		1226	* @param string $actor
		1227	* @return string
		1228	*/
		1229	public function showSignsList($name, $actor) {
		1230	$query = "SELECT * FROM ".$this->prefix."signs";
		1231	$rq =& $this->db->query($query);
		1232	$show = "<ul>\n";
		1233	while ($rq->fetchInto($element)) {
545	alex-w	1234	$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";
539	alex-w	1235	}
		1236	$show .= "</ul>";
		1237
		1238	return $show;
		1239	}
		1240
		1241	/**
		1242	* Вывод формы редактирования/добавления подписей
		1243	*
		1244	* @author Alexander Wolf
		1245	* @category Core
		1246	*
		1247	* @param integer $sectionID
		1248	* @param string $info
		1249	* @return string
		1250	*/
		1251	public function showSignsForm($signID = 0, $info = "") {
		1252	$sSignID = $this->secure->checkInt($signID);
		1253	$sInfo = $this->secure->checkStr($info, 1);
		1254	if ($sInfo == "") {
		1255	$sInfo = "Подписи";
		1256	}
		1257	if ($sSignID != 0) {
		1258	// Режим редактирования
		1259	$query = "SELECT * FROM ".$this->prefix."signs WHERE sign_id='".$sSignID."'";
		1260	$rq =& $this->db->query($query);
		1261	$rq->fetchInto($element);
		1262	}
		1263
		1264	$show = "<fieldset><legend>".$sInfo."</legend>\n";
		1265	$show .= "<div class='inputbox'><label for='sname'>Название подписи:</label> <input type='text' name='sname' id='sname' value='".$this->secure->checkStr($element["sname"],1)."'></div>\n";
		1266	$show .= "<div class='inputbox'><label for='sinfo'>Описание подписи:</label> <input type='text' name='sinfo' id='sinfo' value='".$this->secure->checkStr($element["sinfo"],1)."'></div>\n";
		1267	$show .= "<div class='inputbox'><input type='submit' value=' Отправить данные '></div>\n</fieldset>\n";
		1268
		1269	return $show;
		1270	}
		1271
		1272	/**
		1273	* Обновление информации о секции
		1274	*
		1275	* @author Alexander Wolf
		1276	* @category Core
		1277	*
		1278	* @param integer $sectionID
		1279	* @param string $sname
		1280	* @param string $sinfo
		1281	* @return array
		1282	*/
		1283	public function updateSign($signID, $sname, $sinfo = "") {
		1284	$result = array();
		1285	$sSignID = $this->secure->checkInt($signID);
		1286	$sSName = $this->secure->checkStr($sname,1);
		1287	$sSInfo = $this->secure->checkStr($sinfo,1);
		1288
		1289	$query = "UPDATE ".$this->prefix."signs SET sname='".$sSName."', sinfo='".$sSInfo."' WHERE sign_id='".$sSignID."'";
		1290	$rq =& $this->db->query($query);
		1291	if (PEAR::isError($this->db)) {
		1292	$result["ERR"] = 1;
		1293	$result["ERRINFO"] = $this->db->getMessage();
		1294	} else {
		1295	$result["ERR"] = 0;
		1296	}
		1297
		1298	return $result;
		1299	}
		1300
		1301	/**
		1302	* Удаление информации о подписи
		1303	*
		1304	* @author Alexander Wolf
		1305	* @category Core
		1306	*
		1307	* @param integer $sectionID
		1308	* @return array
		1309	*/
540	alex-w	1310	public function dropSign($signID) {
539	alex-w	1311	$result = array();
		1312	$sSignID = $this->secure->checkInt($signID);
		1313
		1314	// Удаление подписи
		1315	$query = "DELETE FROM ".$this->prefix."signs WHERE sign_id='".$sSignID."'";
		1316	$rq =& $this->db->query($query);
		1317	if (PEAR::isError($this->db)) {
		1318	$result["ERR"] = 1;
		1319	$result["ERRINFO"] = $this->db->getMessage();
		1320	} else {
		1321	$result["ERR"] = 0;
		1322	}
		1323
		1324	return $result;
		1325	}
		1326
		1327	/**
540	alex-w	1328	* Добавление новой подписи
539	alex-w	1329	*
		1330	* @author Alexander Wolf
		1331	* @category Core
		1332	*
		1333	* @param string $sname
		1334	* @param string $sinfo
		1335	* @return array
		1336	*/
540	alex-w	1337	public function addSign($sname, $sinfo = "") {
539	alex-w	1338	$result = array();
		1339	$sSName = $this->secure->checkStr($sname,1);
		1340	$sSInfo = $this->secure->checkStr($sinfo,1);
		1341
540	alex-w	1342	$query = "INSERT INTO ".$this->prefix."signs SET sname='".$sSName."', sinfo='".$sSInfo."'";
539	alex-w	1343	$rq =& $this->db->query($query);
		1344	if (PEAR::isError($this->db)) {
		1345	$result["ERR"] = 1;
		1346	$result["ERRINFO"] = $this->db->getMessage();
		1347	} else {
		1348	$result["ERR"] = 0;
		1349	}
		1350
		1351	return $result;
		1352	}
540	alex-w	1353
539	alex-w	1354	/**
463	alex-w	1355	* Проверка пароля (из формы авторизации)
		1356	*
		1357	* @author Alexander Wolf
		1358	* @category Core
		1359	*
		1360	* @param string $word
		1361	* @return array
		1362	*/
368	alex-w	1363	public function checkSign($word) {
359	alex-w	1364	$result = array();
		1365
		1366	$sHash = $this->secure->encryptStr($word);
		1367	$pwd = $this->getOption("passwd");
		1368	if ($sHash == $pwd["OptValue"]) {
		1369	$result["ERR"] = 0;
		1370	$result["Location"] = "manager.php";
		1371	setcookie($this->cookie, $sHash);
		1372	} else {
		1373	$result["ERR"] = 1;
		1374	$result["ERRINFO"] = "Password not valid";
368	alex-w	1375	$result["Location"] = "manager.php?error=1";
359	alex-w	1376	}
		1377
		1378	return $result;
358	alex-w	1379	}
357	alex-w	1380
463	alex-w	1381	/**
		1382	* Проверка пароля (из cookies)
		1383	*
		1384	* @author Alexander Wolf
		1385	* @category Core
		1386	*
		1387	* @param string $hash
		1388	* @return array
		1389	*/
368	alex-w	1390	public function checkCookieSign($hash) {
359	alex-w	1391	$result = array();
		1392
		1393	$pwd = $this->getOption("passwd");
		1394	if ($hash == $pwd["OptValue"]) {
		1395	$result["ERR"] = 0;
		1396	} else {
		1397	$result["ERR"] = 1;
		1398	$result["ERRINFO"] = "Hash not valid";
368	alex-w	1399	$result["Location"] = "manager.php";
359	alex-w	1400	}
		1401
		1402	return $result;
		1403	}
		1404
463	alex-w	1405	/**
		1406	* Форма ввода пароля
		1407	*
		1408	* @author Alexander Wolf
		1409	* @category Core
		1410	*
		1411	* @return string
		1412	*/
368	alex-w	1413	public function showSigninForm() {
425	alex-w	1414	$show = "<div id='regform'>";
		1415	$show .= "<form action='process.php' method='post'>\n";
368	alex-w	1416	$show .= "<fieldset><legend>Пароль</legend>\n";
		1417	$show .= "<input type='hidden' name='mode' value='authorize'>\n";
427	alex-w	1418	$show .= "<input type='password' name='word' value=''>\n";
368	alex-w	1419	$show .= "<input type='submit' value=' Войти '>\n";
425	alex-w	1420	$show .= "</fieldset>\n</form></div>\n";
368	alex-w	1421
		1422	return $show;
		1423	}
		1424
463	alex-w	1425	/**
		1426	* Обновление пароля
		1427	*
		1428	* @author Alexander Wolf
		1429	* @category Core
		1430	*
		1431	* @param string $word1
		1432	* @param string $word2
		1433	* @return array
		1434	*/
368	alex-w	1435	public function updatePassword($word1, $word2) {
359	alex-w	1436	$result = array();
		1437
		1438	if ($word1 == $word2) {
		1439	$sWord = $this->secure->encryptStr($word1);
		1440	$r = $this->setOption("passwd", $sWord);
		1441	$result = $r;
		1442	} else {
		1443	$result["ERR"] = 1;
		1444	$result["ERRINFO"] = "Passwords is mismatch";
		1445	}
		1446
		1447	return $result;
		1448	}
		1449
504	alex-w	1450	/**
509	alex-w	1451	* Отображение формы создания и редактирования версии apt-дистрибутива
504	alex-w	1452	*
		1453	* @author Alexander Wolf
		1454	* @category Core
		1455	*
		1456	* @param string $name
		1457	* @param string $actor
		1458	* @param integer $versionID
		1459	* @return string
		1460	*/
511	alex-w	1461	public function showDistVersionsForm($versionID = 0, $info = '') {
509	alex-w	1462	$sVersionID = $this->secure->checkInt($versionID);
511	alex-w	1463	$sInfo = $this->secure->checkStr($info, 1);
		1464	if ($sInfo == "") {
		1465	$sInfo = "Версия дистрибутива";
		1466	}
509	alex-w	1467	if ($sVersionID != 0) {
		1468	// Режим редактирования
556	alex-w	1469	$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	1470	$rq =& $this->db->query($query);
		1471	$rq->fetchInto($element);
509	alex-w	1472	}
		1473
511	alex-w	1474	$show = "<fieldset><legend>".$sInfo."</legend>\n";
510	alex-w	1475	if ($sVersionID != 0) {
		1476	$show .= "<div class='inputbox'><label for='distname'>Дистрибутив:</label> <input type='text' name='distname' value='".$this->secure->checkStr($element["distname"],1)."' readonly='readonly'></div>\n";
		1477	} else {
		1478	$show .= "<div class='inputbox'><label for='distname'>Дистрибутив:</label> ".$this->showDistributionList("distname", "", "", "innerhtml")."</div>\n";
		1479	}
509	alex-w	1480	$show .= "<div class='inputbox'><label for='vname'>Название версии:</label> <input type='text' name='vname' value='".$this->secure->checkStr($element["vname"],1)."'></div>\n";
		1481	$show .= "<div class='inputbox'><label for='version'>Номер версии:</label> <input type='text' name='version' value='".$this->secure->checkStr($element["version"],1)."'></div>\n";
		1482	$show .= "<div class='inputbox'><label for='vcodename'>Кодовое имя версии:</label> <input type='text' name='vcodename' value='".$this->secure->checkStr($element["vcodename"],1)."'></div>\n";
		1483	$show .= "<div class='inputbox'><input type='submit' value=' Отправить данные '></div></fieldset>\n";
495	alex-w	1484
504	alex-w	1485	return $show;
509	alex-w	1486	}
504	alex-w	1487
520	alex-w	1488	/**
		1489	* Парсер схемы адреса репозитория
		1490	* FIXME Возможно не потребуется
		1491	*
		1492	* @author Alexander Wolf
		1493	* @category Core
		1494	*
		1495	* @param string $repstring
		1496	* @return integer
		1497	*/
		1498	public function repositoryParser($repstring) {
		1499	$tokens = array();
		1500	$sections = array();
		1501	$tokens = split(" ",$repstring);
		1502
		1503	if ($tokens[0] == "deb") {
		1504	// debian/ubuntu репозиторий "type proto://host/folder distr sections"
		1505	$url = parse_url($tokens[1]);
		1506	$distr = $tokens[2];
		1507
		1508	for($i=3;$i<count($tokens);$i++) {
		1509	$sections[] = $tokens[$i];
		1510	}
		1511	} else {
		1512	// altlinux репозиторий "type [sign] proto://host/folder base repname"
		1513	if (stripos($tokens[1],"]")!=0) {
		1514	$sign = $tokens[1];
		1515	$url = parse_url($tokens[2]);
		1516	$base = $tokens[3];
		1517	$repname = $tokens[4];
		1518	} else {
		1519	$url = parse_url($tokens[1]);
		1520	$base = $tokens[2];
		1521	$repname = $tokens[3];
		1522	}
		1523	}
		1524
		1525	$proto = $url["scheme"]."://";
		1526	$addr = $url["host"];
		1527	if ($url["port"]!="") {
		1528	$addr .= ":".$url["port"];
		1529	}
		1530	$path = $url["path"];
		1531
		1532	return 0;
		1533	}
		1534
539	alex-w	1535	/**
		1536	* Выгрузка картинок логотипов дистрибутивов
		1537	*
		1538	* @author Alexander Wolf
		1539	* @category Core
		1540	*
		1541	* @param string $path
		1542	* @param string $dist
		1543	* @param array $datafile
		1544	* @return integer
		1545	*/
535	alex-w	1546	public function uploadPicture($path, $dist, $datafile) {
		1547	$folder = $path.$dist."-orig.png";
		1548	$folderN = $path.$dist.".png";
		1549	$folderEM = $path.$dist."-em.png";
		1550
		1551	$distlogo = 0;
		1552	if (move_uploaded_file($datafile["distlogo"]["tmp_name"],$folder)) {
		1553	chmod($folder, 0644);
		1554	list($width, $height) = GetImageSize($folder);
		1555	$percent = 32/$height;
		1556	$newwidth = $width * $percent;
		1557	$newheight = $height * $percent;
		1558
		1559	$output = ImageCreateTrueColor($newwidth, $newheight);
		1560	$source = ImageCreateFromPNG($folder);
		1561
		1562	ImageCopyResampled($output, $source, 0, 0, 0, 0, $newwidth, $newheight, $width, $height);
		1563	ImagePNG($output, $folderEM);
		1564
		1565	$percent = 15/$height;
		1566	$newwidth = $width * $percent;
		1567	$newheight = $height * $percent;
		1568
		1569	$output = ImageCreateTrueColor($newwidth, $newheight);
		1570
		1571	ImageCopyResized($output, $source, 0, 0, 0, 0, $newwidth, $newheight, $width, $height);
		1572	ImagePNG($output, $folderN);
		1573
		1574	unlink($folder);
		1575	$distlogo = 1;
		1576	}
		1577	return $distlogo;
		1578	}
547	alex-w	1579
		1580	/**
		1581	* Показ списка репозиториев
		1582	*
		1583	* @author Alexander Wolf
		1584	* @category Core
		1585	*
		1586	* @param string $name
		1587	* @param string $actor
		1588	* @param string $format
		1589	* @return string
		1590	*/
548	alex-w	1591	public function showRepositoriesList($name, $actor, $format = 'list') {
549	alex-w	1592	$query = "SELECT * FROM ".$this->prefix."repository r ";
548	alex-w	1593	$query .= "JOIN ".$this->prefix."rtype rt ON rt.rtype_id=r.rtype_id ";
		1594	$rq =& $this->db->query($query);
		1595	$show = "<ul>";
		1596	while ($rq->fetchInto($element)) {
		1597	$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)." (".$this->secure->checkStr($element["rtype"],1).")</li>\n";
		1598	}
		1599	$show .= "</ul>";
547	alex-w	1600	return $show;
		1601	}
		1602
		1603	/**
558	alex-w	1604	* Вывод списка типов репозиториев
		1605	*
		1606	* @author Alexander Wolf
		1607	* @category Core
		1608	*
		1609	* @param integer $reptype
		1610	* @param string $name
		1611	* @return string
		1612	*/
		1613	public function showRepType($reptype = 0, $name = "") {
		1614	$sRT = $this->secure->checkInt($reptype);
		1615	$sNM = $this->secure->checkStr($name,1);
559	alex-w	1616	$query = "SELECT * FROM ".$this->prefix."rtype";
558	alex-w	1617	$rq =& $this->db->query($query);
		1618	$show = "<select name='".$sNM."' id='".$sNM."'>\n";
		1619	while ($rq->fetchInto($element)) {
		1620	if ($element["rtype_id"]==$sRT) {
		1621	$show .= "<option value='".$this->secure->checkInt($element["rtype_id"])."' selected>".$this->secure->checkStr($element["rtype"],1)."</option>\n";
		1622	} else {
		1623	$show .= "<option value='".$this->secure->checkInt($element["rtype_id"])."'>".$this->secure->checkStr($element["rtype"],1)."</option>\n";
		1624	}
		1625	}
		1626	$show .= "</select>";
		1627
		1628	return $show;
		1629	}
		1630
		1631	/**
547	alex-w	1632	* Форма создания/редактирвоания репозиториев
		1633	*
		1634	* @author Alexander Wolf
		1635	* @category Core
		1636	*
		1637	* @param integer $repID
		1638	* @param string $info
		1639	* @param string $reptype
		1640	* @return string
		1641	*/
		1642	public function showRepositoriesForm($repID = 0, $info = "", $reptype = "") {
556	alex-w	1643	$sRepID = $this->secure->checkInt($repID);
		1644	$sInfo = $this->secure->checkStr($info, 1);
		1645	$sRType = $this->secure->checkStr($reptype, 1);
		1646	if ($sInfo == "") {
		1647	$sInfo = "Репозиторий";
		1648	}
		1649	if ($sRType == "") {
		1650	$sRType = "deb";
		1651	}
		1652	if ($sRepID != 0) {
		1653	// Режим редактирования
558	alex-w	1654	$query = "SELECT r.rtype_id,r.repname,r.repinfo,r.repkey,p.proto,h.rhost,f.rfolder,v.*,d.distname,dt.type FROM ".$this->prefix."repository r ";
		1655	//$query .= "JOIN ".$this->prefix."rtype rt ON r.rtype_id=rt.rtype_id ";
556	alex-w	1656	$query .= "JOIN ".$this->prefix."protos p ON r.proto_id=p.proto_id ";
		1657	$query .= "JOIN ".$this->prefix."rephost h ON r.rhost_id=h.rhost_id ";
		1658	$query .= "JOIN ".$this->prefix."repfolder f ON r.rfolder_id=f.rfolder_id ";
		1659	$query .= "JOIN ".$this->prefix."version v ON r.version=v.version_id ";
		1660	$query .= "JOIN ".$this->prefix."distribution d ON v.dist_id=d.dist_id ";
		1661	$query .= "JOIN ".$this->prefix."dtype dt ON d.disttype=dt.type_id ";
		1662	$query .= "WHERE r.rep_id='".$sRepID."'";
		1663	$rq =& $this->db->query($query);
		1664	$rq->fetchInto($element);
		1665	$sRType = $this->secure->checkStr($element["type"],1);
		1666	}
		1667
		1668	$show = "<fieldset><legend>".$sInfo."</legend>\n";
		1669	$show .= "<div class='inputbox'><label for='rname'>Название репозитория:</label> <input type='text' name='rname' value='".$this->secure->checkStr($element["repname"],1)."'></div>\n";
		1670	$show .= "<div class='inputbox'><label for='rinfo'>Описание репозитория:</label> <input type='text' name='rinfo' value='".$this->secure->checkStr($element["repinfo"],1)."'></div>\n";
		1671	$show .= "<div class='inputbox'><label for='rkey'>Ключ подписи репозитория:</label> <input type='text' name='rkey' value='".$this->secure->checkStr($element["repkey"],1)."'></div>\n";
		1672	$show .= "<div class='inputbox'><label for='rproto'>Протокол доступа:</label> <input type='text' name='rproto' value='".$this->secure->checkStr($element["proto"],1)."'></div>\n";
		1673	$show .= "<div class='inputbox'><label for='rhost'>Хост репозитория:</label> <input type='text' name='rhost' value='".$this->secure->checkStr($element["rhost"],1)."'></div>\n";
		1674	$show .= "<div class='inputbox'><label for='rfolder'>Корневая папка:</label> <input type='text' name='rfolder' value='".$this->secure->checkStr($element["rfolder"],1)."'></div>\n";
558	alex-w	1675	$show .= "<div class='inputbox'><label for='rtype'>Тип репозитория:</label> ".$this->showRepType($this->secure->checkInt($element["rtype_id"]), "rtype")."</div>\n";
564	alex-w	1676	$show .= "<div class='inputbox'><label for='rsects'>Секции репозитория:</label> <div class='formwrapper'>".$this->showSectionsList("rsects",$sRepID,"innerhtml")."</div></div>\n";
569	alex-w	1677	$show .= "<div class='inputbox'><label for='rarchs'>Архитектуры:</label> <div class='formwrapper'>".$this->showArchList("rarchs",$sRepID,"innerhtml")."</div></div>\n";
570	alex-w	1678	$show .= "<div class='inputbox'><label for='rscheme'>Схема репозитория:</label> ".$this->showSchemeList("rscheme",$sRepID,"innerhtml")."</div>\n";
556	alex-w	1679	$show .= "<div class='inputbox'><input type='submit' value=' Отправить данные '></div></fieldset>\n";
		1680
547	alex-w	1681	return $show;
556	alex-w	1682	return $show;
547	alex-w	1683	}
560	alex-w	1684
304	alex-w	1685	}
		1686
356	alex-w	1687	?>

Хранилища Subversion ant

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