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

[redlabour]

Originally Posted by hcmagix

in time 59 989 registered but millions watching the videos. Is a newer plattform like Youtube. Take a look http://www.myvideo.de/ and see the numbers after "Zuschauer:" below a clip.

greetz

Agree - myvideo.de is abolutely exploding at this Time. This has to be integrated.

There are also myvideo Dependances in other Countries - it is the next YouTube.

[mahakala]

Originally Posted by Adult SEO

Hi!

I see that you've gotten it to work?

Btw, I've removed the Forum based videobar as I didn't need it myself and it would cost quite some time development.

So please download the latest product wich will remove the partly installed forum based videobar.

Best Regards,
Jan Jaap

i got the same problem. all works (exept the doubble videos in video.html) but when creating a new board i get this error:
Schwerer Fehler: Field seo_videos_bar is not defined in $validfields in class vb_datamanager_forum in /includes/class_dm.php (Zeile 485)
i downloaded the script yesterday

cu,
thomas

update: downloaded the new files from today; reinstalled the xml, installed the seo*.php - but still got the same error.
during installation:
taring update loop for the vBulletin Forum table
* Field "seo_videos_bar" did not exist, the field has been added to the table
* Field "seo_videos_bar" did not exist, the field has been added to the table
* Field "seo_videos_bar" did not exist, the field has been added to the table

[Adult SEO]

Hi!

Regarding MyVideo.de support, I might add this when I start a German forum as I might since I am planning to take over the forrestry market on the internet starting with The Netherlands: http://www.bosbouw.net/ and when the site is perfect expanding to Germany/Austria/Switserland (german speaking countries) and then English speaking countries and further to China, Japan etc. So there will also be a forum and when it's confirmed for me that my users might want to use myvideo.de I will add it for sure.

Best Regards,
Jan Jaap

[Adult SEO]

Originally Posted by mahakala

i got the same problem. all works (exept the doubble videos in video.html) but when creating a new board i get this error:
Schwerer Fehler: Field seo_videos_bar is not defined in $validfields in class vb_datamanager_forum in /includes/class_dm.php (Zeile 485)
i downloaded the script yesterday

cu,
thomas

update: downloaded the new files from today; reinstalled the xml, installed the seo*.php - but still got the same error.
during installation:
taring update loop for the vBulletin Forum table
* Field "seo_videos_bar" did not exist, the field has been added to the table
* Field "seo_videos_bar" did not exist, the field has been added to the table
* Field "seo_videos_bar" did not exist, the field has been added to the table

Hi!

The latest product (XML) contains a fix for that error. It's because the forum specific videobar was just partly developped.

Regarding videos.html to work, you need to upload htaccess.txt and rename it to .htaccess.

For this you need Mod Rewrite enabled on your server. It will rewrite videos.html to index.php?video=1 (in wich 1 is the page number).

Best Regards,
Jan Jaap

[Adult SEO]

Originally Posted by bklynjava

Its working in the posts but not in the frontpage in index.php

Will I have to run the installer again or just upload and overwrite the xml?

BTW Great Hack clicked install =)

I get nothing for video.html - am I supposed to?

Hi!

Make sure that you have Mod Rewrite enabled on your server and that you renamed htaccess.txt to .htaccess.

Best regards,
Jan Jaap

[murrtex]

thanks Adult SEO,

this is my test topic
http://www.4umturk.com/forum/konu-ve...fa-deneme.html

and this is videos page
http://www.4umturk.com/forum/videos.html

what is the wrong??

[chriszep]

hello
no problem to put a youtube or google video in a post

but on the videobar I see the title of the last video added but not picture or video :surprised:

[mahakala]

hi jan,

Originally Posted by Adult SEO

The latest product (XML) contains a fix for that error. It's because the forum specific videobar was just partly developped.

sorry, still same error. deinstalled, reinstalled, .... NO

Originally Posted by Adult SEO

Regarding videos.html to work, you need to upload htaccess.txt and rename it to .htaccess.

the problem was not the htaccess, but the same videos a few times in video.html

thomas

update: i think the installer.php doesnt create the sql entry. seovidoes exist but seo_videos_bar dont. do you have a manual sql-code?

[iran.gs]

Very nice Installed

[Adult SEO]

Originally Posted by mahakala

hi jan,



sorry, still same error. deinstalled, reinstalled, .... NO



the problem was not the htaccess, but the same videos a few times in video.html

thomas

update: i think the installer.php doesnt create the sql entry. seovidoes exist but seo_videos_bar dont. do you have a manual sql-code?

Hi!

I've deleted and then reuploaded the lates product XML and installer.

Please try again and let me know if it works now.

Best Regards,
Jan Jaap