//-/****************************************/-//
   ZET DE VOLGENDE SCRIPTS IN EEN APPARTE
   MAP, BIJVOORBEELD: WWW.DOMEIN.NL/BANNERSTATS/
//-/****************************************/-//



------- databaseconnect.php ----------
<?
	session_start();
	
	$host = "localhost";
	$user = "database user";
	$pass = "database paswoord";
	$dbdb = "database naam";
	
	if (!@mysql_select_db($dbdb, @mysql_connect($host, $user, $pass)))
	{
		echo "<font face=\"Verdana, Arial, Helvetica\" size=\"2\">Sorry, er kon geen connectie worden gemaakt met de database.<p>";
		echo "Probeer het a.u.b opnieuw. Blijft dit probleem zich voordoen, neemt u dan contact op met de webmaster.</font>";
		exit();
	}
	
	$host = "";
	$user = "";
	$pass = "";
	$dbdb = "";
?>

-------- sessiecheck.php --------
<?
	if (!$HTTP_SESSION_VARS["banid"])
	{
		echo "U heeft niet de juiste rechten om deze pagina te bekijken.<p>";
		
		echo "Om uw banner statistieken te bekijken moet u <a href=\"index.php\">inloggen</a>.";
		exit();
	}
?>

------- navigatie.php ---------
<?
	echo "<a href=\"dagoverzicht.php\" target=\"_top\">dag overzicht</a>";
	echo " | ";
	echo "<a href=\"maandoverzicht.php\" target=\"_top\">maand overzicht</a>";
	echo " | ";
	echo "<a href=\"dagmaandoverzicht.php\" target=\"_top\">dag/maand overzicht</a>";
	echo " | ";
	echo "<a href=\"bannerinstellingen.php\" target=\"_top\">banner instellingen</a>";
	echo " | ";
	echo "<a href=\"uitloggen.php\" target=\"_top\">uitloggen</a>";
?>

