julien
October 29, 2020, 3:48pm
6
Mohammed:
I think we need this, I’m not able to open a link to any of the old questions on the old forum, it asks for my username and password (which I lost and reset) and the temp password I got in the email doesn’t work.
HI @Mohammed
Previous forums have been shutdown so topics are not available anymore. I have a work in progress to replace old link to new url, if you have some expertise on regex + postgresql I can use it (the topic id are the same!):
https://bobj-board.org/t/254765 -> https://bobj-board.org/t/254765
Identify the posts
I am using this kind of query on the database:
select
regexp_matches(raw, 'http://(?:www\.|)forumtopics.com/busobj/([\w\d\.?=]*?)(?:\d*?)', 'g'),
count(1)
from posts
group by 1
order by 2 desc;
Here is a table to list my findings
regexp_matches
count
{viewtopic.php?t=}
16084
{viewtopic.php?p=}
4293
{faq.php?mode=rules}
2193
{search.php}
1123
{faq.php?mode=bbcode}
810
{viewforum.php?f=}
354
{images}
262
{faq.php?mode=ask}
192
{shop.php}
63
{pro…