Topic: Poll for new module features

[kenpachi01]

hi Mark,

4. Display category in entry.
Others have mentioned this, but I am not exactly sure what people mean by this. I would need some sort of specification to understand exactly what is required.

i was said you that will be great if on you module there is a possibility to add categories icons.

and to explain why that can be usefull for some kind of directories im sending you in pm my website link with explain

Regards,

Kenpachi

[NicMason.com]

[REQ:] Show Featured Entries of ALL SUBCATEGORIES of currently-viewed-category


Hi Mark,

Thank you very much for producing a great and very useful module!  I've re-styled it a bit here: http://yarraville.com.au/index.php


My question is:  Is it possible to combine the standard SOBI2 component setting of "Show Entries of Subcategories" with the SimpleFeaturedEntries module "Current Category Filter" set to "yes".

In other words, display the featured entries of all of the subcategories below the currently viewed category.

At present, the module seems to display the featured entries of the currently-viewed-category ONLY (without including the subcategories below this one.)

I hope you can understand what I'm getting at!

Cheers,

Nic

[aboututila]

Nic,

Interestingly (for me), my father was born in Yarraville, my mother in Footscray.
I was born in Ringwood.

(1) Anyway, I understand your requirements, but unfortunately what you describe in not possible in mod_sobi2simplefeatured without substantial additions to the module code, (which would also increase module database calls, processing time, and memory usage).

(2) You are correct in stating that the module can only display the featured entries of the currently-viewed-category ONLY (when Current Category Filter" set to "yes").

(3) It is not straightforward to implement a 'Show Selected Entries in Subcategories of the Currently Displayed Category' in the module since a SOBI2 Entry may belong to several Categories, and the currently displayed Category could have several thousand sub-categories. It is beyond my technical skills to write an efficient SQL query(ies) to implement your requirement.

Regards - Mark

[NicMason.com]

Hi Mark,

How bizarre!  I've been living in the area for about ten years now and love it!  It's such a small world! 

Thank you, too, for the super-fast reply!   I'll have a go at it myself if/when I get time... One day!

Cheers neighbour! 

Nic

[NicMason.com]

Hi Mark,

Do you know how the main SOBI2 component does it with the setting of "Show Entries of Subcategories"..?

(I don't really care if there is a high overhead of DB calls, memory, or processing time.)

Cheers,

Nic

[aboututila]

I believe that if Show Entries of Subcategories=1,
then the function 'function getChildCats ( $catid, &$catChilds )' is called  (in config.class.php at around line 2002 in SOBI2 RC 2.9.2.3) is called.

There is also another function 'function getChildCats($catid)' defined (in frontend.class.php at around line 78 in SOBI2 RC 2.9.2.3), and I believe this function is used to display the Entries in SubCategories.

config.class.php and frontend.class.php are both in MyJoomlaInstallation/components/com_sobi2

Regards- Mark

[NicMason.com]

Thanks again Mark!

Much appreciated!  I'll have a look at those and see if something can be done...

Cheers,

Nic

[aboututila]

Nic,

While working on another problem, I came across the following code;

Code: [Select]

    * Now get all categories witch contain this item
    */
    $p = $config->checkPerm() ? null : ' AND published = 1 ';
    $query = 'SELECT name, relation.catid, params FROM #__sobi2_cat_items_relations AS relation ' .
      'LEFT JOIN #__sobi2_categories AS cats ON relation.catid = cats.catid ' .
      "WHERE ( itemid = {$this->id}{$p} ) LIMIT {$config->maxCatsForEntry}";
$database->setQuery( $query );
    $results = $database->loadObjectList();
if ( $database->getErrorNum() ) {
trigger_error( 'sobi2::getAttributs(): DB reports: '.$database->stderr(), E_USER_WARNING );
}in sobi2.class.php function getAttributs( $sobi2Id, $data = false ) at around line 360
which seems to be getting all the category names and ids (catid) for a given itemid (SOBI2 Entry).

and the following code;
    * returning subcategories info
    *
    * @param integer $parent
    * @return array
    */
   function getCategories($parent = 1)
   {
       $config =& sobi2Config::getInstance();
      $database =& $config->getDb();
      $published = null;
      if($parent < 1) {
         $parent = 1;
      }
      if(!(defined('_SOBI2_ADMIN')))  {
         $published = " published = 1 AND ";
      }
      $query = "SELECT `#__sobi2_cats_relations`.catid " .
              "FROM `#__sobi2_cats_relations` " .
              "LEFT JOIN `#__sobi2_categories` ON `#__sobi2_categories`.catid = `#__sobi2_cats_relations`.catid " .
              "WHERE {$published} `#__sobi2_cats_relations`.parentid = {$parent} ";
      $database->setQuery( $query );
      $cids = $database->loadResultArray();
      if ($database->getErrorNum()) {
         trigger_error("DB reports: ".$database->stderr(), E_USER_WARNING);
      }
in SigsuiTree.php function getCategories($parent = 1) at around line 227
which seems to be returning all the category ids ($cids) for the subcategories of a given 'parent' category id, and then getting information about those categories ($ret).

I don't know if this helps
Regards - Mark

[NicMason.com]

Hi Mark,

Thank you for the code!  I'll see if I can work something out...

Apologies for the late reply...  Haven't been here for a while! 

Cheers,

Nic