KeyHelp Community

Code: Select all

<?php
$dbhost="localhost";
$dbbase="retterradio_db4";
$dbuser="retterradio_db4";
$dbpwd="xxxxxxxxxxxx";

// $streamURL = "retter-radio.de";
$streamURL = "xxxxxxxxxxx";
$streamPort = 8000;

$errno ="";
$errstr = "";
$page="";

function getDJ($streamTitle, $db) {
	$result = new Userdata;
	//$sql = "SELECT ID,name FROM mods WHERE `ismod`='1'";
	//$rs = $db->query($sql);
	$rs = @mysqli_query($db, "SELECT ID,name FROM mods WHERE `ismod`='1'");
	if ($rs) {
		$mods = array();
		while ($md = $rs->fetch_assoc()) {
			$usr = new Userdata;
			$usr->ID = $md["ID"];
			$usr->Name = $md["name"];
			array_push($mods,$usr);
		}
		if (count($mods) > 0) {
			foreach ($mods as $mod) {
				if (strpos($streamTitle,$mod->Name) > - 1) {
					return $mod;
				}
			}
		}
	}
	return $result;
}

//$db= new mysqli($dbhost,$dbuser,$dbpwd,$dbbase);
$db = @mysqli_connect($dbhost, $dbuser, $dbpwd);
if ($db) {
	mysqli_select_db($db,$dbbase);
} else {
	die("Live Stats can't connect to mysql - please check your configuration");
} 

$fp = fsockopen($streamURL, $streamPort, $errno, $errstr, 30);
if ($fp > 0){
	fputs($fp,"GET /index.html?sid=1 HTTP/1.0\r\nUser-Agent: XML Getter (Mozilla Compatible)\r\n\r\n");
	while(!feof($fp)) {
		$page .= fgets($fp, 1000);
	}
	$page=substr($page,strpos($page,"Stream Status:")+2,4000);
	$page=substr($page,strpos($page,"<b>")+2,4000);
	$stat=substr($page,1,strpos($page,"</b>")-1);
	$streamdata["status"]=substr_count($stat,"Stream is up");
	$lstnstart = strpos($page,"listeners (") + 11;
	$lstnend = strpos($page," unique");
	$streamdata["listeners"]=substr($page,$lstnstart,$lstnend - $lstnstart); 
	$streamdata["status"]="on";
	$page=substr($page,strpos($page,"Stream Title:")+2,4000);
	$page=substr($page,strpos($page,"<b>")+2,4000);
	$streamdata["title"]=substr($page,1,strpos($page,"</b>")-1);
	$page=substr($page,strpos($page,"Current Song:")+2,4000);
	$page=substr($page,strpos($page,"<b>")+2,4000);
	$streamdata["song"]=substr($page,1,strpos($page,"</b>")-1);
	$streamdata["mod"]= getDJ($streamdata["title"],$db);
	//$fp = fopen("hoerer.csv","a");
	//fwrite($fp,date("d.m.Y").";".date("H:i").";".$streamdata["title"].";".$streamdata["listeners"]."\r\n");
	//fwrite($fp,date("Y-m-d H:i:s").";".$streamdata["title"].";".$streamdata["listeners"]."\r\n");
	//fclose($fp);
	// SQL-Statement das die Daten in der DB speichert

	//$sql = "INSERT INTO hoerer (title,hoerer,`mod`,`modID`) VALUES ('".$streamdata["title"]."','".$streamdata["listeners"]."','".$streamdata["mod"]->Name."',".$streamdata["mod"]->ID.")";
	//$db->query($sql);
	$result = @mysqli_query($db, "INSERT INTO hoerer (title,hoerer,`mod`,`modID`) VALUES ('".$streamdata["title"]."','".$streamdata["listeners"]."','".$streamdata["mod"]->Name."',".$streamdata["mod"]->ID.")");
	@mysqli_close($db);
} else {
	$streamdata["status"]="off";
}

class Userdata {
	public $ID = 0;
	public $Name ="";
}
?>

Code: Select all

$lstnstart = strpos($page,"listeners (") + 11;

Code: Select all

$lstnstart = strpos($page,"listeners") + 11;

Code: Select all

show create table hoerer;

Code: Select all

show create table mods;