Test our Advanced Pay-Site Search!! - GoFuckYourself.com

rankscom · 05-11-2005, 07:52 AM

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

LeeNoga · 05-11-2005, 08:07 AM

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 :-)

Bro Media - BANNED FOR LIFE · 05-11-2005, 08:15 AM

holy cow thats alot of search options, nice!

Evil Chris · 05-11-2005, 08:18 AM

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

Trixxxia · 05-11-2005, 08:25 AM

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

rankscom · 05-11-2005, 08:27 AM

Quote:

Originally Posted by LeeNoga

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 :-)

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!!

rankscom · 05-11-2005, 08:51 AM

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

rankscom · 05-11-2005, 08:53 AM

Thanks Jay, Trix, and Evil One!

Bama · 05-11-2005, 10:04 AM

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

FreeHugeMovies · 05-11-2005, 10:12 AM

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

rankscom · 05-11-2005, 10:47 AM

Quote:

Originally Posted by Bama

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

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

LeeNoga · 05-11-2005, 11:37 AM

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

05-11-2005, 07:52 AM	#1
rankscom Rick Moby Industry Role: Join Date: Sep 2001 Location: Henderson, NV Posts: 433	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 __________________ MyPorn.com - Porn's most anticipated free site of tomorrow. Coming Q4, 2015.

05-11-2005, 08:18 AM	#4
Evil Chris OG Industry Role: Join Date: Dec 2001 Location: 3rd from the Sun Posts: 13,233	Wow Rick... very impressive indeed. If I know anything about you, it's that you never do anything half-fast. WELL DONE. __________________ It PAYZE to post on GFY chris at payze.com \| Skype chriswrp

05-11-2005, 08:51 AM	#7
rankscom Rick Moby Industry Role: Join Date: Sep 2001 Location: Henderson, NV Posts: 433	I meant "Zmaster was THE shit!!!" ... lol forgive me lee. __________________ MyPorn.com - Porn's most anticipated free site of tomorrow. Coming Q4, 2015.

05-11-2005, 08:53 AM	#8
rankscom Rick Moby Industry Role: Join Date: Sep 2001 Location: Henderson, NV Posts: 433	Thanks Jay, Trix, and Evil One! __________________ MyPorn.com - Porn's most anticipated free site of tomorrow. Coming Q4, 2015.

05-11-2005, 08:07 AM	#2
LeeNoga Confirmed User Join Date: Jul 2001 Location: Egg & Sperm Mutation Posts: 3,043	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 :-)

05-11-2005, 08:15 AM	#3
Bro Media - BANNED FOR LIFE MOBILE PORN: IMOBILEPORN Join Date: Jan 2004 Location: Tinseltown NL Posts: 16,502	holy cow thats alot of search options, nice!

05-11-2005, 08:25 AM	#5
Trixxxia Confirmed User Industry Role: Join Date: Aug 2004 Location: Montreal, Canada Posts: 5,600	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

05-11-2005, 10:04 AM	#9
Bama Confirmed User Join Date: Nov 2001 Location: Redmond, WA Posts: 2,727	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

05-11-2005, 10:12 AM	#10
FreeHugeMovies Too lazy to set a custom title Join Date: Dec 2001 Location: Charlotte, NC Posts: 14,137	Very nice work. I would hate to be the DBA =]

05-11-2005, 11:37 AM	#12
LeeNoga Confirmed User Join Date: Jul 2001 Location: Egg & Sperm Mutation Posts: 3,043	Hi Bama! Long time no see hon', how are you?