3
DeleteClientDatabases();
6
function DeleteClientDatabases() {
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);
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();
17
$delete = $zdbh->prepare("DROP DATABASE IF EXISTS `" . $rowdatabase['my_name_vc'] . "`;");
19
$delete = $zdbh->prepare("FLUSH PRIVILEGES");
21
$delete = $zdbh->prepare("UPDATE x_mysql_databases
22
SET my_deleted_ts = '" . time() . "'
23
WHERE my_acc_fk = '" . $rowclient['ac_id_pk'] . "'");
25
$delete = $zdbh->prepare("DELETE FROM x_mysql_dbmap
26
WHERE mm_database_fk=" . $rowdatabase['my_id_pk'] . "");
28
} catch (PDOException $e) {
b'\\ No newline at end of file'