<?php require_once("wm_core.php");
header("Content-Type: text/plain; charset=utf-8");
InitDB();

if (isset($_GET['m']) && isset($_GET['a']) && isset($_GET['b'])) {
    $m = intval($_GET['m']) % 1000;
    $a = intval($_GET['a']);
    $b = intval($_GET['b']);
    $q = Query("SELECT COUNT(*) AS valid FROM wm_matches WHERE id=$m AND ISNULL(goalsA) AND ISNULL(goalsB)");
    if (intval($q[0]['valid'])) {
        Query("UPDATE wm_matches SET goalsA=$a, goalsB=$b WHERE id=$m");
    }    
    die;
}

$teams = Query("SELECT * FROM wm_teams", RESOLVE_IDS);

StartQuery("SELECT * FROM wm_matches");
while (($match = NextRow())) {
    if (($match['goalsA'] !== NULL) || ($match['goalsB'] !== NULL)) {
        continue;
    }
    $ia = $match['teamA'];
    $ib = $match['teamB'];
    if (($ia > TeamCount) || ($ib > TeamCount)) {
        continue;
    }
    $na = strtolower($teams[$ia]['name']);
    $nb = strtolower($teams[$ib]['name']);
    $mid = $match['id'];
    if ($match['class'] < 100) { $mid += 1000; }
    echo "$mid:$na:$nb\n";
}
CloseQuery();

?>