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

Page 6 of 33

« First

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)

smoknz28

11-15-2006 02:31 AM

Nice hack! ;) But maybe this just isn't meant to work with vB 3.6.2 as I'm running.

I ran the videos_install.php and seems like it ran correctly:

MySQL database updated, added table "seovideos" to the database.
MySQL database updated, added index "video_id" for table "seovideos"

I'm attempting to work this hack now. I tried to insert a google video by adding copying and pasting the url to the video in the bbcode....but got the following database error:

Database error in vBulletin 3.6.2:

Invalid SQL:
INSERT INTO `seovideos` ( `id` , `type` , `video_id` , `title` ) VALUES ('', 'google', '2618184165672891020', 'INSANELY Funny commercial of a girl taking a guys shorts ! WOW ! ';

MySQL Error : 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 '' at line 1
Error Number : 1064
Date : Tuesday, November 14th 2006 @ 10:41:31 PM
Script : http://www.f-bodyhideout.com/forums/...ostthread&f=26
Referrer : http://www.f-bodyhideout.com/forums/...newthread&f=26
IP Address : 72.197.32.40
Username : Admin
Classname : vB_Database

Adult SEO

11-15-2006 03:35 AM

Well, that might be a bug wich has been fixed now.

I've added "latest videos" for on the index page (you can also set from wich forums you want to display videos) and tomorow (later today, it's 6:34 am now) I will complete the forum specific video bar.

A demo of the videobar is available on http://www.papegaaienforum.com/

Have Fun!
Jan Jaap

abramelin

11-15-2006 04:14 AM

videos arent showing, just blank area also if you can make latest videos for vba it will be more fantastic!

transitbus

11-15-2006 05:04 AM

Quote:

Database error in vBulletin 3.6.3:

Invalid SQL:
SELECT id,title FROM `seovideos` WHERE `video_id`='2844183475996675652' AND `post_id`='2681' AND `type`='google' LIMIT 1;

MySQL Error : Unknown column 'post_id' in 'where clause'
Error Number : 1054

trying to delete a post. I can only delete a post if the addon is disabled

Also if you runthe install php file morethan once you get a sql error about the columns already existing in the forum table

Looks to me like you need id , type , video_id , title, post_id, forum_id, date_added but you only have id , type , video_id , title as fields. What should post_id, forum_id, date_added be? INT(255)?

transitbus

11-15-2006 05:25 AM

there is still the issue where you can only link by ID and not the entire hyperlink but that is actually ok, it should be like that.

Ok fixed it:

Find:

Code:

`id` INT( 20 ) NOT NULL ,

`type` SET( 'google', 'youtube' ) NOT NULL ,

`video_id` INT( 255 ) NOT NULL ,

`title` VARCHAR( 255 ) NOT NULL

and replace with

Code:

`id` INT( 20 ) NOT NULL ,

`type` SET( 'google', 'youtube' ) NOT NULL ,

`video_id` INT( 255 ) NOT NULL ,

`title` VARCHAR( 255 ) NOT NULL ,

`post_id` INT( 10 ) NOT NULL ,

`forum_id` INT( 10 ) NOT NULL ,

`date_added` INT( 10 ) NOT NULL

I also included the replacemnt php file. I put the additions as int(10) to keep them small.

redlabour

11-15-2006 05:38 AM

Quote:

Originally Posted by Adult SEO (Post 1117480)

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

At YouTube only the full URL works. Only ID?s are ignored. :confused:

[yt]hWlecEKppTM[/yt] <- does still not work. (I use yt and gv as BB Codes).

I allyways get at every old Link :

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

Even if i post new Videos the same apperas. Something is other than before.

At full URLs i get :

Quote:

Datenbankfehler in vBulletin 3.6.3:

Invalid SQL:
SELECT id,title FROM `vb3_seovideos` WHERE `video_id`='CkS2DJ6VX' AND `post_id`='59259' AND `type`='youtube' LIMIT 1;

Sorry, that costs me to much Time.

transitbus

11-15-2006 06:00 AM

Youtube requires the full path right now and google requires everything after ?docid= and before either &q or &hl or both (which meansa - and all the numbers).

One more bug i noticed only once is after editing a file and viewing it, the header information on top of the browser said "#postid=xxxx, postid=xxxx" instead of the name of the post.

redlabour

11-15-2006 06:08 AM

Quote:

Originally Posted by transitbus (Post 1117759)

Youtube requires the full path right now and google requires everything after ?docid= and before either &q or &hl or both (which meansa - and all the numbers).

Nice to know - but i have no Time to test it again and again. I have to delete the PlugIn from old Hack and 2 vBCodes and reinstall it then. Sorry Guys ....

silks

11-15-2006 08:24 AM

databass error for me had to delete post

Hornstar

11-15-2006 08:45 AM

This looks awesome, I will give this a go for sure.

Edit: where is the install button? can you give us the link because I think vbulletin has removed the install button and I want to tag this thread.
Edit: nvm

THanks.

All times are GMT. The time now is 05:46 AM.

Page 6 of 33

« First

Last »

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01350 seconds Memory Usage 1,746KB 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_code_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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: