1
#!/usr/bin/env php
2
<?php
3
/*
4
 * StatusNet - the distributed open-source microblogging tool
5
 * Copyright (C) 2008, 2009, StatusNet, Inc.
6
 *
7
 * This program is free software: you can redistribute it and/or modify
8
 * it under the terms of the GNU Affero General Public License as published by
9
 * the Free Software Foundation, either version 3 of the License, or
10
 * (at your option) any later version.
11
 *
12
 * This program is distributed in the hope that it will be useful,
13
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
14
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
15
 * GNU Affero General Public License for more details.
16
 *
17
 * You should have received a copy of the GNU Affero General Public License
18
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
19
 */
20
21
define('INSTALLDIR', realpath(dirname(__FILE__) . '/..'));
22
23
require_once INSTALLDIR.'/scripts/commandline.inc';
24
25
common_log(LOG_INFO, 'Fixing up conversations.');
26
27
$notice = new Notice();
28
$notice->query('select id, reply_to from notice where conversation is null');
29
30
while ($notice->fetch()) {
31
32
    $cid = null;
33
    
34
    $orig = clone($notice);
35
    
36
    if (empty($notice->reply_to)) {
37
        $notice->conversation = $notice->id;
38
    } else {
39
        $reply = Notice::staticGet('id', $notice->reply_to);
40
41
        if (empty($reply)) {
42
            common_log(LOG_WARNING, "Replied-to notice $notice->reply_to not found.");
43
            $notice->conversation = $notice->id;
44
        } else if (empty($reply->conversation)) {
45
            common_log(LOG_WARNING, "Replied-to notice $reply->id has no conversation ID.");
46
            $notice->conversation = $notice->id;
47
        } else {
48
            $notice->conversation = $reply->conversation;
49
        }
50
	
51
	unset($reply);
52
	$reply = null;
53
    }
54
55
    print "$notice->conversation";
56
57
    $result = $notice->update($orig);
58
59
    if (!$result) {
60
        common_log_db_error($notice, 'UPDATE', __FILE__);
61
        continue;
62
    }
63
64
    $orig = null;
65
    unset($orig);
66
    
67
    print ".\n";
68
}