diff options
Diffstat (limited to 'upgrades')
| -rw-r--r-- | upgrades/2009082901.php | 29 | ||||
| -rw-r--r-- | upgrades/2010073101.php | 22 |
2 files changed, 51 insertions, 0 deletions
diff --git a/upgrades/2009082901.php b/upgrades/2009082901.php new file mode 100644 index 000000000..dfbdf79f4 --- /dev/null +++ b/upgrades/2009082901.php @@ -0,0 +1,29 @@ +<?php + +/******************************************** + * + * Upgrade from Tidypics 1.5 to 1.6 + * + *********************************************/ + +global $CONFIG; + +// add image class +$id = get_subtype_id("object", "image"); +if ($id != 0) { + $table = $CONFIG->dbprefix . 'entity_subtypes'; + $result = update_data("UPDATE {$table} set class='TidypicsImage' where id={$id}"); + if (!$result) { + register_error('unable to update tidypics image class'); + } +} + +// add album class +$id = get_subtype_id("object", "album"); +if ($id != 0) { + $table = $CONFIG->dbprefix . 'entity_subtypes'; + $result = update_data("UPDATE {$table} set class='TidypicsAlbum' where id={$id}"); + if (!$result) { + register_error('unable to update tidypics album class'); + } +} diff --git a/upgrades/2010073101.php b/upgrades/2010073101.php new file mode 100644 index 000000000..20fd33144 --- /dev/null +++ b/upgrades/2010073101.php @@ -0,0 +1,22 @@ +<?php +/** + * Populate image lists for current photo albums + */ + +$album_subtype_id = get_subtype_id('object', 'album'); + +global $DB_QUERY_CACHE, $DB_PROFILE, $ENTITY_CACHE, $CONFIG; +$album_guids = mysql_query("SELECT guid FROM {$CONFIG->dbprefix}entities WHERE subtype = $album_subtype_id"); +while ($guid_obj = mysql_fetch_object($album_guids)) { + $DB_QUERY_CACHE = $DB_PROFILE = $ENTITY_CACHE = array(); + + $album = get_entity($guid_obj->guid); + $images = get_entities("object", "image", $album->guid, '', 9999); + $image_list = array(); + foreach ($images as $image) { + $image_list[] = $image->guid; + } + + $album->prependImageList($image_list); +} + |