<?php if (isset($_REQUEST['update'])) { updateOverpass(); exit; } $vars['title'] = 'JOSM összeköttetés'; $vars['template'] = 'layout_simpliest'; if (isset($_REQUEST['nosuccess'])) { $nosuccess = "&nosuccess"; } $churches = searchChurches(array()); if (isset($_REQUEST['page']) and is_numeric($_REQUEST['page'])) { $offset = $_REQUEST['page']; } else { $offset = 0; } if (isset($_REQUEST['limit']) and is_numeric($_REQUEST['limit'])) { $limit = $_REQUEST['limit']; } else { $limit = 30; } $query1 = "SELECT t.id FROM templomok t \n\t LEFT JOIN osm ON osm.tid = t.id \n\t WHERE osm.type IS NULL and ok = 'i' \n\t\t\t\tORDER BY t.id LIMIT " . $limit . " OFFSET " . $limit * $offset . " ;"; $query = "SELECT t.id FROM templomok t \n\t WHERE ok = 'i' \n\t\t\t\tORDER BY t.id ASC LIMIT " . $limit . " OFFSET " . $limit * $offset . " ;"; if ($nosuccess) { $query = $query1; } $result = mysql_query($query); $tmp = array(); while ($row = mysql_fetch_assoc($result)) { $tmp[] = $row['id'];
<?php include 'load.php'; set_time_limit('300'); ini_set('memory_limit', '512M'); switch ($_REQUEST['q']) { case 'hourly': clearoutTokens(); clearoutMessages(); updateOverpass(50); updateDistances(); break; case 'daily': clearoutVolunteers(); deleteOverpass(); updateOSM(); for ($v = 1; $v < 5; $v++) { $file = 'fajlok/sqlite/miserend_v' . $v . '.sqlite3'; generateSqlite($v, $file); //upload2ftp('*url*','*user*','*password*','web/'.$file,$file); } break; case 'weekly': assignUpdates(); updateImageSizes(); generateMassTmp(); updateCleanMassLanguages(); updateGorogkatolizalas(); updateDeleteZeroMass(); updateComments2Attributes(); //not so fast!