-
Posts
3,796 -
Joined
-
Last visited
-
Days Won
33
Reputation Activity
-
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
-
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; ?> -
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.
-
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); -
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.
-
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.
-
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
-
bruyndoncx got a reaction from Mort-lemur in Paypal App - Duplicate Tables - Please confirm
Added to tips and tricks
-
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 -
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 -
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 -
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...
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
bruyndoncx reacted to DeadBoLt79 in MUST SELECT ATTRIBUTES
Thanks so much bruyndoncx, that tip saved me lots of time.
-
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 ?