[AppDB] Add getInactiveMaintainers function

Rosanne DiMesio dimesio at earthlink.net
Thu Aug 3 09:02:59 CDT 2017


Signed-off-by: Rosanne DiMesio <dimesio at earthlink.net>
---
 include/maintainer.php | 8 ++++++++
 1 file changed, 8 insertions(+)

diff --git a/include/maintainer.php b/include/maintainer.php
index f4fd822..f45c19d 100644
--- a/include/maintainer.php
+++ b/include/maintainer.php
@@ -545,6 +545,14 @@ class maintainer
     {
         return self::getMaintainerCountForUserId($oUser->iUserId, $bSuperMaintainer);
     }
+    
+    // gets maintainers who have not logged in in the specified number of months 
+    public static function getInactiveMaintainers($iMonths)
+    {
+       $sQuery = "SELECT * FROM appMaintainers, user_list WHERE appMaintainers.userId = user_list.userid 
+           AND stamp <= DATE_SUB(CURDATE(), INTERVAL $iMonths MONTH)";       
+        return query_parameters($sQuery);
+    }
 
     /**
      * get the applications and versions that this user maintains 
-- 
2.12.3




More information about the wine-patches mailing list