Quote Notification

Quote Notification

Note: This hack does not work in vBulletin 3.6. If someone would like to port it, that's fine with me, but I don't feel like updating this particular hack.

Description: This plugin will add a "Quote Notification" option for users to select. If selected, they will receive a notification by PM whenever someone quotes them in a post.

Installation:

• Import the product XML file
• Go to your User CP > Edit Options and select "Quote Notification" if you like
• If you want to change the content of the PM that gets sent, the phrases are quotenotify_subject and quotenotify_message
• The email notification has a separate phrase, quotenotify_emailmessage
• If you want to change the Profile Field options, find the "Quote Notification" field in your User Profile Field Manager in the ACP.
• If you want to set a default user for the notification PMs to be sent through, go to ACP > vBulletin Options > Message Posting and Editing Options > Quote Notification Sender; set it to 0 for the sender to be whoever did the quoting

Warning: DO NOT change the title of the Profile Field from "Quote Notification", or the values from "Private Message", "Email", and "No" or this hack will not work.

Contains:

• 1 Plugin
• 1 Profile Field
• 2 Phrases

This hack is somewhat similar to Who quoted me?, but still considerably different, and if your forum is concerned about quotes then both could probably go rather nicely together.

Version History:
1.0.2
- Fixed compatibility issues with Backlink For Quotes
- Added option for notification by Email or Private Message
- Added ACP option for one specific PM sender or for the PMs to be sent by the user who did the quoting (original functionality)
1.0.1
- Fix for users with apostrophes
1.0
- Original version


Please click install.

[Krofh]

Since everyone seems to want to be able to set this enabled by default...

• Log into your Admin Control Panel
• Go to User Profile Fields > User Profile Field Manager
• Locate the "Quote Notification" field, and click "Edit"
• In the big "Options" textbox, switch "Yes" and "No" so that "Yes" is first. This will make "Yes" the default option.
• Make sure the "Set Default" option is set to "Yes" as well
• Save your changes

[Snake]

Thanks, I'll give this a shot!

[hambil]

Nice hack.

*clicks install*

[SpankMe]

Got the following SQL error

Invalid SQL:
SELECT user_table.userid AS userid, profile_fields.field21 AS wantquotenotify FROM user AS user_table LEFT JOIN userfield AS profile_fields ON (user_table.userid=profile_fields.userid) WHERE user_table.username='Brian d'marge' GROUP BY user_table.userid;

Need to change:

PHP Code:

$quoteuserquery = $vbulletin->db->query_first("SELECT user_table.userid AS userid, profile_fields.field" . $quotegetfieldquery['profilefieldid'] . " AS wantquotenotify FROM " . TABLE_PREFIX . "user AS user_table LEFT JOIN " . TABLE_PREFIX . "userfield AS profile_fields ON (user_table.userid=profile_fields.userid) WHERE user_table.username='" . $kr_load[$kr] . "' GROUP BY user_table.userid"); 


to:

PHP Code:

$quoteuserquery = $vbulletin->db->query_first("SELECT user_table.userid AS userid, profile_fields.field" . $quotegetfieldquery['profilefieldid'] . " AS wantquotenotify FROM " . TABLE_PREFIX . "user AS user_table LEFT JOIN " . TABLE_PREFIX . "userfield AS profile_fields ON (user_table.userid=profile_fields.userid) WHERE user_table.username='" . $vbulletin->db->escape_string($kr_load[$kr]) . "' GROUP BY user_table.userid"); 


so as to escape the username as it contained a single quote in above error.

[Krofh]

Ahh, indeed. Thanks for noticing and fixing that, I'll go post an updated version now.

... done.

[sinaluna]

I really like the sound of this. But I haven't been able to get it to work. Was there supposed to be a php file to download also?

I don't get any error messages. But I don't get any PM's either. The setting is turned on in the User CP.

[Krofh]

Is the product enabled? There's no PHP, it's just the XML file... Is the profile field's name still "Quote Notification", and the values "Yes" and "No"? (sorry, this hack breaks if those are changed). I just tried installing this on a completely clean forum and it worked fine.

[sinaluna]

I finally figured out the problem, though I am still working on finding a solution. I am also using the Back-Link for Quotes hack

https://vborg.vbsupport.ru/showthread.php?t=91282

and the link is interferring with this hack.

Example: [quote=testuser;326157]

Any ideas?

[Krofh]

Ahhh, I see what's causing it... obviously, there will be no user called "username;1324" anyways, I'm really tired right now and don't have the patience to test it thoroughly, but this should work...
1) Go to your Plugin Manager in the ACP
2) Edit the plugin "Quote Notification" under newpost_complete
Add the highlighted code:

$kr_load = array();
$kr_text = array();
if (preg_match_all("/\[quote=([^\\\"\]]*?)\](.*?)\[\/quote\]/is",$post['message'],$matches)>0) {
	for ($kr=0;$kr<count($matches[1]);$kr++){
		//echo $matches[1][$kr]."<br>";
		$matches[1][$kr] = (strpos($matches[1][$kr],";")) ? substr($matches[1][$kr],0,strpos($matches[1][$kr],";")) : $matches[1][$kr];
		if (strtolower($matches[1][$kr]) != strtolower($vbulletin->userinfo['username'])) {

I did some testing on my boards, and it worked fine, though like I said it wasn't very extensive. Let me know if that doesn't work.

[COBRAws]

This works great! Any way i can specify the sender?

I have an username for massive pm's and moderation reports i would lik to use for sending these pm's.

Thank you Jesse