Ask your WordPress questions! Pay money and get answers fast!

WP Plugin (License Key Manager) does not work correctly WordPress

REFUNDED

Hi,
I have wordpress (3.4) and wp e-commerce (3.8.8.2) on my website installed. Additional I have a plugin called Wpec License Key Manager which allows to upload license keys to a product. If a customer buys a product a email should be send with the key which is assigned to the product.

The problem is that this plugin does not send the correct key.

That means if I have for example 3 products and then I add some different keys to products:

Product A:
key1a
key2a
key3a

Product B:
key1b

Product C:
key1c
key2c

The plugin take just one random key and send to the customer.
Customer buys Product A and get "key2c", but he schould get "key1a".

Here is the code of the plugin:
<?php /* Plugin Name: WPEC License Key Manager Plugin URI: http://www.dustinward.com Description: A WPEC plugin to help manage downloadable software license keys. Author: Dustin Ward Version: 2.0 Author URI: http://www.dustinward.com */ //*************** Admin function *************** function wpec_license_mgr_admin_actions() { add_options_page("WPEC License Key Mgr", "WPEC License Key", 'manage_options', "wpec_license_manager", "wpec_license_admin"); } function wpec_license_admin() { global $wpdb; $wpdb->query(" CREATE TABLE IF NOT EXISTS `{$wpdb->prefix}license` ( `id` int(11) NOT NULL AUTO_INCREMENT, `added_on` int(11) NOT NULL, `assigned_on` int(11) NOT NULL, `license` varchar(255) NOT NULL, `related_products` text NOT NULL, `order_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;"); if(file_exists($_FILES['license_file']['tmp_name'])) { $lines = @file($_FILES['license_file']['tmp_name']); foreach ((array) $lines as $line) { $line = trim($line); $chk = $wpdb->get_var("SELECT COUNT(id) AS total FROM {$wpdb->prefix}license WHERE license = '".trim($line)."'"); if(!$chk and !empty($line)) { $wpdb->query("INSERT INTO {$wpdb->prefix}license SET added_on = '".time()."', license = '".trim($line)."'"); $success++; } else { $fail++; } } echo '<div class="updated"><p>License file is processed, '.intval($success).' successed and '.intval($fail).' skipped(already exists).</p></div>'; } if($_POST['license']) { $chk = $wpdb->get_var("SELECT COUNT(id) AS total FROM {$wpdb->prefix}license WHERE license = '".$_POST['license']."'"); if($_POST['edit']) $chk = $wpdb->get_var("SELECT COUNT(id) AS total FROM {$wpdb->prefix}license WHERE license = '".$_POST['license']."' AND id <> '".$_POST['edit']."'"); if(!$chk) { $related = serialize($_POST['related']); if($_POST['edit']) { $wpdb->query("UPDATE {$wpdb->prefix}license SET license = '".$_POST['license']."',related_products = '".$related."' WHERE id = '".$_POST['edit']."'"); } else { $wpdb->query("INSERT INTO {$wpdb->prefix}license SET added_on = '".time()."', license = '".$_POST['license']."',related_products = '".$related."'"); echo '<div class="updated"><p>New License is saved.</p></div>'; } } else { echo '<div class="error"><p>Sorry that license already exists.</p></div>'; } } if($_POST['liccheck']) { foreach((array) $_POST['liccheck'] as $lid) { echo $lid; $wpdb->query("DELETE FROM {$wpdb->prefix}license WHERE id = '".$lid."'"); } } if($_GET['del']) { $wpdb->query("DELETE FROM {$wpdb->prefix}license WHERE id = '".$_GET['del']."'"); echo '<div class="updated"><p>The license has been deleted.</p></div>'; } ?> <div class="wrap nosubsub"> <div class="icon32" id="icon-link-manager"><br> </div> <h2 class="nav-tab-wrapper"> <a class="nav-tab<?php if(empty($_REQUEST['act'])) echo " nav-tab-active"; ?>" href="options-general.php?page=wpec_license_manager">License Manager</a> <a class="nav-tab<?php if($_REQUEST['act']) echo " nav-tab-active"; ?>" href="options-general.php?page=wpec_license_manager&act=1"><?php echo ($_REQUEST['edit'])?"Edit":"Add New"; ?> License</a> </h2> <br /> <?php $all = $wpdb->get_var("SELECT COUNT(id) AS total FROM {$wpdb->prefix}license"); $available = $wpdb->get_var("SELECT COUNT(id) AS total FROM {$wpdb->prefix}license WHERE order_id = 0"); $taken = $wpdb->get_var("SELECT COUNT(id) AS total FROM {$wpdb->prefix}license WHERE order_id <> 0"); ?> <ul class="subsubsub"> <li class="all"><a href="options-general.php?page=wpec_license_manager">All <span class="count">(<?php echo $all; ?>)</span></a> |</li> <li class="trash"><a href="options-general.php?page=wpec_license_manager&av=1">Available <span class="count">(<?php echo $available; ?>)</span></a> |</li> <li class="trash"><a href="options-general.php?page=wpec_license_manager&tk=1">Taken <span class="count">(<?php echo $taken; ?>)</span></a></li> </ul> <form method="post" action="options-general.php?page=wpec_license_manager" id="posts-filter" enctype="multipart/form-data"> <p class="search-box"> <label for="link-search-input" class="screen-reader-text">Search License:</label> <input type="text" value="" name="slicense" id="link-search-input"> <input type="submit" value="Search License" class="button" id="search-submit" name=""> </p> <p class="search-box"> <label for="link-search-input" class="screen-reader-text">Mass License Upload:</label> <input type="file" name="license_file" /> <input type="submit" value="Mass License Upload" class="button" id="search-submit" name="submit_license">    -    </p> <?php if($_REQUEST['act']): ?> <?php if($_GET['edit']) $edit = $wpdb->get_row("SELECT * FROM {$wpdb->prefix}license WHERE id = '".$_GET['edit']."'"); ?> <input type="hidden" name="edit" value="<?php echo $edit->id; ?>" /> <table class="wp-list-table widefat tags ui-sortable"> <thead> <tr> <th width="250"></th> <th></th> </tr> </thead> <tbody> <tr> <td><strong>License</strong></td> <td> <input type="text" name="license" size="40" value="<?php echo $edit->license; ?>" /></td> </tr> <tr> <td valign="top"><strong><a id="related"></a>Related Product</strong><br /><small>Just left unchecked to apply the license to all available product.</small></td> <td><select name="related[]" size="8" multiple="multiple" id="related[]" style="height:200px; width:300px;"> <?php $arras = $wpdb->get_results("SELECT ID,post_title FROM `{$wpdb->prefix}posts` WHERE post_type = 'wpsc-product' AND post_status = 'publish' ORDER BY `post_title` ASC"); $cur_sel = array(); $cur_sel2 = unserialize($edit->related_products); if($cur_sel2) $cur_sel = $cur_sel2; foreach((array)$arras as $product): $sel = ""; if(in_array($product->ID,$cur_sel)) $sel = " selected"; echo "<option value='".$product->ID."'$sel>".$product->post_title."</option>"; endforeach; ?> </select></td> </tr> <tr> <td></td> <td> <input type="submit" value="Save" class="button-primary" id="save_license" name="save_license"> <?php if($_GET['edit']): ?><a href="options-general.php?page=wpec_license_manager">Cancel</a><?php endif; ?> </td> </tr> </tbody> </table> </form> <?php return; endif; ?> <div class="tablenav top"> <div class="alignleft actions"> <select name="action"> <option selected="selected" value="-1">Bulk Actions</option> <option value="delete">Delete</option> </select> <input type="submit" value="Apply" class="button-secondary action" id="doaction" name=""> </div> <br class="clear"> </div> <table cellspacing="0" class="wp-list-table widefat fixed bookmarks"> <thead> <tr> <th style="" class="manage-column column-cb check-column" id="cb" scope="col"><input type="checkbox"></th> <th style="" class="manage-column">License</th> <th style="" class="manage-column column-url <?php echo ($_REQUEST['orderby'] == "added_on")?"sorted ":"sortable "; ?><?php echo ($_REQUEST['order'] and $_REQUEST['orderby'] == "added_on")?$_REQUEST['order']:"desc"; ?> " id="url" scope="col"><a href="options-general.php?page=wpec_license_manager&orderby=added_on&order=<?php if($_REQUEST['order'] == "asc" and $_REQUEST['orderby'] == "added_on") { echo "desc"; } else { echo "asc"; } ?>"><span>Saved On</span><span class="sorting-indicator"></span></a></th> <th style="" class="manage-column column-url <?php echo ($_REQUEST['orderby'] == "assigned_on")?"sorted ":"sortable "; ?><?php echo ($_REQUEST['order'] and $_REQUEST['orderby'] == "assigned_on")?$_REQUEST['order']:"desc"; ?> " id="url" scope="col"><a href="options-general.php?page=wpec_license_manager&orderby=assigned_on&order=<?php if($_REQUEST['order'] == "asc" and $_REQUEST['orderby'] == "assigned_on") { echo "desc"; } else { echo "asc"; } ?>"><span>Assigned On</span><span class="sorting-indicator"></span></a></th> <th style="" class="manage-column column-rel" id="rel" scope="col">Related Order</th> </tr> </thead> <tfoot> <tr> <th style="" class="manage-column column-cb check-column" scope="col"><input type="checkbox"></th> <th style="" class="manage-column column-categories" id="categories" scope="col">License</th> <th style="" class="manage-column column-url <?php echo ($_REQUEST['orderby'] == "added_on")?"sorted ":"sortable "; ?><?php echo ($_REQUEST['order'] and $_REQUEST['orderby'] == "added_on")?$_REQUEST['order']:"desc"; ?> " id="url" scope="col"><a href="options-general.php?page=wpec_license_manager&orderby=added_on&order=<?php if($_REQUEST['order'] == "asc" and $_REQUEST['orderby'] == "added_on") { echo "desc"; } else { echo "asc"; } ?>"><span>Saved On</span><span class="sorting-indicator"></span></a></th> <th style="" class="manage-column column-url <?php echo ($_REQUEST['orderby'] == "assigned_on")?"sorted ":"sortable "; ?><?php echo ($_REQUEST['order'] and $_REQUEST['orderby'] == "assigned_on")?$_REQUEST['order']:"desc"; ?> " id="url" scope="col"><a href="options-general.php?page=wpec_license_manager&orderby=assigned_on&order=<?php if($_REQUEST['order'] == "asc" and $_REQUEST['orderby'] == "assigned_on") { echo "desc"; } else { echo "asc"; } ?>"><span>Assigned On</span><span class="sorting-indicator"></span></a></th> <th style="" class="manage-column column-rel" id="rel" scope="col">Related Order</th> </tr> </tfoot> <tbody id="the-list"> <?php if($_GET['av']) $odi = "order_id = 0 "; if($_GET['tk']) $odi = "order_id <> 0 "; $sql = "SELECT * FROM {$wpdb->prefix}license {$odi}ORDER BY ".(($_REQUEST['orderby'])?$_REQUEST['orderby']:"added_on")." ".(($_REQUEST['order'])?$_REQUEST['order']:"DESC LIMIT 100"); if($_REQUEST['slicense']) $sql = "SELECT * FROM {$wpdb->prefix}license WHERE license LIKE '%".$_REQUEST['slicense']."%'"; $res = $wpdb->get_results($sql); foreach((array) $res as $lic): ?> <tr valign="middle" class="alternate" id="link-<?php echo $i++; ?>"> <th class="check-column" scope="row"><input type="checkbox" value="<?php echo $lic->id; ?>" name="liccheck[]"></th> <td class="column-name"><strong><?php echo $lic->license; ?></strong><br> <div class="row-actions"><span class="edit"><a href="options-general.php?page=wpec_license_manager&act=1&edit=<?php echo $lic->id; ?>">Edit</a> | <a href="options-general.php?page=wpec_license_manager&act=1&edit=<?php echo $lic->id; ?>#related">Related Products</a> | </span><span class="delete"><a onclick="if ( confirm( 'You are about to delete this license.\n \'Cancel\' to stop, \'OK\' to delete.' ) ) { return true;}return false;" href="options-general.php?page=wpec_license_manager&del=<?php echo $lic->id; ?>" class="submitdelete">Delete</a></span></div></td> <td class="column-url"><?php if($lic->added_on) echo date("d/m/Y H:i",$lic->added_on); ?></td> <td class="column-categories"><?php if($lic->assigned_on) echo date("d/m/Y H:i",$lic->assigned_on); ?></td> <td class="column-rel"> <?php if($lic->order_id): ?> <a href="index.php?page=wpsc-sales-logs&purchaselog_id=<?php echo $lic->order_id; ?>"><?php echo $lic->order_id; ?></a> <?php endif; ?> </td> </tr> <?php endforeach; ?> </tbody> </table> <div class="tablenav bottom"> <div class="alignleft actions"> <select name="action2"> <option selected="selected" value="-1">Bulk Actions</option> <option value="delete">Delete</option> </select> <input type="submit" value="Apply" class="button-secondary action" id="doaction2" name=""> </div> <br class="clear"> </div> <div id="ajax-response"></div> </form> </div> <?php } add_action('admin_menu', 'wpec_license_mgr_admin_actions'); ?>

