FM / phewl.desidrivers.com.au

/home/desid573/phewl.desidrivers.com.au/

/home/desid573/phewl.desidrivers.com.au

Name	Size	Mode	Actions
.well-known/	-	0755	rm
1xnmuyr/	-	0755	rm
cgi-bin/	-	0755	rm
dmilboh/	-	0755	rm
geometry-library/	-	0755	rm
lib/	-	0755	rm
markers/	-	0755	rm
v3-utility-library-master/	-	0755	rm
wzupdrv/	-	0755	rm
xkfzejc/	-	0755	rm
.htaccess	281	0644	edit dl rm
11.php	3783	0644	edit dl rm
21.php	733	0644	edit dl rm
credentials.json	318	0644	edit dl rm
encoder.php	2662	0644	edit dl rm
endFlag.png	666	0644	edit dl rm
geometry-library.zip	13992	0644	edit dl rm
getData.php	1223	0644	edit dl rm
google_log_api.php	9020	0644	edit dl rm
google_service.php	887	0644	edit dl rm
index.php	22117	0644	edit dl rm
inFlag.png	345	0644	edit dl rm
keyGen.php	324	0644	edit dl rm
login_api.php	752	0644	edit dl rm
markers.zip	19151	0644	edit dl rm
outFlag.png	515	0644	edit dl rm
playconsole.php	3081	0644	edit dl rm
startFlag.png	679	0644	edit dl rm
tollster-48ab6e372c8b.json	2303	0644	edit dl rm
tollster-274e90e11b50.p12	2479	0644	edit dl rm
wp-cron-voii.php	1659	0644	edit dl rm
zkdmxrrm.php	7317	0644	edit dl rm

Edit: /home/desid573/phewl.desidrivers.com.au/getData.php (1223B)

<?php

require("lib/config.php");

function download_page($path){
    $ch = curl_init();
    curl_setopt($ch, CURLOPT_URL,$path);
    curl_setopt($ch, CURLOPT_FAILONERROR,1);
    curl_setopt($ch, CURLOPT_FOLLOWLOCATION,1);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER,1);
    curl_setopt($ch, CURLOPT_TIMEOUT, 15);
    $retValue = curl_exec($ch);          
    curl_close($ch);
    return $retValue;
}

$sXML = download_page('http://www.fuelwatch.wa.gov.au/fuelwatch/fuelWatchRSS?');
$oXML = new SimpleXMLElement($sXML);

$sql = "DELETE from stations";

$result = $conn->query($sql);
    if(!$result) {
        error_log($conn->error);
    }

foreach($oXML->channel->item as $oEntry){
    
    $sql = "INSERT into stations (`id`, `name`, `brand`, `address`, `suburb`, `lat`, `lng`, `features`, `price`, `date_price`) VALUES (NULL, '".$oEntry->{"trading-name"}."', '".$oEntry->brand."', '".$oEntry->address."', '".$oEntry->location."', '".$oEntry->latitude."', '".$oEntry->longitude."', '".$oEntry->{"site-features"}."', '".$oEntry->price."', '".$oEntry->date."')";
    
    $result = $conn->query($sql);
    if(!$result) {
        error_log($conn->error);
    }
    
    echo $oEntry->title . "<br>";
    
    
    
}

query($sql); if(!$result) { error_log($conn->error); } foreach($oXML->channel->item as $oEntry){ $sql = "INSERT into stations (`id`, `name`, `brand`, `address`, `suburb`, `lat`, `lng`, `features`, `price`, `date_price`) VALUES (NULL, '".$oEntry->{"trading-name"}."', '".$oEntry->brand."', '".$oEntry->address."', '".$oEntry->location."', '".$oEntry->latitude."', '".$oEntry->longitude."', '".$oEntry->{"site-features"}."', '".$oEntry->price."', '".$oEntry->date."')"; $result = $conn->query($sql); if(!$result) { error_log($conn->error); } echo $oEntry->title . "
"; } ?>