----- dagmaandoverzicht.php ----------
<?
	session_start();
	require("databaseconnect.php");
	require("sessioncheck.php");
	require("navigatie.php");

	
	function GetMonth($month)
	{
		if ($month == "01")
			$month = "Januari";
		elseif ($month == "02")
			$month = "Februari";
		elseif ($month == "03")
			$month = "Maart";
		elseif ($month == "04")
			$month = "April";
		elseif ($month == "05")
			$month = "Mei";
		elseif ($month == "06")
			$month = "Juni";
		elseif ($month == "07")
			$month = "Juli";
		elseif ($month == "08")
			$month = "Augustus";
		elseif ($month == "09")
			$month = "September";
		elseif ($month == "10")
			$month = "Oktober";
		elseif ($month == "11")
			$month = "November";
		elseif ($month == "12")
			$month = "December";
			
		return $month;
	}
	
	if ($HTTP_POST_VARS["submit"])
	{
		$seldd = $HTTP_POST_VARS[dd];
		$selmm = $HTTP_POST_VARS[mm];
		$selyy = $HTTP_POST_VARS[yy];
	}
	else
	{
		$seldd = date("d");
		$selmm = date("m");
		$selyy = date("Y");
	}

	echo "<form method=\"post\" action=\"$PHP_SELF\">";
	echo "<select name=\"dd\">";
	for ($i = 1; $i <= 31; $i++)
	{
		if ($i < 10)
			$dd = "0" . $i;
		else
			$dd = $i;
		
		if ($seldd == $i)
			echo "<option value=\"$dd\" selected>$dd</option>";
		else
			echo "<option value=\"$dd\">$dd</option>";
	}
	echo "</select> ";
	echo "<select name=\"mm\">";
	if ($selmm == "01")
		echo "<option value=\"01\" selected>Jan</option>";
	else
		echo "<option value=\"01\">Jan</option>";
		
	if ($selmm == "02")
		echo "<option value=\"02\" selected>Feb</option>";
	else
		echo "<option value=\"02\">Feb</option>";
	
	if ($selmm == "03")
		echo "<option value=\"03\" selected>Mar</option>";
	else	
		echo "<option value=\"03\">Mar</option>";
	
	if ($selmm == "04")
		echo "<option value=\"04\" selected>Apr</option>";
	else
		echo "<option value=\"04\">Apr</option>";
	
	if ($selmm == "05")
		echo "<option value=\"05\" selected>Mei</option>";
	else
		echo "<option value=\"05\">Mei</option>";
	
	if ($selmm == "06")
		echo "<option value=\"06\" selected>Jun</option>";
	else
		echo "<option value=\"06\">Jun</option>";
	
	if ($selmm == "07")
		echo "<option value=\"07\" selected>Jul</option>";
	else
		echo "<option value=\"07\">Jul</option>";
	
	if ($selmm == "08")
		echo "<option value=\"08\" selected>Aug</option>";
	else
		echo "<option value=\"08\">Aug</option>";
	
	if ($selmm == "09")
		echo "<option value=\"09\" selected>Sep</option>";
	else
		echo "<option value=\"09\">Sep</option>";
	
	if ($selmm == "10")
		echo "<option value=\"10\" selected>Okt</option>";
	else
		echo "<option value=\"10\">Okt</option>";
	
	if ($selmm == "11")
		echo "<option value=\"11\" selected>Nov</option>";
	else
		echo "<option value=\"11\">Nov</option>";
	
	if ($selmm == "12")
		echo "<option value=\"12\" selected>Dec</option>";
	else
		echo "<option value=\"12\">Dec</option>";
	
	echo "</select> ";
	
	$cyear = date("Y");
	$firstyear = $cyear - 2;
	echo "<select name=\"yy\">";
	for ($i = $firstyear; $i <= $cyear; $i++)
	{
		if ($selyy == $i)
			echo "<option value=\"$i\" selected>$i</option>";
		else
			echo "<option value=\"$i\">$i</option>";
	}
	echo "</select> ";
	echo "<input type=\"submit\" name=\"submit\" value=\"toon datum\">";
	echo "</form><P>";
	
	if ($HTTP_POST_VARS["submit"])
	{
		$sqldd = $HTTP_POST_VARS[dd];
		$sqlmm = $HTTP_POST_VARS[mm];
		$sqlyy = $HTTP_POST_VARS[yy];
		$total = $sqldd . "." . $sqlmm . "." . $sqlyy;
	}
	else
		$total = date("d.m.Y");
	
	$sql = "SELECT out,views FROM php_banner_out WHERE url = '$HTTP_SESSION_VARS[banurl]' AND datum = '$total'";
	$res = mysql_query($sql);
	$row = mysql_fetch_array($res);
	$out = $row[out];
	$views = $row[views];
	
	if ($views == "")
	{
		$imgwidth = "1";
		$views = "0";
	}
	else
	{
		$imgwidth = $views;
	}
	
	if ($imgwidth > 550)
		$imgwidth = 550;
		
	if ($out == "")
	{
		$imgwidth2 = "1";
		$out = "0";
	}
	else
	{
		$imgwidth2 = $out;
	}
	
	if ($imgwidth2 > 550)
		$imgwidth2 = 550;
	
	echo "<b>Views</b> <span class=\"small\">$total</span><P>";
	
	echo "<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\" bordercolor=\"#000000\" width=\"100%\" bgcolor=\"#BBD4F1\"><tr><td>";
	echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"5\">";
	echo "<tr>";
	echo "<td valign=\"top\"><p>Beneden ziet u de <i>views</i> van uw banner. Dit is dus hoe vaak uw banner bekeken is op <i>$total</i>.</p>";
	echo "<span class=\"small\">totaal: $views <img src=\"imgs/stats.gif\" width=\"$imgwidth\" height=\"10\"></td>";
	echo "</tr>";
	echo "</table>";
	echo "</td></tr></table><p>";
	
	echo "<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\" bordercolor=\"#000000\" width=\"100%\" bgcolor=\"#BBD4F1\"><tr><td>";
	echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"5\">";
	echo "<tr>";
	echo "<td valign=\"top\"><p>Beneden ziet u de <i>kliks</i> van uw banner. Dit is dus hoe vaak er op uw banner geklikt is op <i>$total</i>.</p>";
	echo "<span class=\"small\">totaal: $out <img src=\"imgs/stats.gif\" width=\"$imgwidth2\" height=\"10\"></td>";
	echo "</tr>";
	echo "</table>";
	echo "</td></tr></table><p>";
	
	if ($HTTP_POST_VARS["submit"])
	{
		$sqlmm = $HTTP_POST_VARS[mm];
		$sqlyy = $HTTP_POST_VARS[yy];
		$total = $sqlmm . "." . $sqlyy;
	}
	else
		$total = date("m.Y");
	
	$sql = "SELECT out,views FROM php_banner_out WHERE url = '$HTTP_SESSION_VARS[banurl]' AND SUBSTRING(datum, 4, 9) = '$total'";
	$res = mysql_query($sql);
	
	unset($out);
	unset($views);
	
	while ($row = mysql_fetch_array($res))
	{
		if (!$row[out])
			$row[out] = "0";
		if (!$row[views])
			$row[views] = "0";
		
		if (!$out)
			$out = $row[out];
		else
			$out = $out+$row[out];
		
		if (!$views)
			$views = $row[views];
		else
			$views = $views+$row[views];
	}
	
	if ($views == "")
	{
		$imgwidth = "1";
		$views = "0";
	}
	else
	{
		$imgwidth = $views;
	}
	
	if ($imgwidth > 550)
		$imgwidth = 550;
		
	if ($out == "")
	{
		$imgwidth2 = "1";
		$out = "0";
	}
	else
	{
		$imgwidth2 = $out;
	}
	
	if ($imgwidth2 > 550)
		$imgwidth2 = 550;
		
	$total = substr($total, 0, 2);
	$total = GetMonth($total);
	
	echo "<b>Clicks</b> <span class=\"small\">$total</span><p>";
	
	echo "<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\" bordercolor=\"#000000\" width=\"100%\" bgcolor=\"#BBD4F1\"><tr><td>";
	echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"5\">";
	echo "<tr>";
	echo "<td valign=\"top\"><p>Beneden ziet u de <i>views</i> van uw banner. Dit is dus hoe vaak uw banner is bekeken in de maand $total.</p>";
	echo "<span class=\"small\">totaal: $views <img src=\"imgs/stats.gif\" width=\"$imgwidth\" height=\"10\"></td>";
	echo "</tr>";
	echo "</table>";
	echo "</td></tr></table><p>";
	
	echo "<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\" bordercolor=\"#000000\" width=\"100%\" bgcolor=\"#BBD4F1\"><tr><td>";
	echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"5\">";
	echo "<tr>";
	echo "<td valign=\"top\"><p>Beneden ziet u de <i>kliks</i> van uw banner. Dit is dus hoe vaak er op uw banner is geklikt in de maand $total.</p>";
	echo "<span class=\"small\">totaal: $out <img src=\"imgs/stats.gif\" width=\"$imgwidth2\" height=\"10\"></td>";
	echo "</tr>";
	echo "</table>";
	echo "</td></tr></table>";


