vb.org Archive - Finding Last Video Post

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

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - Finding Last Video Post (https://vborg.vbsupport.ru/showthread.php?t=199761)

vbplusme

12-25-2008 06:00 AM

Finding Last Video Post

A lot of site are allowing their members to post video object code, like YouTube for example. When submitted, vBulletin just stores the code like it is part of the message. The question is, how does one find posts that contain the object code, more specifically, how would you find the "last" post that contains video code as in "The Latest Video" to display a thumbnail on front page of the forum?

So basically, you need to find the most recent post that contains a video. Any ideas or an easy solution for this issue?

Any help greatly appreciated.

TIA

Jinovich

12-25-2008 05:34 PM

Code:

SELECT * FROM `post` WHERE `pagetext` LIKE '%<BBCODE>%' ORDER BY `postid` DESC LIMIT 0,30

This SQL query will display the last post with that code in. Replace <BBCODE> with the code used for videos.

vbplusme

12-26-2008 02:55 AM

Perfect, exactly the direction I needed. I really appreciate it.

thanks very much, Michael

All times are GMT. The time now is 03:53 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00973 seconds Memory Usage 1,708KB 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 (1)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)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 bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: