Joomla Templates Club 406,261 posts

[sergiosp Friend sergiospJoin date: February 2009Posts: 270Downloads:78Uploads:49 Thanks: 35]

#205361

I can not get the latest look in Module latest News, You may help me?
Thanks!
Sergiosp

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#566130

Hi there
Please clearly your issue and reproduce steps.

Thank you,
Viet Vu

[sergiosp Friend sergiospJoin date: February 2009Posts: 270Downloads:78Uploads:49 Thanks: 35]

#566138

Hi Jooservice,
My problem is this: I can not display in the frontend of the site the latest news. if you enter the “Manage Items” Really the article being viewed as latter is the pre-penultimate article published.
It is possible to suggest me to do?

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#566143

Hi there
Please provide your site URL / backend and reproduce steps.
I’ll help you inspect that.

Thank you,
Viet Vu

[sergiosp Friend sergiospJoin date: February 2009Posts: 270Downloads:78Uploads:49 Thanks: 35]

#566151

Dear Viet Vu: The url is: http://asijemin.org.ar

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#566155

Hi there
I can load your site as well. Please provide some more detail and reproduce steps 🙂

Thank you,
Viet Vu

[sergiosp Friend sergiospJoin date: February 2009Posts: 270Downloads:78Uploads:49 Thanks: 35]

#566166

<em>@jooservices 467541 wrote:</em><blockquote>Hi there
I can load your site as well. Please provide some more detail and reproduce steps 🙂

Thank you,
Viet Vu</blockquote>

Dear Viet Vu, I do not understand what you need, can be clearer?
Thanks for all your dedication to my problem
Sergiosp

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#566173

Hi there
<blockquote>My problem is this: I can not display in the frontend of the site the latest news. if you enter the “Manage Items” Really the article being viewed as latter is the pre-penultimate article published.</blockquote>

Actually i’m trying to understand your issue.
If you are talking about latest news module. It’s already sorted by created time.
So … i’m not really sure what’r your issue here. Sorry about that.

And that’s why i have asked for reproduce steps. Or please provide screenshot with notes 🙂

Thank you,
Viet Vu

[sergiosp Friend sergiospJoin date: February 2009Posts: 270Downloads:78Uploads:49 Thanks: 35]

#566179

Ok Viet Vu, I understand what you say, try to be more clear.
The latest news are not going well and not know why.
I sent two pictures for you to see and realize the problem.
In the pictures you can see the view of the items is changed and are seeing the oldest items first and the newest last, I do not know how to make them look good.
SergioSP

image 1: http://www.webpagescreenshot.info/img/55241a97dcb201-96398851
image 2: http://www.webpagescreenshot.info/img/55241eb7b50c93-24629948

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#566253

Hi there
I got it. Let me check.
Ps:// ID higher does not mean it’s latest item 🙂

Thank you,
Viet Vu

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#566264

Hi there
# At first we located which layout file for that thing
pluginssystemt3basetplsblocksspotlight.php
# And now we can trace back which module used for this.
# It’s Últimas Noticias module ( id 28 )
Latest new module.

This module is used to display article with ordering by created_time ( latest first ). Please do not confuse with item id or ordering.
Here is query

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM #__content AS a LEFT JOIN #__content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN #__categories AS c ON c.id = a.catid LEFT JOIN #__users AS ua ON ua.id = a.created_by LEFT JOIN #__users AS uam ON uam.id = a.modified_by LEFT JOIN #__categories as parent ON parent.id = c.parent_id LEFT JOIN #__content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM #__categories AS cat JOIN #__categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id WHERE a.access IN (1,1,2,3) AND c.access IN (1,1,2,3) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND a.catid IN (101,105) ORDER BY a.created DESC

But one more thing.
In template we’r using focus layout and overrided.
And checked into this one we have


//sort those latest article by hits
//$compare = create_function('$a, $b', ' if ($a->hits == $b->hits) { return 0; } return ($a->hits < $b->hits) ? 1 : -1; ');
//uasort($list, $compare);

It’ll update ordering by hits.

Just remove or comment out these line than you can get back right ordering.

Thank you,
Viet Vu

1 user says Thank You to jooservices for this useful post

1. sofian

[sergiosp Friend sergiospJoin date: February 2009Posts: 270Downloads:78Uploads:49 Thanks: 35]

#566787

I apologize, but I do not understand what to do …
sergiosp

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#566968

Hi there
Just open file and comment these line

//sort those latest article by hits
//$compare = create_function('$a, $b', ' if ($a->hits == $b->hits) { return 0; } return ($a->hits < $b->hits) ? 1 : -1; ');
//uasort($list, $compare);

Thank you,
Viet Vu
ps:// If you still can’t work on this please provide FTP access i’ll help you work on that.

1 user says Thank You to jooservices for this useful post

1. sofian

[sofian Friend sofianJoin date: March 2015Posts: 122Downloads:42Uploads:21 Thanks: 80]

#569063

<em>@jooservices 468608 wrote:</em><blockquote>Hi there
Just open file and comment these line

//sort those latest article by hits
//$compare = create_function('$a, $b', ' if ($a->hits == $b->hits) { return 0; } return ($a->hits < $b->hits) ? 1 : -1; ');
//uasort($list, $compare);

Thank you,
Viet Vu
ps:// If you still can’t work on this please provide FTP access i’ll help you work on that.</blockquote>

hi
i was have the same problem , and one person from your support team help me with this and gave me a replace code .

my quastion :
do you will fix this on coming release version of ja magz ??

thank you

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#569082

Hi there
I have asked that with team.

Thank you,
Viet Vu

1 user says Thank You to jooservices for this useful post

1. sofian

[Author]

Posts