if (!empty($res['serf'])) 
{
    $sql_serf = $mysqli->query("SELECT `top`,`redirect`,`time`,`plan` FROM ".DB_PREFIX."_serf WHERE `active`='0' AND `id` IN (".$res['serf'].")");
    $serf_pay = 0;
    while($row = mysqli_fetch_assoc($sql_serf))
    {
        if ($row['time'] == 20)     $forpay_serf = $serf_price['t_20'] * $row['plan'];
        if ($row['time'] == 30)     $forpay_serf = $serf_price['t_30'] * $row['plan'];
        if ($row['top'] == 1)       $forpay_serf = $forpay_serf + $serf_ptop;
        if ($row['redirect'] == 1)  $forpay_serf = $forpay_serf + $serf_loc;
        $serf_pay = $serf_pay + $forpay_serf;
    }

$to_sale = ($serf_sale == 1) ? (($serf_pay / 100) * $discount) : 0;
$to_pay  = ($serf_sale == 1) ? ($serf_pay -(($serf_pay / 100) * $discount)) : $serf_pay;	
}
		

if (!empty($res['autoserf']))
{
    $sql_autoserf = $mysqli->query("SELECT `time`,`plan` FROM ".DB_PREFIX."_autoserf WHERE `active`='0' AND `id` IN (".$res['autoserf'].")");
    $autoserf_pay = 0;
    while($row = mysqli_fetch_assoc($sql_autoserf))
    {
        if ($row['time'] == 20)     $forpay_autoserf = $autoserf_price['t_20'] * $row['plan'];
        if ($row['time'] == 30)     $forpay_autoserf = $autoserf_price['t_30'] * $row['plan'];
        $autoserf_pay = $autoserf_pay + $forpay_autoserf;
     }
			
     $to_sale = $to_sale + ($autoserf_sale == 1) ? (($autoserf_pay / 100) * $discount) : 0;
     $to_pay = $to_pay + ($autoserf_sale == 1) ? ($autoserf_pay -(($autoserf_pay / 100) * $discount)) : $autoserf_pay;		
}

if (!empty($res['task']))
{
    $sql_task = $mysqli->query("SELECT `plan`,`price`,`top` FROM ".DB_PREFIX."_tasks WHERE `active`='0' AND `id` IN (".$res['task'].")");
    $task_pay = 0;
    while($row = mysqli_fetch_assoc($sql_task))
    {
        $forpay_task = ($row['top'] == 1) ? ((($row['price'] * (1 + $task_commision / 100)) * $row['plan']) + $task_ptop) : (($row['price'] * (1 + $task_commision / 100)) * $row['plan']);
        $task_pay = $task_pay + $forpay_task;
    }
			
    $to_sale = $to_sale + ($task_sale == 1) ? (($task_pay / 100) * $discount) : 0;
    $to_pay = $to_pay + ($task_sale == 1) ? ($task_pay -(($task_pay / 100) * $discount)) : $task_pay;
}


if (!empty($res['download']))
{
    $sql_downloads = $mysqli->query("SELECT `plan`,`price`,`top` FROM ".DB_PREFIX."_downloads WHERE `active`='0' AND `id` IN (".$res['download'].")");
    $download_pay = 0;
    while($row = mysqli_fetch_assoc($sql_downloads))
    {
        $forpay_download = ($row['top'] == 1) ? ((($row['price'] * (1 + $download_commision / 100)) * $row['plan']) + $download_ptop) : (($row['price'] * (1 + $download_commision / 100)) * $row['plan']);
	$download_pay = $download_pay + $forpay_download;
     }
			
     $to_sale = $to_sale + ($download_sale == 1) ? (($download_pay / 100) * $discount) : 0;
     $to_pay = $to_pay + ($download_sale == 1) ? ($download_pay -(($download_pay / 100) * $discount)) : $download_pay;
		    $service[] = 'download';
}


if (!empty($res['context']))
{
    $sql_context = $mysqli->query("SELECT `plan` FROM ".DB_PREFIX."_ads_context WHERE `active`='0' AND `id` IN (".$res['context'].")");
    $context_pay = 0;
    while($row = mysqli_fetch_assoc($sql_context))
    {
         $context_pay = $context_pay + ($context_price * $row['plan']);
    }

    $to_sale = $to_sale + ($context_sale == 1) ? (($context_pay / 100) * $discount) : 0;
    $to_pay = $to_pay + ($context_sale == 1) ? ($context_pay -(($context_pay / 100) * $discount)) : $context_pay;
}


if (!empty($res['banner']))
{
    $sql_banners = $mysqli->query("SELECT `type`,`plan` FROM ".DB_PREFIX."_banners WHERE `active`='0' AND `id` IN (".$res['banner'].")");
    $banner_pay = 0;
    while($row = mysqli_fetch_assoc($sql_banners))
    {
        $forpay_banner = $bann_price * $row['plan'];
	if ($row['type'] == 200)
        {
	    $forpay_banner = $forpay_banner * $bann_p_200;
	}
        else if ($row['type'] == 468)
        {
	    $forpay_banner = $forpay_banner * $bann_p_468;
        }
	$banner_pay = $banner_pay + $forpay_banner;
    }
			
    $to_sale = $to_sale + ($bann_sale == 1) ? (($banner_pay / 100) * $discount) : 0;
    $to_pay = $to_pay + ($bann_sale == 1) ? ($banner_pay -(($banner_pay / 100) * $discount)) : $banner_pay;
}

$sql_serf = $mysqli->query("SELECT `top`,`redirect`,`time`,`plan` FROM ".DB_PREFIX."_serf WHERE `active`='0' AND `id` IN (".$res['serf'].")");
    $serf_pay = 0;
    while($row = mysqli_fetch_assoc($sql_serf))