New Posting Features - Maximum New Threads/Replies Per X hours Per Usergroup & Forum

Maximum New Threads/Replies Per X hours Per Usergroup & Forum Hack

Port of: https://vborg.vbsupport.ru/showthread.php?t=81584

• Description
  Control Maximum Number of New Threads and/or Reply allowed per Usergroup and Forum per defined time (in hours).
• Details
  1 Product XML with 4 Plugins, and 5 Phrases
• Install
  To install this hack simply download the xml file to your pc and then import it into vbulletin as a product - then from your ADMINCP go to Forums & Moderators -> Forum Permissions -> Whatever usergroup in any forum.
• History
  1.0.0 on 25. Sep 2005
  Initial Version for vBulletin 3.5
  
  1.0.1 on 7. Nov 2005
  Fixed bug with this
  -> to upgrade, import product-max_thread_post_per_xhour.xml and set Allow Overwrite to yes
  
  1.0.2 on 7. Feb 2006
  Fixed bug with this
  -> to upgrade, import product-max_thread_post_per_xhour.xml and set Allow Overwrite to yes
  
  1.0.3 on 4. Nov 2007
  No changes, just a version # update for vb 3.6.8
  -> to upgrade, import product-max_thread_post_per_xhour.xml and set Allow Overwrite to yes

[Omranic]

works good exept you try to access http://domain.com/forum/newreply.php

you will get the folowing database error ::

Database error in vBulletin 3.5.1:

Invalid SQL:
SELECT * FROM forumpermission
WHERE ( forumid IN() AND usergroupid IN (6)) AND
(maxpost=0 AND postperhour=0);

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 ') AND usergroupid IN (6)) AND
(maxpost=0 AND postperhour=0
Error Number : 1064
Date : Thursday, November 3rd 2005 @ 07:40:01 PM
Script : http://www.domain.com/vb/newreply.php
Referrer :
IP Address : 62.135.95.69
Username : SolidSnake@GTI
Classname : vb_database

[q8manar]

Originally Posted by SolidSnake@GTI

works good exept you try to access http://domain.com/forum/newreply.php

you will get the folowing database error ::

Database error in vBulletin 3.5.1:

Invalid SQL:
SELECT * FROM forumpermission
WHERE ( forumid IN() AND usergroupid IN (6)) AND
(maxpost=0 AND postperhour=0);

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 ') AND usergroupid IN (6)) AND
(maxpost=0 AND postperhour=0
Error Number : 1064
Date : Thursday, November 3rd 2005 @ 07:40:01 PM
Script : http://www.domain.com/vb/newreply.php
Referrer :
IP Address : 62.135.95.69
Username : SolidSnake@GTI
Classname : vb_database

Same problem

Any body can fix this

[Omranic]

Sorry ....
Uninstalled till any coder fix it ....

[rezovor]

Works perfect for me, Thanks!

[uae]

Originally Posted by SolidSnake@GTI

works good exept you try to access http://domain.com/forum/newreply.php

you will get the folowing database error ::

Database error in vBulletin 3.5.1:

Can you please try improting the latest v1.0.1 xml file with Allow Overwrite to yes.

[q8manar]

I Download the updated one and I uploaded to my forum as yes overwrite

but the problem still
an error in db comes
when the user try to go to http://www.q8manar.com/vb/newthread.php

[Omranic]

good work
thanks

Re-installed

[Omranic]

sory for the second time

Database error in vBulletin 3.5.1:

Invalid SQL:
SELECT * FROM forumpermission
WHERE ( forumid IN() AND usergroupid IN (6)) AND
(maxthread=0 AND perhour=0);

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 ') AND usergroupid IN (6)) AND
(maxthread=0 AND perhour=0)' a
Error Number : 1064
Date : Sunday, November 20th 2005 @ 05:15:58 PM
Script : http://domain.com/vb/newthread.php
Referrer :
IP Address : XX.XXX.XXX.XXX
Username : SolidSnake@GTI
Classname : vb_database

[PatrickAdrichem]

Is it possible to edit this to a per user/group set config that goes over ALL forums? because now they can post 10 per forum and i want them to post 10 total

[Puntoboy]

i seem to get getting a database error now...

Database error in vBulletin 3.5.2:

Invalid SQL:
SELECT * FROM vb3_forumpermission 
	WHERE ( forumid IN() AND usergroupid IN (1)) AND 
	(maxthread=0 AND perhour=0);

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 ') AND usergroupid IN (1)) AND 
	(maxthread=0 AND perhour=0)' a
Error Number : 1064
Date         : Monday, January 23rd 2006 @ 01:51:46 PM
Script       : http://www.puntosports.co.uk/forums/newthread.php?do=Application
Referrer     : http://www.puntosports.co.uk/club_join.htm
IP Address   : 82.37.156.173
Username     : Unregistered
Classname    : vb_database