<?php
// Die Videoseite liegt in /videos/, dbpdo.php liegt eine Ebene höher
require_once __DIR__ . '/db.inc.php'; 
echo "\n"; 
include ("includesb/headneu.inc.php");

// 1. Abfrage: Video-Details (row3)
$stmt3 = $pdo->prepare("SELECT id,interpr,titelb,linkb,neukrz,neukrzb,codec,nw,nw100,text,amazonb,euro,internat,black,rock,dance,xmas,neu,newc,posb,ml,itun1,amab,bigpic,itunlk,genre,vidpicyt,likes,ytid,land1,vtermin,teambewertung FROM videos WHERE id = ? LIMIT 1");
$stmt3->execute([38300]);
$row3 = $stmt3->fetch();

if (!$row3) {
    header("HTTP/1.1 404 Not Found");
    exit("Video nicht gefunden.");
}

// 2. Abfrage: Chart-Position (row2)
$stmt2 = $pdo->prepare("SELECT pos,krz,idnr,matrend FROM tagescharts WHERE idnr = ? LIMIT 1");
$stmt2->execute([38300]);
$row2 = $stmt2->fetch();
?>
<!DOCTYPE html>
<html lang="de">
<head>
<meta charset="UTF-8" />
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1" />
<title>Kubi Producent &amp; Sapi Tha King - Koszt Bycia Boss Musikvideo</title>
<meta name="description" content="Musikvideo zum Song Koszt Bycia Boss von Kubi Producent &amp; Sapi Tha King ohne Invideo Werbung, Musik Download, Audio Streaming" />
<meta name="keywords" content="Kubi Producent Sapi Tha King, Koszt Bycia Boss, Video, werbefrei, Musik, Hit, Download, Audiostream" />
<meta name="viewport" content="width = device-width, initial-scale = 1.0" />
<meta name="author" content="oljo.de" />
<meta name="msvalidate.01" content="0DE09F68E89C255FC641E15DC09B3A5D" />
<meta name="robots" content="index,follow" />

<link rel="stylesheet" href="css/normalize.min.css" />
<link rel="stylesheet" href="css/main.css" />
<script src="js/vendor/modernizr-2.6.2-respond-1.1.0.min.js"></script>
<?php include ("includesb/dfpcode.inc.php"); ?>
<?php include_once ("includesb/analytics.php"); ?>
</head>
<body>
<?php include ("includesb/kopfneu.inc.php"); ?>
<?php include ("includesb/main-menue.inc"); ?>

<div class="main-container">
<div class="main wrapper clearfix">
    <aside class="left">
        <div class="leftside">
            <?php include ("includesb/leftsidetop.inc"); ?>
        </div>
    </aside>

    <article>
        <header>
            <div class="header-video">
                <?php include ("includesb/videoneu.inc.php"); ?>
            </div>
            <?php include ("includesb/bewertung.inc"); ?>
            <div class="fbmain">
                <?php include ("includesb/ilikeit.inc.php"); ?>
            </div>
        </header>

        <?php include ("includesb/preisvergleich2016.inc.php"); ?>

        <div class="info_genre">
            <p><b>Musik Genre: <?php echo htmlspecialchars($row3['genre'] ?? 'Pop'); ?></b> &#9733; &#9733; 
            <b>Herkunftsland:</b> <strong><?php echo htmlspecialchars($row3['land1'] ?? 'Deutschland'); ?></strong></p>
        </div>

        <footer>
            <?php include ("includesb/gooad468152013.inc"); ?>
            <?php include ("includesb/hitsinternational2022.inc.php"); ?>
            <?php include ("includesb/news2013.inc"); ?>
            <?php include ("includesb/artikelfootlinks.inc"); ?>
        </footer>
    </article>

    <aside class="right">
        <?php include ("includesb/aazneu.inc"); ?>
        <?php include ("includesb/beez.inc"); ?>
    </aside>
</div> 
</div> 

<?php include ("includesb/footer2016.inc.php"); ?>
<?php include ("includesb/sondermeldung.inc"); ?>
<script src="js/plugins.js"></script>
<script src="js/main2.js"></script>
</body>
</html>