vb.org Archive - View Single Post

#**254** 08-24-2001, 07:56 PM

Quote:

Originally posted by fastforward

Yeah, that should be easy. Usenet posts made by forum members can be identified by a '-1' in the isusenetpost column in the post table.

It might take me a few weeks to get around to it though. I'm in the middle of re-doing BritishExpats.com. It's still running vB 1.1.6 so I think it's about time I did something about it.

You can make the change yourself if you like. It's easy peasy. Find the line that was added by the usenet hack in search.php. It should read:
$wheresql.=" AND thread.isusenetpost=0";
Change that to:
$wheresql.=" AND thread.isusenetpost=0 AND post.isusenetpost <= -1";

If you just want threads that were started by members, change it to:
$wheresql.=" AND thread.isusenetpost <= -1";

bitbender:
Thanks for your kind words.

unfortunatly im getting this when doin those additions:

Database error in vBulletin: Invalid SQL: SELECT COUNT(*) AS threads FROM thread

WHERE thread.visible=1 AND 1=1 AND thread.lastpost>=998680523 AND thread.open<>10 AND thread.isusenetpost=0 AND post.isusenetpost <= -1
mysql error:
mysql error number:
Date: Friday 24th of August 2001 01:51:05 PM
Script: /~unreal-a/vbulletin/search.php3?s=&action=showresults&getnew=true&sear chid=551
Referer:

Any hints? Thanx in advance!

-Alex

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01107 seconds Memory Usage 1,764KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD_SHOWPOST (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_quote (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_box (1)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit_info (1)postbit (1)postbit_wrapper (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit reputationlevel showthread	Included Files: ./showpost.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_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showpost_start bbcode_fetch_tags bbcode_create postbit_factory showpost_post postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start showpost_complete
Messages: