~josephjamesmills/zpanelcp/zpanelcp

« back to all changes in this revision

Viewing changes to var/www/zpanel/modules/mysql_databases/hooks/OnAfterDeleteClient.hook.php

  • Committer: Joseph Mills
  • Date: 2012-05-09 02:52:32 UTC
  • Revision ID: josephjamesmills@gmail.com-20120509025232-ob5xni0ggrse28c0
setup framwork for www

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
<?php
 
2
 
 
3
        DeleteClientDatabases();
 
4
        
 
5
 
 
6
    function DeleteClientDatabases() {
 
7
                global $zdbh;
 
8
        $sql = "SELECT * FROM x_accounts WHERE ac_deleted_ts IS NOT NULL";
 
9
        $numrows = $zdbh->query($sql);
 
10
        if ($numrows->fetchColumn() <> 0) {
 
11
            $sql = $zdbh->prepare($sql);
 
12
            $sql->execute();
 
13
            while ($rowclient = $sql->fetch()) {
 
14
                                $rowdatabase = $zdbh->query("SELECT * FROM x_mysql_databases WHERE my_acc_fk=" . $rowclient['ac_id_pk'] . " AND my_deleted_ts IS NULL")->fetch();
 
15
                                if ($rowdatabase) {
 
16
                                        try {
 
17
                                                $delete = $zdbh->prepare("DROP DATABASE IF EXISTS `" . $rowdatabase['my_name_vc'] . "`;");
 
18
                                        $delete->execute();
 
19
                                        $delete = $zdbh->prepare("FLUSH PRIVILEGES");
 
20
                                        $delete->execute();
 
21
                                        $delete = $zdbh->prepare("UPDATE x_mysql_databases 
 
22
                                                SET my_deleted_ts = '" . time() . "' 
 
23
                                                WHERE my_acc_fk = '" . $rowclient['ac_id_pk'] . "'");
 
24
                                $delete->execute();
 
25
                                $delete = $zdbh->prepare("DELETE FROM x_mysql_dbmap 
 
26
                                                WHERE mm_database_fk=" . $rowdatabase['my_id_pk'] . "");
 
27
                                $delete->execute();
 
28
                                        } catch (PDOException $e) {
 
29
                                
 
30
                                        }
 
31
                        }
 
32
            }
 
33
        }
 
34
    }
 
35
 
 
36
?>
 
 
b'\\ No newline at end of file'