?>

-------- dagoverzicht.php -------
<?
	session_start();
	require("databaseconnect.php");

	require("sessioncheck.php");
	require("navigatie.php");

	
	if ($HTTP_POST_VARS["submit"])
	{
		$seldd = $HTTP_POST_VARS[dd];
		$selmm = $HTTP_POST_VARS[mm];
		$selyy = $HTTP_POST_VARS[yy];
	}
	else
	{
		$seldd = date("d");
		$selmm = date("m");
		$selyy = date("Y");
	}

	echo "<form method=\"post\" action=\"$PHP_SELF\">";
	echo "<select name=\"dd\">";
	for ($i = 1; $i <= 31; $i++)
	{
		if ($i < 10)
			$dd = "0" . $i;
		else
			$dd = $i;
		
		if ($seldd == $i)
			echo "<option value=\"$dd\" selected>$dd</option>";
		else
			echo "<option value=\"$dd\">$dd</option>";
	}
	echo "</select> ";
	echo "<select name=\"mm\">";
	if ($selmm == "01")
		echo "<option value=\"01\" selected>Jan</option>";
	else
		echo "<option value=\"01\">Jan</option>";
		
	if ($selmm == "02")
		echo "<option value=\"02\" selected>Feb</option>";
	else
		echo "<option value=\"02\">Feb</option>";
	
	if ($selmm == "03")
		echo "<option value=\"03\" selected>Mar</option>";
	else	
		echo "<option value=\"03\">Mar</option>";
	
	if ($selmm == "04")
		echo "<option value=\"04\" selected>Apr</option>";
	else
		echo "<option value=\"04\">Apr</option>";
	
	if ($selmm == "05")
		echo "<option value=\"05\" selected>Mei</option>";
	else
		echo "<option value=\"05\">Mei</option>";
	
	if ($selmm == "06")
		echo "<option value=\"06\" selected>Jun</option>";
	else
		echo "<option value=\"06\">Jun</option>";
	
	if ($selmm == "07")
		echo "<option value=\"07\" selected>Jul</option>";
	else
		echo "<option value=\"07\">Jul</option>";
	
	if ($selmm == "08")
		echo "<option value=\"08\" selected>Aug</option>";
	else
		echo "<option value=\"08\">Aug</option>";
	
	if ($selmm == "09")
		echo "<option value=\"09\" selected>Sep</option>";
	else
		echo "<option value=\"09\">Sep</option>";
	
	if ($selmm == "10")
		echo "<option value=\"10\" selected>Okt</option>";
	else
		echo "<option value=\"10\">Okt</option>";
	
	if ($selmm == "11")
		echo "<option value=\"11\" selected>Nov</option>";
	else
		echo "<option value=\"11\">Nov</option>";
	
	if ($selmm == "12")
		echo "<option value=\"12\" selected>Dec</option>";
	else
		echo "<option value=\"12\">Dec</option>";
	
	echo "</select> ";
	
	$cyear = date("Y");
	$firstyear = $cyear - 2;
	echo "<select name=\"yy\">";
	for ($i = $firstyear; $i <= $cyear; $i++)
	{
		if ($selyy == $i)
			echo "<option value=\"$i\" selected>$i</option>";
		else
			echo "<option value=\"$i\">$i</option>";
	}
	echo "</select> ";
	echo "<input type=\"submit\" name=\"submit\" value=\"toon datum\">";
	echo "</form><P>";
	
	if ($HTTP_POST_VARS["submit"])
	{
		$sqldd = $HTTP_POST_VARS[dd];
		$sqlmm = $HTTP_POST_VARS[mm];
		$sqlyy = $HTTP_POST_VARS[yy];
		$total = $sqldd . "." . $sqlmm . "." . $sqlyy;
	}
	else
		$total = date("d.m.Y");
	
	$sql = "SELECT out,views FROM php_banner_out WHERE url = '$HTTP_SESSION_VARS[banurl]' AND datum = '$total'";
	$res = mysql_query($sql);
	$row = mysql_fetch_array($res);
	$out = $row[out];
	$views = $row[views];
	
	if ($views == "")
	{
		$imgwidth = "1";
		$views = "0";
	}
	else
	{
		$imgwidth = $views;
	}
	
	if ($imgwidth > 550)
		$imgwidth = 550;
		
	if ($out == "")
	{
		$imgwidth2 = "1";
		$out = "0";
	}
	else
	{
		$imgwidth2 = $out;
	}
	
	if ($imgwidth2 > 550)
		$imgwidth2 = 550;
	
	echo "<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\" bordercolor=\"#000000\" width=\"100%\" bgcolor=\"#BBD4F1\"><tr><td>";
	echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"5\">";
	echo "<tr>";
	echo "<td valign=\"top\"><p>Beneden ziet u de <i>views</i> van uw banner. Dit is dus hoe vaak uw banner is bekeken.</p>";
	echo "<span class=\"small\">totaal: $views <img src=\"imgs/stats.gif\" width=\"$imgwidth\" height=\"10\"></td>";
	echo "</tr>";
	echo "</table>";
	echo "</td></tr></table><p>";
	
	echo "<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\" bordercolor=\"#000000\" width=\"100%\" bgcolor=\"#BBD4F1\"><tr><td>";
	echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"5\">";
	echo "<tr>";
	echo "<td valign=\"top\"><p>Beneden ziet u de <i>kliks</i> van uw banner. Dit is dus hoe vaak er op uw banner is geklikt.</p>";
	echo "<span class=\"small\">totaal: $out <img src=\"imgs/stats.gif\" width=\"$imgwidth2\" height=\"10\"></td>";
	echo "</tr>";
	echo "</table>";
	echo "</td></tr></table>";