<?php /** * WP eCommerce transaction results class * * This class is responsible for theming the transaction results page. * * @package wp-e-commerce * @since 3.8 */ function wpsc_transaction_theme() { global $wpdb, $user_ID, $nzshpcrt_gateways, $sessionid, $cart_log_id, $errorcode; $errorcode = ''; $transactid = ''; $dont_show_transaction_results = false; if ( isset( $_GET['sessionid'] ) ) $sessionid = $_GET['sessionid']; if ( !isset( $_GET['sessionid'] ) && isset( $_GET['ms'] ) ) $sessionid = $_GET['ms']; if ( isset( $_GET['gateway'] ) && 'google' == $_GET['gateway'] ) { wpsc_google_checkout_submit(); unset( $_SESSION['wpsc_sessionid'] ); } if ( isset( $_SESSION['wpsc_previous_selected_gateway'] ) && in_array( $_SESSION['wpsc_previous_selected_gateway'], array( 'paypal_certified', 'wpsc_merchant_paypal_express' ) ) ) $sessionid = $_SESSION['paypalexpresssessionid']; if ( isset( $_REQUEST['eway'] ) && '1' == $_REQUEST['eway'] ) $sessionid = $_GET['result']; elseif ( isset( $_REQUEST['eway'] ) && '0' == $_REQUEST['eway'] ) echo $_SESSION['eway_message']; elseif ( isset( $_REQUEST['payflow'] ) && '1' == $_REQUEST['payflow'] ){ echo $_SESSION['payflow_message']; $_SESSION['payflow_message'] = ''; } $dont_show_transaction_results = false; if ( isset( $_SESSION['wpsc_previous_selected_gateway'] ) ) { // Replaces the ugly if else for gateways switch($_SESSION['wpsc_previous_selected_gateway']){ case 'paypal_certified': case 'wpsc_merchant_paypal_express': echo $_SESSION['paypalExpressMessage']; if(isset($_SESSION['reshash']['PAYMENTINFO_0_TRANSACTIONTYPE']) && 'expresscheckout' == $_SESSION['reshash']['PAYMENTINFO_0_TRANSACTIONTYPE']) $dont_show_transaction_results = false; else $dont_show_transaction_results = true; break; case 'dps': $sessionid = decrypt_dps_response(); break; //paystation was not updating the purchase logs for successful payment - this is ugly as need to have the databse update done in one place by all gatways on a sucsessful transaction hook not some within the gateway and some within here and some not at all??? This is getting a major overhaul but for here and now it just needs to work for the gold cart people! case 'paystation': $ec = $_GET['ec']; $result= $_GET['em']; if($result == 'Transaction successful' && $ec == 0) $processed_id = '3'; if($result == 'Insufficient Funds' && $ec == 5){ $processed_id = '6'; $payment_instructions = printf( __( 'Sorry your transaction was not accepted due to insufficient funds <br /><a href="%1$s">Click here to go back to checkout page</a>.', 'wpsc' ), get_option( "shopping_cart_url" ) ); } if($processed_id){ $wpdb->update( WPSC_TABLE_PURCHASE_LOGS, array('processed' => $processed_id),array('sessionid'=>$sessionid), array('%f') ); } break; } } if(!$dont_show_transaction_results ) { if ( !empty($sessionid) ){ $cart_log_id = $wpdb->get_var( "SELECT `id` FROM `" . WPSC_TABLE_PURCHASE_LOGS . "` WHERE `sessionid`= " . $sessionid . " LIMIT 1" ); return transaction_results( $sessionid, true ); }else printf( __( 'Sorry your transaction was not accepted.<br /><a href="%1$s">Click here to go back to checkout page</a>.', 'wpsc' ), get_option( "shopping_cart_url" ) ); } } /** * transaction_results function main function for creating the purchase reports, transaction results page, and email receipts * @access public * * @since 3.7 * @param $sessionid (string) unique session id * @param echo_to_screen (boolean) whether to output the results or return them (potentially redundant) * @param $transaction_id (int) the transaction id */ function transaction_results( $sessionid, $display_to_screen = true, $transaction_id = null ) { // Do we seriously need this many globals? global $wpdb, $wpsc_cart, $echo_to_screen, $purchase_log, $order_url; global $message_html, $cart, $errorcode,$wpsc_purchlog_statuses, $wpsc_gateways; $wpec_taxes_controller = new wpec_taxes_controller(); $is_transaction = false; $errorcode = 0; $purchase_log = $wpdb->get_row( "SELECT * FROM `" . WPSC_TABLE_PURCHASE_LOGS . "` WHERE `sessionid`= " . $sessionid . " LIMIT 1", ARRAY_A ); $order_status = $purchase_log['processed']; $curgateway = $purchase_log['gateway']; //new variable to check whether function is being called from resen_email if(isset($_GET['email_buyer_id'])) $resend_email = true; else $resend_email = false; if( !is_bool( $display_to_screen ) ) $display_to_screen = true; $echo_to_screen = $display_to_screen; if ( is_numeric( $sessionid ) ) { if ( $echo_to_screen ) echo apply_filters( 'wpsc_pre_transaction_results', '' ); // New code to check whether transaction is processed, true if accepted false if pending or incomplete $is_transaction = wpsc_check_purchase_processed($purchase_log['processed']); $message_html = $message = stripslashes( get_option( 'wpsc_email_receipt' ) ); if( $is_transaction ){ $message = __('The Transaction was successful', 'wpsc')."\r\n".$message; $message_html = __('The Transaction was successful', 'wpsc')."<br />".$message_html; } $country = get_option( 'country_form_field' ); $billing_country = ''; $shipping_country = ''; if ( !empty($purchase_log['shipping_country']) ) { $billing_country = $purchase_log['billing_country']; $shipping_country = $purchase_log['shipping_country']; } elseif ( !empty($country) ) { $country = $wpdb->get_var( "SELECT `value` FROM `" . WPSC_TABLE_SUBMITED_FORM_DATA . "` WHERE `log_id`=" . $purchase_log['id'] . " AND `form_id` = '" . get_option( 'country_form_field' ) . "' LIMIT 1" ); $billing_country = $country; $shipping_country = $country; } $email = wpsc_get_buyers_email($purchase_log['id']); $previous_download_ids = array( ); $product_list = $product_list_html = $report_product_list = ''; $cart = $wpdb->get_results( "SELECT * FROM `" . WPSC_TABLE_CART_CONTENTS . "` WHERE `purchaseid` = '{$purchase_log['id']}'" , ARRAY_A ); if ( ($cart != null) && ($errorcode == 0) ) { $total_shipping = ''; foreach ( $cart as $row ) { $link = array( ); $wpdb->update(WPSC_TABLE_DOWNLOAD_STATUS, array('active' => '1'), array('cartid' => $row['id'], 'purchid'=>$purchase_log['id']) ); do_action( 'wpsc_transaction_result_cart_item', array( "purchase_id" => $purchase_log['id'], "cart_item" => $row, "purchase_log" => $purchase_log ) ); if ( $is_transaction ) { $download_data = $wpdb->get_results( "SELECT * FROM `" . WPSC_TABLE_DOWNLOAD_STATUS . "` WHERE `active`='1' AND `purchid`='" . $purchase_log['id'] . "' AND `cartid` = '" . $row['id'] . "'", ARRAY_A ); if ( count( $download_data ) > 0 ) { foreach ( $download_data as $single_download ) { $file_data = get_post( $single_download['product_id'] ); // if the uniqueid is not equal to null, its "valid", regardless of what it is if ( $single_download['uniqueid'] == null ) $link[] = array( "url" => site_url( "?downloadid=" . $single_download['id'] ), "name" => $file_data->post_title ); else $link[] = array( "url" => site_url( "?downloadid=" . $single_download['uniqueid'] ), "name" => $file_data->post_title ); } } else { $order_status = $purchase_log['processed']; } if( isset( $download_data['id'] ) ) $previous_download_ids[] = $download_data['id']; } do_action( 'wpsc_confirm_checkout', $purchase_log['id'] ); $total = 0; $shipping = $row['pnp'] * $row['quantity']; $total_shipping += $shipping; $total += ( $row['price'] * $row['quantity']); $message_price = wpsc_currency_display( $total, array( 'display_as_html' => false ) ); $message_price_html = wpsc_currency_display( $total ); $shipping_price = wpsc_currency_display( $shipping, array( 'display_as_html' => false ) ); if ( isset( $purchase['gateway'] ) && 'wpsc_merchant_testmode' != $purchase['gateway'] ) { if ( $gateway['internalname'] == $purch_data[0]['gateway'] ) $gateway_name = $gateway['name']; } else { $gateway_name = "Manual Payment"; } $variation_list = ''; if ( !empty( $link ) ) { $additional_content = apply_filters( 'wpsc_transaction_result_content', array( "purchase_id" => $purchase_log['id'], "cart_item" => $row, "purchase_log" => $purchase_log ) ); if ( !is_string( $additional_content ) ) { $additional_content = ''; } $product_list .= " - " . $row['name'] . " " . $message_price . " " . __( 'Click to download', 'wpsc' ) . ":"; $product_list_html .= " - " . $row['name'] . " " . $message_price_html . "  " . __( 'Click to download', 'wpsc' ) . ":\n\r"; foreach ( $link as $single_link ) { $product_list .= "\n\r " . $single_link["name"] . ": " . $single_link["url"] . "\n\r"; $product_list_html .= "<a href='" . $single_link["url"] . "'>" . $single_link["name"] . "</a>\n"; } $product_list .= $additional_content; $product_list_html .= $additional_content; } else { $product_list.= " - " . $row['quantity'] . " " . $row['name'] . " " . $message_price . "\n\r"; if ( $shipping > 0 ) $product_list .= sprintf(__( ' - Shipping: %s ', 'wpsc' ), $shipping_price); $product_list_html.= "\n\r - " . $row['quantity'] . " " . $row['name'] . " " . $message_price_html . "\n\r"; if ( $shipping > 0 ) $product_list_html .= sprintf(__( '   Shipping: %s ', 'wpsc' ), $shipping_price); } //add tax if included if($wpec_taxes_controller->wpec_taxes_isenabled() && $wpec_taxes_controller->wpec_taxes_isincluded()) { $taxes_text = ' - - '.__('Tax Included', 'wpsc').': '.wpsc_currency_display( $row['tax_charged'], array( 'display_as_html' => false ) )."\n\r"; $taxes_text_html = ' - - '.__('Tax Included', 'wpsc').': '.wpsc_currency_display( $row['tax_charged'] ); $product_list .= $taxes_text; $product_list_html .= $taxes_text_html; }// if $report = get_option( 'wpsc_email_admin' ); $report_product_list.= " - " . $row['quantity'] . " " . $row['name'] . " " . $message_price . "\n\r"; } // closes foreach cart as row // Decrement the stock here if ( $is_transaction ) wpsc_decrement_claimed_stock( $purchase_log['id'] ); if ( !empty($purchase_log['discount_data'])) { $coupon_data = $wpdb->get_row( "SELECT * FROM `" . WPSC_TABLE_COUPON_CODES . "` WHERE coupon_code='" . $wpdb->escape( $purchase_log['discount_data'] ) . "' LIMIT 1", ARRAY_A ); if ( $coupon_data['use-once'] == 1 ) { $wpdb->update(WPSC_TABLE_COUPON_CODES, array('active' => '0', 'is-used' => '1'), array('id' => $coupon_data['id']) ); } } $total_shipping += $purchase_log['base_shipping']; $total = $purchase_log['totalprice']; $total_price_email = ''; $total_price_html = ''; $total_tax_html = ''; $total_tax = ''; $total_shipping_html = ''; $total_shipping_email = ''; if ( wpsc_uses_shipping() ) $total_shipping_email.= sprintf(__( 'Total Shipping: %s ', 'wpsc' ), wpsc_currency_display( $total_shipping, array( 'display_as_html' => false ) ) ); $total_price_email.= sprintf(__( 'Total: %s ', 'wpsc' ), wpsc_currency_display( $total, array( 'display_as_html' => false ) )); if ( $purchase_log['discount_value'] > 0 ) { $discount_email.= __( 'Discount', 'wpsc' ) . "\n\r: "; $discount_email .=$purchase_log['discount_data'] . ' : ' . wpsc_currency_display( $purchase_log['discount_value'], array( 'display_as_html' => false ) ) . "\n\r"; $report.= $discount_email . "\n\r"; $total_shipping_email .= $discount_email; $total_shipping_html.= __( 'Discount', 'wpsc' ) . ": " . wpsc_currency_display( $purchase_log['discount_value'] ) . "\n\r"; } //only show total tax if tax is not included if($wpec_taxes_controller->wpec_taxes_isenabled() && !$wpec_taxes_controller->wpec_taxes_isincluded()){ $total_tax_html .= __('Total Tax', 'wpsc').': '. wpsc_currency_display( $purchase_log['wpec_taxes_total'] )."\n\r"; $total_tax .= __('Total Tax', 'wpsc').': '. wpsc_currency_display( $purchase_log['wpec_taxes_total'] , array( 'display_as_html' => false ) )."\n\r"; } if ( wpsc_uses_shipping() ) $total_shipping_html.= sprintf(__( '<hr>Total Shipping: %s ', 'wpsc' ), wpsc_currency_display( $total_shipping )); $total_price_html.= sprintf(__( 'Total: %s ', 'wpsc' ), wpsc_currency_display( $total ) ); $report_id = sprintf(__("Purchase # %s ", 'wpsc'), $purchase_log['id']); if ( isset( $_GET['ti'] ) ) { $message.= "\n\r" . __( 'Your Transaction ID', 'wpsc' ) . ": " . $_GET['ti']; $message_html.= "\n\r" . __( 'Your Transaction ID', 'wpsc' ) . ": " . $_GET['ti']; $report.= "\n\r" . __( 'Transaction ID', 'wpsc' ) . ": " . $_GET['ti']; } $license = $wpdb->get_row("SELECT * FROM {$wpdb->prefix}license WHERE order_id = '".$purchase_log['id']."'"); $av = true; $related = unserialize($license->related_products); if(is_array($related) and count($related) > 0) { $av = false; $carti = $wpdb->get_row( "SELECT prodid FROM `" . WPSC_TABLE_CART_CONTENTS . "` WHERE `purchaseid` = '{$purchase_log['id']}' LIMIT 1" ); if(in_array($carti->prodid,$related)) $av = true; } if(empty($license->id) and $av == true){ $license = $wpdb->get_row("SELECT * FROM {$wpdb->prefix}license WHERE order_id = 0 ORDER BY RAND() LIMIT 1"); if($license->id) $wpdb->query("UPDATE {$wpdb->prefix}license SET order_id = '".$purchase_log['id']."', assigned_on = '".time()."' WHERE id = '".$license->id."'"); } $license_key = $license->license; $message = str_replace( '%purchase_id%', $report_id, $message ); $message = str_replace( '%product_list%', $product_list, $message ); $message = str_replace( '%total_tax%', $total_tax, $message ); $message = str_replace( '%total_shipping%', $total_shipping_email, $message ); $message = str_replace( '%total_price%', $total_price_email, $message ); $message = str_replace( '%shop_name%', get_option( 'blogname' ), $message ); $message = str_replace( '%find_us%', $purchase_log['find_us'], $message ); $message = str_replace( '%license_key%', $license_key, $message ); $report = str_replace( '%purchase_id%', $report_id, $report ); $report = str_replace( '%product_list%', $report_product_list, $report ); $report = str_replace( '%total_tax%', $total_tax, $report ); $report = str_replace( '%total_shipping%', $total_shipping_email, $report ); $report = str_replace( '%total_price%', $total_price_email, $report ); $report = str_replace( '%shop_name%', get_option( 'blogname' ), $report ); $report = str_replace( '%find_us%', $purchase_log['find_us'], $report ); $report = str_replace( '%license_key%', $license_key, $report ); $message_html = str_replace( '%purchase_id%', $report_id, $message_html ); $message_html = str_replace( '%product_list%', $product_list_html, $message_html ); $message_html = str_replace( '%total_tax%', $total_tax_html, $message_html ); $message_html = str_replace( '%total_shipping%', $total_shipping_html, $message_html ); $message_html = str_replace( '%total_price%', $total_price_html, $message_html ); $message_html = str_replace( '%shop_name%', get_option( 'blogname' ), $message_html ); $message_html = str_replace( '%find_us%', $purchase_log['find_us'], $message_html ); $message_html = str_replace( '%license_key%', $license_key, $message_html ); if ( !empty($email) ) { add_filter( 'wp_mail_from', 'wpsc_replace_reply_address', 0 ); add_filter( 'wp_mail_from_name', 'wpsc_replace_reply_name', 0 ); $message = apply_filters('wpsc_email_message', $message, $report_id, $product_list, $total_tax, $total_shipping_email, $total_price_email); if ( !$is_transaction ) { $payment_instructions = strip_tags( stripslashes( get_option( 'payment_instructions' ) ) ); if(!empty($payment_instructions)) $payment_instructions .= "\n\r"; $message = __( 'Thank you, your purchase is pending, you will be sent an email once the order clears.', 'wpsc' ) . "\n\r" . $payment_instructions . $message; $message_html = __( 'Thank you, your purchase is pending, you will be sent an email once the order clears.', 'wpsc' ) . "\n\r" . $payment_instructions . $message_html; // prevent email duplicates if ( ! get_transient( "{$sessionid}_pending_email_sent" ) ) { wp_mail( $email, __( 'Order Pending: Payment Required', 'wpsc' ), $message ); set_transient( "{$sessionid}_pending_email_sent", true, 60 * 60 * 12 ); } } elseif ( ! get_transient( "{$sessionid}_receipt_email_sent" ) ) { wp_mail( $email, __( 'Purchase Receipt', 'wpsc' ), $message ); set_transient( "{$sessionid}_receipt_email_sent", true, 60 * 60 * 12 ); } } remove_filter( 'wp_mail_from_name', 'wpsc_replace_reply_name' ); remove_filter( 'wp_mail_from', 'wpsc_replace_reply_address' ); $report_user = __( 'Customer Details', 'wpsc' ) . "\n\r"; $form_sql = "SELECT * FROM `" . WPSC_TABLE_SUBMITED_FORM_DATA . "` WHERE `log_id` = '" . $purchase_log['id'] . "'"; $form_data = $wpdb->get_results( $form_sql, ARRAY_A ); if ( $form_data != null ) { foreach ( $form_data as $form_field ) { $form_data = $wpdb->get_row( "SELECT * FROM `" . WPSC_TABLE_CHECKOUT_FORMS . "` WHERE `id` = '" . $form_field['form_id'] . "' LIMIT 1", ARRAY_A ); switch ( $form_data['type'] ) { case "country": $country_code = $form_field['value']; $report_user .= $form_data['name'] . ": " . wpsc_get_country( $country_code ) . "\n"; //check if country has a state then display if it does. $country_data = wpsc_country_has_state($country_code); if(($country_data['has_regions'] == 1)) $report_user .= __( 'Billing State', 'wpsc' ) . ": " . wpsc_get_region( $purchase_log['billing_region'] ) . "\n"; break; case "delivery_country": $report_user .= $form_data['name'] . ": " . wpsc_get_country( $form_field['value'] ) . "\n"; break; default: if ($form_data['name'] == 'State' && is_numeric($form_field['value'])){ $report_user .= __( 'Delivery State', 'wpsc' ) . ": " . wpsc_get_state_by_id( $form_field['value'], 'name' ) . "\n"; }else{ $report_user .= wp_kses( $form_data['name'], array( ) ) . ": " . $form_field['value'] . "\n"; } break; } } } $report_user .= "\n\r"; $report = $report_id . $report_user . $report; //echo '======REPORT======<br />'.$report.'<br />'; //echo '======EMAIL======<br />'.$message.'<br />'; if ( (get_option( 'purch_log_email' ) != null) && ( $purchase_log['email_sent'] != 1 ) ){ wp_mail( get_option( 'purch_log_email' ), __( 'Purchase Report', 'wpsc' ), $report ); $wpdb->update(WPSC_TABLE_PURCHASE_LOGS, array('email_sent' => '1'), array( 'sessionid' => $sessionid ) ); } /// Adjust stock and empty the cart $wpsc_cart->submit_stock_claims( $purchase_log['id'] ); $wpsc_cart->empty_cart(); } } } ?>

2012-06-15 by user

Answers (2)

2012-06-16

Arnav Joy answers:

I think following lines are responsible for selecting key

if(empty($license->id) and $av == true){ $license = $wpdb->get_row("SELECT * FROM {$wpdb->prefix}license WHERE order_id = 0 ORDER BY RAND() LIMIT 1"); if($license->id) $wpdb->query("UPDATE {$wpdb->prefix}license SET order_id = '".$purchase_log['id']."', assigned_on = '".time()."' WHERE id = '".$license->id."'"); }

can you provide me access to your site?

2012-06-17

Just Me answers:

Yes, I think that is the problem. There is a selection for order_ID is zero, which means it has not been used. But then it says random() which means it will not check if the license key is related to the product.

I am not sure if there is a setting anywhere that would make it work. Did you contact the developer of the plugin?

user comments:

Hi, yes I have contacted the developer but he unfortunately didn't answer.

Just Me comments:

It sometimes helps to donate a few bugs to the developer but then again if he has given up on the project then it is money lost.

Someone will have to get access to your wp-admin.
I'd be able to do it but, someone else already offered so I guess you are working with him.