case "2":
feedback(1, $hc_lang_search['Feed02']);
break;
}
switch ($sID) {
case 1:
appInstructions(0, "Editing_Events", $hc_lang_search['TitleEdit'], $hc_lang_search['InstructEdit']);
break;
case 2:
appInstructions(0, "Deleting_Events", $hc_lang_search['TitleDelete'], $hc_lang_search['InstructDelete']);
break;
case 3:
appInstructions(0, "Event_Series", $hc_lang_search['TitleSeries'], $hc_lang_search['InstructSeries']);
break;
default:
appInstructions(0, "Reports", $hc_lang_search['TitleReport'], $hc_lang_search['InstructReport']);
break;
}
echo '
<form name="frmEventSearch" id="frmEventSearch" method="post" action="' . AdminRoot . '/index.php?com=searchresults" onsubmit="return validate();">
<input type="hidden" name="sID" id="sID" value="' . $sID . '" />
<input type="hidden" id="locPreset" name="locPreset" value="0" />
<input type="hidden" id="locPresetName" name="locPresetName" value="" />
<input type="hidden" id="usrID" name="usrID" value="0" />
<fieldset>
<legend>' . $hc_lang_search['DateTitle'] . '</legend>
<label>' . $hc_lang_search['DateRange'] . '</label>
<input name="startDate" id="startDate" type="text" size="12" maxlength="10" value="' . strftime($hc_cfg[24], strtotime(SYSDATE)) . '" required="required" />
<a href="javascript:;" onclick="calx.select(document.getElementById(\'startDate\'),\'cal1\',\'' . $hc_cfg[51] . '\');return false;" id="cal1" class="ds calendar" tabindex="-1"></a>
<span class="output"> ' . $hc_lang_search['To'] . ' </span>
<input name="endDate" id="endDate" type="text" size="12" maxlength="10" value="' . strftime($hc_cfg[24], strtotime(SYSDATE) + $hc_cfg[53] * 86400) . '" required="required" />
* @package Helios Calendar
* @license GNU General Public License version 2 or later; see LICENSE
*/
if (!defined('hcAdmin')) {
header("HTTP/1.1 403 No Direct Access");
exit;
}
include HCLANG . '/admin/manage.php';
if (isset($_GET['msg'])) {
switch ($_GET['msg']) {
case "1":
feedback(1, $hc_lang_manage['Feed01']);
break;
}
}
appInstructions(0, "Billboard_Events", $hc_lang_manage['TitleBillboard'], $hc_lang_manage['InstructBillboard']);
$result = doQuery("SELECT PkID, Title, StartDate, Views FROM " . HC_TblPrefix . "events WHERE IsActive = 1 AND IsApproved = 1 AND IsBillboard = 1 AND StartDate >= '" . cIn(SYSDATE) . "' ORDER BY StartDate, Views DESC");
if (hasRows($result)) {
echo '
<ul class="data">
<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)) {
switch ($_GET['msg']) {
case "1":
feedback(1, $hc_lang_admin['Feed03']);
break;
case "2":
feedback(3, $hc_lang_admin['Feed04']);
break;
case "3":
feedback(1, $hc_lang_admin['Feed05']);
break;
case "4":
feedback(1, $hc_lang_admin['Feed06']);
break;
}
}
appInstructions(0, "Editing_Admin_Users", $hc_lang_admin['TitleBrowseA'], $hc_lang_admin['InstructBrowseA']);
$result = doQuery("SELECT PkID, FirstName, LastName, Email, LastLogin FROM " . HC_TblPrefix . "admin WHERE IsActive = 1 AND SuperAdmin = 0 ORDER BY LastName, FirstName");
if (hasRows($result)) {
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 . '">
$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;
}
}
}
}
$hc_Side[] = array('javascript:;', 'followup.png', $hc_lang_core['LinkFollow'], 0, 'follow_up();return false;');
appInstructions(0, $docLink, $hc_lang_event[$hlpTitle], $hc_lang_event[$hlpDesc]);
$stime_disabled = $tbd > 0 ? ' disabled="disabled"' : '';
$etime_disabled = isset($noEndTime) || $tbd > 0 ? ' disabled="disabled"' : '';
echo '
<form id="frmEventAdd" name="frmEventAdd" method="post" action="' . AdminRoot . '/components/EventAddAction.php" onsubmit="return validate();">';
set_form_token();
echo '
<input type="hidden" id="locPreset" name="locPreset" value="' . $locID . '" />
<input type="hidden" id="locPresetName" name="locPresetName" value="' . $locName . '" />
<fieldset id="follow-up" style="display:none;">
<legend>' . $hc_lang_event['FollowLabel'] . '</legend>
<label for="follow_up">' . $hc_lang_event['Follow'] . '</label>
<select name="follow_up" id="follow_up"' . ($followup == 0 ? ' disabled="disabled"' : '') . '>
<option value="0">' . $hc_lang_event['Follow0'] . '</option>
<option selected="selected" value="1">' . $hc_lang_event['Follow1'] . '</option>
</select>
if (!defined('hcAdmin')) {
header("HTTP/1.1 403 No Direct Access");
exit;
}
include HCLANG . '/admin/tools.php';
if (isset($_GET['msg'])) {
switch ($_GET['msg']) {
case "1":
feedback(1, $hc_lang_tools['Feed02']);
break;
case "2":
feedback(2, $hc_lang_tools['Feed01']);
break;
}
}
appInstructions(0, "Event_Import", $hc_lang_tools['TitleImport'], $hc_lang_tools['InstructImport']);
$token = set_form_token(1);
$hc_Side[] = array(AdminRoot . '/components/ToolImportAction.php?samp=1&tkn=' . $token, 'download_csv.png', $hc_lang_tools['LinkTemplate'], 0);
echo '
<form name="frmEventImport" id="frmEventImport" method="post" action="' . AdminRoot . '/components/ToolImportAction.php" onsubmit="return validate();">
<input type="hidden" name="token" id="token" value="' . $token . '" />
<fieldset>
<legend>' . $hc_lang_tools['ImportLabel'] . '</legend>
<label for="impType">' . $hc_lang_tools['Import'] . '</label>
<select name="impType" id="impType" onchange="toggleMe(document.getElementById(\'csv\'));">
<option value="0">' . $hc_lang_tools['Import0'] . '</option>
<option value="1">' . $hc_lang_tools['Import1'] . '</option>
</select>
</fieldset>
<div id="csv">
<fieldset>
if (hasRows($result)) {
$instTitle = $hc_lang_register['TitleRegisterE'];
$instText = $hc_lang_register['InstructRegisterE'];
$name = mysql_result($result, 0, 1);
$email = mysql_result($result, 0, 2);
$phone = mysql_result($result, 0, 3);
$address = mysql_result($result, 0, 4);
$address2 = mysql_result($result, 0, 5);
$city = mysql_result($result, 0, 6);
$state = mysql_result($result, 0, 7);
$postal = mysql_result($result, 0, 8);
}
$inputs = array(1 => array('City', 'city', $city), 2 => array('Postal', 'zip', $postal));
$first = $hc_lang_config['AddressType'] == 1 ? 1 : 2;
$second = $first == 1 ? 2 : 1;
appInstructions(0, "", $instTitle, $instText);
if ($eID > 0) {
echo '
<form id="frm" name="frm" method="post" action="' . AdminRoot . '/components/RegisterAddAction.php" onsubmit="return validate();">
<input name="oldemail" id="oldemail" type="hidden" value="' . $email . '" />
<input name="eventID" id="eventID" type="hidden" value="' . $eID . '" />
<input name="rID" id="rID" type="hidden" value="' . $rID . '" />
<fieldset>
<legend>' . $hc_lang_register['RegLabel'] . '</legend>
<label for="name">' . $hc_lang_register['Name'] . '</label>
<input name="name" id="name" type="text" size="20" maxlength="50" value="' . $name . '" required="required" />
<label for="name">' . $hc_lang_register['Email'] . '</label>
<input name="email" id="email" type="email" size="40" maxlength="75" value="' . $email . '" required="required" />
<label for="phone">' . $hc_lang_register['Phone'] . '</label>
<input name="phone" id="phone" type="text" size="20" maxlength="25" value="' . $phone . '" />
<label for="address">' . $hc_lang_register['Address'] . '</label>
* @package Helios Calendar
* @license GNU General Public License version 2 or later; see LICENSE
*/
if (!defined('hcAdmin')) {
header("HTTP/1.1 403 No Direct Access");
exit;
}
include HCLANG . '/admin/pages.php';
if (isset($_GET['msg'])) {
switch ($_GET['msg']) {
case "1":
feedback(1, $hc_lang_pages['Feed01']);
break;
}
}
appInstructions(0, "Digest", $hc_lang_pages['TitleDigest'], $hc_lang_pages['InstructDigest']);
$aID = isset($_GET['aID']) && is_numeric($_GET['aID']) ? cIn($_GET['aID']) : 0;
$result = doQuery("SELECT * FROM " . HC_TblPrefix . "settings WHERE PkID IN (97,98,99)");
$status = 0;
$newFor = 1;
$welcomeMsg = '';
if (hasRows($result)) {
$status = cOut(mysql_result($result, 0, 1));
$welcomeMsg = cOut(mysql_result($result, 1, 1));
$newFor = cOut(mysql_result($result, 2, 1));
}
echo '
<form name="frmDigest" id="frmDigest" method="post" action="' . AdminRoot . '/components/DigestAction.php" onsubmit="return validate();">';
set_form_token();
echo '
<fieldset>
<?php
/**
* @package Helios Calendar
* @license GNU General Public License version 2 or later; see LICENSE
*/
if (!defined('hcAdmin')) {
header("HTTP/1.1 403 No Direct Access");
exit;
}
include HCLANG . '/admin/reports.php';
appInstructions(0, "Reports#Duplicate_Event_Report", $hc_lang_reports['TitleDup'], $hc_lang_reports['InstructDup']);
if (isset($_GET['msg'])) {
switch ($_GET['msg']) {
case "1":
feedback(1, $hc_lang_reports['Feed01']);
break;
}
}
$compTitle = !isset($_GET['t']) ? 'e1.Title = e2.Title AND ' : '';
$token = set_form_token(1);
$result = doQuery("SELECT e1.PkID as `First`, e1.Title as Title1, e1.StartDate as Date1, e1.LocID as LocID1, e1.LocationName, l.Name,\r\n\t\t\t\t\t\te2.PkID as `Duplicate`, e2.Title as Title2, e2.StartDate as Date2, e2.LocID as LocID2, e2.LocationName, l.Name\r\n\t\t\t\t\tFROM " . HC_TblPrefix . "events e1\r\n\t\t\t\t\t LEFT JOIN " . HC_TblPrefix . "events e2 ON (" . $compTitle . "e1.StartDate = e2.StartDate AND e1.StartTime = e2.StartTime AND e1.LocID = e2.LocID)\r\n\t\t\t\t\t LEFT JOIN " . HC_TblPrefix . "locations l ON (l.PkID = e1.LocID OR l.PkID = e2.LocID)\r\n\t\t\t\t\tWHERE e1.PkID != e2.PkID AND e1.IsActive = 1 AND e2.IsActive = 1 AND e1.IsApproved = 1 AND e2.IsApproved = 1\r\n\t\t\t\t\t\r\n\t\t\t\t\tORDER BY e1.PkID");
echo '
<form name="eventDuplicateRpt" id="eventDuplicateRpt" method="post" action="' . AdminRoot . '/components/EventDelete.php" onsubmit="return validate();">
<input type="hidden" name="token" id="token" value="' . $token . '" />
<fieldset style="border:0;">
<span class="frm_ctrls">
<label><input type="checkbox" onclick="window.location.href=\'' . AdminRoot . '/index.php?com=reportdup' . (!isset($_GET['t']) ? '&t=1\'" checked="checked" /> ' : '\'" /> ') . $hc_lang_reports['IncludeTitle'] . '</label>
</span>
</fieldset>';
if (hasRows($result)) {
<?php
/**
* @package Helios Calendar
* @license GNU General Public License version 2 or later; see LICENSE
*/
if (!defined('hcAdmin')) {
header("HTTP/1.1 403 No Direct Access");
exit;
}
include HCLANG . '/admin/newsletter.php';
appInstructions(0, "Sending_Newsletters", $hc_lang_news['TitleSend'], $hc_lang_news['InstructSend']);
$nID = isset($_GET['nID']) && is_numeric($_GET['nID']) ? cIn(strip_tags($_GET['nID'])) : 0;
$result = doQuery("SELECT PkID, Subject, SendCount FROM " . HC_TblPrefix . "newsletters WHERE PkID = '" . $nID . "' AND IsActive = 1 AND Status < 3");
if (hasRows($result)) {
echo '
<fieldset>
<legend>' . $hc_lang_news['ProgressLabel'] . '</legend>
<label>' . $hc_lang_news['MailSubject'] . '</label>
<span class="output">' . mysql_result($result, 0, 1) . '</span>
<label>' . $hc_lang_news['MailingSize'] . '</label>
<span class="output">' . number_format(mysql_result($result, 0, 2), 0, '.', ',') . ' ' . $hc_lang_news['Subscribers'] . '</span>
<label>' . $hc_lang_news['Progress'] . '</label>
<iframe src="' . AdminRoot . '/components/NewsletterProgress.php?n=' . $nID . '" name="progress" id="progress" border="0" scrolling="no"></iframe>
</fieldset>
<a href="#" onclick="startMailer(1);" class="newsSend">' . $hc_lang_news['Send'] . '</a>
<a href="#" onclick="startMailer(0);" class="newsPause">' . $hc_lang_news['Pause'] . '</a>
<div id="pauseIt" style="display:none;"></div>
<?php
/**
* @package Helios Calendar
* @license GNU General Public License version 2 or later; see LICENSE
*/
if (!defined('hcAdmin')) {
header("HTTP/1.1 403 No Direct Access");
exit;
}
include HCLANG . '/admin/reports.php';
$eID = isset($_POST['eventID']) ? implode(',', array_filter($_POST['eventID'], 'is_numeric')) : array();
$hc_Side[] = array('javascript:doDownload();', 'download_csv.png', $hc_lang_reports['DownloadRep'], 0);
appInstructions(0, "Reports", $hc_lang_reports['TitleAct'], $hc_lang_reports['InstructAct']);
echo '
<p><a href="' . AdminRoot . '/index.php?com=eventsearch" class="add"><img src="' . AdminRoot . '/img/icons/report.png" width="16" height="16" alt="" />' . $hc_lang_reports['NewReport'] . '</a></p>';
if (count($eID) > 0) {
$result = doQuery("SELECT e.PkID, e.Title, e.StartDate, e.Views, e.Directions, e.Downloads, e.EmailToFriend, e.URLClicks\r\n\t\t\t\t\t\tFROM " . HC_TblPrefix . "events e\r\n\t\t\t\t\t\tWHERE e.PkID IN(" . cIn($eID) . ") ORDER BY e.PkID");
if (hasRows($result)) {
$mViews = $mDir = $mDwnl = $mEmail = $mURL = $aViews = $aDir = $aDwnl = $aEmail = $aURL = $cnt = 0;
$resultX = doQuery("SELECT MAX(Views), MAX(Directions), MAX(Downloads), MAX(EmailToFriend), MAX(URLClicks),\r\n\t\t\t\t\t\t\t\t\tAVG(Views), AVG(Directions), AVG(Downloads), AVG(EmailToFriend), AVG(URLClicks)\r\n\t\t\t\t\t\t\tFROM " . HC_TblPrefix . "events\r\n\t\t\t\t\t\t\tWHERE IsActive = 1 AND IsApproved = 1");
if (hasRows($resultX)) {
$mViews = cOut(mysql_result($resultX, 0, 0));
$mDir = cOut(mysql_result($resultX, 0, 1));
$mDwnl = cOut(mysql_result($resultX, 0, 2));
$mEmail = cOut(mysql_result($resultX, 0, 3));
$mURL = cOut(mysql_result($resultX, 0, 4));
$aViews = cOut(round(mysql_result($resultX, 0, 5), 0));
$aDir = cOut(round(mysql_result($resultX, 0, 6), 0));
$aDwnl = cOut(round(mysql_result($resultX, 0, 7), 0));
$aEmail = cOut(round(mysql_result($resultX, 0, 8), 0));
$pages = ceil(mysql_result($resultC, 0, 0) / $resLimit);
$resOffset = $pages <= $resOffset && $pages > 0 ? $pages - 1 : $resOffset;
if (isset($_GET['msg'])) {
switch ($_GET['msg']) {
case "1":
feedback(1, $hc_lang_user['Feed01']);
break;
case "2":
feedback(1, $hc_lang_user['Feed02']);
break;
case "3":
feedback(1, $hc_lang_user['Feed03']);
break;
}
}
appInstructions(0, "Manage_Users", $hc_lang_user['TitleManage'], $hc_lang_user['InstructManage']);
echo '
<fieldset style="border:0px;">
<label><b>' . $hc_lang_user['UserLabel'] . '</b></label>
<span class="output">' . ($ban == 0 ? '<b>' . $hc_lang_user['UserStatus0'] . '</b>' : '<a href="' . AdminRoot . '/index.php?com=user&a=' . $resLimit . $save . '">' . $hc_lang_user['UserStatus0'] . '</a>') . ' | ' . ($ban == 1 ? '<b>' . $hc_lang_user['UserStatus1'] . '</b>' : '<a href="' . AdminRoot . '/index.php?com=user&b=1&a=' . $resLimit . $save . '">' . $hc_lang_user['UserStatus1'] . '</a>') . '
</span>
<label><b>' . $hc_lang_user['ResPer'] . '</b></label>
<span class="output">';
$save .= $ban == 1 ? '&b=1' : '';
for ($x = 25; $x <= 100; $x = $x + 25) {
echo $x > 25 ? ' | ' : '';
echo $x != $resLimit ? '<a href="' . AdminRoot . '/index.php?com=user&p=' . $resOffset . '&a=' . $x . $save . '">' . $x . '</a>' : '<b>' . $x . '</b>';
}
echo '
</span>
<label><b>' . $hc_lang_user['Page'] . '</b></label>
$helpText = $hc_lang_locations['InstructEdit'];
}
if (isset($_GET['msg'])) {
switch ($_GET['msg']) {
case "1":
feedback(1, $hc_lang_locations['Feed01']);
break;
case "2":
feedback(1, $hc_lang_locations['Feed02']);
break;
}
}
if ($followup == 0) {
$hc_Side[] = array('javascript:;', 'followup.png', $hc_lang_core['LinkFollow'], 0, 'follow_up();return false;');
}
appInstructions(0, $helpDoc, $whereAmI . " Location", $helpText);
$inputs = array(1 => array('City', 'city', $city), 2 => array('Postal', 'zip', $postal));
$first = $hc_lang_config['AddressType'] == 1 ? 1 : 2;
$second = $first == 1 ? 2 : 1;
echo '
<form name="frmLocEdit" id="frmLocEdit" method="post" action="' . AdminRoot . '/components/LocationEditAction.php" onsubmit="return validate();">';
set_form_token();
echo '
<input name="lID" id="lID" type="hidden" value="' . $lID . '" />
<fieldset id="follow-up"' . ($followup == 0 ? ' style="display:none;"' : '') . '>
<legend>' . $hc_lang_locations['FollowLabel'] . '</legend>
<label for="follow_up">' . $hc_lang_locations['Follow'] . '</label>
<select name="follow_up" id="follow_up"' . ($followup == 0 ? ' disabled="disabled"' : '') . '>
<option value="0">' . $hc_lang_locations['Follow0'] . '</option>
<option selected="selected" value="1">' . $hc_lang_locations['Follow1'] . '</option>
</select>
makeTinyMCE('99%', 1, $ovrEdit, 'tempsource');
} else {
if (isset($_GET['msg'])) {
switch ($_GET['msg']) {
case "1":
feedback(1, $hc_lang_news['Feed07']);
break;
case "2":
feedback(1, $hc_lang_news['Feed08']);
break;
case "3":
feedback(1, $hc_lang_news['Feed09']);
break;
}
}
appInstructions(0, "Newsletter_Templates", $hc_lang_news['TitleEditN'], $hc_lang_news['InstructEditNL']);
echo '
<a href="' . AdminRoot . '/index.php?com=mailtmplt&nID=0" class="add"><img src="' . AdminRoot . '/img/icons/add.png" width="16" height="16" alt="" />' . $hc_lang_news['NewTemplate'] . '</a>';
$result = doQuery("SELECT * FROM " . HC_TblPrefix . "templatesnews WHERE IsActive = 1 AND PkID ORDER BY TemplateName");
if (hasRows($result)) {
$cnt = 0;
echo '
<ul class="data">
<li class="row header uline">
<div style="width:55%;">' . $hc_lang_news['TemplateName'] . '</div>
<div style="width:30%;">' . $hc_lang_news['TemplateMsg'] . '</div>
<div style="width:15%;"> </div>
</li>';
while ($row = mysql_fetch_row($result)) {
$hl = $cnt % 2 == 1 ? ' hl' : '';
echo '
if (!defined('hcAdmin')) {
header("HTTP/1.1 403 No Direct Access");
exit;
}
include HCLANG . '/admin/settings.php';
if (isset($_GET['msg'])) {
switch ($_GET['msg']) {
case "1":
feedback(1, $hc_lang_settings['Feed01']);
break;
case "2":
feedback(2, $hc_lang_settings['Feed05']);
break;
}
}
appInstructions(0, "Preferences", $hc_lang_settings['TitleSettings'], $hc_lang_settings['InstructSettings']);
$result = doQuery("SELECT SettingValue FROM " . HC_TblPrefix . "settings\r\n\t\t\t\t\tWHERE PkID IN (1,2,3,4,8,9,10,11,12,13,14,15,21,22,23,24,26,28,29,30,31,32,33,34,35,40,44,48,\r\n\t\t\t\t\t\t\t\t53,54,60,65,66,67,68,70,71,72,73,74,75,76,77,78,79,80,81,82,87,88,89,90,91,92,93,\r\n\t\t\t\t\t\t\t\t106,107,108,109,126)\r\n\t\t\t\t\tORDER BY PkID");
$token = set_form_token(1);
$submit = cOut(mysql_result($result, 0, 0));
$rssMax = cOut(mysql_result($result, 1, 0));
$passApprove = cOut(mysql_result($result, 2, 0));
$passDecline = cOut(mysql_result($result, 3, 0));
$driving = cOut(mysql_result($result, 4, 0));
$weather = cOut(mysql_result($result, 5, 0));
$mostPopular = cOut(mysql_result($result, 6, 0));
$browsePast = cOut(mysql_result($result, 7, 0));
$maxShow = cOut(mysql_result($result, 8, 0));
$fillMax = cOut(mysql_result($result, 9, 0));
$dateFormat = cOut(mysql_result($result, 10, 0));
$showTime = cOut(mysql_result($result, 11, 0));
$state = cOut(mysql_result($result, 12, 0));
* @package Helios Calendar
* @license GNU General Public License version 2 or later; see LICENSE
*/
if (!defined('hcAdmin')) {
header("HTTP/1.1 403 No Direct Access");
exit;
}
include HCLANG . '/admin/reports.php';
if (isset($_GET['msg'])) {
switch ($_GET['msg']) {
case "1":
feedback(1, $hc_lang_reports['Feed02']);
break;
}
}
appInstructions(0, "Reports", $hc_lang_reports['TitleFail'], $hc_lang_reports['InstructFail']);
$result = doQuery("SELECT a.PkID, a.FirstName, a.LastName, a.Email, alh.IP, alh.`Client`, alh.LoginTime, alh.PkID\r\n\t\t\t\t\tFROM " . HC_TblPrefix . "adminloginhistory alh\r\n\t\t\t\t\t\tLEFT JOIN " . HC_TblPrefix . "admin a ON (a.PkID = alh.AdminID)\r\n\t\t\t\t\tWHERE alh.IsFail = 1 AND a.SuperAdmin = 0\r\n\t\t\t\t\tORDER BY LoginTime DESC LIMIT 200");
if (hasRows($result)) {
echo '
<ul class="data">
<li class="row header uline">
<div class="txt" style="width:25%;"> </div>
<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;
$allSub += $row[0] == 1 ? 1 : 0;
$groups .= $cnt > 0 ? ', ' : '';
$groups .= cOut($row[1]);
++$cnt;
}
}
}
if ($allSub > 0) {
$resultS = doQuery("SELECT COUNT(PkID) FROM " . HC_TblPrefix . "subscribers WHERE IsConfirm = 1");
} else {
$resultS = doQuery("SELECT COUNT(DISTINCT sgs.UserID)\r\n\t\t\t\t\t\t\t\tFROM " . HC_TblPrefix . "subscribersgroups sgs\r\n\t\t\t\t\t\t\t\t\tLEFT JOIN " . HC_TblPrefix . "mailgroups mg ON (sgs.GroupID = mg.PkID AND mg.IsActive = 1)\r\n\t\t\t\t\t\t\t\t\tLEFT JOIN " . HC_TblPrefix . "mailersgroups mgs ON (mgs.GroupID = sgs.GroupID)\r\n\t\t\t\t\t\t\t\t\tLEFT JOIN " . HC_TblPrefix . "mailers m ON (mgs.MailerID = m.PkID AND m.IsActive = 1)\r\n\t\t\t\t\t\t\t\t\tLEFT JOIN " . HC_TblPrefix . "subscribers s ON (s.PkID = sgs.UserID)\r\n\t\t\t\t\t\t\t\tWHERE m.PkID = '" . $mID . "' AND s.IsConfirm = 1");
}
$subCnt = mysql_result($resultS, 0, 0);
$resultE = doQuery("SELECT COUNT(DISTINCT e.PkID)\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 (e.PkID = ec.EventID)\r\n\t\t\t\t\t\t\t\tLEFT JOIN " . HC_TblPrefix . "categories c ON (c.PkID = ec.CategoryID)\r\n\t\t\t\t\t\t\tWHERE e.IsActive = 1 AND e.IsApproved = 1 AND (ec.EventID IS NOT NULL AND c.IsActive = 1)\r\n\t\t\t\t\t\t\tAND e.StartDate BETWEEN '" . cIn($mStart) . "' AND '" . cIn($mEnd) . "'");
$eCnt = $now > $mEnd ? 0 : mysql_result($resultE, 0, 0);
appInstructions(0, "Create_Newsletter", $hc_lang_news['TitleCreate'], $hc_lang_news['InstructCreateB']);
$stop = $subCnt == 0 ? 4 : 0;
$stop = $groups == '' ? 2 : $stop;
$stop = mysql_result($result, 0, 7) == '' ? 3 : $stop;
$stopMsg = $stop > 0 ? '<span class="alert">' . $hc_lang_news['NewsStop'] . ' ' . $hc_lang_news['NewsStop' . $stop] . '</span>' : '';
echo '
<form name="frmNewsletter" id="frmNewsletter" method="post" action="' . AdminRoot . '/components/MailQueueAction.php">';
set_form_token();
echo '
<input type="hidden" name="mID" id="mID" value="' . $mID . '" />
<input type="hidden" name="next" id="next" value="0" />
<fieldset>
<legend>' . $hc_lang_news['Summary'] . '</legend>
<label> </label>
<span class="output"><b>' . number_format($subCnt, 0, '.', ',') . '</b> ' . $hc_lang_news['SubStats'] . '</span>
<label> </label>
$queryS = " AND (FirstName LIKE('%" . $term . "%') OR LastName LIKE('%" . $term . "%') OR Email LIKE('%" . $term . "%'))";
}
$resultC = doQuery("SELECT COUNT(*) FROM " . HC_TblPrefix . "subscribers WHERE IsConfirm = 1 {$queryS}");
$pages = ceil(mysql_result($resultC, 0, 0) / $resLimit);
$resOffset = $pages <= $resOffset && $pages > 0 ? $pages - 1 : $resOffset;
if (isset($_GET['msg'])) {
switch ($_GET['msg']) {
case "1":
feedback(1, $hc_lang_news['Feed05']);
break;
case "2":
feedback(1, $hc_lang_news['Feed18']);
break;
}
}
appInstructions(0, "Manage_Subscribers", $hc_lang_news['TitleBrowseS'], $hc_lang_news['InstructBrowseS']);
echo '
<fieldset style="border:0px;">
<label><b>' . $hc_lang_news['ResPer'] . '</b></label>
<span class="output">';
for ($x = 25; $x <= 100; $x = $x + 25) {
echo $x > 25 ? ' | ' : '';
echo $x != $resLimit ? '<a href="' . AdminRoot . '/index.php?com=submngt&p=' . $resOffset . '&a=' . $x . $save . '">' . $x . '</a>' : '<b>' . $x . '</b>';
}
echo '
</span>
<label><b>' . $hc_lang_news['Page'] . '</b></label>
<span class="output">';
$x = $resOffset - $resDiff > 0 ? $resOffset - $resDiff : 0;
$cnt = 0;
echo $resOffset > $resDiff ? '<a href="' . AdminRoot . '/index.php?com=submngt&p=0&a=' . $resLimit . $save . '">1</a> ... ' : '';
<?php
/**
* @package Helios Calendar
* @license GNU General Public License version 2 or later; see LICENSE
*/
if (!defined('hcAdmin')) {
header("HTTP/1.1 403 No Direct Access");
exit;
}
include HCLANG . '/admin/reports.php';
appInstructions(0, "Reports", $hc_lang_reports['TitlePop'], $hc_lang_reports['InstructPop']);
$result = doQuery("SELECT PkID, Title, StartDate, PublishDate, (DATEDIFF('" . cIn(SYSDATE) . "', PublishDate)+1) as Diff, Views, (Views / (DATEDIFF('" . cIn(SYSDATE) . "', PublishDate)+1)) as Ave, IsBillboard\r\n\t\t\t\t\tFROM " . HC_TblPrefix . "events\r\n\t\t\t\t\tWHERE IsActive = 1 AND IsApproved = 1 AND Views > 0 AND StartDate >= '" . cIn(SYSDATE) . "'\r\n\t\t\t\t\tORDER BY AVE DESC, StartDate LIMIT 100");
if (hasRows($result)) {
echo '
<ul class="data">
<li class="row header uline">
<div class="txt" style="width:38%;"> </div>
<div style="width:10%;">' . $hc_lang_reports['Occurs'] . '</div>
<div style="width:10%;">' . $hc_lang_reports['Published'] . '</div>
<div class="number" style="width:7%;">' . $hc_lang_reports['DaysActive'] . '</div>
<div class="number" style="width:12%;">' . $hc_lang_reports['Views'] . '</div>
<div class="number" style="width:12%;">' . $hc_lang_reports['Daily'] . '</div>
<div class="tools" style="width:12%;"> </div>
</li>
</ul>
<ul class="data">
<div class="prpt">';
$cnt = 0;
while ($row = mysql_fetch_row($result)) {
$hl = $cnt % 2 == 1 ? ' hl' : '';
$hl = $cnt % 2 == 1 ? ' hl' : '';
$login_history .= '
<li class="row' . $hl . ($row[5] == 1 ? ' error' : '') . '">
<div style="width:25%;">' . stampToDate($row[4], $hc_cfg[24] . ' ' . $hc_cfg[23]) . '</div>
<div style="width:18%;">' . cOut($row[2]) . '</div>
<div class="txt" title="' . cOut($row[3]) . '" style="width:55%;">' . cOut($row[3]) . '</div>
</li>';
++$cnt;
}
$login_history .= '
</ul>';
}
} else {
$aID = 0;
appInstructions(0, "Adding_Admin_Users", $hc_lang_admin['TitleAddA'], $hc_lang_admin['InstructAddA']);
}
echo '
<form name="frmAdminEdit" id="frmAdminEdit" method="post" action="' . AdminRoot . '/components/AdminEditAction.php" onsubmit="return validate();">';
set_form_token();
echo '
<input type="hidden" name="aID" id="aID" value="' . $aID . '" />
<input type="hidden" name="oldEmail" id="oldEmail" value="' . $oldEmail . '" />
<fieldset>
<legend>' . $hc_lang_admin['Details'] . '</legend>
<label for="firstname">' . $hc_lang_admin['FName'] . '</label>
<input name="firstname" id="firstname" type="text" size="20" maxlength="50" required="required" value="' . $firstname . '" />
<label for="lastname">' . $hc_lang_admin['LName'] . '</label>
<input name="lastname" id="lastname" type="text" size="20" maxlength="50" required="required" value="' . $lastname . '" />
<label for="email">' . $hc_lang_admin['Email'] . '</label>
<input name="email" id="email" type="email" size="30" maxlength="100" required="required" value="' . $email . '" />
* @package Helios Calendar
* @license GNU General Public License version 2 or later; see LICENSE
*/
if (!defined('hcAdmin')) {
header("HTTP/1.1 403 No Direct Access");
exit;
}
include HCLANG . '/admin/settings.php';
if (isset($_GET['msg'])) {
switch ($_GET['msg']) {
case "1":
feedback(1, $hc_lang_settings['Feed03']);
break;
}
}
appInstructions(0, "Themes_Settings", $hc_lang_settings['TitleTheme'], $hc_lang_settings['InstructTheme']);
$result = doQuery("SELECT SettingValue FROM " . HC_TblPrefix . "settings WHERE PkID IN (83,84,86) ORDER BY PkID");
$fullsite = cOut(mysql_result($result, 0, 0));
$mobile = cOut(mysql_result($result, 1, 0));
$agents = cOut(mysql_result($result, 2, 0));
$fullsiteOpts = $mobileOpts = '';
$themes = array();
if (file_exists(HCPATH . '/themes')) {
$dir = dir(HCPATH . '/themes');
while (($file = $dir->read()) != false) {
if (is_dir($dir->path . '/' . $file) && $file != "." && $file != "..") {
$themes[] = $file;
}
}
}
sort($themes);
err +=validMinLength(document.getElementById("locName"),4,"error");
if(err != ""){
alert("' . $hc_lang_locations['Valid19'] . '");
return false;
} else {
return true;
}
}
//-->
</script>';
} else {
$token = '';
$token = $token == '' && isset($_POST['token']) ? cIn(strip_tags($_POST['token'])) : $token;
$token = $token == '' && isset($_GET['tkn']) ? cIn(strip_tags($_GET['tkn'])) : $token;
appInstructions(1, "Merging_Locations", $hc_lang_locations['TitleMerge'], $hc_lang_locations['InstructMerge2']);
$locName = '';
if (isset($_GET['l'])) {
$locName = isset($_GET['l']) ? strip_tags(str_replace("'", "\"", $_GET['l'])) : '';
} elseif (isset($_POST['locName'])) {
$locName = isset($_POST['locName']) ? strip_tags(str_replace("'", "\"", $_POST['locName'])) : '';
}
$result = doQuery("SELECT PkID, Name, IsPublic, \r\n\t\t\t\t\t\t\t(SELECT COUNT(PkID) FROM " . HC_TblPrefix . "events e WHERE e.StartDate >= '" . SYSDATE . "' AND e.LocID = l.PkID) AS EventCnt\r\n\t\t\t\t\t\tFROM " . HC_TblPrefix . "locations l\r\n\t\t\t\t\t\tWHERE IsActive = 1 AND\r\n\t\t\t\t\t\t\t(MATCH(Name,Address,Address2) AGAINST('" . cIn($locName, 0) . "' IN BOOLEAN MODE) OR NAME LIKE('%" . cIn($locName) . "%'))\r\n\t\t\t\t\t\tORDER BY IsPublic, Name");
if (!hasRows($result) || $locName == '' || !check_form_token($token)) {
echo '
<p>' . $hc_lang_locations['NoLoc'] . '</p>
<p><a href="' . AdminRoot . '/index.php?com=locsearch">' . $hc_lang_locations['NoLocLink'] . '</a></p>';
} else {
echo '
<form name="frmMergeLocation" id="frmMergeLocation" method="post" action="' . AdminRoot . '/index.php?com=location&m=1" onsubmit="return validate();">';
set_form_token();
include HCLANG . '/admin/manage.php';
if (isset($_GET['msg'])) {
switch ($_GET['msg']) {
case "1":
feedback(1, $hc_lang_manage['Feed02']);
break;
}
}
$c = isset($_GET['c']) && cIn(strip_tags($_GET['c'])) == 0 ? 0 : 1;
$l = isset($_GET['l']) && cIn(strip_tags($_GET['l'])) == 0 ? 0 : 1;
if ($c == 0 && $l == 0) {
$c = $l = 1;
}
$result = doQuery("SELECT e.PkID, e.Title, e.StartDate, 1 as NoType\r\n\t\t\t\t\tFROM " . HC_TblPrefix . "events e\r\n\t\t\t\t\t\tLEFT JOIN " . HC_TblPrefix . "eventcategories ec ON (e.PkID = ec.EventID)\r\n\t\t\t\t\t\tLEFT JOIN " . HC_TblPrefix . "categories c ON (c.PkID = ec.CategoryID)\r\n\t\t\t\t\tWHERE e.IsActive = 1 AND e.IsApproved = 1 AND (ec.EventID IS NULL OR c.IsActive = 0)\r\n\t\t\t\t\tGROUP BY e.PkID, e.Title, e.StartDate\r\n\t\t\t\t\tUNION\r\n\t\t\t\t\tSELECT e.PkID, e.Title, e.StartDate, 0 as NoType\r\n\t\t\t\t\tFROM " . HC_TblPrefix . "events e\r\n\t\t\t\t\t\tLEFT JOIN " . HC_TblPrefix . "eventcategories ec ON (e.PkID = ec.EventID)\r\n\t\t\t\t\t\tLEFT JOIN " . HC_TblPrefix . "categories c ON (c.PkID = ec.CategoryID)\r\n\t\t\t\t\tWHERE e.IsActive = 1 AND e.IsApproved = 1 AND e.LocID = 0 AND (e.LocationName = '' OR e.LocationName IS NULL OR e.LocationName = 'Unknown')\r\n\t\t\t\t\tAND (ec.EventID IS NOT NULL AND c.IsActive = 1)\r\n\t\t\t\t\tGROUP BY e.PkID, e.Title, e.StartDate\r\n\t\t\t\t\tORDER BY StartDate");
if (hasRows($result)) {
appInstructions(0, "Orphan_Events", $hc_lang_manage['TitleOrphan'], $hc_lang_manage['InstructOrphan']);
echo '
<form name="eventOrphan" id="eventOrphan" method="post" action="' . AdminRoot . '/components/EventDelete.php" onsubmit="return validate();">';
set_form_token();
echo '
<input type="hidden" name="oID" id="oID" value="1" />
<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>
<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>
</script>';
} else {
if (isset($_GET['msg'])) {
switch ($_GET['msg']) {
case "1":
feedback(1, $hc_lang_news['Feed10']);
break;
case "2":
feedback(1, $hc_lang_news['Feed11']);
break;
case "3":
feedback(1, $hc_lang_news['Feed12']);
break;
}
}
appInstructions(0, "Subscriber_Groups", $hc_lang_news['TitleGroup'], $hc_lang_news['InstructGroup']);
echo '
<a href="' . AdminRoot . '/index.php?com=subgrps&gID=0" class="add"><img src="' . AdminRoot . '/img/icons/add.png" width="16" height="16" alt="" />' . $hc_lang_news['NewGroup'] . '</a>';
$result = doQuery("SELECT PkID, Name, IsPublic,\r\n\t\t\t\t\t\t\t(SELECT COUNT(sg.UserID)\r\n\t\t\t\t\t\t\tFROM " . HC_TblPrefix . "subscribersgroups sg\r\n\t\t\t\t\t\t\t\tLEFT JOIN " . HC_TblPrefix . "subscribers s ON (sg.UserID = s.PkID)\r\n\t\t\t\t\t\t\tWHERE sg.GroupID = mg.PkID AND s.IsConfirm = 1) as GrpCnt,\r\n\t\t\t\t\t\t\t(SELECT COUNT(s.PkID)FROM " . HC_TblPrefix . "subscribers s WHERE s.IsConfirm = 1) as AllCnt\r\n\t\t\t\t\t\tFROM " . HC_TblPrefix . "mailgroups mg\r\n\t\t\t\t\t\tWHERE IsActive = 1 ORDER BY IsPublic, Name");
if (hasRows($result)) {
echo '
<ul class="data">
<li class="row header uline">
<div style="width:50%;">' . $hc_lang_news['GroupNameLabel'] . '</div>
<div style="width:20%;">' . $hc_lang_news['GroupStatusLabel'] . '</div>
<div class="number" style="width:20%;">' . $hc_lang_news['GroupCountLabel'] . '</div>
<div class="tools" style="width:10%;"> </div>
</li>';
$cnt = 0;
while ($row = mysql_fetch_row($result)) {
$hl = $cnt % 2 == 1 ? ' hl' : '';
}
$hc_Side[] = array(CalRoot . '/index.php?com=location', 'map.png', $hc_lang_locations['LinkMap'], 1);
if (isset($_GET['msg'])) {
switch ($_GET['msg']) {
case "3":
feedback(1, $hc_lang_locations['Feed03']);
break;
case "4":
feedback(2, $hc_lang_locations['Feed04']);
break;
case "5":
feedback(1, $hc_lang_locations['Feed05']);
break;
}
}
appInstructions(0, "Editing_Locations", $hc_lang_locations['TitleBrowse'], $hc_lang_locations['InstructBrowse']);
$resultC = doQuery("SELECT COUNT(*) FROM " . HC_TblPrefix . "locations WHERE IsActive = 1 {$queryS}");
$pages = ceil(mysql_result($resultC, 0, 0) / $resLimit);
if ($pages <= $resOffset && $pages > 0) {
$resOffset = $pages - 1;
}
echo '
<fieldset style="border:0px;">
<label><b>' . $hc_lang_locations['ResPer'] . '</b></label>
<span class="output">';
for ($x = 25; $x <= 100; $x = $x + 25) {
echo $x > 25 ? ' | ' : '';
echo $x != $resLimit ? '<a href="' . AdminRoot . '/index.php?com=location&p=' . $resOffset . '&a=' . $x . $save . '">' . $x . '</a>' : '<b>' . $x . '</b>';
}
echo '</span>
<label><b>' . $hc_lang_locations['Page'] . '</b></label>
<?php
/**
* @package Helios Calendar
* @license GNU General Public License version 2 or later; see LICENSE
*/
if (!defined('hcAdmin')) {
header("HTTP/1.1 403 No Direct Access");
exit;
}
include HCLANG . '/admin/reports.php';
appInstructions(0, "Reports", $hc_lang_reports['TitleOver'], $hc_lang_reports['InstructOver']);
$na = $hc_lang_reports['NA'];
$result = doQuery("SELECT COUNT(*) FROM " . HC_TblPrefix . "events WHERE IsActive = 1 AND IsApproved = 1");
$tCnt = hasRows($result) ? mysql_result($result, 0, 0) : '0';
$result = doQuery("SELECT COUNT(*) FROM " . HC_TblPrefix . "events WHERE IsActive = 1 AND IsApproved = 1 AND StartDate >= '" . cIn(SYSDATE) . "'");
$aCnt = hasRows($result) ? mysql_result($result, 0, 0) : '0';
$result = doQuery("SELECT COUNT(*) FROM " . HC_TblPrefix . "events WHERE IsActive = 1 AND IsApproved = 1 AND StartDate < '" . cIn(SYSDATE) . "'");
$pCnt = hasRows($result) ? mysql_result($result, 0, 0) : '0';
$stats[$hc_lang_reports['ActiveLabel']] = $aCnt != '' ? number_format($aCnt, 0, '.', ',') : $na;
$stats[$hc_lang_reports['PassedLabel']] = $pCnt != '' ? number_format($pCnt, 0, '.', ',') : $na;
$stats[$hc_lang_reports['TotalLabel']] = $tCnt != '' ? number_format($tCnt, 0, '.', ',') : $na;
$result = doQuery("SELECT COUNT(*) FROM " . HC_TblPrefix . "events WHERE IsActive = 1 AND IsApproved = 1 AND IsBillboard = 1 AND StartDate >= '" . cIn(SYSDATE) . "'");
$stats[$hc_lang_reports['Billboard']] = hasRows($result) ? number_format(mysql_result($result, 0, 0), 0, '.', ',') : $na;
$result = doQuery("SELECT COUNT(*)\r\n\t\t\t\t\tFROM " . HC_TblPrefix . "events e\r\n\t\t\t\t\t\tLEFT JOIN " . HC_TblPrefix . "eventcategories ec ON (e.PkID = ec.EventID)\r\n\t\t\t\t\t\tLEFT JOIN " . HC_TblPrefix . "categories c ON (c.PkID = ec.CategoryID)\r\n\t\t\t\t\tWHERE e.IsActive = 1 AND e.IsApproved = 1 AND (ec.EventID IS NULL OR c.IsActive = 0)");
$stats[$hc_lang_reports['Orphan']] = hasRows($result) ? number_format(mysql_result($result, 0, 0), 0, '.', ',') : $na;
$result = doQuery("SELECT COUNT(*) FROM " . HC_TblPrefix . "events WHERE IsActive = 1 AND IsApproved = 1 AND StartDate = '" . cIn(SYSDATE) . "'");
$stats[$hc_lang_reports['Today']] = hasRows($result) ? number_format(mysql_result($result, 0, 0), 0, '.', ',') : $na;
$result = doQuery("SELECT COUNT(*) FROM " . HC_TblPrefix . "events WHERE IsActive = 1 AND IsApproved = 1 AND StartDate BETWEEN '" . cIn(SYSDATE) . "' AND ADDDATE('" . cIn(SYSDATE) . "',INTERVAL 7 DAY)");
$stats[$hc_lang_reports['Next7']] = hasRows($result) ? number_format(mysql_result($result, 0, 0), 0, '.', ',') : $na;
$result = doQuery("SELECT COUNT(*) FROM " . HC_TblPrefix . "events WHERE IsActive = 1 AND IsApproved = 1 AND StartDate BETWEEN '" . cIn(SYSDATE) . "' AND ADDDATE('" . cIn(SYSDATE) . "',INTERVAL 30 DAY)");
$result = doQuery("SELECT * FROM " . HC_TblPrefix . "templates WHERE PkID = '" . $tID . "' AND IsActive = 1");
if (hasRows($result)) {
$whereAmI = $hc_lang_tools['EditT'];
$helpText = $hc_lang_tools['InstructEditTExp'];
$name = cOut(mysql_result($result, 0, 1));
$content = cOut(mysql_result($result, 0, 2));
$header = cOut(mysql_result($result, 0, 3));
$footer = cOut(mysql_result($result, 0, 4));
$ext = cOut(mysql_result($result, 0, 5));
$typeID = cOut(mysql_result($result, 0, 6));
$groupBy = cOut(mysql_result($result, 0, 7));
$sortBy = cOut(mysql_result($result, 0, 8));
$cleanup = cOut(mysql_result($result, 0, 9));
$dateFormat = cOut(mysql_result($result, 0, 10));
}
appInstructions(0, $helpDoc, $whereAmI, $helpText);
echo '
<form name="frmExpTemp" id="frmExpTemp" method="post" action="' . AdminRoot . '/components/TemplatesEditAction.php" onsubmit="return validate();">';
set_form_token();
echo '
<input type="hidden" name="tID" id="tID" value="' . $tID . '" />
<input type="hidden" name="typeID" id="typeID" value="' . $typeID . '" />
<fieldset>
<legend>' . $hc_lang_tools['TempSettings'] . '</legend>
<label for="name">' . $hc_lang_tools['Name'] . '</label>
<input name="name" id="name" type="text" size="50" maxlength="255" required="required" value="' . $name . '" />
<label for="ext">' . $hc_lang_tools['Extension'] . '</label>
<input name="ext" id="ext" type="text" size="5" maxlength="15" required="required" value="' . $ext . '" />
<label for="sort">' . $hc_lang_tools['Sort'] . '</label>
<select name="sort" id="sort">
<option' . ($sortBy == 0 ? ' selected="selected"' : '') . ' value="0">' . $hc_lang_tools['OptSort0'] . '</option>
break;
case "2":
feedback(1, $hc_lang_settings['Feed06']);
break;
case "3":
feedback(3, $hc_lang_settings['Feed07']);
break;
case "4":
feedback(1, $hc_lang_settings['Feed08']);
break;
case "5":
feedback(3, $hc_lang_settings['Feed09']);
break;
}
}
appInstructions(0, "APIs", $hc_lang_settings['TitleAPI'], $hc_lang_settings['InstructAPI']);
$result = doQuery("SELECT SettingValue FROM " . HC_TblPrefix . "settings \r\n\t\t\t\t\tWHERE PkID IN (5,6,25,27,41,42,43,45,46,47,50,52,55,56,57,58,59,61,62,63,69,94,95,96,\r\n\t\t\t\t\t\t\t\t100,101,102,103,104,105,111,112,113,114,115,117,118,119,120,121,122,123,124,125)\r\n\t\t\t\t\tORDER BY PkID");
$eventbriteKeyA = cOut(mysql_result($result, 0, 0));
$eventbriteKeyU = cOut(mysql_result($result, 1, 0));
$disqusName = cOut(mysql_result($result, 2, 0));
$emapZoom = cOut(mysql_result($result, 3, 0));
$lmapZoom = cOut(mysql_result($result, 4, 0));
$locBrowse = cOut(mysql_result($result, 7, 0));
$twtrAToken = cOut(mysql_result($result, 8, 0));
$twtrASecret = cOut(mysql_result($result, 9, 0));
$quickLinks = explode(",", cOut(mysql_result($result, 10, 0)));
$googMapURL = cOut(mysql_result($result, 11, 0));
$mapLibrary = cOut(mysql_result($result, 12, 0));
$useComments = cOut(mysql_result($result, 13, 0));
$bitlyUser = cOut(mysql_result($result, 14, 0));
$bitlyAPI = cOut(mysql_result($result, 15, 0));
break;
case "3":
feedback(1, $hc_lang_manage['Feed05']);
break;
}
}
$result = doQuery("SELECT PkID, CategoryName, ParentID FROM " . HC_TblPrefix . "categories WHERE PkID = '" . $cID . "'");
if (hasRows($result)) {
$category = mysql_result($result, 0, 1);
$parentID = mysql_result($result, 0, 2);
}
$result = doQuery("SELECT PkID, CategoryName FROM " . HC_TblPrefix . "categories WHERE PkID != '" . $cID . "' AND IsActive = 1 AND ParentID = 0 ORDER BY CategoryName");
while ($row = mysql_fetch_row($result)) {
$catOptions .= $parentID == $row[0] ? '<option selected="selected" value="' . $row[0] . '">' . $row[1] . '</option>' : '<option value="' . $row[0] . '">' . $row[1] . '</option>';
}
appInstructions(0, "Category_Management", $hc_lang_manage['TitleCategory'], $hc_lang_manage['InstructCategory']);
echo '
<div class="catMgtForm">
<form name="frm" id="frm" method="post" action="' . AdminRoot . '/components/CategoryManageAction.php" onsubmit="return validate();">
<input type="hidden" name="token" id="token" value="' . $token . '" />
<input type="hidden" name="cID" id="cID" value="' . $cID . '" />
<fieldset>
<legend>' . $whereAmI . ($cID > 0 ? ' ( <a href="' . AdminRoot . '/index.php?com=categorymanage">' . $hc_lang_manage['AddNew'] . '</a> )' : '') . '</legend>
<label>' . $hc_lang_manage['Name'] . '</label>
<input name="catName" id="catName" type="text" size="35" maxlength="40" required="required" value="' . $category . '" />
<label for="parentID">' . $hc_lang_manage['Parent'] . '</label>
<select name="parentID" id="parentID">
<option value="0">' . $hc_lang_manage['NoParent'] . '</option>
<option value="0">------------------</option>
' . $catOptions . '
</select>
<?php
/**
* @package Helios Calendar
* @license GNU General Public License version 2 or later; see LICENSE
*/
if (!defined('hcAdmin')) {
header("HTTP/1.1 403 No Direct Access");
exit;
}
include HCLANG . '/admin/tools.php';
appInstructions(0, "Filter_Link", $hc_lang_tools['TitleFilter'], $hc_lang_tools['InstructFilter']);
echo '
<form name="frmToolLink" id="frmToolLink" method="post" action="" onsubmit="return false;">
<fieldset>
<legend>' . $hc_lang_tools['Link'] . '</legend>
<input name="filterLink" id="filterLink" type="text" size="95" maxlength="200" value="' . CalRoot . '/link.php" />
</fieldset>
<fieldset>
<legend>' . $hc_lang_tools['Cities'] . '</legend>';
$cities = getCities();
$cnt = 1;
$columns = 3;
$colWidth = number_format(100 / $columns, 0);
$colLimit = ceil(count($cities) / $columns);
echo '
<div class="catCol">';
foreach ($cities as $val) {
if ($cnt > $colLimit) {
echo $cnt > 1 ? '
</div>' : '';
$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;
}
}
$stime_disabled = $tbd > 0 ? ' disabled="disabled"' : '';
$etime_disabled = isset($noEndTime) || $tbd > 0 ? ' disabled="disabled"' : '';
$emailAccept = cleanBreaks('<p>' . $subName . ',</p>' . $hc_cfg[3]);
$emailDecline = cleanBreaks('<p>' . $subName . ',</p>' . $hc_cfg[4]);
appInstructions(0, "Pending_Events", $hc_lang_event['TitlePendingB'], $hc_lang_event['InstructPendingB']);
if ($followup == 0) {
$hc_Side[] = array('javascript:;', 'followup.png', $hc_lang_core['LinkFollow'], 0, 'follow_up();');
}
echo '
<form name="frmEventApprove" id="frmEventApprove" method="post" action="' . AdminRoot . '/components/EventPendingAction.php" onsubmit="return validate();">';
set_form_token();
echo '
<input type="hidden" name="eID" id="eID" value="' . $eID . '" />
<input type="hidden" name="sID" id="sID" value="' . $series . '" />
<input type="hidden" name="fID" id="fID" value="' . $fID . '" />
<input type="hidden" name="editString" id="editString" value="' . $editString . '" />
<input type="hidden" id="locPreset" name="locPreset" value="' . $locID . '" />
<input type="hidden" id="locPresetName" name="locPresetName" value="' . $locName . '" />
<input type="hidden" name="prevStatus" id="prevStatus" value="' . $eventStatus . '" />
<input type="hidden" name="subname" id="subname" value="' . cOut($subName) . '" />
