Rosanne DiMesio : Add updateVersionRatings function

[Jeremy Newman]

Module: appdb
Branch: master
Commit: 55d0546e94d725687a9b58641feb14181397fe6f
URL:    http://source.winehq.org/git/appdb.git/?a=commit;h=55d0546e94d725687a9b58641...

Author: Rosanne DiMesio 
Date:   Wed Jun 14 09:41:41 2017 -0500

Add updateVersionRatings function

Adds a function to the control center to enable admins to
force an update of the version ratings cached in the appVersion table.

Signed-off-by: Rosanne DiMesio 
Signed-off-by: Jeremy Newman

---

admin.php | 24 ++++++++++++++++++++++--
 1 file changed, 22 insertions(+), 2 deletions(-)

diff --git a/admin.php b/admin.php
index f38924d..79fbd58 100644
--- a/admin.php
+++ b/admin.php
@@ -220,13 +220,29 @@ function deleteOrphanVersions()
     echo "Deleted ".query_affected_rows()." orphan versions.<br>";
 }

+function updateVersionRatings()
+{ 
+    $hResult = version::objectGetEntries('accepted');
+
+    $i = 0;
+    while($oRow = query_fetch_object($hResult))
+    {
+        $oVersion = new version(null, $oRow);
+        $oVersion->updateRatingInfo();
+        $i++;
+    }
+
+    echo "Updated $i entries";
+}
+
 function showChoices()
 {
     echo '<a href="admin.php?sAction=fixNoteLinks">Fix/Show note links</a><br />';
     echo '<a href="admin.php?sAction=updateAppMaintainerStates">Update application maintainer states</a><br />';
     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=deleteOrphanVersions">Delete Orphan Versions</a><br>';
+    echo '<a href="admin.php?sAction=updateVersionRatings">Update Version Ratings</a><br>';
 }

switch(getInput('sAction', $aClean))
@@ -249,7 +265,11 @@ switch(getInput('sAction', $aClean))

case 'deleteOrphanVersions':
         deleteOrphanVersions();
-        break;   
+        break;  
+        
+    case 'updateVersionRatings':
+        updateVersionRatings();
+        break;

default:
         showChoices();