/**
* Returns number of files within a specific gallery and it's children
* @deprecated use rsgGallery->itemCount() instead.
* @param int Category id
* @return int Number of files in category
*/
function getFileCount($id)
{
$database =& JFactory::getDBO();
$list = galleryUtils::getChildList($id);
$database->setQuery("SELECT COUNT(1) FROM #__rsgallery2_files WHERE gallery_id IN ({$list})");
$count = $database->loadResult();
return $count;
}
/**
* Shows a selectbox with the filenames in the selected gallery
* @param int Gallery ID
* @param int Currently selected thumbnail
* @return HTML representation of a selectbox
* @todo Also offer the possiblity to select thumbs from subgalleries
*/
function showThumbNames($id, $current_id, $selectname = 'thumb_id')
{
$database =& JFactory::getDBO();
if ($id == null) {
echo JText::_('NO IMAGES IN GALLERY YET');
return;
}
$list = galleryUtils::getChildList($id);
//$sql = "SELECT name, id FROM #__rsgallery2_files WHERE gallery_id in ($list)";
$sql = "SELECT a.name, a.id, b.name as gname FROM #__rsgallery2_files AS a " . "LEFT JOIN #__rsgallery2_galleries AS b ON a.gallery_id = b.id " . "WHERE gallery_id IN ({$list}) " . "ORDER BY gname, a.id ASC";
$database->setQuery($sql);
$list = $database->loadObjectList();
if ($list == null) {
echo JText::_('NO IMAGES IN GALLERY YET');
return;
}
$dropdown_html = "<select name=\"{$selectname}\"><option value=\"0\" SELECTED>- Random thumbnail -</option>\n";
if (!isset($current_id)) {
$current_id = 0;
}
foreach ($list as $item) {
$dropdown_html .= "<option value=\"{$item->id}\"";
if ($item->id == $current_id) {
$dropdown_html .= " SELECTED>";
} else {
$dropdown_html .= ">";
}
$dropdown_html .= $item->name . " (" . $item->gname . ")</option>\n";
}
echo $dropdown_html . "</select>";
}
