*
*/
$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();
