<?php
header('Content-Type: text/html; charset=UTF-8');
header('Cache-Control: no-cache, no-store, must-revalidate');
include('config.php');
echo '<!DOCTYPE html PUBLIC "-//WAPFORUM//DTD XHTML Mobile 1.0//EN" "http://www.wapforum.org/DTD/xhtml-mobile10.dtd">';
echo '<html xmlns="http://www.w3.org/1999/xhtml">';
echo '<head>';
echo '<title>Administrare '.$numesite.'</title>';
echo '<link rel="stylesheet" type="text/css" href="http://tvpemobil.net/style.css"/>';
echo '</head>';
$a=$_GET['a'];

if($a=='sterge2')
{
$id=$_GET['id'];
$categorie=$_GET['categorie'];
$info=$cfr->query("SELECT * FROM ".$categorie." WHERE id='".$id."'")->fetch_array();
$res=$cfr->query("DELETE FROM ".$categorie." WHERE id='".$id."'");
echo '<div class="titlu">&bull; &#350;terge Canal TV &bull;</div>';
echo '<p align="center">';
if($info[nume]=='')
{
echo '<img src="http://tvpemobil.net/imagini/nu.gif" alt=""/> Acest canal nu exist&#259;!<br/>';
}else{
if($res)
{
echo '<img src="http://tvpemobil.net/imagini/da.gif" alt=""/> Canalul <u>'.$info[nume].'</u> a fost &#351;ters cu succes din categoria <u>'.$categorie.'</u>!<br/>';
}else{
echo '<img src="http://tvpemobil.net/imagini/nu.gif" alt=""/> Eroare &#238;n baza de date!<br/>';
}
}
echo '<br/>';
echo '<a href="http://'.$host.'"><img src="http://tvpemobil.net/imagini/acasa.gif" alt=""/>Acas&#259;</a><br/>';
echo '</p>';
echo '<div class="footer">&#169; '.$numesite.' '.date('Y',time()).' &#8482;</div>';
echo '</body>';
echo '</html>';
exit();
}else if($a=='sterge')
{
$id=(int)$_GET['id'];
$categorie=$_GET['categorie'];
$info=$cfr->query("SELECT * FROM ".$categorie." WHERE id='".$id."'")->fetch_array();
echo '<div class="titlu">&bull; &#350;terge Canal TV &bull;</div>';
echo '<p align="center">';
if($info[nume]=='')
{
echo '<img src="http://tvpemobil.net/imagini/nu.gif" alt=""/> Acest canal nu exist&#259;!<br/>';
}else{
echo 'Sunte&#355;i sigur c&#259; dori&#355;i s&#259; &#351;terge&#355;i <u>'.$info[nume].'</u> din categoria <u>'.$categorie.'</u>?<br/><br/>';
echo '&#187;<a href="'.$_SERVER['PHP_SELF'].'?a=sterge2&amp;categorie='.$categorie.'&amp;id='.$id.'">Da</a>&#171; | &#187;<a href="'.$_SERVER['PHP_SELF'].'">Nu</a>&#171;<br/>';
}
echo '<br/>';
echo '<a href="http://'.$host.'"><img src="http://tvpemobil.net/imagini/acasa.gif">Acas&#259;</a><br/>';
echo '</p>';
echo '<div class="footer">&#169; '.$numesite.' '.date('Y',time()).' &#8482;</div>';
echo '</body>';
echo '</html>';
exit();
}else if($a=='adauga2')
{
/*
echo '<div class="titlu">&bull; Adaug&#259; Canal TV &bull;</div>';
echo '<p align="center">';
if(trim($_POST['nume']!=''))
{
$nume=$_POST['nume'];
$sigla=$_POST['sigla'];
$categorie=$_POST['categorie'];
$stream1=$_POST['stream1'];
$stream2=$_POST['stream2'];
$stream3=$_POST['stream3'];
$stream4=$_POST['stream4'];
$stream5=$_POST['stream5'];
$stream6=$_POST['stream6'];
$rtmp1=$_POST['rtmp1'];
$rtmp2=$_POST['rtmp2'];
$rtmp3=$_POST['rtmp3'];
$player1=$_POST['player1'];
$player2=$_POST['player2'];
$res=$cfr->query("INSERT INTO ".$categorie." SET nume='".$nume."', sigla='".$sigla."', stream1='".$stream1."', stream2='".$stream2."', stream3='".$stream3."', stream4='".$stream4."', stream5='".$stream5."', stream6='".$stream6."', rtmp1='".$rtmp1."', rtmp2='".$rtmp2."', rtmp3='".$rtmp3."', player1='".$player1."', player2='".$player2."'");
if($res)
{
echo '<img src="http://tvpemobil.net/imagini/da.gif" alt=""/> Canal ad&#259;ugat cu succes!<br/>';
}else{
echo '<img src="http://tvpemobil.net/imagini/nu.gif" alt=""/> Eroare &#238;n baza de date, canalul nu a fost ad&#259;ugat!<br/>';
}
echo '<br/>';
echo '<img src="'.$sigla.'" width="50" height="50" alt=""/><br/>';
echo 'Nume Post: '.$nume.'<br/>';
echo 'Categorie: '.$categorie.'<br/><br/>';





if($rtmp1!='')
{
echo 'RTMP 1: <a href="'.$rtmp1.'">'.$rtmp1.'</a><br/>';
}
if($rtmp2!='')
{
echo 'RTMP 2: <a href="'.$rtmp2.'">'.$rtmp2.'</a><br/>';
}
if($rtmp3!='')
{
echo 'RTMP 3: <a href="'.$rtmp3.'">'.$rtmp3.'</a><br/>';
}
if($player1!='')
{
echo 'Player 1: <a href="'.$player1.'">'.$player1.'</a><br/>';
}
if($player2!='')
{
echo 'Player 2: <a href="'.$player2.'">'.$player2.'</a><br/>';
}
}else{
echo '<img src="http://tvpemobil.net/imagini/nu.gif" alt=""/> Numele canalului nu poate fi l&#259;sat necompletat!<br/>';
}
echo '<br/>';
echo '<a href="http://'.$host.'"><img src="http://tvpemobil.net/imagini/acasa.gif" alt=""/>Acas&#259;</a><br/>';
echo '</p>';
echo '<div class="footer">&#169; '.$numesite.' '.date('Y',time()).' &#8482;</div>';
echo '</body>';
echo '</html>';
exit();
*/
}else if($a=='adauga')
{
$c=$_GET['c'];
echo '<div class="titlu">&bull; Adaug&#259; Canal TV &bull;</div>';
echo '<p align="center">';
echo '<b>Adaug&#259; &#238;n: <u>'.$c.'</u></b><br/>';
echo '<form align="center" action="'.$_SERVER['PHP_SELF'].'?a=adauga2" method="post">';
echo 'Nume Post:<br/><input type="text" name="nume"/><br/>';
echo 'Sigl&#259; Post:<br/><input type="text" name="sigla" value="http://tvpemobil.net/canale/"/><br/>';
echo '<input type="hidden" name="categorie" value="'.$c.'"/>';
echo 'Stream 1:<br/><input type="text" name="stream1"/><br/>';
echo 'Stream 2:<br/><input type="text" name="stream2"/><br/>';
echo 'Stream 3:<br/><input type="text" name="stream3"/><br/>';
echo 'Stream 4:<br/><input type="text" name="stream4"/><br/>';
echo 'Stream 5:<br/><input type="text" name="stream5"/><br/>';
echo 'Stream 6:<br/><input type="text" name="stream6"/><br/>';
echo 'RTMP 1:<br/><input type="text" name="rtmp1"/><br/>';
echo 'RTMP 2:<br/><input type="text" name="rtmp2"/><br/>';
echo 'RTMP 3:<br/><input type="text" name="rtmp3"/><br/>';
echo 'Player 1:<br/><input type="text" name="player1"/><br/>';
echo 'Player 2:<br/><input type="text" name="player2"/><br/>';
echo '<input type="submit" value="&#187;Adaug&#259;&#171;"/></form>';
echo '</p>';
echo '<p align="center">';
echo '<a href="http://'.$host.'"><img src="http://tvpemobil.net/imagini/acasa.gif" alt=""/>Acas&#259;</a><br/>';
echo '</p>';
echo '<div class="footer">&#169; '.$numesite.' '.date('Y',time()).' &#8482;</div>';
echo '</body>';
echo '</html>';
exit();
}else if($a=='categorii')
{
$c=$_GET['c'];
$ctg=ucwords(str_replace('-',' ',$c));
$ctg=str_replace('Stiri','&#350;tiri',$ctg);
$ctg=str_replace('Muzica','Muzic&#259;',$ctg);
$ctg=str_replace('Deseneanimate','Desene Animate',$ctg);
$ctg=str_replace('Republicamoldova','Republica Moldova',$ctg);
$ctg=str_replace('Canaleinternationale','Canale Interna&#355;ionale',$ctg);
$ctg=str_replace('Adultxxx','Adult XXX (+18)',$ctg);
echo '<div class="titlu">&bull; '.$ctg.' &bull;</div>';
echo '<p align="left">';
$sql=$cfr->query("SELECT * FROM ".$c."");

while($info=$sql->fetch_array())
{
echo '<img src="'.$info[sigla].'" width="50" height="50" alt=""/><br/>';
echo '<b>'.$info[nume].'</b><br/>';
$exista=$info[stream1].$info[stream2].$info[stream3].$info[stream4].$info[stream5].$info[stream6].$info[rtmp1].$info[rtmp2].$info[rtmp3].$info[player1].$info[player2];
if($exista=='')
{
echo '&#187; Lips&#259; stream.<br/>';
}

echo '- - - - -<br/>';
echo '[<a href="'.$_SERVER['PHP_SELF'].'?a=editeaza&amp;categorie='.$c.'&amp;id='.$info[id].'">Editeaz&#259;</a> - [<a href="'.$_SERVER['PHP_SELF'].'?a=sterge&amp;categorie='.$c.'&amp;id='.$info[id].'">&#350;terge</a>]<br/>';
echo '- - - - - - - - - -<br/>';
}
echo '</p>';
echo '<p align="center">';
echo '[<a href="'.$_SERVER['PHP_SELF'].'?a=adauga&c='.$c.'">Adaug&#259; Canal</a>]<br/><br/>';
echo '<a href="'.$host.'"><img src="http://tvpemobil.net/imagini/acasa.gif" alt=""/>Acas&#259;</a><br/>';
echo '</p>';
echo '<div class="footer">&#169; '.$numesite.' '.date('Y',time()).' &#8482;</div>';
echo '</body>';
echo '</html>';
exit();
}






$generaliste=$cfr->query("SELECT COUNT(*) FROM generaliste")->fetch_array();
$stiri=$cfr->query("SELECT COUNT(*) FROM stiri")->fetch_array();
$sport=$cfr->query("SELECT COUNT(*) FROM sport")->fetch_array();
$filme=$cfr->query("SELECT COUNT(*) FROM filme")->fetch_array();
$documentare=$cfr->query("SELECT COUNT(*) FROM documentare")->fetch_array();
$muzica=$cfr->query("SELECT COUNT(*) FROM muzica")->fetch_array();
$deseneanimate=$cfr->query("SELECT COUNT(*) FROM deseneanimate")->fetch_array();
$regionale=$cfr->query("SELECT COUNT(*) FROM regionale")->fetch_array();
$republicamoldova=$cfr->query("SELECT COUNT(*) FROM republicamoldova")->fetch_array();
$canaleinternationale=$cfr->query("SELECT COUNT(*) FROM canaleinternationale")->fetch_array();
$adultxxx=$cfr->query("SELECT COUNT(*) FROM adultxxx")->fetch_array();
echo '<div class="titlu">Administrare '.$numesite.'</div>';
echo '<p align="center">';
echo '<b>List&#259; Categorii:<br/></b>';
echo '<p align="left">';

echo '<font color="red">&bull;</font> <a href="admin.php?a=categorii&a=categorii&c=generaliste">Generaliste</a> <font color="#000000">('.$generaliste[0].')</font><br/>';
echo '<font color="red">&bull;</font> <a href="admin.php?a=categorii&c=stiri">&#350;tiri</a> <font color="#000000">('.$stiri[0].')</font><br/>';
echo '<font color="red">&bull;</font> <a href="admin.php?a=categorii&c=sport">Sport</a> <font color="#000000">('.$sport[0].')</font><br/>';
echo '<font color="red">&bull;</font> <a href="admin.php?a=categorii&c=filme">Filme</a> <font color="#000000">('.$filme[0].')</font><br/>';
echo '<font color="red">&bull;</font> <a href="admin.php?a=categorii&c=documentare">Documentare</a> <font color="#000000">('.$documentare[0].')</font><br/>';
echo '<font color="red">&bull;</font> <a href="admin.php?a=categorii&c=muzica">Muzic&#259;</a> <font color="#000000">('.$muzica[0].')</font><br/>';
echo '<font color="red">&bull;</font> <a href="admin.php?a=categorii&c=deseneanimate">Desene Animate</a> <font color="#000000">('.$deseneanimate[0].')</font><br/>';
echo '<font color="red">&bull;</font> <a href="admin.php?a=categorii&c=regionale">Regionale</a> <font color="#000000">('.$regionale[0].')</font><br/>';
echo '<font color="red">&bull;</font> <a href="admin.php?a=categorii&c=republicamoldova">Republica Moldova</a> <font color="#000000">('.$republicamoldova[0].')</font><br/>';
echo '<font color="red">&bull;</font> <a href="admin.php?a=categorii&c=canaleinternationale">Canale Interna&#355;ionale</a> <font color="#000000">('.$canaleinternationale[0].')</font><br/>';
echo '<font color="red">&bull;</font> <a href="admin.php?a=categorii&c=adultxxx">Adult XXX <font color="red">(+18)</font></a> <font color="#000000">('.$adultxxx[0].')</font><br/>';
echo '</p>';
echo '<p align="center">';
echo '<a href="http://'.$host.'"><img src="http://tvpemobil.net/imagini/acasa.gif" alt=""/>Acas&#259;</a><br/>';
echo '</p>';
echo '<div class="footer">&#169; '.$numesite.' '.date('Y',time()).' &#8482;</div>';
echo '</body>';
echo '</html>';
?>