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 */;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]action_log`
CREATE TABLE `[[dbprefix]]action_log` (
`action_id` int(255) NOT NULL AUTO_INCREMENT,
`action_type` varchar(60) NOT NULL,
`action_username` varchar(60) NOT NULL,
`action_userid` int(30) NOT NULL,
`action_useremail` varchar(200) NOT NULL,
`action_userlevel` int(11) NOT NULL,
`action_ip` varchar(15) NOT NULL,
`date_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`action_success` enum('yes','no') NOT NULL,
`action_details` text NOT NULL,
`action_obj_id` int(255) NOT NULL,
`action_done_id` int(255) NOT NULL,
PRIMARY KEY (`action_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2688 ;
-- Dumping data for table `[[dbprefix]]action_log`
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]admin_notes`
CREATE TABLE `[[dbprefix]]admin_notes` (
`note_id` int(225) NOT NULL AUTO_INCREMENT,
`note` text CHARACTER SET ucs2 NOT NULL,
`date_added` datetime NOT NULL,
`userid` int(225) NOT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=84 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]admin_todo`
CREATE TABLE `[[dbprefix]]admin_todo` (
`todo_id` int(225) NOT NULL AUTO_INCREMENT,
`todo` text CHARACTER SET ucs2 NOT NULL,
`date_added` datetime NOT NULL,
`userid` int(225) NOT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]ads_data`
CREATE TABLE `[[dbprefix]]ads_data` (
`ad_id` int(50) NOT NULL AUTO_INCREMENT,
`ad_name` mediumtext NOT NULL,
`ad_code` mediumtext NOT NULL,
`ad_placement` varchar(50) NOT NULL DEFAULT '',
`ad_category` int(11) NOT NULL DEFAULT '0',
`ad_status` enum('0','1') NOT NULL DEFAULT '0',
`ad_impressions` bigint(255) NOT NULL DEFAULT '0',
`last_viewed` datetime NOT NULL,
`date_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]ads_placements`
CREATE TABLE `[[dbprefix]]ads_placements` (
`placement_id` int(20) NOT NULL AUTO_INCREMENT,
`placement` varchar(26) NOT NULL,
`placement_name` varchar(50) NOT NULL,
`disable` enum('yes','no') NOT NULL DEFAULT 'no',
PRIMARY KEY (`placement_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;
-- Dumping data for table `[[dbprefix]]ads_placements`
INSERT INTO `[[dbprefix]]ads_placements` VALUES
(1, 'ad_160x600', 'Wide Skyscrapper 160 x 600', 'yes'),
(2, 'ad_468x60', 'Banner 468 x 60', 'yes'),
(3, 'ad_300x250', 'Medium Rectangle 300 x 250', 'yes'),
(4, 'ad_728x90', 'Leader Board 728 x 90', 'yes'),
(5, 'ad_120x600', 'Skyscrapper 120 x 600', 'yes');
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]collections`
CREATE TABLE `[[dbprefix]]collections` (
`collection_id` bigint(25) NOT NULL AUTO_INCREMENT,
`collection_name` varchar(225) NOT NULL,
`collection_description` text NOT NULL,
`collection_tags` text NOT NULL,
`category` varchar(200) NOT NULL,
`userid` int(10) NOT NULL,
`views` bigint(20) NOT NULL,
`date_added` datetime NOT NULL,
`featured` varchar(4) NOT NULL DEFAULT 'no',
`broadcast` varchar(10) NOT NULL,
`allow_comments` varchar(4) NOT NULL,
`allow_rating` enum('yes','no') NOT NULL DEFAULT 'yes',
`total_comments` bigint(20) NOT NULL,
`last_commented` datetime NOT NULL,
`total_objects` bigint(20) NOT NULL,
`rating` bigint(20) NOT NULL,
`rated_by` bigint(20) NOT NULL,
`voters` longtext NOT NULL,
`active` varchar(4) NOT NULL,
`public_upload` varchar(4) NOT NULL,
`type` varchar(10) NOT NULL,
PRIMARY KEY (`collection_id`),
KEY `featured` (`featured`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]collection_categories`
CREATE TABLE `[[dbprefix]]collection_categories` (
`category_id` int(255) NOT NULL AUTO_INCREMENT,
`parent_id` int(255) NOT NULL DEFAULT '1',
`category_name` varchar(30) NOT NULL,
`category_order` int(5) NOT NULL,
`category_desc` text NOT NULL,
`date_added` mediumtext NOT NULL,
`category_thumb` mediumint(9) NOT NULL,
`isdefault` enum('yes','no') NOT NULL,
PRIMARY KEY (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
-- Dumping data for table `[[dbprefix]]collection_categories`
INSERT INTO `[[dbprefix]]collection_categories` VALUES
(1, 1, 'Uncategorized', 0, 'Uncategorized', '[[regtime]]', 0, 'yes');
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]collection_contributors`
CREATE TABLE `[[dbprefix]]collection_contributors` (
`contributor_id` int(200) NOT NULL AUTO_INCREMENT,
`collection_id` int(255) NOT NULL,
`userid` int(255) NOT NULL,
`can_edit` enum('yes','no') NOT NULL DEFAULT 'no',
`date_added` datetime NOT NULL,
PRIMARY KEY (`contributor_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]collection_items`
CREATE TABLE `[[dbprefix]]collection_items` (
`ci_id` bigint(20) NOT NULL AUTO_INCREMENT,
`collection_id` bigint(20) NOT NULL,
`object_id` bigint(20) NOT NULL,
`userid` bigint(20) NOT NULL,
`type` varchar(10) NOT NULL,
`date_added` datetime NOT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=30 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]comments`
CREATE TABLE `[[dbprefix]]comments` (
`comment_id` int(60) NOT NULL AUTO_INCREMENT,
`type` varchar(3) NOT NULL,
`userid` int(60) NOT NULL,
`anonym_name` varchar(255) NOT NULL,
`anonym_email` varchar(255) NOT NULL,
`parent_id` int(60) NOT NULL,
`type_id` int(225) NOT NULL,
`type_owner_id` int(255) NOT NULL,
`vote` varchar(225) NOT NULL,
`spam_votes` bigint(20) NOT NULL,
`spam_voters` text NOT NULL,
`date_added` datetime NOT NULL,
`comment_ip` text NOT NULL,
PRIMARY KEY (`comment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=535 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]config`
CREATE TABLE `[[dbprefix]]config` (
`configid` int(20) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL DEFAULT '',
`value` mediumtext NOT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=492 ;
-- Dumping data for table `[[dbprefix]]config`
INSERT INTO `[[dbprefix]]config` VALUES
(225, 'index_recent', '6'),
(226, 'index_featured', '2'),
(227, 'clientid', 'your_client_id_here'),
(228, 'secretId', 'your_client_secret_here'),
(229, 'youtube_api_key', 'key_here'),
(230, 'site_title', '[[site_name]]'),
(231, 'site_slogan', '[[site_desc]]'),
(232, 'baseurl', '[[softurl]]'),
(233, 'basedir', '[[softpath]]'),
(234, 'template_dir', 'cb_28'),
(235, 'player_file', 'cb_video_js.php'),
(237, 'closed_msg', 'We Are Updating Our Website, Please Visit us after few hours.'),
(238, 'description', 'Clip Bucket is an ultimate Video Sharing script'),
(239, 'keywords', 'clip bucket video sharing website script'),
(240, 'ffmpegpath', '/usr/local/bin/ffmpeg'),
(241, 'flvtool2path', '/usr/local/bin/flvtool2'),
(242, 'mp4boxpath', '/usr/local/bin/MP4Box'),
(243, 'vbrate', '300000'),
(248, 'mencoderpath', ''),
(249, 'keep_original', '1'),
(251, 'mplayerpath', ''),
(252, 'email_verification', '1'),
(253, 'allow_registeration', '1'),
(254, 'php_path', '[[php_path]]'),
(255, 'videos_list_per_page', '30'),
(256, 'channels_list_per_page', '25'),
(257, 'videos_list_per_tab', '1'),
(258, 'channels_list_per_tab', '1'),
(259, 'video_comments', '1'),
(260, 'video_rating', '1'),
(261, 'comment_rating', '1'),
(262, 'video_download', '1'),
(263, 'video_embed', '1'),
(264, 'groups_list_per_page', '25'),
(266, 'admin_pages', '100'),
(267, 'search_list_per_page', '25'),
(268, 'recently_viewed_limit', '10'),
(269, 'max_upload_size', '1000'),
(270, 'sbrate', '128000'),
(271, 'thumb_width', '120'),
(272, 'thumb_height', '90'),
(273, 'user_comment_opt1', ''),
(274, 'ffmpeg_type', ''),
(275, 'user_comment_opt2', ''),
(276, 'user_comment_opt3', ''),
(277, 'user_comment_opt4', ''),
(278, 'user_rate_opt1', ''),
(279, 'captcha_type', '0'),
(280, 'allow_upload', ''),
(281, 'allowed_types', 'wmv,avi,divx,3gp,mov,mpeg,mpg,xvid,flv,asf,rm,dat,mp4,png,jpg'),
(283, 'version_type', 'Alpha'),
(284, 'allow_template_change', '1'),
(285, 'allow_language_change', '1'),
(286, 'default_site_lang', ''),
(287, 'video_require_login', ''),
(288, 'audio_codec', 'libfdk_aac'),
(289, 'con_modules_type', ''),
(290, 'remoteUpload', ''),
(291, 'embedUpload', ''),
(292, 'player_div_id', ''),
(293, 'code_dev', '(Powered by ClipBucket)'),
(295, 'debug_level', ''),
(296, 'enable_troubleshooter', '1'),
(298, 'num_thumbs', '5'),
(299, 'big_thumb_width', '320'),
(300, 'big_thumb_height', '240'),
(301, 'user_max_chr', '15'),
(302, 'disallowed_usernames', 'shit, asshole, fucker'),
(303, 'min_age_reg', '0'),
(304, 'max_comment_chr', '800'),
(305, 'user_comment_own', ''),
(306, 'anonym_comments', 'yes'),
(307, 'player_dir', 'CB_video_js'),
(308, 'player_width', '661'),
(309, 'player_height', '360'),
(310, 'default_country_iso2', 'PK'),
(311, 'channel_player_width', '600'),
(312, 'channel_player_height', '281'),
(313, 'videos_items_grp_page', '24'),
(314, 'videos_items_hme_page', '25'),
(315, 'videos_items_columns', '12'),
(316, 'videos_items_ufav_page', '25'),
(317, 'videos_items_uvid_page', '25'),
(318, 'videos_items_search_page', '30'),
(319, 'videos_item_channel_page', '25'),
(320, 'users_items_subscriptions', '5'),
(321, 'users_items_subscibers', '5'),
(322, 'users_items_contacts_channel', '5'),
(323, 'users_items_search_page', '12'),
(324, 'users_items_group_page', '15'),
(325, 'cbhash', 'PGRpdiBhbGlnbj0iY2VudGVyIj48IS0tIERvIG5vdCByZW1vdmUgdGhpcyBjb3B5cmlnaHQgbm90aWNlIC0tPg0KUG93ZXJlZCBieSA8YSBocmVmPSJodHRwOi8vY2xpcC1idWNrZXQuY29tLyI+Q2xpcEJ1Y2tldDwvYT4gJXMgfCA8YSBocmVmPSJodHRwOi8vY2xpcC1idWNrZXQuY29tL2Fyc2xhbi1oYXNzYW4iPkFyc2xhbiBIYXNzYW48L2E+DQo8IS0tIERvIG5vdCByZW1vdmUgdGhpcyBjb3B5cmlnaHQgbm90aWNlIC0tPjwvZGl2Pg=='),
(326, 'min_video_title', '4'),
(327, 'max_video_title', '80'),
(328, 'min_video_desc', '5'),
(329, 'max_video_desc', '300'),
(330, 'video_categories', '4'),
(331, 'min_video_tags', '3'),
(332, 'max_video_tags', '30'),
(333, 'video_codec', 'libx264'),
(334, 'date_released', '11-05-2018'),
(335, 'date_installed', '[[regtime]]'),
(336, 'date_updated', '[[regtime]]'),
(337, 'support_email', '[[admin_email]]'),
(338, 'website_email', '[[admin_email]]'),
(339, 'welcome_email', '[[admin_email]]'),
(340, 'anonymous_id', '99'),
(341, 'date_format', 'Y-m-d'),
(342, 'default_time_zone', '5'),
(343, 'autoplay_video', 'no'),
(344, 'default_country_iso2', 'PK'),
(345, 'channel_comments', '1'),
(346, 'max_profile_pic_size', '2500'),
(347, 'max_profile_pic_height', ''),
(348, 'max_profile_pic_width', '230'),
(350, 'picture_url', 'yes'),
(351, 'picture_upload', 'yes'),
(352, 'background_url', 'yes'),
(353, 'background_upload', 'yes'),
(354, 'max_bg_size', '2500'),
(355, 'max_bg_width', '1600'),
(356, 'max_bg_height', ''),
(357, 'background_color', 'yes'),
(358, 'send_comment_notification', 'yes'),
(359, 'approve_video_notification', 'yes'),
(360, 'keep_mp4_as_is', 'yes'),
(361, 'hq_output', 'yes'),
(362, 'grp_categories', '3'),
(363, 'grps_items_search_page', '25'),
(364, 'grp_thumb_height', '140'),
(365, 'grp_thumb_width', '140'),
(366, 'grp_max_title', '20'),
(367, 'grp_max_desc', '500'),
(369, 'server_friendly_conversion', ''),
(370, 'max_conversion', '2'),
(371, 'max_time_wait', '7200'),
(372, 'allow_unicode_usernames', 'yes'),
(373, 'min_username', '3'),
(374, 'max_username', '15'),
(375, 'youtube_enabled', 'yes'),
(376, 'allow_username_spaces', 'yes'),
(377, 'use_playlist', 'yes'),
(378, 'comments_captcha', 'guests'),
(379, 'player_logo_file', 'logo.jpg'),
(380, 'logo_placement', 'tl'),
(381, 'buffer_time', '5'),
(382, 'use_ffmpeg_vf', 'yes'),
(383, 'own_photo_rating', ''),
(384, 'mail_type', 'mail'),
(388, 'smtp_auth', 'no'),
(391, 'pak_license', ''),
(392, 'photo_ratio', '16:10'),
(393, 'photo_thumb_width', '600'),
(394, 'photo_thumb_height', '75'),
(395, 'photo_med_width', '300'),
(396, 'photo_med_height', '116'),
(397, 'photo_lar_width', '600'),
(398, 'photo_crop', '1'),
(399, 'photo_multi_upload', '5'),
(400, 'photo_download', '1'),
(401, 'photo_comments', '1'),
(402, 'photo_rating', '1'),
(403, 'max_photo_size', '2'),
(404, 'watermark_photo', '0'),
(405, 'watermark_max_width', '120'),
(406, 'watermark_placement', 'left:top'),
(407, 'load_upload_form', 'yes'),
(408, 'load_remote_upload_form', 'yes'),
(409, 'load_embed_form', 'yes'),
(410, 'load_link_video_form', 'yes'),
(411, 'enable_groups', ''),
(412, 'groupsSection', 'yes'),
(413, 'videosSection', 'yes'),
(414, 'photosSection', 'yes'),
(415, 'homeSection', 'yes'),
(416, 'signupSection', 'yes'),
(417, 'uploadSection', 'yes'),
(418, 'collectionsSection', 'yes'),
(419, 'channelsSection', 'yes'),
(421, 'normal_resolution', '480'),
(422, 'high_resolution', '720'),
(423, 'max_video_duration', '320'),
(424, 'embed_player_height', '250'),
(425, 'embed_player_width', '300'),
(426, 'autoplay_embed', 'yes'),
(427, 'playlistsSection', 'yes'),
(428, 'photo_main_list', '10'),
(429, 'photo_home_tabs', '30'),
(430, 'photo_search_result', '30'),
(431, 'photo_channel_page', '10'),
(432, 'photo_user_photos', '20'),
(433, 'photo_user_favorites', '20'),
(434, 'photo_other_limit', '8'),
(435, 'collection_per_page', '30'),
(436, 'collection_home_page', '10'),
(437, 'collection_search_result', '20'),
(438, 'collection_channel_page', '10'),
(439, 'collection_user_collections', '20'),
(440, 'collection_user_favorites', '20'),
(441, 'collection_items_page', '20'),
(442, 'reCaptcha_private_key', '6LcQI8ESAAAAALc_oz1xuNsBVRNx554CaJHjcoXt'),
(443, 'reCaptcha_public_key', '6LcQI8ESAAAAALN1vYQovst9c6nlU52iHdqWExp8'),
(444, 'channel_rating', '1'),
(445, 'own_channel_rating', '1'),
(446, 'collection_rating', '1'),
(447, 'own_collection_rating', '1'),
(448, 'own_video_rating', '1'),
(449, 'vbrate_hd', '500000'),
(450, 'store_guest_session', 'no'),
(451, 'delete_mass_upload', 'no'),
(452, 'use_crons', 'no'),
(453, 'pseudostreaming', 'yes'),
(454, 'comments_per_page', '15'),
(455, 'embed_type', 'iframe'),
(456, 'feedsSection', 'yes'),
(457, 'enlarge_button', 'no'),
(458, 'max_topic_length', '1500'),
(459, 'max_topic_title', '300'),
(460, 'facebook_embed', 'yes'),
(461, 'seo_vido_url', '1'),
(462, 'use_cached_pagin', 'yes'),
(463, 'cached_pagin_time', '5'),
(464, 'player_logo_url', 'http://clip-bucket.com/'),
(465, 'cb_combo_res', 'no'),
(466, 'ffprobe_path', '/usr/bin/ffprobe'),
(467, 'media_info', '/usr/bin/mediainfo'),
(468, 'i_magick', '/usr/bin/convert'),
(474, 'photo_activation', '1'),
(475, 'index_recent', '6'),
(476, 'index_featured', '2'),
(478, 'youtube_api_key', ''),
(479, 'popup_video', 'yes'),
It is recommended that you Edit text format, this type of Fix handles quite a lot in one request
