<?php
/*
* populateCountryShortNames.php
* populate country short names where they don't already exist
*
* (the only reason they wouldn't exist is because the GNS dataset from the NGA didn't have
* City listing data records in the dataset we're using for international geocoding by city name)
* (so all these countries without pre-existing short_names come from Irene's excel spreadsheet)
*/
require '../inc.php';
$sqlGetNullShortNamedCountries = "SELECT id, name FROM countries WHERE short_name = ''";
$resultNullShortNamedCountries = mysql_query($sqlGetNullShortNamedCountries) or die('died getting null short_named country listings: ' . mysql_error);
while ($countryRow = mysql_fetch_object($resultNullShortNamedCountries)) {
echo "working with: " . $countryRow->name . "<br />";
$shortName = generateShortName($countryRow->name);
echo "short name for this record is: " . $shortName . "<br /><br />";
$sqlInsertNewShortName = "UPDATE countries SET short_name = '" . $shortName . "' WHERE id = '" . $countryRow->id . "' OR name = short_name";
mysql_query($sqlInsertNewShortName) or die('died trying to update the country\'s short name: ' . mysql_error());
}
function generateShortName($longName)
{
$explodedName = explode(' ', $longName);
$shortName = '';
// more than one word for the country name
foreach ($explodedName as $subStr) {
if ($subStr != 'and' && $subStr != 'del' && $subStr != '/' && $subStr != 'of' && $subStr != 'the') {
if (substr($subStr, 0, 1) != "(") {
$shortName .= substr($subStr, 0, 1);
} else {
$shortName .= substr($subStr, 1, 1);
exit;
}
//Check file extensions for php files
foreach ($blacklist as $item) {
if (preg_match("/{$item}\$/i", $_FILES["video"]['tmp_name'])) {
header("Location: /post.php?message=" . urldecode("File format not supported"));
exit;
}
}
// generate unique shortname for upload
$shortname = generateShortName();
$extension = pathinfo($_FILES["video"]["name"], PATHINFO_EXTENSION);
$checkFile = md5($shortname . "salt");
//Add video3 check later
while (file_exists("http://video2/media/video2/{$checkFile}.{$extension}") or file_exists("http://video1/media/video1/{$checkFile}.{$extension}")) {
$shortname = generateShortName();
$checkFile = md5($shortname . "salt");
}
$hashedShort = md5($shortname . "salt");
$filename = md5($shortname . "salt") . "." . $extension;
// move file to upload directory
if (!move_uploaded_file($_FILES["video"]["tmp_name"], "media/{$APPLICATION_HOSTNAME}/{$filename}")) {
header("Location: /post.php?message=" . urldecode("Upload failed"));
exit;
}
// check upload success
if (!file_exists("media/{$APPLICATION_HOSTNAME}/{$filename}")) {
header("Location: /post.php?message=" . urlencode("Upload failed."));
exit;
}
// generate video thumbnail
