Improved Post Report System

[boozehound]

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 (http://www.thestudentroom.co.uk/) 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]

I am getting this error....


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]

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


$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


$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]

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]

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

[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


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]

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]

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


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]

hi people,

i'm getting this error


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]

did you read my posts?

Change The


" . 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


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

[Delphiprogrammi]

did you read my posts?

Change The


" . 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


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
yeah i did read your posts but i'm getting anothr error as you had php code that's causing the error ...


$postreports = $DB_site->query("
SELECT
" . TABLE_PREFIX . "postreport.*,
" . TABLE_PREFIX . "user.username modname,
" . TABLE_PREFIX . "post.username postername,
" . TABLE_PREFIX . "post.userid posterid,
" . TABLE_PREFIX . "thread.title, thread.threadid
FROM " . TABLE_PREFIX . "postreport AS postreport
LEFT JOIN " . TABLE_PREFIX . "user AS user ON (postreport.modid = user.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)
WHERE " . TABLE_PREFIX ."postreport.userid = $userid
ORDER BY postreport.dateline DESC
LIMIT $page_start, $reports_per_page
");


:confused:

[wwesn1]

yes, for some reason those first four " . TABLE_PREFIX . " were messing things up. Unless he missed something somewhere that would make it work

[boozehound]

Ok, the problems with the TABLE_PREFIXes... I've updated the files in the zip to work correctly with table prefixes, and also switched the SQL queries for an installer. The installer should add the correct table prefix to the new table.

There is a possibility that if you just ran the queries as they were, on a system that uses table prefixes, you could still have a problem. But you should be able to fix that by removing " . TABLE_PREFIX . " from the FROM clause of the queries.

[trackpads]

Wow, this hack looks great! I am going to install it tonight! Great work!!!!

[Delphiprogrammi]

yeag that seems to be solved now thanks for fixing that ;)

[boozehound]

yeag that seems to be solved now thanks for fixing that ;)
Sorry for any problems you had! Neither the forum it's been installed on for a while nor my test forum use table prefixes, so it was never tested in that way (til now). And there I was thinking gratuitous use of " . TABLE_PREFIX . " would make it ok ;)

[Freezerator]

Wow, this is how post report should have been!
Installing!

[Freezerator]

Works like a charm.

One question or suggestion: Can there be that when a mod looks @ the postreport pages, that he sees al reports, and not the ones from himself? Or somewhere a counter so they can easy see there are open post reports waiting.

[boozehound]

One question or suggestion: Can there be that when a mod looks @ the postreport pages, that he sees al reports, and not the ones from himself?

I suppose so but couldn't they just look in modcp for the same information?


Or somewhere a counter so they can easy see there are open post reports waiting.

Hopefully in a future release :)

[Delphiprogrammi]

hi,

ok dumb question but i'm gonna ask anyhow :D i logged in with my normal user account i use for testing stuff like this and i reported a post.I receive an e-mail with stuff "post reported" but that table remains empty ? also in /modcp/ there's nothing there it says no posts have been reported :s what am i doing here

[Delphiprogrammi]

hi,

nevermind i figured it out it works ok now i did something wrong while editing report.php up and running

* Delphiprogrammi clcks install

i will add this hack to my list ;)

[shadiguy1]

any chance u can add it in the admincp as well so i dont have to use the modcp lol on my site and my mods can use it on the modcp. Most appreciated if you can do this for me thanks in advance ,. Awsome hack Thanks again.

[boozehound]

any chance u can add it in the admincp as well so i dont have to use the modcp lol on my site and my mods can use it on the modcp. Most appreciated if you can do this for me thanks in advance ,. Awsome hack Thanks again.
You could just put the modcp/postreports.php file into the admincp directory, and edit admincp/index.php to add the links to the two pages, which would still be postreports.php?do=closed and postreports.php?do=list. The hack will work just the same way, as it does not rely on that file being anywhere specific.

[shadiguy1]

to add this to AdminCp Do these edits. And Copy postreports.php from modcp over to admincp folder

Find in This: /admincp/index.php

Find This Code:

construct_nav_group($vbphrase['users']);

Below This Add:

