diff options
Diffstat (limited to 'update.php')
| -rw-r--r-- | update.php | 30 |
1 files changed, 29 insertions, 1 deletions
diff --git a/update.php b/update.php index 68367343d..dfa54af59 100644 --- a/update.php +++ b/update.php @@ -101,4 +101,32 @@ function update_1012() { function update_1013() { q("ALTER TABLE `item` ADD `target-type` CHAR( 255 ) NOT NULL AFTER `object` , ADD `target` TEXT NOT NULL AFTER `target-type`"); -}
\ No newline at end of file +} + +function update_1014() { + require_once('include/Photo.php'); + q("ALTER TABLE `contact` ADD `micro` TEXT NOT NULL AFTER `thumb` "); + $r = q("SELECT * FROM `photo` WHERE `scale` = 4"); + if(count($r)) { + foreach($r as $rr) { + $ph = new Photo($rr['data']); + if($ph->is_valid()) { + $ph->scaleImage(48); + $ph->store($rr['uid'],$rr['contact-id'],$rr['resource-id'],$rr['filename'],$rr['album'],6,(($rr['profile']) ? 1 : 0)); + } + } + } + $r = q("SELECT * FROM `contact` WHERE 1"); + if(count($r)) { + foreach($r as $rr) { + if(stristr($rr['thumb'],'avatar')) + q("UPDATE `contact` SET `micro` = '%s' WHERE `id` = %d LIMIT 1", + dbesc(str_replace('avatar','micro',$rr['thumb'])), + intval($rr['id'])); + else + q("UPDATE `contact` SET `micro` = '%s' WHERE `id` = %d LIMIT 1", + dbesc(str_replace('5.jpg','6.jpg',$rr['thumb'])), + intval($rr['id'])); + } + } +}
\ No newline at end of file |