function DbQueryCalendars($qstart, $qend, $userId, $zonediff)
{
$db = db_connect();
$result = $db->query("SELECT * FROM calendar where StartTime<'{$qend}' and EndTime>'{$qstart}' and UPAccount='{$userId}' order by StartTime,EndTime");
$ret = array();
if ($result) {
//echo date("ymd",$row["StartTime"]);
//echo date("ymd",$row["EndTime"]);
foreach ($result as $row) {
$ret[] = array($row["Id"], $row["Subject"], TimeToJsonTime($row["StartTime"]), TimeToJsonTime($row["EndTime"]), $row["IsAlldayEvent"] ? 1 : 0, TimeToTimeStringFormat($row["StartTime"], "Ymd") == TimeToTimeStringFormat($row["EndTime"], "Ymd") ? 0 : 1, 1, $row["Category"] == "1" ? 1 : 0, 1, $row["Attendees"], $row["Location"]);
}
}
return $ret;
}
<?php
require_once 'includes/prefs.inc.php';
require_once 'includes/db.php';
$date = new DateTime();
$timestamp = $date->getTimestamp();
$dataformat = GetCalendarViewFormat("week", $timestamp);
$clientzone = 8;
$serverzone = TIMEZONE_INDEX;
$zonediff = $serverzone - $clientzone;
$qstart = $dataformat['start_date'] + $zonediff * 3600;
$qend = $dataformat['end_date'] + $zonediff * 3600;
$qstart = date("Y-m-d H:i:s", $qstart);
$qend = date("Y-m-d H:i:s", $qend);
$userid = GetClientIP();
$db = db_connect();
$result = $db->query("SELECT * FROM calendar where StartTime<'{$qend}' and EndTime>'{$qstart}' and UpAccount='{$userid}' order by StartTime,EndTime");
$ret = array();
echo " __CURRENTDATA=[";
if ($result) {
$i = 0;
foreach ($result as $row) {
if ($i > 0) {
echo ",";
}
echo "['{$row["Id"]}','{$row["Subject"]}'," . TimeToFullJsonTime($row["StartTime"]) . "," . TimeToFullJsonTime($row["EndTime"]) . "," . ($row["IsAllDayEvent"] ? 1 : 0) . "," . (TimeToTimeStringFormat($row["StartTime"], "Ymd") == TimeToTimeStringFormat($row["EndTime"], "Ymd") ? 0 : 1) . ",1," . ($row["Category"] == "1" ? 1 : 0) . ",1,'{$row["Attendees"]}','{$row["Location"]}']";
$i++;
}
}
echo "];\r\n";
//echo " __CURRENTDATA=".preg_replace("/\/(Date\([0-9-]+\))\//", "new \\1", $r).";";