Nur 1 Banner wird angezeigt

[FloMK]

Umgebaut habe ich nichts, habe die jetzt trotzdem mal getauscht und siehe da es klappt.

die alte:

<?
userstatus (); 
head ('Paidbanner');

$usr = mysql_fetch_assoc (db_query ('SELECT max_forced FROM '.$db_prefix.'_userdaten WHERE uid = '.$_SESSION['uid'].' LIMIT 1'));

$fbanner = db_query ('SELECT t1.* 
          FROM '.$db_prefix.'_gebuchte_werbung t1 
          LEFT JOIN '.$db_prefix.'_reloads t2 
          ON (t1.tan = t2.tan AND (t2.uid = '.$_SESSION['uid'].' OR t2.ip = "'.$ip.'")) 
          WHERE t2.tan IS NULL AND t1.werbeart = "forcedbanner" AND t1.menge > 0 AND t1.status = 1 AND t1.verdienst > 0 AND t1.sponsor != '.$_SESSION['uid'].' ORDER BY t1.verdienst DESC LIMIT '.$usr['max_forced']);

while ($f_banner = mysql_fetch_assoc ($fbanner)){
	echo '<div align="center" id="banner_'.$f_banner['tan'].'"><a href="fc.php?tan='.$f_banner['tan'].'" target="_blank"><img src="'.$f_banner['banner'].'" border="0" height="60" width="468" alt="'.$f_banner['tan'].'" onClick="document.getElementById(\'banner_'.$f_banner['tan'].'\').style.display=\'none\';"></a>'
	. '<br>Reload:'. $f_banner['reload']/3600 .' Std. | Verdienst: '.number_format($f_banner['verdienst'],2,',','.').' | Aufenthalt: '.$f_banner['aufendhalt'].' Sekunden<br><br></div>';    
}  

if (mysql_num_rows ($fbanner) > 0) echo '<div align="center"><input type="button" name="mehr_banner" value="Weitere Banner !" onclick="javascript:location.reload();" /></div>';  
else echo '<div style="text-align: center; font-weight: bold; color: #ff0000;">Alle Banner im Reload !</div>';

foot ();
?>

LG

[Lokutos]

dan führ mal diese sql aus:

SELECT t1.* 
                   FROM vms_gebuchte_werbung t1 
          LEFT JOIN reloads_reloads t2 
          ON (t1.tan = t2.tan AND (t2.uid = "*******DEINEUID*******" OR t2.ip = "*****DEINEIP*****")) 
          WHERE t2.tan IS NULL AND t1.werbeart = "forcedbanner" AND t1.menge > 0 AND t1.status = 1 AND t1.verdienst > 0 AND t1.sponsor != "*****DEINEUID*******" ORDER BY t1.verdienst DESC LIMIT 25 

an drei stelln must du uid oder ip einfügen