<?php
include('php-includes/check-login.php');
require('php-includes/connect.php');
$userid = $_SESSION['userid'];
$user_id = $userid;

	$sel="select * from tree1 where userid='$userid' ";
			$res=mysqli_query($con,$sel);
			$row=mysqli_fetch_array($res,MYSQLI_BOTH);
			$userleft=$row["left"];
			$userright=$row["right"];
			$usermiddle=$row["middle"];
			//echo $usermiddle;
			$allleftusers=array($userleft);
			$allmiddleusers=array($usermiddle);
			$allrightusers=array($userright);
			
			function printleft($user_id)
			{
				global $allleftusers;
				global $con;
				
				$sel1="select * from tree1 where userid='$user_id' ";
				$res1=mysqli_query($con,$sel1);
				$row1=mysqli_fetch_array($res1,MYSQLI_BOTH);
				
				$userleft1=$row1["left"];
				$userright1=$row1["right"];
				$usermiddle1=$row1["middle"];
				//echo $usermiddle1;
				
				if($userleft1!="")
				{
					array_push($allleftusers,$userleft1);
				}
				if($usermiddle1!="")
				{
					array_push($allleftusers,$usermiddle1);
				}
				if($userright1!="")
				{
					array_push($allleftusers,$userright1);
				}
				
				if(checkuser($userleft1))
				{
					printleft($userleft1);
				}	
				if(checkuser($usermiddle1))
				{
					printleft($usermiddle1);
				}				
				if(checkuser($userright1))
				{
					printleft($userright1);
				}
				
			}
			//////////////////////////////middle////////////////////////
			function printmiddle($user_id)
			{
				global $allmiddleusers;
				global $con;
				
				$sel1="select * from tree1 where userid='$user_id' ";
				$res1=mysqli_query($con,$sel1);
				$row1=mysqli_fetch_array($res1,MYSQLI_BOTH);
				
				$userleft1=$row1["left"];
				$userright1=$row1["right"];
				$usermiddle1=$row1["middle"];
			///////////////////////////////////////////////////////	
				if($userleft1!="")
				{
					array_push($allmiddleusers,$userleft1);
				}
				if($usermiddle1!="")
				{
					array_push($allmiddleusers,$usermiddle1);
				}
				if($userright1!="")
				{
					array_push($allmiddleusers,$userright1);
				}
				//////////////////////////////////////////////////
				if(checkuser($userleft1))
				{
					printmiddle($userleft1);
				}				
				if(checkuser($userright1))
				{
					printmiddle($userright1);
				}
				if(checkuser($usermiddle1))
				{
					printmiddle($usermiddle1);
				}
				
			}
			
			function printright($user_id)
			{
				global $allrightusers;
				global $con;
				$sel1="select * from tree1 where userid='$user_id' ";
				$res1=mysqli_query($con,$sel1);
				$row1=mysqli_fetch_array($res1,MYSQLI_BOTH);
				
				$userleft1=$row1["left"];
				
				$usermiddle1=$row1["middle"];
				$userright1=$row1["right"];
				if($userleft1!="")
				{
					array_push($allrightusers,$userleft1);
				}
				if($usermiddle1!="")
				{
					array_push($allrightusers,$usermiddle1);
				}
				if($userright1!="")
				{
					array_push($allrightusers,$userright1);
				}
				
				if(checkuser($userleft1))
				{
					printright($userleft1);
				}
				
				if(checkuser($userright1))
				{
					printright($userright1);
				}
				if(checkuser($usermiddle1))
				{
					printright($usermiddle1);
				}
				
			}
			function checkleft($user_id)
			{
				global $con;
				$sel1="select * from tree1 where userid='$user_id' ";
				$res1=mysqli_query($con,$sel1);
				$row1=mysqli_fetch_array($res1,MYSQLI_BOTH);
				if($row1["left"]=="" || $row1["left"]==NULL || $row1["left"]=="NULL")
				{
					return false;
				}
				else
				{
					return true;
				}
			}
			function checkright($user_id)
			{
				global $con;
				$sel1="select * from tree1 where userid='$user_id' ";
				$res1=mysqli_query($con,$sel1);
				$row1=mysqli_fetch_array($res1,MYSQLI_BOTH);
				if($row1["right"]=="" || $row1["right"]==NULL || $row1["right"]=="NULL")
				{
					return false;
				}
				else
				{
					return true;
				}
			}
			function checkmiddle($user_id)
			{
				global $con;
				$sel1="select * from tree1 where userid='$user_id' ";
				$res1=mysqli_query($con,$sel1);
				$row1=mysqli_fetch_array($res1,MYSQLI_BOTH);
				if($row1["middle"]=="" || $row1["middle"]==NULL || $row1["middle"]=="NULL")
				{
					return false;
				}
				else
				{
					return true;
				}
			}
			
			function checkuser($user_id)
			{
				global $con;
				$sel1="select * from tree1 where userid='$user_id' ";
				$res1=mysqli_query($con,$sel1);
				$row1=mysqli_fetch_array($res1,MYSQLI_BOTH);
				if($row1["right"]=="" && $row1["left"]=="" && $row1["middle"]=="")
				{
					return false;
				}
				else
				{
					return true;
				}
			}
			
			
			printleft($userleft);
			printright($userright);
			printmiddle($usermiddle);
			
			$countleft=count($allleftusers);
				$countmiddle=count($allmiddleusers);
			$countright=count($allrightusers);
		
		//	print_r($allleftusers);
		//	print_r($allmiddleusers);
		//	print_r($allrightusers);
		$k1=0;
		foreach($allrightusers as $a1)
{
	
	////////////////////////for green count
	$sel1253g11="select * from  user where  email='$a1' and amount!='0' ";
	$res12l53g11=mysqli_query($con,$sel1253g11);
	$row12l53g11=mysqli_fetch_array($res12l53g11,MYSQLI_BOTH);
	if($row12l53g11)
	{
		$k1=$k1+1;
	}
	////////////////////////for green count
}
$k2=0;
		foreach($allmiddleusers as $a2)
{
	
	////////////////////////for green count
	$sel1253g115="select * from  user where  email='$a2' and amount!='0' ";
	$res12l53g115=mysqli_query($con,$sel1253g115);
	$row12l53g115=mysqli_fetch_array($res12l53g115,MYSQLI_BOTH);
	if($row12l53g115)
	{
		$k2=$k2+1;
	}
	////////////////////////for green count
}

