$mysql_connection = verbindung_big7();
$sql = "SELECT * FROM big7_videos WHERE video_kategorien LIKE '%$video_kategorie%' ORDER BY id DESC LIMIT $video_start,30";
$result = mysqli_query($mysql_connection, $sql);
while($zeile = mysqli_fetch_array($result)) {
$video_id = $zeile['id'];
$video_titel = ucfirst($zeile['video_titel']);
$video_beschreibung = $zeile['video_beschreibung'];
$video_datum = $zeile['video_datum'];
$video_guid = $zeile['video_guid'];
$video_link = $zeile['video_link'];
$video_duration = $zeile['video_duration'];
$video_thumbnail_fsk16 = $zeile['video_thumbnail_fsk16'];
$video_thumbnail_fsk18 = $zeile['video_thumbnail_fsk18'];
$video_thumbnail_amazon_fsk16 = $zeile['video_thumbnail_amazon_fsk16'];
$video_thumbnail_amazon_fsk18 = $zeile['video_thumbnail_amazon_fsk18'];
$video_user_name = $zeile['video_user_name'];
$video_user_link = $zeile['video_user_link'];
$video_kategorien = $zeile['video_kategorien'];
$video_meta_importiert = $zeile['video_meta_importiert'];
$video_meta_twitter_id = $zeile['video_meta_twitter_id'];
$besucher_uhrzeit = date('G');
$video_image = $video_thumbnail_amazon_fsk16;
if(empty($video_thumbnail_amazon_fsk16)){$video_image = $video_thumbnail_fsk16;}
if( $besucher_uhrzeit >= '22' || $besucher_uhrzeit <= '6'){ $video_image = $video_thumbnail_amazon_fsk18; if(empty($video_thumbnail_amazon_fsk18)){$video_image = $video_thumbnail_fsk18;} }
// Amazon-Fix
$video_image = $video_thumbnail_fsk18;
$anzahl_videos = $anzahl_videos +1;
?>
echo $video_duration; ?> Min
}
mysqli_free_result($result);
mysqli_close($mysql_connection);
?>