session_start(); $actus=$_SESSION["tpsk2015usr"]; $init=''; if ($_GET["ins"]) { $init="test.institute='".strip_tags($_GET["ins"])."';fmax=1;";} if ($_GET["tag"]) { $init="test.tags='".strip_tags($_GET["tag"])."';fmax=1;";} if ($_GET["cat"]) { $init="test.cat='".strip_tags($_GET["cat"])."';fmax=1;";} if ($_GET["vid"]) { require_once ('API/dbconf.php'); $con = mysqli_connect(HO,UN,PW,DB) or die("DB Error " . mysqli_error($con)); mysqli_query($con,"SET CHARACTER SET utf8;" ); mysqli_query($con,"SET NAMES 'UTF-8';"); $x= mysqli_real_escape_string($con,$_GET["vid"]); $sql = " SELECT v.link, v.name, i.acronym as institute, c.name as cat, v.views, v.desc, v.comments, round(v.rating) as rating, DATE_FORMAT(v.video_date,'%d %b %Y - %h:%i') as video_date, GROUP_CONCAT(t.name) AS tags, v.id, u.login, v.thumb_path FROM video AS v LEFT JOIN videotag AS vt ON v.id = vt.id_video LEFT JOIN tags AS t ON vt.id_tag = t.id LEFT JOIN institutions AS i ON v.id_institute = i.id LEFT JOIN categories AS c ON v.id_category = c.id LEFT JOIN users AS u ON v.id_user = u.id WHERE link='".$x."' GROUP BY v.id DESC LIMIT 1 "; $res = mysqli_query($con, $sql) or die("Error in Selecting" . mysqli_error($con)); $v= mysqli_fetch_array($res); mysqli_close($con); } if ($v[10]>0) { $fbimg=$v[12]; $fbdesc=$v[1]; } else { $fbimg="newlogo.jpg"; $fbdesc="Sledujte archív videí"; } ?>
{{desc}}
{{institute}} {{category}} {{t}}
{{cl.person}} {{cl.timestamp}}
{{cl.text}}
if ($actus>0) { ?>
Nový komentár:
} else { ?>
Pre vloženie komentára je nutné sa prihlásiť
} ?>
<iframe width="854" height="480" src="https:// echo $_SERVER['SERVER_NAME']; ?>/API/vplay.php?{{ll}}" frameborder="0" allowfullscreen scrolling="no"></iframe>
} else { ?>
Pre zobrazenie embed kódu je nutné sa prihlásiť
} ?>
https:// echo $_SERVER['SERVER_NAME']; ?>?{{ll}}