besser wäre es, die statistik so zu machen:
PHP-Code:
<?
userstatus();
$max_verguet = 800; //Wie hoch darf die maximale Verguetung sein? Schutz gegen z.B. Interface-Fehler
$forcedbanner = mysql_fetch_object (db_query ("SELECT COUNT(*) AS anzahl 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 t1.menge >='1' and t1.werbeart = 'forcedbanner' and t1.status = '1' and t1.sponsor != '".$_SESSION['uid']."' AND t2.tan IS NULL ORDER BY verdienst DESC"));
$notreload = $forcedbanner->anzahl;
$reloadbanner = mysql_fetch_object (db_query ("SELECT COUNT(*) AS anzahl 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 t1.menge >='1' and t1.werbeart = 'forcedbanner' and t1.status = '1' and t1.sponsor != '".$_SESSION['uid']."' AND t2.tan IS NOT NULL ORDER BY verdienst DESC"));
$inreload = $reloadbanner->anzahl;
head("");
$max_banner = mysql_fetch_array(db_query("SELECT `max_forced` FROM ".$db_prefix."_userdaten WHERE uid=".$_SESSION['uid'].""));
$statsql = mysql_query("SELECT SUM(verdienst) AS sum_verdienst, SUM(aufendhalt) AS sum_aufendhalt FROM ".$db_prefix."_gebuchte_werbung WHERE menge >=1 AND werbeart = 'forcedbanner' AND status = 1 AND sponsor != '".$_SESSION['uid']."' AND verdienst > 0 AND verdienst <= ".$max_verguet) or die(mysql_error());
$stat = mysql_fetch_array ($statsql);
$gesamt = $notreload+$inreload;
echo '<center>";
echo 'Aktive Paidbanner: '.($notreload-$inreload).' | Reloadsperre: '.$inreload.'<br />';
echo 'Ø Aufenthalt: '.number_format(($stat['sum_aufendhalt']/$gesamt),2,',','.').' Sek. | ';
echo 'Ø Durchlauf: '.number_format(($gesamt*($stat['sum_verdienst']/$gesamt)),2,',','.').' '.$waehrung.' | ';
echo 'Ø Vergütung: '.number_format(($stat['sum_verdienst']/$gesamt),2,',','.').' '.$waehrung;
echo '</center><br /><br />";
$forcedbanner = 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 t1.menge >='1' and t1.werbeart = 'forcedbanner' and t1.status = '1' and t1.sponsor != '".$_SESSION['uid']."' AND t2.tan IS NULL ORDER BY verdienst DESC LIMIT ".$max_banner['max_forced']);
$i = 0;
while($f_banner = mysql_fetch_array($forcedbanner)){
echo '<div align="center" id="banner_'.$i.'"><a href="fc.php?tan='.$f_banner['tan'].'" target="_blank"><img src="'.$f_banner['banner'].'" border="0" height="60" width="468" alt="" onClick="document.getElementById(\'banner_'.$i.'\').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>';
$i++;
}
if ($i != 0) echo '<div align="center"><form action="" method="post"><input type="submit" name="mehr_banner" value="Weitere Banner ?" /></form></div>';
else echo '<center>Alle Banner im Reload!</center>';
foot ();
?>
Zitieren