Test our Advanced Pay-Site Search!!
 

We're finishing up a completely version upgrade of TheBestPorn.com today. :))

Part of the upgrade includes a kickass advanced search tool that most users won't be able to appreciate enough. I thought I would share it here and get a webmasters opinion. We just launched it officially last night, so let me know if there are any bugs.

I'm sure a lot of webmasters will find it useful:
http://www.thebestporn.com/search_advanced.html

For those who visit our site often, checkout the rest of our new pages as well. We're pretty much finished upgrading all our pages!! It's a long time coming for myself and the staff.

Thanks for checking it out!

RickM

Rick, a major congrats to you! You have been such an innovator back when you started YNOT. I remember when I first posted on your webmaster board in 1996.

You went on to pioneer amatuer masters, and now in my opinion you championed the best adult review site that surfers depend on and trust.

Make XbangCash write those big checks! Thanks for standing by us during our growing pains.

Congrats my friend! Major props, but thats what you have always been destined to do, change the landscape as we know it :-)

holy cow thats alot of search options, nice! :thumbsup

Wow Rick... very impressive indeed.
If I know anything about you, it's that you never do anything half-fast. WELL DONE.

Very detailed Rick! I'm sure the surfers will agree - now they find exactly all the sites with the itty-bitty detail they are looking for. It will definitely increase exposure to some sites. My compliments as I'm sure it wasn't easy getting all the figured out and ready to roll :thumbsup :thumbsup

Lee, you're too much!!!! I really appreciate your "more" than kind words. We've really worked hard on this site and really believe in it's success. I can't wait to work closer with XBC, and finally get all those sites rated. :)

p.s. Zmaster was shit!! :pimp

I meant "Zmaster was THE shit!!!" ... lol forgive me lee.

Thanks Jay, Trix, and Evil One!

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY a.id ORDER BY score_total DESC,a.name ASC LIMIT 0,50

SELECT a.id,a.name,a.sitetype,a.shortname,a.sitetype,IF(a .site_birth_month=0 AND a.site_birth_year=0,1,0) AS birthOrder,a.site_birth_month,a.site_birth_year,a. major_update,a.primary_cat,IF(c.review_status=4 AND c.review_date <= 1115794800,SUM(b.score_total)/COUNT(*),0) as score_total,IF(c.review_status=4 AND c.review_date <= 1115794800,SUM(b.score_total)/COUNT(*),99999) as score_totalASC,c.caps_status,c.listing_date,c.revi ew_date,c.review_type,IF(c.review_status=4 AND c.review_date <= 1115794800,c.review_date,c.listing_date) AS overallDate,c.review_status,d.title AS catname,e.shortname AS sitetypename,MIN(f.amount) AS trial,IF(MIN(f.amount) IS NULL,9999999,MIN(f.amount)) AS trialSortASC,IF(MIN(f.amount) IS NULL,'',MIN(f.amount)) AS trialSortDESC,MIN(g.amount) AS monthly,IF(MIN(g.amount) IS NULL,9999999,MIN(g.amount)) AS monthlySortASC,IF(MIN(g.amount) IS NULL,0,MIN(g.amount)) AS monthlySortDESC,IF(a.major_update=1,0,1) AS facts,IF(c.caps_status=2,0,1) AS caps FROM tbp_sites a LEFT JOIN tbp_sites_reviews b ON a.id=b.siteid LEFT JOIN tbp_sites_status c ON a.id=c.siteid LEFT JOIN tbp_list_categories d ON a.primary_cat=d.id LEFT JOIN tbp_list_sitetypes e ON a.sitetype=e.id LEFT JOIN tbp_cost_options f ON a.id=f.siteid AND 2=f.cost_option LEFT JOIN tbp_cost_options g ON a.id=g.siteid AND 3=g.cost_option WHERE a.id IN () GROUP BY a.id ORDER BY score_total DESC,a.name ASC LIMIT 0,50

Very nice work. I would hate to be the DBA =]

Hey Bama! Thanks for the bug report man. This should be fixed now.

Hi Bama! Long time no see hon', how are you?