PHP Retrieve data from DB Table

[igotregistered]

Ok, I'd like to give it a shot then. I've sent a message to the developer of vbtube, (my video portal script) asking him which table(s) are used to store the video data. I appreciate you working with me trying to figure this out. Once I hear back I will post the table info. Thank you

[traq]

does your host provide database management software (e.g., phpMyAdmin)? You can see the table structure from there.

[igotregistered]

Yes it does. the table "_vbullthread" is the table where all of the videos are stored.

[traq]

In phpMyAdmin, you can get the table structure by going to the database in question, clicking on the [SQL] tab, and entering this query:

SHOW CREATE TABLE `_vbullthread`

just post the result here.

[igotregistered]

This is what I got

CREATE TABLE `_vbullthread` (
  `threadid` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(250) NOT NULL default '',
  `firstpostid` int(10) unsigned NOT NULL default '0',
  `lastpostid` int(10) unsigned NOT NULL default '0',
  `lastpost` int(10) unsigned NOT NULL default '0',
  `forumid` smallint(5) unsigned NOT NULL default '0',
  `pollid` int(10) unsigned NOT NULL default '0',
  `open` smallint(6) NOT NULL default '0',
  `replycount` int(10) unsigned NOT NULL default '0',
  `hiddencount` int(10) unsigned NOT NULL default '0',
  `deletedcount` int(10) unsigned NOT NULL default '0',
  `postusername` varchar(100) NOT NULL default '',
  `postuserid` int(10) unsigned NOT NULL default '0',
  `lastposter` varchar(50) NOT NULL default '',
  `dateline` int(10) unsigned NOT NULL default '0',
  `views` int(10) unsigned NOT NULL default '0',
  `iconid` smallint(5) unsigned NOT NULL default '0',
  `notes` varchar(250) NOT NULL default '',
  `visible` smallint(6) NOT NULL default '0',
  `sticky` smallint(6) NOT NULL default '0',
  `votenum` smallint(5) unsigned NOT NULL default '0',
  `votetotal` smallint(5) unsigned NOT NULL default '0',
  `attach` smallint(5) unsigned NOT NULL default '0',
  `similar` varchar(55) NOT NULL default '',
  `prefixid` varchar(25) NOT NULL default '',
  `taglist` mediumtext,
  `vbseo_linkbacks_no` int(10) unsigned NOT NULL default '0',
  `ttype` int(10) unsigned NOT NULL default '0',
  `autoskip` smallint(6) default '0',
  `description` varchar(250) NOT NULL default '',
  `vbtpost` int(2) unsigned NOT NULL default '0',
  `vbseo_likes` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`threadid`),
  KEY `postuserid` (`postuserid`),
  KEY `pollid` (`pollid`),
  KEY `forumid` (`forumid`,`visible`,`sticky`,`lastpost`),
  KEY `lastpost` (`lastpost`,`forumid`),
  KEY `dateline` (`dateline`),
  KEY `prefixid` (`prefixid`,`forumid`),
  KEY `replycount` (`replycount`),
  KEY `visible` (`visible`),
  KEY `open` (`open`),
  FULLTEXT KEY `title` (`title`)
) ENGINE=MyISAM AUTO_INCREMENT=37393 DEFAULT CHARSET=utf8

[traq]

That doesn't seem to reference the videos themselves (in fact, that looks more like a native part of VBulletin, not a table for an external script...?). Are there any tables in your DB that contain fields that look like URLs to videos?

[igotregistered]

the script is called "vbtube professional". It is basically a plugin for vbulletin. A very very large plugin. It's not standalone. It requires a full vbulletin infrastructure in order to work.

[traq]

understood... but still, I don't see anything that references videos in the table you posted - it looks more like it deals with the threads themselves. Can you find any tables in your DB that hold values that look like URLs to videos?

[igotregistered]

Ok, I'll check

[igotregistered]

This is the table with the URLS. '_vbullpost'

SQL result

Host: 10xxxxxxxxxx
Database: nhlfightclub
Generation Time: Nov 18, 2012 at 02:41 PM
Generated by: phpMyAdmin 2.11.11.3 / MySQL 4.1.24-log
SQL query: SHOW CREATE TABLE `_vbullpost`;
Rows: 1
Table 	Create Table
_vbullpost 	CREATE TABLE `_vbullpost` (\n  `postid` int(10) unsigned NOT NULL auto_increment,\n  `threadid` int(10) unsigned NOT NULL default '0',\n  `parentid` int(10) unsigned NOT NULL default '0',\n  `username` varchar(100) NOT NULL default '',\n  `userid` int(10) unsigned NOT NULL default '0',\n  `title` varchar(250) NOT NULL default '',\n  `dateline` int(10) unsigned NOT NULL default '0',\n  `pagetext` mediumtext,\n  `allowsmilie` smallint(6) NOT NULL default '0',\n  `showsignature` smallint(6) NOT NULL default '0',\n  `ipaddress` varchar(15) NOT NULL default '',\n  `iconid` smallint(5) unsigned NOT NULL default '0',\n  `visible` smallint(6) NOT NULL default '0',\n  `attach` smallint(5) unsigned NOT NULL default '0',\n  `infraction` smallint(5) unsigned NOT NULL default '0',\n  `reportthreadid` int(10) unsigned NOT NULL default '0',\n  `ame_flag` tinyint(4) NOT NULL default '0',\n  `post_thanks_amount` int(10) unsigned NOT NULL default '0',\n  `vbtpost` int(2) unsigned NOT NULL default '0',\n  PRIMARY KEY  (`postid`),\n  KEY `userid` (`userid`),\n  KEY `threadid` (`threadid`,`userid`),\n  KEY `dateline` (`dateline`),\n  KEY `visible` (`visible`),\n  FULLTEXT KEY `title` (`title`,`pagetext`)\n) ENGINE=MyISAM AUTO_INCREMENT=76515 DEFAULT CHARSET=utf8

This is what the table data looks like when browsing

Full Texts 	postid 	threadid 	parentid 	username 	userid 	title 	dateline 	pagetext 	allowsmilie 	showsignature 	ipaddress 	iconid 	visible 	attach 	infraction 	reportthreadid 	ame_flag 	post_thanks_amount 	vbtpost
	Edit 	Delete 	22 	20 	0 	442nd 	1 	John Kordic vs. Basil McRae 	1202501278 	[img]http://img.youtube.com/vi/hpXsS56jBUk/default... 	1 	0 	64.94.199.9 	0 	1 	0 	0 	0 	2 	0 	0