construct_nav_option($vbphrase['postreports_new'], "postreports.php?do=list");
construct_nav_option($vbphrase['postreports_closed'], "postreports.php?do=closed");
construct_nav_group($vbphrase['postreports'], '<hr />', "$df");

[Diana Notacat]

Will this work along with Erwin's vB Report Manager (https://vborg.vbsupport.ru/showthread.php?t=59709) or will there be a future versions where you can have a report note sent to Mod's Forum or PMs? I rather like this mod for letting user's know they're being heard but I like using the other so staff can discuss reported threads if needed! :]

[The Realist]

I would like to know this as well.

Will this work along with Erwin's vB Report Manager (https://vborg.vbsupport.ru/showthread.php?t=59709) or will there be a future versions where you can have a report note sent to Mod's Forum or PMs? I rather like this mod for letting user's know they're being heard but I like using the other so staff can discuss reported threads if needed! :]

[boozehound]

Will this work along with Erwin's vB Report Manager (https://vborg.vbsupport.ru/showthread.php?t=59709) or will there be a future versions where you can have a report note sent to Mod's Forum or PMs? I rather like this mod for letting user's know they're being heard but I like using the other so staff can discuss reported threads if needed! :]
I haven't installed that hack but from looking at the code for it the two should be able to coexist perfectly happily. I'll figure out the changes to report.php need to get these two working together and post it up here, for those that don't fancy figuring it out themselves :)

[boozehound]

Ok, assuming you've first installed the other hack, go about installing this one as normal, except when you come to the part that says:


find:

if ($reason == '')
{
eval(print_standard_error('error_noreason'));
}

add afterwards:

