Last connection of item's creator

1 year 8 months ago - 1 year 8 months ago #75977 by micker
no its basic option in field configuration

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.

1 year 8 months ago #75978 by templar
Je suis vraiment désolé, mais ça ne marche pas. J'ai essayé avec une valeur quelconque "pour tester" et aucune des trois options :afficher pour les nouveaux contenus, afficher pour tous les ocntenus, ou toujours afficher plutôt qu'une valeur vierge) ne fonctionne.
Par ailleurs, ce champs sert à mettre une valeur fixe, je n'ai pas l'impression qu'il permets d'intégrer une formule avec requête SQL.

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

1 year 8 months ago #75981 by micker
tu peus me faire des screens de ta config ?

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.

1 year 8 months ago - 1 year 8 months ago #75984 by ggppdk
> Ok, so I need the pro version ?

yes you would need Pro version
- but you must not use auto-fill
because the value will not be dynamic
instead see below how to do it

> The field is not dynamic, it is recorded during the creation or the modification of an item and stay "as is" until further modification.

You can create a new (field value) --viewing-- layout for a text field (almost all field support custom layouts)

and name the new layout
/tmpl/value_itemcreator.php

- place the query inside the layout
$query = 'SELECT id, name, lastvisitDate FROM #__user WHERE id = ' . (int) $item->created_by;
- select the 'value_itemcreator' as the viewing layout in field's configuration

the above query will be executed 20 times in category view,
but you will really see no difference in page creation,

unless you are showing 500 items or more per page in category view
because the query itself is super fast as it select 1 row via a column index


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star review. Thanks!

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

1 year 8 months ago - 1 year 8 months ago #76012 by templar
Hello guys,

Thank you for your kind help with my problem.
Here is my solution :
I did edit my personnal 'items_category.php" with the following code :
<?php 
            // Code d'affichage dernière mise à jour
				$db = JFactory::getDbo();
                $query = $db->getQuery(true);
				$query->select('lastvisitDate');
				$query->from($db->quoteName('#_____users'));
				$query->where($db->quoteName('id')." = ".$db->quote($item->created_by));
 
				$db->setQuery($query);
				$result = $db->loadResult();
				echo JHtml::_('date', $result, JText::_('DATE_FORMAT_LC1'));
			// Fin du code d'affichage dernière mise à jour
			?>

It is working like a charm, I'm really happy with it.
Thank you again, and keep up your good work on that awesome plugin !

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

1 year 8 months ago #76015 by micker
Merci pour le tips !

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
© 2018 Flexicontent. All Rights Reserved.