File: /home/httpd/html/chatfree24.com/public_html/schema.sql
-- phpMyAdmin SQL Dump
-- version 5.1.0
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: May 06, 2022 at 11:24 AM
-- Server version: 10.4.18-MariaDB
-- PHP Version: 7.2.34
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
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 utf8mb4 */;
--
-- Database: `cams`
--
-- --------------------------------------------------------
--
-- Table structure for table `blocks`
--
CREATE TABLE `blocks` (
`title` varchar(255) NOT NULL,
`subject` varchar(255) NOT NULL,
`body` text NOT NULL,
`visibility_mode` tinyint(1) NOT NULL DEFAULT 1 COMMENT '0 - Hidden on certain pages, 1 - Visible on certain pages',
`visibility_paths` text NOT NULL COMMENT '''Paths (urls) with placeholder (*) to match visibility''',
`status` tinyint(1) NOT NULL DEFAULT 1,
`date_added` datetime NOT NULL,
`record_num` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `blocks`
--
INSERT INTO `blocks` (`title`, `subject`, `body`, `visibility_mode`, `visibility_paths`, `status`, `date_added`, `record_num`) VALUES
('Footer Text', 'Mechbunny Webcam API Script', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.', 1, '', 1, '0000-00-00 00:00:00', 1);
-- --------------------------------------------------------
--
-- Table structure for table `blocks_languages`
--
CREATE TABLE `blocks_languages` (
`block_id` int(11) NOT NULL,
`language` varchar(3) NOT NULL,
`data` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `cache`
--
CREATE TABLE `cache` (
`key` varchar(255) NOT NULL,
`expiration_date` datetime DEFAULT NULL,
`cache_data` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `comments`
--
CREATE TABLE `comments` (
`userid` int(11) NOT NULL DEFAULT 0,
`name` varchar(255) NOT NULL,
`comment` mediumtext NOT NULL,
`performer_name` varchar(255) NOT NULL DEFAULT '0',
`performer_site` int(11) NOT NULL,
`timestamp` varchar(255) NOT NULL,
`ip` varchar(255) NOT NULL,
`rating` int(11) NOT NULL DEFAULT 0,
`parent` int(11) NOT NULL DEFAULT 0,
`record_num` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `comments`
--
-- --------------------------------------------------------
--
-- Table structure for table `comments_likes`
--
CREATE TABLE `comments_likes` (
`comment_id` int(11) NOT NULL,
`ip` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `configuration`
--
CREATE TABLE `configuration` (
`field_name` varchar(255) NOT NULL,
`field_description` varchar(255) NOT NULL,
`field` varchar(255) NOT NULL,
`value` mediumtext NOT NULL,
`data` mediumtext NOT NULL,
`weight` int(11) NOT NULL DEFAULT 1,
`group` varchar(50) NOT NULL,
`localized` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is language-sensitive?',
`settings` text NOT NULL,
`record_num` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `configuration`
--
INSERT INTO `configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `group`, `localized`, `settings`, `record_num`) VALUES
('Admin Email', 'Email address of site administrator', 'admin_email', 'webmaster@domain.com', '', 1, 'site', 0, '', 1),
('No-Reply Email', 'Reply-to email address of outgoing website transaction emails (forgot password, registration email, etc)', 'noreply_email', 'noreply@domain.com', '', 1, 'site', 0, '', 2),
('Admin IP Limitations', 'Enable/Disable admin area ip restrictions', 'admin_ip_limitation', '0', '{\"true\":1,\"false\":0}', 1, 'site', 0, '', 3),
('Allowed IPs', 'IPs allowed into admin area', 'admin_allowed_ips', '', 'array', 1, 'site', 0, '', 4),
('Site Name', 'Name of Website', 'sitename', 'Mechbunny Cam Directory', '', 1, 'site', 1, '', 5),
('Template', 'Template directory inside /templates/', 'template_name', 'default_v2', '', 1, 'site', 0, '', 6),
('PHP Path', 'Path to PHP binary', 'php_path', '/usr/bin/php', '', 1, 'paths', 0, '', 12),
('Results Per Page', 'Number of media displayed per page on index/search/etc pages', 'results_per_page', '60', '', 1, 'general', 0, '{\"type\":\"number\",\"min\":6,\"max\":1000,\"suffix\":\"items\"}', 40),
('Display Comments?', 'Toggle displaying comments on media pages', 'allowDisplayComments', '1', '{\"true\":1,\"false\":0}', 1, 'general', 0, '', 44),
('Allow Commenting?', 'toggle adding comments on media pages', 'allowAddComments', '1', '{\"true\":1,\"false\":0}', 1, 'general', 0, '', 45),
('Allow Favorites?', 'toggle user adding to favorites', 'allowAddFavorites', '1', '{\"true\":1,\"false\":0}', 1, 'general', 0, '', 46),
('Overall Cache Time', 'Cache time of data for General Data (in seconds)', 'overall_cache_time', '1', '', 1, 'general', 0, '{\"type\":\"number\",\"min\":0,\"max\":2592000,\"suffix\":\"seconds\"}', 48),
('Require Email Confirmation', 'Require email confirmation on user account signup', 'require_account_confirmation', '1', '{\"true\":1,\"false\":0}', 1, 'general', 0, '', 49),
('Enable Signup Captcha', 'Toggle captcha on user signup form', 'enable_signup_captcha', '1', '{\"true\":1,\"false\":0}', 1, 'general', 0, '', 50),
('Redirect Mobile Traffic', 'When filled in, this will redirect all mobile traffic to a completely separate URL. Leave blank to disable.', 'redirect_mobile', '', '', 1, 'general', 0, '', 54),
('Cache Type', 'Defines which caching system to use', 'cacheType', 'filesystem', '{\"Memcached\":\"memcached\",\"Filesystem\":\"filesystem\"}', 1, 'site', 0, '', 58),
('Memcached Server Host', 'Hostname of Memcached Server (usually localhost)', 'memcachedServer', 'localhost', '', 1, 'site', 0, '', 59),
('Memcached Server Port', 'Port of Memcached Server (usually 11211)', 'memcachedPort', '11211', '', 1, 'site', 0, '', 60),
('Send e-mails', '', 'send_emails', '1', '{\"true\":1,\"false\":0}', 1, 'email', 0, '', 76),
('Format e-mails as HTML', '', 'send_html_emails', '1', '{\"true\":1,\"false\":0}', 1, 'email', 0, '', 77),
('Use PHP Mailer', '', 'phpmailer_enabled', '1', '{\"true\":1,\"false\":0}', 1, 'email', 0, '', 78),
('SMTP Host', '', 'smtp_host', '', '', 1, 'email', 0, '', 80),
('SMTP Authorization', '', 'smtp_auth', '0', '{\"true\":1,\"false\":0}', 1, 'email', 0, '', 81),
('SMTP Username', '', 'smtp_user', '', '', 1, 'email', 0, '', 82),
('SMTP Password', '', 'smtp_pass', '', '', 1, 'email', 0, '', 83),
('SMTP Port', '', 'smtp_port', '25', '', 1, 'email', 0, '{\"type\":\"number\",\"min\":25,\"max\":65536}', 84),
('Debugging Mode', 'Whether to display debugging information such as query issues', 'development_mode', '0', '{\"true\":1,\"false\":0}', 1, 'site', 0, '', 85),
('Default Meta Title', '', 'default_meta_title', 'Hot Webcam Girls', '', 1, 'meta', 1, '', 86),
('Default Meta Description', '', 'default_meta_description', 'Hot Webcam Girls', '', 1, 'meta', 1, '', 87),
('Default Meta Keywords', '', 'default_meta_keywords', 'Hot Webcam Girls', '', 1, 'meta', 1, '', 88),
('Default Meta Robots', '', 'default_meta_robots', 'index,follow', '', 1, 'meta', 1, '', 89),
('Maximum avatar filesize (in kB)', '', 'max_avatar_size', '512', '', 1, 'general', 0, '{\"type\":\"number\",\"min\":50,\"max\":8192,\"suffix\":\"kB\"}', 90),
('Min length of username', '', 'username_min_length', '3', '', 1, 'general', 0, '{\"type\":\"number\",\"min\":3,\"max\":20,\"suffix\":\"characters\"}', 91),
('Max length of username', '', 'username_max_length', '20', '', 1, 'general', 0, '{\"type\":\"number\",\"min\":10,\"max\":50,\"suffix\":\"characters\"}', 92),
('Min length of password', '', 'password_min_length', '5', '', 1, 'general', 0, '{\"type\":\"number\",\"min\":5,\"max\":100,\"suffix\":\"characters\"}', 93),
('Max length of password', '', 'password_max_length', '50', '', 1, 'general', 0, '{\"type\":\"number\",\"min\":20,\"max\":100,\"suffix\":\"characters\"}', 94),
('Enable Facebook Login', '', 'enable_facebook_login', '0', '{\"true\":1,\"false\":0}', 1, 'social', 0, '', 95),
('Facebook Application ID', '', 'facebook_appid', '', '', 1, 'social', 0, '', 96),
('Facebook Application Secret Key', '', 'facebook_appsecret', '', '', 1, 'social', 0, '', 97),
('Facebook Response URL', '', 'facebook_response_url', 'http://www.domain.com/includes/facebook/facebook_response.php', '', 1, 'social', 0, '', 98),
('Enable Twitter Login', '', 'enable_twitter_login', '0', '{\"true\":1,\"false\":0}', 1, 'social', 0, '', 99),
('Twitter Consumer Key', '', 'twitter_consumer_key', '', '', 1, 'social', 0, '', 100),
('Twitter Consumer Secret', '', 'twitter_consumer_secret', '', '', 1, 'social', 0, '', 101),
('Twitter Auth Key', '', 'twitter_auth_key', '', '', 1, 'social', 0, '', 102),
('Twitter Auth Secret', '', 'twitter_auth_secret', '', '', 1, 'social', 0, '', 103),
('Search results Cache Time', 'Cache time of data for Search Results (in seconds)', 'search_cache_time', '300', '', 1, 'general', 0, '{\"type\":\"number\",\"min\":0,\"max\":2592000,\"suffix\":\"seconds\"}', 104),
('Most recent results Cache Time', 'Cache time of data for Most Recent page (in seconds)', 'most_recent_cache_time', '300', '', 1, 'general', 0, '{\"type\":\"number\",\"min\":0,\"max\":2592000,\"suffix\":\"seconds\"}', 105),
('Debugging Mode Admin Only', 'When \"Debugging Mode\" is enabled, all debugging information will be visible only, when admin is also logged in', 'development_mode_admin_only', '0', '{\"true\":1,\"false\":0}', 1, 'site', 0, '', 106),
('Maintenance Mode', 'Enabling \"Maintenance Mode\" will disable site for viewers and only authenticated Admin will be able to view website', 'maintenance_mode', '0', '{\"true\":1,\"false\":0}', 1, 'site', 0, '', 107),
('Default Database Charset', '', 'db_charset', 'utf8', '', 1, 'site', 0, '', 110),
('Enable 18+ Warning', 'Enable 18+ Warning', 'ageWarning', '1', '{\"true\":1,\"false\":0}', 99, 'general', 0, '', 158),
('Enable GDPR Warning', 'Enable GDPR Warning', 'gdprWarning', '1', '{\"true\":1,\"false\":0}', 99, 'general', 0, '', 159),
('Redirect Signup', 'Redirects signup page to specified URL (IE To biller payment page)', 'redirectSignupURL', '', '', 100, 'payment_gateway', 0, '', 165),
('Robots.txt', 'Value of robots.txt', 'robots_txt', 'User-agent: *\r\nDisallow: /admin/\r\nDisallow: /includes/\r\nDisallow: /controllers/\r\nDisallow: /core/\r\nDisallow: /content/\r\nDisallow: /csv_photos/\r\nDisallow: /ftp_content/\r\nDisallow: /ftp_photos/\r\nDisallow: /temp_users_uploads/\r\nDisallow: /cache/\r\n\r\n\r\nUser-agent: SEMrushBot-SA\r\nDisallow: /\r\n\r\nUser-agent: SEMrushBot-BA\r\nDisallow: /\r\n\r\nUser-agent: SEMrushBot-SWA\r\nDisallow: /\r\n\r\nUser-agent: SEMrushBot-CT\r\nDisallow: /\r\n\r\nUser-agent: SEMrushBot-BM\r\nDisallow: /\r\n\r\nUser-agent: MJ12bot\r\nDisallow: /\r\n\r\nUser-agent: AhrefsBot\r\nDisallow: /', '', 1, 'site', 0, '{\"type\":\"textarea\"}', 170),
('', '', 'mbAuthToken', '6ad4f8a73c5fa3bf8fb99d51a56d76f3', '', 1, '', 0, '', 171),
('Honor GEOIP Restrictions', 'Enable/Disable honoring of blocked GEO locations from Performer Settings', 'honor_geoip', '1', '{\"true\":1,\"false\":0}', 1, 'site', 0, '', 176),
('GEOIP Enviroment Variable', 'Environment variable containing 2 letter ISO code for surfer\'s country that is stored in $_SERVER. If using Cloudflare, should be \'HTTP_CF_IPCOUNTRY\', if using mod_geoip should be \'GEOIP_COUNTRY_CODE\'.', 'geoip_env', 'HTTP_CF_IPCOUNTRY', '', 1, 'site', 0, '', 177),
('Default Query String', 'Query string used on first load of website for filters. Should be without ? at the start. Example: gender[]=f&status[]=online', 'default_query_string', 'gender[]=f&status[]=online', '', 1, 'site', 0, '', 178),
('Max length of comment', '', 'max_comment_lenght', '1000', '', 1, 'general', 0, '{\"type\":\"number\",\"min\":1,\"max\":100000,\"suffix\":\"characters\"}', 179);
-- --------------------------------------------------------
--
-- Table structure for table `countries`
--
CREATE TABLE `countries` (
`id` int(11) NOT NULL,
`code` varchar(2) NOT NULL,
`value` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `countries`
--
INSERT INTO `countries` (`id`, `code`, `value`) VALUES
(1, 'AF', 'Afghanistan'),
(2, 'AL', 'Albania'),
(3, 'DZ', 'Algeria'),
(4, 'AS', 'American Samoa'),
(5, 'AD', 'Andorra'),
(6, 'AO', 'Angola'),
(7, 'AI', 'Anguilla'),
(8, 'AQ', 'Antarctica'),
(9, 'AG', 'Antigua and Barbuda'),
(10, 'AR', 'Argentina'),
(11, 'AM', 'Armenia'),
(12, 'AW', 'Aruba'),
(13, 'AU', 'Australia'),
(14, 'AT', 'Austria'),
(15, 'AZ', 'Azerbaijan'),
(16, 'BS', 'Bahamas'),
(17, 'BH', 'Bahrain'),
(18, 'BD', 'Bangladesh'),
(19, 'BB', 'Barbados'),
(20, 'BY', 'Belarus'),
(21, 'BE', 'Belgium'),
(22, 'BZ', 'Belize'),
(23, 'BJ', 'Benin'),
(24, 'BM', 'Bermuda'),
(25, 'BT', 'Bhutan'),
(26, 'BO', 'Bolivia'),
(27, 'BA', 'Bosnia and Herzegovina'),
(28, 'BW', 'Botswana'),
(29, 'BV', 'Bouvet Island'),
(30, 'BR', 'Brazil'),
(31, 'IO', 'British Indian Ocean territory'),
(32, 'BN', 'Brunei Darussalam'),
(33, 'BG', 'Bulgaria'),
(34, 'BF', 'Burkina Faso'),
(35, 'BI', 'Burundi'),
(36, 'KH', 'Cambodia'),
(37, 'CM', 'Cameroon'),
(38, 'CA', 'Canada'),
(39, 'CV', 'Cape Verde'),
(40, 'KY', 'Cayman Islands'),
(41, 'CF', 'Central African Republic'),
(42, 'TD', 'Chad'),
(43, 'CL', 'Chile'),
(44, 'CN', 'China'),
(45, 'CX', 'Christmas Island'),
(46, 'CC', 'Cocos (Keeling) Islands'),
(47, 'CO', 'Colombia'),
(48, 'KM', 'Comoros'),
(49, 'CG', 'Congo'),
(50, 'CK', 'Cook Islands'),
(51, 'CR', 'Costa Rica'),
(52, 'CI', 'Cote D\'Ivoire'),
(53, 'HR', 'Croatia'),
(54, 'CU', 'Cuba'),
(55, 'CY', 'Cyprus'),
(56, 'CZ', 'Czech Republic'),
(57, 'DK', 'Denmark'),
(58, 'DJ', 'Djibouti'),
(59, 'DM', 'Dominica'),
(60, 'DO', 'Dominican Republic'),
(61, 'TL', 'East Timor'),
(62, 'EC', 'Ecuador'),
(63, 'EG', 'Egypt'),
(64, 'SV', 'El Salvador'),
(65, 'GQ', 'Equatorial Guinea'),
(66, 'ER', 'Eritrea'),
(67, 'EE', 'Estonia'),
(68, 'ET', 'Ethiopia'),
(69, 'FK', 'Falkland Islands'),
(70, 'FO', 'Faroe Islands'),
(71, 'FJ', 'Fiji'),
(72, 'FI', 'Finland'),
(73, 'FR', 'France'),
(74, 'GF', 'French Guiana'),
(75, 'PF', 'French Polynesia'),
(76, 'TF', 'French Southern Territories'),
(77, 'GA', 'Gabon'),
(78, 'GM', 'Gambia'),
(79, 'GE', 'Georgia'),
(80, 'DE', 'Germany'),
(81, 'GH', 'Ghana'),
(82, 'GI', 'Gibraltar'),
(83, 'GR', 'Greece'),
(84, 'GL', 'Greenland'),
(85, 'GD', 'Grenada'),
(86, 'GP', 'Guadeloupe'),
(87, 'GU', 'Guam'),
(88, 'GT', 'Guatemala'),
(89, 'GN', 'Guinea'),
(90, 'GW', 'Guinea-Bissau'),
(91, 'GY', 'Guyana'),
(92, 'HT', 'Haiti'),
(93, 'HM', 'Heard Island and McDonald Islands'),
(94, 'HN', 'Honduras'),
(95, 'HK', 'Hong Kong'),
(96, 'HU', 'Hungary'),
(97, 'IS', 'Iceland'),
(98, 'IN', 'India'),
(99, 'ID', 'Indonesia'),
(100, 'IR', 'Iran'),
(101, 'IQ', 'Iraq'),
(102, 'IE', 'Ireland'),
(103, 'IL', 'Israel'),
(104, 'IT', 'Italy'),
(105, 'JM', 'Jamaica'),
(106, 'JP', 'Japan'),
(107, 'JO', 'Jordan'),
(108, 'KZ', 'Kazakhstan'),
(109, 'KE', 'Kenya'),
(110, 'KI', 'Kiribati'),
(111, 'KP', 'Korea (north)'),
(112, 'KR', 'Korea (south)'),
(113, 'KW', 'Kuwait'),
(114, 'KG', 'Kyrgyzstan'),
(115, 'LA', 'Lao People\'s Democratic Republic'),
(116, 'LV', 'Latvia'),
(117, 'LB', 'Lebanon'),
(118, 'LS', 'Lesotho'),
(119, 'LR', 'Liberia'),
(120, 'LY', 'Libyan Arab Jamahiriya'),
(121, 'LI', 'Liechtenstein'),
(122, 'LT', 'Lithuania'),
(123, 'LU', 'Luxembourg'),
(124, 'MO', 'Macao'),
(125, 'MK', 'Macedonia'),
(126, 'MG', 'Madagascar'),
(127, 'MW', 'Malawi'),
(128, 'MY', 'Malaysia'),
(129, 'MV', 'Maldives'),
(130, 'ML', 'Mali'),
(131, 'MT', 'Malta'),
(132, 'MH', 'Marshall Islands'),
(133, 'MQ', 'Martinique'),
(134, 'MR', 'Mauritania'),
(135, 'MU', 'Mauritius'),
(136, 'YT', 'Mayotte'),
(137, 'MX', 'Mexico'),
(138, 'FM', 'Micronesia'),
(139, 'MD', 'Moldova'),
(140, 'MC', 'Monaco'),
(141, 'MN', 'Mongolia'),
(142, 'MS', 'Montserrat'),
(143, 'MA', 'Morocco'),
(144, 'MZ', 'Mozambique'),
(145, 'MM', 'Myanmar'),
(146, 'NA', 'Namibia'),
(147, 'NR', 'Nauru'),
(148, 'NP', 'Nepal'),
(149, 'NL', 'Netherlands'),
(150, 'AN', 'Netherlands Antilles'),
(151, 'NC', 'New Caledonia'),
(152, 'NZ', 'New Zealand'),
(153, 'NI', 'Nicaragua'),
(154, 'NE', 'Niger'),
(155, 'NG', 'Nigeria'),
(156, 'NU', 'Niue'),
(157, 'NF', 'Norfolk Island'),
(158, 'MP', 'Northern Mariana Islands'),
(159, 'NO', 'Norway'),
(160, 'OM', 'Oman'),
(161, 'PK', 'Pakistan'),
(162, 'PW', 'Palau'),
(163, 'PS', 'Palestinian Territories'),
(164, 'PA', 'Panama'),
(165, 'PG', 'Papua New Guinea'),
(166, 'PY', 'Paraguay'),
(167, 'PE', 'Peru'),
(168, 'PH', 'Philippines'),
(169, 'PN', 'Pitcairn'),
(170, 'PL', 'Poland'),
(171, 'PT', 'Portugal'),
(172, 'PR', 'Puerto Rico'),
(173, 'QA', 'Qatar'),
(174, 'RE', 'Reunion'),
(175, 'RO', 'Romania'),
(176, 'RU', 'Russian Federation'),
(177, 'RW', 'Rwanda'),
(178, 'SH', 'Saint Helena'),
(179, 'KN', 'Saint Kitts and Nevis'),
(180, 'LC', 'Saint Lucia'),
(181, 'PM', 'Saint Pierre and Miquelon'),
(182, 'VC', 'Saint Vincent and the Grenadines'),
(183, 'WS', 'Samoa'),
(184, 'SM', 'San Marino'),
(185, 'ST', 'Sao Tome and Principe'),
(186, 'SA', 'Saudi Arabia'),
(187, 'SN', 'Senegal'),
(188, 'RS', 'Serbia'),
(189, 'SC', 'Seychelles'),
(190, 'SL', 'Sierra Leone'),
(191, 'SG', 'Singapore'),
(192, 'SK', 'Slovakia'),
(193, 'SI', 'Slovenia'),
(194, 'SB', 'Solomon Islands'),
(195, 'SO', 'Somalia'),
(196, 'ZA', 'South Africa'),
(197, 'GS', 'South Georgia and the South Sandwich Islands'),
(198, 'ES', 'Spain'),
(199, 'LK', 'Sri Lanka'),
(200, 'SD', 'Sudan'),
(201, 'SR', 'Suriname'),
(202, 'SJ', 'Svalbard and Jan Mayen Islands'),
(203, 'SZ', 'Swaziland'),
(204, 'SE', 'Sweden'),
(205, 'CH', 'Switzerland'),
(206, 'SY', 'Syria'),
(207, 'TW', 'Taiwan'),
(208, 'TJ', 'Tajikistan'),
(209, 'TZ', 'Tanzania'),
(210, 'TH', 'Thailand'),
(211, 'TG', 'Togo'),
(212, 'TK', 'Tokelau'),
(213, 'TO', 'Tonga'),
(214, 'TT', 'Trinidad and Tobago'),
(215, 'TN', 'Tunisia'),
(216, 'TR', 'Turkey'),
(217, 'TM', 'Turkmenistan'),
(218, 'TC', 'Turks and Caicos Islands'),
(219, 'TV', 'Tuvalu'),
(220, 'UG', 'Uganda'),
(221, 'UA', 'Ukraine'),
(222, 'AE', 'United Arab Emirates'),
(223, 'GB', 'United Kingdom'),
(224, 'US', 'United States of America'),
(225, 'UY', 'Uruguay'),
(226, 'UZ', 'Uzbekistan'),
(227, 'VU', 'Vanuatu'),
(228, 'VE', 'Venezuela'),
(229, 'VN', 'Vietnam'),
(230, 'VG', 'Virgin Islands (British)'),
(231, 'VI', 'Virgin Islands (US)'),
(232, 'WF', 'Wallis and Futuna Islands'),
(233, 'EH', 'Western Sahara'),
(234, 'YE', 'Yemen'),
(235, 'ZR', 'Zaire'),
(236, 'ZM', 'Zambia'),
(237, 'ZW', 'Zimbabwe');
-- --------------------------------------------------------
--
-- Table structure for table `custom_links`
--
CREATE TABLE `custom_links` (
`url` varchar(255) NOT NULL,
`query_string` varchar(1024) NOT NULL,
`title` varchar(255) NOT NULL,
`headertitle` varchar(255) NOT NULL,
`meta_kw` varchar(255) NOT NULL,
`meta_desc` varchar(1024) NOT NULL,
`meta_robots` varchar(255) NOT NULL,
`custom_text` longtext NOT NULL,
`record_num` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `custom_links`
--
INSERT INTO `custom_links` (`url`, `query_string`, `title`, `headertitle`, `meta_kw`, `meta_desc`, `meta_robots`, `custom_text`, `record_num`) VALUES
('blondes', 'hair[]=blonde&gender[]=f&sortOrder=youngest', 'Blonde Cam Girls', 'Blonde Cam Girls', '', '', '', 'Nothing but hot blondes!', 3),
('girls-online', 'gender[]=f&status[]=online', 'Webcam Girls Online Now', 'Webcam Girls Online Now', '', 'Webcam Girls Online Now', '', 'The hottest webcam girls that are online right now.', 4);
-- --------------------------------------------------------
--
-- Table structure for table `email_templates`
--
CREATE TABLE `email_templates` (
`name` varchar(64) NOT NULL,
`description` varchar(255) NOT NULL,
`record_num` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `email_templates`
--
INSERT INTO `email_templates` (`name`, `description`, `record_num`) VALUES
('email-verification', 'E-mail verification message', 1),
('email-verified', 'E-mail confirmed message', 2),
('reset-password', 'Password change request message', 6),
('reset-password-confirmation', 'Password change confirmation message', 7),
('email-welcome', 'Welcome message after succeeded signup', 10);
-- --------------------------------------------------------
--
-- Table structure for table `email_translations`
--
CREATE TABLE `email_translations` (
`template_id` int(11) NOT NULL,
`subject` varchar(255) NOT NULL,
`body` text NOT NULL,
`language` varchar(2) NOT NULL DEFAULT 'en',
`record_num` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `email_translations`
--
INSERT INTO `email_translations` (`template_id`, `subject`, `body`, `language`, `record_num`) VALUES
(1, 'Verify your e-mail on %sitename', '<p>Hi <strong>%username</strong>,</p>\r\n\r\n<p>You must verify your account on %sitename before you can login! Please click the link below:<br />\r\n<a href=\"%basehttp/validate?id=%validationCode\">%basehttp/validate?id=%validationCode</a></p>\r\n\r\n<p>PLEASE DO NOT REPLY TO THIS MESSAGE!</p>\r\n\r\n<p>Regards, %sitename Administrator</p>', 'en', 1),
(2, 'Your e-mail has been confirmed on %sitename', '<p>Hi <strong><em>%username</em></strong>,</p>\r\n<p>This is just a confirmation, that your e-mail has been confirmed.</p>\r\n<p>PLEASE DO NOT REPLY TO THIS MESSAGE!</p>\r\n<p>Regards, %sitename Administrator</p>', 'en', 2),
(3, 'Someone sent you a message!', '<p>Hi <strong><em>%username</em></strong>,</p>\r\n<p>Someone has sent you a message on %sitename! To view the message, visit your inbox, please click the link below or paste it into your browser\'s address bar.<br><a href=\"%basehttp/mailbox/\">%basehttp/mailbox/</a></p>\r\n<p>PLEASE DO NOT REPLY TO THIS MESSAGE!</p>\r\n<p>Regards, %sitename Administrator</p>', 'en', 3),
(4, 'You have new friend request on %sitename!', '<p>Hi <strong><em>%username</em></strong>,</p>\r\n\r\n<p>You have new friend request on %sitename! To view your friends requests<br />\r\n<a href=\"%basehttp/my-friends\">%basehttp/my-friends</a></p>\r\n\r\n<p>PLEASE DO NOT REPLY TO THIS MESSAGE!</p>\r\n\r\n<p>Regards, %sitename Administrator</p>', 'en', 4),
(5, 'Your friend request has been confirmed', '<p>Hi <strong><em>%username</em></strong>,</p>\r\n\r\n<p>Someone has accepted your friend request on %sitename! Click the link below to view your friends list: <br />\r\n<a href=\"%basehttp/my-friends\">%basehttp/my-friends</a></p>\r\n\r\n<p>PLEASE DO NOT REPLY TO THIS MESSAGE!</p>\r\n\r\n<p>Regards, %sitename Administrator</p>', 'en', 5),
(6, 'Please choose a new password', '<p>Hi <strong><em>%username</em></strong>,</p>\r\n\r\n<p>You have requested to reset the password for username: %username</p>\r\n\r\n<p>Please, click the following link to reset your password:</p>\r\n\r\n<p><a href=\"%password_link\">%password_link</a></p>\r\n\r\n<p>PLEASE DO NOT REPLY TO THIS MESSAGE!</p>\r\n\r\n<p>Regards, </p>\r\n\r\n<p>%sitename Administrator</p>', 'en', 6),
(7, 'Your password has been changed', '<p>Hi <strong><em>%username</em></strong>,</p>\r\n\r\n<p>Someone - presumably you - has requested a password reset on %sitename.</p>\r\n\r\n<p>Your new login information is as follows:</p>\r\n\r\n<p>Username: %username</p>\r\n\r\n<p>Password: %newpassword</p>\r\n\r\n<p>To login, please click the link below or paste it into your browser's address bar.<br />\r\n<a href=\"%basehttp/login\">%basehttp/login</a></p>\r\n\r\n<p>PLEASE DO NOT REPLY TO THIS MESSAGE!</p>\r\n\r\n<p>Regards,</p>\r\n\r\n<p>%sitename Administrator</p>', 'en', 7),
(8, 'Someone added new comment on your wall', '<p>Hi <strong><em>%username</em></strong>,</p>\r\n\r\n<p>Someone added new comment on your profile. <a href=\"%basehttp/my-profile\">Click here to view your profile.</a></p>\r\n\r\n<p>PLEASE DO NOT REPLY TO THIS MESSAGE!</p>\r\n\r\n<p>Regards, %sitename Administrator</p>', 'en', 8),
(9, 'Someone added new comment to your content!', '<p>Hi <strong><em>%username</em></strong>,</p>\r\n\r\n<p>Someone added a comment to your content: <br />\r\n<a href=\"%link\">%link</a></p>\r\n\r\n<p>PLEASE DO NOT REPLY TO THIS MESSAGE!</p>\r\n\r\n<p>Regards, %sitename Administrator</p>', 'en', 9),
(10, 'Welcome to %sitename', '<p>Hi <strong><em>%username</em></strong>,</p>\r\n\r\n<p>Thank you for signing up to %sitename. To login to your profile, please click the link below:<br />\r\n<a href=\"%basehttp/login\" target=\"\" title=\"\">%basehttp/login</a></p>\r\n\r\n<p>PLEASE DO NOT REPLY TO THIS MESSAGE!!</p>\r\n\r\n<p>Regards, %sitename Administrator</p>', 'en', 10),
(11, 'Reported Video', '<p>Submitter: %name, %email</p>\r\n\r\n<p>Reason: %reason</p>\r\n\r\n<p>Video: ID %video_id (<a href=\"%video_link\">%video_link</a>)</p>\r\n\r\n<p>Message:<br />\r\n%content</p>\r\n\r\n<p> </p>\r\n\r\n<p>Regards, %sitename Administrator</p>', 'en', 11);
-- --------------------------------------------------------
--
-- Table structure for table `favorites`
--
CREATE TABLE `favorites` (
`user` int(11) NOT NULL DEFAULT 0,
`performer_name` varchar(255) NOT NULL DEFAULT '0',
`performer_site` int(11) NOT NULL,
`record_num` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `favorites`
--
INSERT INTO `favorites` (`user`, `performer_name`, `performer_site`, `record_num`) VALUES
(3, 'gigiatlanta', 5, 5),
(3, 'KROSHKA_N', 2, 6);
-- --------------------------------------------------------
--
-- Table structure for table `fields`
--
CREATE TABLE `fields` (
`module` varchar(255) NOT NULL,
`code` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
`record_num` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `fields`
--
INSERT INTO `fields` (`module`, `code`, `name`, `record_num`) VALUES
('models', 'ethnicities', 'Models ethnicity options', 2),
('models', 'eye_colors', 'Models eye color options', 3),
('models', 'hair_colors', 'Models hair color options', 4),
('models', 'languages', 'Models language options', 5);
-- --------------------------------------------------------
--
-- Table structure for table `fields_values`
--
CREATE TABLE `fields_values` (
`field_id` int(11) NOT NULL,
`key` varchar(255) NOT NULL,
`value` text NOT NULL,
`weight` int(11) NOT NULL DEFAULT 0,
`record_num` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `fields_values`
--
INSERT INTO `fields_values` (`field_id`, `key`, `value`, `weight`, `record_num`) VALUES
(2, '1', 'White', 0, 56),
(2, '2', 'Black', 1, 57),
(2, '3', 'Asian', 2, 58),
(2, '4', 'Latino', 3, 59),
(2, '5', 'East-Indian', 4, 60),
(2, '6', 'Native', 5, 61),
(2, '7', 'Islander', 6, 62),
(2, '8', 'Other', 7, 63),
(3, '1', 'Amber', 0, 64),
(3, '2', 'Black', 1, 65),
(3, '3', 'Blue', 2, 66),
(3, '4', 'Brown', 3, 67),
(3, '5', 'Grey', 4, 68),
(3, '6', 'Green', 5, 69),
(3, '7', 'Hazel', 6, 70),
(3, '8', 'Violet', 7, 71),
(4, '1', 'Blonde', 0, 72),
(4, '2', 'Red', 1, 73),
(4, '3', 'Brown', 2, 74),
(4, '4', 'Black', 3, 75),
(4, '5', 'Grey', 4, 76),
(4, '6', 'White', 5, 77),
(4, '7', 'Auburn', 6, 78),
(5, 'en.png', 'English', 0, 79),
(5, 'za.png', 'Afrikaans', 0, 80),
(5, 'sa.png', 'Arabic', 0, 81),
(5, 'az.png', 'Azerbaijani', 0, 82),
(5, 'by.png', 'Belarusian', 0, 83),
(5, 'bg.png', 'Bulgarian', 0, 84),
(5, 'es.png', 'Catalan', 0, 85),
(5, 'cs.png', 'Czech', 0, 86),
(5, 'dk.png', 'Danish', 0, 87),
(5, 'de.png', 'German', 0, 88),
(5, 'gr.png', 'Greek', 0, 89),
(5, 'es.png', 'Spanish', 0, 90),
(5, 'ee.png', 'Estonian', 0, 91),
(5, 'ir.png', 'Persian', 0, 92),
(5, 'fi.png', 'Finnish', 0, 93),
(5, 'fj.png', 'Fiji', 0, 94),
(5, 'fo.png', 'Faeroese', 0, 95),
(5, 'fr.png', 'French', 0, 96),
(5, 'ie.png', 'Irish', 0, 97),
(5, 'gb.png', 'Scots/Gaelic', 0, 98),
(5, 'in.png', 'Hindi', 0, 99),
(5, 'hr.png', 'Croatian', 0, 100),
(5, 'hu.png', 'Hungarian', 0, 101),
(5, 'am.png', 'Armenian', 0, 102),
(5, 'id.png', 'Indonesian', 0, 103),
(5, 'is.png', 'Icelandic', 0, 104),
(5, 'it.png', 'Italian', 0, 105),
(5, 'il.png', 'Hebrew', 0, 106),
(5, 'jp.png', 'Japanese', 0, 107),
(5, 'ge.png', 'Georgian', 0, 108),
(5, 'kz.png', 'Kazakh', 0, 109),
(5, 'kh.png', 'Cambodian', 0, 110),
(5, 'kr.png', 'Korean', 0, 111),
(5, 'pk.png', 'Kashmiri', 0, 112),
(5, 'iq.png', 'Kurdish', 0, 113),
(5, 'lt.png', 'Lithuanian', 0, 114),
(5, 'my.png', 'Malay', 0, 115),
(5, 'mt.png', 'Maltese', 0, 116),
(5, 'nl.png', 'Dutch', 0, 117),
(5, 'no.png', 'Norwegian', 0, 118),
(5, 'pl.png', 'Polish', 0, 119),
(5, 'pt.png', 'Portuguese', 0, 120),
(5, 'ro.png', 'Romanian', 0, 121),
(5, 'ru.png', 'Russian', 0, 122),
(5, 'sk.png', 'Slovak', 0, 123),
(5, 'al.png', 'Albanian', 0, 124),
(5, 'rs.png', 'Serbian', 0, 125),
(5, 'sv.png', 'Swedish', 0, 126),
(5, 'th.png', 'Thai', 0, 127),
(5, 'tr.png', 'Turkish', 0, 128),
(5, 'ua.png', 'Ukrainian', 0, 129),
(5, 'vn.png', 'Vietnamese', 0, 130),
(5, 'cn.png', 'Chinese', 0, 131);
-- --------------------------------------------------------
--
-- Table structure for table `keywords`
--
CREATE TABLE `keywords` (
`word` varchar(64) NOT NULL,
`amount` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `languages`
--
CREATE TABLE `languages` (
`name` varchar(255) NOT NULL,
`iso` char(2) NOT NULL,
`record_num` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `link_shortener`
--
CREATE TABLE `link_shortener` (
`slug` varchar(255) NOT NULL,
`target` varchar(1024) NOT NULL,
`record_num` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `locales_source`
--
CREATE TABLE `locales_source` (
`record_num` int(11) NOT NULL,
`text` text NOT NULL,
`source_js` varchar(255) NOT NULL COMMENT 'Path to JS file where this source string is located.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `locales_source`
--
INSERT INTO `locales_source` (`record_num`, `text`, `source_js`) VALUES
(1, 'Home', ''),
(2, 'Login', ''),
(3, 'Signup', ''),
(4, 'Sign up', ''),
(5, 'Change colors', ''),
(6, 'Movies', ''),
(7, 'Most Recent', ''),
(8, 'Most Viewed', ''),
(9, 'Top Rated', ''),
(10, 'Most Discussed', ''),
(11, 'Longest', ''),
(12, 'VR', ''),
(13, 'Albums', ''),
(14, 'Categories', ''),
(15, 'See All', ''),
(16, 'Models', ''),
(17, 'Community', ''),
(18, 'Paysites', ''),
(19, 'Tags', ''),
(20, 'Search', ''),
(21, 'All', ''),
(22, 'Videos', ''),
(23, 'Photos', ''),
(24, 'Network', ''),
(25, 'Upload', ''),
(26, 'UPLOAD', ''),
(27, 'ALL', ''),
(28, 'HD', ''),
(29, 'More', ''),
(30, 'Hide', ''),
(31, 'Being Watched Now', ''),
(32, 'See more', ''),
(33, 'Most Viewed Videos', ''),
(34, '- select -', ''),
(35, 'Newest', ''),
(36, 'Sorry, no results were found.', ''),
(37, 'See all', ''),
(38, 'New Releases', ''),
(39, 'Account', ''),
(40, 'Create free account', ''),
(41, 'Contact', ''),
(42, 'Other products', ''),
(43, 'DMCA Notice', ''),
(44, 'Terms of Use', ''),
(45, '18 U.S.C. 2257 Record-Keeping Requirements Compliance Statement', ''),
(46, 'Username is required field.', ''),
(47, 'Username contains invalid characters. Please use only A-Z and 0-9, no spaces are special characters', ''),
(48, 'Username must be between %username_min_len and %username_max_len characters long', ''),
(49, 'This username already exists in our system.', ''),
(50, 'Email is required field.', ''),
(51, 'Invalid Email Address', ''),
(52, 'This email already exists in our system.', ''),
(53, 'Password must be at least %pass_min_len characters long', ''),
(54, 'You must agree to our terms of service and privacy policy.', ''),
(55, 'Incorrect CAPTCHA Response', ''),
(56, 'Invalid Video ID', ''),
(57, 'Fill-in your name.', ''),
(58, 'Name cant be longer than %name_max_characters characters.', ''),
(59, 'Fill-in your e-mail.', ''),
(60, 'E-mail address is not valid.', ''),
(61, 'Fill-in content of the message.', ''),
(62, 'Message cant be longer than %msg_max_characters characters.', ''),
(63, 'Captcha is not valid.', ''),
(64, 'We\'re sorry, you can only send a message once every %count minutes. Please try again in %left minute(s', ''),
(65, 'Your message has been sent. Thank you!', ''),
(66, '\'Title\' input can\'t be empty !', ''),
(67, '\'Description\' input can\'t be empty !', ''),
(68, '\'Tags\' input can\'t be empty !', ''),
(69, 'Incorrect CAPTCHA Response.!', ''),
(70, 'Please choose file to upload', ''),
(71, 'Can\'t move file. Please try to upload one more time.', ''),
(72, 'Database error occured.', ''),
(73, 'We\'re sorry, uploading is currently disabled.', ''),
(74, 'Your new password has been sent.', ''),
(75, 'If your email exists in our database, a change password confirmation link has been sent.', ''),
(76, 'Target not found', ''),
(77, '%sitename is currently under maintenance. We should be back shortly. Thank you for your patience.', ''),
(78, 'Invalid ID', ''),
(79, 'Invalid Feed', ''),
(80, 'We\'re sorry, the content titled %title has been deleted from our site and is no longer available.', ''),
(81, 'My Friends', ''),
(82, 'E-mail is required!', ''),
(83, 'This e-mail is not available!', ''),
(84, 'Your avatar is too big. It can be a maximum of %sizekB in GIF, JPG, or PNG format.', ''),
(85, 'You may only upload image files.', ''),
(86, 'Your information has been updated.', ''),
(87, 'Success! Your message has been sent.', ''),
(88, 'All fields are mandatory.', ''),
(89, 'Your account has been temporarily disabled. Please contact the site administrator.', ''),
(90, 'Sorry, you must verify your email before logging in.', ''),
(91, 'The login information you have provided was incorrect. Please try again.', ''),
(92, 'Incorrect username and password', ''),
(93, 'Invalid validation code!', ''),
(94, 'Your account has been successfully verified, and you may now <a href=\"%url\">login</a>', ''),
(95, 'We\'re sorry, this video doesn\'t exist or doesn\'t belong to you.', ''),
(96, 'Your changes have been saved.', ''),
(97, 'You can choose a maximum of 6 categories', ''),
(98, 'Mailbox', ''),
(99, 'My Mailbox', ''),
(100, 'There is no such message in your inbox.', ''),
(101, 'Access Denied', ''),
(102, 'Please provide email subject', ''),
(103, 'User you try to send message to, does not exists.', ''),
(104, 'You cant send email to yourself.', ''),
(105, 'You must be logged in to send friend request to user.', ''),
(106, 'You can not be friend with yourself.', ''),
(107, 'Your friend request was sent correctly.', ''),
(108, 'You already sent friend request to this user.', ''),
(109, 'You already are friends with this user.', ''),
(110, 'Hello, it\'s', ''),
(111, 'Send Friend Request', ''),
(112, 'Embed Video', ''),
(113, 'To add this video to your own website, please add the following embed code:', ''),
(114, 'Video Information', ''),
(115, 'Title', ''),
(116, 'Description', ''),
(117, 'Keywords', ''),
(118, 'Length', ''),
(119, 'Missing content id number', ''),
(120, 'Your message has been sent, and you should recieve a reply within 24 hours if a reply was requested.', ''),
(121, 'Please use this form to report any content to us that may be deemed inappropriate.', ''),
(122, 'Name', ''),
(123, 'Email Address', ''),
(124, 'Reason', ''),
(125, '-Select-', ''),
(126, 'Inappropriate (rape, incest, bestiality, etc', ''),
(127, 'Underage', ''),
(128, 'Copyrighted Material', ''),
(129, 'Video Not Playing', ''),
(130, 'Other Reason', ''),
(131, 'Message', ''),
(132, 'Human?', ''),
(133, 'Send report', ''),
(134, 'You don\'t have permissions to log in with Facebook.', ''),
(135, 'Error during log in with Facebook.', ''),
(136, 'Looks like this Facebook user doesn\'t exist. Try with correct credentials.', ''),
(137, 'You have logged in with Facebook.', ''),
(138, 'Cannot login with Facebook.', ''),
(139, 'You have logged in with Twitter.', ''),
(140, 'Cannot login with Twitter.', ''),
(141, 'You have been logged in.', ''),
(142, 'An error has occured: %error', ''),
(143, 'Prev', ''),
(144, 'Page', ''),
(145, 'Next', ''),
(146, 'Vote up', ''),
(147, 'Vote down', ''),
(148, 'Reply To', ''),
(149, 'Username', ''),
(150, 'Subject', ''),
(151, 'Send Message', ''),
(152, 'From', ''),
(153, 'Received', ''),
(154, 'Reply', ''),
(155, 'Delete', ''),
(156, 'To', ''),
(157, 'Sent', ''),
(158, 'Action', ''),
(159, 'Your outbox is empty', ''),
(160, 'Delete messages', ''),
(161, 'Your inbox is empty', ''),
(162, 'No Subject', ''),
(163, 'Inbox', ''),
(164, 'Sent Items', ''),
(165, 'Compose', ''),
(166, 'Admin', ''),
(167, 'Edit profile', ''),
(168, 'Messages', ''),
(169, 'User Informations', ''),
(170, 'Joined', ''),
(171, 'Last Login', ''),
(172, 'Gender', ''),
(173, 'Age', ''),
(174, 'Location', ''),
(175, 'A little about me', ''),
(176, 'Wall', ''),
(177, 'Friends', ''),
(178, 'My', ''),
(179, 'Recently Featured', ''),
(180, 'Advertisement', ''),
(181, 'Ads by mechbunny', ''),
(182, 'Add To Friends', ''),
(183, 'Recent Video Uploads', ''),
(184, 'Recent Photo Uploads', ''),
(185, 'Profile', ''),
(186, 'Aka', ''),
(187, 'Dob', ''),
(188, 'Height', ''),
(189, 'Weight', ''),
(190, 'Measurements', ''),
(191, 'Hair', ''),
(192, 'Eyes', ''),
(193, 'Ethnicity', ''),
(194, 'Official site', ''),
(195, 'Rank', ''),
(196, 'Biography', ''),
(197, 'Anonymous', ''),
(198, 'More Tags', ''),
(199, 'Close\") . \"\' data-opt-title=\'\" . Error', ''),
(200, 'Previous', ''),
(201, 'Download', ''),
(202, 'Close', ''),
(203, 'Report', ''),
(204, 'Share', ''),
(205, 'Comments', ''),
(206, 'Sorry, no tags found!', ''),
(207, 'Purchase Tokens', ''),
(208, 'Confirm Purchase', ''),
(209, 'Password', ''),
(210, 'Email', ''),
(211, 'Click here to indicate that you have read and agree to the', ''),
(212, 'Register', ''),
(213, 'Login by Facebook', ''),
(214, 'Login by Twitter', ''),
(215, 'Sorry, no pornstars were found.', ''),
(216, 'Forgot Password?', ''),
(217, 'Not a member? Click here to sign up, its free!', ''),
(218, 'New invitations', ''),
(219, 'Sent Invitations', ''),
(220, 'User', ''),
(221, 'Approve', ''),
(222, 'ago', ''),
(223, 'Accept ALL', ''),
(224, 'Decline ALL', ''),
(225, 'No new invation', ''),
(226, 'Date added', ''),
(227, 'You have no friends', ''),
(228, 'No result', ''),
(229, 'Comma', ''),
(230, 'Access Level', ''),
(231, 'Public', ''),
(232, 'Private', ''),
(233, 'Select up to %max_categories Categories', ''),
(234, '(Hold CTRL to make multiple selections', ''),
(235, 'Save', ''),
(236, 'Premium', ''),
(237, 'Edit', ''),
(238, 'There are no comments for this video. Please leave your feedback and be the first!', ''),
(239, 'There are no comments for this model. Please leave your feedback and be the first!', ''),
(240, 'There are no comments for this profile. Please leave your feedback and be the first!', ''),
(241, 'Related Content', ''),
(242, 'Some functionality of this demo site is disabled.', ''),
(243, 'My profile', ''),
(244, 'Favorites', ''),
(245, 'Buy Tokens', ''),
(246, 'Logout', ''),
(247, 'My Rentals', ''),
(248, 'Upload avatar', ''),
(249, 'Change Password', ''),
(250, 'Male', ''),
(251, 'Female', ''),
(252, 'About yourself...', ''),
(253, 'About yourself', ''),
(254, 'E-mail Notifications', ''),
(255, 'Email me when someone sends me a private message', ''),
(256, 'Email me when someone posts a comment to my content', ''),
(257, 'Email me when someone writes on my wall', ''),
(258, 'Email me when someone sends me a friend request', ''),
(259, 'Mechbunny Tube Script © Copyright 2021', ''),
(260, 'Show more', ''),
(261, 'Show less', ''),
(262, 'Write your comment here', ''),
(263, 'You must be logged in to post wall comments', ''),
(264, 'You must be a premium member to view this video!', ''),
(265, 'Click here to sign up!', ''),
(266, 'We\'re sorry, You must be friends with ', ''),
(267, 'Click here to view their profile', ''),
(268, 'No categories found', ''),
(269, 'Sign up for a personal account to save videos, leave comments and utilize other advanced features!', ''),
(270, 'I certify that all models depicted are at least %html_strong_open 18 years of age %html_strong_close.', ''),
(271, 'I certify that %html_strong_open I am the owner %html_strong_close or licensed to use this content.', ''),
(272, 'I certify that %html_strong_open I have consent %html_strong_close of all models depicted to submit this content.', ''),
(273, 'Fill out this form to have your password emailed to you', ''),
(274, 'Verification mail was sent to you email address', ''),
(275, 'To login please verify your account through email verification link', ''),
(276, 'You may now login at the', ''),
(277, 'You may login to your account using the form below', ''),
(278, 'Go!', ''),
(279, 'No users found', ''),
(280, 'No paysites found.', ''),
(281, 'Show filters', ''),
(282, 'Search Filter', ''),
(283, 'With avatars', ''),
(284, 'Has uploaded videos', ''),
(285, 'Has uploaded photos', ''),
(286, 'Reset filters', ''),
(287, 'Purchase 1 Token', ''),
(288, 'Purchase 5 Tokens', ''),
(289, 'Purchase 10 Tokens', ''),
(290, 'Purchase 20 Tokens', ''),
(291, 'You must purchase access to this video in order to view it.', ''),
(292, 'Click Here To Purchase Access!', ''),
(293, 'Click in textarea to copy code', ''),
(294, 'Code copied to clipboard', ''),
(295, 'Resolution', ''),
(296, 'Size', ''),
(297, 'Ok', ''),
(298, 'File', ''),
(299, 'Upload now!', ''),
(300, 'Filter Content', ''),
(301, 'Straight', ''),
(302, 'Gay', ''),
(303, 'Shemale', ''),
(304, 'Filter Type', ''),
(305, 'Duration', ''),
(306, 'Your account has been disabled', ''),
(307, 'More Information', ''),
(308, 'OTHER PRODUCTS', ''),
(309, 'Create Free Account', ''),
(310, 'Create Free Account', ''),
(311, 'Add to favorites', ''),
(312, 'Add to favorites', ''),
(313, 'Add to favorites', ''),
(314, 'Add to favorites', ''),
(315, 'Add to favorites', ''),
(316, 'Add to favorites', ''),
(317, 'Add to favorites', ''),
(318, 'Add to favorites', ''),
(319, 'Add to favorites', ''),
(320, 'Add to favorites', ''),
(321, 'Add to favorites', ''),
(322, 'Add to favorites', ''),
(323, 'Add to favorites', ''),
(324, 'Add to favorites', ''),
(325, 'Add to favorites', ''),
(326, 'Add to favorites', ''),
(327, 'Add to favorites', ''),
(328, 'Add to favorites', ''),
(329, 'Add to favorites', ''),
(330, 'Add to favorites', ''),
(331, 'terms of service and privacy policy', ''),
(332, 'Send message', ''),
(333, 'Page you are looking for does not exist', ''),
(334, 'see more', ''),
(335, 'see more', ''),
(336, 'Add Favorite', ''),
(337, 'Remove from Favorites', ''),
(338, 'Remove from Favorites', ''),
(339, 'Remove from Favorites', ''),
(340, 'Thanks for voting!', ''),
(341, 'Sorry, you\'ve already voted.', ''),
(342, '%count mins', ''),
(343, '%count mins', ''),
(344, '1 hr', ''),
(345, '1 hr', ''),
(346, '1 min', ''),
(347, '%count hrs', ''),
(348, '%count hrs', ''),
(349, '%count days', '');
-- --------------------------------------------------------
--
-- Table structure for table `locales_target`
--
CREATE TABLE `locales_target` (
`record_num` int(11) NOT NULL,
`source_id` int(11) NOT NULL,
`language` varchar(2) NOT NULL,
`translated_text` text NOT NULL,
`translated_text_contextual` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `metatags`
--
CREATE TABLE `metatags` (
`controller` varchar(255) NOT NULL,
`mode` varchar(255) NOT NULL,
`path` varchar(255) NOT NULL,
`language` varchar(2) NOT NULL DEFAULT 'EN',
`header_title` varchar(255) NOT NULL,
`meta_title` varchar(255) NOT NULL,
`meta_description` text NOT NULL,
`meta_keywords` text NOT NULL,
`robots` varchar(255) NOT NULL,
`record_num` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `metatags`
--
INSERT INTO `metatags` (`controller`, `mode`, `path`, `language`, `header_title`, `meta_title`, `meta_description`, `meta_keywords`, `robots`, `record_num`) VALUES
('index', 'default', '', 'EN', 'Hot Webcam Girls - {{SITENAME}}', 'Hot Webcam Girls - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 17),
('403', '', '', 'EN', 'Access Denied', 'Access Denied - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', 'noindex', 18),
('404', '', '', 'EN', 'Page Not Found', 'Page Not Found - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', 'noindex', 19),
('login', '', '', 'EN', 'Login', 'Login - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 20),
('signup', '', '', 'EN', 'Signup', 'Signup - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 21),
('sites', '', '', 'EN', 'Webcam Sites', 'Webcam Sites - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 22),
('contact', '', '', 'EN', 'Contact Us', 'Contact - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 24),
('forgot_pass', '', '', 'EN', 'Forgot Your Password?', 'Forgot Your Password - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 26),
('validate', '', '', 'EN', 'Validate Account', 'Validate Account - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 28),
('my_profile', '', '', 'EN', 'Dashboard', 'Dashboard - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 29),
('edit_profile', '', '', 'EN', 'Settings', 'Settings - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 30),
('languages', '', '', 'EN', 'Languages', 'Languages- {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 35),
('displayStatic', '', '', 'EN', '{{TITLE}}', '{{TITLE}} - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 45),
('tags', '', '', 'EN', 'Tags', 'Tags - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 52),
('performer', '', '', 'EN', '{{USERNAME}} from {{SITE_TITLE}} Live Webcam', '{{USERNAME}} from {{SITE_TITLE}} Live Webcam - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 56),
('favorites', '', '', 'EN', 'My Favorites', 'My Favorites - {{SITENAME}}', '{{DESCRIPTION}}', '{{KEYWORDS}}', '', 57);
-- --------------------------------------------------------
--
-- Table structure for table `niches`
--
CREATE TABLE `niches` (
`name` varchar(255) NOT NULL,
`ad0` mediumtext NOT NULL,
`ad1` mediumtext NOT NULL,
`ad2` mediumtext NOT NULL,
`ad3` mediumtext NOT NULL,
`ad4` mediumtext NOT NULL,
`ad5` mediumtext NOT NULL,
`ad6` mediumtext NOT NULL,
`ad7` mediumtext NOT NULL,
`ad8` mediumtext NOT NULL,
`ad9` mediumtext NOT NULL,
`postroll` varchar(255) NOT NULL,
`url` varchar(255) NOT NULL,
`enabled` int(11) NOT NULL DEFAULT 1,
`description` mediumtext NOT NULL,
`metakw` varchar(255) NOT NULL,
`metadesc` varchar(255) NOT NULL,
`metaheader` varchar(255) NOT NULL,
`metatitle` varchar(255) NOT NULL,
`csv_match` varchar(255) NOT NULL,
`flag_navigation` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Whether to show this channel in navigation dropdown/toolbar',
`paysite` int(11) NOT NULL,
`tagImage` varchar(255) NOT NULL,
`record_num` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `niches`
--
--
-- Table structure for table `niches_languages`
--
CREATE TABLE `niches_languages` (
`niche` int(11) NOT NULL,
`language` varchar(3) NOT NULL,
`name` varchar(255) NOT NULL,
`data` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `paysites`
--
CREATE TABLE `paysites` (
`name` varchar(255) NOT NULL,
`functionName` varchar(255) NOT NULL,
`apiData` varchar(2048) NOT NULL,
`apiDataFieldName` varchar(255) NOT NULL DEFAULT 'Affiliate ID',
`maxResults` int(11) NOT NULL DEFAULT 1000,
`parameters` varchar(1024) NOT NULL,
`parametersPlaceholder` varchar(1024) NOT NULL,
`wmReferral` varchar(1024) NOT NULL,
`preferred` varchar(255) NOT NULL DEFAULT 'revshare',
`logoImage` varchar(255) NOT NULL,
`whitelist` longtext NOT NULL,
`whitelabel_domain` varchar(255) NOT NULL,
`whitelabel_domain_placeholder` varchar(255) NOT NULL,
`enabled` int(11) NOT NULL DEFAULT 1,
`record_num` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `paysites`
--
INSERT INTO `paysites` (`name`, `functionName`, `apiData`, `apiDataFieldName`, `maxResults`, `parameters`, `parametersPlaceholder`, `wmReferral`, `preferred`, `logoImage`, `whitelist`, `whitelabel_domain`, `whitelabel_domain_placeholder`, `enabled`, `record_num`) VALUES
('Chaturbate', 'chaturbateData', '', 'Affiliate ID', 1000, '', '', 'https://chaturbate.com/in/?tour=9O7D&campaign=Fxd8Y&track=default', 'iframe_embed_revshare', 'chaturbate.jpg', '', '', '', 1, 1),
('BongaCams', 'bongaData', '', 'Affiliate ID', 1000, '', '', 'https://en.bongacash.com/ref?c=755842', 'iframe_embed_revshare', 'bongacams.jpg', '', '', '', 1, 2),
('Cam4', 'cam4Data', '', 'Affiliate ID ', 1000, '', '&gender=female&age=18-19', 'https://affiliates.cam4.com/signup/3264', 'chat_room_url', 'cam4.jpg', '', '', '', 1, 3),
('CherryTV', 'cherryTVData', '', 'API Key', 1000, '', '', '', 'iframe_embed_revshare', 'cherrytv.jpg', '', '', '', 1, 4),
('CamSoda', 'camSodaData', '', 'Affiliate ID', 1000, '', '', '', 'iframe_embed_revshare', 'camsoda.jpg', '', '', '', 1, 5),
('LiveJasmin', 'liveJasminData', '', 'Access Key', 1000, '', 'PS ID / AWEmpire Username', 'https://apptjmp.com/?siteId=awe&pageName=signup&prm[referral_rs]=mechbunny&filters=', 'iframe_embed_revshare', 'lj.jpg', '', '', '', 1, 7),
('StripChat', 'stripChatData', '', 'Affiliate ID', 1000, '', '', 'https://stripcash.com/sign-up/?userId=04941dc271091a0042dfa9349fe8170c649ddd1f0e45a3f1e40b5bd4dd9188b3', 'iframe_embed_revshare', 'stripchat.jpg', '', '', '', 1, 8),
('XLove', 'xLoveData', '', 'AuthSecret', 1000, '21774', 'Numeric Affiliate ID (5 Digit)', 'https://www.xlovecash.com/?idc=21774&trac=', 'chat_room_url', 'xlove.jpg', '', '', '', 1, 10);
-- --------------------------------------------------------
--
-- Table structure for table `paysites_languages`
--
CREATE TABLE `paysites_languages` (
`paysite` int(11) NOT NULL,
`language` varchar(3) NOT NULL,
`data` mediumtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `performers`
--
CREATE TABLE `performers` (
`username` varchar(255) NOT NULL,
`room_subject` mediumtext NOT NULL,
`seconds_online` int(11) NOT NULL,
`spoken_languages` varchar(255) NOT NULL,
`num_users` int(11) NOT NULL,
`chat_room_url` text NOT NULL,
`gender` varchar(3) NOT NULL DEFAULT 'f',
`age` int(11) NOT NULL,
`race` varchar(255) NOT NULL,
`hair` varchar(255) NOT NULL,
`bust` varchar(255) NOT NULL,
`figure` varchar(255) NOT NULL,
`pubic_area` varchar(255) NOT NULL,
`extra` varchar(255) NOT NULL,
`recorded` varchar(255) NOT NULL,
`current_show` varchar(255) NOT NULL,
`iframe_embed_revshare` text NOT NULL,
`birthday` date NOT NULL,
`image_url` varchar(255) NOT NULL,
`location` varchar(255) NOT NULL,
`live_snapshot_url` varchar(255) NOT NULL,
`block_from_states` varchar(255) NOT NULL,
`block_from_countries` varchar(255) NOT NULL,
`iframe_embed` text NOT NULL,
`chat_room_url_revshare` text NOT NULL,
`position` int(11) NOT NULL,
`last_online` date NOT NULL,
`tags` varchar(255) NOT NULL,
`status` int(1) NOT NULL,
`site` varchar(255) NOT NULL,
`api_counter` int(11) NOT NULL,
`deleted` tinyint(1) NOT NULL DEFAULT 0,
`redirect_url` varchar(1024) NOT NULL,
`return_code` int(11) NOT NULL DEFAULT 200,
`enabled` int(11) NOT NULL DEFAULT 1,
`hd` tinyint(1) NOT NULL DEFAULT 0,
`custom_text` longtext NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `ratings`
--
CREATE TABLE `ratings` (
`performer_name` varchar(255) NOT NULL,
`performer_site` int(11) NOT NULL,
`total_votes` int(11) NOT NULL,
`total_value` int(11) NOT NULL,
`used_ips` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `ratings`
--
-- --------------------------------------------------------
--
-- Table structure for table `ratings_log`
--
CREATE TABLE `ratings_log` (
`ip` varchar(255) NOT NULL,
`performer_site` int(11) NOT NULL,
`performer_name` varchar(255) NOT NULL,
`rate` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `ratings_log`
--
-- --------------------------------------------------------
--
-- Table structure for table `regions`
--
CREATE TABLE `regions` (
`code` varchar(2) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`country` varchar(2) DEFAULT NULL,
`record_num` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `regions`
--
INSERT INTO `regions` (`code`, `name`, `country`, `record_num`) VALUES
('AL', 'Alabama', 'US', 1),
('AK', 'Alaska', 'US', 2),
('AZ', 'Arizona', 'US', 3),
('AR', 'Arkansas', 'US', 4),
('CA', 'California', 'US', 5),
('CO', 'Colorado', 'US', 6),
('CT', 'Connecticut', 'US', 7),
('DE', 'Delaware', 'US', 8),
('DC', 'District of Columbia', 'US', 9),
('FL', 'Florida', 'US', 10),
('GA', 'Georgia', 'US', 11),
('HI', 'Hawaii', 'US', 12),
('ID', 'Idaho', 'US', 13),
('IL', 'Illinois', 'US', 14),
('IN', 'Indiana', 'US', 15),
('IA', 'Iowa', 'US', 16),
('KS', 'Kansas', 'US', 17),
('KY', 'Kentucky', 'US', 18),
('LA', 'Lousisiana', 'US', 19),
('ME', 'Maine', 'US', 20),
('MD', 'Maryland', 'US', 21),
('MA', 'Massachusetts', 'US', 22),
('MI', 'Michigan', 'US', 23),
('MN', 'Minnesota', 'US', 24),
('MS', 'Mississippi', 'US', 25),
('MO', 'Missouri', 'US', 26),
('MT', 'Montana', 'US', 27),
('NE', 'Nebraska', 'US', 28),
('NV', 'Nevada', 'US', 29),
('NH', 'New Hampshire', 'US', 30),
('NJ', 'New Jersey', 'US', 31),
('NM', 'New Mexico', 'US', 32),
('NY', 'New York', 'US', 33),
('NC', 'North Carolina', 'US', 34),
('ND', 'North Dakota', 'US', 35),
('OH', 'Ohio', 'US', 36),
('OK', 'Oklahoma', 'US', 37),
('OR', 'Oregon', 'US', 38),
('PA', 'Pennsylvania', 'US', 39),
('PR', 'Puerto Rico', 'US', 40),
('RI', 'Rhode Island', 'US', 41),
('SC', 'South Carolina', 'US', 42),
('SD', 'South Dakota', 'US', 43),
('TN', 'Tennesee', 'US', 44),
('TX', 'Texas', 'US', 45),
('UT', 'Utah', 'US', 46),
('VT', 'Vermont', 'US', 47),
('VA', 'Virginia', 'US', 48),
('WA', 'Washington', 'US', 49),
('WV', 'West Virginia', 'US', 50),
('WI', 'Wisconsin', 'US', 51),
('WY', 'Wyoming', 'US', 52),
('AB', 'Alberta', 'CA', 53),
('BC', 'British Columbia', 'CA', 54),
('MB', 'Manitoba', 'CA', 55),
('NB', 'New Brunswick', 'CA', 56),
('NL', 'Newfoundland', 'CA', 57),
('NS', 'Nova Scotia', 'CA', 58),
('NT', 'Northwest Territories', 'CA', 59),
('NU', 'Nunavut', 'CA', 60),
('ON', 'Ontario', 'CA', 61),
('PE', 'Prince Edward Island', 'CA', 62),
('QC', 'Quebec', 'CA', 63),
('SK', 'Saskatchewan', 'CA', 64),
('YT', 'Yukon Territory', 'CA', 65);
-- --------------------------------------------------------
--
-- Table structure for table `search_log`
--
CREATE TABLE `search_log` (
`word` varchar(255) CHARACTER SET utf8 NOT NULL,
`counter` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `static`
--
CREATE TABLE `static` (
`filename` varchar(255) NOT NULL,
`title` varchar(255) NOT NULL,
`headertitle` varchar(255) NOT NULL,
`metakw` varchar(255) NOT NULL,
`metadesc` mediumtext NOT NULL,
`body` mediumtext NOT NULL,
`status` tinyint(1) NOT NULL DEFAULT 1,
`record_num` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `static`
--
INSERT INTO `static` (`filename`, `title`, `headertitle`, `metakw`, `metadesc`, `body`, `status`, `record_num`) VALUES
('tos.html', 'Terms of Service', 'Terms of Service', 'Terms of Service', 'Terms of Service', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>', 1, 1),
('2257.html', '2257', '2257', '2257', '2257', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>', 1, 2),
('dmca.html', 'DMCA', 'DMCA', 'DMCA', 'DMCA', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>', 1, 3),
('privacy.html', 'Privacy Policy', 'Privacy Policy', '', '', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.', 1, 4);
-- --------------------------------------------------------
--
-- Table structure for table `static_languages`
--
CREATE TABLE `static_languages` (
`static` int(11) NOT NULL,
`language` varchar(3) NOT NULL,
`data` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `status`
--
CREATE TABLE `status` (
`scraper_running` int(11) NOT NULL,
`scraper_done` int(11) NOT NULL,
`scraper_total` int(11) NOT NULL,
`scraper_pid` int(11) NOT NULL,
`scraper_processing` varchar(1024) NOT NULL,
`scraper_processing_output` varchar(1024) NOT NULL,
`encoder_running` int(11) NOT NULL,
`encoder_done` int(11) NOT NULL,
`encoder_pid` int(11) NOT NULL,
`encoder_total` int(11) NOT NULL,
`csv_import_running` int(11) NOT NULL,
`csv_import_total` int(11) NOT NULL,
`csv_photos_import_running` int(11) NOT NULL,
`csv_photos_import_total` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `status`
--
INSERT INTO `status` (`scraper_running`, `scraper_done`, `scraper_total`, `scraper_pid`, `scraper_processing`, `scraper_processing_output`, `encoder_running`, `encoder_done`, `encoder_pid`, `encoder_total`, `csv_import_running`, `csv_import_total`, `csv_photos_import_running`, `csv_photos_import_total`) VALUES
(0, 0, 0, 0, '', '', 0, 0, 24459, 0, 0, 0, 0, 0);
-- --------------------------------------------------------
--
-- Table structure for table `template_configuration`
--
CREATE TABLE `template_configuration` (
`field_name` varchar(255) NOT NULL,
`field_description` varchar(255) NOT NULL,
`field` varchar(255) NOT NULL,
`value` mediumtext NOT NULL,
`data` mediumtext NOT NULL,
`weight` int(11) NOT NULL DEFAULT 1,
`template` varchar(255) NOT NULL DEFAULT 'default',
`localized` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is language-sensitive?',
`settings` text NOT NULL,
`record_num` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `template_configuration`
--
INSERT INTO `template_configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `template`, `localized`, `settings`, `record_num`) VALUES
('Sidebar - Status', 'Enable/Disable Online Yes/No Filter in Sidebar', 'template_sidebar_status', '1', '{\"true\":1,\"false\":0}', 1, 'default', 0, '', 3),
('Sidebar - Gender', 'Enable/Disable Gender Filter in Sidebar', 'template_sidebar_gender', '1', '{\"true\":1,\"false\":0}', 1, 'default', 0, '', 171),
('Sidebar - Age', 'Enable/Disable Age Filter in Sidebar', 'template_sidebar_age', '1', '{\"true\":1,\"false\":0}', 1, 'default', 0, '', 172),
('Sidebar - Tags', 'Enable/Disable Tag Filter in Sidebar', 'template_sidebar_tags', '1', '{\"true\":1,\"false\":0}', 1, 'default', 0, '', 173),
('Sidebar - Ethnicity', 'Enable/Disable Ethnicity Filter in Sidebar', 'template_sidebar_ethnicity', '1', '{\"true\":1,\"false\":0}', 1, 'default', 0, '', 174),
('Sidebar - Hair Color', 'Enable/Disable Hair Color Filter in Sidebar', 'template_sidebar_hair', '1', '{\"true\":1,\"false\":0}', 1, 'default', 0, '', 175),
('Adblock Check', 'Enable/Disable adblock check on webcam page', 'template_adblock_check', '1', '{\"true\":1,\"false\":0}', 1, 'default', 0, '', 176);
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`username` varchar(64) NOT NULL,
`password` varchar(32) NOT NULL,
`salt` varchar(255) NOT NULL,
`forgot_pass_hash` varchar(64) NOT NULL,
`email` varchar(64) NOT NULL,
`is_admin` int(11) NOT NULL,
`last_ip` varchar(255) NOT NULL,
`date_joined` timestamp NOT NULL DEFAULT current_timestamp(),
`freeform` varchar(255) NOT NULL,
`enabled` int(11) NOT NULL DEFAULT 1,
`lastlogin` varchar(255) NOT NULL,
`validate` varchar(64) NOT NULL,
`custom` mediumtext NOT NULL,
`email_verified` int(1) NOT NULL DEFAULT 0,
`registration_ip` varchar(50) NOT NULL,
`facebook_id` bigint(11) NOT NULL,
`twitter_id` bigint(11) NOT NULL,
`session_reload` tinyint(1) NOT NULL DEFAULT 0,
`record_num` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `users`
--
-- --------------------------------------------------------
--
-- Table structure for table `user_logins`
--
CREATE TABLE `user_logins` (
`time` datetime NOT NULL,
`user` varchar(255) NOT NULL,
`ip` varchar(255) NOT NULL,
`status` varchar(255) NOT NULL,
`record_num` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `user_logins`
--
--
-- Indexes for dumped tables
--
--
-- Indexes for table `blocks`
--
ALTER TABLE `blocks`
ADD PRIMARY KEY (`record_num`),
ADD KEY `status` (`status`);
--
-- Indexes for table `blocks_languages`
--
ALTER TABLE `blocks_languages`
ADD UNIQUE KEY `uidx_block_language` (`block_id`,`language`);
--
-- Indexes for table `cache`
--
ALTER TABLE `cache`
ADD PRIMARY KEY (`key`);
--
-- Indexes for table `comments`
--
ALTER TABLE `comments`
ADD PRIMARY KEY (`record_num`),
ADD KEY `content` (`performer_name`),
ADD KEY `timestamp` (`timestamp`),
ADD KEY `type` (`performer_site`),
ADD KEY `userid` (`userid`);
--
-- Indexes for table `comments_likes`
--
ALTER TABLE `comments_likes`
ADD UNIQUE KEY `comment_id` (`comment_id`,`ip`);
--
-- Indexes for table `configuration`
--
ALTER TABLE `configuration`
ADD PRIMARY KEY (`record_num`),
ADD UNIQUE KEY `field` (`field`);
--
-- Indexes for table `countries`
--
ALTER TABLE `countries`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uidx_code` (`code`);
--
-- Indexes for table `custom_links`
--
ALTER TABLE `custom_links`
ADD UNIQUE KEY `record_num` (`record_num`),
ADD UNIQUE KEY `url` (`url`);
--
-- Indexes for table `email_templates`
--
ALTER TABLE `email_templates`
ADD PRIMARY KEY (`record_num`),
ADD UNIQUE KEY `name` (`name`);
--
-- Indexes for table `email_translations`
--
ALTER TABLE `email_translations`
ADD PRIMARY KEY (`record_num`),
ADD UNIQUE KEY `language` (`language`,`template_id`);
--
-- Indexes for table `favorites`
--
ALTER TABLE `favorites`
ADD PRIMARY KEY (`record_num`),
ADD UNIQUE KEY `user_2` (`user`,`performer_name`,`performer_site`),
ADD KEY `user` (`user`);
--
-- Indexes for table `fields`
--
ALTER TABLE `fields`
ADD PRIMARY KEY (`record_num`),
ADD UNIQUE KEY `module` (`module`,`code`);
--
-- Indexes for table `fields_values`
--
ALTER TABLE `fields_values`
ADD PRIMARY KEY (`record_num`);
--
-- Indexes for table `keywords`
--
ALTER TABLE `keywords`
ADD KEY `word` (`word`),
ADD KEY `amount` (`amount`);
--
-- Indexes for table `languages`
--
ALTER TABLE `languages`
ADD PRIMARY KEY (`record_num`),
ADD UNIQUE KEY `iso` (`iso`);
--
-- Indexes for table `link_shortener`
--
ALTER TABLE `link_shortener`
ADD PRIMARY KEY (`record_num`),
ADD KEY `slug` (`slug`);
--
-- Indexes for table `locales_source`
--
ALTER TABLE `locales_source`
ADD PRIMARY KEY (`record_num`);
--
-- Indexes for table `locales_target`
--
ALTER TABLE `locales_target`
ADD PRIMARY KEY (`record_num`),
ADD UNIQUE KEY `source_id` (`source_id`,`language`),
ADD KEY `source_lang_idx` (`language`);
--
-- Indexes for table `metatags`
--
ALTER TABLE `metatags`
ADD PRIMARY KEY (`record_num`),
ADD UNIQUE KEY `uidx_metatag` (`controller`,`mode`,`path`,`language`);
--
-- Indexes for table `niches`
--
ALTER TABLE `niches`
ADD PRIMARY KEY (`record_num`),
ADD KEY `name` (`name`),
ADD KEY `flag_navigation` (`flag_navigation`);
--
-- Indexes for table `niches_languages`
--
ALTER TABLE `niches_languages`
ADD UNIQUE KEY `niche` (`niche`,`language`);
--
-- Indexes for table `paysites`
--
ALTER TABLE `paysites`
ADD PRIMARY KEY (`record_num`),
ADD KEY `enabled` (`enabled`);
--
-- Indexes for table `paysites_languages`
--
ALTER TABLE `paysites_languages`
ADD UNIQUE KEY `paysite` (`paysite`,`language`);
--
-- Indexes for table `performers`
--
ALTER TABLE `performers`
ADD UNIQUE KEY `username_site` (`username`,`site`),
ADD KEY `status` (`status`,`deleted`) USING BTREE,
ADD KEY `site` (`site`),
ADD KEY `site_2` (`site`,`enabled`,`deleted`,`block_from_countries`);
--
-- Indexes for table `ratings`
--
ALTER TABLE `ratings`
ADD UNIQUE KEY `content` (`performer_name`,`performer_site`);
--
-- Indexes for table `ratings_log`
--
ALTER TABLE `ratings_log`
ADD UNIQUE KEY `ip` (`ip`,`performer_site`,`performer_name`);
--
-- Indexes for table `regions`
--
ALTER TABLE `regions`
ADD PRIMARY KEY (`record_num`),
ADD KEY `code` (`code`),
ADD KEY `country_idx` (`country`);
--
-- Indexes for table `search_log`
--
ALTER TABLE `search_log`
ADD UNIQUE KEY `word` (`word`) USING BTREE;
--
-- Indexes for table `static`
--
ALTER TABLE `static`
ADD PRIMARY KEY (`record_num`),
ADD KEY `filename` (`filename`);
--
-- Indexes for table `static_languages`
--
ALTER TABLE `static_languages`
ADD UNIQUE KEY `static` (`static`,`language`);
--
-- Indexes for table `template_configuration`
--
ALTER TABLE `template_configuration`
ADD PRIMARY KEY (`record_num`),
ADD UNIQUE KEY `field` (`field`);
--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`record_num`),
ADD UNIQUE KEY `username` (`username`),
ADD KEY `validate` (`validate`),
ADD KEY `enabled` (`enabled`),
ADD KEY `email` (`email`),
ADD KEY `email_verified` (`email_verified`);
--
-- Indexes for table `user_logins`
--
ALTER TABLE `user_logins`
ADD PRIMARY KEY (`record_num`),
ADD KEY `user` (`user`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `blocks`
--
ALTER TABLE `blocks`
MODIFY `record_num` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `comments`
--
ALTER TABLE `comments`
MODIFY `record_num` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=71;
--
-- AUTO_INCREMENT for table `configuration`
--
ALTER TABLE `configuration`
MODIFY `record_num` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=180;
--
-- AUTO_INCREMENT for table `countries`
--
ALTER TABLE `countries`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=238;
--
-- AUTO_INCREMENT for table `custom_links`
--
ALTER TABLE `custom_links`
MODIFY `record_num` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `email_templates`
--
ALTER TABLE `email_templates`
MODIFY `record_num` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT for table `email_translations`
--
ALTER TABLE `email_translations`
MODIFY `record_num` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT for table `favorites`
--
ALTER TABLE `favorites`
MODIFY `record_num` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `fields`
--
ALTER TABLE `fields`
MODIFY `record_num` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `fields_values`
--
ALTER TABLE `fields_values`
MODIFY `record_num` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=132;
--
-- AUTO_INCREMENT for table `languages`
--
ALTER TABLE `languages`
MODIFY `record_num` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `link_shortener`
--
ALTER TABLE `link_shortener`
MODIFY `record_num` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `locales_source`
--
ALTER TABLE `locales_source`
MODIFY `record_num` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=350;
--
-- AUTO_INCREMENT for table `locales_target`
--
ALTER TABLE `locales_target`
MODIFY `record_num` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `metatags`
--
ALTER TABLE `metatags`
MODIFY `record_num` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=58;
--
-- AUTO_INCREMENT for table `niches`
--
ALTER TABLE `niches`
MODIFY `record_num` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `paysites`
--
ALTER TABLE `paysites`
MODIFY `record_num` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `regions`
--
ALTER TABLE `regions`
MODIFY `record_num` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=66;
--
-- AUTO_INCREMENT for table `static`
--
ALTER TABLE `static`
MODIFY `record_num` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `template_configuration`
--
ALTER TABLE `template_configuration`
MODIFY `record_num` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=177;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `record_num` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `user_logins`
--
ALTER TABLE `user_logins`
MODIFY `record_num` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=52;
COMMIT;
/*!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 */;
ALTER TABLE `status` ADD `cron_last_run` TIMESTAMP NOT NULL AFTER `csv_photos_import_total`;
INSERT INTO `template_configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `template`, `localized`, `settings`, `record_num`) VALUES ('Logo URL', 'Logo URL (use Logo Upload under Settings to Upload, or specify manually)', 'template_logo_url', '', '', '1', 'default', '0', '', NULL);
INSERT INTO `template_configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `template`, `localized`, `settings`, `record_num`) VALUES ('Primary Foreground Color', '', 'template_primary_foreground', '', '', '1', 'default', '0', '', NULL);
INSERT INTO `template_configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `template`, `localized`, `settings`, `record_num`) VALUES ('Secondary Foreground Color', '', 'template_secondary_foreground', '', '', '1', 'default', '0', '', NULL);
INSERT INTO `template_configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `template`, `localized`, `settings`, `record_num`) VALUES ('Primary Background Color', '', 'template_primary_background', '', '', '1', 'default', '0', '', NULL);
INSERT INTO `template_configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `template`, `localized`, `settings`, `record_num`) VALUES ('Secondary Background Color', '', 'template_secondary_background', '', '', '1', 'default', '0', '', NULL);
INSERT INTO `template_configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `template`, `localized`, `settings`, `record_num`) VALUES ('Primary Text Color', '', 'template_primary_text_color', '', '', '1', 'default', '0', '', NULL);
INSERT INTO `template_configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `template`, `localized`, `settings`, `record_num`) VALUES ('Primary Text Color', '', 'template_secondary_text_color', '', '', '1', 'default', '0', '', NULL);
INSERT INTO `template_configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `template`, `localized`, `settings`, `record_num`) VALUES ('Use Color Scheme', 'Enable/Disable Defined Template Color Scheme', 'template_colors_enabled', '1', '{\"true\":1,\"false\":0}', '1', 'default', '0', '', NULL);
ALTER TABLE `paysites` ADD `last_log` LONGTEXT NOT NULL AFTER `whitelabel_domain_placeholder`;
INSERT INTO `paysites` (`name`, `functionName`, `apiData`, `apiDataFieldName`, `maxResults`, `parameters`, `parametersPlaceholder`, `wmReferral`, `preferred`, `logoImage`, `whitelist`, `whitelabel_domain`, `whitelabel_domain_placeholder`, `last_log`, `enabled`, `record_num`) VALUES ('Cambuilder/Streamate', 'cambuilderData', '', 'AFNO for Streamate, enter 0 if using Cambuilder WL', '1000', '', '', 'https://cambuilder.com', 'chat_room_url', 'streamate.png', '', '', 'Cambuilder whitelabel domain, no https://. Empty = Uses Streamate', '', '0', NULL);
INSERT INTO `paysites` (`name`, `functionName`, `apiData`, `apiDataFieldName`, `maxResults`, `parameters`, `parametersPlaceholder`, `wmReferral`, `preferred`, `logoImage`, `whitelist`, `whitelabel_domain`, `whitelabel_domain_placeholder`, `last_log`, `enabled`, `record_num`) VALUES ('ImLive', 'imliveData', '', 'WID', '1000', '', 'Promocode', 'https://affiliate.imlive.com/wmaster.asp?WID=430892700&promocode=BCODET0000271_00000', 'chat_room_url', 'imlive.jpg', '', '', '', '', '0', NULL);
ALTER TABLE `paysites` ADD `slug` VARCHAR(255) NOT NULL AFTER `name`;
UPDATE `paysites` SET `slug` = LOWER(`name`);
UPDATE `paysites` SET `slug` = 'streamate' WHERE `slug` = 'cambuilder/streamate';
UPDATE `paysites` SET preferred = 'iframe_embed' WHERE record_num = 11;
UPDATE paysites SET preferred = 'iframe_embed_revshare' WHERE record_num = '10';
ALTER TABLE `paysites` ADD `preferredLink` VARCHAR(255) NOT NULL AFTER `preferred`;
UPDATE `paysites` SET preferredLink = 'chat_room_url';
UPDATE `paysites` SET enabled = 0;
ALTER TABLE `performers` ADD `persistentTags` VARCHAR(1024) NOT NULL AFTER `tags`, ADD INDEX (`persistentTags`);
ALTER TABLE `paysites` ADD `defaultModelText` TEXT NOT NULL AFTER `whitelabel_domain_placeholder`;
ALTER TABLE `custom_links` ADD `custom_text_alt` LONGTEXT NOT NULL AFTER `custom_text`;
ALTER TABLE `performers` ADD `custom_metadesc` TEXT NOT NULL AFTER `custom_text`;
ALTER TABLE `performers` ADD `custom_title` TEXT NOT NULL AFTER `custom_text`;
CREATE TABLE `paysites_settings` ( `paysite` INT NOT NULL , `name` VARCHAR(255) NOT NULL , `options` LONGTEXT NOT NULL , UNIQUE (`paysite`, `name`)) ENGINE = InnoDB;
ALTER TABLE `paysites_settings` ADD `description` VARCHAR(1024) NOT NULL AFTER `name`;
ALTER TABLE `paysites` ADD `settings_json` LONGTEXT NOT NULL AFTER `last_log`;
INSERT INTO `paysites_settings` (`paysite`, `name`, `options`) VALUES ('7', 'Program', '{"pps":"pps","revs":"revs"}');
INSERT INTO `paysites_settings` (`paysite`, `name`, `options`) VALUES ('1', 'Tracking Campaign', '');
UPDATE `paysites_settings` SET `description` = 'Custom chaturbate tracking campaign. If not defined, uses track=default and track=embed as delivered by API.' WHERE `paysites_settings`.`paysite` = 1 AND `paysites_settings`.`name` = 'Tracking Campaign';
INSERT INTO `configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `group`, `localized`, `settings`, `record_num`) VALUES ('Google Analytics Code', 'Google Analytics Javascript', 'googleAnalytics', '', '', '1', 'site', '0', '', NULL);
INSERT INTO `paysites_settings` (`paysite`, `name`, `description`, `options`) VALUES ('7', 'LiveJasmin Category', 'Category used by API for Livejasmin. Takes effect next time cron runs.', '{\"Girl\":\"girl\",\"Gay\":\"gay\",\"Mature\":\"mature\",\"Fetish\":\"fetish\",\"Transgender\":\"trangender\",\"Lesbian\":\"lesbian\",\"Couple\":\"couple\"}');
UPDATE paysites SET settings_json = '{"Campaign ID":"","LiveJasmin Category":"","Program":"pps","Site":"jasmin"}' WHERE record_num = 7;
UPDATE paysites SET settings_json = '{"IFrame Style":"chatcam","Tracking Campaign":""}' WHERE record_num = 1;
INSERT INTO `paysites_settings` (`paysite`, `name`, `description`, `options`) VALUES ('7', 'Campaign ID', 'Campaign Tracking ID for AWEmpire. Takes effect next time cron runs.', '');
INSERT INTO `paysites_settings` (`paysite`, `name`, `description`, `options`) VALUES ('7', 'Site', 'AWEmpire Site Slug. Takes effect next time cron runs. Jasmin by default.', '{\"LiveJasmin\":\"jasmin\",\"BimBim\":\"bimbim\",\"Joyourself\":\"joy\",\"Live Privates\":\"lpr\",\"CameraBoys\":\"cmb\",\"DickShow\":\"dickshow\",\"MatureCams\":\"mtc\",\"FetishFix\":\"fetishfix\",\"LiveAsianSex\":\"las\",\"MyCams.com\":\"myc\",\"Livesex Awards\":\"lsa\",\"MyTrannyCams\":\"myt\",\"Livesex\":\"livesex\"}');
UPDATE `paysites_settings` SET `options` = '{\"-\":\"\",\"Girl\":\"girl\",\"Gay\":\"gay\",\"Mature\":\"mature\",\"Fetish\":\"fetish\",\"Transgender\":\"trangender\",\"Lesbian\":\"lesbian\",\"Couple\":\"couple\"}' WHERE `paysites_settings`.`paysite` = 7 AND `paysites_settings`.`name` = 'LiveJasmin Category';
INSERT INTO `paysites_settings` (`paysite`, `name`, `description`, `options`) VALUES ('1', 'IFrame Style', 'Chat and Cam is the traditional normal chaturbate iframe. Cam Only is video only with no chat.', '{\"Chat and Cam\":\"chatcam\",\"Cam Only\":\"camonly\"}');
INSERT INTO `paysites_settings` (`paysite`, `name`, `description`, `options`) VALUES ('8', 'Gender', 'Gender of performers pulled from API', '{ \"All\": \"\", \"Female\": \"female\", \"Male\": \"male\", \"Tranny\": \"tranny\", \"Group\": \"group\"}');
INSERT INTO `paysites_settings` (`paysite`, `name`, `description`, `options`) VALUES ('1', 'Gender', 'Gender of performers pulled from API', '{ \"All\": \"\", \"Female\": \"f\", \"Male\": \"m\", \"Tranny\": \"s\", \"couple\": \"c\"}');
ALTER TABLE template_configuration DROP INDEX field;
ALTER TABLE `template_configuration` ADD UNIQUE (`field`, `template`);
INSERT INTO `template_configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `template`, `localized`, `settings`) VALUES
('Sidebar - Status', 'Enable/Disable Online Yes/No Filter in Sidebar', 'template_sidebar_status', '1', '{"true":1,"false":0}', 1, 'default_v2', 0, ''),
('Sidebar - Gender', 'Enable/Disable Gender Filter in Sidebar', 'template_sidebar_gender', '1', '{"true":1,"false":0}', 1, 'default_v2', 0, ''),
('Sidebar - Age', 'Enable/Disable Age Filter in Sidebar', 'template_sidebar_age', '1', '{"true":1,"false":0}', 1, 'default_v2', 0, ''),
('Sidebar - Tags', 'Enable/Disable Tag Filter in Sidebar', 'template_sidebar_tags', '1', '{"true":1,"false":0}', 1, 'default_v2', 0, ''),
('Sidebar - Ethnicity', 'Enable/Disable Ethnicity Filter in Sidebar', 'template_sidebar_ethnicity', '1', '{"true":1,"false":0}', 1, 'default_v2', 0, ''),
('Sidebar - Hair Color', 'Enable/Disable Hair Color Filter in Sidebar', 'template_sidebar_hair', '1', '{"true":1,"false":0}', 1, 'default_v2', 0, ''),
('Adblock Check', 'Enable/Disable adblock check on webcam page', 'template_adblock_check', '1', '{"true":1,"false":0}', 1, 'default_v2', 0, ''),
('Logo URL', 'Logo URL (use Logo Upload under Settings to Upload, or specify manually)', 'template_logo_url', '', '', 1, 'default_v2', 0, ''),
('Primary Foreground Color', '', 'template_primary_foreground', '', '', 1, 'default_v2', 0, ''),
('Secondary Foreground Color', '', 'template_secondary_foreground', '', '', 1, 'default_v2', 0, ''),
('Tertiary Foreground Color', '', 'template_tertiary_foreground', '', '', 1, 'default_v2', 0, ''),
('Primary Background Color', '', 'template_primary_background', '', '', 1, 'default_v2', 0, ''),
('Secondary Background Color', '', 'template_secondary_background', '', '', 1, 'default_v2', 0, ''),
('Tertiary Background Color', '', 'template_tertiary_background', '', '', 1, 'default_v2', 0, ''),
('Primary Text Color', '', 'template_primary_text_color', '', '', 1, 'default_v2', 0, ''),
('Secondary Text Color', '', 'template_secondary_text_color', '', '', 1, 'default_v2', 0, ''),
('Tertiary Text Color', '', 'template_tertiary_text_color', '', '', 1, 'default_v2', 0, ''),
('Use Color Scheme', 'Enable/Disable Defined Template Color Scheme', 'template_colors_enabled', '1', '{"true":1,"false":0}', 1, 'default_v2', 0, '');
INSERT INTO `paysites` (`name`, `slug`, `functionName`, `apiData`, `apiDataFieldName`, `maxResults`, `parameters`, `parametersPlaceholder`, `wmReferral`, `preferred`, `preferredLink`, `logoImage`, `whitelist`, `whitelabel_domain`, `whitelabel_domain_placeholder`, `defaultModelText`, `last_log`, `settings_json`, `enabled`, `record_num`) VALUES ('Flirt4Free', 'flirt4free', 'flirtForFreeData', '', 'API Key', '1000', '', '', 'https://affiliates.flirt4free.com/', 'iframe_embed', 'chat_room_url', 'flirt4free.jpg', '', '', '', '', '', '', '0', NULL);
UPDATE `paysites` SET `parametersPlaceholder` = 'Tracking Code' WHERE `paysites`.`record_num` = 13;
INSERT INTO `paysites_settings` (`paysite`, `name`, `description`, `options`) VALUES ('13', 'Gender', 'Gender of performers pulled from API', '{ "All": "all", "Female": "girls", "Male": "guys", "Tranny": "trans"}');
INSERT INTO `template_configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `template`, `localized`, `settings`, `record_num`) VALUES ('Homepage Top Text', '', 'template_homepage_top_text', '', '', '1', 'default_v2', '0', '', NULL);
INSERT INTO `paysites_settings` (`paysite`, `name`, `description`, `options`) VALUES ('2', 'Gender', 'Gender of performers pulled from API', '{ \"All\": \"\", \"Female\": \"f\", \"couple\": \"c\"}');
INSERT INTO `paysites_settings` (`paysite`, `name`, `description`, `options`) VALUES ('3', 'Gender', 'Gender of performers pulled from API', '{ \"All\": \"\", \"Female\": \"female\", \"Male\": \"male\", \"Shemale\": \"shemale\"}');
INSERT INTO `paysites_settings` (`paysite`, `name`, `description`, `options`) VALUES ('4', 'Gender', 'Gender of performers pulled from API', '{ \"All\": \"\", \"Female\": \"f\", \"couple\": \"c\", \"Trans\": \"t\"}');
INSERT INTO `paysites_settings` (`paysite`, `name`, `description`, `options`) VALUES ('11', 'Gender', 'Gender of performers pulled from API', '{ \"All\": \"\", \"Female\": \"f\", \"Male\": \"m\", \"couple\": \"c\", \"Trans\": \"t\"}');
INSERT INTO `configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `group`, `localized`, `settings`, `record_num`) VALUES ('SE Friendly URLs', 'Search Engine Friendly URLs', 'seFriendly', '0', '{"true":1,"false":0}', '0', 'site', '0', '', NULL);
ALTER TABLE `custom_links` ADD `showInNav` INT NOT NULL AFTER `custom_text_alt`;
ALTER TABLE `custom_links` ADD `navigationAnchor` VARCHAR(255) NOT NULL AFTER `showInNav`;
ALTER TABLE `custom_links` ADD INDEX (`showInNav`, `navigationAnchor`);
INSERT INTO `template_configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `template`, `localized`, `settings`) VALUES
('Sidebar - Custom URLs', 'Enable/Disable Custom URLs in Sidebar', 'template_sidebar_custom', '1', '{"true":1,"false":0}', 1, 'default_v2', 0, ''),
('Sidebar - Custom URLs Title', '', 'template_sidebar_custom_title', 'Quick Links', '', 1, 'default_v2', 0, '');
INSERT INTO `template_configuration` (`field_name`, `field_description`, `field`, `value`, `data`, `weight`, `template`, `localized`, `settings`) VALUES
('Sidebar - Custom URLs', 'Enable/Disable Custom URLs in Sidebar', 'template_sidebar_custom', '1', '{"true":1,"false":0}', 1, 'default', 0, ''),
('Sidebar - Custom URLs Title', '', 'template_sidebar_custom_title', 'Quick Links', '', 1, 'default', 0, '');
INSERT INTO `paysites_settings` (`paysite`, `name`, `description`, `options`) VALUES ('1', 'Direct To Site', 'Toggle going direct to target site when clicking thumb, skipping the local embed/profile page.', '{"No":"0","Yes":"1"}');
INSERT INTO `paysites_settings` (`paysite`, `name`, `description`, `options`) VALUES ('2', 'Direct To Site', 'Toggle going direct to target site when clicking thumb, skipping the local embed/profile page.', '{"No":"0","Yes":"1"}');
INSERT INTO `paysites_settings` (`paysite`, `name`, `description`, `options`) VALUES ('3', 'Direct To Site', 'Toggle going direct to target site when clicking thumb, skipping the local embed/profile page.', '{"No":"0","Yes":"1"}');
INSERT INTO `paysites_settings` (`paysite`, `name`, `description`, `options`) VALUES ('4', 'Direct To Site', 'Toggle going direct to target site when clicking thumb, skipping the local embed/profile page.', '{"No":"0","Yes":"1"}');
INSERT INTO `paysites_settings` (`paysite`, `name`, `description`, `options`) VALUES ('5', 'Direct To Site', 'Toggle going direct to target site when clicking thumb, skipping the local embed/profile page.', '{"No":"0","Yes":"1"}');
INSERT INTO `paysites_settings` (`paysite`, `name`, `description`, `options`) VALUES ('7', 'Direct To Site', 'Toggle going direct to target site when clicking thumb, skipping the local embed/profile page.', '{"No":"0","Yes":"1"}');
INSERT INTO `paysites_settings` (`paysite`, `name`, `description`, `options`) VALUES ('8', 'Direct To Site', 'Toggle going direct to target site when clicking thumb, skipping the local embed/profile page.', '{"No":"0","Yes":"1"}');
INSERT INTO `paysites_settings` (`paysite`, `name`, `description`, `options`) VALUES ('10', 'Direct To Site', 'Toggle going direct to target site when clicking thumb, skipping the local embed/profile page.', '{"No":"0","Yes":"1"}');
INSERT INTO `paysites_settings` (`paysite`, `name`, `description`, `options`) VALUES ('11', 'Direct To Site', 'Toggle going direct to target site when clicking thumb, skipping the local embed/profile page.', '{"No":"0","Yes":"1"}');
INSERT INTO `paysites_settings` (`paysite`, `name`, `description`, `options`) VALUES ('12', 'Direct To Site', 'Toggle going direct to target site when clicking thumb, skipping the local embed/profile page.', '{"No":"0","Yes":"1"}');
INSERT INTO `paysites_settings` (`paysite`, `name`, `description`, `options`) VALUES ('13', 'Direct To Site', 'Toggle going direct to target site when clicking thumb, skipping the local embed/profile page.', '{"No":"0","Yes":"1"}');
UPDATE paysites SET preferred = 'iframe_embed_revshare' WHERE record_num = '3';