vb.org Archive - Quote Notification

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - Quote Notification (https://vborg.vbsupport.ru/showthread.php?t=112498)

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?

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=

^ 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

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");

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.

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");

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");

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");

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
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (13)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01090 seconds Memory Usage 1,754KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (13)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: