Add-On Releases - Prosperent Product Search and Auto-Linker [Archive]

View Full Version : Add-On Releases - Prosperent Product Search and Auto-Linker

99SIVTEC

01-23-2012, 11:00 PM

Updates:

November 21, 2012- Re-instantiated the template search bar for those who can't use sidebars in their templates. (v.2.8)
November 20, 2012- Altered Default Sort Option to make it a drop down. (v.2.7)
November 20, 2012- Fixed the issue causing users not to be able to view their PMs. (v.2.6)
November 19, 2012- The search bar is now inside a Forum Block, no longer will you have to alter your template files.
There is also an additional part to this plugin, the Auto-Linker. More about this will be described below.

November 13, 2012- Resolved an issue with the starting query and when facets were clicked. (V2.4)
October 24, 2012- Added a starting query and updated the API. Also now works when the query has an apostrophe in it. (V2.3)
July 17, 2012- Added negative filters for Brands and Merchants. (v. 2.2)
June 4, 2012- More optimization, fixed a CSS bug. (v. 2.1)
May 18, 2012- Optimization. Updated API class, better functionality, removed the recent queries table. Added a CSS file that contains most of the CSS for those who want to change any settings. (v. 2.0)
February 21, 2012- Optimization. I was informed that it was running slow on some peoples forums, so I optimized the table. It should run a lot faster and smoother now. (v. 1.6)
February 16, 2012- Made some adjustments in how things are run, worked out a few bugs that I found. (v.1.5)
February 14, 2012- 'Recent Searches' and 'Top Products' Sidebars have been integrated. These will help drive traffic to your forums. More AdminCP Options. (v.1.4)
February 3, 2012- Facets have been launched, more Admin options, optimized code. (v1.3)
January 31, 2012- Updated with AdminCP options for the logo, default price sort type, and API key (v1.2)
January 27, 2012- Updated with Price Sort (v1.1)

Prosperent Product Search

This add-on will help make/increase earnings from your forum. It will add a product search to your forum's sidebar, which users can utilize to search for products. When they click the product through your forum they will be redirected to the Merchant's site. If they make a purchase you will earn a commission from the sale.

Prosperent Auto-Linker
This new portion of the add-on will enable you to designate words that will be linked to the Product Search. You can also use a different query.

For example,

red shoes => red Nike shoes
shoes

If you put the above inside the text area then any time red shoes or just shoes is in a post it will be linked to the Product Search. If you put the additional part after red shoes with any word then when it find 'red shoes' it will actually send the query of 'red Nike shoes' to the Product Search.

As with this example, put the longer part first. That way red shoes will be matched before shoes. Else red shoes would never be found.

Why Prosperent Product Search?

Prosperent Product Search uses Prosperent's API, which is a very advanced API that offers you access to 3000 merchants and 50 million products from all of the top online retailers. Stores like Zappos, 6pm, Best Buy, Overstock, REI, Advance Auto Parts, Kohl's, Gap, Banana Republic, Cabelas, and thousands more. If it is sold online, we probably have it in our system.

We have an ever growing community, which is always willing to answer questions and lend a helping hand, and our team here at Prosperent is also available on the forum.

Installation

