Allow Usergroups to Post HTML

Just like the name says, this ultra-simple little Product will allow you to specify Usergroups that may post in HTML and have that HTML be parsed...SOME PEOPLE ARE HAVING TABLE PROBLEMS - THIS IS UNSUPPORTED USEAGE OF THE MODIFICATION AND I AM UNABLE TO ASSIST!

***BE AWARE THAT INDISCRIMINATE USE OF THIS HACK IS RISKY - RESTRICT IT TO ONLY THOSE USERGROUPS YOU TRUST ABSOLUTELY***

The scary message above is to make sure you are aware that enabling HTML for any group opens you up to security issues. This is why it is not a feature of Stock vB, probably.

I decided I needed to have the ability to post in HTML because I just installed ZT's RSS Feeds hack, and the ones I got from Google looked all horrible.

Now updated to be controlled by a Setting in Usergroup Manager, it's phrased and even works in editpost.php (preview) in WYSIWYG and normal modes, AND the Forum Rules shows HTML is ON.

This will not work retroactively. That is, if a User posted something in HTML before they were given the ability, that post has to be edited by that member (or someone else with HTML ability) in order to be parsed. I am assuming this is due to post caching.

Many thanks to Kirby for prodding me to figure it out by myself and not just telling me what to do.

A "demo" is here..html is OFF in that Forum, but the post is made by an Admin, so the HTML is parsed.

[Andreas]

1) Uninstall
2) Upload the bitfield XML to includes/xml
3) Install

This is necessary, otherwise the bitfield cache will not get rebuilt resulting in errors in usergroup manager

[-=Sniper=-]

thanks man, this should be a default feature really.

[Tulsa]

Yep, working great!

[Vtec44]

Originally Posted by Andreas

Once again:
If you uninstall Hack the use custom Bitfields you must always delete the Bitfield XML before uninstalling it.

I deleted the bitfield_allowhtml.xml, then uninstalled the product, and got the error message below when creating a new user group:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO sbnvb_usergroup
(`title`, `description`, `usertitle`, `opentag`, `closetag`, `passwordexpires`, `passwordhistory`, `ispublicgroup`, `canoverride`, `forumpermissions`, `attachlimit`, `pmquota`, `pmpermissions`, `pmsendmax`, `calendarpermissions`, `wolpermissions`, `adminpermissions`, `genericpermissions`, `genericoptions`, `profilepicmaxwidth`, `profilepicmaxheight`, `profilepicmaxsize`, `avatarmaxwidth`, `avatarmaxheight`, `avatarmaxsize`, `allowhtmlpermissions`, `maxsiglines`, `maxsigfontsize`, `maxsigimgsize`, `maxsigimgwidth`, `maxsigimgheight`, `maxsigimages`, `sigforbiddencodes`, `custompermissions`)
VALUES
('test', '', '', '', '', '', '', '0', '0', '651271', '1000000', '0', '0', '5', '0', '1', '0', '2626563', '9', '100', '100', '25000', '50', '50', '20000', '0', '', '', '', '', '', '', '', '0');

MySQL Error  : Unknown column 'allowhtmlpermissions' in 'field list'
Error Number : 1054

[davidms]

Hey everone, I'm brand new to this, and I'm not sure how to install this plugin is there several 'hooks' that I install on this plugin or do I only install 2, - 1 for each file? (there are only two files in the plugin)

I read the general forum instructions for plugins, but I'm still not sure what to do. I'm not sure how to install this plugin.

Dave :nervous:

[craigbrass]

I just installed the product. Thanks for it!!

But I've found a bug. I posted some announcements a while ago and formatted them in HTML. Then I installed this plugin, and suddenly my announcements were plain text. There was no HTML format.

I hope you can fix this problem soon.

Thanks!

[hydrostatic]

When trying to uninstall as Andreas suggested, it gives me another SQL error

Database error in vBulletin 3.5.0:

Invalid SQL:
ALTER TABLE vb3_usergroup DROP allowhtmlpermissions;

MySQL Error  : Can't DROP 'allowhtmlpermissions'; check that column/key exists
Error Number : 1091
Date         : Friday, October 21st 2005 @ 12:10:26 AM
Script       : http://www.blootix.com/forums/admincp/plugin.php
Referrer     : http://www.blootix.com/forums/admincp/plugin.php?do=productdelete&productid=nzbgroupallowhtml&s=
IP Address   : --------------
Username     : Blootix
Classname    : vb_database

[hydrostatic]

Nevermind, I just deleted the uninstall code in the plugin and it worked... but did anything happen to my database because of this?

[actolearn]

This will not work retroactively.

is there a way this can be tweaked so that it would work retroactively?

[NxTek]

I uploaded bitfield_allowhtml.xml and imported product-nzbgroupallowhtm3.5.0.xml, and tried a new post that contained html tags. It just doesn't work.

The Posting Rules also says HTML code is Off.

Is there any way to debug why this isn't working?