?>

------ maandoverzicht.php --------
<?
	session_start();
	require("databaseconnect.php");

	require("sessioncheck.php");
	require("navigatie.php");

	
	if ($HTTP_POST_VARS["submit"])
	{
		$selmm = $HTTP_POST_VARS[mm];
		$selyy = $HTTP_POST_VARS[yy];
	}
	else
	{
		$selmm = date("m");
		$selyy = date("Y");
	}

	echo "<form method=\"post\" action=\"$PHP_SELF\">";
	echo "<select name=\"mm\">";
	if ($selmm == "01")
		echo "<option value=\"01\" selected>Jan</option>";
	else
		echo "<option value=\"01\">Jan</option>";
		
	if ($selmm == "02")
		echo "<option value=\"02\" selected>Feb</option>";
	else
		echo "<option value=\"02\">Feb</option>";
	
	if ($selmm == "03")
		echo "<option value=\"03\" selected>Mar</option>";
	else	
		echo "<option value=\"03\">Mar</option>";
	
	if ($selmm == "04")
		echo "<option value=\"04\" selected>Apr</option>";
	else
		echo "<option value=\"04\">Apr</option>";
	
	if ($selmm == "05")
		echo "<option value=\"05\" selected>Mei</option>";
	else
		echo "<option value=\"05\">Mei</option>";
	
	if ($selmm == "06")
		echo "<option value=\"06\" selected>Jun</option>";
	else
		echo "<option value=\"06\">Jun</option>";
	
	if ($selmm == "07")
		echo "<option value=\"07\" selected>Jul</option>";
	else
		echo "<option value=\"07\">Jul</option>";
	
	if ($selmm == "08")
		echo "<option value=\"08\" selected>Aug</option>";
	else
		echo "<option value=\"08\">Aug</option>";
	
	if ($selmm == "09")
		echo "<option value=\"09\" selected>Sep</option>";
	else
		echo "<option value=\"09\">Sep</option>";
	
	if ($selmm == "10")
		echo "<option value=\"10\" selected>Okt</option>";
	else
		echo "<option value=\"10\">Okt</option>";
	
	if ($selmm == "11")
		echo "<option value=\"11\" selected>Nov</option>";
	else
		echo "<option value=\"11\">Nov</option>";
	
	if ($selmm == "12")
		echo "<option value=\"12\" selected>Dec</option>";
	else
		echo "<option value=\"12\">Dec</option>";
	
	echo "</select> ";
	
	$cyear = date("Y");
	$firstyear = $cyear - 2;
	echo "<select name=\"yy\">";
	for ($i = $firstyear; $i <= $cyear; $i++)
	{
		if ($selyy == $i)
			echo "<option value=\"$i\" selected>$i</option>";
		else
			echo "<option value=\"$i\">$i</option>";
	}
	echo "</select> ";
	echo "<input type=\"submit\" name=\"submit\" value=\"toon datum\">";
	echo "</form><P>";
	
	if ($HTTP_POST_VARS["submit"])
	{
		$sqlmm = $HTTP_POST_VARS[mm];
		$sqlyy = $HTTP_POST_VARS[yy];
		$total = $sqlmm . "." . $sqlyy;
	}
	else
		$total = date("m.Y");
	
	$sql = "SELECT out,views FROM php_banner_out WHERE url = '$HTTP_SESSION_VARS[banurl]' AND SUBSTRING(datum, 4, 9) = '$total'";
	$res = mysql_query($sql);
	
	unset($out);
	unset($views);
	
	while ($row = mysql_fetch_array($res))
	{
		if (!$row[out])
			$row[out] = "0";
		if (!$row[views])
			$row[views] = "0";
		
		if (!$out)
			$out = $row[out];
		else
			$out = $out+$row[out];
		
		if (!$views)
			$views = $row[views];
		else
			$views = $views+$row[views];
	}
	
	if ($views == "")
	{
		$imgwidth = "1";
		$views = "0";
	}
	else
	{
		$imgwidth = $views;
	}
	
	if ($imgwidth > 550)
		$imgwidth = 550;
		
	if ($out == "")
	{
		$imgwidth2 = "1";
		$out = "0";
	}
	else
	{
		$imgwidth2 = $out;
	}
	
	if ($imgwidth2 > 550)
		$imgwidth2 = 550;
	
	echo "<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\" bordercolor=\"#000000\" width=\"100%\" bgcolor=\"#BBD4F1\"><tr><td>";
	echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"5\">";
	echo "<tr>";
	echo "<td valign=\"top\"><p>Beneden ziet u de <i>views</i> van uw banner. Dit is dus hoe vaak uw banner is bekeken in deze maand.</p>";
	echo "<span class=\"small\">totaal: $views <img src=\"imgs/stats.gif\" width=\"$imgwidth\" height=\"10\"></td>";
	echo "</tr>";
	echo "</table>";
	echo "</td></tr></table><p>";
	
	echo "<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\" bordercolor=\"#000000\" width=\"100%\" bgcolor=\"#BBD4F1\"><tr><td>";
	echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"5\">";
	echo "<tr>";
	echo "<td valign=\"top\"><p>Beneden ziet u de <i>kliks</i> van uw banner. Dit is dus hoe vaak er op uw banner is geklikt in deze maand.</p>";
	echo "<span class=\"small\">totaal: $out <img src=\"imgs/stats.gif\" width=\"$imgwidth2\" height=\"10\"></td>";
	echo "</tr>";
	echo "</table>";
	echo "</td></tr></table>";


