The Arcive of Official vBulletin Modifications Site.

Improved Post Report System · **Released**: 02-17-2005

This hack will place post reports into modcp, and enable moderators to give feedback to users via a page that users can see which includes all of their own post reports.

Post reports have three possible statuses: open, pending or closed.

When a post report is made, the report is put into a page in modcp called 'outstanding reports', and has a status of 'open'. There is a new option in admincp which governs whether or not the post report emails are sent to moderators; so if this is switched on, the emails are still sent.

Moderators can then see who reported the post and the time at which it was reported, and the comment given by the user. There are also links to the post itself, the thread the post is on, the forum the thread is in, the user who posted the post and the user who reported the post.

The user page can be linked anywhere you choose; I have included instructions for linking it on the quicklinks menu.

This system can be switched on or off from admincp. When off, the behaviour of post reports is as normal.

I've also included an optional scheduled task which will remove post reports from the system than are older than an age specified in days in admincp.

Moderators can then update the status of the report, and add a comment. The user who reported the post can then see these changes reflected in their page - it will show the name of the moderator dealing with the report, the comment (if any) left by the moderator, and the time at which the report was last updated.

When a moderator sets the status of a report to 'closed', it is moved to another page in modcp called 'closed post reports'. Post reports that are in the pending state are still kept in the 'outstanding post reports' page.

This hack has been tested on 3.0.3, 3.0.4, 3.0.5 and 3.0.6, and can be seen in action on The Student Room where it has been up and running since 18th January 2005.

Screenshots:

1) What the user sees
2) A closed report in modcp
3) The admincp settings
4) An open report and the modcp menu items

Updated 26th Feb 2005: installer now calls build_language so there is no need to rebuild the phrase cache manually.

wwesn1 · #2 02-18-2005, 07:42 PM

I am getting this error....

Code:

Invalid SQL: 
		SELECT
		vb3_postreport.*,
		vb3_user.username modname,
		vb3_user2.username reporter,
		vb3_post.username postername,
		vb3_post.userid posterid,
		vb3_thread.title,
		vb3_thread.threadid,
		vb3_forum.title forumtitle,
		vb3_forum.forumid
		FROM vb3_postreport AS postreport
		LEFT JOIN vb3_user AS user ON (postreport.modid = user.userid)
		LEFT JOIN vb3_user AS user2 ON (postreport.userid = user2.userid)
		LEFT JOIN vb3_post AS post ON (postreport.postid = post.postid)
		LEFT JOIN vb3_thread AS thread ON (post.threadid = thread.threadid)
		LEFT JOIN vb3_forum AS forum ON (thread.forumid = forum.forumid)
		WHERE postreport.status < 2
		ORDER BY dateline DESC
		LIMIT 0, 25
	
mysql error: Unknown table 'vb3_postreport'

and yes I have a table called vb3_postreport

wwesn1 · #3 02-18-2005, 07:46 PM

nvm, figured it out. If anyone else has a table prefix for their vbulletin you'll need to open modcp/postreport.php and change....

Code:

$searchquery = "
		SELECT
		" . TABLE_PREFIX . "postreport.*,
		" . TABLE_PREFIX . "user.username modname,
		" . TABLE_PREFIX . "user2.username reporter,
		" . TABLE_PREFIX . "post.username postername,
		" . TABLE_PREFIX . "post.userid posterid,
		" . TABLE_PREFIX . "thread.title,
		" . TABLE_PREFIX . "thread.threadid,
		" . TABLE_PREFIX . "forum.title forumtitle,
		" . TABLE_PREFIX . "forum.forumid
		FROM " . TABLE_PREFIX . "postreport AS postreport
		LEFT JOIN " . TABLE_PREFIX . "user AS user ON (postreport.modid = user.userid)
		LEFT JOIN " . TABLE_PREFIX . "user AS user2 ON (postreport.userid = user2.userid)
		LEFT JOIN " . TABLE_PREFIX . "post AS post ON (postreport.postid = post.postid)
		LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON (post.threadid = thread.threadid)
		LEFT JOIN " . TABLE_PREFIX . "forum AS forum ON (thread.forumid = forum.forumid)
		WHERE postreport.status < 2
		ORDER BY dateline DESC
		LIMIT $page_start, $reports_per_page
	";

TO

Code:

