Joomla Templates Club 406,261 posts

[pquesada Friend pquesadaJoin date: February 2006Posts: 6Downloads:3Uploads:0 Thanks: 7 Thanked: 3 times in 2 posts]

#193619

Hello,

I have not Joomla! articles but only K2 items. In the Last Update (top left of the template translated as Actualizado in my site) the last update appears as ‘Lun (Mon in english), 23 Ago (Aug) 2010 12am’ but it should be Mar (Thu in english), 07 Ene (Jan).

I would appreciate if this could be changed or point me where to fix it.

Best,
Pablo.

[Saguaros Moderator SaguarosJoin date: September 2014Posts: 31405Downloads:237Uploads:471 Thanks: 845 Thanked: 5346 times in 4964 posts]

#517941

Hi Pablo,

Currently, the Last Update section displays the last updated date of Joomla content. I have passed this to our team for further consideration. Anyway, I am not in a position to confirm on this right now. I am sorry for that.

1 user says Thank You to Saguaros for this useful post

1. pquesada

[pquesada Friend pquesadaJoin date: February 2006Posts: 6Downloads:3Uploads:0 Thanks: 7 Thanked: 3 times in 2 posts]

#518054

Hello Saguaros,

thanks you for the information. Could you point me the file where the SQL take place ? I would like to try change it.

As a feedback, would be interesting if the user could choose the source of the last update in the template configuration, for example from Joomla! content, K2 items or both 🙂

Best,
Pablo

[Saguaros Moderator SaguarosJoin date: September 2014Posts: 31405Downloads:237Uploads:471 Thanks: 845 Thanked: 5346 times in 4964 posts]

#518108

Hi Pablo,

This is only a snippet of built-in code in header block of this template which calls getLastUpdate function in file: /templates/ja_teline_iv/templateHelper.php, you can customize it there.

Cheers!!!

1 user says Thank You to Saguaros for this useful post

1. pquesada

[pquesada Friend pquesadaJoin date: February 2006Posts: 6Downloads:3Uploads:0 Thanks: 7 Thanked: 3 times in 2 posts]

#518266

For future references to this topic, you can get the last update item from the K2 items with the following query:

$query = "SELECT `$fieldname` FROM #__k2_items ORDER BY `$fieldname` DESC LIMIT 1";

Quite easy! I f you want select from both, Joomla! content and K2 items, you need to select from both tables and get the maximum date. Hope this help others.

Best,
Pablo.

1 user says Thank You to pquesada for this useful post

1. Saguaros

[msilac Friend msilacJoin date: October 2010Posts: 548Downloads:2Uploads:74 Thanks: 115 Thanked: 5 times in 1 posts]

#518320

This is nice, Can you just explain where to do that?

I need to go in phpMyAdmin or in some file?

Thank you

[Saguaros Moderator SaguarosJoin date: September 2014Posts: 31405Downloads:237Uploads:471 Thanks: 845 Thanked: 5346 times in 4964 posts]

#518345

@msilac: please check my previous post 🙂

<blockquote>This is only a snippet of built-in code in header block of this template which calls getLastUpdate function in file: /templates/ja_teline_iv/templateHelper.php, you can customize it there.</blockquote>

1 user says Thank You to Saguaros for this useful post

1. pquesada

[msilac Friend msilacJoin date: October 2010Posts: 548Downloads:2Uploads:74 Thanks: 115 Thanked: 5 times in 1 posts]

#518444

<em>@Saguaros 405786 wrote:</em><blockquote>@msilac: please check my previous post :)</blockquote>

I dont have file templateHelper.php in templates/ja_teline_iv/ folder…

[Saguaros Moderator SaguarosJoin date: September 2014Posts: 31405Downloads:237Uploads:471 Thanks: 845 Thanked: 5346 times in 4964 posts]

#518475

I guess that you’re using JA TelineIV with old T3v2 framework ( Pablo is using TelineIV with new T3 one).

There are some differences in layout between these 2 versions, with TelineIV T3v2 framework, that snippet of code will belong to block: templatesja_teline_ivblockstopbar.php

and it will call getLatestUpdate function from file: pluginssystemjat3jat3corecommon.php

[Author]

Posts