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. :)

First post, one moment while I upload files... done.

thanks ...installed i will try it

Nice hack actually :)

Might use it in the future

[high]* Desihunk says thanks.[/high]

How do I make it so its enabled by default for every user, untill they decide to turn it off?.. possible make a global seting option somewhere in USERGROUPS or ACP? :) Otherwise spelendit hack...

^ That's a good idea, but it'd be tricky to do since this isn't done through normal ACP options/bitfields but the Profile Field Manager. I suppose you could go into phpMyAdmin to your "userfield" table, and set the default value of whatever column that field ended up at to "Yes" :p I'll have to think about how to do that.

I dont see the option to turn it on.. Hmm

Found it

This looks promising.. .

Hello ,

how can i set option enabled by default for every user ,

Is there some qeury to do it ,

Regards

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

Thanks, I'll give this a shot!

Nice hack.

*clicks install*

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:
to:
so as to escape the username as it contained a single quote in above error.

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

... done.

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.

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.

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?

Ahhh, I see what's causing it... obviously, there will be no user called "username;1324" :p 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:
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.

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

Hmmm, it's not currently an option but it's something I can consider adding. Right now, the sender is the person who quoted you.

How about email notifications instead of pm notifications? :)

I suppose that's a good idea too... though can't you turn email notification on for when you get a PM, then it'll PM and email you? :p haha jk. I'll probably add all this stuff from the last several posts in about a week or so (this next week is crazy for me, no time for programming whatsoever) and release an updated version of the script.

Updated as promised, with the above suggestions... Email/PM notification choice, and the ability to set what user sent the notification in the case of PMs.

Thank you, Krofh! Installed ;)

Any update for 3.6?




can't unisntall it.

^ Huh, that's not cool... they apparently removed the "title" column from the profilefield table in 3.6, and I can't seem to figure out where they moved it to :-/ try adding this at the very beginning of the uninstall code:

and this at the end

That should add the title field, put "quote notification" in the one row, then find it and delete that row, then drop the title field again. Definitely don't use this on anything besides 3.6 though, otherwise it'll drop your title field in 3.5, which you actually kinda need.

Weiiiiirrrdddd, I wonder where they put those titles... I saw something about the datastore table, but I couldn't find them in there :-/ if anyone else knows, that'd be cool to know

Thank you, Krofh!

But got this error:


Tried again:


Uninstall Code:

Where it says {insert profileid here}, I meant for you to put the number of the profileid... since vB3.6 kinda broke this, you'll have to look it up yourself. Go to the User Profile Field Manager, look at the links on things, at the end it has profilefieldid={number}, the number on Quote Notification should be that one.

Btw, now that you added the TITLE field, take the
line out of it, and try again after fixing the number like I just said.

My profilefield is field21

Error:

Unisntall Code:
or

or

or

The last one... just the number itself.

Already tried all, Krofh! But didn't work.

Or can I drop its tables manually in phpmyadmin?

Yes, I suppose you could do that... just drop the row with the quote notification, which seems to be #21 in your case. Argh, 'tis strange that they would remove some of these things in 3.6, I don't like it :( it doesn't help that this was one of my first hacks though, and I didn't code it very well :-/ sorry about the trouble.

We love your hack but we have run into a conflict with our alert system. We have 'alerts' set up to display as posts in a separate, staff only forum. The alerts include a quote of the post of the alerted post. Quote notifier rightly so. views it as any other quote and sends a PM to the person quoted, or in this case, alerted on. Since the text includes the name of the person who quoted them and the link refers them to a "no permissions" private forum, this basically tells them who alerted on their post.

Is there a way to drop the ID action from the text itself? Someway to change the text to a generic "Someone has recently quoted you" and retain the link to the post containing the quote?

Thank you.

Cripe, I can't believe I didn't think of that when I made this. In your Plugin Manager in the ACP, edit the plugin "Quote Notification" under newpost_complete. Add this code at the very top and bottom of the plugin, changing the number 25 to whatever id your private forum is.
In the Phrase Manager of the ACP, look for the GLOBAL phrases "quotenotify_message" and "quotenotify_emailmessage". Those phrases are the PM and email phrases (respectively) that get sent to the quoted user, and you could easily modify those for your needs.

thank you!!!. we will try that.

i have edited the cde to read

if ($post['forumid'] != 65) {


$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'])) {
if (!in_array($matches[1][$kr], $kr_load)) {
$kr_load[] = $matches[1][$kr];
$kr_text[] = "";
}
else {
for ($kri=0;$kri<count($kr_load);$kri++) {
if ($kr_load[$kri] == $matches[1][$kr]) {
$kr_text[$kri] .= "";
break;
}
}
}
}
}
}
if (count($kr_load) > 0) {
for ($kr=0;$kr<count($kr_load);$kr++) {
//echo "<br>" . $kr_load[$kr];
$quotegetfieldquery = $vbulletin->db->query_first("SELECT profilefieldid FROM " . TABLE_PREFIX . "profilefield WHERE title='Quote Notification'");
$quoteuserquery = $vbulletin->db->query_first("SELECT user_table.userid AS userid, user_table.email AS email, 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");
$theurl = $vbulletin->options['bburl'] . "/showthread.php?p=" . $post['postid'] . "#post" . $post['postid'];
if ($quoteuserquery['wantquotenotify'] == "Private Message") {
// Override a potentially full inbox.
$senderpermissions['adminpermissions'] = 2;
$pmdm =& datamanager_init('PM', $vbulletin, ERRTYPE_ARRAY);

$qn_fromuserid = $vbulletin->userinfo['userid'];
$qn_fromusername = $vbulletin->userinfo['username'];
if ($vbulletin->options['quotenotify_sender'] > 0) {
$qn_fromuserid = $vbulletin->options['quotenotify_sender'];
$qn_fromtempuser = fetch_userinfo($qn_fromuserid);
$qn_fromusername = $qn_fromtempuser['username'];
}

$pmdm->set('fromuserid', $qn_fromuserid);
$pmdm->set('fromusername', $qn_fromusername);
$pmdm->set('title', $vbphrase['quotenotify_subject']);
$pmdm->set('message', construct_phrase($vbphrase['quotenotify_message'], $kr_load[$kr], $vbulletin->userinfo['username'], $kr_text[$kr], $theurl));
$pmdm->set_recipients($kr_load[$kr], $senderpermissions);
$pmdm->set('dateline', TIMENOW);

$pmdm->save();
//echo "curr url is " . $vbulletin->url;
//echo "send a pm to " . $kr_load[$kr] . "with contents " . $kr_text[$kr];
}
if ($quoteuserquery['wantquotenotify'] == "Email") {
vbmail($quoteuserquery['email'], $vbphrase['quotenotify_subject'], construct_phrase($vbphrase['quotenotify_emailmessage'], $kr_load[$kr], $vbulletin->userinfo['username'], strip_quotes($kr_text[$kr]), $theurl));
}
}
}
}


the alerted posts are still triggering a pm to the alerted person

Ahhh, my mistake. Looking into it, it turns out the $post variable doesn't have the forumid... change the first line I had you put in:
To the following:
When I did that on my server, it worked fine.

Thank you! That did it. GREAT NEW FEATURE !

is there a version for 3.6