$searchquery = "
		SELECT
		postreport.*,
		user.username modname,
		user2.username reporter,
		post.username postername,
		post.userid posterid,
		thread.title,
		thread.threadid,
		forum.title forumtitle,
		forum.forumid
		FROM " . TABLE_PREFIX . "postreport AS postreport
		LEFT JOIN " . TABLE_PREFIX . "user AS user ON (postreport.modid = user.userid)
		LEFT JOIN " . TABLE_PREFIX . "user AS user2 ON (postreport.userid = user2.userid)
		LEFT JOIN " . TABLE_PREFIX . "post AS post ON (postreport.postid = post.postid)
		LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON (post.threadid = thread.threadid)
		LEFT JOIN " . TABLE_PREFIX . "forum AS forum ON (thread.forumid = forum.forumid)
		WHERE postreport.status < 2
		ORDER BY dateline DESC
		LIMIT $page_start, $reports_per_page
	";

That seemed to do the trick for me.

boozehound · #4 02-18-2005, 07:47 PM

Quote:

Originally Posted by wwesn1

I am getting this error....
...
and yes I have a table called vb3_postreport

It was a missing TABLE_PREFIX, my apologies. I've updated it.

wwesn1 · #5 02-18-2005, 07:48 PM

and there would appear to be two instances of this to change in the file

wwesn1 · #6 02-18-2005, 07:52 PM

sorry the above error I had was in modcp/postreport.php

did you put the missing TABLE_PREFIX in the root/postreports.php

which would fix this error I had

Code:

Invalid SQL: 
	SELECT COUNT(p.reportid) AS reportcount
	FROM postreport p WHERE p.userid = 41

mysql error: Table 'wrestle_wrestle.postreport' doesn't exist

wwesn1 · #7 02-18-2005, 07:55 PM

and I had to remove more " . TABLE_PREFIX . " from the root/postreports.php file in the same place as I listed above a few posts. Don't ask me why?

But anyhow it works for me now

Thanks

boozehound · #8 02-18-2005, 07:55 PM

Quote:

Originally Posted by wwesn1

sorry the above error I had was in modcp/postreport.php

did you put the missing TABLE_PREFIX in the root/postreports.php

which would fix this error I had

Code:

Invalid SQL: 
	SELECT COUNT(p.reportid) AS reportcount
	FROM postreport p WHERE p.userid = 41

mysql error: Table 'wrestle_wrestle.postreport' doesn't exist

Both files should be ok now.

Delphiprogrammi · #9 02-18-2005, 09:01 PM

hi people,

i'm getting this error

Code:

Database error in vBulletin 3.0.6:

Invalid SQL: 
	SELECT
	vb3_postreport.*,
	vb3_user.username modname,
	vb3_post.username postername,
	vb3_post.userid posterid,
	vb3_thread.title, thread.threadid
	FROM vb3_postreport AS postreport
	LEFT JOIN vb3_user AS user ON (postreport.modid = user.userid)
	LEFT JOIN vb3_post AS post ON (postreport.postid = post.postid)
	LEFT JOIN vb3_thread AS thread ON (post.threadid = thread.threadid)
	WHERE vb3_postreport.userid = 1
	ORDER BY postreport.dateline DESC
	LIMIT 0, 25

mysql error: Unknown table 'vb3_postreport'

mysql error number: 1051

Date: Saturday 19th of February 2005 12:20:54 AM
Script: http://**********/postreports.php
Referer: 
Username: ************
IP Address: ************

still that table is there ....

my /modcp/postreports.php works fine

wwesn1 · #10 02-18-2005, 09:06 PM

did you read my posts?

Change The

Code:

		" . TABLE_PREFIX . "postreport.*,
		" . TABLE_PREFIX . "user.username modname,
		" . TABLE_PREFIX . "user2.username reporter,
		" . TABLE_PREFIX . "post.username postername,
		" . TABLE_PREFIX . "post.userid posterid,
		" . TABLE_PREFIX . "thread.title,
		" . TABLE_PREFIX . "thread.threadid,
		" . TABLE_PREFIX . "forum.title forumtitle,
		" . TABLE_PREFIX . "forum.forumid

TO

Code:

		postreport.*,
		user.username modname,
		user2.username reporter,
		post.username postername,
		post.userid posterid,
		thread.title,
		thread.threadid,
		forum.title forumtitle,
		forum.forumid

That will work untill he fixes it

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04769 seconds Memory Usage 2,308KB Queries Executed 23 (?)
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 (8)bbcode_code (2)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (9)postbit (10)postbit_onlinestatus (10)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 post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

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