#!/usr/bin/php -q
<?

// -- local config --

@include('../db.php');


// -- setup --

$header_colour = '000000';


// -- show tables --

$query = "SHOW TABLES";

$result = mysql_query($query);
if (!$result)
{
  die('Invalid query: ' . mysql_error());
}

echo "\n";
echo "Results for: $query :-\n";
echo "\n";

print_result($result);


$query = "SELECT * FROM test";

$result = mysql_query($query);
if (!$result)
{
  die('Invalid query: ' . mysql_error());
}

echo "\n";
echo "Results for: $query :-\n";
echo "\n";

html_result($result);


/* Free resultset */

mysql_free_result($result);

return(0);


// ---------------------------------------------------------------------

// -- functions --

function print_result($result)
{
  // print table headers

  $num_cols = mysql_num_fields($result);

  for ($c = 0; $c < $num_cols; $c++)
  {
    echo mysql_field_name($result, $c);
    echo ', ';
  }

  echo "\n";


  // print table contents

  $num_rows = mysql_num_rows($result);

  for ($r = 0; $r < $num_rows; $r++)
  {
    $row = mysql_fetch_row($result);

    for ($c = 0; $c < $num_cols; $c++)
    {
      echo $row[$c];
      echo ', ';
    }

    echo "\n";
  }
}

// ----

function html_result($result)
{
  global $header_colour;

  $num_cols = mysql_num_fields($result);
  $num_rows = mysql_num_rows($result);


  echo "<table align=center border=4 bordercolor=\"#{$header_colour}\" cellSpacing=0 cellPadding=5>\n";
  echo "<tbody valign=center align=center>\n";

  $td_style = 'style="padding: 5 10pt;"';

  echo "<tr>\n";

  for ($c = 0; $c < $num_cols; $c++)
  {
    // if (isset($ladder_headers[$c]))
    if (true)
    {
      $td = mysql_field_name($result, $c);
      echo "<th {$td_style}>{$td}</th>\n";
    }
  }

  echo "</tr>\n";


  for ($r = 0; $r < $num_rows; $r++)
  {
    $row = mysql_fetch_row($result);

    //if ((jdw_time_day() - $player_data[7]) < $ladder_day_highlight)
    if (false)
    {
      //$td_style = 'style="padding: 5 10pt; font-weight: bold;"';
      $td_style = 'style="padding: 5 10pt; font-size: 110%; font-weight: bold;"';
    }
    else
    {
      $td_style = 'style="padding: 5 10pt;"';
    }


    echo "<tr>\n";

    for ($c = 0; $c < $num_cols; $c++)
    {
      //if (!isset($ladder_headers[$c]))
      if (false)
      {
        continue;
      }

      $td = $row[$c];
      if (!isset($td))
      {
        $td = '&nbsp;';
      }

      echo "<td {$td_style}>{$td}</td>\n";
    }

    echo "</tr>\n";
  }

  echo "</tbody>\n";
  echo "</table>\n";
}

?>