Exemple #1
0
function selectDB_save()
{
    if (!isset($_POST["instance-id"])) {
        $_POST["instance-id"] = 0;
    }
    if (!is_numeric($_POST["instance-id"])) {
        $_POST["instance-id"] = 0;
    }
    $fADD[] = 'INSERT INTO `db` (`Host`, `Db`, `User`, `Select_priv`, `Insert_priv`, `Update_priv`, `Delete_priv`, `Create_priv`, `Drop_priv`, `Grant_priv`,';
    $fADD[] = '`References_priv`, `Index_priv`, `Alter_priv`, `Create_tmp_table_priv`, `Lock_tables_priv`, `Create_view_priv`, `Show_view_priv`,';
    $fADD[] = ' `Create_routine_priv`, `Alter_routine_priv`, `Execute_priv`, `Event_priv`, `Trigger_priv`) VALUES ';
    $fADD[] = '("' . $_POST["host"] . '", "' . $_POST["database"] . '", "' . $_POST["user"] . '", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "N", "N", "Y", "Y")';
    $sqladd = @implode(" ", $fADD);
    $sql_delete = "DELETE FROM `db` WHERE \n\t `Host`='{$_POST["host"]}' AND `Db`='{$_POST["database"]}' AND `User`='{$_POST["user"]}'";
    $sql = $sqladd;
    if ($_POST["enable"] == 0) {
        $sql = $sql_delete;
    }
    writelogs("Instance: {$_POST["instance-id"]} user={$_POST["user"]} and host={$_POST["host"]}", __FUNCTION__, __FILE__, __LINE__);
    $q = new mysql();
    if ($_POST["instance-id"] > 0) {
        $q = new mysql_multi($_POST["instance-id"]);
    }
    $q->QUERY_SQL($sql, "mysql");
    if (!$q->ok) {
        writelogs("Instance: {$_POST["instance-id"]} {$q->mysql_error}", __FUNCTION__, __FILE__, __LINE__);
        echo $q->mysql_error;
        return;
    }
    $q->FLUSH_PRIVILEGES();
}