#
# Basic DB data for phpBB2 devel
#
# $Id: mysql_basic.sql,v 1.29.2.29 2006/12/16 13:11:27 acydburn Exp $

# -- 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','yourdomain.com');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('site_desc','A _little_ text to describe your forum');
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', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_autologin','1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_autologin_time','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','youraddress@yourdomain.com');
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 ('search_flood_interval','15');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('search_min_chars','3');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_login_attempts', '5');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('login_reset_time', '30');
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', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('record_online_date', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_name', 'www.myserver.tld');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_port', '80');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('script_path', '/phpBB2/');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '.0.22');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('rand_seed', '0');


# -- Categories
INSERT INTO phpbb_categories (cat_id, cat_title, cat_order) VALUES (1, 'premod evolution', 10);
INSERT INTO phpbb_categories (cat_id, cat_title, cat_order) VALUES('2', 'salle de jeux', '20');

# -- 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, 'premod evolution', 'addons dedant.', 1, 10, 1, 1, 1, 0, 0, 1, 1, 1, 1, 3, 3, 1, 1, 3);
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('2', '2', 'Arcade', '', '0', '10', '0', '0', '0', NULL, '0', '0', '0', '1', '1', '1', '1', '3', '3', '1', '1', '0');
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, forum_icon) VALUES('3', '1', 'presentation ici', '', '0', '20', '1', '1', '3', NULL, '0', '0', '0', '1', '1', '1', '1', '3', '3', '1', '1', '0', '');

# -- 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_style, 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_dateformat, user_actkey, user_newpasswd, user_notify, user_active) VALUES ( -1, 'Anonymous', 0, 0, '', '', '', '', '', '', '', '', 0, NULL, '', '', '', 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_style, 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_dateformat, user_actkey, user_newpasswd, user_notify, user_active) VALUES ( 2, 'Admin', 1, 0, '21232f297a57a5a743894a0e4a801fc3', 'admin@yourdomain.com', '', '', '', '', '', '', 1, 1, '', '', '', 1, 0, 1, 0, 1, 1, 1, 1, 1, 1, '', 'english', 0, 'd M Y h:i a', '', '', 0, 1);


# -- Ranks
INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_special, rank_image) VALUES ( 1, 'Site Admin', -1, 1, 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, 'premod evolution', 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, 'bienvenue sur notre premod!');


# -- 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) 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', '', '', '');

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', '', '', '');
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('2', 'jasidogdotcom', 'jasidogdotcom', 'jasidogdotcom.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', '', '', '', '0', '0');

# -- 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');


# -- 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 );


INSERT INTO phpbb_arcade_categories(arcade_catid, arcade_cattitle, arcade_catorder) VALUES (1, 'Les jeux du forums', 1);

INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('version_arcade','Pro.3.0');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('use_category_mod','1');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('category_preview_games','2');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('games_par_page','10');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('game_order','Fixed');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('display_winner_avatar','1');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('stat_par_page','10');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('winner_avatar_position','left');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('winner_ultime_avatar_position','left');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('maxsize_avatar','200');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('linkcatittle_align','2');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('linkcat_align','2');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('limit_by_posts','0'); 
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('limit_type','date'); 
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('posts_needed','15'); 
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('days_limit','4'); 
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('rating_max', '10');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('use_arcade_vote', '1');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('use_points_mod','0');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('use_points_pay_mod','0');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('use_points_win_mod','0');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('use_points_pay_charging','0');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('use_points_pay_submit','0');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('points_winner','0');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('points_pay','0');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('use_fav_category', '1');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('nbr_games_fav', '-1');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('use_hide_fav', '1');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('fav_nbr_in_page', '10');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('pay_all_games', '0');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('prize_all_games', '');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('quota_games', '');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('game_pres', '0');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('present_fid', '0');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('auths_play', '0');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('auths_score', '0');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('auths_vote', '0');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('auths_vote_hidden', '0');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('championnat_points_one', '30');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('championnat_points_two', '19');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('championnat_points_three', '18');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('championnat_points_four', '17');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('championnat_points_five', '16');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('championnat_points_six', '15');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('championnat_points_seven', '14');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('championnat_points_eight', '13');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('championnat_points_nine', '12');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('championnat_points_ten', '11');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('championnat_points_eleven', '10');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('championnat_points_twelve', '9');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('championnat_points_thirteen', '8');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('championnat_points_fourteen', '7');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('championnat_points_fiveteen', '6');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('championnat_points_sixteen', '5');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('championnat_points_seventeen', '4');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('championnat_points_eighteen', '3');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('championnat_points_nineteen', '2');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('championnat_points_twenty', '1');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('championnat_cat','');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('championnat_taux_un','40');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('championnat_taux_deux','20');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('championnat_taux_trois','10');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('championnat_taux_quatre','9');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('championnat_taux_cinq','6');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('championnat_taux_six','5');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('championnat_taux_sept','4');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('championnat_taux_huit','3');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('championnat_taux_neuf','2');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('championnat_taux_dix','1');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('cat_use','0');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('use_cagnotte_mod','0');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('use_points_cagnotte','0');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('cagnotte','0');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('day_distrib','0');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('date_distribcagnotte','0');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('use_auto_distrib','0');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('champ_see','1');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('heading_see','1');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('topstats_see','1');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('whoisplay_see','1');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('cat_see', '1');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('favoris_see','1');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('champ_seeg','1');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('heading_seeg','1');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('topstats_seeg','1');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('whoisplay_seeg','1');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('cat_seeg', '1');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('favoris_seeg','1');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('scorerow_position','1');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('message_pres','1');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('games_time_tolerance', '10');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('games_cheater_submit', '1');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('color_use', '0');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('color_admin', 'FF0000');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('color_mod', '00FF00');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('color_user', '0000FF');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('page_guest_admin', '50');
INSERT INTO phpbb_arcade (arcade_name, arcade_value) VALUES('display_ultime_winner_avatar', '1');

