vB Report Manager 2.0 (Admin CP) - Report to Email, PM, Staff Forum as a new Thread!

[Erwin]

vB Report Manager 2.1 (Admin CP) - Report to Email, PM, Staff Forum as a new Thread!

By Dr Erwin Loh

What does this hack do?

When a member reports a post, the report goes to:

1) Email (as per normal)
2) PM
3) A new thread in your private Staff Forums
4) In the report, there will be a link to the new thread in your private Staff Forums

Or ANY of the above combination!

The thread title now has the Date/ Time of Report, Originating Forum and Reported Poster!

There is now Admin CP support under vBulletin Options - you can choose to switch on or off any of the notification methods, and set the FORUM ID for the Staff Forum you want the posts to appear in.

All you need to do is run install_vbreport.php and modify 1 file - report.php.

Update Version 2.0

1. Added Admin CP support - choose to switch on and off each notification method. Also specify your Staff Forum ID in Admin CP.

2. Added more info to the THREAD TITLE - now with NAME OF FORUM, USERNAME OF POSTER, AND DATE/ TIME OF REPORT!

Update Version 2.1

1. Fixed email option bug

2. Fixed URL parsing bug

To upgrade, it's easiest just to reinstall this hack over a CLEAN REPORT.PHP file.

Admin CP installer and install instructions in HTML file in ZIP below.
Screenshots attached. :)

Enjoy!

[deathemperor]

nice one ! once more hack will be installed :D

[Morgalis]

i'd REALLY love to get this feature back on our super busy board

can i ask though, is it possible to have the option to post in one thread rather than a new thread each report as the vb2.x hack did? it is so well used on our site, that 10 reports a day is the minimum and i don't want my staff forums cluttered

thanks so much in advance

[tomshawk]

I'm getting this error


Invalid SQL: INSERT INTO pm (pmtextid, userid, messageread) VALUES (31, , 0)
mysql error: 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 ' 0)' at line 1
mysql error number: 1064

Date: Monday 05th of January 2004 12:07:37 AM
Script: http://www.tomshawk.com/forums/report.php
Referer: http://www.tomshawk.com/forums/report.php?p=39

Any ideas?

VB3 RC1

[Erwin]

Did you do step (b) properly? The userid is not being sent.

I've been running this hack for almost a year now. :) Since vB2. It's worked with no problems since.

[Erwin]

Please be aware, sometimes the code is replaced, sometimes new code is added below, or ABOVE. PLEASE READ THE INSTRUCTIONS PROPERLY. :)

[MindTrix]

Nice addition Erwin :) Glad to see more hacks comming from you again :) Thanks.!

[tomshawk]

Please be aware, sometimes the code is replaced, sometimes new code is added below, or ABOVE. PLEASE READ THE INSTRUCTIONS PROPERLY. :)Yes, and just for good measure, I re-did the whole thing again, same problem.


BTW, It does create the post in the forum, but does not send the email and gives this error

[Vile]

Very cool hack. I'll give this a shot :)

[Erwin]

Yes, and just for good measure, I re-did the whole thing again, same problem.


BTW, It does create the post in the forum, but does not send the email and gives this error

Mmm... I rechecked my code - it's the same as what I've got. You've got RC1 right? Mmm... I don't understand.

[tomshawk]

Mmm... I rechecked my code - it's the same as what I've got. You've got RC1 right? Mmm... I don't understand.
Yes, It is RC1

Dunno, It's wierd

[tomshawk]

Mmm... I rechecked my code - it's the same as what I've got. You've got RC1 right? Mmm... I don't understand.OK, I got it working

but...

If you report a post in a forum that has a Moderator, it works fine

If you report a post in a forum that does not have a moderator, this is when you get the error.

Though it says in the email


This message has been sent to all moderators of this forum, or all administrators if there are no moderators.

Please respond to this post as applicable.
Is there a way to fix this

It also puts bogus info in the new thread

Mainly the stuff in the quotes below

Who is upgrading
http://www.tomshawk.com/forums/show...tid=228#post228 (http://www.tomshawk.com/forums/showthread.php?postid=228#post228)

This is part of this thread:
Who is upgrading
http://www.tomshawk.com/forums/t83 (http://www.tomshawk.com/forums/t83)
This is the reason that the user gave:
Testing new report system

This message has been sent to all moderators of this forum, or all administrators if there are no moderators.

Please respond to this post as applicable.

The Report Thread in the Staff Forum is here:
http://www.tomshawk.com/forums/t106 (http://www.tomshawk.com/forums/t106)

[Erwin]

[post not relevant anymore]

[Erwin]

That email is just what vB3 normally says. :) You can change it if you want.

[Chris Gwynne]

Great hack, Erwin! :)

[shorty]

Pah.. I made my own version of this last week and was gonna release it :(

Oh well.. Il have to think of something else ;)

[tomshawk]

Thanks Erwin, It is a kewl hack, Clicks install

[tomshawk]

http://www.tomshawk.com/forums/t83

http://www.tomshawk.com/forums/t106

I figured out what these are

The first is a link to the thread where the bad post is.
the second is a link to the new thread in the Mods forum

But, they are missing the ? and the =

They should read


http://www.tomshawk.com/forums/?t=83

http://www.tomshawk.com/forums/?t=106

Does anybody know where to fix this, or at least where to look?

Is it in the report.php or in a template?

Any help would be great!

[Erwin]

I figured out what these are

The first is a link to the thread where the bad post is.
the second is a link to the new thread in the Mods forum

But, they are missing the ? and the =

They should read


Does anybody know where to fix this, or at least where to look?

Is it in the report.php or in a template?

Any help would be great!
First post updated to Version 1.1.

Sorry!!! Those are my private forums special URLs! This is what happens when I release hacks from my site.

Okay, I've updated the FIRST POST.

To fix the URLs, just COPY AND PASTE the new phrase (ie. repeat the last step).

Sorry again. It should work fine now.

[tomshawk]

Works perfectly now

Thank you very much for your work on this

I look forward to seeing more great hacks from you ;)

[MGM]

great hack! glad I waited before downloading this one ;)

but I don't have mods on all my forums, so idk if ill install it just yet..... perhaps ill wait for that update you "might" do ;)

* MGM clicks Install for the hell of it

MGM out

[tomshawk]

great hack! glad I waited before downloading this one ;)

but I don't have mods on all my forums, so idk if ill install it just yet..... perhaps ill wait for that update you "might" do ;)

* MetalGearMaster clicks Install for the hell of it


MGM out
Hey MetalGearMaster, to get around that, I made a Supermod the mod of all the Catagories

This would work for an Admin or a regular mod as well, Just make them the mod of the Catagory, then bingo, works like a champ

;)

[Michael2]

I installed it. It was a pain in the ass having to go through and add a bogus mod to each forum but I appreciate the work you did on it.

[MGM]

In the first post it says that the admin will be PMed if no mod exists.... does that even work?

MGM out

[Erwin]

In the first post it says that the admin will be PMed if no mod exists.... does that even work?

MGM out
That's just the default message in vB3. :)

[MGM]

ahhhh...... i knew that :D

lol, smods modding all of my forums would work..... or maybe my newly created Pmods :D

MGM out

[wrongful]

Could someone tell me what to take out to stop the reported post from being emailed and PMed to me? At least the PMs because I find this kind of redundant.

Ok nevermind I figured out what step to take out.

[carloshax]

w00t another great hack clicks install again \o/

Carl

[M1th]

Hmm, 'Search Index' isnt getting updated after new thread/post now, is it? It would be a good idea to add the funtion. :)


require_once('./includes/functions_databuild.php');
build_post_index($post['postid'], $foruminfo, 1, 0);


is the above code correct?

[shad-gt]

Since I do have moderators for every forum, I am not going to modify this hack. It does work.

Ensure a MODERATOR is assigned to every forum.

Presumably you can add moderators to parent forums, so that this hack works. If I find time I may fix this, but not at the moment. :)


here a fix for your hack. With it all works correct with no moderators set on a forum....

replace:


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;
}
}


with:


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;
}
}


, user.userid is new.


greets,
shAd

[Erwin]

Update Version 1.2

Thanks to shad-gt - no need to add moderators to every forum - if there is no moderator, the PM will go to an administrator.

The new step is step (d) in the install file, and the code is all in black.

Otherwise, just follow shad-gt's instructions in the post above this one. :)

[M1th]

Update Version 1.2

Thanks to shad-gt - no need to add moderators to every forum - if there is no moderator, the PM will go to an administrator.

The new step is step (d) in the install file, and the code is all in black.

Otherwise, just follow shad-gt's instructions in the post above this one. :) sorry to be so picky but you've missed the "add newpost_usernamecode to $globaltemplates" step.:)

[Erwin]

sorry to be so picky but you've missed the "add newpost_usernamecode to $globaltemplates" step.:)
Sorry? If a template is missing that would be a vB3 bug. :) My hack requires no additional templates.

[M1th]

Sorry? If a template is missing that would be a vB3 bug. :) My hack requires no additional templates.
My bad.. I didnt realise the uncached template before installing your hack. :)

[Aaron1]

This hack sounds wonderfull, but is there also a vb2.* version of this hack somewhere Erwin?
I searched here but no luck :(

[Aaron1]

I found it! Sorry ignore my previous post, thanks!

https://vborg.vbsupport.ru/showthread.php?t=48815&highlight=report+thread

[heynurse]

Congrats on another fine Hack Erwin!

I have a couple questions/modification request to anyone.

1. Is there a way to have the contents of the reported post that is being reported to be included in the staff forum thread that is created?

2. Is it possible to have the username that is being reported to be included in the title of the thread created in the staff forum?

Thanks

[Christine]

Nice hack! *installs*

I am the only person assigned to our comments forum, so I sent a test "report post to mod" from there, yet all admins and mods on the team received the PM, not just me.

Any thoughts on that?

[gmarik]

This, I'm sure, should be in the Gold by default, nice.

[M1th]

I've had a look at the database and it seems that the column 'touserarray' is left empty (ie 'N;') in the database (table pmtext) for a reported post pm. The $tostring var has to return something, but its not, am i correct?

[Princeton]

great idea - great hack! :banana::banana:

[heynurse]

Congrats on another fine Hack Erwin!

I have a couple questions/modification request to anyone.

1. Is there a way to have the contents of the reported post that is being reported to be included in the staff forum thread that is created?

2. Is it possible to have the username that is being reported to be included in the title of the thread created in the staff forum?

Thanks

Does anyone have any ideas how I can get the contents of the reported post to be inserted in the newly created thread?

[Detomah]

I've been waiting patiently for weeks for VB Gold to be released before installing this, what a great hack it is. :)

I can see this making response times for potential situations much much quicker. :)

[sabret00the]

fantastic hack went without a hitch :D

[Loyalty4Life]

Funny story. Please bear with me. :)

Well, I make all the necessary changes in Erwin's HTML document. I go to report a post on my site, and nothing happens. Well, I go to try to report a post again, and nothing happens... Then it occured to me. I never uploaded the file back to my directory! :p So I upload it, report a post, and nothing happens. Now I'm getting a bit worried. I really wanted to use this hack! It looks great.

Then it hit me, like a brick from the sky. I forgot to save my changed php file. :D I never pressed the save button!

Needless to say, I got a good, hearty laugh at the end!

* Loyalty4Life clicks install. :)

[Zoints]

Is it possible to disable all reporting means EXCEPT for the new thread in a staff forum? I only want the report to go to my staff forum, not to PM or e-mail.

