diff options
| author | Friendika <info@friendika.com> | 2011-02-06 19:15:20 -0800 |
|---|---|---|
| committer | Friendika <info@friendika.com> | 2011-02-06 19:15:20 -0800 |
| commit | b96d6c015b8090ee2ec56f320821fe962f821c6f (patch) | |
| tree | 4d642cf482bf0d18737fb57cb108dca21f565e97 /update.php | |
| parent | 147d7f3bbf6c785f2c1eb7cdcfaa0a47e0ee43d3 (diff) | |
| download | volse-hubzilla-b96d6c015b8090ee2ec56f320821fe962f821c6f.tar.gz volse-hubzilla-b96d6c015b8090ee2ec56f320821fe962f821c6f.tar.bz2 volse-hubzilla-b96d6c015b8090ee2ec56f320821fe962f821c6f.zip | |
fix contact photo updates - a result of baseurl being wrong for cmdline processes
Diffstat (limited to 'update.php')
| -rw-r--r-- | update.php | 16 |
1 files changed, 15 insertions, 1 deletions
diff --git a/update.php b/update.php index 2ca008cda..e51e8ac33 100644 --- a/update.php +++ b/update.php @@ -348,4 +348,18 @@ function update_1035() { q("ALTER TABLE `contact` ADD `success_update` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER `last-update` "); -}
\ No newline at end of file +} + +function update_1036() { + + $r = dbq("SELECT * FROM `contact` WHERE `network` = 'dfrn' && `photo` LIKE '%include/photo%' "); + if(count($r)) { + foreach($r as $rr) { + q("UPDATE `contact` SET `photo` = '%s', `thumb` = '%s', `micro` = '%s' WHERE `id` = %d LIMIT 1", + dbesc(str_replace('include/photo','photo',$rr['photo'])), + dbesc(str_replace('include/photo','photo',$rr['thumb'])), + dbesc(str_replace('include/photo','photo',$rr['micro'])), + intval($rr['id'])); + } + } +} |