NSN DL's + Dynamic Titles

killer007 · New Member Joined: Dec 01, 2006 Posts: 16

Helloo I installed both NSN DL's and Dynamic titles But Now title is not changing i also changed "_downloads_downloads to nsngd_downloads and Categories but still not working any body can please help ?

hitwalker · Sells PC To Pay For Divorce Joined: Posts: 5661

huh...can you explain that again...
what are you trying to accomplish ?

kguske · Site Admin Joined: Jun 04, 2004 Posts: 6044

I think I understand the first part - the Dynamic Titles mod may not have logic to detect NSN Group Downloads, so it won't load titles there.

killer007 · New Member Joined: Dec 01, 2006 Posts: 16

Well yeah Dynamic titles working with phpnuke downloads system but when i install NSN downloads it stop working for downloads working for others like Forums and New's etc i changed "_downloads_categories" to "_nsngd_categories" but still not working .. .

montego · Posted: Sun Dec 10, 2006 10:38 am

I use NSN GR Downloads myself and have this working. Replace the existing downloads code in includes/dynamic_titles.php with the following:

Code:

if($name=="Downloads"){
global $op,$cid,$lid;
$cid = intval( $cid );
$lid = intval( $lid );
$newpagetitle = "$sitename $item_delim $name";
$newpagetitle = check_html($newpagetitle, nohtml);
if ( $cid ) {
$sql = "SELECT title, parentid FROM ".$prefix."_nsngd_categories WHERE cid='$cid'";
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$cat = $row['title'];
$parent = $row['parentid'];
if($parent=="0"){
$newpagetitle = "$cat";
$newpagetitle = check_html($newpagetitle, nohtml);
}
else{
$sql = "SELECT title FROM ".$prefix."_nsngd_categories WHERE cid='$parent'";
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$parent = $row['title'];
$newpagetitle = "$parent $item_delim $cat";
$newpagetitle = check_html($newpagetitle, nohtml);
}
}
if($op=="viewdownloaddetails" || $op=="getit") {
   $sql = "SELECT title FROM ".$prefix."_nsngd_downloads WHERE lid='$lid'";
   $result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
   $dl = $row['title'];
   $newpagetitle = "$dl";
$newpagetitle = check_html($newpagetitle, nohtml);
}
}

kguske · Site Admin Joined: Jun 04, 2004 Posts: 6044

Thanks, Montego.

killer007 · New Member Joined: Dec 01, 2006 Posts: 16

Well thanks sir now its working i also installed TN_ShortLinks for nsn downloads its working but i noticed one thing that 1st my links were like this > "downloadview-details-1-Download-name.html" But Now its Changed "download-file-1.html" and can u guys tell me where i can get "Enhanced Downloads Module 2.1" ?

killer007 · New Member Joined: Dec 01, 2006 Posts: 16

Sorry for Double Posting but i Got Enhanced Downloads Block here is the link "http://upload2.net/page/download/x4RQ5ChxLDnYXx2/Nukestyles_EDL_V21_dm1a.zip.html"
but now prob is when i try to install it giving me errors of altering few tables and creating tables any of you guys can send me sql file so that i can manually add and alter tables ? thanks in advance.

montego · Posted: Mon Dec 11, 2006 6:00 am

Sorry, don't have it...

Guardian2003 · Posted: Mon Dec 11, 2006 6:00 am

I think you'l need to make your mind up which downloads module you are going to use - no offence.
The enhanced download block wil onlu work with the enhanced download module (NOT NSN GR Downloads) as the table structure is probabbly different.
As NSN GR Downloads uses its own tables and I think Enhanced Downloads alters the existing downloads tables you are on the fast track to disaster if you are not very careful.

What is it exactly you are trying to achieve?

kguske · Site Admin Joined: Jun 04, 2004 Posts: 6044

EDL 2.1 is commercial, and as Guardian2003 stated, it uses different table structures than NSN GR Downloads. If you've already installed NSN GR Downloads, I'd suggest looking for or creating a block that provides what you need using NSN GR Downloads tables.

killer007 · New Member Joined: Dec 01, 2006 Posts: 16

Well installer with EDl 2.1 is not creating tables thats my prob and also i gave u guys link to download that so please can u guys grab all mysql data from install.php ?

hitwalker · Sells PC To Pay For Divorce Joined: Posts: 5661

Quote:

is not creating tables

so why should it work for us ?

killer007 · New Member Joined: Dec 01, 2006 Posts: 16

Mean i can see everything in install.php but not creating tables and also giving errors while altering few here is code of install.php

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

hitwalker · Sells PC To Pay For Divorce Joined: Posts: 5661

well you cant expect us to install it ...
if you see any errors then just post them here...

killer007 · New Member Joined: Dec 01, 2006 Posts: 16

well sir i am not saying that you guys install it and i told you it giving me errors when creating tales and altering tables and thats php file so i dont know how i can grab all mysql data from it so that i can creat and alter tabels throught phpmyadmin

kguske · Site Admin Joined: Jun 04, 2004 Posts: 6044

I think hitwalker is saying that it would be easier if you posted the errors.

killer007 · New Member Joined: Dec 01, 2006 Posts: 16

Code:

-- 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 **

Installation complete.

You now have the best d*** Downloads Module in all of NukeLand!

If you see an error in the update above, or are having any trouble setting up the administration, please use the Support Forums set up specifically for the EDL V2.0+.

Please do not email me for support... I can't handle all of the emails, and they WILL be ignored.

Please delete this file from your server immediatly for security reasons.

Thank You for purchasing the EDL V2.1!

© NukeStyles.com

and when i goto to Download i can see these errors

Table 'nuke3.nuke_ns_downloads_general' doesn't exist
Table 'nuke3.nuke_ns_downloads_nfeatured' doesn't exist
Table 'nuke3.nuke_ns_downloads_theme_mode' doesn't exist
Unknown column 'ns_disable' in 'where clause'
Table 'nuke3.nuke_ns_downloads_blocks' doesn't exist

kguske · Site Admin Joined: Jun 04, 2004 Posts: 6044

Strange that you could not create tables. Does the database user in your config.php file have the ability to create tables?

killer007 · New Member Joined: Dec 01, 2006 Posts: 16

well yeah i am trying this one localhost here is detail of user
Privileges = Select Insert Update Delete Create Drop Reload Shutdown Process File Grant References Index Alter

and i installed few other scripts with no problem.
and we can creat install files using that script on phpbb.com but is there any way to grab sql queries from install files like this one?

kguske · Site Admin Joined: Jun 04, 2004 Posts: 6044

I would try to use phpMyAdmin to run the same SQL that the install script is failing with to find more details about the error.

killer007 · New Member Joined: Dec 01, 2006 Posts: 16

thanks i am waiting for u

kguske · Site Admin Joined: Jun 04, 2004 Posts: 6044

Waiting for what?

hitwalker · Sells PC To Pay For Divorce Joined: Posts: 5661

i think he interpreted the

Quote:

I would try to use

a bit wrong.... Laughing

killer007 · New Member Joined: Dec 01, 2006 Posts: 16

kguske wrote:

I would try to use phpMyAdmin to run the same SQL that the install script is failing with to find more details about the error.

weel from that line i thought that you will run this script and will detect errors and will try to find some solution thats why i said "i am waiting".