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

[lairnoc]

oops i have database problems now

Database error in vBulletin 3.6.3:

Invalid SQL:
SELECT * FROM `seovideos` WHERE `post_id`!='0' ORDER BY `date_added` DESC LIMIT 4;

MySQL Error : Unknown column 'post_id' in 'where clause'
Error Number : 1054
Date : Wednesday, November 15th 2006 @ 12:30:09 PM
Script : http://www.funclan.nl/index.php
Referrer :
IP Address : x.x.x.x
Username : lairnoc
Classname : vb_database


how do i solve this now my forum is not accessable anymore

is there an uninstall.php ass well maybe?

[lairnoc]

alsoi get this
Fatal error: Field seo_videos_bar is not defined in $validfields in class vb_datamanager_forum in \includes\class_dm.php on line 485

[lairnoc]

and also this

Database error in vBulletin 3.6.3:

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

MySQL Error : Unknown column 'post_id' in 'where clause'
Error Number : 1054
Date : Wednesday, November 15th 2006 @ 12:38:48 PM
Script : http://www.funclan.nl/inlinemod.php?...97,40098,40099
Referrer : http://www.funclan.nl/inlinemod.php?...d=4924&p=40098
IP Address : x.x.x.x
Username : lairnoc
Classname : vb_database

[redlabour]

Originally Posted by lairnoc

how do i solve this now my forum is not accessable anymore

is there an uninstall.php ass well maybe?

Delete the Table with phpMyAdmin and deinstall the Product from AdminCp.

[lairnoc]

euh ok

i'll try.. don't know much about phpadmin actually

[transitbus]

For those gettng dtabase errors, I fixed it here:

https://vborg.vbsupport.ru/showpost....5&postcount=55


Basically the code is not finsihed yet and the install script doesn't add a few neccessary tables.

Don't mean to be harsh but if oyu do not understand how to removed tables from phpmyadmin, you probabbly shouldn't install addons without making sure they are working first.

If the author doesn't fix this today (I am sure he will), I will see what i can do to make an uninstaller for the mysql end, even if a crude one.

[Adult SEO]

Hi!

My appologies for all the bugs, but I want to ensure you that all will be fixed and optimum within a matter of days as I am actualy developing this mod for my own forum so it will be worked on untill it's done and it will be optimized.

Today I will develop an errorsafe installer and complete the video bar feature.

The installer will also make sure that if your tables are installed partly that the instalation will be completed.

I'm aspecting all will be ready in a few hours.

Best Regards,
Jan Jaap

[abramelin]

we are waiting for it also do not forget the vba module please

[Adult SEO]

Hi!

I don't use vBa myself, could you please explain what it is?

It might work as global_start (on all pages of the forum) will rewrite <!-- SEO Videos Index Bar --> with your configured videobar.

Best Regards,
Jan Jaap

[abramelin]

vba = vbadvanced
portal for vbulletin