forcedbanner.php

<?php
userstatus ();
    head ('Klickbanner');
    $fstats_gesamt = mysql_fetch_array(db_query('SELECT COUNT(t1.tan) AS ganzahl, SUM(t1.verdienst) AS gverdienst, SUM(t1.aufendhalt) AS gaufenthalt FROM '.$db_prefix.'_gebuchte_werbung t1
                        LEFT JOIN vms_fb_blacklist AS t3 ON t3.kid = t1.kid AND t3.werbeart=t1.werbeart
                        WHERE (t3.kid IS NULL OR LOCATE(t3.sponsor, t1.ziel) = 0) AND t1.werbeart = "forcedbanner" and t1.reload >= 100 AND t1.menge > 0 AND t1.status = 1 AND t1.verdienst >= 0 AND t1.sponsor != '.$_SESSION['uid'].''));

    $fstats_uebrig = mysql_fetch_array(db_query('SELECT COUNT(t1.tan) AS uanzahl, SUM(t1.verdienst) AS uverdienst FROM '.$db_prefix.'_gebuchte_werbung t1
                        LEFT JOIN vms_fb_blacklist AS t3 ON t3.kid = t1.kid AND t3.werbeart=t1.werbeart
                        LEFT JOIN vms_reloads t2 ON (t1.tan = t2.tan AND (t2.uid = '.$_SESSION['uid'].' OR t2.ip = "'.$ip.'") AND t2.bis >= '.time().')
                        WHERE (t3.kid IS NULL OR LOCATE(t3.sponsor, t1.ziel) = 0) AND t2.tan IS NULL AND t1.werbeart = "forcedbanner" and t1.reload >= 100 AND t1.menge > 0 AND t1.status = 1 AND t1.verdienst >= 0 AND t1.sponsor != '.$_SESSION['uid'].''));
    $uebriga=100/$fstats_gesamt['ganzahl']*$fstats_uebrig['uanzahl'];
    $uebrig=number_format($uebriga,2,',','.');
    $abgebaut= 100-$uebriga;
    echo "<table cellspacing='4' cellpadding='0' width='100%'>
        <tr>
        <td align='center''>Paidbanner gesamt: ".$fstats_gesamt['ganzahl']."</td>
        <td>&nbsp;&nbsp;</td>
        <td align='center'>Paidbanner uebrig: ".$fstats_uebrig['uanzahl']."</td>
        </tr>
        <tr>
        <td align='center'>&Oslash; Aufenthalt: ".number_format($fstats_gesamt['gaufenthalt']/$fstats_gesamt['ganzahl'],2,",",".")." Sekunden</td>
        <td>&nbsp;&nbsp;</td>
        <td align='center''>&Oslash; Verg&uuml;tung: ".number_format($fstats_gesamt['gverdienst']/$fstats_gesamt['ganzahl'],2,",",".")." ".$waehrung."</td>
        </tr>
        <tr>
        <td align='center''>Gesamtwert: ".$fstats_gesamt['gverdienst']." ".$waehrung."</td>
        <td>&nbsp;&nbsp;</td>
        <td align='center'>Offen: ".$fstats_uebrig['uverdienst']." ".$waehrung."</td>
        </tr>
        </table>
        <div id='fortschritt' style='width: 380px;  font-weight: bold; margin: 0 auto' align='center''></div>
        <script type=\"text/javascript\">
        var width = ".$abgebaut.";
        jQuery('#fortschritt').progressbar({value: width});
        jQuery('#fortschritt').append(jQuery('<div>').html('Noch ".$uebrig."&#37; &uuml;brig ').css('position', 'relative').css('top', '-21px').css('width', '100%').css('font-size', '14px').attr('align', 'center').attr('id', 'fortschritttext'));
        </script> ";
    $res = mysql_fetch_assoc (db_query ('SELECT r.bis FROM vms_reloads AS r
                                        LEFT JOIN vms_gebuchte_werbung AS ad ON (ad.tan = r.tan AND ad.status = 1 AND ad.werbeart = "forcedbanner" AND ad.sponsor != '.$_SESSION['uid'].')
                                        WHERE r.uid = '.$_SESSION['uid'].'  AND ad.tan IS NOT NULL  AND r.bis > '.(time()).'
                                        ORDER BY r.bis ASC LIMIT 1'));
    $zeit = ((($res['bis']-time()) >= 0) ? ($res['bis']-time()) : NULL );
    if ($zeit != NULL){
        echo '<center>Der naechste Banner kommt in '.ceil($zeit/60).' Minuten aus dem Reload!</center><hr><br>';
    }else echo '<center>Kein Banner im Reload.</center><hr><br>';

$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 . '_fb_blacklist AS t3 ON t3.kid = t1.kid AND t3.werbeart=t1.werbeart
          	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 (t3.kid IS NULL OR LOCATE(t3.sponsor, t1.ziel) = 0)  AND 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="top_forcedbanner.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 ();