function.php

<?php
function getbaseme()
{
	$q = mysql_query("SELECT * FROM tbl_core_config_data WHERE path='web/unsecure/base_url'");
	$row = mysql_fetch_array($q);
	return $row['value'];
}
	function countfield($field,$value)
	{
		$query = mysql_query("SELECT * FROM tbl_accounts WHERE $field='$value'");
		return mysql_num_rows($query);
	}
	function formquery($post)
	{
	$return = array();
	foreach($post as $key=>$val)
	{
		$return[] = "$key='$val'";
	}
	 return implode(",",$return);
	}

	function randid()
	{
		return rand().strtotime("now");
	}
	function totalaccount()
	{
		$query = "SELECT username,accounts_id as aid,(SELECT COUNT(id) FROM tbl_cycle WHERE account_link = aid AND cycle_count=1 AND cycle_link = 0) as totalacct,account_count FROM tbl_accounts as acct
		JOIN tbl_package as pck WHERE pck.package_id = acct.package_id
		HAVING totalacct < account_count LIMIt 1";
		return mysql_query($query);

	}

	function autocreateaccount()
	{
		while($row=mysql_fetch_assoc(totalaccount()))
		{
			$limit  = $row['account_count'] - $row['totalacct'];
			$aid = $row['aid'];
			for ($x = 1; $x <= $limit; $x++) {
				$username = $row['username']."-".randid();
				mysql_query("INSERT INTO tbl_cycle SET username='$username',account_link='$aid',cycle_count='1',cycle_link='0'");
			}			
			return;
		}
	}
	function autodetectparent()
	{
		$query ="SELECT username,account_link,cycle_count,id as alink,(SELECT COUNT(id) FROM tbl_relation WHERE parent = alink) as checkparent FROM tbl_cycle HAVING checkparent < 2    ORDER by id ASC LIMIT 1 ";
		return mysql_query($query);
	}
	function autodetectchild($parentid)
	{
	$query = "SELECT username,account_link,cycle_count,id as alink,(SELECT COUNT(id) FROM tbl_relation WHERE child = alink) as checkchild FROM tbl_cycle WHERE id!=$parentid AND id > $parentid HAVING checkchild = 0 ORDER by id ASC LIMIT 1";
		return mysql_query($query);
	}
	function loadcycle($id)
	{
		$q = mysql_query("SELECT * FROM tbl_cycle WHERE id='$id'");
		$row = mysql_fetch_assoc($q);
		return $row;
	}
	function getRate($id)
	{
		$q = mysql_query("SELECT cycle_earn FROM tbl_package WHERE package_id='$id'");
		$row = mysql_fetch_assoc($q);
		return $row['cycle_earn'];
	}	
	function getUserPackage($id)
	{
		$q = mysql_query("SELECT package_id FROM tbl_accounts WHERE accounts_id='$id'");
		$row = mysql_fetch_assoc($q);
		return $row['package_id'];		
	}
	function addmoney($uid,$rate)
	{
		mysql_query("UPDATE tbl_accounts SET balance = balance + $rate WHERE accounts_id=$uid");
	}
	function totalbalance($uid,$rate)
	{
		mysql_query("UPDATE tbl_accounts SET total_earnings = total_earnings + $rate WHERE accounts_id=$uid");
	}	
	function exitlabel($id)
	{
		mysql_query("UPDATE tbl_cycle SET cycle_status = 1 WHERE id=$id");
	}
	function cycleinc($id)
	{
		$user = loadcycle($id);
		$inc = $user['cycle_count'] + 1;
		exitlabel($id);
		
		$userpackage = getUserPackage($user['account_link']);
		$rate = getRate($userpackage);
		totalbalance($user['account_link'],$rate);	 	
		if($inc==4)
		{
			addmoney($account_link,($rate * 3));	
			$username = "adminbonus-".randid();
			$account_link = 1;
			$cycle_count = 1;
			$cycle_link = 0;
			mysql_query("INSERT INTO tbl_cycle SET username='$username',account_link='$account_link',cycle_count='$cycle_count',cycle_link='$cycle_link'");			
		}
		else
		{
			$username = $user['username']."-".$inc;
			$account_link = $user['account_link'];
			$cycle_count = $inc;
			if($user['cycle_link']==0)
			{
				$cycle_link =$id;
			}
			else{
				$cycle_link = $user['cycle_link'];
			}
			
			
			$q = mysql_fetch_assoc(mysql_query("SELECT COUNT(id) as chet FROM tbl_cycle WHERE username='$username' AND account_link='$account_link' AND cycle_count='$cycle_count' AND cycle_link='$cycle_link'"));
			if($q['chet']==0):
			mysql_query("INSERT INTO tbl_cycle SET username='$username',account_link='$account_link',cycle_count='$cycle_count',cycle_link='$cycle_link'");
			endif;
		}
	}
	function cycleevent($row)
	{
		$rowx = mysql_fetch_assoc(autodetectchild($row['alink']));
		$parent = $row['alink'];
		$child = $rowx['alink'];
		if($child!='')
		{
			mysql_query("INSERT INTO tbl_relation SET parent='$parent',child='$child'");
			$q = mysql_fetch_assoc(mysql_query("SELECT COUNT(parent) as chet FROM tbl_relation WHERE parent='$parent'"));
			if($q['chet']==2)
			{
				cycleinc($parent);
			}
		}
		
	}
function mytimestamp()
{
	return date('Y-m-d H:i:s');
} 

function getrow($var)
{
	$array['title'] = 'Monoline';
	$array['image'] = 'https://placeholdit.imgix.net/~text?txtsize=19&txt=150%C3%97150&w=200&h=75';
	return $array;
}	


function countquery($query)
{
	$q = mysql_query($query);
	return mysql_num_rows($q);
}

function getpackagelist()
{
   $packrowq = mysql_query("SELECT * FROM tbl_package");
   while($packrow = mysql_fetch_assoc($packrowq))
   {
    $options[$packrow['package_id']] = $packrow['package_name'];
   }
   return $options;	
}

function getwheresearch($field)
{
  if($_GET['search']!='')
  {
    $search = $_GET['search'];
   
    $where = "WHERE";

    foreach($field as $f)
    {
        $where .= " $f LIKE '%$search%' OR";
    }
        $where .= " 1=1";
        $where = str_replace("OR 1=1","",$where);
  }
  return $where;	
}

function getlimit($limit,$page)
{
	if($page=='')
	{
		$page = 0;
	}
	else
	{
		$page--;
	}
	$limitx = $limit * $page;

	return "LIMIT $limitx,$limit";
}
function getpagecount($total,$limit)
{
	return (ceil($total/$limit));
}


function csv()
{
		header('Content-Type: text/csv; charset=utf-8');

		header('Content-Disposition: attachment; filename=payout-'.$_GET['r']."-".rand().'.csv');

		// create a file pointer connected to the output stream

		$output = fopen('php://output', 'w');

		if($_GET['r']=='bank')

		{

		$rows = mysql_query("SELECT b.accounts_id,b.username,transnum,email,amount,bank_name,bank_accountnumber,bank_accountname FROM  tbl_withdraw_history as a JOIN tbl_accounts as b WHERE claim_status=0 AND a.accounts_id=b.accounts_id AND claimtype='".$_GET['r']."'

		");

		$array = explode(",","accounts_id,username,transnum,email,amount,bank_name,bank_accountnumber,bank_accountname");	

		}


		if($_GET['r']=='pickup')

		{

		$rows = mysql_query("SELECT b.accounts_id,b.username,transnum,email,amount FROM  tbl_withdraw_history as a JOIN tbl_accounts as b WHERE claim_status=0 AND a.accounts_id=b.accounts_id AND claimtype='".$_GET['r']."'");

		$array = explode(",","accounts_id,username,transnum,email,amount");	

		}


		fputcsv($output,$array);

		// loop over the rows, outputting them

		while ($row = mysql_fetch_assoc($rows)) 

		{

		foreach($row as $key=>$val)

		{

		$row[$key] = "\"".$val."\"";

		}

		fputcsv($output, $row);

		}	
}


?>