<?
/*
Decoded by SplitIce ioncube decoder
========================================
Version: 0.8.1
Site: http://thewarezscene.org/decoder/
Free for non commercial code recovery.
========================================
=<[2009]>=
*/
define
('affiliatelinkscode',$affiliatelinkscode,'inactive','true',$templatefile);
include('dbconnect.php');
include('includes/functions.php');
include('includes/clientareafunctions.php');
include('includes/ticketfunctions.php');
$pagetitle = $_LANG['affiliatestitle'];
$breadcrumbnav = '<a href="index.php">'.$_LANG['globalsystemname'].'</a> > <a href="affiliates.php">'.$_LANG['affiliatestitle'].'</a>';
$pageicon = 'images/affiliate_big.gif';
initialiseclientarea();
if($_SESSION
['uid']) {
if($_GET
['activate'] == 'true') {
insert_query();
logactivity();
header
();
die();
}
$result = select_query('CLIENTAREA',true',$pagetitle,$pageicon,$breadcrumbnav,'tblaffiliates',array('date
'=>'now()','clientid'=>$_SESSION
['uid'],'visitors'=>'0','balance'=>$CONFIG['AffiliateBonusDeposit']),'Activated Affiliate Account (User ID: '.$_SESSION
['uid'].')','Location: affiliates.php','tblaffiliates','',array('clientid'=>$_SESSION
['uid']));
$data = mysql_fetch_array
($result);
$id = $data['id'];
$affiliateid = $id;
if($id == '') {
$templatefile = 'affiliatessignup';
/* Unknown opcode: 93 (ZEND_FETCH_DIM_FUNC_ARG) */
();
();
();
/* END LOOP */
}
$templatefile = 'affiliates';
/* Unknown opcode: 93 (ZEND_FETCH_DIM_FUNC_ARG) */
$currency = getcurrency('affiliatesystemenabled',$CONFIG,'bonusdeposit',$CONFIG['CurrencySymbol'].$CONFIG['AffiliateBonusDeposit'],'payoutpercentage',$CONFIG['AffiliateEarningPercent'].'%',$_SESSION
);
$date
= $data['date
'];
$date
= frommysqldate($date
);
$visitors = $data['visitors'];
$balance = $data['balance'];
$withdrawn = $data['withdrawn'];
$result = select_query('tblaffiliatesaccounts','COUNT(id)',array('affiliateid'=>$id));
$data = mysql_fetch_array
($result);
$signups = $data[0];
$result = select_query('tblaffiliatespending','SUM(tblaffiliatespending.amount)',array('affiliateid'=>$id),'clearingdate','DESC','','tblaffiliatesaccounts ON tblaffiliatesaccounts.id=tblaffiliatespending.affaccid INNER JOIN tblhosting ON tblhosting.id=tblaffiliatesaccounts.relid INNER JOIN tblproducts ON tblproducts.id=tblhosting.packageid INNER JOIN tblclients ON tblclients.id=tblhosting.userid');
$data = mysql_fetch_array
($result);
$pendingcommissions = $data[0];
$conversionrate = round
($signups / $visitors,2);
();
();
();
();
();
();
/* Unknown opcode: 106 (ZEND_SEND_VAR_NO_REF) */
();
/* Unknown opcode: 106 (ZEND_SEND_VAR_NO_REF) */
();
/* Unknown opcode: 106 (ZEND_SEND_VAR_NO_REF) */
();
if($CONFIG['AffiliatePayout'] < $balance) {
();
if($action == 'withdrawrequest') {
$result = select_query('affiliateid',$id,'referrallink',$CONFIG['SystemURL'].'****************'.$id,'date
',$date
,'visitors',$visitors,'signups',$signups,'conversionrate',$conversionrate,'pendingcommissions',$pendingcommissions,'balance',$balance,'withdrawn',$withdrawn,'withdrawlevel','true','tblticketdepartments','',array('hidden'=>''),'order','ASC');
$data = mysql_fetch_array
($result);
$deptid = $data['id'];
$message = 'Affiliate Account Withdrawal Request. Details below:
Client ID: '.$_SESSION
['uid']."
Affiliate ID: {$id}
Balance: {$balance}";
/* Unknown opcode: 93 (ZEND_FETCH_DIM_FUNC_ARG) */
$ticketdetails = opennewticket($_SESSION
,$deptid,'Affiliate Withdrawal Request',$message,'Medium');
();
}
$content .= '
<p><b>'.$_LANG['affiliatesreferals'].'</b></p>
<table align="center" id="affiliates" cellspacing="1">
<tr><td id="affiliatesheading">'.$_LANG['affiliatessignupdate'].'</td><td id="affiliatesheading">'.$_LANG['affiliateshostingpackage'].'</td><td id="affiliatesheading">'.$_LANG['affiliatesamount'].'</td><td id="affiliatesheading">'.$_LANG['affiliatescommision'].'</td><td id="affiliatesheading">'.$_LANG['affiliatesstatus'].'</td></tr>
';
$referrals = array();
$result = select_query('withdrawrequestsent','true','tblaffiliatesaccounts','',array('affiliateid'=>$affiliateid));
if($data = mysql_fetch_array
($result)) {
$affaccid = $data['id'];
$lastpaid = $data['lastpaid'];
$relid = $data['relid'];
$result2 = select_query('tblhosting','tblproducts.name,tblhosting.userid,tblhosting.domainstatus,tblhosting.amount,tblhosting.firstpaymentamount,tblhosting.regdate,tblhosting.billingcycle',array('tblhosting.id'=>$relid),'','','','tblproducts ON tblproducts.id=tblhosting.packageid INNER JOIN tblclients ON tblclients.id=tblhosting.userid');
$data = mysql_fetch_array
($result2);
$userid = $data['userid'];
$amount = $data['amount'];
$date
= $data['regdate'];
$service = $data['name'];
$billingcycle = $data['billingcycle'];
$status = $data['domainstatus'];
if($billingcycle == 'One Time') {
$amount = $data['firstpaymentamount'];
}
$commission = calculateaffiliatecommission($affiliateid,$relid);
$currency = getcurrency($userid);
$amount = formatcurrency($amount);
$commission = formatcurrency($commission);
$date
= frommysqldate($date
);
if(!) {
$domain = '';
}
if($lastpaid == '0000-00-00') {
$lastpaid = 'Never';
/* END LOOP */
}
$lastpaid = frommysqldate($lastpaid);
if($status == 'Active') {
$status = $_LANG['clientareaactive'];
/* END LOOP */
}
if($status == 'Pending') {
$status = $_LANG['clientareapending'];
/* END LOOP */
}
if($status == 'Suspended') {
$status = $_LANG['clientareasuspended'];
/* END LOOP */
}
if($status == 'Terminated') {
$status = $_LANG['clientareaterminated'];
/* END LOOP */
}
if($status == 'Cancelled') {
$status = $_LANG['clientareacancelled'];
/* END LOOP */
}
if($status == 'Fraud') {
$status = $_LANG['clientareafraud'];
}
$billingcycle = strtolower
($billingcycle);
$billingcycle = str_replace
(' ','',$billingcycle);
$billingcycle = str_replace
('-','',$billingcycle);
$billingcycle = $_LANG['orderpaymentterm'.$billingcycle];
$referrals[] = array('date
'=>$date
,'service'=>$service,'package'=>$service,'amount'=>$amount,'billingcycle'=>$billingcycle,'commission'=>$commission,'lastpaid'=>$lastpaid,'status'=>$status);
/* END LOOP */
}
();
$commissionhistory = array();
$result = select_query('referrals',$referrals,'tblaffiliateshistory','',array('affiliateid'=>$affiliateid),'id','DESC','0,10');
if($data = mysql_fetch_array
($result)) {
$historyid = $data['id'];
$date
= $data['date
'];
$affaccid = $data['affaccid'];
$amount = $data['amount'];
$date
= frommysqldate($date
);
$commissionhistory[] = array('date
'=>$date
,'referralid'=>$affaccid,'amount'=>$CONFIG['CurrencySymbol'].$amount);
/* END LOOP */
}
();
$withdrawalshistory = array();
$result = select_query('commissionhistory',$commissionhistory,'tblaffiliateswithdrawals','',array('affiliateid'=>$id),'id','DESC');
if($data = mysql_fetch_array
($result)) {
$historyid = $data['id'];
$date
= $data['date
'];
$amount = $data['amount'];
$date
= frommysqldate($date
);
$withdrawalshistory[] = array('date
'=>$date
,'amount'=>$CONFIG['CurrencySymbol'].$amount);
/* END LOOP */
}
();
$affiliatelinkscode = $CONFIG['AffiliateLinks'];
$affiliatelinkscode = str_replace
('withdrawalshistory',$withdrawalshistory,'[AffiliateLinkCode]',$CONFIG['SystemURL'].'****************'.$id,$affiliatelinkscode);
$affiliatelinkscode = str_replace
('<(','<',$affiliatelinkscode);
$affiliatelinkscode = str_replace
(')>','>',$affiliatelinkscode);
();
/* END LOOP */
}
$goto = 'affiliates';
include('login.php');
if($CONFIG['AffiliateEnabled'] != 'on') {
();
}
outputclientarea();
return 1;
?>