Author Topic: RoundCube Calendar (jQuery Calendar)  (Read 76323 times)

Offline hantu

  • Newbie
  • *
  • Posts: 1
caldender plugin roundcubemail-0.2.1
« Reply #60 on: March 10, 2010, 03:18:46 AM »
Hi

I cannot figure out what went wrong when installing calendar plugin into roundcubemail-0.2.1

My OS
Centos 5.3
package used is iRedMail-0.5.1 released


here are my steps, anything missing?


Step1
I extracted the calender plugin into /var/www/roundcubemail/plugins/calendar

Step2
I updated mysql

mysql> use database roundcubemail;
mysql>  source /var/www/roundcubemail-0.2.1/plugins/calendar/SQL/mysql.sql
mysql> show tables;


Step3
I also added the following line for /var/www/roundcubemail/config/main.inc.php

$rcmail_config['plugins'] = array(
  "calendar"
  );

Step4
I restart Apache services

Note:
I also enable /var/www/roundcubemail/plugins/calendar/config/config.inc.php Should I do that?

In /var/www/roundcubemail/plugins/calendar/config/config.inc.php
// backend type (database)
$rcmail_config['backend'] = "database";

Should I change my database address?

Thanks
Lee

Offline lacri

  • Full Member
  • ***
  • Posts: 179
    • http://www.php-lexikon.de
RoundCube Calendar (jQuery Calendar)
« Reply #61 on: March 10, 2010, 04:31:58 AM »
hi hantu,

you need min roundcube 0.3 stable

roundcube 0.2.1 dont support plugins

the plugin api comes with roundcube 0.3.

i think roundcube 0.3.1 or the current svn version is better for jQuery Calendar.

best lacri

Offline voltron81

  • Jr. Member
  • **
  • Posts: 42
RoundCube Calendar (jQuery Calendar)
« Reply #62 on: March 19, 2010, 06:10:55 AM »
Hi guys,
I'm running roundcube 0.3.1 and I've installed the last version of this great plugin.

-I've put the folder in the /plugins folder
-I've added the SQL file (mysql -u roundcube -p roundcubemail < SQL/mysql.sql)
-I've edited the file /roundcube/plugins/calendar/config.inc.php, adding the name of the roundcube database and username and password
-I've renamed the file /roundcube/plugins/calendar/config/config.inc.php.dist to config.inc.php (I don't think I've to edit that file)

Now I'm entering in the webmail, I can see the Calendar, I can read the example events, but if I try to add a new one, it's just not memorized...
In can see that the events table in the database is empty...

Am I wrong in something?
Thanks

Michele

Offline voltron81

  • Jr. Member
  • **
  • Posts: 42
RoundCube Calendar (jQuery Calendar)
« Reply #63 on: March 19, 2010, 06:19:08 AM »
Sorry, my bad...

I edited the file /roundcube/plugins/calendar/config/config.inc.php, putting database instead of dummy and now it's working fine...

thanks a lot, great job

Michele

Offline v2mody

  • Newbie
  • *
  • Posts: 2
RoundCube Calendar (jQuery Calendar)
« Reply #64 on: March 22, 2010, 02:17:25 AM »
hi ,
i have used old version of that calendar before ,

however yesterday i tried the latest version , it didn't work untill i add this line from the old config file to the new one
$rcmail_config['use_calendar'] = 'calendar';
it was not exist in the new config file like the old one ??? odd
if i didn't add this line , i can't see the calendar icon on roundcube

just small comments on the new version
before if i select a meeting , there was a start and end date above
now only start date , can i possibly use the old method of showing for example 6-8 meeting instead of only starting date ?/

Offline brashquido

  • Newbie
  • *
  • Posts: 7
RoundCube Calendar (jQuery Calendar)
« Reply #65 on: March 29, 2010, 08:01:07 AM »
Thanks for the tip v2mody. adding that line worked for me on a 0.3.1 install using beta 2 of Calendar.

Offline strictlydata

  • Jr. Member
  • **
  • Posts: 36
Is there an issue with different skins?
« Reply #66 on: March 31, 2010, 02:38:29 PM »
Hi,

I am having an issue that the current skin is not being selected. It is always choosing the default skin.

Is there a bug?

Thanks

Offline strictlydata

  • Jr. Member
  • **
  • Posts: 36
The latest github version
« Reply #67 on: March 31, 2010, 03:06:23 PM »
This seems to have fixed the issue!

Offline zeta67

  • Newbie
  • *
  • Posts: 3
hungarian translation
« Reply #68 on: March 31, 2010, 03:24:48 PM »
hungarian translation

Offline poyo77

  • Newbie
  • *
  • Posts: 1
RoundCube Calendar (jQuery Calendar)
« Reply #69 on: April 02, 2010, 11:29:30 AM »
Hello,
I'm French, so I speak a poor english... Sorry.

I've got a CalDav server (Davical) with many users in it...

How to configure calendar plugin to access all User's calendar?

Note: Calendar plugin works so fine with one user.

thanks for your help.

Poyo77

Offline tjm74

  • Jr. Member
  • **
  • Posts: 10
