Forums / Cotonti / Extensions / Support / need support on list modification

SunChase
#1 2009-10-15 22:41
Trying to make the lists show the subcategories.

Took some things from an old news plugin and inserted them in the list:

$jj = 0;
$mtch = $sed_cat[$c]['path'].".";
$mtchlen = strlen($mtch);
$catsub = array();
$catsub[] = $c;
foreach($sed_cat as $i => $x)
	{
	if (substr($x['path'], 0, $mtchlen)==$mtch && sed_auth('page', $i, 'R'))
		{ $catsub[] = $i; }
	}

and

 else
	{
                sed_die(empty($sed_cat[$c]['title']) && !$usr['isadmin']);
                        $sql = sed_sql_query("SELECT COUNT(*) FROM $db_pages
			WHERE page_cat='$c' AND (page_state='0' OR page_state='2')");

                        $totallines = sed_sql_result($sql, 0, 0);

                        $sql = sed_sql_query("SELECT p.*, u.user_name ".$join_ratings_columns."
                        FROM $db_pages as p ".$join_ratings_condition."
		        LEFT JOIN $db_users AS u ON u.user_id=p.page_ownerid
                        WHERE page_state=0 AND page_cat NOT LIKE 'system'
			AND page_cat IN ('".implode("','", $catsub)."') ORDER BY
			page_$s $w  LIMIT $d,".$cfg['maxrowsperpage']);

        }

The subcategories are shown,but the LIST_ROWCAT_... tags stoped working + dont know how to edit the $catpath so it would show the proper category name.

Tried to edit the sql so it would get the category name from the structure_title field :

$sql = sed_sql_query("SELECT p.*, u.user_name ,s.structure_code ,s.structure_title ".$join_ratings_columns."
                        FROM $db_pages p , $db_users u ,$db_structure s
                        WHERE page_state=0 AND page_cat NOT LIKE 'system'
                        AND p.page_cat=s.structure_code
                        AND u.user_id=p.page_ownerid
                        AND page_cat IN ('".implode("','", $catsub)."') ORDER BY
			page_$s $w  LIMIT $d,".$cfg['maxrowsperpage']);

"CAT" => $row['structure_title'],

but dont know how to do it correctly.
This is the first time i'm trying to edit something massive as list.php.
[url=http://ka13.orgfree.com]KA13[/url] - The essence of creativity