Maybe I'm wrong but the only option I have is : Report-Forum - Forum, in which a topic for every reported video is created.
Which means that a thread will be created if someone report a bad video but not when someone add a video.
And to sum up some problems I have with this hack:
1- On the 'recently added video' page all the videos appear even the ones that come from a private category.
I fixed this one by changing in video.php :
Code:
// Recent Videos
if ($_REQUEST['do'] == 'viewrecent')
{
$videos = $db->query_read("
SELECT video.*, user.*, IF(NOT ISNULL(user.userid), user.username, video.username) AS username, IF(video.ratingnum > 0, video.ratingtotal / video.ratingnum, 0) AS ratingavg
FROM " . TABLE_PREFIX . "video AS video
LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid = video.userid)
ORDER BY dateline DESC
LIMIT " . $vbulletin->options['videodirectory_videosperpage'] . "
");
BY:
Code:
// Recent Videos
if ($_REQUEST['do'] == 'viewrecent')
{
$videos = $db->query_read("
SELECT video.*, user.*, IF(NOT ISNULL(user.userid), user.username, video.username) AS username, IF(video.ratingnum > 0, video.ratingtotal / video.ratingnum, 0) AS ratingavg
FROM " . TABLE_PREFIX . "video AS video
LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid = video.userid)
WHERE video.videocategoryid IN(" . implode(',', $allowedcats) . ")
ORDER BY dateline DESC
LIMIT " . $vbulletin->options['videodirectory_videosperpage'] . "
");
2- Same goes for the video block on the profile page
3- I don't know if it's something normal, but tags added for private videos appear also in the tag cloud.
4- The RSS feed doesn't work either
See you.