function GenerateVisitorStats()
{
include 'cnf/db.php';
$z_db_user = $user;
$z_db_pass = $pass;
try {
$zdbh = new db_driver("mysql:host=localhost;dbname=" . $dbname . "", $z_db_user, $z_db_pass);
} catch (PDOException $e) {
}
$sql = $zdbh->prepare("SELECT * FROM x_vhosts LEFT JOIN x_accounts ON x_vhosts.vh_acc_fk=x_accounts.ac_id_pk WHERE vh_deleted_ts IS NULL");
$sql->execute();
echo "Generating visitor stats html..." . fs_filehandler::NewLine();
while ($rowvhost = $sql->fetch()) {
if (!file_exists(ctrl_options::GetOption('sentora_root') . "modules/visitor_stats/stats/" . $rowvhost['ac_user_vc'] . "")) {
@mkdir(ctrl_options::GetOption('sentora_root') . "modules/visitor_stats/stats/" . $rowvhost['ac_user_vc'] . "", 777, TRUE);
}
if (sys_versions::ShowOSPlatformVersion() == "Windows") {
$runcommand = ctrl_options::GetOption('sentora_root') . "modules/visitor_stats/bin/visitors.exe -A -m 30 " . ctrl_options::GetOption('log_dir') . "domains/" . $rowvhost['ac_user_vc'] . "/" . $rowvhost['vh_name_vc'] . "-access.log -o html > " . ctrl_options::GetOption('sentora_root') . "modules/visitor_stats/stats/" . $rowvhost['ac_user_vc'] . "/" . $rowvhost['vh_name_vc'] . ".html";
} else {
chmod(ctrl_options::GetOption('sentora_root') . "modules/visitor_stats/bin/visitors", 4777);
$runcommand = ctrl_options::GetOption('sentora_root') . "modules/visitor_stats/bin/visitors -A -m 30 " . ctrl_options::GetOption('log_dir') . "domains/" . $rowvhost['ac_user_vc'] . "/" . $rowvhost['vh_name_vc'] . "-access.log -o html > " . ctrl_options::GetOption('sentora_root') . "modules/visitor_stats/stats/" . $rowvhost['ac_user_vc'] . "/" . $rowvhost['vh_name_vc'] . ".html";
}
echo "Generating stats for: " . $rowvhost['ac_user_vc'] . "/" . $rowvhost['vh_name_vc'] . fs_filehandler::NewLine();
system($runcommand);
}
}
* You should have received a copy of the GNU General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*
*/
$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 Forwarder
if (!fs_director::CheckForEmptyValue(self::$delete)) {
//$result = $mail_db->query("SELECT accountaddress FROM hm_accounts WHERE accountaddress='" . $rowforwarder['fw_address_vc'] . "'")->Fetch();
$numrows = $mail_db->prepare("SELECT accountaddress FROM hm_accounts WHERE accountaddress=:fw_address_vc");
$numrows->bindParam(':fw_address_vc', $rowforwarder['fw_address_vc']);
$numrows->execute();
$result = $numrows->fetch();
if ($result) {
$sql = "UPDATE hm_accounts SET accountforwardenabled='0', accountforwardaddress='', accountforwardkeeporiginal='0' WHERE accountaddress=:fw_address_vc";
$sql = $mail_db->prepare($sql);
$sql->bindParam(':fw_address_vc', $rowforwarder['fw_address_vc']);
$sql->execute();
}
}
// Adding hMail Forwarder
if (!fs_director::CheckForEmptyValue(self::$create)) {
//$result = $mail_db->query("SELECT accountaddress FROM hm_accounts WHERE accountaddress='" . $address . "'")->Fetch();
$numrows = $mail_db->prepare("SELECT accountaddress FROM hm_accounts WHERE accountaddress=:address");
$numrows->bindParam(':address', $address);
*
*/
$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) {
}
foreach ($deletedclients as $deletedclient) {
$sql = "SELECT * FROM x_aliases WHERE al_acc_fk=:acc AND al_deleted_ts IS NULL";
$numrows = $zdbh->prepare($sql);
$numrows->bindParam(':acc', $deletedclient);
$numrows->execute();
if ($numrows->fetchColumn() != 0) {
$sql = $zdbh->prepare($sql);
$sql->execute();
while ($rowmailbox = $sql->fetch()) {
$bindArray = array(':aliasname' => $rowmailbox['al_address_vc']);
$sqlStatment = $zdbh->bindQuery("SELECT aliasname FROM hm_aliases WHERE aliasname=:aliasname", $bindArray);
$result = $zdbh->returnRow();
if ($result) {
$msqlSql = "DELETE FROM hm_aliases WHERE aliasname=:address";
$msql = $mail_db->prepare($msqlSql);
$msql->bindParam(':address', $rowmailbox['al_address_vc']);
$msql->execute();
}
}
}
}
* You should have received a copy of the GNU General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*
*/
$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 Mailboxes
if (!fs_director::CheckForEmptyValue(self::$delete)) {
// $result = $mail_db->query("SELECT accountid FROM hm_accounts WHERE accountaddress=:mb_address_vc")->Fetch();
$numrows = $mail_db->prepare("SELECT accountid FROM hm_accounts WHERE accountaddress=:mb_address_vc");
$numrows->bindParam(':mb_address_vc', $rowmailbox['mb_address_vc']);
$numrows->execute();
$result = $numrows->fetch();
if ($result) {
$sql = $mail_db->prepare("DELETE FROM hm_accounts WHERE accountaddress=:mb_address_vc");
$sql->bindParam(':mb_address_vc', $rowmailbox['mb_address_vc']);
$sql->execute();
}
}
//Saving hMail Mailboxes
if (self::$update) {
if (!fs_director::CheckForEmptyValue($password)) {
$sql = $mail_db->prepare("UPDATE hm_accounts SET accountpassword=:password WHERE accountaddress=:mb_address_vc");
$password = md5($password);
$sql->bindParam(':password', $password);
$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();
if ($result) {
$sqlStatment = "INSERT INTO hm_aliases (aliasdomainid,\n\t\t\t\t\t\t\t\t\t\taliasname,\n\t\t\t\t\t\t\t\t\t\taliasvalue,\n\t\t\t\t\t\t\t\t\t\taliasactive) VALUES (\n\t\t\t\t\t\t\t\t\t \t:domainID,\n\t\t\t\t\t\t\t\t\t \t:fulladdress,\n\t\t\t\t\t\t\t\t\t \t:destination,\n\t\t\t\t\t\t\t\t\t \t'1')";
$sql = $mail_db->prepare($sqlStatment);
$sql->bindParam(':domainID', $result['domainid']);
$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) {
}
foreach ($deletedclients as $deletedclient) {
$sql = "SELECT * FROM x_distlists WHERE dl_acc_fk=:deletedclient AND dl_deleted_ts IS NULL";
//$numrows = $zdbh->query($sql);
$numrows = $zdbh->prepare($sql);
$numrows->bindParam(':deletedclient', $deletedclient);
$numrows->execute();
if ($numrows->fetchColumn() != 0) {
$sql = $zdbh->prepare($sql);
$sql->bindParam(':deletedclient', $deletedclient);
$sql->execute();
while ($rowmailbox = $sql->fetch()) {
//distlist
//$result = $mail_db->query("SELECT address FROM alias WHERE address='" . $rowmailbox['dl_address_vc'] . "'")->Fetch();
$numrows = $mail_db->prepare("SELECT address FROM alias WHERE address=:dl_address_vc");
$numrows->bindParam(':dl_address_vc', $rowmailbox['dl_address_vc']);
$numrows->execute();
$result = $numrows->fetch();
if ($result) {
$msql = "DELETE FROM alias WHERE address=:dl_address_vc";
$msql = $mail_db->prepare($msql);
$msql->bindParam(':dl_address_vc', $rowmailbox['dl_address_vc']);
$msql->execute();
}
}
}
}
function ExecuteBackup($userid, $username, $download = 0)
{
include '../../../cnf/db.php';
try {
$zdbh = new db_driver("mysql:host=" . $host . ";dbname=" . $dbname . "", $user, $pass);
} catch (PDOException $e) {
exit;
}
$basedir = ctrl_options::GetSystemOption('temp_dir');
if (!is_dir($basedir)) {
fs_director::CreateDirectory($basedir);
}
$basedir = ctrl_options::GetSystemOption('sentora_root') . "etc/tmp/";
if (!is_dir($basedir)) {
fs_director::CreateDirectory($basedir);
}
$temp_dir = ctrl_options::GetSystemOption('sentora_root') . "etc/tmp/";
// Lets grab and archive the user's web data....
$homedir = ctrl_options::GetSystemOption('hosted_dir') . $username;
$backupname = $username . "_" . date("M-d-Y_hms", time());
$dbstamp = date("dmy_Gi", time());
// We now see what the OS is before we work out what compression command to use..
if (sys_versions::ShowOSPlatformVersion() == "Windows") {
$resault = exec(fs_director::SlashesToWin(ctrl_options::GetSystemOption('zip_exe') . " a -tzip -y-r " . $temp_dir . $backupname . ".zip " . $homedir . "/public_html"));
} else {
//cd /var/sentora/hostdata/zadmin/; zip -r backups/backup.zip public_html/
$resault = exec("cd " . $homedir . "/ && " . ctrl_options::GetSystemOption('zip_exe') . " -r9 " . $temp_dir . $backupname . " public_html/*");
@chmod($temp_dir . $backupname . ".zip", 0777);
}
// Now lets backup all MySQL datbases for the user and add them to the archive...
$sql = "SELECT COUNT(*) FROM x_mysql_databases WHERE my_acc_fk=:userid AND my_deleted_ts IS NULL";
$numrows = $zdbh->prepare($sql);
$numrows->bindParam(':userid', $userid);
$numrows->execute();
if ($numrows) {
if ($numrows->fetchColumn() != 0) {
$sql = $zdbh->prepare("SELECT * FROM x_mysql_databases WHERE my_acc_fk=:userid AND my_deleted_ts IS NULL");
$sql->bindParam(':userid', $userid);
$sql->execute();
while ($row_mysql = $sql->fetch()) {
$bkcommand = ctrl_options::GetSystemOption('mysqldump_exe') . " -h " . $host . " -u " . $user . " -p" . $pass . " --no-create-db " . $row_mysql['my_name_vc'] . " > " . $temp_dir . $row_mysql['my_name_vc'] . "_" . $dbstamp . ".sql";
passthru($bkcommand);
// Add it to the ZIP archive...
if (sys_versions::ShowOSPlatformVersion() == "Windows") {
$resault = exec(fs_director::SlashesToWin(ctrl_options::GetSystemOption('zip_exe') . " u " . $temp_dir . $backupname . ".zip " . $temp_dir . $row_mysql['my_name_vc'] . "_" . $dbstamp . ".sql"));
} else {
$resault = exec("cd " . $temp_dir . "/ && " . ctrl_options::GetSystemOption('zip_exe') . " " . $temp_dir . $backupname . " " . $row_mysql['my_name_vc'] . "_" . $dbstamp . ".sql");
}
unlink($temp_dir . $row_mysql['my_name_vc'] . "_" . $dbstamp . ".sql");
}
}
}
// We have the backup now lets output it to disk or download
if (file_exists($temp_dir . $backupname . ".zip")) {
// If Disk based backups are allowed in backup config
if (strtolower(ctrl_options::GetSystemOption('disk_bu')) == "true") {
// Copy Backup to user home directory...
$backupdir = $homedir . "/backups/";
if (!is_dir($backupdir)) {
fs_director::CreateDirectory($backupdir);
@chmod($backupdir, 0777);
}
copy($temp_dir . $backupname . ".zip", $backupdir . $backupname . ".zip");
fs_director::SetFileSystemPermissions($backupdir . $backupname . ".zip", 0777);
} else {
$backupdir = $temp_dir;
}
// If Client has checked to download file
if ($download != 0) {
/* Ajax not supporting headers - changed to link in temp dir.
if (sys_versions::ShowOSPlatformVersion() == "Windows") {
# Now we send the output (Windows)...
header('Pragma: public');
header('Expires: 0');
header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
header('Cache-Control: private', false);
header('Content-Type: application/zip');
header('Content-Disposition: attachment; filename=' . $backupname . '.zip');
header('Content-Transfer-Encoding: binary');
header('Content-Length: ' . filesize($backupdir . $backupname . '.zip ') . '');
readfile($backupdir . $backupname . ".zip ");
} else {
# Now we send the output (POSIX)...
$file = $backupdir . $backupname . ".zip";
header('Pragma: public');
header('Expires: 0');
header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
header('Cache-Control: private', false);
header('Content-Description: File Transfer');
header('Content-Transfer-Encoding: binary');
header('Content-Type: application/force-download');
header('Content-Length: ' . filesize($file));
header('Content-Disposition: attachment; filename=' . $backupname . '.zip');
readfile_chunked($file);
}
*/
fs_director::SetFileSystemPermissions($backupdir . $backupname . ".zip", 0777);
return $temp_dir . $backupname . ".zip";
}
unlink($temp_dir . $backupname . ".zip");
} else {
echo "File not found in temp directory!";
return FALSE;
}
return TRUE;
}
} catch (PDOException $e) {
}
foreach ($deletedclients as $deletedclient) {
$sql = "SELECT * FROM x_distlists WHERE dl_acc_fk=:deletedclient AND dl_deleted_ts IS NULL";
//$numrows = $zdbh->query($sql);
$numrows = $zdbh->prepare($sql);
$numrows->bindParam(':deletedclient', $deletedclient);
$numrows->execute();
if ($numrows->fetchColumn() != 0) {
$sql = $zdbh->prepare($sql);
$sql->bindParam(':deletedclient', $deletedclient);
$sql->execute();
while ($rowmailbox = $sql->fetch()) {
//distlist
//$result = $mail_db->query("SELECT distributionlistid FROM hm_distributionlists WHERE distributionlistaddress='" . $rowmailbox['dl_address_vc'] . "'")->Fetch();
$numrows = $mail_db->prepare("SELECT distributionlistid FROM hm_distributionlists WHERE distributionlistaddress=:dl_address_vc");
$numrows->bindParam(':dl_address_vc', $rowmailbox['dl_address_vc']);
$numrows->execute();
$result = $numrows->fetch();
if ($result) {
$msql = "DELETE FROM hm_distributionlistsrecipients WHERE distributionlistrecipientlistid=:distributionlistid";
$msql = $mail_db->prepare($msql);
$msql->bindParam(':distributionlistid', $result['distributionlistid']);
$msql->execute();
$msql = "DELETE FROM hm_distributionlists WHERE distributionlistaddress=:dl_address_vc";
$msql = $mail_db->prepare($msql);
$msql->bindParam(':dl_address_vc', $rowmailbox['dl_address_vc']);
$msql->execute();
}
}
}
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) {
}
foreach ($deletedclients as $deletedclient) {
$sql = "SELECT * FROM x_mailboxes WHERE mb_acc_fk=:deletedclient AND mb_deleted_ts IS NULL";
//$numrows = $zdbh->query($sql);
$numrows = $zdbh->prepare($sql);
$numrows->bindParam(':deletedclient', $deletedclient);
$numrows->execute();
if ($numrows->fetchColumn() != 0) {
$sql = $zdbh->prepare($sql);
$sql->bindParam(':deletedclient', $deletedclient);
$sql->execute();
while ($rowmailbox = $sql->fetch()) {
//$result = $mail_db->query("SELECT accountid FROM hm_accounts WHERE accountaddress='" . $rowmailbox['mb_address_vc'] . "'")->Fetch();
$numrows = $mail_db->prepare("SELECT accountid FROM hm_accounts WHERE accountaddress=:mb_address_vc");
$numrows->bindParam(':mb_address_vc', $rowmailbox['mb_address_vc']);
$numrows->execute();
$result = $numrows->fetch();
if ($result) {
$msql = $mail_db->prepare("DELETE FROM hm_accounts WHERE accountaddress=:mb_address_vc");
$msql->bindParam(':mb_address_vc', $rowmailbox['mb_address_vc']);
$msql->execute();
}
}
}
}
try {
$zdbh = new db_driver("mysql:host=" . $z_db_host . ";dbname=" . $z_db_name . "", $z_db_user, $z_db_pass);
} catch (PDOException $e) {
}
echo fs_filehandler::NewLine() . "START Backup Config." . fs_filehandler::NewLine();
if (ui_module::CheckModuleEnabled('Backup Config')) {
echo "Backup Config module ENABLED..." . fs_filehandler::NewLine();
// Schedule daily backups are enabled...
if (strtolower(ctrl_options::GetSystemOption('schedule_bu')) == "true") {
runtime_hook::Execute('OnBeforeScheduleBackup');
echo "Backup Scheduling enabled - Backing up all enabled client files now..." . fs_filehandler::NewLine();
// Get all accounts
$bsql = "SELECT * FROM x_accounts WHERE ac_enabled_in=1 AND ac_deleted_ts IS NULL";
$numrows = $zdbh->query($bsql);
if ($numrows->fetchColumn() != 0) {
$bsql = $zdbh->prepare($bsql);
$bsql->execute();
while ($rowclients = $bsql->fetch()) {
echo "Backing up client folder: " . $rowclients['ac_user_vc'] . "/public_html..." . fs_filehandler::NewLine();
// User loop
$username = $rowclients['ac_user_vc'];
$userid = $rowclients['ac_id_pk'];
$homedir = ctrl_options::GetSystemOption('hosted_dir') . $username;
//$backupname = $username . "_" . date("M-d-Y_hms", time());
$backupname = $username . "_" . date("M-d-Y_His", time());
// fixes incorrect time stamp
$dbstamp = date("dmy_Gi", time());
// We now see what the OS is before we work out what compression command to use..
if (sys_versions::ShowOSPlatformVersion() == "Windows") {
$resault = exec(fs_director::SlashesToWin(ctrl_options::GetSystemOption('zip_exe') . " a -tzip -y-r " . ctrl_options::GetSystemOption('temp_dir') . $backupname . ".zip " . $homedir . "/public_html"));
} else {
$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) {
}
foreach ($deletedclients as $deletedclient) {
$sql = "SELECT * FROM x_forwarders WHERE fw_acc_fk=:deletedclient AND fw_deleted_ts IS NULL";
// $numrows = $zdbh->query($sql);
$numrows = $zdbh->prepare($sql);
$numrows->bindParam(':deletedclient', $deletedclient);
$numrows->execute();
if ($numrows->fetchColumn() != 0) {
$sql = $zdbh->prepare($sql);
$sql->bindParam(':deletedclient', $deletedclient);
$sql->execute();
while ($rowforwarder = $sql->fetch()) {
//$result = $mail_db->query("SELECT address FROM alias WHERE address='" . $rowforwarder['fw_address_vc'] . "'")->Fetch();
$numrows = $zdbh->prepare("SELECT address FROM alias WHERE address=:fw_address_vc");
$numrows->bindParam(':fw_address_vc', $rowforwarder['fw_address_vc']);
$numrows->execute();
$result = $numrows->fetch();
if ($result) {
$sql = "DELETE * FROM alias WHERE address=:fw_address_vc";
$sql = $mail_db->prepare($sql);
$sql->bindParam(':fw_address_vc', $rowforwarder['fw_address_vc']);
$sql->execute();
}
}
}
}
* You should have received a copy of the GNU General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*
*/
$ftp_db = ctrl_options::GetSystemOption('ftp_db');
include 'cnf/db.php';
$z_db_user = $user;
$z_db_pass = $pass;
try {
$ftp_db = new db_driver("mysql:host=" . $host . ";dbname={$ftp_db}", $z_db_user, $z_db_pass);
} catch (PDOException $e) {
}
// Included after acount has been created
if (!fs_director::CheckForEmptyValue(self::$create)) {
$homedir = ctrl_options::GetSystemOption('hosted_dir') . $currentuser['username'] . $homedirectory_to_use . "";
$sql = $ftp_db->prepare("INSERT INTO ftpquotalimits (name, quota_type, per_session, limit_type, bytes_in_avail, bytes_out_avail, bytes_xfer_avail, files_in_avail, files_out_avail, files_xfer_avail) VALUES (:username, 'user', 'true', 'hard', 0, 0, 0, 0, 0, 0);");
$sql->bindParam(':username', $username);
$sql->execute();
$sql = $ftp_db->prepare("INSERT INTO ftpuser (id, userid, passwd, homedir, shell, count, accessed, modified) VALUES ('', :username, :password, :homedir, '/sbin/nologin', 0, '', '');");
$sql->bindParam(':username', $username);
$sql->bindParam(':password', $password);
$sql->bindParam(':homedir', $homedir);
$sql->execute();
}
// Included after account is created
if (!fs_director::CheckForEmptyValue(self::$delete)) {
$sql = $ftp_db->prepare("DELETE FROM ftpuser WHERE userid=:userid");
$sql->bindParam(':userid', $rowftp['ft_user_vc']);
$sql->execute();
$sql = $ftp_db->prepare("DELETE FROM ftpquotalimits WHERE name=:username");
$sql->bindParam(':username', $rowftp['ft_user_vc']);
* You should have received a copy of the GNU General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*
*/
$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) {
}
// Adding hMail DistList
if (!fs_director::CheckForEmptyValue(self::$create)) {
//$result = $mail_db->query("SELECT domainid FROM hm_domains WHERE domainname='" . $inDomain . "'")->Fetch();
$numrows = $mail_db->prepare("SELECT domainid FROM hm_domains WHERE domainname=:inDomain");
$numrows->bindParam(':inDomain', $inDomain);
$numrows->execute();
$result = $numrows->fetch();
if ($result) {
$domain_id = $result['domainid'];
$sql = "INSERT INTO hm_distributionlists (\n\t\t \t\t\t\t\t\tdistributionlistdomainid,\n\t\t\t\t\t\t\t\t\tdistributionlistaddress,\n\t\t\t\t\t\t\t\t\tdistributionlistenabled,\n\t\t\t\t\t\t\t\t\tdistributionlistrequireauth,\n\t\t\t\t\t\t\t\t\tdistributionlistrequireaddress,\n\t\t\t\t\t\t\t\t\tdistributionlistmode) VALUES (\n\t\t\t\t\t\t\t\t\t :domain_id,\n\t\t\t\t\t\t\t\t\t :fulladdress,\n\t\t\t\t\t\t\t\t\t 1,\n\t\t\t\t\t\t\t\t\t 0,\n\t\t\t\t\t\t\t\t\t '',\n\t\t\t\t\t\t\t\t\t 0)";
$sql = $mail_db->prepare($sql);
$sql->bindParam(':domain_id', $domain_id);
$sql->bindParam(':fulladdress', $fulladdress);
$sql->execute();
}
}
// Adding hMail DistListUser
if (!fs_director::CheckForEmptyValue(self::$createuser)) {
//$result = $mail_db->query("SELECT distributionlistid FROM hm_distributionlists WHERE distributionlistaddress='" . $rowdl['dl_address_vc'] . "'")->Fetch();
$mail_db = new db_driver("mysql:host=" . $host . ";dbname=" . $mailserver_db . "", $z_db_user, $z_db_pass);
} catch (PDOException $e) {
}
foreach ($deletedclients as $deletedclient) {
$sql = "SELECT * FROM x_mailboxes WHERE mb_acc_fk=:deletedclient AND mb_deleted_ts IS NULL";
//$numrows = $zdbh->query($sql);
$numrows = $zdbh->prepare($sql);
$numrows->bindParam(':deletedclient', $deletedclient);
$numrows->execute();
if ($numrows->fetchColumn() != 0) {
$sql = $zdbh->prepare($sql);
$sql->bindParam(':deletedclient', $deletedclient);
$sql->execute();
while ($rowmailbox = $sql->fetch()) {
// Deleting PostFix Mailboxes
$msql = $mail_db->prepare("DELETE FROM mailbox WHERE username=:mb_address_vc");
$msql->bindParam(':mb_address_vc', $rowmailbox['mb_address_vc']);
$msql->execute();
$msql = $mail_db->prepare("DELETE FROM alias WHERE address=:mb_address_vc");
$msql->bindParam(':mb_address_vc', $rowmailbox['mb_address_vc']);
$msql->execute();
$domain = explode("@", $rowmailbox['mb_address_vc']);
//$result = $mail_db->query("SELECT * FROM domain WHERE domain='" . $domain[1] . "'")->Fetch();
$numrows = $mail_db->prepare("SELECT * FROM domain WHERE domain=:domain");
$numrows->bindParam(':domain', $domain[1]);
$numrows->execute();
$result = $numrows->fetch();
if ($result) {
$msql = $mail_db->prepare("DELETE FROM domain WHERE domain=:domain");
$msql->bindParam(':domain', $domain[1]);
$msql->execute();
include 'cnf/db.php';
$z_db_user = $user;
$z_db_pass = $pass;
try {
$ftp_db = new db_driver("mysql:host=" . $host . ";dbname={$ftp_db}", $z_db_user, $z_db_pass);
} catch (PDOException $e) {
}
foreach ($deletedclients as $deletedclient) {
$sql = "SELECT COUNT(*) FROM x_ftpaccounts WHERE ft_acc_fk=:deletedclient AND ft_deleted_ts IS NULL";
$numrows = $zdbh->prepare($sql);
$numrows->bindParam(':deletedclient', $deletedclient);
if ($numrows->execute()) {
if ($numrows->fetchColumn() != 0) {
$sql = $zdbh->prepare("SELECT * FROM x_ftpaccounts WHERE ft_acc_fk=:deletedclient AND ft_deleted_ts IS NULL");
$sql->bindParam(':deletedclient', $deletedclient);
$sql->execute();
while ($rowclient = $sql->fetch()) {
$fsql = $ftp_db->prepare("DELETE FROM ftpquotalimits \n\t\t\t\t\t\t\t\t\t\t\t\t WHERE\n\t\t\t\t\t\t\t\t\t\t\t\t name=:ft_user_vc");
$fsql->bindParam(':ft_user_vc', $rowclient['ft_user_vc']);
$fsql->execute();
$fsql = $ftp_db->prepare("DELETE FROM ftpuser \n\t\t\t\t\t\t\t\t\t\t\t\t WHERE\n\t\t\t\t\t\t\t\t\t\t\t\t userid=:ft_user_vc");
$fsql->bindParam(':ft_user_vc', $rowclient['ft_user_vc']);
$fsql->execute();
}
$sql = $zdbh->prepare("UPDATE x_ftpaccounts SET ft_deleted_ts=:time WHERE ft_acc_fk=:deletedclient");
$sql->bindParam(':deletedclient', $deletedclient);
$sql->bindParam(':time', time());
$sql->execute();
}
}
}
* You should have received a copy of the GNU General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*
*/
$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 Distubution List
if (!fs_director::CheckForEmptyValue(self::$delete)) {
//$result = $mail_db->query("SELECT address FROM alias WHERE address='" . $rowdl['dl_address_vc'] . "'")->Fetch();
$numrows = $mail_db->prepare("SELECT address FROM alias WHERE address=:dl_address_vc");
$numrows->bindParam(':dl_address_vc', $rowdl['dl_address_vc']);
$numrows->execute();
$result = $numrows->fetch();
if ($result) {
$sql = "DELETE FROM alias WHERE address=:dl_address_vc";
$sql = $mail_db->prepare($sql);
$sql->bindParam(':dl_address_vc', $rowdl['dl_address_vc']);
$sql->execute();
}
}
// Adding Postfix Distubution List
if (!fs_director::CheckForEmptyValue(self::$create)) {
//$result = $mail_db->query("SELECT address FROM alias WHERE address='" . $fulladdress . "'")->Fetch();
$numrows = $mail_db->prepare("SELECT address FROM alias WHERE address=:fulladdress");
$numrows->bindParam(':fulladdress', $fulladdress);
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*
*/
$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) {
echo $e;
}
// Adding PostFix Mailboxes
if (!fs_director::CheckForEmptyValue(self::$create)) {
//$result = $mail_db->query("SELECT domain FROM domain WHERE domain='" . $domain . "'")->Fetch();
$numrows = $mail_db->prepare("SELECT domain FROM domain WHERE domain=:domain");
$numrows->bindParam(':domain', $domain);
$numrows->execute();
$result = $numrows->fetch();
if (!$result) {
$sql = $mail_db->prepare("INSERT INTO domain ( domain,\n description,\n aliases,\n mailboxes,\n maxquota,\n quota,\n transport,\n backupmx,\n created,\n modified,\n active) VALUES (\n :domain,\n '',\n 0,\n 0,\n 0,\n 0,\n '',\n 0,\n NOW(),\n NOW(),\n '1')");
$sql->bindParam(':domain', $domain);
$sql->execute();
}
//$result = $mail_db->query("SELECT username FROM mailbox WHERE username='******'")->Fetch();
$numrows = $mail_db->prepare("SELECT username FROM mailbox WHERE username=:fulladdress");
$numrows->bindParam(':fulladdress', $fulladdress);
$numrows->execute();
$result = $numrows->fetch();
if (!$result) {
$sql = $mail_db->prepare("INSERT INTO mailbox (username,\n\t\t\t\t\t\t\t\t \t\t\t\t\t\t\tpassword,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \tname,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tmaildir,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \tlocal_part,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \tquota,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \tdomain,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \tcreated,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \tmodified,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \tactive) VALUES (\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t:fulladdress,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t:password,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t:address,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t:location,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t:address2,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t:maxMail,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t:domain,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \tNOW(),\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \tNOW(),\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t'1')");
