chamilo / chamilo-lms

     * @param string $type

     * @return bool

     */

    public static function update_message_status($user_id, $message_id,$type)

    {

        $type = intval($type);

        if ($message_id != strval(intval($message_id)) || $user_id != strval(intval($user_id))) {

            return false;

        }

        $table_message = Database::get_main_table(TABLE_MESSAGE);

        $sql = "UPDATE $table_message SET

                    msg_status = '$type'

                WHERE

                    user_receiver_id=".intval($user_id)." AND

                    id='".intval($message_id)."'";

        Database::query($sql);

    }

    /**

     * get messages by user id and message id

     * @param  int		$message_id

     * @return array

     */

    public static function get_message_by_user($user_id, $message_id)

    {

        if ($message_id != strval(intval($message_id)) || $user_id != strval(intval($user_id)))

            return false;

        $table_message = Database::get_main_table(TABLE_MESSAGE);

        $query = "SELECT * FROM $table_message

                  WHERE user_receiver_id=".intval($user_id)." AND id='".intval($message_id)."'";

        $result = Database::query($query);

        return $row = Database::fetch_array($result);

    }

    /**

     * get messages by group id