\n";
# MAIN: Top Left
print "| ";
print " ".__("Welcome to the AUR! Please read the %hAUR User Guidelines%h and %hAUR TU Guidelines%h for more information.", array('', '', '', ''))."
";
print __("Contributed PKGBUILDs must conform to the %hArch Packaging Standards%h otherwise they will be deleted!", array('', ''))." ";
#print "".__("If you have feedback about the AUR, please leave it in %hFlyspray%h.", array('', ''))."
";
#print __("Email discussion about the AUR takes place on the %sTUR Users List%s.", array('', ''))." ";
print "".__("Remember to vote for your favourite packages!")."
";
print __("The most popular packages will be provided as binary packages in [community].")." ";
#print "".__("Though we can't vouch for their contents, we provide a %hlist of user repositories%h for your convenience.", array('', ''))." ";
# MAIN: Top Right
print " | ";
print "";
# Now present the user login stuff
if (!isset($_COOKIE["AURSID"])) {
# the user is not logged in, give them login widgets
#
if ($login_error) {
print "" . $login_error . "
\n";
}
print "\n";
} else {
print __("Logged-in as: %h%s%h",
array("", username_from_sid($_COOKIE["AURSID"]), ""));
}
# MAIN: Bottom Left
print " | ";
print "
";
print "";
print "";
#Hey, how about listing the newest pacakges? :D
$q = "SELECT * FROM Packages ";
$q.= "WHERE DummyPkg != 1 ";
$q.= "ORDER BY GREATEST(SubmittedTS,ModifiedTS) DESC ";
$q.= "LIMIT 0 , 10";
$result = db_query($q,$dbh);
# Table 2
print '';
print '';
print '';
print '  '.__("Recent Updates").' ';
print ' | ';
print ' ';
while ($row = mysql_fetch_assoc($result)) {
print '';
print '| ';
print '';
print $row["Name"]." ".$row["Version"]."";
print ' | ';
print '';
# figure out the mod string
$mod_int = intval($row["ModifiedTS"]);
$sub_int = intval($row["SubmittedTS"]);
if ($mod_int != 0) {
$modstring = gmdate("r", $mod_int);
}
elseif ($sub_int != 0) {
$modstring = ' '.gmdate("r", $sub_int);
}
else {
$mod_string = "(unknown)";
}
print ''.$modstring.'';
print ' | ';
print ' '."\n";
}
print "";
print "";
print " ";
# End Table 2
#print " | | ";
#print " \n";
# MAIN: Bottom Right
print " | ";
print "";
# AUR STATISTICS
$q = "SELECT count(*) FROM Packages,PackageLocations WHERE Packages.LocationID = PackageLocations.ID AND PackageLocations.Location = 'unsupported'";
$result = db_query($q, $dbh);
$row = mysql_fetch_row($result);
$unsupported_count = $row[0];
$q = "SELECT count(*) FROM Packages,PackageLocations WHERE Packages.LocationID = PackageLocations.ID AND PackageLocations.Location = 'community'";
$result = db_query($q, $dbh);
$row = mysql_fetch_row($result);
$community_count = $row[0];
$q = "SELECT count(*) from Users";
$result = db_query($q, $dbh);
$row = mysql_fetch_row($result);
$user_count = $row[0];
$q = "SELECT count(*) from Users,AccountTypes WHERE Users.AccountTypeID = AccountTypes.ID AND AccountTypes.AccountType = 'Trusted User'";
$result = db_query($q, $dbh);
$row = mysql_fetch_row($result);
$tu_count = $row[0];
$targstamp = intval(strtotime("-7 days"));
$q = "SELECT count(*) from Packages WHERE (Packages.SubmittedTS >= $targstamp OR Packages.ModifiedTS >= $targstamp)";
$result = db_query($q, $dbh);
$row = mysql_fetch_row($result);
$update_count = $row[0];
$q = "SELECT count(*) FROM Packages,PackageLocations WHERE Packages.LocationID = PackageLocations.ID AND PackageLocations.Location = 'unsupported' AND Packages.Safe = 1";
$result = db_query($q, $dbh);
$row = mysql_fetch_row($result);
$safe_count = $row[0];
# Added the user statistcs.
# Added by: dsa
$user = username_from_sid($_COOKIE["AURSID"]);
if (!empty($user)) {
$q = "SELECT count(*) FROM Packages,PackageLocations,Users WHERE Packages.MaintainerUID = Users.ID AND Packages.LocationID = PackageLocations.ID AND PackageLocations.Location = 'unsupported' AND Users.Username='".mysql_real_escape_string($user)."'";
$result = db_query($q, $dbh);
$row = mysql_fetch_row($result);
$maintainer_unsupported_count = $row[0];
$q = "SELECT count(*) FROM Packages,Users WHERE Packages.OutOfDate = 1 AND Packages.MaintainerUID = Users.ID AND Users.Username='".mysql_real_escape_string($user)."'";
$result = db_query($q, $dbh);
$row = mysql_fetch_row($result);
$flagged_outdated = $row[0];
print "";
print "";
print "| ";
print "".__("My Statistics")."";
print " | ";
print " ";
# Number of packages in unsupported
print "";
print "| ";
print "".__("Packages in unsupported")."";
print " | ";
print "$maintainer_unsupported_count | ";
print " ";
# If the user is a TU calculate the number of the packages
$atype = account_from_sid($_COOKIE["AURSID"]);
if ($atype == 'Trusted User') {
$q = "SELECT count(*) FROM Packages,PackageLocations,Users WHERE Packages.MaintainerUID = Users.ID AND Packages.LocationID = PackageLocations.ID AND PackageLocations.Location = 'community' AND Users.Username='".mysql_real_escape_string($user)."'";
$result = db_query($q, $dbh);
$row = mysql_fetch_row($result);
$maintainer_community_count = $row[0];
print "";
print "| ";
print "".__("Packages in [community]")."";
print " | ";
print "$maintainer_community_count | ";
print " ";
}
# Number of outdated packages
print "";
print "| ";
print "".__("Out-of-date")."";
print " | ";
print "$flagged_outdated | ";
print " ";
# Number of safe packages
print "";
print "| ";
if ($atype == 'Trusted User') {
$q = "SELECT count(*) FROM Packages,Users WHERE Packages.Safe = 1 AND Packages.VerifiedBy = Users.ID AND Users.Username='".mysql_real_escape_string($user)."'";
$result = db_query($q, $dbh);
$row = mysql_fetch_row($result);
$flagged_safe = $row[0];
print "".__("Flagged as safe by me")."";
}
else
{
$q = "SELECT count(*) FROM Packages,Users WHERE Packages.Safe = 1 AND Packages.MaintainerUID = Users.ID AND Users.Username='".mysql_real_escape_string($user)."'";
$result = db_query($q, $dbh);
$row = mysql_fetch_row($result);
$flagged_safe = $row[0];
print "".__("Flagged as safe")."";
}
print " | ";
print "$flagged_safe | ";
print " ";
print "
";
}
print "";
print "";
print "| ";
print "".__("Statistics")."";
print " | ";
print " ";
print "";
print "| ";
print "".__("Packages in unsupported")."";
print " | ";
print "$unsupported_count | ";
print " ";
print "";
print "| ";
print "".__("Packages in unsupported and flagged as safe")."";
print " | ";
print "$safe_count | ";
print " ";
print "";
print "| ";
print "".__("Packages in [community]")."";
print " | ";
print "$community_count | ";
print " ";
print "";
print "| ";
print "".__("Packages added or updated in the past 7 days")."";
print " | ";
print "$update_count | ";
print " ";
print "";
print "| ";
print "".__("Registered Users")."";
print " | ";
print "$user_count | ";
print " ";
print "";
print "| ";
print "".__("Trusted Users")."";
print " | ";
print "$tu_count | ";
print " ";
print " ";
# Close out the right column
print " | ";
print "
\n";
print "\n";
# End Table 1
html_footer("