Version: 1.0.2, by Krofh
Developer Last Online: Jun 2013
Version: 3.5.4
Rating:
Released: 04-07-2006
Last Update: 07-06-2006
Installs: 39
DB Changes Uses Plugins
No support by the author.
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.
Show Your Support
This modification may not be copied, reproduced or published elsewhere without author's permission.
Remove the following line from the newpost_complete Quote Notification plugin as it's not needed.
PHP Code:
$quotegetfieldquery = $vbulletin->db->query_first("SELECT profilefieldid FROM " . TABLE_PREFIX . "profilefield WHERE title='Quote Notification'");
and modify the following line...
PHP Code:
$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");
replacing
PHP Code:
" . $quotegetfieldquery['profilefieldid'] . "
with the Quote Notification profile field id number.
Remove the following line from the newpost_complete Quote Notification plugin as it's not needed.
PHP Code:
$quotegetfieldquery = $vbulletin->db->query_first("SELECT profilefieldid FROM " . TABLE_PREFIX . "profilefield WHERE title='Quote Notification'");
and modify the following line...
PHP Code:
$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");
replacing
PHP Code:
" . $quotegetfieldquery['profilefieldid'] . "
with the Quote Notification profile field id number.
Remove the following line from the newpost_complete Quote Notification plugin as it's not needed.
PHP Code:
$quotegetfieldquery = $vbulletin->db->query_first("SELECT profilefieldid FROM " . TABLE_PREFIX . "profilefield WHERE title='Quote Notification'");
and modify the following line...
PHP Code:
$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");
replacing
PHP Code:
" . $quotegetfieldquery['profilefieldid'] . "
with the Quote Notification profile field id number.
I'm not quite understanding those instructions...
the 2nd edit... How do you modify? And the last edit... What is the "profile field id number"?
the instructions you gave for upgrading the quote notification hack are a teeny bit sparse for me.
our real tech admin quit and that means i am the one stuck with upgrading out plugins to 3.6 and i am struggling. could you look at this and tell me what i have done wrong?
based on the first line of code, i assumed that forum id number was 65.
Quote:
if ($threadinfo['forumid'] != 65) {
so i substitued as per instruction
Quote:
$quoteuserquery = $vbulletin->db->query_first("SELECT user_table.userid AS userid,
user_table.email AS email, profile_fields.field 65 AS wantquotenotify
but i am obviously wrong . can you help? i only have a three day pass here... from the owner to try and get all this stuff figured out.
Not forum id, field id.
From the Admin interface, User Profile Fields -> User Profile Field Manager. Look for "Quote Notification". Under the name column is the field number.
Mine is field number 21 so I have "profile_fields.field21".
Quote Notification Details »»
About Developer
DB Changes 
No support by the author.
12-18-2006, 05:40 PM
