function getGame($id)
{
$sql = "select * FROM games WHERE id=:id";
try {
$db = getConnection();
$stmt = $db->prepare($sql);
$stmt->bindParam("id", $id);
$stmt->execute();
$game = $stmt->fetchObject();
//Récup infos teams
$game->region = getRegion($game->region)->name;
$game->blue = getTeam($game->blue)->name;
$game->red = getTeam($game->red)->name;
$game->winner = $game->winner == 1 ? $game->blue : $game->red;
//Récup compos
$game->blue_compo = getCompo($game->blue_compo);
$game->red_compo = getCompo($game->red_compo);
//Récup bans
$game->blue_bans = getBans($game->blue_bans);
$game->red_bans = getBans($game->red_bans);
return $game;
} catch (PDOException $e) {
return null;
}
}
function getTeam($id)
{
$sql = "select * FROM teams WHERE id=:id";
try {
$db = getConnection();
$stmt = $db->prepare($sql);
$stmt->bindParam("id", $id);
$stmt->execute();
$team = $stmt->fetchObject();
$team->region = getRegion($team->region)->name;
return $team;
} catch (PDOException $e) {
return null;
}
}
function addDireccion($dir, $origen)
{
$com = getComuna(trim($dir[2]));
if (count($com) == 0) {
$id_comuna = 0;
} else {
$id_comuna = $com[1];
}
$reg_arr = explode(" ", $dir[3]);
$id_region = 0;
foreach ($reg_arr as $reg) {
$reg = trim($reg);
if (strtolower($reg) != "region" and strtolower($reg) != 'chile') {
$region = getRegion($reg);
//print_r($region);
if (count($region) == 0) {
$id_region = 0;
} else {
$id_region = $region[1];
break;
}
}
}
$dbPg = pgSql_db();
$sql = strtolower(utf8_encode(limpia(utf8_decode("insert into gis_direccion(calle,numero_municipal,latitud,longitud,comuna,id_comuna,region,id_region,query_completa,geom,origen) values('" . $dir[0] . "','" . $dir[1] . "','" . $dir[4] . "','" . $dir[5] . "','" . $com[0] . "'," . $id_comuna . ",'" . $region[0] . "'," . $id_region . ",'" . $dir[6] . "',ST_GeomFromText('POINT(" . $dir[5] . " " . $dir[4] . ")',2276)," . $origen . ")"))));
//echo "<br>".$sql."<br>";
$rsCalle = pg_query($dbPg, $sql);
pg_close($dbPg);
}
39 => "Tajikistan",
40 => "Thailand",
41 => "East Timor",
42 => "Turkey",
43 => "Turkmenistan",
44 => "United Arab Emirates",
45 => "Uzbekistan",
46 => "Vietnam",
47 => "Yemen"
);
foreach($asiaArr as $k => $v)
{
$flag=false;
foreach($jsonObj->pathes as $id => $obj2)
{
if($v==$obj2->name)
{
$flag = true;
}
}
if(!$flag)
echo "$v not found\n";
}
echo "\n\n ---------------------------------- \n\n";
foreach($jsonObj->pathes as $id => $obj2)
{
echo "$obj2->name \n";
}
*/
getRegion($region = "sa", $json);
function getVersion($version)
{
return getFirmVersion($version) . "_" . getRegion($version) . "_" . getMenuVersion($version) . "_" . getMsetVersion($version);
}
$num = sizeof($getShipment) + 1;
foreach ($getShipment as $value) {
$num--;
$idshipment = $value['idshipment_period'];
$date_start = $value['date_start'];
$date_end = $value['date_end'];
echo "<option value = {$idshipment}> รอบที่{$num} : {$date_start} ถึง {$date_end} </option>";
}
?>
</select>
<span class="input-group-addon"><i class="fa fa-home" ></i></span>
<select id="idregion" class="form-control" onchange="change_province();" >
<option value="" >ทุกภูมิภาค</option>
<?php
$getRegion = getRegion();
foreach ($getRegion as $value) {
$idregion = $value['idregion'];
$name_region = $value['name_region'];
$code_region = $value['code_region'];
echo "<option value = {$idregion}> {$name_region} </option>";
}
?>
</select>
<span class="input-group-addon"><i class="fa fa-home" ></i></span>
<select id="show_province" class="form-control" onchange="show_docket_table_period()" >
</select>
</div>
</div>
if ($functionname == 'getDriverByID') {
$driverID = $_POST["driverID"];
getDriverByID($driverID, $mysqli);
}
if ($functionname == 'delDriver') {
$driverID = $_POST["driverID"];
delDriver($driverID, $mysqli);
}
/*Region*/
if ($functionname == 'setRegion') {
$regionID = $_POST["regionID"];
$regionName = $_POST["regionName"];
setRegion($regionID, $regionName, $mysqli);
}
if ($functionname == 'getRegion') {
getRegion($mysqli);
}
if ($functionname == 'getRegionByID') {
$regionID = $_POST["regionID"];
getRegionByID($regionID, $mysqli);
}
if ($functionname == 'delRegion') {
$regionID = $_POST["regionID"];
delRegion($regionID, $mysqli);
}
/*State*/
if ($functionname == 'setState') {
$stateID = $_POST["stateID"];
$stateName = $_POST["stateName"];
$stateCode = $_POST["stateCode"];
setState($stateID, $stateName, $stateCode, $mysqli);
function getFilenameFromVersion($v)
{
return getFirmVersion($v) . "_" . getRegion($v) . "_" . getMenuVersion($v) . "_" . getMsetVersion($v);
}
}
}
}
}
}
}
}
function getMsetVersion($v)
{
if ($v[0] == 9 and $v[1] < 6) {
return "8203";
} else {
return "9221";
}
}
$version = array(0 => $_GET['zero'], 1 => $_GET['one'], 2 => $_GET['two'], 3 => $_GET['three'], 4 => $_GET['four'], 5 => $_GET['five']);
$filename = "./unsupported.png";
// check that version is valid-ish
if (is_numeric($version[0]) && is_numeric($version[1]) && is_numeric($version[2]) && is_numeric($version[3])) {
$filename = "./q/" . getFirmVersion($version) . "_" . getRegion($version) . "_" . getMenuVersion($version) . "_" . getMsetVersion($version) . ".png";
}
if (!file_exists($filename)) {
$filename = "./unsupported.png";
}
$fp = fopen($filename, 'rb');
// // send the right headers
header("Content-Type: image/png");
header("Content-Length: " . filesize($filename));
// dump the picture and stop the script
fpassthru($fp);
exit;
