Major Additions - Video-Directory Remixed

This mod has been rewritten for vB4x here: https://vborg.vbsupport.ru/showthread.php?t=240677

This modification is based on the Video-Directory modification by Survivor and vBPoint.org.
His mod is NOT dead, its still alive and kicking; but he has informed me that he just doesn't have the time to maintain it and give support. So until he is able to work on it agian; I've been doing a series of updates.

What is this mod?

This mod adds a fully featured and fully integrated video directory archive to your forums. Users can add their favorite videos from their favorite video service to the directory. I only support a few select hosters; but the hoster scripting is XML base, so any user can create their own scripts for any number of hosting services. The old MyVideo and Sevenload scripts from Survivor's version will still work, but they wont pull in Keyword/Tagging information, nor the video length time codes.

Basic Feature Listing:

• Fully integrated into the vBulletin user database and product manager.
• Fully phrased and built on templates for easy reskinning and styling.
• Fully administratable and a myriad of settings for personalization.
• Complete customization of permissions based on usergroups.
• Landing page for broad information and fully featured tag cloud.
• Category profiles for videos.
• Contribution profiles for users.
• Keyword profiles for tag cloud.
• Built in comment system for videos.
• Search function for titles and descriptions.
• RSS feed of videos.

Product Demo:

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

Installation Procedure:

