//'; // Получаем текущий раздел if ($tag){$page_name.=" #$tag";} $page['title']=$page_name; $ptype=explode("/",$sv_path); $cid=0; $dir=''; $dir2=''; $ptype[1]=str_replace('name','',$ptype[1]); $ptype[1]=str_replace('customer','',$ptype[1]); if ($ptype[1]) { $dir='/'.$ptype[1]; tri_table_link(9887,'',"``.alias='$ptype[1]'"); if ($row_counter) { $cname_ru=tri_table_output('data1',buff); $cname_en=tri_table_output('data1_en',buff); $calias=tri_table_output('alias',buff); $page_name="Портфолио/".$cname_ru; if ($tag){$page_name.=" #$tag";} $page['title']=str_replace(' ','',"Портфолио - ".$cname_ru); if ($tag){$page['title'].=" #$tag";} $cid=$row_xid; } $ptype[2]=str_replace('name','',$ptype[2]); $ptype[2]=str_replace('customer','',$ptype[2]); if ($ptype[2]) { $dir2='/'.$ptype[2]; tri_table_link(9885,'',"``.alias='$ptype[2]'"); if ($row_counter) { $dname_ru=tri_table_output('data1',buff); $dname_en=tri_table_output('data1_en',buff); $dalias=tri_table_output('alias',buff); // $page_name="Портфолио/".$cname_ru."
".$dname_ru; $page['title']=str_replace(' ','',"Портфолио - ".$cname_ru." - ".$dname_ru); if ($tag){$page['title'].=" #$tag";} $did=$row_xid; } } } $key=explode("\n",tri_page_output(8,buff)); $page['keywords']=trim($key[0]); $page['description']=trim($key[1]); include ('data/templates/header.php'); ?>

Портфолио

'.str_replace('border=0', 'border=0 class="pic" style="float: left; margin-right: 15px;"',tri_table_output('logo',buff)).'

'.tri_table_output(1,buff).'

'.tri_table_output('desc',buff).'

'; } $picture_x=0; $picture_y=25; $offset=(int)$offset; $lim=20; $cat_id=array(); $cat_alias=array(); $cat_name_ru=array(); $cat_name_en=array(); $filter=""; tri_table_link(9885,'',"``.category=$cid AND ``.on=1",'id',1000); while (tri_row('next')) { $cat_alias[]=tri_table_output('alias',buff); $cat_name_ru[]=tri_table_output(1,buff); $cat_name_en[]=tri_table_output('data1_en',buff); if (!in_array($row_xid,$cat_id)) { $cat_id[]=tri_table_output('category',textbuff); $filter.="``.category=$row_xid OR "; } } $filter=rtrim($filter," OR "); if ($filter){$filter="($filter) AND ``.category<>71";} if ($did){$filter="``.category=$did";} $tag=mb_strtolower($tag); if ($tag) { if ($filter) { $filter.="AND (LOWER(".$db_data."_9884.tag1)='$tag' OR LOWER(".$db_data."_9884.tag2)='$tag' OR LOWER(".$db_data."_9884.tag3)='$tag' OR LOWER(".$db_data."_9884.tag4)='$tag' OR LOWER(".$db_data."_9884.tag5)='$tag') "; } else { $filter="(LOWER(".$db_data."_9884.tag1)='$tag' OR LOWER(".$db_data."_9884.tag2)='$tag' OR LOWER(".$db_data."_9884.tag3)='$tag' OR LOWER(".$db_data."_9884.tag4)='$tag' OR LOWER(".$db_data."_9884.tag5)='$tag') "; } $order="LOWER(".$db_data."_9884.tag1) = '" . $tag . "' DESC, LOWER(".$db_data."_9884.tag2) = '" . $tag . "' DESC, LOWER(".$db_data."_9884.tag3) = '" . $tag . "' DESC, LOWER(".$db_data."_9884.tag4) = '" . $tag . "' DESC, LOWER(".$db_data."_9884.tag5) = '" . $tag . "' DESC "; } else { $order=''; } if ((int)$customer){$cust=' AND '.$db_data.'_9884.`client`='.(int)$customer;} else {$cust='';} if ($filter){$filter.=' AND '.$db_data.'_9884.`on`=1'.$cust;} else {$filter=$db_data.'_9884.`on`=1'.$cust;} $vsego=tri_table_counter(9884,'',$filter,'',10000); if ($vsego'; $order="date desc"; if (!$v[0]){echo " ";} else {echo "По дате ";} if ($v[0]=='name'){$order="data1"; echo " ";} else {echo "По названию ";} if (!$customer) { if ($v[0]=='customer'){$order=$db_data.'_9886.`data1`'; echo " ";} else {echo "По клиенту ";} } echo ""; } else { echo '

'; } if ($filter){$filter='AND '.$filter;} $qry='SELECT '.$db_data.'_9884.*, '.$db_data.'_9885.data1 AS data_ex_3, '.$db_data.'_9886.data1 AS data_ex_9 FROM '.$db_data.'_9884 LEFT JOIN '.$db_data.'_9885 ON '.$db_data.'_9884.category='.$db_data.'_9885.xid AND '.$db_data.'_9885.sid=0 LEFT JOIN '.$db_data.'_9886 ON '.$db_data.'_9884.client='.$db_data.'_9886.xid AND '.$db_data.'_9886.sid=0 WHERE '.$db_data.'_9884.sid=0 '.$filter.' AND `cm_data_9884`.`on`=1 ORDER BY '.$order.' LIMIT '."$offset,$lim"; //echo $qry; tri_table_link(9884,$qry); while (tri_row('next')) { echo '

'; if (tri_table_output('icon',textbuff)) { echo '

'.str_replace('border=0','border=0 class="pic"',tri_table_output('icon',buff)).'

'; } if ($order==$db_data.'_9886.`data1`'){$cl=' '.tri_table_output('client',buff).' ';} else {$cl='';} echo '

'.str_replace('_',' ',trim(tri_table_output(1,buff))).' '.$cl.'

'; echo '

'; } if ($vsego>$lim) { echo '