arrExcludeWildcard = explode(";", $siteWildcards);
$this->dirRoot = $dirRoot;
}
// NEW INISETPERMISSIONS FUNCTION - IS CALLED PER RECORD ON THE RECORD FUNCTION INSTEAD OF OWN PROCESS
public function iniSetPermissions($type, $value)
{
if ($type == "Dir")
{
if(file_exists($value))
{
// CHECK THAT DIR PERMISSION IS 0755
if(substr(sprintf("%o", fileperms($value)), -4) != "0755")
{
// IF IT IS NOT 0755 THEN MAKE IT 0755
chmod($value, 0755);
}
return "success";
}
}
else if($type == "File")
{
if(file_exists($value))
{
//CHECK THAT FILE PERMISSION IS 0644
if(substr(sprintf("%o", fileperms($value)), -4) != "0644")
{
// IF IT IS NOT 0644 THEN MAKE IT 0644
chmod($value, 0644);
}
return "success";
}
}
return "failed";
}
// UPDATED RECORD FUNCTION - MAKES USE OF A TIMER / COUNTER SETUP
public function Record(&$result = array(), $dirRoot = null)
{
// INI GLOBALS
global $arrSession, $siteEnviroment, $siteDirectory, $siteWildcards, $intDirCounter, $intGlobalCounter, $processUseTimer, $ProcessMaxRuntime, $processUseCounter, $processStartTime, $ProcessMaxCount, $FIMCronPath;
// $intDirCounter - ACTS LIKE AN ID FOR THE FILES AND DIRECTORY
// $intProcessPausedID - VALUE WHERE $intDirCounter WAS PAUSED
// $intGlobalCounter - JUST A NORMAL COUNTER TO KEEP TRACK OF PROCESS , ONLY COUNTS VALID SAVES
// INI VARS
$intProcessPausedID = 0;
if($intGlobalCounter == "") $intGlobalCounter = 0;
if($intDirCounter == "") $intDirCounter = 0;
if($arrSession[0] == 0)
{
$intProcessPausedID = $arrSession[1];
}
$intProcessComplete = 1;
$sesFile = fopen("sesFile.txt", "r+") or die("Unable to open file!");
fwrite($sesFile, "$intProcessComplete\n");
fclose($sesFile);
$I_RECURSIVE = 0;
// GETTING THE BASE URL - PROCESS SHOULD NOT RUN BEFOR THIS URL
if($dirRoot == null)
{
$dirRoot = $siteDirectory;
}
// GET DIRECTORY INTO AN ARRAY
$arrDir = scandir($dirRoot);
// LOOP THROUGHT DIRECTORY
foreach ($arrDir as $i => $value)
{
$I_RECURSIVE++;
// WRONG FILE/FOLDER EXTENSION CHECK
$fileExtension = substr($value, strpos($value, "."));
// CHECK IF FILE TYPE HAS BEEN EXCLUDED FROM LOGGING
if(!$this->in_array_wildcard($value, $this->arrExcludeWildcard, 0))
{
$RuntTime = strtotime(date("Y-m-d H:i:s"))-strtotime($processStartTime);
// IS RUNTIME BASED ON TIME OR COUNT?
if($processUseTimer == 1)
{
// IF RUN LIMIT IS REACH - EXIT LOOP
if($RuntTime > $ProcessMaxRuntime)
{
$intProcessComplete = 0;
// UPDATE sesFile WITH LAST ID USED
$sesFile = fopen("sesFile.txt", "r+") or die("Unable to open file!");
fwrite($sesFile, "0\n");
fwrite($sesFile, $intGlobalCounter);
fclose($sesFile);
exit;
}
}
else if($processUseCounter == 1)
{
// IF RUN LIMIT IS REACH - EXIT LOOP
if($intDirCounter == $ProcessMaxCount)
{
$intProcessComplete = 0;
// UPDATE sesFile WITH LAST ID USED
$sesFile = fopen("sesFile.txt", "r+") or die("Unable to open file!");
fwrite($sesFile, "$intProcessComplete\n");
fwrite($sesFile, $intGlobalCounter);
fclose($sesFile);
exit;
}
}
$intGlobalCounter++;
// CHECK IF ARRAY ITEM IS FILE OR FOLDER
if (is_dir($dirRoot . DIRECTORY_SEPARATOR . $value))
{
//SKIP FOLDER AND FILES UNTIL IT PASS THE PAUESED ID
if($intGlobalCounter <= $intProcessPausedID)
{
//print_rr($intGlobalCounter . " ------- " . $i . " - " . $value . " - [VOID] - " . $intProcessPausedID);
$this->Record($result, $dirRoot . DIRECTORY_SEPARATOR . $value);
continue;
}
// DEBUG
//print_rr($intGlobalCounter . " ------- " . $i . " - " . $value . " - [] - " . $intProcessPausedID);
// THIS COUNTER ANLY STARTS WHEN THE LOGGING STARTS
$intDirCounter++;
// SAVE IF EXIST
if(file_exists( $dirRoot . DIRECTORY_SEPARATOR . $value))
{
// SAVE RECORD IN DB
$this->Save("Dir", $dirRoot . DIRECTORY_SEPARATOR . $value);
// UPDATE PERMISSIONS OF DIR
$this->iniSetPermissions("Dir", $dirRoot . DIRECTORY_SEPARATOR . $value);
}
//continue; // TESTING PURPOSE ONLY - WILL ONLY RUN TOP LEVEL IF ACTIVE
//RERUN FUNCTION: TO RUN FILES IN FOLDER
$this->Record($result, $dirRoot . DIRECTORY_SEPARATOR . $value);
}
else
{
//SKIP FOLDER AND FILES UNTIL IT PASS THE PAUESED ID
if($intGlobalCounter <= $intProcessPausedID)
{
//print_rr($intGlobalCounter . " ------- " . $i . " - " . $value . " - [VOID] - " . $intProcessPausedID);
continue;
}
// DEBUG
//print_rr($intGlobalCounter . " ------- " . $i . " - " . $value . " - [] - " . $intProcessPausedID);
// THIS COUNTER ANLY STARTS WHEN THE LOGGING STARTS
$intDirCounter++;
// SAVE IF EXIST
if(file_exists( $dirRoot . DIRECTORY_SEPARATOR . $value))
{
// SAVE RECORD IN DB
$this->Save("File", $dirRoot . DIRECTORY_SEPARATOR . $value);
// UPDATE PERMISSIONS OF FILE
$this->iniSetPermissions("File", $dirRoot . DIRECTORY_SEPARATOR . $value);
}
}
}
}
}
protected function Save($type, $value)
{
// INI GLOBALS
//global $DATABASE_SETTINGS, $BR, $SP, $TR, $SystemSettings, $DT, $MYSQLI, $xdb;
global $siteEnviroment, $siteDirectory, $siteWildcards, $intDirCounter, $intGlobalCounter, $conn;
// INI
$dtAudit = date("Y-m-d H:i:s");
$strType = $type;
// STRING PATH TO ONLY SHOW PATH FROM SITE DIRECTORY
if(strpos($value, $siteDirectory) !== false)
{
$strPath = str_replace($siteDirectory, "", $value);
}
else
{
$strPath = str_replace($siteDirectory, "", realpath($value));
}
$strOwner = strval(fileowner($value));
$strPermission = substr(sprintf("%o", fileperms($value)), -4);
$dblSize = strval(filesize($value));
$dtModify = date("Y-m-d H:i:s", filemtime($value));
$strLastUser = $siteEnviroment;
switch($type)
{
case "Dir":
$strHash = sha1($strPath . $strOwner . $strPermission);
$strExtension = "";
break;
case "File":
$strHash = sha1(sha1_file(realpath($value)). $strOwner . $strPermission . $dblSize . $dtModify);
$strExtension = pathinfo($value, PATHINFO_EXTENSION);
break;
}
// SAVE QUERY
$sql = " INSERT INTO sysAudit_$siteEnviroment (dtAudit, strType, strPath, strOwner, strPermission, dblSize, dtModify, strLastUser, strHash, strExtension)
VALUES (
'$dtAudit',
'$strType',
'$strPath',
'$strOwner',
'$strPermission',
'$dblSize',
'$dtModify',
'$strLastUser',
'$strHash',
'$strExtension'
)";
// RUN QUERY
$rst = mysqli_query($conn, "$sql");
}
public static function Compare($strPathIgnore=0)
{
global $siteProjectName, $siteEnviroment, $siteDirectory, $siteWildcards, $FIMBaseURL, $emailParameters, $conn;
// INI
$sysAudit_ENV = "sysAudit_". $siteEnviroment;
$excludeMASTER = "";
$excludeENV = "";
$arrFields = array("strOwner" , "strPermission" , "dblSize" , "dtModify" , "strHash");
$arrayChangesID = array();
$i = 0;
$trMissing = "";
$trNew = "";
$trChanges = "";
$strBody = "";
// GET ENV MAX AUDIT DATE
$rst = mysqli_query($conn, "SELECT MAX(dtAudit) AS maxAudit FROM $sysAudit_ENV");
$maxAudit = mysqli_fetch_object($rst)->maxAudit;
// BUILD EXCLUDE STRING FOR QUERY
$arrIgnorePaths = explode(";", $siteWildcards);
foreach($arrIgnorePaths as $key){
$excludeMASTER .= " AND sysAudit_master.strPath NOT LIKE '".$key."' ";
$excludeENV .= " AND $sysAudit_ENV.strPath NOT LIKE '".$key."' ";
}
// GET THE NUMBER OF CHANGES FOR THE DAY //////////////////////////////////////////////////
// MUST HAVE THE SAME FROM / WHERE AS THE QUERY BELOW
$sqlSummaryChanges = "
SELECT
COUNT(*) AS 'CountChanges',
MAX(sysAudit_master.dtModify) AS 'maxDtChanges',
MIN(sysAudit_master.dtModify) AS 'minDtChanges',
sysAudit_master.strHash, $sysAudit_ENV.strHash,
sysAudit_master.strPath, $sysAudit_ENV.strPath
FROM sysAudit_master
INNER JOIN $sysAudit_ENV ON (sysAudit_master.strHash <> $sysAudit_ENV.strHash) AND (sysAudit_master.strPath = $sysAudit_ENV.strPath)
WHERE $sysAudit_ENV.dtAudit ='$maxAudit' AND sysAudit_master.strHash <> 'IGNORE' $excludeMASTER ";
$rstSummaryChanges = mysqli_query($conn, $sqlSummaryChanges);
$rowSummaryChanges = mysqli_fetch_object($rstSummaryChanges);
// GET THE DATA QUERY
$sql = "SELECT sysAudit_master.ID AS 'MASTER_ID', sysAudit_master.dtAudit AS 'MASTER_dtAudit'
, sysAudit_master.strType AS 'MASTER_strType', sysAudit_master.strPath AS 'MASTER_strPath'
, sysAudit_master.strExtension AS 'MASTER_strExtension', sysAudit_master.strOwner AS 'MASTER_strOwner'
, sysAudit_master.strPermission AS 'MASTER_strPermission'
, sysAudit_master.dblSize AS 'MASTER_dblSize', sysAudit_master.dtModify AS 'MASTER_dtModify'
, sysAudit_master.strHash AS 'MASTER_strHash'
, $sysAudit_ENV.ID AS 'LIVE_ID', $sysAudit_ENV.dtAudit AS 'LIVE_dtAudit'
, $sysAudit_ENV.strType AS 'LIVE_strType'
, $sysAudit_ENV.strPath AS 'LIVE_strPath'
, $sysAudit_ENV.strExtension AS 'LIVE_strExtension', $sysAudit_ENV.strOwner AS 'LIVE_strOwner'
, $sysAudit_ENV.strPermission AS 'LIVE_strPermission'
, $sysAudit_ENV.dblSize AS 'LIVE_dblSize', $sysAudit_ENV.dtModify AS 'LIVE_dtModify'
, $sysAudit_ENV.strHash AS 'LIVE_strHash'
FROM sysAudit_master INNER JOIN $sysAudit_ENV ON (sysAudit_master.strHash <> $sysAudit_ENV.strHash) AND (sysAudit_master.strPath = $sysAudit_ENV.strPath)
WHERE $sysAudit_ENV.dtAudit ='$maxAudit' AND sysAudit_master.strHash <> 'IGNORE'
$excludeMASTER
ORDER BY MASTER_strPath, LIVE_strPath
LIMIT 0,50";
$rst = mysqli_query($conn, $sql);
while($row = mysqli_fetch_object($rst))
{
// INI
$colour = array();
$colour["strType"] = "";
$colour["strPath"] = "";
$colour["strExtension"] = "";
$colour["dtAudit"] = "";
$colour["strOwner"] = "";
$colour["strPermission"] = "";
$colour["dblSize"] = "";
$colour["dtModify"] = "";
$colour["strHash"] = "";
$blnDisplay = 1;
$i++;
$arrayChangesID[$i] = $row->LIVE_ID;
// COMPARE AND HIGHLIGHT CHANGES
foreach($arrFields as $key)
{
$rowMaster = ("MASTER_".$key);
$rowLive = ("LIVE_".$key);
$colour[$key] = "black";
if($row->$rowMaster != $row->$rowLive)
$colour[$key] = "red";
}
if($row->MASTER_strType == "Dir" ){
$colour[dblSize] = "black";
}
$IDChanges[$i] = $row->LIVE_ID;
$trChanges .= "
";
}
//ENCODED ARRAY ID TO PASS ON URL FOR EMAIL
$arrDataChanges = json_encode($arrayChangesID);
// GET MISSING RECORDS FOR THE DAY ////////////////////////////////////////////////////////
// [M=>L, W. L.ID is Null]
// MUST HAVE THE SAME FROM / WHERE AS THE QUERY BELOW
$sqlSummaryMissing = "
SELECT
COUNT(*) AS 'CountMissing',
MAX(sysAudit_master.dtModify) AS 'maxDtMissing',
MIN(sysAudit_master.dtModify) AS 'minDtMissing',
sysAudit_master.strHash,
$sysAudit_ENV.strHash,
sysAudit_master.strPath,
$sysAudit_ENV.strPath
FROM sysAudit_master
LEFT JOIN $sysAudit_ENV ON sysAudit_master.strPath = $sysAudit_ENV.strPath
WHERE $sysAudit_ENV.ID Is Null AND sysAudit_master.strHash <> 'IGNORE' $excludeMASTER";
$rstSummaryMissing = mysqli_query($conn, $sqlSummaryMissing);
$rowSummaryMissing = mysqli_fetch_object($rstSummaryMissing);
// GET THE DATA QUERY
$sql = "SELECT sysAudit_master.ID AS 'MASTER_ID', sysAudit_master.dtAudit AS 'MASTER_dtAudit'
, sysAudit_master.strType AS 'MASTER_strType', sysAudit_master.strPath AS 'MASTER_strPath'
, sysAudit_master.strExtension AS 'MASTER_strExtension', sysAudit_master.strOwner AS 'MASTER_strOwner'
, sysAudit_master.strPermission AS 'MASTER_strPermission'
, sysAudit_master.dblSize AS 'MASTER_dblSize', sysAudit_master.dtModify AS 'MASTER_dtModify'
, sysAudit_master.strHash AS 'MASTER_strHash'
, $sysAudit_ENV.ID AS 'LIVE_ID', $sysAudit_ENV.dtAudit AS 'LIVE_dtAudit'
, $sysAudit_ENV.strType AS 'LIVE_strType', $sysAudit_ENV.strPath AS 'LIVE_strPath'
, $sysAudit_ENV.strExtension AS 'LIVE_strExtension', $sysAudit_ENV.strOwner AS 'LIVE_strOwner'
, $sysAudit_ENV.strPermission AS 'LIVE_strPermission'
, $sysAudit_ENV.dblSize AS 'LIVE_dblSize', $sysAudit_ENV.dtModify AS 'LIVE_dtModify'
, $sysAudit_ENV.strHash AS 'LIVE_strHash'
FROM sysAudit_master LEFT JOIN $sysAudit_ENV ON sysAudit_master.strPath = $sysAudit_ENV.strPath
WHERE $sysAudit_ENV.ID Is Null AND sysAudit_master.strHash <> 'IGNORE'
$excludeMASTER
ORDER BY MASTER_strPath, LIVE_strPath
LIMIT 0,50";
$rst = mysqli_query($conn, $sql);
while($row = mysqli_fetch_object($rst))
{
//display
$trMissing .= "
";
}
// GET NEW RECORDS FOR THE DAY ////////////////////////////////////////////////////////////
// [M<=L, W. M.ID is Null]
// MUST HAVE THE SAME FROM / WHERE AS THE QUERY BELOW
$sqlSummaryNew = "
SELECT
COUNT(*) AS 'CountNew',
MAX($sysAudit_ENV.dtModify) AS 'maxDtNew',
MIN($sysAudit_ENV.dtModify) AS 'minDtNew',
sysAudit_master.strHash,
$sysAudit_ENV.strHash,
sysAudit_master.strPath,
$sysAudit_ENV.strPath
FROM sysAudit_master
RIGHT JOIN $sysAudit_ENV ON sysAudit_master.strPath = $sysAudit_ENV.strPath
WHERE $sysAudit_ENV.dtAudit ='$maxAudit' AND sysAudit_master.ID Is Null $excludeENV";
$rstSummaryNew = mysqli_query($conn, $sqlSummaryNew);
$rowSummaryNew = mysqli_fetch_object($rstSummaryNew);
$sql = "SELECT sysAudit_master.ID AS 'MASTER_ID', sysAudit_master.dtAudit AS 'MASTER_dtAudit'
, sysAudit_master.strType AS 'MASTER_strType', sysAudit_master.strPath AS 'MASTER_strPath'
, sysAudit_master.strExtension AS 'MASTER_strExtension', sysAudit_master.strOwner AS 'MASTER_strOwner'
, sysAudit_master.strPermission AS 'MASTER_strPermission', sysAudit_master.dblSize AS 'MASTER_dblSize'
, sysAudit_master.dtModify AS 'MASTER_dtModify', sysAudit_master.strHash AS 'MASTER_strHash'
, $sysAudit_ENV.ID AS 'LIVE_ID', $sysAudit_ENV.dtAudit AS 'LIVE_dtAudit', $sysAudit_ENV.strType AS 'LIVE_strType'
, $sysAudit_ENV.strPath AS 'LIVE_strPath', $sysAudit_ENV.strExtension AS 'LIVE_strExtension'
, $sysAudit_ENV.strOwner AS 'LIVE_strOwner', $sysAudit_ENV.strPermission AS 'LIVE_strPermission'
, $sysAudit_ENV.dblSize AS 'LIVE_dblSize', $sysAudit_ENV.dtModify AS 'LIVE_dtModify'
, $sysAudit_ENV.strHash AS 'LIVE_strHash'
FROM sysAudit_master RIGHT JOIN $sysAudit_ENV ON sysAudit_master.strPath = $sysAudit_ENV.strPath
WHERE $sysAudit_ENV.dtAudit ='$maxAudit' AND sysAudit_master.ID Is Null
$excludeENV
ORDER BY MASTER_strPath, LIVE_strPath
LIMIT 0,50";
$rst = mysqli_query($conn, $sql);
while($row = mysqli_fetch_object($rst))
{
//output
$trNew .= "