copy admin_ban_log.php /admin/
copy admin_warning.php /admin/
copy admin_ban_log.tpl /templates/admin/
copy admin_warning.tpl /templates/admin/
copy warning.php to /
copy warning_tr.php to /
copy warning.tpl to /templates/default/
copy warning_tr.tpl to /templates/default/
copy add_warning.php to /includes/cron/job/
copy warning_update.php to /includes/cron/job/
copy warn/* to /images/warn/
copy calendar/* to /misc/calendar/
copy date.png to /images/

CREATE TABLE IF NOT EXISTS `bb_users_warn` (
  `warn_id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL,
  `warn_vidal` int(11) NOT NULL,
  `warn_type` tinyint(2) NOT NULL,
  `warn_theme` varchar(255) character set utf8 NOT NULL,
  `warn_bbcode_uid` varchar(10) NOT NULL,
  `warn_text` text character set utf8,
  `warn_exp_time` int(11) NOT NULL default '0',
  `warn_time` int(11) NOT NULL default '0',
  `warn_activ` tinyint(1) NOT NULL default '1',
  `warn_post` int(15) NOT NULL default '0',
  PRIMARY KEY  (`warn_id`),
  KEY `warn_post` (`warn_post`),
  KEY `uw` (`user_id`,`warn_activ`)
); ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=cp1251;

ALTER TABLE bb_users ADD  `user_mod_denny` smallint(1) NOT NULL default '0';
ALTER TABLE bb_users ADD  `user_warnings_id` varchar(255) NOT NULL default '0';
ALTER TABLE bb_users ADD  `ban_time` int(11) NOT NULL default '0';
ALTER TABLE bb_users ADD  `user_warnings` tinyint(3) NOT NULL default '0';
ALTER TABLE bb_users ADD  `user_sigban` tinyint(1) not null default 0;

INSERT INTO `bb_cron` (`cron_id`, `cron_active`, `cron_title`, `cron_script`, `schedule`, `run_day`, `run_time`, `run_order`, `last_run`, `next_run`, `run_interval`, `log_enabled`, `log_file`, `log_sql_queries`, `disable_board`, `run_counter`) VALUES
(NULL, 1, 'Раздача количества предов', 'add_warning.php', 'interval', '', '00:00:00', 22, '0', '0', '01:00:00', 0, '', 0, 0, 0),
(NULL, 1, 'Снятие предупреждений', 'warning_update.php', 'interval', '', '00:00:00', 22, '0', '0', '01:00:00', 0, '', 0, 0, 0);