 |
.\aplication\messages\passErrors.php
|
|
|
|
.. \aplication\messages\passErrors. php
<? // тест документ, не используется!
return array ('password'=> array(
'not_empty'=> 'Пароль не должен быть пустым. ',
'min_length'=> 'Пароль должен содержать не менее 7 символов. ',
'max_length'=> 'Пароль должен содержать не более 16 символов. ',
'regex'=> 'Можно использовать только английские и целочисленные символы верхнего и нижнего регистров. Без специальных сиволов. ', ), );
.. \aplication\messages\validation\myuser. php
<? return array ('username'=> array(
'not_empty'=> 'Вы не заполнили поле Email. ',
'email'=> 'Это не Email. ',
'username_unique'=> 'Данный Email уже зарегистрирован. ', ), );
.. \aplication\messages\validation\regcode. php
<? return array ( 'code'=> array(
'not_empty'=> 'Поле регистрационного кода не должно быть пустым. ',
'bad_code'=> 'Код используется другим пользователем или не существует. ', ), );
.. \aplication\messages\emailthemes\register. php
<? php defined('SYSPATH') or die('No direct script access. '); return array(
'subject' => 'Подтверждение регистрации', );
.. \aplication\messages\emailthemes\rememberpassword. php
<? php defined('SYSPATH') or die('No direct script access. '); return array(
'subject' => 'Восстановление пароля', );
.. \aplication\messages\emailthemes\rememberpasswordcomplete. php
<? php defined('SYSPATH') or die('No direct script access. '); return array(
'subject' => 'Ваш новый пароль', );
SQL dump базы данных “kgksite”
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `materials`
-- ----------------------------
DROP TABLE IF EXISTS `materials`;
CREATE TABLE `materials` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`category_id` int(10) unsigned NOT NULL,
`content` text NOT NULL,
`createtime` int(10) DEFAULT NULL,
`modtime` int(10) DEFAULT NULL,
`name` varchar(25) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `category_id` (`category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of materials
-- ----------------------------
INSERT INTO `materials` VALUES ('1', '5', '< p> \r\n Вы можете свзяаться со мной по адресу: < /p> \r\n< p> \r\n < a href=\" mailto: skutorlike@mail. ru? subject=%D0%A1%D0%BE%D0%BE%D0%B1%D1%89%D0%B5%D0%BD%D0%B8%D0%B5%20%D1%81%20%D0%B2%D0%B0%D1%88%D0%B5%D0%B3%D0%BE%20%D0%BF%D1%80%D0%BE%D0%B5%D0%BA%D1%82%D0%B0%20Kohana\" > skutorlike@mail. ru< /a> < /p> \r\n', '1329132907', null, 'Email');
|
|
|
INSERT INTO `materials` VALUES ('7', '4', '< p> \r\n Какая-то информация< /p> \r\n', '1336382841', null, 'Материал1');
INSERT INTO `materials` VALUES ('8', '4', '< p> \n < strong> Некая информация к Материалу № 2. < /strong> < /p> \n', '1337088918', '1338127500', 'sdfsdfsdf');
INSERT INTO `materials` VALUES ('9', '4', '< p> \n information, many many information =)< /p> \n', '1337088918', '1338127561', 'playgamer');
INSERT INTO `materials` VALUES ('11', '5', '< p> \r\n text for example< /p> \r\n', '1338381423', null, 'example2');
-- ----------------------------
-- Table structure for `regcodes`
-- ----------------------------
DROP TABLE IF EXISTS `regcodes`;
CREATE TABLE `regcodes` (
`id` int(7) NOT NULL AUTO_INCREMENT,
`code` varchar(32) NOT NULL,
`user_id` int(7) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of regcodes
-- ----------------------------
INSERT INTO `regcodes` VALUES ('1', '111', '1');
INSERT INTO `regcodes` VALUES ('2', '222', '2');
INSERT INTO `regcodes` VALUES ('3', '333', '2');
INSERT INTO `regcodes` VALUES ('4', '787', '9');
INSERT INTO `regcodes` VALUES ('5', '121', '3');
-- ----------------------------
-- Table structure for `roles`
-- ----------------------------
DROP TABLE IF EXISTS `roles`;
CREATE TABLE `roles` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(32) NOT NULL,
`description` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `uniq_name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of roles
-- ----------------------------
INSERT INTO `roles` VALUES ('1', 'login', 'Login privileges, granted after account confirmation');
INSERT INTO `roles` VALUES ('2', 'admin', 'Administrative user, has access to everything. ');
-- ----------------------------
-- Table structure for `roles_users`
-- ----------------------------
DROP TABLE IF EXISTS `roles_users`;
CREATE TABLE `roles_users` (
`user_id` int(11) unsigned NOT NULL,
`role_id` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of roles_users
-- ----------------------------
INSERT INTO `roles_users` VALUES ('1', '1');
INSERT INTO `roles_users` VALUES ('1', '2');
INSERT INTO `roles_users` VALUES ('2', '1');
INSERT INTO `roles_users` VALUES ('3', '1');
-- ----------------------------
-- Table structure for `tags`
-- ----------------------------
DROP TABLE IF EXISTS `tags`;
CREATE TABLE `tags` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`url` varchar(100) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
|
|
|
-- ----------------------------
-- Records of tags
-- ----------------------------
INSERT INTO `tags` VALUES ('1', 'email', 'http: //localhost/materials/showcontent/59');
INSERT INTO `tags` VALUES ('2', 'author', 'http: //localhost/materials/showcontent/60');
INSERT INTO `tags` VALUES ('3', 'contact', 'http: //localhost/materials/showcontent/61');
INSERT INTO `tags` VALUES ('7', 'deletematerials', 'http: //localhost/materials/showcontent/7');
INSERT INTO `tags` VALUES ('8', 'info', 'http: //localhost/materials/showcontent/8');
INSERT INTO `tags` VALUES ('9', 'material2', 'http: //localhost/materials/showcontent/9');
INSERT INTO `tags` VALUES ('10', 'mat2', 'http: //localhost/materials/showcontent/10');
INSERT INTO `tags` VALUES ('11', 'zero', 'http: //localhost/materials/showcontent/11');
INSERT INTO `tags` VALUES ('12', 'example', 'http: //localhost/materials/showcontent/12');
INSERT INTO `tags` VALUES ('13', 'foryou', 'http: //localhost/materials/showcontent/13');
INSERT INTO `tags` VALUES ('14', 'test', 'http: //localhost/materials/showcontent/14');
INSERT INTO `tags` VALUES ('15', 'second', 'http: //localhost/materials/showcontent/15');
-- ----------------------------
-- Table structure for `tags_materials`
-- ----------------------------
DROP TABLE IF EXISTS `tags_materials`;
CREATE TABLE `tags_materials` (
`tag_id` int(10) NOT NULL,
`material_id` int(10) NOT NULL,
KEY `FK_tags_materials_tags` (`tag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tags_materials
-- ----------------------------
INSERT INTO `tags_materials` VALUES ('1', '1');
INSERT INTO `tags_materials` VALUES ('2', '1');
INSERT INTO `tags_materials` VALUES ('3', '1');
INSERT INTO `tags_materials` VALUES ('1', '2');
INSERT INTO `tags_materials` VALUES ('7', '3');
INSERT INTO `tags_materials` VALUES ('8', '7');
INSERT INTO `tags_materials` VALUES ('9', '8');
INSERT INTO `tags_materials` VALUES ('10', '8');
INSERT INTO `tags_materials` VALUES ('11', '9');
INSERT INTO `tags_materials` VALUES ('12', '10');
INSERT INTO `tags_materials` VALUES ('13', '10');
INSERT INTO `tags_materials` VALUES ('14', '11');
INSERT INTO `tags_materials` VALUES ('15', '12');
-- ----------------------------
-- Table structure for `tree`
-- ----------------------------
DROP TABLE IF EXISTS `tree`;
CREATE TABLE `tree` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(250) NOT NULL,
`nametrans` varchar(250) NOT NULL,
`left_key` int(10) NOT NULL,
`right_key` int(10) NOT NULL,
`level` int(10) NOT NULL,
PRIMARY KEY (`id`, `nametrans`),
UNIQUE KEY `url` (`nametrans`) USING BTREE,
KEY `key` (`left_key`, `right_key`, `level`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tree
-- ----------------------------
INSERT INTO `tree` VALUES ('1', 'Главная', 'main', '1', '34', '0');
INSERT INTO `tree` VALUES ('3', 'Дизайн', 'Dizayn', '18', '19', '1');
INSERT INTO `tree` VALUES ('4', 'Движок', 'Dvijok', '20', '23', '1');
INSERT INTO `tree` VALUES ('5', 'Контакты', 'Kontaktyi', '24', '25', '1');
-- ----------------------------
-- Table structure for `users`
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`email` varchar(40) NOT NULL,
`username` varchar(40) NOT NULL,
`password` varchar(64) NOT NULL,
`logins` int(10) unsigned NOT NULL DEFAULT '0',
`last_login` int(10) unsigned DEFAULT NULL,
`rempass` varchar(70) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `uniq_username` (`username`),
UNIQUE KEY `uniq_email` (`email`),
UNIQUE KEY `id` (`id`)
|
|
|
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES ('1', 'skutorlike@mail. ru', 'skutorlike@mail. ru', '56878f874f984e7030652aa0d61550b9d28bec2fe256161c0e56bfd61de7794b', '112', '1338720949', null);
INSERT INTO `users` VALUES ('2', 'zoikazaripova@mail. ru', 'zoikazaripova@mail. ru', '56878f874f984e7030652aa0d61550b9d28bec2fe256161c0e56bfd61de7794b', '0', null, null);
INSERT INTO `users` VALUES ('3', 'winist@yandex. ru', 'winist@yandex. ru', '56878f874f984e7030652aa0d61550b9d28bec2fe256161c0e56bfd61de7794b', '2', '1338151839', null);
-- ----------------------------
-- Table structure for `user_tokens`
-- ----------------------------
DROP TABLE IF EXISTS `user_tokens`;
CREATE TABLE `user_tokens` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) unsigned NOT NULL,
`user_agent` varchar(40) NOT NULL,
`token` varchar(40) NOT NULL,
`type` varchar(100) NOT NULL,
`created` int(10) unsigned NOT NULL,
`expires` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `uniq_token` (`token`),
KEY `fk_user_id` (`user_id`),
CONSTRAINT `user_tokens_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of user_tokens
-- ----------------------------
Конфигурационные файлы
Конфигурационные файлы модулей и машрутов Kohana, Apache, PHP, MySQL не включены. Их можно на информационном носителе прилагаемом к диклому.
|
|
|
