<?php
$sperre = mysqli_fetch_array(db_query("SELECT forced_sperre FROM ".$db_prefix."_kontodaten WHERE uid = '".$_SESSION['uid']."' "));
userstatus ();
include ('fakecheck/fc_redirect.php');
    head ('Klickbanner');
    $fstats_gesamt = mysqli_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_adscan_userblacklist t4 ON t4.tan = t1.tan AND t4.uid = '.$_SESSION['uid'].'
               			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 t4.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'].''));

    $fstats_uebrig = mysqli_fetch_array(db_query('SELECT COUNT(t1.tan) AS uanzahl, SUM(t1.verdienst) AS uverdienst FROM '.$db_prefix.'_gebuchte_werbung t1
                        LEFT JOIN vms_adscan_userblacklist t4 ON t4.tan = t1.tan AND t4.uid = '.$_SESSION['uid'].'
               			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 t4.tan IS NULL 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 class=\"table\">
        <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 = mysqli_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 n&auml;chste Banner kommt in '.ceil($zeit/60).' Minuten aus dem Reload!</center><hr><br>';
    }else echo '<center>Kein Banner im Reload.</center><hr><br>';

	if($sperre['forced_sperre'] == 0){
		$usr = mysqli_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 . '_adscan_userblacklist t4 ON t4.tan = t1.tan AND t4.uid = ' . $_SESSION['uid'] . '
					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 t4.tan IS NULL 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 = mysqli_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 (mysqli_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 class="alert alert-warning text-center">Alle Banner im Reload !</div>';
	}else{
		echo '<div class="alert alert-danger text-center">Du bist f&uuml;r den Klickbereich gesperrt.</div>';
	}
foot ();