diff options
| author | jhunkeler <jhunkeler@c5b2fb0a-d05d-0410-98c8-828840a80ff6> | 2010-01-07 19:56:38 -0500 |
|---|---|---|
| committer | jhunkeler <jhunkeler@c5b2fb0a-d05d-0410-98c8-828840a80ff6> | 2010-01-07 19:56:38 -0500 |
| commit | 0894cc944c5147fe2d4fc41db859b73676396b74 (patch) | |
| tree | 4ae0b11bf80eed54b253c65b60066498919f223c /modules | |
| parent | e62cd7f5662928977738f80990322b4433e67d51 (diff) | |
| download | bayonetcms-0894cc944c5147fe2d4fc41db859b73676396b74.tar.gz | |
Preliminary category based download page
git-svn-id: http://svn.3rd-infantry-division.org/testing/branches/Bayonet CMS v2@457 c5b2fb0a-d05d-0410-98c8-828840a80ff6
Diffstat (limited to 'modules')
| -rw-r--r-- | modules/download/index.php | 116 |
1 files changed, 93 insertions, 23 deletions
diff --git a/modules/download/index.php b/modules/download/index.php index 983b6f8..0c0ed2e 100644 --- a/modules/download/index.php +++ b/modules/download/index.php @@ -21,41 +21,111 @@ if(!defined("MODULE_FILE")) {
die("Access denied...");
}
+
+function getCategoryList()
+{
+ global $db;
+ $query = sprintf("SELECT category_id, title FROM bayonet_downloads_categories");
+ $result = $db->Query($query);
+ $categories = $db->Fetch($result);
+
+ return $categories;
+}
+
+function getCategoryName($category)
+{
+ global $db;
+ if(!filter_var($category, FILTER_VALIDATE_INT))
+ return array();
+
+ $query = sprintf("SELECT category_id, title FROM bayonet_downloads_categories WHERE category_id = %d", (int)$category);
+ $result = $db->Query($query);
+ $data = $db->FetchRow($result);
+
+ return $data['title'];
+ //return is_array($data) ? $data : array();
+}
+
+function getCategoryFiles($category)
+{
+ global $db;
+ $query = sprintf("SELECT ca.category_id, ca.title AS category, dl.name, dl.filename, dl.description FROM bayonet_downloads_categories AS ca LEFT OUTER JOIN bayonet_downloads AS dl ON dl.category_id = ca.category_id WHERE ca.category_id = %d", (int)$category);
+
+ $result = $db->Query($query);
+ $downloads = $db->FetchArray($result);
+ decho('downloads data');
+ decho($downloads);
+ decho('downloads data done');
+
+ return $downloads;
+}
+
global $db;
-$download = NULL;
+$downloads = NULL;
$download_relative_path = "modules/" . basename(dirname(__FILE__)) . "/files/";
$download_absolute_path = dirname(__FILE__) . "/files/";
-$download = $db->Query("SELECT `file_id`, `name`, `description`, `filename` FROM `bayonet_downloads`");
+$category = $_GET['category'];
+if(isset($category) && !filter_var($category, FILTER_VALIDATE_INT))
+{
+ ReportHack("Purposely invalid category entry.");
+ return;
+}
+
+$downloads = getCategoryFiles($category);
+decho($downloads);
OpenContent();
-echo "<div class=\"contentHeading\">Downloads</div>";
-echo "<div class=\"content\">";
-foreach($download as $file)
-{
- $download_full_path = $download_absolute_path . $file['filename'];
-
- if(file_exists($download_full_path))
+echo "<div class=\"contentHeading\">Categories</div>\n";
+echo "<div class=\"content\">\n";
+
+$categoryList = getCategoryList();
+
+ foreach($categoryList as $categoryListItem)
{
echo "<p>";
- echo LinkInternal($file['name'], $file['filename'], $download_relative_path) . "<br/>\n";
- echo "<b>Filename:</b> {$file['filename']}<br/>\n";
- printf("<b>Size:</b> %.2fKB<br/>\n", filesize($download_full_path) / 1024);
- echo "<b>MD5 Hash:</b> " . md5_file($download_full_path) . "<br/>\n";
- echo "<b>Description:</b> {$file['description']}<br/>\n";
- echo "</p>";
- }
- else
- {
- decho("File $download_absolute_path{$file['filename']} does not exist! Not listing for download.");
+ echo LinkModule("download", "&category={$categoryListItem['category_id']}",$categoryListItem['title']);
+ echo "</p>\n";
}
-}
-decho($download);
-//logQueueFlush(FORCE);
-echo "</div>";
+echo "</div>\n</div>\n";
CloseContent();
+OpenContent();
+echo "<div class=\"contentHeading\">" . getCategoryName($category) . "</div>\n";
+echo "<div class=\"content\">\n";
+
+ OpenContent();
+ echo "<div class=\"contentHeading\">Files</div>\n";
+ echo "<div class=\"content\">\n";
+
+ if(empty($downloads))
+ {
+ echo "No downloads available.\n";
+ return;
+ }
+
+ foreach($downloads as $file)
+ {
+ $download_full_path = $download_absolute_path . $file['filename'];
+
+ if(!file_exists($download_full_path)) $broken = "(Broken link detected)";
+ echo "<p>";
+ echo LinkInternal($file['name'], $file['filename'], $download_relative_path) . " $broken<br/>\n";
+ echo "<b>Filename:</b> {$file['filename']}<br/>\n";
+ printf("<b>Size:</b> %.2fKB<br/>\n", filesize($download_full_path) / 1024);
+ echo "<b>MD5 Hash:</b> " . md5_file($download_full_path) . "<br/>\n";
+ echo "<b>Description:</b> {$file['description']}<br/>\n";
+ echo "</p>";
+
+ }
+ //logQueueFlush(FORCE);
+
+ echo "</div>\n</div>";
+ echo "</div>\n</div>";
+
+ CloseContent();
+CloseContent();
?>
|