ich habe ja schon einige Mods installiert, aber an den "phpBB Calendar 0.1.0 (alightner)" traue ich mich irgendwie nicht heran. Hier muss man, wie Ihr sicher wisst, in der Datenbank Änderungen vornehmen. Aber wie mache ich das? Die Installationsanleitung schreibt dazu ja:
Code: Alles auswählen
/* WARNING: do NOT execute the SQL commands on the phpbb_acl_options table more
than once if you're upgrading or trying to repair a previous installation of the calendar mod.
Executing this command more than once will add duplicate entries to the table
breaking your current permissions and causing the calendar to malfunction */
INSERT INTO phpbb_acl_options (auth_option, is_global, is_local, founder_only) VALUES ('a_calendar', 1, 0, 0),
('m_calendar_edit_other_users_events', 1, 0, 0),
('m_calendar_delete_other_users_events', 1, 0, 0),
('u_calendar_view_events', 1, 0, 0),
('u_calendar_edit_events', 1, 0, 0),
('u_calendar_delete_events', 1, 0, 0),
('u_calendar_create_public_events', 1, 0, 0),
('u_calendar_create_group_events', 1, 0, 0),
('u_calendar_create_private_events', 1, 0, 0),
('u_calendar_nonmember_groups', 1, 0, 0),
('u_calendar_track_rsvps', 1, 0, 0),
('u_calendar_allow_guests', 1, 0, 0),
('u_calendar_view_headcount', 1, 0, 0),
('u_calendar_view_detailed_rsvps', 1, 0, 0),
('u_calendar_create_recurring_events', 1, 0, 0),
('m_calendar_edit_other_users_rsvps', 1, 0, 0);
CREATE TABLE IF NOT EXISTS `phpbb_calendar_config` (
`config_name` varchar(255) NOT NULL,
`config_value` varchar(255) NOT NULL
);
INSERT INTO `phpbb_calendar_config` (`config_name`, `config_value`) VALUES
('first_day_of_week', '0'),
('index_display_week', '0'),
('index_display_next_events', '5'),
('hour_mode', '12'),
('display_truncated_name', '0'),
('prune_frequency', '0'),
('last_prune', '0'),
('prune_limit', '2592000'),
('display_hidden_groups', '0'),
('time_format','h:i a'),
('date_format','M d, Y'),
('date_time_format','M d, Y h:i a'),
('disp_events_only_on_start','0'),
('populate_frequency','86400'),
('last_populate','0'),
('populate_limit','2592000');
CREATE TABLE IF NOT EXISTS `phpbb_calendar_event_types` (
`etype_id` tinyint(3) unsigned NOT NULL auto_increment,
`etype_index` tinyint(3) unsigned NOT NULL default '0',
`etype_full_name` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '',
`etype_display_name` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '',
`etype_color` varchar(6) character set utf8 collate utf8_bin NOT NULL default '',
`etype_image` varchar(255) NOT NULL,
PRIMARY KEY (`etype_id`)
);
INSERT INTO `phpbb_calendar_event_types` (`etype_id`,`etype_index`,`etype_full_name`,`etype_display_name`,`etype_color`,`etype_image`) VALUES
(1,1,'Generic Event','','','');
CREATE TABLE IF NOT EXISTS `phpbb_calendar_events` (
`event_id` mediumint(8) unsigned NOT NULL auto_increment,
`etype_id` tinyint(4) NOT NULL,
`sort_timestamp` bigint(20) unsigned NOT NULL,
`event_start_time` bigint(20) unsigned NOT NULL,
`event_end_time` bigint(20) unsigned NOT NULL,
`event_all_day` tinyint(2) NOT NULL default '0',
`event_day` varchar(10) character set utf8 collate utf8_bin NOT NULL default '',
`event_subject` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '',
`event_body` longblob NOT NULL,
`poster_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
`event_access_level` tinyint(1) NOT NULL default '0',
`group_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
`group_id_list` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default ',',
`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',
`bbcode_bitfield` varchar(255) character set utf8 collate utf8_bin NOT NULL default '',
`bbcode_uid` varchar(8) character set utf8 collate utf8_bin NOT NULL,
`track_rsvps` tinyint(1) unsigned NOT NULL default '0',
`allow_guests` tinyint(1) unsigned NOT NULL default '0',
`rsvp_yes` mediumint(8) unsigned NOT NULL default '0',
`rsvp_no` mediumint(8) unsigned NOT NULL default '0',
`rsvp_maybe` mediumint(8) unsigned NOT NULL default '0',
`recurr_id` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`event_id`)
);
CREATE TABLE IF NOT EXISTS `phpbb_calendar_recurring_events` (
`recurr_id` mediumint(8) unsigned NOT NULL auto_increment,
`etype_id` tinyint(4) NOT NULL,
`frequency` tinyint(4) NOT NULL default '1',
`frequency_type` tinyint(4) NOT NULL default '0',
`first_occ_time` bigint(20) unsigned NOT NULL,
`final_occ_time` bigint(20) unsigned NOT NULL,
`event_all_day` tinyint(2) NOT NULL default '0',
`event_duration` bigint(20) unsigned NOT NULL,
`week_index` tinyint(2) NOT NULL default '0',
`first_day_of_week` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
`last_calc_time` bigint(20) unsigned NOT NULL,
`next_calc_time` bigint(20) unsigned NOT NULL,
`event_subject` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '',
`event_body` longblob NOT NULL,
`poster_id` mediumint(8) unsigned NOT NULL default '0',
`poster_timezone` decimal(5,2) NOT NULL default '0.00',
`poster_dst` tinyint(1) unsigned NOT NULL default '0',
`event_access_level` tinyint(1) NOT NULL default '0',
`group_id` mediumint(8) unsigned NOT NULL default '0',
`group_id_list` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default ',',
`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',
`bbcode_bitfield` varchar(255) character set utf8 collate utf8_bin NOT NULL default '',
`bbcode_uid` varchar(8) character set utf8 collate utf8_bin NOT NULL,
`track_rsvps` tinyint(1) unsigned NOT NULL default '0',
`allow_guests` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`recurr_id`)
);
CREATE TABLE IF NOT EXISTS `phpbb_calendar_rsvps` (
`rsvp_id` mediumint(8) unsigned NOT NULL auto_increment,
`event_id` mediumint(8) unsigned NOT NULL default '0',
`poster_id` mediumint(8) unsigned NOT NULL default '0',
`poster_name` varchar(255) collate utf8_bin NOT NULL default '',
`poster_colour` varchar(6) collate utf8_bin NOT NULL default '',
`poster_ip` varchar(40) collate utf8_bin NOT NULL default '',
`post_time` int(11) unsigned NOT NULL default '0',
`rsvp_val` tinyint(1) unsigned NOT NULL default '0',
`rsvp_count` smallint(4) unsigned NOT NULL default '1',
`rsvp_detail` mediumtext collate utf8_bin NOT NULL,
`bbcode_bitfield` varchar(255) collate utf8_bin NOT NULL default '',
`bbcode_uid` varchar(8) collate utf8_bin NOT NULL,
`bbcode_options` tinyint(1) unsigned NOT NULL default '7',
PRIMARY KEY (`rsvp_id`),
KEY `event_id` (`event_id`),
KEY `poster_id` (`poster_id`),
KEY `eid_post_time` (`event_id`,`post_time`)
);
CREATE TABLE IF NOT EXISTS `phpbb_calendar_events_watch` (
`event_id` mediumint(8) unsigned NOT NULL default '0',
`user_id` mediumint(8) unsigned NOT NULL default '0',
`notify_status` tinyint(1) unsigned NOT NULL default '0',
`track_replies` tinyint(1) unsigned NOT NULL default '0',
KEY `event_id` (`event_id`),
KEY `user_id` (`user_id`),
KEY `notify_stat` (`notify_status`)
);
CREATE TABLE IF NOT EXISTS `phpbb_calendar_watch` (
`user_id` mediumint(8) unsigned NOT NULL default '0',
`notify_status` tinyint(1) unsigned NOT NULL default '0',
KEY `user_id` (`user_id`),
KEY `notify_stat` (`notify_status`)
);
Einfacher wäre es natürlich, den Google Kalender einzufügen. Müsste ich dafür dann einfach eine neue leere Seite erstellen (http://www.phpbb.com/kb/article/add-a-n ... -to-phpbb/) und dann den Kalender über die iframe Option einbetten (Google Code auf Kalender Seite in Bereich Einstellung:
Code: Alles auswählen
<iframe src="https://www.google.com/calendar/embed?src=....></iframe>Wäre irgendwie besser, denke ich, denn ich könnte die Termine dann immer vor Ort einfach in meinen Google Kalender per Android Handy eingeben und sie würden beim Neuladen der Seite ja dann durch den Abruf des veröffentlichten Google Kalenders sofort angezeigt.
Ist iframe noch zeitgemäß?
Grüße Henning