First thing, head over to Prosperent (http://goo.gl/6X8OT) and click Join, its Free to do so. Create your account and once you are signed in, click the API tab up top. This page will give you the information you need to know about the API. But all you need to do here at the moment is click API Keys on the submenu and click Add New API Key. This will get you the API key you'll need so commissions can be tracked back to you. Name it whatever you'd like and you'll see that its created a key for you.

Save that key somewhere as you'll be needing it later.

Now, download the .zip file and unzip it. First import the plugin file in the AdminCP. Open the 'Upload' folder and copy the contents into your main or root vbulletin directory.

Okay, with that done. Go into your AdminCP and click Settings -> Options -> Prosperent Settings and add your API Key to the input box labeled Api_Key and save that there.

The new search box is now in a forum block. These can be turned on or off inside the AdminCP options.

You also may have to enable sidebars for your forum if they currently are not active, to do this go to admincp -> options -> Forum Sidebar and Block Options and enable the Forum Sidebar option.

After that is finished, go to Forums & Moderators then go to Forum Blocks Manager. Once there click Add Block.

Block Type: Custom HTML/PHP. Click Continue. You'll be doing this for the two (2) sidebars. Now for the information to enter into each, look at the two images attached. Create a sidebar for Top Products.

If you can't view the images for any reason, for the forum block...

Title: 'Prosperent Top Products' or something similar
Description: Displays the top products.
Cache Time: 300 (or more, your call, this won't be changing as much as recent searches)
Content Type: PHP
Content: return $this;
Template to Use: Block_Prosperent_Tops_Template

Title: 'Prosperent Store' or something similar
Description: Displays the search box.
Cache Time: 1
Content Type: PHP
Content: return $this;
Template to Use: block_prosperent

Change the display order on the 'Forum Blocks Manager' to your liking.

Admin Options:

Giving you more power over this add-on.

Api_Key- Enter your Api key here so you can earn your commissions
Phrases and Optional Queries- Insert the words you'd like to be linked to the Product Search and their optional query.
Case Sensitive Matching
Open links in new window?- Will either open a link in a new window or the same window.
Default_Sort- Sets the sort type default. relevance desc = Relevancy, price asc = Low to High, price desc = High to Low
Starting Query- Adds a starting query, if nothing is set as a query when the user gets to the product search page.
Enable Facets
Api Limit- Set the API limit. Default is 10.
Pagination Limit- Set the amount of results to appear per page. Default is 15.
Addional Directory- This one is for those who's forums have an additional directory. Now instead of altering code you are able to define the additional directory here, Don't forget the leading slash (/).
Merchant Facets- Number of merchants to display in primary facet list
Brand Facets-Number of merchants to display in primary facet list
Enable Top Products Sidebar-
Top_Shown- Sets the number of Top Products to be shown in the sidebar.
Negative Brand Filters- Brands to discard from results. If more than 1, seperate by commas. Enter the Brand name exactly how it appears in the results. (ie. Nike, Reebok, Merrell)
Negative Merchant Filters- Merchants to discard from results. If more than 1, seperate by commas. Enter the Merchant's name exactly how it appears in the results.(ie. 6pm, Zappos.com, endless)
Logo_Image-Set to display the Prosperent Logo with the search bar. Size is 167px x 50px.
Logo_imageSmall- Set to enable the smaller logo. Size is 100px x 30px.
Template_Placement- Changes the template that {vb: raw includedphp} is placed in. Remember the template name is case sensitive.

Template Installation of Search Bar:
Go to Styles & Templates, click Style Manager and then on your Primary Style, click Edit Templates. Open the header template and insert {vb:raw includedphp} where you'd like the search bar to show up.

Notes:

You can change which template to put {vb:raw includedphp} into but if you do you must change it inside the plug-in. The Plug-in is named Search Form Input Box. The template name is case sensitive.

If you have any questions or suggestions, please feel free to ask me here or on the Prosperent Community (http://community.prosperent.com/forum.php).

99SIVTEC

01-25-2012, 01:55 PM

I'm one of the other developers here at Prosperent. We tested our search plugin on one of my old automotive message forums mentioned in the first post. Here are my earnings from the plugin over the past several months:

You were paid $317.02 on December 29, 2011
You were paid $148.78 on December 5, 2011
You were paid $316.65 on November 2, 2011
You were paid $278.73 on October 8, 2011
You were paid $375.26 on August 30, 2011
You were paid $206.88 on August 3, 2011
You were paid $170.01 on July 5, 2011
You were paid $157.64 on June 7, 2011

My holiday shopping was good to me. My next payment will be 526.78.

scottct1

01-26-2012, 07:30 PM

I now have it installed , but I notice when I search for an item the price shown is a little funky...

See the attached Pic... Notice the orange dollar sign, and the prices above it.

99SIVTEC

01-26-2012, 07:37 PM

Looking into that now, be back with you in a few.

99SIVTEC

01-26-2012, 07:52 PM

Alright, so I can't get either of the ones that I have running to do the same, even when I search for HDMI cable. The only issue I can see is that its trying to list the price_sale.
Could you give me the URL so I can see a live example and see if the CSS is causing an issue. You can PM me the link if you'd like.
Did you alter the products.php at all?

scottct1

01-26-2012, 07:58 PM

Only thing I changed in products.php was adding my API.

Site URL is www.satelliteguys.us.

scottct1

01-26-2012, 08:02 PM

BTW a user of mine sends a suggestion...

They would like to see results ordered in lowest price to highest price. :)

Thanks for your fast work!

99SIVTEC

01-26-2012, 08:09 PM

K, so looking at the results, it would seem that its commenting out the if and else statements that display the price.
<td style="width:17%; font-size:18px;">  <p style="padding-bottom:15px;"><span>$<span>50.17</span></span></p>  <p style="padding-bottom:3px;"><span style="text-decoration: line-through;">$50.17</span></p> <p style="padding-bottom:15px;"><span><font color="#cc6600">$<span></span></font></span></p>  <a rel="nofollow" href="www.satelliteguys.us/product.php?q=Monster Cable HDMI A/C - Type C Mini HDMI - Type A HDMI Cable- 6ft" onclick="javascript:document.location='http://prosperent.com/store/product/401335-2154-0/?k=Monster+Cable+HDMI+A%2FC+-+Type+C+Mini+HDMI+-+Type+A+HDMI+Cable-+6ft&m=Mwave.com&p=b14bc82e7b5257399d818714aed72ce 5&referrer=http%3A%2F%2Fwww.satelliteguys.us%2F&lo cation=http%3A%2F%2Fwww.satelliteguys.us%2Fproduct .php%3Fq%3Dhdmi%2Bcable&query=Hdmi+Cable';return false;"><img src="http://community.prosperent.com/img/visit_store_button.gif"></a> </td>

So its included  where the PHP statements should be. Check your code, and see if you can add <td style="width:17%; font-size:18px;">
<?php
if(empty($record['price_sale']) || $record['price'] <= $record['price_sale'])
{
//we don't do anything
?>
<p style="padding-bottom:15px;"><span>$<span><?php echo $record['price']?></span></span></p>
<?php
}
//otherwise strike-through Price and list the Price_Sale
else
{
?>
<p style="padding-bottom:3px;"><span style="text-decoration: line-through;">$<?php echo $record['price']?></span></p>
<p style="padding-bottom:15px;"><span><FONT COLOR="#cc6600">$<span><?php echo $record['price_sale']?></span></FONT></span></p>
<?php
}
?>
<a href="<?php echo $_SERVER['HTTP_HOST']; ?>/product.php?q=<?php echo $record['keyword']?>" onclick="javascript:document.location='<?php echo $record['affiliate_url']?>';return false;"><img src="http://community.prosperent.com/img/visit_store_button.gif"></a>
</td>

It may have gotten affected, but if that doesn't work, probably the best thing to do for the moment would be to take out the code inside that <td></td> statement and put <p style="padding-bottom:15px;"><span>$<span><?php echo $record['price']?></span></span></p>

Let me know if either of those fix the issue. And as for the price sorting, that's a very good idea, I'll start working on that. :)

99SIVTEC

01-26-2012, 08:16 PM

And if you'd like you can send me your version of the products.php file and I can fix it for you. :)

scottct1

01-26-2012, 08:18 PM

That worked, looks much better now, thanks! :)

Glad to hear your working on the price sorting feature, I am sure many people will enjoy that! :)

99SIVTEC

01-26-2012, 08:23 PM

That worked, looks much better now, thanks! :)

Glad to hear your working on the price sorting feature, I am sure many people will enjoy that! :)

Awesome, glad we got that looking good. And yea, that will definitely be a nice, and helpful feature to put in there. :)

99SIVTEC

01-27-2012, 08:46 PM

Just updated the add-on with a Price Sort function. Users can now sort High to Low, Low to High, or by Relevancy. :)

Make sure to mark as installed so you get the updates as they are made.

Working on facets for the results page like you can find at theNetPool (http://thenetpool.com/u/mxbrando)

Manoel J?nior

01-28-2012, 02:54 PM

Tagged!

scottct1

01-28-2012, 03:33 PM

Installed.

Another suggestion for the next version would be to store the api key and logo on or off in the database so we dont need to modify the .php files each time for each update.

I would also like to see the sort type settings in the admincp so we can specify the default sort type.

And I hope the company can work a deal with Amazon as well. :)

99SIVTEC

01-30-2012, 03:30 PM

Thanks Manoel.

And scottct1, I'll play around with those ideas after I release the facets update here soon. :)

99SIVTEC

01-30-2012, 04:17 PM

I agree with storing the vars in the database and adding admincp options to control those.

We should have a deal with Amazon and Ebay shortly. We currently run products from 6 different networks, but we're always growing.

Brian

99SIVTEC

01-31-2012, 03:46 PM

Installed.

Another suggestion for the next version would be to store the api key and logo on or off in the database so we dont need to modify the .php files each time for each update.

I would also like to see the sort type settings in the admincp so we can specify the default sort type.

Done and done, you are now able to change these settings and not have to worry about them after later updates. :)

scottct1

01-31-2012, 04:19 PM

Installed and working. :)

BlueCheri

01-31-2012, 04:25 PM

Tagged, will try soon.

scottct1

01-31-2012, 04:47 PM

When they support Amazon, this will really take off!

99SIVTEC

01-31-2012, 04:55 PM

That's high on our priority list. Right now we are filing the papers to move our corporation to another state. Amazon doesn't support Colorado (our main hq) due to some affiliate nexus laws that were passed in which they would have to collect sales taxes from affiliates. Once that goes through, we will roll amazon into our product catalog and you guys will automatically have access to all of their products on top of the 50 million we already provide. :)

scottct1

01-31-2012, 05:03 PM

Thats the same issue here in Connecticut. I was making good money from Amazon then they pulled all affiliates from CT. (Silly thing was the Tax they were mad at was never approved in the state... yet Amazon never reinstated afilliates for CT. Which means they are saving themselves a ton of money by not paying their affiliates here for proper sales.

I am making up a little of it by having Viglink installed, but nothing like I was getting before.

Sal Collaziano

02-01-2012, 05:29 AM

I tried setting this up on my 4.1.x installation and when clicking submit for a product search I was taken to my homepage with /product.php?q=my+search+query

Any idea what could be going wrong?

99SIVTEC

02-01-2012, 03:06 PM

Could you give me the url to it, and I'll have a look.

Did you place the other .php files that came with the .zip into your forums root directory?

iDHKHCM

02-01-2012, 04:12 PM

Do we still have to open Products.php to enter our api key? since theirs a "enter key" in admincp threw xml? in process of installing now, looks very sweet

99SIVTEC

02-01-2012, 04:16 PM

Do we still have to open Products.php to enter our api key? since theirs a "enter key" in admincp threw xml? in process of installing now, looks very sweet

Nope, everything is handled in the AdminCP now, I should probably remove that comment, haha. :D

iDHKHCM

02-01-2012, 04:57 PM

Nope, everything is handled in the AdminCP now, I should probably remove that comment, haha. :D

kk sweet thanks for writing back so fast.

how would i go about changing the image? admincp i entered 0 for hidden. that didnt work. i also changed the image in the img folder also didnt work. i want to use this image i made

https://vborg.vbsupport.ru/external/2012/02/1.png

iDHKHCM

02-01-2012, 04:59 PM

99SIVTEC

02-01-2012, 05:16 PM

thats just a quick change final image will look alot better i just wanted to know how i would change it. whats the initials for your site? P.S. ? i want to keep you guys in the final logo i use for sure. this mod is Awesome!

Hey, actually I just noticed a small error in my part. Anyways to add your own image change the following code in productSearch.php. The original lines are 51-56.

if ($vbulletin->options['Prosperent_logoImage'] == TRUE)
{
?>
<td style="padding-right:5px;"><a href="http://community.prosperent.com" title="Prosperent Search"> <img src="http://community.prosperent.com/img/logo_small.png" /> </a></td>
<?php
}

Anyways change that too...
if ($vbulletin->options['Prosperent_logoImage'] == TRUE)
{
?>
<td style="padding-right:5px;"><a href="http://community.prosperent.com" title="Prosperent Search"> <img src="<?php echo 'http://' . $_SERVER['HTTP_HOST'] . '/img/YOUR_IMAGE_NAME_HERE'; ?>"/> </a></td>
<?php
}
?>

Then just put your image into the img folder that came with the add-on and include your image name after the /img/ and make Logo_Image TRUE or 1 in your AdminCP and you should be good. :)

iDHKHCM

02-01-2012, 07:29 PM

Hey, actually I just noticed a small error in my part. Anyways to add your own image change the following code in productSearch.php. The original lines are 51-56.

if ($vbulletin->options['Prosperent_logoImage'] == TRUE)
{
?>
<td style="padding-right:5px;"><a href="http://community.prosperent.com" title="Prosperent Search"> <img src="http://community.prosperent.com/img/logo_small.png" /> </a></td>
<?php
}

Anyways change that too...
if ($vbulletin->options['Prosperent_logoImage'] == TRUE)
{
?>
<td style="padding-right:5px;"><a href="http://community.prosperent.com" title="Prosperent Search"> <img src="<?php echo 'http://' . $_SERVER['HTTP_HOST'] . '/img/YOUR_IMAGE_NAME_HERE'; ?>"/> </a></td>
<?php
}
?>

Then just put your image into the img folder that came with the add-on and include your image name after the /img/ and make Logo_Image TRUE or 1 in your AdminCP and you should be good. :)

thanks that worked great. Needless to say you are the MAN. Im going to make a thread for my members who own their own sites to read more about this mod on my site n link this url on their so more ppl can use this awesome MOD. any luck with the amazon thing?

https://vborg.vbsupport.ru/external/2012/02/64.png

if anyone needs help with a image or button Message me, i will help.
dont forget to Nominate this guys MOTM its sick!

Sal Collaziano

02-01-2012, 07:39 PM

Could you give me the url to it, and I'll have a look.

Did you place the other .php files that came with the .zip into your forums root directory?

Thank you. Yes, all the files have been uploaded. It's running here:
http://www.cadillacforums.com/forums/forum.php

99SIVTEC

02-01-2012, 07:47 PM

Thank you. Yes, all the files have been uploaded. It's running here:
http://www.cadillacforums.com/forums/forum.php

Alright, to fix this, just open productSearch.php, and on line 44 change
<form style="position: relative; z-index:1; float: right; margin: 5px 5px 0 0;" id="search" method="GET" action="/product.php">

to

<form style="position: relative; z-index:1; float: right; margin: 5px 5px 0 0;" id="search" method="GET" action="/forums/product.php">

Your site just has an extra directory to get to the forum, so adding that /forums in front of /product.php should solve your problem. :)

99SIVTEC

02-01-2012, 07:49 PM

thanks that worked great. Needless to say you are the MAN. Im going to make a thread for my members who own their own sites to read more about this mod on my site n link this url on their so more ppl can use this awesome MOD. any luck with the amazon thing?

if anyone needs help with a image or button Message me, i will help.
dont forget to Nominate this guys MOTM its sick!

Thanks iDHKHCM, I really appreciate that. And we are working on amazon. I'll keep this post updated with any news that we get on that front. :)

Sal Collaziano

02-01-2012, 08:57 PM

Alright, to fix this, just open productSearch.php, and on line 44 change
<form style="position: relative; z-index:1; float: right; margin: 5px 5px 0 0;" id="search" method="GET" action="/product.php">

to

<form style="position: relative; z-index:1; float: right; margin: 5px 5px 0 0;" id="search" method="GET" action="/forums/product.php">

Your site just has an extra directory to get to the forum, so adding that /forums in front of /product.php should solve your problem. :)

Perfect! Thank you! Any possibility of getting this to work on vBulletin 3 forums? If so, I can add it to another 25 sites or so...

c.c.

02-01-2012, 09:24 PM

Nothing show up when I try to search for anything? I followed the instructions step by step. What the heck?

www.highdefjunkies.com

99SIVTEC

02-01-2012, 09:30 PM

Nothing show up when I try to search for anything? I followed the instructions step by step. What the heck?

www.highdefjunkies.com

Did you make yourself an API Key at prosperent.com and insert it into your adminCP?

Sorry I had forgotten to update the instructions after my last release. All you have to do now is go to the AdminCP and add your API Key to the Prosperent Settings. So now you don't have to go into your products.php file and add the API Key there as it will be overwritten whenever I push an update. I corrected that on here to reflect so.

c.c.

02-01-2012, 09:36 PM

Did you make yourself an API Key at prosperent.com and insert it into your adminCP?

Sorry I had forgotten to update the instructions after my last release. All you have to do now is go to the AdminCP and add your API Key to the Prosperent Settings. So now you don't have to go into your products.php file and add the API Key there as it will be overwritten whenever I push an update. I corrected that on here to reflect so.

I sure did.

c.c.

02-01-2012, 09:37 PM

I got it! I uploaded the files first then installed the mod. I just reupload the files and all is well.

99SIVTEC

02-01-2012, 09:38 PM

I got it! I uploaded the files first then installed the mod. I just reupload the files and all is well.

K, awesome, glad to hear its working for you. :)

99SIVTEC

02-01-2012, 09:40 PM

Some of you guys might also take a look at our performance ads if you have a site that is focused around a product or hobby. We target the page content similar to google adsense, but our ads are product based, and you earn a commission when a sale is made instead of being paid per click. You can see an example here:

http://www.highaltitudeimports.com/showthread.php/79049-Anybody-Ski

http://prosperent.com/tools/performanceads

If you installed this, you have access to performance ads already. Just log in and check them out. We're putting a lot of work into them :)

99SIVTEC

02-01-2012, 09:57 PM

Any possibility of getting this to work on vBulletin 3 forums? If so, I can add it to another 25 sites or so...

Hey Sal, we'll have a test site using vbulletin3 hopefully up by tomorrow, so I will play with that, and get it working on there. I'll keep you updated on that.

morrow

02-01-2012, 10:03 PM

I was wondering if you have a vendor list. I'm in a small market and before installing would like to see if relevent products will show up. Thanks.

99SIVTEC

02-01-2012, 10:14 PM

I was wondering if you have a vendor list. I'm in a small market and before installing would like to see if relevent products will show up. Thanks.

Hey morrow, you can go to either of these sites to lookup vendors that we use

Prosperent Merchant List (http://api.prosperent.com/api/merchant?dBug=true&limit=1000)

http://api.prosperent.com/api/merchant?query=@merchant%20Zappos&dBug=true

The first list will show you all the merchant we use while the second one will show you a specific merchant; just change Zappos to the merchant name.

morrow

02-01-2012, 10:25 PM

99SIVTEC

02-01-2012, 10:28 PM

OK... So I signed up and installed... figured what the hell... So my forum resides in http://www.njflyfishing.com/vBulletin

I placed the code into my Navbar template and made the necessary change. It shows exactly where it's supposed to. Hover my mouse over it and it points to http://www.njflyfishing.com/product.php rather than http://www.njflyfishing.com/vBulletin/product.php.

Attempted to copy the files to the root of my site but that just comes up with another error.

I'll leave it installed for now to see what you guys come up with.

Thanks.

No problem, I've got you covered.

open productSearch.php, and on line 44 change
<form style="position: relative; z-index:1; float: right; margin: 5px 5px 0 0;" id="search" method="GET" action="/product.php">

to

<form style="position: relative; z-index:1; float: right; margin: 5px 5px 0 0;" id="search" method="GET" action="/vBulletin/product.php">

Then it will send it to the right page. :)

morrow

02-02-2012, 12:16 AM

No problem, I've got you covered.

open productSearch.php, and on line 44 change
<form style="position: relative; z-index:1; float: right; margin: 5px 5px 0 0;" id="search" method="GET" action="/product.php">

to

<form style="position: relative; z-index:1; float: right; margin: 5px 5px 0 0;" id="search" method="GET" action="/vBulletin/product.php">

Then it will send it to the right page. :)Perfect.. Thanks, I'll give it a shot.

99SIVTEC

02-02-2012, 02:29 PM

We have merchants in pretty much every vertical you can think of. For fishing we work with large vendors like Bass Pro Shops, all the way down to the smaller shops.

Remember, we have over 50 million products from more than 3,000 retailers. We work with huge names like Best Buy, Zappos, QVC, REI, Overstock, Auto Anything, Kohl's, Cabelas, Gap, Banana Republic, and on and on and on :). If it is sold online, we probably have it in our system.

c.c.

02-02-2012, 02:38 PM

Has anyone made any money yet?

99SIVTEC

02-02-2012, 04:15 PM

Has anyone made any money yet?

Let me give you (and others a few tips). Most of my sales that were made during testing came from actual organic searches from search engines, not from the members of my own forum. I would start by promoting the feature on your site to your users. Mention that it is a way for them to help support your site since you earn a commission on every purchase. This goes a long way since members are often ready and willing to help support their favorite forum.

Next, get some organic traffic coming into the search pages. For this, you need to get some backlinks to some of the search result pages. This is as simple as displaying a few search url's in your signature on your forum, and encouraging your users to do that same.

We may also be able to create a side block that perhaps stores and shows the most popular searches? Doing this has the benefit of drawing attention to the search, but also gets some links in which helps get pages indexed and ultimately leads to sales.

Last but not least, be patient. It took me several weeks to start getting search traffic to my product search. After that, sales started to roll in slowly, and now I get several per day and have almost 7 million pages indexed. It went from my forum struggling to make money to being quite the money maker for me, but it took time :).

99SIVTEC

02-02-2012, 04:58 PM

Any possibility of getting this to work on vBulletin 3 forums? If so, I can add it to another 25 sites or so...

I just finished making this add-on work on vBulletin3. The thread is located at Prosperent Product Search vb3 (https://vborg.vbsupport.ru/showthread.php?t=277935)

Sal Collaziano

02-02-2012, 11:43 PM

I just finished making this add-on work on vBulletin3. The thread is located at Prosperent Product Search vb3 (https://vborg.vbsupport.ru/showthread.php?t=277935)

Great! It's on my to-do list to add to my other sites. I'm only waiting to see it work on my busiest forum...

No problem, I've got you covered.

open productSearch.php, and on line 44 change
<form style="position: relative; z-index:1; float: right; margin: 5px 5px 0 0;" id="search" method="GET" action="/product.php">

to

<form style="position: relative; z-index:1; float: right; margin: 5px 5px 0 0;" id="search" method="GET" action="/vBulletin/product.php">

Then it will send it to the right page. :)

Maybe this setting should be put into the AdminCP of vBulletin instead of a file edit...

99SIVTEC

02-02-2012, 11:58 PM

Great! It's on my to-do list to add to my other sites. I'm only waiting to see it work on my busiest forum...

Maybe this setting should be put into the AdminCP of vBulletin instead of a file edit...

That's actually a good idea. I'll include that in my next update which is coming soon. Thanks for the suggestion, they are always welcomed. :)

BlueCheri

02-03-2012, 12:49 PM

Installed, the logo image is bigger compare to Navbar, can you reduce the logo size? Also search box.

Image is attaching.

Thanx in advance.

G!

BlueCheri

02-03-2012, 02:47 PM

Facing problem with product Search; Please check http://www.offwalk.com/product.php

Thanx in advance.

G!

No problem, I've got you covered.

open productSearch.php, and on line 44 change
<form style="position: relative; z-index:1; float: right; margin: 5px 5px 0 0;" id="search" method="GET" action="/product.php">

to

<form style="position: relative; z-index:1; float: right; margin: 5px 5px 0 0;" id="search" method="GET" action="/vBulletin/product.php">

Then it will send it to the right page. :)

99SIVTEC

02-03-2012, 03:22 PM

Facing problem with product Search; Please check http://www.offwalk.com/product.php

Thanx in advance.

G!

My next update will actually solve that problem, at the moment it needs to have a query passed to it, for example, product.php?q=shoes. I should be able to release that update here in a little while, but most users should not be getting to the product page without first having passed a query through the search bar.

And as for the image, let me see if we can come up with a different image design that might work better for you. The current one can't be shrunk any more without losing quality. For the time being I would set the logo_image to hidden in the AdminCP.

BlueCheri

02-03-2012, 03:45 PM

Great and thanx for it.

I am trying it for few days, let's see how it works and the reactions of our members needs to know :)

Sorry for not informing, prosporent logo and search are over lapping the social network icons, they are very important for the back link points of view, please check that also.

Thanx in advance.

G!

My next update will actually solve that problem, at the moment it needs to have a query passed to it, for example, product.php?q=shoes. I should be able to release that update here in a little while, but most users should not be getting to the product page without first having passed a query through the search bar.

And as for the image, let me see if we can come up with a different image design that might work better for you. The current one can't be shrunk any more without losing quality. For the time being I would set the logo_image to hidden in the AdminCP.

99SIVTEC

02-03-2012, 04:09 PM

Great! It's on my to-do list to add to my other sites. I'm only waiting to see it work on my busiest forum...

Maybe this setting should be put into the AdminCP of vBulletin instead of a file edit...

Sal, looking over your forum, you should look at adding the search template to the prosperent template as well. It appears that you have it in the forumhome instead of the header which is fine, but if someone is on a search result page, there is no way for them to search for another product or refine their search. :)

99SIVTEC

02-03-2012, 04:47 PM

Installed, the logo image is bigger compare to Navbar, can you reduce the logo size? Also search box.

Image is attaching.

Thanx in advance.

G!

Hey, we got a smaller image coming out in this next update. You'll have the ability to set whichever one you'd like to visible, or you can set both to hidden. I'm almost done with it, just have a few fixes to do. So look for it soon. :)

99SIVTEC

02-03-2012, 08:02 PM

Alright, just released version 1.3. This one has a lot of goodies in it. Facets, more Admin Options, optimized code. Just all around awesomeness. :D

You now have a choice between two image sizes a 167 x 50 and a 100 x 30.

You can control the API limit, Pagination Limit, and whether Facets are enabled or disabled in the options.

Finally, if your forum has an additional directory, you can now put that in the Admin Options and not have to change it in the code, just remember the leading slash, ie. '/vb4'

As always, I welcome any suggestions, and if you see any bugs in this code, let me know and I will fix them ASAP.

morrow

02-04-2012, 11:01 PM

99SIVTEC

02-05-2012, 03:01 AM

I just "upgraded". Here's what happened. My search box for this product disapeared. I have the code "{vb:raw includedphp} in my NAVBAR template because I don't want it in my header, and that's about it.

There are no admin options anywhere and that's about it.

Other than that, no other issues.

Did you update the plug-in code since you put it into a different template?
at the bottom of the plug-in code it says pre register, in that change header to NAVBAR, and its case sensitive.

BlueCheri

02-06-2012, 11:10 AM

Propsperent search is over lapping 'Advance Search' of forum.

Image attached.

Note: Updated with latest version 1.3

G!

99SIVTEC

02-06-2012, 06:42 PM

Propsperent search is over lapping 'Advance Search' of forum.

Image attached.

Note: Updated with latest version 1.3

G!

You just need to adjust the location you are placing the search bar in your template.

stoute

02-06-2012, 10:16 PM

I'm getting an error when adding it to my main boards

Warning: include(productSearch.php) [function.include]: failed to open stream: No such file or directory in [path]/includes/class_bootstrap.php(98) : eval()'d code on line 2

Warning: include() [function.include]: Failed opening 'productSearch.php' for inclusion (include_path='.:/usr/local/php5/lib/php') in [path]/includes/class_bootstrap.php(98) : eval()'d code on line 2

I have left it in the header even though it is still failed if you need to see it.

http://www.greenromproject.com (http://greenromproject.com)

99SIVTEC

02-06-2012, 10:25 PM

BlueCheri

02-07-2012, 03:57 AM

Thanx for support, as per your PM, it's working fine.

But due to search box size, social networking icons are overlapping, can we reduce the box size and the logo also?

The image is attaching.

Rgds,

G!

stoute

02-07-2012, 04:59 AM

So it seems as though its not able to find the productSearch.php file, did you put that into the directory? As well as the other files that were inside the .zip?

LOL Thanks for the help. I used my wife's tiny netbook to upload so the filezilla upload screen wasn't allowing me to see the correct "root dir" so I uploaded it to the wrong place. Thanks :)

chaoyueh

02-07-2012, 04:38 PM

I would like to place the search box into the location I marked (see img)
Where should I put my code?

Thanks

99SIVTEC

02-08-2012, 03:43 PM

I would like to place the search box into the location I marked (see img)
Where should I put my code?

Thanks

Sorry for the late reply, I was out sick yesterday, from what I can tell its going to be the navbar_link template, which is under the Navigation/ Breadcrumb Templates.

Just remember to change the template name inside the plugin where it is pre-registering the template. Change header to navbar_link.

Hope that helps. :)

grzywa92

02-08-2012, 11:27 PM

where i can edit this "Search Products..." for other?

99SIVTEC

02-09-2012, 01:20 AM

where i can edit this "Search Products..." for other?

On line 77 of productSearch.php look for setDefaultText(form.elements.q, 'Search Products...');
Just change the Search Products... inside the quotes to whatever you'd like. :)

BlueCheri

02-09-2012, 06:26 AM

It would be a great idea.

Sorry not properly understand, could you please explain it in detail.

Thanx in advance.

G!

Sorry for the late reply, I was out sick yesterday, from what I can tell its going to be the navbar_link template, which is under the Navigation/ Breadcrumb Templates.

Just remember to change the template name inside the plugin where it is pre-registering the template. Change header to navbar_link.

Hope that helps. :)

chaoyueh

02-09-2012, 11:13 AM

When I click search results page 2, it jumps back to the forum home.

ex:
http://www.puddingbuy.com/forums/product.php?q=canon+S95

any idea?

Thanks

99SIVTEC

02-09-2012, 03:28 PM

When I click search results page 2, it jumps back to the forum home.

ex:
http://www.puddingbuy.com/forums/product.php?q=canon+S95

any idea?

Thanks

K, found the issue. I forgot a slash. Sorry about that, I'll re-update the files, all you'll need to do is update the products.php.

Or if you just want to change it in your current stack. Open products.php and go to line 336. Look for

$vbulletin->options['Prosperent_additionalDirectory'] . 'product.php?q=' . $query . '&priceSort=' . $sort . '&filterBrand=' . $_GET['filterBrand'] . '&filterMerchant=' . $_GET['filterMerchant'] // the pagenav-link

And change that to
$vbulletin->options['Prosperent_additionalDirectory'] . '/product.php?q=' . $query . '&priceSort=' . $sort . '&filterBrand=' . $_GET['filterBrand'] . '&filterMerchant=' . $_GET['filterMerchant'] // the pagenav-link

Sorry about this, anyone who has an additional directory will want to fix this, or install the new products.php file. I am very sorry for that.

chaoyueh

02-09-2012, 03:43 PM

K, found the issue. I forgot a slash. Sorry about that, I'll re-update the files, all you'll need to do is update the products.php.

Or if you just want to change it in your current stack. Open products.php and go to line 336. Look for

$vbulletin->options['Prosperent_additionalDirectory'] . 'product.php?q=' . $query . '&priceSort=' . $sort . '&filterBrand=' . $_GET['filterBrand'] . '&filterMerchant=' . $_GET['filterMerchant'] // the pagenav-link

And change that to
$vbulletin->options['Prosperent_additionalDirectory'] . '/product.php?q=' . $query . '&priceSort=' . $sort . '&filterBrand=' . $_GET['filterBrand'] . '&filterMerchant=' . $_GET['filterMerchant'] // the pagenav-link

Sorry about this, anyone who has an additional directory will want to fix this, or install the new products.php file. I am very sorry for that.

Perfect. Thank you

BlueCheri

02-09-2012, 03:45 PM

I can not pages for searches, it shows only one page.

Can you please check it.

G!

99SIVTEC

02-09-2012, 04:16 PM

I can not pages for searches, it shows only one page.

Can you please check it.

G!

All this is is an AdminCP option that I gave you access to. You can set the limit inside your AdminCP, look for Api_Limit under Prosperent Settings and change it to what you'd like, I'd suggest going no larger than 250. The default is set to 10, that's why only one page of results was showing.

BlueCheri

02-09-2012, 04:19 PM

Sorry, was not aware, set at 99.

G!

All this is is an AdminCP option that I gave you access to. You can set the limit inside your AdminCP, look for Api_Limit under Prosperent Settings and change it to what you'd like, I'd suggest going no larger than 250. The default is set to 10, that's why only one page of results was showing.

99SIVTEC

02-09-2012, 04:29 PM

Sorry, was not aware, set at 99.

G!

You're fine, just thought I should probably put it on here as well in case someone else had a similar issue. :)

bosken

02-09-2012, 09:33 PM

Nice, but for us that run forums outside the US, any good for us? Many of the stores does not ship overseas. (Europe in my case).
You have any non-US sites that runs your app?

99SIVTEC

02-09-2012, 10:18 PM

Nice, but for us that run forums outside the US, any good for us? Many of the stores does not ship overseas. (Europe in my case).
You have any non-US sites that runs your app?

We're always expanding, and many of our upcoming merchants are in European countries. You guys won't be left out for long! :)

barcena

02-10-2012, 03:38 PM

Will this work for other countries or only the US? I have members from all over the world.

Thanks.

scottct1

02-10-2012, 05:05 PM

Has anyone made any money yet?

So far only a penny...

But keeping it up for now.

99SIVTEC

02-10-2012, 05:18 PM

So far only a penny...

But keeping it up for now.

I'm working on an update at the moment that will help get your forums indexed and get more traffic to your forum. This will help increase earning possibilities.

99SIVTEC

02-10-2012, 05:19 PM

Will this work for other countries or only the US? I have members from all over the world.

Thanks.

We are always expanding, and we will have companies that support other countries coming aboard soon.

dadoc

02-12-2012, 06:34 PM

thespi

02-12-2012, 09:05 PM

Hi how do I put this in the same place you have on http://community.prosperent.com/

(In just the forum page in the white space opposite the bread crumbs. Below the navbar)

BirdOPrey5

02-13-2012, 12:53 PM

Affiliate links removed.

Affiliate links are not allowed to be posted anywhere on vbulletin.org or in mods.

99SIVTEC

02-13-2012, 02:08 PM

You would only be able to make this amount because of your affiliate link you placed in the instal instructions. You are making money off all these guys who are using your mod, maybe you should have said that too. If I am wrong remove your affiliate link.

That isn't our affiliate link, it is for tracking. I'm the CEO of the company, the earnings above were 100 percent from the forum, not from referrals. The most important step people need to take is getting these pages some links so they can start indexing. I have almost 8 million pages indexed on my forum product search. The vast majority of the earnings are not from my forum members, but rather from organic searches. It takes a couple months for the inner search pages to rank, but once they do, it's a nice steady income stream. I detailed some suggestions for indexing and overall use of the plugin earlier in the thread. Check them out, and stop by our forums or ask here if you have any questions. Our developer Brandon is typically the one that posts in this thread, so he can help you out.

Brian

99SIVTEC

02-14-2012, 01:05 PM

Hi how do I put this in the same place you have on http://community.prosperent.com/

(In just the forum page in the white space opposite the bread crumbs. Below the navbar)

Hey, That is actually the header on Prosperents Community site. But I believe on most forums its going to be the navbar_link template, which is under the Navigation/ Breadcrumb Templates.

Just remember to change the template name inside the plugin where it is pre-registering the template. Change header to navbar_link.

99SIVTEC

02-14-2012, 04:44 PM

The newest update has been released (v.1.4). This update includes sidebars, one that will show the 'Recent Searches' and another that will show 'Top Products'. These sidebars will be shown on your forum's main page, and will help drive traffic to your forums, thus increasing sales. This update also includes more AdminCP options. These options will toggle the sidebars on or off and set the number of products to be shown in each. Also for those who change the tempalte location of the search bar, I have now made it easier to change. You just have to change the AdminCP option for Template_Placement to whichever template you'd like. Just remember that the template name is going to be case sensitive.

J-P

02-15-2012, 05:20 PM

99SIVTEC

02-15-2012, 06:10 PM

I am having a really hard time installing this... I would like it in the navbar next to the global search and have edited that template and have used tht template name in the config .. but still not getting anything.

Any help would be appreciated.

The site is :
http://www.invertplanet.com/forum/forum.php

Hey, so go to edit your templates, put {vb:raw includedphp} inside the navbar template. You'll find that under Navigation / Breadcrumb Templates. Once there search for Globalsearch. Put {vb:raw includedphp} before that div. Then in the options change the Template_Placement option to navbar.

Now you'll have to play with the css a little bit to get it just right along the side of the globalsearch. So go into productSearch.php and look around line 39 for <form style="position: relative; z-index:1; float: right; margin: 5px 5px 0 0;" id="search" method="GET" action="<?php echo $vbulletin->options['Prosperent_additionalDirectory'] . '/product.php'; ?>">

Play with the margin attribute. Let me know if you need any help with that.

J-P

02-15-2012, 07:03 PM

ok... did as instructed and get the following error:

: failed to open stream: No such file or directory in [path]/includes/class_bootstrap.php(98) : eval()'d code on line 31

?!?

99SIVTEC

02-16-2012, 07:00 PM

Alright, well after installing this for someone on their forum, I encountered a few bugs. So this newest update fixed those bugs. I hope this update fixes any issues that anyone else was having. Plus I included images for the data to make the two sidebars that will help drive traffic to your forums. Good luck everyone, and let me know if anything comes up let me know. And if you catch any bugs I will fix them ASAP.

My email is different than the one on this account, you can email me personally at brandon@prosperent.com

:)

J-P

02-17-2012, 01:20 PM

