Do you know what changes need to be done to get this contribution working on zc 1.5.1? ;)
Printable View
Do you know what changes need to be done to get this contribution working on zc 1.5.1? ;)
Yes I do ...... :smile:Quote:
Originally Posted by khejit
I never released the 1.5.1 update officially. You can use the latest package available from the download section, and use the 1.5.0 install. Just carefully merge the files and you will be fine. The biggest difference is in the general functions file.
If I have time left I will be updating this module soon to 1.5.1 and 1.5.3
V1.2 has been submitted to the download section.
- Support for Zen Cart 1.5.1 has been added
- Support for Zen Cart 1.3.8 has been dropped
- Fix by a_berezin: Multilangauge names for attributes are properly shown by language
Very pleased to hear you hope to do a 1.5.3 version.
I wish I could help you but I'm still getting to grips with the basics. Need an alpha tester?
Thanks, I will let you know if I need you ;) , but foe now the most time consuming is updating the documentation.Quote:
Originally Posted by CScotty
I have a problem with sql patch. First, I have to put commands manually via PhpMyAdmin, since Install Sql Patches from Tools in Admin gives me error every time.
...and so on, results withCode:INSERT INTO configuration VALUES
(NULL, 'Enable on Category Pages', 'FILTER_CATEGORY', 'Yes', 'Enable the filter on category pages?', @cid, '10', now(), now(), NULL, "zen_cfg_select_option(array('Yes', 'No'),"),
(NULL, 'Enable on All Products Page', 'FILTER_ALL', 'Yes', 'Enable the filter on all products page?', @cid, '20', now(), now(), NULL, "zen_cfg_select_option(array('Yes', 'No'),"),
(NULL, 'Enable on New Products Page', 'FILTER_NEW', 'Yes', 'Enable the filter on new products page?', @cid, '30', now(), now(), NULL, "zen_cfg_select_option(array('Yes', 'No'),"),
(NULL, 'Enable on Featured Products Page', 'FILTER_FEATURED', 'Yes', 'Enable the filter on featured products page?', @cid, '40', now(), now(), NULL, "zen_cfg_select_option(array('Yes', 'No'),"),
(NULL, 'Enable on Specials Page', 'FILTER_SPECIALS', 'Yes', 'Enable the filter on specials page?', @cid, '50', now(), now(), NULL, "zen_cfg_select_option(array('Yes', 'No'),"),
(NULL, 'Enable on Search Page'[...]
Do you have any ideas how to modify this command? The rest of sql patch seems to be working.Quote:
#1136 - Column count doesn't match value count at row 1
The problem is that the column names are net defined in the sql script. If you add extra columns to the configuration table (like the FEC module does), this script will fail.Quote:
Originally Posted by khejit
Below you will find the improved sql, and I will update the downloads section asap:
Code:SELECT @cid:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'Dynamic Filter';
DELETE FROM configuration WHERE configuration_group_id = @cid;
DELETE FROM configuration_group WHERE configuration_group_id = @cid;
INSERT INTO configuration_group VALUES (NULL, 'Dynamic Filter', 'Dynamic Filter Settings', '1', '1');
SET @cid=last_insert_id();
UPDATE configuration_group SET sort_order = @cid WHERE configuration_group_id = @cid;
INSERT INTO configuration (configuration_id, configuration_title, configuration_key , configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)
VALUES (NULL, 'Enable on Category Pages', 'FILTER_CATEGORY', 'Yes', 'Enable the filter on category pages?', @cid, '10', now(), now(), NULL, "zen_cfg_select_option(array('Yes', 'No'),"),
(NULL, 'Enable on All Products Page', 'FILTER_ALL', 'Yes', 'Enable the filter on all products page?', @cid, '20', now(), now(), NULL, "zen_cfg_select_option(array('Yes', 'No'),"),
(NULL, 'Enable on New Products Page', 'FILTER_NEW', 'Yes', 'Enable the filter on new products page?', @cid, '30', now(), now(), NULL, "zen_cfg_select_option(array('Yes', 'No'),"),
(NULL, 'Enable on Featured Products Page', 'FILTER_FEATURED', 'Yes', 'Enable the filter on featured products page?', @cid, '40', now(), now(), NULL, "zen_cfg_select_option(array('Yes', 'No'),"),
(NULL, 'Enable on Specials Page', 'FILTER_SPECIALS', 'Yes', 'Enable the filter on specials page?', @cid, '50', now(), now(), NULL, "zen_cfg_select_option(array('Yes', 'No'),"),
(NULL, 'Enable on Search Page', 'FILTER_SEARCH', 'Yes', 'Enable the filter on advanced search page?', @cid, '60', now(), now(), NULL, "zen_cfg_select_option(array('Yes', 'No'),"),
(NULL, 'Filter Style', 'FILTER_STYLE', 'Link', 'How are the filters to be applied?<br /><br /><strong>Link</strong> - Each option is a link; Only one filter can be applied at a time.<br /><strong>Dropdown (Single)</strong> - Each option is part of a drop down list; Only one filter can be applied at a time.<br /><strong>Dropdown (Multi)</strong> - Each option is part of a drop down list; Multiple filters can be applied at a time.<br /><strong>Checkbox (Single)</strong> - Each option is a checkbox; Only one filter can be applied at a time.<br /><strong>Checkbox (Multi)</strong> - Each option is a checkbox; Multiple filters can be applied at a time.', @cid, '70', now(), now(), NULL, "zen_cfg_select_option(array('Link', 'Dropdown - Single', 'Dropdown - Multi', 'Checkbox - Single', 'Checkbox - Multi'),"),
(NULL, 'Disabled Options Method', 'FILTER_METHOD', 'Greyed', 'How are the unavailable filter options to be disabled?<br /><br /><strong>Greyed</strong> - Grey out the unavailable options.<br /><strong>Hidden</strong> - Hide the unavailable options.', @cid, '80', now(), now(), NULL, "zen_cfg_select_option(array('Greyed', 'Hidden'),"),
(NULL, 'Options Box Style', 'FILTER_OPTIONS_STYLE', 'Scroll', 'Which style of box should be used when the maximum number of options has been reached?<br /><br /><strong>Scroll</strong> - Scroll box.<br /><strong>Expand</strong> - Expanding box with More/Less link.<br /><br /><strong>Note: This option is only applicatble with Link or Checkbox filter styles.</strong>', @cid, '90', now(), now(), NULL, "zen_cfg_select_option(array('Scroll', 'Expand'),"),
(NULL, 'Maximum Number of Options', 'FILTER_MAX_OPTIONS', '9', 'What is the maximum number of options to be displayed before scroll bar/More link is visible?<br /><br /><strong>Note: This option is only applicatble with Link or Checkbox filter styles.</strong>', @cid, '100', now(), now(), NULL, NULL),
(NULL, 'Maximum Number of Price Ranges', 'FILTER_MAX_RANGES', '5', 'What is the maximum number of price range groups?<br /><br /><strong>Note: This can be overridden by the Maximum Price Range parameter</strong>', @cid, '110', now(), now(), NULL, NULL),
(NULL, 'Minimum Price Range', 'FILTER_MIN_PRICE', '10', 'What is the minimum gap in the price ranges?<br />Set as zero to deactivate.', @cid, '120', now(), now(), NULL, NULL),
(NULL, 'Maximum Price Range', 'FILTER_MAX_PRICE', '25', 'What is the minimum gap in the price ranges?<br />Set as zero to deactivate.', @cid, '130', now(), now(), NULL, NULL),
(NULL, 'Include Options', 'FILTER_OPTIONS_INCLUDE', '', 'Enter the list of option IDs to be included in the filter, separated by commas (i.e. 1,2,3)<br />Only the option numbers listed here will appear in the filter.<br />Leave blank to deactivate.', @cid, '140', now(), now(), NULL, NULL),
(NULL, 'Exclude Options', 'FILTER_OPTIONS_EXCLUDE', '', 'Enter the list of option IDs to be excluded from the filter, separated by commas (i.e. 1,2,3)<br />The option numbers listed here will <strong>not</strong> appear in the filter.<br />Leave blank to deactivate.', @cid, '150', now(), now(), NULL, NULL),
(NULL, 'Google Event Tracking', 'FILTER_GOOGLE_TRACKING', 'No', 'Use Google Event Tracking?<br /><br /><strong>No</strong> - Do not use Google Event Tracking<br /><strong>ga.js</strong> - Use traditional ga.js Google Event Tracking method<br /><strong>Asynchronous</strong> - Use new asynchronous Google Event Tracking method<br /><br /><strong>Note: Requires Google Analytics Code</strong>', @cid, '160', now(), now(), NULL, "zen_cfg_select_option(array('No', 'ga.js', 'Asynchronous'),");
/*
zencart 1.5 mods
*/
DELETE FROM admin_pages WHERE page_key='configDynamicFilter';
INSERT INTO admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order) VALUES ('configDynamicFilter','BOX_CONFIGURATION_DYNAMIC_FILTER','FILENAME_CONFIGURATION',CONCAT('gID=',@cid), 'configuration', 'Y', @cid);
I just installed this using the 1.5.0 in the download. I have a template monster template on the site, but other that that, I haven't made any changes to any of the files. I have numerous issues, so I had a few questions. Would deleting the files and using the 1.5.1 install fix these issues, or do I just need to handle them individually? Here are the issues I'm having.
1. The search bar is giving a general error now and doesn't work at all.
2. The filter is working on specific categories, but not on the all products page. It's turned on and shows up just fine, but it's not actually filtering anything.
3. The biggest (and weirdest) issue is that it's actually making the entire site disappear. When I go to the site, it's a completely blank page. The first time it happened, I logged in to the admin side to check things, and when I went to check the site again, it was there with the everything perfect except for the 2 issues I stated above. So after a day of checking, I've realized the site only works when I'm logged in to admin. As soon as I log off, or admin times out, the entire site just vanishes.
Any help would be greatly appreciated. If I should just use the 1.5.1 and see how that goes, let me know and I can come back with whether the issues still exist or not. Thanks guys
You don't say what version of Zen Cart you have. That will determine which version of this plugin you should install. Plus, Template Monster is notorious for making very bad templates.
sorry. I have 1.5.3
That explains it. There is not yet a version of this plugin compatible with Zen Cart 1.5.3
I apologize for being such a beginner at this. May I ask for a bit of advice? Having the filter is something I will definitely need in the store because of the amount of products. If you were me, would you continue working on 1.5.3 until the store is done, and then install the update if it's ready? Or would you install an older version of zencart and work within that one? Thanks again.
There's no telling when the new version will be ready. I'm not the author.
If you *need* this plugin, you're probably better off using Zen Cart 1.5.1 for now and upgrading later. If you got with 1.5.3, you could wait a long time for an update to this plugin. No offense to the author, we are all volunteers and do this as time allows.
I understand completely. Even besides the issues I was having, it was perfect on the pages it did work. Thanks again. I'll install 1.5.1 and begin there.
Okay. Running 1.5.1. I get "WARNING: An Error occurred, please refresh the page and try again."
and in logs I get
1054:Unknown column 'm.manufacturers_name' in 'field list' :: SELECT DISTINCT pd.products_name, p.products_image, pd.products_short_desc, m.manufacturers_name, p.products_model, p.products_quantity, p.products_id, p.products_type, p.master_categories_id,
p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1,
s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price,
p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping,
p.products_qty_box_status FROM products p LEFT JOIN specials s on p.products_id = s.products_id LEFT JOIN products_description pd on p.products_id = pd.products_id JOIN products_to_categories p2c on p.products_id = p2c.products_id WHERE p.products_status = 1
and pd.language_id = '1'
and p2c.categories_id = '684' GROUP BY p.products_id order by p.products_sort_order, pd.products_name in /home/public_html/includes/classes/db/mysql/query_factory.php on line 120
Well I'm gonna blame it on being too tired right now. I'm not getting to the bottom of this. I'll try again tomorrow.
From my quick review, I'm pretty certain that the v1.5.3 version of the functions_general.php file already incorporates the changes that this plugin was attempting to do. So, from now on the functions_general.php file should be excluded from this plugin, and the official ZC version of the file should be used.Quote:
Originally Posted by Design75
And other than that, I think that the rest of the v1.5.1 files for this plugin are probably fine since the affected "core files" were not changed between 151 and 153.
So, to use it on 153, use the plugin's 151 set of files EXCEPT keep the original ZC v153 version of functions_general.php
That said, I'm making these comments simply based on a very quick look at code, and not from doing any tests on a live site.
This article would be well worth the read: http://www.zen-cart.com/content.php?124-blank-pageQuote:
Originally Posted by Craig Freeburg
I'll give that a shot by just using the general functions file from 153. As far as the missing page. I know there wasn't any issues uploading the files, the strangest part is that I have to be logged in to admin for the site to show up. If I'm logged in, the site works and looks completely fine. Odd. But I'll try and get this general functions loaded and see what it does. I appreciate the help.
ok, well that functions_general doesn't help my situation. I get the half blank site with the Warning message telling me to try refreshing. The logs talk about m.manufacturers_name as stated above.
I also have no side box showing for this. It did register in the admin and I've activated it. Just not showing...
Thank You.
On a strictly technical level, the reason it's saying "unknown column m.manufacturers_name" is because you don't have any reference to the manufacturers table in the query, let alone the name. So, whatever you're doing to trigger the error is because the code is either missing mention of manufacturers or you've got some switch related to manufacturer data turned off for whatever page you're trying to display and the addon author didn't account for that possibility.Quote:
Originally Posted by bumba000
Maybe go back to the admin settings for the page where you're seeing that and turn on manufacturer info?
You are right Dr, I had come to that conclusion also.Quote:
Originally Posted by DrByte
The new version will be ready this weekend, Just finishing up the readme and final testing.
installed on v1.51. The sql out of the box did not work. used modified one from the thread. how do i sort by price, Pretty much the only option i want, option does not show on any page?
Most options are greyed out.
Also how can i remove original Filter Results by: or replace with this mod
http://floorz-n-more.com/
Well I haven't been stumped like this in quite some time. The best I've come up with so far is to remove the index_filters/template/default_filter.php. That stops the warning and logs I've mentioned. I can't find an admin setting having to do with manufacturers that lets this work. So after removing the default_filter.php and the site loads, if the filter sidebox is enabled, it breaks the column left and any sidebox that should appear after the filter box is blown out all over the site.
I have found settings regarding manufacturer in admin>config>product_listing. I only plan to use this filter on the product listing and advanced search pages. Where else might I find settings for manufacturer that might help resolve this?
Anymore help on this would of course be greatly appreciated.
Thank You, John
So, with the index_filters/template/default_filter.php in place, the filter sidebox enabled, viewing a category with products, I get the warning and error logs. If I make a selection from the filter side box the warning goes away and I get no error logs, but the site is still broken and nothing is filtered out.
I've got ZC 151 installed and working correctly now. I have the filter working, but for some reason it only works when it's on pages from the categories. If I'm in the new products page, or the all products page, the filter shows up, but isn't filtering. The all products and new products pages are EZ Pages I created, so maybe that has something to do with it? Where the filter isn't thinking it's on the all products page? Any ideas? Thanks guys.
I just happened to see in post 507 of this thread the following SQL:This can cause a problem if the mod has not been installed before, as configuration_group_title= 'Dynamic Filter' does not exist and thus configuration_group_id will be null (can be expressed as "0"). There is a configuration_group_id of 0 in the stock Zen Cart db, and this will be deleted by this code.Code:SELECT @cid:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'Dynamic Filter';
DELETE FROM configuration WHERE configuration_group_id = @cid;
DELETE FROM configuration_group WHERE configuration_group_id = @cid;
There is a recommended alteration to this kind of SQL for all mod authors to use, given in this sticky thread:
http://www.zen-cart.com/showthread.p...tall-sql-files
I don't think I'm versed enough to actually change the sql file. Can it be explained rather easily? Or should I look for a different solution to get the filter to work on the all products page? thanks everyone
This is taken care of in the upcoming releaseQuote:
Originally Posted by gjh42
Awesome. Thanks.
I'm assuming this is the only thread for this dynamic filter, so if I need to post this somewhere else, please let me know. But I had a question about the way this filter works. I know it uses attributes and I've gotten it to filter through the categories. On my site though, it will help to have options on some of the products as well. For example, being able to filter by shirt color, and once you're on the product info page, then having attributes to select the size before it's added to the cart. Is there a way to separate the 2 so only some attributes show up in dynamic filter, and some show up on the product info page?
In the admin, there is an option to include/exclude certain attributes from the filterQuote:
Originally Posted by Craig Freeburg
I've been running version 1.0 of this filter (with some issues as it doesn't work or look quite right) on a manually installed ver 1.51 of Zencart. Now that I see there's an upgrade, are there any specific upgrading instructions? I searched this thread with no results. Thank you
any chance a working version of this mod will be released? I can't seem to get this to work like at all. Everything about it breaks. Error logs fill up with everything from improper use of php functions to missing table names in queries. The sidebox breaks and all other sidebox contents end up all over the main page.
What a major let down.
So still working on this mod from time to time, but lacking the time to fish it up.
But I wanted to at least show you this update.
I did by accident more or less discover how to change the number of filtered products shown between the brackets.
If you search in file includes/templates/YOUR_TEMPLATE/sideboxes/tpl_dynamic_filter.php.
and change
toPHP Code:htmlspecialchars(html_entity_decode($attributes->fields['quantity'], ENT_QUOTES))
the number also changes to the number of products left on which to filter.PHP Code:htmlspecialchars(html_entity_decode($attributes->fields['flag'], ENT_QUOTES))
You can see it in action here
Well done! Such a seemingly simple change for such a big effect. Thank you.
(For some reason the number of products left does not decrease on one of my attributes - it actually increases, I'll need to dig deeper on that one)
Hello, Will this dynamic filter work under ZenCart 1.5.4?
If yes, can you please provide me with a download link?
Thank you very much,
Admir M.
It will work with 1.5.4. You can download the latest version of the module and use the file set for Zen Cart 1.5.1
except for the file includes/functions/functions_general.php. There you will need to make only 1 small change
find:
and replace withPHP Code:function zen_get_all_get_params($exclude_array = array(), $search_engine_safe = true) {
if (!is_array($exclude_array)) $exclude_array = array();
$exclude_array = array_merge($exclude_array, array(zen_session_name(), 'main_page', 'error', 'x', 'y'));
$get_url = '';
if (is_array($_GET) && (sizeof($_GET) > 0)) {
reset($_GET);
while (list($key, $value) = each($_GET)) {
if (!in_array($key, $exclude_array)) {
if (!is_array($value)) {
if (strlen($value) > 0) {
$get_url .= zen_sanitize_string($key) . '=' . rawurlencode(stripslashes($value)) . '&';
}
} else {
foreach(array_filter($value) as $arr){
$get_url .= zen_sanitize_string($key) . '[]=' . rawurlencode(stripslashes($arr)) . '&';
}
}
}
}
}
while (strstr($get_url, '&&')) $get_url = str_replace('&&', '&', $get_url);
while (strstr($get_url, '&&')) $get_url = str_replace('&&', '&', $get_url);
return $get_url;
}
PHP Code:function zen_get_all_get_params($exclude_array = array(), $search_engine_safe = true) {
if (!is_array($exclude_array)) $exclude_array = array();
$exclude_array = array_merge($exclude_array, array(zen_session_name(), 'main_page', 'error', 'x', 'y'));
$get_url = '';
if (is_array($_GET) && (sizeof($_GET) > 0)) {
reset($_GET);
while (list($key, $value) = each($_GET)) {
// bof dynamic filter 1 of 1
if ( (!in_array($key, $exclude_array)) && (is_string($value) && strlen($value) > 0 || is_array($value) && array_filter($value) ) && ($key != 'main_page') && ($key != zen_session_name()) && ($key != 'error') && ($key != 'x') && ($key != 'y') ) {
// eof dynamic filter 1 of 1
if (!is_array($value)) {
if (strlen($value) > 0) {
$get_url .= zen_sanitize_string($key) . '=' . rawurlencode(stripslashes($value)) . '&';
}
} else {
foreach(array_filter($value) as $arr){
$get_url .= zen_sanitize_string($key) . '[]=' . rawurlencode(stripslashes($arr)) . '&';
}
}
}
}
}
while (strstr($get_url, '&&')) $get_url = str_replace('&&', '&', $get_url);
while (strstr($get_url, '&&')) $get_url = str_replace('&&', '&', $get_url);
return $get_url;
}
Design75 ... do you mind if I challenge that?
I'm thinking that code change is redundant. Can you help me understand what I'm missing?
Note the things I've highlighted below, as I think your suggested code change is duplicating what's already in that function's logic:
My point is really: if no changes are needed, then it's better not to touch the file.Code:function zen_get_all_get_params($exclude_array = array(), $search_engine_safe = true) {
if (!is_array($exclude_array)) $exclude_array = array();
$exclude_array = array_merge($exclude_array, array(zen_session_name(), 'main_page', 'error', 'x', 'y'));
$get_url = '';
if (is_array($_GET) && (sizeof($_GET) > 0)) {
reset($_GET);
while (list($key, $value) = each($_GET)) {
// bof dynamic filter 1 of 1
if ( (!in_array($key, $exclude_array)) && (is_string($value) && strlen($value) > 0 || is_array($value) && array_filter($value) ) && ($key != 'main_page') && ($key != zen_session_name()) && ($key != 'error') && ($key != 'x') && ($key != 'y') ) {
// eof dynamic filter 1 of 1
if (!is_array($value)) {
if (strlen($value) > 0) {
$get_url .= zen_sanitize_string($key) . '=' . rawurlencode(stripslashes($value)) . '&';
}
} else {
foreach(array_filter($value) as $arr){
$get_url .= zen_sanitize_string($key) . '[]=' . rawurlencode(stripslashes($arr)) . '&';
}
}
}
}
}
while (strstr($get_url, '&&')) $get_url = str_replace('&&', '&', $get_url);
while (strstr($get_url, '&&')) $get_url = str_replace('&&', '&', $get_url);
return $get_url;
}
I must admit I do not fully understand the code , but just compared old 1.5.1 and new 1.5.4 vanilla files end the code from the mod.Quote:
Originally Posted by DrByte
This was the line that was left after comparing, but is you say it is not needed, (and after some better reading of that code block) I agree it seems unnecessary.
I am going to test it right now, and will report back.
Thank you for pointing this out. I received a "403 page not found" error when selecting price as part of the filter. I searched high and low over the last week or so to see if I could find a solution but to no avail. After seeing this post over the weekend, I contacted my host this morning and they made some changes on their side and voila, the price filter is working again.Quote:
Originally Posted by Eerin
Power to the people that support community based projects!
I just want to say THANK YOU ALL for the reply. I will integrate and test the filter under 1.5.4.
Best Regards,
Admir M.
I am looking for Beta testers of the latest version of this mod.
If you are interested in seriously testing this mod please send me a PM.
There has been some major code shuffling. Moving Queries to the modules files and html stuff to to tpl files.
- New in this release are some additional choices: Filter by price can be switched on and off in the admin
- The number of products left behind the attributes can be switched on and of
- There have been added some language defines to make the module multilingual
I've been messaging Design75 about these issues, I just thought I'd post here so I didn't bother him as much, as well as maybe help others that may be facing the same issues. I'm still on zencart 1.5.1 and have the filter working on index pages within each category. But when on the products_all page, the filter doesn't work at all. Also on the all products page, is another filter added, for categories. It makes complete sense why this wouldn't show up on the other pages, because you're already inside a category and filtering them wouldn't do anything. I don't know if they should work the same, so I started comparing files within each folder.
Inside of the latest Dynamic Filter download is
includes > modules > pages > header_php
includes > modules > pages > jscript_dynamic_filter
But there are no files for the Index pages folder.
Within the current site, there are
includes > modules > pages > index > header_php
includes > modules > pages > index > main_template_vars
So I guess my main question is, should the index folder have a jscript file in it and that's why it's not working? Or could that be included in the main template php file?
Attachment 15029
This is the current "category" filter I'm trying to turn off. If it was actual category names, it might not be as bad. So there are a few options as far as fixes.
Craig,Quote:
Originally Posted by Craig Freeburg
You don't bother me :laugh: it is part of the job.
In the latest test version, all the jscript file were removed and replaced by on script in the templates folder. Please compare your installed version against the latest version. You know where to find it.
For all the other readers. We are very close on releasing the latest and greatest version of this module. There are as you can read above some small bugs to be removed, but that's all.
Thanks Erik,
I just compared the script on my site, to the one in the folder from the Dynamic download, and they're identical. So, that makes me even more confused. ha
:blush: Okay, forgot to merge two edits, please try again :oops:
Update: This may not be an issue for most that installing something fresh, but I wanted to post my solution since I posted the problem. That way if someone is facing that issue, they can also see the solution.
In my products_all folder was still a separate script to run the filter. In the new version they are working on now, the script is written all in one file. So I removed that script from the folder, leaving only the header php and it works fine now on all pages
I'm trying to rename the categories for the category filter. After quite a bit of searching, I've found 2 files that look like they could contain the language to pull the category names from. Either tpl_categories.php or tpl_dynamic_filter.php My main question is does zen cart give each category a specific name? Or are they just defined in some sort of category1, category2 way? If someone could look at those 2 files, or let me know how to find out the exact names of my categories, I could possibly make the changes. Thanks!
Hi,
I am using the stirling grand template on zen cart v 1.5.3 and wondered if this plugin would be suitable for both? if so, could someone tell me where would I find the download link for it as I can only find the link for v1.3.9, v1.5.0, and v1.5.1
Thanks in advance :)
Dee.
Dee,Quote:
Originally Posted by newbie_girl
There is no official download yet for ZC > 1.5.1, I am currently testing the one for 1.5.4. I have not looked worked on a version for 1.5.3, but I can take a look for you what is needed to make it work with 1.5.3.
Hi, That would be brilliant if you could :) Thanks very much. I will keep a look out for any news.Quote:
Originally Posted by Design75
I have had a loo at the files, and basically you can install the latest Dynamic Filter version available, using the file set for zc 1.5.1. When installing, skip the file changes there are for "includes/functions/functions_general.php". You can use the original that came wit Zen Cart 1.5.3.Quote:
Originally Posted by newbie_girl
Excellent! Thank you very much :)Quote:
Originally Posted by Design75
Sorry, just a quick question, can I use the Installation instructions for Zen Cart version 1.5.0? As I can't see any for zc v 1.5.1.
Thank you :)
yes, you can. The only difference between the different versions is the functions_general.php file.
Thank you so much for your help :) I have followed the instructions and can now see the filter in my store. It works lovely and is just what I was looking for however I have just one little problem, when I go to admin> configuration> Im not seeing the Dynamic Filter option. I've obviously gone wrong somewhere but Ive gone over and over the instructions and can't find anything that might be the problem. Sorry to be a pest but would you have any idea what I'm missing?Quote:
Originally Posted by Design75
Thanks,
Dee
When you copied the file \admin\includes\languages\english\extra_definitions\dynamic_attribute_filter_def initions.php to your server, did you also copy it to any additional languages?Quote:
Originally Posted by newbie_girl
This file specifies the name for the configuration menu.
No, I only copied it to admin/includes/languages/english/extra_definitionsQuote:
Originally Posted by Design75
I am using 1.5.4: Have you had the change to finish your testing for that version?Quote:
Originally Posted by Design75
Nope. Still working on a strange bug when filtering categories and manufacturers, and my time is limited. Paying customers go first :cool:Quote:
Originally Posted by adb34
You can use the latest version for now, and skip the edits on the functions_genral.php file
I have this installed on a Zen Cart 1.5.4 using your tip to 'skip the functions_genral.php file'
I'm having one issue. The filtering is only offering the manufacturer and price options and none of the attributes. My understanding is leaving the Include Options and Exclude Options blank would add any attributes that exist (on the product category being viewed) as filtering options.
Is that incorrect, or is there something else going on?
Hi!Quote:
Originally Posted by Design75
To resolve the strange problem when filtering categories and manufacturers, in catalog/includes/templates/YOUR_TEMPLATE/sideboxes/tpl_dynamic_filter.php
after: if (count($unfilteredCategories) > 0) {
insert
$group = DYNAMIC_FILTER_PREFIX . str_replace(' ', '', DYNAMIC_FILTER_CATEGORY_GROUP);
AND
after: if (count($unfilteredManufacturers) > 0) {
insert
$group = DYNAMIC_FILTER_PREFIX . str_replace(' ', '', DYNAMIC_FILTER_MANUFACTURER_GROUP);
Thank you for your input. It it very much appreciated.:thumbsup: Those line were already present in the code, but in rearranging the code were moved to "includes/modules/sideboxes/YOUR_TEMPLATE/dynamic_filter.php".Quote:
Originally Posted by xergos055
I will update the code and test it. After that the only hurdle is to update the documentation.
Edit: the change in the code works :clap:
With welcome!
Did it work? I installed this module to 1.5.4 version and I have a problem to finsh this instalation. When I insert SQL code for finish, system write always WARNING: An Error occurred, please refresh the page and try again. I changed functions_general.php also, but no changes. Does anybody know where is a problem?
hello I need your help, I have zencart 1.5.3 and the plugin I've tested and works correctly, but the problem is that I have deactivated left and right columns, then I need to visualize the plugin on top of each category, which is the php code that calls the function or could do? I tried with css but it still fails and this plugin is essential for me ... please help thanks !!!!
Sorry to tell you, but currently the one column feature is not yet supported by this module. It is on my (very long) to do list, but I really can't promise any time frame. I you are haing some spare time, feel free to help with this module, and I'll add your code to it.Quote:
Originally Posted by uriii
if possible I would compensate by paypal, thank you in advance !!!!!:DQuote:
Originally Posted by Design75
When looking for a nice filter for my product pages (instead of the filter by alphabeth) I come across this one. I like it allot, because it solves a lot of problems like:
I would like to have a left colomn, but only with something usefull in it and wauw this is it!
I think the most important thing for customers is to be able to sort by price. The most user friendly one, i think, is the option to choise from 0 - 50 dollar, 50 - 100 dollar etc. No dropdown, not have to move your big finger over the little screan from left to right, and so on.
What i could not find with the search button for this thread is how and if it shows on mobile phones.
(I am using zencart 1.5.4. with the westminster new template)
I started with winmerge to compage the files from the dynimac filter, to the ones from my webshop.
But after that i donīt know what else to do, because the readme is not working.
Can someone copie that for me, or tell me what it says?
I'm sorry for having another question this quick :blush:
I have some files te changes but I don't know how to, because i have not enough experience.
For example this one:
Featured products header
[/PHP]PHP Code:[PHP]<?php
/**
* Featured Products
*
* @package page
* @copyright Copyright 2003-2006 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
* @version $Id: header_php.php 6912 2007-09-02 02:23:45Z drbyte $
*/
require(DIR_WS_MODULES . zen_get_module_directory('require_languages.php'));
$breadcrumb->add(NAVBAR_TITLE);
// display order dropdown
$disp_order_default = PRODUCT_FEATURED_LIST_SORT_DEFAULT;
require(DIR_WS_MODULES . zen_get_module_directory(FILENAME_LISTING_DISPLAY_ORDER));
$featured_products_array = array();
// bof dynamic filter 1 of 1
include(DIR_WS_MODULES . zen_get_module_directory(FILENAME_DYNAMIC_FILTER));
$listing_sql = "SELECT p.products_id, p.products_type, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name,
p.products_model, p.products_quantity, p.products_weight, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status, p.master_categories_id, m.manufacturers_id";
$listing_sql .= " FROM " . TABLE_PRODUCTS . " p LEFT JOIN " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id" .
" LEFT JOIN " . TABLE_FEATURED . " f on p.products_id = f.products_id" .
" LEFT JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c on p.products_id = p2c.products_id" .
" LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id" .
($filter_attr == true ? " JOIN " . TABLE_PRODUCTS_ATTRIBUTES . " p2a on p.products_id = p2a.products_id" .
" JOIN " . TABLE_PRODUCTS_OPTIONS . " po on p2a.options_id = po.products_options_id" .
" JOIN " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov on p2a.options_values_id = pov.products_options_values_id" .
(defined('TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK') ? " JOIN " . TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK . " p2as on p.products_id = p2as.products_id " : "") : '');
$listing_sql .= " WHERE p.products_status = 1 and f.status = 1 and pd.language_id = :languagesID " .
$filter . " GROUP BY p.products_id " . $having . $order_by;
$listing_sql = $db->bindVars($listing_sql, ':languagesID', $_SESSION['languages_id'], 'integer');
$featured_products_split = new splitPageResults($listing_sql, MAX_DISPLAY_PRODUCTS_FEATURED_PRODUCTS);
// eof dynamic filter 1 of 1
//check to see if we are in normal mode ... not showcase, not maintenance, etc
$show_submit = zen_run_normal();
// check whether to use multiple-add-to-cart, and whether top or bottom buttons are displayed
if (PRODUCT_FEATURED_LISTING_MULTIPLE_ADD_TO_CART > 0 and $show_submit == true and $featured_products_split->number_of_rows > 0) {
// check how many rows
$check_products_all = $db->Execute($featured_products_split->sql_query);
$how_many = 0;
while (!$check_products_all->EOF) {
if (zen_has_product_attributes($check_products_all->fields['products_id'])) {
} else {
// needs a better check v1.3.1
if ($check_products_all->fields['products_qty_box_status'] != 0) {
if (zen_get_products_allow_add_to_cart($check_products_all->fields['products_id']) !='N') {
if ($check_products_all->fields['product_is_call'] == 0) {
if ((SHOW_PRODUCTS_SOLD_OUT_IMAGE == 1 and $check_products_all->fields['products_quantity'] > 0) or SHOW_PRODUCTS_SOLD_OUT_IMAGE == 0) {
if ($check_products_all->fields['products_type'] != 3) {
if (zen_has_product_attributes($check_products_all->fields['products_id']) < 1) {
$how_many++;
}
}
}
}
}
}
}
$check_products_all->MoveNext();
}
if ( (($how_many > 0 and $show_submit == true and $featured_products_split->number_of_rows > 0) and (PRODUCT_FEATURED_LISTING_MULTIPLE_ADD_TO_CART == 1 or PRODUCT_FEATURED_LISTING_MULTIPLE_ADD_TO_CART == 3)) ) {
$show_top_submit_button = true;
} else {
$show_top_submit_button = false;
}
if ( (($how_many > 0 and $show_submit == true and $featured_products_split->number_of_rows > 0) and (PRODUCT_FEATURED_LISTING_MULTIPLE_ADD_TO_CART >= 2)) ) {
$show_bottom_submit_button = true;
} else {
$show_bottom_submit_button = false;
}
}
?>
Has to go into this one (my file)
I see where bof 1 of 1 begins and ends, but because my file looks so differend i really don't know wich is wich and what i should replace.PHP Code:<?php
/**Single Listing Template mod v1.8
* Featured Products header_php.php
*
* @package page
* @copyright Copyright 2003-2006 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
* @version $Id: header_php.php 6912 2007-09-02 02:23:45Z drbyte $
*/
require(DIR_WS_MODULES . zen_get_module_directory('require_languages.php'));
$breadcrumb->add(NAVBAR_TITLE);
// display order dropdown
$disp_order_default = PRODUCT_FEATURED_LIST_SORT_DEFAULT;
require(DIR_WS_MODULES . zen_get_module_directory(FILENAME_LISTING_DISPLAY_ORDER));
$featured_products_array = array();
$listing_sql = "SELECT p.products_id, p.products_type, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call,
p.product_is_always_free_shipping, p.products_qty_box_status,
p.master_categories_id, m.manufacturers_id
FROM (" . TABLE_PRODUCTS . " p
LEFT JOIN " . TABLE_MANUFACTURERS . " m on (p.manufacturers_id = m.manufacturers_id), " .
TABLE_PRODUCTS_DESCRIPTION . " pd
LEFT JOIN " . TABLE_FEATURED . " f on pd.products_id = f.products_id )
WHERE p.products_status = 1 and p.products_id = f.products_id and f.status = 1
AND p.products_id = pd.products_id and pd.language_id = :languagesID " .
$order_by;
$listing_sql = $db->bindVars($listing_sql, ':languagesID', $_SESSION['languages_id'], 'integer');
$featured_products_split = new splitPageResults($featured_products_query_raw, MAX_DISPLAY_PRODUCTS_FEATURED_PRODUCTS);
//check to see if we are in normal mode ... not showcase, not maintenance, etc
$show_submit = zen_run_normal();
$define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL,
'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME,
'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER,
'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE,
'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY,
'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT,
'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE);
/* ,
'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW);
*/
asort($define_list);
reset($define_list);
$column_list = array();
foreach ($define_list as $key => $value)
{
if ($value > 0) $column_list[] = $key;
}
?>
I don't want to break anything offcorse. It's just that I never build websites and therefor can not read the code :blush:
Seeing the files in color in my post above, made it easyer for me to see what i am doing. SO i tryed to change the 4 files i still needed to do and then installed the sql.
It did not work, had to use the second one given by design in this thread.
Then i turned on the dynamic filter in the layout contole and there it is, BUT
I now see brand, color and name, but i swear i just saw a lot more before i refreshed the page. Am I going crazy or....
Am I doing something wrong? (i don't have a readme so i don't know)
I need a little help again :blush:
For the westminster new template I had to install this file:
includes/modules/pages/specials/header.php
I know have to change is for the dynamic filter to work.
But because the code is so very different, i don't know how to do that.
This is the westminster specials header
And this is the specials file with a BOF I have to put in the westminster specials header filePHP Code:<?php
/** Single Listing template mod v1.8
* Specials header_php.php
*
* @package page
* @copyright Copyright 2003-2006 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
* @version $Id: header_php.php 3000 2006-02-09 21:11:37Z wilt $
*/
require(DIR_WS_MODULES . zen_get_module_directory('require_languages.php'));
$breadcrumb->add(NAVBAR_TITLE);
//lines25-71 moved to main_template_vars
//bof Single Listing Template
if (MAX_DISPLAY_SPECIAL_PRODUCTS > 0 ) {
$disp_order_default = PRODUCT_ALL_LIST_SORT_DEFAULT;
require(DIR_WS_MODULES . zen_get_module_directory(FILENAME_LISTING_DISPLAY_ORDER));
$order_by = isset($order_by) ? $order_by : 'ORDER BY s.specials_date_added DESC';
if (MAX_DISPLAY_SPECIAL_PRODUCTS > 0 ) {
$listing_sql = "SELECT p.products_id, p.products_image, pd.products_name,
p.master_categories_id, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight
FROM (" . TABLE_PRODUCTS . " p
LEFT JOIN " . TABLE_SPECIALS . " s on p.products_id = s.products_id
LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id
LEFT JOIN " . TABLE_MANUFACTURERS . " m ON (p.manufacturers_id = m.manufacturers_id))
WHERE p.products_id = s.products_id and p.products_id = pd.products_id and p.products_status = '1'
AND s.status = 1
AND pd.language_id = :languagesID
ORDER BY s.specials_date_added DESC";
$listing_sql = $db->bindVars($listing_sql, ':languagesID', $_SESSION['languages_id'], 'integer');
//check to see if we are in normal mode ... not showcase, not maintenance, etc
$show_submit = zen_run_normal();
$define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL,
'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME,
'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER,
'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE,
'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY,
'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT,
'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE);
/* ,
'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW);
*/
asort($define_list);
reset($define_list);
$column_list = array();
foreach ($define_list as $key => $value)
{
if ($value > 0) $column_list[] = $key;
}
}
}//eof Single Listing Template
?>
Can someone help me with this? I have everything working fine, except for this file so now I get a blanc page on the specials.PHP Code:<?php
/**
* Specials
*
* @package page
* @copyright Copyright 2003-2006 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
* @version $Id: header_php.php 3000 2006-02-09 21:11:37Z wilt $
*/
require(DIR_WS_MODULES . zen_get_module_directory('require_languages.php'));
$breadcrumb->add(NAVBAR_TITLE);
// bof dynamic filter 1 of 1
if (MAX_DISPLAY_SPECIAL_PRODUCTS > 0 ) {
include(DIR_WS_MODULES . zen_get_module_directory(FILENAME_DYNAMIC_FILTER));
$listing_sql = "SELECT DISTINCT p.products_id, p.products_image, pd.products_name, p.master_categories_id, p.manufacturers_id";
$listing_sql .= " FROM " . TABLE_PRODUCTS . " p LEFT JOIN " . TABLE_SPECIALS . " s on p.products_id = s.products_id" .
" LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id" .
" LEFT JOIN " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id" .
" LEFT JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c on p.products_id = p2c.products_id" .
($filter_attr == true ? " JOIN " . TABLE_PRODUCTS_ATTRIBUTES . " p2a on p.products_id = p2a.products_id" .
" JOIN " . TABLE_PRODUCTS_OPTIONS . " po on p2a.options_id = po.products_options_id" .
" JOIN " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov on p2a.options_values_id = pov.products_options_values_id" .
(defined('TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK') ? " JOIN " . TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK . " p2as on p.products_id = p2as.products_id " : "") : '');
$listing_sql .= " WHERE p.products_status = '1'".
" AND s.status = 1" .
" AND pd.language_id = :languagesID" . $filter . " GROUP BY p.products_id " . $having . 'ORDER BY s.specials_date_added DESC';
$listing_sql = $db->bindVars($listing_sql, ':languagesID', $_SESSION['languages_id'], 'integer');
$specials_split = new splitPageResults($listing_sql, MAX_DISPLAY_SPECIAL_PRODUCTS);
}
// eof dynamic filter 1 of 1
?>
I have not tested it, but i think the code below will workQuote:
Originally Posted by Pompidompie
PHP Code:<?php
/** Single Listing template mod v1.8
* Specials header_php.php
*
* @package page
* @copyright Copyright 2003-2006 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
* @version $Id: header_php.php 3000 2006-02-09 21:11:37Z wilt $
*/
require(DIR_WS_MODULES . zen_get_module_directory('require_languages.php'));
$breadcrumb->add(NAVBAR_TITLE);
//lines25-71 moved to main_template_vars
//bof Single Listing Template
// bof dynamic filter 1 of 1
if (MAX_DISPLAY_SPECIAL_PRODUCTS > 0 ) {
include(DIR_WS_MODULES . zen_get_module_directory(FILENAME_DYNAMIC_FILTER));
$disp_order_default = PRODUCT_ALL_LIST_SORT_DEFAULT;
require(DIR_WS_MODULES . zen_get_module_directory(FILENAME_LISTING_DISPLAY_ORDER));
$order_by = isset($order_by) ? $order_by : 'ORDER BY s.specials_date_added DESC';
if (MAX_DISPLAY_SPECIAL_PRODUCTS > 0 ) {
$listing_sql = "SELECT p.products_id, p.products_image, pd.products_name,
p.master_categories_id, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight
FROM " . TABLE_PRODUCTS . " p
LEFT JOIN " . TABLE_SPECIALS . " s on p.products_id = s.products_id
LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id
LEFT JOIN " . TABLE_MANUFACTURERS . " m ON p.manufacturers_id = m.manufacturers_id
LEFT JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c on p.products_id = p2c.products_id" .
($filter_attr == true ? " JOIN " . TABLE_PRODUCTS_ATTRIBUTES . " p2a on p.products_id = p2a.products_id" .
" JOIN " . TABLE_PRODUCTS_OPTIONS . " po on p2a.options_id = po.products_options_id" .
" JOIN " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov on p2a.options_values_id = pov.products_options_values_id" .
(defined('TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK') ? " JOIN " . TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK . " p2as on p.products_id = p2as.products_id " : "") : '') . "
WHERE p.products_id = s.products_id
AND p.products_id = pd.products_id
AND p.products_status = '1'
AND s.status = 1
AND pd.language_id = :languagesID " .
$filter . "
GROUP BY p.products_id " .
$having . "
ORDER BY s.specials_date_added DESC";
$listing_sql = $db->bindVars($listing_sql, ':languagesID', $_SESSION['languages_id'], 'integer');
//check to see if we are in normal mode ... not showcase, not maintenance, etc
$show_submit = zen_run_normal();
$define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL,
'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME,
'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER,
'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE,
'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY,
'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT,
'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE);
/* ,
'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW);
*/
asort($define_list);
reset($define_list);
$column_list = array();
foreach ($define_list as $key => $value)
{
if ($value > 0) $column_list[] = $key;
}
}
}//eof Single Listing Template
?>
Thank you Design.
Before, I got a blanc page witj absolutely nothing.
Now I see my webshop-the specials page again, but WARNING: An Error occurred, please refresh the page and try again.
When looking in the logs it says:
[10-Apr-2015 10:41:34 Europe/Berlin] PHP Warning: mysqli_query(): Empty query in C:\xampp\htdocs\zencart\includes\classes\db\mysql\query_factory.php on line 43
[10-Apr-2015 10:41:34 Europe/Berlin] PHP Fatal error: 0: :: ==> (as called by) C:\xampp\htdocs\zencart\includes\modules\pages\specials\main_template_vars.php on line 29 <== in C:\xampp\htdocs\zencart\includes\classes\db\mysql\query_factory.php on line 155
And if you replace the code from the earlier post with this one??Quote:
Originally Posted by Pompidompie
PHP Code:<?php
/** Single Listing template mod v1.8
* Specials header_php.php
*
* @package page
* @copyright Copyright 2003-2006 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
* @version $Id: header_php.php 3000 2006-02-09 21:11:37Z wilt $
*/
require(DIR_WS_MODULES . zen_get_module_directory('require_languages.php'));
$breadcrumb->add(NAVBAR_TITLE);
//lines25-71 moved to main_template_vars
//bof Single Listing Template
// bof dynamic filter 1 of 1
if (MAX_DISPLAY_SPECIAL_PRODUCTS > 0 ) {
include(DIR_WS_MODULES . zen_get_module_directory(FILENAME_DYNAMIC_FILTER));
$disp_order_default = PRODUCT_ALL_LIST_SORT_DEFAULT;
require(DIR_WS_MODULES . zen_get_module_directory(FILENAME_LISTING_DISPLAY_ORDER));
$order_by = isset($order_by) ? $order_by : 'ORDER BY s.specials_date_added DESC';
if (MAX_DISPLAY_SPECIAL_PRODUCTS > 0 ) {
$listing_sql = "SELECT p.products_id, p.products_image, pd.products_name,
p.master_categories_id, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight
FROM " . TABLE_PRODUCTS . " p
LEFT JOIN " . TABLE_SPECIALS . " s on p.products_id = s.products_id
LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id
LEFT JOIN " . TABLE_MANUFACTURERS . " m ON p.manufacturers_id = m.manufacturers_id
LEFT JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c on p.products_id = p2c.products_id" .
($filter_attr == true ? " JOIN " . TABLE_PRODUCTS_ATTRIBUTES . " p2a on p.products_id = p2a.products_id" .
" JOIN " . TABLE_PRODUCTS_OPTIONS . " po on p2a.options_id = po.products_options_id" .
" JOIN " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov on p2a.options_values_id = pov.products_options_values_id" .
(defined('TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK') ? " JOIN " . TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK . " p2as on p.products_id = p2as.products_id " : "") : '') . "
WHERE p.products_id = s.products_id
AND p.products_id = pd.products_id
AND p.products_status = '1'
AND s.status = 1
AND pd.language_id = :languagesID " .
$filter . "
GROUP BY p.products_id " .
$having . "
ORDER BY s.specials_date_added DESC";
$listing_sql = $db->bindVars($listing_sql, ':languagesID', $_SESSION['languages_id'], 'integer');
$specials_split = new splitPageResults($listing_sql, MAX_DISPLAY_SPECIAL_PRODUCTS);
//check to see if we are in normal mode ... not showcase, not maintenance, etc
$show_submit = zen_run_normal();
$define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL,
'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME,
'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER,
'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE,
'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY,
'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT,
'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE);
/* ,
'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW);
*/
asort($define_list);
reset($define_list);
$column_list = array();
foreach ($define_list as $key => $value)
{
if ($value > 0) $column_list[] = $key;
}
}
}//eof Single Listing Template
?>
My first language is Dutch.
I see my website, I see the specials page, I see the breadcrums, but nothing below, the warning message is also gone.
But
The second language is English and there, when i click on the specials page, I get a blanc page again.
Logs:
[10-Apr-2015 11:00:54 Europe/Berlin] PHP Parse error: syntax error, unexpected 't' (T_STRING) in C:\xampp\htdocs\zencart\includes\languages\english\specials.php on line 24
I have removed a line from the languages file that should not be there and tatatatata at a first look everything works again.
Offcorse I still have to test it, to see that there is not still something wrong somewhere, but he, its a start.
Thank you so much Design!
That is not an isssue with the module, but you probably edited that fale and mad an error. Paste the contents and I'll take a lookQuote:
Originally Posted by Pompidompie
Yes your right. I had the problem that whem featured products is empty it shows TEXT_NO_PRODUCTS instead off the text sorry no products here (or something) So i fixed that with adding a define TEXT_NO_PRODUCTS to the featured products and specials languages files.
Its was fixing that problem, but then it made a new problem with giving me blanc pages after installing the dynamic filter.
So.... now I removed the Define TEXT_NO_PRODUCTS lines from the featured products and specials languages files. Solved my dynamic filter blanc page problem with that, but it gave me back the problem that the text TEXT_NO_PRODUCTS is showing again.
Keeps me busy :bow:
:laugh::thumbsup:
While reading this thread I noticed that everytime i see someone talking about the price, or when i see a picture, it is having two numbers. Like
1 - 20
20 - 50
50 - 70
etc.
Is that something that needs to be done by yourself, or should it normaly look that way?
I also have a problem with the price, and some others, that i took a picture off
Here you see, on the right, the all products page with demo products.
On the left you see the problem with the price option.
Attachment 15148
Design75 you are dutch too?
I would like to ask the above question in dutch then, because my english is not that good :blush:
Ik zie steeds bij andere dynamic filter gebruikers de prijsfilter met 2 getallen. Dus 0 tot 50 euro, 50 tot 100 euro,etc
En bij mij is dat 1 getal.
Tenminste als ik naar by amount moet kijken.
Moet ik dat zelf instellen, kijk ik naar het verkeerde of gaat er gewoon iets fout?
I would like to make it, that it says,
to 50
to 100
to 150
And this option needs to be there on every page.
Can i do that with dynamic filter?
Yeeeejjj I did it.
This is what was wrong:
When putting the install into the database, somehow it left out the SHOW_FILTER_BY_PRICE part.
I put it in there by hand and now it shows up. WITH the 0-25, 25-50, 50-100 and so on.
Wow i have been looking at this for ours, so happy that I found it :bow:
Having a problem.
I just installed the addon stock by attributes.
That addon does not changes anything in the product listing, but yet, something moved my products to under the left sidebox.
Like this
Attachment 15159
I thought i had seen somebody with the same problem in this thread, but can't find it anymore.
Is it a problem with the dynamic filters and if so, how do i fix this?
Is it possible to filter by product availability and show in a sidebox?
So that customers can see which products are selling fast and having dwindling stock?
No not in the current version. You would have to create that filter yourselves, by writing some new code for the moduleQuote:
Originally Posted by zenartman
Is Dynamic Filter compatible with with v1.5.4 Zen?
I am having problems loading this to v1.5.4Quote:
Originally Posted by Kevin205
With some modifications to some of the files I was able to get this to work.Quote:
Originally Posted by adb34
However I do not remember the file changes, the "BEST" option is to do a file comparison most of the SBA changes are clearly marked
Did you download the Dynamic filter from: https://www.zen-cart.com/downloads.php?do=file&id=1361?
It says it's only compatible with Zen CartŪ Versions: v1.3.9, v1.5.0, v1.5.1 ?
Quote:
Originally Posted by Pompidompie
I'm using 1.1 version of this module and ZC 1.5.0. I have also the price range issue like 18-98, 98-178, 178-278. Can you give me some hint how to get ranges like 0-100, 100-200, 200-300 ?
thx!
Any idea please ?
Greetings All,
Reading through the thread, it seems that various folks have tweaked Dynamic Filters to work with 1.5.4. There has also been mention of updating the plugin, but still see version 1.2 from Dec 5th, 2014.
Any chance of getting an updated copy that works with ZC 1.5.4?:no: :yes:
Much appreciated!:thumbsup:
hi,
excellent plugin. well happy
now to my problem.
I want the filter to display items with tax, my site displays items with tax so the filter shows different prices.
i have looked back through but not found an answer to it. (or im blind)
please help
dave
i use 1.5.4
i had to merge the code over.
i will find my files and post link
here is a link to my amended "dynamic filter" which works with 1.5.4
http://www.tlsystems.co.uk/support/Z....2-amended.zip
I have added a folder 1.5.4 to main archive, just follow instructions for previous versions.
take a backup of any files your going to overwrite.
rename the admin folder to yours
rename the YOUR_TEMPLATE folders to your template name
upload files
import sql
and it should work.
mine does, one thing to do is add a admin menu feature to show filter including tax "yes/no".
Thank you, Chief!
I am getting the following error: [27-Jun-2015 00:04:34 EST5EDT] [client 64.7.70.206 ] PHP Fatal error: Call to undefined function zen_get_module_directory() in /big/dom/xscholledresses/www/includes/classes/split_page_results.php on line 28
Can anyone help me debug this?
I am running 1.5.4
This line
Produces this error:PHP Code:// bof dynamic filter 1 of 2
include(DIR_WS_MODULES . zen_get_module_directory(FILENAME_DYNAMIC_FILTER));
// eof dynamic filter 1 of 2
[27-Jun-2015 00:04:34 EST5EDT] [client 64.7.70.206 ] PHP Fatal error: Call to undefined function zen_get_module_directory() in /big/dom/xscholledresses/www/includes/classes/split_page_results.php on line 28
What is wrong?