<?php
$hostname = "localhost";
$database = "chgk";
$username = "piataev";
$password = "";
$link = mysql_connect($hostname.':'.$port, $username, $password) or die("Can't connect to database");
mysql_select_db($database,$link) or die ("Can't select to database");
mysql_query ("SET NAMES 'utf8'");
$tour = $_GET['tour'];
if (preg_match('/\./',$tour))
{
$temp = explode('.', $tour);
$fname=$temp[0];$n=$temp[1];
$sth = mysql_query(
$sql="SELECT t2.Id FROM Tournaments as t1,
Tournaments as t2
WHERE (t1.FileName = '$fname.txt' OR t1.FileName='$fname')
AND t1.Id=t2.ParentId AND t2.Number=$n") or die(mysql_error().": $sql");
}
else
{
$sth=mysql_query($sql="SELECT Id FROM Tournaments WHERE FileName = '$tour.txt' OR FileName = '$tour'") or die (mysql_error().": $sql");
}
$res = mysql_fetch_row ($sth);
$id=$res[0];
$sth = mysql_query("SELECT * FROM Tournaments WHERE Id=$id") or die(mysql_error());
$tournament = mysql_fetch_assoc($sth);
$xw = new xmlWriter();
$xw->openMemory();
$xw->startDocument('1.0','utf8');
$xw->startElement('tournament');
foreach ($tournament as $key => $value)
{
$xw->writeElement ($key, $value);
}
$sth = mysql_query("SELECT * FROM Questions WHERE ParentId =$id");
while ($question = mysql_fetch_assoc($sth) )
{
$xw->startElement('question');
foreach ($question as $key => $value)
{
$xw->writeElement($key, $value);
}
$xw->endElement('question');
}
$xw->endElement('tournament');
$xmlResult = $xw->outputMemory(true);
$xmlResult = preg_replace('/\>\s*\</', ">\n<", $xmlResult);
header("Content-Type: text/xml");
print $xmlResult;
?>
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>