INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES
('config_id', '1'),
('board_disable', '0'),
('sitename', 'apwa.ru'),
('site_desc', 'Жизнь как она есть'),
('cookie_name', 'phpbb2mysql'),
('cookie_path', '/'),
('cookie_domain', ''),
('cookie_secure', '0'),
('session_length', '600'),
('allow_html', '0'),
('allow_html_tags', ''),
('allow_bbcode', '1'),
('allow_smilies', '1'),
('allow_sig', '1'),
('allow_namechange', '0'),
('allow_theme_create', '0'),
('allow_avatar_local', '1'),
('allow_avatar_remote', '1'),
('allow_avatar_upload', '0'),
('enable_confirm', '1'),
('allow_autologin', '1'),
('max_autologin_time', '1'),
('override_user_style', '0'),
('posts_per_page', '10'),
('topics_per_page', '10'),
('hot_threshold', '10'),
('max_poll_options', '12'),
('max_sig_chars', '255'),
('max_inbox_privmsgs', '150'),
('max_sentbox_privmsgs', '150'),
('max_savebox_privmsgs', '100'),
('board_email_sig', ''),
('board_email', '[email protected]'),
('smtp_delivery', '0'),
('smtp_host', ''),
('smtp_username', ''),
('smtp_password', ''),
('sendmail_fix', '1'),
('require_activation', '0'),
('flood_interval', '15'),
('search_flood_interval', '15'),
('search_min_chars', '3'),
('max_login_attempts', '5'),
('login_reset_time', '30'),
('board_email_phpbbm', '1'),
('avatar_filesize', '0'),
('avatar_max_width', '140'),
('avatar_max_height', '140'),
('avatar_path', 'images/avatars'),
('avatar_gallery_path', 'images/avatars/gallery'),
('smilies_path', 'images/smiles'),
('default_style', '73'),
('default_datephpbbmat', 'j.m.y, H:i'),
('board_timezone', '6'),
('prune_enable', '1'),
('privmsg_disable', '0'),
('gzip_compress', '1'),
('coppa_fax', ''),
('coppa_mail', ''),
('record_online_users', '95'),
('record_online_date', '1324812393'),
('server_name', 'apwa.ru'),
('server_port', '80'),
('script_path', '/'),
('version', '2.0.23'),
('rand_seed', '2435ffd4089936d52df87a8ceba12391'),
('warnings_enabled', '1'),
('reputation_enabled', '1'),
('reports_enabled', '0'),
('reputation_least_respected', '0'),
('reputation_ban_warnings', '3'),
('reputation_delete_expired', '-1'),
('reputation_warning_expire', '1,10'),
('reputation_ban_expire', '1,100'),
('reputation_perms', '0,0,1,1,3,3,3,5,3,5,3,3,3'),
('reputation_none', '0,0'),
('reputation_mod_norep', '0'),
('reputation_reviews_per_page', '25'),
('reputation_reports_per_page', '25'),
('reputation_display', '1'),
('reputation_most_respected', '0'),
('reputation_days_req', '5'),
('reputation_posts_req', '100'),
('reputation_points_req', '-100000'),
('reputation_warnings_req', '100000'),
('reputation_rotation_limit', '0'),
('reputation_time_limit', '720'),
('reputation_check_rate', '300'),
('reputation_last_check_time', '1379771374'),
('reputation_empty_reviews', '0'),
('reputation_positive_only', '0'),
('reputation_check_reports', '1'),
('reputation_reports_color', ''),
('reputation_admin_norep', '1'),
('online_time', '1800'),
('max_user_topics_per_page', '50'),
('max_user_posts_per_page', '50'),
('birthday_required', '0'),
('birthday_greeting', '1'),
('max_user_age', '100'),
('min_user_age', '10'),
('birthday_check_day', '1'),
('index_announcement', ''),
('index_spisok', '1'),
('send_user_icq', '0'),
('default_icq', ''),
('default_icq_pass', ''),
('flood_icq_interval', '60'),
('last_check_icq_time', '0'),
('limit_privmsg_enable', '1'),
('limit_privmsg_number', '3'),
('join_interval', '0'),
('allow_guests_gb', '0'),
('gb_posts', '5'),
('gb_quick', '1');
# -- Categories
INSERT INTO phpbb_categories (cat_id, cat_title, cat_order) VALUES (1, 'Тестовая категория', 10);
# -- Forums
INSERT INTO phpbb_forums (forum_id, forum_name, forum_desc, cat_id, forum_order, forum_posts, forum_topics, forum_last_post_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_announce, auth_sticky, auth_pollcreate, auth_vote, auth_attachments) VALUES (1, 'Тестовый форум', 'Ля-Ля', 1, 10, 1, 1, 1, 0, 0, 1, 1, 1, 1, 3, 3, 1, 1, 1);
# -- Users
INSERT INTO phpbb_users (user_id, username, user_level, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_viewemail, user_aim, user_yim, user_msnm, user_posts, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_pm, user_notify_pm, user_allow_viewonline, user_rank, user_avatar, user_lang, user_timezone, user_actkey, user_newpasswd, user_notify, user_active) VALUES ( -1, 'Anonymous', 0, 0, '', '', '', '', '', '', '', '', 0, '', '', '', 0, 0, 1, 1, 1, 0, 1, 1, NULL, '', '', 0, '', '', 0, 0);
# -- username: admin password: admin (change this or remove it once everything is working!)
INSERT INTO phpbb_users (user_id, username, user_level, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_viewemail, user_aim, user_yim, user_msnm, user_posts, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_pm, user_notify_pm, user_popup_pm, user_allow_viewonline, user_rank, user_avatar, user_lang, user_timezone, user_actkey, user_newpasswd, user_notify, user_active) VALUES ( 2, 'admin', 1, 0, '202cb962ac59075b964b07152d234b70', '[email protected]', '', '', '', '', '', '', 1, '', '', '', 1, 0, 1, 0, 1, 1, 1, 1, 1, 1, '', 'russian', 0, '', '', 0, 1);
# -- Ranks
INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_special, rank_image) VALUES (1, 'Админ форума', -1, 1, NULL);
INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_special, rank_image) VALUES (2, 'Юзер', 0, 0, NULL);
# -- Groups
INSERT INTO phpbb_groups (group_id, group_name, group_description, group_single_user) VALUES (1, 'Anonymous', 'Personal User', 1);
INSERT INTO phpbb_groups (group_id, group_name, group_description, group_single_user) VALUES (2, 'Admin', 'Personal User', 1);
# -- User -> Group
INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (1, -1, 0);
INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (2, 2, 0);
# -- Demo Topic
INSERT INTO phpbb_topics (topic_id, topic_title, topic_poster, topic_time, topic_views, topic_replies, forum_id, topic_status, topic_type, topic_vote, topic_first_post_id, topic_last_post_id) VALUES (1, 'Вас приветствует CMS APWA.Ru!', 2, '972086460', 0, 0, 1, 0, 0, 0, 1, 1);
# -- Demo Post
INSERT INTO phpbb_posts (post_id, topic_id, forum_id, poster_id, post_time, post_username, poster_ip) VALUES (1, 1, 1, 2, 972086460, NULL, '7F000001');
INSERT INTO phpbb_posts_text (post_id, post_subject, post_text) VALUES (1, NULL, 'Привет! Если ты читаешь это сообщение, значит CMS APWA.Ru успешно установился! УРААА');
INSERT INTO `phpbb_blog_actions` (`action_id`, `action_text`, `action_url`) VALUES
(1, 'Чай пью', 'action_eat.png'),
(2, 'Слушаю', 'action_listen.png'),
(3, 'Играю', 'action_play.png'),
(4, 'Общаюсь', 'action_read.png'),
(5, 'Смотрю', 'action_watch.png'),
(6, 'Читаю', 'action_work.png'),
(7, 'Играю', 'action_game.png'),
(8, 'Выпиваю', 'action_party.png'),
(9, 'Покупаю', 'action_shop.png');
INSERT INTO `phpbb_blog_categories` (`blog_cat_id`, `blog_cat_title`, `blog_cat_order`, `blog_cat_entry`, `blog_cat_comment`) VALUES
(1, 'Заметки', 10, 0, 0),
(2, 'Личное', 20, 0, 0),
(3, 'Интернет', 30, 0, 0),
(4, 'Про жизнь', 40, 0, 0),
(5, 'Путешествия', 50, 0, 0),
(6, 'Реклама', 60, 0, 0),
(7, 'Увлечения', 70, 0, 0),
(8, 'Прочие', 80, 0, 0);
INSERT INTO `phpbb_blog_config` (`config_name`, `config_value`) VALUES
('enable_mod', '1'),
('no_avatars_index', '0'),
('default_name', 'Дневник %s'),
('default_desc', 'Мой дневничёк !'),
('main_sorttype', '0'),
('main_sortorder', 'desc'),
('main_blogsperpage', '4'),
('censor_weblog', '0'),
('default_auth', '0'),
('default_reply_auth', '1'),
('require_auth', '0'),
('index_list_by_username', '0'),
('shoutbox_flood_delay', '15'),
('hot_level', '5'),
('latest_entry_max', '5'),
('latest_reply_max', '5'),
('show_action', '1'),
('show_comments', '1'),
('show_latest_entries', '1'),
('show_latest_replies', '1'),
('no_blocks_text', 'Администратор этого сайта выбрал не показывать блоки на этой странице');
INSERT INTO `phpbb_blog_contributors` (`weblog_id`, `user_id`) VALUES
(6, 110);
INSERT INTO `phpbb_blog_moods` (`mood_id`, `mood_text`, `mood_url`, `mood_set`) VALUES
(1, 'Ангельское', 'mood_angelic.gif', 0),
(2, 'Конфузия', 'mood_confused.gif', 0),
(3, 'Школьное', 'mood_cool.gif', 0),
(4, 'Придурковато', 'mood_silly.gif', 0),
(5, 'Очень плохо', 'mood_verysad.gif', 0),
(6, 'В шоке', 'mood_shocked.gif', 0),
(7, 'Дьявольское', 'mood_evil.gif', 0),
(8, 'В любви', 'mood_love.gif', 0),
(9, 'Хорошее', 'mood_amused.gif', 0),
(10, 'Злое', 'mood_angry.gif', 0),
(11, 'Нейтральное', 'mood_neutral.gif', 0),
(12, 'Болею', 'mood_sick.gif', 0),
(13, 'Напуганое', 'mood_scared.gif', 0),
(14, 'Праздничное', 'mood_happy.gif', 0),
(15, 'Убиваюсь', 'mood_fedup.gif', 0),
(16, 'Раздражённое', 'mood_distorted.gif', 0),
(17, 'Гипноз', 'mood_hypnotized.gif', 0),
(18, 'Смущенное', 'mood_embarrased.gif', 0),
(19, 'Сплю', 'mood_sleepy.gif', 0);
INSERT INTO `phpbb_config_points` (`config_name`, `config_value`) VALUES
('points_vote', '1'),
('points_register', '100'),
('points_name', 'Активок'),
('points_donate', '1'),
('points_poll', '1'),
('points_reply', '2'),
('points_topic', '5'),
('points_page', '1'),
('points_post', '1'),
('points_browse', '1'),
('points_user_group_auth_ids', '3'),
('points_system_version', '2.1.4'),
('color_points', '300'),
('status_points', '150'),
('razban_points', '50'),
('present_points', '150'),
('delete_time', '7');
INSERT INTO `phpbb_css_style` (`style_id`, `style_name`, `user_id`, `body_background`, `body_color`, `body_border`, `body_width`, `body_max`, `a_link`, `a_hower`, `top_background`, `top_color`, `top_border`, `tab_background`, `tab_color`, `tab_border`, `tab_border_radius`, `row1_background`, `row1_color`, `row1_border`, `row1_border_radius`, `row_hard_background`, `row_hard_color`, `row_hard_border`, `row_easy_background`, `row_easy_color`, `row_easy_border`, `buttom_background`, `buttom_color`, `buttom_border`) VALUES
(9, 'lords-black_NeW!', 872, '#000000', '#f7d700', '#f7d700', '', '', '#00ff00', 'green', 'gray', '#f7d700', '#f7d700', 'gray', '#f7d700', '#f7d700', '', 'gray', '#f7d700', '#f7d700', '', 'gray', '#f7d700', '#f7d700', 'gray', '#f7d700', '#f7d700', 'gray', '#f7d700', '#f7d700'),
(8, 'lords-black_style!', 872, '#000000', '#f7d700', '#00ccff', '', '', '#00ff00', 'green', '#000066', '#f7d700', '#33ccff', '#000066', '#f7d700', '#33ccff', '', '#000099', '#cc0000', '#33ccff', '', '#000099', '#cc0000', '#33ccff', '#000099', '#cc0000', '#33ccff', '#330099', '#660000', '#330099'),
(5, 'Зелено-голубой', 5, '#00CED1', '#556B2F', '#8FBC8F', '99%', '', '#483D8B', '#008B8B', '#66CDA4', '#228B22', '#4B0082', '#990000', '#556B2F', '#660000', '', '#00BFFF', '#556B2F', '#660000', '', '#008B8B', '#008000', '#ADD8E6', '#ADD8E6', '#2F4F4F', '#ADD8E6', '#8FBC8F', '#483D8B', '#00BFFF'),
(7, 'Social', 2, '#FFFFFF', '#696969', '', '99%', '1', '#473C8B', '', '#B0C4DE', '#FFFFFF', '#4074a4', '#4074a4', '#CDCDB4', '#aaa', '', '#F5FFFA', '#000000', '#C1CDCD', '', '#e7f1fe', '#000000', '#E0FFFF', '#F5FFFA', '#000000', '#E6E6FA', '#aad', '#1C1C1C', '#000'),
(10, 'My night', 7, '#000000', '#FFD700', '#FFFFFF', '95%', '0', '#0000CD', '', '#8B7D78', '#FF4500', '#000000', '#FF0000', '#FFFFFF', '#000000', '', '#000000', '#FFD700', '#000000', '', '#FF0010', '#FFDC00', '#FF0010', '#000000', '#FFDC00', '#000000', '#FFFA00', '#FF00FF', '#FF00FF'),
(12, 'Finder', 1115, '#828282', '#00008B', '', '', '0', '#FF6A6A', '', '', '', '', '', '', '', '', '', '', '', '', '#90EE90', '', '', '', '', '', '', '', ''),
(13, 'Finder', 1115, '#828282', '#00008B', '', '', '0', '#FF6A6A', '', '', '', '', '', '', '', '', '', '', '', '', '#90EE90', '', '', '', '', '', '', '', '');
INSERT INTO `phpbb_guest_config` (`config_name`, `config_value`) VALUES
('maxlenght_posts', '500'),
('posts_per_page', '7'),
('hide_posts', '1'),
('smilies_column', '6'),
('smilies_row', '3'),
('no_only_smilies', '1'),
('no_only_quote', '1'),
('word_wrap', '1'),
('flood_interval', '20'),
('contatore', '23044'),
('word_wrap_length', '32'),
('session_posting', '60'),
('password', '12345'),
('permit_mod', '0');
INSERT INTO `phpbb_links` (`link_id`, `link_text`, `link_url`, `link_set`) VALUES
(15, 'Новости всего мира', 'news.php?cat=all', 1),
(7, '<img src="http://mobtop.ru/1570.gif" alt="" />', 'http://mobtop.ru/in/1570', 3);
INSERT INTO `phpbb_links_sets` (`set_id`, `set_name`) VALUES
(1, 'Верхний блок'),
(2, 'Нижний блок'),
(3, 'Счётчики');
INSERT INTO `phpbb_portal_config` (`config_name`, `config_value`) VALUES
('news', '1'),
('number_of_news', '1'),
('news_length', '300'),
('news_forum', '1'),
('number_of_news_recent', '4'),
('recent', '1'),
('topic_length', '30'),
('ignore_forums', '0'),
('nm_topics', '4'),
('gallery', '1'),
('cat_id', '1, 2, 3, 4, 5, 6, 7, 8, 9'),
('display', '0'),
('nm_pics', '4'),
('last', '1'),
('top_time', '24'),
('birthday', '1');
INSERT INTO `phpbb_questions_config` (`config_name`, `config_value`) VALUES
('on_off', '1'),
('cost_right', '1'),
('cost_input', '2'),
('max_numb_temp', '10'),
('min_time', '0'),
('otv_time', '30'),
('numb2rate', '3'),
('adm_bonus', '1'),
('adm_bonus_n', '10'),
('snd_on', '1'),
('popup', '2'),
('automoder', '0'),
('version', '1.05'),
('n1', '0');
INSERT INTO `phpbb_smilies_cat` (`id`, `cat_title`) VALUES
(36, 'Национальные'),
(35, 'Действия'),
(34, 'Разное'),
(33, 'Спорт/Игры'),
(32, 'Музыка'),
(31, 'Любовь/Дружба'),
(30, 'Еда/Алкоголь'),
(28, 'Эмоции/Состояние'),
(27, 'Праздники/Цветы'),
(29, 'Персонажи/Животные'),
(25, 'Юморные'),
(24, 'Девушки'),
(23, 'Плакаты'),
(22, 'Транспорт'),
(21, 'Стандартные');
INSERT INTO `phpbb_styles_css` (`style_id`, `style_name`, `style_text`) VALUES
(1, 'Один', 'body{\r\n background-color: #FFFFFF;\r\n font-size: 12px;\r\n font-family: Tahoma,Arial,Helvetica,sans-serif;\r\n color: #696969;\r\n border: 3px double #FFFFFF; \r\n margin: 2px auto;}\r\n \r\na:link,a:active,a:visited { color: #006400; text-decoration: none;}\r\na:hover {text-decoration: none; color: #FF4500;}\r\n\r\nhr { border: 1px dotted #3399fe;}\r\n.top {\r\n background-color: #00B2EE; \r\n background-image: url(/templates/style/top.gif); \r\n background-repeat: repeat-x; \r\n padding-left: 3px; \r\n text-transphpbbm: none;}\r\n \r\n.tab{\r\n background-color: #00CD66; \r\n color: #FFFFFF; \r\n background-image: url(/templates/style/tab.gif); \r\n background-repeat: repeat-x; \r\n border-left: 3px double #00CD66; \r\n border-right: 3px double #00CD66; \r\n padding: 2px;}\r\n\r\n.row1 { \r\n background-color: #F5FFFA; \r\n color: #7f7f7f; \r\n border: 1px solid #8BD712; \r\n padding: 2px;}\r\n\r\n.row_easy { \r\n background-color: #FFF0F5; \r\n color: #698B22; \r\n border-top: 1px solid #8BD712; \r\n border-left: 1px solid #CFCFCF;\r\n border-right: 1px solid #CFCFCF; \r\n padding: 2px;}\r\n \r\n.row_hard { \r\n background-color: #E6E6FA; \r\n color: #698B22; \r\n border-top: 1px solid #8BD712; \r\n border-left: 1px solid #CFCFCF;\r\n border-right: 1px solid #CFCFCF; \r\n padding: 2px;}\r\n\r\n.row_easy:hover, .row_hard:hover { background-color: #F5FFFA;}\r\n \r\n.genmed { font-size : 11px; }\r\n.top .cattitle{ color: #FFFFFF; font-weight: bold; font-size: 11px;}\r\n.cattitle { color: #698B22; font-weight: bold; font-size: 11px;}\r\na.cattitle { font-weight: bold; font-size: 11px;}\r\na.buttom { color: #0000FF; border: 1px solid #3399fe; background: #FFF68F; padding: 0px 2px 0px; line-height: 1.5;}\r\ninput.button, input.subbutton { background: #F5FFFA; color: #0000FF; border: 1px solid #00CD66; line-height: 1.1;}\r\n.rek {border: 1px dotted #00B2EE; padding-left: 1px;}'),
(2, 'Два (demo)', 'body{\r\ncolor: #696969; \r\nfont-size: 12px; \r\nfont-family: Tahoma; \r\nbackground-color: #FFFFFF; \r\nmargin: auto; \r\n}\r\n\r\na{color: #006400;}\r\na:hover{color: #B22222;}\r\nimg{vertical-align: middle;}\r\n\r\n.top{\r\n background: #F8F8FF; \r\n border: 1px solid #E6E6FA; \r\n}\r\n\r\n.tab{ \r\n border: 1px solid #aaa; \r\n background: #E6E6FA; \r\n padding: 2px; \r\n}\r\n\r\n.row1{\r\n background: #F0F8FF;\r\n border: 1px solid #F5FFFA;\r\n margin: 2px;} \r\n \r\n.row_hard{\r\n background: #FFFFF0; \r\n border: 1px dotted #FFE4B5; \r\n padding: 2px;\r\n}\r\n\r\n.row_easy{\r\n background: #F5FFFA; \r\n border: 1px dotted #E6E6FA; \r\n padding: 2px;\r\n}\r\n\r\n.row_hard a{color: #F08080;}\r\n.row_easy a{color: #228622;}\r\n.row_hard a:hover, .row_easy a:hover{color: #4b9dcd;}\r\n\r\n.subbutton, .button{\r\n font-size: 11px;\r\n border-left:1px solid #B1CADE;\r\n border-top:1px solid #B1CADE;\r\n border-right:1px solid #FFFFFF;\r\n border-bottom:1px solid #FFFFFF;}\r\n\r\n.cattitle{\r\n color: #2F4F4F;\r\n font-weight: bold;\r\n font-size: 12px;\r\n padding: 1px;\r\n margin: 2px;}\r\n \r\n.rek{border: 1px dotted #E6E6FA;}\r\n.select{border: 1px solid #47B902;}\r\n.genmed{color: #8B475D; font-size: 11px; padding: 1px; margin: 2px;}\r\na.buttom {color: #005895; border: 1px solid #CCC; background: #DDD; padding: 0px 2px 0px; line-height: 1.5;}'),
(4, 'Серо-зелёный', 'body {\r\n background-color: #ffffff;\r\n text-transphpbbm: none;\r\n text-align: left;\r\n font-family: Verdana, Arial, Helvetica, sans-serif, Courier new;\r\n color: #119806; \r\n margin: 1px auto;\r\n font-size: 11px;\r\n /*border: 1px solid #119806;*/\r\n padding: 1px;}\r\na:link,a:active,a:visited {\r\n color: #3B678D;\r\n text-decoration: none;}\r\na:hover {\r\n text-decoration: none;\r\n color: #000000;\r\n position: relative; \r\n top: 1px;}\r\n.tab { \r\n background-color: #119806;\r\n background-repeat: repeat-x;\r\n text-align: left;\r\n padding-left: 3px;\r\n color: #ffffff;\r\n font-weight: bold;\r\n border: 1px solid #119806;}\r\n.row_hard, .row_easy {\r\n background-color: #EBEBEB;\r\n border-bottom: 1px solid #999999;\r\n border-left: 1px solid #999999;\r\n border-right: 1px solid #999999;}\r\n.top { \r\n background-color: #EBEBEB;\r\n border: 2px double;\r\n border-color: #cacaca;\r\n color: #ff0000;\r\n text-align: left;\r\n font-size: 12px;\r\n font-weight:bold;\r\n padding: 2px;\r\n margin: 1px 0px 0px 0px;}\r\n.row1 {\r\n background-color: #D4D6D4;\r\n border-bottom: 1px solid #999999;\r\n border-left: 1px solid #999999;\r\n border-right: 1px solid #999999;\r\n padding: 1px;}\r\n.genmed { font-size : 11px; }\r\n.cattitle { color: #333333; font-weight: bold; font-size: 11px; }\r\na.cattitle { color: #3B678D; text-decoration: none; }\r\na.buttom { color: #333333; border: 1px solid #999999; background: #D4D6D4; padding: 0px 2px 0px; line-height: 1.5; }\r\nhr { border: 1px dotted #00ff00;}'),
(5, 'Серый', 'body { background:#FFFFFF; text-transphpbbm: none; text-align: left;\r\nfont-family: Tahoma; font-size: 12px; color: #000000; margin: 10px auto; padding: 0px; max-width:90%;}\r\nfont,th,td,p { color: #000000; font-family: Lucida Grande, Verdana, Arial, Helvetica, sans-serif; font-size: 12px; }\r\na:link,a:active,a:visited\r\n{ color: #3B678D;text-decoration: none; }\r\na:hover { text-decoration: none; color: #000000; position: relative; \r\ntop: 1px; }\r\n\r\n.tab { background-color: #D4D6D4; border-bottom: 1px solid #999999; border-left: 1px solid #999999; border-right: 1px solid #999999; }\r\n.row1, .row_easy, .row_hard { background-color: #EBEBEB; border-bottom: 1px solid #999999; border-left: 1px solid #999999; border-right: 1px solid #999999; padding: 1px; }\r\n.genmed { font-size : 11px; }\r\n.cattitle { color: #333333; font-weight: bold; font-size: 11px; }\r\na.cattitle { color: #3B678D; text-decoration: none; }\r\na.mainmenu { color: #333333; text-decoration: none; font-weight: bold; }\r\na.buttom { color: #333333; border: 1px solid #999999; background: #D4D6D4; padding: 0px 2px 0px; line-height: 1.5; }\r\n\r\n.top { background-color: #EBEBEB; border: 2px double; \r\nborder-color: #acacac; color: #3B678D; font-size: 12px; padding: 2px; \r\nmargin: 1px 0px 0px 0px; border-bottom: 2px solid #9B9B9B; border-left: 2px solid #CACACA; border-right: 0px solid #9B9B9B; }\r\nhr { border: 1px dotted #eeeeee; }'),
(6, 'Осенний', 'body {\r\nbackground-color: #FFFFB9;\r\ncolor: black;\r\nfont-family: Arial, Tahoma, sans-serif;\r\nfont-size: small;\r\nmargin: auto;\r\n}\r\na:link, a:visited {\r\nText-decoration: underline;\r\ncolor: GREEN;\r\n}\r\na:hover {\r\ncolor: red;\r\ntext-decoration: none;\r\n}\r\na:active {\r\ncolor: green;\r\ntext-decoration: underline;\r\n}\r\n\r\n.tab {\r\nmargin: 0px;\r\nbackground-color: #FFBF40;\r\nborder-top: 1px solid #ffffff;\r\nborder-bottom: 1px solid #667886;\r\npadding: 1px 0px 2px 0px;\r\n}\r\n.row1 {\r\nborder: 1px solid #b5bec7;\r\nmargin-bottom: 3px;\r\npadding: 2px;\r\nbackground-color: #A9EE7A;\r\n}\r\n.row_easy {\r\n background-color: #F5E89C; \r\n border-bottom: 1px solid #E37464; \r\n border-left: 1px double #E37464; \r\n border-right: 1px double #7AFF48; \r\n padding: 4px; color:#232323}\r\n.row_hard {\r\n background-color: #EED859; \r\n border-bottom: 1px double #E37464; \r\n border-left: 1px solid #E37464; \r\n border-right: 1px double #E37464; \r\n padding: 4px;color:#232323}'),
(8, 'Чёрно-красный', 'body {background:#000000; text-transphpbbm: none; text-align: left; font-family: Tahoma; font-size: 12px; color: #ffffff; margin: 10px auto;}\r\na:link,a:active,a:visited {color: #FF9900; text-decoration: none;}\r\na:hover{background-color: #990000; color: #ffffff;}\r\n.top{background-color: #393247; font-size: 11px; padding: 2px; margin: 1px 0px 0px 0px; }\r\n.tab {color:#FFFFFF; background-color: #990000; border-left: 3px double #CC0000; border-right: 3px double #660000; margin-bottom: 1px; padding: 2px}\r\n.row_easy, .row1{ background-color: #000000; border: 1px solid #CC3300;}\r\n.row_hard { background-color: #660000; border: 1px solid #CC3300;}\r\n.genmed { font-size : 11px; }\r\n.cattitle { color: #ffffff; font-weight: bold; font-size: 11px; }\r\na.cattitle { color: #ffffff; text-decoration: none; }\r\na.buttom { color: #990033; border: 1px solid #990033; background: #FFCC66; padding: 0px 2px 0px; line-height: 1.5;}\r\nhr { border: 1px dotted #eeeeee; }'),
(9, 'Тёмный стиль', 'body{ background:#3B7D32; background:url(/templates/style/fones.gif); text-transphpbbm: none; text-align: left;\r\nfont-family: Tahoma; font-size: 12px; color: #ffffff; margin: 10px auto; padding: 0px;}\r\na:link,a:active,a:visited { color: #4DF644; text-decoration: none;}\r\na:hover{ background-color: #708090; text-decoration: none; color: #004040; border: 1px solid #A7DDFE; padding: 1px; position: relative; top: 1px;}\r\nhr { border: none; height: 1px; color: #34EB5E; background-color: #34EB5E;}\r\n\r\n.tab{ background-color: #00468c; background-image: url(/templates/style/fones2.gif); background-repeat: repeat-x; font-size: 12px; padding: 2px; \r\nmargin: 1px 0px 0px 0px; border-bottom: 3px solid #00468c; border-top: 3px solid #00468c; border-left: 3px solid #00468c; border-right: 3px solid #00468c;}\r\n\r\n.row1{ background-color: #003366; font-size: 12px; padding: 2px; \r\nmargin: 1px 0px 0px 0px; border-bottom: 3px solid #003366; border-top: 3px solid #003366; border-left: 3px solid #003366; border-right: 3px solid #003366;}\r\n\r\n.top{ background-color: #003D79; background-image: url(/templates/style/fones3.gif); background-repeat: repeat-x; font-size: 11px; padding: 2px; \r\nmargin: 1px 0px 0px 0px;}\r\n\r\n.row_easy{ background-color: #3B7D32; border-bottom: 2px solid #cbcbcb; padding: 3px;}\r\n.row_hard{ background-color: #295723; border-bottom: 2px double #cbcbcb; padding: 3px;}\r\n.genmed { font-size : 11px; }\r\n.cattitle { color: #D3D3D3; font-weight: bold; font-size: 11px; }\r\na.cattitle { color: #D3D3D3; text-decoration: none; }\r\na.buttom { color: #FFFFFF; border: 1px solid #0000FF; background: #3399fe; padding: 0px 2px 0px; line-height: 1.5;}'),
(63, 'Желтый', 'body { background-color : #FFFFB9; color: #494949; font-family: sans-serif; font-size: 12px; }\r\na:link,a:active,a:visited { color: green; text-decoration: none; }\r\na:hover { text-decoration: none; color: black; position: relative;}\r\n.tab, .top { background-color: #FFBF40; border-bottom: #FFAA00; border-left: #FFAA00; border-right: #FFAA00;}\r\n.row1, .row_easy, .row_hard { background-color: #FFFF90; border-bottom: 1px solid #FFBF40; border-left: 1px solid #FFBF40; border-right: 1px solid #FFBF40; padding: 1px;}\r\n.genmed { font-size : 11px; }\r\n.cattitle {color: #494949; font-weight: bold; font-size: 11px;}\r\na.cattitle { color: green; text-decoration: none; }\r\na.buttom { color: green; border: 1px solid #FFBF40; background: #FFBF40; padding: 0px 2px 0px; line-height: 1.5;}'),
(64, 'Голубой', 'body{\r\n background-color : #fff;\r\n color: #4f4f4f; \r\n font-family: Tahoma, Verdana, Arial; \r\n font-size: 12px; \r\n margin: 2px auto;\r\n width: 100%; \r\n border: 1px solid #c8f2ff; \r\n padding: 2px;}\r\na {color: #005895; text-decoration: none; padding: 1px 2px; }\r\na:hover {color: #005895; background: #bcebff; text-decoration: none; }\r\n.top{ \r\n background: #ccffff;\r\n background-repeat: repeat-x;\r\n min-height: 28px;\r\n border: 1px solid #a8d635;\r\n text-align: left;\r\n padding: 1px;\r\n padding-left: 3px;\r\n margin: 0px;}\r\n.tab{\r\n background: #def7ff;\r\n border: 1px solid #c8f2ff;\r\n padding: 2px;\r\n padding-left:5px;\r\n margin: 2px;}\r\n.row1{\r\n background: #fafeff;\r\n text-align: left;\r\n border-top: 0px solid #c8f2ff;\r\n border-bottom: 1px solid #c8f2ff;\r\n padding: 2px;\r\n padding-left: 3px;\r\n margin: 2px;} \r\n.row_easy{background-color: #fafeff;}\r\n.row_hard{background-color: #f2fcff;}\r\n.genmed{ font-size: 11px; margin:2px;}\r\n.cattitle{\r\ncolor: #333;\r\nfont-weight: bold;\r\nfont-size: 12px;\r\npadding: 1px;\r\nmargin: 2px;}\r\na.cattitle { color: #333; text-decoration: none; }\r\na.buttom {color: #005895; border: 1px solid #c8f2ff; background: #bcebff; padding: 0px 2px 0px; line-height: 1.5;}'),
(67, 'Зима', 'body {\r\n font-size: 12px;\r\n font-family: Tahoma, Arial, Helvetica, sans-serif;\r\n color: #698B22;\r\n background-color: #F5F5F5;\r\n background-image: url(/templates/style/background.gif); \r\n margin: 1px auto;}\r\n \r\na:link,a:active,a:visited \r\n{\r\n color: #996666;\r\n text-decoration: none;}\r\n \r\na:hover \r\n{\r\n background-color: #D3D3D3;\r\n text-decoration: none;\r\n color: #FFFFFF;}\r\n \r\nhr { border: 1px dotted #3399fe;}\r\n\r\n.tab \r\n{\r\n background-color: #DAE2E8; \r\n background-image: url(/templates/style/tab.png); \r\n background-repeat: repeat-x; \r\n color: #45688E;\r\n font-size: 12px; \r\n padding: 2px; \r\n border-top: \r\n 1px solid #9B9B9B; \r\n border-left: \r\n 1px solid #CACACA; \r\n border-right: 1px solid #9B9B9B;}\r\n \r\n.row1 \r\n{ \r\n background-color: #F8F8FF;\r\n background-image: url(/templates/style/row1.png);\r\n background-repeat: repeat-x; \r\n border-left: 1px solid #cce2ff; \r\n padding: 2px; \r\n color: #4F4F4F;}\r\n \r\n.top \r\n{\r\n background-color: #CCCCFF; \r\n background-image: url(/templates/style/top.png); \r\n background-repeat: repeat-x; \r\n text-transphpbbm: none;}\r\n \r\n.row_easy {background-color: #F8F8FA;}\r\n.row_hard {background-color: #F5F5FA;}\r\n.row_easy, .row_hard { \r\n color: #4F4F4F; \r\n border-top: 1px solid #C1CDCD; \r\n border-right: 1px solid #C1CDCD; \r\n padding: 2px;}\r\n \r\n.genmed { color: #458B00; font-size : 11px; }\r\n.top .cattitle { color: #FFFFF0; font-weight: bold; font-size: 11px;}\r\n.cattitle { font-weight: bold; font-size: 11px;}\r\na.cattitle { text-decoration: none;}\r\n\r\na.buttom \r\n{\r\n color: #FFFFFF;\r\n border: 1px solid #F0E68C;\r\n background: #D3D3D3; \r\n padding: 0px 2px 0px; \r\n line-height: 1.5;} \r\n \r\nsubbutton, button\r\n{\r\n margin: 3px 0px 3px 0px; \r\n border: 1px solid #F0E68C; \r\n background-color: #D3D3D3; \r\n font-size:11px; \r\n font-weight: bold;} \r\n \r\n.rek {border: 1px solid #FFFFFF; padding: 0px 2px 0px;}'),
(69, 'Салатовый', 'body { background-color : #C3FFB3; margin: 2px auto; max-width:90%; } \r\nfont, th, td, div { color: #707070; font-family: Lucida Grande, Verdana, Arial, Helvetica, sans-serif; font-size: 12px; } \r\n\r\na:link,a:active,a:visited { color: #2D6900; text-decoration: none; } \r\na:hover { text-decoration: none; border: thin solid #2D6900; color: #2D6900; position: relative; top: 1px; } \r\n\r\nhr { border: 1px dotted #018201; } \r\n.tab { background-color: #A2F65F; border: 3px double #065800; } \r\n.row1 { background-color: #81D642; border: 1px solid #409800;} \r\n.row_easy { background-color: #97ED6D; border-bottom: 1px solid #00FF00; border-left: 1px solid #00FF00; border-right: 1px solid #00FF00; padding: 1px;} \r\n.row_hard { background-color: #A7EE85; border-bottom: 1px solid #00FF00; border-left: 1px solid #00FF00; border-right: 1px solid #00FF00; padding: 1px;} \r\n\r\n.top { background-color: #97ED6D; border-top: 3px double #00CC00; border-bottom: 3px double #009900; border-left: 3px double #009900; border-right: 3px double #00CC00; text-align: center; } \r\n\r\n.genmed { font-size : 11px; } \r\n.cattitle { color: #009400; font-weight: bold; font-size: 11px;} \r\na.cattitle { color: #000000; text-decoration: none; } \r\na.buttom { color: #000000; border: 1px solid #003300; background: #99FF99; padding: 0px 2px 0px; line-height: 1.5;}\r\n\r\n.subbutton { background-color: #ffffff; border: 1px solid; \r\ncolor: #3B678D;}'),
(70, 'Сиреневенький', 'body { background-color: #f1f1f1; font-family: Arial, Verdana, Helvetica, sans-serif; font-size: 11px; color: #000000; margin: auto; max-width:98%;}\r\na{color: #686868; text-decoration: none;}\r\na:hover{text-decoration: underline;}\r\n.row1 { background-color: #e0e0e0; border-bottom: 2px solid #d1d1d1; padding: 2px; color: #7f7f7f; }\r\n.row_easy { background-color: #D8BFD8; border-bottom: 2px solid #cbcbcb; padding: 3px; }\r\n.row_hard { background-color: #B0C4DE; border-bottom: 2px double #cbcbcb; padding: 3px;}\r\n.top {\r\n background-color: #FFFB8E; border: 0px double; border-color: #FFFFFF; \r\n color: #A7051B; text-align: center; font-size: 12px; font-weight:bold;\r\n padding: 2px; margin: 1px 0px 0px 0px; }\r\n.genmed { font-size : 12px; }\r\n.cattitle { color: #000000; font-size: 12px; }\r\na.cattitle { color: #000000; text-decoration: none; }\r\na.mainmenu { color: #008000; text-decoration: none; font-weight: bold;}\r\na.buttom { color: #f0f0f0; border: 1px solid #f0f0f0; background: #9bc442; padding: 2px; line-height: 2;}\r\n.tab { background-color: #9ACD32; border-bottom: 2px solid #7ca624; font-weight: bold; color: #000000; margin-top: 4px; }\r\nhr { border: 1px dotted #eeeeee; }'),
(3, 'Три (demo)', 'body{color: #696969; font-size: 12px; font-family: Tahoma; background-color: #FFFFFF; margin: auto; width: 98%;}\r\na{color: #473C8B;}\r\na:hover{color: #B22222;}\r\n.top{background: #778899; background-image: url(/templates/style/topp.png); color: #E0EEEE; border: 1px solid #4682B4;}\r\n.tab{background: #BEBEBE; border: 1px solid #aaa; padding: 2px;}\r\n.top a, .tab a{color: #FFFFFF;}\r\n.top a:hover, .tab a:hover{color: #B22222;}\r\n.row1{background: #F5FFFA; border: 1px solid #C1CDCD; margin: 2px;} \r\n.row_hard{background: #FFFACD; border: 1px solid #E6E6FA; padding: 2px;}\r\n.row_easy{background: #E6E6FA; border: 1px solid #FFFACD; padding: 2px;}\r\n.row_hard a{color: #F08080;}\r\n.row_easy a{color: #228622;}\r\n.row_hard a:hover, .row_easy a:hover{color: #4b9dcd;}\r\n.cattitle{font-weight: bold; font-size: 12px; padding: 1px; margin: 2px;}\r\n.rek{border: 1px dotted #BEBEBE;}\r\n.genmed{color: #8B475D; font-size: 11px; padding: 1px; margin: 2px;}\r\na.buttom, .subbutton, .button{color: #1C1C1C; border: 1px solid #8B3A3A; background: #F8F8FF; padding: 0px 2px 0px; line-height: 1.5;}'),
(72, 'Life-Style', 'body{color: #363636; font-size: 12px; font-family: Tahoma; background-color: #FFFFFF; margin: auto;}\r\na{color: #B8860B;}\r\na:hover{color: #FFDEAD;}\r\nhr{border : 1px dotted #c00;}\r\n.top{border: 1px solid #FFFACD;/*apwa.ru*/}\r\n.tab{background-color: #FFF8DC;/*apwa.ru*/ border: 1px solid #FFD700; padding: 2px;}\r\n.row1{background-color: #FFFFFF; border: 1px solid #FFFACD;} \r\n.row_hard{background-color: #FFFFF0; -webkit-border-radius: 7px; -moz-border-radius: 7px; -khtml-border-radius: 7px; border-radius: 7px; border: 1px solid #FFFACD; padding: 2px;}\r\n.row_easy{background-color: #FFFFE0; -webkit-border-radius: 7px; -moz-border-radius: 7px; -khtml-border-radius: 7px; border-radius: 7px; border: 1px solid #FFF8DC; padding: 2px;}\r\n\r\n.rek{border: 1px dotted #FFFACD;}\r\n.cattitle{color: ##CD950C; font-weight: bold; font-size: 12px; padding: 1px; margin: 2px;}\r\n.genmed{color: #EEC900; font-size: 11px; padding: 1px; margin: 2px;}\r\na.buttom, .subbutton, .button{background: #FFFFE0; color: #CD5C5C;/*apwa.ru*/ border: 1px solid #A0522D; padding: 0px 2px 0px; line-height: 1.5;}'),
(73, 'Превед=)', 'body{\r\n background-color: #FFFFFF;\r\n font-size: 12px;\r\n font-family: Tahoma,Arial,Helvetica,sans-serif;\r\n color: #698B22; \r\n margin: 2px auto;\r\n max-width:95%;}\r\na:link,a:active,a:visited{ color: #27408B; }\r\na:hover{ color: #008B00; text-decoration: underline; }\r\nhr { border: 1px dotted #CDB5CD;}\r\n.top { \r\n background-color: #4074a4; \r\n background-image: url(/templates/style/stop.gif); \r\n background-repeat: repeat-x;\r\n color: #FFFFFF; \r\n padding-left: 3px; \r\n border: 1px solid #D9E0E7;}\r\n.top a{ color: #B9D3EE; }\r\n.tab { \r\n background-color: #DAE2E8; \r\n color: #45688E; \r\n border-left: 1px solid #C1CDCD; \r\n border-top: 1px solid #B1BDD6; \r\n border-right: 1px solid #C1CDCD; padding: 2px; }\r\n.row1 {background-color: #F9F9FF;} \r\n.row_easy {background-color: #F8F8FA;}\r\n.row_hard {background-color: #F4F4FA;}\r\n.row1, .row_easy, .row_hard { \r\n color: #4F4F4F; \r\n border-top: 1px solid #DAE2E8; \r\n border-left: 1px solid #DAE2E8;\r\n border-right: 1px solid #DAE2E8; \r\n padding: 2px;}\r\n.genmed {font-size : 11px; }\r\n.cattitle { font-weight: bold; font-size: 12px; }\r\na.cattitle { font-weight: bold; font-size: 11px;}\r\na.buttom { background-color: #F5F5F5; color: #191970; border: 1px solid #9FB6CD; padding: 0px 2px 0px; text-decoration: none; line-height: 1.5; }\r\ninput.button, input.subbutton, select { background: #F7F7FA; border: 1px solid #DAE2E8; }\r\ninput.subbutton:hover, input.button:hover { border: 1px solid #FFFF00; }\r\n.rek {border: 1px dotted #9FB6CD; padding-left: 1px;}');
INSERT INTO `phpbb_users_bots` (`id`, `name`, `view`, `lastvisit`, `was`, `ip`, `show`) VALUES
(32, 'Crawler', 'WebAlta', 1379722589, '47374', '194.153.113.13', 1),
(25, 'ia_archiver', 'Alexa', 1350882406, '274', '204.236.235.245', 1),
(23, 'becomebot', 'Become', 0, '0', '', 1),
(20, 'aport.ru', 'Aport', 1284471715, '76862', '194.67.18.194', 1),
(17, 'Yahoo', '', 1369494733, '9312', '67.195.111.178', 1),
(14, 'Gigablast', '', 1313636175, '91', '65.111.171.90', 1),
(18, 'Yandex', '', 1379735835, '1212446', '5.255.253.2', 1),
(31, 'Lycos.com', 'Lycos', 0, '0', '', 1),
(5, 'msnbot', 'MSN', 1363321042, '22789', '65.55.215.93', 1),
(4, 'Rambler', '', 1308645669, '1554499', '81.19.78.73', 1),
(3, 'Nigma', '', 1371422491, '1671', '195.239.178.205', 1),
(2, 'Google', '', 1379783875, '2824559', '66.249.78.5', 1);
# -- wordlist
INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 1, 'example', 0 );
INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 2, 'post', 0 );
INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 3, 'phpbb', 0 );
INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 4, 'installation', 0 );
INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 5, 'delete', 0 );
INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 6, 'topic', 0 );
INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 7, 'forum', 0 );
INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 8, 'since', 0 );
INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 9, 'everything', 0 );
INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 10, 'seems', 0 );
INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 11, 'working', 0 );
INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 12, 'welcome', 0 );
# -- wordmatch
INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 1, 1, 0 );
INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 2, 1, 0 );
INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 3, 1, 0 );
INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 4, 1, 0 );
INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 5, 1, 0 );
INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 6, 1, 0 );
INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 7, 1, 0 );
INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 8, 1, 0 );
INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 9, 1, 0 );
INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 10, 1, 0 );
INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 11, 1, 0 );
INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 12, 1, 1 );
INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 3, 1, 1 );
# -- attachments_config
INSERT INTO phpbb_attachments_config VALUES ('upload_dir', 'files');
INSERT INTO phpbb_attachments_config VALUES ('upload_img', 'images/icon_clip.gif');
INSERT INTO phpbb_attachments_config VALUES ('topic_icon', 'images/icon_clip.gif');
INSERT INTO phpbb_attachments_config VALUES ('display_order', '0');
INSERT INTO phpbb_attachments_config VALUES ('max_filesize', '102400');
INSERT INTO phpbb_attachments_config VALUES ('attachment_quota', '0');
INSERT INTO phpbb_attachments_config VALUES ('max_filesize_pm', '102400');
INSERT INTO phpbb_attachments_config VALUES ('max_attachments', '5');
INSERT INTO phpbb_attachments_config VALUES ('max_attachments_pm', '3');
INSERT INTO phpbb_attachments_config VALUES ('disable_mod', '0');
INSERT INTO phpbb_attachments_config VALUES ('allow_pm_attach', '1');
INSERT INTO phpbb_attachments_config VALUES ('attachment_topic_review', '0');
INSERT INTO phpbb_attachments_config VALUES ('allow_ftp_upload', '0');
INSERT INTO phpbb_attachments_config VALUES ('show_apcp', '0');
INSERT INTO phpbb_attachments_config VALUES ('attach_version', '2.4.5');
INSERT INTO phpbb_attachments_config VALUES ('default_upload_quota', '0');
INSERT INTO phpbb_attachments_config VALUES ('default_pm_quota', '0');
INSERT INTO phpbb_attachments_config VALUES ('ftp_server', '');
INSERT INTO phpbb_attachments_config VALUES ('ftp_path', '');
INSERT INTO phpbb_attachments_config VALUES ('download_path', '');
INSERT INTO phpbb_attachments_config VALUES ('ftp_user', '');
INSERT INTO phpbb_attachments_config VALUES ('ftp_pass', '');
INSERT INTO phpbb_attachments_config VALUES ('ftp_pasv_mode', '1');
INSERT INTO phpbb_attachments_config VALUES ('img_display_inlined', '0');
INSERT INTO phpbb_attachments_config VALUES ('img_max_width', '0');
INSERT INTO phpbb_attachments_config VALUES ('img_max_height', '0');
INSERT INTO phpbb_attachments_config VALUES ('img_link_width', '0');
INSERT INTO phpbb_attachments_config VALUES ('img_link_height', '0');
INSERT INTO phpbb_attachments_config VALUES ('img_create_thumbnail', '0');
INSERT INTO phpbb_attachments_config VALUES ('img_min_thumb_filesize', '12000');
INSERT INTO phpbb_attachments_config VALUES ('img_imagick', '');
INSERT INTO phpbb_attachments_config VALUES ('use_gd2', '0');
INSERT INTO phpbb_attachments_config VALUES ('wma_autoplay', '0');
INSERT INTO phpbb_attachments_config VALUES ('flash_autoplay', '0');
# -- forbidden_extensions
INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (1,'php');
INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (2,'php3');
INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (3,'php4');
INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (4,'phtml');
INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (5,'pl');
INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (6,'asp');
INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (7,'cgi');
INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (8,'php5');
INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (9,'php6');
# -- extension_groups
INSERT INTO phpbb_extension_groups VALUES (1, 'Прочее', 0, 1, 1, '', 102400, '');
INSERT INTO phpbb_extension_groups VALUES (2, 'Видео', 0, 1, 1, '', 102400, '');
INSERT INTO phpbb_extension_groups VALUES (3, 'Картинки', 1, 1, 1, '', 102400, '');
INSERT INTO phpbb_extension_groups VALUES (4, 'Архивы', 0, 1, 1, '', 102400, '');
INSERT INTO phpbb_extension_groups VALUES (5, 'Мелодии', 0, 1, 1, '', 102400, '');
# -- extensions
INSERT INTO phpbb_extensions VALUES (1, 3, 'gif', '');
INSERT INTO phpbb_extensions VALUES (2, 3, 'png', '');
INSERT INTO phpbb_extensions VALUES (3, 3, 'jpeg', '');
INSERT INTO phpbb_extensions VALUES (4, 3, 'jpg', '');
INSERT INTO phpbb_extensions VALUES (5, 4, 'tar', '');
INSERT INTO phpbb_extensions VALUES (6, 4, 'zip', '');
INSERT INTO phpbb_extensions VALUES (7, 4, 'rar', '');
INSERT INTO phpbb_extensions VALUES (8, 1, 'txt', '');
INSERT INTO phpbb_extensions VALUES (9, 1, 'sis', '');
INSERT INTO phpbb_extensions VALUES (10, 1, 'jad', '');
INSERT INTO phpbb_extensions VALUES (11, 4, 'jar', '');
INSERT INTO phpbb_extensions VALUES (12, 5, 'aac', '');
INSERT INTO phpbb_extensions VALUES (13, 2, 'avi', '');
INSERT INTO phpbb_extensions VALUES (14, 2, 'mp4', '');
INSERT INTO phpbb_extensions VALUES (15, 2, '3gp', '');
INSERT INTO phpbb_extensions VALUES (16, 5, 'amr', '');
INSERT INTO phpbb_extensions VALUES (17, 5, 'mmf', '');
INSERT INTO phpbb_extensions VALUES (18, 5, 'mp3', '');
INSERT INTO phpbb_extensions VALUES (19, 5, 'wav', '');
INSERT INTO phpbb_extensions VALUES (20, 5, 'midi', '');
INSERT INTO phpbb_extensions VALUES (21, 5, 'mid', '');
INSERT INTO phpbb_extensions VALUES (22, 3, 'bmp', '');
# -- default quota limits
INSERT INTO phpbb_quota_limits (quota_limit_id, quota_desc, quota_limit) VALUES (1, 'Low', 262144);
INSERT INTO phpbb_quota_limits (quota_limit_id, quota_desc, quota_limit) VALUES (2, 'Medium', 2097152);
INSERT INTO phpbb_quota_limits (quota_limit_id, quota_desc, quota_limit) VALUES (3, 'High', 5242880);
INSERT INTO phpbb_album_config VALUES ('max_pics', '1024');
INSERT INTO phpbb_album_config VALUES ('user_pics_limit', '50');
INSERT INTO phpbb_album_config VALUES ('mod_pics_limit', '250');
INSERT INTO phpbb_album_config VALUES ('max_file_size', '128000');
INSERT INTO phpbb_album_config VALUES ('max_width', '800');
INSERT INTO phpbb_album_config VALUES ('max_height', '600');
INSERT INTO phpbb_album_config VALUES ('rows_per_page', '3');
INSERT INTO phpbb_album_config VALUES ('cols_per_page', '1');
INSERT INTO phpbb_album_config VALUES ('fullpic_popup', '1');
INSERT INTO phpbb_album_config VALUES ('thumbnail_quality', '50');
INSERT INTO phpbb_album_config VALUES ('thumbnail_size', '125');
INSERT INTO phpbb_album_config VALUES ('thumbnail_cache', '1');
INSERT INTO phpbb_album_config VALUES ('sort_method', 'pic_time');
INSERT INTO phpbb_album_config VALUES ('sort_order', 'DESC');
INSERT INTO phpbb_album_config VALUES ('jpg_allowed', '1');
INSERT INTO phpbb_album_config VALUES ('png_allowed', '1');
INSERT INTO phpbb_album_config VALUES ('gif_allowed', '0');
INSERT INTO phpbb_album_config VALUES ('desc_length', '512');
INSERT INTO phpbb_album_config VALUES ('hotlink_prevent', '0');
INSERT INTO phpbb_album_config VALUES ('hotlink_allowed', 'smartor.is-root.com');
INSERT INTO phpbb_album_config VALUES ('personal_gallery', '0');
INSERT INTO phpbb_album_config VALUES ('personal_gallery_private', '0');
INSERT INTO phpbb_album_config VALUES ('personal_gallery_limit', '10');
INSERT INTO phpbb_album_config VALUES ('personal_gallery_view', '-1');
INSERT INTO phpbb_album_config VALUES ('rate', '1');
INSERT INTO phpbb_album_config VALUES ('rate_scale', '10');
INSERT INTO phpbb_album_config VALUES ('comment', '1');
INSERT INTO phpbb_album_config VALUES ('gd_version', '2');
INSERT INTO phpbb_album_config VALUES ('album_version', '.0.54');