Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

bruyndoncx

♥Ambassador
  • Posts

    3,796
  • Joined

  • Last visited

  • Days Won

    33

Reputation Activity

  1. Like
    bruyndoncx reacted to LeeFoster in [Addon} Modular Front Page   
    I thought I would share the changes I made to allow you to hide a category from the front page but not the boxes
     
  2. Like
    bruyndoncx got a reaction from cupidare in advent calendar   
    I just got this crazy last minute idea for an advent calendar.
     
    Found this script that looks good as a basis
    https://www.christianheilmann.com/2005/11/16/a-free-christmas-calendar-in-php/
     
    but i think it would be best if it is linked to a banner group, and use a naming convention to find the correct banner to show upon click
     
    this is the main page code

    <?php // Variables $pictureFolder='ups'; $month=12; $clickableClass='done'; $calendarID='calendar'; $pictureID='pic'; $d=preg_replace('/^0/','',date('d')); $selectedImage=$_GET['i']; $img=preg_match('/\d/',$selectedImage)?$selectedImage:'none'; if(date('m')!=$month){$img=25;} if(date('m')!=$month){$d=-1;} $cal='<ul id="'.$calendarID.'">'; for($i=1;$i<25;$i++) { $cal.= '<li>'; $cal.= '<a '.($i<=$d?'class="'.$clickableClass.'"':'').'id="l'.$i.'" href="index.php?i='.($i<=$d?$i:25).'">'; $cal.= $i.'</a></li>'; } $cal.='</ul>'; $pic='<div id="'.$pictureID.'"><a href="index.php"><img src="'.$pictureFolder.'/'.$img.'.jpg" alt="Picture '.$img.'" /></a></div>'; echo $selectedImage==''?$cal:$pic; ?>
  3. Like
    bruyndoncx reacted to mooseracing in OllaCart Point of Sale for osCommerce - ocPOS   
    Lol, I'm sometimes to impatient for my own good.   So I started digging in and stepping through the different files, after I did more work than needed I started over and started reading through the install.php.  Checked to make sure files were all there that it was looking for, then came across the test table statement.  I modded the statement to include the zen_ prefix, saved and the installer worked, except everything doubled to zen_zen_ since I added the prefix to db.php and db_tables in my fiddling around.  So I cleaned that up and started clean.
     
    So for those trying to get this working on Zen it still works.
  4. Like
    bruyndoncx reacted to jackhill in CONTRIBUTION ez Social Login for Google Facebook LinkedIn Microsoft   
    Guys, I did it!! Facebook social login finally working  :thumbsup:
     
    Edit login_with_facebook.php and replace the "GET array" line under 'https://graph.facebook.com/me' with the following
    'GET', array( 'fields'=>'first_name,last_name,gender,email' ), array('FailOnAccessError'=>true), $user);
  5. Like
    bruyndoncx got a reaction from Tsimi in [Addon} Modular Front Page   
    just a litte headsup, I integrated flickity slider (from the isotope guy) which is a responsive touch enabled slider that allows for swiping as a frontpage module, it is very easy to do based upon the banner rotator.
    currently I have settings hardcoded, but overall it is very easy to integrate.
  6. Like
    bruyndoncx reacted to Denzel in [Contribution] Products Specifications   
    First of all: Im very impressed, that you both take care of my problems so quickly  :thumbsup:  :D
     
    At second goes the biggest THANK YOU to Carine (Ive robbed her sleep  o:) )
     
    With your code you save me a lot of time ! Maybe it really was too late yesterday... I found a little mistake in the script in admin/categories.php:
    <script> var $radios = $('input[type=radio][data-sync]'); $radios.change(function() { $radios.filter('[data-sync="' + $(this).attr('data-sync') + '"]').prop('checked', true); }); var $checks = $('input[type=checkbox][data-sync]'); $checks.change(function() { $checks.filter('[data-sync="' + $(this).attr('data-sync') + '"]').prop('checked', $(this).prop('checked')); }); </script> With this corrections it did exactly what I want   (w00t)  :thumbsup: Once again: Thank you very much !
     
    SEE YA !
     
    Denzel.
  7. Like
    bruyndoncx got a reaction from kymation in [Contribution] Products Specifications   
    you have to define a "null" or "not applicable" value yourself and set it the lowest sort order
  8. Like
    bruyndoncx got a reaction from Mort-lemur in Paypal App - Duplicate Tables - Please confirm   
    Added to tips and tricks
  9. Like
    bruyndoncx got a reaction from multimixer in Paypal App - Duplicate Tables - Please confirm   
    I don't have the paypal app, but have the same symptoms for a few of my settings.
     
    This sql will list duplucate configuration keys
    use phpmyadmin or similar to run the sql query and find out exactly
     

    select configuration_key, count(*) from configuration group by configuration_key having count(*) > 1
  10. Like
    bruyndoncx got a reaction from Mort-lemur in Paypal App - Duplicate Tables - Please confirm   
    I don't have the paypal app, but have the same symptoms for a few of my settings.
     
    This sql will list duplucate configuration keys
    use phpmyadmin or similar to run the sql query and find out exactly
     

    select configuration_key, count(*) from configuration group by configuration_key having count(*) > 1
  11. Like
    bruyndoncx got a reaction from kymation in Paypal App - Duplicate Tables - Please confirm   
    I don't have the paypal app, but have the same symptoms for a few of my settings.
     
    This sql will list duplucate configuration keys
    use phpmyadmin or similar to run the sql query and find out exactly
     

    select configuration_key, count(*) from configuration group by configuration_key having count(*) > 1
  12. Like
    bruyndoncx reacted to clustersolutions in Logon as Facebook account   
    FYI...I built a module for that and you should be able to find most of it here...
     
    https://github.com/clustersolutions/osCommerce-234-bootstrap/commit/e7150e4da726d401232b2c418311670fe3a5829c
     
    My bad as my github isn't that tidy....I was learning git and I was under a tight timeline to get the site relaunched...
     
    Those in the addon won't work for sure as FB had a new requirement beginning of this year on re-request due to the permission restriction and what not so the module above should give you a good starting point...also, the current core can't deal with checkout without addresses so you would have to modify the checkout process as well...do checkout the simple register module as well as they kinda go together...
     
    Also, before you venture of this route...consider the pay FB login service as well as make sure that FB login is for your customers...I found older customers least likely to use FB login...
  13. Like
    bruyndoncx got a reaction from ArtcoInc in Latest News Multilingual   
    just had a quick look at the code
     
    1) i can't see any ref to the important field in the sql for the box, it does not seem used
    2)  the same way as it is done on products and categories
    the content table has a language id, and the admin page iterates through the different languages to create headline and content fields for data entry in each language
  14. Like
    bruyndoncx got a reaction from Tsimi in Get 1 Free   
    I solved BUG2 in my version, but it is not using the dropdown
     
    I had an issue with the contribution as I have 7000 active products, the dropdown being impractical.
    I just have boxes to enter product ids, and I removed the pagination and added other tweaks such as the javascript filtertable
     
    I think you can compare and figure out how to do it this way, if that makes sense to  you
     
    CarineI
    get_1_free.php
  15. Like
    bruyndoncx got a reaction from Supertex in Sorting items in basket for invoice   
    Find this line

    $orders_products_query = tep_db_query("select orders_products_id, products_name, products_model, products_price, products_tax, products_quantity, final_price from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$order_id . "'");
     
    change it to

    $orders_products_query = tep_db_query("select orders_products_id, products_name, products_model, products_price, products_tax, products_quantity, final_price from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$order_id . "' order by products_name ");
    by adding
    order by products_name
    just before the last double quote and closing paranthesis, making sure to have a space inserted just before order by
  16. Like
    bruyndoncx reacted to auzStar in [Contribution] Match Categories in Search Results for osCommerce versions 2.3.x   
    Support Thread for Match Categories in Search Results for osCommerce versions 2.3.x
     
    Report problems here.
     
    I will monitor this thread and try to answer as many questions as I can.
     
    Feedback and comments appreciated.
     
     
    Download link:
    http://addons.oscommerce.com/info/9197
     
     
    Dom
  17. Like
    bruyndoncx reacted to g2777 in Multiple Sales/Specials Per Product and osC 2.3.4 Bootstrap   
    I did it! Yay!

    Thank you so much for your help. I had a problem getting the SQL statement in 16b working to begin with but in the end It was simply so that you can select the products associated with a particular sale by using the drop down list. So I used this:
    $listing_sql = "select " . $select_column_list . " p.products_id, SUBSTRING_INDEX(pd.products_description, ' ', 20) as products_description, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . (is_numeric($sale_id) ? "' and s.sale_id = '" . (int)$sale_id : "") . "' and s.status = '1'"; Basically just replace
    '" . (int)$languages_id . "' with
    '" . (int)$languages_id . (is_numeric($sale_id) ? "' and s.sale_id = '" . (int)$sale_id : "") . "' in the original statement.
     
    It works flawlessly as far as I can tell and I got to keep the sorting options.
     
    Thank you again; to both of you.
     
    Regards,
    Graham
  18. Like
    bruyndoncx got a reaction from g2777 in Multiple Sales/Specials Per Product and osC 2.3.4 Bootstrap   
    16a should be covered by the changes you made to product_listing
     
    16b
     
    just to get it to return the data for your sales, (you will loose the sorting options at this point, unless you figure out how to integrate it in detail)
    replace
       $listing_sql line in specials.php
    with (section 16c in instructions) - BUT change $specials_query_raw  into $listing_sql
      $specials_query_raw = "select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price, s.expires_date from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, (select * from (select products_id, specials_new_products_price, expires_date, sale_id, status, specials_date_added from " . TABLE_SPECIALS . " where status = 1 order by products_id, specials_new_products_price, expires_date) as t group by products_id) as s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = " . (int)$languages_id . (is_numeric($sale_id) ? " and s.sale_id = " . (int)$sale_id : "") . " and s.status = '1' order by s.specials_date_added DESC";
     
    16c just apply as instructed
     
     
    18 find the random product line
    and replace with
            if ($random_product = tep_random_select("select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price, s.expires_date from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, (select * from (select products_id, specials_new_products_price, expires_date, status, specials_date_added from " . TABLE_SPECIALS . " where status = 1 order by products_id, specials_new_products_price, expires_date) as t group by products_id) as s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '" . (int)$languages_id . "' and s.status = '1' order by s.specials_date_added desc limit " . MAX_RANDOM_SELECT_SPECIALS)) {
              $expires = '';
              if ((DISPLAY_SALE_EXPIRATION_DATE == 'true') && ($random_product['expires_date'] != '') && ($random_product['expires_date'] != '0000-00-00 00:00:00')) {
                $expires = '<br /><small>' . TEXT_SALE_EXPIRES . tep_date_short($random_product['expires_date']);
                if (DISPLAY_SALE_EXPIRATION_TIME == 'true') $expires .= ' @ ' . substr($random_product['expires_date'], 11);
                $expires .= '</small>';
              }
     
     
     
    Find
        if ($this->group == 'boxes_footer') {  
    the previous line ends in '</span>';
    insert just before  $expires make sure to have $expires surrounded by dots
     
     
     
    As for these sql changes, they seem very resource intensive sql queries, I personally are not sure if this is the proper way to do this. If your site slows down, that is the first place to investigate
  19. Like
    bruyndoncx reacted to Mort-lemur in Wishlist for 2.3 - Last Problem   
    @@AngusD Rene - Thank you, that fix worked a treat - all working now.
     
    Thank You
  20. Like
    bruyndoncx reacted to surfalot in [Contribution] Shell Script Utilities for osCommerce   
    Abstract   The purpose of this set of bash scripts is to help automate setting permissions on osCommerce shops and in addition, provide a convenient way to install batches of updates from a zip file.   Folks that live in rural areas that rely on slow or high latency internet connections may find the zip installer a convenient way to update their shop. Instead of all the overhead of single file checks and uploads, you can upload a zip package then install it with proper permission settings using these scripts. If you prefer your shop locked down, the script will unlock it, install the update, and lock it down again. It's fast and convenient.   There are three sets of bash scripts included. Two sets are developed for a server admin to be run from a root account. The other set is designed to be used by a shop owner from an account level shell login.   From the shop owners perspective, the scripts where designed to take the guess work out of setting the permissions on an osCommerce shop. From the server admin's perspective, it's a fast convenient way to script updates and settings changes on one or multiple shops on a server.   Features  The "Extended" permissions level conforms with the osCommerce 2.3 Security Directory Permissions check. Quickly and easily set 3 different file and directory permissions levels on your shop. Quickly and easily lock and unlock the configure.php files. Easy to customize to fit your specific shop's needs. Conveniently install shop updates from an uploaded zip file and follow-up with setting the correct permissions.   Get them here: http://addons.oscommerce.com/info/9115  
  21. Like
    bruyndoncx reacted to sammy66 in Europe Cookie Laws   
    i have found something jquery based which will handle google analytics (opt in / out) and on my test site it works rather nicely, so i should be able to upload to the addons within half an hour - in case anyone else needs it
  22. Like
    bruyndoncx reacted to surfalot in [Contribution] Database Configurer for contributions   
    New packages have been uploaded with new features, updates.   See the changelog for details.  Some highlights:
     
    - Complete rewrite. - Added page to allow a preview of all SQL commands that will be performed in an install or update. - Added versioning that allows conditional database updates based on a stored contribution version. - Converted the functions file to a class. Now properly containing data and functionality in a class. - Added ability to preload new tables with static or example data.  
      Database Configurer v1.1.0 for osCommerce v2.2ms2 (all releases): http://addons.oscommerce.com/info/4894
    Database Configurer v1.1.0 for osCommerce v2.3.x: http://addons.oscommerce.com/info/9108
  23. Like
    bruyndoncx reacted to kymation in [Addon] Shopping List   
    This addon provides a Shopping List that your customers can use to keep track of items that they want to reorder periodically, or that they want to save for a future order. It was designed for an osCommerce store that sells consumables, but it works with any type of business that wants to increase repeat business.
    Your customers can create multiple shopping lists, up to a maximum that you set in your store's Admin. Products can be added to a shopping list from a product page or from the shopping cart. Any product in a shopping list can be added to the cart, or the whole list can be added at one time. There are a full set of features that allow your customer to create, modify, delete, and view their shopping lists.

    The tooltips used here are a backport from Bootstrap. I'll modify this to use the real Bootstrap tooltips when osCommerce switches to Bootstrap.
     
    Screenshots:
    Add a product to an existing shopping list.
    Add a product to a new shopping list - step one.
    Add a product to a new shopping list - step two.
    After a product is added to a shopping list (confirmation)
    The shopping list page.
     
    Here's the code.
     
    Regards
    Jim
  24. Like
    bruyndoncx reacted to DeadBoLt79 in MUST SELECT ATTRIBUTES   
    Thanks so much bruyndoncx, that tip saved me lots of time.
  25. Like
    bruyndoncx got a reaction from joli1811 in jQuery/Ajax Advanced Order Handler for osCommerce 2.3.3   
    @@Dr. Rolex
    I've done some database tuning in my previous career - anything I can help with ?
×
×
  • Create New...