~NAXC~

File Content: `DovecotConfSSLSetup.php`

<?php
$DoveCotConf = new DoveCotConfSSLSetup;
$email = "support@hostingraja.info";
$checkDoveCotConf = $DoveCotConf->checkDoveCotConf($email); 
echo $checkDoveCotConf."\n";
class DoveCotConfSSLSetup
{
	private $HRPanelAISALib;
	private $HRPanelssl;
	private $domain_lists;
	private $privkey_list;
	private $hostname;
	private $hostdomainname;
	private $dovecotConfFilePath;
	private $zdbh;
	public function __construct()
	{
		error_reporting(0);
		require('/etc/sentora/panel/cnf/db.php');
		include('/etc/sentora/panel/dryden/db/driver.class.php');
		include('/etc/sentora/panel/dryden/debug/logger.class.php');
		include('/etc/sentora/panel/dryden/runtime/dataobject.class.php');
		include('/etc/sentora/panel/dryden/runtime/hook.class.php');
		include('/etc/sentora/panel/dryden/sys/versions.class.php');
		include('/etc/sentora/panel/dryden/ctrl/options.class.php');
		include('/etc/sentora/panel/dryden/fs/director.class.php');
		include('/etc/sentora/panel/dryden/fs/filehandler.class.php');
		include('/etc/sentora/panel/inc/dbc.inc.php');
		try 
		{
			//$this->zdbh = new db_driver("mysql:host=" . $host . ";dbname=" . $dbname . "", $user, $pass);
			$dsn = "mysql:dbname=$dbname;$ovi_socket_path";
			$this->zdbh = new db_driver($dsn, $user, $pass, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'utf8'"));
			$this->zdbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
		}
		catch (PDOException $e) 
		{
		    // exit();
		}

		require_once("/etc/sentora/panel/class/HRPanel_AISA_Lib.php");
		require_once("/etc/sentora/panel/class/Error_Codes.php");
        $this->HRPanelAISALib = new HRPanelAISALib();
		
		// require_once("/root/scripts/aisa/class/HRPanelssl.php");
		// $this->HRPanelssl = new HRPanelssl();
		$this->getHostname();
		$this->dovecotConfFilePath = "/etc/dovecot/dovecot.conf";
	}
	
	public function checkDoveCotConf($email)
	{
		$filename = $this->dovecotConfFilePath;
		$smtp_ssl = trim(shell_exec("grep -ni 'ssl = yes' $filename"));
		if($smtp_ssl)
		{
			// Checking SSL cert Key and CA is already instered or not.
			$check_ssl_cert_key_ca = $this->CheckSSLCertKeyCA();
	        if($check_ssl_cert_key_ca == false)
    	    {
				$return = $this->removeSSLCertKeyCA();
				$return = $this->CheckHostNameAndDoEverything($smtp_ssl, $email);
				if($return == DOMAIN_NAMESERVER_IS_NOT_POINT_WITH_US)
				{
					$return = $this->ChangeSSLtoNo();
				}		
			}
			else
			{
				$return = $this->removeSSLCertKeyCA();
                $return = $this->CheckHostNameAndDoEverything($smtp_ssl, $email);
				if($return == DOMAIN_NAMESERVER_IS_NOT_POINT_WITH_US)
				{
					$return = $this->ChangeSSLtoNo();
				}
			}
		}
		else
		{
			// SSL has been set as no, so checking SSL cert, key and CA has been added or not.
			echo "SSL has been set as no, so checking SSL cert, key and CA has been added or not. \n";
			$check_ssl_cert_key_ca = $this->CheckSSLCertKeyCA();
			$smtp_ssl = trim(shell_exec("grep -ni 'ssl = no' $filename"));		
			$return = $this->removeSSLCertKeyCA();
			if($check_ssl_cert_key_ca)
			{
				echo "SSL certificate is there so checking it and regenerating if wrong \n ";
                $return = $this->CheckHostNameAndDoEverything($smtp_ssl, $email);
				if($return == DOMAIN_NAMESERVER_IS_NOT_POINT_WITH_US)
				{
					$return = DOMAIN_NAMESERVER_IS_NOT_POINT_WITH_US;
				}
				else if($return == DOVECOT_CONF_SETUP_SUCCESSFULLY)
				{
					$return = $this->ChangeSSLtoYes();
				}
			}
			else
			{
				echo "SSL certificate is not there so generating it \n ";
				$return = $this->CheckHostNameAndDoEverything($smtp_ssl, $email);
				if($return == DOMAIN_NAMESERVER_IS_NOT_POINT_WITH_US)
                {
                    $return = DOMAIN_NAMESERVER_IS_NOT_POINT_WITH_US;
                }
                else if($return == DOVECOT_CONF_SETUP_SUCCESSFULLY)
                {
                    $return = $this->ChangeSSLtoYes();
                }
			}
		}
		// return $return;
		$cmd="whereis hostname | awk '{print $2}'";
$server_hostname=trim(shell_exec(trim(shell_exec($cmd),"\n")));
$result = dns_get_record($server_hostname, DNS_A);
$priv_ip=trim(shell_exec("ifconfig | grep -Eo 'inet (addr:)?([0-9]*\.){3}[0-9]*' | grep -Eo '([0-9]*\.){3}[0-9]*' | grep -v '127.0.0.1'"));
require('/etc/sentora/panel/cnf/db.php');
        $servername = $host;
        $username = $user;
        $password = $pass;
        $dbname="sentora_core";
        $ip="";
        $domain_name_list="";
        // Create connection
        $conn = new mysqli($servername, $username, $password, $dbname);
        // Check connection
        if ($conn->connect_error) {
                //die("Connection failed: " . $conn->connect_error);
                $ip=shell_exec("ifconfig | grep -Eo 'inet (addr:)?([0-9]*\.){3}[0-9]*' | grep -Eo '([0-9]*\.){3}[0-9]*' | grep -v '127.0.0.1'");
                $domain_name_list="N_A";
        }else 
        {
                $sql = "select so_value_tx from x_settings where so_name_vc='server_ip'";
                $conn_query=$conn->query($sql);
                $getID = $conn_query->fetch_assoc();
                $ip = $getID['so_value_tx'];
                $domain_sql="select vh_name_vc from x_vhosts where vh_deleted_ts IS NULL";
                $domain_conn_query=$conn->query($domain_sql);
                while($get_domain_name = $domain_conn_query->fetch_assoc())
                $domain_name_list.=$get_domain_name['vh_name_vc'].";";
        }
//print_r($result);
$FULLY_DONE="COMPLETED";
if(count($result)>0)
{
        $get_Result = $result[0];
$get_Result['ip'];
        $HOSTNAME_POINTED="NOT_POINTED";
        if( trim($get_Result['ip']) == trim($ip) ||  trim($get_Result['ip'])==trim($priv_ip))
        {
                $HOSTNAME_POINTED="H_POINTED";
        }
        else
        {
                 $FULLY_DONE="IN_PROGRESS";
        }
}
else
{
        $HOSTNAME_POINTED="NOT_POINTED";   
        $FULLY_DONE="IN_PROGRESS";
}
$data = array('action' => 'UPDATE_A_RECORD', 'ip' => trim($ip),'server_hostname'=>$server_hostname,'HOSTNAME_POINTED' => $HOSTNAME_POINTED,'domain_name_list' => $domain_name_list,'return_output' => $return);
$url="http://hostingraja.info/getserverdetails_SSL_TLS_record.php";
$handle = curl_init($url);
curl_setopt($handle, CURLOPT_POST, true);
curl_setopt($handle, CURLOPT_POSTFIELDS, $data);
curl_exec($handle);
	}

	public function ChangeSSLtoYes($smtp_ssl)
	{
		$filename = $this->dovecotConfFilePath;
		$smtp_ssl = trim(shell_exec("grep -ni 'ssl = no' $filename"));
		$ssl_line = explode(":",$smtp_ssl);
        $ssl_line = $ssl_line[0];
		$cmd_to_replace = "sed -i '".$ssl_line."s/.*/ssl = yes/' $filename";
	    echo $cmd_to_replace."\n";
	    shell_exec($cmd_to_replace);
		return DOVECOT_CONF_SETUP_SUCCESSFULLY;
	}
	
	public function ChangeSSLtoNo($smtp_ssl)
	{
		$filename = $this->dovecotConfFilePath;
		$smtp_ssl = trim(shell_exec("grep -ni 'ssl = yes' $filename"));
		$ssl_line = explode(":",$smtp_ssl);
        $ssl_line = $ssl_line[0];
		$cmd_to_replace = "sed -i '".$ssl_line."s/.*/ssl = no/' $filename";
	    echo $cmd_to_replace."\n";
	    shell_exec($cmd_to_replace);
		return SSL_HAS_BEEN_CHANGED_TO_BECAUSE_NAMESERVER_IS_NOT_POINT_WITH_US;
	}

	public function CheckHostNameAndDoEverything($smtp_ssl, $email)
	{
		// SSL cert Key and CA is not there so checking HostName A record is pointing with us or not.
		$hostnameArecord =  $this->checkHostNameARecord();
		if($hostnameArecord == false)
		{
			// HostName A record is not pointing with us. So checking Host Domain Name is pointing with us.
			$checkHostDomainName = $this->checkHostDomainNameNSisPointWithUs();
			if($checkHostDomainName == true)
			{
				// Host Domain Name is poiinting with us so pointing hostname also with us.
				echo "// Host Domain Name is poiinting with us so pointing hostname also with us.\n";
				$point_hostname_here = $this->PointHostName();
				if($point_hostname_here == DOMAIN_NAME_CREATED || $point_hostname_here == DOMAIN_ALREADY_ADDED)
				{	
					// Checking SSL is installed for Hostname or not. If not installed it will install.
					$check_ssl = false;
					$CheckSSLAndInstall = $this->CheckSSLAndInstall($email, $check_ssl);
					if($CheckSSLAndInstall)
					{
						// After Check SSL installation, Adding SSL cert, key and CA in dovecot.conf
 						$return_add_ssl_cert_key_ca = $this->AddSSLCertKeyCA($smtp_ssl, $n=0);
						if($return_add_ssl_cert_key_ca == true)
		                {
    		                $return = DOVECOT_CONF_SETUP_SUCCESSFULLY;
        		        }
            		    else
                		{
							echo "Dovecot conf failed because SSL domain not in /var/log/letsencrypt/sslrenew.log \n";
	                    	$return = DOVECOT_CONF_SETUP_FAILED_HOSTNAME_DOES_NOT_EXISTS_IN_SSL_DOMAIN_LIST;
		                }
					}
				}
				else
				{
					$return = $point_hostname_here;
				}
			}
			else
			{
				$return = DOMAIN_NAMESERVER_IS_NOT_POINT_WITH_US;
			}
		}
		else
		{
			// Hostname A record is point with us. So Checking SSL is installed for Hostname or not. If not installed it will install.
			echo "Hostname A record is point with us. So Checking SSL is installed for Hostname or not. If not installed it will install. \n";
			$check_ssl = true;
			$CheckSSLAndInstall = $this->CheckSSLAndInstall($email, $check_ssl);
			if($CheckSSLAndInstall)
			{
				// After Check SSL installation, Adding SSL cert, key and CA in dovecot.conf
				$return_add_ssl_cert_key_ca = $this->AddSSLCertKeyCA($smtp_ssl, $n=0);
				if($return_add_ssl_cert_key_ca == true)
				{
					$return = DOVECOT_CONF_SETUP_SUCCESSFULLY;
				}
				else
				{
					echo "Dovecot conf failed because SSL domain not in /var/log/letsencrypt/sslrenew.log \n";
					$return = DOVECOT_CONF_SETUP_FAILED_HOSTNAME_DOES_NOT_EXISTS_IN_SSL_DOMAIN_LIST;
				}
			}
		}
		return $return;
	}

	public function AddSSLCertKeyCA($smtp_ssl, $n)
	{
		echo "AddSSLCertKeyCA $n time \n";
		$this->GetPrivateKeys();	
		$filename = $this->dovecotConfFilePath; 
		$ssl_line = explode(":",$smtp_ssl);
        $ssl_line = $ssl_line[0];
        $ssl_one = $ssl_line + 1;
        $ssl_two = $ssl_line + 2;
        $ssl_three = $ssl_line + 3;
        $ssl_four = $ssl_line + 4;
        $ssl_five = $ssl_line + 5;
        $ssl_six = $ssl_line[0];
        $ssl_seven = $ssl_line + 1;
        $ssl_eight = $ssl_line + 2;
		#echo "smtp_ssl: $smtp_ssl\nssl_line: $ssl_line\nssl_one: $ssl_one\nssl_two: $ssl_two";
		$port_domain = $this->hostname;
		$domain_lists = $this->domain_lists;
		if(in_array(trim($port_domain) ,$domain_lists) ) 
		{
			$get_key = array_search($port_domain,$domain_lists);
            $key_path = $this->privkey_list[$get_key];
			$sql = $this->zdbh->prepare("SELECT * FROM x_ssl WHERE ssl_status='1' AND ssl_delete is NULL");
			$sql->execute();
			if ($sql->rowCount()) 
			{
				while($rows = $sql->fetch())
				{
					//echo "\nsmtp_ssl: $smtp_ssl\nssl_line: $ssl_line\nssl_one: $ssl_one\nssl_two: $ssl_two\nssl_three: $ssl_three\nssl_four: $ssl_four\nssl_five: $ssl_five";
					$domain_name = $rows['ssl_doamin'];
					if($domain_name != $key_path) 
					{
					//echo "grep -ni 'local_name ".$domain_name."' $filename";exit;
					//$added_check = trim(shell_exec("grep -ni 'local_name ".$domain_name."' $filename"));
					//$added_check = trim(shell_exec("grep -ni 'local_name ".$domain_name."' $filename | awk '{ print $1}' | cut -c1"));
					//echo "\nadded_check:$added_check-";
					//if (!$added_check || $added_check=="") 
					//{
						//echo "Adding localDoamins";
						shell_exec("sed -i '".$ssl_line."a local_name ".$domain_name." {' $filename");
						shell_exec("sed -i '".$ssl_one."a ssl_cert = </etc/letsencrypt/live/".$domain_name."/cert.pem' $filename");
            			shell_exec("sed -i '".$ssl_two."a ssl_key = </etc/letsencrypt/live/".$domain_name."/privkey.pem' $filename");
            			shell_exec("sed -i '".$ssl_three."a ssl_ca = </etc/letsencrypt/live/".$domain_name."/fullchain.pem ' $filename");
						shell_exec("sed -i '".$ssl_four."a } ###domainend' $filename");
            			//shell_exec("sed -i '".$ssl_four."a }' $filename");
					//}
						$ssl_six = $ssl_five; $ssl_seven = $ssl_five+1;	$ssl_eight = $ssl_five+2;
						$ssl_line+=5; $ssl_one+=5; $ssl_two+=5; $ssl_three+=5; $ssl_four+=5; $ssl_five+=5;
					/*else
					{
						echo "\nAlready Added";
					}*/
					}
				}
			}
			else
			{
				$ssl_six = $ssl_line; 
				$ssl_seven = $ssl_one;
				$ssl_eight = $ssl_two;
			}
			
                       $sql = $this->zdbh->prepare ("select * from x_ssl_crt where ssl_crt_status=1 and ssl_crt_delete is null");
			$sql->execute();
                        if ($sql->rowCount())
                        {
                                while($rows = $sql->fetch())
                                {
                                        
                                        $domain_name = $rows['ssl_crt_doamin'];
                                        if($domain_name != $key_path)
                                        {
                                                shell_exec("sed -i '".$ssl_line."a local_name ".$domain_name." {' $filename");
                                                shell_exec("sed -i '".$ssl_one."a ssl_cert = </etc/csr/".$domain_name."/".$domain_name.".crt' $filename");
                                shell_exec("sed -i '".$ssl_two."a ssl_key = </etc/csr/".$domain_name."/".$domain_name.".key' $filename");
                               // shell_exec("sed -i '".$ssl_three."a ssl_ca = </etc/csr".$domain_name."/".$domain_name.".key ' $filename");
                                                shell_exec("sed -i '".$ssl_four."a } ###domainend' $filename");
                                
                                                $ssl_six = $ssl_five; $ssl_seven = $ssl_five+1; $ssl_eight = $ssl_five+2;
                                                $ssl_line+=5; $ssl_one+=5; $ssl_two+=5; $ssl_three+=5; $ssl_four+=5; $ssl_five+=5;
                            
                                        }
                                }
                        }
                        else
                        {
                                $ssl_six = $ssl_line;
                                $ssl_seven = $ssl_one;
                                $ssl_eight = $ssl_two;
                        }
			//echo "\nssl_six: $ssl_six\nssl_seven: $ssl_seven\nssl_eight: $ssl_eight";
			//echo "sed -i '".$ssl_line."a  ssl_cert = </etc/letsencrypt/live/".$key_path."/cert.pem' $filename\n";
			shell_exec("sed -i '".$ssl_six."a ssl_cert = </etc/letsencrypt/live/".$key_path."/cert.pem' $filename");
            shell_exec("sed -i '".$ssl_seven."a ssl_key = </etc/letsencrypt/live/".$key_path."/privkey.pem' $filename");
            shell_exec("sed -i '".$ssl_eight."a ssl_ca = </etc/letsencrypt/live/".$key_path."/fullchain.pem' $filename");
			$return = true;;
		}
		/*else
		{
			sleep(30);
			if($n == 18)
				return false;
			$n = $n+1;
			$return = $this->AddSSLCertKeyCA($smtp_ssl, $n);
		}*/
		return $return;
	}

	public function getHostname()
	{
		$this->hostname = trim(shell_exec("hostname"));
		$split_hostname=explode(".",$this->hostname);
		$subDomainName=$split_hostname[0];
		unset($split_hostname[0]);
		$domain_name=trim(implode(".",$split_hostname));
		$this->hostdomainname = $domain_name;
		return true;
	}

	public function GetPrivateKeys()
	{
		$domain_certbot = shell_exec("grep -ni 'Domains' /var/log/letsencrypt/sslrenew.log");
	    $line_cerbot = explode("\n",$domain_certbot);

    	$line=array();
		$domain_list = array();
	    foreach($line_cerbot as $key=>$value)
    	{
        	if(trim($value)!="")
	        {
    	        $line_num = explode(":", $value);
        	    $line[] = trim($line_num[0]) + 3;
				$domain_list_temp=explode(":",$value);
	            $domain_list_temp1=explode(",",$domain_list_temp[2]);
    	        $domain_list[]=trim($domain_list_temp1[0]);
	        }
    	}
	    //print_r($domain_lists);
    	$privkey_list = array();
	    foreach($line as $key => $value)
    	{
	        if(trim($value) != "")
    	    {
        	    $privkey = shell_exec("sed -n '$value'p /var/log/letsencrypt/sslrenew.log");
				$privkey_list_temp = explode("/",$privkey);
	            $privkey_list[] = trim($privkey_list_temp[4]);
    	    }
	    }
		
		foreach($domain_list as $key => $value)
	    {
    	    if(trim($value)!="")
	        {
            	$domain_lists_temp = explode(" ",$value);
        	    $domain_lists[] = trim($domain_lists_temp[0]);
    	    }
	    }
		$this->privkey_list = $privkey_list;
		$this->domain_lists = $domain_lists;
		return true;
	}

	public function GetUserEmailID()
	{
		$rows = $this->zdbh->prepare("SELECT ac_email_vc FROM x_accounts WHERE ac_id_pk = 1 LIMIT 1;");
        $rows->execute();
        $dbvals = $rows->fetch();
        $emailid = $dbvals['ac_email_vc'];
        return $emailid;
	}

	public function CheckSSLAndInstall($email, $check_ssl)
	{
		$host_name = $this->hostname;
		if($check_ssl == true)
		{
			$checkSSLInstalled = $this->HRPanelAISALib->isSSLExists($host_name);	
			if($checkSSLInstalled == SSL_NOT_EXPIRED)
			{
				echo "Checked SSL already installed. Success \n";
				return true;
			}
			else if($checkSSLInstalled == SSL_EXPIRED)
			{
				echo "Checked SSL already installed. SSL is expired so renewing \n";
				$return = $this->HRPanelAISALib->SSLRenew($domain_name);
				return true;	
			}
		}

		echo "Checked SSL already installed. Not Installed \n";
		if(!$email)
		{
			$email = $this->GetUserEmailID();
		}
		$user_IP = ctrl_options::GetSystemOption('server_ip');
		$wwwoption = $this->HRPanelAISALib->InstallSSLTableInsertion($host_name);
		$file_path = ctrl_options::GetSystemOption('ipdomain_dir');
        
	if($this->HRPanelAISALib->isNginx())
       	{
   	        $in="command installnginxSSL $host_name $email $wwwoption $file_path $user_IP";
            echo "Install SSL using $in \n";
       	}
   	    else
        {
           	$in="command installSSL $host_name $email $wwwoption $file_path";
       	    echo "Install SSL using $in \n";
   	    }
	
	$getcwd =__FILE__;
	$command_detail = str_replace("command ","",trim($in));
	$command_detail = str_replace(" ","\n",$command_detail);
	$input="$command_detail\n$getcwd";
	$output = ctrl_module::ConnectServerSocket($input);
	if(!$output){
		self::$tryagain=true;
		return false;
	}
		sleep(60);
        return SSL_INSTALL_INPROGRESS;
	}

	public function PointHostName()
	{
		echo "Host Domain Name is poiinting with us so pointing hostname also with us.\n";	
		$split_hostname = explode(".",$this->hostname);
	    $subDomainName = $split_hostname[0];
		$domain_name = $this->hostdomainname;
		echo "Sub domain name : ".$subDomainName."\n";
		echo "Domain name : ".$domain_name."\n";
		$hostname_pointed = NEED_TO_CHECK;
		/* ////////////////////////////////////// Code for adding A record if it does not exists started HERE  /////////////////////////////////// */
	    $check_ssl = "SELECT vh_acc_fk,vh_id_pk FROM x_vhosts WHERE vh_name_vc='".$domain_name."' AND vh_deleted_ts IS NULL";
        $numcheck = $this->zdbh->prepare($check_ssl);
        $numcheck->execute();
        $check_num = $numcheck->fetchColumn();
        if ($check_num > 0)
        {
			if (!fs_director::CheckForEmptyValue(ctrl_options::GetSystemOption('server_ip'))) 
			{
				$targetIP = ctrl_options::GetSystemOption('server_ip');
			} 
			else 
			{
				$targetIP = $_SERVER["SERVER_ADDR"];
			}
			
			$rows = $this->zdbh->prepare("SELECT vh_acc_fk,vh_id_pk FROM x_vhosts WHERE vh_name_vc='".$domain_name."' AND vh_deleted_ts IS NULL;");
			$rows->execute();
			$dbvals = $rows->fetch();
			$domainID=$dbvals['vh_id_pk'];
			$user_id=$dbvals['vh_acc_fk'];
			$dsql=$this->zdbh->prepare("SELECT count(*) as rcd_cnt FROM x_dns WHERE dn_acc_fk=:userid AND dn_name_vc=:domainName AND dn_vhost_fk=:domainID AND dn_type_vc='A' AND dn_host_vc=:subDomain AND dn_target_vc=:target_new AND dn_deleted_ts is NULL");		
			$dsql->bindParam(':userid', $user_id);
			$dsql->bindParam(':domainName', $domain_name);
			$dsql->bindParam(':domainID', $domainID);
			$dsql->bindParam(':subDomain', $subDomainName);
			$dsql->bindParam(':target_new', $targetIP);
			$dsql->execute();
			$dres=$dsql->fetch();
			if($dres['rcd_cnt']==0)
			{
				$sql = $this->zdbh->prepare("INSERT INTO x_dns (dn_acc_fk,
				dn_name_vc,
				dn_vhost_fk,
				dn_type_vc,
				dn_host_vc,
				dn_ttl_in,
				dn_target_vc,
				dn_priority_in,
				dn_weight_in,
				dn_port_in,
				dn_created_ts) VALUES (
				:userid,
				:domainName,
				:domainID,
				'A',
				:hostName_new,
				'3600',
				:target_new,
				'0',
				'0',
				'0',
				:time)"
				);
				$sql->bindParam(':userid', $user_id);
				$sql->bindParam(':domainName', $domain_name);
				$sql->bindParam(':domainID', $domainID);
				$sql->bindParam(':hostName_new', $subDomainName);
				$sql->bindParam(':target_new', $targetIP);
				$time = time();
				$sql->bindParam(':time', $time);
				$sql->execute();
				unset($sql);

				$sql = $this->zdbh->prepare("INSERT INTO x_dns (dn_acc_fk,
				dn_name_vc,
				dn_vhost_fk,
				dn_type_vc,
				dn_host_vc,
				dn_ttl_in,
				dn_target_vc,
				dn_priority_in,
				dn_weight_in,
				dn_port_in,
				dn_created_ts) VALUES (
				:userid,
				:domainName,
				:domainID,
				'A',
				:hostName_new,
				'3600',
				:target_new,
				'0',
				'0',
				'0',
				:time)"
				);
				$sql->bindParam(':userid', $user_id);
				$sql->bindParam(':domainName', $domainName);
				$sql->bindParam(':domainID', $domainID);
				$serv_alias="www.".$subDomainName;
				$sql->bindParam(':hostName_new',$serv_alias);
				$sql->bindParam(':target_new', $targetIP);
				$time = time();
				$sql->bindParam(':time', $time);
				$sql->execute();
				unset($sql);
				
				$records_list = ctrl_options::GetSystemOption('dns_hasupdates');
				$record_array = explode(',', $records_list);
				if (!in_array($domainID, $record_array)) 
				{
					if (empty($records_list)) 
					{
						$records_list .= $domainID;
					} 
					else 
					{
						$records_list .= ',' . $domainID;
					}
					$sql = "UPDATE x_settings SET so_value_tx=:newlist WHERE so_name_vc='dns_hasupdates'";
					$sql = $this->zdbh->prepare($sql);
					$sql->bindParam(':newlist', $records_list);
					$sql->execute();
				}
				$sql = $this->zdbh->prepare("UPDATE x_settings SET so_value_tx='true' WHERE so_name_vc='apache_changed'");
				$sql->execute();
				echo "DOMAIN_NAME_CREATED\n";
				$this->HRPanelAISALib->SetWriteApacheConfigTrue();
	            $this->HRPanelAISALib->SetCallDaemon();
				$hostname_pointed = DOMAIN_NAME_CREATED;
			}
			else 
			{
				echo "DOMAIN_ALREADY_ADDED\n";
				$hostname_pointed = DOMAIN_ALREADY_ADDED;	
			}
		/* ////////////////////////////////////// Code for adding A record if it does not exists Ended HERE  /////////////////////////////////// */
		
		}
		else 
		{
			echo "DOMAIN_NOT_CREATED\n";
			$hostname_pointed = DOMAIN_NOT_CREATED;
		}
		return $hostname_pointed;		
	}

	public function checkHostDomainNameNSisPointWithUs()
	{
		$hostdomainname = $this->hostdomainname;
		echo $hostdomainname."\n";
        $dns_data = dns_get_record($hostdomainname);
		print_r($dns_data);
        $a_record = null;
        foreach($dns_data as $data)
        {
            if($data['type'] == 'NS')
            {
                $nameserver  = trim($data['target']);
                break;
            }
        }
			
		$namserver_a_record = $this->getARecord($nameserver);	
        $Current_IP_Addr = trim(ctrl_options::GetSystemOption('server_ip'));
		echo "Domain Nameserver :".$namserver_a_record."\n";
		echo "Current IP Address :".$Current_IP_Addr."\n";
        if($namserver_a_record != $Current_IP_Addr)
        {
            return false;
        }
        return true;
	}

	public function getARecord($domain_name)
	{
		$dns_data = dns_get_record($domain_name);
        $a_record = null;
        foreach($dns_data as $data)
        {
            if($data['type'] == 'A')
            {
                $a_record  = trim($data['ip']);
                break;
            }
        }
        return $a_record;	
	}

	public function checkHostNameARecord()
	{
		$hostname = $this->hostname;
		$hostArecord = $this->getARecord($hostname);
		if($hostArecord)
		{
			$Current_IP_Addr = trim(ctrl_options::GetSystemOption('server_ip'));
    	    if($hostArecord != $Current_IP_Addr)
        	{
	            return false;
    	    }
			return true;
		}
		else
		{
            return false;
		}
	}

	public function removeSSLCertKeyCA()
	{
		$filename = $this->dovecotConfFilePath;
		$filename = str_replace("/","\/",$filename);
		$cmd_remove_local_domain = "sed -i '/local_name/d' $filename";
		$cmd_remove_cert = "sed -i '/ssl_cert/d' $filename";
		echo $cmd_remove_cert."\n";
		$cmd_remove_key = "sed -i '/ssl_key/d' $filename";
		echo $cmd_remove_key."\n";
		$cmd_remove_ca = "sed -i '/ssl_ca/d' $filename";
		echo $cmd_remove_ca."\n";
		$cmd_remove_local_domainend = "sed -i '/domainend/d' $filename";
		shell_exec($cmd_remove_local_domain);
		shell_exec($cmd_remove_cert);
		shell_exec($cmd_remove_key);
		shell_exec($cmd_remove_ca);
		shell_exec($cmd_remove_local_domainend);
		return true;
	}

	public function CheckSSLCertKeyCA()
	{
		$filename = $this->dovecotConfFilePath;
		$check_ssl_cert = "grep ssl_cert $filename";
		$check_ssl_key = "grep ssl_key $filename";
		$check_ssl_ca = "grep ssl_ca $filename";
		$ssl_cert_out  = trim(shell_exec($check_ssl_cert));
		$ssl_key_out  = trim(shell_exec($check_ssl_key));
		$ssl_ca_out  = trim(shell_exec($check_ssl_ca));
		if($ssl_cert_out && $ssl_key_out && $ssl_ca_out)
		{
			$output_of_ssl_ckc_check = $ssl_cert_out.":".$ssl_key_out.":".$ssl_ca_out;
		}
		else
		{
			$output_of_ssl_ckc_check = false;
		}
		return $output_of_ssl_ckc_check;
	}
}
File Content: DovecotConfSSLSetup.php

File Content: `DovecotConfSSLSetup.php`
