.-.-.-.-.-

<?php
defined ( '_JEXEC' ) or die ( 'Restricted access' );

class modIndustryHelper {
	/*function getTitle($Itemid1){
	$query1 = "SELECT title FROM #__categories WHERE id = '$Itemid1'";
	$db->setQuery($query1);
	$result1 = $db->loadObjectList();
	foreach ( $result1 as $row ) {
	$title1=$row->title;
	}
	return $title1;

}*/
	
	public function getArticles($articlesCount, $categoryType, $linkType){
	$config = & JFactory::getConfig();
	$db = &JFactory::getDBO();
	$Itemid = $_GET['Itemid'];
	if($categoryType==0){$Itemid=$Itemid+100; $type="mi";} else {$type="bp";}
	$query1 = "SELECT title FROM #__categories WHERE id='$Itemid'";
	$db->setQuery($query1);
	$result1 = $db->loadObjectList();
	foreach ( $result1 as $row1 ) {
	$title1=$row1->title;
	}
	//$title = getTitle($Itemid);
//	echo "<script language=\"javascript\">document.title=\"$title1\"</script>";
/*	$query = "SELECT title, introtext, created, id, catid FROM #__content WHERE catid = '$Itemid' ORDER BY created DESC;";
	$db->setQuery($query);
	$result = $db->loadObjectList();
	$i=1;
	foreach ( $result as $row ) {
    $price = substr($row->introtext,strpos($row->introtext,"Цена"), 24);
	$date = $row->created;
	str_split($date);
	$date1 = $date[8].$date[9].".".$date[5].$date[6].".".$date[2].$date[3];
	if($categoryType==0){$type="mi"; $type1="mi"; $img = "mi/mi_$row->id.gif";} else {$type=""; $type1="bp";$img = "bp/bp_$row->id.png";}
	if	($config->getValue('sef')==1){
		if($categoryType==0){$link = "mi.php?id=$row->id";} else {$link = "bp.php?id=$row->id";}
		}
	else{
		$link = "index.php?option=com_content&catid=$row->catid&id=$row->id&view=article&Itemid=2";
		}
	
	echo "<table style=\"border: 1px solid black; width:300px; margin-bottom:5px;\"><tr><td width=\"160\"><a style=\"float:left\" href=\"$link\"><img src=\"images/stories/$img\" width=\"150\" alt=\"$row->title\" style=\"float:left; margin:5px; \"> </a> </td>
		<td valign=\"top\"><p>Название: $row->title</p>\n<p><a href=\"$type1.php?id=$row->id\" style=\"color:red; font-weight:bold; text-decoration:underline;\">Описание</a></p><p>Дата создания: $date1</p><p style=\"font-weight:bold;\">$price</p><p>Демо-версия:</p><p><a target=\"_blank\" href=\"pdf/$row->id.pdf\" style=\"color:red; font-weight:bold; text-decoration:underline;\">Скачать</a></p><p><a href=\"".$type."buy.php?buyid=$row->id\" style=\"color:red; font-weight:bold; text-decoration:underline;\">Купить</a></p></td></tr></table>";
		
	$i++;
	if($i > $articlesCount){break;}
	}

if($config->getValue('newsystem')==1){*/
			$query1 = "SELECT title FROM #__categories WHERE id='$Itemid'";
			$db->setQuery($query1);
			$result1 = $db->loadObjectList();
			foreach ( $result1 as $row1 ) {
				$title1=$row1->title;
			}
	//$title = getTitle($Itemid);
//	echo "<script language=\"javascript\">document.title=\"$title1\"</script>";
			$query = "SELECT a.*,c.* FROM #__articles AS a LEFT JOIN #__articles_cats AS c ON a.id=c.article_id WHERE c.cat_id='$Itemid' ORDER BY a.date DESC;";
			$db->setQuery($query);
			$result = $db->loadObjectList();
			$i=1;
			foreach ( $result as $row ) {
				$price = $row->price;
				$date = $row->date;
				$date = $date[8].$date[9].".".$date[5].$date[6].".".$date[2].$date[3];
				if($categoryType==0){$type="mi"; $type1="mi"; $img = "mi/mi_$row->id.gif";} else {$type=""; $type1="bp";$img = "bp/bp_$row->id.png";}
				if	($config->getValue('sef')==1){
					if($categoryType==0){$link = "mi.php?id=$row->id";} else {$link = "bp.php?id=$row->id";}
				}
				else{
					$link = "index.php?option=com_content&catid=$row->catid&id=$row->id&view=article&Itemid=2";
				}
			echo "<table style=\"border: 1px solid black; width:300px; margin-bottom:5px;\"><tr><td width=\"160\"><a style=\"float:left\" href=\"$link\"><img src=\"images/stories/$img\" width=\"150\" alt=\"$row->title\" style=\"float:left; margin:5px; \"> </a> </td>
			<td valign=\"top\"><p><a href=\"$type1.php?id=$row->id\"><strong style='font-weight:normal;'>Название: $row->title</strong></a></p>\n<p><a href=\"$type1.php?id=$row->id\" style=\"color:red; font-weight:bold; text-decoration:underline;\">Описание</a></p><p>Дата создания: $date</p><p style=\"font-weight:bold;\">Цена: $price</p><p>Демо-версия:</p><p><a target=\"_blank\" href=\"pdf/$row->id.pdf\" style=\"color:red; font-weight:bold; text-decoration:underline;\">Скачать</a></p><p><a href=\"".$type."buy.php?buyid=$row->id\" style=\"color:red; font-weight:bold; text-decoration:underline;\">Купить</a></p></td></tr></table>";
			$i++;
			if($i > $articlesCount){break;}
			}
		//}
	}

}
?>

/var/www/iplanru/data/./mod-tmp/../old/./www/i-plan.ru/./modules/mod_industry/helper.php