downloads.php modify
Asked Modified Viewed 1,483 times
asked
Hello! I justwas wondering how to modify download.php to show all files (with pagination 10 per page), no matter the category. Just to show me last 10 files.
I don't need panel. I need to edit/modify download.php to show the files that way.
Order by datestamp , latest 10-15 files in all category.
I don't need panel. I need to edit/modify download.php to show the files that way.
Order by datestamp , latest 10-15 files in all category.
answered
Well, why not use the code of panel "latest_downloads"?
Try this:
In line:
ORDER BY download_datestamp DESC LIMIT 0,10");
it's sorted by datestamp. You can set number of downloads to show (10) and kind of sort (DESC).
Try this:
Code Download source
$result = dbquery(
"SELECT td.download_id, td.download_title, td.download_cat, td.download_datestamp,
tc.download_cat_id, tc.download_cat_access
FROM ".DB_DOWNLOADS." td
INNER JOIN ".DB_DOWNLOAD_CATS." tc ON td.download_cat=tc.download_cat_id
".(iSUPERADMIN ? "" : " WHERE ".groupaccess('download_cat_access'))."
ORDER BY download_datestamp DESC LIMIT 0,10");
if (dbrows($result)) {
while($data = dbarray($result)) {
$download_title = trimlink($data['download_title'], 40);
echo THEME_BULLET." <a href='".BASEDIR."downloads.php?download_id=".$data['download_id']."' title='".$data['download_title']."' class='side'>".$download_title."</a><br />\n";
}
} else {
echo "<div style='text-align:center'>".$locale['global_033']."</div>\n";In line:
ORDER BY download_datestamp DESC LIMIT 0,10");
it's sorted by datestamp. You can set number of downloads to show (10) and kind of sort (DESC).
answered
This code hasn't pagination, so it's useless ... I tried to edit the database querries in download.php to get the right list of added downloads, but it's a little bit harder than I was thinkin' it ...
http://graph-pieces.com/Downloads - this is the page I want to change ... Look what I've done and now just want to see last 10 downloads in the index of download.php file, because now, it shows the last 3 files from each category, no matter I'm not added them ... :)
http://graph-pieces.com/Downloads - this is the page I want to change ... Look what I've done and now just want to see last 10 downloads in the index of download.php file, because now, it shows the last 3 files from each category, no matter I'm not added them ... :)
Category Forum
Content Administration - 8Labels
None yet
Statistics
- Views 0 views
- Posts 2 posts
- Votes 0 votes
- Topic users 2 members
2 participants
Notifications
Track thread
You are not receiving notifications from this thread.
Related Questions