public static function restoreSettings() { JCommentsSecurity::checkToken(); $db = JCommentsFactory::getDBO(); $db->setQuery("DELETE FROM `#__jcomments_settings`"); $db->query(); require_once dirname(__FILE__) . '/admin.jcomments.installer.php'; $defaultSettings = dirname(__FILE__) . '/install/sql/settings.sql'; JCommentsInstaller::executeSQL($defaultSettings); require_once dirname(__FILE__) . '/install/helpers/installer.php'; JCommentsInstallerHelper::fixUsergroups(); return JText::_('A_SETTINGS_RESTORED'); }
public static function postInstall() { $app = JCommentsFactory::getApplication('administrator'); $db = JCommentsFactory::getDBO(); $installer = new HTML_JCommentsInstaller(); JCommentsInstallerHelper::extractJCommentsPlugins(); // create database tables if (JCOMMENTS_JVERSION == '1.0') { $sql = dirname(__FILE__) . DS . 'install' . DS . 'sql' . DS . 'install.mysql.nonutf8.sql'; JCommentsInstaller::executeSQL($sql); // collation synchronization (for MySQL 4.1.2 or higher) if (version_compare(preg_replace('~\\-.+?$~', '', $db->getVersion()), '4.1.2') >= 0) { JCommentsInstallerDatabaseHelper::setupCollation(); } } else { $config = JFactory::getConfig(); $app = JFactory::getApplication(); @ob_start(); if ($config->getValue('config.legacy')) { $installSQL = dirname(__FILE__) . DS . 'install' . DS . 'sql' . DS . 'install.mysql.utf8.sql'; JCommentsInstaller::executeSQL($installSQL); } jimport('joomla.filesystem.folder'); jimport('joomla.filesystem.file'); $jomSocialRuleSrc = dirname(__FILE__) . DS . 'install' . DS . 'xml' . DS . 'jomsocial_rule.xm'; $jomSocialRuleDst = JCOMMENTS_BASE . DS . 'jomsocial_rule.xml'; if (!is_file($jomSocialRuleDst)) { JFile::copy($jomSocialRuleSrc, $jomSocialRuleDst); } if (is_dir(JCOMMENTS_BASE . DS . 'languages')) { JFolder::delete(JCOMMENTS_BASE . DS . 'languages'); } if (is_file(JCOMMENTS_BASE . DS . 'plugins' . DS . 'plugins.zip')) { JFile::delete(JCOMMENTS_BASE . DS . 'plugins' . DS . 'plugins.zip'); } @ob_end_clean(); $app->setUserState('com_installer.message', ''); $app->setUserState('com_installer.extension_message', ''); $app->setUserState('com_installer.redirect_url', ''); } $jxml10 = dirname(__FILE__) . DS . 'jcomments10.xml'; $jxml15 = dirname(__FILE__) . DS . 'jcomments15.xml'; $jxml = dirname(__FILE__) . DS . 'jcomments.xml'; if (is_file($jxml10)) { @rename($jxml10, $jxml); } else { if (is_file($jxml15)) { @rename($jxml15, $jxml); // fix version in xml manifest file if (JCOMMENTS_JVERSION == '1.7') { $contents = str_replace('1.5.0', '1.7.0', implode('', file($jxml))); $fh = fopen($jxml, 'w'); if ($fh) { fputs($fh, $contents); fclose($fh); } } } } unset($jxml10, $jxml15, $jxml); if (JCOMMENTS_JVERSION != '1.7') { // remove files from previous version $files = array(dirname(__FILE__) . DS . 'admin.jcomments.subcription.php', dirname(__FILE__) . DS . 'table' . DS . 'custombbcodes.php', JCOMMENTS_BASE . DS . 'model' . DS . 'index.html', JCOMMENTS_BASE . DS . 'model' . DS . 'jcomments.php', JCOMMENTS_BASE . DS . 'model'); foreach ($files as $file) { if (is_file($file)) { @unlink($file); } else { if (is_dir($file)) { @rmdir($file); } } } } // small stuff for future update system $db->setQuery('SELECT `version` FROM `#__jcomments_version`'); $version = $db->loadResult(); require_once dirname(__FILE__) . DS . 'version.php'; $jcommentsVersion = new JCommentsVersion(); $currentVersion = $jcommentsVersion->getVersion(); $currentDate = date('Y-m-d H:i:s'); if (empty($version)) { $db->setQuery("INSERT IGNORE INTO `#__jcomments_version` (`version`,`installed`) VALUES ('{$currentVersion}', '{$currentDate}')"); @$db->query(); // if version isn't specified - we think that it was 2.2.0.0 or earlier... $version = '2.2.0.0'; } else { $db->setQuery("UPDATE `#__jcomments_version` SET `version` = '{$currentVersion}', `updated` = '{$currentDate}';"); @$db->query(); } // install content plugin $result = JCommentsInstallerHelper::installPlugin('Content - JComments', 'jcomments', 'content'); $installer->addMessage(JText::_('A_INSTALL_PLUGIN_CONTENT'), $result); // install search plugin $result = JCommentsInstallerHelper::installPlugin('Search - JComments', 'jcomments', 'search'); $installer->addMessage(JText::_('A_INSTALL_PLUGIN_SEARCH'), $result); // install system plugin $result = JCommentsInstallerHelper::installPlugin('System - JComments', 'jcomments', 'system'); $installer->addMessage(JText::_('A_INSTALL_PLUGIN_SYSTEM'), $result); // install editor buttons $result = JCommentsInstallerHelper::installPlugin('Editor Button - JComments ON', 'jcommentson', 'editors-xtd', array('jcommentson.gif')); $result = $result && JCommentsInstallerHelper::installPlugin('Editor Button - JComments OFF', 'jcommentsoff', 'editors-xtd', array('jcommentsoff.gif')); $installer->addMessage(JText::_('A_INSTALL_PLUGIN_EDITORS_XTD'), $result); if (JCOMMENTS_JVERSION != '1.0') { // install user plugin $result = JCommentsInstallerHelper::installPlugin('User - JComments', 'jcomments', 'user'); $installer->addMessage(JText::_('A_INSTALL_PLUGIN_USER'), $result); } // Fix component menu icon if (JCOMMENTS_JVERSION == '1.0') { $menuiconpath = $app->getCfg('absolute_path') . DS . 'includes' . DS . 'js' . DS . 'ThemeOffice'; $adminIconsPath = '../administrator/components/com_jcomments/assets'; if (is_writable($menuiconpath)) { $currentIconsPath = dirname(__FILE__) . DS . 'images'; ob_start(); $res1 = @copy($currentIconsPath . DS . 'icon-16-jcomments.png', $menuiconpath . DS . 'icon-16-jcomments.png'); $res2 = @copy($currentIconsPath . DS . 'icon-16-import.png', $menuiconpath . DS . 'icon-16-import.png'); $res3 = @copy($currentIconsPath . DS . 'icon-16-settings.png', $menuiconpath . DS . 'icon-16-settings.png'); $res4 = @copy($currentIconsPath . DS . 'icon-16-smiles.png', $menuiconpath . DS . 'icon-16-smiles.png'); $res5 = @copy($currentIconsPath . DS . 'icon-16-comments.png', $menuiconpath . DS . 'icon-16-comments.png'); $res6 = @copy($currentIconsPath . DS . 'icon-16-subscriptions.png', $menuiconpath . DS . 'icon-16-subscriptions.png'); $res7 = @copy($currentIconsPath . DS . 'icon-16-custombbcodes.png', $menuiconpath . DS . 'icon-16-custombbcodes.png'); $res8 = @copy($currentIconsPath . DS . 'icon-16-blacklist.png', $menuiconpath . DS . 'icon-16-blacklist.png'); ob_end_clean(); $result = $res1 && $res2 && $res3 && $res4 && $res5 && $res6 && $res7 && $res8; if ($result && is_file($menuiconpath . DS . 'jcomments16x16.png')) { $adminIconsPath = 'js/ThemeOffice'; } } $db->setQuery("UPDATE #__components SET admin_menu_img='{$adminIconsPath}/icon-16-jcomments.png' " . "\n WHERE admin_menu_link='option=com_jcomments'"); @$db->query(); $db->setQuery("UPDATE #__components SET admin_menu_img='{$adminIconsPath}/icon-16-comments.png', name='" . JText::_('A_SUBMENU_COMMENTS') . "'" . "\n WHERE admin_menu_link='option=com_jcomments&task=comments'"); @$db->query(); $db->setQuery("UPDATE #__components SET admin_menu_img='{$adminIconsPath}/icon-16-settings.png', name='" . JText::_('A_SUBMENU_SETTINGS') . "'" . "\n WHERE admin_menu_link='option=com_jcomments&task=settings'"); @$db->query(); $db->setQuery("UPDATE #__components SET admin_menu_img='{$adminIconsPath}/icon-16-smiles.png', name='" . JText::_('A_SUBMENU_SMILES') . "'" . "\n WHERE admin_menu_link='option=com_jcomments&task=smiles'"); @$db->query(); $db->setQuery("UPDATE #__components SET admin_menu_img='{$adminIconsPath}/icon-16-subscriptions.png', name='" . JText::_('A_SUBMENU_SUBSCRIPTIONS') . "'" . "\n WHERE admin_menu_link='option=com_jcomments&task=subscriptions'"); @$db->query(); $db->setQuery("UPDATE #__components SET admin_menu_img='{$adminIconsPath}/icon-16-custombbcodes.png', name='" . JText::_('A_SUBMENU_CUSTOM_BBCODE') . "'" . "\n WHERE admin_menu_link='option=com_jcomments&task=custombbcodes'"); @$db->query(); $db->setQuery("UPDATE #__components SET admin_menu_img='{$adminIconsPath}/icon-16-blacklist.png', name='" . JText::_('A_SUBMENU_BLACKLIST') . "'" . "\n WHERE admin_menu_link='option=com_jcomments&task=blacklist'"); @$db->query(); $db->setQuery("UPDATE #__components SET admin_menu_img='{$adminIconsPath}/icon-16-import.png', name='" . JText::_('A_SUBMENU_IMPORT') . "'" . "\n WHERE admin_menu_link='option=com_jcomments&task=import'"); @$db->query(); $db->setQuery("UPDATE #__components SET admin_menu_img='{$adminIconsPath}/icon-16-jcomments.png', name='" . JText::_('A_SUBMENU_ABOUT') . "'" . "\n WHERE admin_menu_link='option=com_jcomments&task=about'"); @$db->query(); } if (version_compare($version, '2.3.0', 'le')) { // update db tables if (JCommentsInstallerDatabaseHelper::upgradeStructure()) { $installer->addMessage(JText::_('A_INSTALL_UPGRADE_TABLES'), true); } JCommentsInstallerDatabaseHelper::updateJoomGallery(); if (JCOMMENTS_JVERSION != '1.7') { $db->setQuery("UPDATE `#__jcomments_settings` SET `value` = REPLACE(`value`, 'Unregistered', 'Public') "); $db->query(); $db->setQuery("UPDATE `#__jcomments_settings` SET `value` = REPLACE(`value`, 'Super Administrator', 'Super Users') "); $db->query(); $db->setQuery("UPDATE `#__jcomments_custom_bbcodes` SET `button_acl` = REPLACE(`button_acl`, 'Unregistered', 'Public') "); $db->query(); $db->setQuery("UPDATE `#__jcomments_custom_bbcodes` SET `button_acl` = REPLACE(`button_acl`, 'Super Administrator', 'Super Users') "); $db->query(); } } if (isset($_COOKIE['jcommentsadmin_group'])) { if (!headers_sent()) { setcookie('jcommentsadmin_group', '', time() - 3600, '/'); } unset($_COOKIE['jcommentsadmin_group']); } $db->setQuery("SELECT `name`, `value` FROM `#__jcomments_settings`"); $paramsList = $db->loadObjectList('name'); if (count($paramsList) == 0) { $defaultSettings = dirname(__FILE__) . DS . 'install' . DS . 'sql' . DS . 'settings.sql'; JCommentsInstaller::executeSQL($defaultSettings); } else { JCommentsInstaller::checkParam($paramsList, 'delete_mode', '0'); JCommentsInstaller::checkParam($paramsList, 'can_publish_for_my_object', ''); JCommentsInstaller::checkParam($paramsList, 'can_edit_for_my_object', ''); JCommentsInstaller::checkParam($paramsList, 'can_delete_for_my_object', ''); JCommentsInstaller::checkParam($paramsList, 'enable_blacklist', '0'); JCommentsInstaller::checkParam($paramsList, 'can_ban', 'Administrator,Super Administrator'); JCommentsInstaller::checkParam($paramsList, 'feed_limit', '100'); JCommentsInstaller::checkParam($paramsList, 'report_reason_required', '1'); if (version_compare($version, '2.2.0.0') <= 0) { $smilesPath = DS . 'components' . DS . 'com_jcomments' . DS . 'images' . DS . 'smiles' . DS; JCommentsInstaller::checkParam($paramsList, 'smiles_path', $smilesPath, true); } } unset($paramsList); if (JCOMMENTS_JVERSION == '1.7') { // TODO remove this hack JCommentsInstallerHelper::fixComponentName(); } JCommentsInstallerHelper::fixUsergroups(); $joomfish = $app->getCfg('absolute_path') . DS . 'components' . DS . 'com_joomfish' . DS . 'joomfish.php'; if (is_file($joomfish) || JCommentsMultilingual::isEnabled()) { JCommentsInstaller::upgradeLanguages(); } $db->setQuery("SELECT COUNT(*) FROM `#__jcomments_custom_bbcodes`;"); $cnt = $db->loadResult(); if ($cnt == 0) { $sql = dirname(__FILE__) . DS . 'install' . DS . 'sql' . DS . 'custom_bbcodes.sql'; JCommentsInstaller::executeSQL($sql); } JCommentsInstallerHelper::fixCustomBBCodeACL(); $installer->showInstallLog(); $cache = JCommentsFactory::getCache('com_jcomments'); $cache->clean(); }