".__("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('', ''))."
".__("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('', ''))."
".__("Remember to vote for your favourite packages!")."
";
print __("The most popular packages will be provided as binary packages in [community].")."
".__("Though we can't vouch for their contents, we provide a %hlist of user repositories%h for your convenience.", array('', ''))."
"; print "\n"; # 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]; print "
| "; print "".__("Statistics").""; print " | "; print "|
|---|---|
| "; print "".__("Packages in unsupported").""; print " | "; print "$unsupported_count | "; print "
| "; print "".__("Packages in [community]").""; print " | "; print "$community_count | "; print "
| "; print "".__("Registered Users").""; print " | "; print "$user_count | "; print "
| "; print "".__("Trusted Users").""; print " | "; print "$tu_count | "; print "
| "; print "".__("Packages added or updated in the past 7 days").""; print " | "; print "$update_count | "; print "
';
print '  '.__("Recent Updates").' ';
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 = date("r", $mod_int);
}
elseif ($sub_int != 0) {
$modstring = ' '.date("r", $sub_int);
}
else {
$mod_string = "(unknown)";
}
print ''.$modstring.'';
print ' | ';
print '
\n"; } print "