The Arcive of Official vBulletin Modifications Site.

Quote Notification · **Released**: 04-07-2006

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 · #22 07-01-2006, 04:48 AM

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.

dan35 · #23 07-01-2006, 06:11 PM

How about email notifications instead of pm notifications?

Krofh · #24 07-02-2006, 04:10 AM

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?

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.

Krofh · #25 07-07-2006, 09:22 PM

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.

dan35 · #26 07-08-2006, 01:55 AM

Thank you, Krofh! Installed

VietPirates · #27 10-01-2006, 07:42 AM

Any update for 3.6?

Code:

Invalid SQL:
SELECT profilefieldid FROM profilefield WHERE title='Quote Notification';

MySQL Error  : Unknown column 'title' in 'where clause'
Error Number : 1054
Date         : Sunday, October 1st 2006 @ 03:43:35 AM
Script       : http://www.domain.com/admincp/plugin.php?do=productkill
Referrer     : http://www.domain.com/admincp/plugin.php?do=productdelete&productid=quotenotify&s=

can't unisntall it.

Code:

Database error in vBulletin 3.6.0:

Invalid SQL:
SELECT profilefieldid FROM profilefield WHERE title='Quote Notification';

MySQL Error  : Unknown column 'title' in 'where clause'
Error Number : 1054
Date         : Sunday, October 1st 2006 @ 03:44:29 AM
Script       : http://www.domain.com/admincp/plugin.php?do=productkill
Referrer     : http://www.domain.com/admincp/plugin.php?do=productdelete&productid=quotenotify&s=

Krofh · #28 10-02-2006, 04:57 AM

^ 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:

Code:

$db->query_write("ALTER TABLE " . TABLE_PREFIX . "profilefield ADD title VARCHAR (255)");
$db->query_write("UPDATE TABLE " . TABLE_PREFIX . "profilefield SET title='Quote Notification' where profilefieldid='[insert profilefieldid here]'");

and this at the end

Code:

$db->query_write("ALTER TABLE " . TABLE_PREFIX . "profilefield DROP title");

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

VietPirates · #29 10-03-2006, 09:16 AM

Thank you, Krofh!

But got this error:

Code:

Invalid SQL:
UPDATE TABLE profilefield SET title='Quote Notification' where profilefieldid='[insert profilefieldid here]';

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 'TABLE profilefield SET title='Quote Notification' where profilefieldid='[insert ' at line 1
Error Number : 1064

Tried again:

Code:

Invalid SQL:
ALTER TABLE profilefield ADD title VARCHAR (255);

MySQL Error  : Duplicate column name 'title'
Error Number : 1060

Uninstall Code:

Code:

$db->query_write("ALTER TABLE " . TABLE_PREFIX . "profilefield ADD title VARCHAR (255)");
$db->query_write("UPDATE TABLE " . TABLE_PREFIX . "profilefield SET title='Quote Notification' where profilefieldid='[insert profilefieldid here]'");
$gettheid = $db->query_first("SELECT profilefieldid FROM " . TABLE_PREFIX . "profilefield WHERE title='Quote Notification'");
$db->query_write("DELETE FROM " . TABLE_PREFIX . "profilefield WHERE profilefieldid='" . $gettheid['profilefieldid'] . "' LIMIT 1");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "userfield DROP field" . $gettheid['profilefieldid']);
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "profilefield DROP title");

Krofh · #30 10-04-2006, 04:11 AM

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

Code:

$db->query_write("ALTER TABLE " . TABLE_PREFIX . "profilefield ADD title VARCHAR (255)");

line out of it, and try again after fixing the number like I just said.

VietPirates · #31 10-05-2006, 04:37 AM

My profilefield is field21

Error:

Code:

Invalid SQL:
UPDATE TABLE profilefield SET title='Quote Notification' where profilefieldid='[field21]';

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 'TABLE profilefield SET title='Quote Notification' where profilefieldid='[field21' at line 1
Error Number : 1064

Unisntall Code:

Code:

$db->query_write("UPDATE TABLE " . TABLE_PREFIX . "profilefield SET title='Quote Notification' where profilefieldid='[field21]'");
$gettheid = $db->query_first("SELECT profilefieldid FROM " . TABLE_PREFIX . "profilefield WHERE title='Quote Notification'");
$db->query_write("DELETE FROM " . TABLE_PREFIX . "profilefield WHERE profilefieldid='" . $gettheid['profilefieldid'] . "' LIMIT 1");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "userfield DROP field" . $gettheid['profilefieldid']);
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "profilefield DROP title");

or

Code:

$db->query_write("UPDATE TABLE " . TABLE_PREFIX . "profilefield SET title='Quote Notification' where profilefieldid='[21]'");
$gettheid = $db->query_first("SELECT profilefieldid FROM " . TABLE_PREFIX . "profilefield WHERE title='Quote Notification'");
$db->query_write("DELETE FROM " . TABLE_PREFIX . "profilefield WHERE profilefieldid='" . $gettheid['profilefieldid'] . "' LIMIT 1");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "userfield DROP field" . $gettheid['profilefieldid']);
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "profilefield DROP title");

or

Code:

$db->query_write("UPDATE TABLE " . TABLE_PREFIX . "profilefield SET title='Quote Notification' where profilefieldid='field21'");
$gettheid = $db->query_first("SELECT profilefieldid FROM " . TABLE_PREFIX . "profilefield WHERE title='Quote Notification'");
$db->query_write("DELETE FROM " . TABLE_PREFIX . "profilefield WHERE profilefieldid='" . $gettheid['profilefieldid'] . "' LIMIT 1");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "userfield DROP field" . $gettheid['profilefieldid']);
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "profilefield DROP title");

or

Code:

$db->query_write("UPDATE TABLE " . TABLE_PREFIX . "profilefield SET title='Quote Notification' where profilefieldid='21'");
$gettheid = $db->query_first("SELECT profilefieldid FROM " . TABLE_PREFIX . "profilefield WHERE title='Quote Notification'");
$db->query_write("DELETE FROM " . TABLE_PREFIX . "profilefield WHERE profilefieldid='" . $gettheid['profilefieldid'] . "' LIMIT 1");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "userfield DROP field" . $gettheid['profilefieldid']);
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "profilefield DROP title");

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04755 seconds Memory Usage 2,322KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (13)bbcode_code (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (11)post_thanks_box (1)post_thanks_box_bit (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start fetch_musername post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end post_thanks_function_fetch_thanks_bit_start post_thanks_function_show_thanks_date_start post_thanks_function_show_thanks_date_end post_thanks_function_fetch_thanks_bit_end post_thanks_function_fetch_post_thanks_template_start post_thanks_function_fetch_post_thanks_template_end postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

Благодарность от:
JohorBahru

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!