herbsandhelpers

Hello, Been trying to make this work on Frozen CE php 7.2 with Raiwa modular checkout. No problem installing and getting responses e.g. missing values etc. However running as sandbox with the test card nothing happens pressing confirm button. Pressing finalise button just seems to bypass, confirming order but no payment. Tried the recommended solutions above again nothing don’t seem to get a working button, no call to Square made. I am wondering what people have as the callback url in square? Couldn’t really work out what to put? Any help appreciated just so frustrating getting no where and not knowing why. Lorraine

I couldn't find anything similar in Add Ons that's why I persisted with altering the above module, it does work, although I'm not a coder so would appreciate an expert eye. I did look at the link you posted and one of the comments was that someone was unable to get it to work, which doesn't fill with confidence. I think for now I'll stick with what I've got, although if yours becomes an official add on I may give it a try. Lorraine

Doooh! Can you post the Add On link please ... Lorraine

Hello, Just moved to 2.3.4 BS GOLD and needed to carry on using this excellent contrib. Admin side worked fine along with assistance posted here, however getting the tabs to show shop side failed. I'm not a coder but I've just spent many hours altering the products_tabs.php module to work and show tabs again. I used a lot of help from here: http://forums.oscommerce.com/topic/398352-234bs-tabs-in-product-info/ If it will help anyone then please find the adjusted module below. You can remove the 'brand/image bit' if you prefer. Please note I'm not a coder so an expert eye would be helpful. Lorraine <?php /* $Id$ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2010 osCommerce Released under the GNU General Public License */ ?> <script type="text/javascript"> $(function() { $( "#tabs" ).tabs(); }); </script> <nav class="navbar navbar-default"> <div class="container-fluid"> <div class="navbar-header"> <a class="navbar-brand" href="#"> <img alt="Brand" src="images/QELICON.png"> </a> <!-- Nav tabs --> <div id="tabs" role="tabpanel" class="nav nav-tabs" role="tablist"> <ul class="nav nav-tabs" role="tablist"> <li role="presentation" class="active"><a href="#tabs-0" aria-controls="tabs-0" role="tab" data-toggle="tab"><?php echo TEXT_TAB_DESCRIPTION; ?></a></li> <?php // Tab 1 if ($product_info['products_tab_1'] > '') { ?> <li role="presentation"><a href="#tabs-1" aria-controls="tabs-1" role="tab" data-toggle="tab"><?php echo PRODUCT_TABS_TAB_1; ?></a></li> <?php } ?> <?php // Tab 2 if ($product_info['products_tab_2'] > '') { ?> <li role="presentation"><a href="#tabs-2" aria-controls="tabs-2" role="tab" data-toggle="tab"><?php echo PRODUCT_TABS_TAB_2; ?></a></li> <?php } ?> <?php // Tab 3 if ($product_info['products_tab_3'] > '') { ?> <li role="presentation"><a href="#tabs-3" aria-controls="tabs-3" role="tab" data-toggle="tab"><?php echo PRODUCT_TABS_TAB_3; ?></a></li> <?php } ?> <?php // Tab 4 if ($product_info['products_tab_4'] > '') { ?> <li role="presentation"><a href="#tabs-4" aria-controls="tabs-4" role="tab" data-toggle="tab"><?php echo PRODUCT_TABS_TAB_4; ?></a></li> <?php } ?> <?php // Tab 5 if ($product_info['products_tab_5'] > '') { ?> <li role="presentation"><a href="#tabs-5" aria-controls="tabs-5" role="tab" data-toggle="tab"><?php echo PRODUCT_TABS_TAB_5; ?></a></li> <?php } ?> <?php // Review Tab if (PRODUCT_TABS_REVIEWS_TAB == 'True') { ?> <li><a href="#tabs-6"><?php echo TEXT_TAB_REVIEWS; ?></a></li> <?php } ?> <?php // Ask a Question Tab if (PRODUCT_TABS_QUESTION_TAB == 'True') { ?> <li><a href="#tabs-7"><?php echo TEXT_TAB_ASK_A_QUESTION; ?></a></li> <?php } ?> <?php // Tell a Friend Tab if (PRODUCT_TABS_FRIEND_TAB == 'True') { ?> <li><a href="#tabs-8"><?php echo TEXT_TAB_TELL_A_FRIEND; ?></a></li> <?php } ?> </ul> </div> <!-- Tab panes --> <div class="tab-content"> <div role="tabpanel" class="tab-pane active" id="tabs-0"> <?php echo stripslashes($product_info['products_description']); ?> </div> <?php // Tab 1 if ($product_info['products_tab_1'] > '') { ?> <div role="tabpanel" class="tab-pane" id="tabs-1"> <br> <?php echo stripslashes ($product_info['products_tab_1']); ?> </div> <?php } ?> <?php // Tab 2 if ($product_info['products_tab_2'] > '') { ?> <div role="tabpanel" class="tab-pane" id="tabs-2"> <br> <?php echo stripslashes ($product_info['products_tab_2']); ?> </div> <?php } ?> <?php // Tab 3 if ($product_info['products_tab_3'] > '') { ?> <div role="tabpanel" class="tab-pane" id="tabs-3"> <br> <?php echo stripslashes ($product_info['products_tab_3']); ?> </div> <?php } ?> <?php // Tab 4 if ($product_info['products_tab_4'] > '') { ?> <div role="tabpanel" class="tab-pane" id="tabs-4"> <br> <?php echo stripslashes ($product_info['products_tab_4']); ?> </div> <?php } ?> <?php // Tab 5 if ($product_info['products_tab_5'] > '') { ?> <div role="tabpanel" class="tab-pane"id="tabs-5"> <br> <?php echo stripslashes ($product_info['products_tab_5']); ?> </div> <?php } ?> <?php // Review Tab if (PRODUCT_TABS_REVIEWS_TAB == 'True') { echo ' <div id="tabs-6">'; include( DIR_WS_MODULES . FILENAME_PRODUCT_REVIEWS ); echo ' </div><div style="clear: both;"></div>'; } ?> <?php // Ask a Question Tab if (PRODUCT_TABS_QUESTION_TAB == 'True') { echo ' <div id="tabs-7">'; include( DIR_WS_MODULES . FILENAME_ASK_A_QUESTION ); echo ' </div><div style="clear: both;"></div>'; } ?> <?php // Tell a Friend Tab if (PRODUCT_TABS_FRIEND_TAB == 'True') { echo ' <div id="tabs-8">'; include( DIR_WS_MODULES . FILENAME_TELL_A_FRIEND ); echo ' </div><div style="clear: both;"></div>'; } ?> </div> </div> </div> </nav>

