categorie last update

More
6 years 4 months ago #70837 by tonnick
Replied by tonnick on topic categorie last update
I just added the code on components/com_flexicontent/templates/database/category_items.php before the table :
Code:
<?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>


but it's crashing the page, only the title was displayed. Did I miss something ? :/

Please Log in or Create an account to join the conversation.

More
6 years 4 months ago #70839 by micker
Replied by micker on topic categorie last update
actived error reporting to maximum in joomla global config you can set error

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

Please Log in or Create an account to join the conversation.

More
6 years 4 months ago #70840 by tonnick
Replied by tonnick on topic categorie last update
I did, but this does not help, this just display a lot of code in the page, but nothing readable
Code:
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__"],"

the whole page like this :(

Please Log in or Create an account to join the conversation.

More
6 years 4 months ago #70841 by tonnick
Replied by tonnick on topic categorie last update
oo seems that there was a mistake in copy paste. it's working now :
Code:
<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>

thx a lot !

Please Log in or Create an account to join the conversation.

More
6 years 4 months ago #70846 by micker
Replied by micker on topic categorie last update
cool

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

Please Log in or Create an account to join the conversation.

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.276 seconds
Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline