<? session_start();
include("include/Connection.php");
if (!isset($user))  //if user is not set
{
	header("location: default.php");
	exit;
}
$nonsite = mysql_query("SELECT * FROM websites WHERE uname='".$user."'");
if (mysql_num_rows($nonsite)<=0)  // if there r no websites for this user redirect to default page
{
	header("location: default.php?aff=".$user);
	exit;
}
//if no active sites
$nactivesites = mysql_query("SELECT * FROM websites WHERE uname='".$user."' AND isenabled=1 ORDER BY num");
	if (mysql_num_rows($nactivesites)<=0)  
{
	header("location: default.php?aff=".$user);
	exit;
}

$userobj1 = mysql_query("SELECT * FROM users WHERE uname='".$user."'");  // if no user found with this name redirect to default page
if (mysql_num_rows($userobj1)<=0)
{
	header("location: default.php");
	exit;
}

$userobj=mysql_fetch_array($userobj1);

if ($userobj["numsites"] == 0)  //if no sites, update numvisits and redirect to default page
{
	
	mysql_query("UPDATE users SET numvisits=numvisits+1 WHERE uname='".$user."'");
	header("location: default.php?aff=".$user);
	exit;
}

if ($userobj["lastshown"] == 0)
{
	mysql_query("UPDATE users SET lastshown=1,showntimes=1,numvisits=numvisits+1 WHERE uname='".$user."'");
	$website = mysql_query("SELECT * FROM websites WHERE uname='".$user."' AND num=1");
	$website2 = mysql_fetch_array($website);
	$newsite = $website2["website"];
	$newsite = "http://".$newsite;
	mysql_query("UPDATE websites SET numvisits=numvisits+1 WHERE uname='".$user."' AND num=1");
	//update coop totalhits
	$coopuname = $website2["sitedscn"];
	if ($user == "affcoop" or $user == "maincoop") {
	mysql_query("UPDATE coop SET totalhits=totalhits+1 WHERE uname='".$coopuname."' AND website='$newsite'");
	}
	//update fctccoop totalhits
	if ($user == "fctc") {
	mysql_query("UPDATE fctccoop SET totalhits=totalhits+1 WHERE uname='".$coopuname."' AND website='$newsite'");
	}
	
	
	header("location: ".$newsite);
	exit;
}

$websites = mysql_query("SELECT * FROM websites WHERE uname='".$user."' AND num='".$userobj["lastshown"]."'");
$website = mysql_fetch_array($websites);
if (mysql_num_rows($websites)==0){	
	mysql_query("UPDATE users SET lastshown=1,showntimes=1,numvisits=numvisits+1 WHERE uname='".$user."'");
	$website = mysql_fetch_array(mysql_query("SELECT * FROM websites WHERE uname='".$user."' AND num=1"));
	$newsite = $website["website"];
	$newsite = "http://".$newsite;
	mysql_query("UPDATE websites SET numvisits=numvisits+1 WHERE uname='".$user."' AND num=1");
		//update coop totalhits
	$coopuname = $website["sitedscn"];
	if ($user == "affcoop" or $user == "maincoop") {
	mysql_query("UPDATE coop SET totalhits=totalhits+1 WHERE uname='".$coopuname."' AND website='$newsite'");
	}
	
	//update fctccoop totalhits
	if ($user == "fctc") {
	mysql_query("UPDATE fctccoop SET totalhits=totalhits+1 WHERE uname='".$coopuname."' AND website='$newsite'");
	}
	header("location: ".$newsite);
	exit;
}

if ($userobj["showntimes"] < $website["priority"])
{
	mysql_query("UPDATE users SET showntimes=showntimes+1,numvisits=numvisits+1 WHERE uname='".$user."'");
	mysql_query("UPDATE websites SET numvisits=numvisits+1 WHERE uname='".$user."' AND num=".$website["num"]);
	$newsite = $website["website"];
		//update coop totalhits
	$coopuname = $website["sitedscn"];
	if ($user == "affcoop" or $user == "maincoop") {
	mysql_query("UPDATE coop SET totalhits=totalhits+1 WHERE uname='".$coopuname."' AND website='$newsite'");
	}
	//update fctccoop totalhits
	if ($user == "fctc") {
	mysql_query("UPDATE fctccoop SET totalhits=totalhits+1 WHERE uname='".$coopuname."' AND website='$newsite'");
	}
	header("location: http://".$newsite);
	exit;
}

$nextsites = mysql_query("SELECT * FROM websites WHERE uname='".$user."' AND num>".$userobj["lastshown"]." AND isenabled=1 ORDER BY num");
if (!($nextsites = mysql_fetch_array($nextsites)))
{
	$nextsites = mysql_query("SELECT * FROM websites WHERE uname='".$user."' AND isenabled=1 ORDER BY num");
	if (!($nextsites = mysql_fetch_array($nextsites)))
	{
		header("location: default.php?aff=".$user);
		exit;
	}
}
$newsite = $nextsites["website"];
$coopuname = $nextsites["sitedscn"];

mysql_query("UPDATE users SET lastshown=".$nextsites["num"].",showntimes=1,numvisits=numvisits+1 WHERE uname='".$user."'");
mysql_query("UPDATE websites SET numvisits=numvisits+1 WHERE uname='".$user."' AND num=".$nextsites["num"]." and website='$newsite'");

if ($user == "affcoop" or $user == "maincoop") {
mysql_query("UPDATE coop SET totalhits=totalhits+1 WHERE uname='".$coopuname."' AND website='$newsite'");
}
if ($user == "fctc") {
mysql_query("UPDATE fctccoop SET totalhits=totalhits+1 WHERE uname='".$coopuname."' AND website='$newsite'");
}
header("location: http://".$newsite);
exit;
?>