$pagination->set_pagination_stats($wpbi_dialog['table']['pagination']['stats']);
$pagination->set_paginate_links(paginate_links(array('base' => esc_url(add_query_arg($pagination->pg_parameter, '%#%')), 'format' => '', 'prev_text' => __($wpbi_dialog['table']['pagination']['prev_text']), 'next_text' => __($wpbi_dialog['table']['pagination']['next_text']), 'total' => ceil($pagination->rows / $pagination->pg_interval), 'current' => $pagination->current_page)));
$pagination->initialize();
echo $pagination->get_html();
//END page navigation
//Execute query limitng the resultset
$qy_queries_rows = $wpdb->get_results($query->limit_qy_to($pagination->item_start - 1, $pagination->pg_interval), 'ARRAY_N');
//Output table
$column_headers = array($wpbi_dialog['header']['queries']['id'], $wpbi_dialog['header']['queries']['name'], $wpbi_dialog['header']['queries']['database'], $wpbi_dialog['header']['queries']['statement']);
$single_actions = array("edit" => array("label" => $wpbi_dialog['action']['label']['edit'], "page" => $wpbi_url['slug']['queries'], "action" => $wpbi_settings['value']['edit'], "parameter" => $wpbi_settings['parameter']['qy_id']), "copy" => array("label" => $wpbi_dialog['action']['label']['copy'], "page" => $wpbi_url['slug']['queries'], "action" => $wpbi_settings['value']['copy'], "parameter" => $wpbi_settings['parameter']['qy_id']), "test" => array("label" => $wpbi_dialog['action']['label']['test'], "page" => $wpbi_url['slug']['queries'], "action" => $wpbi_settings['value']['test'], "parameter" => $wpbi_settings['parameter']['qy_id']), "drop" => array("label" => $wpbi_dialog['action']['label']['drop'], "page" => $wpbi_url['slug']['queries'], "action" => $wpbi_settings['value']['drop'], "parameter" => $wpbi_settings['parameter']['qy_id']));
$global_actions = array("drop" => array("label" => $wpbi_dialog['button']['label']['drop'], "value" => $wpbi_settings['value']['drop']));
$table_form = new table_form();
$table_form->set_css_class('widefat post fixed');
$table_form->set_rows($qy_queries_rows);
$table_form->set_cols($column_headers);
$table_form->has_header(true);
$table_form->has_footer(true);
$table_form->encode_html(true);
$table_form->set_single_actions($single_actions);
$table_form->set_global_actions($global_actions);
$table_form->set_gobal_checkbox_id('post_all');
$table_form->set_form_action('');
$table_form->set_form_id('manage_queries');
$table_form->set_form_method('post');
echo $table_form->get_html();
}
// END Condition of user testing new query
//output page footer
$template_site->pparse('footer');
}
//End condition of no test
