<?php include('inc/config.php'); ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html>
 <head>
  <title>OpenBoard by Unleashed!</title>
  <link rel="stylesheet" type="text/css" href="style.css" />
 </head>
 <body>
  <div id="Board">
  <?php 
   if(!isset($_GET['id']))
     echo 'No Thread found.';
   else
   {
    $query = odbc_exec($odbc, 'SELECT * FROM [THREADS_TBL] WHERE m_nId = '.$_GET['id']);
    $result = odbc_fetch_array($query);
    
    echo '<div class="HeadLine">'.$result['m_szName'].'</div>';
 
    $query = odbc_exec($odbc, 'SELECT * FROM [POSTS_TBL] WHERE m_nIdThread = '.$_GET['id']);   
    while($post = odbc_fetch_array($query))
    {
      $quser = odbc_exec($odbc, 'SELECT * FROM [USERS_TBL] WHERE m_nId = '.$post['m_nIdAuthor']);
      $result = odbc_fetch_array($quser);
      echo '<div class="Post"><table><tr><td class="User">'.$result['m_szName'].'<img src="img/avatar/'.$result['m_szAvatar'].'" alt=""" /></td><td><h2>'.$post['m_szTitle'].'</h2><hr /><p>'.$post['m_szText'].'</p></td></tr></div>';
    }
   }
  ?>
  </div>
 </body>
</html>