@saintx
Yatay haber Fonksiyonu bu şekilde hocam
function yatayhaber($offset, $limit, $cat, $yatay=false, $manset=false) {
global $db, $order, $ayar, $theme_path, $dir, $url;
//$db->cache_queries = true;
if($offset) {
$offset = $offset.", ";
} else {
$offset = '';
}
$ext = '';
$catid = kategori_to_id($cat);
if($manset) {
$manset_where_kriter = 'fmanset';
} else {
$manset_where_kriter = 'ymanset';
}
if(isset($_GET['anakategori'])) {
$anakategori = temizle($_GET['anakategori']);
if($db->sayac("haberkat","parent='".$catid."' AND aktif = '1'")) {
$altc = $db->sorgu("SELECT id FROM haberkat WHERE parent = '".$catid."'");
while($x=$db->assoc($altc)) {
$ext.= ",".intval($x['id']);
}
}
}
if($cat==FALSE) {
$sql_ymanset = $manset_where_kriter." = '1' AND ";
} else {
$sql_ymanset = "";
}
$arakriter = "catid IN(".$catid.$ext.") AND ";
if($cat!=false) {
$toplam_haber_sayisi = $db->sayac("haber","".$arakriter." ".$sql_ymanset." catid = '$catid' AND aktif = '1' AND onay = '1'");
if($toplam_haber_sayisi>=$sayfa) {
$q = $db->getir("SELECT id, baslik, hta, resim, spot, renk, kalin, ziplat, (select baslik from haberkat where haber.catid=haberkat.id) as kategori, yorum FROM haber WHERE ".$arakriter." ".$sql_ymanset." aktif = '1' AND onay = '1' ORDER BY $order LIMIT $offset $limit");
} else {
$q = $db->getir("SELECT id, baslik, hta, resim, spot, renk, kalin, ziplat, (select baslik from haberkat where haber.catid=haberkat.id) as kategori, yorum FROM haber WHERE ".$arakriter." ".$sql_ymanset." aktif = '1' AND onay = '1' $ext ORDER BY $order LIMIT $offset $limit");
}
} else {
$toplam_haber_sayisi = $db->sayac("haber","".$sql_ymanset." aktif = '1' AND onay = '1'");
if($toplam_haber_sayisi>=$sayfa) {
$q = $db->getir("SELECT id, baslik, hta, resim, spot, renk, kalin, ziplat, (select baslik from haberkat where haber.catid=haberkat.id) as kategori, yorum FROM haber WHERE ".$sql_ymanset." aktif = '1' AND onay = '1' ORDER BY $order LIMIT $offset $limit");
} else {
$q = $db->getir("SELECT id, baslik, hta, resim, spot, renk, kalin, ziplat, (select baslik from haberkat where haber.catid=haberkat.id) as kategori, yorum FROM haber WHERE ".$sql_ymanset." aktif = '1' AND onay = '1' ORDER BY $order LIMIT $offset $limit");
}
}
if(!$q) return false;
$row_n = array();
$classes = array("left_margin", "middle_box", "right_margin");
$i=0;
$a=0;
$margin = '';
foreach($q AS $row) {
$hta = $ayar['url'].$row['hta']."-h".$row['id'].".html";
if($row['resim']=='' OR !file_exists($dir."images/haberler/thumbs2/".$row['resim'])) {
$resim = $theme_path."images/no_headline_thumb.jpg";
} else {
$resim = $ayar['url']."images/haberler/thumbs2/".$row['resim']."";
}
if($yatay===FALSE) {
if(strlen($row['baslik'])>33) {
$row['baslik'] = character_limiter($row['baslik'],40);
$row['spot'] = character_limiter($row['spot'],85);
} else {
$row['baslik'] = character_limiter($row['baslik'],30);
$row['spot'] = character_limiter($row['spot'],125);
}
} else {
$row['baslik'] = character_limiter($row['baslik'],40);
$row['spot'] = character_limiter($row['spot'],150);
}
$row['baslik'] = baslik_stili($row['renk'],false,$row['ziplat'],$row['baslik']);
if($a>5 AND $a<12) {
$row['horizontal'] = 'horizontal';
} else {
$row['horizontal'] = '';
}
$row['toplam'] = $toplam_haber_sayisi;
unset($row['renk']);
unset($row['kalin']);
unset($row['ziplat']);
unset($row['hta']);
unset($row['id']);
$row['resim'] = $resim;
$row['margin'] = $classes[$i];
$row['hta'] = $hta;
$row_n[] = $row;
($i > 1) ? $i = 0 : $i++ ;
($a ==11) ? $a = 0 : $a++ ;
}
//$db->cache_queries = false;
#$db->debug();
return $row_n;
}