<table>
<?php
  $db_link = @mysql_connect('localhost', 'username', 'pass') or die(mysql_error());
  @mysql_select_db('wowtahc1_achievements') or die(mysql_error());
 
  $id = isset($_GET['id']) ? $_GET['id'] : 0;
 
  $type = $_GET['type'];
  switch ($type)
  {
    case 'general': {
      if ($id < 1) 
      {
        $query = 'SELECT * FROM general';
        $result = @mysql_query($query) or die(mysql_error());
        if ($result)
        {
          while ($row = mysql_fetch_assoc($result))
          {
            echo '<tr>';
            echo '<th class="title"><a href="achievements.php?type=general&id=' . $row['Id'] . '">' . $row['Name'] . '</a></th>';
            echo '<td class="description">' . $row['Description'] . '</td>';
            echo '</tr>';
          }
          mysql_free_result($result);
        }
      }
      else
      {
        $query = "SELECT * FROM general WHERE id=$id";
        $result = @mysql_query($query) or die(mysql_error());
        if ($result)
        {
          if ($row = mysql_fetch_assoc($result))
          {
            echo '<tr>';
            echo '<th class="title">' . $row['Name'] . '</th>';
            echo '<td class="description">' . $row['Description'] . '</td>';
            echo '</tr>';
          }
          mysql_free_result($result);
        }
      }
      break;
    }
    case 'quests':
    {
      if ($id < 1)
      {
        $query = 'SELECT * FROM quests';
        $result = @mysql_query($query) or die(mysql_error());
        if ($result)
        {
          while ($row = mysql_fetch_assoc($result))
          {
            echo '<tr>';
            echo '<th class="title"><a href="achievements.php?type=quests&id=' . $row['Id'] . '">' . $row['Name'] . '</a></th>';
            echo '<td class="description">' . $row['Description'] . '</td>';
            echo '</tr>';
          }
          mysql_free_result($result);
        }
      }
      else
      {
        $query = "SELECT * FROM quests WHERE id=$id";
        $result = @mysql_query($query) or die(mysql_error());
        if ($result)
        {
          if ($row = mysql_fetch_assoc($result))
          {
            echo '<tr>';
            echo '<th class="title">' . $row['Name'] . '</th>';
            echo '<td class="description">' . $row['Description'] . '</td>';
            echo '</tr>';
          }
          mysql_free_result($result);
        }
      }
      break;
    }
  }      
  mysql_close($db_link)
?>
</table>

case 'general': {
      $query = 'SELECT * FROM general';
      $result = @mysql_query($query) or die(mysql_error());
      if ($result)
      {
      while ($row = mysql_fetch_assoc($result))
      {
      echo '<br/>' . '<br/>';
      echo $row['Picture'] . '<span class="title">' . $row['Name'] . '</span>';
	  echo '<br/>';
	  echo '<span class="description">' . $row['Description'] . '</span>';
      }
      mysql_free_result($result);
      }
      break;
      }

<?php
require("tools.php");
if(isset($id))
{
    $filedata = mysql_query("SELECT * FROM general WHERE ID = '".$id."' LIMIT 1");
    header("Content-type: \"".mysql_result($filedata, 0, "filetype")."\"");
// Work out whether we can show or download the attachment:
    $mimetype = explode("/", $row["filetype"]);
    if($mimetype[0] != "Picture")
    {
        header("Content-length: ".mysql_result($filedata, 0, "filesize"));
        header("Content-Disposition: attachment; filename=".mysql_result($filedata, 0, "filename"));
        header("Content-Description: PHP Generated Data");
    }
    echo mysql_result($filedata, 0, "Avatar");
}
?>