Просмотр архива Socialka

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',
'admin@apwa.ru'),
('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', 'admin@yourdomain.com', '', '', '', '',
'', '', 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');