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

Редакция	Автор	№ строки	Строка
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);
		1062	$rq->fetchInto($element);
571	alex-w	1063	$show .= "<div class='inputbox'><label for='scheme'>Схема репозитория:</label> ".$this->showSchemeList("scheme", $element["scheme_id"],"innerhtml")."</div>\n";
		1064	} else {
		1065	$show .= "<div class='inputbox'><label for='scheme'>Схема репозитория:</label> <input type='text' name='scheme' id='scheme' value=''></div>\n";
570	alex-w	1066	}
571	alex-w	1067
570	alex-w	1068	$show .= "<div class='inputbox'><input type='submit' value=' Отправить данные '></div>\n</fieldset>\n";
		1069
		1070	return $show;
		1071	}
		1072
		1073	/**
539	alex-w	1074	* Показывает список подписей
		1075	*
		1076	* @author Alexander Wolf
		1077	* @category Core
		1078	*
		1079	* @param string $name
		1080	* @param string $actor
		1081	* @return string
		1082	*/
		1083	public function showSignsList($name, $actor) {
		1084	$query = "SELECT * FROM ".$this->prefix."signs";
		1085	$rq =& $this->db->query($query);
		1086	$show = "<ul>\n";
		1087	while ($rq->fetchInto($element)) {
545	alex-w	1088	$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	1089	}
		1090	$show .= "</ul>";
		1091
		1092	return $show;
		1093	}
		1094
		1095	/**
		1096	* Вывод формы редактирования/добавления подписей
		1097	*
		1098	* @author Alexander Wolf
		1099	* @category Core
		1100	*
		1101	* @param integer $sectionID
		1102	* @param string $info
		1103	* @return string
		1104	*/
		1105	public function showSignsForm($signID = 0, $info = "") {
		1106	$sSignID = $this->secure->checkInt($signID);
		1107	$sInfo = $this->secure->checkStr($info, 1);
		1108	if ($sInfo == "") {
		1109	$sInfo = "Подписи";
		1110	}
		1111	if ($sSignID != 0) {
		1112	// Режим редактирования
		1113	$query = "SELECT * FROM ".$this->prefix."signs WHERE sign_id='".$sSignID."'";
		1114	$rq =& $this->db->query($query);
		1115	$rq->fetchInto($element);
		1116	}
		1117
		1118	$show = "<fieldset><legend>".$sInfo."</legend>\n";
		1119	$show .= "<div class='inputbox'><label for='sname'>Название подписи:</label> <input type='text' name='sname' id='sname' value='".$this->secure->checkStr($element["sname"],1)."'></div>\n";
		1120	$show .= "<div class='inputbox'><label for='sinfo'>Описание подписи:</label> <input type='text' name='sinfo' id='sinfo' value='".$this->secure->checkStr($element["sinfo"],1)."'></div>\n";
		1121	$show .= "<div class='inputbox'><input type='submit' value=' Отправить данные '></div>\n</fieldset>\n";
		1122
		1123	return $show;
		1124	}
		1125
		1126	/**
		1127	* Обновление информации о секции
		1128	*
		1129	* @author Alexander Wolf
		1130	* @category Core
		1131	*
		1132	* @param integer $sectionID
		1133	* @param string $sname
		1134	* @param string $sinfo
		1135	* @return array
		1136	*/
		1137	public function updateSign($signID, $sname, $sinfo = "") {
		1138	$result = array();
		1139	$sSignID = $this->secure->checkInt($signID);
		1140	$sSName = $this->secure->checkStr($sname,1);
		1141	$sSInfo = $this->secure->checkStr($sinfo,1);
		1142
		1143	$query = "UPDATE ".$this->prefix."signs SET sname='".$sSName."', sinfo='".$sSInfo."' WHERE sign_id='".$sSignID."'";
		1144	$rq =& $this->db->query($query);
		1145	if (PEAR::isError($this->db)) {
		1146	$result["ERR"] = 1;
		1147	$result["ERRINFO"] = $this->db->getMessage();
		1148	} else {
		1149	$result["ERR"] = 0;
		1150	}
		1151
		1152	return $result;
		1153	}
		1154
		1155	/**
		1156	* Удаление информации о подписи
		1157	*
		1158	* @author Alexander Wolf
		1159	* @category Core
		1160	*
		1161	* @param integer $sectionID
		1162	* @return array
		1163	*/
540	alex-w	1164	public function dropSign($signID) {
539	alex-w	1165	$result = array();
		1166	$sSignID = $this->secure->checkInt($signID);
		1167
		1168	// Удаление подписи
		1169	$query = "DELETE FROM ".$this->prefix."signs WHERE sign_id='".$sSignID."'";
		1170	$rq =& $this->db->query($query);
		1171	if (PEAR::isError($this->db)) {
		1172	$result["ERR"] = 1;
		1173	$result["ERRINFO"] = $this->db->getMessage();
		1174	} else {
		1175	$result["ERR"] = 0;
		1176	}
		1177
		1178	return $result;
		1179	}
		1180
		1181	/**
540	alex-w	1182	* Добавление новой подписи
539	alex-w	1183	*
		1184	* @author Alexander Wolf
		1185	* @category Core
		1186	*
		1187	* @param string $sname
		1188	* @param string $sinfo
		1189	* @return array
		1190	*/
540	alex-w	1191	public function addSign($sname, $sinfo = "") {
539	alex-w	1192	$result = array();
		1193	$sSName = $this->secure->checkStr($sname,1);
		1194	$sSInfo = $this->secure->checkStr($sinfo,1);
		1195
540	alex-w	1196	$query = "INSERT INTO ".$this->prefix."signs SET sname='".$sSName."', sinfo='".$sSInfo."'";
539	alex-w	1197	$rq =& $this->db->query($query);
		1198	if (PEAR::isError($this->db)) {
		1199	$result["ERR"] = 1;
		1200	$result["ERRINFO"] = $this->db->getMessage();
		1201	} else {
		1202	$result["ERR"] = 0;
		1203	}
		1204
		1205	return $result;
		1206	}
540	alex-w	1207
539	alex-w	1208	/**
463	alex-w	1209	* Проверка пароля (из формы авторизации)
		1210	*
		1211	* @author Alexander Wolf
		1212	* @category Core
		1213	*
		1214	* @param string $word
		1215	* @return array
		1216	*/
368	alex-w	1217	public function checkSign($word) {
359	alex-w	1218	$result = array();
		1219
		1220	$sHash = $this->secure->encryptStr($word);
		1221	$pwd = $this->getOption("passwd");
		1222	if ($sHash == $pwd["OptValue"]) {
		1223	$result["ERR"] = 0;
		1224	$result["Location"] = "manager.php";
		1225	setcookie($this->cookie, $sHash);
		1226	} else {
		1227	$result["ERR"] = 1;
		1228	$result["ERRINFO"] = "Password not valid";
368	alex-w	1229	$result["Location"] = "manager.php?error=1";
359	alex-w	1230	}
		1231
		1232	return $result;
358	alex-w	1233	}
357	alex-w	1234
463	alex-w	1235	/**
		1236	* Проверка пароля (из cookies)
		1237	*
		1238	* @author Alexander Wolf
		1239	* @category Core
		1240	*
		1241	* @param string $hash
		1242	* @return array
		1243	*/
368	alex-w	1244	public function checkCookieSign($hash) {
359	alex-w	1245	$result = array();
		1246
		1247	$pwd = $this->getOption("passwd");
		1248	if ($hash == $pwd["OptValue"]) {
		1249	$result["ERR"] = 0;
		1250	} else {
		1251	$result["ERR"] = 1;
		1252	$result["ERRINFO"] = "Hash not valid";
368	alex-w	1253	$result["Location"] = "manager.php";
359	alex-w	1254	}
		1255
		1256	return $result;
		1257	}
		1258
463	alex-w	1259	/**
		1260	* Форма ввода пароля
		1261	*
		1262	* @author Alexander Wolf
		1263	* @category Core
		1264	*
		1265	* @return string
		1266	*/
368	alex-w	1267	public function showSigninForm() {
425	alex-w	1268	$show = "<div id='regform'>";
		1269	$show .= "<form action='process.php' method='post'>\n";
368	alex-w	1270	$show .= "<fieldset><legend>Пароль</legend>\n";
		1271	$show .= "<input type='hidden' name='mode' value='authorize'>\n";
427	alex-w	1272	$show .= "<input type='password' name='word' value=''>\n";
368	alex-w	1273	$show .= "<input type='submit' value=' Войти '>\n";
425	alex-w	1274	$show .= "</fieldset>\n</form></div>\n";
368	alex-w	1275
		1276	return $show;
		1277	}
		1278
463	alex-w	1279	/**
		1280	* Обновление пароля
		1281	*
		1282	* @author Alexander Wolf
		1283	* @category Core
		1284	*
		1285	* @param string $word1
		1286	* @param string $word2
		1287	* @return array
		1288	*/
368	alex-w	1289	public function updatePassword($word1, $word2) {
359	alex-w	1290	$result = array();
		1291
		1292	if ($word1 == $word2) {
		1293	$sWord = $this->secure->encryptStr($word1);
		1294	$r = $this->setOption("passwd", $sWord);
		1295	$result = $r;
		1296	} else {
		1297	$result["ERR"] = 1;
		1298	$result["ERRINFO"] = "Passwords is mismatch";
		1299	}
		1300
		1301	return $result;
		1302	}
		1303
504	alex-w	1304	/**
509	alex-w	1305	* Отображение формы создания и редактирования версии apt-дистрибутива
504	alex-w	1306	*
		1307	* @author Alexander Wolf
		1308	* @category Core
		1309	*
		1310	* @param string $name
		1311	* @param string $actor
		1312	* @param integer $versionID
		1313	* @return string
		1314	*/
511	alex-w	1315	public function showDistVersionsForm($versionID = 0, $info = '') {
509	alex-w	1316	$sVersionID = $this->secure->checkInt($versionID);
511	alex-w	1317	$sInfo = $this->secure->checkStr($info, 1);
		1318	if ($sInfo == "") {
		1319	$sInfo = "Версия дистрибутива";
		1320	}
509	alex-w	1321	if ($sVersionID != 0) {
		1322	// Режим редактирования
556	alex-w	1323	$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	1324	$rq =& $this->db->query($query);
		1325	$rq->fetchInto($element);
509	alex-w	1326	}
		1327
511	alex-w	1328	$show = "<fieldset><legend>".$sInfo."</legend>\n";
510	alex-w	1329	if ($sVersionID != 0) {
		1330	$show .= "<div class='inputbox'><label for='distname'>Дистрибутив:</label> <input type='text' name='distname' value='".$this->secure->checkStr($element["distname"],1)."' readonly='readonly'></div>\n";
		1331	} else {
		1332	$show .= "<div class='inputbox'><label for='distname'>Дистрибутив:</label> ".$this->showDistributionList("distname", "", "", "innerhtml")."</div>\n";
		1333	}
509	alex-w	1334	$show .= "<div class='inputbox'><label for='vname'>Название версии:</label> <input type='text' name='vname' value='".$this->secure->checkStr($element["vname"],1)."'></div>\n";
		1335	$show .= "<div class='inputbox'><label for='version'>Номер версии:</label> <input type='text' name='version' value='".$this->secure->checkStr($element["version"],1)."'></div>\n";
		1336	$show .= "<div class='inputbox'><label for='vcodename'>Кодовое имя версии:</label> <input type='text' name='vcodename' value='".$this->secure->checkStr($element["vcodename"],1)."'></div>\n";
		1337	$show .= "<div class='inputbox'><input type='submit' value=' Отправить данные '></div></fieldset>\n";
495	alex-w	1338
504	alex-w	1339	return $show;
509	alex-w	1340	}
504	alex-w	1341
520	alex-w	1342	/**
		1343	* Парсер схемы адреса репозитория
		1344	* FIXME Возможно не потребуется
		1345	*
		1346	* @author Alexander Wolf
		1347	* @category Core
		1348	*
		1349	* @param string $repstring
		1350	* @return integer
		1351	*/
		1352	public function repositoryParser($repstring) {
		1353	$tokens = array();
		1354	$sections = array();
		1355	$tokens = split(" ",$repstring);
		1356
		1357	if ($tokens[0] == "deb") {
		1358	// debian/ubuntu репозиторий "type proto://host/folder distr sections"
		1359	$url = parse_url($tokens[1]);
		1360	$distr = $tokens[2];
		1361
		1362	for($i=3;$i<count($tokens);$i++) {
		1363	$sections[] = $tokens[$i];
		1364	}
		1365	} else {
		1366	// altlinux репозиторий "type [sign] proto://host/folder base repname"
		1367	if (stripos($tokens[1],"]")!=0) {
		1368	$sign = $tokens[1];
		1369	$url = parse_url($tokens[2]);
		1370	$base = $tokens[3];
		1371	$repname = $tokens[4];
		1372	} else {
		1373	$url = parse_url($tokens[1]);
		1374	$base = $tokens[2];
		1375	$repname = $tokens[3];
		1376	}
		1377	}
		1378
		1379	$proto = $url["scheme"]."://";
		1380	$addr = $url["host"];
		1381	if ($url["port"]!="") {
		1382	$addr .= ":".$url["port"];
		1383	}
		1384	$path = $url["path"];
		1385
		1386	return 0;
		1387	}
		1388
