Adding Stats to Affiliate Pages

NATS 3 About NATS 3 NATS3 Requirements IPSP Integration NATS3 Changelog For Affiliates Affiliate Link Codes Affiliate Adtools Affiliate Rewards Affiliate Referral Stats Automatic Campaigns Affiliate Billing Info Deep Linking Affiliate Defaults Linkcode ASP Query String NATS3 Main Program Page TubeStudio Adtools Setup Apache Configuration MySQL Settings Creating Admin Accounts File Upload Setup Link Domain NATS3 Files and Directories NATS Go Live Checklist Moving NATS3 Admin Overview Troubleshoot Chart Director Fix Admin Overview Graphs Admin Reports Profit & Loss Report Strack Surfer Stats Chargeback and Credit Amount Inaccuracies Payments Admin Payment Dump Setting Up Pay Vias Hidden Payout Options Temporary Payout Payment Option Webmasterchecks Affiliate Payout Domestic Wire Instant Payments Intercash International Wire Moneybookers RevUpCard NATS Payments PayPal Payment Dump Entry Numbers Payment Dump Variables Payout Scales Epassporte Affiliates Admin Override ID Numbers Account Representatives Affiliate Starting Balance Affiliate Documents Affiliate Start Page Affiliate Referrals Manual Sale Manual Invoice Statistic Query Strings Creating Admin Accounts Affiliate-Specific Join Options Disabled and Banned Affiliates Verifying Account Changes Members Admin MySQL Auth Members Admin Member ID Numbers Expired Members Creating Trial Members Member Delete Member Logging Trial Member Sites Admin Sites Site Setup Configure Redirects ID Numbers Automail Site User Management Username Checking Join Form Errors Free Pre-Initial Checkbox Payouts Based on Program and Join Options Payouts Based on Join Option and Per Option Adding Extra Site Tours Site Partner Join Options Multisite Access Removing Join Options Tour Setup Site Undelete Join Option Box vs Button Redirecting Traffic to a Sponsor Qualified Join Page Hits Type-In Traffic Allowed languages Linkcode Decoding Programs Admin Programs Admin NATS Program Adding Programs ID Numbers Paid Trials Main Program Page Pay Per Click Pay Per Sale Revenue Share Program Default Payouts Referral Payout Tier Third Parties Admin Third Parties Chargeback and Credit Amount Inaccuracies AdultFriendFinder AdultFriendFinderAPI   AdultFriendFinder versus AdultFriendFinderAPI AllMightyContent CamSpot Cams DatingGold EffexMedia Gamelink Jettis International Third-Party Mallcom My Dirty Hobby SexGoesMobile (SGM) Streamate   Streamate Biller versus Third-Party VideoSecrets WebCamClub   WebCamClub with Biller WebCams XonDemand Adtools Admin Adding Adtools Linking to Join and Tour Pages Duplicate Site Adtools Banner Hot-Linking Adding RSS Feeds to NATS's Adtools Downloadable Adtool Bulk Importer Dump Hosted Galleries Hosted Adtool NATS Thumbnails TubeStudio Adtools Admin Billers Admin Biller Cascade NATS Cascades Adding Cascades Biller Cancel Promotions Cascade Weight Autocascade Hidden Cascades Geo-Targeting Cascades Type-In Cascade Post-Biller Templates Extra Biller Fields HTTPS Gateways Payment Deduction Timed Cascade Rules Multiple Biller Accounts Upgrade Plus Adding a Biller   Biller Instructions NATS3 Biller List 123Bill 365Billing 2000Charge Aconti Payment Service Allopass Ampay Argus Authorize.net Bill1st Gateway Billing Line BoaCompra Card Gate Plus CCBill CCBill Direct Pay CCBill Web900 Centrobill ChargeMeLater ClearCard ClearCard IDV Commerce Gate CurePay DHD Media E-Pay Company Edelweiss Card EGatePay ElectraCash EMerchantPay (Interconsult) EnterCharge Epoch EProcessingNetwork EuroBill EPGBill.com FABILLING Global Access GTBill GXBill HeidelPay HeidelPay Gateway iBill ICN Ltd. Infinity Payment Interconsult Jettis Jettis Gateway Jettis International Linkpoint LocalBilling Merchant Partners Gateway Merchant Partners Membership Merchant Solutions MyVirtualCard Netbilling Netbilling Native NetCash Netpay International NoCreditCard Oakbill Optimized Payment System Password by Phone Pay4 Paygea Payment Network Paysite Cash PhoneAccess Plug'n Pay PPPCard Probiller Protx Pure Vanilla RocketGate RocketGate Native RSBilling SafeCharge Secure Billing World SegPay Sonic Bill StandardBill Streamate Symmetrex TrustCash TrustCharge txtNation Ukash Universal Processing Verotel Pro VXSBill WebBilling WebPay WTS WTSeu YNOT Processing Zombaio Netbilling v3 Upgrade Instructions Purchasing Tokens Through Netbilling Streamate Biller versus Third-Party Switching From Epoch to Epoch EU Epoch Member Approval Plus Multiple Biller Accounts Popups Admin Popup Chain Price Cascade Rewards Admin Rewards Admin Reward Points Unshipping Rewards Cross-Sells Admin Cross Sells Admin Process Gateway Cross Sales Outside NATS Outgoing Gateway Cross Sales CCBill Cross-Selling Cross Sells: A to Z Mailing Admin NATS3 Mailing Admin Email Expired Members Repeating Email Member Cancel Emails Member Chargeback Emails Member Credit Emails Member Join Emails Member Rebill Emails Mailer Template Variables Skins & Templates Admin Smarty Plugins Skins Editing Skins Creating Skins Switching Skins Templates nats_code Affiliate Stats Template Affiliate Support Template Affiliate Login Template custom errors.php Template Array Variable Detailed Stats NATS Variables Dialer Statistics Affiliate Signup Post URL Variables Member Usernames & Passwords Output An Affiliate's Last Paid Date Custom Program and Campaign Selection Pages CAPTCHA Removal Username Recommendations Password Retrieval Post-Biller Templates Geo-Target Join Options Template Caching Random Usernames and Passwords Base Templates Protecting Template Data Mail Reseller Signup Template Variable Names Smarty Smarty print array News Section Templating Affiliate Signup Email Getting The NATSCode Checking for Usernames on All Sites Adding Stats to Affiliate Pages Affiliate Join Page Linkcodes   Template Functions nats_apache_note nats_convert_bytes nats_decode nats_encode nats_fhg nats_helper_row_fill nats_get_gateway_token nats_list_campaigns nats_list_programs nats_list_sites nats_my_decode_entities nats_my_encode_entities nats_smarty_function_ajax_box nats_smarty_function_amount_owed nats_smarty_function_gateway_xsell nats_smarty_function_getbonus nats_smarty_function_get_paid_date nats_smarty_rebuild_link nats_smarty_rebuild_query nats_smarty_function_reseller_ajax_box nats_tooltip nats_tour_report nats_wmref_list Template Shortcuts ajax_box amount_owed apache_note convert_bytes fhg gateway_xsell get_loginid_from_campaignid get_gateway_token get_paid_date list_campaigns list_programs list_sites new_gateway_xsell rebuild_link rebuild_query reseller_ajax_box reward_points tooltip tour_report wmref_list Common Parameters assign assign_prefix count data_only display_on_assign start tpl   Helper Functions nats_code nats_extract_program nats_extract_site nats_modify_program nats_modify_site Configuration Admin NATS3 Configuration Options Extra Country Options PayVia Minimum Log Admin Activity IP Address Filtering MEMBER EXPIRE PAD Second Sign-up Matching Affiliate Signup Email GeoIP Fake Upgrade Misc. Admins Database Cleanup Troubleshooting Common Errors Email_Issues Auto Login Emptying Forms AutoLogin Cookie CAPTCHA Changing Licenses Expired License Zend License NATS Extras Remote Affiliate Authentication Shopping Cart Sales Moving Tours, Members' Area, and Galleries Require W-9 Admin Areas Fraud Report NATS Content of the Day Module NATS Load Balancing Module Gallery Builder Module Build Your Own Anything Module NATS Code Wordpress Plugin Error_message_display TMMid

Quick_stats.php is a function in NATS3 that allows you to add affiliate stats to a page in your NATS system. This function is included with your system, however you must set up your own Smarty plugin in order to call the function. Quick_stats.php can display affiliate stats in e-mails sent to affiliates, as well as other NATS pages.

Setting up the script

In your ../nats/includes folder create a php file. For this example, we can refer to it as mystats.php. In this file, you can use the following code, or alter it to meet your needs:

<?
include_once('quick_stats.php');
$data = quick_stats('normal', $GLOBALS['loginid'], 1);
$top_data = top_stats('2', '2', '10');
$this->assign('top_data', $top_data);
$this->assign('data', $data);
?>

There are two functions in the quick_stats.php script, quick_stats and top_stats.

Quick_stats contains six parameters that designate which stats are displayed, as well as when you want these stats from. These parameters are:

• $type - Sets the type of stats you wish to display. This can be set to owed (payments that have been built but have not yet been paid), site (reseller stats broken down by site), and normal (reseller stats broken down by day).
• $loginid - Use an affiliate login ID to grab stats for that particular affiliate.
• $range_type - Sets what time period stats are displayed for (this period, this month, etc. This is explained in more detail below).
• $range_start - Sets the start date for your selected date range. This can be expressed in year-month-day (yyyy-mm-dd) form.
• $range_end - Sets the end date for your selected date range. This can be expressed in year-month-day (yyyy-mm-dd) form.
• $return_total - Displays affiliate statistic totals, such as total signups.

