Anonymous

<?php
include "mysql.php";
?><h1>Matches</h1>
<?php
/* Example phpbb post:

opponent: Kill or Die
time: 1192377600
server: |x|.Fortress.Server
type: AFL
scoreshome: 46 66 64
scoresopponent: 100 106 104
recording: http://kowsklan.free.fr/recordings/afl/2007Fall/Week%201/TDvsKoD-2007-10-14-AFL.aarec.zip
screenshot: http://img502.imageshack.us/img502/6132/screenshot705ha8.png
screenshot: http://img88.imageshack.us/img88/623/screenshot706db6.png
screenshot: http://img201.imageshack.us/img201/4426/screenshot708aj0.png

*/

// Give here the forum_id which contains matches posts
define(FORUM_ID, 11);

function get_matches ()
{
 db_connect();
 $matchesres = mysql_query("SELECT `post_text`,`post_id` FROM `phpbb_posts_text` WHERE `post_id` IN (SELECT `post_id` FROM `phpbb_posts` WHERE `forum_id` = ". FORUM_ID .")");
 $matches;
 $nummatches = mysql_num_rows($matchesres);
 for($i = 0; $i < $nummatches; $i++)
 {
  $match_id = mysql_result($matchesres, $i, 'post_id');
  $matches[$match_id] = mysql_result($matchesres, $i);

 }
 return $matches;
}

function get_match ($id)
{
 db_connect();
 $matchesres = mysql_query("SELECT `post_text`,`post_id` FROM `phpbb_posts_text` WHERE `post_id` IN (SELECT `post_id` FROM `phpbb_posts` WHERE `forum_id` = " . FORUM_ID . " AND `post_id`= $id)");
 $matches;
 $nummatches = mysql_num_rows($matchesres);
 
 if ($nummatches = 0) return 0;
  
 $match_id = mysql_result($matchesres, 0, 'post_id');
 $matches[$match_id] = mysql_result($matchesres, 0);

 return $matches;
}


function parse_post ($postmessage, $id)
{
 $regexp_url = "([http:\/\/|HTTP:\/\/|https:\/\/|HTTPS:\/\/][a-zA-Z.0-9-]*[\/a-zA-Z.-_]*\/[\/a-zA-Z0-9%._-]*)";

 echo "<!-- $regexp_url -->";

 # parse the message
 $opponent; $time; $server; $type; $scoreshome; $scoresopponent; $recording; $screenshots;
 preg_match ('@^opponent: ([^\r\n\f]+)@m', $postmessage, $opponent);
 preg_match ("@^time: ([0-9]+)@m", $postmessage, $time);
 preg_match ('@^server: ([^\r\n\f]+)@m', $postmessage, $server);
 preg_match ('@^type: ([^\r\n\f]+)@m', $postmessage, $type);
 preg_match ("@^scoreshome: ([0-9 ]+)@m", $postmessage, $scoreshome);
 preg_match ("@^scoresopponent: ([0-9 ]+)@m", $postmessage, $scoresopponent);
 preg_match ("@^recording: $regexp_url@m", $postmessage, $recording);
 preg_match_all ("@^screenshot: $regexp_url@m", $postmessage, $screenshots);
 

 $match;
 $match['id'] = $id;
 $match['opponent'] = $opponent[1];
 $match['time'] = $time[1];
 $match['server'] = $server[1];
 $match['type'] = $type[1];
 $match['scoreshome'] = explode(" ", $scoreshome[1]);
 $match['matchescount'] = count($match['scoreshome']);
 $match['scoresopponent'] = explode(" ", $scoresopponent[1]);
 $match['recording'] = $recording[1];
 $match['screenshots'] = $screenshots[1];
 $match['scorehome'] = 0;
 $match['scoreopponent'] = 0;
 #determines won matches
 for ($i = 0;$i < $match['matchescount']; $i++)
 {
  
  if($match['scoreshome'][$i] < $match['scoresopponent'][$i])
   $match['scoreopponent']++;
  else
   $match['scorehome']++;
 }
 $match['winner'] = ($match['scorehome'] > $match['scoreopponent'])? "Tronic Donkeys" : $match['opponent'];
/* echo "<!--";
 var_export($match);
 echo "-->"; */

# var_export($opponent); var_export($time); var_export($server); var_export($type); var_export($scorehome); var_export($scoreopponent); var_export($recording); var_export($screenshots);
 return $match;
 
}
function order_match(&$match, &$past, &$present, &$future)
{
 if ($match['scoreshome'][0] !== "")
  $past[]=$match;
 else if ($match['time'] < time())
  $present[]=$match;
 else
  $future[]=$match;
}
function compare_match_times($a, $b)
{
 if ($a['time'] == $b['time']) return 0;
 return ($a['time'] > $b['time'])? 1 : -1;
}
function print_matches($past, $present, $future)
{
 ?><table id="matches">
 <thead>
  <tr class="firstline">
   <td>Opponent</td>
   <td>Time</td>
   <td>Server</td>
   <td>Type</td>
   <td>Score</td>
   <td>Winner</td>
  </tr>
 </thead>
 <tbody><?php
 if (isset($present[0]))
 {
  echo "<tr><td class='now' colspan='6'>Current running matches</td></tr>";
  foreach($present as $match)
  {
   echo "<tr><td>{$match['opponent']}</td><td>".date("Y/m/d H:i", $match['time'])." GMT</td><td>{$match['server']}</td><td>{$match['type']}</td><td class='noresults' colspan='2'><a href='?c=5&amp;m={$match['id']}'>No results yet</a></td></tr>";
  }
 }
 if (isset($future[0]))
 {
  echo "<tr><td class='future' colspan='6'>Next upcoming matches</td></tr>";
  foreach($future as $match)
  {
   echo "<tr><td>{$match['opponent']}</td><td>".date("Y/m/d H:i", $match['time'])." GMT</td><td>{$match['server']}</td><td>{$match['type']}</td><td class='noresults' colspan='2'><a href='?c=5&amp;m={$match['id']}'>No results yet</a></td></tr>";
  }
 }
 if (isset($past[0]))
 {
  echo "<tr><td class='past' colspan='6'>Past matches</td></tr>";
  foreach($past as $match)
  {
   echo "<tr><td>{$match['opponent']}</td><td>".date("Y/m/d H:i", $match['time'])." GMT</td><td>{$match['server']}</td><td>{$match['type']}</td><td><a href='?c=5&amp;m={$match['id']}'>" . $match['scorehome'] . " - " . $match['scoreopponent'] . "</a></td><td>{$match['winner']}</td></tr>";
  }
 } ?>
 </tbody>
 </table>
 <?php

}

