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

[Adult SEO]

Yes.

There might still be a bug somewhere, but just let me know and I will fix it.

As of vBa support, I am aspecting it is available in vBa aswell by adding the folowing html code:

<!-- SEO Videos Index Bar -->

Best Regards,
Jan Jaap

[freevisio]

:ermm: now receipt this error

MySQL database updated, added table "seovideos" to the database.
MySQL database updated, added index "video_id" for table "seovideos".

Database error in vBulletin 3.6.2:

Invalid SQL:
ALTER TABLE `forum` ADD `seo_videos_bar` SET( 'enabled', 'disabled' ) NOT NULL DEFAULT 'disabled',
ADD `seo_videos_bar_source` SET( 'google', 'youtube', 'both' ) NOT NULL DEFAULT 'both',
ADD `seo_videos_bar_videos` INT( 3 ) NOT NULL DEFAULT '4';;

MySQL Error : Duplicate column name 'seo_videos_bar'
Error Number : 1060
Date : Wednesday, November 15th 2006 @ 09:50:43 PM
Script : http://www.3dsymax.org/foro/seovideos_install.php
Referrer :
IP Address : ********
Username : *******
Classname : vB_Database

[Adult SEO]

Hi!

You must be using the old installer, as the new installer won't display these messages anymore and uses difrent MySQL code.

I've reuploaded the installer to be sure, please download it again and try again.

Best Regards,
Jan Jaap

[hcmagix]

Hi Adult SEO

I think the third part of your hack should be myvideo.de
Do it for german users. Please

[freevisio]

I using the last installer that you have upload and solves that error :surprised:

[transitbus]

Just to be sure, if we do not want a video index but only want the features for embedding videos, we just turn them off in the options and should not have to worry about adding to our .htaccess file.

Is this correct?

[fourfourthree]

Hi, Adult SEO. Great mod.

One problem though, when I tried posting a youtube video that had an underscode in the url, the full URL doesn't get put in the flash code.

For example if the URL to the video was: http://www.youtube.com/v/npVpn_ExAmpLe

It tries to play http://www.youtube.com/v/npVpn

[Adult SEO]

Originally Posted by fourfourthree

Hi, Adult SEO. Great mod.

One problem though, when I tried posting a youtube video that had an underscode in the url, the full URL doesn't get put in the flash code.

For example if the URL to the video was: http://www.youtube.com/v/npVpn_ExAmpLe

It tries to play http://www.youtube.com/v/npVpn

Yes, I've uploaded a fixed version just 5 minutes ago.

The current regex used is |^[a-zA-Z0-9\-_]+$|Ui wich will match any letter, number, - and _. If anyone knows of an other character used in the Video ID on YouTube just let me know and I will add it.

Best Regards,
Jan Jaap

[Adult SEO]

Originally Posted by transitbus

Just to be sure, if we do not want a video index but only want the features for embedding videos, we just turn them off in the options and should not have to worry about adding to our .htaccess file.

Is this correct?

Yes, you can turn it off from the adminpanel aswell as the videobar or one of the video hosts (e.g. alowing only Google Video). Also from the admin within 2 clicks.

So the .htaccess isn't needed, it's just for the Video Index.

Best Regards,
Jan Jaap

[Adult SEO]

Originally Posted by hcmagix

Hi Adult SEO

I think the third part of your hack should be myvideo.de
Do it for german users. Please

How many users do they have?

Best Regards,
Jan Jaap