/**
* @param \Sitemapper\Url $url
*/
public function addLocation(Location $location)
{
$node = $this->root->appendChild($this->doc->createElement(static::URL_NODE_NAME));
$node->appendChild($this->doc->createElement('loc', $location->getLocation()));
if ($location->getLastModification()) {
$node->appendChild($this->doc->createElement('lastmod', $location->getLastModification()));
}
return $node;
}
</label>
<strong> <span class="selectRequiredMsg selectInvalidMsg text-danger"> Required</span></strong>
</div>
<div class="col-sm-5">
<select class="form-control" id="loc_s" tabindex="<?php
$tabindex++;
print $tabindex;
?>
">
<option value="-1" selected disabled>Choose a Location</option>
<?php
include_once $_SERVER['DOCUMENT_ROOT'] . "/lib/modules/location.php";
$loca = new Location($mySQL);
$loca->getLocations();
foreach ($loca->location as $ID) {
$loca->getLocation($ID);
print ' <option value="' . $loca->ID . '">' . $loca->name . ' (' . $loca->address['city'] . ')</option>' . PHP_EOL;
}
?>
<option value="c">Custom...</option>
</select>
</div>
<div class="col-sm-5">
<input type="text" class="form-control hidden" name="location" id="location" placeholder="Custom Location" value="<?php
print $location;
?>
" tabindex="<?php
$tabindex++;
print $tabindex;
?>
"/>
echo $template->page_title;
?>
</h1>
</div>
<?php
get_message();
?>
<?php
if (is_single()) {
?>
<?php
$location_id = get_var('id');
$location = $location_id ? Location::getLocation($location_id) : false;
$location_name = $location ? $location->getName() : '';
$location_country = $location ? $location->getCountry() : '';
$location_state = $location ? $location->getState() : '';
$location_city = $location ? $location->getCity() : '';
$location_street = $location ? $location->getStreet() : '';
$location_zip = $location ? $location->getZip() : '';
?>
<?php
if (get_var('action') != 'add' && !$location) {
?>
<?php
create_message('danger', 'Location does not exist!', true);
?>
function createData()
{
$eventdata = $this->mySQL['r']->prepare("SELECT `title`,`starts`,`ends`,`notes`,`link`,`location`,`allDay` from `news_events` WHERE `ID`=?");
$eventdata->bind_param('i', $this->ID);
$eventdata->execute();
$eventdata->store_result();
if ($eventdata->num_rows != 0) {
$eventdata->bind_result($title, $starts, $ends, $notes, $link, $location, $allDay);
while ($eventdata->fetch()) {
$this->title = $title;
$this->starts = $starts;
$this->ends = $ends;
$this->notes = $notes;
$this->allDay = $allDay;
$this->link = $link;
if (substr($location, 0, 1) == '%' && substr($location, -1, 1) == '%') {
$loca = new Location($this->mySQL);
$loca->getLocation(substr($location, 1, -1));
$this->location = '<a href="/location?l=' . $loca->ID . '">' . $loca->name . ', ' . $loca->address['city'] . '</a>';
} else {
$this->location = $location;
}
}
$this->data = true;
} else {
$this->data = false;
}
}
function createMeet()
{
// Get data from Main Comp DB
$meet_query = $this->mySQL['r']->prepare("SELECT\n\t\t\t`title`,\n\t\t\t`date_f`,\n\t\t\t`date_s`,\n\t\t\t`sessions`,\n\t\t\t`events`,\n\t\t\t`notes_e`,\n\t\t\t`notes_c`,\n\t\t\t`notes_s`,\n\t\t\t`notes_p`,\n\t\t\t`docs`,\n\t\t\t`licence`,\n\t\t\t`enable`,\n\t\t\t`location`,\n\t\t\t`wizStat`\n\t\tFROM `comp_meet` WHERE `ID`=?");
$meet_query->bind_param('s', $this->id);
$meet_query->execute();
$meet_query->store_result();
$res_query = $this->mySQL['r']->prepare("SELECT\n\t\t\t`enable`,\n\t\t\t`text`,\n\t\t\t`download`,\n\t\t\t`meet`,\n\t\t\t`series`,\n\t\t\t`services`,\n\t\t\t`nextSession`,\n\t\t\t`indSession`\n\t\tFROM `comp_res` WHERE `MID`=?");
$res_query->bind_param('s', $this->id);
$res_query->execute();
$res_query->store_result();
if ($meet_query->num_rows != 0) {
$res_query->bind_result($res['enable'], $res['text'], $res['download'], $res['meet'], $res['series'], $res['services'], $res['nextSession'], $res['indivSession']);
$meet_query->bind_result($title, $date_f, $date_s, $sessions, $events, $notes['e'], $notes['c'], $notes['s'], $notes['p'], $docs, $licence, $enable, $location, $wizStat);
while ($meet_query->fetch()) {
$this->title = $title;
$this->date_s = $date_s;
$this->date_f = $date_f;
$this->enable = $enable;
while ($res_query->fetch()) {
$this->resServ = $res;
}
$this->licence = $licence;
$this->resServ['services'] = unserialize($this->resServ['services']);
if ($date_f != "" && $date_f != $date_s) {
$this->date = date("l jS F Y", strtotime($date_s)) . " - " . date("l jS F Y", strtotime($date_f));
if ($date_s <= date('Y-m-d', strtotime('yesterday')) && $date_f == date('Y-m-d', strtotime('today'))) {
$this->date_wordy = 'Today';
} elseif ($date_s <= date('Y-m-d', strtotime('yesterday')) && $date_f == date('Y-m-d', strtotime('tomorrow'))) {
$this->date_wordy = 'Today until Tomorrow';
} elseif ($date_s == date('Y-m-d', strtotime('yesterday')) && $date_f == date('Y-m-d', strtotime('tomorrow'))) {
$this->date_wordy = 'Today until Tomorrow';
} elseif ($date_s == date('Y-m-d', strtotime('today')) && $date_f == date('Y-m-d', strtotime('tomorrow'))) {
$this->date_wordy = 'Today until Tomorrow';
} elseif ($date_s == date('Y-m-d', strtotime('today')) && $date_f > date('Y-m-d', strtotime('tomorrow'))) {
$this->date_wordy = 'Today until ' . date("l jS F Y", strtotime($date_f));
} elseif ($date_s == date('Y-m-d', strtotime('tomorrow')) && $date_f > date('Y-m-d', strtotime('tomorrow'))) {
$this->date_wordy = 'Tomorrow until ' . date("l jS F Y", strtotime($date_f));
} elseif ($date_s == date('Y-m-d', strtotime('tommorrow'))) {
$this->date_wordy .= 'Tomorrow';
} else {
$this->date_wordy = date("l jS F Y", strtotime($date_s)) . ' to ' . date("l jS F Y", strtotime($date_f));
}
} else {
$this->date = date("l jS F Y", strtotime($date_s));
if ($date_s == date('Y-m-d', strtotime('tomorrow'))) {
$this->date_wordy = 'Tomorrow';
} elseif ($date_s == date('Y-m-d', strtotime('today'))) {
$this->date_wordy = 'Today';
} else {
$this->date_wordy = date("l jS F Y", strtotime($date_s));
}
}
$this->numberEvents = $events;
$this->numberSessions = $sessions;
//$this->wizard = $wizard;
/*if($resServ['text']==''&&$resServ['enable']==1){
$this->resServ['text'] = "<p>Find the results <a href=\"http://".RESULTS_SERVER."/?m=".$resServ['meet']."&series=".$resServ['series']."\">here</a></p>\n";
}*/
$this->notes['e'] = $notes['e'];
$this->notes['c'] = $notes['c'];
$this->notes['p'] = $notes['p'];
$this->notes['s'] = $notes['s'];
if (substr($location, 0, 1) == '%' && substr($location, -1) == '%') {
$loc = new Location($this->mySQL);
$loc->getLocation(substr($location, 1, -1));
$this->location = $loc->getData();
} else {
$this->location['name'] = $location;
}
$this->link = "/competitions/meet?m=" . $this->id;
$this->docs = strgetcsv($docs);
if ($sessions > 0) {
$session_query = $this->mySQL['r']->prepare("\n\t\t\t\t\tSELECT\n\t\t\t\t\t\t`SID`,\n\t\t\t\t\t\t`num`,\n\t\t\t\t\t\t`number`,\n\t\t\t\t\t\t`date`,\n\t\t\t\t\t\t`t_warm`,\n\t\t\t\t\t\t`t_sign`,\n\t\t\t\t\t\t`t_start`,\n\t\t\t\t\t\t`events`\t\t\t\t\t\n\t\t\t\t\tFROM `comp_session`\n\t\t\t\t\tWHERE\n\t\t\t\t\t\t`MID`=?\n\t\t\t\t\tORDER BY\n\t\t\t\t\t\t`num` ASC\n\t\t\t\t\t");
$session_query->bind_param('s', $this->id);
$session_query->execute();
$session_query->store_result();
if ($session_query->num_rows != 0) {
$session_query->bind_result($SID, $num, $number, $date, $t['warm'], $t['sign'], $t['start'], $events);
while ($session_query->fetch()) {
$this->meet['S'][$number]['SID'] = $SID;
$this->meet['S'][$number]['num'] = $num;
$this->meet['S'][$number]['date'] = date("d/m/Y", strtotime($date));
$this->meet['S'][$number]['t']['warm'] = date("H:i", strtotime($t['warm']));
$this->meet['S'][$number]['t']['sign'] = date("H:i", strtotime($t['sign']));
$this->meet['S'][$number]['t']['start'] = date("H:i", strtotime($t['start']));
if ($events > 0) {
$event_query = $this->mySQL['r']->prepare("\n\t\t\t\t\t\t\t\tSELECT\n\t\t\t\t\t\t\t\t\t`num`,\n\t\t\t\t\t\t\t\t\t`number`,\n\t\t\t\t\t\t\t\t\t`prefix`,\n\t\t\t\t\t\t\t\t\t`e_g`,\n\t\t\t\t\t\t\t\t\t`e_d`,\n\t\t\t\t\t\t\t\t\t`e_s`,\n\t\t\t\t\t\t\t\t\t`e_r`,\n\t\t\t\t\t\t\t\t\t`e_al`,\n\t\t\t\t\t\t\t\t\t`e_au`\n\t\t\t\t\t\t\t\tFROM `comp_event`\n\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t`MID`=? AND\n\t\t\t\t\t\t\t\t\t`SID`=?\n\t\t\t\t\t\t\t\tORDER BY\n\t\t\t\t\t\t\t\t\t`number` ASC\n\t\t\t\t\t\t\t\t");
$event_query->bind_param('ss', $this->id, $SID);
$event_query->execute();
$event_query->store_result();
if ($event_query->num_rows != 0) {
$event_query->bind_result($e_num, $e_number, $prefix, $e['g'], $e['d'], $e['s'], $e['r'], $e['a']['l'], $e['a']['u']);
while ($event_query->fetch()) {
if ($prefix == true) {
$this->meet['S'][$number]['E'][$e_number]['num'] = $number . str_pad($e_num, 2, '0', STR_PAD_LEFT);
} else {
$this->meet['S'][$number]['E'][$e_number]['num'] = $e_num;
}
$this->meet['S'][$number]['E'][$e_number]['g'] = $e['g'];
$this->meet['S'][$number]['E'][$e_number]['d'] = $e['d'];
$this->meet['S'][$number]['E'][$e_number]['s'] = $e['s'];
$this->meet['S'][$number]['E'][$e_number]['r'] = $e['r'];
$this->meet['S'][$number]['E'][$e_number]['al'] = $e['a']['l'];
$this->meet['S'][$number]['E'][$e_number]['au'] = $e['a']['u'];
}
}
}
}
}
} else {
$this->dispEvts = false;
}
return true;
}
} else {
return false;
}
}
<tbody>
<?php
$event_query = $mySQL['r']->prepare("SELECT `ID`,`title`,`location`,`starts`,`ends`,`enable` FROM `news_events` ORDER BY `ID`");
$event_query->execute();
$event_query->bind_result($ID, $title, $location, $starts, $ends, $enabled);
$event_query->store_result();
while ($event_query->fetch()) {
print ' <tr>' . PHP_EOL;
print ' <td>' . $ID . '</td>' . PHP_EOL;
print ' <td><span class="hidden">' . $enabled . '</span>';
print Form::toggleLink($enabled, '', 53, array('s' => array('h' => 'Click to unpublish event.', 'i' => 'eye-open', 'u' => '/act/enable?cat=' . $page->getSubCat() . '&mode=event&i=' . $ID . '&m=0"'), 'f' => array('h' => 'Click to publish event.', 'i' => 'eye-close', 'u' => '/act/enable?cat=' . $page->getSubCat() . '&mode=event&i=' . $ID . '&m=1"')));
print '</td>' . PHP_EOL;
print ' <td>' . $title . '</td>' . PHP_EOL;
if (substr($location, 0, 1) == '%' && substr($location, -1, 1) == '%') {
$loca = new Location($mySQL);
$loca->getLocation(substr($location, 1, -1));
print ' <td>' . $loca->name . '</td>' . PHP_EOL;
} else {
print ' <td>' . $location . '</td>' . PHP_EOL;
}
print ' <td>' . date("d/m/Y H:i", strtotime($starts)) . '</td>' . PHP_EOL;
print ' <td>' . date("d/m/Y H:i", strtotime($ends)) . '</td>' . PHP_EOL;
if ($user->accessPage(53)) {
print ' <td><a href="event_edit?e=' . $ID . '">Edit <span class="' . B_ICON . ' ' . B_ICON . '-pencil"></span></a></td>' . PHP_EOL;
}
print ' </tr>' . PHP_EOL;
}
?>
</tbody>
</table>
<script src="/js/jquery.tablesorter.js"></script>
