blob: 6e4bc6643127aff1915253e0a009b3401e06bfdf (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
|
<?
function select($db){
if($_SESSION["login"]){
$share="";
} else {
$share ="AND share='PUBLIC'";
}
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 "parent: " . $parentdir . "<br>";
$content_db = $db->query("SELECT * FROM files WHERE parent=" . $parentdir . " AND owner=" . $owner . ";");
// $content_ar = $content_db->fetchArray(SQLITE3_NUM);
$count=0;
while($row = $content_db->fetchArray(SQLITE3_NUM)){
$content[$count][0] = $row[0];
$content[$count][1] = $row[1];
$content[$count][2] = $row[2];
$content[$count][3] = $row[3];
$content[$count][4] = $row[4];
$content[$count][5] = $row[5];
$content[$count][6] = $row[6];
$content[$count][7] = $row[7];
$content[$count][8] = $row[8];
//echo "<a href='/". $user . "/" . $content[$count][3] . "'>" . $content[$count][3] . "</a><br>";
$count++;
}
return $content;
}
|
