vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Selective Forum Filter (https://vborg.vbsupport.ru/showthread.php?t=98360)

SteveC 02-16-2008 01:35 AM

Quote:

Originally Posted by Andy Rickard (Post 1444174)
Just installed this. After the initial install, the list of forums wouldn't populate, but saving the display order as suggested fixed the issue.

Works great.... thanks for the hack!!

still doesn't work for me and it used to work fine. Does it need to be reinstalled if you add a new forum?

Aquestor 02-18-2008 12:26 AM

Quote:

Originally Posted by Aquestor (Post 1442557)
Have the same Problem need this hack absolutly! Is there anyone who can resolve this problem?

Get this work need no help any more

jilly 05-03-2008 11:10 PM

I get this error message when trying to actually select the forums for exclusion

Database error in vBulletin 3.7.0:

Invalid SQL:
UPDATE usertextfield SET
excludeforumids = '18'
WHERE userid = 1;

MySQL Error : Unknown column 'excludeforumids' in 'field list'
Error Number : 1054
Request Date : Saturday, May 3rd 2008 @ 08:03:18 PM
Error Date : Saturday, May 3rd 2008 @ 08:03:18 PM
Script : http://www.mysite.org/profile.php?do=updateoptions
Referrer : http://www.mysite.org/profile.php?do=editoptions
Classname : vb_database
MySQL Version : 5.0.45-community

jilly 05-08-2008 04:29 PM

Quote:

Originally Posted by jilly (Post 1507457)
I get this error message when trying to actually select the forums for exclusion

Database error in vBulletin 3.7.0:

Invalid SQL:
UPDATE usertextfield SET
excludeforumids = '18'
WHERE userid = 1;

MySQL Error : Unknown column 'excludeforumids' in 'field list'
Error Number : 1054
Request Date : Saturday, May 3rd 2008 @ 08:03:18 PM
Error Date : Saturday, May 3rd 2008 @ 08:03:18 PM
Script : http://www.mysite.org/profile.php?do=updateoptions
Referrer : http://www.mysite.org/profile.php?do=editoptions
Classname : vb_database
MySQL Version : 5.0.45-community



I am guessing this means I need to manually add a field or column somewhere but I am clueless on how to do it - does anyone know?

Andreas 05-08-2008 05:16 PM

[sql]ALTER TABLE usertextfield ADD excludeforumids MEDIUMTEXT[/sql]
But the column should have been created automatically upon product install ...

dtv100 05-08-2008 05:36 PM

edit:
post in wrong thread sorry .

jilly 05-09-2008 10:26 AM

Quote:

Originally Posted by Andreas (Post 1512887)
[sql]ALTER TABLE usertextfield ADD excludeforumids MEDIUMTEXT[/sql]
But the column should have been created automatically upon product install ...

thank you, that fixed it! I don't know why it didnt take at first - I followed all the instructions - but that query fixed it - thanks!

shridevimoogi 11-03-2008 04:17 AM

Hi,

Can I make this hack controllable only by admin
and in conjunction I want to control forum list based on different domains,but the database remains one

Thanks

EagleNick 05-12-2009 07:10 PM

Not working on 3.8.2. I have ran the query multiple times and it confirms that the rows have been affected.

However, in the UserCP in the menu there is only one choice: "[Reset Exclusion]" and selecting it does nothing.
Hopefully somebody can offer a remedy.

akanevsky 06-01-2009 02:11 AM

The new version work better, so you might want to download it now. It works on 3.8.x, too.


All times are GMT. The time now is 09:54 AM.

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.01475 seconds
  • Memory Usage 1,739KB
  • 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
  • (4)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