The Arcive of Official vBulletin Modifications Site.

Relevant Store Products on Threads & Search · **Released**: 07-12-2011

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 paypal@mp3car.com
Thanks!

Manoel J?nior · #2 07-13-2011, 04:25 PM

Hooo great!!! Thanks

Do you think if functionally with Mercado livre? www.mercadolivre.com.br

optikalefx · #3 07-13-2011, 06:23 PM

Yea it shouldn't be a problem. You will just need to match the correct database fields in relevantProducts.php.

If you know a little PHP you can swap out the correct database fields and table names.

lem · #4 10-02-2011, 04:00 PM

This works with any online store software? Or just Volusion?

optikalefx · #5 10-02-2011, 04:14 PM

The current files work with Volusion, but you just need an XML output of products from any store and it will work.

The script takes a little bit of "making it work for you" because store databases are so different. But its well commented and should be easy to see where things need to go. Volusion was easy because they have an XML output of orders from their API

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04184 seconds Memory Usage 2,251KB Queries Executed 19 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (4)navbar_link (120)option (5)post_thanks_box (1)post_thanks_box_bit (5)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit (5)post_thanks_postbit_info (4)postbit (1)postbit_attachment (5)postbit_onlinestatus (5)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start fetch_musername post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end post_thanks_function_fetch_thanks_bit_start post_thanks_function_show_thanks_date_start post_thanks_function_show_thanks_date_end post_thanks_function_fetch_thanks_bit_end post_thanks_function_fetch_post_thanks_template_start post_thanks_function_fetch_post_thanks_template_end postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_attachment postbit_display_complete post_thanks_function_can_thank_this_post_start tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

Благодарность от:
Manoel J?nior

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!