コード例 #1
0
ファイル: locations.php プロジェクト: pvidali/BCSR-1
/**
 * Output list of upcoming events for the location.
 * @since 2.0.0
 * @version 2.0.0
 * @param integer $limit [optional] Event List Size (Default:5)
 * @return void
 */
function location_events($limit = 5)
{
    global $lID, $hc_cfg, $hc_lang_core, $hc_lang_locations;
    $result = doQuery("SELECT PkID, Title, StartDate, StartTime, EndTime, TBD\r\n\t\t\t\t\t\tFROM " . HC_TblPrefix . "events \r\n\t\t\t\t\t\t\tWHERE IsActive = 1 AND IsApproved = 1 AND LocID = '" . cIn($lID) . "' AND StartDate >= '" . cIn(SYSDATE) . "'\r\n\t\t\t\t\t\tORDER BY StartDate, TBD, StartTime, Title\r\n\t\t\t\t\t\tLIMIT " . cIn($limit));
    if (!hasRows($result)) {
        echo '<p>' . $hc_lang_locations['NoEvents'] . ' <a href="' . CalRoot . '/index.php?com=submit" rel="nofollow">' . $hc_lang_locations['NoEventsLink'] . '</a></p>';
        return 0;
    }
    $cnt = $date = 0;
    while ($row = mysql_fetch_row($result)) {
        if ($date != $row[2]) {
            $date = $row[2];
            echo $cnt > 0 ? '
			</ul>' : '';
            echo '
			<header>' . stampToDate($row[2], $hc_cfg[14]) . '</header>
			<ul>';
            $cnt = 1;
        }
        $hl = $cnt % 2 == 0 ? ' class="hl"' : '';
        if ($row[5] == 0) {
            $time = $row[3] != '' ? stampToDate($row[3], $hc_cfg[23]) : '';
            $time .= $row[4] != '' ? ' - ' . stampToDate($row[4], $hc_cfg[23]) : '';
            $stamp = date("Y-m-d\\Th:i:00", strtotime($row[2] . trim(' ' . $row[3]))) . HCTZ;
        } else {
            $time = $row[5] == 1 ? $hc_lang_locations['AllDay'] : $hc_lang_locations['TBA'];
            $stamp = date("Y-m-d", strtotime($row[2]));
        }
        echo '
			<li' . $hl . ' itemscope itemtype="http://schema.org/Event"><time itemprop="startDate" datetime="' . $stamp . '">' . $time . '</time><a itemprop="url" href="' . CalRoot . '/index.php?eID=' . $row[0] . '"><span itemprop="name">' . cOut($row[1]) . '</span></a></li>';
        ++$cnt;
    }
    echo '</ul>';
}
コード例 #2
0
ファイル: ou.php プロジェクト: pvidali/BCSR-1
/**
 * Output weekly dashboard to a page outside of Helios Calendar.
 * @since 2.0.1
 * @version 2.0.1
 * @param binary $submit include submit event link, 0 = hide , 1 = show (Default:1)
 * @param binary $ical include iCalendar subscription link, 0 = hide, 1 = show (Default:1)
 * @param binary $rss include All Events rss feed link, 0 = hide, 1 = show (Default:1)
 * @param binary $end_time include end time in event lists, 0 = hide, 1 = show (Default:1)
 * @param string $menu_format menu format string, accepts any supported strftime() format parameters (Default:%a %m/%d)
 * @return void
 */
function ou_event_carousel($submit = 1, $ical = 1, $rss = 1, $end_time = 1, $menu_format = '%a %m/%d')
{
    global $hc_cfg, $hc_lang_core;
    include HCLANG . '/public/integration.php';
    echo "SYSDATE: " . SYSDATE . "\n";
    if (file_exists(HCPATH . '/cache/int14_' . SYSDATE . '.php')) {
        if (count(glob(HCPATH . '/cache/int14_*.php')) > 0) {
            foreach (glob(HCPATH . '/cache/int14_*.php') as $file) {
                unlink($file);
            }
        }
        ob_start();
        $fp = fopen(HCPATH . '/cache/int14_' . SYSDATE . '.php', 'w');
        fwrite($fp, "<?php\n//\tHelios Dashboard Integration Events Cache - Delete this file when upgrading.\n");
        //link, category, title, start date, end date, start time, end time, location, description
        //array("05/15/2015 - 05/15/2015","1","test event")
        $result = doQuery("SELECT PkID, Title, Description, StartDate, EndDate, StartTime,  EndTime, TBD, LocID, LocationName  FROM " . HC_TblPrefix . "events\nWHERE IsActive = 1 AND IsApproved = 1 AND StartDate Between '" . SYSDATE . "' AND ADDDATE('" . SYSDATE . "', INTERVAL 14 DAY)\nORDER BY StartDate, TBD, StartTime, Title, LocationName");
        if (hasRows($result)) {
            $cur_day = -1;
            $cur_date = '';
            fwrite($fp, "\$hc_next14 = array(\n");
            while ($row = mysql_fetch_row($result)) {
                print_r($row);
                $ouTitle = $row[1];
                $ouDesc = $row[2];
                $ouLoc = $row[7];
                //echo "\nouLoc: " . $ouLoc;
                if ($cur_date = $row[3]) {
                    ++$cur_day;
                    $cur_date = $row[3];
                    if ($cur_day > 0) {
                        fwrite($fp, "\t),\n");
                    }
                    fwrite($fp, $cur_day . " => array(\n");
                }
                if ($row[6] == 0) {
                    $time = $row[4] != '' ? stampToDate($row[4], $hc_cfg[24]) : '';
                    $time .= $row[5] != '' && $end_time == 1 ? ' - ' . stampToDate($row[5], $hc_cfg[24]) : '';
                } else {
                    $time = $row[6] == 1 ? $hc_lang_int['AllDay'] : $hc_lang_int['TimeTBA'];
                }
                fwrite($fp, "\t" . $row[0] . " => array(\"" . $time . "\",\"" . stampToDate($row[3], $hc_cfg[15]) . "\",\"" . str_replace("\"", "'", cOut($row[1])) . "\"),\n");
            }
            fwrite($fp, "\t),");
        }
        fwrite($fp, "\n)\n?>");
        fwrite($fp, ob_get_contents());
        fclose($fp);
        ob_end_clean();
    }
    include HCPATH . '/cache/int14_' . SYSDATE . '.php';
}
コード例 #3
0
ファイル: SaveEvent.php プロジェクト: pvidali/BCSR-1
            if (!preg_match("{$hc_cfg['85']}i", $_SERVER['HTTP_USER_AGENT'])) {
                doQuery("UPDATE " . HC_TblPrefix . "events SET Downloads = Downloads + 1 WHERE PkID = '" . $eID . "'");
            }
            $link = "http://calendar.live.com/calendar/calendar.aspx?rru=addevent";
            if (mysql_result($result, 0, 11) == 0) {
                if (mysql_result($result, 0, 12) != '') {
                    $link .= "&dtstart=" . stampToDate(mysql_result($result, 0, 9) . " " . mysql_result($result, 0, 10), "%Y%m%dT%H%M%S") . "&dtend=" . stampToDate(mysql_result($result, 0, 9) . " " . mysql_result($result, 0, 12), "%Y%m%dT%H%M%S");
                } else {
                    $link .= "&dtstart=" . stampToDate(mysql_result($result, 0, 9) . " " . mysql_result($result, 0, 10), "%Y%m%dT%H%M%S") . "&dtend=" . stampToDate(mysql_result($result, 0, 9) . " " . mysql_result($result, 0, 10), "%Y%m%dT%H%M%S");
                }
            } else {
                $link .= "&dtstart=" . stampToDate(mysql_result($result, 0, 9), "%Y%m%d") . "T000000&dtend=" . stampToDate(mysql_result($result, 0, 9), "%Y%m%d") . "T000000";
            }
            $link .= "&summary=" . urlencode(mysql_result($result, 0, 1));
            if (strlen(mysql_result($result, 0, 8)) > 400) {
                $link .= "&description=" . urlencode(htmlspecialchars(strip_tags(cOut(substr(mysql_result($result, 0, 8), 0, 400)))) . "...\n\nFull Description available at: " . CalRoot . "/index.php?eID=" . $eID);
            } else {
                $link .= "&description=" . urlencode(htmlspecialchars(strip_tags(cOut(mysql_result($result, 0, 8)))));
            }
            if (mysql_result($result, 0, 35) == 0 || mysql_result($result, 0, 35) == '') {
                $link .= "&location=" . urlencode(mysql_result($result, 0, 3) . " " . mysql_result($result, 0, 4) . " " . mysql_result($result, 0, 5) . " " . mysql_result($result, 0, 6) . " " . mysql_result($result, 0, 37) . " " . mysql_result($result, 0, 7));
            } else {
                $result = doQuery("SELECT * FROM " . HC_TblPrefix . "locations WHERE PkID = '" . cIn(mysql_result($result, 0, 35)) . "'");
                $link .= "&location=" . urlencode(mysql_result($result, 0, 2) . " " . mysql_result($result, 0, 3) . " " . mysql_result($result, 0, 4) . " " . mysql_result($result, 0, 5) . " " . mysql_result($result, 0, 6) . " " . mysql_result($result, 0, 7));
            }
            header("Location: {$link}");
            break;
    }
} else {
    header('Location: ' . CalRoot);
}
コード例 #4
0
ファイル: AdminBrowse.php プロジェクト: pvidali/BCSR-1
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 . '">
				<div class="txt" style="width:30%;">' . cOut($row[2] . ', ' . $row[1]) . '</div>
				<div class="txt" style="width:40%;">' . cOut($row[3]) . '</div>
				<div class="txt" style="width:20%;">' . ($row[4] != '' ? stampToDate($row[4], $hc_cfg[24] . ' ' . $hc_cfg[23]) : 'N/A') . '</div>
				<div class="tools" style="width:10%;">
					<a href="' . AdminRoot . '/index.php?com=adminedit&amp;aID=' . $row[0] . '"><img src="' . AdminRoot . '/img/icons/edit.png" width="16" height="16" alt="" /></a>
					<a href="javascript:;" onclick="doDelete(\'' . $row[0] . '\');return false;"><img src="' . AdminRoot . '/img/icons/delete.png" width="16" height="16" alt="" /></a>
				</div>
			</li>';
        ++$cnt;
    }
    echo '
		</ul>
		<script>
		//<!--
		function doDelete(dID){
			if(confirm("' . $hc_lang_admin['Valid07'] . '\\n\\n          ' . $hc_lang_admin['Valid08'] . '\\n          ' . $hc_lang_admin['Valid09'] . '")){
				document.location.href = "' . AdminRoot . '/components/AdminEditAction.php?dID=" + dID + "&tkn=' . set_form_token(1) . '";
コード例 #5
0
ファイル: SettingsAPI.php プロジェクト: pvidali/BCSR-1
$eventbriteGoogleID = cOut(mysql_result($result, 28, 0));
$eventbriteGoogleKey = cOut(mysql_result($result, 29, 0));
$twtrComKey = cOut(mysql_result($result, 30, 0));
$twtrComSec = cOut(mysql_result($result, 31, 0));
$twtrSignIn = cOut(mysql_result($result, 32, 0));
$fbSignIn = cOut(mysql_result($result, 33, 0));
$googSignIn = cOut(mysql_result($result, 34, 0));
$fbAppID = cOut(mysql_result($result, 35, 0));
$fbAppSec = cOut(mysql_result($result, 36, 0));
$fbConOpts = json_decode(cOut(mysql_result($result, 37, 0)), true);
$fbActiveT = cOut(mysql_result($result, 38, 0));
$fbTokenU = cOut(mysql_result($result, 39, 0));
$fbExpires = cOut(mysql_result($result, 40, 0));
$fbActiveI = cOut(mysql_result($result, 41, 0));
$googID = cOut(mysql_result($result, 42, 0));
$googSec = cOut(mysql_result($result, 43, 0));
$fbConOptsOut = '';
echo '
	<form name="frmSettings" id="frmSettings" method="post" action="' . AdminRoot . '/components/SettingsAPIAction.php" onsubmit="return validate();">';
set_form_token();
echo '
	<fieldset>
		<legend>' . $hc_lang_settings['Maps'] . '</legend>
		<label for="mapLibrary">' . $hc_lang_settings['Library'] . '</label>
		<select name="mapLibrary" id="mapLibrary" onchange="togMapLibrary(this.options[this.selectedIndex].value);">
			<option' . ($mapLibrary == 1 ? ' selected="selected"' : '') . ' value="1">' . $hc_lang_settings['Library1'] . '</option>
			<option' . ($mapLibrary == 2 ? ' selected="selected"' : '') . ' value="2">' . $hc_lang_settings['Library2'] . '</option>
		</select>
		<div id="library1" style="clear:both;' . ($mapLibrary != 1 ? ' display:none;' : '') . '">
			<label for="googMapURL">' . $hc_lang_settings['GoogMapURL'] . '</label>
			<input' . ($mapLibrary != 1 ? ' disabled="disabled"' : '') . ' name="googMapURL" id="googMapURL" type="url" size="30" maxlength="100" required="required" value="' . $googMapURL . '" />
コード例 #6
0
ファイル: PaymentEdit.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;
}
$errorMsg = '';
$result = doQuery("SELECT * FROM " . HC_TblPrefix . "settings WHERE PkID IN(5,6);");
if (!hasRows($result)) {
    $apiFail = true;
    $errorMsg = 'Eventbrite API Settings Unavailable.';
} else {
    $ebAPI = cOut(mysql_result($result, 0, 1));
    $ebUser = cOut(mysql_result($result, 1, 1));
    if ($ebAPI == '' || $ebUser == '') {
        $apiFail = true;
        $errorMsg = 'Eventbrite API Settings Missing.';
    } else {
        $ebSend = "/xml/payment_update?app_key=" . $ebAPI . "&user_key=" . $ebUser;
        $ebSend .= "&event_id=" . $ebID;
        if (isset($_POST['ebPaypal']) && $hc_cfg[103] != '') {
            $ebSend .= "&accept_paypal=1";
            $ebSend .= "&paypal_email=" . $hc_cfg[103];
        } else {
            $ebSend .= "&accept_paypal=0";
        }
        if (isset($_POST['ebGoogleC']) && $hc_cfg[104] != '' && $hc_cfg[105] != '') {
            $ebSend .= "&accept_google=1";
            $ebSend .= "&google_merchant_id=" . $hc_cfg[104];
コード例 #7
0
ファイル: ReportOverview.php プロジェクト: pvidali/BCSR-1
    echo '
	</ul>
	</div>';
}
$result = doQuery("SELECT FirstName, LastName, Email, RegisteredAt FROM " . HC_TblPrefix . "subscribers WHERE IsConfirm = 1 ORDER BY RegisteredAt DESC, LastName, FirstName LIMIT 50");
if (hasRows($result)) {
    echo '
	<ul class="data">
		<li class="row header uline">
			<div style="width:88%;">' . $hc_lang_reports['NewestUsers'] . '</div>
			<div style="width:10%;">' . $hc_lang_reports['Registered'] . '</div>
			<div style="width:2%;">&nbsp;</div>
		</li>
	</ul>
	<div class="ostat">
	<ul class="data">';
    $cnt = 0;
    while ($row = mysql_fetch_row($result)) {
        $hl = $cnt % 2 == 1 ? ' hl' : '';
        echo '
		<li class="row' . $hl . '">
			<div class="txt" title="' . cOut($row[0]) . '" style="width:30%;">' . cOut(trim($row[1] . ', ' . $row[0])) . '</div>
			<div style="width:60%;">' . cOut($row[2]) . '</div>
			<div class="number" style="width:10%;">' . stampToDate($row[3], $hc_cfg[24]) . '</div>
		</li>';
        ++$cnt;
    }
    echo '
	</ul>
	</div>';
}
コード例 #8
0
ファイル: MailGroups.php プロジェクト: pvidali/BCSR-1
    $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' : '';
            echo '
		<li class="row' . $hl . '">
			<div style="width:50%;">' . cOut($row[1]) . '</div>
			<div style="width:20%;">' . ($row[2] == 1 ? $hc_lang_news['Public'] : $hc_lang_news['AdminOnly']) . '</div>
			<div class="number" style="width:20%;">' . ($row[0] == 1 ? number_format($row[4], 0, '.', ',') : number_format($row[3], 0, '.', ',')) . '</div>
			<div class="tools" style="width:10%;">
				<a href="' . AdminRoot . '/index.php?com=subgrps&amp;gID=' . $row[0] . '"><img src="' . AdminRoot . '/img/icons/edit.png" width="16" height="16" alt="" /></a>
				' . ($row[0] > 1 ? '<a href="javascript:;" onclick="javascript:doDelete(\'' . $row[0] . '\');return false;"><img src="' . AdminRoot . '/img/icons/delete.png" width="16" height="16" alt="" /></a>' : '<img src="' . AdminRoot . '/img/spacer.gif" width="16" height="16" alt="" />') . '
			</div>
		</li>';
            ++$cnt;
        }
        echo '
	</ul>
	
	<script language="JavaScript" type="text/JavaScript">
	//<!--
	function doDelete(dID){
コード例 #9
0
ファイル: Digest.php プロジェクト: pvidali/BCSR-1
    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>
		<legend>' . $hc_lang_pages['Settings'] . '</legend>
		<label for="status">' . $hc_lang_pages['StatusD'] . '</label>
		<select name="status" id="status">
			<option' . ($status == 0 ? ' selected="selected"' : '') . ' value="0">' . $hc_lang_pages['StatusD0'] . '</option>
			<option' . ($status == 1 ? ' selected="selected"' : '') . ' value="1">' . $hc_lang_pages['StatusD1'] . '</option>
		</select>
		<span class="output">
			<a class="tooltip" data-tip="' . $hc_lang_pages['Tip01'] . '" href="javascript:;" tabindex="-1"><img src="' . AdminRoot . '/img/icons/info.png" width="16" height="16" alt="" /></a>
		</span>
コード例 #10
0
ファイル: ReportFail.php プロジェクト: pvidali/BCSR-1
				<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;
    while ($row = mysql_fetch_row($result)) {
        $hl = $cnt % 2 == 1 ? ' hl' : '';
        echo '
			<li class="row' . $hl . '">
				<div class="txt" title="' . cOut($row[1]) . '" style="width:25%;">' . cOut('(' . $row[0] . ') ' . trim($row[1] . ' ' . $row[2])) . '</div>
				<div style="width:15%;">' . cOut($row[4]) . '</div>
				<div style="width:20%;">' . stampToDate($row[6], $hc_cfg[24] . ' ' . $hc_cfg[23]) . '</div>
				<div class="txt" title="' . cOut($row[5]) . '" style="width:30%;">' . cOut($row[5]) . '</div>
				<div class="tools" style="width:10%;">
					<a href="' . AdminRoot . '/index.php?com=adminedit&amp;aID=' . $row[0] . '"><img src="' . AdminRoot . '/img/icons/user_edit.png" width="16" height="16" alt="" /></a>
					<a href="javascript:;" onclick="doDelete(\'' . $row[7] . '\');return false;"><img src="' . AdminRoot . '/img/icons/delete.png" width="16" height="16" alt="" /></a>
				</div>
			</li>';
        ++$cnt;
    }
    echo '
		</div>
		</ul>
		<script>
		//<!--
		function doDelete(dID){
			if(confirm("' . $hc_lang_reports['Valid04'] . '\\n\\n          ' . $hc_lang_reports['Valid05'] . '\\n          ' . $hc_lang_reports['Valid06'] . '")){
				document.location.href = "' . AdminRoot . '/components/ReportFailAction.php?dID=" + dID + "&tkn=' . set_form_token(1) . '";
コード例 #11
0
ファイル: CategoryManage.php プロジェクト: pvidali/BCSR-1
	<input type="submit" name="submit" id="submit" value="' . $hc_lang_manage['SaveCat'] . '" />
	</form>
	</div>
	<div class="catMgtList">
		<ul class="data">';
$result = doQuery("SELECT c.PkID, c.CategoryName, c.ParentID, c.CategoryName as Sort, NULL as Selected\r\n\t\t\t\t\tFROM " . HC_TblPrefix . "categories c \r\n\t\t\t\t\t\tLEFT JOIN " . HC_TblPrefix . "eventcategories ec ON (c.PkID = ec.CategoryID)\r\n\t\t\t\t\tWHERE c.ParentID = 0 AND c.IsActive = 1\r\n\t\t\t\t\tGROUP BY c.PkID, c.CategoryName, c.ParentID\r\n\t\t\t\t\tUNION SELECT c.PkID, c.CategoryName, c.ParentID, c2.CategoryName as Sort, NULL as Selected\r\n\t\t\t\t\tFROM " . HC_TblPrefix . "categories c \r\n\t\t\t\t\t\tLEFT JOIN " . HC_TblPrefix . "categories c2 ON (c.ParentID = c2.PkID) \r\n\t\t\t\t\t\tLEFT JOIN " . HC_TblPrefix . "eventcategories ec ON (c.PkID = ec.CategoryID) \r\n\t\t\t\t\tWHERE c.ParentID > 0 AND c.IsActive = 1\r\n\t\t\t\t\tGROUP BY c.PkID, c.CategoryName, c.ParentID, c2.CategoryName\r\n\t\t\t\t\tORDER BY Sort, ParentID, CategoryName");
$rowCnt = mysql_num_rows($result);
if (hasRows($result)) {
    $cnt = 0;
    $curCat = "";
    while ($row = mysql_fetch_row($result)) {
        $hl = $cnt % 2 == 1 ? ' hl' : '';
        $indent = $row[2] != 0 ? '&nbsp;&nbsp;&nbsp;&nbsp;' : '';
        echo '
			<li class="row' . $hl . '">
				<div style="width:85%;">' . $indent . ($cID == $row[0] && $cID > 0 ? '<b>' . cOut($row[1]) . '</b>' : cOut($row[1])) . '</div>
				<div style="width:15%;">
					<a href="' . AdminRoot . '/index.php?com=categorymanage&amp;cID=' . $row[0] . '"><img src="' . AdminRoot . '/img/icons/edit.png" width="16" height="16" alt="" /></a>
					' . ($rowCnt > 1 ? '<a href="javascript:;" onclick="doDelete(\'' . $row[0] . '\');return false;"><img src="' . AdminRoot . '/img/icons/delete.png" width="16" height="16" alt="" /></a>' : '') . '
				</div>
			</li>';
        $cnt++;
    }
    echo '
			</ul>
		<script>
		//<!--
		function doDelete(dID){
			if(confirm("' . $hc_lang_manage['Valid08'] . '\\n\\n          ' . $hc_lang_manage['Valid09'] . '\\n          ' . $hc_lang_manage['Valid10'] . '"))
				window.location.href = "' . AdminRoot . '/components/CategoryManageAction.php?dID=" + dID + "&tkn=' . $token . '";
		}
コード例 #12
0
ファイル: TemplatesEdit.php プロジェクト: pvidali/BCSR-1
$cleanup = "BLANK";
$dateFormat = 0;
$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>
コード例 #13
0
ファイル: NewsletterProgress.php プロジェクト: pvidali/BCSR-1
/**
 * Builds list of events for the template based on the passed query.
 * @param string $qry Columns: PkID, Title, StartDate, StartTime, IsBillboard, SeriesID, TBD, EndTime
 * @return string
 */
function getEventList($qry)
{
    global $hc_lang_news, $hc_cfg;
    $replace = $curDate = '';
    $hide = array();
    $cnt = 0;
    $result = doQuery($qry);
    $str = '<ul style="list-style:none;padding:0px;">';
    while ($row = mysql_fetch_row($result)) {
        if ($row[5] == '' || !in_array($row[5], $hide)) {
            if ($curDate != $row[2]) {
                $curDate = cOut($row[2]);
                $str .= '<li>' . stampToDate($row[2], $hc_cfg[14]) . '</li>';
            }
            $str .= '<li style="padding-left:15px;"><a href="' . CalRoot . '/index.php?eID=' . $row[0] . '" target="_blank">' . $row[1] . '</a>';
            if ($row[6] == 0) {
                $str .= ' - ' . strftime($hc_cfg[23], strtotime($row[3])) . '</li>';
            } elseif ($row[6] == 1) {
                $str .= ' - <i>' . $hc_lang_news['AllDay'] . '</i></li>';
            } elseif ($row[6] == 2) {
                $str .= ' - <i>' . $hc_lang_news['TBA'] . '</i></li>';
            }
        }
        if ($row[5] != '' && !in_array($row[5], $hide)) {
            $hide[] = $row[5];
        }
        ++$cnt;
    }
    $str .= '</ul>';
    return $str;
}
コード例 #14
0
ファイル: user-search.php プロジェクト: pvidali/BCSR-1
        switch ($row[1]) {
            case 1:
                $net_img = 'twitter_icon';
                break;
            case 2:
                $net_img = 'facebook_icon';
                break;
            case 3:
                $net_img = 'google';
                break;
        }
        echo '
				<label' . $hl . ' for="usrValue_' . $row[0] . '"><input name="usrValue" id="usrValue_' . $row[0] . '" type="radio" onclick="setUser(' . $row[0] . ');" />
				<a href="' . AdminRoot . '/index.php?com=useredit&uID=' . $row[0] . '" target="_blank"><img src="' . AdminRoot . '/img/icons/user_edit.png" width="16" height="16" alt="" /></a>
				<img src="' . AdminRoot . '/img/logos/' . $net_img . '.png" width="16" height="16" style="float:none;" />
				' . ($row[4] != '' ? '<a href="mailto:' . $row[4] . '">' . cOut($row[2]) . '</a>' : cOut($row[2])) . '
				(' . $row[10] . ' ' . $hc_lang_user['Events'] . ')
				</label>';
        ++$x;
    }
    $pages = ceil(mysql_result($resultP, 0, 0) / $resLimit);
    if ($pages > 1) {
        echo '<div id="pages">';
        for ($x = 0; $x < $pages; ++$x) {
            if ($x % 20 == 0 && $x > 0) {
                echo "<br /><br />";
            } elseif ($x > 0) {
                echo "&nbsp;|&nbsp;";
            }
            echo $resOffset != $x ? '<a href="javascript:;" onclick="searchUsers(' . $x . ');">' . ($x + 1) . '</a>' : '<b>' . ($x + 1) . '</b>';
        }
コード例 #15
0
ファイル: SettingsTheme.php プロジェクト: pvidali/BCSR-1
    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);
foreach ($themes as $val) {
    $fullsiteOpts .= '
			<option' . ($val == $fullsite ? ' selected="selected"' : '') . ' value="' . $val . '">' . ucfirst($val) . '</option>';
    $mobileOpts .= '
コード例 #16
0
ファイル: event-to-friend.php プロジェクト: pvidali/BCSR-1
}
spamIt($proof, $challenge, 2);
$myName = cIn(strip_tags(cleanBreaks($_POST['hc_fx1'])));
$myEmail = cIn(strip_tags(cleanBreaks($_POST['hc_fx2'])));
$friendName = cIn(strip_tags(cleanBreaks($_POST['hc_fx3'])));
$friendEmail = cIn(strip_tags(cleanBreaks($_POST['hc_fx4'])));
$sendMsg = cleanBreaks(nl2br(strip_tags($_POST['hc_fx5'])));
$eID = isset($_POST['eID']) && is_numeric($_POST['eID']) ? cIn(strip_tags($_POST['eID'])) : 0;
$tID = isset($_POST['tID']) && is_numeric($_POST['tID']) ? cIn(strip_tags($_POST['tID'])) : 0;
if ($tID == 0) {
    $result = doQuery("SELECT Title, StartDate, StartTime, TBD FROM " . HC_TblPrefix . "events WHERE PkID = '" . $eID . "'");
} else {
    $result = doQuery("SELECT Name, Address, Address2, City, State, Zip, Country FROM " . HC_TblPrefix . "locations WHERE PkID = '" . $eID . "'");
}
if (hasRows($result) && $myName != '' && $myEmail != '' && $friendName != '' && $friendEmail != '') {
    $message = '<p>' . cOut($sendMsg) . '</p>';
    $message .= '<p><b>' . mysql_result($result, 0, 0) . '</b><br />';
    if ($tID == 0) {
        $where = '/index.php?com=send&eID=';
        $subject = CalName . " " . $hc_lang_sendtofriend['SubjectE'] . " " . $myName;
        $message .= stampToDate(mysql_result($result, 0, 1), $hc_cfg[14]) . ' - ';
        if (mysql_result($result, 0, 3) == 0) {
            $message .= stampToDate("1980-01-01 " . mysql_result($result, 0, 2), $hc_cfg[23]);
        } elseif (mysql_result($result, 0, 3) == 1) {
            $message .= $hc_lang_sendtofriend['AllDay'];
        } elseif (mysql_result($result, 0, 3) == 2) {
            $message .= $hc_lang_sendtofriend['TBA'];
        }
        $message .= '<br /><a href="' . CalRoot . '/index.php?eID=' . $eID . '">' . CalRoot . '/index.php?eID=' . $eID . '</a></p>';
    } else {
        $where = '/index.php?com=send&lID=';
コード例 #17
0
<?php

/**
 * @package Helios Calendar
 * @license GNU General Public License version 2 or later; see LICENSE
 */
define('hcAdmin', true);
include '../loader.php';
admin_logged_in();
action_headers();
$pID = isset($_GET['pID']) && is_numeric($_GET['pID']) ? cIn(strip_tags($_GET['pID'])) : 0;
$result = doQuery("SELECT TemplateSource FROM " . HC_TblPrefix . "templatesnews WHERE PkID = '" . $pID . "'");
echo hasRows($result) ? cOut(mysql_result($result, 0, 0)) : $hc_lang_news['InvalidTemplate'];
コード例 #18
0
ファイル: MailSubBrowse.php プロジェクト: pvidali/BCSR-1
if (hasRows($result)) {
    echo '
		<ul class="data">
			<li class="row header uline">
				<div style="width:35%;">' . $hc_lang_news['Name'] . '</div>
				<div style="width:40%;">' . $hc_lang_news['Emailb'] . '</div>
				<div style="width:15%;">' . $hc_lang_news['Registered'] . '</div>
				<div style="width:10%;">&nbsp;</div>
			</li>';
    $cnt = 1;
    while ($row = mysql_fetch_row($result)) {
        $hl = $cnt % 2 == 0 ? ' hl' : '';
        echo '
			<li class="row' . $hl . '">
				<div style="width:35%;">' . cOut(trim($row[2] . ', ' . $row[1])) . '</div>
				<div class="txt" title="' . cOut($row[3]) . '" style="width:40%;">' . cOut($row[3]) . '&nbsp;</div>
				<div style="width:15%;">' . stampToDate($row[4], $hc_cfg[24]) . '</div>
				<div class="tools" style="width:10%;">
					<a href="' . AdminRoot . '/index.php?com=subedit&amp;uID=' . $row[0] . '"><img src="' . AdminRoot . '/img/icons/edit.png" width="16" height="16" alt="" /></a>
					<a href="javascript:;" onclick="doDelete(\'' . $row[0] . '\');return false;"><img src="' . AdminRoot . '/img/icons/delete.png" width="16" height="16" alt="" /></a>
				</div>
			</li>';
        ++$cnt;
    }
    echo '
		</ul>
		
		<script>
		//<!--
		function doDelete(dID){
			if(confirm("' . $hc_lang_news['Valid08'] . '\\n\\n          ' . $hc_lang_news['Valid09'] . '\\n          ' . $hc_lang_news['Valid10'] . '"))
コード例 #19
0
ファイル: eventadd-archive.php プロジェクト: pvidali/BCSR-1
 $imageURL = cOut(mysql_result($result, 0, 38));
 $featured = cOut(mysql_result($result, 0, 40));
 $expire = mysql_result($result, 0, 41) > 0 ? cOut(mysql_result($result, 0, 41)) : $hc_cfg[134];
 $locID = cOut(mysql_result($result, 0, 33));
 $locName = $locID == 0 ? cOut(mysql_result($result, 0, 2)) : cOut(mysql_result($result, 0, 43));
 $locAddress = $locID == 0 ? cOut(mysql_result($result, 0, 3)) : cOut(mysql_result($result, 0, 44));
 $locAddress2 = $locID == 0 ? cOut(mysql_result($result, 0, 4)) : cOut(mysql_result($result, 0, 45));
 $locCity = $locID == 0 ? cOut(mysql_result($result, 0, 5)) : cOut(mysql_result($result, 0, 46));
 $state = $locID == 0 ? cOut(mysql_result($result, 0, 6)) : cOut(mysql_result($result, 0, 47));
 $locPostal = $locID == 0 ? cOut(mysql_result($result, 0, 7)) : cOut(mysql_result($result, 0, 48));
 $locCountry = $locID == 0 ? cOut(mysql_result($result, 0, 35)) : cOut(mysql_result($result, 0, 49));
 $cost = cOut(mysql_result($result, 0, 34));
 $rsvp_type = cOut(mysql_result($result, 0, 51));
 $rsvp_space = cOut(mysql_result($result, 0, 55));
 $rsvp_disp = cOut(mysql_result($result, 0, 56));
 $rsvp_notice = cOut(mysql_result($result, 0, 57));
 $rsvp_open = stampToDate(mysql_result($result, 0, 53), $hc_cfg[24]);
 $rsvp_close = stampToDate(mysql_result($result, 0, 54), $hc_cfg[24]);
 if ($tbd == 0) {
     $startTimeHour = date($hc_time['format'], strtotime(mysql_result($result, 0, 9) . ' ' . mysql_result($result, 0, 10)));
     $startTimeMins = date("i", strtotime(mysql_result($result, 0, 9) . ' ' . mysql_result($result, 0, 10)));
     $startTimeAMPM = date("A", strtotime(mysql_result($result, 0, 9) . ' ' . mysql_result($result, 0, 10)));
     if (mysql_result($result, 0, 12) != '') {
         $endTimeHour = date($hc_time['format'], strtotime(mysql_result($result, 0, 9) . ' ' . mysql_result($result, 0, 12)));
         $endTimeMins = date("i", strtotime(mysql_result($result, 0, 9) . ' ' . mysql_result($result, 0, 12)));
         $endTimeAMPM = date("A", strtotime(mysql_result($result, 0, 9) . ' ' . mysql_result($result, 0, 12)));
     } else {
         $endTimeHour = date($hc_time['format'], strtotime(mysql_result($result, 0, 9) . ' ' . mysql_result($result, 0, 10) . ' +1 hour'));
         $endTimeAMPM = date("A", strtotime(mysql_result($result, 0, 9) . ' ' . mysql_result($result, 0, 10) . ' +1 hour'));
         $noEndTime = 1;
     }
コード例 #20
0
ファイル: event-rsvp.php プロジェクト: pvidali/BCSR-1
    $eOver = $eLimit = 0;
    if (mysql_result($result, 0, 0) > mysql_result($result, 0, 1) && mysql_result($result, 0, 1) != 0) {
        $eOver = 1;
    } elseif (mysql_result($result, 0, 0) == mysql_result($result, 0, 1) && mysql_result($result, 0, 1) != 0) {
        $eLimit = 1;
    }
    $rMsg = '<p><b>' . cOut($hc_lang_rsvp['PartySize']) . " " . cOut($partySize) . '</b>';
    $rMsg .= '<br />' . cOut($regName) . '<br />' . cOut($regEmail);
    $rMsg .= $phone != '' ? '<br />' . $phone : '';
    $rMsg .= $address != '' ? '<br />' . strip_tags(buildAddress($address, $address2, $city, $state, $zip, $country, $hc_lang_config['AddressType']), '<br>') : '';
    $rMsg .= '</p>';
    //	RSVP User Email
    $regSubj = cOut($hc_lang_rsvp['regSubject']) . $eventTitle;
    $regMsg = '<p>' . cOut($hc_lang_rsvp['regMsg']) . '</p>';
    $regMsg .= $eMsg . $rMsg;
    $regMsg .= $eOver == 1 ? " " . cOut($hc_lang_rsvp['regOverflow']) : '';
    $regMsg .= '<p>' . cOut($hc_lang_rsvp['ThankYou']) . '<br />' . $hc_cfg[79] . '</p>';
    $regMsg .= '<p>' . cOut($hc_lang_rsvp['regDisclaimer']) . '</p>';
    //	Event Contact Email
    $conSubj = cOut($hc_lang_rsvp['conSubject']) . $eventTitle;
    $conMsg = '<p>' . cOut($hc_lang_rsvp['conMsg']) . '</p>';
    $conMsg .= $eMsg;
    $conMsg .= $eOver == 1 ? '<p>' . cOut($hc_lang_rsvp['conOverflow']) . '</p>' : '';
    $conMsg .= $eLimit == 1 ? '<p>' . cOut($hc_lang_rsvp['conLimit']) . '</p>' : '';
    $conMsg .= $rMsg;
    $conMsg .= '<p>' . cOut($hc_lang_rsvp['ThankYou']) . '<br />' . $hc_cfg[79] . '</p>';
    $conMsg .= '<p>' . cOut($hc_lang_rsvp['conDisclaimer']) . '</p>';
    reMail($regName, $regEmail, $regSubj, $regMsg, $hc_cfg[79], $hc_cfg[78]);
    reMail('', $conEmail, $conSubj, $conMsg, $hc_cfg[79], $hc_cfg[78]);
    header("Location: " . CalRoot . "/index.php?com=rsvp&eID=" . $eID . "&msg=2");
}
コード例 #21
0
ファイル: index.php プロジェクト: pvidali/BCSR-1
	<generator>Helios Calendar</generator>
	<docs>' . CalRoot . '&#47;index.php&#63;com=tools</docs>
	<description>' . cleanXMLChars($hc_lang_rss['Upcoming']) . '</description>';
    $result = doQuery($query);
    if (hasRows($result)) {
        echo '
	<title>' . cleanXMLChars($feedName . ' - ' . CalName) . '</title>';
        $cnt = 0;
        while ($row = mysql_fetch_row($result)) {
            $description = $hc_cfg[107] > 0 ? clean_truncate($row[2], $hc_cfg[107]) : $row[2];
            $comment = $hc_cfg[25] != '' ? '<comments><![CDATA[' . CalRoot . '/index.php?eID=' . $row[0] . '#disqus_thread' . ']]></comments>' : '';
            echo '
	<item>
		<title>' . cleanXMLChars(stampToDate(cOut($row[3]), $hc_cfg[24])) . " - " . cleanXMLChars(cOut($row[1])) . '</title>
		<link><![CDATA[' . CalRoot . '/index.php?eID=' . $row[0] . ']]></link>
		<description>' . cleanXMLChars(cOut($description)) . '</description>
		' . $comment . '
		<guid>' . CalRoot . '/index.php&#63;eID=' . $row[0] . '</guid>
		<pubDate>' . cleanXMLChars(stampToDate($row[3] . ' ' . $row[4], "%a, %d %b %Y %H:%M:%S") . ' ' . $tzRSS) . '</pubDate>
	</item>';
            ++$cnt;
        }
    } else {
        echo '
	<title>' . $hc_lang_rss['RSSSorry'] . '</title>
	<item>
		<title>' . $hc_lang_rss['RSSNoEvents'] . '</title>
		<link>' . CalRoot . '/</link>
		<description>' . $hc_lang_rss['RSSNoLink'] . '</description>
		<guid>' . CalRoot . '/</guid>
	</item>';
コード例 #22
0
ファイル: AdminEdit.php プロジェクト: pvidali/BCSR-1
    $pages = mysql_result($result, 0, 17);
    $notices = array_filter(explode(',', mysql_result($result, 0, 18)), 'is_numeric');
    $fails = mysql_result($result, 0, 19);
    $active = $_SESSION['AdminPkID'] == $aID ? ' disabled="disabled"' : '';
    $resultH = doQuery("SELECT * FROM " . HC_TblPrefix . "adminloginhistory WHERE AdminID = '" . $aID . "' ORDER BY LoginTime DESC LIMIT 100");
    if (hasRows($resultH)) {
        $login_history .= '
		<ul class="data">';
        $cnt = 0;
        while ($row = mysql_fetch_row($resultH)) {
            $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 '
コード例 #23
0
ファイル: ReportActivityD.php プロジェクト: pvidali/BCSR-1
 */
define('hcAdmin', true);
include '../loader.php';
admin_logged_in();
action_headers();
include HCLANG . '/admin/newsletter.php';
$eID = isset($_SESSION['ReportDownload']) ? implode(',', array_filter(explode(',', utf8_decode($_SESSION['ReportDownload'])), 'is_numeric')) : '0';
header('Content-type: application/csv');
header('Content-Disposition: inline; filename="' . CalName . ' Event Report ' . SYSDATE . '.csv"');
$resultX = doQuery("SELECT MAX(Views), MAX(Directions), MAX(Downloads), MAX(EmailToFriend), MAX(URLClicks),\r\n\t\t\t\t\t\tAVG(Views), AVG(Directions), AVG(Downloads), AVG(EmailToFriend), AVG(URLClicks)\r\n\t\t\t\t\tFROM " . HC_TblPrefix . "events\r\n\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));
    $aURL = cOut(round(mysql_result($resultX, 0, 9), 0));
}
echo "Event,Views,Directions,Downloads,Email,URL\n";
echo "Average," . number_format($aViews, 0, '.', ',') . "," . number_format($aDir, 0, '.', ',') . "," . number_format($aDwnl, 0, '.', ',') . "," . number_format($aEmail, 0, '.', ',') . "," . number_format($aURL, 0, '.', ',') . "\n";
echo "Best," . number_format($mViews, 0, '.', ',') . "," . number_format($mDir, 0, '.', ',') . "," . number_format($mDwnl, 0, '.', ',') . "," . number_format($mEmail, 0, '.', ',') . "," . number_format($mURL, 0, '.', ',') . "\n";
$result = doQuery("SELECT e.PkID, e.Title, e.Views, e.Directions, e.Downloads, e.EmailToFriend, e.URLClicks\r\n\t\t\t\t\tFROM " . HC_TblPrefix . "events e\r\n\t\t\t\t\tWHERE e.PkID IN(" . cIn($eID) . ") ORDER BY e.PkID");
if (hasRows($result)) {
    while ($row = mysql_fetch_row($result)) {
        echo "(" . $row[0] . ") " . str_replace(',', '', $row[1]) . "," . $row[2] . "," . $row[3] . "," . $row[4] . "," . $row[5] . "," . $row[6] . "\n";
    }
}
コード例 #24
0
ファイル: ical.php プロジェクト: pvidali/BCSR-1
        $summary = $row[1];
        $description = $hc_cfg[109] > 0 ? clean_truncate(strip_tags($row[2]), $hc_cfg[109]) . ' ' . $hc_lang_event['ReadMore'] . ' ' . CalRoot . '/?eID=' . $row[0] : $row[2];
        $location = $row[13] > 0 ? $row[24] . ' - ' . str_replace('<br />', ' ', buildAddress($row[25], $row[26], $row[27], $row[28], $row[29], $row[30])) : $row[16] . ' - ' . str_replace('<br />', ' ', buildAddress($row[17], $row[18], $row[19], $row[20], $row[21], $row[22]));
        $descFooter = "\\n______________________________\\niCalendar Feed powered by OU Calendar";
        echo "BEGIN:VEVENT\r\n";
        echo "URL;VALUE=URI:" . CalRoot . "/index.php?eID=" . $row[0] . "\r\n";
        if ($allDay == false) {
            echo "DTSTART:" . $startDate . "\r\n";
            echo "DTEND:" . $endDate . "\r\n";
        } else {
            echo "DTSTART;VALUE=DATE:" . $startDate . "\r\n";
            echo "DTEND;VALUE=DATE:" . $endDate . "\r\n";
        }
        echo "SUMMARY:" . str_replace(";", "\\;", str_replace(",", "\\,", html_entity_decode(cOut(cleanSpecialChars(strip_tags($summary)))))) . "\r\n";
        echo "DESCRIPTION:" . str_replace(";", "\\;", str_replace(",", "\\,", html_entity_decode(cOut(cleanSpecialChars(strip_tags(cleanBreaks($description))))) . $descFooter)) . "\r\n";
        echo "LOCATION:" . str_replace(";", "\\;", str_replace(",", "\\,", html_entity_decode(cOut($location)))) . "\r\n";
        echo "CATEGORIES:" . CalName . " Events\r\n";
        echo "PRIORITY:0\r\n";
        echo "TRANSP:TRANSPARENT\r\n";
        echo "END:VEVENT\r\n";
    }
    echo "END:VCALENDAR";
    fwrite($fp, ob_get_contents());
    fclose($fp);
    ob_end_clean();
}
include HCPATH . '/cache/ical' . SYSDATE;
function purge_icalendar()
{
    if (count(glob(HCPATH . '/cache/ical*')) > 0) {
        foreach (glob(HCPATH . '/cache/ical*') as $file) {
コード例 #25
0
ファイル: EventBillboard.php プロジェクト: pvidali/BCSR-1
				<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)) {
        $hl = $cnt % 2 == 1 ? ' hl' : '';
        echo '
			<li class="row ' . $hl . '">
				<div class="txt" title="' . cOut($row[1]) . '" style="width:70%;">' . cOut($row[1]) . '</div>
				<div style="width:10%;">' . stampToDate($row[2], $hc_cfg[24]) . '</div>
				<div class="number" style="width:10%;">' . number_format(cOut($row[3]), 0, '', ',') . '</div>
				<div class="tools" style="width:10%;">
					<a href="' . AdminRoot . '/index.php?com=eventedit&amp;eID=' . $row[0] . '"><img src="' . AdminRoot . '/img/icons/edit.png" width="16" height="16" alt="" /></a>
					<a href="javascript:;" onclick="doDelete(\'' . $row[0] . '\');return false;"><img src="' . AdminRoot . '/img/icons/delete.png" width="16" height="16" alt="" /></a>
				</div>
			</li>';
        ++$cnt;
    }
    echo '
		</div>
		</ul>
		<script>
		//<!--
		function doDelete(eID){
			if(confirm("' . $hc_lang_manage['Valid01'] . "\\n\\n          " . $hc_lang_manage['Valid02'] . "\\n          " . $hc_lang_manage['Valid03'] . '"))
				window.location.href = "' . AdminRoot . '/components/EventBillboardAction.php?eID=" + eID + "&tkn=' . set_form_token(1) . '";
コード例 #26
0
ファイル: int.php プロジェクト: pvidali/BCSR-1
/**
 * Output weekly dashboard to a page outside of Helios Calendar.
 * @since 2.0.1
 * @version 2.0.1
 * @param binary $submit include submit event link, 0 = hide , 1 = show (Default:1)
 * @param binary $ical include iCalendar subscription link, 0 = hide, 1 = show (Default:1)
 * @param binary $rss include All Events rss feed link, 0 = hide, 1 = show (Default:1)
 * @param binary $end_time include end time in event lists, 0 = hide, 1 = show (Default:1)
 * @param string $menu_format menu format string, accepts any supported strftime() format parameters (Default:%a %m/%d)
 * @return void
 */
function int_week_dashboard($submit = 1, $ical = 1, $rss = 1, $end_time = 1, $menu_format = '%a %m/%d')
{
    global $hc_cfg, $hc_lang_core;
    include HCLANG . '/public/integration.php';
    if (!file_exists(HCPATH . '/cache/int7_' . SYSDATE . '.php')) {
        if (count(glob(HCPATH . '/cache/int7_*.php')) > 0) {
            foreach (glob(HCPATH . '/cache/int7_*.php') as $file) {
                unlink($file);
            }
        }
        ob_start();
        $fp = fopen(HCPATH . '/cache/int7_' . SYSDATE . '.php', 'w');
        fwrite($fp, "<?php\n//\tHelios Dashboard Integration Events Cache - Delete this file when upgrading.\n");
        $result = doQuery("SELECT PkID, Title, StartDate, StartTime, EndTime, TBD FROM " . HC_TblPrefix . "events \r\n\t\t\t\t\t\t\tWHERE IsActive = 1 AND IsApproved = 1 AND StartDate Between '" . SYSDATE . "' AND ADDDATE('" . SYSDATE . "', INTERVAL 6 DAY)\r\n\t\t\t\t\t\t\tORDER BY StartDate, TBD, StartTime, Title");
        if (hasRows($result)) {
            $cur_day = -1;
            $cur_date = '';
            fwrite($fp, "\$hc_next7 = array(\n");
            while ($row = mysql_fetch_row($result)) {
                if ($cur_date != $row[2]) {
                    ++$cur_day;
                    $cur_date = $row[2];
                    if ($cur_day > 0) {
                        fwrite($fp, "\t),\n");
                    }
                    fwrite($fp, $cur_day . " => array(\n");
                }
                if ($row[5] == 0) {
                    $time = $row[3] != '' ? stampToDate($row[3], $hc_cfg[23]) : '';
                    $time .= $row[4] != '' && $end_time == 1 ? ' - ' . stampToDate($row[4], $hc_cfg[23]) : '';
                } else {
                    $time = $row[5] == 1 ? $hc_lang_int['AllDay'] : $hc_lang_int['TimeTBA'];
                }
                fwrite($fp, "\t" . $row[0] . " => array(\"" . $time . "\",\"" . stampToDate($row[2], $hc_cfg[14]) . "\",\"" . str_replace("\"", "'", cOut($row[1])) . "\"),\n");
            }
            fwrite($fp, "\t),");
        }
        fwrite($fp, "\n)\n?>");
        fwrite($fp, ob_get_contents());
        fclose($fp);
        ob_end_clean();
    }
    include HCPATH . '/cache/int7_' . SYSDATE . '.php';
    echo '
		<script>
		//<!--
		function hc_tog_dash(show){var i = 0;while(i <= 6){document.getElementById("hc_dashboard_day"+i).style.display = (i == show) ? "block" : "none";i++;}}
		//-->
		</script>
		<div id="hc_dashboard">
			<ul id="menu">
				<li><a href="javascript:;" onclick="hc_tog_dash(0);return false;">' . strftime($menu_format, strtotime(SYSDATE) + 86400 * 0) . '</a></li>
				<li><a href="javascript:;" onclick="hc_tog_dash(1);return false;">' . strftime($menu_format, strtotime(SYSDATE) + 86400 * 1) . '</a></li>
				<li><a href="javascript:;" onclick="hc_tog_dash(2);return false;">' . strftime($menu_format, strtotime(SYSDATE) + 86400 * 2) . '</a></li>
				<li><a href="javascript:;" onclick="hc_tog_dash(3);return false;">' . strftime($menu_format, strtotime(SYSDATE) + 86400 * 3) . '</a></li>
				<li><a href="javascript:;" onclick="hc_tog_dash(4);return false;">' . strftime($menu_format, strtotime(SYSDATE) + 86400 * 4) . '</a></li>
				<li><a href="javascript:;" onclick="hc_tog_dash(5);return false;">' . strftime($menu_format, strtotime(SYSDATE) + 86400 * 5) . '</a></li>
				<li><a href="javascript:;" onclick="hc_tog_dash(6);return false;">' . strftime($menu_format, strtotime(SYSDATE) + 86400 * 6) . '</a></li>
				' . ($rss == 1 && $hc_cfg[106] == 1 ? '<li class="icon"><a href="' . CalRoot . '/rss/" title="' . $hc_lang_int['TitleRSS'] . '" rel="nofollow" target="_blank"><img src="' . CalRoot . '/img/feed.png" width="16" height="16" alt="" /></a></li>' : '') . '
				' . ($ical == 1 && $hc_cfg[108] == 1 ? '<li class="icon"><a href="webcal://' . substr(CalRoot, 7) . '/link/ical.php" title="' . $hc_lang_int['TitleiCal'] . '" rel="nofollow"><img src="' . CalRoot . '/img/icons/ical.png" width="16" height="16" alt="" /></a></li>' : '') . '
			</ul>';
    $date = '';
    foreach ($hc_next7 as $day => $arr) {
        foreach ($arr as $id => $value) {
            if ($date != $value[1]) {
                $date = $value[1];
                echo '
			<div id="hc_dashboard_day' . $day . '" class="hc_dashboard_day"' . ($day > 0 ? ' style="display:none;"' : '') . '>
			<ul>
				<li>' . $value[1] . '</li>';
            }
            echo '
				<li><div class="time">' . $value[0] . '</div><a href="' . CalRoot . '/index.php?eID=' . $id . '" rel="nofollow">' . cOut($value[2]) . '</a></li>';
        }
        echo $date != '' ? '
			</ul>
			</div>' : '';
    }
    echo $date == '' ? $hc_lang_int['NoEvent'] : '';
    echo '
			<a href="' . CalRoot . '/" rel="nofollow">' . $hc_lang_int['Browse'] . '</a>
			' . ($submit == 1 ? '| <a href="' . CalRoot . '/index.php?com=submit" rel="nofollow">' . $hc_lang_int['Submit'] . '</a>' : '') . '
		</div>';
}
コード例 #27
0
ファイル: loader.php プロジェクト: pvidali/BCSR-1
             $crmbAdd[HCCanURL] = $hc_lang_core[HCCOM];
         }
     }
     $title = cOut(mysql_result($result, 0, 0));
     include_once HCLANG . '/public/' . HCCOM . '.php';
     include_once HCPATH . HCINC . '/functions/forms.php';
     load_theme_page('form.php');
     break;
 case 'rsvp':
     $result = doQuery("SELECT e.Title,e.StartDate,e.StartTime,e.TBD,e.ContactName,e.ContactEmail,e.SeriesID,er.OpenDate,er.CloseDate,er.RegOption,\r\n\t\t\t\t\t\t\t\t\tMIN(e2.StartDate),MAX(e2.StartDate),MIN(e2.PkID)\r\n\t\t\t\t\t\t\t\tFROM " . HC_TblPrefix . "events e\r\n\t\t\t\t\t\t\t\t\tLEFT JOIN " . HC_TblPrefix . "events e2 ON (e.SeriesID = e2.SeriesID)\r\n\t\t\t\t\t\t\t\t\tLEFT JOIN " . HC_TblPrefix . "eventrsvps er ON (e.PkID = er.EventID)\r\n\t\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t\t\te.PkID = '" . $eID . "'\r\n\t\t\t\t\t\t\t\tGROUP BY e.Title,e.StartDate,e.StartTime,e.TBD,e.ContactName,e.ContactEmail,e.SeriesID,er.OpenDate,er.CloseDate, er.RegOption\r\n\t\t\t\t\t\t\t\tORDER BY StartDate\r\n\t\t\t\t\t\t\t\tLIMIT 1");
     if ($eID > 0 && hasRows($result)) {
         define('HCCanURL', CalRoot . '/index.php?com=rsvp&amp;eID=' . $eID);
         $crmbAdd[CalRoot . '/index.php?eID=' . $eID] = mysql_result($result, 0, 0);
         $crmbAdd[HCCanURL] = $hc_lang_core[HCCOM];
     }
     $title = hasRows($result) ? cOut(mysql_result($result, 0, 0)) : '';
     include_once HCLANG . '/public/rsvp.php';
     include_once HCPATH . HCINC . '/functions/forms.php';
     load_theme_page('form.php');
     break;
 case 'submit':
     if ($hc_cfg[1] == 0) {
         go_home();
     }
 case 'filter':
 case 'search':
     define('HCCanURL', CalRoot . '/index.php?com=' . HCCOM);
     $crmbAdd[HCCanURL] = $hc_lang_core[HCCOM];
     include_once HCLANG . '/public/' . HCCOM . '.php';
     include_once HCPATH . HCINC . '/functions/forms.php';
     load_theme_page('form.php');
コード例 #28
0
ファイル: pages.php プロジェクト: pvidali/BCSR-1
/**
 * Output digest newsletters list. Newsletters listed in decending order by sent date.
 * @since 2.1.0
 * @version 2.1.0
 * @param integer $size max number of newsletters to include in the list (list may be smaller depending on settings/available newsletters).
 * @return void
 */
function digest_newsletter_list($size, $dateFormat = '')
{
    global $hc_cfg, $hc_lang_pages;
    if (!file_exists(HCPATH . '/cache/digest_' . SYSDATE . '_n')) {
        ob_start();
        $fp = fopen(HCPATH . '/cache/digest_' . SYSDATE . '_n', 'w');
        $result = doQuery("SELECT PkID, Subject, SentDate FROM " . HC_TblPrefix . "newsletters WHERE Status > 0 AND IsArchive = 1 AND IsActive = 1 AND ArchiveContents != '' ORDER BY SentDate DESC LIMIT " . $size);
        if (!hasRows($result)) {
            echo '
			<ul class="newsletters"><li>' . $hc_lang_pages['NoNewsletters'] . '</li></ul>';
            return 0;
        }
        $cnt = 1;
        $dateFormat = $dateFormat == '' ? $hc_cfg[24] : $dateFormat;
        echo '
			<ul class="newsletters">';
        while ($row = mysql_fetch_row($result)) {
            $hl = $cnt % 2 == 0 ? ' class="hl"' : '';
            echo '<li' . $hl . '><time datetime="' . stampToDate($row[2], '%Y-%m-%d') . '">' . stampToDate($row[2], $dateFormat) . '</time><a href="' . CalRoot . '/newsletter/index.php?n=' . md5($row[0]) . '" target="_blank">' . cOut($row[1]) . '</a></li>';
            ++$cnt;
        }
        echo '
			</ul>';
        fwrite($fp, ob_get_contents());
        fclose($fp);
        ob_end_clean();
    }
    include HCPATH . '/cache/digest_' . SYSDATE . '_n';
}
コード例 #29
0
ファイル: ToolFilter.php プロジェクト: pvidali/BCSR-1
		<legend>' . $hc_lang_tools['CategoriesLabel'] . '</legend>';
$result = doQuery("SELECT c.PkID, c.CategoryName, c.ParentID, c.CategoryName as Sort, NULL as Selected\r\n\t\t\t\t\tFROM " . HC_TblPrefix . "categories c \r\n\t\t\t\t\t\tLEFT JOIN " . HC_TblPrefix . "eventcategories ec ON (c.PkID = ec.CategoryID)\r\n\t\t\t\t\tWHERE c.ParentID = 0 AND c.IsActive = 1\r\n\t\t\t\t\tGROUP BY c.PkID, c.CategoryName, c.ParentID\r\n\t\t\t\t\tUNION SELECT c.PkID, c.CategoryName, c.ParentID, c2.CategoryName as Sort, NULL as Selected\r\n\t\t\t\t\tFROM " . HC_TblPrefix . "categories c \r\n\t\t\t\t\t\tLEFT JOIN " . HC_TblPrefix . "categories c2 ON (c.ParentID = c2.PkID) \r\n\t\t\t\t\t\tLEFT JOIN " . HC_TblPrefix . "eventcategories ec ON (c.PkID = ec.CategoryID) \r\n\t\t\t\t\tWHERE c.ParentID > 0 AND c.IsActive = 1\r\n\t\t\t\t\tGROUP BY c.PkID , c.CategoryName, c.ParentID, c2.CategoryName\r\n\t\t\t\t\tORDER BY Sort, ParentID, CategoryName");
$cnt = 1;
echo '
		<div class="catCol">';
while ($row = mysql_fetch_row($result)) {
    if ($cnt > ceil(mysql_num_rows($result) / $columns) && $row[2] == 0) {
        echo $cnt > 1 ? '
		</div>' : '';
        echo '
		<div class="catCol">';
        $cnt = 1;
    }
    $sub = $row[2] != 0 ? ' class="sub"' : '';
    echo '
			<label for="catID_' . $row[0] . '"' . $sub . '><input onclick="updateLink();" name="catID[]" id="catID_' . $row[0] . '" type="checkbox" value="' . $row[0] . '" />' . cOut($row[1]) . '</label>';
    ++$cnt;
}
echo '
		</div>
	</fieldset>
	<input name="reset" id="reset" type="reset" value="' . $hc_lang_tools['ResetLink'] . '" />
	</form>
	
	<script src="' . CalRoot . '/inc/javascript/validation.js"></script>
	<script>
	//<!--
		function updateLink(){
			var catStr = (validCheckArray("frmToolLink","catID[]",1,"error") == "") ? "l=" + checkUpdateString("frmToolLink", "catID[]") : "";
			var cityStr = (validCheckArray("frmToolLink","cityName[]",1,"error") == "") ? "c=" + checkUpdateString("frmToolLink", "cityName[]") : "";
			var both = (catStr != "" && cityStr != "") ? "&" : "";
コード例 #30
0
ファイル: simonsrock.php プロジェクト: pvidali/BCSR-1
function sr_event_browse($show_images = 0)
{
    global $lID, $hc_cfg, $hc_lang_event, $favQ1, $favQ2, $resultEB, $myNav;
    $location = $lID > 0 ? '&amp;lID=' . $lID : '';
    $cnt = $date = 0;
    $row_number = 1;
    echo $myNav;
    if (!hasRows($resultEB)) {
        no_event_notice();
        return 0;
    }
    while ($row = mysql_fetch_row($resultEB)) {
        //echo print_r($row);
        $color_class = sr_colorizer($row_number);
        $description = $hc_cfg[107] > 0 ? clean_truncate($row[21], $hc_cfg[107]) : $row[21];
        $categories = explode(",", $row[20]);
        //filtering out ACE
        switch (count($categories)) {
            case 0:
                $category = 'No Category';
                break;
            case 1:
                $category = substr($categories[0], 3);
                break;
            default:
                $category = substr($categories[0], -4) != '_ACE' ? substr($categories[0], 3) : substr($categories[1], 3);
                break;
        }
        $category = '<h4>' . $category . '</h4>';
        if ($date != $row[2]) {
            $date = $row[2];
            echo $cnt > 0 ? '</ul>' : '';
            echo '<h2>' . stampToDate($row[2], '%A, %B %d, %Y') . '</h2><ul>';
            $cnt = 1;
        }
        $limit = $row[8] > 0 ? cOut($row[8]) : $hc_cfg[134];
        $expire = $limit > 0 ? date("Y-m-d", strtotime($date) + $limit * 86400) : '';
        $cls = $cnt % 2 == 0 ? 'hl' : '';
        $cls .= $row[7] > 0 ? ' featured' : '';
        if ($row[5] == 0) {
            $time = $row[3] != '' ? stampToDate($row[3], $hc_cfg[23]) : '';
            $time .= $row[4] != '' ? ' - ' . stampToDate($row[4], $hc_cfg[23]) : '';
            //$stamp = date("Y-m-d\Th:i:00",strtotime($row[2] . trim(' '.$row[3]))) . HCTZ;
            $stamp = stampToDate($row[2], '%A, %B %d');
            //$hc_cfg[14]
        } else {
            $time = $row[5] == 1 ? $hc_lang_event['AllDay'] : $hc_lang_event['TBA'];
            $stamp = $row[2];
            $stamp = stampToDate($row[2], '%A, %B %d');
        }
        echo '
        <li ' . ($cls != '' ? 'class="' . $color_class . ' ' . trim($cls) . '" ' : 'class="' . $color_class . '"') . 'itemscope itemtype="http://schema.org/Event">
            <a href="' . CalRoot . '/index.php?eID=' . $row[0] . $location . '">' . '<div class="event-content-container">' . $category . '<h3 itemprop="name">' . cOut($row[1]) . '</h3><div class="date-time">
            <span itemprop="startDate" datetime="' . $stamp . '">' . $stamp . ', ' . $time . '</span>
            <span class="location"><i class="fa fa-map-marker"></i> ' . $row[14] . ($row[22] != '' ? ' - ' . $row[22] : '') . '</span></div><p>' . strip_tags(cOut($description)) . '<span class="readmore">&nbsp;READ MORE</span></p></div>' . ($show_images == 1 && $row[6] != '' ? '<div class="event-image-container" style="background-image: url(' . $row[6] . '); min-width:' . (strlen($row[1]) > 43 ? 325 : 287) . 'px;"></div>' : '') . '</a></li>';
        //'<span class="readmore">&nbsp;READ MORE</span></p></div>'.(($show_images == 1 && $row[6] != '') ? '<div class="event-image-container"><img itemprop="image" src="'.$row[6].'" class="eimage_b" /></div>':'').'</a></li>'
        ++$cnt;
        ++$row_number;
    }
    echo '
        </ul>
    ' . $myNav;
}