I'm not sure how I can go about fixing this problem. I modified my advanced_search_result header.php file to accomodate for a product type and searches against the data table where the information is. Here is the new modified form.
After much and some scrambling, I managed to modify my advanced_search_results/header.php file so that is now searches the database and does a proper LEFT JOIN of the tables in question. I now get a proper set of results.
However, what I noticed is that if you click on any of the navigation helpers (either the next button or page numbers) instead of returning this limited section of results, ZenCart returns the entire dump of the products table:
Here's something else I noticed, here is the address bar of the first page of results:
http://www.localhost.com/zencart/index.php?main_page=advanced_search_result&keyword=&search_in_description=1&cate gories_id=&inc_subcat=1&manufacturers_id=&pfrom=&pto=&dfrom=mm%2Fdd%2Fyyyy&dto=m m%2Fdd%2Fyyyy&ufs_card_type_is=yes&ufs_card_type=&ufs_card_rarity_is=yes&ufs_car d_rarity=&ufs_resources_is=all&ufs_resources%5B%5D=evil&ufs_resources%5B%5D=orde r&ufs_comp_direction=eq&ufs_difficulty=&ufs_keyword_exact=any&ufs_block_mod=&ufs _block_level=&ufs_atk_speed=&ufs_atk_level=&ufs_atk_dmg=&x=43&y=22
Now here's the page in the address bar when I try to go to the next page:
http://www.localhost.com/zencart/index.php?main_page=advanced_search_result&search_in_description=1&inc_subcat=1& dfrom=mm%2Fdd%2Fyyyy&dto=mm%2Fdd%2Fyyyy&ufs_card_type_is=yes&ufs_card_rarity_is= yes&ufs_resources_is=all&ufs_comp_direction=eq&ufs_keyword_exact=any&sort=20a&pa ge=2
So I'm thinking the problem is, where's the rest of my search? Could it be because I included two sets of [] of array builders in the get request that ZenCart sanitized the URL and disabled them? (I used the ufs_resources[] method to build an array of checked of indexes. If anyone else has an idea about how to about this, I'm all ears.)
Can anyone figure out how do I go about fixing this?
Bookmarks