function weather_generate() { global $db; // get regions $regions = getRegions(); // get weather $weather = weather_getWeatherWonders(); foreach ($regions as $region) { if (!$region['startRegion']) { weather_log('Skipping unused region %s.', $region['name']); continue; } weather_log('Processing region %s.', $region['name']); // pick a random weather $regionweather = $weather[array_rand($weather)]; weather_log('Selected Weather: %s', $regionweather->name); // save weather information in DB $sql = $db->prepare("UPDATE " . REGIONS_TABLE . "\n SET weather = :weather\n WHERE regionID = :regionID"); $sql->bindValue('weather', $regionweather->weatherID, PDO::PARAM_INT); $sql->bindValue('regionID', $region['regionID'], PDO::PARAM_INT); if (!$sql->execute()) { weather_log('Failed to execute query: %s', $query); return -1; } $sql = $db->prepare("INSERT INTO " . EVENT_WEATHER_TABLE . "\n (regionID, weatherID, impactID, start, end)\n VALUES (:regionID, :weatherID, :impactID, :start, :end)"); foreach ($regionweather->impactList as $impactID => $impact) { $delay = (int) ($impact['delay'] * WEATHER_TIME_BASE_FACTOR); $now = time(); $sql->bindValue('regionID', $region['regionID'], PDO::PARAM_INT); $sql->bindValue('weatherID', $regionweather->weatherID, PDO::PARAM_INT); $sql->bindValue('impactID', $impactID, PDO::PARAM_INT); $sql->bindValue('start', time_toDatetime($now), PDO::PARAM_STR); $sql->bindValue('end', time_toDatetime($now + $delay), PDO::PARAM_STR); if (!$sql->execute()) { weather_log('Failed to execute query'); return -1; } } } }
function weather_getReport() { global $weatherTypeList; init_Weathers(); $regions = getRegions(); $template = tmpl_open($_SESSION['player']->getTemplatePath() . 'weather_report.ihtml'); $tmp = true; foreach ($regions as $region) { $tmp = $tmp && $region[weather] == -1; } if ($tmp) { // no weather so far tmpl_set($template, 'CONTENT/NOWEATHER', array('iterate' => '')); return tmpl_parse($template); } $alt = 0; foreach ($regions as $region) { $alt = ($alt + 1) % 2; // alternates between 0 and 1. Couldn't use regionID, they don't need to be adjacent tmpl_iterate($template, 'CONTENT/WEATHER/ROW'); tmpl_set($template, 'CONTENT/WEATHER/ROW', array('region' => $region['name'], 'weather' => $weatherTypeList[$region['weather']]->name, 'alternate' => $alt)); } return tmpl_parse($template); }
<?php require_once "10.regions.php"; $regions = getRegions(); ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html401/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <title>Wines</title> </head> <body> <form action="10.results.php" method="GET"> Region: <select name="regionName"> <?php foreach ($regions as $id => $name) { ?> <option value="<?php echo $id; ?> "><?php echo $name; ?> </option> <?php } ?> </select>
function readProjectFromCsv($fname) { $result = []; $errors = []; $regions = getRegions(); $data = file($fname); if (!$data) { return [false, ['Ошибка чтения файла проекта.']]; } $result['name'] = isset($data[0]) ? trim(mb_convert_encoding($data[0], 'utf-8', 'windows-1251')) : ''; $result['url'] = isset($data[1]) ? trim(mb_convert_encoding($data[1], 'utf-8', 'windows-1251')) : ''; if ($result['name'] == '') { return [false, ['Не задано название проекта.']]; } if ($result['url'] == '') { return [false, ['Не задан урл проекта.']]; } $l = count($data); $result['regions'] = []; for ($i = 2; $i < $l; $i++) { if (empty($data[$i])) { break; } $line = trim(mb_convert_encoding($data[$i], 'utf-8', 'windows-1251')); if ($line == '') { break; } $result['regions'][] = [$line, $regions[$line]]; } if (count($result['regions']) == 0) { $result['regions'][] = ['Москва', $regions['Москва']]; } $i++; $result['keywords'] = []; for (; $i < $l; $i++) { if (empty($data[$i])) { break; } $line = trim(mb_convert_encoding($data[$i], 'utf-8', 'windows-1251')); if ($line == '') { break; } $result['keywords'][] = $line; } if (count($result['keywords']) == 0) { return [false, ['Не заданы ключевые слова проекта.']]; } return [$result, $errors]; }
function getRegions($countries) { getInCycle('getRegions', $countries, 'country_id', 'regions'); } function getCities($countries) { getInCycle('getCities', $countries, 'country_id', 'cities'); } function getUniversities($cities) { getInCycle('getUniversities', $cities, 'city_id', 'universities'); } function getSchools($cities) { getInCycle('getSchools', $cities, 'city_id', 'schools'); } function getFaculties($universities) { getInCycle('getFaculties', $universities, 'university_id', 'faculties'); } function getChairs($faculties) { getInCycle('getChairs', $faculties, 'faculty_id', 'chairs'); } getCountries(); getRegions('countries'); getCities('countries'); getUniversities('cities'); getFaculties('universities'); getChairs('faculties'); getSchools('cities');
<?
function weather_generate($db) { global $db; // get regions $regions = getRegions(); // get weather $weather = weather_getWeatherWonders($db); foreach ($regions as $region) { if (!$region['startRegion']) { weather_log('Skipping unused region %s.', $region['name']); continue; } weather_log('Processing region %s.', $region['name']); // pick a random weather $regionweather = $weather[array_rand($weather)]; weather_log('Selected Weather: %s', $regionweather->name); // save weather information in DB $query = "UPDATE `Regions` " . "SET `weather` = {$regionweather->weatherID} " . "WHERE `regionID` = {$region['regionID']}"; if (!$db->query($query)) { weather_log('Failed to execute query: %s', $query); return -1; } foreach ($regionweather->impactList as $impactID => $impact) { $delay = (int) (($delayDelta + $impact['delay']) * WEATHER_TIME_BASE_FACTOR); $now = time(); $query = sprintf("INSERT INTO Event_weather " . "(`regionID`, `weatherID`, `impactID`, `start`, `end`) " . "VALUES (%d, %d, %d, '%s', '%s')", $region['regionID'], $regionweather->weatherID, $impactID, time_toDatetime($now), time_toDatetime($now + $delay)); if (!$db->query($query)) { weather_log('Failed to execute query: %s', $query); return -1; } } } }
function getReceivers($db) { $receivers = array(); if (isset($_POST["users_ids"]) && $_POST["users_ids"] != "") { print "Spacific ids = " . $_POST["users_ids"] . "<br>"; $arr = explode(";", $_POST["users_ids"]); $ids = ""; for ($i = 0; $i < count($arr); $i++) { if ($arr[$i] != "") { if ($i == 0) { $ids = "id=" . $arr[$i]; } else { $ids .= " or id=" . $arr[$i]; } } } $result = $db->getUsersOfCond($ids); while ($row = mysql_fetch_array($result)) { $receivers[] = $row["registration_id"]; print "selected = " . $row["registration_id"] . "<br>"; } if (count($receivers) > 0) { return $receivers; } } $send_method = $_POST["send_method"]; if (!isset($_POST["send_method"])) { $send_method = 1; } switch ($send_method) { case 1: $result = $db->getAllUsers(); while ($row = mysql_fetch_array($result)) { $receivers[] = $row["registration_id"]; } break; case 2: $users = getRegions(); for ($i = 0; $i < count($users); $i++) { $subusers = $db->getUsersByRegionId($users[$i]); while ($row = mysql_fetch_array($subusers)) { $receivers[] = $row["registration_id"]; } } /* if(count($receivers) == 0){ $result = $db->getAllUsers(); while ($row = mysql_fetch_array($result)){ $receivers[] = $row["registration_id"]; } }*/ break; case 3: $users = getLangs(); for ($i = 0; $i < count($users); $i++) { $subusers = $db->getUsersByLangId($users[$i]); while ($row = mysql_fetch_array($subusers)) { $receivers[] = $row["registration_id"]; } } /* if(count($receivers) == 0){ $result = $db->getAllUsers(); while ($row = mysql_fetch_array($result)){ $receivers[] = $row["registration_id"]; } }*/ break; } return $receivers; }
function addNewRegionsToDb() { $regionsData = getRegions(); insertRegions($regionsData); }
<?php $method = $_POST['method']; if ($method == "getRegions") { getRegions(); } else { if ($method == "getMatch") { getMatch($_POST['region'], $_POST['match_id']); } } /** * Function returns all regions analysed * Scan directory * @return Array with regions */ function getRegions() { $dir = 'resources/bilgewater_matchID'; $files = array_diff(scandir($dir), array('..', '.')); $regions = array(); foreach ($files as $file) { array_push($regions, strtolower(explode(".", $file)[0])); } echo json_encode($regions); } /** * Function returns stats for one game * Launch a request to RIOT API * Update BDD */ function getMatch($region, $id)