Dynamic Titles for NSN GR Downloads Module

Site Admin/Owner Joined: Feb 12, 2005 Posts: 965

The existing Dynamic Titles was coded to work with the original PHP-Nuke/RavenNuke(tm) Downloads module. If you would like to "tweak" your DT to work with NSN GR Downloads, it is a simple fix:

=== OPEN ===

includes/dynamic_titles.php

=== FIND ===

Code:

// Downloads
elseif ($name == 'Downloads') {
global $d_op, $cid, $lid;
if ($d_op == 'viewdownload') {
   $sql = 'SELECT title, parentid, cdescription FROM '.$prefix.'_downloads_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.'_downloads_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 ($d_op == 'viewdownloaddetails' || $d_op == 'getit') {
   $sql = 'SELECT title, description FROM '.$prefix.'_downloads_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);
}
}

=== REPLACE WITH ===

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);
}
}

=== DONE ===

Hope this helps!

Newbie Joined: Jan 04, 2007 Posts: 55 Location: Cyberworld

Works great ! Smile

Site Admin/Owner Joined: Feb 12, 2005 Posts: 965

Awesome. Thank you for letting me know.

Spam Stopper - Comments Modules · Site Admin Joined: Jul 18, 2005 Posts: 311

Cool, I had not even noticed this but I have used your fix now, thanks again'!