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!');
}
