Alternate Reporting for 'Report Post to Moderators'

[the3jams]

This hack makes it so that when a member reports a post to a moderator it is generated on a page in the ModCP instead of sending an email. All mods can view this page and once the post is dealt with the entry can be removed.

I have been using this on my forum for about 6 months and my mods love it. I've had some requests for it so I thought I would share it with everyone.

[the3jams]

screen shot

[sphinx]

nice one installing m8 ;)

[Sho]

Awesome idea. Thanks for sharing. https://vborg.vbsupport.ru/external/2011/01/19.gif

[Sam FT]

There is an error in your proreport.php file....

MYSQL

Warning: Division by zero in ...... /proreport.php on line 41

Looks like you have to have at least one report for it to work....

[the3jams]

Looks like you have to have at least one report for it to work....
Sorry about that. The zip file has now been updated to fix this. Just re-upload the probreport.php and you should be all set.

[Sam FT]

Works greats the3jams no problems at all. Yeah says I wanted to have this feature added to my admin control panel. All I would have to do is copy the proreport.php file to the admin folder and add the mod/index.php code to my admin/index.php?

[the3jams]

Yes, it will work the same if you do that.


If you wish to do like Music Pirate has mentioned here is the step.

find in admin/index.php:makenavselect("Announcements");
// ***add below:makenavoption("View Reported Posts","probreport.php?action=view_reports");
makenavselect("Additions");
// ***Then upload the probreport.php to the admin dir.

[sleepbirdcyp]

when i click "View Reported Posts"
it say:

Invalid SQL:
SELECT probid, username, userid, thread, threadid, forum, date, postid, reason
FROM probreport
ORDER BY probid
LIMIT 0,
mysql database error: You have an error in your SQL syntax near '' at line 5

mysql database error: 1064


any help?

[Dean C]

Excellent idea - however does it still send an email too?
- miSt

[the3jams]

@ sleepbirdcyp - Did you run the SQL queries?

@ Mist - My directions disable the email. If you want the email to still be sent you can skip the first two changes in report.php. The first two changes are just commenting out the code that sends the email.

[irn-bru]

wont use it myself..but nice idea jams :)

[sleepbirdcyp]

Today at 06:44 AM the3jams said this in Post #11 (https://vborg.vbsupport.ru/showthread.php?postid=411647#post411647)
@ sleepbirdcyp - Did you run the SQL queries?

@ Mist - My directions disable the email. If you want the email to still be sent you can skip the first two changes in report.php. The first two changes are just commenting out the code that sends the email.



yes

already run

CREATE TABLE probreport (
probid int(10) unsigned NOT NULL DEFAULT '0' auto_increment,
username varchar(30) NOT NULL,
userid int(10) NOT NULL DEFAULT '0',
thread varchar(50) NOT NULL,
threadid int(10) NOT NULL DEFAULT '0',
forum varchar(50) NOT NULL,
date varchar(20) NOT NULL DEFAULT '0',
reason varchar(250) NOT NULL DEFAULT 'No Comment',
postid int(10) NOT NULL DEFAULT '0',
PRIMARY KEY(probid)
);

[the3jams]

Try re-uploading the probreport.php from the zip file above. Make sure it overwrites the old one and also that it is uploaded in ASCII mode.

[cnczone]

I get this error-




Invalid query id specified
mysql error:

mysql error number: 0

Date: Monday 23rd of June 2003 03:36:30 PM
Script: http://www.cnczone.com/report.php
Referer: http://www.cnczone.com/report.php?s=&postid=6516

[the3jams]

Did you run the sql query to create the table?

[Floris]

Sweeeet hack !
Installed it on a few sites :)

[Oblivion Knight]

Awesome alternative to sending e-mails to report problematic posts..! :)

Installed at Umbrella Online and things are running flawlessly.

[Paul]

Lacking one small thing: The page in the modcp should display the text of the actual post itself (or at least the first X characters of it).

One click viewing and deleting would be very nice. :) Good idea though.

[mossyuk]

super duper :) nice one, will be installing this one.

[mossyuk]

installed :)

[TechGuy]

Does this (or could it) keep a log of "completed" reports so that other moderators can see see who dealt with what? If it kept a log of each report and who marked it completed, it would be perfect. :)