function getChatboxData($id) { global $messages; global $userid; global $chromeReorderFix; global $prependLimit; if (empty($_REQUEST['prepend'])) { if (USE_COMET == 1 && !empty($id)) { if (!empty($_SESSION['cometchat']['cometmessagesafter'])) { $limit = 10; $prelimit = ' limit ' . intval($limit); if (!empty($_REQUEST['callbackfn']) && $_REQUEST['callbackfn'] == 'mobileapp') { $prelimit = ' limit 10'; } if (!empty($_SESSION['cometchat']['cometchat_user_' . $id])) { $messages = array_merge($messages, $_SESSION['cometchat']['cometchat_user_' . $id]); } $moremessages = array(); $messagesafter = $_SESSION['cometchat']['cometmessagesafter']; if (!empty($_SESSION['cometchat']['cometchat_user_' . $id . '_clear']) && $_SESSION['cometchat']['cometchat_user_' . $id . '_clear']['timestamp'] > $_SESSION['cometchat']['cometmessagesafter']) { $messagesafter = $_SESSION['cometchat']['cometchat_user_' . $id . '_clear']['timestamp']; } $sql = "select * from cometchat where ((cometchat.from = " . mysqli_real_escape_string($GLOBALS['dbh'], $userid) . " and cometchat.to = " . mysqli_real_escape_string($GLOBALS['dbh'], $id) . " and direction <>1) or ( cometchat.from = " . mysqli_real_escape_string($GLOBALS['dbh'], $id) . " and cometchat.to = " . mysqli_real_escape_string($GLOBALS['dbh'], $userid) . " and direction <>2 )) and cometchat.direction <> 3 order by cometchat.id desc " . mysqli_real_escape_string($GLOBALS['dbh'], $prelimit) . ";"; $query = mysqli_query($GLOBALS['dbh'], $sql); while ($message = mysqli_fetch_assoc($query)) { if ($message['from'] == $id && $message['sent'] >= intval($messagesafter / 1000)) { $self = 0; if ($message['from'] == $userid) { $message['from'] = $message['to']; $self = 1; } $moremessages[$chromeReorderFix . $message['id']] = array("id" => $message['id'], "from" => $message['from'], "message" => $message['message'], "self" => $self, "old" => 1, 'sent' => $message['sent'], 'direction' => $message['direction']); } } if (!empty($id) && empty($_SESSION['cometchat']['cometchat_user_' . $id])) { getPrevMessages($id); } $messages = array_merge($messages, $moremessages); usort($messages, "cmp"); } else { if (!empty($id) && !empty($_SESSION['cometchat']['cometchat_user_' . $id])) { $messages = array_merge($messages, $_SESSION['cometchat']['cometchat_user_' . $id]); } } } else { if (!empty($id) && !empty($_SESSION['cometchat']['cometchat_user_' . $id])) { $messages = array_replace($messages, $_SESSION['cometchat']['cometchat_user_' . $id]); } if (!empty($id) && empty($_SESSION['cometchat']['cometchat_user_' . $id])) { getPrevMessages($id); $messages = array_reverse($messages); } } } else { $prelimit = intval($prependLimit); $messages = array(); if ($_REQUEST['prepend'] != '-1') { $prepend = bigintval($_REQUEST['prepend']); $sql = "select * from cometchat where ((cometchat.from = " . mysqli_real_escape_string($GLOBALS['dbh'], $userid) . " and cometchat.to = " . mysqli_real_escape_string($GLOBALS['dbh'], $id) . " and direction <>1) or ( cometchat.from = " . mysqli_real_escape_string($GLOBALS['dbh'], $id) . " and cometchat.to = " . mysqli_real_escape_string($GLOBALS['dbh'], $userid) . " and direction <> 2)) and (cometchat.id < {$prepend}) and cometchat.direction <> 3 order by cometchat.id desc limit {$prelimit};"; } else { $sql = "select * from cometchat where ((cometchat.from = " . mysqli_real_escape_string($GLOBALS['dbh'], $userid) . " and cometchat.to = " . mysqli_real_escape_string($GLOBALS['dbh'], $id) . " and direction <>1) or ( cometchat.from = " . mysqli_real_escape_string($GLOBALS['dbh'], $id) . " and cometchat.to = " . mysqli_real_escape_string($GLOBALS['dbh'], $userid) . " and direction <>2 )) and cometchat.direction <> 3 order by cometchat.id desc limit {$prelimit};"; } $query = mysqli_query($GLOBALS['dbh'], $sql); if (defined('DEV_MODE') && DEV_MODE == '1') { echo mysqli_error($GLOBALS['dbh']); } while ($chat = mysqli_fetch_assoc($query)) { $self = 0; $old = 0; if ($chat['from'] == $userid) { $chat['from'] = $chat['to']; $self = 1; $old = 1; } if ($chat['read'] == 1) { $old = 1; } $messages[$chromeReorderFix . $chat['id']] = array('id' => $chat['id'], 'from' => $chat['from'], 'message' => $chat['message'], 'self' => $self, 'old' => $old, 'sent' => $chat['sent'], 'direction' => $chat['direction']); } $messages = array_reverse($messages); } }
function getChatboxData($id) { global $messages; global $userid; global $chromeReorderFix; global $prependLimit; if (empty($_REQUEST['prepend'])) { if (USE_COMET == 1) { if (!empty($_SESSION['cometchat']['cometmessagesafter']) || empty($id)) { $key = ''; if (defined('KEY_A') && defined('KEY_B') && defined('KEY_C')) { $key = KEY_A . KEY_B . KEY_C; } $limit = COMET_HISTORY_LIMIT; if (!empty($_REQUEST['callbackfn']) && $_REQUEST['callbackfn'] == 'mobileapp') { $limit = 10; } $channel = md5($userid . $key); $comet = new Comet(KEY_A, KEY_B); $history = $comet->history(array('channel' => $channel, 'limit' => $limit)); if (!empty($id) && !empty($_SESSION['cometchat']['cometchat_user_' . $id])) { $messages = array_replace($messages, $_SESSION['cometchat']['cometchat_user_' . $id]); } $moremessages = array(); if (!empty($_SESSION['cometchat']['cometmessagesafter'])) { $messagesafter = $_SESSION['cometchat']['cometmessagesafter']; } if (!empty($_SESSION['cometchat']['cometchat_user_' . $id . '_clear']) && $_SESSION['cometchat']['cometchat_user_' . $id . '_clear']['timestamp'] > $_SESSION['cometchat']['cometmessagesafter']) { $messagesafter = $_SESSION['cometchat']['cometchat_user_' . $id . '_clear']['timestamp']; } if (!empty($history)) { foreach ($history as $key => $message) { if ($message['from'] == $id && $message['sent'] >= $messagesafter || empty($id)) { $moremessages[$chromeReorderFix . $message['sent']] = array("id" => $message['sent'], "from" => $message['from'], "message" => $message['message'], "self" => $message['self'], "old" => 1, 'sent' => $message['sent'] / 1000); } } } if (!empty($id) && empty($_SESSION['cometchat']['cometchat_user_' . $id])) { getPrevMessages($id); } if (!empty($_REQUEST['callbackfn']) && $_REQUEST['callbackfn'] == 'mobileapp') { $messages = $moremessages; } else { $messages = array_replace($messages, $moremessages); usort($messages, 'comparetime'); } } } else { if (!empty($id) && !empty($_SESSION['cometchat']['cometchat_user_' . $id])) { $messages = array_replace($messages, $_SESSION['cometchat']['cometchat_user_' . $id]); } if (!empty($id) && empty($_SESSION['cometchat']['cometchat_user_' . $id])) { getPrevMessages($id); $messages = array_reverse($messages); } } } else { if (USE_COMET == 1 && SAVE_LOGS == 0) { return; } $prelimit = intval($prependLimit); $messages = array(); if ($_REQUEST['prepend'] != '-1') { $prepend = bigintval($_REQUEST['prepend']); $sql = "select * from cometchat where ((cometchat.from = " . mysqli_real_escape_string($GLOBALS['dbh'], $userid) . " and cometchat.to = " . $id . " and direction <>1) or ( cometchat.from = " . mysqli_real_escape_string($GLOBALS['dbh'], $id) . " and cometchat.to = " . mysqli_real_escape_string($GLOBALS['dbh'], $userid) . " and direction <> 2)) and (cometchat.id < {$prepend}) order by cometchat.id desc limit {$prelimit};"; } else { $sql = "select * from cometchat where ((cometchat.from = " . mysqli_real_escape_string($GLOBALS['dbh'], $userid) . " and cometchat.to = " . mysqli_real_escape_string($GLOBALS['dbh'], $id) . " and direction <>1) or ( cometchat.from = " . mysqli_real_escape_string($GLOBALS['dbh'], $id) . " and cometchat.to = " . mysqli_real_escape_string($GLOBALS['dbh'], $userid) . " and direction <>2 )) order by cometchat.id desc limit {$prelimit};"; } $query = mysqli_query($GLOBALS['dbh'], $sql); if (defined('DEV_MODE') && DEV_MODE == '1') { echo mysqli_error($GLOBALS['dbh']); } while ($chat = mysqli_fetch_assoc($query)) { $self = 0; $old = 0; if ($chat['from'] == $userid) { $chat['from'] = $chat['to']; $self = 1; $old = 1; } if ($chat['read'] == 1) { $old = 1; } $messages[$chromeReorderFix . $chat['id']] = array('id' => $chat['id'], 'from' => $chat['from'], 'message' => $chat['message'], 'self' => $self, 'old' => $old, 'sent' => $chat['sent']); } $messages = array_reverse($messages); } }