categorie last update

<?php if ($this->params->get('show_title', 1) || count($columns)) : ?> <?php /* $db = JFactory::getDbo(); $query = 'SELECT last_modified FROM #__content WHERE catid = ' . $catid .' ORDER BY last_modified DESC LIMIT 1'; $db->setQuery($query); $most_recent_mod = $db->loadResult(); */ ?> <table id="flexitable" class="flexitable" width="100%" border="0" cellspacing="0" cellpadding="0" summary="<?php echo $this->category->name; ?>"> <thead> <tr>

unning autotoc object(Joomla\CMS\Version)#1650 (0) { } object(stdClass)#1427 (32) { ["id"]=> string(2) "49" ["asset_id"]=> string(2) "72" ["parent_id"]=> string(2) "59" ["lft"]=> string(2) "12" ["rgt"]=> string(2) "13" ["level"]=> string(1) "2" ["path"]=> string(41) "database/origin-worldwide-gis-compilation" ["extension"]=> string(11) "com_content" ["title"]=> string(32) "oriGIn Worldwide GIs Compilation" ["alias"]=> string(32) "origin-worldwide-gis-compilation" ["note"]=> string(0) "" ["description"]=> string(0) "" ["published"]=> string(1) "1" ["checked_out"]=> string(1) "0" ["checked_out_time"]=> string(19) "0000-00-00 00:00:00" ["access"]=> string(1) "1" ["params"]=> string(4865) "{"image":"","note":"","print_behaviour":"","show_print_icon":"0","show_email_icon":"0","show_feed_icon":"","show_feed_link":"1","show_csvbutton":"","show_addbutton":"0","addbutton_menu_itemid":"","show_icons":"","use_font_icons":"","font_icon_configs":"","font_icon_classes":"","btn_grp_dropdown":"","btn_grp_dropdown_class":"","show_cat_title":"1","title_cut_text":"200","show_description_image":"1","cat_image_source":"2","cat_link_image":"1","cat_image_method":"1","cat_image_width":"80","cat_image_height":"80","show_description":"1","trigger_onprepare_content_cat":"","show_subcategories":"1","subcat_orderby":"order","show_itemcount":"1","show_subcatcount":"","show_empty_cats":"","show_description_image_subcat":"","subcat_image_source":"","subcat_link_image":"","subcat_image_method":"","subcat_image_width":"","subcat_image_height":"","show_description_subcat":"","description_cut_text_subcat":"","show_label_subcats":"","prx_sfx_open_close_configs_subcat":"","subcat_pretext":"","subcat_posttext":"","subcat_separatorf":"","subcat_opentag":"","subcat_closetag":"","show_peercategories":"0","peercat_orderby":"","show_itemcount_peercat":"","show_subcatcount_peercat":"","show_empty_peercats":"","show_description_image_peercat":"","peercat_image_source":"","peercat_link_image":"","peercat_image_method":"","peercat_image_width":"","peercat_image_height":"","show_description_peercat":"","description_cut_text_peercat":"","show_label_peercats":"","prx_sfx_open_close_configs_peercat":"","peercat_pretext":"","peercat_posttext":"","peercat_separatorf":"","peercat_opentag":"","peercat_closetag":"","ff_placement":"","ff_toggle_search_title":"","filter_autosubmit":"","filter_instructions":"","show_search_go":"","flexi_button_class_go":"","flexi_button_class_go_custom":"","show_search_reset":"","flexi_button_class_reset":"","flexi_button_class_reset_custom":"","filter_pretext":"","filter_posttext":"","filter_opentag":"","filter_closetag":"","filter_placement":"","filter_separatorf":"1","use_search":"1","show_search_label":"","show_searchphrase":"0","default_searchphrase":"","search_autocomplete":"","use_filters":"1","filters_order":"1","filters":"17,18,19,16,29","show_filter_labels":"0","initial_filters":"","use_persistent_filters":"","persistent_filters":"","show_alpha":"1","alphacharseparator":"","alphaaliases":"","alphaskipempty":"0","show_editbutton_lists":"","show_state_icon_lists":"","show_deletebutton_lists":"","show_comments_count":"","show_title_lists":"","link_titles_lists":"0","force_full":"0","show_readmore":"1","orderby":"alpha","orderbycustomfield":"","orderbycustomfieldid":"0","orderbycustomfielddir":"ASC","orderbycustomfieldint":"0","orderby_2nd":"","orderbycustomfield_2nd":"","orderbycustomfieldid_2nd":"0","orderbycustomfielddir_2nd":"","orderbycustomfieldint_2nd":"","orderby_override":"0","orderby_override_2nd":"","limit_options":"","orderby_custom":"","orderby_custom_2nd":"","show_noauth":"0","show_owned":"","show_trashed":"","display_subcategories_items":"0","filtercat":"","use_limit_before_search_filt":"","limit_before_search_filt":"","display_flag_featured":"","limit":"20","show_item_total":"1","show_pagination":"","show_pagination_results":"1","limit_override":"","limit_override_label":"","mu_addtext_cats":"","mu_add_condition_obtainded_acc":"","mu_addtext_acclvl":["no_acc","free_acc","needed_acc","obtained_acc","__SAVED__"],"

<div>Last modification : <?php $db = JFactory::getDbo(); $catid = JFactory::getApplication()->input->getInt('cid'); $query = 'SELECT modified FROM #__content AS c JOIN #__flexicontent_cats_item_relations AS rel ON c.id = rel.itemid WHERE rel.catid = ' . (int) $catid .' ORDER BY modified DESC LIMIT 1'; $db->setQuery($query); $most_recent_mod = $db->loadResult(); print $most_recent_mod ; ?> </div>