[AppDB] Control Center: add 3 functions
Rosanne DiMesio
dimesio at earthlink.net
Mon Jun 26 10:08:13 CDT 2017
Adds purgeRejectedDistributions, purgeRejectedVendors,
and viewAppdbAdmins to the admin Control Center.
Signed-off-by: Rosanne DiMesio <dimesio at earthlink.net>
---
admin.php | 63 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 file changed, 63 insertions(+)
diff --git a/admin.php b/admin.php
index 79fbd58..f82fc2b 100644
--- a/admin.php
+++ b/admin.php
@@ -220,6 +220,22 @@ function deleteOrphanVersions()
echo "Deleted ".query_affected_rows()." orphan versions.<br>";
}
+function purgeRejectedDistributions()
+{
+ $sQuery = "DELETE FROM distributions WHERE state = 'deleted'";
+ $hResult = query_parameters($sQuery);
+
+ echo "Removed " .query_affected_rows()." rejected distributions from database.<br>";
+}
+
+function purgeRejectedVendors()
+{
+ $sQuery = "DELETE FROM vendor WHERE state = 'deleted'";
+ $hResult = query_parameters($sQuery);
+
+ echo "Removed " .query_affected_rows()." rejected vendors from database.<br>";
+}
+
function updateVersionRatings()
{
$hResult = version::objectGetEntries('accepted');
@@ -235,6 +251,36 @@ function updateVersionRatings()
echo "Updated $i entries";
}
+function viewAppdbAdmins()
+{
+ echo html_frame_start("AppDB Admins","90%","",0);
+ echo "<table width='100%' border=0 cellpadding=3 cellspacing=0>\n\n";
+ echo "<tr class=color1>\n";
+ echo "<td>Real name</td>\n";
+ echo "<td>Email</td>\n";
+ echo "<td>Last connected</td>\n";
+ echo "</tr>\n\n";
+
+ $sQuery = "SELECT user_list.userid, realname, email, stamp FROM user_list, user_privs WHERE user_list.userid = user_privs.userid AND user_privs.priv = 'admin' ORDER BY realname";
+
+ $hResult = query_parameters($sQuery);
+
+ $i = 0;
+ while($oRow = query_fetch_object($hResult))
+ {
+ $oUser = new User($oRow->userid);
+ echo "<tr class=color0>";
+ echo "<td>".$oUser->objectMakeLink()."</td>\n";
+ echo "<td>".$oUser->sEmail."</td>\n";
+ echo "<td>".$oUser->sStamp."</td>\n";
+ $i++;
+ }
+ echo "</table>";
+ echo html_frame_end();
+
+ echo "Found $i entries. <br>";
+}
+
function showChoices()
{
echo '<a href="admin.php?sAction=fixNoteLinks">Fix/Show note links</a><br />';
@@ -242,7 +288,10 @@ function showChoices()
echo '<a href="admin.php?sAction=updateVersionMaintainerStates">Update version maintainer states</a><br />';
echo '<a href="admin.php?sAction=deleteOrphanComments">Delete Orphan Comments</a><br>';
echo '<a href="admin.php?sAction=deleteOrphanVersions">Delete Orphan Versions</a><br>';
+ echo '<a href="admin.php?sAction=purgeRejectedDistributions">Purge Rejected Distributions</a><br>';
+ echo '<a href="admin.php?sAction=purgeRejectedVendors">Purge Rejected Vendors</a><br>';
echo '<a href="admin.php?sAction=updateVersionRatings">Update Version Ratings</a><br>';
+ echo '<a href="admin.php?sAction=viewAppdbAdmins">View AppDB Admins</a><br>';
}
switch(getInput('sAction', $aClean))
@@ -267,9 +316,23 @@ switch(getInput('sAction', $aClean))
deleteOrphanVersions();
break;
+ case 'purgeRejectedDistributions':
+ purgeRejectedDistributions();
+ break;
+
+ case 'purgeRejectedVendors':
+ purgeRejectedVendors();
+ break;
+
case 'updateVersionRatings':
updateVersionRatings();
break;
+
+ case 'viewAppdbAdmins':
+ viewAppdbAdmins();
+ break;
+
+
default:
showChoices();
--
2.12.3
More information about the wine-patches
mailing list