phpBB.de - Die deutsche phpBB-Community
https://www.phpbb.de/community/
phpBB2/install/schemas -> mysql_basic.sql & mysql_schema.sql .. Dort jeweils nach CREATE TABLE phpbb_config bzw INSERT INTO phpbb_config suchenoder die CREATE und INSERT Statements aus der phpBB Installation raussuchen.
Code: Alles auswählen
CREATE TABLE `phpbb_config` (
`config_name` varchar(255) NOT NULL default '',
`config_value` varchar(255) NOT NULL default '',
PRIMARY KEY (`config_name`)
);
---------------------------------------------------------------
INSERT INTO `phpbb_config` VALUES ('config_id', '1');
INSERT INTO `phpbb_config` VALUES ('board_disable', '1');
INSERT INTO `phpbb_config` VALUES ('sitename', 'name derseite');
INSERT INTO `phpbb_config` VALUES ('site_desc', 'name des forums');
INSERT INTO `phpbb_config` VALUES ('cookie_name', 'deincookiename');
INSERT INTO `phpbb_config` VALUES ('cookie_path', '/');
INSERT INTO `phpbb_config` VALUES ('cookie_domain', '');
INSERT INTO `phpbb_config` VALUES ('cookie_secure', '0');
INSERT INTO `phpbb_config` VALUES ('session_length', '3600');
INSERT INTO `phpbb_config` VALUES ('allow_html', '0');
INSERT INTO `phpbb_config` VALUES ('allow_html_tags', 'b,i,u,pre');
INSERT INTO `phpbb_config` VALUES ('allow_bbcode', '1');
INSERT INTO `phpbb_config` VALUES ('allow_smilies', '1');
INSERT INTO `phpbb_config` VALUES ('allow_sig', '0');
INSERT INTO `phpbb_config` VALUES ('allow_namechange', '0');
INSERT INTO `phpbb_config` VALUES ('allow_theme_create', '0');
INSERT INTO `phpbb_config` VALUES ('allow_avatar_local', '0');
INSERT INTO `phpbb_config` VALUES ('allow_avatar_remote', '1');
INSERT INTO `phpbb_config` VALUES ('allow_avatar_upload', '0');
INSERT INTO `phpbb_config` VALUES ('enable_confirm', '0');
INSERT INTO `phpbb_config` VALUES ('override_user_style', '0');
INSERT INTO `phpbb_config` VALUES ('posts_per_page', '30');
INSERT INTO `phpbb_config` VALUES ('topics_per_page', '60');
INSERT INTO `phpbb_config` VALUES ('hot_threshold', '15');
INSERT INTO `phpbb_config` VALUES ('max_poll_options', '10');
INSERT INTO `phpbb_config` VALUES ('max_sig_chars', '255');
INSERT INTO `phpbb_config` VALUES ('max_inbox_privmsgs', '25');
INSERT INTO `phpbb_config` VALUES ('max_sentbox_privmsgs', '25');
INSERT INTO `phpbb_config` VALUES ('max_savebox_privmsgs', '25');
INSERT INTO `phpbb_config` VALUES ('board_email_sig', 'deine emailsignatur');
INSERT INTO `phpbb_config` VALUES ('board_email', 'info@deine addy.de');
INSERT INTO `phpbb_config` VALUES ('smtp_delivery', '0');
INSERT INTO `phpbb_config` VALUES ('smtp_host', '');
INSERT INTO `phpbb_config` VALUES ('smtp_username', '');
INSERT INTO `phpbb_config` VALUES ('smtp_password', '');
INSERT INTO `phpbb_config` VALUES ('sendmail_fix', '1');
INSERT INTO `phpbb_config` VALUES ('require_activation', '1');
INSERT INTO `phpbb_config` VALUES ('flood_interval', '15');
INSERT INTO `phpbb_config` VALUES ('board_email_form', '1');
INSERT INTO `phpbb_config` VALUES ('avatar_filesize', '6144');
INSERT INTO `phpbb_config` VALUES ('avatar_max_width', '80');
INSERT INTO `phpbb_config` VALUES ('avatar_max_height', '80');
INSERT INTO `phpbb_config` VALUES ('avatar_path', 'images/avatars');
INSERT INTO `phpbb_config` VALUES ('avatar_gallery_path', 'images/avatars/gallery');
INSERT INTO `phpbb_config` VALUES ('smilies_path', 'images/smiles');
INSERT INTO `phpbb_config` VALUES ('default_style', '11');
INSERT INTO `phpbb_config` VALUES ('default_dateformat', 'd.m.Y, H:i');
INSERT INTO `phpbb_config` VALUES ('board_timezone', '1');
INSERT INTO `phpbb_config` VALUES ('prune_enable', '0');
INSERT INTO `phpbb_config` VALUES ('privmsg_disable', '0');
INSERT INTO `phpbb_config` VALUES ('gzip_compress', '0');
INSERT INTO `phpbb_config` VALUES ('coppa_fax', '');
INSERT INTO `phpbb_config` VALUES ('coppa_mail', 'info@´deine addy.net');
INSERT INTO `phpbb_config` VALUES ('record_online_users', '12');
INSERT INTO `phpbb_config` VALUES ('record_online_date', '1099760280');
INSERT INTO `phpbb_config` VALUES ('server_name', 'deine url.de');
INSERT INTO `phpbb_config` VALUES ('server_port', '80');
INSERT INTO `phpbb_config` VALUES ('script_path', '');
INSERT INTO `phpbb_config` VALUES ('version', '.0.11');
INSERT INTO `phpbb_config` VALUES ('board_startdate', '1084910802');
INSERT INTO `phpbb_config` VALUES ('default_lang', 'german');