Thank you kindly.

[Marulatree]

Does this work with gold and if so can someone update the instructions....

Erwin, Would it be possible so add a /switch so we could choose wether (from a admin side) we want the message to goto either PM/THREAD/EMAIL or all?

[ragintajin]

Is it possible to disable all reporting means EXCEPT for the new thread in a staff forum? I only want the report to go to my staff forum, not to PM or e-mail.

Thank you kindly.
I'm interested in this too...

[Erwin]

Is it possible to disable all reporting means EXCEPT for the new thread in a staff forum? I only want the report to go to my staff forum, not to PM or e-mail.

Thank you kindly.
That's not too hard to do. I just need time to add instructions.

[Michael2]

Does this work with gold and if so can someone update the instructions....

Erwin, Would it be possible so add a /switch so we could choose wether (from a admin side) we want the message to goto either PM/THREAD/EMAIL or all?

I just installed it on the gold version and it's working fine.

[Zoints]

That's not too hard to do. I just need time to add instructions.

I understand what it's like to be incredibly busy :) I look forward to it when you find time. Thank you!

[Reeve of shinra]

To just have the new thread only just follow steps 1A and 1D and ignore the rest of the report.php file edits

[ragintajin]

To just have the new thread only just follow steps 1A and 1D and ignore the rest of the report.php file edits
I tried that but the report post still sends an email to the moderators. Anyone else have luck?

[xlguy]

Is it possible to disable all reporting means EXCEPT for the new thread in a staff forum? I only want the report to go to my staff forum, not to PM or e-mail.

Thank you kindly.
Yes this would be great... on my vB2.x forums I use another hack that just creates a 'ticket' (i.e. a thread) containing the post that has been reported, its contents and a link to take you directly there. I'm not sure if this hack does all of this, but even a thread in a staff forum (without the PM and e-mail) would be great.

[chrisvonc]

I too would like to raise my hand for interest in only having it create the new thread in my moderator forum. That would definatly be sweet for my use.
:)

[Watson]

works a treat, cheers

[ragintajin]

I too would like to raise my hand for interest in only having it create the new thread in my moderator forum. That would definatly be sweet for my use.
:)just a friendly bump...

[Erwin]

This is a hack that I would like to update soon - just need to find the time. :)

[zetetic]

Is it safe to assume that 10 people reporting a post is going to create 10 separate threads, and if so is there some way around that? :)

[y2krazy]

/me clicks install!

[heynurse]

This is a great hack! I would like to have the username of the author of the reported thread be put into the title of the thread that is created in the reported forum.


For example: someone reports a user by the name of joeblow

The new thread that is created in the reported post forum is titled some thing like:
Reported Post: joeblow in XXXX forum

Does anyone know how I can do this? Thanks in advance.

[venomx]

Does this work with VB3.0.3?

[ethics]

Any updates on this, Erwin?

[Lionel]

Erwin, looking at your code, what are the chances that you do a quick and dirty for us?

Automatically create a new thread in a set forum at registration? The new member could have a text area in the registration form, giving him the option to input his own words, if empty the the generic welcome will be posted.

[Erwin]

Erwin, looking at your code, what are the chances that you do a quick and dirty for us?

Automatically create a new thread in a set forum at registration? The new member could have a text area in the registration form, giving him the option to input his own words, if empty the the generic welcome will be posted.
That's a different hack altogether - not hard to do at all... maybe when I find time.

[Lionel]

Thanks for considering. I'll be patiently waiting. That is basically the only thing missing by me. Right now, we are creating the thread manually - the hard way-

[SaN-DeeP]

* SaN-DeeP clicks install.
Thanks for the nice work :)

Regards,

[marcel-ea]

running in vb3.0.3

thx

[bluecat]

Thanks for the mod!

I'm trying to NOT have it send a new PM and Email everytime someone reports and tried skipping step 1b. and 1c. but got errors. Can anyone tell me exactly what to change to do this (so pm's at least are not sent, but preferably both).

Thank you :)

[sully02]

Thanks for the mod!

I'm trying to NOT have it send a new PM and Email everytime someone reports and tried skipping step 1b. and 1c. but got errors. Can anyone tell me exactly what to change to do this (so pm's at least are not sent, but preferably both).

Thank you :)
I would also like to find out how to remove the sending of private messages.

[Erwin]

I really need to find time to do this. :) I've been busy with moving my forums 3 times to larger and larger networks. I should have some time soon.

[sully02]

I really need to find time to do this. :) I've been busy with moving my forums 3 times to larger and larger networks. I should have some time soon.
I know how that goes. Am I correct in assuming it is just cutting out a couple snippets of code?

[bluecat]

I know how that goes. Am I correct in assuming it is just cutting out a couple snippets of code?

That's probably a safe bet, I just can't figure out which :(

[ctown]

I tried installing this but got this error message:
Parse error: parse error, unexpected T_VARIABLE in /home/balt/public_html/talk/report.php on line 122

Line 122 is this:
$moderators = $DB_site->query("

Any suggestions?

[The Markus]

This is the first hack I am going to make. Im sorta lost :nervous:

In the hack it says to:

3. Look for the phrase variable "reportbadpost" under "Email Body Text Phrases".

I cannot find Email Body Text phrases. Where is that?

[peterska2]

This is the first hack I am going to make. Im sorta lost :nervous:

In the hack it says to:



I cannot find Email Body Text phrases. Where is that?
Go into Phrase Manager > Search in phrases

Search for reportbadpost as the variable name. Check it is in the group Email Body phrases by looking at the headings above each phrase that your search returns.

Click Edit :)

[turkforum]

is thre a way that we can diable the email but you only PM instead

[Mr_Bob]

You have a nice hack here, it will be VERY useful. I am having a bit of a ..pathetic, problem though. When I upload the newly coded report.php file I get this error when reporting:
Parse error: parse error, unexpected ';' in /home/virtual/site36/fst/var/www/html/forum/report.php on line 146

I chekced all the code around that area and it looks just fine. This is a snipet of your code as it looks in my file

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


Sorry there is no REAL way for me to show you exactly how it looks (not a big enough edit box). But the parsings should be in the right place. Do you have any suggestions? I am not very good at PHP :) so I know this may be an obvious fix for some.

