echo "<filetype>" . $type[0] . "</filetype>"; echo "</file>"; } } else { xml_encode("error", "No files were found!"); } } } echo "</files>"; break; case "encrypted": $userIdResult = dbUtil::SELECT("SELECT clmnId FROM tblUsers WHERE clmnUserName=:uname", array(':uname' => $_SESSION['un'])); if (count($userIdResult) != 0) { $userId = $userIdResult[0]['clmnId']; } $fileResult = dbUtil::SELECT("SELECT clmnFileName, clmnFileSize, clmnFileModified, clmnFileType FROM tblFiles WHERE clmnUNFile=:uname AND clmnEncrypted='1'", array(':uname' => $_SESSION['un'])); if (count($fileResult)) { foreach ($fileResult as $trow) { echo "<file>"; echo "<filename>" . $trow['clmnFileName'] . "</filename>"; echo "<filesize>" . FileSizeConvert($trow['clmnFileSize']) . "</filesize>"; echo "<filemod>" . date("d/m/Y", $trow['clmnFileModified']) . "</filemod>"; $type = explode("/", $trow['clmnFileType']); echo "<filetype>" . $type[0] . "</filetype>"; echo "</file>"; } } else { xml_encode("error", "No files were found!"); } break; default:
/* 52 428 800 = 100% usage = ? */ $uppercal = $overallusage * 100; $usage = $uppercal / 52428800; echo "<perc>" . (int) $usage . "</perc>"; echo "</usagerequest>"; break; case 'adminusage': if ($_SESSION['un'] == 'admin') { $action = $_GET['action']; echo "<usagerequest>"; switch ($action) { case 'file': $allFileSizesResult = dbUtil::SELECT("SELECT clmnFileSize FROM tblFiles", null); $overallusage = 0; if (count($allFileSizesResult) != 0) { foreach ($allFileSizesResult as $row) { $overallusage += $row['clmnFileSize']; } } /* 52 428 800 = 100% usage = ? */ $uppercal = $overallusage * 100; $usage = $uppercal / 52428800; echo "<perc>" . (int) $usage . "</perc>"; break; case 'cpu':
$cleanupRS = new dbRS(); if (sizeof($arFtpSiteIds) > 0) { $inString = ''; foreach ($arFtpSiteIds as $ftpSiteId) { if (strlen($inString) > 0) { $inString .= ','; } $inString .= $ftpSiteId; } $cleanupRS->execute(sprintf("delete from ftp_path where group_id = %s and ftp_site_id not in (%s)", dbUtil::encode($groupId) ,$inString)); } else { $cleanupRS->execute(sprintf("delete from ftp_path where group_id = %s", dbUtil::encode($groupId))); } echo getJSONResult(array("ftpPath" => "saved")); } else { echo getJSONError(array(2, "Error saving FTPPath record")); } } } else { echo getJSONError(array(12, "Group Id must be specified when saving paths")); } } function getJSONResult($result) { return json_encode(array("result" => $result));
function printUserLocation($activeUser, $fileId, $delete) { $userLocationResult = dbUtil::SELECT("SELECT clmnFileLine, clmnLineMode, clmnLineText, clmnLinePos FROM tblFileModif WHERE clmnFileId=:fileid AND clmnUserId=:userid", array(':userid' => $activeUser, ':fileid' => $fileId)); foreach ($userLocationResult as $row) { printXML("userloc"); printXML("line"); echo $row['clmnFileLine']; printXML("/line"); printXML("mode"); echo $row['clmnLineMode']; printXML("/mode"); printXML("ltext"); echo str_replace(array('\\n', '\\r'), "", $row['clmnLineText']); printXML("/ltext"); printXML("pos"); echo $row['clmnLinePos']; printXML("/pos"); printXML("/userloc"); } if ($delete) { $deleteLogsResult = dbUtil::DELETE("DELETE FROM tblFileModif WHERE clmnFileId=:fileid AND clmnUserId=:userid", array(':userid' => $activeUser, ':fileid' => $fileId)); } }