Jump to content

mommaroodles

♥Ambassador
  • Content count

    183
  • Joined

  • Last visited

  • Days Won

    2

Everything posted by mommaroodles

  1. mommaroodles

    RMA Returns error for 2.2 MS2

    @@markg-uk - why dont you post the returns.php file - unless you have this sorted out now.
  2. mommaroodles

    Braintree Test Credit Cards not working

    I've set up a Sandbox Environment and am using the test values which can be found here. developers.braintreepayments.com/ios+ruby/reference/general/testing#credit-card-numbers I performed a test purchases but despite me using the correct values as found at the link above - I kept on getting errors. The cart total was $10 500.00 - I used the 4111111111111111 visa card number -The expiry date is a future date (2016) and I've disabled the verification by cvv just to simply matters The error messages were saying that it was a card error. No matter what card number I use and amount which is supposed to give me a successful authorisation - ($0.01 - $1999.99 and $3001.00+) it just doesnt go through. In the sandbox area - all other features are disabled besides the paypal which enabled by default. Any ideas ??
  3. mommaroodles

    osCommerce Online Merchant v2.3.3.4

    another thing I've noticed is the inconsistency of the indexes in the oscommerce.sql file. it would appear that the naming convention for the indexes is "idx_table_name_column_name" and all in lowercase, however there are some which are just the idx_column_name and then some that are in uppercase. take this for example: DROP TABLE IF EXISTS action_recorder; CREATE TABLE action_recorder ( id int NOT NULL auto_increment, module varchar(255) NOT NULL, user_id int, user_name varchar(255), identifier varchar(255) NOT NULL, success char(1), date_added datetime NOT NULL, PRIMARY KEY (id), KEY idx_action_recorder_module (module), KEY idx_action_recorder_user_id (user_id), KEY idx_action_recorder_identifier (identifier), KEY idx_action_recorder_date_added (date_added) ) CHARACTER SET utf8 COLLATE utf8_unicode_ci; in the above we can see idx_tablename_columnname below we have idx_columname DROP TABLE IF EXISTS banners; CREATE TABLE banners ( banners_id int NOT NULL auto_increment, banners_title varchar(64) NOT NULL, banners_url varchar(255) NOT NULL, banners_image varchar(64) NOT NULL, banners_group varchar(10) NOT NULL, banners_html_text text, expires_impressions int(7) DEFAULT '0', expires_date datetime DEFAULT NULL, date_scheduled datetime DEFAULT NULL, date_added datetime NOT NULL, date_status_change datetime DEFAULT NULL, status int(1) DEFAULT '1' NOT NULL, PRIMARY KEY (banners_id), KEY idx_banners_group (banners_group) ) CHARACTER SET utf8 COLLATE utf8_unicode_ci; and even in uppercase - a few tables DROP TABLE IF EXISTS countries; CREATE TABLE countries ( countries_id int NOT NULL auto_increment, countries_name varchar(255) NOT NULL, countries_iso_code_2 char(2) NOT NULL, countries_iso_code_3 char(3) NOT NULL, address_format_id int NOT NULL, PRIMARY KEY (countries_id), KEY IDX_COUNTRIES_NAME (countries_name) ) CHARACTER SET utf8 COLLATE utf8_unicode_ci; so its very apparent that there doesnt seem to be a set standard and it's def not following any form of 'best practice'
  4. mommaroodles

    osCommerce Online Merchant v2.3.3.4

    they havent been responding to any tickets now for sometime nor do they respond to comments left on their facebook page. The last template I bought from them was very disappointing to say the least. I used them quite often over the years and I wont be using them any longer.
  5. mommaroodles

    jQuery/Ajax Shopping Cart

    @@Dr. Rolex thank you very much, I'll try that and let you know how it pans out :thumbsup:
  6. mommaroodles

    Credit Class & Gift Vouchers for 2.3.4

    Please note: I have not updated the installation instructions, I simply just dont have the time at the moment - the files uploaded in the latest package are all the correct files.
  7. mommaroodles

    Credit Class & Gift Vouchers for 2.3.4

    the order total must be more than the gift voucher amount - thats just the way it is code to work so as not to leave credit balances - but if you want to let you customers have credit balances then you can modify the code to suit your store
  8. mommaroodles

    Credit Class & Gift Vouchers for 2.3.4

    @@Spiceupyour I've sent you a message telling you what to do and you havent responded yet - as i said to you, I have checked this on my installation and it works, so please read the instructions and check your settings again
  9. mommaroodles

    Credit Class & Gift Vouchers for 2.3.4

    @@Spiceupyour Replace your ot_gv.php file with this <?php /* $Id: ot_gv.php,v 1.37.3 2004/01/01 12:52:59 Strider Exp $ $Id: ot_gv.php,v 1.4.2.12 2003/05/14 22:52:59 wilt Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2002 osCommerce Released under the GNU General Public License */ class ot_gv { var $title, $output; function ot_gv() { $this->code = 'ot_gv'; $this->title = MODULE_ORDER_TOTAL_GV_TITLE; $this->header = MODULE_ORDER_TOTAL_GV_HEADER; $this->description = MODULE_ORDER_TOTAL_GV_DESCRIPTION; $this->user_prompt = MODULE_ORDER_TOTAL_GV_USER_PROMPT; $this->enabled = MODULE_ORDER_TOTAL_GV_STATUS; $this->sort_order = MODULE_ORDER_TOTAL_GV_SORT_ORDER; $this->include_shipping = MODULE_ORDER_TOTAL_GV_INC_SHIPPING; $this->include_tax = MODULE_ORDER_TOTAL_GV_INC_TAX; $this->calculate_tax = MODULE_ORDER_TOTAL_GV_CALC_TAX; $this->credit_tax = MODULE_ORDER_TOTAL_GV_CREDIT_TAX; $this->tax_class = MODULE_ORDER_TOTAL_GV_TAX_CLASS; $this->show_redeem_box = MODULE_ORDER_TOTAL_GV_REDEEM_BOX; $this->credit_class = true; $this->checkbox = $this->user_prompt . '<input type="checkbox" onclick="submitFunction()" name="' . 'c' . $this->code . '">'; $this->output = array(); } function process() { global $order, $currencies, $cot_gv; // if ($_SESSION['cot_gv']) { // old code Strider if (tep_session_is_registered('cot_gv')) { $order_total = $this->get_order_total(); $od_amount = $this->calculate_credit($order_total); if ($this->calculate_tax != "None") { $tod_amount = $this->calculate_tax_deduction($order_total, $od_amount, $this->calculate_tax); $od_amount = $this->calculate_credit($order_total); } $this->deduction = $od_amount; // if (($this->calculate_tax == "Credit Note") && (DISPLAY_PRICE_WITH_TAX != 'true')) { // $od_amount -= $tod_amount; // $order->info['total'] -= $tod_amount; // } $order->info['total'] = $order->info['total'] - $od_amount; if ($od_amount > 0) { $this->output[] = array('title' => $this->title . ':', 'text' => ' -' . $currencies->format($od_amount) . '', 'value' => $od_amount); } } } function selection_test() { global $customer_id; if ($this->user_has_gv_account($customer_id)) { return true; } else { return false; } } function pre_confirmation_check($order_total) { global $cot_gv, $order; // if ($_SESSION['cot_gv']) { // old code Strider $od_amount = 0; // set the default amount we will send back if (tep_session_is_registered('cot_gv')) { // pre confirmation check doesn't do a true order process. It just attempts to see if // there is enough to handle the order. But depending on settings it will not be shown // all of the order so this is why we do this runaround jane. What do we know so far. // nothing. Since we need to know if we process the full amount we need to call get order total // if there has been something before us then if ($this->include_tax == 'false') { $order_total = $order_total - $order->info['tax']; } if ($this->include_shipping == 'false') { $order_total = $order_total - $order->info['shipping_cost']; } $od_amount = $this->calculate_credit($order_total); if ($this->calculate_tax != "None") { $tod_amount = $this->calculate_tax_deduction($order_total, $od_amount, $this->calculate_tax); $od_amount = $this->calculate_credit($order_total)+$tod_amount; } } return $od_amount; } // original code /*function pre_confirmation_check($order_total) { if ($SESSION['cot_gv']) { $gv_payment_amount = $this->calculate_credit($order_total); } return $gv_payment_amount; } */ function use_credit_amount() { global $cot_gv; // $_SESSION['cot_gv'] = false; // old code - Strider $cot_gv = false; if ($this->selection_test()) { $output_string .= '<td align="right" class="main">'; $output_string .= '<b>' . $this->checkbox . '</b>' . '</td>' . "\n"; } return $output_string; } function update_credit_account($i) { global $order, $customer_id, $insert_id, $REMOTE_ADDR; if (preg_match('/^GIFT/', addslashes($order->products[$i]['model']))) { $gv_order_amount = ($order->products[$i]['final_price'] * $order->products[$i]['qty']); if ($this->credit_tax=='true') $gv_order_amount = $gv_order_amount * (100 + $order->products[$i]['tax']) / 100; // $gv_order_amount += 0.001; $gv_order_amount = $gv_order_amount * 100 / 100; if (MODULE_ORDER_TOTAL_GV_QUEUE == 'false') { // GV_QUEUE is true so release amount to account immediately $gv_query=tep_db_query("select amount from " . TABLE_COUPON_GV_CUSTOMER . " where customer_id = '" . (int)$customer_id . "'"); $customer_gv = false; $total_gv_amount = 0; if ($gv_result = tep_db_fetch_array($gv_query)) { $total_gv_amount = $gv_result['amount']; $customer_gv = true; } $total_gv_amount = $total_gv_amount + $gv_order_amount; if ($customer_gv) { $gv_update=tep_db_query("update " . TABLE_COUPON_GV_CUSTOMER . " set amount = '" . $total_gv_amount . "' where customer_id = '" . (int)$customer_id . "'"); } else { $gv_insert=tep_db_query("insert into " . TABLE_COUPON_GV_CUSTOMER . " (customer_id, amount) values ('" . $customer_id . "', '" . $total_gv_amount . "')"); } } else { // GV_QUEUE is true - so queue the gv for release by store owner $gv_insert=tep_db_query("insert into " . TABLE_COUPON_GV_QUEUE . " (customer_id, order_id, amount, date_created, ipaddr) values ('" . $customer_id . "', '" . $insert_id . "', '" . $gv_order_amount . "', NOW(), '" . $REMOTE_ADDR . "')"); } } } function credit_selection() { global $customer_id, $currencies, $language; $selection_string = ''; $gv_query = tep_db_query("select coupon_id from " . TABLE_COUPONS . " where coupon_type = 'G' and coupon_active='Y'"); if (tep_db_num_rows($gv_query)) { $selection_string .= '<tr>' . "\n"; $selection_string .= ' <td width="10">' . tep_draw_separator('pixel_trans.gif', '10', '1') .'</td>'; $selection_string .= ' <td class="main">' . "\n"; $image_submit = '<input type="image" name="submit_redeem" onClick="submitFunction()" src="' . DIR_WS_LANGUAGES . $language . '/images/buttons/button_redeem.gif" border="0" alt="' . IMAGE_REDEEM_VOUCHER . '" title = "' . IMAGE_REDEEM_VOUCHER . '">'; $selection_string .= TEXT_ENTER_GV_CODE . tep_draw_input_field('gv_redeem_code') . '</td>'; $selection_string .= ' <td align="right">' . $image_submit . '</td>'; $selection_string .= ' <td width="10">' . tep_draw_separator('pixel_trans.gif', '10', '1') . '</td>'; $selection_string .= '</tr>' . "\n"; } return $selection_string; } function apply_credit() { global $order, $customer_id, $coupon_no, $cot_gv; if (tep_session_is_registered('cot_gv')) { $gv_query = tep_db_query("select amount from " . TABLE_COUPON_GV_CUSTOMER . " where customer_id = '" . (int)$customer_id . "'"); $gv_result = tep_db_fetch_array($gv_query); $gv_payment_amount = $this->deduction; $gv_amount = $gv_result['amount'] - $gv_payment_amount; $gv_update = tep_db_query("update " . TABLE_COUPON_GV_CUSTOMER . " set amount = '" . $gv_amount . "' where customer_id = '" . (int)$customer_id . "'"); } return $gv_payment_amount; } function collect_posts() { global $currencies, $_POST, $customer_id, $coupon_no, $REMOTE_ADDR; if ($_POST['gv_redeem_code']) { $gv_query = tep_db_query("select coupon_id, coupon_type, coupon_amount from " . TABLE_COUPONS . " where coupon_code = '" . $_POST['gv_redeem_code'] . "'"); $gv_result = tep_db_fetch_array($gv_query); if (tep_db_num_rows($gv_query) != 0) { $redeem_query = tep_db_query("select * from " . TABLE_COUPON_REDEEM_TRACK . " where coupon_id = '" . $gv_result['coupon_id'] . "'"); if ( (tep_db_num_rows($redeem_query) != 0) && ($gv_result['coupon_type'] == 'G') ) { tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, 'error_message=' . urlencode(ERROR_NO_INVALID_REDEEM_GV), 'SSL')); } } if ($gv_result['coupon_type'] == 'G') { $gv_amount = $gv_result['coupon_amount']; // Things to set // ip address of claimant // customer id of claimant // date // redemption flag // now update customer account with gv_amount $gv_amount_query=tep_db_query("select amount from " . TABLE_COUPON_GV_CUSTOMER . " where customer_id = '" . (int)$customer_id . "'"); $customer_gv = false; $total_gv_amount = $gv_amount;; if ($gv_amount_result = tep_db_fetch_array($gv_amount_query)) { $total_gv_amount = $gv_amount_result['amount'] + $gv_amount; $customer_gv = true; } $gv_update = tep_db_query("update " . TABLE_COUPONS . " set coupon_active = 'N' where coupon_id = '" . $gv_result['coupon_id'] . "'"); $gv_redeem = tep_db_query("insert into " . TABLE_COUPON_REDEEM_TRACK . " (coupon_id, customer_id, redeem_date, redeem_ip) values ('" . $gv_result['coupon_id'] . "', '" . $customer_id . "', now(),'" . $REMOTE_ADDR . "')"); if ($customer_gv) { // already has gv_amount so update $gv_update = tep_db_query("update " . TABLE_COUPON_GV_CUSTOMER . " set amount = '" . $total_gv_amount . "' where customer_id = '" . (int)$customer_id . "'"); } else { // no gv_amount so insert $gv_insert = tep_db_query("insert into " . TABLE_COUPON_GV_CUSTOMER . " (customer_id, amount) values ('" . $customer_id . "', '" . $total_gv_amount . "')"); } tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, 'error_message=' . urlencode(ERROR_REDEEMED_AMOUNT. $currencies->format($gv_amount)), 'SSL')); } } if ($_POST['submit_redeem_x'] && $gv_result['coupon_type'] == 'G') tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, 'error_message=' . urlencode(ERROR_NO_REDEEM_CODE), 'SSL')); } function calculate_credit($amount) { global $customer_id, $order; $gv_query=tep_db_query("select amount from " . TABLE_COUPON_GV_CUSTOMER . " where customer_id = '" . (int)$customer_id . "'"); $gv_result=tep_db_fetch_array($gv_query); $gv_payment_amount = $gv_result['amount']; $gv_amount = $gv_payment_amount; $save_total_cost = $amount; $full_cost = $save_total_cost - $gv_payment_amount; if ($full_cost <= 0) { $full_cost = 0; $gv_payment_amount = $save_total_cost; } return tep_round($gv_payment_amount,2); } function calculate_tax_deduction($amount, $od_amount, $method) { global $order; switch ($method) { case 'Standard': $ratio1 = tep_round($od_amount / $amount,2); $tod_amount = 0; reset($order->info['tax_groups']); while (list($key, $value) = each($order->info['tax_groups'])) { $tax_rate = tep_get_tax_rate_from_desc($key); $total_net += $tax_rate * $order->info['tax_groups'][$key]; } if ($od_amount > $total_net) $od_amount = $total_net; reset($order->info['tax_groups']); while (list($key, $value) = each($order->info['tax_groups'])) { $tax_rate = tep_get_tax_rate_from_desc($key); $net = $tax_rate * $order->info['tax_groups'][$key]; if ($net > 0) { $god_amount = $order->info['tax_groups'][$key] * $ratio1; $tod_amount += $god_amount; $order->info['tax_groups'][$key] = $order->info['tax_groups'][$key] - $god_amount; } } $order->info['tax'] -= $tod_amount; $order->info['total'] -= $tod_amount; break; case 'Credit Note': $tax_rate = tep_get_tax_rate($this->tax_class, $order->delivery['country']['id'], $order->delivery['zone_id']); $tax_desc = tep_get_tax_description($this->tax_class, $order->delivery['country']['id'], $order->delivery['zone_id']); $tod_amount = $this->deduction / (100 + $tax_rate)* $tax_rate; $order->info['tax_groups'][$tax_desc] -= $tod_amount; // $order->info['total'] -= $tod_amount; //// ????? Strider break; default: } return $tod_amount; } function user_has_gv_account($c_id) { $gv_query = tep_db_query("select amount from " . TABLE_COUPON_GV_CUSTOMER . " where customer_id = '" . $c_id . "'"); if ($gv_result = tep_db_fetch_array($gv_query)) { if ($gv_result['amount']>0) { return true; } } return false; } function get_order_total() { global $order; $order_total = $order->info['total']; if ($this->include_tax == 'false') $order_total = $order_total - $order->info['tax']; if ($this->include_shipping == 'false') $order_total = $order_total - $order->info['shipping_cost']; return $order_total; } function check() { if (!isset($this->check)) { $check_query = tep_db_query("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_ORDER_TOTAL_GV_STATUS'"); $this->check = tep_db_num_rows($check_query); } return $this->check; } function keys() { return array('MODULE_ORDER_TOTAL_GV_STATUS', 'MODULE_ORDER_TOTAL_GV_SORT_ORDER', 'MODULE_ORDER_TOTAL_GV_QUEUE', 'MODULE_ORDER_TOTAL_GV_INC_SHIPPING', 'MODULE_ORDER_TOTAL_GV_INC_TAX', 'MODULE_ORDER_TOTAL_GV_CALC_TAX', 'MODULE_ORDER_TOTAL_GV_TAX_CLASS', 'MODULE_ORDER_TOTAL_GV_CREDIT_TAX'); } function install() { tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Display Total', 'MODULE_ORDER_TOTAL_GV_STATUS', 'true', 'Do you want to display the Gift Voucher value?', '6', '1','tep_cfg_select_option(array(\'true\', \'false\'), ', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Sort Order', 'MODULE_ORDER_TOTAL_GV_SORT_ORDER', '5', 'Sort order of display.', '6', '2', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Queue Purchases', 'MODULE_ORDER_TOTAL_GV_QUEUE', 'true', 'Do you want to queue purchases of the Gift Voucher?', '6', '3','tep_cfg_select_option(array(\'true\', \'false\'), ', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function ,date_added) values ('Include Shipping', 'MODULE_ORDER_TOTAL_GV_INC_SHIPPING', 'false', 'Include Shipping in calculation', '6', '5', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function ,date_added) values ('Include Tax', 'MODULE_ORDER_TOTAL_GV_INC_TAX', 'true', 'Include Tax in calculation.', '6', '6','tep_cfg_select_option(array(\'true\', \'false\'), ', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function ,date_added) values ('Re-calculate Tax', 'MODULE_ORDER_TOTAL_GV_CALC_TAX', 'None', 'Re-Calculate Tax', '6', '7','tep_cfg_select_option(array(\'None\', \'Standard\', \'Credit Note\'), ', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) values ('Tax Class', 'MODULE_ORDER_TOTAL_GV_TAX_CLASS', '0', 'Use the following tax class when treating Gift Voucher as Credit Note.', '6', '0', 'tep_get_tax_class_title', 'tep_cfg_pull_down_tax_classes(', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function ,date_added) values ('Credit including Tax', 'MODULE_ORDER_TOTAL_GV_CREDIT_TAX', 'false', 'Add tax to purchased Gift Voucher when crediting to Account', '6', '8','tep_cfg_select_option(array(\'true\', \'false\'), ', now())"); } function remove() { tep_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key in ('" . implode("', '", $this->keys()) . "')"); } } ?>
  10. mommaroodles

    Credit Class & Gift Vouchers for 2.3.4

    @@nikko50 You've added a product with the model number GIFT25 and gave it a weight of 0. This means that you now have a gift voucher to the value of $25 which you have made available for customers to buy.That gift voucher appears under your products in admin and under categories on the front end Now once a customer buys the gift voucher, one of two things can happen, he/she can use that against another purchase, they will be able to use the whole $25 or part there of - or they can email the gift voucher to a friend who then will have to come and register at the site and buy something in order to use it. Only once you have sold the gift voucher to a customer does it appear in the gift voucher queue in admin, you then physically have to make it available for the customer to use by clicking the release button. it was setup like this to prevent fraud -you release the gift voucher once you have received the payment for it. Once you have released the gift voucher it disappears from the queue and for the customer, when he logs in again - he will see 1) in the shopping cart box - a note to tell him he has a gift voucher of R25.00 to use or to email to a friend, 2) in his account area - customer is also notified.
  11. mommaroodles

    jQuery/Ajax Shopping Cart

    @@Patty No I didnt and no js errors either
  12. mommaroodles

    Credit Class & Gift Vouchers for 2.3.4

    There isnt an ot_coupon_admin.php file in the package, your file is most likely from some other contribution.
  13. mommaroodles

    jQuery/Ajax Shopping Cart

    @@Dr. Rolex I've installed this mod onto a clean oscommerce 2.3.4 install and everything works well, I've checked with IE 11, Chrome, Safari, Opera and Firefox and all seems fine - I'm not really bothered with IE and below. But I am finding it quite taxing add the code to the modules. Please could you have a look at this code and give me advice on how and where to add your code, I'm really struggling with this :( I'd really appreciate this very much <?php /* * $Id$ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2010 osCommerce Released under the GNU General Public License */ if ((! isset ( $new_products_category_id )) || ($new_products_category_id == '0')) { $new_products_query = tep_db_query ( "select p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_featured = '1' and p.products_id = pd.products_id and pd.language_id = '" . ( int ) $languages_id . "' order by RAND() limit " . MAX_DISPLAY_NEW_PRODUCTS ); } else { $new_products_query = tep_db_query ( "select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . ( int ) $new_products_category_id . "' and p.products_status = '1' and p.products_featured = '1' and p.products_id = pd.products_id and pd.language_id = '" . ( int ) $languages_id . "' order by RAND() limit " . MAX_DISPLAY_NEW_PRODUCTS ); } $num_new_products = tep_db_num_rows ( $new_products_query ); if ($num_new_products > 0) { $counter = 0; $col = 0; $new_prods_content = '<div class="grid-100 grid-parent">'; while ( $new_products = tep_db_fetch_array ( $new_products_query ) ) { $counter ++; if ($col === 0) { $new_prods_content .= '<div class="grid-33 mobile-grid-100 tablet-grid-33">'; } $new_prods_content .= '<div class="border grid-100 mobile-grid-100"> <div class="grid-100 mobile-grid-100" style="text-align:center"> <div class="product_name box mobile-grid-100"> <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id'] ) . '">' . $new_products['products_name'] . '</a> </div> <div class="product_img box mobile-grid-100"> ' . tep_image_cdn(DIR_WS_IMAGES_CDN . $new_products ['products_image'], $new_products['products_name'],SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . ' </div> </div> <div class="grid-100 mobile-grid-100 tablet-grid-100"> <div class="product_price box grid-50 mobile-grid-100 tablet-grid-50"> <div class="prodprice mobile-grid-100 tablet-grid-50"> ' . $currencies->display_price ( $new_products['products_price'], tep_get_tax_rate ( $new_products['products_tax_class_id'] ) ) . ' </div> </div> <div class="product_more_info box grid-50 mobile-grid-100 tablet-grid-50"> <div class="moreinfo mobile-grid-100 tablet-grid-50"> <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id'] ) . '">' . READ_MORE . '</a> </div> </div> </div> </div>'; $col ++; if (($col > 0) || ($counter == $num_new_products)) { $new_prods_content .= '</div>'; $col = 0; } } $new_prods_content .= '</div>'; ?> <div class="contentText"> <?php echo $new_prods_content; ?> </div> <?php } ?>
  14. mommaroodles

    Credit Class & Gift Vouchers for 2.3.4

    @@Spiceupyour what exactly did you do or was it that I didnt do - I'd like to check this and make the necessary changes :)
  15. mommaroodles

    [Contribution] Discount Coupon Codes

    I got this module installed (one by greasemonkey) with the one page checkout v2 (http://addons.oscommerce.com/info/7993) by Web Source 5 and everything is working Ok except payment modules - I'm wondering if there is anyone else perhaps tried these two and got it working 100% the payment modules, I'm battling with is he Purchase Order and the eWaypayment module. for the life of me I cannot find the errors! :blush:
  16. mommaroodles

    Superfish and jquery 1.11.1

    @@greasemonkey I am using superfish menu with jquery 2.1.1 - Unless you using the mega menu you dont need hoverIntent. In actual fact you dont need jquery at all - the superfish menu works perfectly just with css. I've even made the superfish menu responsive
  17. mommaroodles

    Credit Class & Gift Vouchers for 2.3.4

    @@Spiceupyour let me know if you find any errors - if there is anything it will more than likely be with the customer mailing gift vouchers to some other person. I tested the discount coupon codes but didnt really go into the voucher side of things - they did work last time i checked. I've also improved the verbage in the emails sent to customers - I didnt change it too radically - just the basics
  18. mommaroodles

    Credit Class & Gift Vouchers for 2.3.4

    I have uploaded a much improved version of the CCGV for osCommerce 2.3.4 - I have tested it too on osCommerce 2.3.4 but not totally thoroughly. You should test the gift vouchers first. Fixes and improvements include the following. Coupon Admin now uses the jQuery date picker to select the start and expiry dates of the coupons. coupon_admin.php file has been cleaned up and a lot of unnecessary code has been removed. When mailing a Gift Voucher, the data is correctly inserted into the database and you can see to whom you have mailed gift vouchers too when clicking on the "Gift Vouchers Sent" link All the buttons are also jQuery buttons. You can set a discount coupon "Active" or "Inactive" CCGV now has its own link and settings in the Configuration tab. You can also set the length of the auto generated coupon code and gift voucher code in admin. The content which was in the add_ccgvdc_application_top.php in both catalog and admin have been moved to their correct respective files. The content which was in the add_ccgvdc_english.php in both catalog and admin have been moved to their correct respective files. The ot_coupon.php and the ot_gv.php files have correct settings, once the order totals have been installed you don't need to change them but you will need to change the rest of the order total modules. $HTTP_GET_VARS $HTTP_POST_VARS have been changed to $_GET and $_POST You can get the package here http://addons.oscommerce.com/info/9020
  19. @@Dr. Rolex I'm just wondering if I am missing something here regarding the operation of the Calculate Orders Totals - I select 2 or 3 items, click on Calculate Orders Total and then nothing appears, Without anything selected I get a popup saying the totals are 0
  20. The fix you provided for the js file, must have fixed this issue too, because the order is expanding now. Just one last quick question? I've obviously upgraded from the Rev2 - (btw the tep_count_modules function was in the general.php file from Rev2) - which of the files from Rev 2 can are not being used and can be deleted.? I'm assuming the create_order.php and create_order_process.php but can the following files be deleted too? oc_batch_delete_confirm.php oc_batch_delete.php order_handler.php order_poller.php orders_ajax.php Once again, thank you for your support and for making this wonderful addon. Melanie
  21. Thank You Dr rolex - I applied the changes and so far it's all good - it also fixed the issue I was experiencing when I clicked the "expand order" link :)
  22. is there not perhaps something on this line 111 of edit_orders.php ? <td class="main"><span><?php echo tep_cfg_pull_down_payment($order -> info['payment_method'], 'id="payment_method_pull_down" class="multiselect btn btn-xs btn-info" data-table="orders" data-field="payment_method"', $custom); ?></span></td>
  23. then another issue I have (and for the life of me cannot find where to edit this) is I have the pruchase order payment module installed. If I use the edit "Edit Orders" link - I have an error with the Purchase Order payment module - the small drop down You can see the error if you view the source - see lines 1 and 4 - the purchase order payment module is reflecting twice <option value="["_custom","Purchase Order <span class=\"smal"]">Purchase Order <span class="smal</option> <option value="["cod","Cash on Delivery"]">Cash on Delivery</option> <option value="["paypal_express","PayPal Express Checkout"]">PayPal Express Checkout</option> <option value="["po","Purchase Order"]">Purchase Order</option> <option value="["_manual",""]">Manual Input</option> I think what it's doing is getting confused with the modules public_title and title. - some payment modules have a public_title which appears on the front end and the title which just appears in admin, some modules only have title and no public_title The function_selection() in the payment modules: You'll find some have function selection() { return array('id' => $this->code, 'module' => $this->title); } and function selection() { return array('id' => $this->code, 'module' => $this->public_title); }
  24. Hi Dr Rolex just installed your Rev 3.1 version and just thought I'd point out the following error message I get. 1.) In order_handler/general_functions.php - I had to comment out the tep_count_modules function - previously declared in admin/includes/functions/general.php /* * commented out function - previously declared in general.php line 1374 * function tep_count_modules($modules = '') { $count = 0; if (empty($modules)) return $count; $modules_array = explode(';', $modules); for ($i=0, $n=sizeof($modules_array); $i<$n; $i++) { $class = substr($modules_array[$i], 0, strrpos($modules_array[$i], '.')); if (isset($GLOBALS[$class]) && is_object($GLOBALS[$class])) { if ($GLOBALS[$class]->enabled) { $count++; } } } return $count; } function tep_count_payment_modules() { return tep_count_modules(MODULE_PAYMENT_INSTALLED); } function tep_count_shipping_modules() { return tep_count_modules(MODULE_SHIPPING_INSTALLED); } */ I find that if I expand the order - I get a modal popup which says "An error occured while communicating to the server." - Any Ideas??
  25. Not sure if anyone else has picked up this bug but get error message when creating a new order Parse error: syntax error, unexpected '[' in /home/xxx/public_html/xxx/xxxxx/create_order_process.php on line 56 Line 56 and line 61 have errors $payment_method = $payment_modules->selection()[0]['module']; // load the selected shipping module require(DIR_WS_CLASSES . 'shipping.php'); $shipping_modules = new shipping($shipping_method); $shipping_cost = $shipping_modules->quote($shipping_method)[0]['methods'][0]['cost'];
×