NSN GR Downloads dynamic titles issue in RavenNuke 2.20.01

Susann · Posted: Tue Mar 04, 2008 4:22 pm

Can someone confirm there isn´t a issue with dynamic titles with NSN GR Downloads in RavenNuke vers. 2.20.01.
It just doesn ´t work correctly looking at the categories of the downloads.
Its possible I broke somewhere the code of the thousand NSN GR files by changing all br and img etc. to make this more XHTML compatible.
I have another site where it works without any problems but its not RN version 2.20.01

montego · Posted: Tue Mar 04, 2008 10:08 pm

Susann, I am running 2.20.01 on Montego Scripts now and I see that I forgot to make sure that I did not overwrite the NSN GR Downloads statements. We cannot use the stock RavenNuke DynamicTitles with NSN GR Downloads.

You will need to re-replace the Downloads section within the new RN dynamic_titles.php with what I provided in the 1.2.0 download from my site.

Remember, RavenNuke does not come with native NSN GR Download support... So, its the same issue with ShortLinks. I always have to remember to merge code rather than just overwrite....

Susann · Posted: Wed Mar 05, 2008 4:42 am

I have all required rules for NSN GR within the .htaccess and in includes/dynamic titles:

Code:

// Downloads for NSN GR Downloads
elseif ($name == 'Downloads') {
global $op, $cid, $lid;
if ($cid) {
$sql = 'SELECT title, parentid, cdescription FROM '.$prefix.'_nsngd_categories WHERE cid=\''.intval($cid).'\'';
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$asDTText['category'] = $row['title'];
$asDTText['text'] = substr($row['cdescription'], 0, $text_size);
if ($row['parentid'] == 0) {
$newpagetitle = $asDTText['category'].$dt_delim.$asDTText['text'].$dt_delim.$sitename;
} else {
$sql = 'SELECT title FROM '.$prefix.'_nsngd_categories WHERE cid=\''.intval($row['parentid']).'\'';
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$newpagetitle = $asDTText['category'].$dt_delim.$asDTText['text'].$dt_delim.$row['title'].$dt_delim.$sitename;
}
} elseif ($op == 'getit') {
$sql = 'SELECT title, description FROM '.$prefix.'_nsngd_downloads WHERE lid=\''.intval($lid).'\'';
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$newpagetitle = $row['title'].$dt_delim.substr($row['description'], 0, $text_size);
}
}

Still don´t know why this doesn´t work.
edit: There isn´t a description only the name of the download within the title.

montego · Posted: Wed Mar 05, 2008 6:10 pm

Susann, not sure it will help, but this is what I am running on Montego Scripts:

Code:

/*
* NSN GR Downloads
*/
elseif ($name == 'Downloads') {
global $op, $cid, $lid;
if ($cid) {
   $sql = 'SELECT title, parentid, cdescription FROM '.$prefix.'_nsngd_categories WHERE cid=\''.intval($cid).'\'';
   $result = $db->sql_query($sql);
   $row = $db->sql_fetchrow($result);
   $asDTText['category'] = $row['title'];
   $asDTText['text'] = $row['cdescription'];
   if ($row['parentid'] == 0) {
      $newpagetitle = $asDTText['category'] . $dt_sDelim . $asDTText['text'] . $dt_sDelim . $sitename;
   } else {
      $sql = 'SELECT title FROM '.$prefix.'_nsngd_categories WHERE cid=\''.intval($row['parentid']).'\'';
      $result = $db->sql_query($sql);
      $row = $db->sql_fetchrow($result);
      $newpagetitle = $asDTText['category'] . $dt_sDelim . $asDTText['text'] . $dt_sDelim . $row['title'] . $dt_sDelim . $sitename;
   }
} elseif ($op == 'getit') {
   $sql = 'SELECT title, description FROM '.$prefix.'_nsngd_downloads WHERE lid=\''.intval($lid).'\'';
   $result = $db->sql_query($sql);
   $row = $db->sql_fetchrow($result);
   $newpagetitle = $row['title'] . $dt_sDelim . $row['description'];
}
}

Susann · Posted: Wed Mar 05, 2008 7:30 pm

Montego thanks.
I have two different versions and there is one line different thats what I found out:
So I prefer the working version with this line:

Code:

$asDTText['text'] = $row['cdescription'];
if ($row['parentid'] == 0)

instead of:

Code:

$asDTText['text'] = substr($row['cdescription'], 0, $text_size);
if ($row['parentid'] == 0)

Its seems this is solved.

montego · Posted: Sat Mar 08, 2008 1:45 pm

Excellent.

blith · Posted: Tue Jul 08, 2008 12:32 pm

What do I need to do with this module? I am confused on edits I should make... Thank you.

Susann · Posted: Tue Jul 08, 2008 5:13 pm

Quess you don´t have the same problem I had month before with my different versions of code and RavenNuke.
So if I where you I would only check out at montegoscripts if there is already a new version of dynamic titles for NSN GR downloads available.