Forum Page Numbers

Newbie Joined: Sep 11, 2006 Posts: 92

I was curious if anyone had asked about getting page numbers addressed in the titles to keep from have duplicate page titles.

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

No sir, it has not come up until now. Good idea. Of course, it doesn't solve the worse problem of duplicate content, but, that is a much bigger problem with phpBB2 in of itself, and probably will never be addresses until the RavenNuke(tm) team decides to ditch phpBB2 for something else with better SEO characteristics.

I'll put this on the enhancement list for Dynamic Titles though.

Thanks!

Newbie Joined: Sep 11, 2006 Posts: 92

I don't know how much this is going to help you, but it works on Clan Themes.

Code:

// Forums
if ($name == 'Forums') {
global $p, $t, $f, $c;
$board_config = array();
$sqlpage = 'SELECT * FROM '.$prefix.'_bbconfig WHERE config_name = \'topics_per_page\' OR config_name = \'posts_per_page\'';
$querypage = $db->sql_query($sqlpage);
while($rowpage = $db->sql_fetchrow($querypage)){
   $board_config[$rowpage['config_name']] = $rowpage['config_value'];
}
if ($p) {
   $p = intval($p);
   $sql = 'SELECT post_subject, post_id, post_text FROM '.$prefix.'_bbposts_text WHERE post_id=\''.$p.'\'';
   $result = $db->sql_query($sql);
   $row = $db->sql_fetchrow($result);
   $asDTText['subject'] = $row['post_subject'];
   $asDTText['text'] = substr($row['post_text'], 0, $text_size);
   if (empty($asDTText['subject'])) {
      $sql = 'SELECT topic_id FROM '.$prefix.'_bbposts WHERE post_id = \''.$p.'\'';
      $result = $db->sql_query($sql);
      $row = $db->sql_fetchrow($result);
      $sql = 'SELECT post_subject FROM '.$prefix.'_bbposts_text a, '.$prefix.'_bbposts b '
      .'WHERE a.post_id = b.post_id AND b.topic_id = \''.intval($row['topic_id']).'\' AND post_subject != \'\' '
      .'AND a.post_id < \''.$p.'\' ORDER BY a.post_id DESC LIMIT 1';
      $result = $db->sql_query($sql);
      $row = $db->sql_fetchrow($result);
      $asDTText['subject'] = $row['post_subject'];
   }
   $newpagetitle = $asDTText['subject'].$dt_delim.$asDTText['text'];
} elseif ($t) {
   $sql = 'SELECT topic_first_post_id FROM '.$prefix.'_bbtopics WHERE topic_id=\''.intval($t).'\'';
   $result = $db->sql_query($sql);
   $row = $db->sql_fetchrow($result);
   $sql = 'SELECT post_subject, post_id, post_text FROM '.$prefix.'_bbposts_text WHERE post_id=\''.intval($row['topic_first_post_id']).'\'';
   $result = $db->sql_query($sql);
   $row = $db->sql_fetchrow($result);
   $asDTText['subject'] = $row['post_subject'];
   $asDTText['text'] = substr($row['post_text'], 0, $text_size);
   if(intval($_GET['start']) > 0){
      $page = 'Page '.(intval($_GET['start']) / intval($board_config['posts_per_page'])+ 1);
      $newpagetitle = $page.$dt_delim.$asDTText['subject'].$dt_delim.$asDTText['text'];
   }else{
      $newpagetitle = $asDTText['subject'].$dt_delim.$asDTText['text'];
   }
} elseif ($c) {
   $sql = 'SELECT cat_title FROM '.$prefix.'_bbcategories WHERE cat_id=\''.intval($c).'\'';
   $result = $db->sql_query($sql);
   $row = $db->sql_fetchrow($result);
   $newpagetitle = $row['cat_title'];
} elseif ($f) {
   $sql = 'SELECT forum_name FROM '.$prefix.'_bbforums WHERE forum_id=\''.intval($f).'\'';
   $result = $db->sql_query($sql);
   $row = $db->sql_fetchrow($result);
   if(intval($_GET['start']) > 0){
      $page = 'Page '.(intval($_GET['start']) / intval($board_config['topics_per_page'])+ 1);
      $newpagetitle = $page.$dt_delim.$row['forum_name'];
   }else{
      $newpagetitle = $row['forum_name'];
   }
}
}

http://www.clanthemes.com/forum-1-general-topics-100.html

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

Thank you floppy.

Newbie Joined: Sep 11, 2006 Posts: 92

You bet, but your right a lot of the SEO issues are at the core of phpbb. I think one of my favorites is this problem.

http://www.clanthemes.com/forum-1-general-topics.html

http://www.clanthemes.com/forum-1-general-topics-0.html

The above two links are the same page which creates duplicate pages in a sitemap for instance.

I wonder if phpbb3 is also this shabby.

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

floppy wrote:

I wonder if phpbb3 is also this shabby.

Yeah, don't know. However, I did read a fairly recent interview with Matt Cutts and in that he made mention that "duplicate content" from internal pages to other internal pages are not really an issue anymore. However, having duplicate content spread across multiple domains is.

I think, though, that was in regards to PageRank. I just can't seem to get beyond the fact that it could hurt SERPs. Don't know.

Newbie Joined: Sep 11, 2006 Posts: 92

SEO gets real opinionated when you start talking about stuff like this, because nobody ("besides matt") really knows. For me, its just irritating more than anything.

If I get to throw my 2 cents into the pot I would say it prolly conflicts mostly with indexing because the pages have duplicate titles SE's just count them both out.