0){
$conncond.=" AND conn_type='".$conn_type."'";
}
if(isset($_GET['conn_id'])){
$conn_id=$_GET['conn_id'];
}else{
$conn_id="";
}
if(strlen($conn_id)>0){
if($ext=="coll"){
$conncond.= " AND coll_id='".$conn_id."'";
$imageconnectonstable="";
$imageconnectionscond="";
}else{
$conncond.= " AND conn_id='".$conn_id."'";
$imageconnectionstable=", video_connections kapocs ";
$imageconnectionscond=" AND kapocs.vid_id=videok.id ";
}
}
function getvideothumb($provider,$vidobj){
$vidwidth=270;
$vidheight=228;
//echo $provider.$vidobj;
if ($provider=="youtube"){
$vidthumb = "";
}else if($provider=="vimeo"){
$vidthumb = "";
}
echo $vidthumb;
}
//HA film
if($conn_type==1){
$parancs = "SELECT * FROM movies WHERE movie_id ='" . $conn_id ."' ";
$eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
while ( $sor = mysql_fetch_array($eredmeny)) {
$title2= "".$sor['title'];
if($sor['season']>0){
if($lng=="hun"){
$title2.= " - ". $sor['season'].".".$txt['season']."";
}else{
$title2.= " - ".$txt['season']." ". $sor['season'];
}
}
$title2.= "
";
if( $sor['hun_title']!= $sor['eng_title']){
$title2.= "".$sor['hun_title'];
if($sor['season']>0){
if($lng=="hun"){
$title2.= " - ". $sor['season'].".".$txt['season']."";
}else{
$title2.= " - ".$txt['season']." ". $sor['season'];
}
}
$title2.= "
";
}
$title2.= "(".$sor['year'];
$title2.= ")
";
}
}
//HA szemely
if($conn_type==2){
$parancs = "SELECT person_id, name FROM persons WHERE person_id =" . $conn_id ;
$eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
while ( $sor = mysql_fetch_array($eredmeny)) {
$title2= $sor['name'];
}
}
//HA cimke
if($conn_type==3){
$parancs = "SELECT ".$lng."_tag_name FROM tags WHERE tag_id =" . $conn_id ;
$eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
while ( $sor = mysql_fetch_array($eredmeny)) {
$title2= $sor[$lng."_tag_name"];
}
}
//HA kultfigura
if($conn_type==4){
$parancs = "SELECT ".$lng."_name FROM cult_characters WHERE id =" . $conn_id ;
$eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
while ( $sor = mysql_fetch_array($eredmeny)) {
$title2= $sor[$lng."_name"];
}
}
if($ext=="coll" && $conn_id>0){
$pagerquery="SELECT name FROM image_collections WHERE id='".$conn_id."' ";
$eredmeny = mysql_query($pagerquery, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
while ( $sor = mysql_fetch_array($eredmeny)){
$title2=$sor['name'];
}
}
//csekkolni h csak sajatot
/*
if($nick!=$_SESSION['nick'] && $_SESSION['role']!="admin"){
header("Location: index.php");
echo "";
}
*/
?>
<?php echo $txt['videos']?> - FilmO
0){
$extracon_fields="";
$extracon_tables=" ,image_coll_items gyujtemenyek";
$extracon_cond=" AND gyujtemenyek.vid_id=videok.id AND gyujtemenyek.coll_id='".$conn_id."'";
$extracon_groupby=" GROUP BY gyujtemenyek.vid_id";
$orderby=" gyujtemenyek.datetime DESC, videok.id DESC";
$titletext=$txt['collection'];
}else if($ext=="nfav" && strlen($nick)>0){
$extracon_fields=",COUNT(kedvencek.nick) AS kedvencekszama";
$extracon_tables=" ,favvideos kedvencek";
$extracon_cond=" AND kedvencek.vid_id=videok.id AND kedvencek.nick='".$nick."'";
$extracon_groupby=" GROUP BY kedvencek.vid_id";
$orderby=" kedvencek.datetime DESC, videok.id DESC";
$titletext=$txt['favourite']." ".$txt['videos'];
}else{
$extracon_fields="";
$extracon_tables="";
$extracon_cond="";
$extracon_groupby=" GROUP BY videok.id";
$orderby=" datetime DESC, videok.id DESC";
$titletext=$txt['videos'];
}
?>
".$nick."
";
}
if($title2!=""){
echo "".$title2."
";
}
?>
0 && $conn_id>0) || strlen($ext)>0 ){
$pagerquery="SELECT videok.id, hun_title, eng_title, provider, objectid, url, owner, videok.datetime AS datetime ".$extracon_fields." FROM videos videok ".$imageconnectionstable." ".$extracon_tables." WHERE 1=1 ".$imageconnectionscond." ".$conncond." ".$extracon_cond." ".$extracon_groupby."";
}else{
$pagerquery="SELECT videok.id, hun_title, eng_title, provider, objectid, url, owner, videok.datetime ".$extracon_fields." FROM videos videok ".$extracon_tables." ".$extracon_groupby."";
}
$visible="true";
include 'pager-videos.php';
if((strlen($conn_type)>0 && $conn_id>0) || strlen($ext)>0 ){
$parancs = "SELECT videok.id, hun_title, eng_title, provider, objectid, url, owner, videok.datetime AS datetime ".$extracon_fields." FROM videos videok ".$imageconnectionstable." ".$extracon_tables." WHERE 1=1 ".$imageconnectionscond." ".$conncond." ".$extracon_cond." ".$extracon_groupby." ORDER BY ".$orderby." LIMIT " . $kezd ." , " . $megjelenitett;
}else{
$parancs = "SELECT videok.id, hun_title, eng_title, provider, objectid, url, owner, videok.datetime AS datetime ".$extracon_fields." FROM videos videok ".$extracon_tables." WHERE 1=1 ".$extracon_cond." ".$extracon_groupby." ORDER BY ".$orderby." LIMIT " . $kezd ." , " . $megjelenitett;
}
$eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
echo "";
if($rows > $megjelenitett){
$visible="true";
include 'pager-videos.php';
}
echo "";
?>