\n";
echo "\n";
$td_style = 'style="padding: 5 10pt;"';
echo "\n";
for ($c = 0; $c < $num_cols; $c++)
{
// if (isset($ladder_headers[$c]))
if (true)
{
$td = mysql_field_name($result, $c);
echo "| {$td} | \n";
}
}
echo "
\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 "\n";
for ($c = 0; $c < $num_cols; $c++)
{
//if (!isset($ladder_headers[$c]))
if (false)
{
continue;
}
$td = $row[$c];
if (!isset($td))
{
$td = ' ';
}
echo "| {$td} | \n";
}
echo "
\n";
}
echo "\n";
echo "\n";
}
// ----
function html_choose_date($date_name, $years)
{
// $size = the number of days to display in the drop down
// $default = Todays date in m:d:Y format (SEE DATE COMMAND ON WWW.PHP.NET)
$months = array(
1 => 'January',
2 => 'February',
3 => 'March',
4 => 'April',
5 => 'May',
6 => 'June',
7 => 'July',
8 => 'August',
9 => 'September',
10 => 'October',
11 => 'November',
12 => 'December');
$now_time = time();
$now_year = date('Y', $now_time);
echo "\n";
echo "\n";
echo "\n";
}
// ----
function html_edit_table($table_name, $action, $action_tag)
{
$query = "SELECT * FROM {$table_name}";
$result = mysql_query($query);
if (!is_resource($result))
{
echo "Not a Resource\n";
return(0);
}
$num_cols = mysql_num_fields($result);
$num_rows = mysql_num_rows($result);
echo "\n";
mysql_free_result($result);
}
// ----
function admin_action_del($table_name)
{
global $dbt_booking_list;
$query = "SELECT * FROM {$table_name}";
$result = mysql_query($query);
if (!is_resource($result))
{
echo "Not a Resource
\n";
return(0);
}
$num_cols = mysql_num_fields($result);
$num_rows = mysql_num_rows($result);
$col_0_id = mysql_field_name($result, 0);
// ----
for ($r = 0; $r < $num_rows; $r++)
{
$row = mysql_fetch_row($result);
$admin_par = $table_name . '_' . $row[0] . '_del';
$data = $_POST[$admin_par];
if (isset($data))
{
$del_query = "DELETE FROM {$table_name} WHERE {$col_0_id} = {$row[0]}";
//echo $del_query;
$del_result = mysql_query($del_query);
if (!$del_result)
{
echo "Could not remove {$col_0_id}.{$row[0]} from table {$table_name}: " . mysql_error() . "
\n";
}
// --
$del_query = "DELETE FROM {$dbt_booking_list} WHERE {$col_0_id} = {$row[0]}";
//echo $del_query;
$del_result = mysql_query($del_query);
if (!$del_result)
{
echo "Could not remove {$col_0_id}.{$row[0]} from table {$dbt_booking_list}: " . mysql_error() . "
\n";
}
}
}
// ----
mysql_free_result($result);
}
// ----user = 'user1'
function html_show_bookinglists()
{
global $dbt_equipment, $dbt_bookings, $dbt_booking_list;
/*
// list of B_UID's for user, ordered by from date first
$query = "SELECT B_UID FROM {$dbt_bookings} WHERE user = 'user0' ORDER BY date_from";
$result = mysql_query($query);
// html_result($result);
$user_bookings_array = col_to_array($result, 0);
var_dump($user_bookings_array);
echo "
\n";
mysql_free_result($result);
/* */
// --
$query = "SELECT DISTINCT B_UID FROM {$dbt_booking_list}";
$b_uid_result = mysql_query($query);
if (!is_resource($b_uid_result))
{
echo "Not a Resource\n";
return(0);
}
do
{
$b_uid_row = mysql_fetch_row($b_uid_result);
if (!$b_uid_row)
{
break;
}
$b_uid = $b_uid_row[0];
$query = "SELECT user FROM {$dbt_bookings} WHERE B_UID = {$b_uid}";
$result = mysql_query($query);
$row = mysql_fetch_row($result);
$user = $row[0];
mysql_free_result($result);
$query = "SELECT date_from FROM {$dbt_bookings} WHERE B_UID = {$b_uid}";
$result = mysql_query($query);
$row = mysql_fetch_row($result);
$date_from = $row[0];
mysql_free_result($result);
$query = "SELECT date_to FROM {$dbt_bookings} WHERE B_UID = {$b_uid}";
$result = mysql_query($query);
$row = mysql_fetch_row($result);
$date_to = $row[0];
mysql_free_result($result);
echo "\n";
echo "Booking list {$b_uid}, by {$user}, from {$date_from}, to {$date_to}:\n";
echo "
\n";
echo "\n";
$query = "SELECT E_UID FROM {$dbt_booking_list} WHERE B_UID = {$b_uid}";
$e_uid_result = mysql_query($query);
do
{
$e_uid_row = mysql_fetch_row($e_uid_result);
if (!$e_uid_row)
{
break;
}
$e_uid = $e_uid_row[0];
$query = "SELECT description FROM {$dbt_equipment} WHERE E_UID = {$e_uid}";
$result = mysql_query($query);
$row = mysql_fetch_row($result);
$equ_description = $row[0];
mysql_free_result($result);
echo "{$equ_description}
\n";
} while (true);
mysql_free_result($e_uid_result);
echo "
\n";
echo "
\n";
} while (true);
mysql_free_result($b_uid_result);
}
// ----
function col_to_array($db_result, $column)
{
$array_new = array();
if (is_resource($db_result))
{
mysql_data_seek($db_result, 0);
do
{
$row = mysql_fetch_row($db_result);
if (!$row)
{
break;
}
$array_new[] = $row[$column];
} while (true);
}
return($array_new);
}
// ----
function get_new_uid($db_result, $uid_max)
{
$uid_new = $uid_max;
if (is_resource($db_result))
{
// convert column data into an array
$uid_array = col_to_array($db_result, 0);
// find new UID
for ($uid_new = 0; $uid_new < $uid_max; $uid_new++)
{
if (!in_array($uid_new, $uid_array))
{
break;
}
}
}
return($uid_new);
}
// ----
?>