Auto PM to Thread Starter on Moderation

What does this Hack do?
When a thread is Opened/Closed, Stuck/Unstuck, Moved, Split, Merged, or a Post is deleted, a PM will be automatically sent to the Poster to inform them of this.

If you don't want to have a PM sent for a specific action, just don't add the code for that bit.

As requested here

Don't forget to click Install.

Update: PM now includes the name of the Moderator who actioned the changes.

22 December 2004 - Bugfix - missing variables. Thanks to Bison.

14 April 2005 - Fixed missing $action for Deleted threads.

[theArchitect]

Sensational idea for a hack, but i am getting the following DB error when i try and moderate a thread:

Invalid SQL: 
 		    	SELECT postid, post.title, pagetext, post.threadid, thread.title AS threadtitle
 				FROM post AS post
 				INNER JOIN thread AS thread USING(threadid)
 				WHERE postid = 
 			
 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 '' at line 4
 
 mysql error number: 1064

Any assistance would be most appreciated.

[kall]

Originally Posted by TundraSoul

In the instructions it states

Add $modby to your PM text in the Admin CP options.

Where exactly does $modby go?

@Tundrasoul: In the part in the AdminCP where you define what the message will be - it's in the User Posting part from memory.

@omaniman: Another good idea, but again, something I couldn't work out how to do.

@futureye: if you are using vBs built in SQL thingame, one command at a time. If you are using phpmyadmin you can copy and paste the entire queries and run them at once.

@theArchitect: I don't know why you are getting that error, it looks like it's not getting the postid for some reason.

@Ageel: I agree, but I couldn't work out how to do that easily. If someone wants to write the code for that I can add it to the first post and credit them.

[Delphiprogrammi]

can't get this working i installed tested it did a post with my "test user" logged out looged back in as admin locked the thread and finally checked the pm's on the test account but nope ... no errors at all but no pm either

pm is enabled on both accounts

[Bison]

The variables to delete, close and move aren't printing in the PM...

[kall]

Originally Posted by Bison

The variables to delete, close and move aren't printing in the PM...

Oh dear, so they aren't. Thanks man.

Fixed install file uploaded...I think that's correct, it's 11PM here and I'm rapidly losing consciousness.

[Delphiprogrammi]

can't get this working no errors at all when i am done editing postings.php i upload the modified file to /forums/ then i goto

http://forums.mysite.com/admincp/opt...ing&do=options and i click save then i moderate a thread (i lock it) but no pm ....

[Bison]

Originally Posted by kall

Oh dear, so they aren't. Thanks man.

Fixed install file uploaded...I think that's correct, it's 11PM here and I'm rapidly losing consciousness.

Thanks for the fix Kall, but there's still another problem ... if you "soft delete" a thread or post, and restore the same thread or post later later, no notification is sent when the thread was retored. Also, the delet fix didn't work. The $action variable is not storing values.

[Delphiprogrammi]

i can't get this to work pm's on my testaccount are on i did the database querys you instructions tell us todo then i edit postings.php i upload the modified file (overwriting the existing one) then i close a thread and login with the test account but no pm ??????

PHP Code:

$_REQUEST['forceredirect'] = 1;
    $url = "showthread.php?$session[sessionurl]t=$threadid";
    eval(print_standard_redirect('redirect_openclose')); 


above that code i add code like your instructions tells us ... but nope :devious:

[Filmrus]

Hello,
I have found one problem in your script. When deleting one of any posts in the topic then confirmation message has been sending not to the author of the post but to the author of the topic. Could you please fix it?

[kadafi_alive]

Does anyone know how to do undo the database? I'm gettin' a error when I try to moderate threads and posts.

I want to do delete the SQL queries I ran, what queries do I've to type in to delete?