so dann hier mal das Beispiel von gremlin mit Sebbys Vorschlag:
PHP-Code:
<?
userstatus();
head("Paidbanner");
$usr = mysql_fetch_array(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 >='1' 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_array($fbanner)){
echo '<div align="center" id="banner_'.$x_banner.'"><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_'.$x_banner.'\').style.display=\'none\';"></a><br>Reload:'. $f_banner['reload']/3600 .' Std. | Verdienst: '.number_format($f_banner['verdienst'],2,',','.').' | Aufendhalt:'.$f_banner['aufendhalt'].' Sekunden<br><br></div>';
$x_banner++;
}
echo '<div align="center"><form action="" method="post"><input type="Submit" name="mehr_banner" value="Weitere Banner !"></form></div>';
foot();
?>
Zitieren