Solved! The whole problem was the Ultimate SEO urls 5, With making soo many changes I uploaded the original Ultimate SEO files but then didn't upload the ones from support as well! Once this corrected all is well. Many thanks, when you make several changes it's hard to know what's gone wrong sometimes. Back to normal thanks for a great contrib!

Thanks Rainer, general is fine but a there's a </div> at the end of the header file. Removing it seems to make no difference can you direct me to the thread on this please? Thanks, Lorraine

Hello, Strangely I'm getting the following: Warning: Cannot modify header information - headers already sent by (output started at /.../shop/mobile/includes/header.php:6) in /..../shop/includes/functions/general.php on line 57 I've changed SEO URL 5.0 to rewrite and now it seems I'm getting this error in my mobile shop. Can anyone shed light please? See at this link: https://www.herbalmedicineuk.com/shop/mobile/green-tea-100g-mp-1056.html?redirectCancelled=true Thanks, Lorraine

Hello David, What would you like to know? My mobile site currently now works fully for SPPC and Hide Categories. Happy to help. been away for a few days recently, Lorraine

Okay thanks to the mighty Rainer all you need to do to make search work on 2.3.4 is add above the $listing_sql shown from the original instructions as here: // BOF Separate Price Per Customer // global variable (session): $sppc_customers_group_id -> local variable $customer_group_id if(!tep_session_is_registered('sppc_customer_group_id')) {$customer_group_id = '0'; } else { $customer_group_id = $sppc_customer_group_id; } // EOF SPPC $listing_sql = $select_str . $from_str . $where_str . $order_str; Then compare your advanced_search_result.php with the mobile version and ensure you compare and copy in every SPPC and Hide Categories changes exactly. I'm NOT a coder all at your own risk but it now seems to work perfectly for me ... Best wishes, Lorraine

