Posts by Kevin

// Configuratie met database
include('inc/config.php');


// Banner rotatie ophalen
$sqli				= $db->Query("SELECT * FROM `banex` ORDER BY RAND() LIMIT 1");
$banner				= $db->FetchArray($sqli);


// clicks eraf halen van de banner
$db->Query("UPDATE `banex` SET `vieuw`=`vieuw`-'1' WHERE `naam`='".$banner['naam']."'");


$website = $banner['website'];
?>


<script type="text/javascript">




/**
		Bnner instellingen
**/


var settings = {
	
	'force_size':			0,         		//  0 = 1 banner , 1 = alle banners
	'img_width':			468,			//	De breedte van de banner
	'img_height':			60, 			// 	De hoogte van de banner
	
	'refresh_time':			5000,			//	Na hoeveel seconden de banner refreshs
	'refresh_max':			100,				//	Max nummer van het herladen van de pagina
	
	'duplicate_banners':	0,				//	Voor een error
	
	'location_prefix': 		'adLocation-',	
											
	'location_class':		'swb',			//  Voor de <div>
	
	'window': 				'_blank',		//	 _self = current, _blank = nieuw. Use _top if in a frame!		
	
	'default_ad_loc':		'default'		
}




/**
		Banners
**/


var banners = [
	new banner('<?=$banner['naam'];?>',			'banner.php?p=click', 			'http://<?=$banner['banner'];?>', 	'bottom')
]


/**
Niet veranderen hier.
**/
var used=0;var location_counter=0;var refresh_counter=1;var map=new Array();function banner(a,b,c,d,e){this.name=a;this.url=b;this.image=c;this.date=d;this.active=1;this.oid=0;if(e!=''){this.loc=e}else{this.loc=settings.default_ad_loc}}function show_banners(a){location_counter=location_counter+1;if(a!=''&&a!=undefined){map[location_counter]=a}else{map[location_counter]=settings.default_ad_loc}var b='<div id="'+settings.location_prefix+location_counter+'" class="'+settings.location_class+'"></div>';document.write(b);display_banners(location_counter)}function display_banners(a){var b=new Array();if(a==''||!a||a<0){return}var c=banners.length;if((c==used)&&settings.duplicate_banners==0){return}for(i=0;i<(banners.length);i++){banners[i].oid=i;if((banners[i].loc==map[a])&&(banners[i].active==1)){b.push(banners[i])}}var d=Math.floor(Math.random()*b.length);var e=b[d];var f=(settings.force_size==1)?' width="'+settings.img_width+'" height="'+settings.img_height+'"':'';var g='<a href="'+e.url+'" title="'+e.name+'" target="'+settings.window+'"><img border="0" src="'+e.image+'"'+f+' alt="'+e.name+'" /></a>';var h=new Date();var j=e.date;j=j.split('/',3);var k=new Date();k.setFullYear(parseInt(j[2]),parseInt(j[1])-1,parseInt(j[0]));if((h<k)&&e.active==1){var l=document.getElementById(settings.location_prefix+a);if(l==null){alert('spyka Webmaster banner rotator\nError: adLocation doesn\'t exist!')}else{l.innerHTML=g;if(settings.duplicate_banners==0){banners[e.oid].active=0;used++}return}}else{display_banners(a)}return}function refresh_banners(){if((refresh_counter==settings.refresh_max)||settings.refresh_time<1){clearInterval(banner_refresh)}used=0;for(j=0;j<(banners.length);j++){banners[j].active=1}for(j=1;j<(location_counter+1);j++){display_banners(j)}refresh_counter++}var banner_refresh=window.setInterval(refresh_banners,settings.refresh_time);
</script>






<table>
 <tr>
  <td>
		
		
		<?
		if($_GET['p']  == "click")
		{
		
		$db->Query("UPDATE `banex` SET `clicks`=`clicks`-'1' WHERE `naam`='".$banner['naam']."'");
		?>
		
			<SCRIPT LANGUAGE="JavaScript"> 
			<!-- 
			function redirect() 
			{ 
				window.top.location = "<?=$website;?>" 
			} 


			setTimeout("redirect();", 1000) 
			//--> 
			</SCRIPT> 
			
		<?
		}
		?>
		








</td>
 </tr>
</table>

<?
// Een telling bij houden.
    $tel            = 0;
    
    // De prijzen die er te winnen vallen.
    $prijzenkast    = Array ('30', '20', '10');
    
    // De mysqli query uitvoeren en hierbij de hoogste? 3 uitpakken.
    $input            = $mysqli->query ("SELECT `login` FROM `[users]` ORDER BY `actief` DESC LIMIT 3 ");
    
    // Een while uitvoeren waarbij de data van de vorige query word geselecteerd.
    while ($output = mysqli_fetch_assoc ($input))
    {
        // Een query uitvoeren waarbij de kristallen worden opgeteld bij de $output['login'] user.
        $mysqli->query ("UPDATE `[users]` SET `kristallen` = `kristallen` + '" . $prijzenkast[$tel] . "' WHERE `login`='" . $output['login'] . "'");
		echo "UPDATE `[users]` SET `kristallen` = `kristallen` + '" . $prijzenkast[$tel] . "' WHERE `login`='" . $output['login'] . "'";   
        
        // +1 bij $tel.
        $tel++;
		
		echo '<pre>' . print_r($output, true) . '</pre>';
    }


    // De gehele [users] tabel updates zodat iedereen value 0 krijgt in actief.
    $mysqli->query ("UPDATE `[users]` SET `actief` = '0'");
?>

<?
UPDATE `[users]` SET `kristallen` = `kristallen` + '5' WHERE `login`='Mtvk'
Array
(
    [login] => Mtvk
)
UPDATE `[users]` SET `kristallen` = `kristallen` + '10' WHERE `login`='Urotho'
Array
(
    [login] => Urotho
)
UPDATE `[users]` SET `kristallen` = `kristallen` + '25' WHERE `login`='Scarefacez'
Array
(
    [login] => Scarefacez
)
?>

<?
Array
(
    [login] => Mtvk
)
Array
(
    [login] => Urotho
)
Array
(
    [login] => Scarefacez
)
?>