Module: appdb
Branch: master
Commit: d90969fd145eb63572fb809e390a91197a802788
URL: http://source.winehq.org/git/appdb.git/?a=commit;h=d90969fd145eb63572fb809e…
Author: Rosanne DiMesio <dimesio(a)earthlink.net>
Date: Thu Aug 10 12:12:18 2017 -0500
Add case Cancel to processForm()
Most of the error_log entries are due to its absence.
Also corrects a typo in a nearby comment.
Signed-off-by: Rosanne DiMesio <dimesio(a)earthlink.net>
Signed-off-by: Jeremy Newman <jnewman(a)codeweavers.com>
---
include/objectManager.php | 5 ++++-
1 file changed, 4 insertions(+), 1 deletion(-)
diff --git a/include/objectManager.php b/include/objectManager.php
index 36df560..2f19b64 100644
--- a/include/objectManager.php
+++ b/include/objectManager.php
@@ -1456,13 +1456,16 @@ class ObjectManager
break;
case "Delete":
- /* Heere we call an objectManager function instead
+ /* Here we call an objectManager function instead
of a function of the object's class. Thus we
need to store the object so changes in
getOutputEditorValues() are caught. */
$this->oObject = $oObject;
$this->delete_entry($aClean['sReplyText']);
break;
+
+ case "Cancel":
+ break;
default:
// shouldn't end up here, log the submit type that landed us here
Module: appdb
Branch: master
Commit: 272e99660686480c967cc7afef5f1c54bc167ef2
URL: http://source.winehq.org/git/appdb.git/?a=commit;h=272e99660686480c967cc7af…
Author: Rosanne DiMesio <dimesio(a)earthlink.net>
Date: Thu Aug 10 10:03:08 2017 -0500
Update cleanup cron script
Removes two unused functions and adds two new ones. Removes
individual email notices from the votes and screenshots cleanups.
Signed-off-by: Rosanne DiMesio <dimesio(a)earthlink.net>
Signed-off-by: Jeremy Newman <jnewman(a)codeweavers.com>
---
cron/cleanup.php | 123 +++++++++++++------------------------------------------
1 file changed, 28 insertions(+), 95 deletions(-)
diff --git a/cron/cleanup.php b/cron/cleanup.php
index 08ba100..dbf930d 100644
--- a/cron/cleanup.php
+++ b/cron/cleanup.php
@@ -1,7 +1,7 @@
#!/usr/bin/php
<?php
/**************************************************/
-/* this script has to be run once a month by cron */
+/* this script has to be run daily by cron */
/* it's purpose is to clean the user's table. */
/**************************************************/
@@ -16,9 +16,8 @@ notifyAdminsOfCleanupStart();
/* check to see if there are orphaned versions in the database */
orphanVersionCheck();
-/* report error log entries to admins and flush the error log after doing so */
-// temporarily disabled - it apperas we have too many errors
-// reportErrorLogEntries();
+// delete error logs over 12 months old
+deleteOldErrorLogs();
/* remove screenshots that are missing their screenshot and thumbnail files */
removeScreenshotsWithMissingFiles();
@@ -28,12 +27,12 @@ removeScreenshotsWithMissingFiles();
/* status since they aren't really maintaining the application/version */
maintainerCheck();
+// remove maintainers who have not logged in in over 24 months
+deleteInactiveMaintainers();
+
/* remove votes for versions that have been deleted */
cleanupVotes();
-/* Updates the rating info for all versions based on test results */
-//updateRatings();
-
function notifyAdminsOfCleanupStart()
{
@@ -54,34 +53,12 @@ function orphanVersionCheck()
$sQuery = "select versionId, versionName from appVersion where appId = 0 and state != 'deleted'";
$hResult = query_appdb($sQuery);
- $found_orphans = false;
-
- $sMsg = "Found these orphaned versions in the database with\r\n";
- $sMsg.= "this sql command '".$sQuery."'\r\n";
-
- /* don't report anything if no orphans are found */
- if(query_num_rows($hResult) == 0)
- return;
-
- $sMsg .= "versionId/name\r\n";
- while($oRow = query_fetch_object($hResult))
- {
- $sMsg .= $oRow->versionId."/".$oRow->versionName."\r\n";
- }
-
- $sSubject = $sEmailSubject."Orphan version cleanup\r\n";
-
- $sEmail = user::getAdminEmails(); /* get list admins */
- if($sEmail)
- mail_appdb($sEmail, $sSubject, $sMsg);
}
-// report the database error log entries to the mailing list
-function reportErrorLogEntries()
+function deleteOldErrorLogs()
{
- global $sEmailSubject;
- error_log::mail_admins_error_log($sEmailSubject);
- error_log::flush();
+ $sQuery = "DELETE FROM error_log WHERE submitTime <= DATE_SUB(CURDATE(), INTERVAL '12' MONTH)";
+ $hResult = query_parameters($sQuery);
}
// returns an array of iScreenshotIds of screenshots that are
@@ -118,39 +95,7 @@ function getMissingScreenshotArray()
function removeScreenshotsWithMissingFiles()
{
- global $sEmailSubject;
-
- $aMissingScreenshotIds = getMissingScreenshotArray();
-
- if(sizeof($aMissingScreenshotIds))
- {
- $sPlural = (sizeof($aMissingScreenshotIds) == 1) ? "" : "s";
- // build the email to admins about what we are doing
- $sMsg = "Found ".count($aMissingScreenshotIds)." screenshot$sPlural with missing files.\r\n";
-
- if($sPlural)
- $sMsg.= "Deleting these screenshots.\r\n";
- else
- $sMsgm.= "Deleting it.\r\n";
-
- // add the screenshot ids to the email so we can see which screenshots are
- // going to be deleted
- $sMsg.="\r\n";
- $sMsg.="Screenshot ID$sPlural:\r\n";
- foreach($aMissingScreenshotIds as $iScreenshotId)
- {
- $sMsg.=$iScreenshotId."\r\n";
- }
- } else
- {
- $sMsg = "No screenshot entries with missing files were found.\r\n";
- }
-
- $sSubject = $sEmailSubject."Missing screenshot cleanup\r\n";
-
- $sEmail = user::getAdminEmails(); /* get list admins */
- if($sEmail)
- mail_appdb($sEmail, $sSubject, $sMsg);
+ $aMissingScreenshotIds = getMissingScreenshotArray();
// log in as admin user with user id 1000
// NOTE: this is a bit of a hack but we need admin
@@ -178,6 +123,24 @@ function maintainerCheck()
maintainer::notifyMaintainersOfQueuedData();
}
+// removes maintainers who have not logged in in over 24 months
+function deleteInactiveMaintainers()
+{
+ $hResult = maintainer::getInactiveMaintainers(24);
+ $i = 0;
+ while($oRow = query_fetch_object($hResult))
+ {
+ $oMaintainer = new maintainer(null, $oRow);
+ $oMaintainer->delete();
+ $oUser = new User($oRow->userid);
+ $sEmail = $oUser->sEmail;
+ $sSubject = "Maintainer status removed";
+ $sMsg = "Your maintainer status has been removed because you have not logged into the AppDB in over 24 months.";
+ mail_appdb($sEmail, $sSubject, $sMsg);
+ $i++;
+ }
+}
+
/* remove votes for versions that have been deleted */
function cleanupVotes()
{
@@ -199,36 +162,6 @@ function cleanupVotes()
else
$iFailed++;
}
-
- $sEmails = user::getAdminEmails(); // only admins
-
- if($sEmails)
- {
- global $sEmailSubject;
- $sSubject = $sEmailSubject . 'Vote Cleanup';
- $sPlural = ($iDeleted == 1) ? '' : 's';
- $sMsg = "Removed $iDeleted vote$sPlural cast for deleted versions\n";
- if($iFailed)
- {
- $sPlural = ($iFailed == 1) ? '' : 's';
- $sMsg .= "WARNING: Failed to delete $iFailed vote$sPlural\n";
- }
- mail_appdb($sEmails, $sSubject, $sMsg);
- }
-}
-
-function updateRatings()
-{
- $hResult = query_parameters("SELECT * FROM appVersion");
-
- if(!$hResult)
- return;
-
- while($oRow = query_fetch_object($hResult))
- {
- $oVersion = new version(0, $oRow);
- $oVersion->updateRatingInfo();
- }
}
?>
Module: website
Branch: master
Commit: f9f86ad8ab6e9b035d6862a2931c16c17e4464e0
URL: http://source.winehq.org/git/website.git/?a=commit;h=f9f86ad8ab6e9b035d6862…
Author: Julian Rüger <jr98(a)gmx.net>
Date: Tue Aug 8 17:18:49 2017 +0200
German translation for release 2.14
Signed-off-by: Julian Rüger <jr98(a)gmx.net>
Signed-off-by: Jeremy Newman <jnewman(a)codeweavers.com>
---
news/de/2017080301.xml | 16 ++++++++++++++++
1 file changed, 16 insertions(+)
diff --git a/news/de/2017080301.xml b/news/de/2017080301.xml
new file mode 100644
index 0000000..e7ba544
--- /dev/null
+++ b/news/de/2017080301.xml
@@ -0,0 +1,16 @@
+<news>
+<date>3. August 2017</date>
+<title>Wine 2.14 freigegeben</title>
+<body>
+<p> Die Entwicklungsversion 2.14 von Wine ist jetzt verfügbar.</p>
+<p> <a href="{$root}/announce/2.14">Neuerungen (en)</a> in dieser Version:</p>
+<ul>
+ <li>Aktualisierte Mono-Engine mit verschiedenen Fehlerkorrekturen.</li>
+ <li>Workarounds für C++ calling conventions im IDL-Compiler.</li>
+ <li>Z-Order-Unterstützung im Android-Grafiktreiber.</li>
+ <li>Skalierbare Mauszeiger unter macOS.</li>
+ <li>Diverse Fehlerkorrekturen.</li>
+</ul>
+<p>Der Quelltext ist ab sofort <a href="//dl.winehq.org/wine/source/2.x/wine-2.14.tar.xz">verfügbar</a>.
+Binärpakete werden gerade erstellt und stehen bald auf den jeweiligen <a href="{$root}/download">Downloadseiten</a> zur Verfügung.
+</p></body></news>