Example #1
0
             }
             Database::needRoot(false);
             $mysql_add_data = (include_once dirname(__FILE__) . '/lib/formfields/customer/mysql/formfield.mysql_add.php');
             $mysql_add_form = htmlform::genHTMLForm($mysql_add_data);
             $title = $mysql_add_data['mysql_add']['title'];
             $image = $mysql_add_data['mysql_add']['image'];
             eval("echo \"" . getTemplate('mysql/mysqls_add') . "\";");
         }
     }
 } elseif ($action == 'edit' && $id != 0) {
     $result_stmt = Database::prepare("SELECT `id`, `databasename`, `description`, `dbserver` FROM `" . TABLE_PANEL_DATABASES . "`\n\t\t\tWHERE `customerid` = :customerid\n\t\t\tAND `id` = :id");
     Database::pexecute($result_stmt, array("customerid" => $userinfo['customerid'], "id" => $id));
     $result = $result_stmt->fetch(PDO::FETCH_ASSOC);
     if (isset($result['databasename']) && $result['databasename'] != '') {
         Database::needRoot(true);
         $sql_root = Database::getSecuredSqlRootArrayFromUserDataFile();
         Database::needRoot(false);
         if (!isset($sql_root[$result['dbserver']]) || !is_array($sql_root[$result['dbserver']])) {
             $result['dbserver'] = 0;
         }
         if (isset($_POST['send']) && $_POST['send'] == 'send') {
             // Only change Password if it is set, do nothing if it is empty! -- PH 2004-11-29
             $password = validate($_POST['mysql_password'], 'password');
             if ($password != '') {
                 // validate password
                 $password = validatePassword($password);
                 if ($password == $result['databasename']) {
                     standard_error('passwordshouldnotbeusername');
                 }
                 // Begin root-session
                 Database::needRoot(true, $result['dbserver'], true);