Rosanne DiMesio : Add getInactiveMaintainers function

[Jeremy Newman]

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

Author: Rosanne DiMesio <dimesio at earthlink.net>
Date:   Thu Aug  3 09:02:59 2017 -0500

Add getInactiveMaintainers function

Signed-off-by: Rosanne DiMesio <dimesio at earthlink.net>
Signed-off-by: Jeremy Newman <jnewman at codeweavers.com>

---

 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