[HowTo]: Backup ausschalten "per Domain" - Neue Version auf Seite 6

[TheCry]

Oki Doki... Ich muss jetzt noch mal kurz weg und dann schau ich mir das Script an.
Aber ich kann Dir jetzt schon mal sagen das dieser Query nicht greifen wird:

Code:

$sql = "
        SELECT
            t1.domain_id,
            t1.domain_name,
            t1.domain_status,
            t1.domain_uid,
            t1.domain_gid,
            t1.allowbackup,
            t2.admin_name,
            t2.email
        FROM
            domain AS t1,
            admin AS t2
        WHERE
                t1.domain_status    = 'ok'
            AND    t1.domain_admin_id    = t2.admin_id
            AND    t1.allowbackup        = 'full'
            OR     t1.allowbackup        = 'domain'
            OR    t1.allowbackup        = 'sql'
        ORDER BY
            t1.domain_id
    ";

Den würde ich einfacher machen

Code:

$sql = "
        SELECT
            t1.domain_id,
            t1.domain_name,
            t1.domain_status,
            t1.domain_uid,
            t1.domain_gid,
            t1.allowbackup,
            t2.admin_name,
            t2.email
        FROM
            domain AS t1,
            admin AS t2
        WHERE
                t1.domain_status    = 'ok'
            AND    t1.domain_admin_id    = t2.admin_id
            AND    t1.allowbackup        != 'no'
        ORDER BY
            t1.domain_id
    ";

Den Rest dann später