First thanks to Rainer for his excellent contrib. Just going to post a workaround I found for SPPC with Hide Categories and Products as this has been the only thing stopping me using this in the past. Please note I am NOT a coder! All at your own risk! Additionally I can't get the search to work. it's too restrictive if anyone can help further with this please. So to ensure only the categories and products show per SPPC on 2.3.4.only: In catalog_mb.php find first listing_sql and paste this above it as per current SPPC instructions: // BOF Separate Price Per Customer // global variable (session): $sppc_customers_group_id -> local variable $customer_group_id if(!tep_session_is_registered('sppc_customer_group_id')) {$customer_group_id = '0'; } else { $customer_group_id = $sppc_customer_group_id; } // EOF SPPC Then find this line: $listing_sql .= " and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'"; and directly below it paste this line: // BOF SPPC Hide products and categories from groups $listing_sql .= " and find_in_set('".$customer_group_id."', products_hide_from_groups) = 0 "; // EOF SPPC Hide products and categories from groups Do this for the other files mentioned: specials.php and products_new.php Then in login.php compare your login file with one below and add the SPPC and Hide Categories bit: <?php require_once('includes/application_top.php'); // redirect the customer to a friendly cookie-must-be-enabled page if cookies are disabled (or the session has not started) if ($session_started == false) { tep_redirect(tep_mobile_link(FILENAME_COOKIE_USAGE)); } require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_LOGIN); $error = false; if (isset($HTTP_GET_VARS['action']) && ($HTTP_GET_VARS['action'] == 'process')) { $email_address = tep_db_prepare_input($HTTP_POST_VARS['email_address']); $password = tep_db_prepare_input($HTTP_POST_VARS['password']); // Check if email exists // BOF Separate Pricing per Customer $check_customer_query = tep_db_query("select customers_id, customers_firstname, customers_group_id, customers_password, customers_email_address, customers_default_address_id, customers_specific_taxes_exempt from " . TABLE_CUSTOMERS . " where customers_email_address = '" . tep_db_input($email_address) . "'"); // EOF Separate Pricing Per Customer if (!tep_db_num_rows($check_customer_query)) { $error = true; } else { $check_customer = tep_db_fetch_array($check_customer_query); // Check that password is good if (!tep_validate_password($password, $check_customer['customers_password'])) { $error = true; } else { if (SESSION_RECREATE == 'True') { tep_session_recreate(); } // BOF Separate Pricing Per Customer: choice for logging in under any customer_group_id // note that tax rates depend on your registered address! if ($_POST['skip'] != 'true' && $_POST['email_address'] == SPPC_TOGGLE_LOGIN_PASSWORD ) { $existing_customers_query = tep_db_query("select customers_group_id, customers_group_name from " . TABLE_CUSTOMERS_GROUPS . " order by customers_group_id "); echo '<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">'; print ("\n<html "); echo HTML_PARAMS; print (">\n<head>\n<title>Choose a Customer Group</title>\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset="); echo CHARSET; print ("\"\n<base href=\""); echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; print ("\">\n<link rel=\"stylesheet\" type=\"text/css\" href=\"stylesheet.css\">\n"); echo '<body bgcolor="#ffffff" style="margin:0">'; print ("\n<table border=\"0\" width=\"100%\" height=\"100%\">\n<tr>\n<td style=\"vertical-align: middle\" align=\"middle\">\n"); echo tep_draw_form('login', tep_href_link(FILENAME_LOGIN, 'action=process', 'SSL')); print ("\n<table border=\"0\" bgcolor=\"#f1f9fe\" cellspacing=\"10\" style=\"border: 1px solid #7b9ebd;\">\n<tr>\n<td class=\"main\">\n"); $index = 0; while ($existing_customers = tep_db_fetch_array($existing_customers_query)) { $existing_customers_array[] = array("id" => $existing_customers['customers_group_id'], "text" => " ".$existing_customers['customers_group_name']." "); ++$index; } print ("<h1>Choose a Customer Group</h1>\n</td>\n</tr>\n<tr>\n<td align=\"center\">\n"); echo tep_draw_pull_down_menu('new_customers_group_id', $existing_customers_array, $check_customer['customers_group_id']); print ("\n<tr>\n<td class=\"main\"> <br />\n "); print ("<input type=\"hidden\" name=\"email_address\" value=\"".$_POST['email_address']."\">"); print ("<input type=\"hidden\" name=\"skip\" value=\"true\">"); print ("<input type=\"hidden\" name=\"password\" value=\"".$_POST['password']."\">\n</td>\n</tr>\n<tr>\n<td align=\"right\">\n"); echo tep_image_submit('button_continue.gif', IMAGE_BUTTON_CONTINUE); print ("</td>\n</tr>\n</table>\n</form>\n</td>\n</tr>\n</table>\n</body>\n</html>\n"); exit; } // EOF Separate Pricing Per Customer: choice for logging in under any customer_group_id // migrate old hashed password to new phpass password if (tep_password_type($check_customer['customers_password']) != 'phpass') { tep_db_query("update " . TABLE_CUSTOMERS . " set customers_password = '" . tep_encrypt_password($password) . "' where customers_id = '" . (int)$check_customer['customers_id'] . "'"); } $check_country_query = tep_db_query("select entry_country_id, entry_zone_id from " . TABLE_ADDRESS_BOOK . " where customers_id = '" . (int)$check_customer['customers_id'] . "' and address_book_id = '" . (int)$check_customer['customers_default_address_id'] . "'"); $check_country = tep_db_fetch_array($check_country_query); $customer_id = $check_customer['customers_id']; $customer_default_address_id = $check_customer['customers_default_address_id']; $customer_first_name = $check_customer['customers_firstname']; // BOF Separate Pricing Per Customer $customers_specific_taxes_exempt = $check_customer['customers_specific_taxes_exempt']; if ($_POST['skip'] == 'true' && $_POST['email_address'] == SPPC_TOGGLE_LOGIN_PASSWORD && isset($_POST['new_customers_group_id'])) { $sppc_customer_group_id = $_POST['new_customers_group_id'] ; $check_customer_group_tax = tep_db_query("select customers_group_show_tax, customers_group_tax_exempt, group_specific_taxes_exempt from " . TABLE_CUSTOMERS_GROUPS . " where customers_group_id = '" .(int)$_POST['new_customers_group_id'] . "'"); } else { $sppc_customer_group_id = $check_customer['customers_group_id']; $check_customer_group_tax = tep_db_query("select customers_group_show_tax, customers_group_tax_exempt, group_specific_taxes_exempt from " . TABLE_CUSTOMERS_GROUPS . " where customers_group_id = '" .(int)$check_customer['customers_group_id'] . "'"); } $customer_group_tax = tep_db_fetch_array($check_customer_group_tax); $sppc_customer_group_show_tax = (int)$customer_group_tax['customers_group_show_tax']; $sppc_customer_group_tax_exempt = (int)$customer_group_tax['customers_group_tax_exempt']; $group_specific_taxes_exempt = $customer_group_tax['group_specific_taxes_exempt']; if (tep_not_null($customers_specific_taxes_exempt)) { $sppc_customer_specific_taxes_exempt = $customers_specific_taxes_exempt; } elseif (tep_not_null($group_specific_taxes_exempt)) { $sppc_customer_specific_taxes_exempt = $group_specific_taxes_exempt; } else { $sppc_customer_specific_taxes_exempt = ''; } // EOF Separate Pricing Per Customer $customer_country_id = $check_country['entry_country_id']; $customer_zone_id = $check_country['entry_zone_id']; tep_session_register('customer_id'); tep_session_register('customer_default_address_id'); tep_session_register('customer_first_name'); // BOF Separate Pricing per Customer tep_session_register('sppc_customer_group_id'); tep_session_register('sppc_customer_group_show_tax'); tep_session_register('sppc_customer_group_tax_exempt'); if (tep_not_null($sppc_customer_specific_taxes_exempt)) { tep_session_register('sppc_customer_specific_taxes_exempt'); } // EOF Separate Pricing per Customer tep_session_register('customer_country_id'); tep_session_register('customer_zone_id'); tep_db_query("update " . TABLE_CUSTOMERS_INFO . " set customers_info_date_of_last_logon = now(), customers_info_number_of_logons = customers_info_number_of_logons+1, password_reset_key = null, password_reset_date = null where customers_info_id = '" . (int)$customer_id . "'"); // reset session token $sessiontoken = md5(tep_rand() . tep_rand() . tep_rand() . tep_rand()); // restore cart contents $cart->restore_contents(); if (sizeof($navigation->snapshot) > 0) { $origin_href = tep_mobile_link($navigation->snapshot['page'], tep_array_to_string($navigation->snapshot['get'], array(tep_session_name())), $navigation->snapshot['mode']); $navigation->clear_snapshot(); tep_redirect($origin_href); } else { tep_redirect(tep_mobile_link(FILENAME_DEFAULT)); } } } } if ($error == true) { $messageStack->add('login', TEXT_LOGIN_ERROR); } $breadcrumb->add(NAVBAR_TITLE, tep_mobile_link(FILENAME_LOGIN, '', 'SSL')); require(DIR_MOBILE_INCLUDES . 'header.php'); $headerTitle->write(); ?> <div id="iphone_content"> <div id="messageStack"> <?php if ($messageStack->size('login') > 0) { echo $messageStack->output('login'); } ?> </div> <div id="returning_cust"> <h1><?php echo HEADING_RETURNING_CUSTOMER; ?></h1> <?php echo tep_draw_form('login', tep_mobile_link(FILENAME_LOGIN, 'action=process', 'SSL')); ?> <label for="email_address"><?php echo ENTRY_EMAIL_ADDRESS; ?></label> <?php echo tep_input_jquery('email_address'); ?> <label for="password"><?php echo ENTRY_PASSWORD; ?></label> <?php echo tep_draw_password_field('password','','id="password" data-theme="a"'); ?> <div class="bouton"> <?php echo tep_button_jquery( IMAGE_BUTTON_FORGOT_PASS , tep_mobile_link(FILENAME_PASSWORD_FORGOTTEN, '', 'SSL') , 'b' , 'button' , 'data-icon="info" data-inline="true" data-ajax="false"' ); echo tep_button_jquery( IMAGE_BUTTON_LOGIN , '', 'b' , 'submit' , 'data-icon="arrow-r" data-iconpos="right" data-inline="true"' ); ?> </div> </form> </div> <div id="new_cust"> <h1><?php echo HEADING_NEW_CUSTOMER; ?></h1> <?php echo TEXT_NEW_CUSTOMER_INTRODUCTION; ?> <div class="bouton"> <?php echo tep_button_jquery( IMAGE_BUTTON_CREATE_ACCOUNT , tep_mobile_link(FILENAME_CREATE_ACCOUNT, '', 'SSL'), 'b' , 'button' , 'data-icon="arrow-r" data-iconpos="right" data-inline="true" ' ); ?> </div> </div> <?php if( JQUERY_MOBILE_VALIDATE == 'True') require(DIR_MOBILE_INCLUDES. 'form_check.js.php'); else require(DIR_WS_INCLUDES . 'form_check.js.php'); require(DIR_MOBILE_INCLUDES . 'footer.php'); ?> Do the same for your logoff.php with this: <?php require_once('includes/application_top.php'); require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_LOGOFF); $breadcrumb->add(NAVBAR_TITLE); tep_session_unregister('customer_id'); tep_session_unregister('customer_default_address_id'); tep_session_unregister('customer_first_name'); // BOF Separate Pricing Per Customer tep_session_unregister('sppc_customer_group_id'); tep_session_unregister('sppc_customer_group_show_tax'); tep_session_unregister('sppc_customer_group_tax_exempt'); if (tep_session_is_registered('sppc_customer_specific_taxes_exempt')) { tep_session_unregister('sppc_customer_specific_taxes_exempt'); } // EOF Separate Pricing Per Customer tep_session_unregister('customer_country_id'); tep_session_unregister('customer_zone_id'); if ( tep_session_is_registered('sendto') ) { tep_session_unregister('sendto'); } if ( tep_session_is_registered('billto') ) { tep_session_unregister('billto'); } if ( tep_session_is_registered('shipping') ) { tep_session_unregister('shipping'); } if ( tep_session_is_registered('payment') ) { tep_session_unregister('payment'); } if ( tep_session_is_registered('comments') ) { tep_session_unregister('comments'); } if ( tep_session_is_registered('mobilesession') ) { tep_session_unregister('mobilesession'); } $cart->reset(); require(DIR_MOBILE_INCLUDES . 'header.php'); $headerTitle->write(); ?> <div id="iphone_content"> <div id="cms"> <?php echo TEXT_MAIN; ?> <div id="bouton"> <?php echo tep_button_jquery(IMAGE_BUTTON_CONTINUE , tep_mobile_link(FILENAME_DEFAULT, '', 'NONSSL'), 'b' , 'button' , ' data-icon="arrow-r" data-iconpos="right" data-ajax="false"' ); ?> </div> </div> <?php require(DIR_MOBILE_INCLUDES . 'footer.php'); ?> You'll also have to make some changes to the mobile product_info.php file too just compare with your existing main catalog version. It all works except advanced search/search. Hope this helps someone! Lorraine

