mirj4m.nl

I wanted to display only the component output of a Joomla webpage, nothing more (e.g. modules) nothing less. That can be done by adding &tmpl=component to the URL.

(Joomla 1.5 and 2.5)

$query = "SELECT files.*, galleries.ordering, galleries.access " //galleries.name AS category, users.name AS editor"
 ." FROM #__rsgallery2_files AS files"
 ." LEFT JOIN #__rsgallery2_galleries AS galleries ON galleries.id = files.gallery_id"
 ." LEFT JOIN #__users AS users ON users.id = files.checked_out"
 ." WHERE galleries.access IN (".$groupsIN.")"    //View access levels implementation
 ." ORDER BY galleries.ordering, files.ordering"    
 ." LIMIT $pageNav->limitstart, $pageNav->limit";
 

 $db =& JFactory::getDBO();
 $query = $db->getQuery(true);
 $query->select('count(*)');
 $query->from('#__pt_building AS b');
 $query->leftJoin('#__pt_unit AS u ON b.building_id = u.building_id');
 $query->where('b.property_id = '. (int) $property_id);
 $db->setQuery($query);
 return $db->loadResult();
 

setQuery($query, $limitstart, $limit);
 

 $query = $database->getQuery(true);
 $query->select('files.*, galleries.ordering, galleries.access');
 $query->from('#__rsgallery2_files AS files');
 $query->leftJoin('#__rsgallery2_galleries AS galleries ON galleries.id = files.gallery_id');
 $query->leftJoin('#__users AS users ON users.id = files.checked_out');
 $query->where('galleries.access IN ('.$groupsIN.')');
 $query->order('galleries.ordering, files.ordering');
 $database->setQuery($query, $pageNav->limitstart, $pageNav->limit);
 

SELECT files.*, galleries.ordering, galleries.access
 FROM jos_rsgallery2_files AS files
 LEFT JOIN jos_rsgallery2_galleries AS galleries
 ON galleries.id = files.gallery_id
 LEFT JOIN jos_users AS users
 ON users.id = files.checked_out
 WHERE galleries.access IN (1, 2, 3)
 ORDER BY galleries.ordering, files.ordering
 LIMIT 0, 20
 

SELECT files.*, galleries.ordering, galleries.access
 FROM jos_rsgallery2_files AS files
 LEFT JOIN jos_rsgallery2_galleries AS galleries
 ON galleries.id = files.gallery_id
 LEFT JOIN jos_users AS users
 ON users.id = files.checked_out
 WHERE galleries.access IN (1, 2, 3)
 ORDER BY galleries.ordering, files.ordering
 LIMIT 20, 20
 

Brilliant! I was looking for a way to determine whether code in a Joomla component is called for from the backend or the frontend. Finding out if a user is logged in is easy, quite enough code snippets can be found, but finding out if a user is logged in in the frontend or the backend...

But, here we go:
We use the JApplication class which has methods isSite and isAdmin. You've guessed it: the first one returns true if the interface is the site, e.g. a user calls for content from the frontend, the second one returns true if the interface is 'admin', e.g. a user calls for content from the backend.

Now we can use:

if ($app->isSite()) {
//content/logic for frontend
}
if ($app->isAdmin()) {
//content/logic for backend
}
 

And on the off chance that you got here to find out how to see whether or not a user is logged in:

$user =& JFactory::getUser();
if($user->id) {
 //if no user is logged in you won't go here sinde $user->id is 0, which is false
}
 

Just got a strange error message: "Class 'JHtmlSelect' not found" whicht refers to a line

$mitems[]   = JHtmlSelect::option( '0', JText::_('COM_YADAYADAYADA') );
 

The strange thing is not really the error, but that in Joomla 1.6 I get the error for a user with no configure permission whereas if the user has configure permission I don't get this error. But this has nothing directly to do with any configure permission, as far as I can tell...

Then I found a post ''JHTMLSelect, JHTMLMenu, etc results in class not found" where it says "...people should use the proxy methods such as JHTML::_().".

This is explainedby whurley:
"The JHTML widgets are lazily included depending on usage.  In other words, if none of the code has a need for a particular JHTML widget the source file will not be added to the execution environment.  When JTHML::_ is called it imports the appropriate file using jimport (I would imagine) and then executes the appropriate function.  The reason for this is optimization.  If you want to use the direct calls, something that I imagine is not recommended, you could manually call jimport with the appropriate path to ensure it's included.".

Based on that I changed

$mitems[]   = JHtmlSelect::option( '0', JText::_('COM_YADAYADAYADA') );
 

$mitems[]   = JHtml::_('select.option', '0', JText::_('COM_YADAYADAYADA') );