Alguém me ajuda , no box do lado do topmatch , não aparece as news ;$
www.smile-gaming.net switchbox_head.php
<?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
<?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 !