CB Articles

3 weeks and 4 days ago, I had asked about the order of articles/items displayed with CB Articles. The default is to order them by date created. I had asked about changing the "sort" or "order by" to categories. My understanding was that I needed to go to components/com_comprofiler/plugin/user/plug_cbarticles/models/joomla25.php and for Joomla articles or components/com_comprofiler/plugin/user/plug_cbarticles/models/k2.php for K2 items/articles. Then I would change this line of code: "\n ORDER BY a." . $_CB_database->NameQuote( 'created' ) . " DESC";

I assume 'created' refers to date created? So I would just change 'created' to 'category_title' if I want to sort by category title?

Since then, I realized that it would be even better to sort by the item (article) title since then the end user could number the articles in the specific order they want them to appear. So if that is the case, would I just change 'created' to 'name' ??

I suppose I could just try different things but editing php is a bit intimidating for me and always afraid I am going to totally mess things up. Before I do anything, I will make a backup but thought I would check again, just to make sure I am on the right path for changing the order of the K2 items displayed in CB Articles.

As always, thanks for your assistance.

Check the database table for Joomla articles and/or K2 articles. You can order by any of them. For K2 the table is _k2_items. For Joomla the table is _content. For your specific case you'd order by title. A parameter to change the order by is planned for a later release so you eventually won't have to change it in PHP anymore.

Well, I decided to go ahead and try changing the sort order in the php. I was still not sure what would work better for the sort, category id or name so I decided to try category id first.

I went to components/com_comprofiler/plugin/user/plug_cbarticles/models/k2.php and opened k2.php in text editor and found the line \n ORDER BY a." . $_CB_database->NameQuote( 'created' ) . " DESC"; and changed it to "\n ORDER BY a." . $_CB_database->NameQuote( 'catid' ) . " ASC";

I didn't change anything else. I got this error message:

Parse error: syntax error, unexpected T_NS_SEPARATOR in /home/nretrosp/public_html/components/com_comprofiler/plugin/user/plug_cbarticles/models/k2.php on line 110

In the text editor, I went to line 110 and this is what was highlighted:

Parse error: syntax error, unexpected T_NS_SEPARATOR in <span>/</span>home<span>/</span>nretrosp/public_html/components/com_comprofiler/plugin/user/plug_cbarticles/models/k2.php on line 110

Not sure what I am doing wrong??

The ORDER BY is the part of the query that changes the ordering. You shouldn't get any PHP errors, because you're not supposed to touch the surrounding PHP. You strictly only need to change the 'catid' string to for example 'title'. So you'd have the following.

FROM: TO: