execute(" INSERT INTO arrowchat_status ( userid, popout ) VALUES ( '" . $db->escape_string($userid) . "', '" . $db->escape_string($time) . "' ) ON DUPLICATE KEY UPDATE popout = '" . $db->escape_string($time) . "' "); echo "1"; close_session(); exit(0); } // ######################### START POST SOUND ############################ if (!empty($_POST['sound'])) { if ($sound == "-1") { $sound = 0; } $db->execute(" INSERT INTO arrowchat_status ( userid, play_sound ) VALUES ( '" . $db->escape_string($userid) . "', '" . $db->escape_string($sound) . "' ) ON DUPLICATE KEY UPDATE play_sound = '" . $db->escape_string($sound) . "' "); echo "1"; close_session(); exit(0); } // ###################### START POST HIDE WELCOME ######################### if (!empty($_POST['welcome'])) { $db->execute(" INSERT INTO arrowchat_status ( userid, welcome_viewed ) VALUES ( '" . $db->escape_string($userid) . "', '1' ) ON DUPLICATE KEY UPDATE welcome_viewed = '1' "); echo "1"; close_session(); exit(0); } // ##################### START POST KEEP WINDOW OPEN ##################### if (!empty($_POST['window'])) { if ($window == "-1") { $window = 0; $db->execute(" INSERT INTO arrowchat_status ( userid, window_open ) VALUES ( '" . $db->escape_string($userid) . "', '" . $db->escape_string($window) . "' ) ON DUPLICATE KEY UPDATE window_open = '" . $db->escape_string($window) . "' "); } else { $db->execute(" INSERT INTO arrowchat_status ( userid, window_open ) VALUES ( '" . $db->escape_string($userid) . "', '" . $db->escape_string($window) . "' ) ON DUPLICATE KEY UPDATE window_open = '" . $db->escape_string($window) . "' "); } echo "1"; close_session(); exit(0); } // ##################### START POST SHOW ONLY NAMES ###################### if (!empty($_POST['name'])) { if ($name == "-1") { $name = 0; } $db->execute(" INSERT INTO arrowchat_status ( userid, only_names ) VALUES ( '" . $db->escape_string($userid) . "', '" . $db->escape_string($name) . "' ) ON DUPLICATE KEY UPDATE only_names = '" . $db->escape_string($name) . "' "); echo "1"; close_session(); exit(0); } // ######################## START POST FOCUS CHAT ######################## if (!empty($_POST['focus_chat'])) { if ($tab_alert == "1") { $db->execute(" UPDATE arrowchat SET arrowchat.user_read = '1', arrowchat.read = '1' WHERE arrowchat.from = '" . $db->escape_string($focus_chat) . "' AND arrowchat.to = '" . $db->escape_string($userid) . "' AND arrowchat.user_read = '0' "); } $result = $db->execute(" SELECT focus_chat, unfocus_chat FROM arrowchat_status WHERE userid = '" . $db->escape_string($userid) . "' "); if ($result AND $db->count_select() > 0) { $row = $db->fetch_array($result); if (empty($row['unfocus_chat'])) $unfocus_unserialize = array(); else $unfocus_unserialize = unserialize($row['unfocus_chat']); if (empty($row['focus_chat'])) $focus_unserialize = array(); else $focus_unserialize = unserialize($row['focus_chat']); if (!in_array($focus_chat, $focus_unserialize)) { if (count($focus_unserialize) >= $allowed_open_windows) { if (($key2 = array_search($focus_unserialize[0], $unfocus_unserialize)) !== false) { unset($unfocus_unserialize[$key2]); $unfocus_unserialize[] = $focus_unserialize[0]; } else { $unfocus_unserialize[] = $focus_unserialize[0]; } array_shift($focus_unserialize); $focus_unserialize[2] = $focus_chat; } else { $focus_unserialize[] = $focus_chat; } } else { if (($key2 = array_search($focus_chat, $focus_unserialize)) !== false) { unset($focus_unserialize[$key2]); $focus_unserialize[] = $focus_chat; } } $unfocus_insert = serialize($unfocus_unserialize); $focus_insert = serialize($focus_unserialize); } $db->execute(" INSERT INTO arrowchat_status ( userid, focus_chat, unfocus_chat ) VALUES ( '" . $db->escape_string($userid) . "', '" . $db->escape_string($focus_insert) . "', '" . $db->escape_string($unfocus_insert) . "' ) ON DUPLICATE KEY UPDATE focus_chat = '" . $db->escape_string($focus_insert) . "', unfocus_chat = '" . $db->escape_string($unfocus_insert) . "' "); echo "1"; close_session(); exit(0); } // ###################### START POST UNFOCUS CHAT ######################## if (!empty($_POST['unfocus_chat'])) { if ($tab_alert == "1") { $db->execute(" UPDATE arrowchat SET arrowchat.user_read = '1' , arrowchat.read = '1' WHERE arrowchat.from = '" . $db->escape_string($unfocus_chat) . "' AND arrowchat.to = '" . $db->escape_string($userid) . "' AND arrowchat.user_read = '0' "); } $result = $db->execute(" SELECT unfocus_chat, focus_chat FROM arrowchat_status WHERE userid = '" . $db->escape_string($userid) . "' "); if ($result AND $db->count_select() > 0) { $row = $db->fetch_array($result); if (empty($row['unfocus_chat'])) $unfocus_unserialize = array(); else $unfocus_unserialize = unserialize($row['unfocus_chat']); if (empty($row['focus_chat'])) $focus_unserialize = array(); else $focus_unserialize = unserialize($row['focus_chat']); if (($key2 = array_search($unfocus_chat, $unfocus_unserialize)) !== false) { unset($unfocus_unserialize[$key2]); $unfocus_unserialize[] = $unfocus_chat; } else { $unfocus_unserialize[] = $unfocus_chat; } if (($key2 = array_search($unfocus_chat, $focus_unserialize)) !== false) { unset($focus_unserialize[$key2]); } $unfocus_insert = serialize($unfocus_unserialize); $focus_insert = serialize($focus_unserialize); } $db->execute(" INSERT INTO arrowchat_status ( userid, unfocus_chat, focus_chat ) VALUES ( '" . $db->escape_string($userid) . "', '" . $db->escape_string($unfocus_insert) . "', '" . $db->escape_string($focus_insert) . "' ) ON DUPLICATE KEY UPDATE focus_chat = '" . $db->escape_string($focus_insert) . "', unfocus_chat = '" . $db->escape_string($unfocus_insert) . "' "); echo "1"; close_session(); exit(0); } // ######################## START POST CLOSE CHAT ######################## if (!empty($_POST['close_chat'])) { if ($tab_alert == "1") { $db->execute(" UPDATE arrowchat SET arrowchat.user_read = '1', arrowchat.read = '1' WHERE arrowchat.from = '" . $db->escape_string($close_chat) . "' AND arrowchat.to = '" . $db->escape_string($userid) . "' AND arrowchat.user_read = '0' "); } $result = $db->execute(" SELECT unfocus_chat, focus_chat FROM arrowchat_status WHERE userid = '" . $db->escape_string($userid) . "' "); if ($result AND $db->count_select() > 0) { $row = $db->fetch_array($result); if (empty($row['unfocus_chat'])) $unfocus_unserialize = array(); else $unfocus_unserialize = unserialize($row['unfocus_chat']); if (empty($row['focus_chat'])) $focus_unserialize = array(); else $focus_unserialize = unserialize($row['focus_chat']); if (($key2 = array_search($close_chat, $unfocus_unserialize)) !== false) { unset($unfocus_unserialize[$key2]); } if (($key2 = array_search($close_chat, $focus_unserialize)) !== false) { unset($focus_unserialize[$key2]); } $unfocus_insert = serialize($unfocus_unserialize); $focus_insert = serialize($focus_unserialize); } $db->execute(" INSERT INTO arrowchat_status ( userid, unfocus_chat, focus_chat ) VALUES ( '" . $db->escape_string($userid) . "', '" . $db->escape_string($unfocus_insert) . "', '" . $db->escape_string($focus_insert) . "' ) ON DUPLICATE KEY UPDATE focus_chat = '" . $db->escape_string($focus_insert) . "', unfocus_chat = '" . $db->escape_string($unfocus_insert) . "' "); echo "1"; close_session(); exit(0); } // ######################## START POST CLEAR CHAT ######################## if (!empty($_POST['clear_chat'])) { $result = $db->execute(" SELECT clear_chats FROM arrowchat_status WHERE userid = '" . $db->escape_string($userid) . "' "); if ($result AND $db->count_select() > 0) { $row = $db->fetch_array($result); $clear_chats = $row['clear_chats']; if (empty($clear_chats)) { $new_clear_chats = array($clear_user => time()); } else { $new_clear_chats = unserialize($clear_chats); $new_clear_chats[$clear_user] = time(); } } $new_clear_chats = serialize($new_clear_chats); $db->execute(" INSERT INTO arrowchat_status ( userid, clear_chats ) VALUES ( '" . $db->escape_string($userid) . "', '" . $db->escape_string($new_clear_chats) . "' ) ON DUPLICATE KEY UPDATE clear_chats = '" . $db->escape_string($new_clear_chats) . "' "); echo "1"; close_session(); exit(0); } // ######################## START POST REPORT ######################## if (!empty($_POST['report_from'])) { if ($enable_moderation == 1) { if (empty($report_chatroom)) $report_chatroom = 0; $db->execute(" INSERT INTO arrowchat_reports ( report_from, report_about, report_chatroom, report_time, working_by, working_time, completed_by, completed_time ) VALUES ( '" . $db->escape_string($report_from) . "', '" . $db->escape_string($report_about) . "', '" . $db->escape_string($report_chatroom) . "', '" . $db->escape_string(time()) . "', '', '0', '', '0' ) "); } echo "1"; close_session(); exit(0); } // ################### START POST ANNOUNCEMENT READ ###################### if (!empty($_POST['announce'])) { $db->execute(" UPDATE arrowchat_status SET announcement = '1' WHERE userid = '" . $db->escape_string($userid) . "' "); echo "1"; close_session(); exit(0); } // ################## START POST BLOCK PRIVATE CHATS ##################### if (var_check('chatroom_block_chats')) { if ($chatroom_block_chats == "-1") { $chatroom_block_chats = 0; } $db->execute(" UPDATE arrowchat_status SET chatroom_block_chats = '" . $db->escape_string($chatroom_block_chats) . "' WHERE userid = '" . $db->escape_string($userid) . "' "); $db->execute(" UPDATE arrowchat_chatroom_users SET block_chats = '" . $db->escape_string($chatroom_block_chats) . "' WHERE user_id = '" . $db->escape_string($userid) . "' "); echo "1"; close_session(); exit(0); } // ################## START POST CHAT ROOM SOUND ##################### if (var_check('chatroom_sound')) { if ($chatroom_sound == "-1") { $chatroom_sound = 0; } $db->execute(" UPDATE arrowchat_status SET chatroom_sound = '" . $db->escape_string($chatroom_sound) . "' WHERE userid = '" . $db->escape_string($userid) . "' "); echo "1"; close_session(); exit(0); } // ################## START POST CHAT ROOM NAMES ##################### if (var_check('chatroom_show_names')) { if ($chatroom_show_names == "-1") { $chatroom_show_names = 0; } $db->execute(" UPDATE arrowchat_status SET chatroom_show_names = '" . $db->escape_string($chatroom_show_names) . "' WHERE userid = '" . $db->escape_string($userid) . "' "); echo "1"; close_session(); exit(0); } // ##################### START POST MAKE MODERATOR ####################### if (var_check('chatroom_mod')) { $result = $db->execute(" SELECT is_mod, is_admin FROM arrowchat_chatroom_users WHERE user_id = '" . $db->escape_string($userid) . "' AND chatroom_id = '" . $db->escape_string($chatroom_id) . "' AND (is_admin = '1' OR is_mod = '1') "); if ($result AND $db->count_select() > 0) { if (check_if_guest($chatroom_mod)) { $mod_username = create_guest_username($chatroom_mod, '', true); if (empty($mod_username)) { $mod_username = create_guest_username($chatroom_mod, '', false); } } else { $sql = get_user_details($chatroom_mod); $result = $db->execute($sql); if ($result AND $db->count_select() > 0) { $row = $db->fetch_array($result); $mod_username = $row['username']; } } $mod_message = $mod_username . $language[106] . $db->escape_string(strip_tags(get_username($userid))) . "."; $db->execute(" INSERT INTO arrowchat_chatroom_messages ( chatroom_id, user_id, username, message, global_message, sent ) VALUES ( '" . $db->escape_string($chatroom_id) . "', '" . $db->escape_string($userid) . "', 'Global', '" . $mod_message . "', '1', '" . time() . "' ) "); if ($push_on == 1) { push_publish($push_encrypt . '_chatroom' . $chatroom_id, array('chatroommessage' => array("id" => $db->last_insert_id(), "name" => 'Global', "message" => $mod_message, "userid" => $userid, "sent" => time(), "global" => '1', "chatroomid" => $chatroom_id))); } $db->execute(" UPDATE arrowchat_chatroom_users SET is_mod = '1' WHERE user_id = '" . $db->escape_string($chatroom_mod) . "' AND chatroom_id = '" . $db->escape_string($chatroom_id) . "' "); } echo "1"; close_session(); exit(0); } // ################### START POST REMOVE MODERATOR ####################### if (var_check('chatroom_remove_mod')) { $result = $db->execute(" SELECT is_mod, is_admin FROM arrowchat_chatroom_users WHERE user_id = '" . $db->escape_string($userid) . "' AND chatroom_id = '" . $db->escape_string($chatroom_id) . "' AND (is_admin = '1' OR is_mod = '1') "); if ($result AND $db->count_select() > 0) { if (check_if_guest($chatroom_remove_mod)) { $mod_username = create_guest_username($chatroom_remove_mod, '', true); if (empty($mod_username)) { $mod_username = create_guest_username($chatroom_remove_mod, '', false); } } else { $sql = get_user_details($chatroom_remove_mod); $result = $db->execute($sql); if ($result AND $db->count_select() > 0) { $row = $db->fetch_array($result); $mod_username = $row['username']; } } $mod_message = $mod_username . $language[156] . $db->escape_string(strip_tags(get_username($userid))) . "."; $db->execute(" INSERT INTO arrowchat_chatroom_messages ( chatroom_id, user_id, username, message, global_message, sent ) VALUES ( '" . $db->escape_string($chatroom_id) . "', '" . $db->escape_string($userid) . "', 'Global', '" . $mod_message . "', '1', '" . time() . "' ) "); if ($push_on == 1) { push_publish($push_encrypt . '_chatroom' . $chatroom_id, array('chatroommessage' => array("id" => $db->last_insert_id(), "name" => 'Global', "message" => $mod_message, "userid" => $userid, "sent" => time(), "global" => '1', "chatroomid" => $chatroom_id))); } $db->execute(" UPDATE arrowchat_chatroom_users SET is_mod = '0' WHERE user_id = '" . $db->escape_string($chatroom_remove_mod) . "' AND chatroom_id = '" . $db->escape_string($chatroom_id) . "' "); } echo "1"; close_session(); exit(0); } // ####################### START POST BAN USER ########################## if (var_check('chatroom_ban')) { // Fail-safe if name isn't retrieved $chatroom_name = "a chat room"; $result = $db->execute(" SELECT name FROM arrowchat_chatroom_rooms WHERE id = '" . $db->escape_string($chatroom_id) . "' "); if ($result AND $db->count_select() > 0) { $row = $db->fetch_array($result); $chatroom_name = $row['name']; } $result = $db->execute(" SELECT is_mod, is_admin FROM arrowchat_chatroom_users WHERE user_id = '" . $db->escape_string($userid) . "' AND chatroom_id = '" . $db->escape_string($chatroom_id) . "' AND (is_admin = '1' OR is_mod = '1') "); if ($result AND $db->count_select() > 0) { if (check_if_guest($chatroom_ban)) { $ban_username = create_guest_username($chatroom_ban, '', true); if (empty($ban_username)) { $ban_username = create_guest_username($chatroom_ban, '', false); } } else { $sql = get_user_details($chatroom_ban); $result = $db->execute($sql); if ($result AND $db->count_select() > 0) { $row = $db->fetch_array($result); $ban_username = $row['username']; } } $ban_message = $ban_username . $language[107] . $db->escape_string(strip_tags(get_username($userid))) . "."; $db->execute(" INSERT INTO arrowchat_chatroom_messages ( chatroom_id, user_id, username, message, global_message, sent ) VALUES ( '" . $db->escape_string($chatroom_id) . "', '" . $db->escape_string($userid) . "', 'Global', '" . $ban_message . "', '1', '" . time() . "' ) "); if (empty($chatroom_ban_length)) $ban_message2 = $language[55] . $chatroom_name; else $ban_message2 = $language[56] . $chatroom_name . $language[219] . $chatroom_ban_length . $language[220]; if ($push_on == 1) { push_publish($push_encrypt . '_chatroom' . $chatroom_id, array('chatroommessage' => array("id" => $db->last_insert_id(), "name" => 'Global', "message" => $ban_message, "userid" => $userid, "sent" => time(), "global" => '1', "chatroomid" => $chatroom_id))); push_publish($push_encrypt . '_u' . $chatroom_ban, array('chatroomban' => array("error2" => $ban_message2, 'id' => $chatroom_id))); } $db->execute(" DELETE FROM arrowchat_chatroom_banlist WHERE user_id = '" . $db->escape_string($chatroom_ban) . "' AND chatroom_id = '" . $db->escape_string($chatroom_id) . "' "); // Get User IP address $result = $db->execute(" SELECT ip_address FROM arrowchat_status WHERE userid = '" . $db->escape_string($chatroom_ban) . "' "); if ($row = $db->fetch_array($result)) $user_ip = $row['ip_address']; else $user_ip = ''; $db->execute(" INSERT INTO arrowchat_chatroom_banlist ( user_id, chatroom_id, ban_length, ban_time, ip_address ) VALUES ( '" . $db->escape_string($chatroom_ban) . "', '" . $db->escape_string($chatroom_id) . "', '" . $db->escape_string($chatroom_ban_length) . "', '" . time() . "', '" . $db->escape_string($user_ip) . "' ) "); $db->execute(" UPDATE arrowchat_chatroom_users SET session_time = '0' WHERE user_id = '" . $db->escape_string($chatroom_ban) . "' AND chatroom_id = '" . $db->escape_string($chatroom_id) . "' "); } echo "1"; close_session(); exit(0); } // ####################### START POST SILENCE USER ########################## if (var_check('chatroom_silence')) { $result = $db->execute(" SELECT is_mod, is_admin FROM arrowchat_chatroom_users WHERE user_id = '" . $db->escape_string($userid) . "' AND chatroom_id = '" . $db->escape_string($chatroom_id) . "' AND (is_admin = '1' OR is_mod = '1') "); if ($result AND $db->count_select() > 0 AND is_numeric($chatroom_silence_length)) { if (check_if_guest($chatroom_silence)) { $silence_username = create_guest_username($chatroom_silence, '', true); if (empty($silence_username)) { $silence_username = create_guest_username($chatroom_silence, '', false); } } else { $sql = get_user_details($chatroom_silence); $result = $db->execute($sql); if ($result AND $db->count_select() > 0) { $row = $db->fetch_array($result); $silence_username = $row['username']; } } $silence_message = $silence_username . $language[163] . $db->escape_string(strip_tags(get_username($userid))) . "."; $db->execute(" INSERT INTO arrowchat_chatroom_messages ( chatroom_id, user_id, username, message, global_message, sent ) VALUES ( '" . $db->escape_string($chatroom_id) . "', '" . $db->escape_string($userid) . "', 'Global', '" . $silence_message . "', '1', '" . time() . "' ) "); if ($push_on == 1) { push_publish($push_encrypt . '_chatroom' . $chatroom_id, array('chatroommessage' => array("id" => $db->last_insert_id(), "name" => 'Global', "message" => $silence_message, "userid" => $userid, "sent" => time(), "global" => '1', "chatroomid" => $chatroom_id))); } // Max silence time is 300 seconds (5 minutes) if ($chatroom_silence_length > 300) $chatroom_silence_length = 300; $db->execute(" UPDATE arrowchat_chatroom_users SET silence_length = '" . $db->escape_string($chatroom_silence_length) . "', silence_time = '" . time() . "' WHERE user_id = '" . $db->escape_string($chatroom_silence) . "' AND chatroom_id = '" . $db->escape_string($chatroom_id) . "' "); } echo "1"; close_session(); exit(0); } // ####################### START DELETE CHAT MSG ########################## if (var_check('delete_msg')) { $result = $db->execute(" SELECT is_mod, is_admin FROM arrowchat_chatroom_users WHERE user_id = '" . $db->escape_string($userid) . "' AND chatroom_id = '" . $db->escape_string($chatroom_id) . "' AND (is_admin = '1' OR is_mod = '1') "); if ($result AND $db->count_select() > 0) { $db->execute(" UPDATE arrowchat_chatroom_messages SET message = '" . $db->escape_string($language[159] . $delete_name) . "' WHERE id = '" . $db->escape_string($delete_msg) . "' AND chatroom_id = '" . $db->escape_string($chatroom_id) . "' "); $db->execute(" INSERT INTO arrowchat_chatroom_messages ( chatroom_id, user_id, username, message, global_message, sent, action ) VALUES ( '" . $db->escape_string($chatroom_id) . "', '" . $db->escape_string($userid) . "', '" . $db->escape_string($delete_name) . "', '" . $db->escape_string($delete_msg) . "', '1', '" . time() . "', '1' ) "); if ($push_on == 1) { push_publish($push_encrypt . '_chatroom' . $chatroom_id, array('chatroommessage' => array("id" => $delete_msg, "name" => 'Delete', "message" => $language[159] . $delete_name, "userid" => $userid, "sent" => time(), "global" => '1', "mod" => 0, "admin" => 0, "chatroomid" => $chatroom_id))); } } echo "1"; close_session(); exit(0); } // ####################### START POST WELCOME MSG ########################## if (var_check('chatroom_welcome_msg')) { $result = $db->execute(" SELECT is_mod, is_admin FROM arrowchat_chatroom_users WHERE user_id = '" . $db->escape_string($userid) . "' AND chatroom_id = '" . $db->escape_string($chatroom_id) . "' AND (is_admin = '1' OR is_mod = '1') "); if ($result AND $db->count_select() > 0) { $db->execute(" UPDATE arrowchat_chatroom_rooms SET welcome_message = '" . $db->escape_string($chatroom_welcome_msg) . "' WHERE id = '" . $db->escape_string($chatroom_id) . "' "); } echo "1"; close_session(); exit(0); } // ####################### START POST DESCRIPTION ########################## if (var_check('chatroom_description')) { $result = $db->execute(" SELECT is_mod, is_admin FROM arrowchat_chatroom_users WHERE user_id = '" . $db->escape_string($userid) . "' AND chatroom_id = '" . $db->escape_string($chatroom_id) . "' AND (is_admin = '1' OR is_mod = '1') "); if ($result AND $db->count_select() > 0) { $db->execute(" UPDATE arrowchat_chatroom_rooms SET description = '" . $db->escape_string($chatroom_description) . "' WHERE id = '" . $db->escape_string($chatroom_id) . "' "); } echo "1"; close_session(); exit(0); } // ####################### START POST CHAT ROOM FLOOD ########################## if (var_check('flood_message')) { $result = $db->execute(" SELECT is_mod, is_admin FROM arrowchat_chatroom_users WHERE user_id = '" . $db->escape_string($userid) . "' AND chatroom_id = '" . $db->escape_string($chatroom_id) . "' AND (is_admin = '1' OR is_mod = '1') "); if ($result AND $db->count_select() > 0 AND is_numeric($flood_message) AND is_numeric($flood_seconds)) { $db->execute(" UPDATE arrowchat_chatroom_rooms SET limit_message_num = '" . $db->escape_string($flood_message) . "', limit_seconds_num = '" . $db->escape_string($flood_seconds) . "' WHERE id = '" . $db->escape_string($chatroom_id) . "' "); } echo "1"; close_session(); exit(0); } // ################# START BLOCK CHAT ################## if (var_check('block_chat')) { if ($userid == $block_chat) { // Cannot block yourself echo "-1"; close_session(); exit (0); } $result = $db->execute(" SELECT is_admin FROM arrowchat_status WHERE userid = '" . $db->escape_string($block_chat) . "' AND (is_admin = '1' OR is_mod = '1') "); if ($result AND $db->count_select() > 0) { // Cannot block admin/mod echo "-1"; close_session(); exit (0); } $result = $db->execute(" SELECT block_chats FROM arrowchat_status WHERE userid = '" . $db->escape_string($userid) . "' "); if ($result AND $db->count_select() > 0) { $row = $db->fetch_array($result); if (!empty($row['block_chats'])) { $block_chat_array = unserialize($row['block_chats']); } else { $block_chat_array = array(); } } else { $block_chat_array = array(); } if (!in_array($block_chat, $block_chat_array)) { $block_chat_array[] = $block_chat; } $block_chat_serialized = serialize($block_chat_array); $db->execute(" UPDATE arrowchat_status SET block_chats = '" . $db->escape_string($block_chat_serialized) . "' WHERE userid = '" . $db->escape_string($userid) . "' "); echo "1"; close_session(); exit (0); } // ################# START UNBLOCK CHAT ################## if (var_check('unblock_chat')) { $result = $db->execute(" SELECT block_chats FROM arrowchat_status WHERE userid = '" . $db->escape_string($userid) . "' "); if ($result AND $db->count_select() > 0) { $row = $db->fetch_array($result); if (!empty($row['block_chats'])) { $block_chat_array = unserialize($row['block_chats']); } else { $block_chat_array = array(); } } else { $block_chat_array = array(); } foreach ($block_chat_array as $key => $value) { if ($unblock_chat == $value) { unset($block_chat_array[$key]); } } $block_chat_serialized = serialize($block_chat_array); $db->execute(" UPDATE arrowchat_status SET block_chats = '" . $db->escape_string($block_chat_serialized) . "' WHERE userid = '" . $db->escape_string($userid) . "' "); echo "1"; close_session(); exit (0); } // ################# GUEST USERNAME ################## if (var_check('chat_name')) { if ($guest_name_change != 1) { echo "1"; close_session(); exit (0); } function in_array_like($referencia, $array) { foreach($array as $ref) { $ref = str_replace(" ", "", $ref); if (stristr($referencia, $ref)) { return $ref; } } return false; } if (empty($chat_name)) { echo $language[120]; close_session(); exit (0); } if (!empty($guest_name)) { echo $language[123]; close_session(); exit (0); } if (strlen($chat_name) > 25) { echo $language[125]; close_session(); exit (0); } if (preg_match('#\W#', $chat_name)) { echo $language[121]; close_session(); exit (0); } $bad_words = explode(",", $guest_name_bad_words); if ($bad_name = in_array_like($chat_name, $bad_words)) { echo $language[122] . $bad_name; close_session(); exit (0); } if ($guest_name_duplicates != 1) { $result = $db->execute(" SELECT userid FROM arrowchat_status WHERE LOWER(guest_name) = '" . $db->escape_string(strtolower($chat_name)) . "' "); if ($result AND $db->count_select() > 0) { echo $language[124]; close_session(); exit (0); } } $db->execute(" UPDATE arrowchat_status SET guest_name = '" . $db->escape_string($chat_name) . "' WHERE userid = '" . $db->escape_string($userid) . "' "); echo "1"; close_session(); exit (0); } // ######################## START POST CLOSE REPORT ######################## if (var_check('report_id')) { if ($is_mod == 1 || $is_admin == 1) { $result = $db->execute(" SELECT report_about FROM arrowchat_reports WHERE id = '" . $db->escape_string($report_id) . "' "); if ($row = $db->fetch_array($result)) { $db->execute(" UPDATE arrowchat_reports SET completed_by = '" . $db->escape_string($userid) . "', completed_time = '" . $db->escape_string(time()) . "' WHERE report_about = '" . $db->escape_string($row['report_about']) . "' AND completed_time = 0 "); } } echo "1"; close_session(); exit(0); } // ######################## START POST REPORT BAN ######################## if (var_check('report_ban')) { if ($is_mod == 1 || $is_admin == 1) { $result = $db->execute(" SELECT report_about FROM arrowchat_reports WHERE id = '" . $db->escape_string($report_ban) . "' "); if ($row = $db->fetch_array($result)) { $db->execute(" UPDATE arrowchat_reports SET completed_by = '" . $db->escape_string($userid) . "', completed_time = '" . $db->escape_string(time()) . "' WHERE report_about = '" . $db->escape_string($row['report_about']) . "' AND completed_time = 0 "); $result = $db->execute(" SELECT ban_userid FROM arrowchat_banlist WHERE ban_userid = '" . $db->escape_string($row['report_about']) . "' "); if ($result AND $db->count_select() > 0) { // Ban already exists } else { $db->execute(" INSERT INTO arrowchat_banlist ( ban_userid, banned_by, banned_time ) VALUES ( '" . $db->escape_string($row['report_about']) . "', '" . $db->escape_string($userid) . "', '" . $db->escape_string(time()) . "' ) "); require_once (dirname(dirname(dirname(dirname(__FILE__)))) . DIRECTORY_SEPARATOR . AC_FOLDER_ADMIN . DIRECTORY_SEPARATOR . 'includes' . DIRECTORY_SEPARATOR . 'functions' . DIRECTORY_SEPARATOR . 'functions_update.php'); update_config_file(); } } } echo "1"; close_session(); exit(0); } // ######################## START POST WARN USER ######################## if (var_check('report_warn')) { if ($is_mod == 1 || $is_admin == 1) { $result = $db->execute(" SELECT report_about FROM arrowchat_reports WHERE id = '" . $db->escape_string($report_warn) . "' "); if ($row = $db->fetch_array($result)) { $result = $db->execute(" SELECT id FROM arrowchat_warnings WHERE user_id = '" . $db->escape_string($row['report_about']) . "' AND warning_time > (" . time() . " - 86400) "); if ($result AND $db->count_select() > 0 AND $report_warn_confirm != 1) { // User has been warned in the past 24 hours, let the reporter handler know that before processing echo "2"; close_session(); exit(0); } else { $db->execute(" UPDATE arrowchat_reports SET completed_by = '" . $db->escape_string($userid) . "', completed_time = '" . $db->escape_string(time()) . "' WHERE report_about = '" . $db->escape_string($row['report_about']) . "' AND completed_time = 0 "); $db->execute(" INSERT INTO arrowchat_warnings ( user_id, warn_reason, warned_by, warning_time, user_read ) VALUES ( '" . $db->escape_string($row['report_about']) . "', '" . $db->escape_string($report_warn_reason) . "', '" . $db->escape_string($userid) . "', '" . $db->escape_string(time()) . "', '0' ) "); if ($push_on == 1) { push_publish($push_encrypt . '_u' . $row['report_about'], array('warning' => array("data" => $report_warn_reason, "read" => "0"))); } } } } echo "1"; close_session(); exit(0); } // ################### START POST WARNING READ ###################### if (!empty($_POST['warning_read'])) { $db->execute(" UPDATE arrowchat_warnings SET user_read = '1' WHERE user_id = '" . $db->escape_string($userid) . "' "); echo "1"; close_session(); exit(0); } ?>