Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 30

Thread: PHP Retrieve data from DB Table

  1. #11
    Join Date
    Mar 2009
    Posts
    74
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Default

    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

  2. #12
    Join Date
    Apr 2008
    Location
    So.Cal
    Posts
    3,643
    Thanks
    63
    Thanked 516 Times in 502 Posts
    Blog Entries
    5

    Default

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

  3. #13
    Join Date
    Mar 2009
    Posts
    74
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Default

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

  4. #14
    Join Date
    Apr 2008
    Location
    So.Cal
    Posts
    3,643
    Thanks
    63
    Thanked 516 Times in 502 Posts
    Blog Entries
    5

    Default

    In phpMyAdmin, you can get the table structure by going to the database in question, clicking on the [SQL] tab, and entering this query:
    Code:
    SHOW CREATE TABLE `_vbullthread`
    just post the result here.

  5. #15
    Join Date
    Mar 2009
    Posts
    74
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Default

    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
    Last edited by traq; 11-18-2012 at 08:57 PM.

  6. #16
    Join Date
    Apr 2008
    Location
    So.Cal
    Posts
    3,643
    Thanks
    63
    Thanked 516 Times in 502 Posts
    Blog Entries
    5

    Default

    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?

  7. #17
    Join Date
    Mar 2009
    Posts
    74
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Default

    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.

  8. #18
    Join Date
    Apr 2008
    Location
    So.Cal
    Posts
    3,643
    Thanks
    63
    Thanked 516 Times in 502 Posts
    Blog Entries
    5

    Default

    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?

  9. #19
    Join Date
    Mar 2009
    Posts
    74
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Default

    Ok, I'll check

  10. #20
    Join Date
    Mar 2009
    Posts
    74
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Default

    This is the table with the URLS. '_vbullpost'

    Code:
    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

    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

Similar Threads

  1. Replies: 0
    Last Post: 10-21-2011, 07:41 PM
  2. retrieve the data from sql to textbox
    By kiranbvsn in forum PHP
    Replies: 0
    Last Post: 02-20-2010, 06:53 AM
  3. Content Slider & retrieve data from mysql
    By ajloun in forum MySQL and other databases
    Replies: 1
    Last Post: 02-16-2010, 12:04 AM
  4. Replies: 4
    Last Post: 03-04-2009, 03:36 PM
  5. Replies: 21
    Last Post: 08-30-2007, 09:15 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •