PDA

View Full Version : Report post to moderator -> PM or e-mail


JohnM
27 May 2001, 05:34
This hack allows you to select the method of delivery for the report to moderator message.

Rename the attached script to JohnMinstall.php and run it. It will make the necessary database modification and give you further instructions. Delete the script when you're done.

I hope this helps some people :)

DEMOLiTiON
27 May 2001, 11:10
But I get this when installing.

Parse error: parse error in /usr/local/etc/httpd/sites/demolition/htdocs/vb/admin/johnminstall.php on line 10

JohnM
28 May 2001, 15:39
not in admin, just your normal directory

works for me :-(

JohnM
28 May 2001, 15:48
If you're using PHP3 use the attached script instead and do the following:



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------

JohnM
28 May 2001, 15:55
Err, forgot to attach it :O

DEMOLiTiON
28 May 2001, 17:10
ok the installing is working now :)
but when reporting a post I get this in my e-mail:

Database error in vBulletin: Invalid SQL: SELECT DISTINCT userid, user.email FROM moderator,user WHERE user.userid=moderator.userid AND moderator.forumid IN (4,3,-1)
mysql error: Column: 'userid' in field list is ambiguous
mysql error number: 1052
Date: Monday 28th of May 2001 07:09:27 PM
Script: /vb/report.php

:(

Psycho
28 May 2001, 22:42
ive installed everything just like you laid it out. but when i test it, i get a parse error on the last line on the report.php

the last line is the ?>

any suggestions?

JohnM
29 May 2001, 00:37
demolition:

change:
$moderators=$DB_site->query("SELECT DISTINCT userid, user.email FROM moderator,user WHERE user.userid=moderator.userid AND moderator.forumid IN ($foruminfo[parentlist])");

to:
$moderators=$DB_site->query("SELECT DISTINCT user.userid, user.email FROM moderator,user WHERE user.userid=moderator.userid AND moderator.forumid IN ($foruminfo[parentlist])");

Psycho: make sure you didn't overwrite the } for the while() loop

Psycho
29 May 2001, 04:15
I changed that section of code, but still receive the same error code. the } is still there for the while loop, made sure there were 3 open and closing.

I attached the file for you to look at if you so wish, Maybe I set something wrong in it. Reason I tried to set this hack up is because the report didnt work on its own as an email, now it still isnt working.

<file removed>

DEMOLiTiON
29 May 2001, 13:36
ok I got this working now :)
but the reports are only send to one moderator.. is there a way to send it to all moderators and admins?
thnx

JohnM
29 May 2001, 17:29
First of all, it's against the license to post files. Please remove it.

for your question, your tags were a bit messed up :p

your while() loop part should be:



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------

JohnM
29 May 2001, 17:32
Originally posted by DEMOLiTiON
ok I got this working now :)
but the reports are only send to one moderator.. is there a way to send it to all moderators and admins?
thnx

it should send it to all of them... I don't see why it wouldn't... PM me your while loop part of report.php

Psycho
29 May 2001, 23:16
I wasnt thinking on the file, but I appreciate your help. It works great now. Thank you very much :)

Psycho
31 May 2001, 22:10
I know your probably getting sick of me. Ive put that code into my file which seemed to have fixed it. However, when I look at the private message it give me this

("INSERT INTO privatemessage (privatemessageid,userid,touserid,fromuserid,title
,message,dateline,showsignature,iconid,messageread
,folderid) VALUES (NULL,1,1,1,',',".time().",0,0,0,0)");

DEMOLiTiON
01 Jun 2001, 06:17
JohnM, I emailed you my report.php, please look at it :)

JohnM
01 Jun 2001, 23:51
"Look at the private message"?

Demolition: it shouldn't be doing that. are you sure you have more than one moderator? ;)

kdog316
02 Jun 2001, 04:13
i keep getting parase error and here is what my code looks like

oh and the parase is on line 68 which is ?>







Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



with out the space after the question mark

jojo85
02 Jun 2001, 05:14
Good idea,nice hack,
CONGRATS :D

daydreamer
28 Jun 2001, 02:15
"go into your control panel and select an option"

You lost me there... select an option where?

dd

daydreamer
28 Jun 2001, 02:51
Duh, found it.

Foxtroter
02 Jul 2001, 02:04
Originally posted by kdog316
i keep getting parase error and here is what my code looks like

oh and the parase is on line 68 which is ?>







Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



with out the space after the question mark

add another } after this

Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------

there should be two.

anyway i believe two other people have answered ur question.

ptegan
14 Aug 2001, 13:48
Thx !!

Nice hack.

idban
18 Sep 2001, 05:57
i just modified report.php to make this possible

JJR512
19 Sep 2001, 09:24
Originally posted by daydreamer
"go into your control panel and select an option"

You lost me there... select an option where?

dd
Originally posted by daydreamer
Duh, found it.

Sorry, I haven't found it yet! What option am I looking for and on which control panel (admin cp, my own user cp, what?) I can't find anything anywhere!

Also...maybe this is related to the option that I haven't set because I don't know what the option is or where it is, but after installing it, I try clicking the Report link in any thread in any forum and I get the new error message "Sorry, this feature is disabled" or whatever.

Sephi
22 Jan 2002, 20:42
Originally posted by idban
i just modified report.php to make this possible

Thank You :D
This hack works perfectly :p

See 4 Later !

Omero
06 Feb 2002, 11:53
Bug found! If ' or " is present in the report text and the notify with PM is active, the mysql INSERT into private messages fail with mysql error!

Here is the workaround:

Change this:



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



into this



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



This will fix the bug, by adding the proper slashes where they are needed ;)

Stoned Gecko
08 Feb 2002, 01:04
Works great!!! Thanks!

Remi
07 Apr 2002, 20:47
Does this hack work also with 2.2.4?

Thanks

Erwin
08 Apr 2002, 02:09
Yes. Also with 2.2.5 - it's one of the best hacks around and should be standard in 3.0 methinks.

Remi
08 Apr 2002, 14:13
Thanks Erwin

I followed the instructions, but I could not find some of the Text I was asked to replace.

I must be doing something wrong :D

I will try again today :)

mas404
09 Apr 2002, 08:49
hi
it is work but nothing apper on the PM (no message )
only the temp. which I install ..
and the email working good

why??

Dylan Leblanc
03 Jul 2002, 03:35
This hack sounds cool, I was looking for something kind of like it. What I was looking for is something that would take the Report a Post messages and automatically post them into a private moderators forum.

Would this be possible?

Pilot
08 Jul 2002, 21:01
Is the original attachment updated with the fixes?

Seifer
09 Jul 2002, 05:54
Parse error: parse error, unexpected '=' in /home/plasmic/www/forums/report.php(66) : eval()'d code on line 1

Parse error: parse error, unexpected '=' in /home/plasmic/www/forums/report.php(67) : eval()'d code on line 1


Uh...help?

Seifer
09 Jul 2002, 06:06
Also, when I tested it, the moderator said the PM is there, but there's no subject or link or anything. The PM said it was from me, but that's it she said.

Seifer
09 Jul 2002, 06:11
She sent me this image:

Edit: Also, when tried with e-mails, the e-mails are blank too.

Exo
06 Oct 2002, 23:18
same here

Parse error: parse error in /home/www/web3/html/report.php(62) : eval()'d code on line 1

Parse error: parse error in /home/www/web3/html/report.php(63) : eval()'d code on line 1

Parse error: parse error in /home/www/web3/html/report.php(62) : eval()'d code on line 1

Parse error: parse error in /home/www/web3/html/report.php(63) : eval()'d code on line 1

Exo
07 Oct 2002, 22:38
plz someone help us!!

Zelda-King
27 Nov 2002, 22:23
I'm using vBulletin 2.2.9 and the last three report.php edits don't exist. The script is different. I tried installing the hack. Looked promising then I got untold parse errors and though the PMs/emails would send they would be blank.

Sebastian
29 Nov 2002, 02:10
Originally posted by Zelda-King
I'm using vBulletin 2.2.9 and the last three report.php edits don't exist. The script is different. I tried installing the hack. Looked promising then I got untold parse errors and though the PMs/emails would send they would be blank.

I wouldn't even bother installing it, this is one of the worst poorly written hacks I've ever seen. It would be nice if someone could rewrite it.

alamuae
08 Jun 2003, 09:55
i ned tehs hacks for (Version 2.3.0)

Erwin
08 Jun 2003, 12:11
This hack works for 2.3.0, but you need to know how to edit the instructions to make it work.

alamuae
08 Jun 2003, 12:56
ok thank you Erwin
........
which Attachment i have to downlod

alamuae
08 Jun 2003, 13:13
plz someone help
((you need to know how to edit the instructions to make it work.))