function recievedSetPosition($fromDeviceID, $llong, $llat) { $time = time(); $stime = date("Y-m-d H:i:s"); debugMsg($stime); global $conn; debugMsg("RCV SetPosition id=" . $fromDeviceID . " llong=" . $llong . " llat=" . $llat); $sqlStmnt = "update devices set llong = " . $llong . ", llat = " . $llat . " , lastActive = " . " '" . $stime . "' " . " where deviceId = " . $fromDeviceID; debugMsg("about to update position"); echo $sqlStmnt; debugMsg($sqlStmnt); $result = mysql_query($sqlStmnt, $conn); debugMsg($result); updateDistances($fromDeviceID); //Used for updating ongoing pickups. }
<?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!