Hey all,

I would like to add an extra table to my forum database where I can link specific content to a forum thread. When people click the linked thread they will be redirected to the content url in stead of the topic url.

Any idea if this is possible with phpbb3, to change the url by joining with this extra table and add some code to replace the topic url for a complete new one?

I hope someone can help me get started.

Not sure if this ith the best forum to ask my question, but feel free to move it.

umm...What exactly do you mean? Can we have an example?

Unfortunately I do not have a working example but I will try to explain what I would like to achieve.

Just like all other topics I would like to have topics in the forum which seems to represents forum topics. (see first image).

When a topic is linked to content (to an other section of my website) I would like to change the url of this topic in the forum overview. When you click one of these (linked)topics you would go to -http://www.mysite.com/article/123.html instead of -http://www.mysite.com/forum/topictitle-t3315.html

Topics linked to articles on other sections of the website are the only topics which will be redirected. I would like to store the linked topics in a newly created table in the phpbb3 database with an topic id and a content id.

When the forum is processed I would like to add an extra join to (the query to) see if a topic is linked to content, if it's linked I would like to change the url of the topic.

Does this make sense ?

plz say your board url i think i can help u

Professional wrote:plz say your board url i think i can help u

Can you help here as well? Or else send me a PM with details what you have in mind.

no just say your forum url i'll say my suggestions here.

"When a topic is linked to content (to an other section of my website)" what kind of content is that and how would you link a topic to a content on our site?

iwanttobelieve wrote:"When a topic is linked to content (to an other section of my website)" what kind of content is that and how would you link a topic to a content on our site?

I would do that by joining the topic query with a linking table. I will fill the linking table with my own cms.

Anyone?

So basically, what you want is the same as forum links, but for topics. If you know a bit of php/mysql, you could add an extra column to the topic table, or simply add a new table listing topic id and redirect url.
Then, in viewtopic.php, you could deal with this after :

Code: Select all

$topic_id = (int) $topic_data['topic_id'];

Eg check if there is a redirect to perform and do it if so.
The tricky part would be to add the extra field in the posting template, for the column addition case, you can inspire from the Ultimate SEO URL mod since it adds an extra column to the topic table and makes it editable (can be for admin only).
But if you only have few of them, you could as well just add them manually with phpmyadmin.

++