function postInstall() { global $mainframe; $db =& JCommentsFactory::getDBO(); $installer = new HTML_JCommentsInstaller(); JCommentsInstallerHelper::extractJCommentsPlugins(); JCommentsInstallerHelper::setPermissions(JCOMMENTS_BASE . DS . 'tpl', '0644'); // create database tables if (JCOMMENTS_JVERSION == '1.0') { $installSQL = dirname(__FILE__) . DS . 'install' . DS . 'sql' . DS . 'install.mysql.nonutf8.sql'; JCommentsInstaller::executeSQL($installSQL); } else { if (JCOMMENTS_JVERSION == '1.5') { require_once JCOMMENTS_LIBRARIES . DS . 'joomlatune' . DS . 'filesystem.php'; $config =& JFactory::getConfig(); $mainframe =& JFactory::getApplication(); if ($config->getValue('config.legacy')) { $installSQL = dirname(__FILE__) . DS . 'install' . DS . 'sql' . DS . 'install.mysql.utf8.sql'; JCommentsInstaller::executeSQL($installSQL); // path to languages directory $path = JCOMMENTS_BASE . DS . 'languages'; $jpath = JPATH_ROOT . DS . 'language'; $languages = JoomlaTuneFS::readDirectory($path); if (!is_writable($jpath)) { @chmod($jpath, 0755); } foreach ($languages as $language) { if (preg_match('#[a-z]{2}\\-[A-Z]{2}\\.com_jcomments.ini#is', (string) $language)) { $languageCode = substr((string) $language, 0, 5); $languageDir = $jpath . DS . $languageCode; if (!is_dir($languageDir)) { if (!JFolder::create($languageDir)) { continue; } } if (is_dir($languageDir)) { @chmod($languageDir, 0755); $languageSrc = $path . DS . $language; $languageDestination = $languageDir . DS . $language; if (!@copy($languageSrc, $languageDestination)) { $errorMessage = JText::sprintf('Unable to copy file %s to language folder. Please set write persmission to language folder (%s) and press the Refresh/Reload button of your browser.', $language, $languageDir); $installer->addError($errorMessage); continue; } } } } unset($languages); $language =& JFactory::getLanguage(); $language->load('com_jcomments', JPATH_SITE, null, true); } @ob_start(); // install JomSocial Rule $jomSocialRuleSrc = dirname(__FILE__) . DS . 'install' . DS . 'xml' . DS . 'jomsocial_rule.xm'; $jomSocialRuleDst = JCOMMENTS_BASE . DS . 'jomsocial_rule.xml'; if (!is_file($jomSocialRuleDst)) { JCommentsInstallerHelper::copyFile($jomSocialRuleSrc, $jomSocialRuleDst); JCommentsInstallerHelper::setPermissions($jomSocialRuleDst, 0755); } // remove language files $path = JCOMMENTS_BASE . DS . 'languages'; $filter = '\\.ini'; $files = JoomlaTuneFS::readDirectory($path, $filter, false, true); foreach ($files as $file) { JCommentsInstallerHelper::deleteFile($file); } if (is_dir($path)) { JCommentsInstallerHelper::deleteFolder($path); } // remove plugins.zip if (is_file(JCOMMENTS_BASE . DS . 'plugins' . DS . 'plugins.zip')) { JCommentsInstallerHelper::deleteFile(JCOMMENTS_BASE . DS . 'plugins' . DS . 'plugins.zip'); } @ob_end_clean(); } } $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); } } unset($jxml10, $jxml15, $jxml); // small stuff for future update system $db->setQuery('SELECT `version` FROM `#__jcomments_version`'); $version = $db->loadResult(); $versionInfo = JCommentsInstallerHelper::getVersionInfo('jcomments'); $currentVersion = $versionInfo->releaseVersion; $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 1.4.0.9 or earlier... $version = '1.4.0.9'; } else { $db->setQuery("UPDATE `#__jcomments_version` SET `version` = '{$currentVersion}', `updated` = '{$currentDate}';"); @$db->query(); } if (version_compare($version, '2.1.0.0') < 0) { JCommentsInstallerHelper::uninstallPlugin('jcomments.content', 'content'); JCommentsInstallerHelper::uninstallPlugin('jcomments.search', 'search'); JCommentsInstallerHelper::uninstallPlugin('jcomments.system', 'system'); } // install content plugin JCommentsInstallerHelper::installPlugin('Content - JComments', 'jcomments', 'content', array(), 'AI_INSTALL_CONTENTBOT', 'AI_INSTALL_CONTENTBOT_WARNING', 1, $installer); // install search plugin JCommentsInstallerHelper::installPlugin('Search - JComments', 'jcomments', 'search', array(), 'AI_INSTALL_CONTENTSEARCHBOT', 'AI_INSTALL_CONTENTSEARCHBOT_WARNING', 1, $installer); // install system plugin JCommentsInstallerHelper::installPlugin('System - JComments', 'jcomments', 'system', array(), 'AI_INSTALL_SYSTEMBOT', 'AI_INSTALL_SYSTEMBOT_WARNING', 1, $installer); // install editor buttons JCommentsInstallerHelper::installPlugin('Editor Button - JComments ON', 'jcommentson', 'editors-xtd', array('jcommentson.gif'), '', '', 1, $installer); JCommentsInstallerHelper::installPlugin('Editor Button - JComments OFF', 'jcommentsoff', 'editors-xtd', array('jcommentsoff.gif'), '', '', 1, $installer); if (JCOMMENTS_JVERSION == '1.5') { // install user plugin JCommentsInstallerHelper::installPlugin('User - JComments', 'jcomments', 'user', array(), '', '', 1, $installer); } // Fix component menu icon if (JCOMMENTS_JVERSION == '1.0') { $menuiconpath = $mainframe->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 = $res2 = $res3 = $res4 = $res5 = false; $res1 = @copy($currentIconsPath . DS . 'jcomments16x16.png', $menuiconpath . DS . 'jcomments16x16.png'); $res2 = @copy($currentIconsPath . DS . 'import16x16.png', $menuiconpath . DS . 'import16x16.png'); $res3 = @copy($currentIconsPath . DS . 'settings16x16.png', $menuiconpath . DS . 'settings16x16.png'); $res4 = @copy($currentIconsPath . DS . 'smiles16x16.png', $menuiconpath . DS . 'smiles16x16.png'); $res5 = @copy($currentIconsPath . DS . 'comments16x16.png', $menuiconpath . DS . 'comments16x16.png'); $res6 = @copy($currentIconsPath . DS . 'subscriptions16x16.png', $menuiconpath . DS . 'subscriptions16x16.png'); $res7 = @copy($currentIconsPath . DS . 'custombbcodes16x16.png', $menuiconpath . DS . 'custombbcodes16x16.png'); ob_end_clean(); $result = $res1 && $res2 && $res3 && $res4 && $res5 && $res6 && $res7; if ($result && is_file($menuiconpath . DS . 'jcomments16x16.png')) { $adminIconsPath = 'js/ThemeOffice'; } } $db->setQuery("UPDATE #__components SET admin_menu_img='{$adminIconsPath}/jcomments16x16.png' " . "\n WHERE admin_menu_link='option=com_jcomments'"); @$db->query(); $db->setQuery("UPDATE #__components SET admin_menu_img='{$adminIconsPath}/comments16x16.png', name='" . JText::_('AI_MENU_COMMENTS') . "'" . "\n WHERE admin_menu_link='option=com_jcomments&task=comments'"); @$db->query(); $db->setQuery("UPDATE #__components SET admin_menu_img='{$adminIconsPath}/settings16x16.png', name='" . JText::_('AI_MENU_SETTINGS') . "'" . "\n WHERE admin_menu_link='option=com_jcomments&task=settings'"); @$db->query(); $db->setQuery("UPDATE #__components SET admin_menu_img='{$adminIconsPath}/smiles16x16.png', name='" . JText::_('AI_MENU_SMILES') . "'" . "\n WHERE admin_menu_link='option=com_jcomments&task=smiles'"); @$db->query(); $db->setQuery("UPDATE #__components SET admin_menu_img='{$adminIconsPath}/subscriptions16x16.png', name='" . JText::_('AI_MENU_SUBSCRIPTIONS') . "'" . "\n WHERE admin_menu_link='option=com_jcomments&task=subscriptions'"); @$db->query(); $db->setQuery("UPDATE #__components SET admin_menu_img='{$adminIconsPath}/custombbcodes16x16.png', name='" . JText::_('Custom BBCode') . "'" . "\n WHERE admin_menu_link='option=com_jcomments&task=custombbcodes'"); @$db->query(); $db->setQuery("UPDATE #__components SET admin_menu_img='{$adminIconsPath}/import16x16.png', name='" . JText::_('AI_MENU_IMPORT') . "'" . "\n WHERE admin_menu_link='option=com_jcomments&task=import'"); @$db->query(); $db->setQuery("UPDATE #__components SET admin_menu_img='{$adminIconsPath}/jcomments16x16.png', name='" . JText::_('AI_MENU_ABOUT') . "'" . "\n WHERE admin_menu_link='option=com_jcomments&task=about'"); @$db->query(); // clear Joostina administrative menu cache if (function_exists('js_menu_cache_clear')) { @js_menu_cache_clear(); } } else { $adminIconsPath = 'components/com_jcomments/assets'; $db->setQuery("UPDATE #__components SET admin_menu_img='{$adminIconsPath}/jcomments16x16.png' WHERE admin_menu_link='option=com_jcomments' OR admin_menu_link='option=com_jcomments&task=about'"); @$db->query(); $db->setQuery("UPDATE #__components SET admin_menu_img='{$adminIconsPath}/comments16x16.png' WHERE admin_menu_link='option=com_jcomments&task=comments'"); @$db->query(); $db->setQuery("UPDATE #__components SET admin_menu_img='{$adminIconsPath}/settings16x16.png' WHERE admin_menu_link='option=com_jcomments&task=settings'"); @$db->query(); $db->setQuery("UPDATE #__components SET admin_menu_img='{$adminIconsPath}/smiles16x16.png' WHERE admin_menu_link='option=com_jcomments&task=smiles'"); @$db->query(); $db->setQuery("UPDATE #__components SET admin_menu_img='{$adminIconsPath}/subscriptions16x16.png' WHERE admin_menu_link='option=com_jcomments&task=subscriptions'"); @$db->query(); $db->setQuery("UPDATE #__components SET admin_menu_img='{$adminIconsPath}/custombbcodes16x16.png' WHERE admin_menu_link='option=com_jcomments&task=custombbcodes'"); @$db->query(); $db->setQuery("UPDATE #__components SET admin_menu_img='{$adminIconsPath}/import16x16.png' WHERE admin_menu_link='option=com_jcomments&task=import'"); @$db->query(); } $installer->addMessage(JText::_('AI_UPDATE_MENU_ICONS'), true); // update db tables $dbStructureChanged = version_compare($version, '2.2.0.0') <= 0; if ($dbStructureChanged) { require_once dirname(__FILE__) . DS . 'install' . DS . 'helpers' . DS . 'database.php'; $upgradeStructure2000 = false; if (version_compare($version, '2.0.0.0') < 0) { // auto upgrade old table structure $upgradeStructure2000 = JCommentsInstallerDatabaseHelper::upgradeStructure(); } $upgradeStructure2200 = JCommentsInstallerDatabaseHelper::upgradeStructure2200(); if ($upgradeStructure2200) { // TODO upgrade tree structure during installation process // JCommentsInstallerDatabaseHelper::updateCommentsLevel(); // JCommentsInstallerDatabaseHelper::updateCommentsPath(); } if ($upgradeStructure2000 || $upgradeStructure2200) { $installer->addMessage(JText::_('AI_UPGRADE_TABLES'), true); } } // upgrade subscriptions to new comments $subscriptionsChanged = version_compare($version, '2.1.0.0') < 0; if ($subscriptionsChanged) { $upgradeSubs = JCommentsInstaller::upgradeSubscriptions($version); if ($upgradeSubs) { $installer->addMessage(JText::_('Upgrade subscriptions'), true); } } // collation synchronization (for MySQL 4.1.2 or higher) if (version_compare(preg_replace('~\\-.+?$~', '', $db->getVersion()), '4.1.2') >= 0) { require_once dirname(__FILE__) . DS . 'install' . DS . 'helpers' . DS . 'database.php'; JCommentsInstallerDatabaseHelper::setupCollation(); } $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, 'comment_title', '0'); JCommentsInstaller::checkParam($paramsList, 'enable_custom_bbcode', '0'); JCommentsInstaller::checkParam($paramsList, 'enable_bbcode_quote', 'Unregistered,Registered,Author,Editor,Publisher,Manager,Administrator,Super Administrator'); JCommentsInstaller::checkParam($paramsList, 'notification_type', '1,2'); JCommentsInstaller::checkParam($paramsList, 'captcha_engine', 'kcaptcha'); JCommentsInstaller::checkParam($paramsList, 'comment_minlength', '0'); } unset($paramsList); $joomfish = $mainframe->getCfg('absolute_path') . DS . 'components' . DS . 'com_joomfish' . DS . 'joomfish.php'; if (is_file($joomfish)) { JCommentsInstaller::upgradeLanguages(); } if (JCOMMENTS_JVERSION == '1.0') { // Update Artio JoomSEF configuration (add option to skip JComments urls) JCommentsInstaller::updateArtio(); } $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); } $installer->showInstallLog(); JCommentsCache::cleanCache('com_jcomments'); }
function installPlugin($name, $element, $folder, $files, $message, $errorMessage, $published, &$installer) { static $ordering, $plugins; $db =& JCommentsFactory::getDBO(); $published = intval($published) ? 1 : 0; if (JCOMMENTS_JVERSION == '1.0') { global $mainframe; $pluginsName = 'mambots'; $pluginsTable = '#__mambots'; $pluginsDstPath = $mainframe->getCfg('absolute_path') . DS . 'mambots' . DS . $folder; $pluginsQuery = "INSERT INTO `#__mambots` (`name`, `element`, `folder`, `access`, `ordering`, `published` ) VALUES ('%s', '%s', '%s', 0, %s, {$published} );"; $pluginsExt = 'x10'; } else { if (JCOMMENTS_JVERSION == '1.5') { $version = new JVersion(); if (version_compare('1.6', $version->getShortVersion()) <= 0) { $pluginsName = 'plugins'; $pluginsTable = '#__extensions'; $pluginsDstPath = JPATH_ROOT . DS . 'plugins' . DS . $folder; $pluginsQuery = "INSERT INTO `#__extensions` (`type`, `name`, `element`, `folder`, `access`, `ordering`, `enabled`) VALUES ('plugin', '%s', '%s', '%s', 1, %s, {$published} );"; $pluginsExt = 'x15'; } else { $pluginsName = 'plugins'; $pluginsTable = '#__plugins'; $pluginsDstPath = JPATH_ROOT . DS . 'plugins' . DS . $folder; $pluginsQuery = "INSERT INTO `#__plugins` (`name`, `element`, `folder`, `access`, `ordering`, `published` ) VALUES ('%s', '%s', '%s', 0, %s, {$published} );"; $pluginsExt = 'x15'; } } } if (empty($ordering)) { $db->setQuery("SELECT folder, MAX(ordering) as maxid FROM `" . $pluginsTable . "` GROUP BY `folder`;"); $ordering = @$db->loadObjectList('folder'); } if (empty($plugins)) { $db->setQuery("SELECT CONCAT(folder, '.', element) as plugin FROM `" . $pluginsTable . "` WHERE `folder` <> '' order by `folder`;"); $plugins = $db->loadResultArray(); } $pluginsSrcPath = JCOMMENTS_ADMIN . DS . 'install' . DS . 'plugins' . DS . $folder; if (!is_dir($pluginsDstPath . DS)) { JCommentsInstallerHelper::createFolder($pluginsDstPath . DS); } if (!is_writable($pluginsDstPath . DS)) { @chmod($pluginsDstPath . DS, 0755); } $result = true; $files[] = $element . '.php'; $files[] = $element . '.' . $pluginsExt; foreach ($files as $file) { $dstFileName = $pluginsDstPath . DS . $file; $srcFileName = $pluginsSrcPath . DS . $file; if (strpos($dstFileName, $pluginsExt) !== false) { $dstFileName = str_replace($pluginsExt, 'xml', $dstFileName); } if (is_file($dstFileName)) { JCommentsInstallerHelper::deleteFile($dstFileName); } $result = $result && JCommentsInstallerHelper::copyFile($srcFileName, $dstFileName); } if ($result) { if (!in_array($folder . '.' . $element, $plugins)) { $maxId = isset($ordering[$folder]) ? intval($ordering[$folder]->maxid) + 1 : 0; $db->setQuery(sprintf($pluginsQuery, $name, $element, $folder, $maxId)); $db->query(); } } if ($message != '') { $installer->addMessage(JText::_($message), $result); if (!$result && $errorMessage != '') { $installer->addWarning(JText::sprintf($errorMessage, $pluginsName)); } } }