committers/committertools/mir_drop_list_status.php

<?php
        require_once "/home/data/httpd/eclipse-php-classes/system/dbconnection.class.php";
        require_once "/home/data/httpd/eclipse-php-classes/system/app.class.php";

        #*****************************************************************************
        #
        # mir_list.php
        #
        # Author:       Denis Roy
        # Date:         2004-11-16
        #
        # Description:  Logic for displaying mirrors according to incoming parameters
        #
        # HISTORY:
        #
        #*****************************************************************************



	# Connect to database
	$dbc 	= new DBConnection();
	$dbh 	= $dbc->connect();

	$app = new App();
	
	$sql_info = "SELECT LEFT(MIN(date),10) as OldestDate, COUNT(*) AS RecordCount FROM downloads";
	$rs_info 	= mysql_query($sql_info, $dbh);
	$myrow_info = mysql_fetch_assoc($rs_info);
	$download_count = $myrow_info['RecordCount'];

	$sql_info = "SELECT COUNT(*) AS RecordCount FROM downloads WHERE mirror_id = 1";
	$rs_info 	= mysql_query($sql_info, $dbh);
	$myrow_info = mysql_fetch_assoc($rs_info);
	$eclipse_dl_count = $myrow_info['RecordCount'];
	

	# Fetch complete resultset
	$sql = "SELECT
				MIR.mirror_id,
				MIR.organization,
				MIR.ccode,
				MIR.email,
				MIR.create_status,
				COU.en_description	
			FROM mirrors as MIR
				INNER JOIN SYS_countries AS COU ON MIR.ccode = COU.ccode
			WHERE MIR.create_status != 'dropped'
				AND MIR.is_internal != 1
			ORDER BY COU.en_description, MIR.organization";

	$rs 	= mysql_query($sql, $dbh);

	include("inc/en_mir_drop_list_status.php");

	$dbc->disconnect();

	$rs 	= null;
	$dbh 	= null;
	$dbc 	= null;

?>