vb.org Archive - Board Optimization - SEO YouTube and Google Videos

Page 1 of 9

Last »

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)

- - Board Optimization - SEO YouTube and Google Videos (https://vborg.vbsupport.ru/showthread.php?t=131567)

Adult SEO

11-13-2006 10:00 PM

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:

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:

https://vborg.vbsupport.ru/external/2006/11/4.jpg

https://vborg.vbsupport.ru/external/2006/11/4.jpg

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

P.Jackson

11-14-2006 07:08 PM

awsome addon :)

abramelin

11-14-2006 07:08 PM

i am using custom bbcode for youtube so if i want to install this mod i should uninstall the bbcode am i right? and how this is looks in postbit? can you show a screen from there too?

Lqd	11-14-2006 07:09 PM

*installs*

Thanks a lot! This is a very good replacement for the anymedia thing, since they dont want to move on to 3.6.x I am going to give this a try, and the way it looks won't be needing more then this one!

Kaleem

11-14-2006 07:24 PM

Quote:

Originally Posted by Lqd (Post 1117314)

If it work out let me know i will use it too :)

blue6995

11-14-2006 07:31 PM

Getting this message:

Failed to recognized your video code, please enter the video ID or full video URL wich contains the Video ID.

lovelypk

11-14-2006 07:31 PM

Nice

Adult SEO

11-14-2006 07:34 PM

Quote:

Originally Posted by abramelin (Post 1117313)

i am using custom bbcode for youtube so if i want to install this mod i should uninstall the bbcode am i right? and how this is looks in postbit? can you show a screen from there too?

You could keep the YouTube bbcode if you want by disabling YouTube within the adminpanel or you could delete the YouTube bbcode and use this mod.

I've added a screenshot of the postbit btw!

Jan Jaap

Adult SEO

11-14-2006 07:35 PM

Quote:

Originally Posted by blue6995 (Post 1117329)

Getting this message:

Failed to recognized your video code, please enter the video ID or full video URL wich contains the Video ID.

Hi!

Please let me know the content you use between the tags. ([googlevideo]...[/googlevideo])

Best Regards,
Jan Jaap

blue6995

11-14-2006 07:40 PM

Quote:

Originally Posted by Adult SEO (Post 1117336)

Hi!

Please let me know the content you use between your tags.

Best Regards,
Jan Jaap

I'm taking directly from youtube:

http://www.youtube.com/watch?v=xC7fjv3J31M

taxick

11-14-2006 07:47 PM

Hey :)

I get this error, when i have make are post, and i wont to se it :(

Quote:

Table 'forum.forum_seovideos' doesn't exist

Plz Help

Adult SEO

11-14-2006 07:57 PM

Quote:

Originally Posted by blue6995 (Post 1117351)

I'm taking directly from youtube:

http://www.youtube.com/watch?v=xC7fjv3J31M

It works fine for me: http://www.papegaaienforum.com/edelp....html#post1837

Please investigate if you made a mistake yourself otherwise I will try to find the reason that it doesn't work for you.

Please also let me know your vBulletin version.

Best Regards,
Jan Jaap

Adult SEO

11-14-2006 07:59 PM

Quote:

Originally Posted by taxick (Post 1117365)

Hey :)

I get this error, when i have make are post, and i wont to se it :(

Plz Help

Hi!

What vBulletin version are you using, it might be that vBulletin 3.5.x doesn't have support for product based MySQL instalation and uninstalation instructions.

If so, you could look in the product on top to see the MySQL to execute (2 queries, 1 to create a table and 1 to optimize it by setting an index).

It might be that this mod also works with vBulletin 3.5.x when you install the MySQL manualy.

Best Regards,
Jan Jaap

redlabour

11-14-2006 08:00 PM

Well done ! :D

Can you add Quicktime and WMA etc. to the next Update ?

blue6995

11-14-2006 08:02 PM

Quote:

Originally Posted by Adult SEO (Post 1117377)

Oops, I am using version 3.6.0. Is that the reason why?

joopss

11-14-2006 08:03 PM

Tanks...........

Adult SEO

11-14-2006 08:06 PM

Quote:

Originally Posted by redlabour (Post 1117380)

Well done ! :D

Can you add Quicktime and WMA etc. to the next Update ?

Well, for my users I don't need this ability and Any Media might be better for it as it's already developped and existing for some time. This mod is just for implementing support for publishing of free hosted videos.

But if I need it in the future I will extend this mod for it.

Adult SEO

11-14-2006 08:08 PM

Quote:

Originally Posted by blue6995 (Post 1117384)

Oops, I am using version 3.6.0. Is that the reason why?

Well, I don't know for sure. It should work I think since the verification functions are actualy standard preg_match PHP functions.

But maybe a sertain hook is placed on a difrent location in vB3.6.0 so that the variables required to check on aren't available.

Best would be to upgrade to 3.6.3.

Ricsca

11-14-2006 08:08 PM

Tnaks! :)

