PHP Web Host - Quality Web Hosting For All PHP Applications Clan Themes! We make clans look good!!
  Login or Register
 • Home • Downloads • Your Account • Forums • 

View next topic
View previous topic


Google
 
Web RavenPHPScripts (This Site)
Post new topic   Reply to topic
Author Message
blith
Client


Joined: Jul 18, 2003
Posts: 975

PostPosted: Fri Oct 10, 2008 1:56 pm Reply with quote Back to top

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!
View user's profile Send private message Visit poster's website
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 16647
Location: Kansas

PostPosted: Sat Oct 11, 2008 1:21 am Reply with quote Back to top

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.
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger
montego
Site Admin


Joined: Aug 29, 2004
Posts: 8625
Location: Arizona

PostPosted: Sun Oct 12, 2008 9:31 am Reply with quote Back to top

Here is the exact SQL to use in phpMyAdmin:

SELECT `title` , `url`
FROM `nuke_nsngd_downloads`
View user's profile Send private message Visit poster's website
pureliving
Worker
Worker


Joined: Dec 01, 2008
Posts: 161

PostPosted: Sat Feb 14, 2009 5:29 pm Reply with quote Back to top

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
View user's profile Send private message
jestrella
Moderator


Joined: Dec 01, 2005
Posts: 395
Location: Latin America, Dominican Republic, Santiago

PostPosted: Sat Feb 14, 2009 5:42 pm Reply with quote Back to top

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
View user's profile Send private message Visit poster's website
pureliving
Worker
Worker


Joined: Dec 01, 2008
Posts: 161

PostPosted: Sat Feb 14, 2009 6:12 pm Reply with quote Back to top

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:
Only registered users can see links on this board!
Get registered or login to the forums!


xx Bless xx
View user's profile Send private message
jestrella
Moderator


Joined: Dec 01, 2005
Posts: 395
Location: Latin America, Dominican Republic, Santiago

PostPosted: Sat Feb 14, 2009 6:37 pm Reply with quote Back to top

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.
View user's profile Send private message Visit poster's website
pureliving
Worker
Worker


Joined: Dec 01, 2008
Posts: 161

PostPosted: Sat Feb 14, 2009 6:53 pm Reply with quote Back to top

what would you say is the best downloads module to use with raven nuke2.3?
View user's profile Send private message
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 16647
Location: Kansas

PostPosted: Sat Feb 14, 2009 7:03 pm Reply with quote Back to top

For now? Just use the one that ships with RavenNuke(tm) Wink
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger
jestrella
Moderator


Joined: Dec 01, 2005
Posts: 395
Location: Latin America, Dominican Republic, Santiago

PostPosted: Sat Feb 14, 2009 10:56 pm Reply with quote Back to top

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.
View user's profile Send private message Visit poster's website
pureliving
Worker
Worker


Joined: Dec 01, 2008
Posts: 161

PostPosted: Tue Feb 17, 2009 8:56 am Reply with quote Back to top

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?
View user's profile Send private message
jestrella
Moderator


Joined: Dec 01, 2005
Posts: 395
Location: Latin America, Dominican Republic, Santiago

PostPosted: Tue Feb 17, 2009 9:08 am Reply with quote Back to top

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
View user's profile Send private message Visit poster's website
pureliving
Worker
Worker


Joined: Dec 01, 2008
Posts: 161

PostPosted: Tue Feb 17, 2009 9:44 am Reply with quote Back to top

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!).
View user's profile Send private message
jestrella
Moderator


Joined: Dec 01, 2005
Posts: 395
Location: Latin America, Dominican Republic, Santiago

PostPosted: Tue Feb 17, 2009 12:02 pm Reply with quote Back to top

No dates at the moment... maybe with next major version of RavenNuke it get a chance as the default.
View user's profile Send private message Visit poster's website
pureliving
Worker
Worker


Joined: Dec 01, 2008
Posts: 161

PostPosted: Tue Feb 17, 2009 12:55 pm Reply with quote Back to top

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?
View user's profile Send private message
jestrella
Moderator


Joined: Dec 01, 2005
Posts: 395
Location: Latin America, Dominican Republic, Santiago

PostPosted: Tue Feb 17, 2009 6:39 pm Reply with quote Back to top

Uhm... nsn_gd releases are kind of outdated now. You can always check latest version from
Only registered users can see links on this board!
Get registered or login to the forums!
View user's profile Send private message Visit poster's website
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 16647
Location: Kansas

PostPosted: Tue Feb 17, 2009 7:18 pm Reply with quote Back to top

That project reached EOL a long time ago.
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger
montego
Site Admin


Joined: Aug 29, 2004
Posts: 8625
Location: Arizona

PostPosted: Wed Feb 18, 2009 6:24 am Reply with quote Back to top

... 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.
View user's profile Send private message Visit poster's website
pureliving
Worker
Worker


Joined: Dec 01, 2008
Posts: 161

PostPosted: Wed Feb 18, 2009 6:30 am Reply with quote Back to top

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

Wave Wave Wave

Please let us all know when complete.

xx Bless xx
View user's profile Send private message
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 16647
Location: Kansas

PostPosted: Wed Feb 18, 2009 9:11 am Reply with quote Back to top

Raven wrote:
That project reached EOL a long time ago.

killing me - For the record, I wasn't even referring to you. I was referring to grabbing the d/l from Bob's site
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger
pureliving
Worker
Worker


Joined: Dec 01, 2008
Posts: 161

PostPosted: Wed Feb 18, 2009 1:14 pm Reply with quote Back to top

Oops Sorry!
Embarassed
View user's profile Send private message
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 16647
Location: Kansas

PostPosted: Wed Feb 18, 2009 2:30 pm Reply with quote Back to top

And, I wasn't referring to you either killing me - Montego was my intended target/victim Wink
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger
montego
Site Admin


Joined: Aug 29, 2004
Posts: 8625
Location: Arizona

PostPosted: Wed Feb 18, 2009 8:53 pm Reply with quote Back to top

ROTFL killing me 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.)
View user's profile Send private message Visit poster's website
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 16647
Location: Kansas

PostPosted: Thu Feb 19, 2009 3:09 am Reply with quote Back to top

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
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger
jestrella
Moderator


Joined: Dec 01, 2005
Posts: 395
Location: Latin America, Dominican Republic, Santiago

PostPosted: Thu Feb 19, 2009 8:01 am Reply with quote Back to top

Yeah, always ready to hit them all... ROTFL
View user's profile Send private message Visit poster's website
Display posts from previous:       
Post new topic   Reply to topic

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Forums ©
 

All logos and trademarks in this site are property of their respective owner.
The comments are property of their posters, all the rest © 2002-2010 by Raven

You can syndicate our news using the file xml

CSE HTML Validator Helped Clean up This Page! [Valid RSS] valid RSS 2.0 Valid robots.txt Stop Spam Harvesters, Join Project Honey Pot

Website engines core code is © copyright by PHP-Nuke but has been heavily patched and modified by myself and others.
PHP-Nuke is a free software released under the GNU/GPL.


:: fisubice phpbb2 style by Daz :: PHP-Nuke theme by www.nukemods.com ::
:: fisubice Theme Modified by the RavenNuke™ Team ::

:: W3C CSS Compliance Validation :: W3C HTML 4.01 Transitional Compliance Validation ::

zerosum