function transfer_message_archive_chat() { $db = DBManagerFactory::getInstance(); $date_record = date('Y-m-d H:i:s', strtotime('- 1 days')); $sql_find_mess = "SELECT id AS mess_id, cm.date_time, cm.message, cm.session_id, cm.sender_id\n FROM chat_messages AS cm\n WHERE deleted = 0\n AND date_time < '{$date_record}'\n "; $query_find_mess = $db->query($sql_find_mess); while ($row_find_mess = $db->fetchByAssoc($query_find_mess)) { $chat_archives = new Chat_Archives(); $chat_archives->date_time = $row_find_mess['date_time']; $chat_archives->message = $row_find_mess['message']; $chat_archives->session_id = $row_find_mess['session_id']; $chat_archives->sender_id = $row_find_mess['sender_id']; $chat_archives->save(); $mess_id = $row_find_mess['mess_id']; $sql_delete_mess = "DELETE FROM chat_messages\n WHERE id = '{$mess_id}'\n "; $query_delete_mess = $db->query($sql_delete_mess); } }
global $current_user; $db = DBManagerFactory::getInstance(); $friend_id = $_REQUEST['user_clear']; $my_user_id = $current_user->id; $sql_check = "SELECT cs.id AS session_id\n FROM chat_session AS cs\n WHERE deleted = 0\n AND (user_1_id = '{$friend_id}' OR user_1_id = '{$my_user_id}')\n AND (user_2_id = '{$my_user_id}' OR user_2_id = '{$friend_id}')\n "; $query_check = $db->query($sql_check); $session_id = array(); while ($row_check = $db->fetchByAssoc($query_check)) { $session_id[] = $row_check['session_id']; } foreach ($session_id as $session) { $sql_session = "SELECT id AS mess_id, cmess.message, cmess.date_time, cmess.sender_id\n FROM chat_messages AS cmess\n WHERE deleted = 0\n AND session_id = '{$session}'\n "; $query_session = $db->query($sql_session); while ($row_session = $db->fetchByAssoc($query_session)) { $chat_archives = new Chat_Archives(); $chat_archives->date_time = $row_session['date_time']; $chat_archives->message = $row_session['message']; $chat_archives->session_id = $session; $chat_archives->sender_id = $row_session['sender_id']; $chat_archives->save(); $mess_id = $row_session['mess_id']; $sql_delete_mess = "DELETE FROM chat_messages\n WHERE id = '{$mess_id}'\n "; $query_delete_mess = $db->query($sql_delete_mess); } } ////$date_record = date('Y-m-d H:i:s', strtotime('- 1 days' )); // //$sql_find_mess = "SELECT id AS mess_id, cm.date_time, cm.message, cm.session_id, cm.sender_id // FROM chat_messages AS cm // WHERE deleted = 0