function wpbi_initWPDBconnection()
{
global $wpdb, $wpbi_settings, $wpbi_sql;
$wpbi_query = "SELECT * FROM " . $wpbi_sql['tname']['databases'];
// test if at least one DB connection already exists
if (!$wpdb->query($wpbi_query)) {
$wpbi_credentials = wpbi_getWPDBcredentials();
$vo_database = new vo_database(NULL, $wpbi_credentials[0], $wpbi_credentials[3], $wpbi_credentials[1], $wpbi_credentials[2]);
$dao_database = new dao_database($wpdb, $wpbi_sql['tname']['databases']);
$dao_database->add($vo_database);
}
}
******************************************************************************/
/***********************/
/*** SET TEMPLATE ***/
/***********************/
$template_site->set_filenames(array('header' => $wpbi_url['tpl']['root-path'] . $wpbi_url['tpl']['header'], 'footer' => $wpbi_url['tpl']['root-path'] . $wpbi_url['tpl']['footer'], 'connections-new' => $wpbi_url['tpl']['root-path'] . $wpbi_url['tpl']['connections-new'], 'connections-edit' => $wpbi_url['tpl']['root-path'] . $wpbi_url['tpl']['connections-edit']));
?>
<?php
/***********************/
/*** ADD ACTION ***/
/***********************/
if ($_POST[$wpbi_settings['parameter']['action']] == $wpbi_settings['value']['add']) {
$vo_database = new vo_database(NULL, $_POST[$wpbi_settings['parameter']['db_name']], $_POST[$wpbi_settings['parameter']['db_host']], $_POST[$wpbi_settings['parameter']['db_user']], $_POST[$wpbi_settings['parameter']['db_pass']]);
$dao_database = new dao_database($wpdb, $wpbi_sql['tname']['databases']);
$dao_database->add($vo_database);
//wls_simple_log("WPBI", " New connection added");
}
?>
<?php
/***********************/
/*** DROP ACTION ***/
/***********************/
/*** GLOBAL ***/
if ($_POST[$wpbi_settings['parameter']['action']] == $wpbi_settings['value']['drop']) {
//Get list of connections to be deleted
$selected_queries = $_POST['post'];
for ($conn_idx = 0; $conn_idx < sizeof($selected_queries); $conn_idx++) {
$vo_database = new vo_database($selected_queries[$conn_idx], NULL, NULL, NULL, NULL);
$dao_database = new dao_database($wpdb, $wpbi_sql['tname']['databases']);
