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...

[ArnyVee]

Originally Posted by WarLion

i find a way arny go to admincp - avatars - storage -and change customavatar to customavatar/thumbs
i saw that the code for the avatar $comment[avatarurl] is diferent
and the you have to rebuilt the custom avatars

Wait, so you changed the name of the directory (from customavatar to customavatar/thumbs) or added a sub-directory named thumbs?

[TCB]

Originally Posted by Pehchaan

Uninstalling it seems unsuccessful, getting this:

• Dropping Table community_video ... Done!
• Dropping Table community_videocategory ... Done!
• Altering Table session ...Done!
• Altering Table usergroup ...Done!

• Dropping Table community_videotag ... Done!
• Dropping Table community_videotagvideo ... Done!

• Dropping Table community_videocomment ... Done!
• Altering Table video ...vB_Database_Alter: fetch_table_info() has not been called successfully.
  Table 'website_forum.community_video' doesn't exist

also geeting this error on forum home:

I had the same error... I disabled it, installed the survivor version, tried to uninstall that one, upload old files, installed another old version, and so on. Now I finally had it deleted. Don't know how exactly, but it is.

THis weekend I'll try to install a better version. But it looks great so far (y)

[TCB]

djeezz.... I finally thought I had everything working, had a good install, was able to change all settings, but the went to the actual page:

Database error in vBulletin 3.7.0:

Invalid SQL:

		SELECT videotagvideo.tagid AS tag, videotag.*, COUNT(*) AS quantity
			FROM vb3_videotagvideo
			INNER JOIN vb3_videotag ON (videotag.tagid = videotagvideo.tagid)
			WHERE videotagvideo.dateline > 1199740698
			GROUP BY videotag.tagid, videotag.tagtext
			ORDER BY quantity DESC
			LIMIT 50;

MySQL Error   : Unknown table 'videotag'
Error Number  : 1051
Request Date  : Tuesday, January 6th 2009 @ 02:18:18 PM
Error Date    : Tuesday, January 6th 2009 @ 02:18:18 PM
Script        : http://www.mysite/video.php
Referrer      : 
IP Address    : 195.xxx.xxx.xx
Username      : TCB
Classname     : vB_Database
MySQL Version : 5.0.67-community-log

[Veer]

Originally Posted by Jaxel

Hmm... Pehchaan... lets try it this way... In:
Manage Products > Video-Directory > EDIT > Version

Change it to 1.0.0... Then try to re-install. (used attached file)

If that doesn't work.. Delete all "Existing Install/Uninstall Code" (there are checkboxes on the right to delete them)... then uninstall, and then re-install with the attached file... But try the other way first.

okay I installed with attached xml using first way.
Forum home is fine now, but getting database error when browing /video.php

Database error in vBulletin 3.8.0 Release Candidate 1:

Invalid SQL:

SELECT videotagvideo.tagid AS tag, videotag.*, COUNT(*) AS quantity
FROM community_videotagvideo
INNER JOIN community_videotag ON (videotag.tagid = videotagvideo.tagid)
WHERE videotagvideo.dateline > 1199740602
GROUP BY videotag.tagid, videotag.tagtext
ORDER BY quantity DESC
LIMIT 50;

MySQL Error : Unknown table 'videotag'
Error Number : 1051
Request Date : Tuesday, January 6th 2009 @ 04:16:42 PM
Error Date : Tuesday, January 6th 2009 @ 04:16:42 PM
Script : http://www.domain.com/video.php
MySQL Version : 5.0.67-community

[WarLion]

Originally Posted by ArnyVee

Wait, so you changed the name of the directory (from customavatar to customavatar/thumbs) or added a sub-directory named thumbs?

i chage the past from customavatar to customavatar/thumbs and now is working fine

[Jaxel]

Well at least we're making progress to weeding out all these problems... Penchaan or TCB, do you mind contacting me on aim so I can look at your forums and your database? AIM: BadBreath911

[ArnyVee]

Originally Posted by WarLion

i chage the past from customavatar to customavatar/thumbs and now is working fine

I'm sorry, I don't understand your response to my question. Did you change the name of the directory or add a sub-directory?

[Jaxel]

ArnyVee... all he's saying is change your avatar storing options from Database to File System.

The file system will AUTOMATICALLY create a directory called /thumbs... chmod that to 777. THATS IT.

[WarLion]

sorry my englsh is not so good
what i did was change the path from my admincp-avatar-storage and change customavatars to customavatars/thumbs

and you need to have your folder forum-root/customavatars/thumbs (chmd 777) then you need to go
Maintenance > Update Counters > Rebuild Custom Avatar Thumbnails

that will move all your avatars from your db to a folder forum-root/customavatars/thumbs

that work for me not sure if will work for you
http://www.rctitis.com/foro/videos/t...te-301-15.html

[Jaxel]

No... dont change your storage to customavatars/thumbs, leave it as the default customavatars... else it will end up being customavatars/thumbs/thumbs. vBulletin AUTOMATICALLY handles the thumbs directory and pulls from it if available. Dont forget to CHMOD both customavatars and customavatars/thumbs to 777. Then run the update counter.

As long as you have both directories, vBulletin handles the rest:
/customavatars/avatar1_7.gif
/customavatars/thumbs/avatar1_7.gif

The /customavatars DIR keeps normal avatars for the forum...
The /customavatars/thumbs DIR keeps thumbnailed avatars at 60x60 for commenting sections of the forums.