if ($vboptions['postreports_enabled'])
{
require_once('./includes/functions.php');

$userid = $bbuserinfo['userid'];
$DB_site->query("INSERT INTO " . TABLE_PREFIX . "postreport
(postid, userid, reporttext, status, dateline)
VALUES
($postid,
$userid,
'". addslashes(htmlspecialchars_uni($reason)) . "',
0,
" . TIMENOW . "
)");
}

if (!$vboptions['postreports_enabled'] || ($vboptions['postreports_enabled'] && $vboptions['postreports_alsoemail']))
{

find:

vbmail_end();

add afterwards:

}

instead 'add afterwards' the following code only:


if ($vboptions['postreports_enabled'])
{
require_once('./includes/functions.php');

$userid = $bbuserinfo['userid'];
$DB_site->query("INSERT INTO " . TABLE_PREFIX . "postreport
(postid, userid, reporttext, status, dateline)
VALUES
($postid,
$userid,
'". addslashes(htmlspecialchars_uni($reason)) . "',
0,
" . TIMENOW . "
)");
}


The two systems should then work in tandem, and the email setting of my hack is ignored and the email settings of the other hack is used.

My report.php with both hacks installed if I've not explained it very well:


<?php
/*================================================= =====================*\
|| ################################################## ################## ||
|| # vBulletin 3.0.7 - Licence Number <edited>
|| # ---------------------------------------------------------------- # ||
|| # Copyright ?2000?2005 Jelsoft Enterprises Ltd. All Rights Reserved. ||
|| # This file may not be redistributed in whole or significant part. # ||
|| # ---------------- VBULLETIN IS NOT FREE SOFTWARE ---------------- # ||
|| # http://www.vbulletin.com | http://www.vbulletin.com/license.html # ||
|| ################################################## ################## ||
\*================================================ ======================*/

// ####################### SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);

// #################### DEFINE IMPORTANT CONSTANTS #######################
define('NO_REGISTER_GLOBALS', 1);
define('THIS_SCRIPT', 'report');

// ################### PRE-CACHE TEMPLATES AND DATA ######################
// get special phrase groups
$phrasegroups = array('messaging');

// get special data templates from the datastore
$specialtemplates = array();

// pre-cache templates used by all actions
$globaltemplates = array(
'newpost_usernamecode',
'reportbadpost'
);

// pre-cache templates used by specific actions
$actiontemplates = array();

// ######################### REQUIRE BACK-END ############################
require_once('./global.php');

// Erwin's Report Hack
require_once('./includes/functions_bbcodeparse.php');
require_once('./includes/functions_newpost.php');
// Erwin's Report Hack

// ################################################## #####################
// ######################## START MAIN SCRIPT ############################
// ################################################## #####################

//check usergroup of user to see if they can use this
if (!$bbuserinfo['userid'])
{
print_no_permission();
}

/*
if (!$vboptions['enableemail'])
{
eval(print_standard_error('error_emaildisabled'));
}
*/
if (!$vboptions['enableemail'] && ($vboptions['postreports_enabled'] && $vboptions['postreports_alsoemail']))
{
eval(print_standard_error('error_emaildisabled'));
}

if (empty($_REQUEST['do']))
{
$_REQUEST['do'] = 'report';
}

$forumperms = fetch_permissions($threadinfo['forumid']);
if (!($forumperms & CANVIEW))
{
print_no_permission();
}

if ($threadinfo['isdeleted'] OR $postinfo['isdeleted'])
{
$idname = $vbphrase['post'];
eval(print_standard_error('error_invalidid'));
}

// check if there is a forum password and if so, ensure the user has it set
verify_forum_password($foruminfo['forumid'], $foruminfo['password']);

if ($_REQUEST['do'] == 'report')
{
$postid = verify_id('post', $_REQUEST['postid'] );

/*if ($postinfo['userid'] == $bbuserinfo['userid'])
{
eval(print_standard_error('error_cantreportself')) ;
}*/

// draw nav bar
$navbits = array();
$parentlist = array_reverse(explode(',', $foruminfo['parentlist']));
foreach ($parentlist AS $forumID)
{
$forumTitle = $forumcache["$forumID"]['title'];
$navbits["forumdisplay.php?$session[sessionurl]f=$forumID"] = $forumTitle;
}
$navbits["showthread.php?$session[sessionurl]p=$postid"] = $threadinfo['title'];
$navbits[''] = $vbphrase['report_bad_post'];
$navbits = construct_navbits($navbits);

require_once('./includes/functions_editor.php');
$textareacols = fetch_textarea_width();
eval('$usernamecode = "' . fetch_template('newpost_usernamecode') . '";');

eval('$navbar = "' . fetch_template('navbar') . '";');
eval('print_output("' . fetch_template('reportbadpost') . '");');

}

if ($_POST['do'] == 'sendemail')
{
$postid = verify_id('post', $_REQUEST['postid'] );

globalize($_POST , array('reason' => STR));

if ($reason == '')
{
eval(print_standard_error('error_noreason'));
}

if ($vboptions['postreports_enabled'])
{
require_once('./includes/functions.php');

$userid = $bbuserinfo['userid'];
$DB_site->query("INSERT INTO " . TABLE_PREFIX . "postreport
(postid, userid, reporttext, status, dateline)
VALUES
($postid,
$userid,
'". addslashes(htmlspecialchars_uni($reason)) . "',
0,
" . TIMENOW . "
)");
}

/*
$moderators = $DB_site->query("
SELECT DISTINCT user.email
FROM " . TABLE_PREFIX . "moderator AS moderator," . TABLE_PREFIX . "user AS user
WHERE user.userid = moderator.userid
AND moderator.forumid IN ($foruminfo[parentlist])
");
*/
// Erwin's Report Hack
$moderators = $DB_site->query("
SELECT DISTINCT user.email, user.userid
FROM " . TABLE_PREFIX . "moderator AS moderator," . TABLE_PREFIX . "user AS user
WHERE user.userid = moderator.userid
AND moderator.forumid IN ($foruminfo[parentlist])
");
// Erwin's Report Hack

$mods = array();

while ($moderator = $DB_site->fetch_array($moderators))
{
$mods[] = $moderator;
}

$threadinfo['title'] = unhtmlspecialchars($threadinfo['title']);
$postinfo['title'] = unhtmlspecialchars($postinfo['title']);
/*
if (empty($mods) OR $foruminfo['options'] & $_FORUMOPTIONS['warnall'])
{
// get admins if no mods or if this forum notifies all
$moderators = $DB_site->query("
SELECT user.email, user.languageid
FROM " . TABLE_PREFIX . "user AS user
INNER JOIN " . TABLE_PREFIX . "usergroup AS usergroup USING (usergroupid)
WHERE usergroup.adminpermissions <> 0
");

while ($moderator = $DB_site->fetch_array($moderators))
{
$mods[] = $moderator;
}
}
*/
// Erwin's Report Hack
if (empty($mods) OR $foruminfo['options'] & $_FORUMOPTIONS['warnall'])
{
// get admins if no mods or if this forum notifies all
$moderators = $DB_site->query("
SELECT user.email, user.languageid, user.userid
FROM " . TABLE_PREFIX . "user AS user
INNER JOIN " . TABLE_PREFIX . "usergroup AS usergroup USING (usergroupid)
WHERE usergroup.adminpermissions <> 0
");

while ($moderator = $DB_site->fetch_array($moderators))
{
$mods[] = $moderator;
}
}

// Erwin's Report Hack
// Erwin's Report Hack
if ($vboptions['vbreportthread'] == '1') {
$forumid = $vboptions['vbreportforum'];
$today = vbdate('m-d-Y', TIMENOW, false, false);
$DB_site->query("
INSERT INTO " . TABLE_PREFIX . "thread(title, lastpost, forumid, open, replycount,
postusername, postuserid, lastposter, dateline, iconid, visible, attach)
VALUES
('$today REPORT: " . addslashes($foruminfo['title']) . " - " . addslashes($postinfo['username']) . "', " . TIMENOW . ", $forumid,
1, 0, '" . addslashes($bbuserinfo['username']) . "', $bbuserinfo[userid],
'" . addslashes($bbuserinfo['username']) . "', " . TIMENOW . ", 0, 1,
0)
");
$thread['threadid'] = $DB_site->insert_id();
eval(fetch_email_phrases('reportbadpost'));
$message = convert_url_to_bbcode($message);
$DB_site->query("
INSERT INTO " . TABLE_PREFIX . "post
(threadid, title, username, userid, dateline, pagetext, allowsmilie,
showsignature, iconid, visible)
VALUES
($thread[threadid], '$today REPORT: " . addslashes($foruminfo['title']) . " - " . addslashes($postinfo['username']) . "',
'" . addslashes($bbuserinfo['username']) . "', $bbuserinfo[userid], " . TIMENOW . ",
'" . addslashes($message) . "', 1, 1,
0, 1)
");
$post['postid'] = $DB_site->insert_id();
$DB_site->query("
UPDATE " . TABLE_PREFIX . "thread
SET firstpostid = $post[postid]
WHERE threadid = $thread[threadid]
");
$DB_site->query("
UPDATE " . TABLE_PREFIX . "forum
SET replycount = replycount + 1,
threadcount = threadcount + 1,
lastpost = " . TIMENOW . ",
lastposter = '" . addslashes($bbuserinfo['username']) . " - " . addslashes($postinfo['username']) . "',
lastthread = '$today REPORT: " . addslashes($foruminfo['title']) . "',
lastthreadid = $thread[threadid]
WHERE forumid = $forumid
");
}
if ($vboptions['vbreportpm'] == '1') {
$DB_site->query("INSERT INTO " . TABLE_PREFIX . "pmtext\n\t(fromuserid, fromusername, title, message, touserarray, iconid, dateline, showsignature)\nVALUES\n\t($bbuserinfo[userid], '" . addslashes($bbuserinfo['username']) . "', '$today REPORT: " . addslashes($foruminfo['title']) . " - " . addslashes($postinfo['username']) . "', '".addslashes(htmlspecialchars($message))."', '" . addslashes(serialize($tostring)) . "', 0, " . TIMENOW . ", 1)");

$pmtextid = $DB_site->insert_id();
}

// Erwin's Report Hack


vbmail_start();
/*
foreach ($mods AS $index => $moderator)
{
if (!empty($moderator['email']))
{
eval(fetch_email_phrases('reportbadpost', $moderator['languageid']));
vbmail($moderator['email'], $subject, $message);
}
}
*/

// Erwin's Report Hack
foreach ($mods AS $index => $moderator)
{
if (!empty($moderator['email']))
{
eval(fetch_email_phrases('reportbadpost', $moderator['languageid']));
if ($vboptions['vbreportemail'] == '1') {
vbmail($moderator['email'], $subject, $message);
}

if ($vboptions['vbreportpm'] == '1') {
$DB_site->query("INSERT INTO " . TABLE_PREFIX . "pm (pmtextid, userid, messageread) VALUES ($pmtextid, $moderator[userid], 0)");
$DB_site->shutdown_query("UPDATE " . TABLE_PREFIX . "user SET pmtotal=pmtotal+1, pmunread=pmunread+1 WHERE userid = $moderator[userid]");
}
}
}
// Erwin's Report Hack

vbmail_end();

eval(print_standard_redirect('redirect_reportthank s'));
}

/*================================================= =====================*\
|| ################################################## ##################
|| # Downloaded: 08:35, Sun Feb 20th 2005
|| # CVS: $RCSfile: report.php,v $ - $Revision: 1.47 $
|| ################################################## ##################
\*================================================ ======================*/
?>

[Nickeh32]

I installed this mod, well i tried. Followed everything correctly but they links arent showing up in modcp, the tables around them are their but no links!

Is it something i've done wrong, can someone help thanks!

[boozehound]

I installed this mod, well i tried. Followed everything correctly but they links arent showing up in modcp, the tables around them are their but no links!

Is it something i've done wrong, can someone help thanks!
Did you refresh the phrase cache by editing a phrase through admincp? That's the only thing I can really think of.

I really should have put a call to build_language in the installer, but I didn't know about it at the time.

[Nickeh32]

Ok, thanks for that it works.
Nice mod it will help with my forum alot ;)

[boozehound]

I'm a begginer when it comes to vb, care explaining were that is?
Admincp -> language & phrases -> phrase manager.
Edit any phrase, and save it without changing anything.

[Nickeh32]

I have a question, i've put postreport.php in the usercp but when i open it it deosn't have the usercp links at the side, i was wondering if someone could help, thanks!

[boozehound]

I have a question, i've put postreport.php in the usercp but when i open it it deosn't have the usercp links at the side, i was wondering if someone could help, thanks!
To do that you could change the postreports template to:


$pagenav

<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">

<thead>
<tr>
<td class="tcat" colspan="9">
$vbphrase[postreports_yourpostreports]
</td>
</tr>
</thead>

<tbody>

<tr>
<td class="thead">$vbphrase[postreports_postnumber]</td>
<td class="thead">$vbphrase[postreports_postedby]</td>
<td class="thead">$vbphrase[postreports_onthread]</td>
<td class="thead">$vbphrase[postreports_yourcomment]</td>
<td class="thead">$vbphrase[postreports_timestamp]</td>
<td class="thead">$vbphrase[postreports_status]</td>
<td class="thead">$vbphrase[postreports_moderator]</td>
<td class="thead">$vbphrase[postreports_comment]</td>
<td class="thead">$vbphrase[postreports_updated]</td>
</tr>
$postreportbits
<tr>
<td colspan="9" class="tfoot">&nbsp;
</td>
</tr>
</tbody>
</table>

Then in postreports.php change

eval('print_output("' . fetch_template('postreports') . '");');
eval('$footer = "' . fetch_template('footer') . '";');
echo $footer;

to

eval('$HTML = "' . fetch_template('postreports') . '";');
eval('print_output("' . fetch_template('USERCP_SHELL') . '");');

[Nickeh32]

Wow, thankyou.

You made my day, thanks!

Another problem (i know i fuss, but it's needed :p)

The user cp link in reportpost.php have no class for the td their in, their just white!

[trackpads]

For some reason the reports are not making it into the database. I dont have prefix's and I am using your report.php from the post above since I use Erwins hack aswell. His is still functioning but the reportpost table is empty.

Any ideas?

Thanks!

-Jason

[trackpads]

Ok, never mind :) :) figured it out!

[trackpads]

Ok, drats. Got most of it working. The only problem is that when a user goes to their postreports.php it is just the headers, no reports that they submitted.

Any ideas?

Thanks again,

-Jason

[trackpads]

Ah ok, spelled the bits template wrong... dorh.... :)

[Moncal]

Good job pig. I think I will install this some time soon, just for the fun of it considering that no one on my forum ever reports posts.

[Diana Notacat]

Thank you very much! This is going to be a beautiful addition for my mods! <3

[HabboForum]

Will this be converted so it is compatible with vBulletin 3.5?

Thanks.

[Ghanem]

Hi,

Thank you for the wounderfull job
there is a small problem..

All the modeaters and admins view all the reports and can update and change the status of the report.
In other words, the moderator should view only the rports that belongs to his forum..

Regards.

[Ghanem]

up :disappointed:

[Ghanem]

Another up but with request..

Each time I have to log to CP to chk if there is any report..
Could you do somthing to show number of reports say in the welcome panel under the private message numbers.
Ex:

Welcome, unicorn.
You last visited: Today at 01:25
Private Messages: 0 Unread, Total 2
Post Reports : 2 new, 3 pinding

Regards,
Ghanem.

[King Kovifor]

This would be useful... Going to bring it up to the "master"

[boozehound]

All the modeaters and admins view all the reports and can update and change the status of the report.
In other words, the moderator should view only the rports that belongs to his forum..


I'm doing a new version (as well as converting for 3.5). You will be able to select one of three modes, in the admincp settings:

1) All moderators can see and edit all reports
2) All moderators can see all reports, but can only edit reports in their forums
3) Moderators can only see and edit reports in their forums


Each time I have to log to CP to chk if there is any report..
Could you do somthing to show number of reports say in the welcome panel under the private message numbers.
Ex:

Welcome, unicorn.
You last visited: Today at 01:25
Private Messages: 0 Unread, Total 2
Post Reports : 2 new, 3 pinding
Next version.

If you want to add it now, you can do this (but it only shows open reports not pending, but you could easily modify that). This is a bit hacky, but it works and it's been used on a site I admin for months:

In global.php find:

$vbphrase['total_x_nav_compiled'] = construct_phrase($vbphrase['total_x_nav'], $bbuserinfo['pmtotal']);

Add below that:

$reportcount = 0;
if(can_moderate())
{
$reports = $DB_site->query_first("
SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "postreport AS pr
WHERE pr.status = 0
");
$reportcount = intval($reports['count']);
}

Then you just need to do something with $reportcount in the navbar template. I did the following:

In navbar template, find:

<if condition="$show['pmstats']"><br /><phrase 1="$vbphrase[unread_x_nav_compiled]" 2="$vbphrase[total_x_nav_compiled]" 3="$session[sessionurl]">$vbphrase[private_messages_nav]</phrase></if>

Add below that:

<if condition="can_moderate()">
<if condition="$reportcount == 1">
<a href="modcp/postreports.php?do=list"><br/><strong>1 post report</strong></a>
</if>
<if condition="$reportcount > 1">
<a href="modcp/postreports.php?do=list"><br/><strong>$reportcount post reports</strong></a>
</if>
</if>

[Ghanem]

Next version.
If you want to add it now, you can do this (but it only shows open reports not pending, but you could easily modify that). This is a bit hacky, but it works and it's been used on a site I admin for months:Tested working perfect on V3.0.7

Thanks a million, very nice neat jop.

Kindest Regards.

[Jinovich]

Is there any way that I can substitute the Modification for the standard VB email for certain usergroups?

Basically, we have the hack installed and the Moderators can use it, however our forum Vip's get their own subforum which they moderate but I would rather them being sent the standard Vbulletin email rather then them using the Modcp?

Also when is the new version coming out it sounds great!

[boozehound]

If anyone is interested, in my development version I have replaced, in report.php

$mods = array();

while ($moderator = $DB_site->fetch_array($moderators))
{
$mods[] = $moderator;
}

with

$mods = array();

while ($moderator = $DB_site->fetch_array($moderators))
{
if(can_moderate($foruminfo['forumid'], null, $moderator['userid']))
{
$mods[] = $moderator;
}
}

which means moderators are only sent emails from reports in the fora they moderate, if you have emailing switching on. Otherwise, all moderators get the emails.

Is there any way that I can substitute the Modification for the standard VB email for certain usergroups?

Basically, we have the hack installed and the Moderators can use it, however our forum Vip's get their own subforum which they moderate but I would rather them being sent the standard Vbulletin email rather then them using the Modcp?

I'm not sure if you mean 'for certain usergroups' or 'for certain forums'. Do you want reports forums like this 'VIP' forum to be 'email-only' and not go into modcp at all, or something else?

Also when is the new version coming out it sounds great!
Probably a week or so for a new version for 3.0.x, and a bit longer for 3.5 since I haven't really looked at that yet.

[Jinovich]

I'm not sure if you mean 'for certain usergroups' or 'for certain forums'. Do you want reports forums like this 'VIP' forum to be 'email-only' and not go into modcp at all, or something else?

Well if it can be made so that certain forum reports wont be sent to the MODCP but instead be sent via email to the moderator of that forum that would work just as well.

[MThornback]

I'm getting this error in the AdminCP Installer...help :speechless:

Database error in vBulletin 3.0.7:

Invalid SQL:
CREATE TABLE vb3_postreport (reportid INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
postid INTEGER NOT NULL, userid INTEGER NOT NULL, reporttext MEDIUMTEXT, status INTEGER,
modid INTEGER, dateline INTEGER, updatetime INTEGER, modtext MEDIUMTEXT);

mysql error: Table 'vb3_postreport' already exists

mysql error number: 1050

[Marco van Herwaarden]

Looks like you tried to run the installer twice.

[MThornback]

So if I drop the table I should have no problems then?

Edit:

OK...I dropped the table...and have a new error:

Database error in vBulletin 3.0.7:

Invalid SQL:
INSERT INTO vb3_phrasetype (phrasetypeid, fieldname, title, editrows) VALUES (183, 'postreports', 'Post Reports', 3);

mysql error: Duplicate entry '183' for key 1

mysql error number: 1062

[boozehound]

So if I drop the table I should have no problems then?

Edit:

OK...I dropped the table...and have a new error:

Database error in vBulletin 3.0.7:

Invalid SQL:
INSERT INTO vb3_phrasetype (phrasetypeid, fieldname, title, editrows) VALUES (183, 'postreports', 'Post Reports', 3);

mysql error: Duplicate entry '183' for key 1

mysql error number: 1062
If you've already got the phrases and settings added, but have dropped the table, just recreate the table. The SQL for that is in your previous post.

[question?]

When can we see this for 3.5 as a plugin or extension??

[Bakie]

Here is a really noobish question (I am new to vB) but how do I install the templates?

It says here:
3) Add the templates found in the templates folder.

postreports.txt -> postreports
postreportbits.txt -> postreportbits

How do I do this? I think that I know where but I just dont know how, it it under Style Manager -> Edit templte -> Postbit Templates and after here I am lost...

can anyone help?

[boozehound]

Here is a really noobish question (I am new to vB) but how do I install the templates?

It says here:
3) Add the templates found in the templates folder.

postreports.txt -> postreports
postreportbits.txt -> postreportbits

How do I do this? I think that I know where but I just dont know how, it it under Style Manager -> Edit templte -> Postbit Templates and after here I am lost...

can anyone help?
In the main 'style manager' page, where each style is listed, there is a dropdown next to each style. In that dropdown is an option called 'add new template'. Use that.

[Ghanem]

Hi..

Not yet for 3.5 :rolleyes:

[Delphiprogrammi]

hi people,

i like this hack and i modified this hack so it would work with vbulletin 3.5x so far so good.The MySQL stuff is done the "look" from the hack is there and so far it's working just getting a few syntax error but i will try to sort it out

here's a little "preview"

ignore that empty empty fields it's just an INSERT query i did to testto see if it's working

[Ghanem]

hi people,
God bless you
I was waiting for it

[Delphiprogrammi]

hi,

Just cleared out some dirty MySQL errors.There is still a problem with the script in the modcp for some reason it says it can't find the phrases used but they are there.I'm guessing it's because the 3.xx script uses some old vb function not supported in 3.5.x anymore when i got the time i will check the api docs at members.vbulletin.com.

A thing new to this hack is an automated uninstaller.Just hit the unintall button and all database modifications used are deleted (you get no warnings so think twice before hitting delete)

the problem with script in the modcp is solved.No unsupported functions but for some reason jelsoft moved the control panel stop message phrases to the error messages phraseid group

two thing to test out the cron script and the report.php modification after that ..... done (well as a beta to testdrive)

update

report.php modification done seems to be ok (no error messages or MySQL errors) but some things aren't set as they should be like for example the timestamp... i'm checking this.Also finische the cron script no problems with that

[Delphiprogrammi]

hi,
Well i don't get it where the hell is my dateline ?????? it's in the database show ......


$db->query_first("INSERT INTO " . TABLE_PREFIX . "postreport(postid,userid,reporttext,status,datelin e)VALUES($postid,$userid,'" .addslashes(htmlspecialchars_uni($reason)) . "',0," . TIMENOW . ")");


ok need a break now :speechless:

problem with timestamps solved all is working except for the thing "user comment" for some reason i didn't found yet that is staying empty


$db->query_first("INSERT INTO " . TABLE_PREFIX . "postreport(postid,userid,reporttext,status,datelin e)VALUES($postid,$userid,'" .addslashes(htmlspecialchars_uni($reason)) . "',0," . TIMENOW . ")");


htmlspecialchars_uni is still supported according to http://members.vbulletin.com/api so why on earth is that staying empty ??

[Delphiprogrammi]

hi,

Problem solved the user comment filed is properly filled in now


$reason =& $vbulletin->GPC['reason'];


but while testing i found another problem.If you have that redirection messages enabled you're redirected to an empty white page after you've submitted a report.Again i'm looking into this stay tuned ;)

[Ghanem]

stay tuned ;)waiting :)

