How do I put a "Specials" link at the TOP of my categories list?

[Colin01]

Hi

I'd like one of my categories when clicked on to link directly to another page in the site and can't work out how to do it.

To be exact I want to have my 1st category in the category box to be called specials and to link to the specials page.

I know there is already a link at the bottom of the categories box to specials, but I want it as the very first thing people will see in the categories box.

If it is too difficult to get a category to be a link instead of to just show products then I am happy to find out how to move the existing special link to the top of the category box. Either solution will be fine.

Any help much appreciated thanks

[DrByte]

1. First be sure you've got your own custom template set up. In this example I'll call it FRED
2. Copy the /includes/templates/template_default/sideboxes/tpl_categories.php to your /includes/templates/FRED/sideboxes/ folder
3. You will now edit that new copy: /includes/templates/FRED/sideboxes/tpl_categories.php
Around line 66 you'll see a section of code that looks like this:

    if (SHOW_CATEGORIES_BOX_SPECIALS == 'true') {
      $show_this = $db->Execute("select s.products_id from " . TABLE_SPECIALS . " s where s.status= 1 limit 1");
      if ($show_this->RecordCount() > 0) {
        $content .= '<a class="category-links" href="' . zen_href_link(FILENAME_SPECIALS) . '">' . CATEGORIES_BOX_HEADING_SPECIALS . '</a>' . '<br />' . "\n";
      }
    }

MOVE all those lines up between lines 13-14 so it looks like this:

  $content .= '<div id="' . str_replace('_', '-', $box_id . 'Content') . '" class="sideBoxContent">' . "\n";
    if (SHOW_CATEGORIES_BOX_SPECIALS == 'true') {
      $show_this = $db->Execute("select s.products_id from " . TABLE_SPECIALS . " s where s.status= 1 limit 1");
      if ($show_this->RecordCount() > 0) {
        $content .= '<a class="category-links" href="' . zen_href_link(FILENAME_SPECIALS) . '">' . CATEGORIES_BOX_HEADING_SPECIALS . '</a>' . '<br />' . "\n";
      }
    }
  for ($i=0;$i<sizeof($box_categories_array);$i++) {

[Colin01]

Thats done the job, thank you very much