vb.org Archive
Page 5 of 11 « First 34 5 67 Last »
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".


All times are GMT. The time now is 04:35 AM.
Page 5 of 11 « First 34 5 67 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01427 seconds
  • Memory Usage 1,767KB
  • 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
  • (9)bbcode_php_printable
  • (6)bbcode_quote_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