<?php
	//Kontrola existence databáze
    if ($db = new SQLiteDatabase('benny.db')) {
        $q = @$db->query('SELECT id FROM credit');
        if ($q === false) {
            $db->queryExec('CREATE TABLE credit (id int AUTO_INCREMENT,time DATETIME,surf FLOAT(8,4),banner FLOAT(8,4),PRIMARY KEY (id));');
        }
	}


$cokie="UserAutoLogin=Vorisajad3c0a4519fa129f6e7dad5d62839501; PHPSESSID=8c9ij9lmrdeve4talqkju2oe32";
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, 'http://www.benny-surf.de/login.php?page=account');
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_HEADER, 1);
curl_setopt($ch, CURLOPT_COOKIE, $cokie);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
curl_setopt($ch, CURLOPT_USERAGENT, "Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)");
$output = curl_exec($ch);

$pos = strpos($output,"Eigener Verdienst",0);
$pos2 = strpos($output,"rechts\">",$pos);
$pos3 = strpos($output,"</span>",$pos2);
$surf = substr($output,$pos2+8,$pos3-$pos2-8);
$cr = floatval(str_replace(",",".",str_replace(".","",$surf)));

$pos = strpos($output,"Sonstige Einnahmen",$pos);
$pos2 = strpos($output,"rechts\">",$pos);
$pos3 = strpos($output,"</span>",$pos2);
$banner = substr($output,$pos2+8,$pos3-$pos2-8);
$cr2 = floatval(str_replace(",",".",str_replace(".","",$banner)));

echo "Nasurfovano: ".$cr."<br>";
echo "benner: ".$cr2."<br>";
echo "celkem: ".($cr+$cr2-1000);

if(isset($_GET["write"])) {
	$db->queryExec('INSERT INTO credit VALUES (null,DATETIME(\'now\'),'.$cr.','.$cr2.');');
}

?>