?>

------ bannerinstellingen.php ---------
<?
	session_start();
	require("databaseconnect.php");

	require("sessioncheck.php");
	require("navigatie.php");

	
	if ($HTTP_POST_VARS["submit"] && $HTTP_POST_VARS["alt"] && $HTTP_POST_VARS["url"])
	{
		if (!$HTTP_POST_VARS["confirm"])
		{
			echo "<b>Weet u zeker dat u de volgende wijzigingen wilt aanbrengen?</b><p>";
			
			if (substr($url, 0, 7) != "http://")
				$url = "http://" . "$HTTP_POST_VARS[url]";
			else
				$url = "$HTTP_POST_VARS[url]";
			
			echo "<b>Url:</b> $HTTP_POST_VARS[url]<br>";
			echo "<b>Alt:</b> $HTTP_POST_VARS[alt]<br>";
			
			echo "<form method=\"post\" action=\"$PHP_SELF\">";
			echo "<input type=\"hidden\" name=\"confirm\" value=\"1\">";
			echo "<input type=\"hidden\" name=\"url\" value=\"$url\">";
			echo "<input type=\"hidden\" name=\"alt\" value=\"$HTTP_POST_VARS[alt]\">";
			echo "<input type=\"submit\" name=\"submit\" value=\"wijzigingen aanbrengen\"> | <a href=\"$PHP_SELF\">annuleren</a>";
			echo "</form>";
		}
		elseif ($HTTP_POST_VARS["confirm"])
		{
			$sql = "UPDATE php_banners SET url = '$HTTP_POST_VARS[url]', alt = '$HTTP_POST_VARS[alt]' WHERE url = '$HTTP_SESSION_VARS[banurl]'";
			$res = mysql_query($sql);
			
			$sql = "UPDATE php_banner_login SET url = '$HTTP_POST_VARS[url]' WHERE id = '$HTTP_SESSION_VARS[banid]'";
			$res = mysql_query($sql);
			
			$sql = "UPDATE php_banner_out SET url = '$HTTP_POST_VARS[url]' WHERE url = '$HTTP_SESSION_VARS[banurl]'";
			$res = mysql_query($sql);
			
			$sql = "SELECT url FROM php_banners WHERE url = '$HTTP_POST_VARS[url]'";
			$res = mysql_query($sql);
			$banurl = mysql_result($res, 0);
			
			session_unregister("banurl");
			
			session_register(banurl);
			echo "<script language=\"javascript\" type=\"text/javascript\">window.location='$PHP_SELF?edit=1'</script>";
		}
	}
	else
	{
		if ($HTTP_POST_VARS["submit"])
			echo "<span class=\"error\">U bent enkele velden vergeten in te vullen.</span><p>";
		elseif ($edit)
			echo "<span class=\"error\">Uw wijzigingen zijn aangebracht.</span><p>";
			
		echo "De huidige gegevens zijn de standaard waardes in de invoer velden. Na op de 'wijzigen' knop ";
		echo "te hebben geklikt zult u de nieuwe gegevens moeten bevestigen. Dit ter beveiliging.<p>";
		
		//echo "<span class=\"error\">Onthoud!</span> Als u uw url adres wijzigt vervallen de statistieken en zullen er nieuwe statistieken worden aangemaakt. Als u uw 'oude' url adres vervolgens weer terug zet heeft u uw oude statistieken weer.<p>";
		
		$sql = "SELECT url,alt,pic FROM php_banners WHERE url = '$HTTP_SESSION_VARS[banurl]'";
		$res = mysql_query($sql);
		$row = mysql_fetch_array($res);
		
		if (substr($row[url], 0, 7) != "http://")
			$furl = "http://" . $row[url];
		else
			$furl = $row[url];
			
		if (substr($row[pic], 0, 7) != "http://")
			$purl = "http://" . $row[pic];
		else
			$purl = $row[pic];
		
		echo "<form method=\"post\" action=\"$PHP_SELF\">";
		echo "<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\" bordercolor=\"#000000\" bgcolor=\"#BBD4F1\"><tr><td>";
		echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"5\">";
		echo "<tr><td width=\"100\">Uw URL adres:</td><td><input type=\"text\" name=\"url\" value=\"$furl\" size=\"60\" maxlength=\"200\"></td></tr>";
		echo "<tr><td width=\"100\">Uw alt tekst:</td><td><input type=\"text\" name=\"alt\" value=\"$row[alt]\" size=\"50\" maxlength=\"50\"></td></tr>";
		echo "<tr><td>&nbsp;</td><td><input type=\"submit\" name=\"submit\" value=\"wijzigen\"></td></tr>";
		echo "</table>";
		echo "</td></tr></table>";
		echo "</form><p>";
		
		echo "<center><span class=\"small\">banner weergave</span><br>";
		echo "<img src=\"$purl\" alt=\"$row[alt]\" border=\"1\" style=\"border-color: #000000\">";
		echo "</center>";
	}


?>

----------- index.php -------------
<?
	session_start();

	if ($HTTP_POST_VARS["loginnaam"] && $HTTP_POST_VARS["wachtwoord"])
	{
		$sql = "SELECT id,url FROM php_banner_login WHERE loginnaam = '$HTTP_POST_VARS[loginnaam]' AND wachtwoord = '$HTTP_POST_VARS[wachtwoord]'";
		$res = mysql_query($sql);
		if (mysql_num_rows($res) >= 1)
		{
			$row = mysql_fetch_array($res);
			$banid = $row[id];
			$banurl = $row[url];
			session_register(banid);
			session_register(banurl);
			echo "<script language=\"javascript\" type=\"text/javascript\">window.location='$PHP_SELF'</script>";
		}
		else
		{
			echo "<script language=\"javascript\" type=\"text/javascript\">window.location='$PHP_SELF?err=1'</script>";
		}
	}
	elseif ($HTTP_SESSION_VARS["banid"])
	{
		require("navigatie.php");
		echo "U bent reeds ingelogd.<p>";
		
		echo "De navigatie kunt u aan de bovenkant van de pagina vinden.";
	}
    else
    {
    	if ($err)
    		echo "<p class=\"error\">U heeft een ongeldige login naam of wachtwoord ingevoerd. Probeer het opnieuw.</p>";
?>
    	<p>Welkom bij de banner statistieken. Hier kunt u uw 
              banner statistieken tot op de dag volgen.</p>
            <p>Om in te loggen moet u uw login naam en wachtwoord die u van ons 
              heeft gekregen, in onderstaande velden invullen. Mocht u nog vragen 
              hebben of bent u uw login gegevens kwijt, neem dan contact met ons 
              op. Voor een snel antwoord kunt u mailen naar <a href="mailto:info@domein.nl">info@domein.nl</a>.</p>
            <form name="form1" method="post" action="">
              <table width="243" border="0" cellspacing="0" cellpadding="0">
                <tr valign="top" align="left"> 
                  <td width="93">login naam</td>
                  <td width="166"> 
                    <input type="text" name="loginnaam" size="10" maxlength="10">
                  </td>
                </tr>
                <tr valign="top" align="left"> 
                  <td width="93">wachtwoord</td>
                  <td width="166"> 
                    <input type="password" name="wachtwoord" size="10" maxlength="10">
                  </td>
                </tr>
                <tr valign="top" align="left"> 
                  <td width="93">&nbsp;</td>
                  <td width="166">
                    <input type="submit" name="submit" value="inloggen">
                  </td>
                </tr>
              </table>
            </form>
            <p>&nbsp;</p>
<?
	}