539	alex-w	1389	/**
		1390	* Выгрузка картинок логотипов дистрибутивов
		1391	*
		1392	* @author Alexander Wolf
		1393	* @category Core
		1394	*
		1395	* @param string $path
		1396	* @param string $dist
		1397	* @param array $datafile
		1398	* @return integer
		1399	*/
535	alex-w	1400	public function uploadPicture($path, $dist, $datafile) {
		1401	$folder = $path.$dist."-orig.png";
		1402	$folderN = $path.$dist.".png";
		1403	$folderEM = $path.$dist."-em.png";
		1404
		1405	$distlogo = 0;
		1406	if (move_uploaded_file($datafile["distlogo"]["tmp_name"],$folder)) {
		1407	chmod($folder, 0644);
		1408	list($width, $height) = GetImageSize($folder);
		1409	$percent = 32/$height;
		1410	$newwidth = $width * $percent;
		1411	$newheight = $height * $percent;
		1412
		1413	$output = ImageCreateTrueColor($newwidth, $newheight);
		1414	$source = ImageCreateFromPNG($folder);
		1415
		1416	ImageCopyResampled($output, $source, 0, 0, 0, 0, $newwidth, $newheight, $width, $height);
		1417	ImagePNG($output, $folderEM);
		1418
		1419	$percent = 15/$height;
		1420	$newwidth = $width * $percent;
		1421	$newheight = $height * $percent;
		1422
		1423	$output = ImageCreateTrueColor($newwidth, $newheight);
		1424
		1425	ImageCopyResized($output, $source, 0, 0, 0, 0, $newwidth, $newheight, $width, $height);
		1426	ImagePNG($output, $folderN);
		1427
		1428	unlink($folder);
		1429	$distlogo = 1;
		1430	}
		1431	return $distlogo;
		1432	}
547	alex-w	1433
		1434	/**
		1435	* Показ списка репозиториев
		1436	*
		1437	* @author Alexander Wolf
		1438	* @category Core
		1439	*
		1440	* @param string $name
		1441	* @param string $actor
		1442	* @param string $format
		1443	* @return string
		1444	*/
