Rules per Forum

vBHacker file attached.

What it does: instead of (or in addition to) just having global rules, rules can be defined per forum. For example, in a "Support" forum, the rules can be "No random threads, general chatter should be in [link to forum].". Only admins can edit the rules, and only people who have access to view the forum can view the rules as well.

Upload showrules.php to your forums' root directory.

[SmartGnome]

For me it works now on 2.3.0 for existing forums, when I create a new forum I get the following sql error

 
Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: INSERT INTO forum
                      (forumid,styleid,title,description,active,displayorder,parentid,
                       parentlist,allowposting,cancontainthreads,daysprune,newpostemail,newthreademail,
                       moderatenew,allowhtml,allowbbcode,allowimages,allowsmilies,allowicons,
                       styleoverride,allowratings,countposts,moderateattach,storereply,storethread,mustread,mustreadtext,private,rulestext)
                   VALUES
                      (NULL,'1','Neue Sachen ins Board','Here we announce new optioins in the board and eplain how it works.','1','1','118',
                       '','1','1','30','postings@krissiweb.net','postings@krissiweb.net',
                       '0','0','1','1','1','1',
                       '0','1','1','0', '','','0','','1',)
mysql error: You have an error in your SQL syntax near ')' at line 10

mysql error number: 1064

Date: Wednesday 09th of April 2003 10:02:55 AM
Script: http://forum.krissiweb.org/board/board/admin/forum.php
Referer: http://forum.krissiweb.org/board/adm...hp?action=add&

Who can help me please ???


Cheers

[Frozen Dreams]

I am getting the same SQL error at 2.2.9
Please someone - help

[solent]

ok beacuse i myself using vb2.3.0 i had the same problem and i went and fix the problem in the insert query. i recon it was a typing error.

anyway.

edit admin/forum.php

PHP Code:

find this bit of code

$DB_site->query("INSERT INTO forum
(forumid,styleid,title,description,active,displayorder,parentid,
parentlist,allowposting,cancontainthreads,daysprune,newpostemail,newthreademail,
moderatenew,allowhtml,allowbbcode,allowimages,allowsmilies,allowicons,
styleoverride,allowratings,countposts,moderateattach)
VALUES
(NULL,'$styleset','".addslashes($title)."','".addslashes($description)."','$isactive','$displayorder','$parentid',
'','$allowposting','$cancontainthreads','$daysprune','".addslashes($newpostemail)."','".addslashes($newthreademail)."',
'$moderatenew','$aallowhtmlcode','$aallowbbcode','$aallowimgcode','$aallowsmilies','$aallowicons',
'$styleoverride','$allowratings','$countposts','$moderateattach'");


and replayce with this

$DB_site->query("INSERT INTO forum
(forumid,styleid,title,description,rulestext,active,displayorder,parentid,
parentlist,allowposting,cancontainthreads,daysprune,newpostemail,newthreademail,
moderatenew,allowhtml,allowbbcode,allowimages,allowsmilies,allowicons,
styleoverride,allowratings,countposts,moderateattach)
VALUES
(NULL,'$styleset','".addslashes($title)."','".addslashes($description)."','".addslashes($rulestext)."','$isactive','$displayorder','$parentid',
'','$allowposting','$cancontainthreads','$daysprune','".addslashes($newpostemail)."','".addslashes($newthreademail)."',
'$moderatenew','$aallowhtmlcode','$aallowbbcode','$aallowimgcode','$aallowsmilies','$aallowicons',
'$styleoverride','$allowratings','$countposts','$moderateattach')"); 


[PurpleCow]

Is the instructions given in the text file by spaceb and the mysql error solution mentioned in the previous post working fine on 2.3.0 ?/

I want this hack

Thanks