= get_var('config_online_timeout'))
{
$heart_beat_test = false;
}
// Add a slash to the end of the base URL is one doesn't exist
if (substr($new_base_url, -1) != "/")
{
$new_base_url = $new_base_url . "/";
}
$result = $db->execute("
UPDATE arrowchat_config
SET config_value = CASE
WHEN config_name = 'base_url' THEN '" . $new_base_url . "'
WHEN config_name = 'login_url' THEN '" . get_var('config_login_url') . "'
WHEN config_name = 'online_timeout' THEN '" . get_var('config_online_timeout') . "'
WHEN config_name = 'heart_beat' THEN '" . get_var('config_heart_beat') . "'
WHEN config_name = 'buddy_list_heart_beat' THEN '" . get_var('config_buddy_list_heart_beat') . "'
WHEN config_name = 'idle_time' THEN '" . get_var('config_idle_time') . "'
WHEN config_name = 'push_on' THEN '" . get_var('push_on') . "'
WHEN config_name = 'push_ssl' THEN '" . get_var('push_ssl') . "'
WHEN config_name = 'push_publish' THEN '" . trim(get_var('push_publish')) . "'
WHEN config_name = 'push_subscribe' THEN '" . trim(get_var('push_subscribe')) . "'
WHEN config_name = 'spam_protection' THEN '" . trim(get_var('spam_protection')) . "'
END WHERE config_name IN ('channel_name', 'base_url', 'login_url', 'online_timeout', 'disable_smilies', 'heart_beat', 'buddy_list_heart_beat', 'idle_time', 'push_on', 'push_ssl', 'push_publish', 'push_subscribe', 'spam_protection')
");
if ($result && $heart_beat_test)
{
$base_url = $new_base_url;
$login_url = get_var('config_login_url');
$online_timeout = get_var('config_online_timeout');
$heart_beat = get_var('config_heart_beat');
$buddy_list_heart_beat = get_var('config_buddy_list_heart_beat');
$idle_time = get_var('config_idle_time');
$push_on = get_var('push_on');
$push_ssl = get_var('push_ssl');
$push_publish = trim(get_var('push_publish'));
$push_subscribe = trim(get_var('push_subscribe'));
$spam_protection = get_var('spam_protection');
update_config_file();
$msg = "Your settings were successfully saved.";
}
else if (!$heart_beat_test)
{
$error = "The buddy list heart beat cannot be equal to or lower than the online timeout. Please adjust the settings.";
}
else
{
$error = "There was a database error. Please try again.";
}
}
// Auto Upgrade Step 1 Processor
if (var_check('auto-step-1'))
{
$do = "step1";
}
// Auto Upgrade Step 2 Processor
if (var_check('auto-step-2'))
{
$do = "step2";
}
// Auto Upgrade Step 3 Processor
if (var_check('auto-step-3'))
{
$do = "step3";
}
// Auto Upgrade Step 4 Processor
if (var_check('auto-step-4'))
{
$do = "step4";
}
// Auto Upgrade Step 5 Processor
if (var_check('auto-step-5'))
{
$do = "step5";
}
// Maintenance Submit Processor
if (var_check('maintenance_submit'))
{
$_SESSION['clean_private_messages'] = get_var('clean_private_messages');
$_SESSION['clean_inactive_guests'] = get_var('clean_inactive_guests');
$_SESSION['clean_inactive_users'] = get_var('clean_inactive_users');
$_SESSION['clean_cr_messages'] = get_var('clean_cr_messages');
$_SESSION['clean_cr_rooms'] = get_var('clean_cr_rooms');
$_SESSION['clean_cr_users'] = get_var('clean_cr_users');
$_SESSION['clean_notifications'] = get_var('clean_notifications');
$_SESSION['counter'] = 0;
header("Location: system.php?do=maintenance2&token=" . $token);
}
// Maintenance Processing
if ($do == 'maintenance2')
{
if (empty($_SESSION['clean_private_messages']) AND empty($_SESSION['clean_inactive_guests']) AND empty($_SESSION['clean_inactive_users']) AND empty($_SESSION['clean_cr_messages']) AND empty($_SESSION['clean_cr_rooms']) AND empty($_SESSION['clean_cr_users']) AND empty($_SESSION['clean_notifications']))
{
header("Location: system.php?do=maintenance");
}
if (!empty($_SESSION['clean_private_messages']))
{
$cleaning_message = "Cleaning Private Messages";
$result = $db->execute("
SELECT COUNT(*)
FROM arrowchat
WHERE (sent + (3600 * 24 * 28) < " . time() . ")
OR (sent + (3600 * 24 * 14) < " . time() . " AND user_read = 1)
");
if ($row = $db->fetch_array($result))
{
$no_rows = $row['COUNT(*)'];
if (empty($_SESSION['counter']))
$_SESSION['original_count'] = $no_rows;
if ($no_rows < 5000)
{
if ($_SESSION['counter'] != 0)
{
$db->execute("
DELETE FROM arrowchat
WHERE (sent + (3600 * 24 * 28) < " . time() . ")
OR (sent + (3600 * 24 * 14) < " . time() . " AND user_read = 1)
");
$_SESSION['counter'] = -1;
$_SESSION['clean_private_messages'] = 0;
}
$cleaning_percent = 100;
$_SESSION['counter']++;
}
else
{
if ($_SESSION['counter'] != 0)
{
$db->execute("
DELETE FROM arrowchat
WHERE (sent + (3600 * 24 * 28) < " . time() . ")
OR (sent + (3600 * 24 * 14) < " . time() . " AND user_read = 1)
LIMIT 5000
");
$cleaning_percent = round((5000 * $_SESSION['counter']) / $_SESSION['original_count'] * 100);
}
$_SESSION['counter']++;
}
}
}
if (!empty($_SESSION['clean_inactive_guests']) AND empty($_SESSION['clean_private_messages']))
{
$cleaning_message = "Cleaning Inactive Guests";
$result = $db->execute("
SELECT COUNT(*)
FROM arrowchat_status
WHERE session_time + (3600 * 24 * 14) < " . time() . "
AND userid LIKE 'g%'
AND is_admin = 0
AND is_mod = 0
");
if ($row = $db->fetch_array($result))
{
$no_rows = $row['COUNT(*)'];
if (empty($_SESSION['counter']))
$_SESSION['original_count'] = $no_rows;
if ($no_rows < 5000)
{
if ($_SESSION['counter'] != 0)
{
$db->execute("
DELETE FROM arrowchat_status
WHERE session_time + (3600 * 24 * 14) < " . time() . "
AND userid LIKE 'g%'
AND is_admin = 0
AND is_mod = 0
");
$_SESSION['counter'] = -1;
$_SESSION['clean_inactive_guests'] = 0;
}
$cleaning_percent = 100;
$_SESSION['counter']++;
}
else
{
if ($_SESSION['counter'] != 0)
{
$db->execute("
DELETE FROM arrowchat_status
WHERE session_time + (3600 * 24 * 14) < " . time() . "
AND userid LIKE 'g%'
AND is_admin = 0
AND is_mod = 0
LIMIT 5000
");
$cleaning_percent = round((5000 * $_SESSION['counter']) / $_SESSION['original_count'] * 100);
}
$_SESSION['counter']++;
}
}
}
if (!empty($_SESSION['clean_inactive_users']) AND empty($_SESSION['clean_inactive_guests']) AND empty($_SESSION['clean_private_messages']))
{
$cleaning_message = "Cleaning Inactive Users";
$result = $db->execute("
SELECT COUNT(*)
FROM arrowchat_status
WHERE session_time + (3600 * 24 * 28) < " . time() . "
AND is_admin = 0
AND is_mod = 0
");
if ($row = $db->fetch_array($result))
{
$no_rows = $row['COUNT(*)'];
if (empty($_SESSION['counter']))
$_SESSION['original_count'] = $no_rows;
if ($no_rows < 5000)
{
if ($_SESSION['counter'] != 0)
{
$db->execute("
DELETE FROM arrowchat_status
WHERE session_time + (3600 * 24 * 28) < " . time() . "
AND is_admin = 0
AND is_mod = 0
");
$_SESSION['counter'] = -1;
$_SESSION['clean_inactive_users'] = 0;
}
$cleaning_percent = 100;
$_SESSION['counter']++;
}
else
{
if ($_SESSION['counter'] != 0)
{
$db->execute("
DELETE FROM arrowchat_status
WHERE session_time + (3600 * 24 * 28) < " . time() . "
AND is_admin = 0
AND is_mod = 0
LIMIT 5000
");
$cleaning_percent = round((5000 * $_SESSION['counter']) / $_SESSION['original_count'] * 100);
}
$_SESSION['counter']++;
}
}
}
if (!empty($_SESSION['clean_cr_messages']) AND empty($_SESSION['clean_inactive_users']) AND empty($_SESSION['clean_inactive_guests']) AND empty($_SESSION['clean_private_messages']))
{
$cleaning_message = "Cleaning Chat Room Messages";
$result = $db->execute("
SELECT COUNT(*)
FROM arrowchat_chatroom_messages
WHERE sent + (3600 * 24 * 7) < " . time() . "
");
if ($row = $db->fetch_array($result))
{
$no_rows = $row['COUNT(*)'];
if (empty($_SESSION['counter']))
$_SESSION['original_count'] = $no_rows;
if ($no_rows < 5000)
{
if ($_SESSION['counter'] != 0)
{
$db->execute("
DELETE FROM arrowchat_chatroom_messages
WHERE sent + (3600 * 24 * 7) < " . time() . "
");
$_SESSION['counter'] = -1;
$_SESSION['clean_cr_messages'] = 0;
}
$cleaning_percent = 100;
$_SESSION['counter']++;
}
else
{
if ($_SESSION['counter'] != 0)
{
$db->execute("
DELETE FROM arrowchat_chatroom_messages
WHERE sent + (3600 * 24 * 7) < " . time() . "
LIMIT 5000
");
$cleaning_percent = round((5000 * $_SESSION['counter']) / $_SESSION['original_count'] * 100);
}
$_SESSION['counter']++;
}
}
}
if (!empty($_SESSION['clean_cr_rooms']) AND empty($_SESSION['clean_cr_messages']) AND empty($_SESSION['clean_inactive_users']) AND empty($_SESSION['clean_inactive_guests']) AND empty($_SESSION['clean_private_messages']))
{
$cleaning_message = "Cleaning User Created Chat Rooms";
$result = $db->execute("
SELECT COUNT(*)
FROM arrowchat_chatroom_rooms
WHERE session_time + (3600 * 24 * 7) < " . time() . "
AND length != '0'
");
if ($row = $db->fetch_array($result))
{
$no_rows = $row['COUNT(*)'];
if (empty($_SESSION['counter']))
$_SESSION['original_count'] = $no_rows;
if ($no_rows < 5000)
{
if ($_SESSION['counter'] != 0)
{
$db->execute("
DELETE FROM arrowchat_chatroom_rooms
WHERE session_time + (3600 * 24 * 7) < " . time() . "
AND length != '0'
");
$_SESSION['counter'] = -1;
$_SESSION['clean_cr_rooms'] = 0;
}
$cleaning_percent = 100;
$_SESSION['counter']++;
}
else
{
if ($_SESSION['counter'] != 0)
{
$db->execute("
DELETE FROM arrowchat_chatroom_rooms
WHERE session_time + (3600 * 24 * 7) < " . time() . "
AND length != '0'
LIMIT 5000
");
$cleaning_percent = round((5000 * $_SESSION['counter']) / $_SESSION['original_count'] * 100);
}
$_SESSION['counter']++;
}
}
}
if (!empty($_SESSION['clean_cr_users']) AND empty($_SESSION['clean_cr_rooms']) AND empty($_SESSION['clean_cr_messages']) AND empty($_SESSION['clean_inactive_users']) AND empty($_SESSION['clean_inactive_guests']) AND empty($_SESSION['clean_private_messages']))
{
$cleaning_message = "Cleaning Chat Room Users";
$result = $db->execute("
SELECT COUNT(*)
FROM arrowchat_chatroom_users
WHERE session_time + (3600 * 24 * 14) < " . time() . "
AND is_admin = 0
AND is_mod = 0
");
if ($row = $db->fetch_array($result))
{
$no_rows = $row['COUNT(*)'];
if (empty($_SESSION['counter']))
$_SESSION['original_count'] = $no_rows;
if ($no_rows < 5000)
{
if ($_SESSION['counter'] != 0)
{
$db->execute("
DELETE FROM arrowchat_chatroom_users
WHERE session_time + (3600 * 24 * 14) < " . time() . "
AND is_admin = 0
AND is_mod = 0
");
$_SESSION['counter'] = -1;
$_SESSION['clean_cr_users'] = 0;
}
$cleaning_percent = 100;
$_SESSION['counter']++;
}
else
{
if ($_SESSION['counter'] != 0)
{
$db->execute("
DELETE FROM arrowchat_chatroom_users
WHERE session_time + (3600 * 24 * 14) < " . time() . "
AND is_admin = 0
AND is_mod = 0
LIMIT 5000
");
$cleaning_percent = round((5000 * $_SESSION['counter']) / $_SESSION['original_count'] * 100);
}
$_SESSION['counter']++;
}
}
}
if (!empty($_SESSION['clean_notifications']) AND empty($_SESSION['clean_cr_users']) AND empty($_SESSION['clean_cr_rooms']) AND empty($_SESSION['clean_cr_messages']) AND empty($_SESSION['clean_inactive_users']) AND empty($_SESSION['clean_inactive_guests']) AND empty($_SESSION['clean_private_messages']))
{
$cleaning_message = "Cleaning Notifications";
$result = $db->execute("
SELECT COUNT(*)
FROM arrowchat_notifications
WHERE alert_time + (3600 * 24 * 28) < " . time() . "
");
if ($row = $db->fetch_array($result))
{
$no_rows = $row['COUNT(*)'];
if (empty($_SESSION['counter']))
$_SESSION['original_count'] = $no_rows;
if ($no_rows < 5000)
{
if ($_SESSION['counter'] != 0)
{
$db->execute("
DELETE FROM arrowchat_notifications
WHERE alert_time + (3600 * 24 * 28) < " . time() . "
");
$_SESSION['counter'] = -1;
$_SESSION['clean_notifications'] = 0;
}
$cleaning_percent = 100;
$_SESSION['counter']++;
}
else
{
if ($_SESSION['counter'] != 0)
{
$db->execute("
DELETE FROM arrowchat_notifications
WHERE alert_time + (3600 * 24 * 28) < " . time() . "
LIMIT 5000
");
$cleaning_percent = round((5000 * $_SESSION['counter']) / $_SESSION['original_count'] * 100);
}
$_SESSION['counter']++;
}
}
}
if ($cleaning_percent > 100)
$cleaning_percent = 100;
}
// Repair Processor
if (var_check('repair_submit'))
{
$push_random = random_string();
$result = $db->execute("
INSERT IGNORE INTO arrowchat_config (
config_name,
config_value,
is_dynamic
)
VALUES ('theme', 'new_facebook_full', 0),
('base_url', '" . $db->escape_string($base_url) . "', 0),
('online_timeout', '120', 0),
('disable_smilies', '0', 0),
('auto_popup_chatbox', '1', 0),
('heart_beat', '3', 0),
('language', 'en', 0),
('idle_time', '3', 0),
('install_time', '" . $db->escape_string($install_time) . "', 0),
('chatrooms_on', '0', 0),
('notifications_on', '0', 0),
('hide_bar_on', '1', 0),
('applications_on', '0', 0),
('popout_chat_on', '1', 0),
('theme_change_on', '0', 0),
('disable_avatars', '0', 0),
('disable_buddy_list', '1', 0),
('search_number', '5', 0),
('chat_maintenance', '0', 0),
('announcement', '', 0),
('admin_chat_all', '1', 0),
('admin_view_maintenance', '1', 0),
('user_chatrooms', '0', 0),
('user_chatrooms_flood', '10', 0),
('user_chatrooms_length', '30', 0),
('guests_can_view', '0', 0),
('video_chat', '0', 0),
('us_time', '1', 0),
('file_transfer_on', '0', 0),
('width_applications', '16', 0),
('width_buddy_list', '189', 0),
('width_chatrooms', '16', 0),
('buddy_list_heart_beat', '60', 0),
('bar_fixed', '0', 0),
('bar_fixed_alignment', 'center', 0),
('bar_fixed_width', '900', 0),
('bar_padding', '15', 0),
('chatroom_auto_join', '0', 0),
('chat_display_type', '1', 0),
('chatroom_history_length', '60', 0),
('disable_arrowchat', '0', 0),
('enable_mobile', '1', 0),
('guests_can_chat', '0', 0),
('guests_chat_with', '1', 0),
('push_on', '0', 0),
('push_publish', '', 0),
('push_subscribe', '', 0),
('push_secret', '', 0),
('show_full_username', '0', 0),
('users_chat_with', '3', 0),
('hide_admins_buddylist', '0', 0),
('show_bar_links_right', '0', 0),
('enable_chat_animations', '1', 0),
('hide_applications_menu', '0', 0),
('guest_name_change', '1', '0'),
('guest_name_duplicates', '0', '0'),
('guest_name_bad_words', 'fuck,cunt,nigger,shit,admin,administrator,mod,moderator,support', '0'),
('admin_background_color', '', '0'),
('admin_text_color', '', '0'),
('facebook_app_id', '', '0'),
('blocked_words', 'fuck,[shit],nigger,[cunt],[ass],asshole', '0'),
('desktop_notifications', '0', '0'),
('login_url', '', '0'),
('max_upload_size', '5', '0'),
('enable_moderation', '0', '0'),
('chatroom_transfer_on', '0', '0'),
('chatroom_message_length', '150', '0'),
('push_ssl', '0', '0'),
('window_top_padding', '70', '0'),
('video_chat_selection', '1', '0'),
('video_chat_width', '900', '0'),
('video_chat_height', '600', '0'),
('tokbox_api', '', '0'),
('tokbox_secret', '', '0'),
('chatroom_default_names', '0', '0'),
('group_disable_arrowchat', '', '0'),
('group_disable_video', '', '0'),
('group_disable_apps', '', '0'),
('group_disable_rooms', '', '0'),
('group_disable_uploads', '', '0'),
('group_disable_sending_private', '', '0'),
('group_disable_sending_rooms', '', '0'),
('group_enable_mode', '0', '0'),
('online_list_on', '1', '0'),
('giphy_off', '0', '0'),
('giphy_chatroom_off', '0', '0'),
('push_encrypt', '".$push_random."', '0'),
('mobile_chat_icon', 'fas fa-comment', '0'),
('mobile_background_color', '0076ff', '0'),
('mobile_icon_color', 'ffffff', '0'),
('mobile_chat_action', '1', '0'),
('spam_protection', '0', '0'),
('group_is_admin', '', '0'),
('group_is_mod', '', '0'),
('enable_rtl', '0', '0'),
('agora_app_id', '', '0')
");
$result2 = $db->execute("
DROP TABLE IF EXISTS `arrowchat_status`
");
$result3 = $db->execute('
CREATE TABLE IF NOT EXISTS `arrowchat_status` (
`userid` varchar(50) NOT NULL,
`guest_name` varchar(50) default NULL,
`message` text,
`status` varchar(10) default NULL,
`theme` int(3) unsigned default NULL,
`popout` int(11) unsigned default NULL,
`typing` text,
`hide_bar` tinyint(1) unsigned default NULL,
`play_sound` tinyint(1) unsigned default \'1\',
`window_open` tinyint(1) unsigned default NULL,
`only_names` tinyint(1) unsigned default NULL,
`chatroom_window` varchar(6) NOT NULL default \'-1\',
`chatroom_stay` varchar(6) NOT NULL default \'0\',
`chatroom_unfocus` text,
`chatroom_show_names` tinyint(1) unsigned default NULL,
`chatroom_block_chats` tinyint(1) unsigned default NULL,
`chatroom_sound` tinyint(1) unsigned default NULL,
`announcement` tinyint(1) unsigned NOT NULL default \'1\',
`unfocus_chat` text,
`focus_chat` varchar(50) default NULL,
`last_message` text,
`clear_chats` text,
`apps_bookmarks` text,
`apps_other` text,
`apps_open` int(10) unsigned default NULL,
`apps_load` text,
`block_chats` text,
`session_time` int(20) unsigned NOT NULL,
`is_admin` tinyint(1) unsigned NOT NULL default \'0\',
`is_mod` tinyint(1) unsigned NOT NULL default \'0\',
`hash_id` varchar(20) NOT NULL,
`ip_address` varchar(40) default \'\',
PRIMARY KEY (`userid`),
KEY `hash_id` (`hash_id`),
KEY `session_time` (`session_time`)
)
');
if ($result && $result2 && $result3)
{
update_config_file();
$msg = "The repair has been successfully completed";
}
}
$row = $db->fetch_row("
SELECT email
FROM arrowchat_admin
");
$admin_email = $row->email;
// Admin Settings Submit Processor
if (var_check('admin_submit'))
{
$admin_new_password = get_var('admin_new_password');
$admin_confirm_password = get_var('admin_confirm_password');
$admin_email = get_var('admin_email');
$admin_old_password = get_var('admin_old_password');
if (!empty($admin_new_password) OR !empty($admin_confirm_password))
{
if ($admin_new_password != $admin_confirm_password)
{
$error = "Your new password and confirmation passwords do not match.";
}
if (!empty($admin_new_password) AND empty($admin_confirm_password))
{
$error = "You must supply a confirmation password.";
}
if (empty($admin_new_password) AND !empty($admin_confirm_password))
{
$error = "You must supply a new password.";
}
}
if (empty($admin_email))
{
$error = "The admin email cannot be blank.";
}
if (empty($admin_old_password))
{
$error = "You must input your old password.";
}
if (empty($error))
{
$result = $db->execute("
SELECT *
FROM arrowchat_admin
");
if ($result AND $db->count_select() > 0)
{
$row = $db->fetch_array($result);
$old_password = $row['password'];
$old_email = $row['email'];
$admin_old_password = md5($admin_old_password);
$admin_new_password = md5($admin_new_password);
if ($admin_old_password != $old_password)
{
$error = "Your old password is not correct.";
}
if (empty($error))
{
if (empty($_POST['admin_new_password']))
{
$admin_new_password = $old_password;
}
if (empty($_POST['admin_email']))
{
$admin_email = $old_email;
}
$result = $db->execute("
UPDATE arrowchat_admin
SET password = '" . $db->escape_string($admin_new_password) . "',
email = '" . $db->escape_string($admin_email) . "'
");
if ($result)
{
$msg = "Your settings were successfully saved.";
}
else
{
$error = "There is a database error. Please try again.";
}
}
}
else
{
$error = "There is a database error. Please try again.";
}
}
}
// Language Active Processor
if ($do == "language")
{
if (!empty($_REQUEST['activate']))
{
$result = $db->execute("
UPDATE arrowchat_config
SET config_value = '" . get_var('activate') . "'
WHERE config_name = 'language'
");
if ($result)
{
$msg = "Your language has been successfully activated.";
update_config_file();
}
else
{
$error = "There was a database error.";
}
}
}
}
else
{
die("No valid token");
}
}
require(dirname(__FILE__) . DIRECTORY_SEPARATOR . "layout/pages_header.php");
require(dirname(__FILE__) . DIRECTORY_SEPARATOR . "layout/pages_system.php");
require(dirname(__FILE__) . DIRECTORY_SEPARATOR . "layout/pages_footer.php");
flush_headers();
// ####################### START AUTOMATIC UPGRADE PROCESSES ########################
if ($do == "step3")
{
// Authenticate that the user has an active subscription
echo '';
flush_headers();
// fopen causes a "no data received" error on some servers, so change to fpen for now
//$fp = @fpen("http://www.arrowchat.com/validate.php?u=" . get_var('validate_username') . "&p=" . get_var('validate_password'), "r");
if ($fp)
{
$validation = @fread($fp, 99);
$validation_pieces = explode(":", $validation);
if ($validation_pieces[0] == "1")
{
echo '';
flush_headers();
}
else if ($validation_pieces[0] == "2")
{
echo '';
echo '';
flush_headers();
exit;
}
else
{
echo '';
echo '';
flush_headers();
exit;
}
}
else
{
echo '';
echo '';
flush_headers();
exit;
}
fclose ($fp);
$key = $validation_pieces[1];
if (empty($key))
{
echo '';
echo '';
flush_headers();
exit;
}
sleep(2);
// Start downloading ArrowChat if it doesn't already exist in the cache folder
if (file_exists(dirname(dirname(__FILE__)) . DIRECTORY_SEPARATOR . AC_FOLDER_CACHE . DIRECTORY_SEPARATOR . "arrowchat_v" . get_var('url') . ".zip"))
{
echo '';
flush_headers();
}
else
{
set_time_limit(300);
$remoteFile = "http://www.arrowchat.com/update-download.php?file=ac&id=" . $key;
$dir = dirname(dirname(__FILE__)) . DIRECTORY_SEPARATOR . AC_FOLDER_CACHE . DIRECTORY_SEPARATOR;
$file = @fopen($remoteFile, "r");
echo '';
flush_headers();
if (!$file)
{
echo '';
flush_headers();
exit;
}
$line = '';
while (!feof ($file))
{
$line .= fgets ($file, 4096);
}
file_put_contents(dirname(dirname(__FILE__)) . DIRECTORY_SEPARATOR . AC_FOLDER_CACHE . DIRECTORY_SEPARATOR . "arrowchat_v" . get_var('url') . ".zip", $line);
fclose($file);
}
sleep(2);
// Start downloading the mySQL file if it doesn't already exist in the cache folder
if (file_exists(dirname(dirname(__FILE__)) . DIRECTORY_SEPARATOR . AC_FOLDER_CACHE . DIRECTORY_SEPARATOR . "mysql_v" . get_var('url') . ".zip"))
{
echo '';
flush_headers();
}
else
{
set_time_limit(300);
$remoteFile = "http://www.arrowchat.com/update-download-mysql.php?file=ac&id=" . $key;
$dir = dirname(dirname(__FILE__)) . DIRECTORY_SEPARATOR . AC_FOLDER_CACHE . DIRECTORY_SEPARATOR;
$file = @fopen($remoteFile, "r");
echo '';
flush_headers();
if (!$file)
{
echo '';
flush_headers();
exit;
}
$line = '';
while (!feof ($file))
{
$line .= fgets ($file, 4096);
}
file_put_contents(dirname(dirname(__FILE__)) . DIRECTORY_SEPARATOR . AC_FOLDER_CACHE . DIRECTORY_SEPARATOR . "mysql_v" . get_var('url') . ".zip", $line);
fclose($file);
}
sleep(2);
// Put ArrowChat into maintenance mode for installation
echo '';
flush_headers();
$result = $db->execute("
UPDATE arrowchat_config
SET config_value = CASE
WHEN config_name = 'chat_maintenance' THEN '1'
END WHERE config_name IN ('chat_maintenance')
");
update_config_file();
sleep(1);
// Unzip the ArrowChat zip file and overwrite all files
echo '';
flush_headers();
$zip = new ZipArchive;
if ($zip->open(dirname(dirname(__FILE__)) . DIRECTORY_SEPARATOR . AC_FOLDER_CACHE . DIRECTORY_SEPARATOR . "arrowchat_v" . get_var('url') . ".zip") === TRUE)
{
$zip->extractTo(dirname(dirname(__FILE__)) . DIRECTORY_SEPARATOR);
$zip->close();
}
else
{
echo '';
flush_headers();
exit;
}
sleep(2);
// Unzip the mySQL zip file
echo '';
flush_headers();
$zip = new ZipArchive;
if ($zip->open(dirname(dirname(__FILE__)) . DIRECTORY_SEPARATOR . AC_FOLDER_CACHE . DIRECTORY_SEPARATOR . "mysql_v" . get_var('url') . ".zip") === TRUE)
{
$zip->extractTo(dirname(dirname(__FILE__)) . DIRECTORY_SEPARATOR);
$zip->close();
}
else
{
echo '';
flush_headers();
exit;
}
sleep(2);
// Start running all the SQL statements that were in the update
echo '';
flush_headers();
$dbms_schema = dirname(dirname(__FILE__)) . 'mysql_schema.sql';
$remove_remarks = "remove_remarks";
$delimiter = ";";
$sql_query = @file_get_contents($dbms_schema);
$remove_remarks($sql_query);
$sql_query = split_sql_file($sql_query, $delimiter);
foreach ($sql_query as $sql)
{
$db->execute($sql);
}
sleep(2);
// Bring ArrowChat out of maintenance mode
echo '';
flush_headers();
$result = $db->execute("
UPDATE arrowchat_config
SET config_value = CASE
WHEN config_name = 'chat_maintenance' THEN '0'
END WHERE config_name IN ('chat_maintenance')
");
update_config_file();
sleep(1);
// Delete the ArrowChat zip file
echo '';
flush_headers();
unlink(dirname(dirname(__FILE__)) . DIRECTORY_SEPARATOR . AC_FOLDER_CACHE . DIRECTORY_SEPARATOR . "arrowchat_v" . get_var('url') . ".zip");
sleep(1);
// Delete the SQL zip file
echo '';
flush_headers();
unlink(dirname(dirname(__FILE__)) . DIRECTORY_SEPARATOR . AC_FOLDER_CACHE . DIRECTORY_SEPARATOR . "mysql_v" . get_var('url') . ".zip");
unlink(dirname(dirname(__FILE__)) . DIRECTORY_SEPARATOR . "mysql_schema.sql");
sleep(1);
echo '';
flush_headers();
}
?>