function showMedia()
{
#----------------------------------------------------------------------
global $chosenYears, $chosenRegionId, $chosenOrder;
#--- Prepare conditions.
$yearCondition = yearCondition();
$regionCondition = regionCondition('competition');
$orderCondition = $chosenOrder == 'date' ? "ORDER BY competition.year DESC,\n competition.month DESC,\n competition.day DESC" : "ORDER BY timestampDecided DESC";
#--- Get data of the (matching) media items.
$media = dbQuery("\n SELECT media.*, competition.*, cellName, country.name AS countryName\n\n FROM CompetitionsMedia media, Competitions competition, Countries country\n WHERE 1\n AND competition.id = competitionId\n AND country.id = countryId\n {$yearCondition}\n {$regionCondition}\n AND status = 'accepted'\n {$orderCondition}, cellName\n ");
#--- Print the data.
tableBegin('results', 6);
# tableCaption( false, spaced(array( eventName($chosenEventId), chosenRegionName(), $chosenYears )));
tableHeader(explode('|', 'Insertion Date|Competition Date|Competition|Country, City|Type|Link'), array(5 => 'class="f"'));
foreach ($media as $data) {
extract($data);
#--- Print the empty row.
if ($chosenOrder == 'submission') {
$year = preg_replace('/-.*/', '', $timestampDecided);
}
if (isset($previousYear) && $year != $previousYear) {
tableRowEmpty();
}
$previousYear = $year;
tableRow(array(preg_replace('/ .*/', '', $timestampDecided), competitionDate($data), competitionLink($competitionId, $cellName), "<b>{$countryName}</b>, {$cityName}", $type, externalLink($uri, $text)));
}
tableEnd();
}
function processLink($text, $link)
{
$text = preg_replace('/\\\\([\'\\"])/', '$1', $text);
$link = preg_replace('/\\\\([\'\\"])/', '$1', $link);
if (preg_match('/^mailto:(.*)$/', $link, $match)) {
return emailLink($match[1], $text);
}
if (preg_match('/^https?:(.*)$/', $link, $match)) {
return externalLink($link, $text);
}
return emptyLink('[{' . $text . '}{' . $link . '}]');
}
function infoMedium()
{
#----------------------------------------------------------------------
global $mediumId;
$infos = dbQuery("\n SELECT media.*, competition.cellName\n FROM CompetitionsMedia media, Competitions competition\n WHERE media.id = '{$mediumId}'\n AND competition.id = media.competitionId\n ");
extract($infos[0]);
echo "<table border='0' cellspacing='0' cellpadding='2' width='100%'>\n";
$tableList = array(array('Type', $type), array('Competition', competitionLink($competitionId, $cellName)), array('Link', externalLink(htmlEscape($uri), htmlEscape($text))), array('Submitter', emailLink(htmlEscape($submitterEmail), htmlEscape($submitterName))), array('Comment', htmlEscape($submitterComment)), array('Submitted on:', $timestampSubmitted), array('Decided on', $timestampDecided), array('Status', $status));
foreach ($tableList as $table) {
list($name, $value) = $table;
echo "<tr><td>{$name}</td><td>{$value}</td></tr>";
}
echo "</table>";
displayChoices(array(array(choiceButton(false, "refuse{$mediumId}", 'Erase'), choiceButton(false, "accept{$mediumId}", 'Accept'))));
}
function showCompetitionInfos()
{
#----------------------------------------------------------------------
global $chosenCompetitionId;
#--- Get the competition infos from the database.
$competition = getFullCompetitionInfos($chosenCompetitionId);
extract($competition);
$delegates = getCompetitionDelegates($chosenCompetitionId);
$wcaDelegate = joinUsers($delegates, true);
$organizers = getCompetitionOrganizers($chosenCompetitionId);
// Only show organizer emails if there is no contact info given.
$organizer = joinUsers($organizers, !$contact);
$website = externalLink($website, "{$name} website");
#--- Show the infos.
echo "<h1>{$name}</h1>\n";
#--- Start the table.
echo "<div class='table-responsive'>\n";
echo "<table width='100%' id='competitionDetails'><tr valign='top'>\n";
#--- Left part.
echo "<td style='width:70%'><table>";
$country = getCountry($countryId);
showItem('key', "Date", array(competitionDate($competition), $year));
showItem('key', "City", array($cityName, $country['name']));
showItem('key', "Venue", array($venue));
showItem('sub', "Address", array($venueAddress));
showItem('sub', "Details", array($venueDetails));
showItem('key', "Website", array($website), false);
showItem('key', "Organizer", array($organizer));
showItem('key', "WCA Delegate", array($wcaDelegate));
showItem('key', "Contact", array($contact));
echo "</table></td>";
#--- Right part.
echo "<td style='width:30%'><table>";
showItem('key', "Information", array($information));
showListItemNew('View results for', computeCompetitionEvents($eventSpecs));
showListItemNew('Reports', computeMedia('report'));
showListItemNew('Articles', computeMedia('article'));
showListItemNew('Multimedia', computeMedia('multimedia'));
echo "</table></td>";
#--- End table.
echo "</tr></table></div>";
}
function showMedia()
{
#----------------------------------------------------------------------
global $chosenType, $chosenStatus, $chosenRegionId, $chosenOrder;
#--- Prepare conditions.
$typeCondition = $chosenType ? "AND type='{$chosenType}'" : '';
$accepted = $chosenStatus == 'accepted';
$order = $accepted ? "ORDER BY timestampDecided DESC" : "ORDER BY timestampSubmitted DESC";
$orderCondition = $chosenOrder == 'date' ? "ORDER BY competition.year DESC,\n competition.month DESC,\n competition.day DESC" : $order;
$headerDate = $accepted ? "Insertion" : "Submission";
#--- Get data of the (matching) media items.
$media = dbQuery("\n SELECT media.*,\n competition.year, competition.month, competition.day,\n competition.endMonth, competition.endDay,\n competition.countryId, competition.cityName,\n cellName,\n country.name AS countryName\n FROM CompetitionsMedia media, Competitions competition, Countries country\n WHERE 1\n AND competition.id = competitionId\n AND country.id = countryId\n {$typeCondition}\n " . regionCondition('competition') . "\n AND status='{$chosenStatus}'\n {$orderCondition}, cellName\n ");
#--- Begin form and table.
echo "<form action='validate_media_ACTION.php' method='POST'>\n";
tableBegin('results', 7);
tableHeader(explode('|', $headerDate . ' Date|Competition Date|Competition|Country, City|Type|Link|'), array(5 => 'class="f"'));
#--- Print results.
foreach ($media as $data) {
extract($data);
$timestamp = $accepted ? $timestampDecided : $timestampSubmitted;
if ($chosenOrder == 'submission') {
$year = preg_replace('/-.*/', '', $timestamp);
}
if (isset($previousYear) && $year != $previousYear) {
tableRowEmpty();
}
$previousYear = $year;
$button = "<input type='submit' class='butt' value='Info' name='info{$id}' /> ";
$button .= "<input type='submit' class='butt' value='Edit' name='edit{$id}' /> ";
$button .= $accepted ? "<input type='submit' class='butt' value='Erase' name='refuse{$id}' />" : "<input type='submit' class='butt' value='Accept' name='accept{$id}' />\n <input type='submit' class='butt' value='Refuse' name='refuse{$id}' />";
tableRow(array(preg_replace('/ .*/', '', $timestamp), competitionDate($data), competitionLink($competitionId, $cellName), "<b>{$countryName}</b>, {$cityName}", $type, externalLink(htmlEscape($uri), htmlEscape($text)), $button));
}
#--- End form and table.
tableEnd();
echo "</form>";
}
<dt><a href="media.php">Multimedia</a></dt>
<dd>Articles, Videos, Pictures and Reports about competitions.</dd>
<dt><a href="statistics.php">Statistics</a></dt>
<dd>Some additional statistics for fun.</dd>
</dl>
</div>
<p>
The WCA result pages are designed and built by
<?php
print externalLink('http://www.stefan-pochmann.info/', 'Stefan Pochmann');
?>
,
<?php
print externalLink('https://www.worldcubeassociation.org/results/p.php?i=2004GALL02', 'Clément Gallet');
?>
, and
<?php
print externalLink('http://www.rubikscube.info/', 'Josef Jelinek');
?>
.<br />
We would like to thank them for their great work for the cubing community.<br />
<br />
If you have questions about the rankings or if you want to correct something, then please <a href="/contact">contact the appropriate party</a>.
</p>
<?php
require_once 'includes/_footer.php';
