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

[camdude]

I put the new htaccess file, but same result. The videos are okay within the forum. But the <!-- SEO Videos Index Bar --> only shows the borders of the video player and a black screen in the middle. Also there are no video pages within the directory.

[Hastin]

Originally Posted by Adult SEO

Regarding the wrong ID's, could you please show me an example?

Best Regards,
Jan Jaap

Be my guest:

http://www.micechat.com/forums/index.php?videos=1

I've also attached an SQL dump of the table.

[silks]

this plugin was working great untill i switched " html on " on 1 forum

upon i got this Field seo_videos_bar is not defined in $validfields in class vb_datamanager_forum in /includes/class_dm.php on line 485

i would like to uninstall safely as i now have to use a back up now a few things arnt working please plz plz can i have some advice

[ZiG]

fixed it myself******edit

[firstrebel]

Originally Posted by Adult SEO

RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^videos\.html&page=([0-9]+)$ http://www.micechat.com/forums/videos-page$1.html [L,R=301]
 
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^videos\.html$ index.php?videos=1 [L]
 
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^videos-page([0-9]+)\.html$ index.php?videos=$1 [L]

What about these two lines if the forum is in /forum

RewriteCond %{HTTP_HOST} !^www\.yourdomain\.com
RewriteRule (.*) http://www.yourdomain.com/$1 [L,R=301]

Also, where are the images mentioned in the installation.

Bob

[KTBleeding]

I apologize ahead of time if this has been mentioned..

One of my members just reported this issue, perhaps you can look into it?

The google / youtube icons show up when you:
1) start a thread
2)reply to a quote/quote something.

But if you go to the bottom of the page and click "go advanced," they don't show up.

[Adult SEO]

Hi!

The images are attached to the mod (google.gif/youtube.gif).

Regarding the 301 redirect to make your www. less domain redirect to www.domain.com you should just add /forum/ or any other url you want the www. less domain redirect to.

Best Regards,
Jan Jaap

[GasPipeJimmy]

I'm having a problem with the installation instructions and I was wondering if you could clarify a few things for me before I get started.
This is my first vBulletin Mod, so bear with me if these seem like "noob" questions...

Instalation:

1. Import the XML product

How would I do that?
Is this done through the vB Admin Control Panel?
If so, what part?
When I try to do that through the "Style Manager" > "Import Style XML File" I get an error that says: Invalid File Specified

Upload the attached icon images (or use your own)
Default is:
/images/editor/google.gif
/images/editor/youtube.gif

Where are they attached?
I'm not seeing them.

Open htaccess.txt, configure it (replace yourdomain with your domain), save it as .htaccess and upload it to the root of your forum

OK, that one I think I understand.

Run the included installer

Sounds easy, but how do I get too it to run it?
Do I do that through my browser like I did when I installed vBulletin?
Does it matter where I run the installer from anywhere in my vBulletin install?
Can I upload that file to anywhere in my vBulletin install, such as in the install folder of my vBulletin installation?

Do I have to change any of my write permissions (chmod to 777) for any of these files that I'm uploading for this to work correctly?

OK, I think that is all for now.
Thanks!

[Adult SEO]

Originally Posted by GasPipeJimmy

I'm having a problem with the installation instructions and I was wondering if you could clarify a few things for me before I get started.
This is my first vBulletin Mod, so bear with me if these seem like "noob" questions...

Instalation:

How would I do that?
Is this done through the vB Admin Control Panel?
If so, what part?
When I try to do that through the "Style Manager" > "Import Style XML File" I get an error that says: Invalid File Specified

The product needs to be added via your product manager.


Where are they attached?
I'm not seeing them.

https://vborg.vbsupport.ru/attachmen...1&d=1163534932
https://vborg.vbsupport.ru/attachmen...1&d=1163655869


OK, that one I think I understand.


Sounds easy, but how do I get too it to run it?
Do I do that through my browser like I did when I installed vBulletin?
Does it matter where I run the installer from anywhere in my vBulletin install?
Can I upload that file to anywhere in my vBulletin install, such as in the install folder of my vBulletin installation?

Yes, by requesting the file the instalation will be started.

Do I have to change any of my write permissions (chmod to 777) for any of these files that I'm uploading for this to work correctly?

OK, I think that is all for now.
Thanks!

... [charlimit]

[GasPipeJimmy]

Thanks for your help, but "no joy in Mudville" tonight

Database error in vBulletin 3.6.4:

Invalid SQL:
SELECT id,title FROM `seovideos` WHERE `video_id`='mCwKbUVyHLY' AND `post_id`='111464' AND `type`='youtube' LIMIT 1;

MySQL Error : Table 'thehappyex_THEvB.seovideos' doesn't exist
Error Number : 1146
Date : Sunday, November 26th 2006 @ 01:34:53 AM
Script : http://www.XXXXXXXXXXX.com/vBulletin...ote=1&p=111536
Referrer : http://www.XXXXXXXXXXX.com/vBulletin...t=10223&page=2
IP Address : XXX.165.18.XXX
Username : XXXXXX
Classname : vb_database