Enhanced Downloads Module Version 2.1

rickleigh · Worker Joined: Jan 06, 2009 Posts: 183

I there a Ver. of this that will work with RN2.3.1? I tried it on my test site and it isn't installing all the tables. I'm getting the following errors:

Quote:

-- Table nuke_downloads_categories altered successfully.

** Error Altering Table: nuke_downloads_categories **

** Error Altering Table: nuke_downloads_downloads **

** Error Altering Table: nuke_downloads_downloads **

** Error Altering Table: nuke_downloads_downloads **

** Error Altering Table: nuke_downloads_downloads **

** Error Altering Table: nuke_downloads_downloads **

** Error Altering Table: nuke_downloads_downloads **

-- Table nuke_downloads_downloads altered successfully.

-- Table nuke_downloads_downloads altered successfully.

** Error Altering Table: nuke_downloads_modrequest **

** Error Altering Table: nuke_downloads_modrequest **

** Error Altering Table: nuke_downloads_modrequest **

** Error Altering Table: nuke_downloads_modrequest **

-- Table nuke_downloads_modrequest altered successfully.

-- Table nuke_downloads_modrequest altered successfully.

** Error Altering Table: nuke_downloads_newdownload **

** Error Altering Table: nuke_downloads_newdownload **

** Error Altering Table: nuke_downloads_newdownload **

** Error Altering Table: nuke_downloads_newdownload **

-- Table nuke_downloads_newdownload altered successfully.

-- Table nuke_downloads_newdownload altered successfully.

** Error Creating Table: nuke_ns_downloads_new_pop **

** Dump Error for Table: nuke_ns_downloads_new_pop **

-- Table nuke_ns_downloads_rating created successfully.

-- Table Dump for nuke_ns_downloads_rating successful.

** Error Creating Table: nuke_ns_downloads_general **

** Dump Error for Table: nuke_ns_downloads_general **

-- Table nuke_ns_downloads_add_modify created successfully.

-- Table Dump for nuke_ns_downloads_add_modify successful.

** Error Creating Table: nuke_ns_downloads_desc_img **

** Dump Error for Table: nuke_ns_downloads_desc_img **

-- Table nuke_ns_downloads_theme created successfully.

** Error Creating Table: nuke_ns_downloads_theme_mode **

** Error Creating Table: nuke_ns_downloads_table_form **

** Error Creating Table: nuke_ns_downloads_table_html **

** Error Creating Table: nuke_ns_downloads_upload **

** Dump Error for Table: nuke_ns_downloads_upload **

-- Table nuke_ns_downloads_field created successfully.

** Error Creating Table: nuke_ns_downloads_field_perm **

** Dump Error for Table: nuke_ns_downloads_field_perm **

** Error Creating Table: nuke_ns_downloads_nfeatured **

** Error Creating Table: nuke_ns_downloads_recommend **

** Dump Error for Table: nuke_ns_downloads_recommend **

** Error Creating Table: nuke_ns_downloads_recom_dlstats **

** Error Creating Table: nuke_ns_downloads_recom_usrstats **

** Error Creating Table: nuke_ns_downloads_fetch **

** Dump Error for Table: nuke_ns_downloads_fetch **

** Error Creating Table: nuke_ns_downloads_auth **

** Dump Error for Table: nuke_ns_downloads_auth **

** Error Creating Table: nuke_ns_downloads_blocks **

** Dump Error for Table: nuke_ns_downloads_blocks **

trunks · Posted: Mon Mar 02, 2009 5:24 am

Not sure to be honest, never tried it on 2.3.1 Have you tried adding the sql manually?

jakec · Posted: Mon Mar 02, 2009 5:37 am

Just wondering if it using the old database layer. Are there any $dbi in the code?

rickleigh · Worker Joined: Jan 06, 2009 Posts: 183

jakec,

Yes, There is $dbi in the code. Is this correct or should it be something else? I see this same Ver. of EDM on this site. So, if this site is running RN2.3.1 then Raven or someone has the correct EDM.

jakec · Posted: Mon Mar 02, 2009 7:39 am

This site is not yet using RN, I believe Raven is working on it. Wink

There is a sticky in the forums here about converting block/modules to use the new datatbase layer. This should fix your problem hopefully.

rickleigh · Worker Joined: Jan 06, 2009 Posts: 183

trunks,

There isn't a SQL file by itself in the package and I don't no how to extract it from the install.php file. I'm still learning how to deal with php code and have to rely on the support of others like you.

I hope that one day I can support and help others here to. Right now I feel like a leech by always asking and not giving. I'm $10,000 in debt right now which makes it hard to pay or donate to anyone.

So, with that being said. I am always grateful for any support I get.

Palbin · Posted: Mon Mar 02, 2009 9:23 am

This is kind of a big module to convert from $dbi to $db. There for I would just search the forums about uncommenting the $dbi layer in mainfile.php.

Hopefully in the next release of RN we will have a more advanced download module, but you can never be sure until it is released Smile

rickleigh · Worker Joined: Jan 06, 2009 Posts: 183

Palbin,

Thanks, Is this the information your referring to?:

Only registered users can see links on this board!
Get registered or login to the forums!

nuken · Posted: Mon Mar 02, 2009 11:05 am

Only registered users can see links on this board!
Get registered or login to the forums!

This is the one about mainfile changes for dbi.

rickleigh · Worker Joined: Jan 06, 2009 Posts: 183

nuken wrote:

Only registered users can see links on this board!
Get registered or login to the forums!

This is the one about mainfile changes for dbi.

Thanks nuken,

