Section -> How do I change the default (10) number of content items displayed - Page 2

shady · 25.05.2004, 19:04

Quote:

Originally Posted by jump

PHP Code:

      . ($noauth ? "\n    AND c.access<='$gid'" : "" )

    . "\nGROUP BY c.id"

    . "\n    HAVING COUNT(b.id) > 0"

    . "\nORDER BY a.ordering ASC" //This is what you change

    );

I do not have this. The closet I have is...

PHP Code:

      . ($noauth ? "\n    AND c.access<='$gid'" : "" )

    . "\nGROUP BY c.id"

    . "\n    HAVING COUNT(b.id) > 0"

    . "\nORDER BY c.ordering"

And also..

PHP Code:

      . ($noauth ? "\n    AND c.access<='$gid'" : "" )

    . "\nGROUP BY c.id"

    . "\n    HAVING COUNT(b.id) > 0"

    . "\nORDER BY c.ordering"

I've got the same problem

visualdensity · 26.05.2004, 08:14

Which line and which file?

I'll have a look.. the change should be the same. But just want to be sure.

shady · 01.06.2004, 17:53

Hi

the file is the same
/components/com_content/content.php

i am using mambo Version : 4.5 Stable (1.0.7)

line 165-174

Code:

// get the list of other categories
	$database->setQuery( "SELECT c.*, COUNT(b.id) AS numitems"
	. "\nFROM #__categories AS c"
	. "\nLEFT JOIN #__content AS b ON b.catid = c.id $xwhere2"
	. "\nWHERE c.section='$category->section' $xwhere"
	. ($noauth ? "\n	AND c.access<='$gid'" : "" )
	. "\nGROUP BY c.id"
	. "\n	HAVING COUNT(b.id) > 0"
	. "\nORDER BY c.ordering"
	);

line 186 -193

Code:

// get the total number of records
	$database->setQuery( "SELECT count(id)"
		. "\nFROM #__content AS c"
		. "\nWHERE c.catid='$id' $xwhere"
		. ($noauth ? "\n	AND c.access<='$gid'" : "" )
		. "\nAND '$category->access'<='$gid'"
	);
	$total = $database->loadResult();

line 199-210

Code:

// get the list of items for this category
	$database->setQuery( "SELECT c.id, c.title, c.hits, c.created_by, c.created_by_alias,"
		. "\n	c.created AS created, c.access, u.name AS author, c.state"
		. "\nFROM #__content AS c"
		. "\nLEFT JOIN #__users AS u ON u.id = c.created_by"
		. "\nWHERE c.catid='$category->id' $xwhere"
		. ($noauth ? "\n	AND c.access<='$gid'" : "" )
		. "\nAND '$category->access'<='$gid'"
		. "\nORDER BY c.ordering"
		. "\nLIMIT $limitstart, $limit"
	);
	$items = $database->loadObjectList();

hughesjr · 11.06.2004, 05:34

In the section you have labeled as 199-210, change the line:

Code:

. "\nORDER BY c.ordering"

to

Code:

. "\nORDER BY c.created DESC"

and your categories will be sorted by descending created date....

shady · 12.06.2004, 16:54

Quote:

Originally Posted by hughesjr

In the section you have labeled as 199-210, change the line:

Code:

. "\nORDER BY c.ordering"

to

Code:

. "\nORDER BY c.created DESC"

and your categories will be sorted by descending created date....

Thanks

works perfect now

ngvmambo · 27.06.2004, 11:23

This thread has been helpful to me - thank you.

Is there a similar hack for making similar changes in the backend? i.e. I want to increase the default number of items displayed in the admin menus.

Thank you

headbanger · 02.08.2004, 09:00

Quote:

Originally Posted by jump

PHP Code:

      . ($noauth ? "\n    AND c.access<='$gid'" : "" )

    . "\nGROUP BY c.id"

    . "\n    HAVING COUNT(b.id) > 0"

    . "\nORDER BY a.ordering ASC" //This is what you change

    );

I do not have this. The closet I have is...

PHP Code:

      . ($noauth ? "\n    AND c.access<='$gid'" : "" )

    . "\nGROUP BY c.id"

    . "\n    HAVING COUNT(b.id) > 0"

    . "\nORDER BY c.ordering"

And also..

PHP Code:

      . ($noauth ? "\n    AND c.access<='$gid'" : "" )

    . "\nGROUP BY c.id"

    . "\n    HAVING COUNT(b.id) > 0"

    . "\nORDER BY c.ordering"

works great, thank you for ur help

kalex · 03.08.2004, 04:50

Visual,

Thank you for this post! This is my first day looking at this forum and this was exactly what I wanted to find here. I have been trying to find out where the line was that set the ordering of categories and items. I want my news items to appear by date published in my archive on my site. This hack worked perfectly and for my site, it does not affect other areas in a way that I can't handle.

kalex · 05.08.2004, 16:53

Visualidenetity

Is there a way to have items in your admin list by date created rather than by ordering. In my admin section I want to have my items under content list by publish date and the same under mamblefish. Any ideas?

headbanger · 08.08.2004, 06:26

how do i make the ordering by Hits?