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));
}
}