ALTER TABLE phpbb_users ADD `user_nb_game` int(3) DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_users ADD `user_date_game` varchar (255) DEFAULT '0' NOT NULL;

INSERT INTO `phpbb_arcade` (`arcade_name`, `arcade_value`) VALUES ('bestplayers_portal', '0');
INSERT INTO `phpbb_arcade` (`arcade_name`, `arcade_value`) VALUES ('bestplayers_arcade', '0');
INSERT INTO `phpbb_arcade` (`arcade_name`, `arcade_value`) VALUES ('bestplayers_games', '0');
INSERT INTO `phpbb_arcade` (`arcade_name`, `arcade_value`) VALUES ('bestplayers_forum', '1');
INSERT INTO `phpbb_arcade` (`arcade_name`, `arcade_value`) VALUES ('bestplayers_viewforum', '0');
INSERT INTO `phpbb_arcade` (`arcade_name`, `arcade_value`) VALUES ('bestplayers_viewtopic', '0');
INSERT INTO `phpbb_arcade` (`arcade_name`, `arcade_value`) VALUES ('limit_bestplayers', '5');
INSERT INTO `phpbb_arcade` (`arcade_name`, `arcade_value`) VALUES ('avatar_best', '60');
INSERT INTO `phpbb_arcade` (`arcade_name`, `arcade_value`) VALUES ('admin_best_on', '1');
INSERT INTO `phpbb_arcade` (`arcade_name`, `arcade_value`) VALUES ('modo_best_on', '1');
INSERT INTO `phpbb_arcade` (`arcade_name`, `arcade_value`) VALUES ('use_gender_img', '0');
INSERT INTO `phpbb_arcade` (`arcade_name`, `arcade_value`) VALUES ('use_flag_img', '0');
INSERT INTO `phpbb_arcade` (`arcade_name`, `arcade_value`) VALUES ('use_stats_link', '1');

INSERT INTO `phpbb_areabb_blocs` VALUES (1, 1, 6, 'PHP');
INSERT INTO `phpbb_areabb_blocs` VALUES (2, 1, 2, 'PHP');
INSERT INTO `phpbb_areabb_blocs` VALUES (3, 1, 7, 'PHP');
INSERT INTO `phpbb_areabb_blocs` VALUES (4, 1, 5, 'PHP');
INSERT INTO `phpbb_areabb_blocs` VALUES (5, 1, 0, '');
INSERT INTO `phpbb_areabb_blocs` VALUES (6, 1, 3, 'PHP');
INSERT INTO `phpbb_areabb_blocs` VALUES (7, 1, 4, 'PHP');
INSERT INTO `phpbb_areabb_blocs` VALUES (8, 1, 0, '');
INSERT INTO `phpbb_areabb_blocs` VALUES (9, 1, 0, '');
INSERT INTO `phpbb_areabb_blocs` VALUES (10, 1, 0, '');
INSERT INTO `phpbb_areabb_blocs` VALUES (11, 1, 0, '');

