summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorroot2014-03-10 15:33:18 +0100
committerroot2014-03-10 15:33:18 +0100
commite93cb148d7dbfe8276db9e3b28ec439ba47f157b (patch)
treef668cd2231a33095f63d3753c460feb5b367c9a8
parent833d72001d3df1680913759ff760708766618eb8 (diff)
downloadfiles.iamfabulous.de-e93cb148d7dbfe8276db9e3b28ec439ba47f157b.tar.gz
rm
-rw-r--r--tmp/select.php68
1 files changed, 0 insertions, 68 deletions
diff --git a/tmp/select.php b/tmp/select.php
deleted file mode 100644
index ffa12d1..0000000
--- a/tmp/select.php
+++ /dev/null
@@ -1,68 +0,0 @@
-<?
-
-session_start();
-
-if($_SESSION["login"]){
- $share="";
-} else {
- $share ="AND share='PUBLIC'";
-}
-
-$db = new SQLite3("../database/sqlite.db");
-
-function failure($reason){
- echo "A 404 error occurred. <br>";
- echo $reason;
- exit;
-}
-
-if(!empty($_GET["name"])){
- $user = $_GET["name"];
-} else {
- failure("No user input.");
-}
-
-$owner_db = $db->query("SELECT id FROM user WHERE name='" . SQLite3::escapeString($user) . "';");
-
-if(empty($owner_db)){
- failure("This user doesn't exist.");
-}
-
-$owner_ar = $owner_db->fetchArray(SQLITE3_NUM);
-$owner = $owner_ar[0];
-
-$folder_array_unsafe = explode("/",$_GET["folder"]);
-$length = count($folder_array_unsafe);
-
-
-$root_db = $db->query("SELECT id FROM files WHERE parent=0 AND owner=" . $owner . " AND folder='DIRECTORY' " . $share . ";");
-if(empty($root_db)){
- failure("There is something seriously wrong. If you are a human you should never read this. Mail the admin please.");
-}
-$root_ar = $root_db->fetchArray(SQLITE3_NUM);
-$root_id = $root_ar[0];
-$parentdir = SQLite3::escapeString($root_id);
-$temp_id = $root_id;
-
-
-for($i=0; $i<$length; $i++){
-
- if(!empty($folder_array_unsafe[$i])){
- $parentdir_db = $db->query("SELECT id, parent FROM files WHERE owner=" . $owner . " AND folder='DIRECTORY' " . $share . " AND parent=" . $parentdir . " AND name='" . SQLite3::escapeString($folder_array_unsafe[$i]) . "';");
- if(empty($parentdir_db)){
- failure("Database error.");
- }
- $prim_id = $parentdir_db->fetchArray(SQLITE3_NUM);
- if($parentdir != $prim_id[1]){
- failure("This folder doesn't exist. Folder: " . $folder_array_unsafe[$i]);
- }
-
- $parentdir = $prim_id[0];
- echo SQLite3::escapeString($folder_array_unsafe[$i]);
-
- echo "<br>";
- }
-}
-
-$content_db = $db->query("SELECT id, name, folder FROM files WHERE parent=" . $parentdir . " AND owner=" . $owner . ";");
-$content_ar = $conten_db->fetchArray(SQLITE3_NUM);