phpBB.de

Code: Alles auswählen

// INSTALL latest version
	// If you have problems with this install script, insert this into db manually
	$sql_array = array(
		'DROP TABLE IF EXISTS ' . SFNC_FEEDS,
		'CREATE TABLE ' . SFNC_FEEDS . ' (
			id int(11) NOT NULL AUTO_INCREMENT,
			feed_name varchar(255) NOT NULL DEFAULT \'\',
			url varchar(255) NOT NULL DEFAULT \'\',
			feed_type varchar(10) NOT NULL DEFAULT \'\',
			next_update varchar(10) NOT NULL DEFAULT \'0\',
			last_update int(10) NOT NULL DEFAULT \'0\',
			available_feed_attributes varchar(255) NOT NULL DEFAULT \'\',
			available_item_attributes varchar(255) NOT NULL DEFAULT \'\',
			encoding varchar(255) NOT NULL DEFAULT \'\',
			refresh_after varchar(5) COLLATE utf8_bin NOT NULL DEFAULT \'3600\',
			template_for_displaying varchar(255) NOT NULL DEFAULT \'\',
			template_for_posting varchar(255) NOT NULL DEFAULT \'\',
			poster_id int(5) NOT NULL DEFAULT \'0\',
			poster_forum_destination_id int(5) NOT NULL DEFAULT \'0\',
			poster_topic_destination_id int(5) NOT NULL DEFAULT \'0\',
			posting_limit int(2) NOT NULL DEFAULT \'1\',
			enabled_posting int(1) NOT NULL DEFAULT \'0\',
			enabled_displaying int(1) NOT NULL DEFAULT \'0\',
			PRIMARY KEY (id)
		);',
		// I've decided to skip the default feed, because the settings can be faulty on not vanilla boards ...
//		'INSERT INTO ' . SFNC_FEEDS . ' (id, feed_name, url, feed_type, next_update, last_update, available_feed_attributes, available_item_attributes, encoding, refresh_after, template_for_displaying, template_for_posting, poster_id, poster_forum_destination_id, poster_topic_destination_id, posting_limit, enabled_posting, enabled_displaying) VALUES (NULL, \'phpBB.com\', \'http://www.phpbb.com/community/feed.php?mode=news\', \'atom\', \'0\', \'0\', \'\', \'\', \'utf-8\', \'7200\', \'\', \'\', \'2\', \'2\', \'0\', \'5\', \'1\', \'0\');',
		'INSERT INTO ' . CONFIG_TABLE . ' VALUES (\'sfnc_download_function\', \''.$default_function.'\', \'0\');',
		'INSERT INTO ' . CONFIG_TABLE . ' VALUES (\'sfnc_cron_init\', \'0\', \'1\');',
		'INSERT INTO ' . CONFIG_TABLE . ' VALUES (\'sfnc_cron_posting\', \'0\', \'1\');',
		'INSERT INTO ' . CONFIG_TABLE . ' VALUES (\'sfnc_index_init\', \'0\', \'1\');',
		'INSERT INTO ' . CONFIG_TABLE . ' VALUES (\'sfnc_index_posting\', \'0\', \'1\');',
		'INSERT INTO ' . CONFIG_TABLE . ' VALUES (\'sfnc_version\', \'' . $version . '\', \'0\');',
	);
}