#!/usr/bin/env php . */ define('INSTALLDIR', realpath(dirname(__FILE__) . '/..')); require_once INSTALLDIR.'/scripts/commandline.inc'; common_log(LOG_INFO, 'Fixing up conversations.'); $notice = new Notice(); $notice->whereAdd('conversation is null'); $notice->orderBy('id'); $cnt = $notice->find(); print "Found $cnt notices.\n"; while ($notice->fetch()) { print "$notice->id =>"; $orig = clone($notice); if (empty($notice->reply_to)) { $notice->conversation = $notice->id; } else { $reply = Notice::staticGet('id', $notice->reply_to); if (empty($reply)) { common_log(LOG_WARNING, "Replied-to notice $notice->reply_to not found."); $notice->conversation = $notice->id; } else if (empty($reply->conversation)) { common_log(LOG_WARNING, "Replied-to notice $reply->id has no conversation ID."); $notice->conversation = $notice->id; } else { $notice->conversation = $reply->conversation; } } print "$notice->conversation"; $result = $notice->update($orig); if (!$result) { common_log_db_error($notice, 'UPDATE', __FILE__); continue; } print ".\n"; }