<?php
include "config.inc.php";
//include "uploadedFile.php";
include "alias.php";
adminPage();
$conn = getConnection();
if (strtoupper($_SERVER['REQUEST_METHOD']) == 'POST') {
$aliasText = issetOrBlank($_POST['alias']);
$pointer = issetOrBlank($_POST['pointer']);
//echo "Alias: ".$alias.", pointer: ".$pointer;
if ($aliasText != "" && $pointer != "") {
//we can add them if the alias doesn't already exist.
if (!startsWith($aliasText, "/")) {
$aliasText = "/" . $aliasText;
}
$alias = new Alias($conn);
$alias->setAlias($aliasText);
//must start with '/'
$numAliases = sizeof($alias->getObjectsLikeThis());
$alias->setType("url");
$alias->setPointer($pointer);
if ($alias->getAlias() != "/" && $numAliases == 0 && $alias->save() > 0) {
echo '<h1>Alias created OK!</h1>';
echo $alias->getAlias() . " will now point to: " . $pointer;
} else {
if ($numAliases > 0) {
echo '<p>The Alias: ' . $alias->getAlias() . ' already exists</p>';
} else {
if ($alias->getAlias() == "/") {
echo '<p>Alias cannot be saved as /</p>';
?> </select> </td> </tr> <tr> <td>File</td> <td> <input type="file" name="file-file" required/> </td> </tr> <tr> <td>Alias</td> <td><input name="file-alias" type="text" value="<?php echo issetOrBlank($_POST['file-alias']); ?> " placeholder="/alias" /></td> </tr> <tr> <td colspan="2"> <input type="submit" value="submit" /> </td> <tr> </table> </form>
$fileUpdate->setActive(issetOrBlank($_POST['file-active']) == "" ? 0 : 1);
if (!isset($_FILES["file-file"])) {
//no new file
$fileUpdate->setUploader($file->getUploader());
$fileUpdate->setSize($file->getSize());
$fileUpdate->setContentType($file->getContentType());
$fileUpdate->setExtension($file->getExtension());
$fileUpdate->setPath($file->getPath());
} else {
//$file->setUploader( ($_SESSION['username'] != "" ? $_SESSION['username'] : '******' ); //from session?
//$file->setSize($_FILES["file-file"]['size']);
//$file->setContentType( issetOrBlank($_FILES["file-file"]['type']) );
//$file->setExtension( pathinfo($_FILES["file-file"]['name'], PATHINFO_EXTENSION) );
//delete existing file
}
$fileAlias = issetOrBlank($_POST['file-alias']);
if (!startsWith($fileAlias, "/")) {
$fileAlias = "/" . $fileAlias;
}
// echo "Alias: ".$file->getAliasID();
// echo "Alias Text: ".$fileAlias;
//check if alias is new or changed.
$aliasFind = "SELECT `id` FROM `alias` WHERE `alias` = :ALIASTEXT";
$aliasFind = $conn->prepare($aliasFind);
$aliasFind->bindParam(':ALIASTEXT', $fileAlias);
$aliasFind->execute();
$aliasFind = $aliasFind->fetchAll(PDO::FETCH_ASSOC);
//echo "Alias ID: ".$aliasFind[0]['id'];
if ($aliasFind[0]['id'] == $file->getAliasID()) {
//echo "No Alias Update";
$fileUpdate->setAliasID($file->getAliasID());
session_start();
include "config.inc.php";
if (!isset($_SESSION['username'])) {
exit;
}
$type = $_GET['type'];
$draw = $_GET['draw'];
// current ID?
$start = $_GET['start'];
$length = (int) $_GET['length'];
$orderBy = (int) $_GET['order'][0]['column'];
$orderDir = $_GET['order'][0]['dir'];
$orderDir = $orderDir == "asc" ? "ASC" : "DESC";
//order[0][column]:2
//order[0][dir]:desc
$search = issetOrBlank($_GET['search']['value']);
if ($search != "") {
$search = "%" . $search . "%";
}
if ($start < 0 || !is_int($start)) {
$start = 0;
}
//https://datatables.net/manual/server-side
if ($type == "files") {
$conn = getConnection();
$query = "SELECT COUNT(`id`) as `cnt` FROM `uploadedfile`";
$result = $conn->prepare($query);
$result->execute();
$result = $result->fetchAll(PDO::FETCH_ASSOC);
$recordsTotal = $result[0]['cnt'];
if ($orderBy != "" && is_int($orderBy)) {
