public static function getInstance()
{
if (!self::$instance) {
self::$instance = self::createAdapterInstance();
}
return self::$instance;
}
public static function getAll()
{
$sgdb = SGDatabase::getInstance();
$configs = $sgdb->query('SELECT * FROM ' . SG_CONFIG_TABLE_NAME);
if (!$configs) {
return null;
}
$currentConfigs = array();
foreach ($configs as $config) {
self::$values[$config['ckey']] = $config['cvalue'];
$currentConfigs[$config['ckey']] = $config['cvalue'];
}
return $currentConfigs;
}
public static function uninstall($deleteBackups = false)
{
try {
$sgdb = SGDatabase::getInstance();
//drop config table
$res = $sgdb->query('DROP TABLE IF EXISTS `' . SG_CONFIG_TABLE_NAME . '`;');
if ($res === false) {
throw new SGExceptionDatabaseError('Could not execute query');
}
//drop action table
$res = $sgdb->query('DROP TABLE IF EXISTS `' . SG_ACTION_TABLE_NAME . '`;');
if ($res === false) {
throw new SGExceptionDatabaseError('Could not execute query');
}
//delete directory of backups
if ($deleteBackups) {
$backupPath = SGConfig::get('SG_BACKUP_DIRECTORY');
deleteDirectory($backupPath);
}
} catch (SGException $exception) {
die($exception);
}
}
public function __construct()
{
$this->sgdb = SGDatabase::getInstance();
}
public function __construct()
{
$this->sgdb = SGDatabase::getInstance();
$notificationCenter = SGNotificationCenter::getInstance();
$notificationCenter->addObserver(SG_NOTIFICATION_SAVE_DB_ACTION_STATE, $this, 'saveActionState', true);
}
public static function deleteBackup($backupName, $deleteAction = true)
{
deleteDirectory(SG_BACKUP_DIRECTORY . $backupName);
if ($deleteAction) {
$sgdb = SGDatabase::getInstance();
$sgdb->query('DELETE FROM ' . SG_ACTION_TABLE_NAME . ' WHERE name=%s', array($backupName));
}
}
function getReport()
{
$jsonArray = array();
$headerArray = array();
$jsonArray['ptype'] = '1';
$jsonArray['token'] = '28016ffb35b451291bfed7c5905474d6';
$lastReportTime = SGConfig::get('SG_LAST_REPORT_DATE');
if (!$lastReportTime) {
SGConfig::set('SG_LAST_REPORT_DATE', time());
}
SGBackup::getLogFileHeader($headerArray);
$jsonArray['header'] = $headerArray;
$jsonArray['header']['uid'] = sha1("http://" . @$_SERVER[HTTP_HOST] . @$_SERVER[REQUEST_URI]);
$sgdb = SGDatabase::getInstance();
$res = $sgdb->query('SELECT type, subtype, status, count(*) AS scount FROM ' . SG_ACTION_TABLE_NAME . ' WHERE update_date > FROM_UNIXTIME(%d) GROUP BY type, subtype, status', array($lastReportTime));
if (count($res)) {
foreach ($res as $item) {
$jsonArray['log'][] = $item;
}
}
return json_encode($jsonArray);
}
