Advanced Search

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,625
    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.
    We Only Torture the Folks We Don't Like (You're Probably Gonna Be Okay)
    It's a Party in the CIA

  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,625
    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.
    We Only Torture the Folks We Don't Like (You're Probably Gonna Be Okay)
    It's a Party in the CIA

  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 07:57 PM.

  6. #16
    Join Date
    Apr 2008
    Location
    So.Cal
    Posts
    3,625
    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?
    We Only Torture the Folks We Don't Like (You're Probably Gonna Be Okay)
    It's a Party in the CIA

  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,625
    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?
    We Only Torture the Folks We Don't Like (You're Probably Gonna Be Okay)
    It's a Party in the CIA

  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, 06:41 PM
  2. retrieve the data from sql to textbox
    By kiranbvsn in forum PHP
    Replies: 0
    Last Post: 02-20-2010, 05:53 AM
  3. Content Slider & retrieve data from mysql
    By ajloun in forum MySQL and other databases
    Replies: 1
    Last Post: 02-15-2010, 11:04 PM
  4. Replies: 4
    Last Post: 03-04-2009, 02:36 PM
  5. Replies: 21
    Last Post: 08-30-2007, 08: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
  •