absolutely awesome!! Thank you so much for this. I would highly recommend this to anyone.

I am already a member of other affiliate programs through Commission Junction and this product bypasses that and makes things so much easier. Definitely 9.5 out of 10 :) Excellent excellent work, thank you!

BlueCheri

02-17-2012, 03:04 PM

Updated, but the setting for image and search box size is gone again.

Need to re do it again the same way, as before done?

G!

99SIVTEC

02-17-2012, 03:17 PM

Updated, but the setting for image and search box size is gone again.

Need to re do it again the same way, as before done?

G!

Yep, it will be the same way as before for that. :)

Let me know if you have any trouble.

BlueCheri

02-17-2012, 03:41 PM

I think line number changed, can you please tell me step by step (I think there are about three steps), and some details and in thread and few are in PMs

Thanx in advance.

G!

Yep, it will be the same way as before for that. :)

Let me know if you have any trouble.

99SIVTEC

02-17-2012, 03:57 PM

I think line number changed, can you please tell me step by step (I think there are about three steps), and some details and in thread and few are in PMs

Thanx in advance.

G!

Gathered everything up that I could remember and sent you a PM.

99SIVTEC

02-20-2012, 03:06 PM

99SIVTEC

02-21-2012, 03:34 PM

How's this working for everyone, has anyone noticed any bugs? Has anyone checked how indexing is going on their forum after the last update?

scottct1

02-21-2012, 03:42 PM

99SIVTEC

02-21-2012, 05:52 PM

I had to turn it off after the last update as it was slowing my page loading time on all pages from 0.23415 seconds to 3.41375 seconds.

What was strange while it was taking longer for pages to load the server load was normal.

By turning off the Plugin the page load times went back to normal.

I'll look into the slowdown. If you turn off the recentQueries in the adminCP options that should fix the slowdown, so you can continue to use it. I'm going to optimize it to make it work better and faster though. Thanks for the heads up, it wasn't slowing down the forum I was working with, but that doesn't meant that's how it will be for each user.

99SIVTEC

02-21-2012, 07:29 PM

I had to turn it off after the last update as it was slowing my page loading time on all pages from 0.23415 seconds to 3.41375 seconds.

What was strange while it was taking longer for pages to load the server load was normal.

By turning off the Plugin the page load times went back to normal.

Alright, I just released v1.6. This update made drastic changes to the table that held the recent queries. Therefore it should run a lot faster, and you should not notice any change in the load time on your forum.

Thanks for bringing this to my attention Scottct1. I appreciate it. :)

99SIVTEC

02-23-2012, 03:47 PM

Hey everyone, I just wanted to repost this from earlier.

Let me give you (and others a few tips). Most of my sales that were made during testing came from actual organic searches from search engines, not from the members of my own forum. I would start by promoting the feature on your site to your users. Mention that it is a way for them to help support your site since you earn a commission on every purchase. This goes a long way since members are often ready and willing to help support their favorite forum.

Next, get some organic traffic coming into the search pages. For this, you need to get some backlinks to some of the search result pages. This is as simple as displaying a few search url's in your signature on your forum, and encouraging your users to do that same.

We may also be able to create a side block that perhaps stores and shows the most popular searches? Doing this has the benefit of drawing attention to the search, but also gets some links in which helps get pages indexed and ultimately leads to sales.

Last but not least, be patient. It took me several weeks to start getting search traffic to my product search. After that, sales started to roll in slowly, and now I get several per day and have almost 7 million pages indexed. It went from my forum struggling to make money to being quite the money maker for me, but it took time .

So all in all, give this time. Sales will come, one just has to be patient. :)

BlueCheri

02-24-2012, 09:06 AM

Can not upgrade 1.6 XML file

G!

BlueCheri

02-25-2012, 11:15 AM

Do we have any type of responsibility for sale or giving search option, as they are searching through our forum?

Need to have any kind of disclaimer from our side?

G!

99SIVTEC

02-25-2012, 05:29 PM

Do we have any type of responsibility for sale or giving search option, as they are searching through our forum?

Need to have any kind of disclaimer from our side?

G!

Nope, no disclaimer is needed.

shona

02-27-2012, 08:35 AM

hi,

just tried to install this in vbulletin 4.1.9 forum

and forum index now is a blank page with the following error message:

Fatal error: Uncaught exception 'Exception' with message 'Prosperent_Api needs the CURL PHP extension.' in /web/inverts/Prosperent_Api.php:404 Stack trace: #0 /web/inverts/TopProducts.php(17): Prosperent_Api->__construct(Array) #1 /web/inverts/includes/class_bootstrap.php(98) : eval()'d code(63): include('/web/inverts/To...') #2 /web/inverts/includes/class_bootstrap.php(98): eval() #3 /web/inverts/includes/class_bootstrap.php(64): vB_Bootstrap->init() #4 /web/inverts/global.php(26): vB_Bootstrap->bootstrap() #5 /web/inverts/forum.php(63): require_once('/web/inverts/gl...') #6 /web/inverts/index.php(63): require('/web/inverts/fo...') #7 {main} thrown in /web/inverts/Prosperent_Api.php on line 404

have removed all files & uninstalled the xml file so the forum will function again. any suggestions?

also the install instructions say there are 4 files and 2 images in the folder which need to be ftp'ed in but I am seeing 6 php files + 5 images in /img/

thanks :)

99SIVTEC

02-27-2012, 03:23 PM

hi,

just tried to install this in vbulletin 4.1.9 forum

and forum index now is a blank page with the following error message:

have removed all files & uninstalled the xml file so the forum will function again. any suggestions?

also the install instructions say there are 4 files and 2 images in the folder which need to be ftp'ed in but I am seeing 6 php files + 5 images in /img/

thanks :)

Hey, what is your forums url?

And that's a mistake, I guess I had forgotten to update that in the write up when I updated it. Sorry about that.

J-P

02-27-2012, 03:53 PM

the product.php page seems to be giving an unusual amount of database errors. I get at least 10 a day with it disabled and and more when it is enabled.

Database error in vBulletin 4.1.10:

Invalid SQL:
SELECT *
FROM rbs_banners
WHERE enabled=1
AND startdate<=1330360708
AND enddate>=1330360708
AND IF(forumhome, 0=0, IF(forumids='', 1, FIND_IN_SET('0', forumids)))
AND IF(maximpressions>0, impressions<maximpressions, 1)
AND IF(clicktrack, maxclicks=0 OR (maxclicks>0 AND clicks<maxclicks), 1);

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Monday, February 27th 2012 @ 10:38:28 AM
Error Date : Monday, February 27th 2012 @ 10:38:39 AM
Script : http://www.invertplanet.com/forum/product.php?q=Sage-O-Soothe%20Tea%203.2%20oz%20by%20North%20American%20 Herb%20&Spice=
Referrer :
IP Address : 207.46.204.188
Username : Unregistered
Classname : vB_Database
MySQL Version :

There are various error messages but they all stem from the product.php page :(

99SIVTEC

02-27-2012, 04:17 PM

the product.php page seems to be giving an unusual amount of database errors. I get at least 10 a day with it disabled and and more when it is enabled.

There are various error messages but they all stem from the product.php page :(

Have you upgraded to the newest version yet? If not, I can do that for you real quick if that information you gave me last time works still. The newest version should fix the errors.

J-P

02-27-2012, 05:14 PM

just upgraded.

Will let you know :)

Thank you :D

99SIVTEC

02-27-2012, 05:17 PM

just upgraded.

Will let you know :)

Thank you :D

No problem. Yea that should fix any mySQL errors that you were getting, its a much more stable and faster version. :)

99SIVTEC

03-01-2012, 03:43 PM

So how's 1.6 working for everyone?

J-P

03-01-2012, 04:34 PM

still getting DB errors from unregistered users but not nearly as many as before. When I asked the hosting about this I received this reply:
Apache timeout: 30 seconds
MySQL timeout: 10 seconds
PHP Execution timeout: 45 seconds

I don't know if it is the time outs that are causing this or the cache.

99SIVTEC

03-01-2012, 06:43 PM

still getting DB errors from unregistered users but not nearly as many as before. When I asked the hosting about this I received this reply:

I don't know if it is the time outs that are causing this or the cache.

Which error is it giving you. Its been running fine on a test site, whether I'm logged in or not.

J-P

03-02-2012, 01:19 PM

This is the most common.

Database error in vBulletin 4.1.10:

Invalid SQL:

SELECT *
FROM style
WHERE (styleid = 5 AND userselect = 1)
OR styleid = 5
ORDER BY styleid ASC
LIMIT 1;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, March 2nd 2012 @ 03:44:19 AM
Error Date : Friday, March 2nd 2012 @ 03:44:31 AM
Script : http://www.invertplanet.com/forum/product.php?q=Slippers&priceSort=&filterBrand=Overland+Sheepskin+Co
Referrer :
IP Address : 66.249.72.243
Username : Unregistered
Classname : vB_Database
MySQL Version :

This one come up on occasion:
Database error in vBulletin 4.1.10:

Invalid SQL:
SELECT *
FROM rbs_banners
WHERE enabled=1
AND startdate<=1330678621
AND enddate>=1330678621
AND IF(forumhome, 0=0, IF(forumids='', 1, FIND_IN_SET('0', forumids)))
AND IF(maximpressions>0, impressions<maximpressions, 1)
AND IF(clicktrack, maxclicks=0 OR (maxclicks>0 AND clicks<maxclicks), 1);

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, March 2nd 2012 @ 02:57:01 AM
Error Date : Friday, March 2nd 2012 @ 02:57:14 AM
Script : http://www.invertplanet.com/forum/product.php?q=Cheng's%20Ent.
Referrer :
IP Address : 66.249.72.243
Username : Unregistered
Classname : vB_Database
MySQL Version :

I just noticed that the request date and error dates are just a tad over the 10 second limit :(

shona

03-06-2012, 12:56 AM

Hey, what is your forums url?

And that's a mistake, I guess I had forgotten to update that in the write up when I updated it. Sorry about that.

forum url is http://inverts.com.au

thanks :)

J-P

03-10-2012, 12:56 PM

had to disable it again...

This time it crashed the entire forum until I found the file:
prosperent_queries (in the phpMyAdmin section) and deleted the contents. The queries went up to 999 and then stopped. After that the entire forum went "poof".

Which is too bad. I really liked this product and hope one day to implement it fully.

BlueCheri

03-10-2012, 04:33 PM

Some thing wrong:

Feb Impressions: 462093

And for March: 25900 (this impression figure is fixed for last few days may be for 4/5 days )

Please check.

G!

99SIVTEC

03-12-2012, 03:26 PM

Working on the bugs you guys have found, it seems they mostly stem from the table for recent queries. If that is causing you issues at the moment I would disable it inside the AdminCP for the time being, that will stop it from writing to the table for recent queries. And you can still run the product.

BlueCheri

03-14-2012, 05:51 AM

All right, waiting for your update on this.

Note: The product is kept on forum.

G!

Working on the bugs you guys have found, it seems they mostly stem from the table for recent queries. If that is causing you issues at the moment I would disable it inside the AdminCP for the time being, that will stop it from writing to the table for recent queries. And you can still run the product.

alasiri

04-30-2012, 10:03 AM

thank you ...

99SIVTEC

05-18-2012, 05:49 PM

Hey everyone, I'm sorry this took a while to get updated. We did a huge overhaul on the API, to make it work even better and faster. I took out the recent queries table that was affecting some of you, I felt that even if I were to fix it it would still slow your forums down. I added a CSS file so most of the styling can be found there instead of inline. Figured that would make it easier to change to your liking. If anyone has any questions let me know. Glad to be back. Hope you all are doing well.

99SIVTEC

05-31-2012, 02:19 PM

Also, Reporting has been redone, offers you a lot more info on how your forum is doing.

We've also released updated Performance Ads, which once you log into Prosperent you can view. Its very easy to implement these into your forum and they will take the CSS from your page so they actually look like they belong there, unlike some other ads.

Also we've release ProsperLinks, it has a very in-depth algorithm that will come back with the what your page is about, and it will link products depending on what it finds.

99SIVTEC

07-17-2012, 02:03 PM

This last update added Negative Filters. Negative filters allow you to remove a Brand or Merchant, or multiple Brands/ Merchants, from the results.

Using the ACP just list out the Brand or Merchant that you do not want in the results. If there are multiple Brands or Merchants just use commas to separate each one, and make sure your spelling is identical to how their names are shown in the results.

99SIVTEC

10-24-2012, 07:55 PM

The newest version includes an updated API, a starting query admin option for those who want to set a query for when users go to the product page without a query.

Also, the query now accepts apostrophes, so searching for something like Levi's return correct products.

Brandon Sheley

10-24-2012, 08:46 PM

nice affiliate link there OP ;)

I wonder how much the OP made off everyone here :rolleyes:

99SIVTEC

10-25-2012, 06:03 PM

Actually I am not making anything, that is a link for us to track visitors from this site. Affiliate links are not allowed.

scottct1

11-16-2012, 04:01 PM

I just installed this again for the Holiday Season and now for every product I search for I get

No Results
Please refine your search.

Even generated a new API Key and am having the same issue with that one as well. Any ideas?

scottct1

11-20-2012, 11:58 PM

Ok I updated and while the search is working, the search box that I had in my Navbar template is no longer being shown.

PLEASE RETURN IT TO THE WAY IT WAS!

I do not use Forum Blocks. I had it setup great in my Navbar template.

scottct1

11-22-2012, 03:21 AM

THANK YOU for the QUICK FIX!

It is working great now on my site. :)

dodgechargerfan

12-25-2012, 02:32 PM

I am finding that when I have the Product Search bar set up, my forum will not load if the Prosperent website is unreachable - as it is right now, apparently.

I am getting timeout errors related to the API when my site tries to load.

When I try to browse to www.prosperent.com directly, I get a CloudFlare error saying that the website is unavailable.

I can't even get into my admincp to disable the plugin because I still have the template change in place for the search bar.
Until your site comes back up, I'm dead in the water.

Here's hoping your site problems are minor.