Printable View
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
does your host provide database management software (e.g., phpMyAdmin)? You can see the table structure from there.
Yes it does. the table "_vbullthread" is the table where all of the videos are stored.
In phpMyAdmin, you can get the table structure by going to the database in question, clicking on the [SQL] tab, and entering this query:just post the result here.Code:SHOW CREATE TABLE `_vbullthread`
This is what I got
Code: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
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?
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.
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?
Ok, I'll check
This is the table with the URLS. '_vbullpost'
This is what the table data looks like when browsingCode: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
Code: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