}
//Prepare output
$template_site->assign_vars(array('PG_TITLE' => $wpbi_dialog['page']['queries']['title'], 'PG_DESCRIPTION' => sprintf($wpbi_dialog['query']['saved']['edit'], $vo_query->name, htmlentities($query->stmt)), 'QY_EDIT_CONNECTION' => $wpbi_dialog['field']['queries']['connection'], 'QY_EDIT_NAME' => $wpbi_dialog['field']['queries']['name'], 'P_QY_NAME' => $wpbi_settings['parameter']['qy_name'], 'V_QY_NAME' => isset($_POST[$wpbi_settings['parameter']['qy_name']]) ? $_POST[$wpbi_settings['parameter']['qy_name']] : $vo_query->name, 'QY_EDIT_STMT' => $wpbi_dialog['field']['queries']['statement'], 'P_QY_STMT' => $wpbi_settings['parameter']['qy_statement'], 'P_QY_ID' => $wpbi_settings['parameter']['qy_id'], 'V_QY_ID' => $vo_query->id, 'V_QY_STMT' => isset($_POST[$wpbi_settings['parameter']['qy_statement']]) ? $_POST[$wpbi_settings['parameter']['qy_statement']] : $vo_query->statement, 'QY_EDIT_DB_OPTIONS' => $select_options, 'QY_EDIT_FORM_ACTION' => substr(substr(strrchr($_SERVER['REQUEST_URI'], '/'), 1), 0, strpos(substr(strrchr($_SERVER['REQUEST_URI'], '/'), 1), '&')), 'P_QY_DB' => $wpbi_settings['parameter']['qy_db'], 'P_QY_ACTION' => $wpbi_settings['parameter']['action'], 'V_EDIT_ACTION' => $wpbi_settings['value']['edit'], 'V_TEST_ACTION' => $wpbi_settings['value']['edit-test'], 'LBL_BTN_SAVE' => $wpbi_dialog['label']['button']['add'], 'LBL_BTN_TEST' => $wpbi_dialog['label']['button']['test']));
//output page header and query form
$template_site->pparse('header');
$template_site->pparse('queries-edit');
//Output new query test result (if any)
echo $test_output;
}
/**** Edit query: save modifications ***/
if ($_POST[$wpbi_settings['parameter']['action']] == $wpbi_settings['value']['edit'] && isset($_POST[$wpbi_settings['parameter']['qy_id']]) && isset($_POST[$wpbi_settings['parameter']['qy_db']]) && isset($_POST[$wpbi_settings['parameter']['qy_statement']]) && isset($_POST[$wpbi_settings['parameter']['qy_name']])) {
$selected_query = $_POST[$wpbi_settings['parameter']['qy_id']];
$old_query = new vo_query($selected_query, NULL, NULL, NULL);
$new_query = new vo_query($selected_query, $_POST[$wpbi_settings['parameter']['qy_db']], $_POST[$wpbi_settings['parameter']['qy_name']], $_POST[$wpbi_settings['parameter']['qy_statement']]);
$dao_query = new dao_query($wpdb, $wpbi_sql['tname']['queries']);
$dao_query->edit($old_query, $new_query);
}
?>
<?php
/***********************/
/*** DEFAULT ***/
/***********************/
/**** Build form to create new query and display the created query ***/
if ($_GET[$wpbi_settings['parameter']['action']] != $wpbi_settings['value']['test'] && $_GET[$wpbi_settings['parameter']['action']] != $wpbi_settings['value']['edit'] && $_POST[$wpbi_settings['parameter']['action']] != $wpbi_settings['value']['edit-test']) {
//Database select options
$dao_database = new dao_database($wpdb, $wpbi_sql['tname']['databases']);
$vo_database = $dao_database->select(NULL);
if (sizeof($vo_database) == 0) {
echo '
<p>' . $wpbi_dialog['msg']['warning']['no-connections'] . '</p>
