} else {
$query .= 'id=' . $sync_options['cat_id'];
}
$cat_ids = array_from_query($query, 'id');
$query = "\n SELECT `id`, `file`, `path`\n FROM " . IMAGES_TABLE . " INNER JOIN " . IMAGE_CATEGORY_TABLE . " ON id=image_id\n WHERE " . SQL_VIDEOS . " " . $OVERWRITE . "\n AND category_id IN (" . implode(',', $cat_ids) . ")\n GROUP BY id";
} else {
$query = "SELECT `id`, `file`, `path`\n FROM " . IMAGES_TABLE . "\n WHERE " . SQL_VIDEOS . " " . $OVERWRITE . ";";
}
// Do the work, share with batch manager
require_once dirname(__FILE__) . '/../include/function_sync2.php';
// Send sync result to template
$template->assign('sync_errors', $errors);
$template->assign('sync_warnings', $warnings);
$template->assign('sync_infos', $infos);
// Send result to templates
$template->assign('update_result', array('NB_ELEMENTS_POSTER' => $posters, 'NB_ELEMENTS_THUMB' => $thumbs, 'NB_ELEMENTS_EXIF' => $metadata, 'NB_ELEMENTS_CANDIDATES' => $videos, 'NB_ERRORS' => count($errors), 'NB_WARNINGS' => count($warnings)));
}
/* Get statistics */
// All videos with supported extensions by VideoJS
$query = "SELECT COUNT(*) FROM " . IMAGES_TABLE . " WHERE " . SQL_VIDEOS . ";";
list($nb_videos) = pwg_db_fetch_row(pwg_query($query));
// All videos with supported extensions by VideoJS and thumb
$query = "SELECT COUNT(*) FROM " . IMAGES_TABLE . " WHERE `representative_ext` IS NOT NULL AND " . SQL_VIDEOS . ";";
list($nb_videos_thumb) = pwg_db_fetch_row(pwg_query($query));
// All videos with supported extensions by VideoJS and with GPS data
$query = "SELECT COUNT(*) FROM " . IMAGES_TABLE . " WHERE `latitude` IS NOT NULL and `longitude` IS NOT NULL AND " . SQL_VIDEOS . ";";
list($nb_videos_geotagged) = pwg_db_fetch_row(pwg_query($query));
$query = 'SELECT id, CONCAT(name, IF(dir IS NULL, " (V)", "") ) AS name, uppercats, global_rank FROM ' . CATEGORIES_TABLE;
display_select_cat_wrapper($query, array($sync_options['cat_id']), 'categories', false);
// send value to template
$template->assign(array('SUBCATS_INCLUDED_CHECKED' => $sync_options['subcats_included'] ? 'checked="checked"' : '', 'NB_VIDEOS' => $nb_videos, 'NB_VIDEOS_GEOTAGGED' => $nb_videos_geotagged, 'NB_VIDEOS_THUMB' => $nb_videos_thumb, 'VIDEOJS_PATH' => VIDEOJS_PATH));
FROM ' . CATEGORIES_TABLE . '
WHERE status = \'public\'
;';
$query_false = '
SELECT id,name,uppercats,global_rank
FROM ' . CATEGORIES_TABLE . '
WHERE status = \'private\'
;';
$template->assign(array('L_SECTION' => l10n('Manage authorizations for selected albums'), 'L_CAT_OPTIONS_TRUE' => l10n('Public'), 'L_CAT_OPTIONS_FALSE' => l10n('Private')));
break;
case 'representative':
$query_true = '
SELECT id,name,uppercats,global_rank
FROM ' . CATEGORIES_TABLE . '
WHERE representative_picture_id IS NOT NULL
;';
$query_false = '
SELECT DISTINCT id,name,uppercats,global_rank
FROM ' . CATEGORIES_TABLE . ' INNER JOIN ' . IMAGE_CATEGORY_TABLE . ' ON id=category_id
WHERE representative_picture_id IS NULL
;';
$template->assign(array('L_SECTION' => l10n('Representative'), 'L_CAT_OPTIONS_TRUE' => l10n('singly represented'), 'L_CAT_OPTIONS_FALSE' => l10n('randomly represented')));
break;
}
display_select_cat_wrapper($query_true, array(), 'category_option_true');
display_select_cat_wrapper($query_false, array(), 'category_option_false');
// +-----------------------------------------------------------------------+
// | sending html code |
// +-----------------------------------------------------------------------+
$template->assign_var_from_handle('DOUBLE_SELECT', 'double_select');
$template->assign_var_from_handle('ADMIN_CONTENT', 'cat_options');
$page['errors'][] = l10n('Cannot delete the old permalink !');
}
}
$template->set_filename('permalinks', 'permalinks.tpl');
// +-----------------------------------------------------------------------+
// | tabs |
// +-----------------------------------------------------------------------+
$page['tab'] = 'permalinks';
include PHPWG_ROOT_PATH . 'admin/include/albums_tab.inc.php';
$query = '
SELECT
id, permalink,
CONCAT(id, " - ", name, IF(permalink IS NULL, "", " √") ) AS name,
uppercats, global_rank
FROM ' . CATEGORIES_TABLE;
display_select_cat_wrapper($query, $selected_cat, 'categories', false);
// --- generate display of active permalinks -----------------------------------
$sort_by = parse_sort_variables(array('id', 'name', 'permalink'), 'name', 'psf', array('delete_permanent'), 'SORT_');
$query = '
SELECT id, permalink, uppercats, global_rank
FROM ' . CATEGORIES_TABLE . '
WHERE permalink IS NOT NULL
';
if ($sort_by[0] == 'id' or $sort_by[0] == 'permalink') {
$query .= ' ORDER BY ' . $sort_by[0];
}
$categories = array();
$result = pwg_query($query);
while ($row = pwg_db_fetch_assoc($result)) {
$row['name'] = get_cat_display_name_cache($row['uppercats']);
$categories[] = $row;
FROM ' . PFEMAIL_MAILBOXES_TABLE . ' AS pm
JOIN ' . CATEGORIES_TABLE . ' AS c ON c.id = category_id
ORDER BY pm.id DESC
;';
$mailboxes = query2array($query);
foreach ($mailboxes as $idx => $mailbox) {
$mailboxes[$idx]['album'] = get_cat_display_name_cache($mailbox['uppercats'], null, false);
$mailboxes[$idx]['data'] = json_encode($mailbox);
}
$template->assign(array('mailboxes' => $mailboxes, 'PWG_TOKEN' => get_pwg_token()));
// list of albums
$query = '
SELECT id,name,uppercats,global_rank
FROM ' . CATEGORIES_TABLE . '
;';
display_select_cat_wrapper($query, isset($category_options_selected) ? $category_options_selected : array(), 'category_options');
// groups
$query = '
SELECT id
FROM ' . GROUPS_TABLE . '
;';
$group_ids = query2array($query, null, 'id');
$query = '
SELECT id
FROM ' . GROUPS_TABLE . '
WHERE pfemail_notify = \'true\'
;';
$groups_selected = query2array($query, null, 'id');
$template->assign(array('CACHE_KEYS' => get_admin_client_cache_keys(array('groups')), 'groups' => $group_ids, 'groups_selected' => $groups_selected));
// +-----------------------------------------------------------------------+
// | sending html code |
;';
$author_counts = array();
$result = pwg_query($query);
while ($row = pwg_db_fetch_assoc($result)) {
if (!isset($author_counts[$row['author']])) {
$author_counts[$row['author']] = 0;
}
$author_counts[$row['author']]++;
}
foreach ($author_counts as $author => $counter) {
$authors[] = array('author' => $author, 'counter' => $counter);
}
$template->assign('AUTHORS', $authors);
//------------------------------------------------------------- categories form
$query = '
SELECT id,name,global_rank,uppercats
FROM ' . CATEGORIES_TABLE . '
' . get_sql_condition_FandF(array('forbidden_categories' => 'id', 'visible_categories' => 'id'), 'WHERE') . '
;';
display_select_cat_wrapper($query, array(), 'category_options', true);
// include menubar
$themeconf = $template->get_template_vars('themeconf');
if (!isset($themeconf['hide_menu_on']) or !in_array('theSearchPage', $themeconf['hide_menu_on'])) {
include PHPWG_ROOT_PATH . 'include/menubar.inc.php';
}
//------------------------------------------------------------ html code display
include PHPWG_ROOT_PATH . 'include/page_header.php';
trigger_notify('loc_end_search');
flush_page_messages();
$template->pparse('search');
include PHPWG_ROOT_PATH . 'include/page_tail.php';
} else {
$tpl_introduction = array('sync' => 'dirs', 'sync_meta' => true, 'display_info' => false, 'add_to_caddie' => false, 'subcats_included' => true, 'privacy_level_selected' => 0, 'meta_all' => false, 'meta_empty_overrides' => false);
$cat_selected = array();
if (isset($_GET['cat_id'])) {
check_input_parameter('cat_id', $_GET, false, PATTERN_ID);
$cat_selected = array($_GET['cat_id']);
$tpl_introduction['sync'] = 'files';
}
}
$tpl_introduction['privacy_level_options'] = get_privacy_level_options();
$template->assign('introduction', $tpl_introduction);
$query = '
SELECT id,name,uppercats,global_rank
FROM ' . CATEGORIES_TABLE . '
WHERE site_id = ' . $site_id;
display_select_cat_wrapper($query, $cat_selected, 'category_options', false);
if (count($errors) > 0) {
foreach ($errors as $error) {
$template->append('sync_errors', array('ELEMENT' => $error['path'], 'LABEL' => $error['type'] . ' (' . $error_labels[$error['type']][0] . ')'));
}
foreach ($error_labels as $error_type => $error_description) {
$template->append('sync_error_captions', array('TYPE' => $error_type, 'LABEL' => $error_description[1]));
}
}
if (count($infos) > 0 and isset($_POST['display_info']) and $_POST['display_info'] == 1) {
foreach ($infos as $info) {
$template->append('sync_infos', array('ELEMENT' => $info['path'], 'LABEL' => $info['info']));
}
}
// +-----------------------------------------------------------------------+
// | sending html code |
$page['errors'][] = l10n('Select at least one album');
}
}
// +-----------------------------------------------------------------------+
// | template initialization |
// +-----------------------------------------------------------------------+
$template->set_filename('cat_move', 'cat_move.tpl');
$template->assign(array('U_HELP' => get_root_url() . 'admin/popuphelp.php?page=cat_move', 'F_ACTION' => get_root_url() . 'admin.php?page=cat_move'));
// +-----------------------------------------------------------------------+
// | tabs |
// +-----------------------------------------------------------------------+
$page['tab'] = 'move';
include PHPWG_ROOT_PATH . 'admin/include/albums_tab.inc.php';
// +-----------------------------------------------------------------------+
// | Categories display |
// +-----------------------------------------------------------------------+
$query = '
SELECT id,name,uppercats,global_rank
FROM ' . CATEGORIES_TABLE . '
WHERE dir IS NULL
;';
display_select_cat_wrapper($query, array(), 'category_to_move_options');
$query = '
SELECT id,name,uppercats,global_rank
FROM ' . CATEGORIES_TABLE . '
;';
display_select_cat_wrapper($query, array(), 'category_parent_options');
// +-----------------------------------------------------------------------+
// | sending html code |
// +-----------------------------------------------------------------------+
$template->assign_var_from_handle('ADMIN_CONTENT', 'cat_move');
SET polaroid_active = \'true\'
WHERE id IN (' . implode(',', $_POST['albums']) . ')
;';
pwg_query($query);
}
$page['infos'][] = l10n('Your configuration settings are saved');
}
// +-----------------------------------------------------------------------+
// | template init |
// +-----------------------------------------------------------------------+
$template->set_filename('plugin_admin_content', dirname(__FILE__) . '/admin_config.tpl');
// +-----------------------------------------------------------------------+
// | form options |
// +-----------------------------------------------------------------------+
// associate to albums
$query = '
SELECT id
FROM ' . CATEGORIES_TABLE . '
WHERE polaroid_active = \'true\'
;';
$polaroid_albums = array_from_query($query, 'id');
$query = '
SELECT id,name,uppercats,global_rank
FROM ' . CATEGORIES_TABLE . '
;';
display_select_cat_wrapper($query, $polaroid_albums, 'album_options');
$template->assign('apply_to_albums', $conf['polaroid']['apply_to_albums']);
// +-----------------------------------------------------------------------+
// | sending html code |
// +-----------------------------------------------------------------------+
$template->assign_var_from_handle('ADMIN_CONTENT', 'plugin_admin_content');
// +-----------------------------------------------------------------------+
$title = l10n('User comments');
$page['body_id'] = 'theCommentsPage';
$template->set_filenames(array('comments' => 'comments.tpl'));
$template->assign(array('F_ACTION' => PHPWG_ROOT_PATH . 'comments.php', 'F_KEYWORD' => htmlspecialchars(stripslashes(@$_GET['keyword'])), 'F_AUTHOR' => htmlspecialchars(stripslashes(@$_GET['author']))));
// +-----------------------------------------------------------------------+
// | form construction |
// +-----------------------------------------------------------------------+
// Search in a particular category
$blockname = 'categories';
$query = '
SELECT id, name, uppercats, global_rank
FROM ' . CATEGORIES_TABLE . '
' . get_sql_condition_FandF(array('forbidden_categories' => 'id', 'visible_categories' => 'id'), 'WHERE') . '
;';
display_select_cat_wrapper($query, array(@$_GET['cat']), $blockname, true);
// Filter on recent comments...
$tpl_var = array();
foreach ($since_options as $id => $option) {
$tpl_var[$id] = $option['label'];
}
$template->assign('since_options', $tpl_var);
$template->assign('since_options_selected', $page['since']);
// Sort by
$template->assign('sort_by_options', $sort_by);
$template->assign('sort_by_options_selected', $page['sort_by']);
// Sorting order
$template->assign('sort_order_options', $sort_order);
$template->assign('sort_order_options_selected', $page['sort_order']);
// Number of items
$blockname = 'items_number_option';
