Major Additions - 8WayRun.Com - Media Library

Don't forget to click INSTALL!
I'm an unemployed computer programmer... if you appreciate the work I have done on this mod, please don't hesitate in offering me a donation by clicking the "Support Developer" link to the right of this text. A donation of $50 or more automatically gives you the right to remove the copyright footer for this modification from a single forum.

This is a new modification, spawning from the old VB 3.x Video Directory modifications.
For all intents and purposes, both my old Video Directory Remixed mod, and Survivor's original Video Directory mod have been discontinued. Neither of us are maintaining these older versions, they will not receive any future updates and we will not be providing any support. This version has a new name because it has been completely rewritten from scratch and is not being built on Survivor's old code. Because of this, if you are upgrading to this new version, from the old version, be sure to read this entire post in order to understand the upgrade process.

What is this mod?
Simply put, this mod is a directory for media. It supports URL inputs, in order to extract meta data and directorize media into a simple and easy to understand library. Users can add their favorite media from a select few online distribution centers (such as Youtube or Vimeo) and categorize and tag them as they see fit. This mod offers rudimentary support for the hosting of local media. An administrator can upload a media to the /customVID/ (default) directory; then add the media to the library using the URL code of "local:filename". Media hosted locally will be displayed using JWPlayer, but will not provide meta data, so that kind of information will need to be entered manually.

Demo:

http://www.8wayrun.com/media.php

Features:

• Integrated directly into the vBulletin user database and product manager.
• Fully phrased and built on tempaltes for easy re-skinning and styling.
• Simple to use administration features and usergroup permission settings.
• Landing page with the most recent, most popular and highest rated media.
• Ability to add media into a single category, while adding multiple tags.
• Ability to browse media through categories, tags, and user contributions.
• Summary tag cloud with a link to the entire list of tags in the system.
• Comment and rating system based on AJAX including graceful degredation.
• Individual RSS Feeds for newest videos, categories, tags and user media.
• Search function for titles and descriptions.

Installation:

If you are upgrading from before version 1.1, please install that version first.

1. Upload all the files in the "upload" directory of the attached zip file to your forum root.
2. CHMOD the /customVID/thumbs/ directory to full read/write/execute 777 permissions.
3. CHMOD the /customVID/sitemap/ directory to full read/write/execute 777 permissions.
4. Import the product file called "product-medialibrary.xml" in the Product Manager of vBulletin.
5. Set your usergroup permissions and media library settings in your administration control panel.
6. OPTIONAL: Enable the "Generate XML Media Sitemap" scheduled task in your administration control panel.
   
   NOTES: Make sure you decide what you wish to use for your thumbnail quality setting. By default, thumbnails are saved at 50% quality. At 50%, thumbnails will only be 2kb in size, but at the expense of quality. At 100%, thumbnails will be about 15kb in size, but will have the highest quality. I recommend setting it to 80%, which would leave thumbnails at 5kb in size with still excellent quality.
   
   Every time you change your thumbnail quality setting, you will need to run the "Rebuild Media Thumbnails" to see any changes.

Upgrading from VDR:

1. The "video*" tables from your previous installation of VDR need to exist in your database.
2. Enable the "media ADMIN import" plugin in the plugin manager of your control panel.
3. Run the "Import Media from VDR" process in your update counters menu in maintenance.
4. Disable the "media ADMIN import" plugin in the plugin manager of your control panel.
5. Run the "Rebuild Media Thumbnails" process in your update counters menu in maintenance.
6. You may now uninstall VDR once you confirm everything has been imported as intended.
   
   NOTES: You will mostly likely get at least one error while rebuilding media thumbnails...
   
   When you get an error, click the details link for that media. If the media displays some sort of error such as "This video has been removed" or "This video no longer exist", then that means that media is gone and you'll be unable to generate a thumbnail for that particular media. Use the available options on that media's detail page to DELETE it from your library. Then go back to your browser window which is rebuilding thumbnails and click the "retry from this position" link.
   
   If you got an error for a media, but after clicking the details link you can find no obvious error with the video; then the error could have just been a simple syn/ack failure. Just click the "retry from this position" link and the system will try to rebuild that thumbnail again.

