$mysql_connection = verbindung_all();
$sql = "SELECT * FROM mdh_videos ORDER BY id DESC LIMIT 0,12";
$result = mysqli_query($mysql_connection, $sql);
while($zeile = mysqli_fetch_array($result)) {
$id = $zeile['id'];
$title = ($zeile['title']);
$link = $zeile['link'];
$description = ($zeile['description']);
$description = explode('.', $description);
$description = $description[0];
$description = explode('!', $description);
$description = $description[0].'.';
$description = ucfirst($description);
$anzahl_description = strlen($description);
if($anzahl_description > 100){
$description = substr($description, '0', '100').'...';
}
$pubdate = $zeile['pubdate'];
$video_online = $zeile['video_online'];
$vide_online_tag = substr($video_online, '0', '2');
$vide_online_monat = substr($video_online, '3', '2');
$vide_online_jahr = substr($video_online, '6', '4');
$vide_online_stunde = substr($video_online, '11', '2');
$vide_online_minute = substr($video_online, '14', '2');
//$video_online_datum = $vide_online_tag.'.'.$vide_online_monat.'.'.$vide_online_jahr.' '.$vide_online_stunde.':'.$vide_online_minute;
$video_online_datum = $vide_online_jahr.$vide_online_monat.$vide_online_tag.$vide_online_stunde.$vide_online_minute;
//echo $video_online_datum. ' ++ ';
date_default_timezone_set('Europe/Paris');
$datum_jetzt = date('YmdHi');
//echo $datum_jetzt;
if($datum_jetzt > $video_online_datum){
// echo 'Zeigen...';
}
$video_online = substr($video_online, '0', '10');
$video_dc = $zeile['video_dc'];
$video_min = $zeile['video_min'];
$video_img = $zeile['video_img'];
$video_vote = $zeile['video_vote'];
$u_nick = (strtoupper($zeile['u_nick']));
$u_id = $zeile['u_id'];
$u_link = $zeile['u_link'];
$uv_id= $zeile['uv_id'];
// Check, ob User in der User-Datenbank enthalten ist und dadurch ein "Top-Amateur"-Badge bekommt
$sql_2 = "SELECT * FROM mdh_user WHERE u_id = '$u_id' ORDER BY id DESC LIMIT 0,1";
$result_2 = mysqli_query($mysql_connection, $sql);
$top_amateur = mysqli_num_rows($result_2);
$u_nick_url = str_replace(' ', '_leer_', $u_nick);
?>
} ?>