Sidebar Categories Enhancement AddOn

[AnAlienHolakres3]

If you do not want to be "discarded" links displayed in counts, open your dbtree.php in libs fodler,find sidebarextracats function and replace original code:

PHP Code:

//get num of links in root category (and its subcats) (ALL-ALWAYS)
              foreach ($roots as $roots_id){                
                     $root_count_array_total[$roots_id->category_id]= 
                     $db->get_var("SELECT count(link_id) FROM ".table_links." WHERE link_category=".$roots_id->category_id.
                     " OR link_category IN (SELECT distinct subcat.category_id FROM ".table_categories.
                                            " JOIN ".table_categories." subcat ON subcat.category_parent=".table_categories.
                                            ".category_id WHERE ".table_categories.".category_id=".$roots_id->category_id.
                                            " UNION SELECT distinct subcat2.category_id FROM ".table_categories.
                                            " JOIN ".table_categories." subcat ON subcat.category_parent=".table_categories.".category_id".
                                            " JOIN ".table_categories." subcat2 ON subcat2.category_parent=subcat.category_id".
                                            " WHERE ".table_categories.".category_id=".$roots_id->category_id.")"); 


with

PHP Code:

//get num of links in root category (and its subcats) (ALL-ALWAYS)
              foreach ($roots as $roots_id){                
                     $root_count_array_total[$roots_id->category_id]= 
                     $db->get_var("SELECT count(link_id) FROM ".table_links." WHERE link_status NOT LIKE 'discard' AND (link_category=".$roots_id->category_id.
                     " OR link_category IN (SELECT distinct subcat.category_id FROM ".table_categories.
                                            " JOIN ".table_categories." subcat ON subcat.category_parent=".table_categories.
                                            ".category_id WHERE ".table_categories.".category_id=".$roots_id->category_id.
                                            " UNION SELECT distinct subcat2.category_id FROM ".table_categories.
                                            " JOIN ".table_categories." subcat ON subcat.category_parent=".table_categories.".category_id".
                                            " JOIN ".table_categories." subcat2 ON subcat2.category_parent=subcat.category_id".
                                            " WHERE ".table_categories.".category_id=".$roots_id->category_id."))"); 


Hope it helps

[fingerprn]

The latest updates to SVN broke your code. The problem appears to be with dbtree.php

[AnAlienHolakres3]

Please could you be more specific?

[fingerprn]

Well, I did the upgrade and the subcategories all disappeared. The problem appears to be caused in dbtree.php from the following:

OLD VERSION

$sql = 'SELECT * FROM `'.$table.'` WHERE lft BETWEEN '.$row->lft.' AND '.$row->rgt.' and category_enabled <> 0 ORDER BY lft ASC;';
$result = $db->get_results($sql);

NEW VERSION

$result = get_cached_between($row->lft, $row->rgt);

[fingerprn]

Just noticed that the categories in the Pligg demo are gone also. Assuming that the Pligg demo uses the latest SVN, it appears that there's a bug in the latest SVN and not your mod.

[vivevtvivas]

Does anyone have any quick thoughts as to why this display problem might be happening? I think I followed the instructions for v0.3 correctly but who knows.






Image show up now?

[fingerprn]

Okay, the newest SVN is out for dbtree and it's still not working with your script. This time the main categories show up in an unaesthetic fashion and the subcategories don't show up at all.

[cameron65]

Originally Posted by vivevtvivas

Does anyone have any quick thoughts as to why this display problem might be happening? I think I followed the instructions for v0.3 correctly but who knows.






Image show up now?

I'm actually looking at this same problem right now. From what I can see, I don't think <ul> and <li> tags are being closed properly (v9.8). I will post what I find if someone doesn't beat me to it.


Edit: It does have to do with properly closing the tags. When the last category has a sub category, it doesn't close the tags. If your last category does not have a sub cat, then it works properly. I'm trying to find a solution but I don't use Smarty, so it's a pain to figure out.


Edit: My solution
There may be a better way to solve this, and I don't know if it works for 3 levels deep because I'm not using them, but here is what I did.

v9.8
categories.tpl

Find:

          {assign var=lastspacer value=$cat_array[thecat].spacercount}
{/section}

Below it place

{if $cat_array[thecat].spacercount eq "" and $lastspacer ne "1"}</li></ul></div>{/if}

[haxhax]

It have some issues with ie6.0 about layout.
You can find it at site Pligg Beta 9

Please see attached image.

[Naranja]

I have this categories.tpl, but i don't know how to do it:.
(digitalnature template)

PHP Code:

<li>
  <div class="box" id="categorybox">
    <h1><span class="expand"><a id="expcat" class="expand-up"></a></span><a class="htitle">{#PLIGG_Visual_Category_Title#}</a></h1>
    <ul id="categorynav">
      {section name=thecat loop=$cat_array start=1}
      {if $lastspacer eq ""}
      {assign var=lastspacer value=$cat_array[thecat].spacercount}
      {/if}
      <li> {if $cat_array[thecat].spacercount lt $lastspacer}{$cat_array[thecat].spacerdiff|repeat_count:'</li>
    </ul>
    '}{/if}
    {if $cat_array[thecat].spacercount gt $lastspacer}
    <ul style="padding-right:12px">
      <li>{/if} {if $pagename eq "upcoming"} <a href="{$URL_queuedcategory, $cat_array[thecat].safename}" style="padding-bottom:0">{$cat_array[thecat].name}</a>
          {else} <a href="{$URL_maincategory, $cat_array[thecat].safename}" style="padding-bottom:0;">{$cat_array[thecat].name}</a> {/if}        
        {assign var=lastspacer value=$cat_array[thecat].spacercount}
        {/section}</li>
    </ul>
  </div>
</li>