diff options
author | Zach Copley <zach@status.net> | 2010-02-25 18:13:34 -0800 |
---|---|---|
committer | Zach Copley <zach@status.net> | 2010-02-25 18:13:34 -0800 |
commit | c49fbb63c56cc851153d0fecec81b4ca92b41bc6 (patch) | |
tree | ef84518fbdc879fceb6213aebb99228aec853f2a /scripts/init_conversation.php | |
parent | 792f0942f761fe8b29363689eb7cbe4317f64b96 (diff) | |
parent | c8ddcbe0d32fb072456587fc554f6b78db672fa7 (diff) |
Merge branch 'testing' of gitorious.org:statusnet/mainline into testing
* 'testing' of gitorious.org:statusnet/mainline:
init_conversation.php script to copy old notice conversations into the conversation table
cache results of webfinger lookups
Parse an hcard for hints, if available
use new hcard method for webfinger
add hkit for hCard parsing
use new dedicated hcard method for Webfinger profile
Add an hcard action
Diffstat (limited to 'scripts/init_conversation.php')
-rwxr-xr-x | scripts/init_conversation.php | 49 |
1 files changed, 49 insertions, 0 deletions
diff --git a/scripts/init_conversation.php b/scripts/init_conversation.php new file mode 100755 index 000000000..675e7cabd --- /dev/null +++ b/scripts/init_conversation.php @@ -0,0 +1,49 @@ +#!/usr/bin/env php +<?php +/* + * StatusNet - the distributed open-source microblogging tool + * Copyright (C) 2008, 2009, StatusNet, Inc. + * + * This program is free software: you can redistribute it and/or modify + * it under the terms of the GNU Affero General Public License as published by + * the Free Software Foundation, either version 3 of the License, or + * (at your option) any later version. + * + * This program is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU Affero General Public License for more details. + * + * You should have received a copy of the GNU Affero General Public License + * along with this program. If not, see <http://www.gnu.org/licenses/>. + */ + +define('INSTALLDIR', realpath(dirname(__FILE__) . '/..')); + +require_once INSTALLDIR.'/scripts/commandline.inc'; + +common_log(LOG_INFO, 'Initializing conversation table...'); + +$notice = new Notice(); +$notice->query('select distinct conversation from notice'); + +while ($notice->fetch()) { + $id = $notice->conversation; + + if ($id) { + $uri = common_local_url('conversation', array('id' => $id)); + + // @fixme db_dataobject won't save our value for an autoincrement + // so we're bypassing the insert wrappers + $conv = new Conversation(); + $sql = "insert into conversation (id,uri,created) values(%d,'%s','%s')"; + $sql = sprintf($sql, + $id, + $conv->escape($uri), + $conv->escape(common_sql_now())); + echo "$id "; + $conv->query($sql); + print "... "; + } +} +print "done.\n"; |