[charlesk]

Just wondering.. is this hack safe to install in vB 3.0.3? Thanks. :)

Charles

[The Markus]

Go into Phrase Manager > Search in phrases

Search for reportbadpost as the variable name. Check it is in the group Email Body phrases by looking at the headings above each phrase that your search returns.

Click Edit :)
One hack successfully installed thanks to you!

[pokesph]

ok hmmm did this hack in 3.0.3,, seems to have gone in fine EXCEPT one little thing.. now the report post icon / link is gone.... any ideas??

linkage: http://pokecommunity.com/showthread.php?goto=newpost&t=23623

edit: Nevermind.. seems I can't report my own posts, lol

*clicks install*

[WoodiE]

I too would be interested in this ONLY creating the thread, and NOT sending out a PM or email!

-Michael

[WoodiE]

Has anyone been able to make this ONLY create a thread in a certain forum?

-Michael

[Erwin]

Has anyone been able to make this ONLY create a thread in a certain forum?


-Michael
I promise I will post an update to this hack to do this. :)

[Erwin]

Update Version 2.0

1. Added Admin CP support - choose to switch on and off each notification method. Also specify your Staff Forum ID in Admin CP.

2. Added more info to the THREAD TITLE - now with NAME OF FORUM, USERNAME OF POSTER, AND DATE/ TIME OF REPORT!

To upgrade, it's easiest just to reinstall this hack over a CLEAN REPORT.PHP file.

Admin CP installer and install instructions in HTML file in ZIP in 1st post.

Screenshots attached. :)

Enjoy!

[WebMasterAJ]

Erwin - great hack! However, as soon as I installed this hack I get the error:

Parse error: parse error, unexpected $ in /home/fhco/public_html/boardvb2/report.php on line 246

Any ideas?

[Erwin]

Erwin - great hack! However, as soon as I installed this hack I get the error:

Parse error: parse error, unexpected $ in /home/fhco/public_html/boardvb2/report.php on line 246

Any ideas?
What's on line 246?

[rh2004]

Hi I got that error to on line 246


vbmail_end();

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

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

/*================================================= =====================*\
|| ################################################## ##################
|| # Downloaded: 10:20, Tue Nov 30th 2004
|| # CVS: $RCSfile: report.php,v $ - $Revision: 1.47 $
|| ################################################## ##################
\*================================================ ======================*/
?>


Line 246 is

?>

[WebMasterAJ]

Same thing here... error on line 246 is ?>

Wierd...

[Erwin]

Strange posting times... it's out of order...

[rh2004]

Hi I got a simular error when reporting posts: error to on line 247

Parse error: parse error, unexpected $ in /home/username/public_html/community/report.php on line 247


vbmail_end();

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

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

/*================================================= =====================*\
|| ################################################## ##################
|| # Downloaded: 10:20, Tue Nov 30th 2004
|| # CVS: $RCSfile: report.php,v $ - $Revision: 1.47 $
|| ################################################## ##################
\*================================================ ======================*/
?>


Line 246 is

?>


Sorry for the two the server was not being found

[Erwin]

I've changed the install instructions. It's because I cut and paste wrongly:

In the report.php file,

Change:
}// Erwin's Report Hack

To:

}
// Erwin's Report Hack

[rh2004]

Hi I went through it all again and still get the error


Parse error: parse error, unexpected $ in /home/username/public_html/community/report.php on line 249


I have included my report.php file, it has no mods I don't think except your
one, can you see what the problem is :ermm:


Many thanks

[Erwin]

Hi I went through it all again and still get the error


Parse error: parse error, unexpected $ in /home/username/public_html/community/report.php on line 249


I have included my report.php file, it has no mods I don't think except your
one, can you see what the problem is :ermm:


Many thanks
I see the problem.

This is what happens when you change your original install file... and the instructions have changed.

The last code change, instead of adding the code below, REPLACE the code.

So, step (e) should REPLACE the code, not add below.

Sorry about this - the install file has been edited. It should work now.

I've deleted the report.php file from your post anyway as that is against our rules. :) But it helped me identify the problem which was my instructions! :)

[Erwin]

I repeat, if you downloaded the old ZIP for version 2 and get an error, in step (e), you REPLACE the old code with new, you do NOT add below (which just creates a repeat of the code). :)

The ZIP has been updated.

[Moparx]

im still getting the error even with the latest update :\

[Erwin]

im still getting the error even with the latest update :\
Post your report.php and I'll take a look. I'll delete it after. It's weird that there's still an error.

[Moparx]

here you go

[Erwin]

I'm missing a closing tag it seems - must have missed it since I coded this off the top of my head.

Above the LAST:

// Erwin's Report Hack

Add another:

}

See if that fixes it.

[Moparx]

still nothing

[Erwin]

I'm missing a closing tag it seems - must have missed it since I coded this off the top of my head.

Above the LAST:

// Erwin's Report Hack

Add another:

}

See if that fixes it.
I'm an idiot.

Add 2 }

So above the LAST:

// Erwin's Report Hack

Add 2 closing tags:

}
}

In total there should be 3 closing tags above the comment.

See if that works. :)

[Moparx]

that fixed it.. :)

[Erwin]

that fixed it.. :)
Step (e) was the problem - I told you to find the wrong code, and do the wrong thing to it.

I've fixed the install.html file.

NOTE: If you installed the hack and get an error - what I would do is to start with a FRESH report.php file, and redo the code changes AGAIN.

