Код за потвърждение: Избери целия код
-- phpMyAdmin SQL Dump
-- version 4.0.10.6
-- http://www.phpmyadmin.net
--
-- Хост: localhost
-- Време на генериране: 5 дек 2014 в 15:40
-- Версия на сървъра: 5.5.34-MariaDB-cll-lve
-- Версия на PHP: 5.4.23
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 */;
--
-- БД: `bulgarok_site`
--
-- --------------------------------------------------------
--
-- Структура на таблица `banners`
--
CREATE TABLE IF NOT EXISTS `banners` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`img` text NOT NULL,
`url` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;
--
-- Схема на данните от таблица `banners`
--
INSERT INTO `banners` (`id`, `img`, `url`) VALUES
(13, 'http://prikachi.com/images/44/7644044W.png', 'http://armyplay.info/'),
(15, 'http://www.lan-bg.info/themes/banners/banner11.png', 'http://lan-bg.info/'),
(16, 'http://prikachi.com/images/868/7734868g.png', 'https://www.youtube.com/user/infamousmusictv1');
-- --------------------------------------------------------
--
-- Структура на таблица `files`
--
CREATE TABLE IF NOT EXISTS `files` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` longtext CHARACTER SET utf8 NOT NULL,
`url` longtext CHARACTER SET utf8 NOT NULL,
`size` longtext CHARACTER SET utf8 NOT NULL,
`date` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
--
-- Схема на данните от таблица `files`
--
INSERT INTO `files` (`id`, `title`, `url`, `size`, `date`) VALUES
(8, 'Auto Demo Recorder', 'http://dox.bg/files/dw?a=5334167ed3', '6,88 KB', '11.12.14 / 15:42');
-- --------------------------------------------------------
--
-- Структура на таблица `ips`
--
CREATE TABLE IF NOT EXISTS `ips` (
`id_vapros` int(12) NOT NULL,
`ip` varchar(30) NOT NULL,
`timestamp` int(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Схема на данните от таблица `ips`
--
INSERT INTO `ips` (`id_vapros`, `ip`, `timestamp`) VALUES
(3, '31.211.134.56', 0),
(3, '77.85.10.38', 0),
(3, '87.126.129.249', 0),
(3, '89.253.168.164', 0);
-- --------------------------------------------------------
--
-- Структура на таблица `lgsl`
--
CREATE TABLE IF NOT EXISTS `lgsl` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`ip` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`c_port` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`q_port` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`s_port` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`zone` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`disabled` tinyint(1) NOT NULL DEFAULT '0',
`comment` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`status` tinyint(1) NOT NULL DEFAULT '0',
`cache` text COLLATE utf8_unicode_ci NOT NULL,
`cache_time` text COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
--
-- Схема на данните от таблица `lgsl`
--
INSERT INTO `lgsl` (`id`, `type`, `ip`, `c_port`, `q_port`, `s_port`, `zone`, `disabled`, `comment`, `status`, `cache`, `cache_time`) VALUES
(1, 'halflife', '78.83.34.125', '27019', '27019', '0', '1', 0, '', 1, 'YTo1OntzOjE6ImIiO2E6Nzp7czo0OiJ0eXBlIjtzOjg6ImhhbGZsaWZlIjtzOjI6ImlwIjtzOjEyOiI3OC44My4zNC4xMjUiO3M6NjoiY19wb3J0IjtzOjU6IjI3MDE5IjtzOjY6InFfcG9ydCI7czo1OiIyNzAxOSI7czo2OiJzX3BvcnQiO3M6MToiMCI7czo2OiJzdGF0dXMiO3M6MToiMSI7czo3OiJwZW5kaW5nIjtpOjA7fXM6MToibyI7YTo1OntzOjc6InJlcXVlc3QiO3M6Mjoic3AiO3M6MjoiaWQiO3M6MToiMSI7czo0OiJ6b25lIjtzOjE6IjEiO3M6NzoiY29tbWVudCI7czowOiIiO3M6ODoibG9jYXRpb24iO3M6MDoiIjt9czoxOiJzIjthOjY6e3M6NDoiZ2FtZSI7czo3OiJjc3RyaWtlIjtzOjQ6Im5hbWUiO3M6NDM6IkJ1bGdhcmlhLVBsYXkuSU5GTyAjIERlYXRobWF0Y2ggKyBBcm15UmFua3MiO3M6MzoibWFwIjtzOjg6ImRlX2R1c3QyIjtzOjc6InBsYXllcnMiO3M6MToiMCI7czoxMDoicGxheWVyc21heCI7czoyOiIyNCI7czo4OiJwYXNzd29yZCI7czoxOiIwIjt9czoxOiJlIjthOjExMDp7czoxMToiZGVzY3JpcHRpb24iO3M6MTQ6IkNvdW50ZXItU3RyaWtlIjtzOjc6Im5ldGNvZGUiO3M6MjoiNDciO3M6OToiZGVkaWNhdGVkIjtzOjE6ImQiO3M6Mjoib3MiO3M6MToidyI7czoxMjoibW9kX3VybF9pbmZvIjtzOjA6IiI7czoxNjoibW9kX3VybF9kb3dubG9hZCI7czowOiIiO3M6MTE6Im1vZF92ZXJzaW9uIjtzOjE6IjEiO3M6ODoibW9kX3NpemUiO3M6MToiMCI7czoxNToibW9kX3NlcnZlcl9zaWRlIjtzOjE6IjEiO3M6MTQ6Im1vZF9jdXN0b21fZGxsIjtzOjE6IjAiO3M6OToiYW50aWNoZWF0IjtzOjE6IjAiO3M6NDoiYm90cyI7czoxOiIwIjtzOjM1OiJfdHV0b3JfYm9tYl92aWV3YWJsZV9jaGVja19pbnRlcnZhbCI7czozOiIwLjUiO3M6MTg6Il90dXRvcl9kZWJ1Z19sZXZlbCI7czoxOiIwIjtzOjE5OiJfdHV0b3JfZXhhbWluZV90aW1lIjtzOjM6IjAuNSI7czoyNToiX3R1dG9yX2hpbnRfaW50ZXJ2YWxfdGltZSI7czo0OiIxMC4wIjtzOjE3OiJfdHV0b3JfbG9va19hbmdsZSI7czoyOiIxMCI7czoyMDoiX3R1dG9yX2xvb2tfZGlzdGFuY2UiO3M6MzoiMjAwIjtzOjQ5OiJfdHV0b3JfbWVzc2FnZV9jaGFyYWN0ZXJfZGlzcGxheV90aW1lX2NvZWZmaWNpZW50IjtzOjQ6IjAuMDciO3M6MzU6Il90dXRvcl9tZXNzYWdlX21pbmltdW1fZGlzcGxheV90aW1lIjtzOjE6IjEiO3M6MjI6Il90dXRvcl9tZXNzYWdlX3JlcGVhdHMiO3M6MToiNSI7czoyMDoiX3R1dG9yX3ZpZXdfZGlzdGFuY2UiO3M6NDoiMTAwMCI7czoxMjoiYWVzcF92ZXJzaW9uIjtzOjM6IjEuMyI7czoxNjoiYWxsb3dfc3BlY3RhdG9ycyI7czozOiIxLjAiO3M6MjA6ImFteF9jbGllbnRfbGFuZ3VhZ2VzIjtzOjE6IjEiO3M6MTI6ImFteF90aW1lbGVmdCI7czo1OiIwMDowMCI7czoxNToiYW14bW9keF92ZXJzaW9uIjtzOjEwOiIxLjguMS4zNzQ2IjtzOjE4OiJhbnRpZGxmaWxlX3ZlcnNpb24iO3M6MzoiMS40IjtzOjEwOiJhcm15X3JhbmtzIjtzOjg6IjEuMmZpeC0zIjtzOjIwOiJib29zdGVyX2xpdGVfdmVyc2lvbiI7czo0OiIxLjEzIjtzOjQ6ImNvb3AiO3M6MToiMCI7czoxMToiY3NkbV9hY3RpdmUiO3M6MToiMSI7czoxMjoiY3NkbV92ZXJzaW9uIjtzOjU6IjIuMS4yIjtzOjE0OiJjc2ZfYWNfdmVyc2lvbiI7czoxMDoiMS4yMyBGaXggMyI7czoxMDoiZGVhdGhtYXRjaCI7czoxOiIxIjtzOjE0OiJkZWNhbGZyZXF1ZW5jeSI7czoyOiIzMCI7czoxMDoiZHBfdmVyc2lvbiI7czo3OiIwLjkuMTg3IjtzOjEyOiJlZGdlZnJpY3Rpb24iO3M6MToiMiI7czoxMzoiaG9zdGFnZV9kZWJ1ZyI7czoxOiIwIjtzOjEyOiJob3N0YWdlX3N0b3AiO3M6MToiMCI7czoxMToiaHNkX3ZlcnNpb24iO3M6ODoiWC4xNi4xLjAiO3M6MTY6Imh1bWFuc19qb2luX3RlYW0iO3M6MzoiYW55IjtzOjE1OiJtYXhfcXVlcmllc19zZWMiO3M6MToiMSI7czoyMjoibWF4X3F1ZXJpZXNfc2VjX2dsb2JhbCI7czoxOiIxIjtzOjE4OiJtYXhfcXVlcmllc193aW5kb3ciO3M6MToiMSI7czoxNToibWV0YW1vZF92ZXJzaW9uIjtzOjc6IjEuMjBwMzYiO3M6MTY6Im1wX2FsbG93bW9uc3RlcnMiO3M6MToiMCI7czoxMToibXBfYXV0b2tpY2siO3M6MToiMSI7czoxODoibXBfYXV0b3RlYW1iYWxhbmNlIjtzOjE6IjEiO3M6MTA6Im1wX2J1eXRpbWUiO3M6NDoiMC4zMCI7czoxMDoibXBfYzR0aW1lciI7czoyOiIzNSI7czoxMToibXBfY2hhdHRpbWUiO3M6MjoiMTAiO3M6MTQ6Im1wX2NvbnNpc3RlbmN5IjtzOjE6IjEiO3M6MTQ6Im1wX2ZhZGV0b2JsYWNrIjtzOjE6IjAiO3M6MTM6Im1wX2ZsYXNobGlnaHQiO3M6MToiMCI7czoxMjoibXBfZm9vdHN0ZXBzIjtzOjE6IjEiO3M6MTQ6Im1wX2ZvcmNlY2FtZXJhIjtzOjE6IjAiO3M6MTY6Im1wX2ZvcmNlY2hhc2VjYW0iO3M6MToiMCI7czoxMjoibXBfZnJhZ3NsZWZ0IjtzOjE6IjAiO3M6MTM6Im1wX2ZyZWVmb3JhbGwiO3M6MToiMCI7czoxMzoibXBfZnJlZXpldGltZSI7czoxOiIwIjtzOjE1OiJtcF9mcmllbmRseWZpcmUiO3M6MToiMCI7czoxNzoibXBfZ2hvc3RmcmVxdWVuY3kiO3M6MzoiMC4xIjtzOjE3OiJtcF9ob3N0YWdlcGVuYWx0eSI7czoyOiIxMyI7czoxNDoibXBfa2lja3BlcmNlbnQiO3M6NDoiMC42NiI7czoxMzoibXBfbGltaXR0ZWFtcyI7czoxOiIyIjtzOjEyOiJtcF9sb2dkZXRhaWwiO3M6MToiMCI7czoxMDoibXBfbG9nZmlsZSI7czoxOiIxIjtzOjE0OiJtcF9sb2dtZXNzYWdlcyI7czoxOiIxIjtzOjE1OiJtcF9tYXB2b3RlcmF0aW8iO3M6NDoiMC42NiI7czoxMjoibXBfbWF4cm91bmRzIjtzOjE6IjAiO3M6MTU6Im1wX21pcnJvcmRhbWFnZSI7czoxOiIwIjtzOjExOiJtcF9wbGF5ZXJpZCI7czoxOiIwIjtzOjEyOiJtcF9yb3VuZHRpbWUiO3M6NDoiMS40NSI7czoxMzoibXBfc3RhcnRtb25leSI7czozOiI4MDAiO3M6MTE6Im1wX3RpbWVsZWZ0IjtzOjE6IjAiO3M6MTI6Im1wX3RpbWVsaW1pdCI7czoyOiIzMCI7czoxMToibXBfdGtwdW5pc2giO3M6MToiMCI7czoxNjoibXBfd2luZGlmZmVyZW5jZSI7czoxOiIxIjtzOjExOiJtcF93aW5saW1pdCI7czoxOiIwIjtzOjg6InBhdXNhYmxlIjtzOjE6IjAiO3M6MTI6InNwYW1fYmxvY2tlciI7czozOiIxLjIiO3M6MTM6InN2X2FjY2VsZXJhdGUiO3M6MToiNSI7czo2OiJzdl9haW0iO3M6MToiMCI7czoxNjoic3ZfYWlyYWNjZWxlcmF0ZSI7czoyOiIxMCI7czoxMDoic3ZfYWlybW92ZSI7czoxOiIxIjtzOjE0OiJzdl9hbGxvd3VwbG9hZCI7czoxOiIxIjtzOjEwOiJzdl9hbGx0YWxrIjtzOjE6IjAiO3M6OToic3ZfYm91bmNlIjtzOjE6IjEiO3M6OToic3ZfY2hlYXRzIjtzOjE6IjAiO3M6MTQ6InN2X2NsaWVudHRyYWNlIjtzOjE6IjEiO3M6MTE6InN2X2NsaXBtb2RlIjtzOjE6IjAiO3M6MTA6InN2X2NvbnRhY3QiO3M6MDoiIjtzOjExOiJzdl9mcmljdGlvbiI7czoxOiI0IjtzOjEwOiJzdl9ncmF2aXR5IjtzOjM6IjgwMCI7czoxMjoic3ZfbG9nYmxvY2tzIjtzOjE6IjAiO3M6MTA6InN2X21heHJhdGUiO3M6MToiMCI7czoxMToic3ZfbWF4c3BlZWQiO3M6MzoiOTAwIjtzOjEwOiJzdl9taW5yYXRlIjtzOjE6IjAiO3M6MTE6InN2X3Bhc3N3b3JkIjtzOjE6IjAiO3M6MTA6InN2X3Byb3hpZXMiO3M6MToiMSI7czo5OiJzdl9yZWdpb24iO3M6MzoiMjU1IjtzOjEwOiJzdl9yZXN0YXJ0IjtzOjE6IjAiO3M6MTU6InN2X3Jlc3RhcnRyb3VuZCI7czoxOiIwIjtzOjExOiJzdl9zdGVwc2l6ZSI7czoyOiIxOCI7czoxMjoic3Zfc3RvcHNwZWVkIjtzOjI6Ijc1IjtzOjEyOiJzdl91cGxvYWRtYXgiO3M6MzoiMC41IjtzOjE0OiJzdl92b2ljZWVuYWJsZSI7czoxOiIxIjtzOjE4OiJzdl93YXRlcmFjY2VsZXJhdGUiO3M6MjoiMTAiO3M6MTY6InN2X3dhdGVyZnJpY3Rpb24iO3M6MToiMSI7fXM6MToicCI7YTowOnt9fQ==', '1417786760_1417786404_1417786760');
-- --------------------------------------------------------
--
-- Структура на таблица `news`
--
CREATE TABLE IF NOT EXISTS `news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` longtext CHARACTER SET utf8 NOT NULL,
`new` longtext CHARACTER SET utf8 NOT NULL,
`author` longtext CHARACTER SET utf8 NOT NULL,
`date` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
--
-- Схема на данните от таблица `news`
--
INSERT INTO `news` (`id`, `title`, `new`, `author`, `date`) VALUES
(8, 'BULGARIA-PLAY.INFO', 'Здравейте, днес Bulgaria-Play отвори врати официално. Сайта е готов , както и сървърите. Засега имаме само 6 сървъра,но много скоро очаквайте и още. Стремим се да предлагаме на нашите потребители добра игра, без нарушители и качествени админи. Пожелаваме Ви приятна игра при нас. :)\r\n \r\n ', 'Т.Иванов', '10.05.14 / 13:43'),
(9, 'Развитие', 'Ако искате да помогнете B-P да се развие по-бързо, може да изпратите смс на номер 1092 с текст csrek. Струва 2.40 с ДДС. След това ще получите обратен смс със код, който трябва да го изпратите на skype: aloneblackwolf\r\nВсеки помогнал, може да получи права в някой от нашите сървъри или смяна на никнейм/ранк във форума.', 'Т.Иванов', '11.04.14 / 18:49');
-- --------------------------------------------------------
--
-- Структура на таблица `otgovori`
--
CREATE TABLE IF NOT EXISTS `otgovori` (
`id` int(12) NOT NULL AUTO_INCREMENT,
`id_vapros` int(12) NOT NULL,
`otgovor` varchar(255) CHARACTER SET utf8 NOT NULL,
`broi` int(5) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
--
-- Схема на данните от таблица `otgovori`
--
INSERT INTO `otgovori` (`id`, `id_vapros`, `otgovor`, `broi`) VALUES
(5, 3, 'Да', 3),
(6, 3, 'Не', 1);
-- --------------------------------------------------------
--
-- Структура на таблица `sitebanners`
--
CREATE TABLE IF NOT EXISTS `sitebanners` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`img` longtext CHARACTER SET utf8 NOT NULL,
`url` longtext CHARACTER SET utf8 NOT NULL,
`size` longtext CHARACTER SET utf8 NOT NULL,
`author` longtext CHARACTER SET utf8 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;
--
-- Схема на данните от таблица `sitebanners`
--
INSERT INTO `sitebanners` (`id`, `img`, `url`, `size`, `author`) VALUES
(16, 'http://prikachi.com/images/898/7628898s.png', 'http://bulgaria-play.info/', '468x60', ''),
(17, 'http://prikachi.com/images/102/7704102o.png', 'http://bulgaria-play.info', '', ''),
(18, 'http://prikachi.com/images/357/7715357p.png', 'http://bulgaria-play.info', '', ''),
(19, 'http://prikachi.com/images/695/7716695j.gif', 'http://bulgaria-play.info/', '', '');
-- --------------------------------------------------------
--
-- Структура на таблица `team`
--
CREATE TABLE IF NOT EXISTS `team` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` longtext CHARACTER SET utf8 NOT NULL,
`post` longtext CHARACTER SET utf8 NOT NULL,
`skype` longtext CHARACTER SET utf8 NOT NULL,
`nick` longtext CHARACTER SET utf8 NOT NULL,
`date` longtext CHARACTER SET utf8 NOT NULL,
`img` longtext CHARACTER SET utf8 NOT NULL,
`city` longtext CHARACTER SET utf8 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
-- --------------------------------------------------------
--
-- Структура на таблица `vaprosi`
--
CREATE TABLE IF NOT EXISTS `vaprosi` (
`id` int(12) NOT NULL AUTO_INCREMENT,
`vapros` varchar(255) CHARACTER SET utf8 NOT NULL,
`br_otgovori` int(5) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Схема на данните от таблица `vaprosi`
--
INSERT INTO `vaprosi` (`id`, `vapros`, `br_otgovori`) VALUES
(3, 'Харесват ли ви сървърите?', 4);
/*!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 */;