Is this site using the new RN 2.3.1. If so, where might I find the Version of EDM that is being used on here?

nuken · Posted: Wed Mar 04, 2009 9:11 pm

I believe this site is not RN 2.30.10. You can get EDL 2.1 here

Only registered users can see links on this board!
Get registered or login to the forums!

jackel · Worker Joined: Jan 15, 2009 Posts: 145 Location: Iowa, USA

ok
So if i wanted to get this to work i need to change all $dbi to $db

Code:

function ns_dl_OpenTable() {
global $prefix, $dbi, $ns_theme, $module_name;
$result_th = sql_query("select id, name from ".$prefix."_ns_downloads_theme where name='$ns_theme'", $dbi);
list($id, $name) = sql_fetch_array($result_th, $dbi);
$result_md = sql_query("select mode, mset from ".$prefix."_ns_downloads_theme_mode where id='$id'", $dbi);
list($mode, $mset) = sql_fetch_array($result_md, $dbi);
if ($mset == 0) {
OpenTable2();
} elseif ($mset == 1) {
   if ($mode == 1) {
      OpenTable2();
   } elseif ($mode == 2) {
      $result_m2 = sql_query("select width, cpad, cspace, align, bdr, bdrclr, trclr, tdclr, bgclr, bgimg from ".$prefix."_ns_downloads_table_form where id='$id' && act='1'", $dbi);

to

Code:

function ns_dl_OpenTable() {
global $prefix, $db, $ns_theme, $module_name;
$result_th = sql_query("select id, name from ".$prefix."_ns_downloads_theme where name='$ns_theme'", $db);
list($id, $name) = sql_fetch_array($result_th, $db);
$result_md = sql_query("select mode, mset from ".$prefix."_ns_downloads_theme_mode where id='$id'", $db);
list($mode, $mset) = sql_fetch_array($result_md, $db);
if ($mset == 0) {
OpenTable2();
} elseif ($mset == 1) {
   if ($mode == 1) {
      OpenTable2();
   } elseif ($mode == 2) {
      $result_m2 = sql_query("select width, cpad, cspace, align, bdr, bdrclr, trclr, tdclr, bgclr, bgimg from ".$prefix."_ns_downloads_table_form where id='$id' && act='1'", $db);

I might just be dumb Smile

but just wondering I'm betting theres alot more lol <wishin it would be that easy

Thanks

nuken · Posted: Thu Mar 05, 2009 10:18 am

Quote:

So if i wanted to get this to work i need to change all $dbi to $db

Or do the mainfile.php changes and it should work with the old dbi.

Only registered users can see links on this board!
Get registered or login to the forums!

My opinion, it's easier to use NSN_GR downloads if you want a better downloads module.

Reasons being, EDL is a dead project from my understanding. NSN_GR is getting ready to have a rebirth thanks to montego. Wave

jackel · Worker Joined: Jan 15, 2009 Posts: 145 Location: Iowa, USA

you have a link?

nuken · Posted: Thu Mar 05, 2009 10:30 am

It can be downloaded from nukescripts.net.
You will have to comment out the include headers in the install files before it will install the DB in RavenNuke(tm)

ex. inside nsngd_installer directory, most all the files will have :

Code:

$pagetitle = $pagename.": Upgrade 1.0.0 - 1.0.1";
@include("header.php");
title($pagetitle);

just change that to :

Code:

$pagetitle = $pagename.": Upgrade 1.0.0 - 1.0.1";
//@include("header.php");
title($pagetitle);

and it should work with out a problem.

Download link

Only registered users can see links on this board!
Get registered or login to the forums!

jackel · Worker Joined: Jan 15, 2009 Posts: 145 Location: Iowa, USA

I tried to download that and its a blank file ? could you email it to me?

Only registered users can see links on this board!
Get registered or login to the forums!

?

jackel · Worker Joined: Jan 15, 2009 Posts: 145 Location: Iowa, USA

ok i got the download thanks but the install is having trouble i can't get the SQL to load do you have a manual SQL?

nuken · Posted: Thu Mar 05, 2009 11:34 am

I'm gonna run it on a test site and see what is happening. Give me a minute.

rickleigh · Worker Joined: Jan 06, 2009 Posts: 183

jackel wrote:

I tried to download that and its a blank file ? could you email it to me?

Only registered users can see links on this board!
Get registered or login to the forums!

?

Jackel,

Did you get this error after trying to extract the file? The error I'm getting is:
tar: This does not look like a tar archive
tar: Skipping to next header
tar: Error exit delayed from previous errors

I'm trying to extract using the cpanel/ file manager

nuken · Posted: Thu Mar 05, 2009 11:58 am

If you use 7-Zip, it should uncompress without any issue.

jackel · Worker Joined: Jan 15, 2009 Posts: 145 Location: Iowa, USA

nuken,

Everythign works like a charm with RN this file should be uploaded to raven for others can use it

Thanks Again

JoAnne · Worker Joined: Oct 18, 2005 Posts: 127 Location: NYC

Does NSN_GR have the ability to add an image to the download?

nuken · Posted: Sat Mar 07, 2009 8:18 am

Only through HTML in the description.

JoAnne · Worker Joined: Oct 18, 2005 Posts: 127 Location: NYC

nuken wrote:

Only through HTML in the description.

That should work. I liked EDL because it allowed an image for each download.

I am going to try NSN_GR

Thanks nuken

JoAnne

jackel · Worker Joined: Jan 15, 2009 Posts: 145 Location: Iowa, USA

Yea it does all you have to do in the in the DL exstension settings make jpg, jpeg and gif both file type and image type and works like a charm I love it

Nuken is da man for getting this work