Last connection of item's creator

More
5 years 2 weeks ago - 5 years 2 weeks 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]
Last edit: 5 years 2 weeks ago by ggppdk.

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

More
5 years 2 weeks 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.

More
5 years 2 weeks 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.

More
5 years 2 weeks ago - 5 years 2 weeks 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
Code:
$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...
Last edit: 5 years 2 weeks ago by ggppdk.

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

More
5 years 2 weeks ago - 5 years 2 weeks 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 :
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 !
Last edit: 5 years 2 weeks ago by templar.

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

More
5 years 2 weeks 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
Time to create page: 0.292 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