function print_match ($matchdata)
{
 echo "<table>";
 echo "<tr class='firstline'><td colspan='2'>Tronic Donkeys VS {$matchdata['opponent']}, the ". date("j \of F", $matchdata['time']) ."</td></tr>";
 echo "<tr><td>Date</td><td>The ". date("jS \of F, Y", $matchdata['time'])  ."</td></tr>";
 echo "<tr><td>Time</td><td>" . date("H:i", $matchdata['time']) . " GMT</td></tr>";
 echo "<tr><td>Server</td><td>{$matchdata['server']}</td></tr>";
 echo "<tr><td>Type</td><td>{$matchdata['type']}</td></tr>";
 if ($matchdata['scoreshome'][0] != '')
 {
  echo "<tr><td class='results' colspan='2'>Results</td></tr>";
  for($i = 0; $i < $matchdata['matchescount']; $i++)
  {
   echo "<tr><td>Match ". ($i + 1) ."</td><td><a href='{$matchdata['screenshots'][$i]}'>{$matchdata['scoreshome'][$i]}-{$matchdata['scoresopponent'][$i]}</a></td></tr>";
  }
  echo "<tr><td>Final scores</td><td>{$matchdata['scorehome']}-{$matchdata['scoreopponent']}</td></tr>";
  echo "<tr><td>Winner</td><td>{$matchdata['winner']}</td></tr>";
  echo "<tr><td>Recording</td><td><a href='{$matchdata['recording']}'>Click here</a></td></tr>";
 }
 echo "</table>";
}

function list_all()
{
 $pastmatches;
 $currentmatches;
 $upcomingmatches;
 $matches = get_matches();
 foreach ($matches as $match_id => $match)
 {
  $matchdata = parse_post($match, $match_id);
  order_match($matchdata, $pastmatches, $currentmatches, $upcomingmatches);
 }
 @usort($pastmatches, "compare_match_times");
 @usort($currentmatches, "compare_match_times");
 @usort($upcomingmatches, "compare_match_times");

 print_matches($pastmatches, $currentmatches, $upcomingmatches);

}
function match_info ($id)
{
 $match = get_match($id);
 if ($match == 0)
 {
  echo "<p>There is no such match. <a href='?c=5'>Return</a></p>";
  return;
 }
 $matchdata = parse_post($match[$id], $id);
 print_match($matchdata);
 echo "<p><a href='?c=5'>Return</a></p>";
}
?>
<?php

if(isset($_GET['m']))
{
 match_info($_GET['m']);
}
else
{
 list_all();
}


?>