Thread: vbtube_tubes -> Link Table in DB

In my db when i first started using vbtube it used to add the link to the post automatically. Now when i check the db only the old ones have the link field filled in and not the new videos. Where are the links generated I have created an RSS feed for vbtube but my problem is that since the link field is now empty on all my new videos. the rss cant link to it.

where can i find the dates of the posted items

NVM I figured it Out.

Just need to know where i can query posted dates from. PLEASE!

Where are the posted dates stored?

in vbtube_show.php

Code:

		$cmnt['posttime']=vbdate($vbulletin->options['timeformat'], $cmnt['dateline']);
		$cmnt['dateline']=vbdate($vbulletin->options['dateformat'], $cmnt['dateline'], true);

is this responsible for the post date?

Yes..............

Thanks.............

Originally Posted by demo7up

in vbtube_show.php

Code:

		$cmnt['posttime']=vbdate($vbulletin->options['timeformat'], $cmnt['dateline']);
		$cmnt['dateline']=vbdate($vbulletin->options['dateformat'], $cmnt['dateline'], true);

is this responsible for the post date?

Is there any why you can tell me what i need to do to query the post date in an external php script. Like what includes i need etc.. Thanks.

vbdate is a vbulletin function so :

PHP Code:

// Include Globals
require_once('./global.php'); 


PHP Code:

$cmnt['dateline'] 


is a db entry in vbtube_tubes table
So you need a db query to read this.

you are awesome