Diaries/Owned Forums

Hi There!
Original from Andrew111888
German Version avaiable her: http://www.vbhacks-germany.com/forum...ead.php?t=2357

What this hack does
This hack will allow your members to create 'diaries' (the term my site uses)--forums that are "owned" by a member or group of members. The owner(s) will be able to add and delete other owners to their diary, and modify the title/description of their diary.


How it works
When a user would like to create a diary, they will visit /forumdir/diarycp.php and submit their application (username and description of their desired diary). To prevent abuse, the application will be moved to /forumdir/queue.php. An administrator can either deny or confirm the application. If denied, the application is removed from the diary_queue table. If it is confirmed, it is removed from the diary_queue table and created as a new forum.
For nearly all of this functions I use the build-In Class System to prevent Errors and use the Internal Error-Handling.
The file located at /forumdir/diarycp.php will include the statistics of an owner's diary(s), including post count, thread count, latest post, forum name, as well as the 'Edit Diary', 'Add Owner', and 'Delete Owner' functions.

AdminCP
In this brand New Version you can modify the possible Settings for the New Forums and the Moderator-Settings in the ACP in the vBulletin Options.
Attention: This Settings has only effect for new created Forums and/or Moderators/Owners.

You can Give each Usergroup additional Rights to see the DiaryCP, to create/edit Diaries and to Administrate Diaries.

[Yorixz]

Hoffi, one question; will it cause any harm (data left in the db or so) if you just delete a subforum as admin or is there another (better) way to do so?

[Hoffi]

There ist no extra Data stored in the DB. So just do what you want in the AdminCP. The created Table is only for the requests and will be cleared during creation of a Forum.

[tuanluu]

I got this error when I try to create new diary.

Invalid SQL:
INSERT INTO diary_queue (title, description, owner, ownerid, date) VALUES ('Goku's Diary', 'I am testing daily diary', 'Goku', 3, 1133422813);

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 's Diary', 'I am testing daily diary', 'Goku', 3, 1133422813)' at line 1
Error Number : 1064
Date : Thursday, December 1st 2005 @ 01:40:13 AM

does compatable the new release of mysql and php?

[Xtrato]

I got that too is there a fix?

[tuanluu]

I am still waitting ... I thing the problem is that we are using the current release of php and mysql and this hack is not up to date yet?....

[Xtrato]

dont know but we cant use this hack without a fix haha

[yack]

Bugs:

1, diarycp.php -- the redirection problem.

line 244 and 288: change to

PHP Code:

header("Location: ".$vbulletin->options['bburl']."/diarycp.php"); 


2, line 150 wrong datatype error in some instance.

3, when delete owner, user can only delete itself. Only super administrator can manage all owners.

Some suggestions
1. First owner have the priority permission, that can delete other owners.
2. When applyed, user can choose which category the diary is under.
3. if possible, a icon image for each diary is great.
4. First owner can manage the templates.
5. owners can modify the permission of their diarys. can reply, can start a thread, can upload attachments, etc.
6. owners can manage the subscribtions

I really like this hack. Eagar for the new version.

Great Thanks.

[Xtrato]

any fixes from Coder ?

[Hoffi]

I'll update this week.

[ReadOrDie]

It's be much better if the screenshots weren't in german. :/