This is because in step (e) I told you to find the wrong code - I have removed the vbmail function which should not be removed.

So if you downloaded the install.html file BEFORE this post, I suggest doing it again, and then reinstalling with a fresh REPORT.PHP file. No need to run the installer again though or do the phrase changes.

[Erwin]

I repeat, even if adding the 3 closing tags fixes your problem, your report.php may be missing 1 line that ends the vbmail function. :) So I suggest re-downloading the updated install.html and redoing just the code changes to a fresh report.php just to be safe. :)

[rh2004]

Hi it works but when you receive a PM its just blank...

The emails send ok, and the forum posts fine too :squareeyed: :nervous: :nervous:

[Erwin]

Hi it works but when you receive a PM its just blank...

The emails send ok, and the forum posts fine too :squareeyed: :nervous: :nervous:I see the problem - it happens when you switch OFF threads but turn ON PMs.

To fix this,

1.In report.php find:


eval(fetch_email_phrases('reportbadpost'));
$message = convert_url_to_bbcode($message);


CUT it out and MOVE it to ABOVE this:


if ($vboptions['vbreportthread'] == '1') {


2. Then find:


$today = vbdate('m-d-Y', TIMENOW, false, false);


Also, CUT it out and MOVE it to ABOVE this:


if ($vboptions['vbreportthread'] == '1') {


That will fix it. You will also get the DATE in the title of your PMs even if you switch Threads off.

I've updated the ZIP file.

[Erwin]

As far as I can tell, the current ZIP file has all the bug fixes. :) Sorry about the bugs - I added the new features quickly and didn't have time to test them out out extensively.

Things should work properly now.

[rh2004]

Thanks for all the help its working now :)

[The Markus]

As far as I can tell, the current ZIP file has all the bug fixes. :) Sorry about the bugs - I added the new features quickly and didn't have time to test them out out extensively.

Things should work properly now.
What does it mean, install it over a clean report.php?

I installed the one before you updated it, and am somehwhat of an amature at the moment.

[Erwin]

What does it mean, install it over a clean report.php?

I installed the one before you updated it, and am somehwhat of an amature at the moment.
Reinstall the hack into an unhacked report.php.

[W4arab]

Thanx a lot ..

i've a problem in PM's

when there is NO moderator the admin get the report >> That's OK

BUT when there is a moderator NO report in PM's at all! >> here the PROBLEM

[Erwin]

Thanx a lot ..

i've a problem in PM's

when there is NO moderator the admin get the report >> That's OK

BUT when there is a moderator NO report in PM's at all! >> here the PROBLEM
Well, that's odd. :) Mods of a forum WILL get a PM report if the PM option is chosen.

[W4arab]

Well, that's odd. :) Mods of a forum WILL get a PM report if the PM option is chosen.

OK,

Can you give us "report.php" after edited ?

note : delete Licence Number for security :o

[W4arab]

it's OK Now

thanx a lot :)

[mOdEtWo]

Erwin;

I wondered if you would be so kind to show me what to do when I want to use this hack without running the install_vbreport.php file. I don't want to add hacks that alters my database at all, in case I need official support later.

I had it working before I had to upgrade to vB 3.0.5, but you have now updated your original thread with the new system.

Thanks in advance, it's a great hack!

[mholtum]

Sweet, installed

[Erwin]

Erwin;

I wondered if you would be so kind to show me what to do when I want to use this hack without running the install_vbreport.php file. I don't want to add hacks that alters my database at all, in case I need official support later.

I had it working before I had to upgrade to vB 3.0.5, but you have now updated your original thread with the new system.

Thanks in advance, it's a great hack!
If you modify your report.php that would void official support anyway. :)

In any case, adding new option settings can be done through your Admin CP in debug mode, so it's not like it's doing anything that vB is not set out to do. If I have time I can give you code to bypass the options - it's quite simple.

[mOdEtWo]

If you modify your report.php that would void official support anyway. :)
True, but it is easier to just overwrite that file with a clean one, than unhacking the database. :p

If I have time I can give you code to bypass the options - it's quite simple.
That'd be great! :)

[kall]

* y2krazy clicks install!
Odd...for some reason it's all working fine, except the 'reported thread' that gets created in the Reported Post forum has no id at the end of the url (the very last part of the thread).

Ie: Please respond to this post as applicable.

The Report Thread in the Staff Forum is here:
http://forums.nzboards.com/showthread.php?t=

[Erwin]

Odd...for some reason it's all working fine, except the 'reported thread' that gets created in the Reported Post forum has no id at the end of the url (the very last part of the thread).

Ie: Please respond to this post as applicable.

The Report Thread in the Staff Forum is here:
http://forums.nzboards.com/showthread.php?t=
Bizarre - is this happening to anyone else?

[Mark.B]

Bizarre - is this happening to anyone else?
Yes, same thing here. And in the PM too.

[Erwin]

What's your Admin CP setting? As in, what is switched on or off? Does it happen if you switch everything to on? It could be the way I made the conditionals...

[Mark.B]

What's your Admin CP setting? As in, what is switched on or off? Does it happen if you switch everything to on? It could be the way I made the conditionals...
All three settings set to yes.....

It shows correctly in the email, just not in the PM or the thread.

Fantastic hack though Erwin.....thought I should add that. I couldn't manage reports without at least the PM option.

I should also add I am now on 3.0.6.

[geezzaa]

Geezzaa smaks down the install button .
My Pms arent working tho- any ideas im usung 3.0.3

[Erwin]

All three settings set to yes.....

It shows correctly in the email, just not in the PM or the thread.

Fantastic hack though Erwin.....thought I should add that. I couldn't manage reports without at least the PM option.

I should also add I am now on 3.0.6.
Bizarre - I'm going to have to look at the code again this weekend. Sorry about this.

[Erwin]

Update Version 2.1

1. Fixed email option bug

2. Fixed URL parsing bug

To upgrade, it's easiest just to reinstall this hack over a CLEAN REPORT.PHP file

[jribz]

Erwin, thanks for the great hack, extremely useful on my boards, I appreciate the work. :)

|| clicks install ||

[Starsurfer]

Hi there, I just downloaded this, however I cant find where to put the last bit of code, can someone please advise. Thanks. Its the bit about the variable reportbadpost

[Starsurfer]

i have looked over it, and I still have not found it, any help please?

[Erwin]

i have looked over it, and I still have not found it, any help please?
It's a phrase - search in your phrase manager in Admin CP.

[Starsurfer]

Tahnks, iI have done it and installed it, is there a possible way to send this to the admins asl well?

[Erwin]

Tahnks, iI have done it and installed it, is there a possible way to send this to the admins asl well?
By default, this happens only if there are no mods assigned.

[Starsurfer]

how do you change it?

[H2k]

how do you change it?
i have the same problems

[ambumann]

How can I add a function that sends email/PM to the reporting user containing a standard message like:

"vB.org team has received your report and will adress this matter as quickly as possible".

[Erwin]

i have the same problems
It's not a "problem" this is how vB works by default. Most admins won't want to get PMed the report if there's a mod in the forum and the admin is not a mod of that forum.

[gkar]

Great one thanks a lot.

Install :D

[dwh]

The only thing I didn't understand about how you implemented this, fromlooking at the table rows created directly, is why you didn't seem toproperly populate the touserarray field in pmtext table. It turns outthat you are inserting this variable:
'" . addslashes(serialize($tostring)) . "'

however I don't see the variable $tostring created anywhere, unless itcame from a function. I am still looking into this, but I have afeeling this needs to be fixed. Weird thing is, PM did show up :)

:rolleyes:

[Erwin]

The only thing I didn't understand about how you implemented this, fromlooking at the table rows created directly, is why you didn't seem toproperly populate the touserarray field in pmtext table. It turns outthat you are inserting this variable:
'" . addslashes(serialize($tostring)) . "'

however I don't see the variable $tostring created anywhere, unless itcame from a function. I am still looking into this, but I have afeeling this needs to be fixed. Weird thing is, PM did show up :)

:rolleyes:
I'm not populating it because I'm not using code to check who we are sending it to and checking their PM permissions etc. :)

[dwh]

I'm not populating it because I'm not using code to checkwho we are sending it to and checking their PM permissions etc. :)

as long as its on purpose :)

So was I just seeing things or is that variable empty?

[H2k]

very nice .i try this mod 4 day a go .. and it dont work with me ..

so i'am going to install it again and see how it work ..

i have other idea.. if u can do it in the Contact as ... this will be help full becz some time user send how can i install windows xp and this nd that.. if u can make it.. for contact as it will be really great..

Thankyou :)

[kall]

very nice .i try this mod 4 day a go .. and it dont work with me ..

so i'am going to install it again and see how it work ..

i have other idea.. if u can do it in the Contact as ... this will be help full becz some time user send how can i install windows xp and this nd that.. if u can make it.. for contact as it will be really great..

Thankyou :)
You...want people to be able to report the contact us page?

*scratches head in confusion*

[H2k]

You...want people to be able to report the contact us page?

*scratches head in confusion*
Some time They go right away Type how to Active My account or how to get this programs or this and that ..

so if he can make it for contact us .. that anyone is going to send msg.. in contact as.. it will post a thread..

some time we dont check our emails all the times ..

[Marulatree]

Erwin,

Great hack and very useful - Thank you.

I am have one problem though...

I have all 3 options set to YES.

But it's not posting the reported post in my designated forum (ID:72)

Although I am getting emails & PM's but no thread is being created in the "reported posts" forum...

I have check and double checked the install and all is ok.

Any ideas?

[Marulatree]

Nevermind - I put the wrong forum id in....lol

Thanks agian for this great hack m8

[Snifter]

Installed this, and now when I try to report a post I get this error:

Parse error: parse error, unexpected T_VARIABLE in /home/****/forum/report.php on line 129

Line 129 being $moderators = $DB_site->query(" from:

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

[Snifter]

Nevermind, I installed it wrong. Works great, thanks Erwin :)

[Erwin]

What's with all the +++ symbols in the code? The hack works if installed as per instruction.

[Nickeh32]

Great Mod, installed but i got a database error when a post was reported
Invalid SQL: INSERT INTO pm (pmtextid, userid, messageread) VALUES (, 1, 0)
mysql error: 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 ' 1, 0)' at line 1

mysql error number: 1064

I'm not too good at php and mysql so be nice :p can anyone help?

[YabbaDabba]

I installed an early version of this in June of last year on a vB 3.0.1 install.

I recently upgraded to vB 3.0.7.

I would like to upgrade to your 2.1 release.

I haven't moved the old report.php changes into the new report.php file.

Should I treat this as a brand new install?

[Erwin]

I installed an early version of this in June of last year on a vB 3.0.1 install.

I recently upgraded to vB 3.0.7.

I would like to upgrade to your 2.1 release.

I haven't moved the old report.php changes into the new report.php file.

Should I treat this as a brand new install?
Yes.

[YabbaDabba]

Thank you for your quick response.
It's always a pleasure to see a well-supported 3rd-party feature.

Regards,

[kcadd]

/me installs... Thanks!

[zorab]

Great hack - fantastic work erwin!

[QuickFire]

good hack :)

[SmartGnome]

Again an Dr. Erwin Hack :banana: Installed in less then 5 minutes.....

Install is clicked

[Robert9]

This is a great hack, everything is working perfectly. I'm only having problems with part 2 of the install, where you say these instructions:

"2. Look for the phrase variable "reportbadpost" under "Email Body Text Phrases".

Replace it with this translation."

Where would I find this Email Body Text Phrases (I can't find it in report.php)? Thanks in advance!

[Erwin]

This is a great hack, everything is working perfectly. I'm only having problems with part 2 of the install, where you say these instructions:

"2. Look for the phrase variable "reportbadpost" under "Email Body Text Phrases".

Replace it with this translation."

Where would I find this Email Body Text Phrases (I can't find it in report.php)? Thanks in advance!
Admin CP, Phrase Manager.

[Robert9]

Thanks, I guess that was a little obvious:)

[HeloHi]

Thank you for this :)

[WoodiE]

I was running the older version of this on 3.0.1 and a while back I upgraded vB to 3.0.7 and today installed 2.1 of this hack, however now when someone reports a post I have it setup to the mods get a PM. They receive the PM with the title: REPORT: FORUM NAME - Problem member name but the body of the PM is blank - what do I need to do?


-Michael

[Erwin]

I was running the older version of this on 3.0.1 and a while back I upgraded vB to 3.0.7 and today installed 2.1 of this hack, however now when someone reports a post I have it setup to the mods get a PM. They receive the PM with the title: REPORT: FORUM NAME - Problem member name but the body of the PM is blank - what do I need to do?


-Michael
Did you make the phrase changes?

[WoodiE]

In the zip file it only said for one phase change... reportbadpost - and I did change it.

-Michael

[Erwin]

In the zip file it only said for one phase change... reportbadpost - and I did change it.



-Michael
With a version upgrade old phrases may have been deleted - do the phrase change again and see.

[WoodiE]

Erwin,

I guess I'm not understanding - your html file only calls for one phase change (reportbadpost), upon upgrading to your new version 2.1 I also replied that one phase change - the body of my PM's are blank.

-Michael

[Erwin]

Erwin,

I guess I'm not understanding - your html file only calls for one phase change (reportbadpost), upon upgrading to your new version 2.1 I also replied that one phase change - the body of my PM's are blank.


-Michael
I suggest uninstalling and totally reinstalling the hack again. Obviously something went wrong.

[WoodiE]

I suggest uninstalling and totally reinstalling the hack again. Obviously something went wrong.


It doesn't look like your install script has an UN-install feature - what do I need to do to completely remove this hack then?



-Michael

[Erwin]

It doesn't look like your install script has an UN-install feature - what do I need to do to completely remove this hack then?



-Michael
When I mean reinstall, I mean redoing the code changes to a completely unhacked private.php

To get rid of the Admin CP settings bits, run vB in debug mode so you can delete settings easily.

[Erwin]

Erwin,

I guess I'm not understanding - your html file only calls for one phase change (reportbadpost), upon upgrading to your new version 2.1 I also replied that one phase change - the body of my PM's are blank.


-Michael
If you add phrases to the Master (if running in debug) they get overwritten with upgrades of vB.

[David Bott]

Hello Erwin...

I am looking for a way to have the e-mails that come in to have the RETURN or REPLY TO address be the member who sent it and NOT the site admin. Right now if a mod clicks REPLY to send a note back to the member who reported the post, it is addressed to the admin.

It would also be good to be able to include all the moderators in on the reply to the e-mail. I had this done in VB2, but have no clue how to make it happen in Vb3 which AVS Forum just moved to last Sunday.

Thank you.

[Erwin]

Hello Erwin...

I am looking for a way to have the e-mails that come in to have the RETURN or REPLY TO address be the member who sent it and NOT the site admin. Right now if a mod clicks REPLY to send a note back to the member who reported the post, it is addressed to the admin.

It would also be good to be able to include all the moderators in on the reply to the e-mail. I had this done in VB2, but have no clue how to make it happen in Vb3 which AVS Forum just moved to last Sunday.

Thank you.
That's possible with some code changes. I don't have time to do this at the moment.

[David Bott]

Bummer...But understood. Does not sound like it would be to bad. Are you for hire? :)

[Erwin]

Bummer...But understood. Does not sound like it would be to bad. Are you for hire? :)
No. :)

[David Bott]

That also is too bad. :)

[Marco van Herwaarden]

No. :)Hmm what a disappointment, my wife just asked the same question. :(

[Erwin]

Hmm what a disappointment, my wife just asked the same question. :(
Your wife asked you whether you are for hire???

[Marco van Herwaarden]

Nope, she saw your avatar and asked when YOU where for hire. :D :D

[David Bott]

BTW...I forgot to mention this addition works very well. So thank you very much.

[Nuckolsc.com]

Just installed it on my new board I got. Very easy to install and works flawlessly! Thanks man!

[WoodiE]

When I mean reinstall, I mean redoing the code changes to a completely unhacked private.php

To get rid of the Admin CP settings bits, run vB in debug mode so you can delete settings easily.

Erwin,

I'm still messing with this trying to get it to work and still unable to. Your above comment says to make the changes to an unhacked private.php - what changes? The install file nor anywhere in this thread (least that I could find) call for any changse in to a private.php file.

Am I missing something?


-Michael

[COBRAws]

is there a way to quote the reported msg?

[mOdEtWo]

Erwin;

Could you please give me the instructions on how to remove this hack? I'm getting ready for 3.5, and I don't want anything cluttering it up. Seems like something is saved in the database as I see the Report Manager Settings in the ACP on my 3.5 test board.

Thanks. :)

[mOdEtWo]

*bump*

[MThornback]

Is there anyway to edit:

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

That section of the code so that you can specify that all reported posts go to 1 thread with the title "Reported Posts" or something similar?

[Black_Widow]

Is it possibile to let any mod chose to receive or not pm or email?
At the moment all mod receive or don't receive email and pm.
thanks

[Neal-UK]

Erwin,

I'm still messing with this trying to get it to work and still unable to. Your above comment says to make the changes to an unhacked private.php - what changes? The install file nor anywhere in this thread (least that I could find) call for any changse in to a private.php file.

Am I missing something?


-Michael

How do I turn debug on and which file does it go in on vb 3.5.0 rc1?

[Andreas]

1) This Hack is not compatible with vBulletin 3.5
2) Debug Mode in vBulletin 3.5 is beinmg enabled by placing

$config['Misc']['debug'] = 1;

in config.php

[Neal-UK]

1) This Hack is not compatible with vBulletin 3.5
2) Debug Mode in vBulletin 3.5 is beinmg enabled by placing

$config['Misc']['debug'] = 1;

in config.php

excellent thanks, got it off vbulletin.com, should have said sorry

[cdonger]

Hi,

This mod is not working for 3.5. I don't know how to take it out.

[ombossman]

how to remove my database because upload my forum 3.5.1 versıon dont work it

[Mindwarp]

this is currently working on my server 3.5.3 for everyone but Admins :(

[MorrisMcD]

this is currently working on my server 3.5.3 for everyone but Admins :(

This hack is for 3.0.x.. Some things may have changes.. Why not use the plugin/extension system..

Here is a 3.5 version of the hack.. Similar anyway
https://vborg.vbsupport.ru/showthread.php?t=83074&highlight=reported

[coRtALoS]

Does this NOT work with the newest VB? I wish it did..the other report hack does not send out a PM to the mods :(

[bruno.bfB]

Great hack, Erwin! :)
good one!

[Mysticales]

Question... I have 3.0.9 I installed this mod.. Well.. oddly, I think I am getting parse errors from the adminfunctions_template.php which will come up as:
Parse error: parse error, unexpected T_STRING, expecting ',' or ';' in /home/forumsq/public_html/includes/adminfunctions_template.php on line 375

The only other mod I installed the same time was a cron job for purging users who dont activate after 10 days.

So was wondering.. does this not work for 3.0.9 or something? I mean.. luckily I can still work in the adminCP. However Forum manager, add new forum give me this error and I dont know if its from this mod somehow or what. =/

Anyone have some advice? =)

Edit: Yeaaaa Only took me 5 hours to figure it out.. you see something was odd about the php file.. it looked like if a 2 year old was learning php.. double quotes all over the place, no correct string or line breaks etc..

Which was odd, since I couldnt see how EITHER mod could cause it.
Tracked it down...
https://vborg.vbsupport.ru/showthread.php?t=59820

That.. if you use the built in file editor.. it will save the php code in such a way that it ruins the design of the php page in question! OUCH! However.. using the upload function to overwrite it using the mod works fine and no issues anymore.. but so much for my idea to use edit to be quicker to work with.. sigh..

Anyways installed. ^^

[Mysticales]

Ok I hate to double post.. but Im lost.. its late and Im tired. 3.0.9 I understand Ill have to make some phase changes, correct? Which will be applied to the reportbad phrase?

Do I have to do extras in the report.php?

Oddly.. eveyrone can report a post.. it will come up with SQL database issues like
Invalid SQL: INSERT INTO pmtextnt(fromuserid, fromusername, title, message, touserarray, iconid, dateline, showsignature)nVALUESnt(30013, 'Mysticales', '07-13-2006 REPORT: Admin/Mod General Chat - Hardrive', 'Mysticales ( mailto:mysticales@darkmystics.com ) has reported this post:

So Im just curous.. what files really need to be edited to work now? Its cute.. it doesnt email us, or PM us.. but it does make a forum thread just nothing else.. starting to feel like I am stupid on this right now. =/

Just would love to get it where it can do all 3, if anyone has a idea.. please let me know. =)

[Mysticales]

Sigh guess no one here uses this really anymore. =(

Just cant figure out why the reporting gives SQL errors, however does make a new thread just fine, but no email or PM..

Thinking of just removing it since I cant get it working right. Whats this debug mode method to remove it from the admin cp anyways? Hows that work? Never did it before.

Edit: Since these forums dont have auto merge..

Ok I got it to work.. finally.. GJ (Installs)

Issue.. Im getting 2 PM/Emails per reported post, however if I remove my name as listed moderator for the forum.. I only get 1..

So maybe I am missing something or not understanding something here.

But also would be nice to know how to uninstall, just in case. But so far.. my mods love it.. so its staying. =)

Also.. why are mods that "arent" assigned to "x" forum getting PMs/Email reports of forums they arent moderators of? But the ones they ARE mods of, they get 2.

[Coldhands]

Could this be made to work with 3.6? How could I do that, and if there are no plans to update this mod, where can I read a little more about how to get this to work with 3.6 on my own?

[ConqSoft]

3.6 has most, if not all, of these features built in.

[Coldhands]

Really, I didn't see anything to this effect. What part of vb options is the PM option in?

[ConqSoft]

Just checked. The PM option isn't built in. E-mailing and/or creating a thread is built in.

[Mysticales]

To be honest.. the PM option on large forums annoyed us more.. cause oddly it would PM every mod.. sometimes do a double PM etc.

Btw.. since I switched to 3.5.4 now.. this is still stuck in my adminCP, I have never uninstalled things on vB before.. what steps would I go to remove things from admincp?

[ragintajin]

Btw.. since I switched to 3.5.4 now.. this is still stuck in my adminCP, I have never uninstalled things on vB before.. what steps would I go to remove things from admincp?

I'd like to know how to uninstall this as well.

Bump.

[marty1881]

When trying to install it through admincp, i get this.
Fatal error: Call to a member function query() on a non-object in /home/gamingul/public_html/admincp/install_vbreport.php on line 20

[ITSNS]

I get the same error..

vB Report Manager v2.1 Installer - by Dr Erwin Loh
PHP Fatal error: Call to a member function query() on a non-object in D:\htdocs\forum\admincp\install_vbreport.php on line 20

vBulletin 3.7.2 Patch Level 1