Forum Topics

Posted: Tue Sep 05, 2006 7:38 pm

Greetings All,
I am looking for a nudge int eh right direction....

I am using Dynamic Titles on my site but I want to change how my Foums show up.

Currently I have

Site Name - Forums - Forum Name - Topic Name

Here is the code I am using....

Code:




// Forums 


if($name=="Forums"){ 


global $p,$t,$forum,$f; 


$newpagetitle = "$name"; 


    if($p) { 


        $sql = "SELECT post_subject, post_id FROM ".$prefix."_bbposts_text WHERE post_id='$p'"; 


        $result = $db->sql_query($sql); 


        $row = $db->sql_fetchrow($result); 


        $title = $row[post_subject]; 


        $post = $row[post_id]; 





        $newpagetitle = "$name $item_delim Post $post $item_delim $title"; 


    } 


    if($t) { 


        $sql = "SELECT topic_title, forum_id FROM ".$prefix."_bbtopics WHERE topic_id='$t'"; 


        $result = $db->sql_query($sql); 


        $row = $db->sql_fetchrow($result); 


        $title = $row[topic_title]; 


        $forum = $row[forum_id]; 





        $sql = "SELECT forum_name FROM ".$prefix."_bbforums WHERE forum_id='$forum'"; 


        $result = $db->sql_query($sql); 


        $row = $db->sql_fetchrow($result); 


        $forum = $row[forum_name]; 


        $newpagetitle = "$item_delim $name $item_delim $forum $item_delim $title"; 


    } 


    elseif($f) { 


        $sql = "SELECT forum_name FROM ".$prefix."_bbforums WHERE forum_id='$f'"; 


        $result = $db->sql_query($sql); 


        $row = $db->sql_fetchrow($result); 


        $forum = $row[forum_name]; 


        $newpagetitle = "$item_delim $name $item_delim $forum"; 


    } 


}

I want....
Site Name - Forum Catagory - Forum Name - Topic Name

I have tried several different ways but nothing seems to work. A point in the right direction is all I need.

Thank You for your time!

Dawg

registered · Posted: Tue Sep 05, 2006 10:51 pm

While there are others who would profess that having your actual latest forum post up front as much as possible is even better... this is what storebuilder had suggested long back. "Six" redid DT after that and came up with this instead:

Code:




if($name=="Forums"){


global $p,$t,$forum,$f;


$newpagetitle = "$sitename $item_delim $name";  


$newpagetitle = preg_replace("/\[(\S+)\]/e", "", $newpagetitle);


$newpagetitle = check_html($newpagetitle, nohtml);


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


        $title = $row[post_subject]; 


        $post = $row[post_id]; 


        $ptext = $row[post_text];





        $newpagetitle = "$title $item_delim $ptext"; 


        $newpagetitle = preg_replace("/\[(\S+)\]/e", "", $newpagetitle);


        $newpagetitle = check_html($newpagetitle, nohtml);


    } 


    if($t) {


$t = intval($t);


        $sql = "SELECT topic_first_post_id  FROM ".$prefix."_bbtopics WHERE topic_id='$t'"; 


        $result = $db->sql_query($sql); 


        $row = $db->sql_fetchrow($result); 


        $tpid = $row[topic_first_post_id ]; 


          


        $sql = "SELECT post_subject, post_id, post_text FROM ".$prefix."_bbposts_text WHERE post_id='$tpid'"; 


        $result = $db->sql_query($sql); 


        $row = $db->sql_fetchrow($result); 


        $title = $row[post_subject]; 


        $post = $row[post_id]; 


        $ptext = $row[post_text];





        $newpagetitle = "$title $item_delim $ptext"; 


        $newpagetitle = preg_replace("/\[(\S+)\]/e", "", $newpagetitle);


        $newpagetitle = check_html($newpagetitle, nohtml);


    } 


    elseif($f) { 


$f = intval($f);


        $sql = "SELECT forum_name FROM ".$prefix."_bbforums WHERE forum_id='$f'"; 


        $result = $db->sql_query($sql); 


        $row = $db->sql_fetchrow($result); 


        $forum = $row[forum_name]; 


        $newpagetitle = "$sitename $item_delim $forum"; 


        $newpagetitle = preg_replace("/\[(\S+)\]/e", "", $newpagetitle);


        $newpagetitle = check_html($newpagetitle, nohtml);


    }


}

But, I think the way this works is the "p" stands for if the user had actually clicked into a post, so its at the "lowest level" in phpBB. The "t" stands for if they had clicked into an actual Topic. The "f" is for if they just clicked on the overall Forum. I do not know this for certain, but I suspect that "c" would be if they had clicked on a Forum category (if you wanted to add that level).

So, you would need to consider each of the first three and possibly the additonal one as to what fields make sense at each level.