prefix."query_wrangler";
$query_id = $_GET['edit'];
$sql = "SELECT name,type,data,path FROM ".$table_name." WHERE id = ".$query_id." LIMIT 1";
$row = $wpdb->get_row($sql);
$options = qw_unserialize($row->data);
// preprocess existing handlers
$filters = qw_preprocess_handlers('filter', $options['args']['filters']);
$fields = (isset($options['display']['field_settings']['fields'])) ? qw_preprocess_handlers('field', $options['display']['field_settings']['fields']) : array();
$sorts = qw_preprocess_handlers('sort', $options['args']['sorts']);
$theme = get_option('qw_edit_theme');
if($theme == ""){
$theme = QW_DEFAULT_THEME;
}
// start building edit page data
$edit_args = array(
// editor theme
'theme' => $theme,
// query data
'query_id' => $query_id,
'options' => $options,
'args' => $options['args'],
'display' => $options['display'],
'query_name' => $row->name,
'query_type' => $row->type,
'query_page_title' => isset($options['display']['title']) ? $options['display']['title'] : '',
'filters' => $filters,
'fields' => $fields,
'sorts' => $sorts,
// all datas
'post_statuses' => qw_all_post_statuses(),
'styles' => qw_all_styles(),
'row_styles' => qw_all_row_styles(),
'row_complete_styles' => qw_all_row_complete_styles(),
'page_templates' => get_page_templates(),
'post_types' => qw_all_post_types(),
'pager_types' => qw_all_pager_types(),
'category_ids' => get_all_category_ids(),
'tags' => get_tags(array('hide_empty' => false)),
'all_filters' => qw_all_filters(),
'all_fields' => qw_all_fields(),
'all_sorts' => qw_all_sort_options(),
);
// Page Queries
if($row->type == 'page'){
$edit_args['query_page_path'] = $row->path;
}
// overrides
if($row->type == 'override'){
$edit_args['query_override_type'] = $row->override_type;
}
// admin wrapper arguments
$admin_args = array(
'title' => 'Edit query '.$edit_args['query_name'].'',
// content is the query_edit page
'content' => theme('query_edit', $edit_args)
);
// add view link for pages
if($row->type == 'page' && isset($row->path)){
$admin_args['title'].= ' View';
}
// include the edit form
print theme('admin_wrapper', $admin_args);
}
/*
* Settings!
*/
function qw_save_settings($post){
update_option('qw_edit_theme', $post['qw-theme']);
update_option('qw_widget_theme_compat', $post['qw-widget-theme-compat']);
}
function qw_settings_page()
{
$settings_args = array(
'theme' => get_option('qw_edit_theme'),
'edit_themes' => qw_all_edit_themes(),
'widget_theme_compat' => get_option('qw_widget_theme_compat'),
);
$args = array(
'title' => 'Query Wrangler Settings',
'content' => theme('query_settings', $settings_args)
);
print theme('admin_wrapper', $args);
}
/*
* Create Query Page
*/
function qw_create_query() {
$args = array(
'title' => 'Create Query',
'content' => theme('query_create')
);
print theme('admin_wrapper', $args);
}
/*
* Export Query page
*/
function qw_export_page(){
global $wpdb;
$table = $wpdb->prefix.'query_wrangler';
$row = $wpdb->get_row('SELECT name FROM '.$table.' WHERE id = '.$_GET['export']);
$args = array(
'title' => 'Export Query: '.$row->name.'',
'content' => theme('query_export', array('query_id' => $_GET['export'])),
);
print theme('admin_wrapper', $args);
}
/*
* Import Query Page
*/
function qw_import_page(){
// show import page
$args = array(
'title' => 'Import Query',
'content' => theme('query_import'),
);
print theme('admin_wrapper', $args);
}