@($owner = @$_POST['owner']); @($id = @$_POST['id']); $ppath = lockname($path); //Resolve the shared file if (@$owner != "") { $query = \OCP\DB::prepare("SELECT X.path, Y.id FROM *PREFIX*filecache X INNER JOIN *PREFIX*storages Y ON X.storage = Y.numeric_id where X.fileid = " . $id . " LIMIT 1"); $result = $query->execute()->fetchAll(); // ? with execute parameters weren't working, so I used it in prepare $original_path = $result[0]['path']; $storage_id = str_replace("home::", "", $result[0]['id']) . '/'; $lockpath = $storage_id . $original_path; } else { $lockpath = \OCP\USER::getUser() . "/files" . cleanPath($path); } //Lock DB entry $lockfile = lockname($lockpath); $db_lock_state = \OCP\DB::prepare("SELECT * FROM *PREFIX*" . app::table . " WHERE name = ?")->execute(array($lockfile))->fetchAll(); if ($db_lock_state != null) { if (@$safe == "false") { \OCP\DB::prepare("DELETE FROM *PREFIX*" . app::table . " WHERE name=?")->execute(array($lockfile)); echo $l->t("File not locked"); } else { echo $l->t("Status: locked") . " " . $l->t("by") . " " . $db_lock_state[0]['locked_by']; } } else { if (@$safe == "false") { \OCP\DB::prepare("INSERT INTO *PREFIX*" . app::table . "(name,locked_by) VALUES(?,?)")->execute(array($lockfile, \OCP\User::getUser())); echo $l->t("File is locked") . " " . $l->t("by") . " " . \OCP\User::getUser(); } else { echo $l->t("Status: not locked"); }
$query = OCP\DB::prepare("SELECT parent, uid_owner, id FROM *PREFIX*share where id = ? LIMIT 1"); $result = $query->execute(array($result[0]['parent']))->fetchAll(); $new = @$result[0]['uid_owner']; } if ($old != "-") { $user = $old; } $realpath = $storage . $user . '$' . $postpath; for ($i = $backcount; $i > 0; $i -= 1) { $realpath .= '/' . $relpath[count($relpath) - $i]; } } else { $realpath = $storage . OCP\USER::getUser() . "/files" . cleanPath($path); } //lockfile name $lock = $apath . lockname($realpath); if (file_exists($lock)) { if (@$safe == "false") { @unlink($lock); echo $l->t("File not locked"); } else { echo $l->t("Status: locked"); } } else { @date_default_timezone_set('Europe/Berlin'); if (@$safe == "false") { $h = fopen($lock, "w"); fwrite($h, OCP\User::getUser() . " " . date(DATE_RFC822)); fclose($h); echo $l->t("File is locked"); } else {