[Delphiprogrammi]

hi,

redirection trouble solved to.I'm gonna put it on my live site and let it run for a while if now new problems show up .... i can share it with others

[Ghanem]

congratulation :)
shouldn't you post it now in vb35x forum :cheeky:

[Delphiprogrammi]

congratulation :)
shouldn't you post it now in vb35x forum :cheeky:

Yeah release will be in vb3.5.x code modifications.But i'm doing some more tests.You don't want a thing that crashes your database or server do you ? :rolleyes: i'm also playing with an idea to put the thread from the reported post(s) into the moderation que but that could cause a security issue.I don't know about you but let's say for example your forum is hit by spammers url don't you wanna take action as fast you possibly can ? putting such threads into the moderation que would make them invisible (except for moderators and admins offcource) and the spammers won't get hits from your forums but like i said that could cause abuse

[Ghanem]

Yeah release will be in vb3.5.x code...I meant discussing it there will bring the 3.5.x coders and users while here the interested will be only 3.0.x :)

[Delphiprogrammi]

hi,

Everything is ready for release but i need to wait for the original author permission before that i'm not allowed to release anything yeah the rules of the opensource playground

[Ghanem]

but i need to wait for the original author permissionhope he is still arround :up:

[Delphiprogrammi]

i was bored.... and i ported this to the vb plugin system so no file modifications are needed.The only thing that refuses to work is to also email when the custom reporting system is active.But i can't take accept a non working function i will find what's wrong .... the good news is the the product xml installs and uninstalls fine ....

[Ghanem]

the good news is that the product xml installs and uninstalls fine ....cool :up:

[boozehound]

Here is a beta of this hack ported to 3.5.x. It should function similarly to the 3.0.x hack, with a couple of exceptions listed below. I have not included instructions on how to add a link to the user post report page (for example in the quick links menu). The installer does however add the links to the modcp index/navigation page.

Install from the product manager in admincp. If you already have the database table the 3.0.x version added (postreport) the installer will cope and the product will use the existing data. If you uninstall, the postreport table will be dropped.

The beta does not feature the options page that the 3.0.x version did - if you install it, it is 'on' and there is no option to optionally email the moderators as in the previous version - the email is sent always.

The product adds two hooks: one in report_send_process and the other in mod_index_navigation; two templates 'postreports' and 'postreportbits'; several phrases and a phrase group. Two files need to be uploaded: postreports.php in the forum root directory and a different postreports.php to the modcp directory.

Issues: some of the phrases in the modcp page do not work. They will be included in the final version.

I have posted this here because I can't see a beta section in the 3.5 forum, and the people reading this are the people most likely to want to beta test this.

[boozehound]

3.5 port: https://vborg.vbsupport.ru/showthread.php?t=105165

[parash]

is this hack coming for 3.7 version