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']);