71 lines
2.2 KiB
PHP
71 lines
2.2 KiB
PHP
<?php
|
|
|
|
/* General Global Include Functions Here */
|
|
|
|
function contactDB($query, $column) {
|
|
|
|
// $query: the SQLite query to the database
|
|
// $column: the column you're asking the DB to report back on
|
|
// 1: fileid
|
|
// 2: filepath (link)
|
|
// 3: fileowner (user id)
|
|
// 4: filedate (uploaded date, unix timestamp)
|
|
// ie, $result = contactDB("SELECT * FROM files WHERE fileowner='admin';", 2);
|
|
// populates the $result[] array with the file paths to every file owned by the admin user
|
|
|
|
$dbresult = array();
|
|
|
|
$datab = 'sqlite:./filedb.sqlite';
|
|
$dbpdo = new PDO($datab) or die ("Fatal Error: Can't open the database");
|
|
|
|
foreach ($dbpdo->query($query) as $row) {
|
|
array_push($dbresult, $row[$column]);
|
|
}
|
|
|
|
$dbpdo = NULL; // Closing connection
|
|
return $dbresult;
|
|
}
|
|
|
|
function isLocalhost() {
|
|
// Returns true if the site is being served through 127.0.0.1
|
|
// This is used by upload.php in determining whether we can access the browser navigator.clipboard API from JavaScript to copy download links to the user's clipboard
|
|
|
|
return ( ($_SERVER['HTTP_HOST'] == "127.0.0.1") || ($_SERVER['HTTP_HOST'] == "localhost") );
|
|
}
|
|
|
|
function isSSL() {
|
|
// Returns true if on HTTPS, false if on HTTP
|
|
|
|
return ( (!empty($_SERVER['HTTPS']) && $_SERVER['HTTPS'] !== 'off') || $_SERVER['SERVER_PORT'] == 443);
|
|
}
|
|
|
|
function get_download_link($file_id) {
|
|
// Returns the full (absolute) link to download.php?id= ($file_id)
|
|
|
|
// Check if we're on HTTPS or HTTP
|
|
if (isSSL()) {
|
|
$url = "https://";
|
|
} else {
|
|
$url = "http://";
|
|
}
|
|
|
|
// Get the URL of the current page
|
|
// e.g: https://127.0.0.1/some/directory/SimpleFS/upload.php
|
|
$url .= $_SERVER['HTTP_HOST'] . $_SERVER['PHP_SELF'];
|
|
|
|
// Find the last slash (the directory we're in, rather than the file)
|
|
$position_of_last_slash = strrpos($url, "/");
|
|
|
|
// Trim the URL to just that directory
|
|
// e.g: https://127.0.0.1/some/directory/SimpleFS/
|
|
$url = substr($url, 0, $position_of_last_slash + 1);
|
|
|
|
// Append download.php?id= (the id supplied)
|
|
// e.g: https://127.0.0.1/some/directory/SimpleFS/download.php?id=12345
|
|
$url .= "download.php?id=$file_id";
|
|
|
|
return $url;
|
|
}
|
|
|
|
?>
|