function wppa_get_edit_search_photos($limit = '', $count_only = false) { global $wpdb; global $wppa_search_stats; $doit = false; // if ( wppa_user_is( 'administrator' ) ) $doit = true; if (current_user_can('wppa_admin') && current_user_can('wppa_moderate')) { $doit = true; } if (wppa_switch('upload_edit')) { $doit = true; } if (!$doit) { // Should never get here. Only when url is manipulted manually. die('Security check failure #309'); } $words = explode(',', wppa_sanitize_searchstring($_REQUEST['wppa-searchstring'])); $wppa_search_stats = array(); $first = true; foreach ($words as $word) { // Find lines in index db table if (wppa_switch('wild_front')) { $pidxs = $wpdb->get_results("SELECT `slug`, `photos` FROM `" . WPPA_INDEX . "` WHERE `slug` LIKE '%" . $word . "%'", ARRAY_A); } else { $pidxs = $wpdb->get_results("SELECT `slug`, `photos` FROM `" . WPPA_INDEX . "` WHERE `slug` LIKE '" . $word . "%'", ARRAY_A); } $photos = ''; foreach ($pidxs as $pi) { $photos .= $pi['photos'] . ','; } if ($first) { $photo_array = wppa_index_array_remove_dups(wppa_index_string_to_array(trim($photos, ','))); $count = empty($photo_array) ? '0' : count($photo_array); $list = implode(',', $photo_array); if (!$list) { $list = '0'; } // if ( wppa_user_is( 'administrator' ) ) { if (current_user_can('wppa_admin') && current_user_can('wppa_moderate')) { $real_count = $wpdb->get_var("SELECT COUNT(*) FROM `" . WPPA_PHOTOS . "` WHERE `id` IN (" . $list . ") "); if ($count != $real_count) { update_option('wppa_remake_index_photos_status', __('Required', 'wp-photo-album-plus')); // echo 'realcount mismatch:1'; // echo ' count='.$count.', realcount='.$real_count.'<br/>'; } } else { // Not admin, can edit own photos only $real_count = $wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM `" . WPPA_PHOTOS . "` WHERE `id` IN (" . $list . ") AND `owner` = %s", wppa_get_user())); } $wppa_search_stats[] = array('word' => $word, 'count' => $real_count); $first = false; } else { $temp_array = wppa_index_array_remove_dups(wppa_index_string_to_array(trim($photos, ','))); $count = empty($temp_array) ? '0' : count($temp_array); $list = implode(',', $temp_array); // if ( wppa_user_is( 'administrator' ) ) { if (current_user_can('wppa_admin') && current_user_can('wppa_moderate')) { $real_count = $wpdb->get_var("SELECT COUNT(*) FROM `" . WPPA_PHOTOS . "` WHERE `id` IN (" . $list . ") "); if ($count != $real_count) { update_option('wppa_remake_index_photos_status', __('Required', 'wp-photo-album-plus')); // echo 'realcount mismatch:2'; // echo ' count='.$count.', realcount='.$real_count.'<br/>'; } } else { // Not admin, can edit own photos only $real_count = $wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM `" . WPPA_PHOTOS . "` WHERE `id` IN (" . $list . ") AND `owner` = %s", wppa_get_user())); } $wppa_search_stats[] = array('word' => $word, 'count' => $real_count); $photo_array = array_intersect($photo_array, $temp_array); } } if (!empty($photo_array)) { $list = implode(',', $photo_array); // if ( wppa_user_is( 'administrator' ) ) { if (current_user_can('wppa_admin') && current_user_can('wppa_moderate')) { $totcount = $wpdb->get_var("SELECT COUNT(*) FROM `" . WPPA_PHOTOS . "` WHERE `id` IN (" . $list . ") "); } else { // Not admin, can edit own photos only $totcount = $wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM `" . WPPA_PHOTOS . "` WHERE `id` IN (" . $list . ") AND `owner` = %s", wppa_get_user())); } $wppa_search_stats[] = array('word' => __('Combined', 'wp-photo-album-plus'), 'count' => $totcount); // if ( wppa_user_is( 'administrator' ) ) { if (current_user_can('wppa_admin') && current_user_can('wppa_moderate')) { $photos = $wpdb->get_results("SELECT * FROM `" . WPPA_PHOTOS . "` WHERE `id` IN (" . $list . ") " . wppa_get_photo_order('0', 'norandom') . $limit, ARRAY_A); } else { // Not admin, can edit own photos only $photos = $wpdb->get_results($wpdb->prepare("SELECT * FROM `" . WPPA_PHOTOS . "` WHERE `id` IN (" . $list . ") AND `owner` = %s" . wppa_get_photo_order('0', 'norandom') . $limit, wppa_get_user()), ARRAY_A); } } else { $photos = false; } if ($count_only) { if (is_array($photos)) { return count($photos); } else { return '0'; } } else { return $photos; } }
function wppa_search_edit($collapsable = false) { $doit = false; // if ( wppa_user_is( 'administrator' ) ) $doit = true; if (current_user_can('wppa_admin') && current_user_can('wppa_moderate')) { $doit = true; } if (wppa_switch('upload_edit')) { $doit = true; } if (!$doit) { return; } ?> <tr> <td colspan="<?php echo $collapsable ? 19 : 13; ?> " > <em><?php _e('Search for photos to edit', 'wp-photo-album-plus'); ?> </em> <small><?php _e('Enter search words seperated by commas. Photos will meet all search words by their names, descriptions, translated keywords and/or tags.', 'wp-photo-album-plus'); ?> </small> </td> </tr> <tr class="alternate" > <?php if ($collapsable) { echo '<td></td>'; } ?> <td> <?php _e('Any', 'wppa', 'wp-photo-album-plus'); ?> </td> <?php if ($collapsable) { echo '<td></td><td></td><td></td><td></td><td></td>'; } ?> <td> <?php _e('Search for', 'wp-photo-album-plus'); ?> </td> <td colspan="4" > <?php /* if ( wppa_switch( 'indexed_search' ) ) { */ ?> <?php $value = isset($_REQUEST['wppa-searchstring']) ? wppa_sanitize_searchstring($_REQUEST['wppa-searchstring']) : ''; ?> <a id="wppa-edit-search-tag" /> <input type="text" id="wppa-edit-search" name="wppa-edit-search" style="width:100%; padding:2px; color:black; background-color:#ccffcc;" value="<?php echo $value; ?> " /> <?php /* } else { ?> <small style="color:red;" ><?php _e('To use this feature, enable indexed search in Table IX-E7') ?></small> <?php } */ ?> </td> <?php if (current_user_can('wppa_admin') && current_user_can('wppa_moderate')) { echo '<td></td>'; } ?> <td> <a class="wppaedit" onclick="wppaEditSearch('<?php echo wppa_ea_url('search'); ?> ', 'wppa-edit-search' )" > <b><?php _e('Edit', 'wp-photo-album-plus'); ?> </b> </a> </td> <td> <a class="wppaedit" onclick="wppaEditSearch('<?php echo wppa_ea_url('search') . '&quick'; ?> ', 'wppa-edit-search' )" > <b><?php _e('Quick', 'wp-photo-album-plus'); ?> </b> </a> </td> <td> <a class="wppaedit" onclick="wppaEditSearch('<?php echo wppa_ea_url('search') . '&bulk'; ?> ', 'wppa-edit-search' )" > <b><?php _e('Bulk', 'wp-photo-album-plus'); ?> </b> </a> </td> <td></td><td></td><td></td> </tr> <?php }