<?php



session_start();



include "../config.php";

include "../header.php";

include "../style.php";



if( session_is_registered("ulogin") )

   	{  // members only stuff!

		include("navigation.php");

        include("../banners.php");



        echo "<font size=2 face='$fonttype' color='$fontcolour'><p><center>";

		echo "<center><font size=6>Referral Builder</font></center><br><div align=\"left\">";



		$query1 = "SELECT * FROM pages WHERE name='Referral Builder'";

	    $result1 = mysql_query ($query1);



	    $line1 = mysql_fetch_array($result1);

	         $htmlcode = $line1["htmlcode"];

		$firstnameq = substr(trim($userrecord['name']) , 0, strpos(trim($userrecord['name']), " "));
		$htmlcode = str_replace("~fname~",$firstnameq,$htmlcode);

	    echo $htmlcode;





if($_POST['update']) {



	$sid = intval($_POST['sid']);

	$info = htmlentities($_POST['info']);

	

	$sql = mysql_query("SELECT * FROM builder WHERE userid = '".$userid."'");

	if(!@mysql_num_rows($sql)) {

		mysql_query("INSERT INTO builder (userid, site".$sid.") VALUES ('".$userid."', '".$info."')");

	} else {

		mysql_query("UPDATE builder SET site".$sid." = '".$info."' WHERE userid = '".$userid."'");

	}

}



//Get the user links

$ub = array();

$sql = mysql_query("SELECT * FROM builder WHERE userid = '".$userid."'");

if(@mysql_num_rows($sql)) $ub = mysql_fetch_array($sql);






$lastcat = "";

//Get the links for each site

$slist = mysql_query("SELECT s.*,c.name as catname FROM builder_sites s JOIN builder_cat c ON s.category=c.id ORDER BY c.order, s.category, s.order ASC");

while($each = mysql_fetch_array($slist)) {



	$user = $userid;

	$found = 0;



	while($found == 0) {



		//Referrer exists?

		$sql = mysql_query("SELECT m.referid FROM members m JOIN members r ON m.referid = r.userid WHERE m.userid = '".$user."'");



		if(@mysql_num_rows($sql)) {

		

			$referrer = mysql_result($sql, 0);

			

			$sql = mysql_query("SELECT site".$each['id']." FROM builder WHERE userid = '".$referrer."'");

			if(@mysql_num_rows($sql)) {

			

				// Found a row, check if it's empty

				$value = mysql_result($sql, 0);

				if($value) {

					//found a link, end the loop

					$links = $value;

					$found = 1;

				} else {

					//No link, next.

					$user = $referrer;

				}

				

			} else {

				//No row, next.

				$user = $referrer;

			}



		} else {

			//No more referrers, use default values

			$links = $each['url'];

			$found = 1;

		}



	}

	

	if($lastcat != $each['category']) echo "<br><center><h2>".$each['catname']."</h2></center><hr>";

	$lastcat = $each['category'];	

	

	?>

	

	

	  <h3><a href="<? echo $links; ?>" target=_new"><? echo $each['name']; ?></a></h3>

	  

	  <p><? echo $each['desc']; ?></p> 

	  <div style="text-align: right;">

	  <form method="post"><input type="hidden" name="sid" value="<? echo $each['id']; ?>">My referral link: <input type="text" name="info" value="<? echo $ub["site".$each['id']]; ?>"><input type="submit" name="update" value="Update"></form>

	  </div>

	  

	  <hr>

	

	

	

	<?

	

	

	



}

		echo "<br><br></div>";

        echo "</font></td></tr></table>";

	}



else

  { ?>



  <font size=2 face="<? echo $fonttype; ?>" color="<? echo $fontcolour; ?>"><p><b><center>You must be logged in to access this site. Please <a href="<? echo $domain; ?>/memberlogin.php">click here</a> to login.</p></b></font><center>



  <? }



include "../footer.php";

mysql_close($dblink);

?>