vb.org Archive - Quote Notification

Page 2 of 3

Show 40 post(s) from this thread on one page

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)

vbreal

11-20-2006 08:59 PM

can anyone port this over to 3.6

Konstantinos

12-18-2006 05:40 PM

it doesnt work for 3.6.4 Database error in vBulletin 3.6.4:

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

MySQL Error : Unknown column 'title' in 'where clause'
Error Number : 1054

SpankMe

12-19-2006 12:42 AM

I got it working in 3.6 ok. I'll dig up what I did and post it soon.

Konstantinos

12-21-2006 12:28 PM

Quote:

Originally Posted by SpankMe (Post 1141335)

I got it working in 3.6 ok. I'll dig up what I did and post it soon.

di u have the fix ?

SpankMe

12-24-2006 01:06 AM

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.

HPIA	12-27-2006 05:27 AM

I would love someone to port this to 3.6 :D

Konstantinos

12-27-2006 06:55 AM

Quote:

Originally Posted by SpankMe (Post 1144251)

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.

great it works by the way do u have a fix for this https://vborg.vbsupport.ru/showthread.php?t=93138 or if u can make one i ll send u some cash

PoetJA-1975

01-22-2007 05:33 PM

Quote:

Originally Posted by SpankMe (Post 1144251)

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"?

Trying to get this to work for 3.6.4

Thanx

JAcquii.

PoetJA-1975

01-26-2007 06:09 PM

hello?

SpankMe

02-23-2007 09:21 PM

Quote:

Originally Posted by distractme

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".

SpankMe

02-23-2007 09:27 PM

Also everyone should put.

PHP Code:


		
			
$pmdm->overridequota = true;

below

PHP Code:


		
			
$pmdm =& datamanager_init('PM', $vbulletin, ERRTYPE_ARRAY);

in the plugin. This will prevent the user getting an error when quoting a member who has disabled PMs in his profile, but has quote PMs turned on.

Renada

02-24-2007 02:08 AM

Quote:

Originally Posted by SpankMe (Post 1189370)

Also everyone should put.

PHP Code:


		
			
$pmdm->overridequota = true;

below

PHP Code:


		
			
$pmdm =& datamanager_init('PM', $vbulletin, ERRTYPE_ARRAY);

in the plugin. This will prevent the user getting an error when quoting a member who has disabled PMs in his profile, but has quote PMs turned on.

Hi,

Do you know what changes would need to be made to install this from scratch on a 3.6 board?

Regards,
Renada

distractme

02-25-2007 05:38 PM

Quote:

Originally Posted by SpankMe (Post 1189365)

Thank you! It worked and I will be a hero. :)

Follie Folli

03-23-2007 11:57 AM

i have installed this modification some months ago but now i can't remove it .

i have a database error when i try to delete this modification

can you help me?

vbreal

03-26-2007 07:52 PM

i looked for this for 3.6, was tihs done?

provedel

06-20-2007 03:27 PM

Same problem here, can't uninstall... :(

And this plugin cause errors on my admincp.

Please, any person can tell me how I can remove this plugin manually?

Here is error I get when tried to remove:

Code:

Database error in vBulletin 3.6.7:



Invalid SQL:

SELECT profilefieldid FROM profilefield WHERE title='Quote Notification';



MySQL Error  : Unknown column 'title' in 'where clause'

Error Number : 1054

Date         : Wednesday, June 20th 2007 @ 12:26:39 PM

Script       : http://forum.plurall.org/admincp/plugin.php?do=productkill

Referrer     : http://forum.plurall.org/admincp/plugin.php?do=productdelete&productid=quotenotify&s=

IP Address   : 201.37.210.158

Username     : Sauron

Classname    : vb_database

Quote:

Originally Posted by Follie Folli (Post 1210301)

i have installed this modification some months ago but now i can't remove it .

i have a database error when i try to delete this modification

can you help me?

vbreal

01-29-2008 05:19 PM

I have the same issue. i can't remove it. i would love to see this in 3.6 though.

does anyone know how to remove it?

Breathex

05-02-2008 06:36 PM

How can we use it for 3.7.x?

Konstantinos

05-03-2008 09:06 AM

u can delete the plugin via plugin manager

AcidX

05-17-2008 05:22 PM

Still no port for 3.6? :(

Breathex

05-30-2008 11:37 PM

Quote:

Originally Posted by Breathex (Post 1506026)

How can we use it for 3.7.x?

Any answers? This is a great plugin, but not working in 3.7 :(

SpankMe

05-31-2008 12:39 AM

This is what I have in my Quote Notification newpost_complete plugin. Works fine in 3.7 and worked in 3.6 to. You just need to change the field id number "profile_fields.field21" to whatever your custom profile field number is on your forums.

PHP 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'])) {

            if (!in_array($matches[1][$kr], $kr_load)) {

                $kr_load[] = $matches[1][$kr];

                $kr_text[] = "[quote=".$matches[1][$kr]."]".$matches[2][$kr]."[/quote]";

            }

            else {

                for ($kri=0;$kri<count($kr_load);$kri++) {

                    if ($kr_load[$kri] == $matches[1][$kr]) {

                        $kr_text[$kri] .= "[quote=".$matches[1][$kr]."]".$matches[2][$kr]."[/quote]";

                        break;

                    }

                }

            }

        }

    }

}

