The Arcive of Official vBulletin Modifications Site.

SEO YouTube and Google Videos · **Released**: 11-13-2006

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:

Import the XML product
Upload the attached icon images (or use your own)
- Default is:
  - /images/editor/google.gif
  - /images/editor/youtube.gif
Open htaccess.txt, configure it (replace yourdomain with your domain), save it as .htaccess and upload it to the root of your forum
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.
To install the Videobar anywhere on the forum use the folowing code:
- PHP Code:

Done.

Have Fun!
Jan Jaap

Screenshots:

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

Adult SEO · #22 11-14-2006, 08:12 PM

Quote:

Originally Posted by redlabour

Argh - i get the Errormessage :

"No Database selected" on a white Page after i entered the first Youtube Video in a Post.

I use 3.6.3 !

Ok, it might be that it is due to that I don't use the vBulletin MySQL object but the default PHP MySQL functions wich work fine on my server.

I will upgrade the mod to use the vBulletin MySQL object to see if this will fix the problem for you.

Best Regards,
Jan Jaap

Adult SEO · #23 11-14-2006, 08:26 PM

Quote:

Originally Posted by redlabour

Argh - i get the Errormessage :

"No Database selected" on a white Page after i entered the first Youtube Video in a Post.

I use 3.6.3 !

Even if the Hack is deactivated or not.

And it is ignoring all old short Links from "Embed XHTML valid YouTube and Google Video into your posts" so over hundreds Links have to be corrected.

Klick uninstalled. Sorry .... :/

Hi!

This has nothing to do with this mod, 100% sure.

Why? Because this mod does not change any links.

I've upgraded the mod however so it uses the standard vBulletin database functions, wich might make it faster.

Best Regards,
Jan Jaap

Ricsca · #24 11-14-2006, 08:29 PM

Error:

"Table 'tartaporta_mkp2.vb_seovideos' doesn't exist"

Whay ?

Bye

Adult SEO · #25 11-14-2006, 08:36 PM

Hi!

Sorry, I've found the problem.

When saving the Product from within vBulletin the instalation information isn't preserved.

Just to be sure, I will add an seperate install script.

Best Regards,
Jan Jaap

redlabour · #26 11-14-2006, 08:37 PM

Quote:

Originally Posted by Adult SEO

Hi!

This has nothing to do with this mod, 100% sure.

No Database selected is only appearing for Posting with your Mod installed and youtube and/or google link in it.

transitbus · #27 11-14-2006, 08:38 PM

Fatal error: Call to a member function on a non-object in /home/shebalis/public_html/includes/class_bbcode.php(166) : eval()'d code on line 15

When trying to link a google video

for example:

http://video.google.com/videoplay?do...62058784&hl=en

In fact this mod screwed up my entire posting functions

Adult SEO · #28 11-14-2006, 08:41 PM

Quote:

Originally Posted by transitbus

Fatal error: Call to a member function on a non-object in /home/shebalis/public_html/includes/class_bbcode.php(166) : eval()'d code on line 15

When trying to link a google video

for example:

http://video.google.com/videoplay?do...62058784&hl=en

Hi!

I am verry verry sorry for this, I uploaded an untested product and then tested it to see this error, I then deleted the product but you must have downloaded it within these 5 minutes.

It's fixed now, please download the latest product for it to work.

You might also need to run the included installer.

Best Regards,
Jan Jaap

Adult SEO · #29 11-14-2006, 08:44 PM

Quote:

Originally Posted by redlabour

No Database selected is only appearing for Posting with your Mod installed and youtube and/or google link in it.

Hi!

Please download the latest product XML and installer and please try again if you want. The mod doesn't touch the MySQL connection at all so I am not aspecting that the plugin is able to cause the loss of the MySQL connection.

Best Regards,
Jan Jaap

Adult SEO · #30 11-14-2006, 08:46 PM

Quote:

Originally Posted by Ricsca

Error:

"Table 'tartaporta_mkp2.vb_seovideos' doesn't exist"

Whay ?

Bye

Hi!

When saving a product with an XML configured installer the installer is lost, so please use the attached installer to install the database.

https://vborg.vbsupport.ru/attachmen...chmentid=55961

Best Regards,
Jan Jaap

Adult SEO · #31 11-14-2006, 08:49 PM

Quote:

Originally Posted by redlabour

No Database selected is only appearing for Posting with your Mod installed and youtube and/or google link in it.

Just so you know: The only MySQL that is used is to:

check the seovideos table to see if a video has been parsed before, if so it will return the information.
insert the information of a video into the seovideos table after parsing the video.

There is no other MySQL used in this mod.

PHP Code:


			
$result = $db->query_read("SELECT id,title FROM `".TABLE_PREFIX."seovideos` WHERE `video_id`='".addslashes($videoid)."' AND `type`='google' LIMIT 1");

if ($db->num_rows($result)) {

    $video_info = $db->fetch_array($result);

    if ($video_info["title"] == 'seovideos-no-title') {

        $video_info["title"] = $vbulletin->options["seo_videos_default_google_title"];

    }

    return $video_info["title"];

} else {

    .... PARSING OF THE VIDEO ...

    $result = $db->query_write("INSERT INTO `".TABLE_PREFIX."seovideos` ( `id` , `type` , `video_id` , `title` ) VALUES ('', 'google', '".addslashes($videoid)."', '".addslashes($title)."');");

}

That's all.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04835 seconds Memory Usage 2,330KB Queries Executed 26 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (2)bbcode_php (7)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!