コード例 #1
0
ファイル: EventSearch.php プロジェクト: pvidali/BCSR-1
    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">&nbsp;&nbsp;' . $hc_lang_search['To'] . '&nbsp;&nbsp;</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" />
コード例 #2
0
ファイル: EventBillboard.php プロジェクト: pvidali/BCSR-1
 * @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%;">&nbsp;</div>
			</li>
		</ul>
		<ul class="data">
		<div class="blbd">';
    $cnt = 0;
    while ($row = mysql_fetch_row($result)) {
コード例 #3
0
ファイル: AdminBrowse.php プロジェクト: pvidali/BCSR-1
    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%;">&nbsp;</div>
			</li>';
    $cnt = 0;
    while ($row = mysql_fetch_row($result)) {
        $hl = $cnt % 2 == 1 ? ' hl' : '';
        echo '
			<li class="row ' . $hl . '">
コード例 #4
0
ファイル: eventadd-archive.php プロジェクト: pvidali/BCSR-1
            $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>
コード例 #5
0
ファイル: ToolImport.php プロジェクト: pvidali/BCSR-1
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>
コード例 #6
0
ファイル: RegisterAdd.php プロジェクト: pvidali/BCSR-1
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>
コード例 #7
0
ファイル: Digest.php プロジェクト: pvidali/BCSR-1
 * @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>
コード例 #8
0
ファイル: ReportDuplicate.php プロジェクト: pvidali/BCSR-1
<?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)) {
コード例 #9
0
ファイル: NewsletterSend.php プロジェクト: pvidali/BCSR-1
<?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>
コード例 #10
0
ファイル: ReportActivity.php プロジェクト: pvidali/BCSR-1
<?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));
コード例 #11
0
ファイル: UserBrowse.php プロジェクト: pvidali/BCSR-1
$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 ? '&nbsp;|&nbsp;' : '';
    echo $x != $resLimit ? '<a href="' . AdminRoot . '/index.php?com=user&amp;p=' . $resOffset . '&amp;a=' . $x . $save . '">' . $x . '</a>' : '<b>' . $x . '</b>';
}
echo '
			</span>
			<label><b>' . $hc_lang_user['Page'] . '</b></label>
コード例 #12
0
ファイル: LocationEdit.php プロジェクト: pvidali/BCSR-1
    $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>
コード例 #13
0
ファイル: MailTemplateEdit.php プロジェクト: pvidali/BCSR-1
    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%;">&nbsp;</div>
		</li>';
        while ($row = mysql_fetch_row($result)) {
            $hl = $cnt % 2 == 1 ? ' hl' : '';
            echo '
コード例 #14
0
ファイル: SettingsGeneral.php プロジェクト: pvidali/BCSR-1
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));
コード例 #15
0
ファイル: ReportFail.php プロジェクト: pvidali/BCSR-1
 * @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%;">&nbsp;</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%;">&nbsp;</div>
			</li>
		</ul>
		<ul class="data">
		<div class="prpt">';
    $cnt = 0;
コード例 #16
0
ファイル: MailQueue.php プロジェクト: pvidali/BCSR-1
                    $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>&nbsp;</label>
				<span class="output"><b>' . number_format($subCnt, 0, '.', ',') . '</b> ' . $hc_lang_news['SubStats'] . '</span>
				<label>&nbsp;</label>
コード例 #17
0
ファイル: MailSubBrowse.php プロジェクト: pvidali/BCSR-1
    $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 ? '&nbsp;|&nbsp;' : '';
    echo $x != $resLimit ? '<a href="' . AdminRoot . '/index.php?com=submngt&amp;p=' . $resOffset . '&amp;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>&nbsp;...&nbsp;' : '';
コード例 #18
0
ファイル: ReportPopular.php プロジェクト: pvidali/BCSR-1
<?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%;">&nbsp;</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%;">&nbsp;</div>
			</li>
		</ul>
		<ul class="data">
		<div class="prpt">';
    $cnt = 0;
    while ($row = mysql_fetch_row($result)) {
        $hl = $cnt % 2 == 1 ? ' hl' : '';
コード例 #19
0
ファイル: AdminEdit.php プロジェクト: pvidali/BCSR-1
            $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 . '" />
コード例 #20
0
ファイル: SettingsTheme.php プロジェクト: pvidali/BCSR-1
 * @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);
コード例 #21
0
ファイル: LocationSearch.php プロジェクト: pvidali/BCSR-1
			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&amp;m=1" onsubmit="return validate();">';
        set_form_token();
コード例 #22
0
ファイル: EventOrphan.php プロジェクト: pvidali/BCSR-1
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>
			&nbsp;|&nbsp; <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%;">&nbsp;</div>
コード例 #23
0
ファイル: MailGroups.php プロジェクト: pvidali/BCSR-1
	</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%;">&nbsp;</div>
		</li>';
        $cnt = 0;
        while ($row = mysql_fetch_row($result)) {
            $hl = $cnt % 2 == 1 ? ' hl' : '';
コード例 #24
0
ファイル: Location.php プロジェクト: pvidali/BCSR-1
}
$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 ? '&nbsp;|&nbsp;' : '';
    echo $x != $resLimit ? '<a href="' . AdminRoot . '/index.php?com=location&amp;p=' . $resOffset . '&amp;a=' . $x . $save . '">' . $x . '</a>' : '<b>' . $x . '</b>';
}
echo '</span>
			<label><b>' . $hc_lang_locations['Page'] . '</b></label>
コード例 #25
0
ファイル: ReportOverview.php プロジェクト: pvidali/BCSR-1
<?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)");
コード例 #26
0
ファイル: TemplatesEdit.php プロジェクト: pvidali/BCSR-1
$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>
コード例 #27
0
ファイル: SettingsAPI.php プロジェクト: pvidali/BCSR-1
            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));
コード例 #28
0
ファイル: CategoryManage.php プロジェクト: pvidali/BCSR-1
            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 ? '&nbsp;( <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>
コード例 #29
0
ファイル: ToolFilter.php プロジェクト: pvidali/BCSR-1
<?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>' : '';
コード例 #30
0
ファイル: EventPending.php プロジェクト: pvidali/BCSR-1
            $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) . '" />