execute(" DELETE FROM arrowchat WHERE (arrowchat.read = 1 AND ('" . time() . "' - arrowchat.sent) > 10800) OR (arrowchat.read = 0 AND ('" . time() . "' - arrowchat.sent) > 604800) "); // Deletes notifications 5 days old $result = $db->execute(" DELETE FROM arrowchat_notifications WHERE arrowchat_notifications.user_read = 1 AND ('" . time() . "' - arrowchat_notifications.alert_time) > 432000 "); } // Announcement Hide Processor if (var_check('announcement_hide')) { $result = $db->execute(" UPDATE arrowchat_config SET config_value = CASE WHEN config_name = 'announcement' THEN '" . get_var('announcement') . "' END WHERE config_name IN ('announcement') "); if ($result) { update_config_file(); include(dirname(dirname(__FILE__)) . DIRECTORY_SEPARATOR . AC_FOLDER_CACHE . DIRECTORY_SEPARATOR . 'data_admin_options.php'); $result = $db->execute(" UPDATE arrowchat_status SET announcement='1' "); if ($result) { $msg = "The chat announcement is now hidden."; if ($push_on == 1) { $arrowpush->publish(array( 'channel' => 'arrowchat', 'message' => array('announcement' => array("data" => "", "read" => "1")) )); } } else { $error = "There was a database error. Please try again."; } } else { $error = "There was a database error. Please try again."; } } // Announcement Show Processor if (var_check('announcement_show')) { $result = $db->execute(" UPDATE arrowchat_config SET config_value = CASE WHEN config_name = 'announcement' THEN '" . get_var('announcement') . "' END WHERE config_name IN ('announcement') "); if ($result) { update_config_file(); include(dirname(dirname(__FILE__)) . DIRECTORY_SEPARATOR . AC_FOLDER_CACHE . DIRECTORY_SEPARATOR . 'data_admin_options.php'); $result = $db->execute(" UPDATE arrowchat_status SET announcement='0' "); if ($result) { $msg = "The chat announcement is now being shown."; if ($push_on == 1) { $arrowpush->publish(array( 'channel' => 'arrowchat', 'message' => array('announcement' => array("data" => $_POST['announcement'], "read" => "0")) )); } } else { $error = "There was a database error. Please try again."; } } else { $error = "There was a database error. Please try again."; } } // Get information for the page $num_messages = $db->count_all(" arrowchat "); $num_users = $db->count_all(" " . TABLE_PREFIX . DB_USERTABLE . " "); $install_time = $db->fetch_row(" SELECT config_value FROM arrowchat_config WHERE config_name = 'install_time' "); // Calculate overview information $days_since = (time() - $install_time->config_value) / 86400; $messages_day = $num_messages / $days_since; $users_day = $num_users / $days_since; // Process Smarty template $smarty->assign('msg', $msg); $smarty->assign('error', $error); $smarty->display(dirname(__FILE__) . DIRECTORY_SEPARATOR . "layout/pages_header.tpl"); require_once (dirname(__FILE__) . DIRECTORY_SEPARATOR . "layout/pages_index.php"); $smarty->display(dirname(__FILE__) . DIRECTORY_SEPARATOR . "layout/pages_footer.tpl"); ?>