function update_albums()
{
global $wpdb;
$this->increase_time_limit();
// reset album import progress
$this->update_progress(true);
// if this is the first import then reset the order at the end to make the newest on top
$reset_order = count(fb_get_album()) > 0 ? false : true;
// get albums for each user from Facebook
$fb_albums = array();
$fb_photos = array();
foreach ($this->sessions as $key => $session) {
// setup general info
$uid = $session['uid'];
$this->select_session($uid);
// get all albums
$result = $this->facebook->photos_getAlbums($uid, null);
if (!is_array($result)) {
// the current user has no photos so move on
continue;
}
$fb_albums = array_merge($fb_albums, $result);
$this->update_progress();
// get all photos - queries are limited to 5,000 items per query so we need to split them up
// technically this could still error out if the user 100+ photos per album, in that case
// the following number would need to change to 25 or lower
$albums_per_query = 50;
$i = 0;
$album_offset = 0;
while ($album_offset < count($result)) {
$photos = $this->facebook->fql_query("SELECT pid, aid, owner, src, src_big, src_small, link, caption, created FROM photo WHERE aid IN (SELECT aid FROM album WHERE owner = '{$uid}' LIMIT {$albums_per_query} OFFSET {$album_offset})");
$fb_photos = array_merge($fb_photos, (array) $photos);
$album_offset = $albums_per_query * ++$i;
}
$this->update_progress();
// get photos of user
$fb_user_photos = $this->facebook->photos_get($uid, null, null);
if ($fb_user_photos) {
foreach ($fb_user_photos as $k => $v) {
$fb_user_photos[$k]['aid'] = $uid;
}
$fb_photos = array_merge($fb_photos, (array) $fb_user_photos);
$fb_albums[] = array('aid' => $uid, 'cover_pid' => $fb_user_photos[0]['pid'], 'owner' => $uid, 'name' => 'Photos of ' . (count($this->sessions) > 1 ? $session['name'] : 'Me'), 'created' => time(), 'modified' => time(), 'description' => '', 'location' => '', 'link' => "http://www.facebook.com/photo_search.php?id={$uid}", 'size' => count($fb_user_photos));
}
if (!$fb_albums || $this->facebook->error_code) {
$this->msg = 'Fotobook encountered an error while retrieving your photos. [Error #' . $this->facebook->error_code . ']';
return false;
}
}
// put all the albums in an array with the aid as the key
$albums = fb_get_album();
if ($albums) {
foreach ($albums as $album) {
$wp_albums[$album['aid']] = $album;
}
}
// go through all the facebook albums see which ones need to be added
foreach ($fb_albums as $fb_album) {
$wp_album = isset($wp_albums[$fb_album['aid']]) ? $wp_albums[$fb_album['aid']] : false;
$album_data = array('cover_pid' => $fb_album['cover_pid'], 'owner' => $fb_album['owner'], 'name' => $fb_album['name'], 'created' => !empty($fb_album['created']) ? date('Y-m-d H:i:s', $fb_album['created']) : '', 'modified' => !empty($fb_album['modified']) ? date('Y-m-d H:i:s', $fb_album['modified']) : '', 'description' => $fb_album['description'], 'location' => $fb_album['location'], 'link' => $fb_album['link'], 'size' => $fb_album['size']);
// if it already exists, just update it with any updated info
if ($wp_album) {
// check to make sure the page exists and update the name of the page if needed
if (fb_page_exists($wp_album['page_id'])) {
$album_data['page_id'] = $wp_album['page_id'];
if ($fb_album['name'] != $wp_album['name']) {
fb_update_page($wp_album['page_id'], $fb_album['name']);
}
} else {
$album_data['page_id'] = fb_add_page($fb_album['name']);
}
$wpdb->update(FB_ALBUM_TABLE, $album_data, array('aid' => $fb_album['aid']));
} else {
$album_data['aid'] = $fb_album['aid'];
$album_data['page_id'] = fb_add_page($fb_album['name']);
$album_data['hidden'] = 0;
$album_data['ordinal'] = fb_get_next_ordinal();
$wpdb->insert(FB_ALBUM_TABLE, $album_data);
}
}
// update the photos
$wpdb->query('DELETE FROM ' . FB_PHOTO_TABLE);
$ordinal = 1;
foreach ($fb_photos as $photo) {
if ($last_aid !== $photo['aid']) {
// reset ordinal if we're on a new album now
$ordinal = 1;
}
$album_data = array('pid' => $photo['pid'], 'aid' => $photo['aid'], 'owner' => $photo['owner'], 'src' => $photo['src'], 'src_big' => $photo['src_big'], 'src_small' => $photo['src_small'], 'link' => $photo['link'], 'caption' => $photo['caption'], 'created' => date('Y-m-d H:i:s', $photo['created']), 'ordinal' => $ordinal);
$wpdb->insert(FB_PHOTO_TABLE, $album_data);
// handle ordinal
$last_aid = $photo['aid'];
$ordinal++;
}
// put IDs of all albums in an array
foreach ($fb_albums as $fb_album) {
$album_ids[] = $fb_album['aid'];
}
$wp_albums = fb_get_album();
if (count($wp_albums) > 0) {
// delete albums that have been removed off of Facebook
foreach ($wp_albums as $fb_album) {
if (!@in_array($fb_album['aid'], $album_ids)) {
fb_delete_page($fb_album['page_id']);
$wpdb->query('DELETE FROM `' . FB_ALBUM_TABLE . "` WHERE `aid` = '" . $fb_album['aid'] . "'");
}
}
// delete superfluous pages
foreach ($wp_albums as $fb_album) {
$album_pages[] = $fb_album['page_id'];
}
$wp_pages = $wpdb->get_results('SELECT `ID` FROM `' . FB_POSTS_TABLE . "` WHERE `post_parent` = '" . get_option('fb_albums_page') . "'", ARRAY_A);
foreach ($wp_pages as $page) {
if (!in_array($page['ID'], $album_pages)) {
fb_delete_page($page['ID']);
}
}
}
// now reset the order if needed
if ($reset_order) {
fb_reset_album_order();
}
if (!$this->msg) {
$this->msg = 'Albums imported successfully.';
}
$this->update_progress(true);
}
function update_albums()
{
global $wpdb;
$this->increase_time_limit();
// reset album import progress
$this->update_progress(true);
// if this is the first import then reset the order at the end to make the newest on top
$reset_order = count(fb_get_album()) > 0 ? false : true;
// get albums for each user from Facebook
$fb_albums = array();
$fb_photos = array();
foreach ($this->sessions as $key => $session) {
// setup general info
$uid = $session['uid'];
$this->select_session($uid);
try {
//START CHANGES HERE
if (is_numeric($session['gid'])) {
//groups don't have albums, just photos. Here we get all the photos and fake an album
$gid = $session['gid'];
$group_photos = $this->facebook->fql_query("SELECT pid, aid, owner, src, src_big, src_small, link, caption, created FROM photo WHERE pid IN (SELECT pid FROM photo_tag WHERE subject={$gid})");
//$this->facebook->call_method('Photos.get', array('subj_id' => $gid)); -this is supposed to get all a groups photos but doesnt
if ($group_photos) {
foreach ($group_photos as $key => $value) {
$value['aid'] = $gid;
//this may cause some problems
$value['owner'] = $gid;
//this is fine, I think
array_push($fb_photos, $value);
}
//get group info
$group_info = $this->facebook->fql_query("SELECT gid,name FROM group WHERE gid={$gid}");
//fake an album
$fb_albums[] = array('aid' => $gid, 'cover_pid' => $group_photos[0]['pid'], 'owner' => $gid, 'name' => $group_info[0]['name'] . ' Group Photos', 'created' => time(), 'modified' => time(), 'description' => '', 'location' => '', 'link' => "http://www.facebook.com/group.php?v=photos&ref=ts&gid=" . $gid, 'size' => count($group_photos));
}
} else {
// get all albums
$result = $this->facebook->photos_getAlbums($uid, null);
if (!is_array($result)) {
// the current user has no photos so move on
continue;
}
$fb_albums = array_merge($fb_albums, $result);
$this->update_progress();
}
// get all photos - queries are limited to 5,000 items per query so we need to split them up
// technically this could still error out if the user 100+ photos per album, in that case
// the following number would need to change to 25 or lower
$albums_per_query = 50;
$i = 0;
$album_offset = 0;
while ($album_offset < count($result)) {
$photos = $this->facebook->fql_query("SELECT pid, aid, owner, src, src_big, src_small, link, caption, created FROM photo WHERE aid IN (SELECT aid FROM album WHERE owner = '{$uid}' LIMIT {$albums_per_query} OFFSET {$album_offset})");
$fb_photos = array_merge($fb_photos, (array) $photos);
$album_offset = $albums_per_query * ++$i;
}
$this->update_progress();
// get photos of user
$fb_user_photos = $this->facebook->photos_get($uid, null, null);
if ($fb_user_photos) {
foreach ($fb_user_photos as $k => $v) {
$fb_user_photos[$k]['aid'] = $uid;
}
$fb_photos = array_merge($fb_photos, (array) $fb_user_photos);
$fb_albums[] = array('aid' => $uid, 'cover_pid' => $fb_user_photos[0]['pid'], 'owner' => $uid, 'name' => 'Photos of ' . (count($this->sessions) > 1 ? $session['name'] : 'Me'), 'created' => time(), 'modified' => time(), 'description' => '', 'location' => '', 'link' => "http://www.facebook.com/photo_search.php?id={$uid}", 'size' => count($fb_user_photos));
}
} catch (Exception $e) {
if ($e->getCode() == 102) {
unset($this->sessions[$key]);
update_option('fb_facebook_session', $this->sessions);
$this->msg = "The account for {$session['name']} is no longer active. Please add the account again from the settings panel.";
} else {
$this->msg = "There was an error while retrieving your photos: {$e->getMessage()} [Error #{$e->getCode()}]";
}
return false;
}
}
// put all the albums in an array with the aid as the key
$albums = fb_get_album();
if ($albums) {
foreach ($albums as $album) {
$wp_albums[$album['aid']] = $album;
}
}
// go through all the facebook albums see which ones need to be added
foreach ($fb_albums as $fb_album) {
$wp_album = isset($wp_albums[$fb_album['aid']]) ? $wp_albums[$fb_album['aid']] : false;
$album_data = array('cover_pid' => $fb_album['cover_pid'], 'owner' => $fb_album['owner'], 'name' => $fb_album['name'], 'created' => !empty($fb_album['created']) ? date('Y-m-d H:i:s', $fb_album['created']) : '', 'modified' => !empty($fb_album['modified']) ? date('Y-m-d H:i:s', $fb_album['modified']) : '', 'description' => $fb_album['description'], 'location' => $fb_album['location'], 'link' => $fb_album['link'], 'size' => $fb_album['size']);
// if it already exists, just update it with any updated info
if ($wp_album) {
// check to make sure the page exists and update the name of the page if needed
if (fb_page_exists($wp_album['page_id'])) {
$album_data['page_id'] = $wp_album['page_id'];
if ($fb_album['name'] != $wp_album['name']) {
fb_update_page($wp_album['page_id'], $fb_album['name']);
}
} else {
$album_data['page_id'] = fb_add_page($fb_album['name']);
}
$wpdb->update(FB_ALBUM_TABLE, $album_data, array('aid' => $fb_album['aid']));
} else {
$album_data['aid'] = $fb_album['aid'];
$album_data['page_id'] = fb_add_page($fb_album['name']);
$album_data['hidden'] = 0;
$album_data['ordinal'] = fb_get_next_ordinal();
$wpdb->insert(FB_ALBUM_TABLE, $album_data);
}
}
// update the photos
$wpdb->query('DELETE FROM ' . FB_PHOTO_TABLE);
$ordinal = 1;
foreach ($fb_photos as $photo) {
if ($last_aid !== $photo['aid']) {
// reset ordinal if we're on a new album now
$ordinal = 1;
}
$album_data = array('pid' => $photo['pid'], 'aid' => $photo['aid'], 'owner' => $photo['owner'], 'src' => $photo['src'], 'src_big' => $photo['src_big'], 'src_small' => $photo['src_small'], 'link' => $photo['link'], 'caption' => $photo['caption'], 'created' => date('Y-m-d H:i:s', $photo['created']), 'ordinal' => $ordinal);
$wpdb->insert(FB_PHOTO_TABLE, $album_data);
// handle ordinal
$last_aid = $photo['aid'];
$ordinal++;
}
// put IDs of all albums in an array
foreach ($fb_albums as $fb_album) {
$album_ids[] = $fb_album['aid'];
}
$wp_albums = fb_get_album();
if (count($wp_albums) > 0) {
// delete albums that have been removed off of Facebook
foreach ($wp_albums as $fb_album) {
if (!@in_array($fb_album['aid'], $album_ids)) {
fb_delete_page($fb_album['page_id']);
$wpdb->query('DELETE FROM `' . FB_ALBUM_TABLE . "` WHERE `aid` = '" . $fb_album['aid'] . "'");
}
}
// delete superfluous pages
foreach ($wp_albums as $fb_album) {
$album_pages[] = $fb_album['page_id'];
}
$wp_pages = $wpdb->get_results('SELECT `ID` FROM `' . FB_POSTS_TABLE . "` WHERE `post_parent` = '" . get_option('fb_albums_page') . "'", ARRAY_A);
foreach ($wp_pages as $page) {
if (!in_array($page['ID'], $album_pages)) {
fb_delete_page($page['ID']);
}
}
}
// now reset the order if needed
if ($reset_order) {
fb_reset_album_order();
}
if (!$this->msg) {
$this->msg = 'Albums imported successfully.';
}
$this->update_progress(true);
}