phpBB.de

Code: Alles auswählen

<author-notes lang="en-gb"><![CDATA[Please don't forget to set the forums for the default-Template, because at start every new user will only see the forums in this template and those who have the static-flag.
		
		If you want you can use the pre-patched files contained in the 'prepatched_<VERSION_OF_YOUR_FORUM>'-directory. Please make sure that you don't overwrite other modifications and that you only use the files for YOUR phpbb-Version.]]></author-notes>
		<author-notes lang="de"><![CDATA[Bitte vergiss nicht die Foren für das default-template eintzstellen, da jeder neue Userr am Anfang nur diese und die als statisch markierten Foren sieht.
		
		Wenn du willst kannst du die Dateien aus dem Ordner 'prepatched_<VERSIONSNUMMER_DEINES_FORUMS>' nutzen. Wenn du dies tust, achte bitte darauf dass du keine schon vorhandenen Mods überschreibst und du die Dateien für DEINE phpbb-version nutzt.]]></author-notes>
	</header>
	<action-group>
		<sql><![CDATA[CREATE TABLE `phpbb_forums_selected` (`user_id` MEDIUMINT( 8 ) NOT NULL , `forum_id` MEDIUMINT( 8 ) NOT NULL , PRIMARY KEY ( `user_id` , `forum_id` ) )]]></sql>
		<sql><![CDATA[ALTER TABLE `phpbb_forums` ADD `static` TINYINT( 1 ) NOT NULL DEFAULT '0']]></sql>
		<sql><![CDATA[CREATE TABLE `phpbb_selection_templates` (`template_id` MEDIUMINT( 8 ) NOT NULL ,`forum_id` MEDIUMINT( 8 ) NOT NULL ,PRIMARY KEY ( `template_id` , `forum_id` ))]]></sql>
		<sql><![CDATA[CREATE TABLE `phpbb_selection_template_names` (`template_id` MEDIUMINT( 8 ) NOT NULL AUTO_INCREMENT ,`template_name` VARCHAR( 255 ) NOT NULL ,PRIMARY KEY ( `template_id` ))]]></sql>
		<sql><![CDATA[INSERT INTO `phpbb_selection_template_names` (`template_id` ,`template_name`)VALUES ('-1', 'Default'), ('0', 'reserved');]]></sql>

Code: Alles auswählen

	<sql><![CDATA[--
-- Change the prefix if required!
--

ALTER TABLE `phpbb_forums` ADD `forum_auto_answer` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '1' AFTER `forum_status` ;
	
--
-- Change the prefix if required!
--

CREATE TABLE IF NOT EXISTS `phpbb_auto_a_config` (
  `config_id` tinyint(1) unsigned NOT NULL auto_increment,
  `enable` tinyint(3) unsigned NOT NULL default '0',
  `user_id` mediumint(8) unsigned NOT NULL default '2',
  `guests` tinyint(1) unsigned NOT NULL default '1',
  `multi_words` tinyint(1) unsigned NOT NULL default '0',
  `answer_edited` tinyint(1) unsigned NOT NULL default '0',
  `post_locked` tinyint(1) unsigned NOT NULL default '1',
  `post_normal` tinyint(1) unsigned NOT NULL default '1',
  `post_sticky` tinyint(1) unsigned NOT NULL default '1',
  `post_announce` tinyint(1) unsigned NOT NULL default '1',
  `post_global` tinyint(1) unsigned NOT NULL default '1',
  `no_answer` tinyint(1) unsigned NOT NULL default '0',
  `no_answer_word` varchar(255) default NULL,
  PRIMARY KEY  (`config_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Change the prefix if required!
--

INSERT INTO `phpbb_auto_a_config` (`config_id`, `enable`, `user_id`, `guests`, `multi_words`, `answer_edited`, `post_locked`, `post_normal`, `post_sticky`, `post_announce`, `post_global`, `no_answer`, `no_answer_word`) VALUES
(1, 1, 2, 1, 3, 0, 1, 1, 1, 1, 1, 0, 'nobot');

-- --------------------------------------------------------

--
-- Change the prefix if required!
--

CREATE TABLE IF NOT EXISTS `phpbb_auto_a_msgs` (
  `post_id` mediumint(8) unsigned NOT NULL auto_increment,
  `icon_id` mediumint(8) unsigned NOT NULL default '0',
  `enable_bbcode` tinyint(1) unsigned NOT NULL default '1',
  `enable_smilies` tinyint(1) unsigned NOT NULL default '1',
  `enable_magic_url` tinyint(1) unsigned NOT NULL default '1',
  `enable_sig` tinyint(1) unsigned NOT NULL default '1',
  `post_subject` varchar(100) character set utf8 collate utf8_unicode_ci NOT NULL,
  `post_text` mediumtext character set utf8 collate utf8_bin NOT NULL,
  `bbcode_uid` varchar(8) character set utf8 collate utf8_bin NOT NULL,
  `bbcode_bitfield` varchar(255) character set utf8 collate utf8_bin NOT NULL,
  `write_as` tinyint(1) unsigned NOT NULL default '1',
  `post_edit_locked` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`post_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Change the prefix if required!
--

CREATE TABLE IF NOT EXISTS `phpbb_auto_a_words` (
  `post_id` mediumint(8) unsigned NOT NULL,
  `word_text` varchar(255) NOT NULL,
  `word_type` tinyint(1) unsigned NOT NULL default '0',
  `word_match` tinyint(1) unsigned NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
]]></sql>

Code: Alles auswählen

ALTER TABLE `phpbb_forums` ADD `forum_auto_answer` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '1' AFTER `forum_status` ; 

CREATE TABLE IF NOT EXISTS `phpbb_auto_a_config` ( 
  `config_id` tinyint(1) unsigned NOT NULL auto_increment, 
  `enable` tinyint(3) unsigned NOT NULL default '0', 
  `user_id` mediumint(8) unsigned NOT NULL default '2', 
  `guests` tinyint(1) unsigned NOT NULL default '1', 
  `multi_words` tinyint(1) unsigned NOT NULL default '0', 
  `answer_edited` tinyint(1) unsigned NOT NULL default '0', 
  `post_locked` tinyint(1) unsigned NOT NULL default '1', 
  `post_normal` tinyint(1) unsigned NOT NULL default '1', 
  `post_sticky` tinyint(1) unsigned NOT NULL default '1', 
  `post_announce` tinyint(1) unsigned NOT NULL default '1', 
  `post_global` tinyint(1) unsigned NOT NULL default '1', 
  `no_answer` tinyint(1) unsigned NOT NULL default '0', 
  `no_answer_word` varchar(255) default NULL, 
  PRIMARY KEY  (`config_id`) 
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; 

INSERT INTO `phpbb_auto_a_config` (`config_id`, `enable`, `user_id`, `guests`, `multi_words`, `answer_edited`, `post_locked`, `post_normal`, `post_sticky`, `post_announce`, `post_global`, `no_answer`, `no_answer_word`) VALUES 
(1, 1, 2, 1, 3, 0, 1, 1, 1, 1, 1, 0, 'nobot'); 

CREATE TABLE IF NOT EXISTS `phpbb_auto_a_msgs` ( 
  `post_id` mediumint(8) unsigned NOT NULL auto_increment, 
  `icon_id` mediumint(8) unsigned NOT NULL default '0', 
  `enable_bbcode` tinyint(1) unsigned NOT NULL default '1', 
  `enable_smilies` tinyint(1) unsigned NOT NULL default '1', 
  `enable_magic_url` tinyint(1) unsigned NOT NULL default '1', 
  `enable_sig` tinyint(1) unsigned NOT NULL default '1', 
  `post_subject` varchar(100) character set utf8 collate utf8_unicode_ci NOT NULL, 
  `post_text` mediumtext character set utf8 collate utf8_bin NOT NULL, 
  `bbcode_uid` varchar(8) character set utf8 collate utf8_bin NOT NULL, 
  `bbcode_bitfield` varchar(255) character set utf8 collate utf8_bin NOT NULL, 
  `write_as` tinyint(1) unsigned NOT NULL default '1', 
  `post_edit_locked` tinyint(1) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`post_id`) 
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

CREATE TABLE IF NOT EXISTS `phpbb_auto_a_words` ( 
  `post_id` mediumint(8) unsigned NOT NULL, 
  `word_text` varchar(255) NOT NULL, 
  `word_type` tinyint(1) unsigned NOT NULL default '0', 
  `word_match` tinyint(1) unsigned NOT NULL default '0' 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Code: Alles auswählen

-- Change the prefix if required!