Is there a way to output a list of all downloads

Client Joined: Jul 18, 2003 Posts: 977

I need to get a list of all the downloads in nsngd_downloads_downloads. I would like just the names and the path to the file. Is that possible?
Thanks!

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

Without seeing the schema I can only give a generis sql syntax.

SELECT `name`, `path_to_file`
FROM `nsngd_downloads_downloads`
[ORDER BY `var`]

The ORDER BY clause is optional - `var` would be a column in the nsngd_downloads_downloads table.

registered · Posted: Sun Oct 12, 2008 9:31 am

Here is the exact SQL to use in phpMyAdmin:

SELECT `title` , `url`
FROM `nuke_nsngd_downloads`

Worker Joined: Dec 01, 2008 Posts: 180

Any chance you can explain how to achieve this for the less intellectual people(?) whilst on this subject please. RN2.3 with nsn gr downloads.

xx Bless xx

Posted: Sat Feb 14, 2009 5:42 pm

i think there's a module to list all downloads... it was developed by nukescripts and it's called myDownloads (as far as i remember). You can look for it at warp-speed.de

Posted: Sat Feb 14, 2009 6:12 pm

What version would you say would work with RN2.3 and nsn gr downloads? as there are a few and i am clueless which one to choose:

http://warpspeed.4thdimension.de/modules.php?name=Downloads&d_op=search&query=

xx Bless xx

Posted: Sat Feb 14, 2009 6:37 pm

Choose latest version... it will only need a simple change in the sql query from nuke_downloads_downloads to nuke_nsngd_downloads. If you find any anomaly with the module usage post back.

Posted: Sat Feb 14, 2009 6:53 pm

what would you say is the best downloads module to use with raven nuke2.3?

Posted: Sat Feb 14, 2009 7:03 pm

For now? Just use the one that ships with RavenNuke(tm) Wink

Posted: Sat Feb 14, 2009 10:56 pm

Yeah Raven that's true... but also a lot of people are using nsn groups downloads, even when it is a little outdated. But to avoid some misc issues you might stay with the standard one.

Posted: Tue Feb 17, 2009 8:56 am

But what about the fact that nsn gr downloads as many added features that the standard has not, wouldn't this be a better module to have with RN rather than the standard one?

Posted: Tue Feb 17, 2009 9:08 am

This have been discussed in the past, we have been arguing the pros and cons of adding this module by default and btw I think Montego is working in an enhanced version of gr downloads

Posted: Tue Feb 17, 2009 9:44 am

Any chance there being a release date? as i do believe the existing standard downloads module is past dated.

In other words there are many features necessary, that gr downloads slightly offers, although i believe much more can be approved, as i hope Montego can do to enhance RN (great guy!).

Posted: Tue Feb 17, 2009 12:02 pm

No dates at the moment... maybe with next major version of RavenNuke it get a chance as the default.

Posted: Tue Feb 17, 2009 12:55 pm

I hope it definately becomes part of RN as i think this is by far a better module.

Well i am using NSN_GR_Downloads_750_103pl2, would this be the most up to date version, or is this past dated?

What i am trying to figure out is if i am using a older version, maybe its making scripting errors, that conflict with RN, that are less obvious to notice, or maybe a bug that requires a fix.

Where would you suggest i could find the most recent version, or am i using it?

Posted: Tue Feb 17, 2009 6:39 pm

Uhm... nsn_gd releases are kind of outdated now. You can always check latest version from http://nukescripts.net

Posted: Tue Feb 17, 2009 7:18 pm

That project reached EOL a long time ago.

Posted: Wed Feb 18, 2009 6:24 am

... Because I went AWOL on it several years back when Bob let me take it over. Sad

I see that I need to revitalize this project and will begin preparations as such.

Posted: Wed Feb 18, 2009 6:30 am

Nice 1 Montego!!!!!!!!!

Wave

Please let us all know when complete.

xx Bless xx

Posted: Wed Feb 18, 2009 9:11 am

Raven wrote:

That project reached EOL a long time ago.

- For the record, I wasn't even referring to you. I was referring to grabbing the d/l from Bob's site

Posted: Wed Feb 18, 2009 1:14 pm

Oops Sorry!
Embarassed

Posted: Wed Feb 18, 2009 2:30 pm

And, I wasn't referring to you either killing me

- Montego was my intended target/victim Wink

Posted: Wed Feb 18, 2009 8:53 pm

Oh my that is funny! (Still mean what I said - lol - I do need to get that thing cleaned up and will... who knows, maybe the RN Team is ready for a DL module change.)

Posted: Thu Feb 19, 2009 3:09 am

Montego wrote:

who knows, maybe the RN Team is ready for a DL module change

Sure we are. Just as soon as you return to active duty Wink

Posted: Thu Feb 19, 2009 8:01 am

Yeah, always ready to hit them all... ROTFL