INSERT INTO `phpbb_areabb_config` VALUES ('mod_point_system', '0');
INSERT INTO `phpbb_areabb_config` VALUES ('mod_gender', '0');
INSERT INTO `phpbb_areabb_config` VALUES ('mod_rcs', '0');
INSERT INTO `phpbb_areabb_config` VALUES ('news_par_defaut', '1');
INSERT INTO `phpbb_areabb_config` VALUES ('mod_profile', '1');
INSERT INTO `phpbb_areabb_config` VALUES ('nbre_topics_recents', '10');
INSERT INTO `phpbb_areabb_config` VALUES ('defiler_topics_recents', '1');
INSERT INTO `phpbb_areabb_config` VALUES ('news_forums', '1');
INSERT INTO `phpbb_areabb_config` VALUES ('news_nbre_mots', '500');
INSERT INTO `phpbb_areabb_config` VALUES ('news_nbre_coms', '20');
INSERT INTO `phpbb_areabb_config` VALUES ('news_nbre_news', '10');
INSERT INTO `phpbb_areabb_config` VALUES ('news_aff_icone', '0');
INSERT INTO `phpbb_areabb_config` VALUES ('news_aff_coms', '1');
INSERT INTO `phpbb_areabb_config` VALUES ('news_aff_asv', '1');

INSERT INTO `phpbb_areabb_feuille` VALUES (1, 1, 3, 1);

INSERT INTO `phpbb_areabb_modeles` VALUES (1, '<table width="100%" cellspacing="0" cellpadding="2" border="0" align="center" valign="top">\r\n<tr>\r\n      <td width="28%" align="center" valign="top">%s</td>\r\n      <td width="44%" align="center" valign="top"><center>%s</center></td>\r\n      <td width="28%" align="center" valign="top">%s</td>\r\n</tr>\r\n</table>', '3 colonnes, le bloc central est 2 fois plus large que les autres');
INSERT INTO `phpbb_areabb_modeles` VALUES (2, '<table width="100%">\r\n   <tr>\r\n      <td class="row1">%s</td>\r\n   </tr>\r\n</table>', 'Bloc 100% de la largeur');
INSERT INTO `phpbb_areabb_modeles` VALUES (3, '<table width="100%" cellspacing="0" cellpadding="2" border="0" align="center" valign="top">\r\n<tr>\r\n    <td width="22%" align="center" valign="top">\r\n         %s \r\n         %s \r\n         %s \r\n         %s \r\n         %s \r\n      </td>\r\n      <td width="56%" align="center" valign="top">%s</td>\r\n      <td width="22%" align="center" valign="top">\r\n         %s \r\n         %s \r\n         %s \r\n         %s \r\n         %s \r\n       </td>\r\n</tr>\r\n</table>', 'Structure traditionnelle');

INSERT INTO `phpbb_areabb_mods` VALUES (1, 'config', 0, '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30');
INSERT INTO `phpbb_areabb_mods` VALUES (2, 'login', 1, '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30');
INSERT INTO `phpbb_areabb_mods` VALUES (3, 'news', 1, '3');
INSERT INTO `phpbb_areabb_mods` VALUES (4, 'recent_topics', 1, '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30');
INSERT INTO `phpbb_areabb_mods` VALUES (5, 'whoisonline', 1, '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30');
INSERT INTO `phpbb_areabb_mods` VALUES (6, 'welcome', 1, '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30');
INSERT INTO `phpbb_areabb_mods` VALUES (7, 'statistiques', 1, '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30');
INSERT INTO `phpbb_areabb_mods` VALUES (8, 'profile', 0, '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30');

INSERT INTO `phpbb_areabb_squelette` VALUES (1, 'Un concentré d''Actualité', NULL, 3,0);
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ('AreaBB_version', '0.9.1');
ALTER TABLE `phpbb_sessions` ADD `areabb_tps_depart` INT( 11 ) , ADD `areabb_gid` INT( 11 ) ,ADD `areabb_variable` VARCHAR( 50 ) ;

INSERT INTO phpbb_shout (shout_id, shout_username, shout_user_id, shout_group_id, shout_session_time, shout_ip, shout_text, shout_active, enable_bbcode, enable_html, enable_smilies, enable_sig, shout_bbcode_uid) VALUES('1', '', '2', '0', '1181779383', '5a1d7bec', 'teste', '0', '1', '0', '1', '0', '3cc48a7ac1');


