112 lines
1.8 KiB
PHP
112 lines
1.8 KiB
PHP
{
|
|
"topLevel": {
|
|
<?php
|
|
include("config.php");
|
|
// Returns numbers in string format as needed for file names
|
|
function clipNumber($number, $length)
|
|
{
|
|
$number = abs($number) . "";
|
|
while (strlen($number) < $length)
|
|
{
|
|
$number = "0" . $number;
|
|
}
|
|
return $number;
|
|
}
|
|
$con = new mysqli($SQL_SERVER, $SQL_USER, $SQL_PASSWORD, $SQL_DATABASE, $SQL_PORT);
|
|
if ($con->connect_error)
|
|
{
|
|
quit();
|
|
}
|
|
$sql = "SELECT topLevel.name AS name, status.color AS color FROM topLevel JOIN status ON topLevel.status_id = status.id";
|
|
$ret = $con->query($sql)->fetch_all(MYSQLI_ASSOC);
|
|
if ($ret != False)
|
|
{
|
|
$tiles = [];
|
|
foreach($ret as $row)
|
|
{
|
|
$tiles[$row["name"]] = $row["color"];
|
|
}
|
|
}
|
|
$first = true;
|
|
for ($i = 80; $i >= -90; $i -= 10)
|
|
{
|
|
if ($i >= 0)
|
|
{
|
|
$ns = "n";
|
|
}
|
|
else
|
|
{
|
|
$ns = "s";
|
|
}
|
|
for ($j = -180; $j < 180; $j += 10)
|
|
{
|
|
if ($first)
|
|
{
|
|
$first = false;
|
|
}
|
|
else
|
|
{
|
|
echo ",";
|
|
}
|
|
if ($j < 0)
|
|
{
|
|
$ew = "w";
|
|
}
|
|
else
|
|
{
|
|
$ew = "e";
|
|
}
|
|
$name = $ew . clipNumber($j, 3) . $ns . clipNumber($i, 2);
|
|
echo '"' . $name . '": "' . $tiles[$name] . '"';
|
|
}
|
|
}
|
|
?>
|
|
},
|
|
"secondLevel": {
|
|
<?php
|
|
$sql = "SELECT secondLevel.name AS name, status.color AS color FROM secondLevel JOIN status ON secondLevel.status_id = status.id";
|
|
$ret = $con->query($sql)->fetch_all(MYSQLI_ASSOC);
|
|
if ($ret != False)
|
|
{
|
|
$tiles = [];
|
|
foreach($ret as $row)
|
|
{
|
|
$tiles[$row["name"]] = $row["color"];
|
|
}
|
|
}
|
|
$first = true;
|
|
for ($i = 80; $i >= -90; $i -= 1)
|
|
{
|
|
if ($i >= 0)
|
|
{
|
|
$ns = "n";
|
|
}
|
|
else
|
|
{
|
|
$ns = "s";
|
|
}
|
|
for ($j = -180; $j < 180; $j += 1)
|
|
{
|
|
if ($first)
|
|
{
|
|
$first = false;
|
|
}
|
|
else
|
|
{
|
|
echo ",";
|
|
}
|
|
if ($j < 0)
|
|
{
|
|
$ew = "w";
|
|
}
|
|
else
|
|
{
|
|
$ew = "e";
|
|
}
|
|
$name = $ew . clipNumber($j, 3) . $ns . clipNumber($i, 2);
|
|
echo '"' . $name . '": "' . $tiles[$name] . '"';
|
|
}
|
|
}
|
|
?>
|
|
}
|
|
}
|