548	alex-w	1445	public function showRepositoriesList($name, $actor, $format = 'list') {
549	alex-w	1446	$query = "SELECT * FROM ".$this->prefix."repository r ";
548	alex-w	1447	$query .= "JOIN ".$this->prefix."rtype rt ON rt.rtype_id=r.rtype_id ";
		1448	$rq =& $this->db->query($query);
		1449	$show = "<ul>";
		1450	while ($rq->fetchInto($element)) {
		1451	$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";
		1452	}
		1453	$show .= "</ul>";
547	alex-w	1454	return $show;
		1455	}
		1456
		1457	/**
558	alex-w	1458	* Вывод списка типов репозиториев
		1459	*
		1460	* @author Alexander Wolf
		1461	* @category Core
		1462	*
		1463	* @param integer $reptype
		1464	* @param string $name
		1465	* @return string
		1466	*/
		1467	public function showRepType($reptype = 0, $name = "") {
		1468	$sRT = $this->secure->checkInt($reptype);
		1469	$sNM = $this->secure->checkStr($name,1);
559	alex-w	1470	$query = "SELECT * FROM ".$this->prefix."rtype";
558	alex-w	1471	$rq =& $this->db->query($query);
		1472	$show = "<select name='".$sNM."' id='".$sNM."'>\n";
		1473	while ($rq->fetchInto($element)) {
		1474	if ($element["rtype_id"]==$sRT) {
		1475	$show .= "<option value='".$this->secure->checkInt($element["rtype_id"])."' selected>".$this->secure->checkStr($element["rtype"],1)."</option>\n";
		1476	} else {
		1477	$show .= "<option value='".$this->secure->checkInt($element["rtype_id"])."'>".$this->secure->checkStr($element["rtype"],1)."</option>\n";
		1478	}
		1479	}
		1480	$show .= "</select>";
		1481
		1482	return $show;
		1483	}
		1484
		1485	/**
547	alex-w	1486	* Форма создания/редактирвоания репозиториев
		1487	*
		1488	* @author Alexander Wolf
		1489	* @category Core
		1490	*
		1491	* @param integer $repID
		1492	* @param string $info
		1493	* @param string $reptype
		1494	* @return string
		1495	*/
		1496	public function showRepositoriesForm($repID = 0, $info = "", $reptype = "") {
556	alex-w	1497	$sRepID = $this->secure->checkInt($repID);
		1498	$sInfo = $this->secure->checkStr($info, 1);
		1499	$sRType = $this->secure->checkStr($reptype, 1);
		1500	if ($sInfo == "") {
		1501	$sInfo = "Репозиторий";
		1502	}
		1503	if ($sRType == "") {
		1504	$sRType = "deb";
		1505	}
		1506	if ($sRepID != 0) {
		1507	// Режим редактирования
558	alex-w	1508	$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 ";
		1509	//$query .= "JOIN ".$this->prefix."rtype rt ON r.rtype_id=rt.rtype_id ";
556	alex-w	1510	$query .= "JOIN ".$this->prefix."protos p ON r.proto_id=p.proto_id ";
		1511	$query .= "JOIN ".$this->prefix."rephost h ON r.rhost_id=h.rhost_id ";
		1512	$query .= "JOIN ".$this->prefix."repfolder f ON r.rfolder_id=f.rfolder_id ";
		1513	$query .= "JOIN ".$this->prefix."version v ON r.version=v.version_id ";
		1514	$query .= "JOIN ".$this->prefix."distribution d ON v.dist_id=d.dist_id ";
		1515	$query .= "JOIN ".$this->prefix."dtype dt ON d.disttype=dt.type_id ";
		1516	$query .= "WHERE r.rep_id='".$sRepID."'";
		1517	$rq =& $this->db->query($query);
		1518	$rq->fetchInto($element);
		1519	$sRType = $this->secure->checkStr($element["type"],1);
		1520	}
		1521
		1522	$show = "<fieldset><legend>".$sInfo."</legend>\n";
		1523	$show .= "<div class='inputbox'><label for='rname'>Название репозитория:</label> <input type='text' name='rname' value='".$this->secure->checkStr($element["repname"],1)."'></div>\n";
		1524	$show .= "<div class='inputbox'><label for='rinfo'>Описание репозитория:</label> <input type='text' name='rinfo' value='".$this->secure->checkStr($element["repinfo"],1)."'></div>\n";
		1525	$show .= "<div class='inputbox'><label for='rkey'>Ключ подписи репозитория:</label> <input type='text' name='rkey' value='".$this->secure->checkStr($element["repkey"],1)."'></div>\n";
		1526	$show .= "<div class='inputbox'><label for='rproto'>Протокол доступа:</label> <input type='text' name='rproto' value='".$this->secure->checkStr($element["proto"],1)."'></div>\n";
		1527	$show .= "<div class='inputbox'><label for='rhost'>Хост репозитория:</label> <input type='text' name='rhost' value='".$this->secure->checkStr($element["rhost"],1)."'></div>\n";
		1528	$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	1529	$show .= "<div class='inputbox'><label for='rtype'>Тип репозитория:</label> ".$this->showRepType($this->secure->checkInt($element["rtype_id"]), "rtype")."</div>\n";
564	alex-w	1530	$show .= "<div class='inputbox'><label for='rsects'>Секции репозитория:</label> <div class='formwrapper'>".$this->showSectionsList("rsects",$sRepID,"innerhtml")."</div></div>\n";
569	alex-w	1531	$show .= "<div class='inputbox'><label for='rarchs'>Архитектуры:</label> <div class='formwrapper'>".$this->showArchList("rarchs",$sRepID,"innerhtml")."</div></div>\n";
570	alex-w	1532	$show .= "<div class='inputbox'><label for='rscheme'>Схема репозитория:</label> ".$this->showSchemeList("rscheme",$sRepID,"innerhtml")."</div>\n";
556	alex-w	1533	$show .= "<div class='inputbox'><input type='submit' value=' Отправить данные '></div></fieldset>\n";
		1534
547	alex-w	1535	return $show;
556	alex-w	1536	return $show;
547	alex-w	1537	}
560	alex-w	1538
304	alex-w	1539	}
		1540
356	alex-w	1541	?>

Хранилища Subversion ant

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