phpBB.de

/* 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_create_events', 1, 0, 0),
('u_calendar_edit_events', 1, 0, 0),
('u_calendar_delete_events', 1, 0, 0);

DROP TABLE IF EXISTS `phpbb_calendar_config`;
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');

DROP TABLE IF EXISTS `phpbb_calendar_event_types`;
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','','','');

DROP TABLE IF EXISTS `phpbb_calendar_events`;
CREATE TABLE IF NOT EXISTS `phpbb_calendar_events` (
  `event_id` int(10) 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,
  `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,
  PRIMARY KEY  (`event_id`)
);

As with any mod installation, be sure to save a backup copy of your database and your files. This is a complicated mod! If you miss a step, restoring your backup database and files is a fast way to get your board back up and running. Often by forcing yourself to go through the entire installation again you will find the step you missed and fix the problems yourself.

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

After you editing the SQL database and uploading the files you must:

1) Open templates/prosilver.xml and follow those instructions to install the required style changes. If you don't follow these, your calendar will not have a user interface.

2) Install the calendar modules in the ACP, set up the calendar permissions (make sure to give yourself permission to administrate the calendar) configure the calendar in the new ACP calendar modules.

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

Troubleshooting and tips to avoid problems:

1) If you have problems accessing the ACP modules after installation, be sure you purge your cache, and make sure you have given yourself calendar admin privileges.

2) The SQL commands provided assume you're using MySQL 41 for your database... if you're using something else like: Firebird, Mssql, MySQL40, Oracle, Postgres, or Sqlite you may have some difficulties (especially when declaring variables that hold foreign characters. See this post for more details:

http://www.phpbb.com/community/viewtopi ... 5#p3824905

One kind user posted their changes required for MSSQL 9 (2005) you will find them in the contrib folder. If you port the SQL commands to any other database type, please post them so we can add them to the contrib folder for the next release.

3) The sql commands assume you are using phpbb_ as your table prefix. If your table prefix is not phpbb_, you must edit the sql commands to match your table prefix before executing the sql commands. To find your table prefix open your root/config.php file and look for something like: $table_prefix = 'phpbb_';
For example, phpbb3_ is commonly used as the table prefix on a forum that was converted from phpbb2 to phpbb3. In this case you must find phpbb_ and replace it with phpbb3_ before running the sql commands.

4) If you have any problems with your permissions please run the following command in phpMyAdmin: select * from phpbb_acl_options where auth_option like '%calendar%'; If you see anything listed twice that's the source of your problem - you must remove all duplicate entries from that table and start over with setting up your permissions in the ACP. These duplicate entries were caused by running the SQL command on the acl_options table more then once.

5) If your calendar looks dark blue everywhere - instead of what you see in the demo, you haven't refreshed your style properly. Enter the ACP and go to the "Styles" tab and select "Templates" from the list of style components on the left. Find your style name in the list of installed templates, and click the link to "Refresh" your style's template. Confirm that "Yes" you really eant to clear the cached version of your template. Now select "Themes" from the list of style components on the left. Find your style name in the list of installed themes and click on the link to "Refresh" your style's theme. Confirm that "Yes" you really want to clear the cached version of your theme. Finally select "Imagesets" from the list of style componenets, and refresh your imageset. Now return to the general tab and click the "Run now" button next to where it says "Purge the cache". Now return to your calendar and refresh the page. I've seen internet explorer store stale copies of the calendar in my temporary interenet files before, so if all else fails, close all browser windows except for one, go to Tools->Internet Options, and on the "General" tab choose "Delete Files" to delete all of your cached web pages on your computer. Now return to the ACP (don't view the calendar yet) and refresh all the parts of the style and purge the cache again. Now return to the calendar, and things should look better.

6) If you don't see some of the icons in your calendar like you see in the demo, first make sure you've tried steps 4 and 5 above. Bad permissions will prevent icons from showing if you don't have permission to use them. Failing to refresh all the parts of your style may also prevent icon display.ere are some tips:
a) If you're not using english, be sure you uploaded the icons into the appropriate folder for your language. They are language specific, as the numerals displayed on the calendar icons are different in english and Chinese character sets.
b) If you can see all of the icons except for the star, then you probably don't really have permission to create new events - go back to troubleshooting step 4 and then go into your ACP->Permissions and select "View user-based permissions" at the bottom left. Now select your username from the list of users and click "View permissions". Click on the calendar tab and if you don't see a green background under the yes column for "Can create events" that's your problem. To see how your permission was calculated click on the circle with an arrow just to the left of where it says "Can create events". That will open a popup window which shows you exactly what permission settings you're using from what group - so you can figure out what you need to change.

7) Be careful when hand editing any of the files. You must use a proper text editor - especially one that supports UTF-8 formatting for the language files. If you have a simple white space before the starting <?php in a file you may see strange errors, so the white space and character encoding you get from your text editing program are very important. I believe notepad is a common cause of problems like these. Textpad is an inexpensive editor that you may find useful: http://www.textpad.com/ I've also heard that there is a free editor called notepad++ (not to be confused with notepad) that will work well if you specify the proper settings when saving the file.

Before installing this mod (at the very least) you MUST read all posts in the thread pertaining to this latest release. For example if the current release is 0.0.5, please search the thread for the first post with 0.0.5 in the subject, and read all of the posts through to the end of the thread. Why? If any bugs were reported in this release, I will post the fix as soon as it's available, so save yourself some trouble and look for bug fixes (if there are any) before you install this mod.

9) If you've finished reading all of these troubleshooting pages and are still lost, try searching for the answer on phpbb.com/community. If you return to the calendar topic here: http://www.phpbb.com/community/viewtopi ... &sk=t&sd=a be warned that the search box that says "Search this topic..." does NOT do what it implies. It will return everything outside of this topic making it almost impossible to find what you're looking for.

Here's a better way to find what your looking for. Go to the "Advanced Search" page here: http://www.phpbb.com/community/search.php Since "calendar" and "alightner" are in the subject of virtually every post in this thread, be sure to enter the following in your "Search for keywords:" calendar alightner whatever_you_are_looking_for. Also make sure to select "Search for all terms or use query as entered". That should help you find what you need.


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

Other notes:

This mod is NOT recommended for beginners, because it is still in development and will have many updates released.

Don't ask me what changed in this mod release from a previous mod release. It's in development and I don't have time to publish upgrade instructions. If you want to see what changed and you don't think the change list provides enough detail for what you're trying to find out download kdiff3 and use it to diff all of the files from your previously downloaded mod with the latest mod files. Kdiff3 can be found here: http://kdiff3.sourceforge.net/

Before posting any enhancement requests in the mod thread, please read the entire post thread - yes that means you'll have to read at least 100 pages, but I've had to read them all too (many times) so laziness is no excuse. It's likely someone has requested the same thing before, so please check before making a new request... it's polite and I appreciate it. Also if you post an enhancement request, and I don't respond - it does NOT mean that I didn't read your post. It means I'm considering it. I won't commit to new functionality if I don't know how long it will take to implement, so if you get a fast response, it's me saying "No I won't add that". If you want me to take your request seriously - you should give me time to think it over, and repeating your question makes you sound impatient and disrespectful... which means I'm less likely to fulfill your request. Simple manners will get you far.

• Du hast das Thema binnen weniger Minuten/Stunden mit einem Folgebeitrag nach oben geschoben.
  Die Mindestwartezeit für Topic Bumping beträgt 24 Stunden.
• Auch "intelligentes" Bumping ( Beitrag löschen und mit identischem Inhalt erneut posten ) fällt unter diese Regelung