" .PHP_EOL; $emailParameters["headers"] .= "MIME-Version: 1.0" .PHP_EOL; $emailParameters["headers"] .= "Date: ". date("r").PHP_EOL; //D d M Y H:m:i $emailParameters["headers"] .= "Content-type: text/html; charset=iso-8859-1" .PHP_EOL; $emailParameters["headers"] .= " boundary=\"{==Multipart_Boundary_x{".md5(time())."}x}\""; $emailParameters["parameters"] = ""; ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ## FIM CONNECT TO DB $conn = mysqli_connect($dbHostname, $dbUsername, $dbPassword, $dbDatabase ); ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// // FUNCTIONS function print_rr($value, $blnString=false) { echo "

";
   print_r($value,$blnString);
   echo "

"; } ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// include_once("fim.cron.php"); ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// // CREATE TABLES - RUN ONLY ONCE //MASTER AUDIT TABLE $sqlMaster = " SET FOREIGN_KEY_CHECKS=0; DROP TABLE IF EXISTS `sysAudit_master`; CREATE TABLE IF NOT EXISTS `sysAudit_master` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `dtAudit` date NOT NULL, `strType` enum('File','Dir') NOT NULL, `strPath` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `strExtension` varchar(20) DEFAULT NULL, `strOwner` varchar(100) NOT NULL DEFAULT '', `strPermission` varchar(20) NOT NULL DEFAULT '', `dblSize` double NOT NULL DEFAULT 0, `strHash` varchar(255) NOT NULL DEFAULT '', `dtModify` datetime NOT NULL, `strLastUser` varchar(100) NOT NULL DEFAULT 'System', `dtLastEdit` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`ID`), UNIQUE KEY `UNIQUE` (`strPath`,`dtAudit`), KEY `strHash` (`strPath`,`strHash`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET FOREIGN_KEY_CHECKS=1;"; //mysqli_query($conn, $sqlMaster); //ENVIROMENT AUDIT TABLE $sqlEnviroment = "SET FOREIGN_KEY_CHECKS=0; DROP TABLE IF EXISTS `sysAudit_$siteEnviroment`; CREATE TABLE IF NOT EXISTS `sysAudit_$siteEnviroment` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `dtAudit` date NOT NULL, `strType` enum('File','Dir') NOT NULL, `strPath` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `strExtension` varchar(20) DEFAULT NULL, `strOwner` varchar(100) NOT NULL DEFAULT '', `strPermission` varchar(20) NOT NULL DEFAULT '', `dblSize` double NOT NULL DEFAULT 0, `strHash` varchar(512) NOT NULL DEFAULT '', `dtModify` datetime NOT NULL, `strLastUser` varchar(100) NOT NULL DEFAULT 'System', `dtLastEdit` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET FOREIGN_KEY_CHECKS=1;"; //mysqli_query($conn, $sqlEnviroment); //die; ?>