/**
* Output list of upcoming events for the location.
* @since 2.0.0
* @version 2.0.0
* @param integer $limit [optional] Event List Size (Default:5)
* @return void
*/
function location_events($limit = 5)
{
global $lID, $hc_cfg, $hc_lang_core, $hc_lang_locations;
$result = doQuery("SELECT PkID, Title, StartDate, StartTime, EndTime, TBD\r\n\t\t\t\t\t\tFROM " . HC_TblPrefix . "events \r\n\t\t\t\t\t\t\tWHERE IsActive = 1 AND IsApproved = 1 AND LocID = '" . cIn($lID) . "' AND StartDate >= '" . cIn(SYSDATE) . "'\r\n\t\t\t\t\t\tORDER BY StartDate, TBD, StartTime, Title\r\n\t\t\t\t\t\tLIMIT " . cIn($limit));
if (!hasRows($result)) {
echo '<p>' . $hc_lang_locations['NoEvents'] . ' <a href="' . CalRoot . '/index.php?com=submit" rel="nofollow">' . $hc_lang_locations['NoEventsLink'] . '</a></p>';
return 0;
}
$cnt = $date = 0;
while ($row = mysql_fetch_row($result)) {
if ($date != $row[2]) {
$date = $row[2];
echo $cnt > 0 ? '
</ul>' : '';
echo '
<header>' . stampToDate($row[2], $hc_cfg[14]) . '</header>
<ul>';
$cnt = 1;
}
$hl = $cnt % 2 == 0 ? ' class="hl"' : '';
if ($row[5] == 0) {
$time = $row[3] != '' ? stampToDate($row[3], $hc_cfg[23]) : '';
$time .= $row[4] != '' ? ' - ' . stampToDate($row[4], $hc_cfg[23]) : '';
$stamp = date("Y-m-d\\Th:i:00", strtotime($row[2] . trim(' ' . $row[3]))) . HCTZ;
} else {
$time = $row[5] == 1 ? $hc_lang_locations['AllDay'] : $hc_lang_locations['TBA'];
$stamp = date("Y-m-d", strtotime($row[2]));
}
echo '
<li' . $hl . ' itemscope itemtype="http://schema.org/Event"><time itemprop="startDate" datetime="' . $stamp . '">' . $time . '</time><a itemprop="url" href="' . CalRoot . '/index.php?eID=' . $row[0] . '"><span itemprop="name">' . cOut($row[1]) . '</span></a></li>';
++$cnt;
}
echo '</ul>';
}
/**
* Output weekly dashboard to a page outside of Helios Calendar.
* @since 2.0.1
* @version 2.0.1
* @param binary $submit include submit event link, 0 = hide , 1 = show (Default:1)
* @param binary $ical include iCalendar subscription link, 0 = hide, 1 = show (Default:1)
* @param binary $rss include All Events rss feed link, 0 = hide, 1 = show (Default:1)
* @param binary $end_time include end time in event lists, 0 = hide, 1 = show (Default:1)
* @param string $menu_format menu format string, accepts any supported strftime() format parameters (Default:%a %m/%d)
* @return void
*/
function ou_event_carousel($submit = 1, $ical = 1, $rss = 1, $end_time = 1, $menu_format = '%a %m/%d')
{
global $hc_cfg, $hc_lang_core;
include HCLANG . '/public/integration.php';
echo "SYSDATE: " . SYSDATE . "\n";
if (file_exists(HCPATH . '/cache/int14_' . SYSDATE . '.php')) {
if (count(glob(HCPATH . '/cache/int14_*.php')) > 0) {
foreach (glob(HCPATH . '/cache/int14_*.php') as $file) {
unlink($file);
}
}
ob_start();
$fp = fopen(HCPATH . '/cache/int14_' . SYSDATE . '.php', 'w');
fwrite($fp, "<?php\n//\tHelios Dashboard Integration Events Cache - Delete this file when upgrading.\n");
//link, category, title, start date, end date, start time, end time, location, description
//array("05/15/2015 - 05/15/2015","1","test event")
$result = doQuery("SELECT PkID, Title, Description, StartDate, EndDate, StartTime, EndTime, TBD, LocID, LocationName FROM " . HC_TblPrefix . "events\nWHERE IsActive = 1 AND IsApproved = 1 AND StartDate Between '" . SYSDATE . "' AND ADDDATE('" . SYSDATE . "', INTERVAL 14 DAY)\nORDER BY StartDate, TBD, StartTime, Title, LocationName");
if (hasRows($result)) {
$cur_day = -1;
$cur_date = '';
fwrite($fp, "\$hc_next14 = array(\n");
while ($row = mysql_fetch_row($result)) {
print_r($row);
$ouTitle = $row[1];
$ouDesc = $row[2];
$ouLoc = $row[7];
//echo "\nouLoc: " . $ouLoc;
if ($cur_date = $row[3]) {
++$cur_day;
$cur_date = $row[3];
if ($cur_day > 0) {
fwrite($fp, "\t),\n");
}
fwrite($fp, $cur_day . " => array(\n");
}
if ($row[6] == 0) {
$time = $row[4] != '' ? stampToDate($row[4], $hc_cfg[24]) : '';
$time .= $row[5] != '' && $end_time == 1 ? ' - ' . stampToDate($row[5], $hc_cfg[24]) : '';
} else {
$time = $row[6] == 1 ? $hc_lang_int['AllDay'] : $hc_lang_int['TimeTBA'];
}
fwrite($fp, "\t" . $row[0] . " => array(\"" . $time . "\",\"" . stampToDate($row[3], $hc_cfg[15]) . "\",\"" . str_replace("\"", "'", cOut($row[1])) . "\"),\n");
}
fwrite($fp, "\t),");
}
fwrite($fp, "\n)\n?>");
fwrite($fp, ob_get_contents());
fclose($fp);
ob_end_clean();
}
include HCPATH . '/cache/int14_' . SYSDATE . '.php';
}
/**
* Output an event list. Writes list cache file if not currently available.
* @since 2.0.0
* @version 2.0.2
* @param integer $type list to output, 0 = Billboard Events, 1 = Most Popular Events, 2 = Newest Events (Default:0)
* @param integer $eTime [optional] 0 = do NOT include end time, 1 = include end time in list (Default:0)
* @return void
*/
function event_list($type = 0, $eTime = 0)
{
global $hc_cfg, $hc_lang_event;
$bQuery = $uQuery = '';
switch ($type) {
case 0:
$cf = 'list' . SYSDATE . '_0';
$noList = $hc_lang_event['NoBillboard'];
$sQuery = 'e.PkID, e.Title, e.StartDate, e.StartTime, e.IsBillboard, e.SeriesID, e.TBD, e.EndTime';
$bQuery = $hc_cfg[13] == 0 ? ' AND e.IsBillboard = 1 ' : '';
$oQuery = ' ORDER BY IsBillboard DESC, StartDate, StartTime, Title LIMIT ' . $hc_cfg[12];
break;
case 1:
$cf = 'list' . SYSDATE . '_1';
$noList = $hc_lang_event['NoPopular'];
$sQuery = 'e.PkID, e.Title, e.StartDate, e.StartTime, e.IsBillboard, e.SeriesID, e.TBD, e.EndTime, (e.Views / (DATEDIFF(\'' . SYSDATE . '\', e.PublishDate)+1)) as Ave';
$oQuery = ' ORDER BY AVE DESC, StartDate LIMIT ' . $hc_cfg[10];
break;
case 2:
$cf = 'list' . SYSDATE . '_2';
$noList = $hc_lang_event['NoNewest'];
$sQuery = 'e.PkID, e.Title, e.StartDate, e.StartTime, e.IsBillboard, e.SeriesID, e.TBD, e.EndTime, e.PublishDate';
$oQuery = ' ORDER BY PublishDate DESC, StartDate LIMIT ' . $hc_cfg[66];
break;
default:
return 0;
}
if (!file_exists(HCPATH . '/cache/' . $cf)) {
purge_cache_list($type);
ob_start();
$fp = fopen(HCPATH . '/cache/' . $cf, 'w');
$uQuery = $hc_cfg[33] == 0 ? " AND SeriesID IS NULL \r\n\t\t\t\t\tUNION \r\n\t\t\t\t\tSELECT " . $sQuery . " FROM " . HC_TblPrefix . "events e\r\n\t\t\t\t\t\tLEFT JOIN " . HC_TblPrefix . "events e2 ON (e.SeriesID = e2.SeriesID AND e2.StartDate > '" . SYSDATE . "' AND e.StartDate > e2.StartDate)\r\n\t\t\t\t\tWHERE\r\n\t\t\t\t\t\te2.StartDate IS NULL AND \r\n\t\t\t\t\t\te.IsActive = 1 AND e.IsApproved = 1 AND e.StartDate >= '" . SYSDATE . "' AND e.SeriesID IS NOT NULL " . $bQuery . "\r\n\t\t\t\t\tGROUP BY e.SeriesID, e.PkID, e.Title, e.StartDate, e.StartTime, e.EndTime, e.TBD, e.IsBillboard, e.Views, e.PublishDate" : '';
$curDate = $cnt = 0;
$showHeader = $type == 0 ? 0 : 1;
$result = doQuery("SELECT " . $sQuery . " FROM " . HC_TblPrefix . "events e WHERE e.IsActive = 1 AND e.IsApproved = 1 AND e.StartDate >= '" . cIn(SYSDATE) . "'" . $bQuery . $uQuery . $oQuery);
if (!hasRows($result)) {
echo $noList;
} else {
echo '
<ul>';
while ($row = mysql_fetch_row($result)) {
if ($row[4] == 0 && $showHeader == 0) {
$showHeader = 1;
echo '
<li class="upcoming">' . $hc_lang_event['Upcoming'] . '</li>';
}
if ($curDate != $row[2]) {
$curDate = $row[2];
echo '
<li class="date">' . stampToDate($row[2], $hc_cfg[14]) . '</li>';
}
if ($row[6] == 0 && $hc_cfg[15] == 1) {
$time = $row[3] != '' ? stampToDate($row[3], $hc_cfg[23]) : '';
$time .= $eTime == 1 && $row[7] != '' ? ' - ' . stampToDate($row[7], $hc_cfg[23]) : '';
} elseif ($row[6] > 0 && $hc_cfg[15] == 1) {
$time = $row[6] == 1 ? $hc_lang_event['AllDay'] : $hc_lang_event['TBA'];
}
echo '
<li><a href="' . CalRoot . '/index.php?eID=' . $row[0] . '">' . cOut($row[1]) . '</a> ' . $time . '</li>';
++$cnt;
}
echo '
</ul>';
}
fwrite($fp, ob_get_contents());
fclose($fp);
ob_end_clean();
}
include HCPATH . '/cache/' . $cf;
}
echo '
<ul class="data">
<li class="row header uline">
<div style="width:30%;">' . $hc_lang_admin['Name'] . '</div>
<div style="width:40%;">' . $hc_lang_admin['EmailLabel'] . '</div>
<div style="width:20%;">' . $hc_lang_admin['Login'] . '</div>
<div style="width:10%;"> </div>
</li>';
$cnt = 0;
while ($row = mysql_fetch_row($result)) {
$hl = $cnt % 2 == 1 ? ' hl' : '';
echo '
<li class="row ' . $hl . '">
<div class="txt" style="width:30%;">' . cOut($row[2] . ', ' . $row[1]) . '</div>
<div class="txt" style="width:40%;">' . cOut($row[3]) . '</div>
<div class="txt" style="width:20%;">' . ($row[4] != '' ? stampToDate($row[4], $hc_cfg[24] . ' ' . $hc_cfg[23]) : 'N/A') . '</div>
<div class="tools" style="width:10%;">
<a href="' . AdminRoot . '/index.php?com=adminedit&aID=' . $row[0] . '"><img src="' . AdminRoot . '/img/icons/edit.png" width="16" height="16" alt="" /></a>
<a href="javascript:;" onclick="doDelete(\'' . $row[0] . '\');return false;"><img src="' . AdminRoot . '/img/icons/delete.png" width="16" height="16" alt="" /></a>
</div>
</li>';
++$cnt;
}
echo '
</ul>
<script>
//<!--
function doDelete(dID){
if(confirm("' . $hc_lang_admin['Valid07'] . '\\n\\n ' . $hc_lang_admin['Valid08'] . '\\n ' . $hc_lang_admin['Valid09'] . '")){
document.location.href = "' . AdminRoot . '/components/AdminEditAction.php?dID=" + dID + "&tkn=' . set_form_token(1) . '";
}
<li class="row header uline">
<div style="width:68%;">' . $hc_lang_manage['Title'] . '</div>
<div style="width:10%;">' . $hc_lang_manage['Date'] . '</div>
<div class="number" style="width:10%;">' . $hc_lang_manage['Views'] . '</div>
<div style="width:10%;"> </div>
</li>
</ul>
<ul class="data">
<div class="blbd">';
$cnt = 0;
while ($row = mysql_fetch_row($result)) {
$hl = $cnt % 2 == 1 ? ' hl' : '';
echo '
<li class="row ' . $hl . '">
<div class="txt" title="' . cOut($row[1]) . '" style="width:70%;">' . cOut($row[1]) . '</div>
<div style="width:10%;">' . stampToDate($row[2], $hc_cfg[24]) . '</div>
<div class="number" style="width:10%;">' . number_format(cOut($row[3]), 0, '', ',') . '</div>
<div class="tools" style="width:10%;">
<a href="' . AdminRoot . '/index.php?com=eventedit&eID=' . $row[0] . '"><img src="' . AdminRoot . '/img/icons/edit.png" width="16" height="16" alt="" /></a>
<a href="javascript:;" onclick="doDelete(\'' . $row[0] . '\');return false;"><img src="' . AdminRoot . '/img/icons/delete.png" width="16" height="16" alt="" /></a>
</div>
</li>';
++$cnt;
}
echo '
</div>
</ul>
<script>
//<!--
function doDelete(eID){
if(confirm("' . $hc_lang_manage['Valid01'] . "\\n\\n " . $hc_lang_manage['Valid02'] . "\\n " . $hc_lang_manage['Valid03'] . '"))
$result = doQuery($query);
if (hasRows($result)) {
echo '
<title>' . cleanXMLChars($feedName . ' - ' . CalName) . '</title>';
$cnt = 0;
while ($row = mysql_fetch_row($result)) {
$description = $hc_cfg[107] > 0 ? clean_truncate($row[2], $hc_cfg[107]) : $row[2];
$comment = $hc_cfg[25] != '' ? '<comments><![CDATA[' . CalRoot . '/index.php?eID=' . $row[0] . '#disqus_thread' . ']]></comments>' : '';
echo '
<item>
<title>' . cleanXMLChars(stampToDate(cOut($row[3]), $hc_cfg[24])) . " - " . cleanXMLChars(cOut($row[1])) . '</title>
<link><![CDATA[' . CalRoot . '/index.php?eID=' . $row[0] . ']]></link>
<description>' . cleanXMLChars(cOut($description)) . '</description>
' . $comment . '
<guid>' . CalRoot . '/index.php?eID=' . $row[0] . '</guid>
<pubDate>' . cleanXMLChars(stampToDate($row[3] . ' ' . $row[4], "%a, %d %b %Y %H:%M:%S") . ' ' . $tzRSS) . '</pubDate>
</item>';
++$cnt;
}
} else {
echo '
<title>' . $hc_lang_rss['RSSSorry'] . '</title>
<item>
<title>' . $hc_lang_rss['RSSNoEvents'] . '</title>
<link>' . CalRoot . '/</link>
<description>' . $hc_lang_rss['RSSNoLink'] . '</description>
<guid>' . CalRoot . '/</guid>
</item>';
}
echo '
</channel>
/**
* Output digest newsletters list. Newsletters listed in decending order by sent date.
* @since 2.1.0
* @version 2.1.0
* @param integer $size max number of newsletters to include in the list (list may be smaller depending on settings/available newsletters).
* @return void
*/
function digest_newsletter_list($size, $dateFormat = '')
{
global $hc_cfg, $hc_lang_pages;
if (!file_exists(HCPATH . '/cache/digest_' . SYSDATE . '_n')) {
ob_start();
$fp = fopen(HCPATH . '/cache/digest_' . SYSDATE . '_n', 'w');
$result = doQuery("SELECT PkID, Subject, SentDate FROM " . HC_TblPrefix . "newsletters WHERE Status > 0 AND IsArchive = 1 AND IsActive = 1 AND ArchiveContents != '' ORDER BY SentDate DESC LIMIT " . $size);
if (!hasRows($result)) {
echo '
<ul class="newsletters"><li>' . $hc_lang_pages['NoNewsletters'] . '</li></ul>';
return 0;
}
$cnt = 1;
$dateFormat = $dateFormat == '' ? $hc_cfg[24] : $dateFormat;
echo '
<ul class="newsletters">';
while ($row = mysql_fetch_row($result)) {
$hl = $cnt % 2 == 0 ? ' class="hl"' : '';
echo '<li' . $hl . '><time datetime="' . stampToDate($row[2], '%Y-%m-%d') . '">' . stampToDate($row[2], $dateFormat) . '</time><a href="' . CalRoot . '/newsletter/index.php?n=' . md5($row[0]) . '" target="_blank">' . cOut($row[1]) . '</a></li>';
++$cnt;
}
echo '
</ul>';
fwrite($fp, ob_get_contents());
fclose($fp);
ob_end_clean();
}
include HCPATH . '/cache/digest_' . SYSDATE . '_n';
}
if (hasRows($result)) {
$last = mysql_result($result, 0, 1) != '' ? '<lastmod>' . stampToDate(mysql_result($result, 0, 1), '%Y-%m-%d') . '</lastmod>' : '';
$x = 1;
$stop = mysql_result($result, 0, 0) > $hc_cfg[87] ? ceil(mysql_result($result, 0, 0) / $hc_cfg[87]) : 1;
while ($x <= $stop) {
echo '
<sitemap>
<loc>' . CalRoot . '/sitemap/events.php?map=' . $x . '</loc>
' . $last . '
</sitemap>';
++$x;
}
}
$result = doQuery("SELECT COUNT(l.PkID), MAX(l.LastMod) FROM " . HC_TblPrefix . "locations l WHERE l.IsActive = 1");
if (hasRows($result)) {
$last = mysql_result($result, 0, 1) != '' ? '<lastmod>' . stampToDate(mysql_result($result, 0, 1), '%Y-%m-%d') . '</lastmod>' : '';
$x = 1;
$stop = mysql_result($result, 0, 0) > $hc_cfg[87] ? ceil(mysql_result($result, 0, 0) / $hc_cfg[87]) : 1;
while ($x <= $stop) {
echo '
<sitemap>
<loc>' . CalRoot . '/sitemap/locations.php?map=' . $x . '</loc>
' . $last . '
</sitemap>';
++$x;
}
}
echo '
</sitemapindex>';
fwrite($fp, ob_get_contents());
fclose($fp);
echo "END:VEVENT\r\n";
echo "END:VCALENDAR";
break;
case 5:
if (!preg_match("{$hc_cfg['85']}i", $_SERVER['HTTP_USER_AGENT'])) {
doQuery("UPDATE " . HC_TblPrefix . "events SET Downloads = Downloads + 1 WHERE PkID = '" . $eID . "'");
}
$link = "http://calendar.live.com/calendar/calendar.aspx?rru=addevent";
if (mysql_result($result, 0, 11) == 0) {
if (mysql_result($result, 0, 12) != '') {
$link .= "&dtstart=" . stampToDate(mysql_result($result, 0, 9) . " " . mysql_result($result, 0, 10), "%Y%m%dT%H%M%S") . "&dtend=" . stampToDate(mysql_result($result, 0, 9) . " " . mysql_result($result, 0, 12), "%Y%m%dT%H%M%S");
} else {
$link .= "&dtstart=" . stampToDate(mysql_result($result, 0, 9) . " " . mysql_result($result, 0, 10), "%Y%m%dT%H%M%S") . "&dtend=" . stampToDate(mysql_result($result, 0, 9) . " " . mysql_result($result, 0, 10), "%Y%m%dT%H%M%S");
}
} else {
$link .= "&dtstart=" . stampToDate(mysql_result($result, 0, 9), "%Y%m%d") . "T000000&dtend=" . stampToDate(mysql_result($result, 0, 9), "%Y%m%d") . "T000000";
}
$link .= "&summary=" . urlencode(mysql_result($result, 0, 1));
if (strlen(mysql_result($result, 0, 8)) > 400) {
$link .= "&description=" . urlencode(htmlspecialchars(strip_tags(cOut(substr(mysql_result($result, 0, 8), 0, 400)))) . "...\n\nFull Description available at: " . CalRoot . "/index.php?eID=" . $eID);
} else {
$link .= "&description=" . urlencode(htmlspecialchars(strip_tags(cOut(mysql_result($result, 0, 8)))));
}
if (mysql_result($result, 0, 35) == 0 || mysql_result($result, 0, 35) == '') {
$link .= "&location=" . urlencode(mysql_result($result, 0, 3) . " " . mysql_result($result, 0, 4) . " " . mysql_result($result, 0, 5) . " " . mysql_result($result, 0, 6) . " " . mysql_result($result, 0, 37) . " " . mysql_result($result, 0, 7));
} else {
$result = doQuery("SELECT * FROM " . HC_TblPrefix . "locations WHERE PkID = '" . cIn(mysql_result($result, 0, 35)) . "'");
$link .= "&location=" . urlencode(mysql_result($result, 0, 2) . " " . mysql_result($result, 0, 3) . " " . mysql_result($result, 0, 4) . " " . mysql_result($result, 0, 5) . " " . mysql_result($result, 0, 6) . " " . mysql_result($result, 0, 7));
}
header("Location: {$link}");
break;
function sr_event_browse($show_images = 0)
{
global $lID, $hc_cfg, $hc_lang_event, $favQ1, $favQ2, $resultEB, $myNav;
$location = $lID > 0 ? '&lID=' . $lID : '';
$cnt = $date = 0;
$row_number = 1;
echo $myNav;
if (!hasRows($resultEB)) {
no_event_notice();
return 0;
}
while ($row = mysql_fetch_row($resultEB)) {
//echo print_r($row);
$color_class = sr_colorizer($row_number);
$description = $hc_cfg[107] > 0 ? clean_truncate($row[21], $hc_cfg[107]) : $row[21];
$categories = explode(",", $row[20]);
//filtering out ACE
switch (count($categories)) {
case 0:
$category = 'No Category';
break;
case 1:
$category = substr($categories[0], 3);
break;
default:
$category = substr($categories[0], -4) != '_ACE' ? substr($categories[0], 3) : substr($categories[1], 3);
break;
}
$category = '<h4>' . $category . '</h4>';
if ($date != $row[2]) {
$date = $row[2];
echo $cnt > 0 ? '</ul>' : '';
echo '<h2>' . stampToDate($row[2], '%A, %B %d, %Y') . '</h2><ul>';
$cnt = 1;
}
$limit = $row[8] > 0 ? cOut($row[8]) : $hc_cfg[134];
$expire = $limit > 0 ? date("Y-m-d", strtotime($date) + $limit * 86400) : '';
$cls = $cnt % 2 == 0 ? 'hl' : '';
$cls .= $row[7] > 0 ? ' featured' : '';
if ($row[5] == 0) {
$time = $row[3] != '' ? stampToDate($row[3], $hc_cfg[23]) : '';
$time .= $row[4] != '' ? ' - ' . stampToDate($row[4], $hc_cfg[23]) : '';
//$stamp = date("Y-m-d\Th:i:00",strtotime($row[2] . trim(' '.$row[3]))) . HCTZ;
$stamp = stampToDate($row[2], '%A, %B %d');
//$hc_cfg[14]
} else {
$time = $row[5] == 1 ? $hc_lang_event['AllDay'] : $hc_lang_event['TBA'];
$stamp = $row[2];
$stamp = stampToDate($row[2], '%A, %B %d');
}
echo '
<li ' . ($cls != '' ? 'class="' . $color_class . ' ' . trim($cls) . '" ' : 'class="' . $color_class . '"') . 'itemscope itemtype="http://schema.org/Event">
<a href="' . CalRoot . '/index.php?eID=' . $row[0] . $location . '">' . '<div class="event-content-container">' . $category . '<h3 itemprop="name">' . cOut($row[1]) . '</h3><div class="date-time">
<span itemprop="startDate" datetime="' . $stamp . '">' . $stamp . ', ' . $time . '</span>
<span class="location"><i class="fa fa-map-marker"></i> ' . $row[14] . ($row[22] != '' ? ' - ' . $row[22] : '') . '</span></div><p>' . strip_tags(cOut($description)) . '<span class="readmore"> READ MORE</span></p></div>' . ($show_images == 1 && $row[6] != '' ? '<div class="event-image-container" style="background-image: url(' . $row[6] . '); min-width:' . (strlen($row[1]) > 43 ? 325 : 287) . 'px;"></div>' : '') . '</a></li>';
//'<span class="readmore"> READ MORE</span></p></div>'.(($show_images == 1 && $row[6] != '') ? '<div class="event-image-container"><img itemprop="image" src="'.$row[6].'" class="eimage_b" /></div>':'').'</a></li>'
++$cnt;
++$row_number;
}
echo '
</ul>
' . $myNav;
}
/**
* Output user's list of submitted events.
* @since 2.1.0
* @version 2.2.1
* @return void
*/
function user_manage_events()
{
global $hc_cfg, $hc_lang_user;
if (!user_check_status()) {
return -1;
}
$date = isset($_GET['d']) && is_numeric($_GET['d']) ? strftime("%Y-%m-%d", cIn(strip_tags($_GET['d']))) : SYSDATE;
$d = explode('-', $date);
$year = isset($d[0]) && is_numeric($d[0]) ? $d[0] : NULL;
$month = isset($d[1]) && is_numeric($d[1]) ? $d[1] : NULL;
$day = isset($d[2]) && is_numeric($d[2]) ? $d[2] : NULL;
if (!checkdate($month, $day, $year)) {
$date = SYSDATE;
$day = date('d', strtotime(SYSDATE));
$month = date('m', strtotime(SYSDATE));
$year = date('Y', strtotime(SYSDATE));
}
$sqlStart = $year . '-' . $month . '-1';
$sqlEnd = strftime("%Y-%m-%d", mktime(0, 0, 0, $month + 1, 0, $year));
$result = doQuery("SELECT DISTINCT e.PkID, e.Title, e.StartDate, e.StartTime, e.EndTime, e.TBD, e.IsApproved, e.SeriesID, er.Type, er.Space,\r\n\t\t\t\t\t\t\t(SELECT COUNT(PkID) FROM " . HC_TblPrefix . "registrants r WHERE EventID = e.PkID) as SpacesTaken\r\n\t\t\t\t\t\tFROM " . HC_TblPrefix . "events e\r\n\t\t\t\t\t\t\tLEFT JOIN " . HC_TblPrefix . "eventcategories ec ON (ec.EventID = e.PkID)\r\n\t\t\t\t\t\t\tLEFT JOIN " . HC_TblPrefix . "eventrsvps er ON (er.EventID = e.PkID)\r\n\t\t\t\t\t\t\tLEFT JOIN " . HC_TblPrefix . "locations l ON (e.LocID = l.PkID)\r\n\t\t\t\t\t\tWHERE e.StartDate BETWEEN '" . cIn($sqlStart) . "' AND '" . cIn($sqlEnd) . "' \r\n\t\t\t\t\t\t\tAND e.IsActive = 1 AND e.OwnerID = '" . cIn($_SESSION['UserPkID']) . "'\r\n\t\t\t\t\t\tGROUP BY e.PkID, e.Title, e.StartDate, e.StartTime, e.EndTime, e.TBD, e.IsApproved, e.SeriesID, er.Type, er.Space\r\n\t\t\t\t\t\tORDER BY e.StartDate, e.TBD, e.StartTime, e.Title");
$i = 0;
$jmp = 12;
$stop = $jmp + 12;
$jumpMonth = date("n", mktime(0, 0, 0, $month - $jmp, 1, $year));
$jumpYear = date("Y", mktime(0, 0, 0, $month - $jmp, 1, $year));
$actJump = date("Y-m-d", mktime(0, 0, 0, $month, 1, $year));
$opts = '';
while ($i <= 24) {
$jmpDate = date("Y-m-d", mktime(0, 0, 0, $jumpMonth + $i, 1, $jumpYear));
$select = $jmpDate == $actJump ? ' selected="selected"' : '';
$opts .= '
<option value="' . CalRoot . '/index.php?com=acc&sec=list&d=' . date("U", mktime(0, 0, 0, $jumpMonth + $i, 1, $jumpYear)) . '"' . $select . '>' . strftime($hc_cfg[92], mktime(0, 0, 0, $jumpMonth + $i, 1, $jumpYear)) . '</option>';
++$i;
}
echo '
<fieldset class="user">
<legend>' . $hc_lang_user['UserEventLabel'] . '</legend>
<ul id="user_events">
<li id="ue_prev"><a href="' . CalRoot . '/index.php?com=acc&sec=list&d=' . strtotime(strftime("%Y-%m-%d", mktime(0, 0, 0, $month - 1, 1, $year))) . '"><</a></li>
<li id="ue_jump">
<select name="ue_jump_select" id="ue_jump_select" onchange="window.location.href=this.value;">' . $opts . '
</select>
</li>
<li id="ue_next"><a href="' . CalRoot . '/index.php?com=acc&sec=list&d=' . strtotime(strftime("%Y-%m-%d", mktime(0, 0, 0, $month + 1, 1, $year))) . '">></a></li>
</ul>';
if (!hasRows($result)) {
echo '<p>' . $hc_lang_user['NoEventNotice'] . '</p>';
return -1;
}
echo '
<ul class="data">';
$cnt = 1;
while ($row = mysql_fetch_row($result)) {
echo '
<li class="row' . ($cnt % 2 == 0 ? ' hl' : '') . '">
<div class="ue_title txt" title="' . cOut($row[1]) . '">' . clean_truncate(cOut($row[1]), 100) . '</div>
<div class="ue_date">' . stampToDate($row[2], $hc_cfg[24]) . '</div>
<div class="ue_time txt">';
if ($row[5] == 0) {
$time = $row[3] != '' ? stampToDate($row[3], $hc_cfg[23]) : '';
} else {
$time = $row[5] == 1 ? $hc_lang_user['AllDay'] : $hc_lang_user['TBD'];
}
$rsvp = '';
if ($row[8] == 1) {
$rsvp = $row[10] > 0 && $row[6] != 2 ? '<a href="' . CalRoot . '/download-rsvp.php?eID=' . cOut($row[0]) . '"><img src="' . CalRoot . '/img/icons/rsvp_download.png" width="16" height="16" alt="" title="' . $hc_lang_user['TitleRSVP'] . '" /></a>' : '<img src="' . CalRoot . '/img/icons/rsvp_download_o.png" width="16" height="16" alt="" title="' . $hc_lang_user['TitleRSVP0'] . '" />';
}
echo $time . '</div>
<div class="ue_status txt">
' . $rsvp . $hc_lang_user['Status' . $row[6]] . '
</div>
<div class="ue_tools tools">
' . ($row[6] == 2 ? '<img src="' . CalRoot . '/img/icons/single_o.png" width="16" height="16" alt="" title="' . $hc_lang_user['TitleView'] . '" />' : '<a href="' . CalRoot . '/index.php?eID=' . $row[0] . '"><img src="' . CalRoot . '/img/icons/single.png" width="16" height="16" alt="" title="' . $hc_lang_user['TitleView'] . '" /></a>') . '
<a href="' . CalRoot . '/index.php?com=submit&eID=' . $row[0] . '"><img src="' . CalRoot . '/img/icons/edit.png" width="16" height="16" alt="" title="' . $hc_lang_user['TitleEdit'] . '" /></a>';
if ($row[7] != '') {
echo ($row[6] == 2 ? '
<img src="' . CalRoot . '/img/icons/series_o.png" width="16" height="16" alt="" title="' . $hc_lang_user['TitleViewSeries'] . '" />' : '<a href="' . CalRoot . '/index.php?com=series&sID=' . $row[7] . '"><img src="' . CalRoot . '/img/icons/series.png" width="16" height="16" alt="" title="' . $hc_lang_user['TitleViewSeries'] . '" /></a>') . '
<a href="' . CalRoot . '/index.php?com=submit&sID=' . $row[7] . '"><img src="' . CalRoot . '/img/icons/edit_series.png" width="16" height="16" alt="" title="' . $hc_lang_user['TitleEditSeries'] . '" /></a>';
}
echo '
</div>
</li>';
++$cnt;
}
echo '
</fieldset>';
}
$curYear = $dateParts[0];
$cnt = 0;
if ($whichDay != 0) {
$x = date("w", mktime(0, 0, 0, $curMonth + $whichRepeat, 1, $curYear));
while ($x % 7 != $whichDOW) {
++$x;
++$cnt;
}
$curDate = date("Y-m-d", mktime(0, 0, 0, $curMonth + $whichRepeat, 1 + $cnt + (7 * $whichDay - 7), $curYear));
} else {
$x = date("w", mktime(0, 0, 0, $curMonth + $whichRepeat + 1, 0, $curYear));
$offset = 0;
if ($x < $whichDOW) {
$x = $x + 7;
}
while (abs($x) % 7 != $whichDOW) {
--$x;
++$cnt;
}
$curDate = date("Y-m-d", mktime(0, 0, 0, $curMonth + $whichRepeat + 1, 0 - $cnt, $curYear));
}
}
}
break;
}
$x = 0;
foreach ($dates as $val) {
echo $x % 7 == 0 ? '<br />' : ', ';
echo stampToDate($val, $hc_cfg[24]);
++$x;
}
$date = cleanXMLChars(stampToDate($min, "%B %d")) . ' - ' . cleanXMLChars(stampToDate($max, "%B %d"));
} else {
$date = cleanXMLChars(stampToDate($row[3], "%B %d"));
}
$comment = $hc_cfg[25] != '' ? '<comments><![CDATA[' . CalRoot . '/index.php?eID=' . $row[0] . '#disqus_thread' . ']]></comments>' : '';
echo '
<item>
<title>' . cleanXMLChars(stampToDate(cOut($row[3]), $hc_cfg[24])) . " - " . cleanXMLChars(cOut($row[1])) . '</title>
<link><![CDATA[' . CalRoot . '/index.php?eID=' . $row[0] . ']]></link>
<description>' . cleanXMLChars(cOut($description)) . '</description>
' . $comment . '
<guid>' . CalRoot . '/index.php?eID=' . $row[0] . '</guid>
<pubDate>' . cleanXMLChars(stampToDate($row[3] . ' ' . $row[4], "%a, %d %b %Y %H:%M:%S") . ' ' . $tzRSS) . '</pubDate>
<date>' . $date . '</date>
<startTime>' . date("h:i A", strtotime(stampToDate($row[3] . ' ' . $row[4], "%d %b %Y %H:%M:%S"))) . '</startTime>
<endTime>' . date("h:i A", strtotime(stampToDate($row[3] . ' ' . $row[7], "%d %b %Y %H:%M:%S"))) . '</endTime>
<location>' . $row[8] . '</location>
<category>' . cleanXMLChars($category) . '</category>
<eventName>' . cleanXMLChars(cOut($row[1])) . '</eventName>
<test>' . $min . '</test>
</item>';
++$cnt;
}
} else {
echo '
<title>' . $hc_lang_rss['RSSSorry'] . '</title>
<item>
<title>' . $hc_lang_rss['RSSNoEvents'] . '</title>
<link>' . CalRoot . '/</link>
<description>' . $hc_lang_rss['RSSNoLink'] . '</description>
<guid>' . CalRoot . '/</guid>
<span class="output"><b>' . number_format($subCnt, 0, '.', ',') . '</b> ' . $hc_lang_news['SubStats'] . '</span>
<label> </label>
<span class="output"><b>' . number_format($eCnt, 0, '.', ',') . '</b> ' . $hc_lang_news['EventStats'] . '</span>
</fieldset>
<fieldset>
<legend>' . $hc_lang_news['Settings'] . '</legend>
<label>' . $hc_lang_news['MailName'] . '</label>
<span class="output">' . mysql_result($result, 0, 1) . '</span>
<label>' . $hc_lang_news['MailSubject'] . '</label>
<span class="output">' . mysql_result($result, 0, 2) . '</span>
<label>' . $hc_lang_news['Dates'] . '</label>';
if (mysql_result($result, 0, 3) != '') {
echo mysql_result($result, 0, 3) < date("Y-m-d") ? '<span class="output alert">' . stampToDate(mysql_result($result, 0, 3), $hc_cfg[24]) . '</span>' : '<span class="output">' . stampToDate(mysql_result($result, 0, 3), $hc_cfg[24]) . '</span>';
}
if (mysql_result($result, 0, 4) != '') {
echo mysql_result($result, 0, 4) < date("Y-m-d") ? '<span class="output alert"> - ' . stampToDate(mysql_result($result, 0, 4), $hc_cfg[24]) . '</span>' : '<span class="output"> - ' . stampToDate(mysql_result($result, 0, 4), $hc_cfg[24]) . '</span>';
}
echo '
<label>' . $hc_lang_news['Groups'] . '</label>
' . ($groups == '' ? '<span class="output alert">' . $hc_lang_news['NoGroups'] . '</span>' : '<span class="output">' . $groups . '</span>') . '
<label>' . $hc_lang_news['Template'] . '</label>
' . (mysql_result($result, 0, 7) == '' ? '<span class="output alert">' . $hc_lang_news['NoTemplate'] . '</span>' : '<span class="output">' . mysql_result($result, 0, 7) . '</span>') . '
<label>' . $hc_lang_news['ArchStatus'] . '</label>
<span class="output">' . (mysql_result($result, 0, 5) == 1 ? $hc_lang_news['ArchStatus1'] : $hc_lang_news['ArchStatus0']) . '</span>
</fieldset>
<fieldset>
<legend>' . $hc_lang_news['Message'] . (strpos(mysql_result($result, 0, 8), '[message]') === false ? ' ' . $hc_lang_news['NoMsgTemp'] : '') . '</legend>
' . (mysql_result($result, 0, 6) != '' ? mysql_result($result, 0, 6) : $hc_lang_news['NoMessage']) . '
</fieldset>
<p>' . $stopMsg . '</p>
<input name="save" id="save" type="button"' . ($stop > 0 ? ' disabled="disabled"' : '') . ' value="' . $hc_lang_news['Approve0'] . '" onclick="approve(0);return false;" />
/**
* Create JavaScript array() variable named "locations" with location entries for use with location Google map. Saves array to cache if cache not present.
* @since 2.0.0
* @version 2.1.0
* @return void
*/
function map_locations()
{
global $hc_cfg;
if (!file_exists(HCPATH . '/cache/lmap' . SYSDATE)) {
purge_cache_map();
$cnt = 0;
ob_start();
$fp = fopen(HCPATH . '/cache/lmap' . SYSDATE, 'w');
$result = doQuery("SELECT l.PkID, l.Name, l.Address, l.Address2, l.City, l.State, l.Country, l.Zip, l.Lat, l.Lon, COUNT(e.LocID), MIN(e.StartDate), l.URL, l.Phone\r\n\t\t\t\t\t\t\tFROM " . HC_TblPrefix . "locations l\r\n\t\t\t\t\t\t\t\tLEFT JOIN " . HC_TblPrefix . "events e ON (e.LocID = l.PkID)\r\n\t\t\t\t\t\t\tWHERE l.Lat IS NOT NULL AND l.Lon IS NOT NULL AND l.Lat != '' AND l.Lon != '' AND l.IsActive = 1 AND\r\n\t\t\t\t\t\t\t\te.LocID > 0 AND e.IsActive = 1 AND e.IsApproved = 1 AND e.PkID IS NOT NULL AND e.StartDate >= '" . cIn(SYSDATE) . "'\r\n\t\t\t\t\t\t\tGROUP BY l.PkID, l.Name, l.Address, l.Address2, l.City, l.State, l.Country, l.Zip, l.Lat, l.Lon, l.URL, l.Phone\r\n\t\t\t\t\t\t\tHAVING COUNT(e.LocID) > 0\r\n\t\t\t\t\t\t\tORDER BY l.Name");
if (hasRows($result)) {
echo '
var locations = [';
while ($row = mysql_fetch_row($result)) {
echo '
["' . $row[0] . '","' . cOut($row[1]) . '","' . $row[8] . '","' . $row[9] . '","' . cOut($row[1]) . '","' . cOut($row[2]) . '","' . cOut($row[3]) . '","' . cOut($row[4]) . '","' . cOut($row[5]) . '","' . cOut($row[6]) . '","' . cOut($row[7]) . '","' . $row[10] . '","' . stampToDate($row[11], $hc_cfg[14]) . '","' . ($row[12] != '' && $row[12] != 'http://' ? '1' : '0') . '","' . cOut($row[13]) . '"],';
++$cnt;
}
echo '
];';
}
fwrite($fp, ob_get_contents());
fclose($fp);
ob_end_clean();
}
include HCPATH . '/cache/lmap' . SYSDATE;
}
define('isAction', true);
include_once '../loader.php';
$page = isset($_GET['map']) && is_numeric($_GET['map']) ? cIn(strip_tags($_GET['map'])) : 1;
header('Content-type: application/xml; charset="utf-8"');
if (!file_exists(HCPATH . '/cache/sitemap_events_' . $page)) {
$result = doQuery("SELECT PkID, PublishDate \r\n\t\t\t\t\t\tFROM " . HC_TblPrefix . "events \r\n\t\t\t\t\t\tWHERE IsActive = 1 AND IsApproved = 1 AND StartDate >= '" . cIn(SYSDATE) . "'\r\n\t\t\t\t\t\tORDER BY StartDate\r\n\t\t\t\t\t\tLIMIT {$hc_cfg['87']} OFFSET " . $hc_cfg[87] * ($page - 1));
if (!hasRows($result)) {
header("Location: " . CalRoot . "/sitemap");
exit;
}
ob_start();
$fp = fopen(HCPATH . '/cache/sitemap_events_' . $page, 'w');
echo '<?xml version="1.0" encoding="UTF-8"?>
<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">';
while ($row = mysql_fetch_row($result)) {
$last = $row[1] != '' ? '<lastmod>' . stampToDate($row[1], '%Y-%m-%d') . '</lastmod>' : '';
echo '
<url>
<loc>' . CalRoot . '/index.php?eID=' . $row[0] . '</loc>
' . $last . '
</url>';
}
echo '
</urlset>';
fwrite($fp, ob_get_contents());
fclose($fp);
ob_end_clean();
}
if (file_exists(HCPATH . '/cache/sitemap_events_' . $page)) {
readfile(HCPATH . '/cache/sitemap_events_' . $page);
}
/**
* Output weekly dashboard to a page outside of Helios Calendar.
* @since 2.0.1
* @version 2.0.1
* @param binary $submit include submit event link, 0 = hide , 1 = show (Default:1)
* @param binary $ical include iCalendar subscription link, 0 = hide, 1 = show (Default:1)
* @param binary $rss include All Events rss feed link, 0 = hide, 1 = show (Default:1)
* @param binary $end_time include end time in event lists, 0 = hide, 1 = show (Default:1)
* @param string $menu_format menu format string, accepts any supported strftime() format parameters (Default:%a %m/%d)
* @return void
*/
function int_week_dashboard($submit = 1, $ical = 1, $rss = 1, $end_time = 1, $menu_format = '%a %m/%d')
{
global $hc_cfg, $hc_lang_core;
include HCLANG . '/public/integration.php';
if (!file_exists(HCPATH . '/cache/int7_' . SYSDATE . '.php')) {
if (count(glob(HCPATH . '/cache/int7_*.php')) > 0) {
foreach (glob(HCPATH . '/cache/int7_*.php') as $file) {
unlink($file);
}
}
ob_start();
$fp = fopen(HCPATH . '/cache/int7_' . SYSDATE . '.php', 'w');
fwrite($fp, "<?php\n//\tHelios Dashboard Integration Events Cache - Delete this file when upgrading.\n");
$result = doQuery("SELECT PkID, Title, StartDate, StartTime, EndTime, TBD FROM " . HC_TblPrefix . "events \r\n\t\t\t\t\t\t\tWHERE IsActive = 1 AND IsApproved = 1 AND StartDate Between '" . SYSDATE . "' AND ADDDATE('" . SYSDATE . "', INTERVAL 6 DAY)\r\n\t\t\t\t\t\t\tORDER BY StartDate, TBD, StartTime, Title");
if (hasRows($result)) {
$cur_day = -1;
$cur_date = '';
fwrite($fp, "\$hc_next7 = array(\n");
while ($row = mysql_fetch_row($result)) {
if ($cur_date != $row[2]) {
++$cur_day;
$cur_date = $row[2];
if ($cur_day > 0) {
fwrite($fp, "\t),\n");
}
fwrite($fp, $cur_day . " => array(\n");
}
if ($row[5] == 0) {
$time = $row[3] != '' ? stampToDate($row[3], $hc_cfg[23]) : '';
$time .= $row[4] != '' && $end_time == 1 ? ' - ' . stampToDate($row[4], $hc_cfg[23]) : '';
} else {
$time = $row[5] == 1 ? $hc_lang_int['AllDay'] : $hc_lang_int['TimeTBA'];
}
fwrite($fp, "\t" . $row[0] . " => array(\"" . $time . "\",\"" . stampToDate($row[2], $hc_cfg[14]) . "\",\"" . str_replace("\"", "'", cOut($row[1])) . "\"),\n");
}
fwrite($fp, "\t),");
}
fwrite($fp, "\n)\n?>");
fwrite($fp, ob_get_contents());
fclose($fp);
ob_end_clean();
}
include HCPATH . '/cache/int7_' . SYSDATE . '.php';
echo '
<script>
//<!--
function hc_tog_dash(show){var i = 0;while(i <= 6){document.getElementById("hc_dashboard_day"+i).style.display = (i == show) ? "block" : "none";i++;}}
//-->
</script>
<div id="hc_dashboard">
<ul id="menu">
<li><a href="javascript:;" onclick="hc_tog_dash(0);return false;">' . strftime($menu_format, strtotime(SYSDATE) + 86400 * 0) . '</a></li>
<li><a href="javascript:;" onclick="hc_tog_dash(1);return false;">' . strftime($menu_format, strtotime(SYSDATE) + 86400 * 1) . '</a></li>
<li><a href="javascript:;" onclick="hc_tog_dash(2);return false;">' . strftime($menu_format, strtotime(SYSDATE) + 86400 * 2) . '</a></li>
<li><a href="javascript:;" onclick="hc_tog_dash(3);return false;">' . strftime($menu_format, strtotime(SYSDATE) + 86400 * 3) . '</a></li>
<li><a href="javascript:;" onclick="hc_tog_dash(4);return false;">' . strftime($menu_format, strtotime(SYSDATE) + 86400 * 4) . '</a></li>
<li><a href="javascript:;" onclick="hc_tog_dash(5);return false;">' . strftime($menu_format, strtotime(SYSDATE) + 86400 * 5) . '</a></li>
<li><a href="javascript:;" onclick="hc_tog_dash(6);return false;">' . strftime($menu_format, strtotime(SYSDATE) + 86400 * 6) . '</a></li>
' . ($rss == 1 && $hc_cfg[106] == 1 ? '<li class="icon"><a href="' . CalRoot . '/rss/" title="' . $hc_lang_int['TitleRSS'] . '" rel="nofollow" target="_blank"><img src="' . CalRoot . '/img/feed.png" width="16" height="16" alt="" /></a></li>' : '') . '
' . ($ical == 1 && $hc_cfg[108] == 1 ? '<li class="icon"><a href="webcal://' . substr(CalRoot, 7) . '/link/ical.php" title="' . $hc_lang_int['TitleiCal'] . '" rel="nofollow"><img src="' . CalRoot . '/img/icons/ical.png" width="16" height="16" alt="" /></a></li>' : '') . '
</ul>';
$date = '';
foreach ($hc_next7 as $day => $arr) {
foreach ($arr as $id => $value) {
if ($date != $value[1]) {
$date = $value[1];
echo '
<div id="hc_dashboard_day' . $day . '" class="hc_dashboard_day"' . ($day > 0 ? ' style="display:none;"' : '') . '>
<ul>
<li>' . $value[1] . '</li>';
}
echo '
<li><div class="time">' . $value[0] . '</div><a href="' . CalRoot . '/index.php?eID=' . $id . '" rel="nofollow">' . cOut($value[2]) . '</a></li>';
}
echo $date != '' ? '
</ul>
</div>' : '';
}
echo $date == '' ? $hc_lang_int['NoEvent'] : '';
echo '
<a href="' . CalRoot . '/" rel="nofollow">' . $hc_lang_int['Browse'] . '</a>
' . ($submit == 1 ? '| <a href="' . CalRoot . '/index.php?com=submit" rel="nofollow">' . $hc_lang_int['Submit'] . '</a>' : '') . '
</div>';
}
| <a href="javascript:;" onclick="uncheckAllArray(\'eventOrphan\',\'eventID[]\');">' . $hc_lang_core['DeselectAll'] . '</a> ]
</div>
<ul class="data">
<li class="row header uline">
<div style="width:60%;">' . $hc_lang_manage['Title'] . '</div>
<div style="width:15%;">' . $hc_lang_manage['Date'] . '</div>
<div style="width:10%;">' . $hc_lang_manage['Missing'] . '</div>
<div style="width:15%;"> </div>
</li>';
$cnt = 0;
while ($row = mysql_fetch_row($result)) {
$hl = $cnt % 2 == 1 ? ' hl' : '';
echo '
<li class="row ' . $hl . '">
<div class="txt" style="width:60%;">' . cOut($row[1]) . '</div>
<div class="txt" style="width:15%;">' . stampToDate($row[2], $hc_cfg[24]) . '</div>
<div class="txt" style="width:10%;">' . $hc_lang_manage['Missing' . $row[3]] . '</div>
<div class="tools" style="width:15%;">
<a href="' . AdminRoot . '/index.php?com=eventedit&eID=' . $row[0] . '&oID=1"><img src="' . AdminRoot . '/img/icons/edit.png" width="16" height="16" alt="" /></a>
<a href="javascript:;" onclick="doDelete(\'' . $row[0] . '\');return false;"><img src="' . AdminRoot . '/img/icons/delete.png" width="16" height="16" alt="" /></a>
<input type="checkbox" name="eventID[]" id="eventID_' . $row[0] . '" value="' . $row[0] . '" />
</div>
</li>';
++$cnt;
}
echo '
</ul>
<div class="catCtrl">
[ <a href="javascript:;" onclick="checkAllArray(\'eventOrphan\',\'eventID[]\');">' . $hc_lang_core['SelectAll'] . '</a>
| <a href="javascript:;" onclick="uncheckAllArray(\'eventOrphan\',\'eventID[]\');">' . $hc_lang_core['DeselectAll'] . '</a> ]
</div>
<?php
echo $myEvnt['Bitly'] != '' ? '
<a href="' . $myEvnt['Bitly'] . '.qrcode" target="_blank" rel="nofollow" class="icon qr">' . event_lang('QRCode') . '</a><br />' : '';
?>
<h2><?php
echo event_lang('Social');
?>
</h2>
<div class="socialT">
<a href="http://twitter.com/share" class="twitter-share-button" data-url="<?php
echo $myLnks['This'];
?>
" data-text="<?php
build_tweet($myEvnt['Title'] . ' @ ' . $myEvnt['Venue_Name'] . ' - ' . $myEvnt['Time'] . ' ' . event_lang('On') . ' ' . stampToDate($myEvnt['DateRaw'], $hc_cfg[24]));
?>
" data-count="horizontal">Tweet</a>
<script type="text/javascript" src="http://platform.twitter.com/widgets.js"></script>
</div>
<div class="socialG">
<g:plusone size="medium" count="true" href="<?php
echo $myLnks['This'];
?>
"></g:plusone>
<script type="text/javascript" src="https://apis.google.com/js/plusone.js"></script>
</div>
<div class="socialF">
<div class="fb-like" data-href="<?php
echo $myLnks['This'];
?>
break;
case 3:
$query .= " AND e.IsBillboard = 1 " . $gQuery . " ORDER BY e.StartDate, e.TBD ASC, e.StartTime, e.Title LIMIT " . $hc_cfg[60];
break;
}
$result = doQuery($query);
if (hasRows($result)) {
$x = 1;
fwrite($fp, 'var hc_events = {');
while ($row = mysql_fetch_row($result)) {
if ($row[4] == 0) {
$time = $row[3] != '' ? stampToDate($row[3], $hc_cfg[23]) : '';
} else {
$time = $row[4] == 1 ? $hc_lang_synd['AllDay'] : $hc_lang_synd['TBA'];
}
fwrite($fp, "\n\t" . '"' . $x . '":{"id":"' . $row[0] . '","title":"' . $row[1] . '","date":"' . stampToDate($row[2], $hc_cfg[14]) . '","time":"' . $time . '","catids":",0,' . $row[8] . ',"},');
++$x;
}
fwrite($fp, "\n};");
}
fwrite($fp, ob_get_contents());
fclose($fp);
ob_end_clean();
}
include $cache;
echo isset($_GET['t']) && is_numeric($_GET['t']) ? '
var showtime = ' . cIn($_GET['t']) : '0';
echo '
var stop = ' . (isset($_GET['z']) && is_numeric($_GET['z']) ? cIn($_GET['z']) : $hc_cfg[60]) . ';
var x = 0;
var date = "";';
/**
* Builds list of events for the template based on the passed query.
* @param string $qry Columns: PkID, Title, StartDate, StartTime, IsBillboard, SeriesID, TBD, EndTime
* @return string
*/
function getEventList($qry)
{
global $hc_lang_news, $hc_cfg;
$replace = $curDate = '';
$hide = array();
$cnt = 0;
$result = doQuery($qry);
$str = '<ul style="list-style:none;padding:0px;">';
while ($row = mysql_fetch_row($result)) {
if ($row[5] == '' || !in_array($row[5], $hide)) {
if ($curDate != $row[2]) {
$curDate = cOut($row[2]);
$str .= '<li>' . stampToDate($row[2], $hc_cfg[14]) . '</li>';
}
$str .= '<li style="padding-left:15px;"><a href="' . CalRoot . '/index.php?eID=' . $row[0] . '" target="_blank">' . $row[1] . '</a>';
if ($row[6] == 0) {
$str .= ' - ' . strftime($hc_cfg[23], strtotime($row[3])) . '</li>';
} elseif ($row[6] == 1) {
$str .= ' - <i>' . $hc_lang_news['AllDay'] . '</i></li>';
} elseif ($row[6] == 2) {
$str .= ' - <i>' . $hc_lang_news['TBA'] . '</i></li>';
}
}
if ($row[5] != '' && !in_array($row[5], $hide)) {
$hide[] = $row[5];
}
++$cnt;
}
$str .= '</ul>';
return $str;
}
<a class="tooltip" data-tip="' . $hc_lang_tools['Tip01'] . '" href="javascript:;"><img src="' . AdminRoot . '/img/icons/info.png" width="16" height="16" alt="" /></a>
</span>
<label for="group">' . $hc_lang_tools['GroupBy'] . '</label>
<select name="group" id="group">
<option' . ($groupBy == 0 ? ' selected="selected"' : '') . ' value="0">' . $hc_lang_tools['OptCategory'] . '</option>
<option' . ($groupBy == 1 ? ' selected="selected"' : '') . ' value="1">' . $hc_lang_tools['OptEvent'] . '</option>
<option' . ($groupBy == 2 ? ' selected="selected"' : '') . ' value="2">' . $hc_lang_tools['OptEventS'] . '</option>
<option' . ($groupBy == 3 ? ' selected="selected"' : '') . ' value="3">' . $hc_lang_tools['OptEventSC'] . '</option>
</select>
<span class="output">
<a class="tooltip" data-tip="' . $hc_lang_tools['Tip02'] . '" href="javascript:;"><img src="' . AdminRoot . '/img/icons/info.png" width="16" height="16" alt="" /></a>
</span>
<label for="dateFormat">' . $hc_lang_tools['DateFormat'] . '</label>
<select name="dateFormat" id="dateFormat">
<option' . ($dateFormat == 0 ? ' selected="selected"' : '') . ' value="0">' . $hc_lang_tools['Date0'] . ' (' . stampToDate(date("Y-m-d"), $hc_cfg[14]) . ')' . '</option>
<option' . ($dateFormat == 1 ? ' selected="selected"' : '') . ' value="1">' . $hc_lang_tools['Date1'] . ' (' . stampToDate(date("Y-m-d"), $hc_cfg[24]) . ')' . '</option>
<option' . ($dateFormat == 2 ? ' selected="selected"' : '') . ' value="2">' . $hc_lang_tools['Date2'] . ' (' . stampToDateAP(date("Y-m-d"), 1) . ')' . '</option>
</select>
</fieldset>
<fieldset>
<legend>' . $hc_lang_tools['TempVarsOper'] . '</legend>
<label>' . $hc_lang_tools['Variables'] . '</label>
<span class="output">
<a href="javascript:;" onclick="togVar();" id="tempLink">' . $hc_lang_tools['ShowVariables'] . '</a>
</span>
<div id="tempVars" style="display:none;">
<h5>' . $hc_lang_tools['VarLabelE'] . '</h5>
<p>
<span><a class="tooltip" data-tip="[event_id] - ' . $hc_lang_tools['Tip03'] . '" href="javascript:;"><img src="' . AdminRoot . '/img/icons/info.png" width="16" height="16" alt="" /></a>[event_id]</span>
<span><a class="tooltip" data-tip="[event_title] - ' . $hc_lang_tools['Tip04'] . '" href="javascript:;"><img src="' . AdminRoot . '/img/icons/info.png" width="16" height="16" alt="" /></a>[event_title]</span>
<span><a class="tooltip" data-tip="[event_desc] - ' . $hc_lang_tools['Tip05'] . '" href="javascript:;"><img src="' . AdminRoot . '/img/icons/info.png" width="16" height="16" alt="" /></a>[event_desc]</span>
$expire = mysql_result($result, 0, 41) > 0 ? cOut(mysql_result($result, 0, 41)) : $hc_cfg[134];
$locID = cOut(mysql_result($result, 0, 33));
$locName = $locID == 0 ? cOut(mysql_result($result, 0, 2)) : cOut(mysql_result($result, 0, 43));
$locAddress = $locID == 0 ? cOut(mysql_result($result, 0, 3)) : cOut(mysql_result($result, 0, 44));
$locAddress2 = $locID == 0 ? cOut(mysql_result($result, 0, 4)) : cOut(mysql_result($result, 0, 45));
$locCity = $locID == 0 ? cOut(mysql_result($result, 0, 5)) : cOut(mysql_result($result, 0, 46));
$state = $locID == 0 ? cOut(mysql_result($result, 0, 6)) : cOut(mysql_result($result, 0, 47));
$locPostal = $locID == 0 ? cOut(mysql_result($result, 0, 7)) : cOut(mysql_result($result, 0, 48));
$locCountry = $locID == 0 ? cOut(mysql_result($result, 0, 35)) : cOut(mysql_result($result, 0, 49));
$cost = cOut(mysql_result($result, 0, 34));
$rsvp_type = cOut(mysql_result($result, 0, 51));
$rsvp_space = cOut(mysql_result($result, 0, 55));
$rsvp_disp = cOut(mysql_result($result, 0, 56));
$rsvp_notice = cOut(mysql_result($result, 0, 57));
$rsvp_open = stampToDate(mysql_result($result, 0, 53), $hc_cfg[24]);
$rsvp_close = stampToDate(mysql_result($result, 0, 54), $hc_cfg[24]);
if ($tbd == 0) {
$startTimeHour = date($hc_time['format'], strtotime(mysql_result($result, 0, 9) . ' ' . mysql_result($result, 0, 10)));
$startTimeMins = date("i", strtotime(mysql_result($result, 0, 9) . ' ' . mysql_result($result, 0, 10)));
$startTimeAMPM = date("A", strtotime(mysql_result($result, 0, 9) . ' ' . mysql_result($result, 0, 10)));
if (mysql_result($result, 0, 12) != '') {
$endTimeHour = date($hc_time['format'], strtotime(mysql_result($result, 0, 9) . ' ' . mysql_result($result, 0, 12)));
$endTimeMins = date("i", strtotime(mysql_result($result, 0, 9) . ' ' . mysql_result($result, 0, 12)));
$endTimeAMPM = date("A", strtotime(mysql_result($result, 0, 9) . ' ' . mysql_result($result, 0, 12)));
} else {
$endTimeHour = date($hc_time['format'], strtotime(mysql_result($result, 0, 9) . ' ' . mysql_result($result, 0, 10) . ' +1 hour'));
$endTimeAMPM = date("A", strtotime(mysql_result($result, 0, 9) . ' ' . mysql_result($result, 0, 10) . ' +1 hour'));
$noEndTime = 1;
}
}
}
<div style="width:15%;">' . $hc_lang_reports['IP'] . '</div>
<div style="width:20%;">' . $hc_lang_reports['Date'] . '</div>
<div class="txt" style="width:30%">' . $hc_lang_reports['User'] . '</div>
<div class="tools" style="width:10%;"> </div>
</li>
</ul>
<ul class="data">
<div class="prpt">';
$cnt = 0;
while ($row = mysql_fetch_row($result)) {
$hl = $cnt % 2 == 1 ? ' hl' : '';
echo '
<li class="row' . $hl . '">
<div class="txt" title="' . cOut($row[1]) . '" style="width:25%;">' . cOut('(' . $row[0] . ') ' . trim($row[1] . ' ' . $row[2])) . '</div>
<div style="width:15%;">' . cOut($row[4]) . '</div>
<div style="width:20%;">' . stampToDate($row[6], $hc_cfg[24] . ' ' . $hc_cfg[23]) . '</div>
<div class="txt" title="' . cOut($row[5]) . '" style="width:30%;">' . cOut($row[5]) . '</div>
<div class="tools" style="width:10%;">
<a href="' . AdminRoot . '/index.php?com=adminedit&aID=' . $row[0] . '"><img src="' . AdminRoot . '/img/icons/user_edit.png" width="16" height="16" alt="" /></a>
<a href="javascript:;" onclick="doDelete(\'' . $row[7] . '\');return false;"><img src="' . AdminRoot . '/img/icons/delete.png" width="16" height="16" alt="" /></a>
</div>
</li>';
++$cnt;
}
echo '
</div>
</ul>
<script>
//<!--
function doDelete(dID){
if(confirm("' . $hc_lang_reports['Valid04'] . '\\n\\n ' . $hc_lang_reports['Valid05'] . '\\n ' . $hc_lang_reports['Valid06'] . '")){
echo '
</ul>
</div>';
}
$result = doQuery("SELECT FirstName, LastName, Email, RegisteredAt FROM " . HC_TblPrefix . "subscribers WHERE IsConfirm = 1 ORDER BY RegisteredAt DESC, LastName, FirstName LIMIT 50");
if (hasRows($result)) {
echo '
<ul class="data">
<li class="row header uline">
<div style="width:88%;">' . $hc_lang_reports['NewestUsers'] . '</div>
<div style="width:10%;">' . $hc_lang_reports['Registered'] . '</div>
<div style="width:2%;"> </div>
</li>
</ul>
<div class="ostat">
<ul class="data">';
$cnt = 0;
while ($row = mysql_fetch_row($result)) {
$hl = $cnt % 2 == 1 ? ' hl' : '';
echo '
<li class="row' . $hl . '">
<div class="txt" title="' . cOut($row[0]) . '" style="width:30%;">' . cOut(trim($row[1] . ', ' . $row[0])) . '</div>
<div style="width:60%;">' . cOut($row[2]) . '</div>
<div class="number" style="width:10%;">' . stampToDate($row[3], $hc_cfg[24]) . '</div>
</li>';
++$cnt;
}
echo '
</ul>
</div>';
}
$state = isset($_POST['locState']) ? cIn(strip_tags($_POST['locState'])) : '';
$country = isset($_POST['hc_f9']) ? cIn(strip_tags($_POST['hc_f9'])) : '';
$zip = isset($_POST['hc_f8']) ? cIn(strip_tags($_POST['hc_f8'])) : '';
$partySize = is_numeric($_POST['hc_f7']) ? cIn(strip_tags($_POST['hc_f7'])) + 1 : 0;
$result = doQuery("SELECT PkID FROM " . HC_TblPrefix . "registrants WHERE Email = '" . $regEmail . "' AND EventID = '" . $eID . "'");
if (hasRows($result)) {
header("Location: " . CalRoot . "/index.php?com=rsvp&eID=" . $eID . "&msg=1");
} else {
$result = doQuery("SELECT Title, StartDate, StartTime, TBD, ContactEmail FROM " . HC_TblPrefix . "events WHERE PkID = '" . $eID . "'");
$eventTitle = cOut(mysql_result($result, 0, 0));
$eventDate = stampToDate(mysql_result($result, 0, 1), $hc_cfg[14]);
$conEmail = mysql_result($result, 0, 4);
$groupID = $partySize > 1 ? md5($regName . $eventTitle . date("U")) : '';
$eMsg = '<p><b>' . mysql_result($result, 0, 0) . '</b><br />' . stampToDate(mysql_result($result, 0, 1), $hc_cfg[14]) . ' - ';
if (mysql_result($result, 0, 3) == 0) {
$eMsg .= stampToDate("1980-01-01 " . mysql_result($result, 0, 2), $hc_cfg[23]);
} elseif (mysql_result($result, 0, 3) == 1) {
$eMsg .= $hc_lang_rsvp['AllDay'];
} elseif (mysql_result($result, 0, 3) == 2) {
$eMsg .= $hc_lang_rsvp['TBA'];
}
$eMsg .= '<br /><a href="' . CalRoot . '/index.php?eID=' . $eID . '">' . CalRoot . '/index.php?eID=' . $eID . '</a></p>';
for ($x = 1; $x <= $partySize; $x++) {
$addName = $partySize > 1 ? $regName . " - " . $x . "/" . $partySize : $regName;
doQuery("INSERT into " . HC_TblPrefix . "registrants(Name, Email, Phone, Address, Address2, City, State, Zip, EventID, IsActive, RegisteredAt, GroupID)\r\n\t\t\t\t\tValues(\t'" . cIn($addName) . "',\r\n\t\t\t\t\t\t\t'" . $regEmail . "',\r\n\t\t\t\t\t\t\t'" . $phone . "',\r\n\t\t\t\t\t\t\t'" . $address . "','" . $address2 . "','" . $city . "','" . $state . "','" . $zip . "',\r\n\t\t\t\t\t\t\t'" . $eID . "',\r\n\t\t\t\t\t\t\t1, NOW(),\r\n\t\t\t\t\t\t\t'" . cIn($groupID) . "');");
}
$result = doQuery("SELECT COUNT(r.EventID), er.Space\r\n\t\t\t\t\t\t\tFROM " . HC_TblPrefix . "registrants r\r\n\t\t\t\t\t\t\t\tLEFT JOIN " . HC_TblPrefix . "eventrsvps er ON (r.EventID = er.EventID)\r\n\t\t\t\t\t\t\tWHERE r.EventID = '" . $eID . "' and r.IsActive = 1\r\n\t\t\t\t\t\t\tGROUP BY r.EventID, er.Space");
$eOver = $eLimit = 0;
if (mysql_result($result, 0, 0) > mysql_result($result, 0, 1) && mysql_result($result, 0, 1) != 0) {
$eOver = 1;
} elseif (mysql_result($result, 0, 0) == mysql_result($result, 0, 1) && mysql_result($result, 0, 1) != 0) {
function stampToDateAP($timeStamp, $useYear = 1)
{
$stampParts = explode(" ", $timeStamp);
$dateParts = explode("-", $stampParts[0]);
$dateFormat = $useYear == 1 ? ' %#d, %Y' : ' %#d';
switch ($dateParts[1]) {
case 1:
case 2:
case 8:
case 9:
case 10:
case 11:
case 12:
$dateFormat = '%b.' . $dateFormat;
break;
default:
$dateFormat = '%B' . $dateFormat;
break;
}
switch (stampToDate($timeStamp, '%w')) {
case 0:
$dateFormat = 'Sun., ' . $dateFormat;
break;
case 1:
$dateFormat = 'Mon., ' . $dateFormat;
break;
case 2:
$dateFormat = 'Tues., ' . $dateFormat;
break;
case 3:
$dateFormat = 'Wed., ' . $dateFormat;
break;
case 4:
$dateFormat = 'Thurs., ' . $dateFormat;
break;
case 5:
$dateFormat = 'Fri., ' . $dateFormat;
break;
case 6:
$dateFormat = 'Sat., ' . $dateFormat;
break;
}
$theDate = strftime($dateFormat, mktime(0, 0, 0, $dateParts[1], $dateParts[2], $dateParts[0]));
if (isset($stampParts[1])) {
$theDate .= ' ' . timeToAp($stampParts[1]);
}
return $theDate;
}
<legend>' . $hc_lang_admin['Summary'] . '</legend>
<label>' . $hc_lang_admin['LocStatus'] . '</label>
<span class="output">
' . ($fails >= $hc_cfg[80] ? '<span style="color:#E40000;">' . $hc_lang_admin['Locked'] . '</span>' : $hc_lang_admin['Unlocked']) . '
</span>
<label>' . $hc_lang_admin['LogCount'] . '</label>
<span class="output">
' . $logins . '
</span>
<label>' . $hc_lang_admin['LogFCount'] . '</label>
<span class="output">
' . $fails . '
</span>
<label>' . $hc_lang_admin['Login'] . '</label>
<span class="output">
' . stampToDate($lastlogin, $hc_cfg[24] . ' ' . $hc_cfg[23]) . '
</span>
<label>' . $hc_lang_admin['PasswordAge'] . '</label>
<span class="output">
' . ($passAge != '' ? daysDiff($passAge, date("Y-m-d")) - 1 : $hc_lang_admin['Unavailable']) . '
<a class="tooltip" data-tip="' . $hc_lang_admin['Tip01'] . '" href="javascript:;" tabindex="-1"><img src="' . AdminRoot . '/img/icons/info.png" width="16" height="16" alt="" /></a>
</span>
<label>' . $hc_lang_admin['Recent'] . '</label>
<div id="logins" class="output">
' . ($login_history != '' ? $login_history : $hc_lang_admin['Unavailable']) . '
</div>
</fieldset>';
}
echo '
<input type="submit" name="submit" id="submit" value="' . $hc_lang_admin['Save'] . '" />
</form>
function buildIt($content, $row)
{
global $expVars, $hc_cfg, $ext, $curDate, $curCategory, $sortBy, $dateFormat;
$built = "";
$built = $content;
$i = 1;
$stop = count($expVars);
while ($i <= $stop) {
$replace = 'BLANK';
switch ($expVars[$i]['tag']) {
case '[event_time_start]':
case '[event_time_end]':
if ($row[$expVars[$i]['field']] != '') {
switch ($dateFormat) {
case 0:
case 1:
$timepart = explode(":", $row[$expVars[$i]['field']]);
$replace = strftime($hc_cfg[23], mktime($timepart[0], $timepart[1], $timepart[2]));
break;
case 2:
$replace = timeToAP($row[$expVars[$i]['field']]);
break;
}
}
break;
case '[loc_name]':
$replace = $row[11] == 0 ? $row[12] : $row[19];
break;
case '[loc_address]':
$replace = $row[11] == 0 ? $row[13] : $row[20];
break;
case '[loc_address2]':
$replace = $row[11] == 0 ? $row[14] : $row[21];
break;
case '[loc_city]':
$replace = $row[11] == 0 ? $row[15] : $row[22];
break;
case '[loc_region]':
$replace = $row[11] == 0 ? $row[16] : $row[23];
break;
case '[loc_postal]':
$replace = $row[11] == 0 ? $row[17] : $row[24];
break;
case '[loc_country]':
$replace = $row[11] == 0 ? $row[18] : $row[25];
break;
case '[loc_url]':
case '[contact_url]':
if ($row[$expVars[$i]['field']] != 'http://') {
$replace = $row[$expVars[$i]['field']];
}
break;
case '[cal_url]':
$replace = CalRoot;
break;
case '[date_series]':
if ($row[27] != '') {
$replace = $row[27] != $row[28] && $row[28] != '' ? stampToDate($row[27], $hc_cfg[24]) . ' - ' . stampToDate($row[28], $hc_cfg[24]) : stampToDate($row[27], $hc_cfg[24]);
}
break;
case '[event_date]':
if ($row[$expVars[$i]['field']] != '') {
switch ($dateFormat) {
case 0:
case 1:
$timepart = explode(":", $row[$expVars[$i]['field']]);
$replace = $dateFormat == 0 ? stampToDate($row[$expVars[$i]['field']], $hc_cfg[14]) : stampToDate($row[$expVars[$i]['field']], $hc_cfg[24]);
break;
case 2:
$replace = stampToDateAP($row[$expVars[$i]['field']], 1);
break;
}
}
break;
case '[date_unique]':
if ($curDate != $row[$expVars[$i]['field']] && $row[$expVars[$i]['field']] != '') {
$curDate = $row[$expVars[$i]['field']];
$curCategory = $sortBy == 1 ? '' : $curCategory;
switch ($dateFormat) {
case 0:
case 1:
$timepart = explode(":", $row[$expVars[$i]['field']]);
$replace = $dateFormat == 0 ? stampToDate($row[$expVars[$i]['field']], $hc_cfg[14]) : stampToDate($row[$expVars[$i]['field']], $hc_cfg[24]);
break;
case 2:
$replace = stampToDateAP($row[$expVars[$i]['field']], 1);
break;
}
}
break;
case '[category_unique]':
if ($curCategory != $row[$expVars[$i]['field']]) {
$curCategory = $row[$expVars[$i]['field']];
$replace = $row[$expVars[$i]['field']];
$curDate = $sortBy == 0 ? '' : $curDate;
}
break;
case '[desc_notags]':
if ($row[$expVars[$i]['field']] != '') {
$replace = strip_tags(cleanBreaks($row[$expVars[$i]['field']]));
}
break;
default:
if ($row[$expVars[$i]['field']] != '') {
$replace = cleanBreaks($row[$expVars[$i]['field']]);
}
break;
}
$built = $ext == '.csv' ? str_replace($expVars[$i]['tag'], str_replace(",", "", $replace), $built) : str_replace($expVars[$i]['tag'], $replace, $built);
++$i;
}
return $built;
}
/**
* Output wall calendar style monthly mini-calendar. Writes cache files if not currently available.
* @since 2.0.0
* @version 2.0.0
* @param string $date [optional] calendar month to create (Default: current browse date)
* @return void
*/
function ou_mini_cal_month($date = '')
{
global $lID, $favQ1, $favQ2, $hc_cfg, $hc_lang_config;
$year = HCYEAR;
$month = HCMONTH;
if ($date != '') {
$year = date("Y", strtotime($date));
$month = date("m", strtotime($date));
}
if (!file_exists(HCPATH . '/cache/mcal_' . $year . '_' . $month)) {
ob_start();
$fp = fopen(HCPATH . '/cache/mcal_' . $year . '_' . $month, 'w');
$stopDay = date("t", mktime(0, 0, 0, $month, 1, $year));
$locSaver = $lQuery = $opts = $dow = '';
$events = array();
$result = doQuery("SELECT DISTINCT e.StartDate\r\n\t\t\t\t\t\t\tFROM " . HC_TblPrefix . "events e\r\n\t\t\t\t\t\t\t\tLEFT JOIN " . HC_TblPrefix . "eventcategories ec ON (ec.EventID = e.PkID)\r\n\t\t\t\t\t\t\t\tLEFT JOIN " . HC_TblPrefix . "locations l ON (e.LocID = l.PkID)\r\n\t\t\t\t\t\t\tWHERE e.StartDate BETWEEN '" . date("Y-m-d", mktime(0, 0, 0, $month, 1, $year)) . "' AND '" . date("Y-m-d", mktime(0, 0, 0, $month + 1, 0, $year)) . "'\r\n\t\t\t\t\t\t\tAND e.IsActive = 1 AND e.IsApproved = 1\r\n\t\t\t\t\t\t\tORDER BY e.StartDate");
if (hasRows($result)) {
while ($row = mysql_fetch_row($result)) {
$events[] = stampToDate($row[0], $hc_cfg[93]);
}
}
$navBack = date("Y-m-d", mktime(0, 0, 0, $month - 1, 1, $year));
$navFrwd = date("Y-m-d", mktime(0, 0, 0, $month + 1, 1, $year));
$bak = $hc_cfg['First'] > strtotime(HCDATE) || HCDATE <= SYSDATE && $hc_cfg[11] == 0 ? '<a href="#" rel="nofollow"><</a>' : '<a href="' . CalRoot . '/?d=' . $navBack . $locSaver . '" rel="nofollow"><</a>';
$fwd = $hc_cfg['Last'] > strtotime($navFrwd) ? '<a href="' . CalRoot . '/?d=' . $navFrwd . $locSaver . '" rel="nofollow">></a>' : '<a href="#" rel="nofollow">></a>';
$jmp = $hc_cfg[11] == 1 ? 12 : 0;
$stop = $jmp + 12;
$jumpMonth = date("n", mktime(0, 0, 0, $month - $jmp, 1, $year));
$jumpYear = date("Y", mktime(0, 0, 0, $month - $jmp, 1, $year));
$sysDay = date("d", strtotime(SYSDATE));
$sysMonth = date("m", strtotime(SYSDATE));
$sysYear = date("y", strtotime(SYSDATE));
$actJump = date("Y-m-d", mktime(0, 0, 0, $month, 1, $year));
$i = 0;
while ($i <= $stop) {
$jmpDate = date("Y-m-d", mktime(0, 0, 0, $jumpMonth + $i, 1, $jumpYear));
$select = $jmpDate == $actJump ? ' selected="selected"' : '';
$opts .= '
<option value="' . CalRoot . '/?d=' . $jmpDate . $locSaver . '&b=1"' . $select . '>' . strftime($hc_cfg[92], mktime(0, 0, 0, $jumpMonth + $i, 1, $jumpYear)) . '</option>';
++$i;
}
$i = 0;
while ($i < 7) {
$dow .= '
<td class="dow">' . $hc_lang_config['MiniCalDays'][($hc_cfg[22] + $i) % 7] . '</td>';
++$i;
}
echo '
<form name="frmJump" id="frmJump" action="#">
<table class="mini-cal table table-bordered">
<tr>
<td class="nav">' . $bak . '</td>
<td class="title" colspan="5">
<select name="jumpMonth" id="jumpMonth" onchange="window.location.href=this.value;">' . $opts . '
</select>
</td>
<td class="nav">' . $fwd . '</td>
</tr>
<tr>
' . $dow . '
</tr>
<tr>';
$i = 0;
$fillCnt = (date("w", mktime(0, 0, 0, $month, 1, $year)) - $hc_cfg[22] + 7) % 7;
while ($i < $fillCnt) {
echo '
<td class="blank"> </td>';
++$i;
}
$i = 1;
while ($i <= $stopDay) {
echo $i > 1 && ($i + $fillCnt) % 7 == 1 ? '
</tr>
<tr>' : '';
if (in_array($i, $events)) {
$cell = SYSDATE == date("Y-m-d", mktime(0, 0, 0, $month, $i, $year)) ? 'today' : 'events';
echo '
<td class="' . $cell . '"><a href="' . CalRoot . '/index.php?d=' . $year . '-' . $month . '-' . $i . '&m=1' . $locSaver . '" rel="nofollow">' . strftime($hc_cfg[93], mktime(0, 0, 0, $month, $i, $year)) . '</a></td>';
} else {
$cell = SYSDATE == date("Y-m-d", mktime(0, 0, 0, $month, $i, $year)) ? 'today' : 'empty';
echo '
<td class="' . $cell . '">' . strftime($hc_cfg[93], mktime(0, 0, 0, $month, $i, $year)) . '</td>';
}
++$i;
}
$i = ($i + $fillCnt - 1) % 7;
while ($i < 7 && $i != 0) {
echo '
<td class="blank"> </td>';
++$i;
}
echo '
</tr>
</table>
</form>';
fwrite($fp, ob_get_contents());
fclose($fp);
ob_end_clean();
}
include HCPATH . '/cache/mcal_' . $year . '_' . $month;
}
