Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.6 > vBulletin 3.6 Add-ons
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
SEO YouTube and Google Videos Details »»
SEO YouTube and Google Videos
Version: 1.00, by Adult SEO Adult SEO is offline
Developer Last Online: Nov 2013 Show Printable Version Email this Page

Category: Board Optimization - Version: 3.6.4 Rating:
Released: 11-13-2006 Last Update: 02-17-2007 Installs: 142
DB Changes Uses Plugins Template Edits
Additional Files  
No support by the author.

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

Supporters / CoAuthors

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #32  
Old 11-14-2006, 09:01 PM
redlabour's Avatar
redlabour redlabour is offline
 
Join Date: Mar 2004
Location: Wuppertal, NRW, Germany
Posts: 1,541
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Adult SEO View Post
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
Could it be that the Problems results because of using PHP5 with mySQLi enabled ?
Reply With Quote
  #33  
Old 11-14-2006, 09:05 PM
Adult SEO's Avatar
Adult SEO Adult SEO is offline
 
Join Date: May 2006
Location: The Netherlands
Posts: 291
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #34  
Old 11-14-2006, 09:10 PM
transitbus transitbus is offline
 
Join Date: Aug 2006
Location: California
Posts: 97
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #35  
Old 11-14-2006, 09:31 PM
Adult SEO's Avatar
Adult SEO Adult SEO is offline
 
Join Date: May 2006
Location: The Netherlands
Posts: 291
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by transitbus View Post
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
Reply With Quote
  #36  
Old 11-14-2006, 09:40 PM
transitbus transitbus is offline
 
Join Date: Aug 2006
Location: California
Posts: 97
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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?
Reply With Quote
  #37  
Old 11-14-2006, 09:44 PM
redlabour's Avatar
redlabour redlabour is offline
 
Join Date: Mar 2004
Location: Wuppertal, NRW, Germany
Posts: 1,541
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Adult SEO View Post
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
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.
Reply With Quote
  #38  
Old 11-14-2006, 09:45 PM
transitbus transitbus is offline
 
Join Date: Aug 2006
Location: California
Posts: 97
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

one more for you: Uninstalling the mod does not uninstall the sql table
Reply With Quote
  #39  
Old 11-14-2006, 09:53 PM
Adult SEO's Avatar
Adult SEO Adult SEO is offline
 
Join Date: May 2006
Location: The Netherlands
Posts: 291
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by redlabour View Post
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
Reply With Quote
  #40  
Old 11-14-2006, 09:57 PM
Adult SEO's Avatar
Adult SEO Adult SEO is offline
 
Join Date: May 2006
Location: The Netherlands
Posts: 291
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by transitbus View Post
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?
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
Reply With Quote
  #41  
Old 11-14-2006, 09:59 PM
transitbus transitbus is offline
 
Join Date: Aug 2006
Location: California
Posts: 97
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 05:33 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04985 seconds
  • Memory Usage 2,327KB
  • 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
  • (1)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