Last connection of item's creator

micker
Offline
Administrator

5 years 9 months ago #75981 by micker

Replied by micker on topic Last connection of item's creator

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.

ggppdk
Offline
Administrator

5 years 9 months ago - 5 years 9 months ago #75984 by ggppdk

Replied by ggppdk on topic Last connection of item's creator

> 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 9 months ago by ggppdk.

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

templar
Topic Author
Offline
New Member

5 years 9 months ago - 5 years 9 months ago #76012 by templar

Replied by templar on topic Last connection of item's creator

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 9 months ago by templar.

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