Login Register

VRD-to-Forum data now shown to you, dear MVS user

General discussion about Volvos, Volvo parts, your DIY skills, Volvo ownership, and more. Come on in, introduce yourself and say hi! List Volvo events here. Have a nice Volvo? Show it off here. Do you have a question or comment about how MVS works? Ask here.
Post Reply
User avatar
matthew1  
Site Admin
Posts: 14484
Joined: 14 September 2002
Year and Model: 850 T5, 1997
Location: Denver, Colorado, US
Has thanked: 2660 times
Been thanked: 1248 times
Contact:

VRD-to-Forum data now shown to you, dear MVS user

Post by matthew1 »

Hot on the heels of another smashing new MVS feature -- Powersearch -- comes this...

Image

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)
Help keep MVS on the web -> click sponsors' links here on MVS when you buy from them.

Also -> Amazon link
. Click that when you go to buy something on Amazon and MVS gets a cut!

1998 V70, no dash lights on

1997 850 T5 [gone] w/ MSD ignition coil, Hallman manual boost controller, injectors, R bumper, OMP strut brace

2004 V70 R [gone]

How to Thank someone for their post

Image

User avatar
matthew1  
Site Admin
Posts: 14484
Joined: 14 September 2002
Year and Model: 850 T5, 1997
Location: Denver, Colorado, US
Has thanked: 2660 times
Been thanked: 1248 times
Contact:

Post by matthew1 »

No programmer nerds here :(

(They make too much money and have too little time to fart around keeping 10-30 year old Volvos running :lol:)
Help keep MVS on the web -> click sponsors' links here on MVS when you buy from them.

Also -> Amazon link
. Click that when you go to buy something on Amazon and MVS gets a cut!

1998 V70, no dash lights on

1997 850 T5 [gone] w/ MSD ignition coil, Hallman manual boost controller, injectors, R bumper, OMP strut brace

2004 V70 R [gone]

How to Thank someone for their post

Image

User avatar
matthew1  
Site Admin
Posts: 14484
Joined: 14 September 2002
Year and Model: 850 T5, 1997
Location: Denver, Colorado, US
Has thanked: 2660 times
Been thanked: 1248 times
Contact:

Post by matthew1 »

Recently completed:

_backfilled the lookup table with data that's escaped my efforts so far
_added it to individual VRD posts
Help keep MVS on the web -> click sponsors' links here on MVS when you buy from them.

Also -> Amazon link
. Click that when you go to buy something on Amazon and MVS gets a cut!

1998 V70, no dash lights on

1997 850 T5 [gone] w/ MSD ignition coil, Hallman manual boost controller, injectors, R bumper, OMP strut brace

2004 V70 R [gone]

How to Thank someone for their post

Image

Post Reply