[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