Top_stats contains seven parameters that must be set as well in order to display top affiliate stats. These parameters include:

• $type - Sets the type of stats you wish to display. This can be set to 1 (top sites by joins), 2 (top sites by ratio), 3 (top affiliates by ratio), 4 (worst affiliates by ratio), or default (top affiliates by amount earned).
• $range_type - Sets what time period stats are displayed for (this period, this month, etc. This is explained in more detail below).
• $num - Sets the number of results to return.
• $range_start - Sets the start date for your selected date range. This can be expressed in year-month-day (yyyy-mm-dd) form.
• $range_end - Sets the end date for your selected date range. This can be expressed in year-month-day (yyyy-mm-dd) form.
• $limit_sites - Allows you to set an array of site stats you want to display, or set a comma-separated list of site stats to display.
• $ratio - Sets how you want an affiliate's join ratio to be displayed. Must be set as unq, raw, or qual.

Note: The top_stats function should be run as a cron that only updates once an hour. We strongly recommend that you store the results in a flat file and display them from the file.

Your options for time period ($range_type parameter) are:

• 0 = today
• 1 = this period
• 2 = this month
• 3 = previous day
• 4 = previous period
• 5 = previous month
• 6 = freeform; to use this you will have to include a 4th and 5th parameter as start and end dates. These values can be dates or statements like "friday 3 weeks ago". For more information, please see our Freeform Date article.

Including mystats.php on a template

If you would like to include your example script (mystats.php) on a template, locate the template you would like your affiliate statistics to appear on in your "../nats/templates" directory. In the template you wish to edit, you can include mystats.php like the following example:

{include_php file="mystats.php"}

You can use the following variables to get your stats:

• {$data.raw|default:0} gives you raw hits
• {$data.unq|default:0} gives you unique hits
• {$data.qual|default:0} gives you qualified hits
• {$data.signups|default:0} gives you joins
• {$data.a_signups|default:0} gives you active joins
• {$data.earned|default:0} gives you the amount earned on the sale
• {$data.ratio} gives you a ratio of joins to raw hits

Example top_stats_cron:

<?
$do_db = 1; // we want to connect to the db
$do_login = 0; // we want to try to login if login info is provided
include_once('../includes/header.php');
include_once('../includes/quick_stats.php');

$top_data = top_stats(2, 1, 5);
$filename = 'top_data.txt';
$data = '';
foreach($top_data as $order => $info){
$data_info = Array();
foreach($info as $field => $value){
$data_info[] = "'$field'='$value'";
}
$data .= implode(', ', $data_info);
$data .= "n";
}
if (is_writable($filename)){
if (!$handle = fopen($filename, 'w')) {
exit;
}
if (fwrite($handle, $data) === FALSE) {
exit;
}
fclose($handle);
}
?>

Example Smarty plugin to read top_data.txt file:

<?
function smarty_function_get_top_stats($params, &$smarty){
$top_data = Array();
if(!$params['file']) return FALSE;
$filename = $params['file'];

if(!filesize($filename)) return FALSE;
$handle = fopen($filename, 'r');
$contents = fread($handle, filesize($filename));
fclose($handle);

$data = explode("\n", $contents);
foreach($data as $values){
$values = substr($values, 1);
$values = substr($values, 0, -1);
$vdata = explode("', '", $values);
$info = Array();
foreach($vdata as $vinfo){
list($field, $val) = explode("'='", $vinfo);
$info[$field] = $val;
}
$top_data[] = $info;
}
$smarty->assign('top_data', $top_data);
return;
}
?>

Call to plugin on the template:

{get_top_stats file="/pathtonats/tools/top_data.txt"}