index.php

<?php
header("Location: 2022.php");
die();
?>
<?php require_once("inc/header.php"); ?>
<div class='container-fluid'>
    <div class='row'>
    <div class='col-md-4'>
    <h4>Recent updates</h4>
    <table class='table table-condensed table-striped table-hover fptable' style='width: 100%'>
<?php
$updatedago = strtotime("now") - $memcached->get("github.commits.lastupdated");
if ($updatedago == strtotime("now")) {
    $updatedago = "?";
}
?>
    <thead><tr><th>Description</th><th style='width: 200px'>&nbsp;</th></tr></thead>
    <?php
    if (empty($github['username'])) {
        echo "<tr><td colspan='2'>Repo history is disabled when GitHub info in config is not set.</td></tr>";
    } else {
        if (!$memcached->get("github.commits.json")) {
            require_once("scripts/updateGitHistory.php");
        }
        
        $commits = json_decode($memcached->get("github.commits.json"));
        foreach ($commits as $commit) {
            $message = $commit->message;
            if (strlen($message) > 55){
                $message = substr($message, 0, 55)  . "(...)";
            }

            echo "
            <tr>
            <td>[" . $commit->repo . "] <a target='_BLANK' href='" . $commit->url . "'>" . $message . "</a></td>
            <td style='min-width: 100px'>" . date("Y-m-d H:i:s", $commit->timestamp) . "</td>
            </tr>";
        }
    }

    ?>
    </table>
    </div>
    <div class='col-md-4'>
    <h4>Current WoW versions per branch</h4>
    <table class='table table-condensed table-striped table-hover fptable' style='width: 100%'>
    <thead><tr><th>Name</th><th>Build</th><th>Compiled at (PT)</th></tr></thead>
    <?php
    $productCDNMap = $pdo->query("SELECT program, cdndir FROM ngdp_products WHERE program LIKE 'wow%'")->fetchAll(PDO::FETCH_KEY_PAIR);
    $urlq = $pdo->query("SELECT id, name, url FROM ngdp_urls WHERE url LIKE '%wow%versions' ORDER BY ID ASC");
    $histq = $pdo->prepare("SELECT newvalue, timestamp FROM ngdp_history WHERE url_id = ? AND event = 'valuechange' ORDER BY ID DESC LIMIT 1");
    while ($row = $urlq->fetch(PDO::FETCH_ASSOC)) {
        $histq->execute([$row['id']]);
        
        $product = str_replace("/versions", "", substr($row['url'], strpos($row['url'], "wow")));
        $highestBuild = 0;
        $highestBuildName = "<i>Unknown</i>";
        $buildTime = "<i>Unknown</i>";
        $histr = $histq->fetch(PDO::FETCH_ASSOC);
        if (!empty($histr)) {
            $bc = parseBPSV(explode("\n", $histr['newvalue']));
            foreach ($bc as $bcregion) {
                if ($bcregion['BuildId'] > $highestBuild) {
                    $highestBuild = $bcregion['BuildId'];
                    $highestBuildName = $bcregion['VersionsName'];
                    $highestConfig = $bcregion['BuildConfig'];
                    $build = getBuildConfigByBuildConfigHash($bcregion['BuildConfig']);
                    if (!empty($build['builton'])) {
                        $buildTime = $build['builton'];
                    }
                }
            }
        }
        
        if (!empty($product) && array_key_exists($product, $productCDNMap) && in_array($productCDNMap[$product], ["tpr/wowdev", "tpr/wowdev2", "tpr/wowv"])) {
            $encrypted = " <i title='This branch is encrypted' class='fa fa-lock'></i>";
        } else {
            $encrypted = "";
        }
        
        if ($highestBuildName == "<i>Unknown</i>" && $buildTime == "<i>Unknown</i>") {
            continue;
        }
        
        echo "<tr>
        <td>" . str_replace("WoW ", "", str_replace(" Versions", "", $row['name'])) . $encrypted . "</td>
        <td>" . $highestBuildName . "</td><td>" . $buildTime . "</td>
        </tr>";
    }
    ?>
    </table>
    </div>
    <div class='col-md-4'>
    <h4>Recently detected hotfixes <small><a href='/dbc/hotfix_log.php?showAll=true'>(view all)</a></small></h4>
    <table class='table table-condensed table-striped table-hover fptable' style='width: 100%'>
    <thead><tr><th style='min-width: 110px;'>Push ID</th><th>Tables</th><th style='min-width: 60px;'>Rows</th><th>Detected on</th></tr></thead>
    <?php
    function getStatusColor($status)
    {

        switch ($status) {
            case "unknown":
                return "danger";
            case "unverified":
                return "warning";
            case "verified":
                return "success";
            case "official":
                return "primary";
            default:
                return "secondary";
        }
    }
    $hotfixLog = $pdo->prepare("SELECT name, status FROM wow_hotfixlogs WHERE pushID = ?");
    $buildQ = $pdo->prepare("SELECT expansion, major, minor FROM wow_builds WHERE build = ?");
    $hotfixes = $pdo->query("SELECT GROUP_CONCAT(DISTINCT(tableName)) as tables, COUNT(recordID) as rowCount, pushID, firstdetected, build FROM wow_hotfixes GROUP BY pushID ORDER BY firstdetected DESC, pushID DESC LIMIT 0,7")->fetchAll();
    foreach ($hotfixes as $hotfix) {
        $buildQ->execute([$hotfix['build']]);
        $buildRow = $buildQ->fetch(PDO::FETCH_ASSOC);
        if(empty($buildRow)){
            $hotfix['patch'] = "Unknown";
        }else{
            $hotfix['patch'] = $buildRow['expansion'].".".$buildRow['major'].".".$buildRow['minor'];
        }

        echo "<tr>
        <td><a href='/dbc/hotfixes.php#search=pushid:" . $hotfix['pushID'] . "'>" . $hotfix['pushID'] . "</a><br><span class='badge bg-secondary'>".$hotfix['patch']."</span></td>
        <td>" . implode('<br>', explode(',', $hotfix['tables'])) . "</td>
        <td>" . $hotfix['rowCount'] . "</td>
        <td>" . $hotfix['firstdetected'] . "</td>
        </tr>";

        $hotfixLog->execute([$hotfix['pushID']]);
        if ($logRow = $hotfixLog->fetch(PDO::FETCH_ASSOC)) {
            echo "<tr><td style='text-align: right'>└ <span class='badge bg-" . getStatusColor($logRow['status']) . "'>" . ucfirst($logRow['status']) . "</span></td><td colspan='3'><a href='/dbc/hotfix_log.php#" . $hotfix['pushID'] . "'><i class='fa fa-info-circle'></i></a> " . $logRow['name'] . "</td></tr>";
        }
    }
    ?>
    </table>
    <!--
    <h4>Latest filename additions</h4>
    <table class='table table-condensed table-striped table-hover' style='width: 100%'>
    <thead><tr><th>Amount</th><th>User</th><th>Date</th><th>Status</th></tr></thead>
    <?php
    $suggestions = $pdo->query("SELECT userid, DATE_FORMAT( submitted, \"%M %d\" ) as submitday, status, COUNT(*) as count FROM wow_rootfiles_suggestions GROUP BY userid, status, DATE_FORMAT( submitted, \"%Y %M %d\" ) ORDER BY submitted DESC LIMIT 0,2")->fetchAll();
    foreach ($suggestions as $row) {
        echo "<tr>
        <td>" . $row['count'] . " files</td>
        <td>" . getUsernameByUserID($row['userid']) . "</td>
        <td>" . $row['submitday'] . "</td>
        <td>" . $row['status'] . "</td>
        </tr>";
    }
    ?>
    </table>
    -->
    </div>
    </div>
    </div>
    <?php require_once("inc/footer.php"); ?>