# # phpBB Backup Script # Dump of tables for newjudea # # DATE : 29-10-2003 20:29:57 GMT # # # Table Data for phpbb_categories # INSERT INTO phpbb_categories (cat_id, cat_title, cat_order) VALUES('1', 'Test category 1', '10'); # # Table Data for phpbb_config # INSERT INTO phpbb_config (config_name, config_value) VALUES('config_id', '1'); INSERT INTO phpbb_config (config_name, config_value) VALUES('board_disable', '0'); INSERT INTO phpbb_config (config_name, config_value) VALUES('sitename', 'Новая Иудея'); INSERT INTO phpbb_config (config_name, config_value) VALUES('site_desc', 'Аналитический сайт-форум'); INSERT INTO phpbb_config (config_name, config_value) VALUES('cookie_name', 'phpbb2mysql'); INSERT INTO phpbb_config (config_name, config_value) VALUES('cookie_path', '/'); INSERT INTO phpbb_config (config_name, config_value) VALUES('cookie_domain', ''); INSERT INTO phpbb_config (config_name, config_value) VALUES('cookie_secure', '0'); INSERT INTO phpbb_config (config_name, config_value) VALUES('session_length', '3600'); INSERT INTO phpbb_config (config_name, config_value) VALUES('allow_html', '0'); INSERT INTO phpbb_config (config_name, config_value) VALUES('allow_html_tags', 'b,i,u,pre'); INSERT INTO phpbb_config (config_name, config_value) VALUES('allow_bbcode', '1'); INSERT INTO phpbb_config (config_name, config_value) VALUES('allow_smilies', '1'); INSERT INTO phpbb_config (config_name, config_value) VALUES('allow_sig', '1'); INSERT INTO phpbb_config (config_name, config_value) VALUES('allow_namechange', '0'); INSERT INTO phpbb_config (config_name, config_value) VALUES('allow_theme_create', '0'); INSERT INTO phpbb_config (config_name, config_value) VALUES('allow_avatar_local', '0'); INSERT INTO phpbb_config (config_name, config_value) VALUES('allow_avatar_remote', '0'); INSERT INTO phpbb_config (config_name, config_value) VALUES('allow_avatar_upload', '0'); INSERT INTO phpbb_config (config_name, config_value) VALUES('enable_confirm', '0'); INSERT INTO phpbb_config (config_name, config_value) VALUES('override_user_style', '0'); INSERT INTO phpbb_config (config_name, config_value) VALUES('posts_per_page', '15'); INSERT INTO phpbb_config (config_name, config_value) VALUES('topics_per_page', '50'); INSERT INTO phpbb_config (config_name, config_value) VALUES('hot_threshold', '25'); INSERT INTO phpbb_config (config_name, config_value) VALUES('max_poll_options', '10'); INSERT INTO phpbb_config (config_name, config_value) VALUES('max_sig_chars', '255'); INSERT INTO phpbb_config (config_name, config_value) VALUES('max_inbox_privmsgs', '50'); INSERT INTO phpbb_config (config_name, config_value) VALUES('max_sentbox_privmsgs', '25'); INSERT INTO phpbb_config (config_name, config_value) VALUES('max_savebox_privmsgs', '50'); INSERT INTO phpbb_config (config_name, config_value) VALUES('board_email_sig', 'Thanks, The Management'); INSERT INTO phpbb_config (config_name, config_value) VALUES('board_email', 'taz0w@actcom.co.il'); INSERT INTO phpbb_config (config_name, config_value) VALUES('smtp_delivery', '0'); INSERT INTO phpbb_config (config_name, config_value) VALUES('smtp_host', ''); INSERT INTO phpbb_config (config_name, config_value) VALUES('smtp_username', ''); INSERT INTO phpbb_config (config_name, config_value) VALUES('smtp_password', ''); INSERT INTO phpbb_config (config_name, config_value) VALUES('sendmail_fix', '0'); INSERT INTO phpbb_config (config_name, config_value) VALUES('require_activation', '0'); INSERT INTO phpbb_config (config_name, config_value) VALUES('flood_interval', '15'); INSERT INTO phpbb_config (config_name, config_value) VALUES('board_email_form', '0'); INSERT INTO phpbb_config (config_name, config_value) VALUES('avatar_filesize', '6144'); INSERT INTO phpbb_config (config_name, config_value) VALUES('avatar_max_width', '80'); INSERT INTO phpbb_config (config_name, config_value) VALUES('avatar_max_height', '80'); INSERT INTO phpbb_config (config_name, config_value) VALUES('avatar_path', 'images/avatars'); INSERT INTO phpbb_config (config_name, config_value) VALUES('avatar_gallery_path', 'images/avatars/gallery'); INSERT INTO phpbb_config (config_name, config_value) VALUES('smilies_path', 'images/smiles'); INSERT INTO phpbb_config (config_name, config_value) VALUES('default_style', '1'); INSERT INTO phpbb_config (config_name, config_value) VALUES('default_dateformat', 'D M d, Y g:i a'); INSERT INTO phpbb_config (config_name, config_value) VALUES('board_timezone', '0'); INSERT INTO phpbb_config (config_name, config_value) VALUES('prune_enable', '1'); INSERT INTO phpbb_config (config_name, config_value) VALUES('privmsg_disable', '0'); INSERT INTO phpbb_config (config_name, config_value) VALUES('gzip_compress', '0'); INSERT INTO phpbb_config (config_name, config_value) VALUES('coppa_fax', ''); INSERT INTO phpbb_config (config_name, config_value) VALUES('coppa_mail', ''); INSERT INTO phpbb_config (config_name, config_value) VALUES('record_online_users', '1'); INSERT INTO phpbb_config (config_name, config_value) VALUES('record_online_date', '1067457679'); INSERT INTO phpbb_config (config_name, config_value) VALUES('server_name', 'chop.phpwebhosting.com'); INSERT INTO phpbb_config (config_name, config_value) VALUES('server_port', '80'); INSERT INTO phpbb_config (config_name, config_value) VALUES('script_path', '/~vilsha/'); INSERT INTO phpbb_config (config_name, config_value) VALUES('version', '.0.6'); INSERT INTO phpbb_config (config_name, config_value) VALUES('board_startdate', '1067457611'); INSERT INTO phpbb_config (config_name, config_value) VALUES('default_lang', 'russian'); # # Table Data for phpbb_forums # INSERT INTO phpbb_forums (forum_id, cat_id, forum_name, forum_desc, forum_status, forum_order, forum_posts, forum_topics, forum_last_post_id, prune_next, prune_enable, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments) VALUES('1', '1', 'Test Forum 1', 'This is just a test forum.', '0', '10', '1', '1', '1', NULL, '0', '0', '0', '0', '0', '1', '1', '3', '3', '1', '1', '3'); # # Table Data for phpbb_groups # INSERT INTO phpbb_groups (group_id, group_type, group_name, group_description, group_moderator, group_single_user) VALUES('1', '1', 'Anonymous', 'Personal User', '0', '1'); INSERT INTO phpbb_groups (group_id, group_type, group_name, group_description, group_moderator, group_single_user) VALUES('2', '1', 'Admin', 'Personal User', '0', '1'); # # Table Data for phpbb_posts # INSERT INTO phpbb_posts (post_id, topic_id, forum_id, poster_id, post_time, poster_ip, post_username, enable_bbcode, enable_html, enable_smilies, enable_sig, post_edit_time, post_edit_count) VALUES('1', '1', '1', '2', '972086460', '7F000001', NULL, '1', '0', '1', '1', NULL, '0'); # # Table Data for phpbb_posts_text # INSERT INTO phpbb_posts_text (post_id, bbcode_uid, post_subject, post_text) VALUES('1', '', NULL, 'This is an example post in your phpBB 2 installation. You may delete this post, this topic and even this forum if you like since everything seems to be working!'); # # Table Data for phpbb_ranks # INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_special, rank_image) VALUES('1', 'Site Admin', '-1', '1', NULL); # # Table Data for phpbb_search_wordlist # INSERT INTO phpbb_search_wordlist (word_text, word_id, word_common) VALUES('example', '1', '0'); INSERT INTO phpbb_search_wordlist (word_text, word_id, word_common) VALUES('post', '2', '0'); INSERT INTO phpbb_search_wordlist (word_text, word_id, word_common) VALUES('phpbb', '3', '0'); INSERT INTO phpbb_search_wordlist (word_text, word_id, word_common) VALUES('installation', '4', '0'); INSERT INTO phpbb_search_wordlist (word_text, word_id, word_common) VALUES('delete', '5', '0'); INSERT INTO phpbb_search_wordlist (word_text, word_id, word_common) VALUES('topic', '6', '0'); INSERT INTO phpbb_search_wordlist (word_text, word_id, word_common) VALUES('forum', '7', '0'); INSERT INTO phpbb_search_wordlist (word_text, word_id, word_common) VALUES('since', '8', '0'); INSERT INTO phpbb_search_wordlist (word_text, word_id, word_common) VALUES('everything', '9', '0'); INSERT INTO phpbb_search_wordlist (word_text, word_id, word_common) VALUES('seems', '10', '0'); INSERT INTO phpbb_search_wordlist (word_text, word_id, word_common) VALUES('working', '11', '0'); INSERT INTO phpbb_search_wordlist (word_text, word_id, word_common) VALUES('welcome', '12', '0'); # # Table Data for phpbb_search_wordmatch # INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('1', '1', '0'); INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('1', '2', '0'); INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('1', '3', '0'); INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('1', '4', '0'); INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('1', '5', '0'); INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('1', '6', '0'); INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('1', '7', '0'); INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('1', '8', '0'); INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('1', '9', '0'); INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('1', '10', '0'); INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('1', '11', '0'); INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('1', '12', '1'); INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('1', '3', '1'); # # Table Data for phpbb_sessions # INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in) VALUES('32b7e4ccd9cd72f659fb0a1ea80b22d4', '2', '1067457700', '1067459389', '812ad0b6', '0', '1'); # # Table Data for phpbb_smilies # INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('1', ':D', 'icon_biggrin.gif', 'Very Happy'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('2', ':-D', 'icon_biggrin.gif', 'Very Happy'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('3', ':grin:', 'icon_biggrin.gif', 'Very Happy'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('4', ':)', 'icon_smile.gif', 'Smile'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('5', ':-)', 'icon_smile.gif', 'Smile'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('6', ':smile:', 'icon_smile.gif', 'Smile'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('7', ':(', 'icon_sad.gif', 'Sad'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('8', ':-(', 'icon_sad.gif', 'Sad'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('9', ':sad:', 'icon_sad.gif', 'Sad'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('10', ':o', 'icon_surprised.gif', 'Surprised'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('11', ':-o', 'icon_surprised.gif', 'Surprised'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('12', ':eek:', 'icon_surprised.gif', 'Surprised'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('13', ':shock:', 'icon_eek.gif', 'Shocked'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('14', ':?', 'icon_confused.gif', 'Confused'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('15', ':-?', 'icon_confused.gif', 'Confused'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('16', ':???:', 'icon_confused.gif', 'Confused'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('17', '8)', 'icon_cool.gif', 'Cool'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('18', '8-)', 'icon_cool.gif', 'Cool'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('19', ':cool:', 'icon_cool.gif', 'Cool'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('20', ':lol:', 'icon_lol.gif', 'Laughing'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('21', ':x', 'icon_mad.gif', 'Mad'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('22', ':-x', 'icon_mad.gif', 'Mad'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('23', ':mad:', 'icon_mad.gif', 'Mad'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('24', ':P', 'icon_razz.gif', 'Razz'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('25', ':-P', 'icon_razz.gif', 'Razz'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('26', ':razz:', 'icon_razz.gif', 'Razz'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('27', ':oops:', 'icon_redface.gif', 'Embarassed'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('28', ':cry:', 'icon_cry.gif', 'Crying or Very sad'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('29', ':evil:', 'icon_evil.gif', 'Evil or Very Mad'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('30', ':twisted:', 'icon_twisted.gif', 'Twisted Evil'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('31', ':roll:', 'icon_rolleyes.gif', 'Rolling Eyes'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('32', ':wink:', 'icon_wink.gif', 'Wink'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('33', ';)', 'icon_wink.gif', 'Wink'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('34', ';-)', 'icon_wink.gif', 'Wink'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('35', ':!:', 'icon_exclaim.gif', 'Exclamation'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('36', ':?:', 'icon_question.gif', 'Question'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('37', ':idea:', 'icon_idea.gif', 'Idea'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('38', ':arrow:', 'icon_arrow.gif', 'Arrow'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('39', ':|', 'icon_neutral.gif', 'Neutral'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('40', ':-|', 'icon_neutral.gif', 'Neutral'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('41', ':neutral:', 'icon_neutral.gif', 'Neutral'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('42', ':mrgreen:', 'icon_mrgreen.gif', 'Mr. Green'); # # Table Data for phpbb_themes # INSERT INTO phpbb_themes (themes_id, template_name, style_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3, img_size_poll, img_size_privmsg) VALUES('1', 'subSilver', 'subSilver', 'subSilver.css', '', 'E5E5E5', '000000', '006699', '5493B4', '', 'DD6900', 'EFEFEF', 'DEE3E7', 'D1D7DC', '', '', '', '98AAB1', '006699', 'FFFFFF', 'cellpic1.gif', 'cellpic3.gif', 'cellpic2.jpg', 'FAFAFA', 'FFFFFF', '', 'row1', 'row2', '', 'Verdana, Arial, Helvetica, sans-serif', 'Trebuchet MS', 'Courier, \'Courier New\', sans-serif', '10', '11', '12', '444444', '006600', 'FFA34F', '', '', '', NULL, NULL); # # Table Data for phpbb_themes_name # INSERT INTO phpbb_themes_name (themes_id, tr_color1_name, tr_color2_name, tr_color3_name, tr_class1_name, tr_class2_name, tr_class3_name, th_color1_name, th_color2_name, th_color3_name, th_class1_name, th_class2_name, th_class3_name, td_color1_name, td_color2_name, td_color3_name, td_class1_name, td_class2_name, td_class3_name, fontface1_name, fontface2_name, fontface3_name, fontsize1_name, fontsize2_name, fontsize3_name, fontcolor1_name, fontcolor2_name, fontcolor3_name, span_class1_name, span_class2_name, span_class3_name) VALUES('1', 'The lightest row colour', 'The medium row color', 'The darkest row colour', '', '', '', 'Border round the whole page', 'Outer table border', 'Inner table border', 'Silver gradient picture', 'Blue gradient picture', 'Fade-out gradient on index', 'Background for quote boxes', 'All white areas', '', 'Background for topic posts', '2nd background for topic posts', '', 'Main fonts', 'Additional topic title font', 'Form fonts', 'Smallest font size', 'Medium font size', 'Normal font size (post body etc)', 'Quote & copyright text', 'Code text colour', 'Main table header text colour', '', '', ''); # # Table Data for phpbb_topics # INSERT INTO phpbb_topics (topic_id, forum_id, topic_title, topic_poster, topic_time, topic_views, topic_replies, topic_status, topic_vote, topic_type, topic_first_post_id, topic_last_post_id, topic_moved_id) VALUES('1', '1', 'Welcome to phpBB 2', '2', '972086460', '0', '0', '0', '0', '0', '1', '1', '0'); # # Table Data for phpbb_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'); # # Table Data for phpbb_users # INSERT INTO phpbb_users (user_id, user_active, username, user_password, user_session_time, user_session_page, user_lastvisit, user_regdate, user_level, user_posts, user_timezone, user_style, user_lang, user_dateformat, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_emailtime, user_viewemail, user_attachsig, user_allowhtml, user_allowbbcode, user_allowsmile, user_allowavatar, user_allow_pm, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_rank, user_avatar, user_avatar_type, user_email, user_icq, user_website, user_from, user_sig, user_sig_bbcode_uid, user_aim, user_yim, user_msnm, user_occ, user_interests, user_actkey, user_newpasswd) VALUES('-1', '0', 'Anonymous', '', '0', '0', '0', '1067457611', '0', '0', '0.00', NULL, '', '', '0', '0', '0', NULL, '0', '0', '0', '1', '1', '1', '0', '1', '0', '1', '0', NULL, '', '0', '', '', '', '', '', NULL, '', '', '', '', '', '', ''); INSERT INTO phpbb_users (user_id, user_active, username, user_password, user_session_time, user_session_page, user_lastvisit, user_regdate, user_level, user_posts, user_timezone, user_style, user_lang, user_dateformat, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_emailtime, user_viewemail, user_attachsig, user_allowhtml, user_allowbbcode, user_allowsmile, user_allowavatar, user_allow_pm, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_rank, user_avatar, user_avatar_type, user_email, user_icq, user_website, user_from, user_sig, user_sig_bbcode_uid, user_aim, user_yim, user_msnm, user_occ, user_interests, user_actkey, user_newpasswd) VALUES('2', '1', 'Admin', 'c9e42e0266771709743d77bc749ad796', '1067459389', '0', '1067457700', '1067457611', '1', '1', '0.00', '1', 'russian', 'd M Y h:i a', '0', '0', '0', NULL, '1', '0', '0', '1', '1', '1', '1', '1', '0', '1', '1', '1', '', '0', 'taz0w@actcom.co.il', '', '', '', '', '', '', '', '', '', '', '', '');