[AJUDA] Webspell news.

[pumpzera]

Alguém me ajuda , no box do lado do topmatch , não aparece as news ;$


www.smile-gaming.net

switchbox_head.php

Code Select Expand

<?php

$ergebnis=safe_query("SELECT * FROM ".PREFIX."news_rubrics ORDER BY rubric LIMIT 0, 4");
while($ds=mysql_fetch_array($ergebnis)) {
echo ' <div class="switchbox_main_head"><a href="#" class="toc">'.getinput($ds['rubric']).'</a></div>';
}

?>
$ergebnis no switchbox_content,  ele é melhor entendi tendo relação com rubric, 


switchbox_content.php

Code Select Expand

<?php

$ergebnis2=safe_query("SELECT * FROM ".PREFIX."news_rubrics ORDER BY rubric LIMIT 0, 4");
while($db=mysql_fetch_array($ergebnis2)) {

##########################
;

$ergebnis=safe_query("SELECT * FROM ".PREFIX."news WHERE published='4' AND rubric='".$db['rubricID']."' AND intern<=".isclanmember($userID)." ORDER BY date DESC LIMIT 0, 4");
if(mysql_num_rows($ergebnis)){
$n=1;
echo '<div class="contentdiv">';
while($ds=mysql_fetch_array($ergebnis)) {
$date=date("d.m.Y", $ds['date']);
$time=date("H:i", $ds['date']);
$news_id=$ds['newsID'];
$poster = getnickname($ds['poster']);



$message_array = array();
$query=safe_query("SELECT n.*, c.short AS `countryCode`, c.country FROM ".PREFIX."news_contents n LEFT JOIN ".PREFIX."countries c ON c.short = n.language WHERE n.newsID='".$ds['newsID']."'");
while($qs = mysql_fetch_array($query)) {
$message_array[] = array('lang' => $qs['language'], 'headline' => $qs['headline'], 'message' => $qs['content'], 'country'=> $qs['country'], 'countryShort' => $qs['countryCode']);
}
$showlang = select_language($message_array);
 
$languages='portuguese';
$i=0;
 
$lang=$message_array[$showlang]['lang'];

$headlines=$message_array[$showlang]['headline'];

if(mb_strlen($headlines)>$maxheadlinechars) {
$headlines=mb_substr($headlines, 0, $maxheadlinechars);
$headlines.='...';
}

$headlines=clearfromtags($headlines);

eval ("\$sc_switchbox = \"".gettemplate("sc_switchbox")."\";");
echo $sc_switchbox;

$n++;
}
unset($rubricID);
echo '</div>';
}

########################



 
}


?>
alguém pode me ajudar ? :/


obrigado !