function executeSQL($filename = '') { if (is_file($filename)) { $buffer = file_get_contents($filename); if ($buffer === false) { return false; } $db =& JCommentsFactory::getDBO(); $queries = JCommentsInstaller::splitSql($buffer); foreach ($queries as $query) { $query = trim((string) $query); if ($query != '') { $db->setQuery($query); @$db->query(); } } } return true; }
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'); }
function restoreSettings() { $db =& JCommentsFactory::getDBO(); $db->setQuery("DELETE FROM `#__jcomments_settings`"); $db->query(); require_once dirname(__FILE__) . DS . 'admin.jcomments.installer.php'; $defaultSettings = dirname(__FILE__) . DS . 'install' . DS . 'sql' . DS . 'settings.sql'; JCommentsInstaller::executeSQL($defaultSettings); return JText::_('The default settings have been restored!'); }