INSERT INTO `phpbb_classement_table` VALUES ('CI_classement_0', 'date_register');
INSERT INTO `phpbb_classement_table` VALUES ('CI_order_0', 'asc');
INSERT INTO `phpbb_classement_table` VALUES ('CI_limit_0', '3');
INSERT INTO `phpbb_classement_table` VALUES ('CI_desactivate_0', '0');
INSERT INTO `phpbb_classement_table` VALUES ('CI_position_0', '1');
INSERT INTO `phpbb_classement_table` VALUES ('CI_page_0', '0');
INSERT INTO `phpbb_classement_table` VALUES ('CI_random_0', '0');
INSERT INTO `phpbb_classement_table` VALUES ('CI_manual_order_0', '0');
INSERT INTO `phpbb_classement_table` VALUES ('CI_random_order_0', '0');
INSERT INTO `phpbb_classement_table` VALUES ('CI_classement_1', 'nbr_post');
INSERT INTO `phpbb_classement_table` VALUES ('CI_order_1', 'asc');
INSERT INTO `phpbb_classement_table` VALUES ('CI_limit_1', '5');
INSERT INTO `phpbb_classement_table` VALUES ('CI_desactivate_1', '0');
INSERT INTO `phpbb_classement_table` VALUES ('CI_position_1', '1');
INSERT INTO `phpbb_classement_table` VALUES ('CI_page_1', '0');
INSERT INTO `phpbb_classement_table` VALUES ('CI_random_1', '0');
INSERT INTO `phpbb_classement_table` VALUES ('CI_manual_order_1', '0');
INSERT INTO `phpbb_classement_table` VALUES ('CI_random_order_1', '0');

INSERT INTO `phpbb_config` VALUES ('restriction_sms', '');
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) 
VALUES ( 
'sms_texte', 'Ce forum n\'est pas un téléphone portable!<br>Merci de ne pas y poster des messages avec une écriture sms.');
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) 
VALUES ( 
'color_sms', 'red');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('visit_counter', '1');
INSERT INTO phpbb_config VALUES ('registration_notify', 1);

ALTER TABLE phpbb_users ADD user_from_flag varchar(25) NULL AFTER user_from;
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','usa','usa.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','afghanistan','afghanistan.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','albania','albania.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','algeria','algeria.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','andorra','andorra.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','angola','angola.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','antigua and barbuda','antiguabarbuda.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','argentina','argentina.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','armenia','armenia.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','australia','australia.gif');

INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','austria','austria.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','azerbaijan','azerbaijan.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','bahamas','bahamas.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','bahrain','bahrain.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','bangladesh','bangladesh.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','barbados','barbados.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','belarus','belarus.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','belgium','belgium.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','belize','belize.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','benin','benin.gif');

INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','bhutan','bhutan.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','bolivia','bolivia.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','bosnia herzegovina','bosnia_herzegovina.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','botswana','botswana.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','brazil','brazil.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','brunei','brunei.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','bulgaria','bulgaria.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','burkinafaso','burkinafaso.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','burma','burma.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','burundi','burundi.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','cambodia','cambodia.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','cameroon','cameroon.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','canada','canada.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','central african rep','centralafricanrep.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','chad','chad.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','chile','chile.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','china','china.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','columbia','columbia.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','comoros','comoros.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','congo','congo.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','costarica','costarica.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','croatia','croatia.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','cuba','cuba.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','cyprus','cyprus.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','czech republic','czechrepublic.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','demrepcongo','demrepcongo.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','denmark','denmark.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','djibouti','djibouti.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','dominica','dominica.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','dominican rep','dominicanrep.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','ecuador','ecuador.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','egypt','egypt.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','elsalvador','elsalvador.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','eq guinea','eq_guinea.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','eritrea','eritrea.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','estonia','estonia.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','ethiopia','ethiopia.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','fiji','fiji.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','finland','finland.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','france','france.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','gabon','gabon.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','gambia','gambia.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','georgia','georgia.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','germany','germany.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','ghana','ghana.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','greece','greece.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','grenada','grenada.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','grenadines','grenadines.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','guatemala','guatemala.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','guinea','guinea.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','guineabissau','guineabissau.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','guyana','guyana.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','haiti','haiti.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','honduras','honduras.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','hong kong','hong_kong.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','hungary','hungary.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','iceland','iceland.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','india','india.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','indonesia','indonesia.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','iran','iran.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','iraq','iraq.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','ireland','ireland.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','israel','israel.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','italy','italy.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','ivory coast','ivorycoast.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','jamaica','jamaica.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','japan','japan.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','jordan','jordan.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','kazakhstan','kazakhstan.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','kenya','kenya.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','kiribati','kiribati.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','kuwait','kuwait.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','kyrgyzstan','kyrgyzstan.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','laos','laos.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','latvia','latvia.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','lebanon','lebanon.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','liberia','liberia.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','libya','libya.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','liechtenstein','liechtenstein.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','lithuania','lithuania.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','luxembourg','luxembourg.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','macadonia','macadonia.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','macau','macau.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','madagascar','madagascar.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','malawi','malawi.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','malaysia','malaysia.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','maldives','maldives.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','mali','mali.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','malta','malta.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','mauritania','mauritania.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','mauritius','mauritius.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','mexico','mexico.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','micronesia','micronesia.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','moldova','moldova.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','monaco','monaco.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','mongolia','mongolia.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','morocco','morocco.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','mozambique','mozambique.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','namibia','namibia.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','nauru','nauru.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','nepal','nepal.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','neth antilles','neth_antilles.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','netherlands','netherlands.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','new zealand','newzealand.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','nicaragua','nicaragua.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','niger','niger.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','nigeria','nigeria.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','north korea','north_korea.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','norway','norway.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','oman','oman.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','pakistan','pakistan.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','panama','panama.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','papua newguinea','papuanewguinea.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','paraguay','paraguay.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','peru','peru.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','philippines','philippines.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','poland','poland.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','portugal','portugal.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','puertorico','puertorico.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','qatar','qatar.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','rawanda','rawanda.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','romania','romania.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','russia','russia.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','sao tome','sao_tome.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','saudiarabia','saudiarabia.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','senegal','senegal.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','serbia','serbia.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','seychelles','seychelles.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','sierraleone','sierraleone.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','singapore','singapore.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','slovakia','slovakia.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','slovenia','slovenia.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','solomon islands','solomon_islands.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','somalia','somalia.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','south_korea','south_korea.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','south africa','southafrica.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','spain','spain.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','srilanka','srilanka.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','stkitts nevis','stkitts_nevis.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','stlucia','stlucia.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','sudan','sudan.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','suriname','suriname.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','sweden','sweden.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','switzerland','switzerland.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','syria','syria.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','taiwan','taiwan.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','tajikistan','tajikistan.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','tanzania','tanzania.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','thailand','thailand.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','togo','togo.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','tonga','tonga.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','trinidad and tobago','trinidadandtobago.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','tunisia','tunisia.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','turkey','turkey.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','turkmenistan','turkmenistan.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','tuvala','tuvala.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','uae','uae.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','uganda','uganda.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','uk','uk.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','ukraine','ukraine.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','uruguay','uruguay.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','ussr','ussr.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','uzbekistan','uzbekistan.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','vanuatu','vanuatu.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','venezuela','venezuela.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','vietnam','vietnam.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','western samoa','western_samoa.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','yemen','yemen.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','yugoslavia','yugoslavia.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','zaire','zaire.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','zambia','zambia.gif');
INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','zimbabwe','zimbabwe.gif');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('cash_disable',0);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cash_display_after_posts',1);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cash_post_message','You earned %s for that post');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cash_disable_spam_num',10);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cash_disable_spam_time',24);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cash_disable_spam_message','You have exceeded the alloted amount of posts and will not earn anything for your post');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cash_installed','yes');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cash_version','2.2.3');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cash_adminbig','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cash_adminnavbar','1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('points_name','Points');

ALTER TABLE phpbb_users ADD user_inactive_emls TINYINT( 1 ) NOT NULL ;
ALTER TABLE phpbb_users ADD user_inactive_last_eml INT( 11 ) NOT NULL ;
INSERT INTO phpbb_config (config_name, config_value) VALUES ('removed_users', '0') ;

ALTER TABLE phpbb_users ADD user_birthday varchar(10) DEFAULT '' NOT NULL;
INSERT INTO phpbb_config (config_name, config_value) VALUES ('birthday_settings', '0-1-5-100');

INSERT INTO `phpbb_cijoint` ( `cijoint_filepath` , `cijoint_filesize` , 
`cijoint_urlallow` , `cijoint_imgallow` )
VALUES ('cijoint/', '512', 'doc,xls,ppt,odt,ods,odp', 'jpg,gif,png');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('rabbitoshi_enable', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('rabbitoshi_name', 'Rabbistoshi');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('rabbitoshi_enable_cron', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('rabbitoshi_cron_time', '86400');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('rabbitoshi_cron_last_time', '0');
INSERT INTO phpbb_rabbitoshi_config (creature_id, creature_name, creature_prize, creature_max_hunger, creature_max_thirst, creature_max_health, creature_max_hygiene, creature_food_id, creature_buyable, creature_evolution_of, creature_img) VALUES (10, 'Eagle', 500, 150, 60, 150, 60, 3, 1, 0, 'Eagle.gif');
INSERT INTO phpbb_rabbitoshi_config (creature_id, creature_name, creature_prize, creature_max_hunger, creature_max_thirst, creature_max_health, creature_max_hygiene, creature_food_id, creature_buyable, creature_evolution_of, creature_img) VALUES (9, 'Tiger', 5000, 60, 400, 60, 400, 5, 1, 0, 'Tiger.gif');
INSERT INTO phpbb_rabbitoshi_config (creature_id, creature_name, creature_prize, creature_max_hunger, creature_max_thirst, creature_max_health, creature_max_hygiene, creature_food_id, creature_buyable, creature_evolution_of, creature_img) VALUES (8, 'Beaver', 30, 20, 20, 20, 50, 1, 1, 0, 'Beaver.gif');
INSERT INTO phpbb_rabbitoshi_config (creature_id, creature_name, creature_prize, creature_max_hunger, creature_max_thirst, creature_max_health, creature_max_hygiene, creature_food_id, creature_buyable, creature_evolution_of, creature_img) VALUES (7, 'Hiloterium', 50, 200, 200, 200, 1500, 5, 1, 0, 'Hiloterium.gif');
INSERT INTO phpbb_rabbitoshi_config (creature_id, creature_name, creature_prize, creature_max_hunger, creature_max_thirst, creature_max_health, creature_max_hygiene, creature_food_id, creature_buyable, creature_evolution_of, creature_img) VALUES (6, 'Dragon', 20000, 300, 1000, 5000, 250, 6, 1, 0, 'Dragon.gif');
INSERT INTO phpbb_rabbitoshi_config (creature_id, creature_name, creature_prize, creature_max_hunger, creature_max_thirst, creature_max_health, creature_max_hygiene, creature_food_id, creature_buyable, creature_evolution_of, creature_img) VALUES (11, 'Polar Bear', 700, 500, 500, 500, 500, 4, 1, 0, 'Polar_Bear.gif');
INSERT INTO phpbb_rabbitoshi_config (creature_id, creature_name, creature_prize, creature_max_hunger, creature_max_thirst, creature_max_health, creature_max_hygiene, creature_food_id, creature_buyable, creature_evolution_of, creature_img) VALUES (12, 'Rabbit', 20, 20, 20, 20, 50, 2, 1, 0, 'Rabbit.gif');
INSERT INTO phpbb_rabbitoshi_config (creature_id, creature_name, creature_prize, creature_max_hunger, creature_max_thirst, creature_max_health, creature_max_hygiene, creature_food_id, creature_buyable, creature_evolution_of, creature_img) VALUES (13, 'Chaos Rabbit', 8000, 1500, 1500, 1500, 100, 2, 1, 12, 'Chaos_Rabbit.gif');
INSERT INTO phpbb_rabbitoshi_config (creature_id, creature_name, creature_prize, creature_max_hunger, creature_max_thirst, creature_max_health, creature_max_hygiene, creature_food_id, creature_buyable, creature_evolution_of, creature_img) VALUES (4, 'Lion', 240, 80, 70, 400, 120, 5, 1, 0, 'Lion.gif');
INSERT INTO phpbb_rabbitoshi_config (creature_id, creature_name, creature_prize, creature_max_hunger, creature_max_thirst, creature_max_health, creature_max_hygiene, creature_food_id, creature_buyable, creature_evolution_of, creature_img) VALUES (3, 'Cat', 40, 20, 20, 90, 20, 4, 1, 0, 'Cat.gif');
INSERT INTO phpbb_rabbitoshi_config (creature_id, creature_name, creature_prize, creature_max_hunger, creature_max_thirst, creature_max_health, creature_max_hygiene, creature_food_id, creature_buyable, creature_evolution_of, creature_img) VALUES (2, 'Dog', 40, 50, 50, 60, 100, 3, 1, 0, 'Dog.gif');
INSERT INTO phpbb_rabbitoshi_config (creature_id, creature_name, creature_prize, creature_max_hunger, creature_max_thirst, creature_max_health, creature_max_hygiene, creature_food_id, creature_buyable, creature_evolution_of, creature_img) VALUES (1, 'Chinchilla', 120, 100, 100, 15, 100, 1, 1, 0, 'Chinchilla.gif');
INSERT INTO phpbb_rabbitoshi_config (creature_id, creature_name, creature_prize, creature_max_hunger, creature_max_thirst, creature_max_health, creature_max_hygiene, creature_food_id, creature_buyable, creature_evolution_of, creature_img) VALUES (5, 'Penguin', 500, 120, 60, 75, 50, 4, 1, 0, 'Penguin.gif');
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('thirst_time', 600);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('thirst_value', 1);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('hunger_time', 600);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('hunger_value', 1);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('hygiene_time', 3600);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('hygiene_value', 1);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('health_time', 86400);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('health_value', 5);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('rebirth_enable', 1);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('rebirth_price', 50000);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('vet_enable', 1);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('vet_price', 300);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('hotel_enable', 1);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('hotel_cost', 500);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('evolution_enable', 1);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('evolution_cost', 100);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('evolution_time', 25);
INSERT INTO phpbb_rabbitoshi_shop (item_id, item_name, item_prize, item_desc, item_type, item_power, item_img) VALUES (1, 'Rabbitoshi_items_seeds', 10, 'Rabbitoshi_items_seeds_desc', 1, 1, 'Seeds.gif');
INSERT INTO phpbb_rabbitoshi_shop (item_id, item_name, item_prize, item_desc, item_type, item_power, item_img) VALUES (2, 'Rabbitoshi_items_carrots', 20, 'Rabbitoshi_items_carrots_desc', 1, 20, 'Carotts.gif');
INSERT INTO phpbb_rabbitoshi_shop (item_id, item_name, item_prize, item_desc, item_type, item_power, item_img) VALUES (3, 'Rabbitoshi_items_meat', 30, 'Rabbitoshi_items_meat_desc', 1, 3, 'Fresh_meat.gif');
INSERT INTO phpbb_rabbitoshi_shop (item_id, item_name, item_prize, item_desc, item_type, item_power, item_img) VALUES (4, 'Rabbitoshi_items_fish', 30, 'Rabbitoshi_items_fish_desc', 1, 3, 'Fish.gif');
INSERT INTO phpbb_rabbitoshi_shop (item_id, item_name, item_prize, item_desc, item_type, item_power, item_img) VALUES (5, 'Rabbitoshi_items_gazelle', 100, 'Rabbitoshi_items_gazelle_desc', 1, 8, 'Gazelle.gif');
INSERT INTO phpbb_rabbitoshi_shop (item_id, item_name, item_prize, item_desc, item_type, item_power, item_img) VALUES (6, 'Rabbitoshi_items_diamonds', 500, 'Rabbitoshi_items_diamonds_desc', 1, 10, 'Diamonds.gif');
INSERT INTO phpbb_rabbitoshi_shop (item_id, item_name, item_prize, item_desc, item_type, item_power, item_img) VALUES (7, 'Rabbitoshi_items_limpid_water', 2, 'Rabbitoshi_items_limpid_water_desc', 2, 4, 'Limpid_water.gif');
INSERT INTO phpbb_rabbitoshi_shop (item_id, item_name, item_prize, item_desc, item_type, item_power, item_img) VALUES (8, 'Rabbitoshi_items_cleaner', 500, 'Rabbitoshi_items_cleaner_desc', 3, 10, 'Cleaner.gif');

ALTER TABLE phpbb_forums ADD forum_parent INT NOT NULL DEFAULT '0';

ALTER TABLE `phpbb_forums` ADD `forum_link` VARCHAR(255) NULL;
ALTER TABLE `phpbb_forums` ADD `forum_link_count` INT(11) NOT NULL DEFAULT '1';
ALTER TABLE `phpbb_forums` ADD `forum_link_date` INT(11) NOT NULL DEFAULT '0';