| Server IP : 94.23.64.18 / Your IP :
216.73.216.185 [
Web Server : Apache System : Linux webm005.cluster107.gra.hosting.ovh.net 5.15.167-ovh-vps-grsec-zfs-classid #1 SMP Tue Sep 17 08:14:20 UTC 2024 x86_64 User : villadal ( 6036) PHP Version : 7.4.33 Disable Function : _dyuweyrj4,_dyuweyrj4r,dl Domains : 2 Domains MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/villadal/www/old/booked/Web/ |
Upload File : |
<?php
/**
Copyright 2012-2014 Alois Schloegl, IST Austria
This file is part of Booked Scheduler.
Booked Scheduler is free software: you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.
Booked Scheduler is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with Booked Scheduler. If not, see <http://www.gnu.org/licenses/>.
*/
die('To use this file, please remove this line from source');
require_once('../config/config.php');
## use parameters in config/config
$url = $conf['settings']['script.url'];
$hostname = $conf['settings']['database']['hostspec'];
$username = $conf['settings']['database']['user'];
$password = $conf['settings']['database']['password'];
$database = $conf['settings']['database']['name'];
$icskey = $conf['settings']['ics']['subscription.key'];
$tab = ' ';
header("Exported calendars of Booked Scheduler");
echo '<H1>Exported calendars of <a href="',$url,'">Booked Scheduler</a></H1>';
echo 'Which calendar client are you using ?<br>';
foreach (array("Outlook","Mozilla") as $client) {
echo $tab.'<a href="'.$url.'/'.basename($_SERVER['SCRIPT_NAME']).'?client='.$client.'">'.$client.'</a><br>';
}
/*
Client specific usage description
*/
if ( ( isset($_GET["outlook"]) && $_GET["outlook"] )
|| ( isset($_GET["win"]) && $_GET["win"] )
|| ( isset($_GET["client"]) && $_GET["client"]=='Outlook' )
)
{
$url=preg_replace('(^http)m','webcal',$url);
echo '<H2>HowTo use with Outlook</H2>';
echo '<pre>Double click on link below to start calendar import into Outlook</pre>';
}
else
{
echo '<H2>HowTo use with Mozilla</H2>';
echo '<pre> Mozilla -> Menu File -> New Calendar -> <br>';
echo ' ->"Select: On The Network" -> Next<br>';
echo ' -> Select: iCalendar (ICS), Location: URL starting with https://... ->Next<br>';
echo ' -> Name: (it\'s recommended to use the name listed below)</pre>';
}
// Open data base connection
$link = mysql_connect( $hostname, $username, $password);
#mysql_select_db($database);
if (!$link) {
die('Could not connect: ' . mysql_error());
}
// Get Urls for Schedule calendars
echo "<H3>URLs for all schedules and resources </H3>";
echo '<table border="0"><tr><td><b>Schedules, resources</b></td><td><b>contact, email</b></td></tr>';
$schedule = mysql_query('SELECT public_id, name, schedule_id AS id, allow_calendar_subscription FROM '.$database.'.schedules ORDER BY name ');
while ($srow = mysql_fetch_assoc($schedule)) {
$sid = $srow['public_id'];
$name = $srow['name'];
echo '<tr><td><b>';
if ($srow['allow_calendar_subscription'] && $sid)
{
echo '<a href="',$url,'/export/ical-subscribe.php?uid=&sid=',$sid,'&rid=&icskey=',$icskey,'">',$name,'</a>';
}
else
{
echo $name;
}
echo '</b></td></tr>';
// Get Urls for resource calendars
$result = mysql_query('SELECT public_id, name, contact_info, allow_calendar_subscription FROM '.$database.'.resources WHERE schedule_id = '.mysql_real_escape_string($srow['id']).' ORDER BY name ');
while ($rrow = mysql_fetch_assoc($result)) {
$rid = $rrow['public_id'];
$name = $rrow['name'];
$contact = $rrow['contact_info'];
if ($rrow['allow_calendar_subscription'] && $rid)
{
echo '<tr><td>',$tab,'<a href="',$url,'/export/ical-subscribe.php?uid=&sid=&rid=',$rid,'&icskey=',$icskey,'">',$name,'</a></td>';
if ( preg_match('/^[a-z0-9!#$%&\'*+\/\=?^_\`{|}~-]+(?:\.[a-z0-9!#\$%&\'*+\/\=?^_\`{|}~-]+)*@(?:[a-z0-9](?:[a-z0-9-]*[a-z0-9])?\.)+[a-z0-9](?:[a-z0-9-]*[a-z0-9])?$/i',$contact) )
{
/*
matches valid email addresses according to RFC 2822
see also http://www.regular-expressions.info/email.html
*/
echo '<td><a href="mailto:',$contact,'">',$contact,'</a></td>';
}
else
{
echo '<td>',$contact,'</td>';
}
}
else
{
echo '<tr><td>',$tab,$name,'</td>';
}
echo '</tr>';
}
}
echo '</table>';
echo "<H3>URLs for accessories </H3>";
$result = mysql_query('SELECT accessory_name FROM '.$database.'.accessories');
while ($row = mysql_fetch_assoc($result)) {
echo '<a href="',$url,'/export/ical-subscribe.php?uid=&sid=&rid=&aid=',$row['accessory_name'],'&icskey=',$icskey,'">',$row['accessory_name'].'</a><br>';
}
// get Urls for resource calendars
### TODO: this is specific to IST Austria, its generic use should be documented somewhere else.
echo "<H3>Accessory calendars (combined)</H3>";
foreach (array("IT__%","Announce%","Catering%","Tech%") as $cal) {
echo '<a href="',$url,'/export/ical-subscribe.php?uid=&sid=&rid=&aid=',$cal,'&icskey=',$icskey,'">',$cal,'</a><br>';
}
// Free the resources associated with the result set
// This is done automatically at the end of the script
mysql_free_result($schedule);
mysql_free_result($result);
mysql_close($link);
?>