-- phpMyAdmin SQL Dump -- version 3.5.5 -- http://www.phpmyadmin.net -- -- Хост: localhost -- Время создания: Мар 01 2013 г., 03:39 -- Версия сервера: 5.1.68-beget-log -- Версия PHP: 5.2.17 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- База данных: `suppor16_now` -- -- -------------------------------------------------------- -- -- Структура таблицы `_vbvbtube_favourites` -- -- Создание: Фев 28 2013 г., 23:32 -- Последнее обновление: Фев 28 2013 г., 23:32 -- DROP TABLE IF EXISTS `_vbvbtube_favourites`; CREATE TABLE IF NOT EXISTS `_vbvbtube_favourites` ( `id` int(30) NOT NULL AUTO_INCREMENT, `title` mediumtext, `aboutme` mediumtext, `link` varchar(250) NOT NULL, `link1img` varchar(250) NOT NULL, `userid` int(30) NOT NULL, `tubeid` int(30) NOT NULL, `reviewid` int(20) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Структура таблицы `_vbvbtube_ip` -- -- Создание: Фев 28 2013 г., 23:32 -- Последнее обновление: Фев 28 2013 г., 23:32 -- DROP TABLE IF EXISTS `_vbvbtube_ip`; CREATE TABLE IF NOT EXISTS `_vbvbtube_ip` ( `id` int(6) unsigned NOT NULL AUTO_INCREMENT, `tubeid` int(20) unsigned NOT NULL, `ip` varchar(17) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ; -- -- Дамп данных таблицы `_vbvbtube_ip` -- INSERT INTO `_vbvbtube_ip` (`id`, `tubeid`, `ip`) VALUES (1, 1, '79.111.63.168'), (2, 3, '79.111.63.168'), (3, 2, '79.111.63.168'), (4, 4, '79.111.63.168'), (5, 5, '79.111.63.168'), (6, 6, '79.111.63.168'), (7, 6, '79.111.58.244'), (8, 1, '79.111.58.244'), (9, 7, '79.111.58.244'), (10, 9, '79.111.58.244'), (11, 8, '79.111.58.244'); -- -------------------------------------------------------- -- -- Структура таблицы `_vbvbtube_lastkeywords` -- -- Создание: Фев 28 2013 г., 23:32 -- Последнее обновление: Фев 28 2013 г., 23:32 -- DROP TABLE IF EXISTS `_vbvbtube_lastkeywords`; CREATE TABLE IF NOT EXISTS `_vbvbtube_lastkeywords` ( `keywordid` int(50) unsigned NOT NULL AUTO_INCREMENT, `lastkeywords` varchar(250) NOT NULL DEFAULT '', `username` varchar(250) NOT NULL DEFAULT '', `userid` int(20) unsigned NOT NULL DEFAULT '0', `userip` varchar(250) NOT NULL DEFAULT '', PRIMARY KEY (`keywordid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Структура таблицы `_vbvbtube_part` -- -- Создание: Фев 28 2013 г., 23:32 -- Последнее обновление: Фев 28 2013 г., 23:32 -- DROP TABLE IF EXISTS `_vbvbtube_part`; CREATE TABLE IF NOT EXISTS `_vbvbtube_part` ( `id` int(50) unsigned NOT NULL AUTO_INCREMENT, `tubeid` int(10) unsigned NOT NULL DEFAULT '0', `part` int(10) unsigned NOT NULL DEFAULT '0', `link` varchar(250) NOT NULL, `link1` longtext NOT NULL, `link2` longtext NOT NULL, `link3` longtext NOT NULL, `link4` longtext NOT NULL, `link1img` varchar(250) NOT NULL, `site` int(10) unsigned NOT NULL, `filename` varchar(30) NOT NULL DEFAULT '', `mext` varchar(6) NOT NULL, `msize` int(20) NOT NULL, `filename_mp4` varchar(30) NOT NULL DEFAULT '', `filename_img` varchar(30) NOT NULL DEFAULT '', `duration` varchar(15) NOT NULL DEFAULT '', `active` varchar(1) NOT NULL DEFAULT '0', `reviewid` int(10) unsigned NOT NULL DEFAULT '0', `mediatype` varchar(20) NOT NULL DEFAULT '', `del` int(1) unsigned NOT NULL DEFAULT '0', `deleted` int(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Структура таблицы `_vbvbtube_ratings` -- -- Создание: Фев 28 2013 г., 23:32 -- Последнее обновление: Фев 28 2013 г., 23:32 -- DROP TABLE IF EXISTS `_vbvbtube_ratings`; CREATE TABLE IF NOT EXISTS `_vbvbtube_ratings` ( `ratingid` int(10) unsigned NOT NULL AUTO_INCREMENT, `tubeid` int(10) unsigned DEFAULT NULL, `userid` int(10) unsigned DEFAULT NULL, `rate` int(3) unsigned DEFAULT NULL, `postdate` datetime DEFAULT NULL, PRIMARY KEY (`ratingid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ; -- -- Дамп данных таблицы `_vbvbtube_ratings` -- INSERT INTO `_vbvbtube_ratings` (`ratingid`, `tubeid`, `userid`, `rate`, `postdate`) VALUES (1, 1, 1, 5, NULL), (2, 6, 1, 5, NULL); -- -------------------------------------------------------- -- -- Структура таблицы `_vbvbtube_stack` -- -- Создание: Фев 28 2013 г., 23:32 -- Последнее обновление: Фев 28 2013 г., 23:32 -- DROP TABLE IF EXISTS `_vbvbtube_stack`; CREATE TABLE IF NOT EXISTS `_vbvbtube_stack` ( `id` int(20) unsigned NOT NULL AUTO_INCREMENT, `tubeid` int(20) unsigned NOT NULL, `filename` varchar(30) NOT NULL DEFAULT '', `mext` varchar(6) NOT NULL DEFAULT '', `msize` int(20) unsigned NOT NULL, `hd` int(1) unsigned NOT NULL, `progress` int(1) unsigned NOT NULL, `status` int(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- Дамп данных таблицы `_vbvbtube_stack` -- INSERT INTO `_vbvbtube_stack` (`id`, `tubeid`, `filename`, `mext`, `msize`, `hd`, `progress`, `status`) VALUES (1, 9, '784_9025', '.flv', 16539683, 1, 3, 0); -- -------------------------------------------------------- -- -- Структура таблицы `_vbvbtube_tubes` -- -- Создание: Фев 28 2013 г., 23:32 -- Последнее обновление: Фев 28 2013 г., 23:36 -- DROP TABLE IF EXISTS `_vbvbtube_tubes`; CREATE TABLE IF NOT EXISTS `_vbvbtube_tubes` ( `tubeid` int(20) unsigned NOT NULL AUTO_INCREMENT, `categoryid` int(3) unsigned NOT NULL DEFAULT '0', `forumid` int(10) unsigned NOT NULL DEFAULT '0', `userid` int(20) unsigned NOT NULL DEFAULT '0', `username` varchar(70) NOT NULL DEFAULT '', `email` varchar(70) NOT NULL DEFAULT '', `title` mediumtext, `vidlang` varchar(50) NOT NULL DEFAULT '', `link` varchar(170) NOT NULL DEFAULT '', `link1` longtext NOT NULL, `link2` longtext NOT NULL, `link3` longtext NOT NULL, `link1img` varchar(250) NOT NULL DEFAULT '', `thumb_type` int(1) unsigned NOT NULL DEFAULT '0', `filename` varchar(30) NOT NULL DEFAULT '', `mext` varchar(6) NOT NULL DEFAULT '', `msize` int(20) unsigned NOT NULL, `filename_mp4` varchar(30) NOT NULL DEFAULT '', `filename_img` varchar(30) NOT NULL DEFAULT '', `filename_img2` varchar(30) NOT NULL DEFAULT '', `photo_mp3` varchar(30) NOT NULL DEFAULT '', `url_flv` varchar(150) NOT NULL DEFAULT '', `ofilename` varchar(20) NOT NULL DEFAULT '', `oext` varchar(6) NOT NULL DEFAULT '', `osize` int(20) unsigned NOT NULL, `mediatype` varchar(50) NOT NULL DEFAULT '', `site` varchar(50) NOT NULL DEFAULT '', `aboutme` longtext, `active` varchar(1) NOT NULL DEFAULT '0', `tube` varchar(50) NOT NULL DEFAULT '', `views` int(30) unsigned NOT NULL DEFAULT '0', `votes` int(10) unsigned NOT NULL DEFAULT '0', `rates` int(10) unsigned NOT NULL DEFAULT '0', `rating` double(5,2) unsigned NOT NULL DEFAULT '0.00', `duration` varchar(15) NOT NULL DEFAULT '', `keywords` varchar(250) NOT NULL DEFAULT '', `joindate` int(10) unsigned NOT NULL DEFAULT '0', `reviewid` int(10) unsigned NOT NULL DEFAULT '0', `positive` int(10) unsigned NOT NULL DEFAULT '0', `negative` int(10) unsigned NOT NULL DEFAULT '0', `reported` varchar(1) NOT NULL DEFAULT '0', `reporteruser` varchar(50) NOT NULL DEFAULT '', `reportreason` mediumtext, `reportcategory` varchar(50) NOT NULL DEFAULT '', `lastpost` int(10) unsigned NOT NULL DEFAULT '0', `lastposter` int(10) unsigned NOT NULL DEFAULT '0', `totalcom` int(8) unsigned NOT NULL DEFAULT '0', `deleted` int(1) unsigned NOT NULL DEFAULT '0', `vbtpost` int(2) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`tubeid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ; -- -- Дамп данных таблицы `_vbvbtube_tubes` -- INSERT INTO `_vbvbtube_tubes` (`tubeid`, `categoryid`, `forumid`, `userid`, `username`, `email`, `title`, `vidlang`, `link`, `link1`, `link2`, `link3`, `link1img`, `thumb_type`, `filename`, `mext`, `msize`, `filename_mp4`, `filename_img`, `filename_img2`, `photo_mp3`, `url_flv`, `ofilename`, `oext`, `osize`, `mediatype`, `site`, `aboutme`, `active`, `tube`, `views`, `votes`, `rates`, `rating`, `duration`, `keywords`, `joindate`, `reviewid`, `positive`, `negative`, `reported`, `reporteruser`, `reportreason`, `reportcategory`, `lastpost`, `lastposter`, `totalcom`, `deleted`, `vbtpost`) VALUES (1, 2, 0, 1, 'hopehserge', 'support4430@gmail.com', 'Установка CMS Joomla на хостинг', 'Russian', 'http://www.sergeer.ru/forum/vbtube_show.php?tubeid=1&name=ustanovka-cms-joomla-na-hosting', '', '', 'embed', 'http://i701.photobucket.com/albums/ww12/hopeh2000/th_e197f1fd.jpg', 0, '', '', 0, '', '', '', '', '', '', '', 0, 'embed', '', 'Установка CMS Joomla на хостинг', '1', '', 2, 1, 5, 5.00, '', 'CMS Joomla Установка CMS Joomla на хостинг', 1361878586, 0, 0, 0, '0', '', NULL, '', 1361965961, 1, 2, 0, 0), (2, 1, 0, 1, 'hopehserge', 'support4430@gmail.com', 'Shadow Media configuration', '---', 'http://www.sergeer.ru/forum/vbtube_show.php?tubeid=2&name=shadow-media-configuration', '', '', 'http://www.youtube.com/watch?v=9jZiF_DtYfA', 'http://www.sergeer.ru/forum/vbtube/upload/thumb_link/7416_7124.jpg', 0, '', '', 0, '', '', '', '', '', '', '', 0, 'video', '1', '', '0', '', 1, 0, 0, 0.00, '01:40', 'Shadow, Media, configuration, Shadow Media configuration', 1361911491, 0, 0, 0, '0', '', NULL, '', 0, 0, 0, 1, 0), (3, 2, 0, 1, 'hopehserge', 'support4430@gmail.com', 'Shadow Media configuration', '---', 'http://www.sergeer.ru/forum/vbtube_show.php?tubeid=3&name=shadow-media-configuration', '', '', 'http://www.youtube.com/watch?v=9jZiF_DtYfA', 'http://www.sergeer.ru/forum/vbtube/upload/thumb_link/556_2590.jpg', 0, '', '', 0, '', '', '', '', '', '', '', 0, 'video', '1', '', '1', '', 1, 0, 0, 0.00, '01:40', 'Shadow, Media, configuration, Shadow Media configuration', 1361911605, 0, 0, 0, '0', '', NULL, '', 0, 0, 0, 0, 0), (4, 1, 0, 1, 'hopehserge', 'support4430@gmail.com', 'The Na Nach Swipe', '---', 'http://www.sergeer.ru/forum/vbtube_show.php?tubeid=4&name=na-nach-swipe', '', '', 'http://www.youtube.com/watch?v=ZacRtqRLSLw', 'http://www.sergeer.ru/forum/vbtube/upload/thumb_link/7181_3227.jpg', 0, '', '', 0, '', '', '', '', '', '', '', 0, 'video', '1', 'Tutorial about the esoteric hand sign of the Breslov chasidum http://nanach.name', '0', '', 1, 0, 0, 0.00, '02:14', 'Na, Nach, judaism, breslov, meditation, mantra, spirituality, esoteric, hand, signs, The Na Nach Swipe', 1361911721, 0, 0, 0, '0', '', NULL, '', 0, 0, 0, 1, 0), (5, 2, 0, 1, 'hopehserge', 'support4430@gmail.com', 'Бугатти Вейрон против BMW M3', 'Russian', 'http://www.sergeer.ru/forum/vbtube_show.php?tubeid=5&name=bugatti-veyron-vs-bmw-m3', 'Bugatti Veyron vs BMW M3', '', 'http://www.youtube.com/watch?v=VEL5ABddZ0k', 'http://www.sergeer.ru/forum/vbtube/upload/thumb_link/6116_566.jpg', 0, '', '', 0, '', '', '', '', '', '', '', 0, 'video', '1', 'Гонки взлетно-посадочной полосы между Бугатти Вейрон и голландский гонщик Хо-Пин Тун в новом E92 M3. Просмотр оригинал на: http://www.autojunk.nl/clips/view/133255', '1', '', 1, 0, 0, 0.00, '01:22', 'bmw, m3, bugati, veyron, dragrace, burnout, autoblog, autoblog.nl, automobile, high speed, extreme driving, engines, car, cars, vehicle, bmw m3, vs, bugatti ..., Bugatti Veyron vs BMW M3', 1361911754, 0, 0, 0, '0', '', NULL, '', 0, 0, 0, 0, 0), (6, 2, 0, 1, 'hopehserge', 'support4430@gmail.com', 'Что такое шаблон Joomla', 'Russian', 'http://www.sergeer.ru/forum/vbtube_show.php?tubeid=6&name=chto-takoe-shablon-joomla', 'Что такое шаблон Joomla', '', 'http://www.youtube.com/watch?v=7LsmbyrbCfU', 'http://www.sergeer.ru/forum/vbtube/upload/thumb_link/4672_8346.png', 0, '', '', 0, '', '', '', '', '', '', '', 0, 'video', '1', 'Что такое шаблон Joomla', '1', '', 2, 1, 5, 5.00, '', 'template Joomla,Что такое шаблон Joomla', 1361915395, 0, 0, 0, '0', '', NULL, '', 1361995002, 1, 2, 0, 0), (7, 3, 0, 1, 'hopehserge', 'support4430@gmail.com', 'plugin', '', 'vbtube_add.php?do=redirect&tubeid=7&t=2', '<a href="http://www.sergeer.ru/forum/vbtube/photos/original/252teRyY.jpg" target="_blank"><img src="http://www.sergeer.ru/forum/vbtube/photos/medium/252teRyY.jpg" alt="" /></a>', '<img src="http://www.sergeer.ru/forum/vbtube/photos/original/252teRyY.jpg" alt=""/>', 'http://www.sergeer.ru/forum/vbtube/photos/original/252teRyY.jpg', 'http://www.sergeer.ru/forum/vbtube/photos/thumbs/252teRyY.jpg', 1, '', '', 0, '', '252teRyY.jpg', '', '', '', '', '', 0, 'photo', '', 'plugin Joomla', '1', '', 1, 0, 0, 0.00, '', ' plugin', 1361987365, 0, 0, 0, '0', '', NULL, '', 1361987450, 1, 1, 0, 0), (8, 1, 11, 1, 'hopehserge', 'support4430@gmail.com', 'Что такое шаблон Joomla', 'Russian', '', '', '', '', 'http://www.sergeer.ru/forum/vbtube/upload/thumb/742_90505.jpg', 0, '742_90505.flv', '', 0, '', '742_90505.jpg', '1_742_90505.jpg', '', '', '', '', 0, 'video', '777', 'Что такое шаблон Joomla', '0', '', 1, 0, 0, 0.00, '', 'Joomla Что такое шаблон Joomla', 1361999848, 0, 0, 0, '', '', NULL, '', 0, 0, 2, 1, 0), (9, 2, 11, 1, 'hopehserge', 'support4430@gmail.com', 'Shap_2011', 'Russian', '', '', '', '', 'http://www.sergeer.ru/forum/vbtube/upload/thumb/784_9025.jpg', 0, '784_9025.flv', '', 0, '', '784_9025.jpg', '1_784_9025.jpg', '', '', '784_9025', '.flv', 16539683, 'video', '777', 'Урок', '1', '', 2, 0, 0, 0.00, '00:03:50.26, st', 'CMS Joomla Shap_2011', 1362002950, 2, 0, 0, '', '', NULL, '', 0, 0, 2, 0, 0), (10, 2, 11, 1, 'hopehserge', 'support4430@gmail.com', 'Shadow Media configuration', '---', '', '', '', 'http://www.youtube.com/watch?v=9jZiF_DtYfA', 'http://www.sergeer.ru/forum/vbtube/upload/thumb_link/2638_8454.jpg', 0, '', '', 0, '', '', '', '', '', '', '', 0, 'video', '1', '', '1', '', 0, 0, 0, 0.00, '01:40', 'Shadow, Media, configuration, Shadow Media configuration', 1362094499, 3, 0, 0, '0', '', NULL, '', 0, 0, 0, 0, 0), (11, 2, 11, 1, 'hopehserge', 'support4430@gmail.com', 'Titanic II', '---', '', '', '', 'http://www.youtube.com/watch?v=hu5rTrzY80k', 'http://www.sergeer.ru/forum/vbtube/upload/thumb_link/8428_3263.jpg', 0, '', '', 0, '', '', '', '', '', '', '', 0, 'video', '1', 'SOURCEFED SHIRTS!!! http://dft.ba/-4EpA Australian money-man released blueprints for his Titanic replica. Our Sources: http://dft.ba/-4K0i More stories at: http://www.sourcefed.com or check out: http://youtube.com/sourcefed for our 5 daily videos or anything else we've ever done. Follow us on Twitter: http://twitter.com/sourcefed Follow us on Tumblr: http://sourcefed.tumblr.com/ Like us on Facebook: http://on.fb.me/xQDV8M Philly D OFFICIAL APP for instant updates: http://bit.ly/aIyY0w Order your SourceFed Posters here: http://bit.ly/SourceFedPosters Hosts: @joebereta @leenewtonsays Music: @ronaldjenkees @Hagemeister', '1', '', 0, 0, 0, 0.00, '02:52', 'SourceFed, Philip DeFranco, Elliott Morgan, Joe Bereta, Lee Newton, Steve Zaragoza, Trisha Hershberger, Meg Turney, sxephil, titanic, titanic II, titanic 2, ..., Titanic II', 1362094523, 4, 0, 0, '0', '', NULL, '', 0, 0, 0, 0, 0), (12, 2, 11, 1, 'hopehserge', 'support4430@gmail.com', 'Evolution of Dance - By Judson Laipply', '---', '', '', '', 'http://www.youtube.com/watch?v=dMH0bHeiRNg', 'http://www.sergeer.ru/forum/vbtube/upload/thumb_link/3574_5673.jpg', 0, '', '', 0, '', '', '', '', '', '', '', 0, 'video', '1', 'For more visit http://www.mightaswelldance.com', '1', '', 0, 0, 0, 0.00, '06:00', 'Dancing, comedy, speaking, speaker, motivational speaker, Funny, Training, Success, Evolution of Dance - By Judson Laipply', 1362094558, 5, 0, 0, '0', '', NULL, '', 0, 0, 0, 0, 0); /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;