public static function listFilesWithCategory($cat) { $renderer = new DA_Renderer(); $files = DA_DatabaseHandler::findInTable(FILES_TABLE, "categories", "%" . $cat . "%"); foreach ($files as $key => $file) { if (self::checkFileForPic($file["filename"])) { $files[$key]["thumbnail"] = 1; } if (self::getThumbForPdf($file["id"])) { $files[$key]["thumbnail"] = 2; } $folder = current(DA_DatabaseHandler::findInTable(FOLDERS_TABLE, "id", $file["parent_id"])); $files[$key]["parentname"] = $folder["filename"]; } $renderer->templatename = "catfrontend.html"; $renderer->setTemplate(); $renderer->arr["files"] = $files; $renderer->arr["dapath"] = "/wp-content/"; $renderer->arr["subpath"] = "uploads/downloadarea/"; return $renderer->renderArr(); }
public function updatePositions() { $this->table = FILES_TABLE; foreach ($_POST["sorting"] as $key => $file) { $folderinfo = current(DA_DatabaseHandler::findInTable(FOLDERS_TABLE, "id", $file["parent_id"])); $fileinfo = current(DA_DatabaseHandler::findInTable($this->table, "id", $file["id"])); DA_DatabaseHandler::updateTableRow(array($this->table => array("position" => $file["position"], "parent_id" => $file["parent_id"], "filepath" => $folderinfo["filepath"] . "/" . $fileinfo["filename"])), "id", $file["id"]); rename(DA_WP_PATH . $fileinfo["filepath"], DA_WP_PATH . $folderinfo["filepath"] . "/" . $fileinfo["filename"]); } echo "sorted!"; }