beschleunigungsbanner

[zauberbengel91]

wie erstelle ich den die datei dafür damit es in die Vervielf-Förderung geht?



<?
$besch_gesamt = mysql_fetch_array(db_query("SELECT COUNT(tan) AS ganzahl, SUM(verdienst) AS gverdienst, SUM(aufendhalt) AS gaufenthalt FROM ".$db_prefix."_gebuchte_werbung WHERE werbeart = 'forcedbanner' and reload >= 3600 AND menge > 0 AND status = 1 AND verdienst > 0 AND sponsor != '".$_SESSION['uid']."'")) OR die(mysql_error());
$besch_uebrig = mysql_fetch_array(db_query("SELECT COUNT(t1.tan) AS uanzahl, SUM(t1.verdienst) AS uverdienst FROM ".$db_prefix."_gebuchte_werbung AS t1 LEFT OUTER JOIN ".$db_prefix."_reloads AS t2 ON (t2.tan = t1.tan AND (t2.uid = ".$_SESSION['uid']." OR t2.ip = '".$ip."') AND t2.bis >= '".time()."') WHERE t2.tan IS NULL AND t1.werbeart = 'forcedbanner' AND t1.menge > 0 AND t1.status = 1 and t1.reload >= 3600 AND t1.verdienst > 0 AND t1.sponsor != '".$_SESSION['uid']."'")) OR die(mysql_error());


echo '
<center>
<table cellspacing="4" cellpadding="0">
<tr>
<td align="center">Beschleunigerbanner gesamt: '.$besch_gesamt['ganzahl'].'</td>
<td>&nbsp;&nbsp;</td>
<td align="center">Beschleunigerbanner uebrig: '.$besch_uebrig['uanzahl'].'</td>
</tr>
<tr>
<td align="center">&Oslash; Aufenthalt: '.number_format($besch_gesamt['gaufenthalt']/$besch_gesamt['ganzahl'],2,',','.').' Sekunden</td>
<td>&nbsp;&nbsp;</td>
<td align="center">&Oslash; Verguetung: '.number_format($besch_gesamt['gverdienst']/$besch_gesamt['ganzahl'],2,',','.').' '.$waehrung.'</td>
</tr>
<tr>
<td align="center">Gesamtwert: '.number_format($besch_gesamt['gverdienst'],0,",",".").' '.$waehrung.'</td>
<td>&nbsp;&nbsp;</td>
<td align="center">Offen: '.number_format($besch_uebrig['uverdienst'],0,",",".").' '.$waehrung.'</td>
</tr>
</table>
</center>
<br>

<hr>';

$usr = mysql_fetch_assoc (db_query ('SELECT max_forced, art, sort 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.'") AND t2.bis >= '.time().')
WHERE t2.tan IS NULL AND t1.werbeart = "forcedbanner" AND t1.menge > 0 AND t1.status = 1 and t1.reload >= 3600 AND t1.verdienst > 0 AND t1.sponsor != '.$_SESSION['uid'].' ORDER BY t1.verdienst desc LIMIT 30');

while ($f_banner = mysql_fetch_assoc ($fbanner)){
echo '<div align="center" id="banner_'.$f_banner['tan'].'"><a href="fc_kd.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 | <a href="?content=/blacklist&tan='.$f_banner['tan'].'" target="_self">Blackliste</a><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>';

?>