AutoBB 2.3 for Joomla 1.5 legacy mode - страница 19 - AutoBB

$query = "SELECT a.*, v.itemid as vendor_itemid, v.title as vendortitle, m.itemid as model_itemid, m.title as modeltitle, p.id as photoid, cur.sign as currency_title, ct.title as city_title, LOWER(s.title) as state_title, s.ordering as state_id FROM #__autobb_messages AS a"
	."\n LEFT JOIN #__autobb_vendors as v ON a.vendor=v.id"
	."\n LEFT JOIN #__autobb_models as m ON a.model=m.id"
	."\n LEFT JOIN #__autobb_photos as p ON a.id=p.msgid"
	."\n LEFT JOIN #__autobb_cities as ct ON a.city=ct.id"
	."\n LEFT JOIN #__autobb_states as s ON a.state=s.id"
	."\n LEFT JOIN #__autobb_currency as cur ON cur.id=a.currency"
	.( count( $where )? "\n WHERE " . implode( ' AND ', $where ) : "" )
	."\n GROUP BY a.id"
	."\n ORDER BY a.sticked DESC, a.ordering, a.createDate DESC"
	."\n LIMIT 0, $count"

<?php
	defined( '_VALID_MOS' ) or die( 'Прямой доступ к файлам по этому адресу запрещен!' );

	global $database, $Itemid, $mosConfig_absolute_path, $mosConfig_live_site;

	$moduleclass_sfx 	= $params->get( 'moduleclass_sfx' ); 
	$count 		= intval( $params->get( 'count' ) ); 
	$cols 	= intval( $params->get( 'cols' ) ); 
	$menuid 	= intval( $params->get( 'menuid' ) )? intval( $params->get( 'menuid' ) ) : $Itemid; 
	$category_id	= intval( $params->get( 'category_id' ) ); 
	$front_only	= intval( $params->get( 'front_only' ) ); 
	$with_photo_only	= intval( $params->get( 'with_photo_only' ) ); 
	$size = intval( $params->get( 'size' ) ); 
	$msize = intval( $params->get( 'msize' ) ); 
	$link_url = $params->get( 'link_url' );
	$link_text = $params->get( 'link_text' );
	$link_title = $params->get( 'link_title' );

	$show_price = $params->get( 'show_price' );
	$show_condition = $params->get( 'show_condition' );
	
	switch( $size ) {
		case '1' : $url_size = "middle"; break;
		case '2' : $url_size = "custom&amp;msize={$msize}"; break;
		default  : $url_size = 'thumb';
	}
		
	$state_colors = array(
	    0 => "63676A",
		1 => "36900F",
		2 => "85900F",
		3 => "C8D817",
		4 => "D88611",
		5 => "D80E0E"
	);
	

	$where = array();
	$where[] = "a.expirationDate>=NOW()";
	$where[] = "a.published='1'";
	if($front_only) $where[] = "a.front='1'";
	if($with_photo_only) $where[] = 'p.id IS NOT NULL';
	if($category_id) $where[] = "a.category=".$category_id;

	$query = "SELECT a.*, v.itemid as vendor_itemid, v.title as vendortitle, m.itemid as model_itemid, m.title as modeltitle, p.id as photoid, cur.sign as currency_title, ct.title as city_title, LOWER(s.title) as state_title, s.ordering as state_id FROM #__autobb_messages AS a"
	."\n LEFT JOIN #__autobb_vendors as v ON a.vendor=v.id"
	."\n LEFT JOIN #__autobb_models as m ON a.model=m.id"
	."\n LEFT JOIN #__autobb_photos as p ON a.id=p.msgid"
	."\n LEFT JOIN #__autobb_cities as ct ON a.city=ct.id"
	."\n LEFT JOIN #__autobb_states as s ON a.state=s.id"
	."\n LEFT JOIN #__autobb_currency as cur ON cur.id=a.currency"
	.( count( $where )? "\n WHERE " . implode( ' AND ', $where ) : "" )
	."\n GROUP BY a.id"
	."\n ORDER BY a.sticked DESC, a.ordering, a.createDate DESC, p.id"
	."\n LIMIT 0, $count"
	;
	$database->setQuery( $query );
	$msg = $database->loadObjectList();
	if (!$msg) return ;
	?>
	<table class="autobb_latests" >
	<?php
	$i = 0; //индекс элемента $msg
	$width = intval( 100/$cols );
	$n = sizeof($msg);
	while( $i<$n) {
		echo "<tr>";
		for($c=0; $c<$cols && $i<$n; ++$c) {
			$itemid_ = $msg[$i]->model_itemid ? $msg[$i]->model_itemid : ( $msg[$i]->vendor_itemid ? $msg[$i]->vendor_itemid : $menuid );
			$title = $msg[$i]->vendortitle.' '.$msg[$i]->modeltitle.' '.$msg[$i]->modification.' '.$msg[$i]->year.' г/в';
			$link = sefRelToAbs("index.php?option=com_autobb&amp;Itemid=".$itemid_."&amp;task=show&amp;id=".$msg[$i]->id);
			if( $url_size=='thumb' and file_exists ( $mosConfig_absolute_path."/components/com_autobb/photos/".$msg[$i]->id."/im_".$msg[$i]->photoid.".jpg" ) ) {
				$img = $mosConfig_live_site."/components/com_autobb/photos/".$msg[$i]->id."/im_".$msg[$i]->photoid.".jpg";
					}
				else $img = "index2.php?option=com_autobb&amp;task=photo&amp;no_html=1&amp;size=".$url_size."&amp;id=".$msg[$i]->photoid;
			echo '<div style=\'border-bottom:1px solid #CCCCCC; padding-bottom:3px; text-align:center;\'<td width="'.$width.'%">';
			echo '<div class="autobb_vendor" ><strong><a href="'.$link.'" title="'.$title.'">'.$msg[$i]->vendortitle.' '.$msg[$i]->modeltitle.' '.$msg[$i]->modification.'</a></strong></div>';
			if(intval( $msg[$i]->photoid ) ) echo '<a href="'.$link.'" title="'.$title.'"><img src="'.$img.'" border="0" title="'.$title.'" alt="'.$title.'" /></a><br />';
			echo '<a href="'.$link.'" title="'.$title.'"><span class="autobb_year">'.$msg[$i]->year.' г/в</span><br />';
			echo 'г. '.$msg[$i]->city_title.'<br />';
			if( $show_condition ) echo 'состояние <font color="#'.$state_colors[ intval($msg[$i]->state_id) ].'">'.$msg[$i]->state_title.'</font><br />';
			if( $show_price ) echo ' <span class="autobb_price">'.preg_replace('/(?<=[0-9])(?=(?:[0-9]{3})+(?![0-9]))/i', '.', $msg[$i]->price).' '.$msg[$i]->currency_title.'</span></a><br /></div>';
			echo '</td>';
			++$i;
		}
		for( ; $c<$cols; ++$c ) {
			echo '<td width="'.$width.'%">&nbsp;</td>';
		}
		echo "</tr>\n";
	}
	echo '</table>';
	if( $link_url && ( $link_text || $link_text ) ) echo "<p align=\"right\"><a href=\"".sefRelToAbs($link_url)."\" title=\"".($link_title?$link_title:$link_text)."\">".($link_text?$link_text:$link_title)."</a></p>";
	unset($i, $width, $where, $query, $n, $c);
?>