Tableau Responsive Theme - Support Thread

**leon2lil** · 30 Sep 2015, 12:21 PM

Thanks So Much Bislewl
Worked A Treat

Has any one noticed on a mobile device sometimes the logo gets cut in half.
Or is there a limit on the size of a logo I can change somewhere

Website address is prohairtherapyltd.co.uk.

**mikestaps** · 30 Sep 2015, 03:51 PM

I have been asked (via PM's) how I was able to add the Information drop down menu next to the Categories drop down menu in the header of my site - HERE. I have also noticed similar questions posted here, so rather than answer a few PM's I wanted to share this here.
I basically copied the tpl_modules_categories_tabs.php and renamed it tpl_modules_information_tabs.php.
I also created an information defines page to deal with the mobile version of the menu not expanding, when you click on the parent "category" in the information menu it loads this page.

Please do not just upload all of these files to your site, use them as a guide to edit your files, as I have other modules and add-ons installed.

Here are the files I changed/created...
information_tab.zip

**mikestaps** · 30 Sep 2015, 04:16 PM

Originally Posted by mikestaps

I have been asked (via PM's) how I was able to add the Information drop down menu next to the Categories drop down menu in the header of my site - HERE. I have also noticed similar questions posted here, so rather than answer a few PM's I wanted to share this here.
I basically copied the tpl_modules_categories_tabs.php and renamed it tpl_modules_information_tabs.php.
I also created an information defines page to deal with the mobile version of the menu not expanding, when you click on the parent "category" in the information menu it loads this page.

Please do not just upload all of these files to your site, use them as a guide to edit your files, as I have other modules and add-ons installed.

Here are the files I changed/created...
information_tab.zip

I forgot the css file... This goes in the templates/tableau/css folder

css.zip

**vanhorn_s** · 1 Oct 2015, 12:52 AM

Originally Posted by mikestaps

I have been asked (via PM's) how I was able to add the Information drop down menu next to the Categories drop down menu in the header of my site - HERE. I have also noticed similar questions posted here, so rather than answer a few PM's I wanted to share this here.
I basically copied the tpl_modules_categories_tabs.php and renamed it tpl_modules_information_tabs.php.
I also created an information defines page to deal with the mobile version of the menu not expanding, when you click on the parent "category" in the information menu it loads this page.

Please do not just upload all of these files to your site, use them as a guide to edit your files, as I have other modules and add-ons installed.

Here are the files I changed/created...
information_tab.zip

Thank you for this. Where are the names defined for this?
On my test site, I still have HEADER_TITLE_INFORMATION next to categories, rather than information, also HEADER_TITLE_CUSTOMER_SERVICE, and TITLE_GENERAL.

redsautorehab.com/newzen

**vanhorn_s** · 1 Oct 2015, 01:32 AM

In the left column sideboxes, the reviews sidebox has blue text that shows REVIEWS [MORE], and I cannot collapse the sidebox. The featured sidebox did the same thing, but I just turned it off, because I don't care about it.
Also, is there a way of setting the default sort order to best selling? When you navigate from a mobile device, it does not have the entire drop down menu, and so main categories are all you see, rather than sub categories.

http://redsautorehab.com/newzen/inde...index&cPath=13

**satello** · 4 Oct 2015, 11:13 AM

Hi everyone, long time since I retouched my heavily customized tableau. this morning i've installed the new one, over a 1.5.4 zencart, using old patched database.

before I go into extra custom work, just got this very odd problem. surely is just something in the settings I am missing...

Ok, in my old version (1.2) the main category page shows all the subcategories

http://www.londonsatman.co.uk/italian-satellite-tv-77/

with the same settings, but on the latest version of the template, the category main page show all the products present in the subcategories

http://www.londonsatman.co.uk/zencar...index&cPath=77

I would like the main category page to show subcategories, and also a small thumb for it. I remember when I tried to update a few months ago this was the result but as I was very busy I've abandoned the upgrade, but can't manage to have it now

here are a few conf settings:

Layout Settings

Main Page - Opens with Category 0
Categories - Always Open to Show SubCategories 1

many thanks for your time in reading this.

**mikestaps** · 8 Oct 2015, 03:32 PM

Originally Posted by satello

Hi everyone, long time since I retouched my heavily customized tableau. this morning i've installed the new one, over a 1.5.4 zencart, using old patched database.

before I go into extra custom work, just got this very odd problem. surely is just something in the settings I am missing...

Ok, in my old version (1.2) the main category page shows all the subcategories

http://www.londonsatman.co.uk/italian-satellite-tv-77/

with the same settings, but on the latest version of the template, the category main page show all the products present in the subcategories

http://www.londonsatman.co.uk/zencar...index&cPath=77

I would like the main category page to show subcategories, and also a small thumb for it. I remember when I tried to update a few months ago this was the result but as I was very busy I've abandoned the upgrade, but can't manage to have it now

here are a few conf settings:

Layout Settings

Main Page - Opens with Category 0
Categories - Always Open to Show SubCategories 1

many thanks for your time in reading this.

This is caused by a change in the includes\modules\pages\index\main_template_vars.php file
To switch back to the old way first uncomment lines 64 THROUGH 123 and line 126.

Code:

  /*$sql = "SELECT cd.categories_name, c.categories_image
          FROM   " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd
          WHERE      c.categories_id = :categoriesID
          AND        cd.categories_id = :categoriesID
          AND        cd.language_id = :languagesID
          AND        c.categories_status= '1'";

  $sql = $db->bindVars($sql, ':categoriesID', $current_category_id, 'integer');
  $sql = $db->bindVars($sql, ':languagesID', $_SESSION['languages_id'], 'integer');
  $category = $db->Execute($sql);

  if (isset($cPath) && strpos($cPath, '_'))
  {
    // check to see if there are deeper categories within the current category
    $category_links = array_reverse($cPath_array);
    for($i=0, $n=sizeof($category_links); $i<$n; $i++)
    {
      $sql = "SELECT count(*) AS total
              FROM   " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd
              WHERE      c.parent_id = :parentID
              AND        c.categories_id = cd.categories_id
              AND        cd.language_id = :languagesID
              AND        c.categories_status= '1'";

      $sql = $db->bindVars($sql, ':parentID', $category_links[$i], 'integer');
      $sql = $db->bindVars($sql, ':languagesID', $_SESSION['languages_id'], 'integer');
      $categories = $db->Execute($sql);

      if ($categories->fields['total'] < 1)
      {
        // do nothing, go through the loop
      } else {
        $categories_query = "SELECT c.categories_id, cd.categories_name, c.categories_image, c.parent_id
                             FROM   " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd
                             WHERE      c.parent_id = :parentID
                             AND        c.categories_id = cd.categories_id
                             AND        cd.language_id = :languagesID
                             AND        c.categories_status= '1'
                             ORDER BY   sort_order, cd.categories_name";

        $categories_query = $db->bindVars($categories_query, ':parentID', $category_links[$i], 'integer');
        $categories_query = $db->bindVars($categories_query, ':languagesID', $_SESSION['languages_id'], 'integer');
        break; // we've found the deepest category the customer is in
      }
    }
  } else {
    $categories_query = "SELECT c.categories_id, cd.categories_name, c.categories_image, c.parent_id
                         FROM   " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd
                         WHERE      c.parent_id = :parentID
                         AND        c.categories_id = cd.categories_id
                         AND        cd.language_id = :languagesID
                         AND        c.categories_status= '1'
                         ORDER BY   sort_order, cd.categories_name";

    $categories_query = $db->bindVars($categories_query, ':parentID', $current_category_id, 'integer');
    $categories_query = $db->bindVars($categories_query, ':languagesID', $_SESSION['languages_id'], 'integer');
  }
  $categories = $db->Execute($categories_query);
  $number_of_categories = $categories->RecordCount();
  $new_products_category_id = $current_category_id;*/

  /////////////////////////////////////////////////////////////////////////////////////////////////////
  //$tpl_page_body = 'tpl_index_categories.php';
  /////////////////////////////////////////////////////////////////////////////////////////////////////

Next comment out this section (129-196):

Code:

//BOF SHOW ALL PRODUCTS FOR PARENT CATEGORIES
   if (SHOW_PRODUCT_INFO_ALL_PRODUCTS == '1') {
    // set a category filter
    $new_products_category_id = $cPath;
  } else {
    // do not set the category
  }
  // create column list
  $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;
  }

  $select_column_list = '';

  for ($i=0, $n=sizeof($column_list); $i<$n; $i++)
  {
    switch ($column_list[$i])
    {
      case 'PRODUCT_LIST_MODEL':
      $select_column_list .= 'p.products_model, ';
      break;
      case 'PRODUCT_LIST_NAME':
      $select_column_list .= 'pd.products_name, ';
      break;
      case 'PRODUCT_LIST_MANUFACTURER':
      $select_column_list .= 'm.manufacturers_name, ';
      break;
      case 'PRODUCT_LIST_QUANTITY':
      $select_column_list .= 'p.products_quantity, ';
      break;
      case 'PRODUCT_LIST_IMAGE':
      $select_column_list .= 'p.products_image, ';
      break;
      case 'PRODUCT_LIST_WEIGHT':
      $select_column_list .= 'p.products_weight, ';
      break;
    }
  }
  // always add quantity regardless of whether or not it is in the listing for add to cart buttons
  if (PRODUCT_LIST_QUANTITY < 1) {
    $select_column_list .= 'p.products_quantity, ';
  }

  // set the product filters according to selected product type
  $typefilter = 'default';
  if (isset($_GET['typefilter'])) $typefilter = $_GET['typefilter'];
  require(zen_get_index_filters_directory($typefilter . '_filter.php'));

  ////////////////////////////////////////////////////////////////////////////////////////////////////////////
  $tpl_page_body = 'tpl_index_product_list.php';
  ////////////////////////////////////////////////////////////////////////////////////////////////////////////
   
   //EOF SHOW ALL PRODUCTS FOR PARENT CATEGORIES

This will revert to sub-category photos showing when a parent category is selected.

**satello** · 10 Oct 2015, 12:16 AM

YOU ARE A STAR, YOU REALLY ARE!!!

Thanks for your help, this has been bugging me for a week. Just a question, is this related to this template only, or it is for the core cart?

As I've asked the same question in the main forum, and nobody new anything, thinking as well that was a db problem.

**MIKEYFM** · 28 Oct 2015, 10:06 PM

Originally Posted by mikestaps

This is caused by a change in the includes\modules\pages\index\main_template_vars.php file
To switch back to the old way first uncomment lines 64 THROUGH 123 and line 126.

Code:

  /*$sql = "SELECT cd.categories_name, c.categories_image
          FROM   " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd
          WHERE      c.categories_id = :categoriesID
          AND        cd.categories_id = :categoriesID
          AND        cd.language_id = :languagesID
          AND        c.categories_status= '1'";

  $sql = $db->bindVars($sql, ':categoriesID', $current_category_id, 'integer');
  $sql = $db->bindVars($sql, ':languagesID', $_SESSION['languages_id'], 'integer');
  $category = $db->Execute($sql);

  if (isset($cPath) && strpos($cPath, '_'))
  {
    // check to see if there are deeper categories within the current category
    $category_links = array_reverse($cPath_array);
    for($i=0, $n=sizeof($category_links); $i<$n; $i++)
    {
      $sql = "SELECT count(*) AS total
              FROM   " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd
              WHERE      c.parent_id = :parentID
              AND        c.categories_id = cd.categories_id
              AND        cd.language_id = :languagesID
              AND        c.categories_status= '1'";

      $sql = $db->bindVars($sql, ':parentID', $category_links[$i], 'integer');
      $sql = $db->bindVars($sql, ':languagesID', $_SESSION['languages_id'], 'integer');
      $categories = $db->Execute($sql);

      if ($categories->fields['total'] < 1)
      {
        // do nothing, go through the loop
      } else {
        $categories_query = "SELECT c.categories_id, cd.categories_name, c.categories_image, c.parent_id
                             FROM   " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd
                             WHERE      c.parent_id = :parentID
                             AND        c.categories_id = cd.categories_id
                             AND        cd.language_id = :languagesID
                             AND        c.categories_status= '1'
                             ORDER BY   sort_order, cd.categories_name";

        $categories_query = $db->bindVars($categories_query, ':parentID', $category_links[$i], 'integer');
        $categories_query = $db->bindVars($categories_query, ':languagesID', $_SESSION['languages_id'], 'integer');
        break; // we've found the deepest category the customer is in
      }
    }
  } else {
    $categories_query = "SELECT c.categories_id, cd.categories_name, c.categories_image, c.parent_id
                         FROM   " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd
                         WHERE      c.parent_id = :parentID
                         AND        c.categories_id = cd.categories_id
                         AND        cd.language_id = :languagesID
                         AND        c.categories_status= '1'
                         ORDER BY   sort_order, cd.categories_name";

    $categories_query = $db->bindVars($categories_query, ':parentID', $current_category_id, 'integer');
    $categories_query = $db->bindVars($categories_query, ':languagesID', $_SESSION['languages_id'], 'integer');
  }
  $categories = $db->Execute($categories_query);
  $number_of_categories = $categories->RecordCount();
  $new_products_category_id = $current_category_id;*/

  /////////////////////////////////////////////////////////////////////////////////////////////////////
  //$tpl_page_body = 'tpl_index_categories.php';
  /////////////////////////////////////////////////////////////////////////////////////////////////////

Next comment out this section (129-196):

Code:

//BOF SHOW ALL PRODUCTS FOR PARENT CATEGORIES
   if (SHOW_PRODUCT_INFO_ALL_PRODUCTS == '1') {
    // set a category filter
    $new_products_category_id = $cPath;
  } else {
    // do not set the category
  }
  // create column list
  $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;
  }

  $select_column_list = '';

  for ($i=0, $n=sizeof($column_list); $i<$n; $i++)
  {
    switch ($column_list[$i])
    {
      case 'PRODUCT_LIST_MODEL':
      $select_column_list .= 'p.products_model, ';
      break;
      case 'PRODUCT_LIST_NAME':
      $select_column_list .= 'pd.products_name, ';
      break;
      case 'PRODUCT_LIST_MANUFACTURER':
      $select_column_list .= 'm.manufacturers_name, ';
      break;
      case 'PRODUCT_LIST_QUANTITY':
      $select_column_list .= 'p.products_quantity, ';
      break;
      case 'PRODUCT_LIST_IMAGE':
      $select_column_list .= 'p.products_image, ';
      break;
      case 'PRODUCT_LIST_WEIGHT':
      $select_column_list .= 'p.products_weight, ';
      break;
    }
  }
  // always add quantity regardless of whether or not it is in the listing for add to cart buttons
  if (PRODUCT_LIST_QUANTITY < 1) {
    $select_column_list .= 'p.products_quantity, ';
  }

  // set the product filters according to selected product type
  $typefilter = 'default';
  if (isset($_GET['typefilter'])) $typefilter = $_GET['typefilter'];
  require(zen_get_index_filters_directory($typefilter . '_filter.php'));

  ////////////////////////////////////////////////////////////////////////////////////////////////////////////
  $tpl_page_body = 'tpl_index_product_list.php';
  ////////////////////////////////////////////////////////////////////////////////////////////////////////////
   
   //EOF SHOW ALL PRODUCTS FOR PARENT CATEGORIES

This will revert to sub-category photos showing when a parent category is selected.

This is exactly what I wanted to get the category listing back but it seems to break the sort filter and the listing the products by cheapest to highest price. Or the old to new . I am not sure if you can have both. It would be good if you can as the price low to high is a nice feature..

Has anyone else noticed this and is there a fix somewhere that I have not been able to see on the forum/thread.

Thank you.

MG

**chrx** · 17 Nov 2015, 07:09 PM

I downloaded Tableau v1.6.6 through Zen Cart and installed it as part of an upgrade to ZC 1.5. I would like to have subcategories show in the body of the page, when a category is selected from the menu. At this time, selecting a category shows the products in that category. I followed the instructions shown in post #425, but I ended up getting a blank page result. Is there a new way to get my subcategories to show when I select a category? I have been looking around, but have found nothing else.
Thank you!

Thread: Tableau Responsive Theme - Support Thread

Thread Tools

Search Thread

Display

Hybrid View

Re: Tableau Responsive Theme - Support Thread

Re: Tableau Responsive Theme - Support Thread

Re: Tableau Responsive Theme - Support Thread

Re: Tableau Responsive Theme - Support Thread

Re: Tableau Responsive Theme - Support Thread

Re: Tableau Responsive Theme - Support Thread

Re: Tableau Responsive Theme - Support Thread

Re: Tableau Responsive Theme - Support Thread

Re: Tableau Responsive Theme - Support Thread

Re: Tableau Responsive Theme - Subcategories Display In Body?

Similar Threads

v155 Responsive Classic (built in to Zen Cart v1.5.5) [Support Thread]

v155 Support Thread - Responsive Color Changes for 155

v155 Tableau Theme configuration not working.

v155 Responsive Classic (built in to Zen Cart v1.5.5) [Support Thread]

v154 Order Steps Responsive [Support Thread]

Posting Permissions