static function process_action_sys()
{
@set_time_limit(900);
switch ($_REQUEST["action_sys"]) {
case "maintenance":
if (!sys_validate_token()) {
sys_die("{t}Invalid security token{/t}");
}
$lock_file = SIMPLE_STORE . "/maintenance.lck";
if (!file_exists($lock_file)) {
touch($lock_file);
sys_log_message_alert("info", "{t}Maintenance mode{/t}: {t}Active{/t}");
} else {
unlink($lock_file);
sys_log_message_alert("info", "{t}Maintenance mode{/t}: {t}Inactive{/t}");
}
break;
case "clear_locking":
self::_remove_locks();
dirs_create_empty_dir(SIMPLE_STORE . "/locking");
sys_log_message_log("clean", "{t}Locking{/t}");
break;
case "clear_output":
dirs_create_empty_dir(SIMPLE_CACHE . "/smarty");
dirs_create_empty_dir(SIMPLE_CACHE . "/output");
dirs_create_empty_dir(SIMPLE_CACHE . "/artichow");
dirs_create_empty_dir(SIMPLE_CACHE . "/thumbs");
dirs_create_empty_dir(SIMPLE_CACHE . "/lang");
self::build_css();
self::build_js();
self::build_icons();
sys_log_message_log("clean", "{t}Output{/t}");
break;
case "clear_debug":
dirs_create_empty_dir(SIMPLE_CACHE . "/debug");
sys_log_message_log("clean", "{t}Debug-dir{/t}");
break;
case "clear_cms":
dirs_create_empty_dir(SIMPLE_CACHE . "/cms");
sys_log_message_log("clean", "{t}CMS{/t}");
break;
case "clear_ip":
dirs_create_empty_dir(SIMPLE_CACHE . "/ip");
if (APC) {
apc_clear_cache("user");
}
sys_log_message_log("clean", "IP");
break;
case "clear_schema":
dirs_create_empty_dir(SIMPLE_CACHE . "/schema");
if (APC) {
apc_clear_cache("user");
}
sys_log_message_log("clean", "{t}Schema{/t}");
break;
case "clear_schemadata":
dirs_create_empty_dir(SIMPLE_CACHE . "/schema_data");
dirs_create_empty_dir(SIMPLE_CACHE . "/preview");
if (APC) {
apc_clear_cache("user");
}
sys_log_message_log("clean", "{t}Schema data{/t}");
break;
case "clear_email":
dirs_create_empty_dir(SIMPLE_CACHE . "/imap");
dirs_create_empty_dir(SIMPLE_CACHE . "/pop3");
sys_log_message_log("clean", "{t}E-mail{/t}");
break;
case "clean_notifications":
db_delete("simple_sys_notifications", array("sent='1'"), array());
sql_table_optimize("simple_sys_notifications");
sys_log_message_log("clean", "{t}Notifications{/t}");
break;
case "clear_upload":
dirs_create_empty_dir(SIMPLE_CACHE . "/upload");
sys_log_message_log("clean", "{t}Uploaded files{/t}");
break;
case "clean_tables":
db_optimize_tables();
sys_log_message_log("clean", "{t}Optimize Tables{/t}");
break;
case "clean_statistics":
if (!sys_validate_token()) {
sys_die("{t}Invalid security token{/t}");
}
db_delete("simple_sys_stats", array(), array());
sql_table_optimize("simple_sys_stats");
sys_log_message_log("clean", "{t}Statistics{/t}");
break;
case "clean_events":
if (!sys_validate_token()) {
sys_die("{t}Invalid security token{/t}");
}
db_delete("simple_sys_events", array(), array());
$folder = db_select_value("simple_sys_tree", "id", "ftype=@type@", array("type" => "sys_events"));
if (!empty($folder)) {
db_delete("simple_sys_search", array("folder=@folder@"), array("folder" => $folder));
}
sql_table_optimize("simple_sys_events");
sql_table_optimize("simple_sys_search");
sys_log_message_log("clean", "{t}Events{/t}");
break;
case "clean_trash":
if (!sys_validate_token()) {
sys_die("{t}Invalid security token{/t}");
}
$trash = db_select_value("simple_sys_tree", "id", "anchor=@anchor@", array("anchor" => "trash"));
if (!empty($trash)) {
$folders = db_select("simple_sys_tree", array("id", "fmountpoint"), "parent=@parent@", "", "", array("parent" => $trash));
if (is_array($folders) and count($folders) > 0) {
foreach ($folders as $folder) {
if (!empty($folder["fmountpoint"])) {
continue;
}
folders::delete($folder["id"]);
}
}
}
dirs_create_empty_dir(SIMPLE_STORE . "/trash");
sys_log_message_log("clean", "{t}Trash{/t}");
sys_redirect("index.php?" . sys::$urladdon);
break;
case "clean_cache":
$dirs = array(SIMPLE_STORE . "/cron", SIMPLE_CACHE . "/imap", SIMPLE_CACHE . "/pop3", SIMPLE_CACHE . "/smarty", SIMPLE_CACHE . "/cms", SIMPLE_CACHE . "/cifs", SIMPLE_CACHE . "/gdocs", SIMPLE_CACHE . "/lang", SIMPLE_CACHE . "/output", SIMPLE_CACHE . "/artichow", SIMPLE_CACHE . "/thumbs", SIMPLE_CACHE . "/schema");
foreach ($dirs as $dir) {
self::_dirs_clean_dir($dir, 2592000);
}
// 30 days
self::_remove_locks();
$dirs = array(SIMPLE_CACHE . "/schema_data", SIMPLE_CACHE . "/preview", SIMPLE_STORE . "/locking", SIMPLE_CACHE . "/upload", SIMPLE_CACHE . "/ip", SIMPLE_CACHE . "/debug", SIMPLE_CACHE . "/updater", SIMPLE_CACHE . "/backup");
foreach ($dirs as $dir) {
self::_dirs_clean_dir($dir, 86400);
}
// 1 day
sys_log_message_log("clean", "{t}Clean Cache{/t}");
sys_redirect("index.php?" . sys::$urladdon);
break;
case "clear_setup":
if (!sys_validate_token()) {
sys_die("{t}Invalid security token{/t}");
}
@unlink("simple_store/config.php");
@unlink("simple_store/config_old.php");
header("Location: index.php");
exit;
break;
case "backup":
self::_create_backup($_SESSION["folder"]);
self::_out("<br><a href='index.php?folder=^system/!sys_nodb_backups'>{t}Continue{/t}</a>");
exit;
break;
case "restore_newer":
self::$_restore_onlynewer = true;
echo self::_restore($_REQUEST["file"]);
self::_out("<br><a href='index.php'>{t}Continue{/t}</a>");
exit;
break;
case "restore":
echo self::_restore($_REQUEST["file"]);
self::_out("<br><a href='index.php'>{t}Continue{/t}</a>");
exit;
break;
case "restore_here":
self::$_restore_here = true;
echo self::_restore($_REQUEST["file"]);
self::_out("<br><a href='index.php'>{t}Continue{/t}</a>");
exit;
break;
case "restore_missing":
self::$_restore_missing = true;
echo self::_restore($_REQUEST["file"]);
self::_out("<br><a href='index.php'>{t}Continue{/t}</a>");
exit;
break;
case "rebuild_search":
if (!sys_validate_token()) {
sys_die("{t}Invalid security token{/t}");
}
self::rebuild_schema(true);
self::_out("<br><a href='index.php'>{t}Continue{/t}</a>");
exit;
break;
case "clear_session":
if (!sys_validate_token()) {
sys_die("{t}Invalid security token{/t}");
}
db_delete("simple_sys_session", array(), array());
if (APC) {
apc_clear_cache("user");
}
sys_log_message_log("clean", "{t}Sessions{/t}");
self::_out("<br><a href='index.php'>{t}Continue{/t}</a>");
exit;
break;
case "phpinfo":
echo "System time: " . date("c") . "<br>";
echo "Database time: " . sgsml_parser::sql_date();
phpinfo();
exit;
break;
}
}
public static function import_createedit($tfolder, $module, $username, $lastsync, $fields)
{
$table_source = "fnbl_simple_" . $module . "_imp";
$table_dest = "simple_" . $module;
$sys_date = date("Y-m-d H:i:s");
$db_date = sgsml_parser::sql_date();
if (abs(strtotime($sys_date) - strtotime($db_date)) > 60) {
sys_warning("{t}Error{/t}: {t}current time{/t} {t}System{/t}: " . $sys_date . " {t}Database{/t}: " . $db_date);
}
if (DEBUG) {
echo "Sync4j: " . $table_source . " lastmodified > " . $lastsync . " " . date("c", $lastsync);
}
$count_insert = 0;
$count_update = 0;
$rows = db_select($table_source, "*", array("userid=@username@", "lastmodified > @lastmodified@"), "", "", array("username" => $username, "lastmodified" => $lastsync - 600));
if (is_array($rows) and count($rows) > 0) {
foreach ($rows as $row) {
if ($row["status"] == "D") {
// delete
self::_import_delete($tfolder, $row["syncid"], $table_dest, $module);
continue;
}
unset($row["userid"]);
unset($row["status"]);
if ($table_dest == "simple_contacts" and empty($row["contactid"])) {
continue;
}
if ($table_dest == "simple_tasks") {
if (empty($row["begin"]) and empty($row["ending"])) {
continue;
}
if (empty($row["begin"])) {
$row["begin"] = $row["ending"];
}
}
$exists = db_select_value($table_dest, "id", "syncid=@id@", array("id" => $row["syncid"]));
if (!empty($exists)) {
$id = $exists;
} else {
$id = 0;
}
if ($id != 0) {
// update
$row["history"] = sprintf("{t}Item edited (%s) by %s at %s{/t} (sync)\n", "@fields@", $_SESSION["username"], sys_date("{t}m/d/y g:i:s a{/t}"));
$cdata = "";
$data = $row;
$cfields = array();
$data_old = db_select_first($table_dest, "*", "id=@id@", "", array("id" => $id));
if (!empty($data_old["id"])) {
if ($row["lastmodified"] == $data_old["lastmodified"]) {
continue;
}
foreach ($data as $key => $val) {
if (isset($data_old[$key]) and $key != "history") {
if ($data_old[$key] != $val) {
if (trim($val) != "") {
$cdata .= $key . ": " . $val . "\n";
}
$cfields[] = $key;
} else {
unset($data[$key]);
}
}
}
}
if (count($data) < 3) {
continue;
}
$data["history"] = str_replace("@fields@", implode(", ", $cfields), $data["history"]) . $cdata . "\n";
if (DEBUG) {
print_r($data);
}
$error_sql = db_update($table_dest, $data, array("id=@id@"), array("id" => $id));
$count_update++;
} else {
// new
$id = sql_genID($table_dest) * 100;
$row["id"] = $id;
$row["folder"] = $tfolder;
$row["dsize"] = 0;
$row["history"] = sprintf("{t}Item created by %s at %s{/t} (sync)\n", $_SESSION["username"], sys_date("{t}m/d/y g:i:s a{/t}"));
if (DEBUG) {
print_r($row);
}
$error_sql = db_insert($table_dest, $row);
$count_insert++;
}
if ($error_sql == "") {
if ($module == "calendar") {
trigger::calcappointment($id, $row, false, "simple_calendar");
}
if ($module == "tasks") {
trigger::duration($id, $row, false, "simple_tasks");
}
trigger::notify($id, $row, array(), "simple_" . $module);
db_search_update($table_dest, $id, $fields);
if ($count_insert > 0) {
sys_log_stat("new_records", $count_insert);
}
if ($count_update > 0) {
sys_log_stat("changed_records", $count_update);
}
}
}
}
db_update_treesize($table_dest, $tfolder);
return "";
}
