blob: a4655ffe271cd16fe0d9d7aa465cb679f603a808 [file] [log] [blame]
function getCount($filename, $dbh) {
#get the file id
$sql = "SELECT file_id
FROM download_file_index
WHERE file_name = '$filename'";
$rs = mysql_query($sql, $dbh);
$myrow = mysql_fetch_assoc($rs);
$fileid = $myrow['file_id'];
$sql = "SELECT COUNT(file_id) as count
FROM downloads
WHERE file_id = $fileid";
$rs = mysql_query($sql, $dbh);
$myrow = mysql_fetch_assoc($rs);
return $myrow['count'];
# simplisticly silly way of preventing the page from being accessed by just anybody.
# Linking to page.php?password=abc123 obviously defeats the whole purpose of this.
$_PASSWORD = $_GET['password'];
if ($_PASSWORD == "cdtstats") {
require_once "/home/data/httpd/eclipse-php-classes/system/dbconnection_downloads_ro.class.php";
# Connect to database
$dbc = new DBConnectionDownloads();
$dbh = $dbc->connect();
$files = array(
"/technology/epp/downloads/release/galileo/SR1/eclipse-cpp-galileo-SR1-linux-gtk.tar.gz,Linux 32",
"/technology/epp/downloads/release/galileo/SR1/eclipse-cpp-galileo-SR1-linux-gtk-x86_64.tar.gz,Linux 64",
"/technology/epp/downloads/release/galileo/SR1/eclipse-cpp-galileo-SR1-macosx-carbon.tar.gz,Mac Carbon 32",
"/technology/epp/downloads/release/galileo/SR1/eclipse-cpp-galileo-SR1-macosx-cocoa.tar.gz,Mac Cocoa 32",
"/technology/epp/downloads/release/galileo/SR1/eclipse-cpp-galileo-SR1-macosx-cocoa-x86_64.tar.gz,Mac Cocoa 64",
echo "<h2>Galileo SR1 C/C++ IDE Downloads</h2>";
echo "<table>";
echo "<tr>";
echo "<th>Platform</th>";
echo "<th>Downloads</th>";
echo "</tr>";
foreach ($files as $file) {
$fileex = explode(",", $file);
$filename = $fileex[0];
$platform = $fileex[1];
$count = getCount($filename, $dbh);
$total += $count;
echo "<tr>";
echo "<td>$platform</td>";
echo "<td>$count</td>";
echo "</tr>";
echo "</table>";
echo "<p>Total: $total</p>";
} else {
echo "<p>You are not authorized to access this page. (3)</p>";