redlabour

11-14-2006 08:09 PM

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 .... :/

Adult SEO

11-14-2006 08:12 PM

Quote:

Originally Posted by redlabour (Post 1117396)

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

11-14-2006 08:26 PM

Quote:

Originally Posted by redlabour (Post 1117396)

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

11-14-2006 08:29 PM

Error:

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

Whay ?

Bye

Adult SEO

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

11-14-2006 08:37 PM

Quote:

Originally Posted by Adult SEO (Post 1117407)

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

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

11-14-2006 08:41 PM

Quote:

Originally Posted by transitbus (Post 1117419)

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

11-14-2006 08:44 PM

Quote:

Originally Posted by redlabour (Post 1117418)

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

11-14-2006 08:46 PM

Quote:

Originally Posted by Ricsca (Post 1117409)

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

11-14-2006 08:49 PM

Quote:

Originally Posted by redlabour (Post 1117418)

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.

redlabour

11-14-2006 09:01 PM

Quote:

Originally Posted by Adult SEO (Post 1117425)

Could it be that the Problems results because of using PHP5 with mySQLi enabled ?

Adult SEO

11-14-2006 09:05 PM

Well, the latest product should fix this as it doesn't use standard PHP MySQL functions anymore wich might have been the reason that it didn't work.

But I don't think this could cause change of information in the database.

But if you would like and have time for it, could you please test if the latest product works for you? So if it doesn't work, I could try to find a solution for it.

Best Regards,
Jan Jaap

transitbus

11-14-2006 09:10 PM

well new error trying to run the php script:

Quote:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ENGINE = MYISAM' at line 6

fixed it sort of by changing 'ENGINE = MYISAM' to TYPE=MYISAM. It creates the table but give a false error of not being able to update.

Adult SEO

11-14-2006 09:31 PM

Quote:

Originally Posted by transitbus (Post 1117442)

well new error trying to run the php script:

Hi!

I've removed the MYISAM configuration from the installer so it should work now, could you please try again and let me know?

Best Regards,
Jan Jaap

transitbus

11-14-2006 09:40 PM

Got it working but now I ahve a problem

When a video embedded into a thread is deleted by deleting that post or thread, a sql entry is retained into the database. Not only that but it seem two entries are entered.

Would it be possible to have it so when the thread or post is deleted, the sql entry is deleted? Or at least a function in the admin CP to allow the pruning of the table?

There is also the issue withthe ID only reading 0 on all the sql entries

And lastly, you can not put in the whole link for a google video, it hasto be only the id number?

redlabour

11-14-2006 09:44 PM

Quote:

Originally Posted by Adult SEO (Post 1117439)

No - i just makes more Problems :

Quote:

MySQL-Fehler : Table 'usrdb_poltbofu.vb3_seovideos' doesn't exist

In anyway - this should be fixed by Installer. But your Hack is not longer interesting because all Links of the old Hack are using only the VideoID and you are using the full Url. We have changed this after AnyMedia is gone and now again ? That?s to much. ;)

transitbus

11-14-2006 09:45 PM

one more for you: Uninstalling the mod does not uninstall the sql table

Adult SEO

11-14-2006 09:53 PM

Quote:

Originally Posted by redlabour (Post 1117471)

No - i just makes more Problems :

In anyway - this should be fixed by Installer. But your Hack is not longer interesting because all Links of the old Hack are using only the VideoID and you are using the full Url. We have changed this after AnyMedia is gone and now again ? That?s to much. ;)

Hi!

Indeed, you will now need to use the installer to install the database as the build in XML MySQL instalation doesn't seem stable.

Regarding the contents of the tag, you can even post the embedding codes and it will work. (thus also just the ID will work) so you don't need to change anything to use this mod.

Best Regards,
Jan Jaap

Adult SEO

11-14-2006 09:57 PM

Quote:

Originally Posted by transitbus (Post 1117466)

Hi!

I will add a function wich will delete videos from a post that is deleted.

Regarding the ID only issue, I will investigate it now.

Regarding the whole link, you should be able to post anything from the google video site with the video ID included to get it to work, even the embedded code should work!

I will post here if the mod is updated.

Best Regards,
Jan Jaap

transitbus

11-14-2006 09:59 PM

Ok I will wiat to hear about your progress. Overall good job on the mod, just needthe bugs worked out

All times are GMT. The time now is 06:10 AM.

Page 1 of 9

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01737 seconds Memory Usage 1,860KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_php_printable (24)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: