//init if ($privs == 9) { //admin if (isset($_POST['uploadFile'])) { $msg = processUpload(); } if (isset($_POST['uploadFile']) and !$msg or isset($_POST['addEvents'])) { $errors = processEvtFields($_POST['sDate'], $_POST['eDate'], $_POST['sTime'], $_POST['eTime'], $_POST['title'], $_POST['catID']); } if (isset($_POST['addEvents']) and !$errors) { $msg = addEvents(); //add events to calendar } echo "<p class='error'>{$msg}</p>\n"; echo "<div class='scrollBoxAd'>\n"; if (!isset($_POST['uploadFile']) and !isset($_POST['addEvents']) or isset($_POST['uploadFile']) and $msg) { instructions(); } echo "<div class='centerBox'>\n"; if (!isset($_POST['uploadFile']) and !isset($_POST['addEvents']) or isset($_POST['uploadFile']) and $msg) { uploadFile(); } elseif (!isset($_POST['addEvents']) or $errors) { displayEvents($errors); //file uploaded or errors, display events } else { echo "<button type='button' onclick=\"window.location.href='index.php?lc&cP=96'\">{$ax['back']}</button>\n"; } echo "</div>\n</div>\n"; } else { echo "<p class='error'>{$ax['no_way']}</p>\n"; }
function searchMailEvents() { global $oAdminButton; xoops_cp_header(); echo $oAdminButton->renderButtons('mailEvents'); if (!isset($_POST['searchEvents'])) { $stylePath = (include_once XHELP_INCLUDE_PATH . '/calendar/calendarjs.php'); echo '<link rel="stylesheet" type="text/css" media="all" href="' . $stylePath . '" /><!--[if gte IE 5.5000]><script src="iepngfix.js" language="JavaScript" type="text/javascript"></script><![endif]-->'; echo "<form method='post' action='" . XHELP_ADMIN_URL . "/index.php?op=searchMailEvents'>"; echo "<table width='100%' cellspacing='1' class='outer'>"; echo "<tr><th colspan='2'>" . _AM_XHELP_SEARCH_EVENTS . "</th></tr>"; echo "<tr><td width='20%' class='head'>" . _AM_XHELP_TEXT_MAILBOX . "</td>\r\n <td class='even'><input type='text' size='55' name='email' class='formButton'></td></tr>"; echo "<tr><td class='head'>" . _AM_XHELP_TEXT_DESCRIPTION . "</td>\r\n <td class='even'><input type='text' size='55' name='description' class='formButton'></td></tr>"; echo "<tr><td class='head'>" . _AM_XHELP_SEARCH_BEGINEGINDATE . "</td>\r\n <td class='even'><input type='text' name='begin_date' id='begin_date' size='10' maxlength='10' value='" . formatTimestamp(time(), 'mysql') . "' />\r\n <a href='' onclick='return showCalendar(\"begin_date\");'><img src='" . XHELP_IMAGE_URL . "/calendar.png' alt='Calendar image' name='calendar' style='vertical-align:bottom;border:0;background:transparent' /></a> "; xhelpDrawHourSelect("begin_hour", 12); xhelpDrawMinuteSelect("begin_minute"); xhelpDrawModeSelect("begin_mode"); echo "<tr><td class='head'>" . _AM_XHELP_SEARCH_ENDDATE . "</td>\r\n <td class='even'><input type='text' name='end_date' id='end_date' size='10' maxlength='10' value='" . formatTimestamp(time(), 'mysql') . "' />\r\n <a href='' onclick='return showCalendar(\"end_date\");'><img src='" . XHELP_IMAGE_URL . "/calendar.png' alt='Calendar image' name='calendar' style='vertical-align:bottom;border:0;background:transparent' /></a> "; xhelpDrawHourSelect("end_hour", 12); xhelpDrawMinuteSelect("end_minute"); xhelpDrawModeSelect("end_mode"); echo "<tr><td class='foot' colspan='2'><input type='submit' name='searchEvents' value='" . _AM_XHELP_BUTTON_SEARCH . "' /></td></tr>"; echo "</table>"; echo "</form>"; xhelpAdminFooter(); xoops_cp_footer(); } else { $hMailEvent =& xhelpGetHandler('mailEvent'); $hDeptMbox =& xhelpGetHandler('departmentMailBox'); $mailboxes =& $hDeptMbox->getObjects(null, true); $begin_date = explode('-', $_POST['begin_date']); $end_date = explode('-', $_POST['end_date']); $begin_hour = xhelpChangeHour($_POST['begin_mode'], $_POST['begin_hour']); $end_hour = xhelpChangeHour($_POST['end_mode'], $_POST['end_hour']); // Get timestamps to search by $begin_time = mktime($begin_hour, $_POST['begin_minute'], 0, $begin_date[1], $begin_date[2], $begin_date[0]); $end_time = mktime($end_hour, $_POST['end_minute'], 0, $end_date[1], $end_date[2], $end_date[0]); $crit = new CriteriaCompo(new Criteria('posted', $begin_time, '>=')); $crit->add(new Criteria('posted', $end_time, '<=')); if ($_POST['email'] != '') { $email = $_POST['email']; $crit->add(new Criteria('emailaddress', "%{$email}%", "LIKE", "d")); } if ($_POST['description'] != '') { $description = $_POST['description']; $crit->add(new Criteria('event_desc', "%{$description}%", "LIKE")); } $crit->setOrder('DESC'); $crit->setSort('posted'); if (isset($email)) { $mailEvents =& $hMailEvent->getObjectsJoin($crit); } else { $mailEvents =& $hMailEvent->getObjects($crit); } displayEvents($mailEvents, $mailboxes); xhelpAdminFooter(); xoops_cp_footer(); } }
function generateCalendar($range, $events, $class) { for ($k = -$range / 2; $k < 1 + $range / 2; $k++) { $date = strtotime($k . ' months'); $strdate = explode("-", date('m-Y', $date)); $days = daysInMonth($date); $decalage = date('w', strtotime($strdate[1] . "-" . $strdate[0] . "-01")) == "0" ? 6 : date('w', strtotime($strdate[1] . "-" . $strdate[0] . "-01")) - 1; $taille = ceil(($decalage + $days) / 7) * 7; $day = 1; ?> <div class="cal <?php echo $class; ?> " id="<?php echo ltrim($strdate[0], 0); ?> "> <h2><?php echo ucfirst(strftime('%B', $date)); ?> <?php echo $strdate[1]; ?> </h2> <button class="nav" id="next" onclick="changeCal(1)">〉</button> <button class="nav" id="previous" onclick="changeCal(-1)">〈</button> <table> <thead> <tr> <td><?php lang('Lundi'); ?> </td> <td><?php lang('Mardi'); ?> </td> <td><?php lang('Mercredi'); ?> </td> <td><?php lang('Jeudi'); ?> </td> <td><?php lang('Vendredi'); ?> </td> <td><?php lang('Samedi'); ?> </td> <td><?php lang('Dimanche'); ?> </td> </tr> </thead> <tr> <?php for ($i = 0; $i < $taille; $i++) { ?> <?php if (date('Ymd') == date('Ym', $date) . sprintf('%02d', $day)) { $today = "today"; } else { $today = ""; } ?> <?php if ($i % 7 == 0 && $i != $taille) { ?> </tr> <tr> <?php } ?> <?php if ($i < $decalage || $i > $days + $decalage - 1) { ?> <td class="disabled"> </td> <?php } else { ?> <td> <h2 class="<?php echo $today; ?> "><?php echo $i < $days + $decalage + 1 ? $day : null; ?> </h2> <div class="event-list"> <?php displayEvents($day, $strdate, $events); ?> </div> <?php displayModals($day, $strdate, $events); ?> </td> <?php $day++; ?> <?php } ?> <?php } ?> </tr> </table> </div> <?php // echo $taille."<br>"; // echo $decalage."<br>"; // echo "mois: ".$strdate[0]."<br>"; // echo "année: ".$strdate[1]."<br><br>"; } }
function displayHillclimbInfo() { // Display Info echo "<table class=\"default\" width=\"100%\">\n"; echo "<tr><th>Hillclimb Info:</th></tr>\n"; echo "<tr><td>\n"; echo file_get_contents("html/hillclimbinfo.html"); echo "</td></tr>\n"; echo "</table>\n"; } ////////////////////////////////////////////////////////////// ////////////////////////////////////////////////////////////// ////////////BEGIN SCRIPT EXECUTION BELOW////////////////////// ////////////////////////////////////////////////////////////// ////////////////////////////////////////////////////////////// if (!isSSL()) { header("Location: logout.php"); } else { validateSession(); $query = "SELECT * FROM users WHERE sha256_user = '******'ID') . "'"; $check = mysql_query($query) or die(mysql_error()); $info = mysql_fetch_array($check); echoFrameHeader(); // displayHillclimbInfo(); // displayAutoXInfo(); echo "<br /><br />"; displayEvents($info); echoFrameFooter(); die; // attempt to guard against any code insertion at the end of the file }
function searchAdEventsByCategory() { $eventCode = $_POST['eventCode']; $eventName = $_POST['name']; $startDateUnformatted = $_POST['startDate']; $endDateUnformatted = $_POST['endDate']; $description = $_POST['description']; $eventType = $_POST['eventType']; $temp = ""; $startDates = explode("/", $startDateUnformatted); //[10], [28], [2015] $startDatesReversed = array_reverse($startDates); //[2015], [28], [10] $temp = $startDatesReversed[1]; //[2015], [28], [10] t:[28] $startDatesReversed[1] = $startDatesReversed[2]; //[2015], [10], [10] t:[28] $startDatesReversed[2] = $temp; //[2015], [10], [28] $startDate = implode("-", $startDatesReversed); //2015-10-28 $endDates = explode("/", $endDateUnformatted); $endDatesReversed = array_reverse($endDates); $temp = $endDatesReversed[1]; $endDatesReversed[1] = $endDatesReversed[2]; $endDatesReversed[2] = $temp; $endDate = implode("-", $endDatesReversed); $cond1 = ""; $cond2 = ""; $cond3 = ""; $cond4 = ""; $cond5 = ""; $cond6 = ""; $whereCondition = ""; if (isset($eventCode) && $eventCode != "") { $cond1 = "EventCode LIKE '%" . $eventCode . "%'"; } if (isset($description) && $description != "") { $cond2 = "Description LIKE '%" . $description . "%'"; } if (isset($eventName) && $eventName != "") { $cond3 = "Name LIKE '%" . $eventName . "%'"; } if (isset($startDate) && $startDate != "--") { $cond4 = "StartDate = '" . $startDate . "'"; } if (isset($endDate) && $endDate != "--") { $cond5 = "EndDate = '" . $endDate . "'"; } if (isset($eventType) && $eventType != "---") { $cond6 = "AdType = '" . $eventType . "'"; } if ($cond1 != "") { $whereCondition = $whereCondition . $cond1; } if ($cond2 != "") { if (strlen($whereCondition) > 1) { $whereCondition = $whereCondition . " AND " . $cond2; } else { $whereCondition = $whereCondition . $cond2; } } if ($cond3 != "") { if (strlen($whereCondition) > 1) { $whereCondition = $whereCondition . " AND " . $cond3; } else { $whereCondition = $whereCondition . $cond3; } } if ($cond4 != "") { if (strlen($whereCondition) > 1) { $whereCondition = $whereCondition . " AND " . $cond4; } else { $whereCondition = $whereCondition . $cond4; } } if ($cond5 != "") { if (strlen($whereCondition) > 1) { $whereCondition = $whereCondition . " AND " . $cond5; } else { $whereCondition = $whereCondition . $cond5; } } if ($cond6 != "") { if (strlen($whereCondition) > 1) { $whereCondition = $whereCondition . " AND " . $cond6; } else { $whereCondition = $whereCondition . $cond6; } } $ad_event_search_sql = "SELECT * FROM AdEvent WHERE {$whereCondition}"; $eventResult = mysql_query($ad_event_search_sql); //Test whether the queries were successful if (!$eventResult) { $event_search_message = "The retrieval of ad events was unsuccessful: "; } $number_event_rows = mysql_num_rows($eventResult); // Check if results turned out empty $event_search_message = ""; if ($number_event_rows == 0) { $event_search_message = "No ad events found in database"; } //Display the results displayEvents($event_search_message, $eventResult); //Free the result sets mysql_free_result($eventResult); }