UseBB Community

Hi all,

I just finished my extention of UseBB, which can handle unlimited usergroups per forum, and unlimited amount of users per usergroup. Is anyone interested in this? If yes, can anybody tell me how to create a diff file of my current code compared to the original 1.0.4 source code.
For this to work you need to make changes to the *forum table, and add 2 new tables into your database. I also changed the install routine (for myself) that will do this automatically.
The admin part is real basic, you can add, change or delete usergroups, and you can add users on a per-user basis. (Same as editing a user)
Also the user had an expention on his controlpanel, with a simple page that tells him into which usergroups he has been added. You can give a forum special read and writerights to a single usergroup (so you can have anyone to access the forum, and a single usergroup that can write into the forum)
So far it's just for forums, and not for category's.
Also I included the english and dutch translation with it.

Contributing your modifications is highly appreciated.

You can make a diff using the diff utility (Windows version):

diff -udPr UseBB UseBB-modified > patch.diff

To apply the changes, you cd into the forum's directory and perform:

patch -p1 < patch.diff

I submitted this modification to the sourceforge tracker, and to the UseBB Zone.
You can find the tracker item here: https://sourceforge.net/tracker/?func=detail&atid=609474&aid=1630137&group_id=93103

As i just discovered, there was a huge typo made which I didn't found during testing. So I present version 1.1

I just tried to apply the patch, but it didn't work. I guess it would be better to have a unified diff.

diff -udPr UseBB UseBB-modified > patch.diff

Sorry for this mistake.

Thanks for pointing this out. I tested this file and it should be working now Thanks for teaching me the diff / patch skill (I posted the new file on sourceforge / useBB Zone)

Couldn't get it to work since this patch seems to be missing a few things (changes in the database tables, some PHP code for panel.php, etc).

It also seems you're using subqueries, which don't work in MySQL < 4.1 (I'm still using 4.0).

This time I'm sorry because I have to separate the usercatmod from the rest of the code I missed panel.php. Yes I am using subqueries. I will try to change this into a join query, but I have not that much experience with them, so thats why I uses subquery's.

For the database you can run the following query's to make it work: (replace usebb_ with your custom prefix)

ALTER TABLE `usebb_forums` ADD `readaccess` INT(11) NOT NULL DEFAULT '-1';
ALTER TABLE `usebb_forums` ADD `writeaccess` INT(11) NOT NULL DEFAULT '-1';

CREATE TABLE `usebb_usergroup` (
  `user_id` int(11) NOT NULL default '0',
  `group_id` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `usebb_usergroups` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `descr` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

I uploaded the new version with the updated panel.php diff info

Would it be possible for someone to upload a version of this modification that doesn't require patching the software with a .diff file?

Or would someone point me in the right direction of applying a .diff file to a forum on a shared hosting account?

Would be much appreciated because I need this usergroup modification on my forum.