blob: 5ee342f2fbb6e6733268a6a5f26ea1e18b1eb048 (
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
|
<?php
function account($db){
echo "loged in as: " . $_SESSION["username"];
$safe_name=SQLite3::escapeString("$_SESSION[username]");
$invite_db = $db->query("SELECT invites FROM user WHERE name='" . $safe_name . "';");
$invite_ar = $invite_db->fetchArray(SQLITE3_NUM);
$invite = $invite_ar[0];
echo "<br><br>";
echo "You have currently $invite invites. <br>";
return true;
}
function user($db, $user){
$owner_db = $db->query("SELECT id FROM user WHERE name='" . SQLite3::escapeString($user) . "';");
$owner_ar = $owner_db->fetchArray(SQLITE3_NUM);
if(empty($owner_ar)){
return false;
}
$owner = $owner_ar[0];
return $owner;
}
function user_is_owner($username, $file_id){
$db = $GLOBALS["db"];
$owner_db = $db->query("SELECT owner FROM files WHERE id=". SQLite3::escapeString('$file_id') . ";");
$owner_ar = $owner_db->fetchArray(SQLITE3_NUM);
if($owner_ar[0] != $username){
return false;
} else {
return true;
}
}
|