?>



//-/****************************************/-//
   GEBRUIKT DIT VOOR OP JE PAGINA
//-/****************************************/-//


-------- banners.php ---------
<?
	// maak db connectie (hoeft dus niet als je al 1 hebt)
	$host = "localhost";
	$user = "database user";
	$pass = "database paswoord";
	$dbdb = "database naam";
	
	if (!@mysql_select_db($dbdb, @mysql_connect($host, $user, $pass)))
	{
		echo "<font face=\"Verdana, Arial, Helvetica\" size=\"2\">Sorry, er kon geen connectie worden gemaakt met de database.<p>";
		echo "Probeer het a.u.b opnieuw. Blijft dit probleem zich voordoen, neemt u dan contact op met de webmaster.</font>";
		exit();
	}
	
	$host = "";
	$user = "";
	$pass = "";
	$dbdb = "";
	
	$btable = "php_banners";
	$btable2 = "php_banner_rotation";

	$rsql = "SELECT bid FROM $btable2 WHERE id = 1";
	$rres = mysql_query($rsql);
	$row = mysql_fetch_array($rres);
	
	if (mysql_num_rows($rres) >= 1)
		$bid = $row[bid];
	else
		$bid = 1;

	$sql = "SELECT id,url,pic,alt FROM $btable WHERE bid = '$bid'";
	$res = mysql_query($sql);
	
	if (mysql_num_rows($res) >= 1)
	{
		$total = mysql_num_rows($res);
		$row = mysql_fetch_array($res);
		
		if (substr($row[url], 0, 7) != "http://")
			$row[url] = "http://" . $row[url];
		if (substr($row[pic], 0, 7) != "http://")
			$row[pic] = "http://" . $row[pic];
		
		echo "<a href=\"http://www.phphulp.nl/out.php?url=$row[url]\" target=\"_blank\"><img src=\"$row[pic]\" alt=\"$row[alt]\" border=\"1\" style=\"border-color: #000000\"></a><p>";
		$url = $row[url];
	}
	
	$datum = date("d.m.Y");
	$sql = "SELECT id FROM php_banner_out WHERE datum = '$datum' AND url = '$url'";
	$res = mysql_query($sql);
	
	if (mysql_num_rows($res) >= 1)
		$sql = "UPDATE php_banner_out SET views = views+1 WHERE datum = '$datum' AND url = '$url'";
	else
		$sql = "INSERT INTO php_banner_out (id, url, views, datum) VALUES ('', '$url', '1', '$datum')";
	@mysql_query($sql);
	
	$sql = "SELECT id FROM $btable";
	$res = mysql_query($sql);
	$count = mysql_num_rows($res);

	if ($bid == $count)
		$bid = "0";
		
	$sql = "UPDATE $btable2 SET bid = $bid+1";
	@mysql_query($sql);
	
	unset($sql);
	unset($count);
	unset($res);
	unset($row);
	unset($rres);
	unset($rsql);
	
?>

-------- out.php -----------
<?
	if ($HTTP_GET_VARS["url"])
	{
	    // maak db connectie (hoeft dus niet als je al 1 hebt) 
	    $host = "localhost"; 
	    $user = "database user"; 
	    $pass = "database paswoord"; 
	    $dbdb = "database naam"; 
	     
	    if (!@mysql_select_db($dbdb, @mysql_connect($host, $user, $pass))) 
	    { 
	        echo "<font face=\"Verdana, Arial, Helvetica\" size=\"2\">Sorry, er kon geen connectie worden gemaakt met de database.<p>"; 
	        echo "Probeer het a.u.b opnieuw. Blijft dit probleem zich voordoen, neemt u dan contact op met de webmaster.</font>"; 
	        exit(); 
	    } 
	     
	    $host = ""; 
	    $user = ""; 
	    $pass = ""; 
	    $dbdb = ""; 

		$sql = "UPDATE php_banner_out SET out=out+1 WHERE url = '$HTTP_GET_VARS[url]'";
		mysql_query($sql);

		header("Location: $url");
	}
?>