Known Bugs:

There is a conflict with this modification and some of Valter's VSA modifications that will prevent navbar permissions from being handled correctly. I don't know exactly who's fault it is; but I'm pretty sure there are no errors in my code that would be causing this problem. There is a work around for this however.

Admin Control Panel > Plugins & Products > Plugin Manager > "media NAVTAB"

Find the code:

    $perms = media_permissions();

Replace with:

$perms['rate'] = true;
$perms['comment'] = true;
$perms['submit'] = true;
$perms['playlist'] = true;
 
if (is_member_of($vbulletin->userinfo, explode(',','5,6')))
{
    $perms['modtags'] = true;
    $perms['modcategory'] = true;
    $perms['modservice'] = true;
}

[Jaxel]

Originally Posted by EquinoxWorld

Hello Jaxel, I was wondering if you can help us out with this one; we have a bit of a concern with the search feature. Let's say someone wants to search for and episode of "Bleach" and the episode 240 . Now let's say the actual video is named "bleach - 240" ; if you search for just "bleach 240" (without the dash) the video will not appear in search; if you type "bleach - 240" exactly how the name is then the video will come up in the search results. My question would be how can I broaden the search to include only letter maybe or not so specific to allow for more results possibilities maybe? Any light yourself or anyone can shine on our concern please don't be shy. We have close to 20,000 videos and it is very hard to find a specific one because of the nature of our implementation of the mod so any help we can receive would be immensly appreciated. Thank you for your time.

Next version of this mod will have BOOLEAN search.

[bahattab]

hi

i am getting this when i submit videos:

PHP Code:


Warning: Division by zero in [path]/includes/functions.php on line 2470

Warning: Division by zero in [path]/includes/functions.php on line 2470

Warning: Division by zero in [path]/media/media_functions_constructs.php on line 416

Warning: Division by zero in [path]/media/media_functions_constructs.php on line 418
Database Error     Database error
The ************* database has encountered a problem.
Please try the following:

    * Load the page again by clicking the Refresh button in your web browser.
    * Open the www.*************.com home page, then try to open another page.
    * Click the Back button to try another link.

The www.*************.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
 
We apologise for any inconvenience.




Database error in vBulletin 4.0.4:

Invalid SQL:

        SELECT media_comment.*, user.*, media.title, IF(NOT ISNULL(user.userid), user.username, media_comment.username) AS username,
            NOT ISNULL(customavatar.userid) AS hascustomavatar,    user.avatarrevision AS avatarrevision, avatar.avatarpath AS avatarpath,
            customavatar.width AS avwidth, customavatar.height AS avheight, customavatar.dateline AS avatardateline
        FROM media_comment AS media_comment
        LEFT JOIN user AS user ON(user.userid = media_comment.userID)
        LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid)
        LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
        LEFT JOIN media AS media ON(media.mediaID = media_comment.mediaID)
        WHERE media_comment.mediaID = '1'
        ORDER BY media_comment.dateline DESC
        LIMIT -0, 0;

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 '-0, 0' at line 11
Error Number  : 1064
Request Date  : Wednesday, July 14th 2010 @ 03:25:46 PM
Error Date    : Wednesday, July 14th 2010 @ 03:25:46 PM
Script        : http://www.*************.com/vb/media.php?do=details&mid=1
Referrer      : http://www.*************.com/vb/media.php
IP Address    : *************
Username      : *********
Classname     : vB_Database
MySQL Version : 5.0.91-community-log 


[WeMovie.co.uk]

I can't click on any of the links in the Media library. I keep getting a 404 Not Found error.
I can't submit media or create categories, etc.

For example the link to submit media is 'http://www.wemovie.co.uk/forum/media/submit' but there's nothing on that page. Just a 404 Error.

Help!?

[EquinoxWorld]

Originally Posted by Jaxel

Next version of this mod will have BOOLEAN search.

Thank you so much for this EXCELLENT news Jaxel. By any chance can we get an approximate ETA on the next release?

[Jaxel]

Originally Posted by bahattab

hi

i am getting this when i submit videos:

PHP Code:


Warning: Division by zero in [path]/includes/functions.php on line 2470

Warning: Division by zero in [path]/includes/functions.php on line 2470

Warning: Division by zero in [path]/media/media_functions_constructs.php on line 416

Warning: Division by zero in [path]/media/media_functions_constructs.php on line 418
Database Error     Database error
The ************* database has encountered a problem.
Please try the following:

    * Load the page again by clicking the Refresh button in your web browser.
    * Open the www.*************.com home page, then try to open another page.
    * Click the Back button to try another link.

The www.*************.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
 
We apologise for any inconvenience.




Database error in vBulletin 4.0.4:

Invalid SQL:

        SELECT media_comment.*, user.*, media.title, IF(NOT ISNULL(user.userid), user.username, media_comment.username) AS username,
            NOT ISNULL(customavatar.userid) AS hascustomavatar,    user.avatarrevision AS avatarrevision, avatar.avatarpath AS avatarpath,
            customavatar.width AS avwidth, customavatar.height AS avheight, customavatar.dateline AS avatardateline
        FROM media_comment AS media_comment
        LEFT JOIN user AS user ON(user.userid = media_comment.userID)
        LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid)
        LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
        LEFT JOIN media AS media ON(media.mediaID = media_comment.mediaID)
        WHERE media_comment.mediaID = '1'
        ORDER BY media_comment.dateline DESC
        LIMIT -0, 0;

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 '-0, 0' at line 11
Error Number  : 1064
Request Date  : Wednesday, July 14th 2010 @ 03:25:46 PM
Error Date    : Wednesday, July 14th 2010 @ 03:25:46 PM
Script        : http://www.*************.com/vb/media.php?do=details&mid=1
Referrer      : http://www.*************.com/vb/media.php
IP Address    : *************
Username      : *********
Classname     : vB_Database
MySQL Version : 5.0.91-community-log 


That error seems releated to the $perpage variable being empty. Make sure your comments per page variable is not 0.

Originally Posted by WeMovie.co.uk

I can't click on any of the links in the Media library. I keep getting a 404 Not Found error.
I can't submit media or create categories, etc.

For example the link to submit media is 'http://www.wemovie.co.uk/forum/media/submit' but there's nothing on that page. Just a 404 Error.

Help!?

Turn off SEO slugging if you don't have SEO.

Originally Posted by EquinoxWorld

Thank you so much for this EXCELLENT news Jaxel. By any chance can we get an approximate ETA on the next release?

I wont even BEGIN programming for another 2 weeks... I can tell you that... Plans in the work for the next release...

Boolean Search
Playlists
Custom Variables
Advanced Search
Option to auto-tick checkboxes
Option for sidebar placement
Option for tag cloud placement

Naturally, it will be a larger update than usual.

[WeMovie.co.uk]

Originally Posted by Jaxel

Turn off SEO slugging if you don't have SEO.

Thankyou!

[Veer]

Originally Posted by Jaxel

Plans in the work for the next release...

Boolean Search
Playlists
Custom Variables
Advanced Search
Option to auto-tick checkboxes
Option for sidebar placement
Option for tag cloud placement

Naturally, it will be a larger update than usual.

That's great

Good luck bro.

[schlottkej]

I'd like to propose the addition of rss feed importing. So we can add an RSS feed from Youtube or Blip, etc.. and have it bring in the file automatically instead of having to manually add each file.

[bahattab]

That error seems releated to the $perpage variable being empty. Make sure your comments per page variable is not 0.

thanks it works

but you should fix this because i want to disable the comments

thanks for help

[promet]

edit:

works like charm on 4.0.5