Hi Jim, Thanks again, yeap triple yep I've checked this and reuploaded my application_top.php and everything is the exactly the same the error message as above. If I remove the wishlist box PDF datasheet works fine and account link to wishlist but I need the box ... I think I'll have to remove PDF datasheet sadly ... Lorraine

Can anyone suggest a fix for this? Tried in the Wish List 3.0 forum with no success. If I remove the Wish List box both PDF datasheet and Wish List work well however I need to have the Wishlist box ... Fatal error: Call to a member function count_contents() on a non-object in /homepages/xx/xxxx/htdocs/clickandbuilds/xxxxx/xxxx/xxxx/includes/modules/boxes/bm_wishlist.php on line 37 Thanks again, Lorraine

Here's the bit that creates it: function productInfo(){ global $languages_id; $this->productInfo = array(); $p_string = ''; for($i=0, $n=sizeof($this->products); $i<$n; $i++){ $p_string .= $this->products[$i] . ', '; } $p_string = trim($p_string, ', '); $product_query = tep_db_query("select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, if(s.status, s.specials_new_products_price, NULL) as specials_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd left join (select * from (select products_id, specials_new_products_price, expires_date, status from " . TABLE_SPECIALS . " where status = 1 order by products_id, specials_new_products_price, expires_date) as t group by products_id) as s on pd.products_id = s.products_id where pd.products_id = p.products_id and p.products_id in(" . $p_string . ") and pd.language_id=" . (int)$languages_id . " order by products_name"); Is there an error here?

Using 2.3.4 getting this error to do with the $p_string: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and pd.language_id=1 order by products_name' at line 1 select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, if(s.status, s.specials_new_products_price, NULL) as specials_price from products p, products_description pd left join (select * from (select products_id, specials_new_products_price, expires_date, status from specials where status = 1 order by products_id, specials_new_products_price, expires_date) as t group by products_id) as s on pd.products_id = s.products_id where pd.products_id = p.products_id and p.products_id in() and pd.language_id=1 order by products_name [TEP STOP] Is there a solution? The email won't send ... Thanks, Lorraine

Not a coder but this puts the link back in: <?php if (tep_not_null($product_info['products_url'])) { echo sprintf(TEXT_MORE_INFORMATION, tep_href_link(FILENAME_REDIRECT, 'action=url&goto=' . urlencode($product_info['products_url']), 'NONSSL', true, false)); } ?>