vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Miscellaneous Hacks - Instant New Thread Notification (https://vborg.vbsupport.ru/showthread.php?t=141280)

WebmasterSimds 03-14-2007 06:24 AM

There is a problem with this and the Vboard Newer version. I get a BD error when someone wants to post, and here it is
================================================== ============
Database error in vBulletin 3.6.5:

Invalid SQL:

SELECT email, username
FROM user
WHERE userid IN ();

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 ')' at line 3
Error Number : 1064
Date : Wednesday, March 14th 2007 @ 03:20:43 AM
Script : http://www.xxxxxxx.com/Ss/newthread....stthread&f=324
Referrer : http://www.xxxxxxx.com/Ss/newthread....ewthread&f=324
IP Address : xx.xx.xx.82
Username : Someone
Classname : vb_database

================================================== ========

I edited options right after I installed it, and set the member groups that i wanteed to get instant notifications about any topic posted, but when its enabled this happens, when not enabled, its ok to post.

Any Ideas?

WebmasterSimds 03-14-2007 04:22 PM

So far your upgrade seemed to be working thanks.

I will Keep an eye on it to see how it goes, and if there are any more issues. I will let you know. I have a massive board. So this helps

RedTyger 03-14-2007 04:23 PM

It should be fine, but if you have a really huge board doesn't it take forever to actually post the thread? Even with a small mailing list it stalls quite a bit, you might want to look at a different solution.

WebmasterSimds 03-14-2007 04:36 PM

actually no, not at all. I have my own server, and enough power to handle situations like this. and it helps me to test its limits LOL

Tralala 03-16-2007 04:55 PM

I like that this has Admin options; thanks for sharing! Does it allow you to change the email subject and body via phrases too, like this older similar hack did?

RedTyger 03-16-2007 05:16 PM

Yes, it does. It's very much like that other modification with some additional optimisation and options.

Tralala 03-16-2007 06:54 PM

Quote:

Originally Posted by RedTyger (Post 1204987)
Yes, it does. It's very much like that other modification with some additional optimisation and options.

Thanks for the reply RedTyger. I did indeed find the newthreadsub phrase, and used the variables to make the email subject more verbose, namely:

PHP Code:

$vboptions[bbtitleSubscription$threadinfo[postusernameposted "$threadinfo[title]in $foruminfo[title_clean

I noticed this doesn't sends out the subscription email to the actual creator of the thread (even if they are subscribed to the forum...) which is smart and very cool.

I like this a lot, thanks for the excellent mod.

One thing about forum subscriptions though, it's not intuitive how to UNSUBSCRIBE. You can only do it from the UserCP. Wouldn't it make sense that for subscribed forums, this menu changed to say "Unsubscribe from this Forum" -- just like it works for Threads?
https://vborg.vbsupport.ru/external/2007/03/16.jpg

Is that something this hack could incorporate? I hope you like my suggestion. :)

HollyRidge 03-18-2007 12:30 AM

The version check hack is reporting the wrong version (https://vborg.vbsupport.ru/showthread.php?t=133366). It reports 1.01 when we downloaded and installed the 1.02 hack from here last night on a fresh vb install.

rjmjr69 03-18-2007 07:01 AM

-Reserved- great idea

RedTyger 03-18-2007 08:38 AM

Quote:

Originally Posted by HollyRidge (Post 1205955)
The version check hack is reporting the wrong version (https://vborg.vbsupport.ru/showthread.php?t=133366). It reports 1.01 when we downloaded and installed the 1.02 hack from here last night on a fresh vb install.

Thanks, fixed it. It makes no difference but you can use the new zip if you want.


Quote:

Originally Posted by rjmjr69 (Post 1206135)
-Reserved- great idea

What are you reserving? And why? :confused:


All times are GMT. The time now is 03:35 PM.

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.01216 seconds
  • Memory Usage 1,741KB
  • 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_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (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