Mini Mods - Auto-PM to Staff when a User is Banned

AutoPM Staff on Ban
Version 1.0

What does this do?
When one of your moderators or administrators bans a user, this mod will PM all staff (Mods and Admins) letting them know that the user has been banned!


Sounds Great! How do I install?
Installation couldn't be easier. Unzip the attached ZIP file and import the Product XML to your AdminCP as normal. - it adds 2 phrases, and 1 plugin


Can I customize the PM text?
Yep! The PM text is stored in a phrase called autopm_on_ban_message. You can edit this to put your own text in.

Note: In the PM message phrase, {1} is the name of the user who has been banned, and {2} is the name of the person who banned them.[/left]

Note 2: The person who bans the user will NOT receive a PM, so if your not receiving a PM, it's likely because you where the one who banned the user!


Important: Unfortunately, my leased vBulletin licence has now expired, and I won't be renewing it until September which means I will be unable to reply to this thread, or update this mod until then. I'm hopeful that the great vBulletin.org community will step in to answer any questions in my absence though See you all in early September!

[Alan @ CIT]

Sorry, this modification is only supported on vBulletin 3.6 Beta 2 or above.

Thanks,
Alan.

[Adrian Schneider]

Originally Posted by bashy

Hi

After reading this post i went ahead and tried to install this but got this error
I am on 3.5.4
any ideas please?

Database error in vBulletin 3.5.4:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO plugin
	(`active`, `executionorder`, `title`, `hookname`, `phpcode`, `product`)
VALUES
	('1', '5', 'AutoPM Staff on Ban', 'userdata_postsave', 'if ($usergroups_changed)\r\n{\r\n	// Check to see if the user has just been banned (in the last 10 seconds)\r\n	$ban_info_q = \"SELECT ban.userid, user.username\r\n		FROM \" . TABLE_PREFIX . \"userban AS ban\r\n		LEFT JOIN \" . TABLE_PREFIX . \"user AS user ON (ban.userid = user.userid)\r\n		WHERE ban.userid = \" . intval($userid) . \"\r\n		AND bandate > \" . (TIMENOW - 10) . \"\r\n		ORDER BY bandate DESC\r\n		LIMIT 1\";\r\n\r\n	if ($ban_info_a = $this->dbobject->query_first($ban_info_q))\r\n	{\r\n		// Users just been banned, so fetch the list of admins/mods to PM\r\n		$recipients_q = \"SELECT users.userid, users.username\r\n			FROM \" . TABLE_PREFIX . \"user AS users\r\n			LEFT JOIN \" . TABLE_PREFIX . \"administrator AS admins ON (admins.userid = users.userid)\r\n			LEFT JOIN \" . TABLE_PREFIX . \"moderator AS mods ON (mods.userid = users.userid)\r\n			WHERE users.userid IN (admins.userid)\r\n			OR users.userid IN (mods.userid)\";\r\n\r\n		$recipients_r = $this->dbobject->query_read($recipients_q);\r\n\r\n		while ($recipients_a = $this->dbobject->fetch_array($recipients_r))\r\n		{\r\n			$pmto_a[$recipients_a[\'userid\']] = $recipients_a[\'username\'];\r\n		}\r\n\r\n		// Create the final recipients list for the PM, removing the current user from the PM list\r\n		unset($pmto_a[$this->registry->userinfo[\'userid\']]);\r\n		$recipients = implode(\';\', $pmto_a);\r\n\r\n		global $vbphrase;\r\n\r\n		// Prepare the message title\r\n		$pm_title = construct_phrase(\r\n			$vbphrase[\'x_has_been_banned\'],\r\n			$ban_info_a[\'username\']\r\n		);\r\n\r\n		// Prepare the message text\r\n		$pm_text = construct_phrase(\r\n			$vbphrase[\'autopm_on_ban_message\'],\r\n			$ban_info_a[\'username\'],\r\n			$this->registry->userinfo[\'username\']\r\n		);\r\n\r\n		// Send the PM\r\n		$force_it_baby[\'adminpermissions\'] = 2;\r\n		\r\n		$pm =& datamanager_init(\'PM\', $this->registry, ERRTYPE_SILENT);\r\n		$pm->set(\'fromuserid\', $this->registry->userinfo[\'userid\']);\r\n		$pm->set(\'fromusername\', $this->registry->userinfo[\'username\']);\r\n		$pm->set(\'title\', $pm_title);\r\n		$pm->set(\'message\', $pm_text);\r\n		$pm->set_recipients($recipients, $force_it_baby);\r\n		$pm->set(\'dateline\', TIMENOW);\r\n\r\n		if (!$pm->errors)\r\n		{	\r\n			// No errors, so send the PM\r\n			$pm->save();\r\n		}\r\n	}\r\n\r\n}', 'cit_pm_on_ban');

MySQL Error  : Unknown column 'executionorder' in 'field list'
Error Number : 1054
Date         : Sunday, June 25th 2006 @ 04:31:25 AM
Script       : http://www.bashys-place.com/forums/admincp/plugin.php
Referrer     : http://www.bashys-place.com/forums/admincp/plugin.php?do=productadd

Guys the "executionorder" field was added in vBulletin 3.6.

[bashy]

The only reason why i have tried this is because of what you said in another thread....

https://vborg.vbsupport.ru/showthread.php?t=118919 - Should work fine with 3.5.4, but if you have any problems, let me know.

Hence trying this out.......its the part that says "but if you have any problems, let me know"
is why i posted here asking fro help...

Originally Posted by Alan @ CIT

Sorry, this modification is only supported on vBulletin 3.6 Beta 2 or above.

Thanks,
Alan.

[Alan @ CIT]

"should" is the key word in my sentance

Thanks,
Alan.

[bashy]

Fair enough, thanks anyway!!

[klaush]

Originally Posted by Alan @ CIT

"should" is the key word in my sentance

Thanks,
Alan.

So, Alan, can you port this to 3.5.x, or is it too difficult?

[Alan @ CIT]

Sorry, but I have no plans to back-port any of my 3.6 hacks to work with 3.5.x

Thanks,
Alan.

[Eagle Creek]

Am I able to edit the staff UG's?

Cause I have Admins, S-mods, Beheer, Mods.. They are all part of my forum staff.

[php]

looks and seems very nice, Thank You

[Ncturnal]

How can I limit the people this goes out to, like say just to admins. This was sent to anyone who can mod a particular forum and thus went to a lot of people we really didn't want seeing that message.