Board Optimization - SEO YouTube and Google Videos

This mod was inspired by by Embed XHTML valid YouTube and Google Video into your posts but this mod contains some bugs and isn't complete so I then needed to modify it and decided to do it really well and aply SEO technology to it.

This mod will enable your users to publish YouTube or Google videos on your forum. It's managable via the adminpanel and the script will automaticly download the titles of the videos from YouTube or Google Video and store it in the database so it will get the videos indexed verry well and it's fast.

Some of the features:

• Custom tagnames, manageable from the adminpanel
• Automatic Video Title retrieval, with optional support for Lib Curl and user-simulated video title retrieval
• Custom editor icons, managable from the adminpanel
• Template based Google or YouTube video output
• Support for local Google Video servers, to make your site local
• Phrases for all text so it has support for multi-lingual forums
• Optional, extend all links within the video with rel="nofollow", customizable seperately for YouTube or Google Video
• Custom Video titles via tag option ([googlevideo="Video Title"]...[/googlevideo])
• SEO Video Index (demo)
• SEO Video Bar (demo)
• Ability to configure usergroups that have access to delete videos.

Instalation:

1. Import the XML product
2. Upload the attached icon images (or use your own)
   • Default is:
     • /images/editor/google.gif
     • /images/editor/youtube.gif
3. Open htaccess.txt, configure it (replace yourdomain with your domain), save it as .htaccess and upload it to the root of your forum
4. Run the included installer
   • The installer will also upgrade previous instalations
   • Bug: when you run the installer more then once, multiple of the same indexes are created. I haven't found a way yet to prevent this. I have posted some messages on MySQL forums to find an answere and will then upgrade the installer. For now it is adviced to run the installer just once and for upgrades it is adviced to check the PREFIXseovideos table after upgrading to see if there are any duplicate indexes configured to remove them if needed.
5. To install the Videobar anywhere on the forum use the folowing code:
   • PHP Code:

     <!-- SEO Videos Index Bar --> 


Done.

Have Fun!
Jan Jaap

Screenshots:





Update: 18 februari 2007 (latest files from www.papegaaienforum.nl where this mod works very well).

[da420]

Hi Jaan,

Can you tell me why my video's do not play? In the threads they do, but not in the videos.html page.

http://www.mindifidoaj.com/forum/videos.html

Thank you,

Dustin

[mikehawk]

I have it installed, but it is not letting me delete threads now:

Database error in vBulletin 3.6.3:

Invalid SQL:
DELETE FROM `seovideos` WHERE `post_id`='7263';

MySQL Error : Table 'realmysql.seovideos' doesn't exist
Error Number : 1146
Date : Thursday, February 22nd 2007 @ 07:58:09 PM
Script : http://www.realopinion.com/realboard...&threadid=6482
Referrer : http://www.realopinion.com/realboards/postings.php
IP Address :
Username :
Classname :

[b6gm6n]

I have a solution which allows members to insert youtube videos using tags, would this be a better solution? i'll give it a whirl... looks very good, cheers

actually the demo site shows a DB error... not very convincing, un-installed, sorry dude

-b6

[angkor408]

Does this support 3.5X?

[dbirosel]

Does this addon, affect bandwidth? How bad is it? Thank you.

[snoopgst]

does the .htaccess file need to be coded differently if I have my forums under mydomain/forums/ ?

I placed my htaccess fild under mydomain/forums/ but the videos.html is giving me a 404 error.

[RichieBoy67]

Are there instructions for installing the update???

[RichieBoy67]

Why is it shortening my urls? for some reason it keeps cutting off most of the url and because of that videos are not working..

Thanks..

[angeljs]

Unfortunately I just can't seem to get the videos to show up in the video bar. I've added the code to 'FORUMHOME' template, but I'm not seeing anything. I'm also not sure about the .htaccess file...do I have to input the url to the forums, or just my domain?

I've enabled everything using the admin settings, and I really want this to work, but can't seem to crack it!

[RichieBoy67]

I believe it is the whole address... just try both.... pretty sure it's the address though..