$sCheckResult = dbUtil::SELECT("SELECT clmnShrId FROM tblSharedFiles WHERE clmnFileID=:fileId", array(':fileId' => $fCheckResult[0]['clmnFileID']));
if (count($sCheckResult) == 0) {
$exc = dbUtil::INSERT("INSERT INTO tblSharedFiles VALUES('', :fileid, :fileown, :unfold)", array(':fileid' => $fCheckResult[0]['clmnFileID'], ':unfold' => $shareCheckResult[0]['clmnID'], ':fileown' => $userId));
if ($exc == true) {
//sucess
}
}
}
break;
case 'fUnShare':
$fName = $_GET['name'];
$type = $_GET['type'];
$where = $_GET['where'];
$fCheckResult = dbUtil::SELECT("SELECT clmnFileID FROM tblFiles WHERE clmnFileName=:fileName AND clmnFoldIn=:foldin AND clmnUNFile=:uname", array(':fileName' => $fName, ':uname' => $_SESSION['un'], ':foldin' => $where));
if (count($fCheckResult) != 0) {
dbUtil::DELETE("DELETE FROM tblSharedFiles WHERE clmnFileID=:fileId", array(':fileId' => $fCheckResult[0]['clmnFileID']));
}
break;
case 'fDownload':
$dmode = $_GET['dmode'];
switch ($dmode) {
case 'single':
$fName = $_GET['name'];
$type = $_GET['type'];
$where = $_GET['where'];
if ($type == 'Folder') {
//recursive
if (!is_dir("../temp/" . $fName)) {
mkdir("../temp/" . $fName);
}
$fFolderFilesResult = dbUtil::SELECT("SELECT clmnFileID FROM tblFiles WHERE clmnUNFile=:uname AND clmnFoldIn=:foldin", array(':uname' => $_SESSION['un'], ':foldin' => $fName));
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));
}
}
