Recently I wanted some users to have the ability to upload videos without the necessity to moderate these users. I requested this as a feature for a future release of UVG and received some pointers on how to achieve this.

The posting can be found over here and I encourage you all to have this incorporated in UVG by default.

Note: In order to be safe I you to try this first in a sandbox environment, make a backup of your database & website first. In other words, if you screw up don’t blame me.

1. Create a DNN role in your portal for which the members will be automatically moderated when uploading a new video to your portal. Write down the DNN role Id as this is specific for your portal and needs to be filled in later on;
2. Open up the sql statement that is attached to this blog and change the text “Place your DNN role Id over here” with the real Id that you have written down previously (also remove the quotes!!);
3. Log in as a host user on your portal and go to the sql section;
4. Copy and paste the sql statement in the sql text box area and check the checkbox “run as script” and execute the statement

What happens is that a database trigger is created that will update the approved field in the UVG_Video table for the users in the DNN role that you have created when a new video is entered. This is done on the SQL server and done each time for all users.

I would have loved to include the UserID and the ItemId to update only one record instead of all records for users in the DNN role but I have no idea how this should be done. If some of the real smart guys would like to step up and include this to the sql statement that would be awesome.

I hope it serves you well.

Best regards,
Marc