Държа да подчертая, че потребител, чиито никнейм не знам, но скайпа му е alex123santa е препродал системата за 17 лева на друг потребител, чието име няма да споменавам. Ако модераторите решат могат да го добавят към черния списък.
ENJOY
Система: sHoRt
Автор на дизайна: mastatekilla
Изработен за: http://www.bulletplay.net
Подчертавам, че това е една от системите на sHoRT. Извършени са редакции от мен. Дизайна е изцяло променен, заедно с дизайна на Админ панела. Добавил съм Контактна форма, чрез която можете да четете съобщенията директно от Администраторския панел. Дизайна на LGSL-то също е мое дело.
За да функционира системата, трябва да имате инсталиран phpbb3 форум в директория /forum
Снимки на системата: Снимка 1, Снимка 2, Снимка 3, Админ панел 1, Админ панел 2
Файлове за редакция:
config.php
admin/config.php
admin/.htaccess (въведете вашият IP адрес, за да имате достъп до админ панела)
lgsl/lgsl_files/lgsl_config.php
SQL
Code: Select all
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=12 ;
CREATE TABLE IF NOT EXISTS `contact` (
`id` int(32) NOT NULL AUTO_INCREMENT,
`ime` varchar(150) NOT NULL,
`skype` varchar(150) NOT NULL,
`tema` text NOT NULL,
`message` text NOT NULL,
`date` text NOT NULL,
`ip` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=35 ;
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=5 ;
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
(2, '176.12.52.151', 0);
CREATE TABLE IF NOT EXISTS `menuright` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` longtext CHARACTER SET utf8 NOT NULL,
`txt` longtext CHARACTER SET utf8 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
--
-- Схема на данните от таблица `menuright`
--
INSERT INTO `menuright` (`id`, `title`, `txt`) VALUES
(3, 'Примерно меню', 'Това е примерно меню. Добавя се от Админ панела.');
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=16 ;
--
-- Схема на данните от таблица `news`
--
INSERT INTO `news` (`id`, `title`, `new`, `author`, `date`) VALUES
(9, 'Нова визия', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\\''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged.', 'mastatekilla', '10.06.14 / 19:53'),
(10, 'Примерна новина', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\\''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged.', 'дсасад', '10.07.14 / 00:33'),
(11, 'Примерна новина #2', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\\''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged.', 'mastatekilla', '10.09.14 / 02:13'),
(12, 'Примерна новина #3', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\\''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged.', 'mastatekilla', '10.09.14 / 02:13'),
(13, 'Примерна новина #4', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\\''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged.', 'mastatekilla', '10.09.14 / 02:13'),
(14, 'Примерна новина #5', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\\''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged.', 'mastatekilla', '10.09.14 / 02:14'),
(15, 'Примерна новина #6', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\\''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged.', 'mastatekilla', '10.09.14 / 02:14');
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=8 ;
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=19 ;
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=5 ;
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 ;
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=6 ;