<?php
include('php-includes/connect.php');
include('php-includes/check-login.php');

$sel="select * from  tree ";
	$res=mysqli_query($conn,$sel);
	$s=1;
	while($row=mysqli_fetch_array($res,MYSQLI_BOTH))
		
	{
		$user=$row['userid'];
		
		$sel1="select * from  tree where userid='$user'";
	$res1=mysqli_query($conn,$sel1);
	$row1=mysqli_fetch_array($res1,MYSQLI_BOTH);
	if($row1)
		{
			//echo $user;
			//echo '<br/>';
			$left=$row1['left'];
		$middle=$row1['middle'];
		$right=$row1['right'];
		
		//////////////////for checking//////
		$sel11="select * from  user where email='$left' and amount>0";
	$res11=mysqli_query($conn,$sel11);
	$row11=mysqli_fetch_array($res11,MYSQLI_BOTH);
	
	$sel111="select * from  user where email='$middle' and amount>0";
	$res111=mysqli_query($conn,$sel111);
	$row111=mysqli_fetch_array($res111,MYSQLI_BOTH);
	
	$sel1111="select * from  user where email='$right' and amount>0";
	$res1111=mysqli_query($conn,$sel1111);
	$row1111=mysqli_fetch_array($res1111,MYSQLI_BOTH);
	if($row11 or $row111 or $row1111)
	{
		echo $user;
			echo '<br/>';
		
	
		//Insert into Tree
		
		
		$sel4113="select * from  tree1 where `left`='' order by id asc";
		$res4113=mysqli_query($conn,$sel4113);
		$row4113=mysqli_fetch_array($res4113,MYSQLI_BOTH);
		
		if($row4113 )
		{
			$user1=$row4113['userid'];
			$side='left';
		}
		
		$sel41136="select * from  tree1 where `left`!='' and `middle`=''  order by id asc";
		$res41136=mysqli_query($conn,$sel41136);
		$row41136=mysqli_fetch_array($res41136,MYSQLI_BOTH);
		
		
		if($row41136 )
			
		{
			$user1=$row41136['userid'];
			$side='middle';
			
		}
		
		
		$sel411361="select * from  tree1 where `left`!='' and `middle`!='' and `right`=''  order by id asc";
		$res411361=mysqli_query($conn,$sel411361);
		$row411361=mysqli_fetch_array($res411361,MYSQLI_BOTH);
		
		
		if($row411361 )
		{
			$user1=$row411361['userid'];
			$side='right';
		
		}
		
		
		
	$up4="update tree1 set `$side`='$user' where userid='$user1' order by id asc";
										$q4=mysqli_query($conn,$up4);
										if($q4)
										{
		$query = mysqli_query($conn,"insert into tree1(userid,`left`,`middle`,`right`) values('$user','','','')");
										}		
			
		
	}
		}
		
	}
?>