$k3=0;
		foreach($allleftusers as $a3)
{
	
	////////////////////////for green count
	$sel1253g1151="select * from  user where  email='$a3' and amount!='0' ";
	$res12l53g1151=mysqli_query($con,$sel1253g1151);
	$row12l53g1151=mysqli_fetch_array($res12l53g1151,MYSQLI_BOTH);
	if($row12l53g1151)
	{
		$k3=$k3+1;
	}
	////////////////////////for green count
}

$non=$k1+$k2;
						if($non>=3)
						{
							 $le1=300;
						}
						else
						{
							$le1=0;
						}
							if($non>=12)
						{
							 $le2=400;
						}
						else
						{
							$le2=0;
						}
							if($non>=39)
						{
							 $le3=800;
						}
						else
						{
							$le3=0;
						}
							if($non>=120)
						{
							 $le4=1200;
						}
						else
						{
							$le4=0;
						}
							if($non>=363)
						{
							 $le5=2400;
						}
						else
						{
							$le5=0;
						}
							if($non>=1092)
						{
							 $le6=3900;
						}
						else
						{
							$le6=0;
						}
							if($non>=3279)
						{
							 $le7=11000;
						}
						else
						{
							$le7=0;
						}
							if($non>=9840)
						{
							 $le8=32000;
						}
						else
						{
							$le8=0;
						}
							if($non>=29523)
						{
							 $le9=98000;
						}
						else
						{
							$le9=0;
						}
							if($non>=88572)
						{
							 $le10=290000;
						}
						else
						{
							$le10=0;
						}
							if($non>=265719)
						{
							 $le11=900000;
						}
						else
						{
							$le11=0;
						}
							if($non>=797160)
						{
							 $le12=2000000;
						}
						else
						{
							$le12=0;
						}
							if($non>=2391483)
						{
							 $le13=3660000;
						}
						else
						{
							$le13=0;
						}
							if($non>=7174452)
						{
							 $le14=9000000;
						}
						else
						{
							$le14=0;
						}
							if($non>=21523359)
						{
							 $le15=34000000;
						}
						else
						{
							$le15=0;
						}
							 $growth=$le1+$le2+$le3+$le4+$le5+$le6+$le7+$le8+$le9+$le10+$le11+$le12+$le13+$le14+$le15;
						
						$up41="update user set growth_income='$growth' where email='$userid' ";
					if(	mysqli_query($con,$up41))
					{
					    echo "<script>alert('Update Successfully');window.location.href='home.php'</script>";
					}
						
						

?>