1. Upload all files in the "upload" directory to your forum root.
2. CHMOD /videothumbnails/* and /includes/videoserviceapi to 777.
3. Import the product "product-videodirectory.xml" in your Product Manager.
4. Follow the on screen instructions to configure your video hoster settings.
5. Refresh your administration control panel to see the new navigation links.

NOTES:
vBulletin 3.7.0 instituted a new avatar-thumbnail system. There is a high probability that you are unaware of this new system and may have failed to setup your vBulletin to make use of it. Make sure that a directory called /thumbs is located in your avatar directory and CHMOD it to 777. Then go into Maintenance > Update Counters and run the Rebuild Custom Avatar Thumbnails process.

Upgrade Procedure:

1. Upload all files in the "upload" directory to your forum root.
2. Take note of the information stored in Limits of Videos > General Settings.
3. Import the product "product-videodirectory.xml" in your Product Manager.
4. Re-establish your previous Limits settings in Videos > General Settings.
5. Re-import ALL of your hosters and settings in Videos > Manage hosters.
   • You MUST remember to re-import your hosters after upgrading.

NOTES:
You may lose your category dataman when you upgrade. If no categories are listed after an upgrade, you will be required to rebuild your category dataman. Its very easy to rebuild it if you need to. Simply go into Videos > Manage categories, select ANY category and hit [Edit], then click [Save]. Your category dataman will automatically be rebuilt.

Roadmap for the Future:

• Moderation
• Favorites
• Playlists

Don't forget to click INSTALL!

If you want to donate, I'm all for it... as I'm an unemployed computer programmer...

[inciarco]

One Favor to Ask you Jaxel:

Could you please Attach the XML Files for the Two (2) New Video Hosters (Version 1.1.3) that you show on the Screenshots, for YouTube International and for YouTube HD? (I only have the ones of the Previous Version (1.1.0))

I Appreciate that, I can see some Interesting Thing that You've Added on that New Version (1.1.3).

My Best Regards.



Edit: I managed to make a Fresh Install of the Mod on another Forum and I got the Original XML Files of the New Video Hosters, I'm Attaching them in case someone needs them.

[ArnyVee]

Originally Posted by Katelynn

Got another error I see?

On the comments, only some of the avatars are showing up, not all of them?

For instance, I am admin and mine isn't showing up ... some regular members are showing up and some "other" groups are showing up .. but not all?

Thanks ..

Katelynn, I think that Warlion mentioned it, but we had the same issue until we moved the avatars being stored from database to file system.

Go to AdminCP -> Avatars -> User Picture Storage Type ... then, click on "go" or "send" (forgot what it was, but you get the idea) and you should be straightened out after that.

Originally Posted by inciarco

For Your Next Release, it would be nice to have the Option to Auto-Generate Tags for the Videos; it can check the Title of the Videos and generate the Tags (checking each word to see if the tag already exists).

(There's a Mod to Auto-Generate Tags for Threads, I guess the code should be similar for the Videos).

Funny enough I was going to suggest the same thing today to Jaxel! Great minds think alike, right?

[ArnyVee]

I just received a database error related to the tags. This one looks like it has something to do with the tags having an apostrophe "s" at the end of "Disney". So, here's the error...

Invalid SQL:

               SELECT videotag.*
               FROM videotag AS videotag
               WHERE tagtext = 'disney's';

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'' at line 3
Error Number  : 1064

....any word on what can be done with this one?

[inciarco]

Originally Posted by Pehchaan

Found error when editing video tag:



Editing tag doesn't work.

I confirm this Error/Bug; I've got it while trying to Tag my Old Videos and some that I uploaded without that Information.

Jaxel, What Code-Line (and in what Template/Plugin/File) can I Modify for it to be Fixed?

My Best Regards.

[inciarco]

Other Error/Bug When Clicking on the Tags:

I've Indicated the TABLE_PREFIX as "prefixtable-".

Perhaps there is something on the Code that isn't taking in Consideration the Table Prefixes in some cases that it should? (I think that SQL is on the videotag.php File)

I Hope you can Fix those Tag Bugs, Jaxel.

My Best Regards.

Database error in vBulletin 3.7.3:

Invalid SQL:
SELECT COUNT(video.videoid) AS count FROM prefixtable-video 
			INNER JOIN prefixtable-videotagvideo AS videotagvideo ON
				(videotagvideo.tagid = 2 AND videotagvideo.videoid = video.videoid)
			WHERE videotagvideo.tagid = '2' AND video.videocategoryid IN(0,1,6,2,4,3,5);

MySQL Error   : Unknown column 'video.videoid' in 'field list'
Error Number  : 1054
Request Date  : Wednesday, January 7th 2009 @ 03:14:47 PM
Error Date    : Wednesday, January 7th 2009 @ 03:14:48 PM
Script        : http://ZZZ/video.php?do=viewtag&tag=commercial
Referrer      : http://ZZZ/video.php
IP Address    : ZZZ
Username      : ZZZ
Classname     : prefixtable-Database
MySQL Version : 5.0.51a-community

[DoB Rhapsody]

How does the youtube HD work? I've tried adding a video that is HD and it doesn't come up in HD even after adding &fmt=22.

[Jaxel]

Originally Posted by Pehchaan

Found error when editing video tag:



Editing tag doesn't work.

Where are you getting these errors? You really gotta be more informative when you report a bug.

[Jaxel]

================================================== =========
Version 1.1.6
================================================== =========

This update is mostly a series of bug fixes.

• Reformatted the entire install script so its easier to debug and process.
• Upgrades will now re-install your hosters. So you dont have to do it manually.
• The tag cloud now constructs tag fonts using PIXELS (px), instead of POINTS (pt).
  
  • Pixel fonts give higher accuracy and control of text sizes, over points.
    
• BUG FIX: Fixed installation errors by switching to the dbalter function.
• BUG FIX: Fixed the tag cloud display error for people who use table prefixes.
• BUG FIX: Fixed the tag cloud insertion error from the admin control panel.
• BUG FIX: Fixed the tag cloud video count for people who use table prefixes.
• BUG FIX: Fixed the tag search error with tags that have an apostrophe in them.
• BUG FIX: Fixed navbit errors for videocategory for prefixes on edit tag page.
• FILE EDITS SINCE 1.1.5: (make sure you upload these new versions!)
  
  • a lot of them... just re-upload everything and re-install.
    
• Removed the tweaked vBAdvanced modules at request of the original author.

This new version should fix 99% of the bugs people are reporting... PLEASE TRY THIS NEW VERSION!

[ArnyVee]

Originally Posted by DoB Rhapsody

How does the youtube HD work? I've tried adding a video that is HD and it doesn't come up in HD even after adding &fmt=22.

It's done differently with this mod. Instead of using the &fmt=22, we change the "http" in the URL to "hdef".

Here's an example of one done on my site.

http://www.waltdisneyboards.com/vide...ornia-110.html

[inciarco]

Fantastic Update, Jaxel. :up:

Everything I've Tested So Far Works Fine on vB373, Including the Tags. :up::up::up:

Thank You Very Much For The Update, definitely a Mod Of The Month (MOTM) Winner.

My Best Regards.