Viewing file:  import_palmdesktop.php (2.11 KB) -rw-rw-rw-
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
// Parse the datebook file and return the data hash.
//
function parse_palmdesktop ($file, $exc_private = 1) {
$file = EscapeShellArg($file);
$exc_private = EscapeShellArg($exc_private);
exec ("perl tools/palm_datebook.pl $file $exc_private", $Entries);
$data = array ();
while ( list( $line_num, $line ) = each( $Entries ) ) {
$data[] = ParseLine($line);
}
return $data;
}
// Delete all Palm Events for $login to clear any events deleted in the palm
// Return 1 if success
function delete_palm_events($login) {
$res = dbi_query ( "SELECT cal_id FROM webcal_import_data " .
"WHERE cal_login = '$login' AND cal_import_type = 'palm'" );
if ( $res ) {
while ( $row = dbi_fetch_row ( $res ) ) {
dbi_query ( "DELETE FROM webcal_entry_user WHERE cal_id = $row[0]" );
dbi_query ( "DELETE FROM webcal_entry_repeats WHERE cal_id = $row[0]" );
dbi_query ( "DELETE FROM webcal_entry_repeats_not WHERE cal_id = $row[0]" );
dbi_query ( "DELETE FROM webcal_entry_log WHERE cal_entry_id = $row[0]" );
dbi_query ( "DELETE FROM webcal_site_extras WHERE cal_id = $row[0]" );
dbi_query ( "DELETE FROM webcal_reminder_log WHERE cal_id = $row[0]" );
dbi_query ( "DELETE FROM webcal_import_data WHERE cal_id = $row[0]" );
dbi_query ( "DELETE FROM webcal_entry WHERE cal_id = $row[0]" );
}
}
dbi_free_result ( $res );
return 1;
}
function ParseLine($line){
list(
$Entry['RecordID'],
$Entry['StartTime'],
$Entry['EndTime'],
$Entry['Summary'],
$Entry['Duration'],
$Entry['Description'],
$Entry['Untimed'],
$Entry['Private'],
$Entry['Category'],
$Entry['AlarmSet'],
$Entry['AlarmAdvanceAmount'],
$Entry['AlarmAdvanceType'],
$Entry['Repeat']['Interval'],
$Entry['Repeat']['Frequency'],
$Entry['Repeat']['EndTime'],
$Exceptions,
$Entry['Repeat']['RepeatDays'],
$WeekNum,
) = explode("|", $line);
if ($Exceptions) $Entry['Repeat']['Exceptions'] = explode(":",$Exceptions);
if (($WeekNum == '5') && ($Entry['Repeat']['Interval'] == '3')) $Entry['Repeat']['Interval'] = '6';
return $Entry;
}
?>
|