blob: 5bd5f78b425fd3322ca57a307f822e6b0d973610 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
|
<?php
/**
* Convert river entries for tags to be tagger-tagee-annotation from
* image-tagee
*/
$album_subtype_id = get_subtype_id('object', 'album');
global $DB_QUERY_CACHE, $DB_PROFILE, $ENTITY_CACHE, $CONFIG;
$query = "SELECT * FROM {$CONFIG->dbprefix}river WHERE view = 'river/object/image/tag'";
$river_items = mysql_query($query);
while ($item = mysql_fetch_object($river_items)) {
$DB_QUERY_CACHE = $DB_PROFILE = array();
// find the annotation for this river item
$annotations = get_annotations($item->subject_guid, '', '', 'phototag', '', 0, 999);
foreach ($annotations as $annotation) {
$tag = unserialize($annotation->value);
if ($tag->type === 'user') {
if ($tag->value == $item->object_guid) {
$update = "UPDATE {$CONFIG->dbprefix}river SET subject_guid = $annotation->owner_guid, annotation_id = $annotation->id where id = $item->id";
mysql_query($update);
}
}
}
}
|
