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",
        intval($message_id),
        intval($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",
        dbesc($conv_guid),
        intval($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']),
            dbesc($conv_guid),
            intval($channel_id)
        );
    }

}