* */ $mailserver_db = ctrl_options::GetSystemOption('mailserver_db'); include 'cnf/db.php'; $z_db_user = $user; $z_db_pass = $pass; try { $mail_db = new db_driver("mysql:host=" . $host . ";dbname=" . $mailserver_db . "", $z_db_user, $z_db_pass); } catch (PDOException $e) { } // Deleting hMail Alias if (!fs_director::CheckForEmptyValue(self::$delete)) { //$result = $mail_db->query("SELECT aliasname FROM hm_aliases WHERE aliasname='" . $rowalias['al_address_vc'] . "'")->Fetch(); $bindArray = NULL; $bindArray = array(':aliasname' => $rowalias['al_address_vc']); $sqlStatment = $mail_db->bindQuery("SELECT aliasname FROM hm_aliases WHERE aliasname=:aliasname", $bindArray); $result = $mail_db->returnRow(); if ($result) { $sqlStatment = "DELETE FROM hm_aliases WHERE aliasname=:aliasname"; $sql = $mail_db->prepare($sqlStatment); $sql->bindParam(':aliasname', $rowalias['al_address_vc']); $sql->execute(); } } // Adding hMail Alias if (!fs_director::CheckForEmptyValue(self::$create)) { //$result = $mail_db->query("SELECT domainid FROM hm_domains WHERE domainname='" . $domain . "'")->Fetch(); $bindArray = NULL; $bindArray = array(':domain' => $domain); $sqlStatment = $mail_db->bindQuery("SELECT domainid FROM hm_domains WHERE domainname=:domain", $bindArray); $result = $mail_db->returnRow();
* */ $mailserver_db = ctrl_options::GetSystemOption('mailserver_db'); include 'cnf/db.php'; $z_db_user = $user; $z_db_pass = $pass; try { $mail_db = new db_driver("mysql:host=" . $host . ";dbname=" . $mailserver_db . "", $z_db_user, $z_db_pass); } catch (PDOException $e) { } // Deleting Postfix Alias if (!fs_director::CheckForEmptyValue(self::$delete)) { //$result = $mail_db->query("SELECT address FROM alias WHERE address='" . $rowalias['al_address_vc'] . "'")->Fetch(); $bindArray = NULL; $bindArray = array(':aliasname' => $rowalias['al_address_vc']); $sqlStatment = $mail_db->bindQuery("SELECT address FROM alias WHERE address=:aliasname", $bindArray); $result = $mail_db->returnRow(); if ($result) { $sqlStatment = "DELETE FROM alias WHERE address=:address"; $sql = $mail_db->prepare($sqlStatment); $sql->bindParam(':address', $rowalias['al_address_vc']); $sql->execute(); } } // Adding Postfix Alias if (!fs_director::CheckForEmptyValue(self::$create)) { //$result = $mail_db->query("SELECT address FROM alias WHERE address='" . $fulladdress . "'")->Fetch(); $bindArray = NULL; $bindArray = array(':address' => $fulladdress); $sqlStatment = $mail_db->bindQuery("SELECT address FROM alias WHERE address=:address", $bindArray); $result = $mail_db->returnRow();