.-.-.-.-.-

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

class modIndustry2Helper {
	public function getArticles($articlesCount, $categoryType, $defcat){
		$config = &JFactory::getConfig();
		$db = &JFactory::getDBO();
		$Itemid = $_GET['Itemid'];
		if($categoryType==0){$Itemid=$Itemid+100;}
	/*	$query = "SELECT title, introtext, created, id, catid FROM #__content ORDER BY created DESC;";
		$db->setQuery($query);
		$result = $db->loadObjectList();
		$query1 = "SELECT title, id FROM #__categories WHERE id>11 ORDER BY id ASC;";
		$db->setQuery($query1);
		$result1 = $db->loadObjectList();
		if($categoryType==0){
		//echo "<div style=\"font-weight:bold; text-align:center; \">Навигация по отраслям</div>\n";
			echo "<table style=\"margin-bottom: 10px; width:100%\"><tr>";
			foreach ($result1 as $row1){
				if (($row1->id == 118)||($row1->id < 100)){continue;}
				if (($row1->id == 112)||($row1->id ==119)||($row1->id ==125)||($row1->id ==130)){ echo "<td width=\"25%\" valign=\"top\">";}
				echo "<div><a href=\"mi.php#$row1->id\"><span style=\"color:black; text-decoration:underline;\">$row1->title</span></a></div>\n";
				if (($row1->id == 117)||($row1->id ==124)||($row1->id ==129)||($row1->id ==133)){ echo "</td>";}
				$otrname[$row1->id] = $row1->title;
			}
			echo "</table>";
			for($k=112;$k<134;$k++){	
				if($k==118){continue;}
				echo "<a name=\"$k\"></a><div style=\"font-size: 14px; color: gray; text-align:center;\">$otrname[$k]</div>\n";
				$i=1;
				echo "<table>";
				foreach ( $result as $row ) {
					if($row->catid == $k){
						$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];
						$img = "mi/mi_$row->id.gif";
						if ($i%2==1){ echo "<tr><td>";} else {echo "<td>";}	
						echo "<table style=\"border: 1px solid #d2d2d2; width:300px; margin-bottom:5px;\"><tr><td width=\"164\"><a style=\"float:left\" href=\"mi.php?id=$row->id\"><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=\"mi.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=\"mibuy.php?buyid=$row->id\" style=\"color:red; font-weight:bold; text-decoration:underline;\">Купить</a></p></td></tr></table>";
						if ($i%2==1){ echo "</td>";} else {echo "</td></tr>";}
						$i++;
//			if($i > $articlesCount){break;}
					}
				}
			if ($i%2==0){ echo "</tr>";}
			echo "</table>";
			}
		}
		if($categoryType==1){
		//echo "<div style=\"font-weight:bold; text-align:center; \">Навигация по отраслям</div>\n";
			echo "<table style=\"margin-bottom: 10px; width:100%\"><tr>";
			foreach ($result1 as $row1){
				if (($row1->id == 18)||($row1->id > 100)){continue;}
				if (($row1->id == 12)||($row1->id ==19)||($row1->id ==25)||($row1->id ==30)){ echo "<td width=\"25%\" valign=\"top\">";}
				echo "<div><a href=\"bp.php#$row1->id\"><span style=\"color:black; text-decoration:underline;\">$row1->title</span></a></div>\n";
				if (($row1->id == 17)||($row1->id ==24)||($row1->id ==29)||($row1->id ==33)){ echo "</td>";}
				$otrname[$row1->id] = $row1->title;
			}
			echo "</table>";
			for($k=12;$k<34;$k++){
				if($k==18){continue;}
				echo "<a name=\"$k\"></a><div style=\"font-size: 14px; color: gray; text-align:center;\">$otrname[$k]</div>\n";
				$i=1;
				echo "<table>";
				foreach ( $result as $row ) {
					if($row->catid == $k){
					$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];
					$img = "bp/bp_$row->id.png";
					if ($i%2==1){ echo "<tr><td >";} else {echo "<td>";}
					echo "<table style=\"border: 1px solid #d2d2d2; width:300px; margin-bottom:5px;\"><tr><td width=\"164\"><a style=\"float:left\" href=\"bp.php?id=$row->id\"><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=\"bp.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=\"buy.php?buyid=$row->id\" style=\"color:red; font-weight:bold; text-decoration:underline;\">Купить</a></p></td></tr></table>";
					if ($i%2==1){ echo "</td>";} else {echo "</td></tr>";}
					$i++;
					}
				}	
				//if($i > $articlesCount){break;}
				if ($i%2==0){ echo "</tr>";}
				echo "</table>";
			}
		}
		
		
		
		
			
		if($config->getValue('newsystem')==1){*/
			echo "</div>";
			$query = "SELECT a.*,c.* FROM #__articles AS a LEFT JOIN #__articles_cats AS c ON a.id=c.article_id ORDER BY a.date DESC;";
			$db->setQuery($query);
			$result = $db->loadObjectList();
			$query1 = "SELECT title, id FROM #__categories WHERE id>11 ORDER BY id ASC;";
			$db->setQuery($query1);
			$result1 = $db->loadObjectList();
			if($categoryType==0){
		//echo "<div style=\"font-weight:bold; text-align:center; \">Навигация по отраслям</div>\n";
				echo "<table style=\"margin-bottom: 10px; width:100%\"><tr>";
				foreach ($result1 as $row1){
					if (($row1->id == 118)||($row1->id < 100)){continue;}
					if (($row1->id == 112)||($row1->id ==119)||($row1->id ==125)||($row1->id ==130)){ echo "<td width=\"25%\" valign=\"top\">";}
				//	echo "<div><a href=\"mi.php#$row1->id\"><span style=\"color:black; text-decoration:underline;\">$row1->title</span></a></div>\n";
					echo "<div><a href=\"mi.php?cat=$row1->id\"><span style=\"color:black; text-decoration:underline;\">$row1->title</span></a></div>\n";
					if (($row1->id == 117)||($row1->id ==124)||($row1->id ==129)||($row1->id ==133)){ echo "</td>";}
					$otrname[$row1->id] = $row1->title;
				}
				echo "</table>";
				if(($defcat == 0)||(!$defcat)){$defcat = 20;}
				if(!$_GET['cat']){$cat = $defcat+100;}
				else{$cat=$_GET['cat'];}
				for($k=112;$k<134;$k++){	
					if($k==118){continue;}
					if($k!=$cat) {continue;}
					echo "<a name=\"$k\"></a><div style=\"font-size: 14px; color: gray; text-align:center;\">$otrname[$k]</div>\n";
					$i=1;
					echo "<table>";
					foreach ( $result as $row ) {
						if($row->cat_id == $k){
							$price = $row->price;
							$date = $row->date;
							$date = $date[8].$date[9].".".$date[5].$date[6].".".$date[2].$date[3];
							$img = "mi/mi_$row->id.gif";
							if ($i%2==1){ echo "<tr><td>";} else {echo "<td>";}	
							echo "<table style=\"border: 1px solid #d2d2d2; width:300px; margin-bottom:5px;\"><tr><td width=\"164\"><a style=\"float:left\" href=\"mi.php?id=$row->id\"><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=\"mi.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=\"mibuy.php?buyid=$row->id\" style=\"color:red; font-weight:bold; text-decoration:underline;\">Купить</a></p></td></tr></table>";
							if ($i%2==1){ echo "</td>";} else {echo "</td></tr>";}
							$i++;
//			if($i > $articlesCount){break;}
						}
					}
				if ($i%2==0){ echo "</tr>";}
				echo "</table>";
				}
			}
			if($categoryType==1){
		//echo "<div style=\"font-weight:bold; text-align:center; \">Навигация по отраслям</div>\n";
				echo "<table style=\"margin-bottom: 10px; width:100%\"><tr>";
				foreach ($result1 as $row1){
					if (($row1->id == 18)||($row1->id > 100)){continue;}
					if (($row1->id == 12)||($row1->id ==19)||($row1->id ==25)||($row1->id ==30)){ echo "<td width=\"25%\" valign=\"top\">";}
				//	echo "<div><a href=\"bp.php#$row1->id\"><span style=\"color:black; text-decoration:underline;\">$row1->title</span></a></div>\n";
					echo "<div><a href=\"bp.php?cat=$row1->id\"><span style=\"color:black; text-decoration:underline;\">$row1->title</span></a></div>\n";
					if (($row1->id == 17)||($row1->id ==24)||($row1->id ==29)||($row1->id ==33)){ echo "</td>";}
					$otrname[$row1->id] = $row1->title;
				}
				echo "</table>";
				if(($defcat == 0)||(!$defcat)){$defcat = 19;}
				if(!$_GET['cat']){$cat = $defcat;}
				else{$cat=$_GET['cat'];}
				for($k=12;$k<34;$k++){
					if($k==18){continue;}
					if($k!=$cat) {continue;}
					echo "<a name=\"$k\"></a><div style=\"font-size: 14px; color: gray; text-align:center;\">$otrname[$k]</div>\n";
					$i=1;
					echo "<table>";
					foreach ( $result as $row ) {
						if($row->cat_id == $k){
							$price = $row->price;
							$date = $row->date;
							$date = $date[8].$date[9].".".$date[5].$date[6].".".$date[2].$date[3];
							$img = "bp/bp_$row->id.png";
							if ($i%2==1){ echo "<tr><td >";} else {echo "<td>";}
							echo "<table style=\"border: 1px solid #d2d2d2; width:300px; margin-bottom:5px;\"><tr><td width=\"164\"><a style=\"float:left\" href=\"bp.php?id=$row->id\"><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=\"bp.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=\"buy.php?buyid=$row->id\" style=\"color:red; font-weight:bold; text-decoration:underline;\">Купить</a></p></td></tr></table>";
							if ($i%2==1){ echo "</td>";} else {echo "</td></tr>";}
							$i++;
						}
					}	
				//if($i > $articlesCount){break;}
					if ($i%2==0){ echo "</tr>";}
					echo "</table>";
				}
			}
	//	}

}

}
?>

/var/www/iplanru/data/./mod-tmp/../old/./www/i-plan.ru/modules/mod_industry2(backup)/helper.php