function consolidateDB() { global $rsgConfig; $database =& JFactory::getDBO(); //Load all image names from DB in array $sql = "SELECT name FROM #__rsgallery2_files"; $database->setQuery($sql); $names_db = rsg2_consolidate::arrayToLower($database->loadResultArray()); $files_display = rsg2_consolidate::getFilenameArray($rsgConfig->get('imgPath_display')); $files_original = rsg2_consolidate::getFilenameArray($rsgConfig->get('imgPath_original')); $files_thumb = rsg2_consolidate::getFilenameArray($rsgConfig->get('imgPath_thumb')); $files_total = array_unique(array_merge($files_display, $files_original, $files_thumb)); html_rsg2_maintenance::consolidateDB($names_db, $files_display, $files_original, $files_thumb, $files_total); }
function showMaintenanceCP() { ?> <div id="rsg2-thisform"> <div id='cpanel'> <?php $link = 'index2.php?option=com_rsgallery2&rsgOption=maintenance&task=consolidateDB'; html_rsg2_maintenance::quickiconBar($link, 'blockdevice.png', JText::_('MAINT_CONSOLDB'), JText::_('MAINT_CONSOLDB_TXT')); $link = 'index2.php?option=com_rsgallery2&rsgOption=maintenance&task=regenerateThumbs'; html_rsg2_maintenance::quickiconBar($link, 'menu.png', JText::_('MAINT_REGEN'), JText::_('MAINT_REGEN_TXT')); $link = 'index2.php?option=com_rsgallery2&rsgOption=maintenance&task=optimizeDB'; html_rsg2_maintenance::quickiconBar($link, 'db_optimize.png', JText::_('MAINT_OPTDB'), JText::_('MAINT_OPTDB_TXT')); ?> </div> <div class='rsg2-clr'> </div> </div> <?php }
function regenerateImages() { //Select the right gallery, multiple galleries or select them all $lists['gallery_dropdown'] = galleryUtils::galleriesSelectList(null, "gid[]", true, "MULTIPLE"); html_rsg2_maintenance::regenerateImages($lists); }