vBulletin LTS

Relevant Store Products on Threads & Search
Mod Version: 1.00, by optikalefx

This hack will use data from your online store database (or whatever data source you want) and determine which are the most relevant products to show at the top of a thread. It will also show relevant products related to search queries.

It accomplishes this task by some clever javascript that gets the most common occurrences of words / phrases in your posts, and does some clever mysql logic to figure out what is most relevant.

This hack comes with an option for users with over 50 posts to turn OFF seeing these products.
You need to make 2 template modifications, add some CSS and Javascript, and drop in the PHP files. Also add 1 field to the user table (sql statement included) Then edit the relevantProducts.php file to match whatever data you have. Its setup right now for a Volusion API export.

Files:
relevantProducts.php
relevantProductsAjax.php
RP-plugins.txt
RP-search template changes.txt
RP-box template.txt
RP-css.css
RP-debugging.php
RP-hide/show template changes.txt
RP-jQuery Plugin.js
RP-jQuery Plugin Usage.js
RP-sql.sql




To make this better for later, your store might also give you product popularity, something our store does not. Factoring that in would increase the relevance of the products.

If you like this hack please donate to email
Thanks!