function generate_download_link($retrieved_product, $item_name, $payment_data = '')
{
$time = time();
global $wpdb;
global $products_table_name;
if (isset($retrieved_product)) {
$product_id = $retrieved_product->id;
} else {
$product_id = "";
}
$script_location = get_option('eStore_download_script');
$random_key = get_option('eStore_random_code');
$eStore_auto_shorten_url = WP_ESTORE_AUTO_SHORTEN_DOWNLOAD_LINKS;
//Check if nextgen gallery integration is being used
$pid_check_value = eStore_is_ngg_pid_present($item_name);
if ($pid_check_value != -1) {
$pictureID = $pid_check_value;
$download_link = eStore_get_ngg_image_url($pictureID, $item_name);
//Generate link from Nextgen gallery
return $download_link;
}
//check if it is a digital variation
$is_digital_variation = false;
if (!empty($retrieved_product->variation3) && eStore_check_if_string_contains_url($retrieved_product->variation3)) {
$is_digital_variation = true;
}
if (empty($retrieved_product->product_download_url) && !$is_digital_variation) {
$download_link = "\n" . $item_name . WP_ESTORE_THIS_ITEM_DOES_NOT_HAVE_DOWNLOAD;
} else {
if (empty($payment_data['txn_id'])) {
$payment_data['txn_id'] = "";
}
if (!empty($retrieved_product->variation3)) {
$download_link = get_download_for_variation($item_name, $retrieved_product, $script_location, $random_key, $payment_data);
} else {
$download_url_field = $retrieved_product->product_download_url;
$product_ids = explode(',', $download_url_field);
$package_product = eStore_is_package_product($retrieved_product);
$multi_parts = false;
if (sizeof($product_ids) > 1 && !$package_product) {
$multi_parts = true;
}
if ($package_product) {
eStore_payment_debug('Generating download link for package product.', true);
//$count = 0;
foreach ($product_ids as $id) {
$id = trim($id);
$retrieved_product_for_specific_id = $wpdb->get_row("SELECT * FROM {$products_table_name} WHERE id = '{$id}'", OBJECT);
//recursively generate the links
$download_link .= generate_download_link($retrieved_product_for_specific_id, $retrieved_product_for_specific_id->name, $payment_data);
}
} else {
if ($multi_parts) {
eStore_payment_debug('Generating download link for multi part file.', true);
$count = 1;
$download_link .= "\n" . stripslashes($item_name) . " - ";
foreach ($product_ids as $id) {
$id = trim($id);
if (!empty($id)) {
//$download = $product_id.'|'.$time.'|'.$id;
//$download_key = eStore_generate_download_key($product_id,$id);
$download_key = eStore_check_stamping_flag_and_generate_download_key($retrieved_product, $product_id, $id, $payment_data);
$encrypted_download_url = eStore_construct_raw_encrypted_dl_url($download_key);
$download_item = "\n" . ESTORE_PART . " " . $count . " : " . $encrypted_download_url;
$download_link .= $download_item;
eStore_register_link_in_db('', $download_key, $download_item, '', '', '', 0, $payment_data['txn_id']);
$count++;
}
}
} else {
eStore_payment_debug('Generating download link for single file.', true);
//$download = $product_id.'|'.$time;
//$download_key = eStore_generate_download_key($product_id);
$download_key = eStore_check_stamping_flag_and_generate_download_key($retrieved_product, $product_id, '', $payment_data);
$encrypted_download_url = eStore_construct_raw_encrypted_dl_url($download_key);
$download_link = "\n" . stripslashes($item_name) . " - " . $encrypted_download_url;
eStore_register_link_in_db('', $download_key, $download_link, '', '', '', 0, $payment_data['txn_id']);
}
}
}
}
return $download_link;
}
function eStore_generate_download_links_for_cart_items($payment_data, $cart_items)
{
eStore_payment_debug('Executing eStore_generate_download_links_for_cart_items()', true);
global $wpdb;
$wp_eStore_config = WP_eStore_Config::getInstance();
$products_table_name = WP_ESTORE_PRODUCTS_TABLE_NAME;
$product_name_array = array();
$download_link_array = array();
foreach ($cart_items as $current_cart_item) {
$cart_item_data_num = $current_cart_item['item_number'];
$cart_item_data_name = $current_cart_item['item_name'];
$cart_item_data_quantity = $current_cart_item['quantity'];
$cart_item_data_total = $current_cart_item['mc_gross'];
$cart_item_data_currency = $current_cart_item['mc_currency'];
eStore_payment_debug('Item Number: ' . $cart_item_data_num, true);
eStore_payment_debug('Item Name: ' . $cart_item_data_name, true);
eStore_payment_debug('Item Quantity: ' . $cart_item_data_quantity, true);
eStore_payment_debug('Item Total: ' . $cart_item_data_total, true);
eStore_payment_debug('Item Currency: ' . $cart_item_data_currency, true);
if ($cart_item_data_num != "SHIPPING") {
// Compare the values with the values stored in the database
$key = $cart_item_data_num;
$retrieved_product = $wpdb->get_row("SELECT * FROM {$products_table_name} WHERE id = '{$key}'", OBJECT);
if (!$retrieved_product) {
eStore_payment_debug('No Item found for the Item ID: ' . $cart_item_data_num, false);
return false;
}
$item_name = $cart_item_data_name;
$download_link = generate_download_link($retrieved_product, $item_name, $payment_data);
eStore_payment_debug('Download Link : ' . $download_link, true);
array_push($product_name_array, $cart_item_data_name);
array_push($download_link_array, $download_link);
}
}
for ($i = 0; $i < sizeof($product_name_array); $i++) {
//Download links list for all items in the cart
$constructed_download_link .= "\n";
if (is_array($download_link_array[$i])) {
$package_downloads = $download_link_array[$i];
for ($j = 0; $j < sizeof($package_downloads); $j++) {
$constructed_download_link .= $package_downloads[$j];
$constructed_download_link .= "\n";
}
} else {
$constructed_download_link .= $download_link_array[$i];
}
}
return $constructed_download_link;
}
function eStore_display_members_purchase_history($user_id, $show_download = false)
{
global $wpdb;
$customer_table_name = WP_ESTORE_CUSTOMER_TABLE_NAME;
$products_table_name = WP_ESTORE_PRODUCTS_TABLE_NAME;
$ret_customer_db = $wpdb->get_results("SELECT * FROM {$customer_table_name} WHERE member_username = '******'", OBJECT);
if (!$show_download) {
$output .= '
<table class="widefat">
<thead><tr>
<th scope="col">' . ESTORE_PRODUCT_NAME . '</th>
<th scope="col">' . ESTORE_DATE . '</th>
<th scope="col">' . ESTORE_PRICE_PAID . '</th>
</tr></thead>
<tbody>';
if ($ret_customer_db) {
foreach ($ret_customer_db as $ret_customer_db) {
$ret_product = $wpdb->get_row("SELECT * FROM {$products_table_name} WHERE id = '{$ret_customer_db->purchased_product_id}'", OBJECT);
$product_details = $ret_customer_db->product_name;
if (!empty($ret_product->product_url)) {
$product_details = '<a href="' . $ret_product->product_url . '" target="_blank">' . $ret_customer_db->product_name . '</a>';
}
$output .= '<tr>';
$output .= '<td align="left">' . $product_details . '</td>';
$output .= '<td align="center">' . $ret_customer_db->date . '</td>';
$output .= '<td align="center">' . $ret_customer_db->sale_amount . '</td>';
$output .= '</tr>';
}
} else {
$output .= '<tr><td colspan="4">' . ESTORE_NO_PURCHASE_FOUND . '</td></tr>';
}
$output .= '</tbody></table>';
} else {
if (isset($_POST['eStore_purchase_history_generate_download_now_button'])) {
//Show the generated download links
$id = strip_tags($_POST['download_now_product_id']);
$retrieved_product = $wpdb->get_row("SELECT * FROM {$products_table_name} WHERE id = '{$id}'", OBJECT);
//$payment_data = free_download_pseudo_payment_data($cust_name, $cust_email);
$item_name = strip_tags($_POST['download_now_item_name']);
$download_link = generate_download_link($retrieved_product, $item_name);
$download_link = nl2br($download_link);
$download_link = wp_eStore_replace_url_in_string_with_link($download_link);
$output .= '<p style="border:1px solid #ccc; padding:10px;">' . $download_link . '</p>';
}
$output .= '
<table class="widefat">
<thead><tr>
<th scope="col">' . ESTORE_PRODUCT_NAME . '</th>
<th scope="col">' . ESTORE_DATE . '</th>
<th scope="col">' . ESTORE_PRICE_PAID . '</th>
<th scope="col">' . ESTORE_GENERATE_DOWNLOAD . '</th>
</tr></thead>
<tbody>';
if ($ret_customer_db) {
foreach ($ret_customer_db as $ret_customer_db) {
$ret_product = $wpdb->get_row("SELECT * FROM {$products_table_name} WHERE id = '{$ret_customer_db->purchased_product_id}'", OBJECT);
if ($ret_product) {
$product_details = $ret_customer_db->product_name;
if (!empty($ret_product->product_url)) {
$product_details = '<a href="' . $ret_product->product_url . '" target="_blank">' . $ret_customer_db->product_name . '</a>';
}
$output .= '<tr>';
$output .= '<td align="left">' . $product_details . '</td>';
$output .= '<td align="center">' . $ret_customer_db->date . '</td>';
$output .= '<td align="center">' . $ret_customer_db->sale_amount . '</td>';
$output .= '<td align="center">';
$output .= '<form method="post" action="" style="display:inline">';
$output .= '<input type="hidden" name="eStore_purchase_history_generate_download_now_button" value="1" />';
$output .= '<input type="hidden" name="download_now_product_id" value="' . $ret_product->id . '" />';
$output .= '<input type="hidden" name="download_now_item_name" value="' . $ret_customer_db->product_name . '" />';
$output .= '<input type="submit" name="submit" class="generate_download_now_button" value="' . ESTORE_GENERATE_DOWNLOAD . '" />';
$output .= '</form>';
$output .= '</td>';
$output .= '</tr>';
} else {
$output .= "<br />Error - Could not find the requested product ID in the products database!";
}
}
} else {
$output .= '<tr><td colspan="4">' . ESTORE_NO_PURCHASE_FOUND . '</td></tr>';
}
$output .= '</tbody></table>';
}
return $output;
}
function wp_estore_admin_menu()
{
echo '<div class="wrap">';
echo '<h2>Admin Functions</h2>';
echo '<div id="poststuff"><div id="post-body">';
echo eStore_admin_css();
global $wpdb;
echo '<div class="eStore_yellow_box">These helpful admin functions allow you to do various manual admin stuff from time to time like generating an encrypted download link for any product, sending email to any customer etc.</div>';
$message = "";
$eStore_product_id = "";
$wp_eStore_variation_name = "";
$eStore_download_link = "";
if (isset($_POST['generate_download_link'])) {
$eStore_product_id = trim($_POST["wp_eStore_product_id"]);
$wp_eStore_variation_name = stripslashes($_POST["wp_eStore_variation_name"]);
$products_table_name = $wpdb->prefix . "wp_eStore_tbl";
$retrieved_product = $wpdb->get_row("SELECT * FROM {$products_table_name} WHERE id = '{$eStore_product_id}'", OBJECT);
if (!empty($wp_eStore_variation_name)) {
$item_name = $retrieved_product->name . " (" . $wp_eStore_variation_name . ")";
} else {
$item_name = $retrieved_product->name;
}
$eStore_download_link = generate_download_link($retrieved_product, $item_name);
if (empty($eStore_download_link)) {
$eStore_download_link = "Download link generation failed! Make sure the digital product variation name is correct if this product uses digital product variation.";
}
$message .= 'Download Link Generated!';
}
if (isset($_POST['send_email'])) {
update_option('eStore_from_email', stripslashes($_POST["wp_eStore_from_email"]));
update_option('eStore_to_email', stripslashes($_POST["wp_eStore_to_email"]));
update_option('eStore_email_subject', stripslashes($_POST["wp_eStore_email_subject"]));
update_option('eStore_admin_email_body', stripslashes($_POST["wp_eStore_email_body"]));
$attachment = '';
if (get_option('eStore_use_wp_mail')) {
$from = get_option('eStore_from_email');
$headers = 'From: ' . $from . "\r\n";
wp_mail(get_option('eStore_to_email'), get_option('eStore_email_subject'), get_option('eStore_admin_email_body'), $headers);
$message .= "Email sent successfully!";
} else {
if (@eStore_send_mail(get_option('eStore_to_email'), get_option('eStore_admin_email_body'), get_option('eStore_email_subject'), get_option('eStore_from_email'), $attachment)) {
$message .= "Email sent successfully!";
} else {
$message .= "Email Sending failed!";
}
}
}
if (isset($_POST['bulk_delete'])) {
$interval_val = $_POST['bulk_delete_hours'];
$interval_unit = 'HOUR';
//MINUTE
$cur_time = current_time('mysql');
$download_links_table_name = $wpdb->prefix . "wp_eStore_download_links_tbl";
$cond = " DATE_SUB('{$cur_time}',INTERVAL '{$interval_val}' {$interval_unit}) > creation_time";
$result = $wpdb->query("DELETE FROM {$download_links_table_name} WHERE {$cond}", OBJECT);
if ($result) {
$message .= "The download links have been deleted! The current timestamp value used was: " . $cur_time;
} else {
$message .= "Nothing to delete!";
}
}
if (isset($_POST['reset_settings_to_default'])) {
wp_eStore_reset_settings_to_default();
$message .= "Settings options have been reset to default!";
}
if (isset($_POST['reset_sales_data'])) {
wp_eStore_reset_sales_data();
$message .= "Sales data have been reset!";
}
if (isset($_POST['reset_product_sales_counter_data'])) {
wp_eStore_reset_product_sales_counter();
$message .= "All product sales counter have been reset to 0!";
}
if (isset($_POST['refresh_prod_cat_relations_tbl'])) {
wp_eStore_refresh_product_category_relation_tbl();
$message .= "The products and category relations table has been resynced.";
}
if (isset($_POST['remove_all_db_tables'])) {
wp_eStore_remove_all_db_tables();
$message .= "All Database tables have been removed! Remember, eStore will not work unless you deactivate and reactivate it again!";
}
//Display message to the user
if (!empty($message)) {
echo '<div id="message" class="updated fade"><p><strong>';
echo $message;
echo '</strong></p></div>';
}
?>
<div class="postbox">
<h3><label for="title">Generate an Encrypted download link for a Product</label></h3>
<div class="inside">
<form method="post" action="<?php
echo $_SERVER["REQUEST_URI"];
?>
">
<input type="hidden" name="generate_download_link" id="generate_download_link" value="true" />
<table class="form-table" width="100%" border="0" cellspacing="0" cellpadding="6">
<tr valign="top"><td align="left">
Product ID:
</td><td align="left">
<input name="wp_eStore_product_id" type="text" size="10" value="<?php
echo $eStore_product_id;
?>
" />
<br /><i>(i) Enter the product id of the product that you want to generate an encrypted download link for.</i>
</td></tr>
<tr valign="top"><td align="left">
Digital Product Variation Name:
</td><td align="left">
<input name="wp_eStore_variation_name" type="text" size="30" value="<?php
echo $wp_eStore_variation_name;
?>
" />
<br /><i>(ii) Enter the digital product variation name if you are using it. Leave empty if this product does not use the digital product variation field.</i>
</td></tr>
<tr valign="top"><td align="left">
</td><td align="left">
<input type="submit" name="generate_download_link" value="Generate Link »" />
<br /><i>(iii) Hit the "Generate Link" button.</i><br /><br />
</td></tr>
<tr valign="top"><td align="left">
Download Link:
</td><td align="left">
<textarea name="wp_eStore_download_link" rows="6" cols="70"><?php
echo $eStore_download_link;
?>
</textarea>
<br /><i>The encrypted download link for a product will be shown in the above area when you hit the Generate Link button.</i><br />
</td></tr>
</table>
</form>
</div></div>
<div class="postbox">
<h3><label for="title">Send Email to Customers</label></h3>
<div class="inside">
<div class="eStore_yellow_box">You can use this section to send a quick email to your customer.
If you want to send a download link for a product then first generate the link from the above section then copy and paste
the encrypted link in the body section below.
</div>
<form method="post" action="<?php
echo $_SERVER["REQUEST_URI"];
?>
">
<input type="hidden" name="send_email" id="send_email" value="true" />
<table class="form-table" width="100%" border="0" cellspacing="0" cellpadding="6">
<tr valign="top"><td align="left">
From Email Address:
</td><td align="left">
<input name="wp_eStore_from_email" type="text" size="50" value="<?php
echo get_option('eStore_from_email');
?>
" />
<br /><i>This email address will appear in the from field of the email.</i>
</td></tr>
<tr valign="top"><td align="left">
To Email Address:
</td><td align="left">
<input name="wp_eStore_to_email" type="text" size="50" value="<?php
echo get_option('eStore_to_email');
?>
" />
<br /><i>This is the email address where the email will be sent to.</i>
</td></tr>
<tr valign="top"><td align="left">
Email Subject:
</td><td align="left">
<input name="wp_eStore_email_subject" type="text" size="50" value="<?php
echo get_option('eStore_email_subject');
?>
" />
<br /><i>This is the email subject.</i>
</td></tr>
<tr valign="top"><td align="left">
Email Body:
</td><td align="left">
<textarea name="wp_eStore_email_body" rows="10" cols="70"><?php
echo get_option('eStore_admin_email_body');
?>
</textarea>
<br /><i>Type your email and hit Send Email button below.</i><br /><br />
<input type="submit" name="send_email" value="<?php
_e('Send Email');
?>
»" />
</td></tr>
</table>
</form>
</div></div>
<div class="postbox">
<h3><label for="title">Clean The Encrypted Download Links Table</label></h3>
<div class="inside">
<br />
<form method="post" action="<?php
echo $_SERVER["REQUEST_URI"];
?>
">
Delete All Links Older Than
<input name="bulk_delete_hours" type="text" size="3" value=""/> Hours
<div class="submit">
<input type="submit" name="bulk_delete" value="Bulk Delete »" />
</div>
</form>
</div></div>
<div class="postbox">
<h3><label for="title">The Almighty Reset Buttons</label></h3>
<div class="inside">
<form method="post" action="<?php
echo $_SERVER["REQUEST_URI"];
?>
" onSubmit="return confirm('Are you sure you want to reset all the settings options to default?');" >
<div class="submit">
<input type="submit" name="reset_settings_to_default" value="Reset eStore Settings to Default" />
</div>
</form>
<form method="post" action="<?php
echo $_SERVER["REQUEST_URI"];
?>
" onSubmit="return confirm('Are you sure you want to reset all sales related data? Useful if you are trying to reset all the test transactions before going live.');" >
<div class="submit">
<input type="submit" name="reset_sales_data" value="Reset All Sales Data" />
</div>
</form>
<form method="post" action="<?php
echo $_SERVER["REQUEST_URI"];
?>
" onSubmit="return confirm('Are you sure you want to reset all product sales counter to 0?');" >
<div class="submit">
<input type="submit" name="reset_product_sales_counter_data" value="Reset Product Sales Counter" />
</div>
</form>
<form method="post" action="<?php
echo $_SERVER["REQUEST_URI"];
?>
" onSubmit="return confirm('Are you sure you want to run this operation?');" >
<div class="submit">
<input type="submit" name="refresh_prod_cat_relations_tbl" value="Resync Products and Category Relations Table" />
</div>
</form>
<form method="post" action="<?php
echo $_SERVER["REQUEST_URI"];
?>
" onSubmit="return confirm('Are you sure you want to remove all eStore database tables? Useful if you are trying to do a clean reinstall of the plugin.');" >
<div class="submit">
<input type="submit" name="remove_all_db_tables" value="Remove All eStore Database Tables" />
</div>
</form>
</div></div>
<div class="postbox">
<h3><label for="title">Site Diagnostics</label></h3>
<div class="inside">
<strong>WP eStore Version: </strong><code><?php
echo WP_ESTORE_VERSION;
?>
</code><br />
<strong>WP Version: </strong><code><?php
echo get_bloginfo("version");
?>
</code><br />
<strong>WPMU: </strong><code><?php
echo !defined('MULTISITE') || !MULTISITE ? "No" : "Yes";
?>
</code><br />
<strong>MySQL Version: </strong><code><?php
echo $wpdb->db_version();
?>
</code><br />
<strong>WP Table Prefix: </strong><code><?php
echo $wpdb->prefix;
?>
</code><br />
<strong>PHP Version: </strong><code><?php
echo phpversion();
?>
</code><br />
<strong>Session Save Path: </strong><code><?php
echo ini_get("session.save_path");
?>
</code><br />
<strong>WP URL: </strong><code><?php
echo get_bloginfo('wpurl');
?>
</code><br />
<strong>Server Name: </strong><code><?php
echo $_SERVER['SERVER_NAME'];
?>
</code><br />
<strong>Cookie Domain: </strong><code><?php
$cookieDomain = parse_url(strtolower(get_bloginfo('wpurl')));
echo $cookieDomain['host'];
?>
</code><br />
<strong>CURL Library Present: </strong><code><?php
echo function_exists('curl_init') ? "Yes" : "No";
?>
</code><br />
<strong>Debug File Write Permissions: </strong><code><?php
echo is_writable(WP_ESTORE_PATH) ? "Writable" : "Not Writable";
?>
</code><br />
</div></div>
<?php
echo '</div></div>';
echo '</div>';
}
function validate_and_dispatch_product()
{
// Check Product Name , Price , Currency , Receivers email ,
global $error_msg;
global $wpdb;
$wp_eStore_config = WP_eStore_Config::getInstance();
$clientdate = date("Y-m-d");
$clienttime = date("H:i:s");
$product_specific_instructions = "";
$currency_symbol = get_option('cart_currency_symbol');
//Post/Forward IPN data to external URL if needed
eStore_POST_IPN_data_to_url($this->ipn_data);
// Read the IPN and validate
if (get_option('eStore_strict_email_check') != '') {
$seller_paypal_email = get_option('cart_paypal_email');
if ($seller_paypal_email != $this->ipn_data['receiver_email']) {
$error_msg .= 'Invalid Seller Paypal Email Address : ' . $this->ipn_data['receiver_email'];
$this->debug_log($error_msg, false);
return false;
} else {
$this->debug_log('Seller Paypal Email Address is Valid: ' . $this->ipn_data['receiver_email'], true);
}
}
$payment_status = $this->ipn_data['payment_status'];
if (!empty($payment_status)) {
if ($payment_status == "Denied") {
$error_msg .= 'Payment status for this transaction is DENIED. You denied the transaction... most likely a cancellation of an eCheque.';
$this->debug_log("You denied the transaction. Most likely a cancellation of an eCheque. Nothing to do here.", false);
return false;
}
if ($payment_status == "Canceled_Reversal") {
$this->debug_log("This is a dispute closed notification in your favour. The plugin will not do anyting.", false);
return true;
}
if ($payment_status != "Completed" && $payment_status != "Processed" && $payment_status != "Refunded" && $payment_status != "Reversed") {
$error_msg .= 'Funds have not been cleared yet. Product(s) will be delivered when the funds clear!';
$this->debug_log($error_msg, false);
$to_address = $this->ipn_data['payer_email'];
$subject = ESTORE_PENDING_PAYMENT_EMAIL_SUBJECT;
$body = ESTORE_PENDING_PAYMENT_EMAIL_BODY;
$from_address = get_option('eStore_download_email_address');
eStore_send_notification_email($to_address, $subject, $body, $from_address);
return false;
}
}
$transaction_type = $this->ipn_data['txn_type'];
if ($transaction_type == "new_case") {
$this->debug_log('This is a dispute case', true);
return true;
}
$transaction_id = $this->ipn_data['txn_id'];
$transaction_subject = $this->ipn_data['transaction_subject'];
$custom = $this->ipn_data['custom'];
$delimiter = "&";
$customvariables = array();
$namevaluecombos = explode($delimiter, $custom);
foreach ($namevaluecombos as $keyval_unparsed) {
$equalsignposition = strpos($keyval_unparsed, '=');
if ($equalsignposition === false) {
$customvariables[$keyval_unparsed] = '';
continue;
}
$key = substr($keyval_unparsed, 0, $equalsignposition);
$value = substr($keyval_unparsed, $equalsignposition + 1);
$customvariables[$key] = $value;
}
$eMember_id = $customvariables['eMember_id'];
$pictureID = $customvariables['ngg_pid'];
//Check for refund payment
$gross_total = $this->ipn_data['mc_gross'];
if ($gross_total < 0) {
// This is a refund or reversal so handle the refund
eStore_handle_refund($this->ipn_data);
$this->debug_log('This is a refund/reversal. Refund amount: ' . $gross_total, true);
return true;
}
//Check for duplicate notification due to server setup issue
if (eStore_is_txn_already_processed($this->ipn_data)) {
$error_msg .= 'The transaction ID and the email address already exists in the database. So this seems to be a duplicate transaction notification. This usually happens with bad server setup.';
$this->debug_log('The transaction ID and the email address already exists in the database. So this seems to be a duplicate transaction notification. This usually happens with bad server setup.', false);
return true;
//No need to be alarmed
}
//=== End of duplicate notification check ===
//Fire the begin processing hook
do_action('eStore_begin_payment_processing', $this->ipn_data['payer_email'], $customvariables['ip']);
$time = time();
global $wpdb;
$products_table_name = $wpdb->prefix . "wp_eStore_tbl";
$customer_table_name = $wpdb->prefix . "wp_eStore_customer_tbl";
$sales_table_name = $wpdb->prefix . "wp_eStore_sales_tbl";
if ($transaction_type == "cart") {
$this->debug_log('Transaction Type: Shopping Cart', true);
// Cart Items
$num_cart_items = $this->ipn_data['num_cart_items'];
$this->debug_log('Number of Cart Items: ' . $num_cart_items, true);
$i = 1;
$cart_items = array();
while ($i < $num_cart_items + 1) {
$item_number = $this->ipn_data['item_number' . $i];
$item_name = $this->ipn_data['item_name' . $i];
//$item_name = mb_convert_encoding($item_name, "UTF-8");
$quantity = $this->ipn_data['quantity' . $i];
$mc_gross = $this->ipn_data['mc_gross_' . $i];
$mc_shipping = $this->ipn_data['mc_shipping' . $i];
$mc_currency = $this->ipn_data['mc_currency'];
$current_item = array('item_number' => $item_number, 'item_name' => $item_name, 'quantity' => $quantity, 'mc_gross' => $mc_gross, 'mc_shipping' => $mc_shipping, 'mc_currency' => $mc_currency);
array_push($cart_items, $current_item);
$i++;
}
} else {
if ($transaction_type == "subscr_signup") {
$this->debug_log('Subscription signup IPN received... (handled by the subscription IPN handler). Check the "subscription_handle_debug.log" file more details.', true);
if (eStore_chk_and_record_cust_data_for_free_trial_signup($this->ipn_data)) {
//Check and record customer data for free trial
return true;
}
$subsc_prod_id = $this->ipn_data['item_number'];
$ret_product = $wpdb->get_row("SELECT * FROM {$products_table_name} WHERE id = '{$subsc_prod_id}'", OBJECT);
if (!$ret_product) {
$error_msg .= 'Request received for subscription product ID: ' . $subsc_prod_id . '. Could not find this Product ID in the product database (please check the manage products menu and verify that you have specified the correct product ID).';
$this->debug_log($error_msg, false);
return false;
}
$subsc_ref = $ret_product->ref_text;
if (!empty($subsc_ref)) {
//Do membership signup task
$this->debug_log('Reference Text field value: ' . $subsc_ref, true);
if (get_option('eStore_enable_wishlist_int')) {
$this->debug_log('WishList integration is being used... creating member account... see the "subscription_handle_debug.log" file for details', true);
wl_handle_subsc_signup($this->ipn_data, $subsc_ref, $this->ipn_data['subscr_id']);
} else {
if (function_exists('wp_eMember_install')) {
$this->debug_log('eMember integration is being used... creating member account... see the "subscription_handle_debug.log" file for details', true);
eMember_handle_subsc_signup($this->ipn_data, $subsc_ref, $this->ipn_data['subscr_id'], $eMember_id);
}
}
}
return true;
} else {
if ($transaction_type == "subscr_cancel" || $transaction_type == "subscr_eot" || $transaction_type == "subscr_failed") {
if (get_option('eStore_enable_wishlist_int')) {
wl_handle_subsc_cancel($this->ipn_data);
} else {
// Code to handle the IPN for subscription cancellation
if (function_exists('wp_eMember_install')) {
eMember_handle_subsc_cancel($this->ipn_data);
}
}
$this->debug_log('Subscription cancellation IPN received... nothing to do here(handled by the subscription IPN handler)', true);
return true;
} else {
$cart_items = array();
$this->debug_log('Transaction Type (Buy Now/Subscribe): ' . $transaction_type, true);
$item_number = $this->ipn_data['item_number'];
$item_name = $this->ipn_data['item_name'];
//$item_name = mb_convert_encoding($item_name, "UTF-8");
$quantity = $this->ipn_data['quantity'];
if (empty($quantity)) {
$quantity = 1;
}
$mc_tax = $this->ipn_data['tax'];
if (!empty($mc_tax)) {
//For "web_accept" txn, the total tax is included in the "mc_gross" amt.
$mc_gross = $this->ipn_data['mc_gross'] - $mc_tax;
$this->debug_log('Deducting tax amount (' . $mc_tax . ') from mc_gross amt', true);
} else {
$mc_gross = $this->ipn_data['mc_gross'];
}
$mc_shipping = $this->ipn_data['mc_shipping'];
$mc_currency = $this->ipn_data['mc_currency'];
$current_item = array('item_number' => $item_number, 'item_name' => $item_name, 'quantity' => $quantity, 'mc_gross' => $mc_gross, 'mc_shipping' => $mc_shipping, 'mc_currency' => $mc_currency);
array_push($cart_items, $current_item);
}
}
}
// URL of directory where script is stored ( include trailing slash )
$script_location = get_option('eStore_download_script');
$random_key = get_option('eStore_random_code');
$payment_currency = get_option('cart_payment_currency');
$product_id_array = array();
$product_name_array = array();
$product_price_array = array();
$product_qty_array = array();
$download_link_array = array();
$download_link_for_digital_item = array();
$product_key_data = "";
$counter = 0;
foreach ($cart_items as $current_cart_item) {
$cart_item_data_num = $current_cart_item['item_number'];
$key = $cart_item_data_num;
$retrieved_product = $wpdb->get_row("SELECT * FROM {$products_table_name} WHERE id = '{$key}'", OBJECT);
if (!$retrieved_product) {
$error_msg .= 'Request received for product ID: ' . $cart_item_data_num . '. Could not find this Product ID in the product database (please check the manage products menu and verify that you have specified the correct product ID).';
$this->debug_log($error_msg, false);
return false;
}
$cart_item_data_name = trim($current_cart_item['item_name']);
//$retrieved_product->name;
$cart_item_data_quantity = $current_cart_item['quantity'];
$cart_item_data_total = $current_cart_item['mc_gross'];
$cart_item_shipping = $current_cart_item['mc_shipping'];
$cart_item_data_currency = $current_cart_item['mc_currency'];
if (empty($cart_item_data_quantity)) {
$cart_item_data_quantity = 1;
}
$this->debug_log('Item Number: ' . $cart_item_data_num, true);
$this->debug_log('Item Name: ' . $cart_item_data_name, true);
$this->debug_log('Item Quantity: ' . $cart_item_data_quantity, true);
$this->debug_log('Item Price: ' . $cart_item_data_total, true);
$this->debug_log('Item Shipping: ' . $cart_item_shipping, true);
$this->debug_log('Item Currency: ' . $cart_item_data_currency, true);
// Compare the values with the values stored in the database
$coupon_code = $customvariables['coupon'];
if (!empty($coupon_code)) {
$this->debug_log('Coupon Code Used : ' . $coupon_code, true);
$coupon_table_name = $wpdb->prefix . "wp_eStore_coupon_tbl";
$ret_coupon = $wpdb->get_row("SELECT * FROM {$coupon_table_name} WHERE coupon_code = '{$coupon_code}'", OBJECT);
if ($ret_coupon) {
$discount_amount = $ret_coupon->discount_value;
$discount_type = $ret_coupon->discount_type;
if ($discount_type == 0) {
//apply % discount
$discount = $retrieved_product->price * $discount_amount / 100;
$true_product_price = $retrieved_product->price - $discount;
} else {
// apply value discount
$true_product_price = $retrieved_product->price - $discount_amount;
}
} else {
eStore_payment_debug('Could not find the coupon in the database: ' . $coupon_code, false);
}
if ($transaction_type == "subscr_payment") {
$true_product_price = 0;
//Used coupon on subscription product
eStore_payment_debug('Coupon discount was used on a subscription product', true);
}
} else {
if (is_numeric($retrieved_product->a3)) {
$true_product_price = 0;
//subscription product
} else {
if (is_numeric($retrieved_product->price)) {
$true_product_price = $retrieved_product->price * $cart_item_data_quantity;
} else {
$true_product_price = 0;
//most likely a subscription
}
}
}
$check_price = true;
$msg = "";
$msg = apply_filters('eStore_before_checking_price_filter', $msg, $current_cart_item);
if (!empty($msg) && $msg == "currency-check-override") {
$check_price = false;
$this->debug_log('Price and currency check override enabled by filter eStore_before_checking_price_filter', true);
}
if ($check_price) {
$true_product_price = round($true_product_price, 2);
if ($cart_item_data_total < $true_product_price) {
$error_msg .= 'Wrong Product Price Detected! Actual Product Price : ' . $true_product_price . ' Amount Paid: ' . $cart_item_data_total;
$this->debug_log($error_msg, false);
return false;
}
if (!empty($retrieved_product->currency_code)) {
$payment_currency = $retrieved_product->currency_code;
}
if ($payment_currency != $cart_item_data_currency) {
$error_msg .= 'Invalid Product Currency Detected! The payment was made in currency: ' . $cart_item_data_currency;
$this->debug_log($error_msg, false);
$this->debug_log('You specified to receive payment in: ' . $payment_currency . ' for this product. Check eStore settings or this product\'s Buy Now/Subscription section and correct the currency code to fix this issue.', false);
return false;
}
}
//*** Handle Membership Payment ***
$member_ref = $retrieved_product->ref_text;
$this->debug_log('Value of the reference text field for this product: ' . $member_ref, true);
if (!empty($member_ref)) {
if ($transaction_type == "web_accept") {
if (get_option('eStore_enable_wishlist_int')) {
$this->debug_log('WishList integration is being used... creating member account... see the "subscription_handle_debug.log" file for details', true);
wl_handle_subsc_signup($this->ipn_data, $member_ref, $this->ipn_data['txn_id']);
} else {
if (function_exists('wp_eMember_install')) {
$this->debug_log('eMember integration is being used... creating member account... see the "subscription_handle_debug.log" file for details', true);
eMember_handle_subsc_signup($this->ipn_data, $member_ref, $this->ipn_data['txn_id'], $eMember_id);
}
}
} else {
if ($transaction_type == "cart") {
if (get_option('eStore_enable_wishlist_int')) {
$this->debug_log('WishList integration is being used... creating member account... see the "subscription_handle_debug.log" file for details', true);
wl_handle_subsc_signup($this->ipn_data, $member_ref, $this->ipn_data['txn_id']);
} else {
if (function_exists('wp_eMember_install')) {
$this->debug_log('eMember integration is being used... creating member account... see the "subscription_handle_debug.log" file for details', true);
eMember_handle_subsc_signup($this->ipn_data, $member_ref, $this->ipn_data['txn_id'], $eMember_id);
}
}
} else {
if ($transaction_type == "subscr_payment") {
$subscr_id = $this->ipn_data['subscr_id'];
eStore_update_member_subscription_start_date_if_applicable($this->ipn_data, $subscr_id);
}
}
}
}
//== End of Membership payment handling ==
$product_id = $retrieved_product->id;
//Check if nextgen gallery integration is being used
$pid_check_value = eStore_is_ngg_pid_present($cart_item_data_name);
if ($pid_check_value != -1) {
$pictureID = $pid_check_value;
}
//Generate link from Nextgen gallery if PID is present.
if (!empty($pictureID)) {
$download_link = eStore_get_ngg_image_url($pictureID, $cart_item_data_name);
$pictureID = "";
} else {
$this->debug_log('Generating encrypted download link for this product.', true);
$download_link = generate_download_link($retrieved_product, $cart_item_data_name, $this->ipn_data);
}
$this->debug_log('Download Link: [hidden]', true);
//$download_link
$product_specific_instructions .= eStore_get_product_specific_instructions($retrieved_product);
//Product license key generation if using the license manager
if (function_exists('wp_lic_manager_install')) {
$product_license_data .= eStore_check_and_generate_license_key($retrieved_product, $this->ipn_data);
$this->debug_log('License Data: [hidden]', true);
//$product_license_data
}
//Issue serial key if this feature is being used
$product_key_data .= eStore_post_sale_retrieve_serial_key_and_update($retrieved_product, $cart_item_data_name, $cart_item_data_quantity);
array_push($product_name_array, $cart_item_data_name);
array_push($product_id_array, $product_id);
array_push($product_price_array, $cart_item_data_total);
array_push($product_qty_array, $cart_item_data_quantity);
array_push($download_link_array, $download_link);
if (eStore_check_if_string_contains_url($download_link)) {
array_push($download_link_for_digital_item, $download_link);
}
$counter++;
$download_link = '';
}
if (!empty($product_key_data)) {
$this->ipn_data['product_key_data'] = $product_key_data;
}
// How long the download link remain valid (hours)
$download_url_life = get_option('eStore_download_url_life');
// Email settings data
$notify_email = get_option('eStore_notify_email_address');
// Email which will receive notification of sale (sellers email)
$download_email = get_option('eStore_download_email_address');
// Email from which the mail wil be sent from
$email_subject = get_option('eStore_buyer_email_subj');
$email_body = get_option('eStore_buyer_email_body');
$notify_subject = get_option('eStore_seller_email_subj');
$notify_body = get_option('eStore_seller_email_body');
// Send the product
for ($i = 0; $i < sizeof($product_name_array); $i++) {
$constructed_products_name .= $product_name_array[$i];
$constructed_products_name .= ", ";
$constructed_products_price .= $product_price_array[$i];
$constructed_products_price .= ", ";
$constructed_products_id .= $product_id_array[$i];
$constructed_products_id .= ", ";
$constructed_products_details .= "\n" . $product_name_array[$i] . " x " . $product_qty_array[$i] . " - " . $currency_symbol . $product_price_array[$i] . " (" . $payment_currency . ")";
$tax_inc_price = eStore_get_tax_include_price_by_prod_id($product_id_array[$i], $product_price_array[$i]);
$constructed_products_details_tax_inc .= "\n" . $product_name_array[$i] . " x " . $product_qty_array[$i] . " - " . $currency_symbol . $tax_inc_price . " (" . $payment_currency . ")";
//Download links list for all items in the cart
$constructed_download_link .= "\n";
if (is_array($download_link_array[$i])) {
$package_downloads = $download_link_array[$i];
for ($j = 0; $j < sizeof($package_downloads); $j++) {
$constructed_download_link .= $package_downloads[$j];
$constructed_download_link .= "\n";
}
} else {
$constructed_download_link .= $download_link_array[$i];
}
//Download links for only digital items in the cart
$constructed_download_link_for_digital_item .= "\n";
if (is_array($download_link_for_digital_item[$i])) {
$package_downloads2 = $download_link_for_digital_item[$i];
for ($j = 0; $j < sizeof($package_downloads2); $j++) {
$constructed_download_link_for_digital_item .= $package_downloads2[$j];
$constructed_download_link_for_digital_item .= "\n";
}
} else {
$constructed_download_link_for_digital_item .= $download_link_for_digital_item[$i];
}
}
$purchase_date = date("Y-m-d");
$total_purchase_amt = $this->ipn_data['mc_gross'];
$txn_id = $this->ipn_data['txn_id'];
$total_tax = $this->ipn_data['tax'];
$total_shipping = round($this->ipn_data['mc_handling'] + $this->ipn_data['mc_shipping'], 2);
$total_minus_total_tax = round($total_purchase_amt - $total_tax, 2);
$this->ipn_data['mc_tax'] = $total_tax;
$this->ipn_data['mc_shipping'] = $total_shipping;
//Counter for incremental receipt number
$last_records_id = $wp_eStore_config->getValue('eStore_custom_receipt_counter');
//get_option('eStore_custom_receipt_counter');
if (empty($last_records_id)) {
$last_records_id = 0;
}
$receipt_counter = $last_records_id + 1;
$this->debug_log('Incremental counter value for PayPal checkout: ' . $receipt_counter, true);
$wp_eStore_config->setValue('eStore_custom_receipt_counter', $receipt_counter);
$wp_eStore_config->saveConfig();
$buyer_shipping_info = "\n" . $this->ipn_data['address_name'];
$buyer_shipping_info .= "\n" . $this->ipn_data['address_street'];
$buyer_shipping_info .= "\n" . $this->ipn_data['address_city'];
$buyer_shipping_info .= "\n" . $this->ipn_data['address_state'] . " " . $this->ipn_data['address_zip'];
$buyer_shipping_info .= "\n" . $this->ipn_data['address_country'];
$buyer_shipping_info .= "\n" . $this->ipn_data['contact_phone'];
$this->ipn_data['address'] = $buyer_shipping_info;
$buyer_phone = $this->ipn_data['contact_phone'];
$shipping_option = $customvariables['ship_option'];
if (empty($shipping_option)) {
$shipping_option = "Default";
}
$product_specific_instructions = eStore_apply_post_payment_dynamic_tags($product_specific_instructions, $this->ipn_data, $cart_items);
$tags = array("{first_name}", "{last_name}", "{payer_email}", "{product_name}", "{product_link}", "{product_price}", "{product_id}", "{download_life}", "{product_specific_instructions}", "{product_details}", "{product_details_tax_inclusive}", "{shipping_info}", "{license_data}", "{purchase_date}", "{purchase_amt}", "{transaction_id}", "{shipping_option_selected}", "{product_link_digital_items_only}", "{total_tax}", "{total_shipping}", "{total_minus_total_tax}", "{customer_phone}", "{counter}", "{coupon_code}", "{serial_key}");
$vals = array($this->ipn_data['first_name'], $this->ipn_data['last_name'], $this->ipn_data['payer_email'], $constructed_products_name, $constructed_download_link, $constructed_products_price, $constructed_products_id, $download_url_life, $product_specific_instructions, $constructed_products_details, $constructed_products_details_tax_inc, $buyer_shipping_info, $product_license_data, $purchase_date, $total_purchase_amt, $txn_id, $shipping_option, $constructed_download_link_for_digital_item, $total_tax, $total_shipping, $total_minus_total_tax, $buyer_phone, $receipt_counter, $coupon_code, $product_key_data);
$subject = str_replace($tags, $vals, $email_subject);
$body = stripslashes(str_replace($tags, $vals, $email_body));
$headers = 'From: ' . $download_email . "\r\n";
$attachment = '';
//Call the filter for email notification body
$this->debug_log('Applying filter - eStore_notification_email_body_filter', true);
$body = apply_filters('eStore_notification_email_body_filter', $body, $this->ipn_data, $cart_items);
// Determine if it's a recurring payment
$recurring_payment = is_paypal_recurring_payment($this->ipn_data);
if (!$recurring_payment) {
if (get_option('eStore_send_buyer_email')) {
if (get_option('eStore_use_wp_mail')) {
wp_eStore_send_wp_mail($this->ipn_data['payer_email'], $subject, $body, $headers);
//wp_mail($this->ipn_data['payer_email'], $subject, $body, $headers);
$this->debug_log('Product Email successfully sent to ' . $this->ipn_data['payer_email'] . '.', true);
} else {
if (@eStore_send_mail($this->ipn_data['payer_email'], $body, $subject, $download_email, $attachment)) {
$this->debug_log('Product Email successfully sent (using PHP mail) to ' . $this->ipn_data['payer_email'] . '.', true);
} else {
$this->debug_log('Error sending product Email (using PHP mail) to ' . $this->ipn_data['payer_email'] . '.', false);
}
}
}
}
// Notify seller
$n_subject = str_replace($tags, $vals, $notify_subject);
$n_body = str_replace($tags, $vals, $notify_body);
if ($wp_eStore_config->getValue('eStore_add_payment_parameters_to_admin_email') == '1') {
$n_body .= "\n\n------- User Email ----------\n" . $body . "\n\n------- Paypal Parameters (Only admin will receive this) -----\n" . $this->post_string;
}
$n_body = stripslashes($n_body);
if (!$recurring_payment) {
$notify_emails_array = explode(",", $notify_email);
foreach ($notify_emails_array as $notify_email_address) {
if (!empty($notify_email_address)) {
$recipient_email_address = trim($notify_email_address);
if (get_option('eStore_use_wp_mail')) {
wp_eStore_send_wp_mail($recipient_email_address, $n_subject, $n_body, $headers);
//wp_mail($recipient_email_address, $n_subject, $n_body, $headers);
$this->debug_log('Notify Email successfully sent to ' . $recipient_email_address . '.', true);
} else {
if (@eStore_send_mail($recipient_email_address, $n_body, $n_subject, $download_email)) {
$this->debug_log('Notify Email successfully sent (using PHP mail) to ' . $recipient_email_address . '.', true);
} else {
$this->debug_log('Error sending notify Email (using PHP mail) to ' . $recipient_email_address . '.', false);
}
}
}
}
}
// Do Post operations
if (!$recurring_payment) {
$this->debug_log('Updating Products, Customers, Coupons, Sales Database Tables with Sales Data.', true);
$firstname = $this->ipn_data['first_name'];
$lastname = $this->ipn_data['last_name'];
$emailaddress = $this->ipn_data['payer_email'];
$address = esc_sql(stripslashes($buyer_shipping_info));
$phone = $this->ipn_data['contact_phone'];
$subscr_id = $this->ipn_data['subscr_id'];
$customer_ip = $customvariables['ip'];
if (empty($customer_ip)) {
$customer_ip = "No information";
}
$product_key_data = $this->ipn_data['product_key_data'];
if (empty($product_key_data)) {
$product_key_data = "";
}
$notes = "";
$status = "Paid";
if (function_exists('wp_eMember_install') && empty($eMember_id)) {
//eMember purchase history additional check
$this->debug_log('No eMember ID was passed so the user was not logged in. Quering member database to see if a user account exists for: ' . $emailaddress, true);
$members_table_name = $wpdb->prefix . "wp_eMember_members_tbl";
$query_emem_db = $wpdb->get_row("SELECT member_id FROM {$members_table_name} WHERE email = '{$emailaddress}'", OBJECT);
if ($query_emem_db) {
$eMember_id = $query_emem_db->member_id;
$this->debug_log('Found a user account with the purchaser email address. adding this purchase to account ID: ' . $eMember_id, true);
}
}
$counter = 0;
foreach ($cart_items as $current_cart_item) {
$cart_item_data_num = $current_cart_item['item_number'];
$cart_item_data_name = $current_cart_item['item_name'];
$key = $cart_item_data_num;
$retrieved_product = $wpdb->get_row("SELECT * FROM {$products_table_name} WHERE id = '{$key}'", OBJECT);
$current_product_id = $cart_item_data_num;
$cart_item_qty = $current_cart_item['quantity'];
$sale_price = $current_cart_item['mc_gross'];
if (empty($cart_item_qty)) {
$cart_item_qty = 1;
}
$this->debug_log('Product ID: ' . $cart_item_data_num . '. Current available copies value: ' . $retrieved_product->available_copies . ' Sales count value: ' . $retrieved_product->sales_count, true);
$new_available_copies = "";
if (is_numeric($retrieved_product->available_copies)) {
$new_available_copies = $retrieved_product->available_copies - $cart_item_qty;
}
$new_sales_count = $retrieved_product->sales_count + $cart_item_qty;
$this->debug_log('New available copies value: ' . $new_available_copies . ' New sales count value: ' . $new_sales_count, true);
$updatedb = "UPDATE {$products_table_name} SET available_copies = '{$new_available_copies}', sales_count = '{$new_sales_count}' WHERE id='{$current_product_id}'";
$results = $wpdb->query($updatedb);
// Update the Customer table
$product_name = esc_sql(stripslashes($cart_item_data_name));
$eMember_username = $eMember_id;
$updatedb = "INSERT INTO {$customer_table_name} (first_name, last_name, email_address, purchased_product_id,txn_id,date,sale_amount,coupon_code_used,member_username,product_name,address,phone,subscr_id,purchase_qty,ipaddress,status,serial_number,notes) VALUES ('{$firstname}', '{$lastname}','{$emailaddress}','{$current_product_id}','{$transaction_id}','{$clientdate}','{$sale_price}','{$coupon_code}','{$eMember_username}','{$product_name}','{$address}','{$phone}','{$subscr_id}','{$cart_item_qty}','{$customer_ip}','{$status}','{$product_key_data}','{$notes}')";
$results = $wpdb->query($updatedb);
$updatedb2 = "INSERT INTO {$sales_table_name} (cust_email, date, time, item_id, sale_price) VALUES ('{$emailaddress}','{$clientdate}','{$clienttime}','{$current_product_id}','{$sale_price}')";
$results = $wpdb->query($updatedb2);
}
if (!empty($coupon_code)) {
$coupon_table_name = $wpdb->prefix . "wp_eStore_coupon_tbl";
$ret_coupon = $wpdb->get_row("SELECT * FROM {$coupon_table_name} WHERE coupon_code = '{$coupon_code}'", OBJECT);
if ($ret_coupon) {
$redemption_count = $ret_coupon->redemption_count + 1;
$updatedb = "UPDATE {$coupon_table_name} SET redemption_count = '{$redemption_count}' WHERE coupon_code='{$coupon_code}'";
$results = $wpdb->query($updatedb);
}
}
$this->debug_log('Products, Customers, Coupons, Sales Database Tables Updated.', true);
//Autoresponder signups
eStore_item_specific_autoresponder_signup($cart_items, $firstname, $lastname, $emailaddress);
eStore_global_autoresponder_signup($firstname, $lastname, $emailaddress);
$this->ipn_data['eMember_userid'] = $eMember_id;
//need to add the member ID to the IPN data
do_action('eStore_product_database_updated_after_payment', $this->ipn_data, $cart_items);
//eStore's action after post payment product database is update
}
$this->debug_log('Updating Affiliate Database Table with Sales Data if Using the WP Affiliate Platform Plugin.', true);
if (eStore_affiliate_capability_exists()) {
//$this->debug_log('WP Affiliate Platform is installed, checking referral details...',true);
$award_commission = true;
if (get_option('eStore_aff_one_time_commission')) {
if ($recurring_payment) {
$award_commission = false;
$this->debug_log('One time commission option is being used, This is a recurring payment and will not generate affiliate commission.', true);
}
}
if ($award_commission) {
$this->debug_log('Affiliate Commission may need to be tracked. See the "eStore_post_payment_debug.log" file for more details on commission calculation', true);
eStore_aff_award_commission($this->ipn_data, $cart_items);
}
//Handle auto affiliate account creation if this feature is used
eStore_handle_auto_affiliate_account_creation($this->ipn_data);
} else {
$this->debug_log('Not Using the WP Affiliate Platform Plugin.', true);
}
//Fire Recurring payment action hook
if ($recurring_payment) {
$this->debug_log('Firing the PayPal recurring payment action hook.', true);
do_action('eStore_paypal_recurring_payment_received', $this->ipn_data, $cart_items);
}
//Revenue sharing
$share_revenue = get_option('eStore_aff_enable_revenue_sharing');
if (!empty($share_revenue)) {
eStore_award_author_commission($this->ipn_data, $cart_items);
}
//POST IPN Data to memberwing script if specified in the settings
$memberwing_external_post_url = get_option('eStore_memberwing_ipn_post_url');
if (!empty($memberwing_external_post_url)) {
$this->debug_log('Posting IPN data to Memberwing plugin :' . $memberwing_external_post_url, true);
eStore_POST_IPN_data_to_url($this->ipn_data, $memberwing_external_post_url);
}
return true;
}
