include/msglib.php


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28

<?php

/* Common private message processing functions */

function msg_drop($message_id, $channel_id, $conv_guid) {

    // Delete message
    $r = q("DELETE FROM mail WHERE id = %d AND channel_id = %d",
        $message_id,
        $channel_id
    );

    // Get new first message...
    $r = q("SELECT mid, parent_mid FROM mail WHERE conv_guid = '%s' AND channel_id = %d ORDER BY id ASC LIMIT 1",
        $conv_guid,
        $channel_id
    );
    // ...and if wasn't first before...
    if ($r[0]['mid'] != $r[0]['parent_mid']) {
        // ...refer whole thread to it
        q("UPDATE mail SET parent_mid = '%s', mail_isreply = abs(mail_isreply - 1) WHERE conv_guid = '%s' AND channel_id = %d",
            dbesc($r[0]['mid']),
            $conv_guid,
            $channel_id
        );
    }

}