if (count($kr_load) > 0) {

    for ($kr=0;$kr<count($kr_load);$kr++) {

        //echo "<br>" . $kr_load[$kr];

        $quoteuserquery = $vbulletin->db->query_first("SELECT user_table.userid AS userid, profile_fields.field21 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'] == "Yes") {

            // Override a potentially full inbox.

            $senderpermissions['adminpermissions'] = 2;

            $pmdm =& datamanager_init('PM', $vbulletin, ERRTYPE_ARRAY);



            $pmdm->overridequota = true;

            $pmdm->set('fromuserid', $vbulletin->userinfo['userid']);

            $pmdm->set('fromusername', $vbulletin->userinfo['username']);

            $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];

        }

    }

}

Breathex

06-08-2008 01:53 AM

Thanks for the reply, and how will i install it? Any updated xml file?

SpankMe

06-08-2008 03:34 AM

The only thing I have changed since I installed it in 3.5, is the above plugin. I have no idea if the original xml will install in 3.7. But the three things you need to install (phrases, custom profile field & plugin) can be installed manually through the admincp.

Konstantinos

06-25-2008 08:22 PM

this is very usefull hack. however i need to stop it sending quote notification that comes from users that are added to tachy goes to conventry.

meaning when users who are added to coventry when quoting normail members.

anyway for this SpankMe?

Breathex

06-30-2008 02:02 PM

Quote:

Originally Posted by SpankMe (Post 1543716)

...and also i tried to install it manually but it gives database error in 3.7.2 :/

SpankMe

06-30-2008 10:57 PM

Quote:

Originally Posted by Breathex (Post 1563042)

...and also i tried to install it manually but it gives database error in 3.7.2 :/

What gives you a database error? and whats the error?

Breathex

07-01-2008 10:12 PM

It gives this error;

PHP Code:


		
			
Database error in vBulletin 3.7.2:



Invalid SQL:

INSERT INTO vb3_profilefield (title, description, required, hidden, maxlength, size, displayorder, editable, type, data, height, def, optional, searchable, memberlist, regex, form, html) VALUES ('Quote Notification', 'Would you like to be notified by PM when someone quotes something you said in a post?', '0', '1', '250', '25', '100', '1', 'radio', 'a:2:{i:0;s:2:"No";i:1;s:3:"Yes";}', '0', '1', '0', '0', '0', '', '2', '0');



MySQL Error   : Unknown column 'title' in 'field list'

Error Number  : 1054

Request Date  : Wednesday, July 2nd 2008 @ 01:09:19 AM

Error Date    : Wednesday, July 2nd 2008 @ 01:09:19 AM

Script        : http://xxxxxx/admincp/plugin.php?do=productimport

Referrer      : http://xxxxxx/admincp/plugin.php?do=productadd

IP Address    : 85.108.150.135

Username      : xxxxxx

Classname     : vB_Database

MySQL Version : 5.0.58

SpankMe

07-02-2008 05:24 AM

Quote:

Originally Posted by Breathex (Post 1564317)

It gives this error;

Looks like you tried to import the product instead of installing it manually.

Breathex

07-02-2008 10:05 PM

Quote:

(phrases, custom profile field & plugin)

*** How will i install phrases?
*** what will i enter to the boxes in "Add New Plugin" and "Add a Profile Field" menu?

I think i need a guidance :o I didn't add an add-on in this way before, sorry.

Breathex

08-06-2008 02:45 AM

Any suggestions?

SpankMe

08-06-2008 04:31 AM

Quote:

Originally Posted by Breathex (Post 1592336)

Any suggestions?

Make a copy of your site for testing, and start playing. :)

Konstantinos

09-27-2008 06:25 AM

Quote:

Originally Posted by SpankMe (Post 1543716)

it doesnt install in 3.7 and if added manually u dont have the setting who's gonna send the pm from

SpankMe

09-27-2008 07:44 AM

Just noticed the AdminCP options are no longer there. I guess the settings in the database must be still there from when I installed it in vB 3.5.

Konstantinos

09-27-2008 09:17 AM

yeah happens in my old forum as well but i want to install it in a new forum now, it shouldnt be hard to be fixed and this mod is great cause it really boosts discussion

SpankMe

09-30-2008 11:51 PM

It's a simple mod, so I will look at updating the product install to work on 3.7 as soon as I have some spare time.

SpankMe

10-17-2008 11:41 PM

ok, here's the product install for 3.7.

If you already have this mod installed, first delete the existing Quote Notification Profile Field.

Then just install this product. Click Allow Overwrite if you have the old version installed.

Let me know how it goes. I've only tested on vB 3.7.2.

Renada

10-17-2008 11:53 PM

Thank you very much :)

SpankMe

10-18-2008 12:23 AM

Previous product attachment didn't work in 3.7.1, so have modified and updated attachment in previous post.

Konstantinos

11-08-2008 06:00 AM

Quote:

Originally Posted by SpankMe (Post 1647364)

Quote Notification Sender option doest show in vbsettings

All times are GMT. The time now is 01:34 PM.

Page 2 of 3

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01593 seconds Memory Usage 1,914KB 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 (1)bbcode_code_printable (15)bbcode_php_printable (17)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)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: