Miscellaneous Hacks - VSa - Advanced Permissions Based on Post Count

Info:

This product allows you to set permissions based on user’s post count for:
-viewing forum (threads listing),
-viewing threads content,
-creating new threads,
-replying to threads,
-viewing attachments,
-Viewing/Posting links/images and e-mail addresses,
-adding links to signatures
-voting on polls,
-sending private messages,
-sending e-mails,
-posting Visitor messages
-viewing Albums
-creating new Albums
-posting Picture comments
-viewing Social Groups
-creating new Social Groups
-posting Group messages

This will disallow members with no permissions to view forums/threads/posts/links through normal view, printthread, search, archive, thread preview. Note that you can set Forum/Thread Permissions for each forum/sub-forum separately. Screenshot shows additional options in Forum Manager and error messages shown to user when trying to view restricted area.

How it works and why it's better than vB Promotions system?!
Forum is shown on forumhome but with "Locked" icon and if you have no needed post count you'll get "no permission" error message. When you set this via vB Promotions system forum is hidden on forumhome and you must create additional usergroup to make all this working. When user collect needed amount of posts he will be able to access protected forum immediately. When you set this via vB Promotions system then user must wait until Promotions task is executed ... then he will be able to access protected forum. How much time user must wait it depends on settings in AdminCP/Scheduled Tasks... and if you set this to run every minute it pushes your server. If you set it to 2 or more minutes then user must wait more and more... and nobody like it.

Installation:
Import XML file (as product) through AdminCP > Plugin System > Manage Products > [Add/Import Product]

Versions:
v1.0 - Sep 16.2005.
-First release
v4.4 - Jun 19. 2008.
-Latest 3.x version
v5.0 - Jan 23. 2010.
-Updated for vBulletin 4.x
-Option to hide or not "Last post info"
-Minor bugs fixed...
-Mod prefix (Cyb) changed to 'VSa'
v5.1 - May 02. 2010.
-Fixed: LPI hidden for excluded groups
-Fixed: Upgrade errors (vB3.x to vB4.x)
-Fixed: Some PHP errors, and minor bugs
v5.2 - May 26. 2012.
-New: Permissions applied to What's New/Activity streams
-New: Permissions applied to subscription logs in member profiles
-New: Warnings in messages replaced by "Hidden Content" where you get more info on click
-New: Disallow links/emails in signatures
-New: Disallow voting on polls
-Fixed: Threads visible in Search results
-Fixed: Links visible in post search results
-Fixed: Links visible in subscription emails
-Fixed: SendPM possible via BCC
-Fixed: PHP 5.3 errors
-Fixed: Style issues on "set all forums" page
-Fixed: Signature perminfo errors
-Fixed: Forum locks
-Fixed: Minor bugs
v5.2.1 - Jun 02. 2012.
-Minor bug fixed (submit form error phrase)

[Parafal]

Any fix for the reported bug for the VB4.0.3?
This is a must have MOD for me, but I'm using VB4.0.3 and I'm not a tech-php guy. :-(

[Valter]

What bug?

zelnik,

what db error?

Ensure that you have no two instances of this product installed (vB4 one + old one for vB3 with 'Cyb' prefix).

[CvP]

new settings compared to 3.8 version are awesome!

is there any way to disable blog posting based on post count?

[marshal_ramdev]

thanks ...

[zelnik]

Originally Posted by Valter

What bug?

zelnik,

what db error?

Ensure that you have no two instances of this product installed (vB4 one + old one for vB3 with 'Cyb' prefix).

I have uninstalled the vb3 version before installing the vb4 version if that's what you mean?

The following is the SQL error:

Database error in vBulletin 4.0.3:

Invalid SQL:
UPDATE forum SET
title_clean = 'Latest News & Sport From Espana',
title = 'Latest News & Sport From Espana',
description_clean = 'The latest news headlines.',
description = 'The latest news headlines.',
link = '',
displayorder = 1,
parentid = 49,
daysprune = -1,
defaultsortfield = 'lastpost',
defaultsortorder = 'desc',
showprivate = 0,
newpostemail = '',
newthreademail = '',
### Bitfield: forum.options ###
options = IF(options & 8, options - 8, options),
options = IF(options & 16, options - 16, options),
options = IF(options & 32, options, options + 32),
options = IF(options & 32768, options - 32768, options),
options = IF(options & 8192, options, options + 8192),
options = IF(options & 4, options, options + 4),
options = IF(options & 1, options, options + 1),
options = IF(options & 2, options - 2, options),
options = IF(options & 16384, options, options + 16384),
options = IF(options & 256, options, options + 256),
options = IF(options & 64, options, options + 64),
options = IF(options & 128, options, options + 128),
options = IF(options & 512, options, options + 512),
options = IF(options & 1024, options, options + 1024),
options = IF(options & 2048, options, options + 2048),
options = IF(options & 4096, options, options + 4096),
options = IF(options & 65536, options, options + 65536),
options = IF(options & 131072, options - 131072, options),
styleid = 0,
imageprefix = '',
password = '',
vbseo_moderatepingbacks = 1,
vbseo_moderatetrackbacks = 1,
vbseo_moderaterefbacks = 1,
accessf_nb = 0,
accesst_nb = 0,
create_nb = 0,
reply_nb = 0,
linkview_nb = 0,
linkpost_nb = 0,
enable_recipe = '0'
WHERE forumid = 33;

MySQL Error : Unknown column 'accessf_nb' in 'field list'
Error Number : 1054
Request Date : Wednesday, April 21st 2010 @ 07:47:25 PM
Error Date : Wednesday, April 21st 2010 @ 07:47:25 PM
Script : http://www.mysite.com/forum/admincp/forum.php?do=update
Referrer : http://www.mysite.com/forum/admincp/...o=edit&f=33&s=
IP Address : 7x.xx.xx.xx
Username : xxxxx
Classname : vB_Database
MySQL Version : 5.0.45-log

[Valter]

You may uninstalled old version AFTER installing new one for vB4, as you are missing database field required by this product to work properly.

If it's not big problem for you uninstall/re-install product to re-create required fields.

[Dave-M]

I had the same database error as the others in this thread, but I can confirm that uninstalling and reinstalling fixed this.

[coffee]

Valter, I need to add permissions described here:
https://vborg.vbsupport.ru/showthread.php?t=240124

Could you please tell me what you think?

[Valter]

v5.1 - May 02. 2010.
-Fixed: LPI hidden for excluded groups
-Fixed: Upgrade errors (vB3.x to vB4.x)
-Fixed: Some PHP errors, and minor bugs

To upgrade:
-Import XML, allow overwrite
-Revert product templates if modified

Note:
-There are important changes in this version, please upgrade soon

[Manoel J?nior]

wow. nice mod. thank you