
See a good example of it here: https://www.matthewsvolvosite.com/page/3
It shows forum data as they relate to VRD items, to put it simply. Views, replies and solved status for forum topics that are in the VRD.
[how to mark forum posts as Solved]
To make this, I set up a "lookup table" in the database to hard link forum topics (phpBB software) to VRD posts (Wordpress software). It's something I've been thinking about for a few years. There are about 1300 rows in this table, in case you're a nerd and find this stuff interesting.
Now when you look at the MVS home page or browse through posts (like https://www.matthewsvolvosite.com/page/3) you'll see this data, if it's available. Not all VRD posts will have this. An example of one that will not have any data is a VRD post that doesn't point to a repair or Volvo thing in the forum. If it doesn't lead to a forum topic, naturally, there's no forum data to show you.
To do:
_backfill the lookup table with data that's escaped my efforts so far*
_make a subselect in the db query to get topic_id from post_id when post_id is all it has (currently doesn't show anything)
_add it to individual VRD posts
_mark more solved topics solved (you can help!)
_roll this out for mobile
* I started with a gigantic mess of raw VRD post text (all 1600+), and regular-expressioned my way through the VRD-Forum relationships via looking for and isolating those big blue "This Ain't All" anchor tags (no, really, this is how I built the lookup table)