Daylight Saving bug
« Reply #70 on: April 06, 2010, 04:49:53 PM »
Quote from: rosali;25008
solved

use that:
Code: [Select]

  function get_events()
  {
    $rcmail = rcmail::get_instance();

    $tz = isset($_SESSION['timezone']) ? $_SESSION['timezone'] : date('Z')/3600;


mmm, not quite.  This shifts all events that are not in the current timezone off by one hour -- so if it's july (during daylight saving time) and you're looking back at what happened in january (during which we observed standard time), or vice versa, events look fine in your current month but they are off by an hour during the months where the other tz was observed.

I have a fix, it's not pretty but it works better.  I even try to determine whether DST is not observed where you are (or at least, where the server is, which is usually a good indication).

1. fix toGMT

Code: [Select]

  function toGMT($time) {
    $gmt_offset = date('Z');

    // current gmt offset may not match event's gmt offset
    // adjust accordingly
    if (date('I') && !date('I',$time)) {
      $gmt_offset -= 3600;
    } else if (!date('I') && date('I',$time)) {
      $gmt_offset += 3600;
    }

    return date('Y-m-d H:i:s',$time - $gmt_offset);
  }


2. fix getEvents (in database.php)
Code: [Select]

  public function getEvents($start, $end) {
    if (!empty($this->rcmail->user->ID)) {

      /* This was completely wrong -- the question is whether to adjust
         the EVENT's time for DST.
         Whether we are CURRENTLY observing DST is not really the issue.
         The question is (A) does the user observe DST? and if so,
         (B) does THIS EVENT fall on the calendar during DST or STD time?
      */

      if ($this->rcmail->config->get('timezone') === "auto") {
        $auto = TRUE;
        $tz = isset($_SESSION['timezone']) ? $_SESSION['timezone'] : date('Z')/3600;
      } else {
        $auto = FALSE;
        $tz = $this->rcmail->config->get('timezone');
        if($this->rcmail->config->get('dst_active')) {
          $dst_active = TRUE;
          $tz++;
        }
      }

      if (date('I') || (!$auto && $dst_active)) {
        $tz_std = $tz - 1;
        $tz_dst = $tz;
      } else {
        $tz_std = $tz;
        $tz_dst = $tz + 1;
      }

      // Server does not observe DST?  Then most likely the user doesn't either.
      if (($auto || !$dst_active) && !date('I',mktime(0,0,0,7,1,2010))) {
        // no DST adjustment
        $tz_std = $tz;
        $tz_dst = $tz;
      }

      $result = $this->rcmail->db->query(
        "SELECT * FROM events
         WHERE user_id=?",
         $this->rcmail->user->ID
       );

      $events = array();
      while ($result && ($event = $this->rcmail->db->fetch_assoc($result))) {
        $event['start'] = strtotime($event['start']);
        $event['end'] = strtotime($event['end']);

        // is/was the EVENT during daylight saving time?
        if (date('I',$event['start'] + $tz * 3600)) {
          $event['start'] += $tz_dst * 3600;
          $event['end'] += $tz_dst * 3600;
        } else {
          $event['start'] += $tz_std * 3600;
          $event['end'] += $tz_std * 3600;
        }

        $events[]=array(
          'id'    => $event['event_id'],
          'start' => date('c', $event['start']),
          'end'   => date('c', $event['end']),
          'title' => $event['summary'],
          'description'  => $event['description'],
          'className'  => $event['category'],
          'allDay'=> ($event['all_day'] == 1)?true:false,
        );
      }

      return json_encode($events);
    }
  }


Offline rosali

  • Hero Member
  • *****
  • Posts: 2,533
RoundCube Calendar (jQuery Calendar)
« Reply #71 on: April 24, 2010, 04:46:21 AM »
Hmmm... works for me. Which browser?
Regards,
Rosali
__________________
MyRoundcube Project (commercial)

Offline katie

  • Newbie
  • *
  • Posts: 5
RoundCube Calendar (jQuery Calendar)
« Reply #72 on: May 02, 2010, 04:30:43 PM »
Quote from: Blueyed1;27098
Hi Katie

Did you ever get it to work?? RC with calendar on postgresSQL ?

/Blueyed1


No.

Makes no sense to hack around at this state.

Any Ideas?

Offline Blueyed1

  • Newbie
  • *
  • Posts: 3
RoundCube Calendar (jQuery Calendar)
« Reply #73 on: May 05, 2010, 03:30:41 AM »
Quote from: katie;27206
No.

Makes no sense to hack around at this state.

Any Ideas?


It's a pitty that it dosn't work with postgreSQL... I managed to get some tables in the postgreSQL db and I can see/edit them with phpPgAdmin. But I don't know if the tables are correct or what else I need to do. Look at screenshots below.









/Blueyed1
« Last Edit: May 05, 2010, 01:37:56 PM by Blueyed1 »

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
RoundCube Calendar (jQuery Calendar)
« Reply #74 on: May 05, 2010, 09:49:48 AM »
Assuming the database is setup correctly you would need to edit the sql querys that are going to the database that are in the main plugin file.