<?php
mysql_connect("000000","000000","0000000000000") or die("dbcon");
mysql_select_db("000000000") or die("db");
$getid = $_GET['stream'];
$sql = mysql_query("SELECT * FROM stream_system where ID = '$getid'");
while ($row = mysql_fetch_assoc($sql))
{
	echo "<center><video src=\"".$row['link']."\"; controls width=90% /></video></center>";
}
?>

<?
session_start();
$shows = 0;

if($_POST['check'] == "Login") {
  @require_once ('../lib/functions.lib.php');
  db_connect();
  $page = mysql_fetch_array(db_query("SELECT admin_name, admin_pass FROM ".$db_prefix."_seitenkonfig LIMIT 1"));
       if($_POST['loginname'] == $page['admin_name'] && $_POST['passwort'] == $page['admin_pass']) {
        $_SESSION['admin'] = 1;
        header("Location: ".$_SERVER['PHP_SELF']."?".$_SERVER['QUERY_STRING']);
       } 
}


if($_SESSION['admin'] == 1) {

@include_once('lib/header.php'); 
?>

<?
mysql_connect("000000","0000000","000000") or die("dbcon");
mysql_select_db("00000") or die("db");

if (isset($_POST['new']) and $_POST['new'] != "")
{
$title = $_POST['title'];
$image = $_POST['image'];
$link = $_POST['videolink'];
mysql_query("INSERT INTO
				stream_link
					(
						ID,
						title,
						image
					)
				VALUES
					(
						NULL,
						'$title',
						'$image'
					)
			");
mysql_query("INSERT INTO
				stream_system
					(
						ID,
						link
					)
				VALUES
					(
						NULL,
						'$link'
					)
			");
echo "ERFOLGREICH ANGELEGT! <a href=\"".$_SERVER['PHP_SELF']."\">!weiter!</a>";
}
elseif (isset ($_POST['drop']) and $_POST['drop'] != "")
{
$dropid = $_POST['delete'];
	mysql_query("DELETE FROM stream_system WHERE ID = '$dropid'");
	mysql_query("DELETE FROM stream_link WHERE ID = '$dropid'");
	echo "ERFOLGREICH GEL&Ouml;! <a href=\"".$_SERVER['PHP_SELF']."\">!weiter!</a>";
}
else
{
?>
<h1>neuer Link</h1>
		<form action="<? echo $_SERVER['PHP_SELF']; ?>" method="POST">
			Link: (der Link der in "video src" stehen soll)<br>
			<input type="text" name="videolink"><br>
			Titel (wie der link heissen soll)<br>
			<input type="text" name="title"><br>
			Bild (pfad komplett bsp.: http://beispieldomain.de/ordner/bild.png)<br>
			<input type="text" name="image"><br>
			<input type="submit" name="new" value="new">
		</form><br>
		
		<h1>Stream l&ouml;schen</h1>
		<form action="<? echo $_SERVER['PHP_SELF']; ?>" method="POST">
			title:<br>
				<select name="delete" size="5">
				<optgroup label="Bitte den zu entfernenden stream anklicken.">
					<?
						$sql = mysql_query("SELECT * FROM stream_link");
						While ($row = mysql_fetch_assoc($sql))
						{
							echo "<option value=\"".$row['ID']."\">".$row['title']."</option>";
						}
					?>
					</optgroup>
				</select><br>
				<input type="submit" name="drop" value="drop">
		</form>
			


<?
}
@include_once('lib/footer.php');

} else {
?>
<? header("location: ./index.php"); ?>
<?}?>