# Samsung SPF-83v specific tasks
# ===============================
# disable and enable picture cache for this rss feed to make immediately refresh possible
wget -s "http://$samsung_ip_address:5050/configuration/storage.htm?CheckRssNameId=$samsung_rss_id&Checked=false"
wget -s "http://$samsung_ip_address:5050/configuration/storage.htm?CheckRssNameId=$samsung_rss_id&Checked=true"
# force samsung picture frame to immediately refresh picture by simulate clicking on "next" in web interface
wget -s "http://$samsung_ip_address:5050/configuration/photo_frame.htm?next"root@fritz:/var/tmp/infoframe# sh refresh_83v.sh
Connecting to 192.168.0.5 (192.168.0.5:80)
info.jpg 100% |*******************************| 101k 0:00:00 ETA
Connecting to 192.168.0.7:5050 (192.168.0.7:5050)
wget: can't connect to remote host (192.168.0.7): No route to host
Connecting to 192.168.0.7:5050 (192.168.0.7:5050)
wget: can't connect to remote host (192.168.0.7): No route to host
Connecting to 192.168.0.7:5050 (192.168.0.7:5050)
wget: can't connect to remote host (192.168.0.7): No route to host
root@fritz:/var/tmp/infoframe#
//!include_path anpassen!!!!
date_default_timezone_set('Europe/Berlin');
$loc = setlocale(LC_ALL, 'de_DE.UTF8', 'de_DE', 'de', 'ge');
$config = parse_ini_file("../infoframe/config.ini", true);
$sysconfig = $config['System'];
//DB connection und table anlegen, kann spaeter in die /library/dbconn.php ausgegliedert werden
mysql_connect($sysconfig['db_host'], $sysconfig['db_user'], $sysconfig['db_password']) or die ("Verbindung nicht möglich");
mysql_select_db( $sysconfig['db_name']) or die ("Die Datenbank existiert nicht.");
$query = "SELECT * FROM `if_tanken` ORDER BY `datum` DESC, `preis` ASC";
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
// if(preg_match('#ARAL|SHELL|SUPOL#isU', $row['station'], $matches)){ // hier wird allgeimen nach Tankstellen-Marken gesucht
if(preg_match('#ARAL Gütersloher Str. 123|SHELL In der Anderen Straße|SUPOL Ganz wo anders#isU', $row['station'], $matches)){ //Am Besten die Tankstellen 1zu1 aus der Datenbank kopieren
print_r($row);
}
}
