---
UPGRADING | 4 ++++
support/schema/aur-schema.sql | 1 +
web/lang/cs.po | 2 +-
web/lang/de.po | 2 +-
web/lang/el_GR.po | 2 +-
web/lang/fr.po | 2 +-
web/lang/he.po | 2 +-
web/lang/hr.po | 2 +-
web/lang/hu.po | 2 +-
web/lang/it.po | 2 +-
web/lang/nb_NO.po | 2 +-
web/lang/pl.po | 2 +-
web/lang/ro.po | 2 +-
web/lang/ru.po | 2 +-
web/lang/sr.po | 2 +-
web/lang/tr.po | 2 +-
web/lang/uk.po | 2 +-
web/lang/zh_CN.po | 2 +-
web/lib/pkgfuncs.inc | 3 ++-
web/template/pkg_details.php | 3 ++-
20 files changed, 25 insertions(+), 18 deletions(-)
diff --git a/UPGRADING b/UPGRADING
index 743f404..99c5d1a 100644
--- a/UPGRADING
+++ b/UPGRADING
@@ -1,6 +1,10 @@
Upgrading
=========
+From 1.7.0
+----------
+ALTER TABLE Packages ADD OutOfDateTS BIGINT UNSIGNED NOT NULL;
+
From 1.6.0 to 1.7.0
-------------------
ALTER TABLE Users ADD Salt CHAR(32) NOT NULL DEFAULT '';
diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql
index 250d405..15705a3 100644
--- a/support/schema/aur-schema.sql
+++ b/support/schema/aur-schema.sql
@@ -120,6 +120,7 @@ CREATE TABLE Packages (
LocationID TINYINT UNSIGNED NOT NULL DEFAULT 1,
NumVotes INTEGER UNSIGNED NOT NULL DEFAULT 0,
OutOfDate TINYINT UNSIGNED DEFAULT 0,
+ OutOfDateTS BIGINT UNSIGNED NOT NULL,
SubmittedTS BIGINT UNSIGNED NOT NULL,
ModifiedTS BIGINT UNSIGNED NOT NULL,
SubmitterUID INTEGER UNSIGNED NOT NULL DEFAULT 0, -- who submitted it?
diff --git a/web/lang/cs.po b/web/lang/cs.po
index e430d05..214df00 100644
--- a/web/lang/cs.po
+++ b/web/lang/cs.po
@@ -15,7 +15,7 @@ global $_t;
$_t["Search by"] = "Vyhledat dle";
-$_t["This package has been flagged out of date."] = "BalÃÄek byl oznaÄen jako zastaralý.";
+$_t["This package has been flagged out of date"] = "BalÃÄek byl oznaÄen jako zastaralý";
$_t["Voted"] = "Hlasováno";
diff --git a/web/lang/de.po b/web/lang/de.po
index 929e6f8..bbaa16b 100644
--- a/web/lang/de.po
+++ b/web/lang/de.po
@@ -390,7 +390,7 @@ $_t["You are not allowed to access this area."] = "Es ist Dir nicht erlaubt, auf
$_t["Unsafe"] = "Unsicher";
-$_t["This package has been flagged out of date."] = "Dieses Paket wurde als veraltet markiert.";
+$_t["This package has been flagged out of date"] = "Dieses Paket wurde als veraltet markiert";
$_t["The above files have been verified (by %h%s%h) and are safe to use."] = "Die obigen Dateien wurden (von %h%s%h) als sicher markiert.";
diff --git a/web/lang/el_GR.po b/web/lang/el_GR.po
index 5f5c96c..4118c18 100644
--- a/web/lang/el_GR.po
+++ b/web/lang/el_GR.po
@@ -86,7 +86,7 @@ $_t["Unsupported packages are user produced content. Any use of the provided fil
$_t["Search by"] = "ÎναζήÏηÏη καÏά";
-$_t["This package has been flagged out of date."] = "ÎÏ
ÏÏ Ïο ÏακÎÏο ÎÏει ÏαÏακÏηÏιÏÏεί ÏαÏÏÏημÎνο.";
+$_t["This package has been flagged out of date"] = "ÎÏ
ÏÏ Ïο ÏακÎÏο ÎÏει ÏαÏακÏηÏιÏÏεί ÏαÏÏÏημÎνο";
$_t["Voted"] = "ΨηÏιÏμÎνο";
diff --git a/web/lang/fr.po b/web/lang/fr.po
index 596f4af..1ce1896 100644
--- a/web/lang/fr.po
+++ b/web/lang/fr.po
@@ -405,7 +405,7 @@ $_t["Out of Date"] = "Périmé";
$_t["Required by"] = "Requis par";
-$_t["This package has been flagged out of date."] = "Ce paquet a été marqué comme périmé.";
+$_t["This package has been flagged out of date"] = "Ce paquet a été marqué comme périmé";
$_t["Toggle Notify"] = "Suivre/Ne plus suivre";
diff --git a/web/lang/he.po b/web/lang/he.po
index d5c19b7..ad0c558 100644
--- a/web/lang/he.po
+++ b/web/lang/he.po
@@ -14,7 +14,7 @@ global $_t;
$_t["Confirm your e-mail address:"] = "××ש×ר ×ת××ת ×××××´× ×©××";
-$_t["This package has been flagged out of date."] = "×××××× ×ס××× ×ª ××× ×¢××× ×ת.";
+$_t["This package has been flagged out of date"] = "×××××× ×ס××× ×ª ××× ×¢××× ×ת";
$_t["Missing a required field."] = "ש×× ××ר×× ×סר.";
diff --git a/web/lang/hr.po b/web/lang/hr.po
index 93028b7..4d46fec 100644
--- a/web/lang/hr.po
+++ b/web/lang/hr.po
@@ -162,7 +162,7 @@ $_t["Description"] = "Opis";
$_t["unknown"] = "nepoznato";
-$_t["This package has been flagged out of date."] = "Paket je obilježen kao zastarijeli.";
+$_t["This package has been flagged out of date"] = "Paket je obilježen kao zastarijeli";
$_t["No New Comment Notification"] = "Nemoj me više obavještavati o novim komentarima";
diff --git a/web/lang/hu.po b/web/lang/hu.po
index e198ac3..54f3a12 100644
--- a/web/lang/hu.po
+++ b/web/lang/hu.po
@@ -6,7 +6,7 @@ global $_t;
$_t["Search by"] = "Keresés eszerint";
-$_t["This package has been flagged out of date."] = "Ez a csomag elavultnak van jelölve.";
+$_t["This package has been flagged out of date"] = "Ez a csomag elavultnak van jelölve";
$_t["Missing a required field."] = "Egy kötelezŠmezŠmegadása hiányzik.";
diff --git a/web/lang/it.po b/web/lang/it.po
index 4bd0727..5876c45 100644
--- a/web/lang/it.po
+++ b/web/lang/it.po
@@ -411,7 +411,7 @@ $_t["Required by"] = "Richiesto da";
$_t["The above files have been verified (by %h%s%h) and are safe to use."] = "I file sono stati verificati (da %h%s%h) ed il loro utilizzo è da considerarsi sicuro.";
-$_t["This package has been flagged out of date."] = "Questo pacchetto è stato contrassegnato come non aggiornato.";
+$_t["This package has been flagged out of date"] = "Questo pacchetto è stato contrassegnato come non aggiornato";
$_t["Toggle Notify"] = "Rimuovi la notifica";
diff --git a/web/lang/nb_NO.po b/web/lang/nb_NO.po
index 687e639..1b8b20e 100644
--- a/web/lang/nb_NO.po
+++ b/web/lang/nb_NO.po
@@ -14,7 +14,7 @@ global $_t;
$_t["Search by"] = "Søk etter";
-$_t["This package has been flagged out of date."] = "Denne pakken har blitt merket som utdatert.";
+$_t["This package has been flagged out of date"] = "Denne pakken har blitt merket som utdatert";
$_t["Voted"] = "Stemmet";
diff --git a/web/lang/pl.po b/web/lang/pl.po
index 967ab36..e337bb1 100644
--- a/web/lang/pl.po
+++ b/web/lang/pl.po
@@ -367,7 +367,7 @@ $_t["unknown"] = "nieznana";
$_t["Out of Date"] = "Nieaktualny";
-$_t["This package has been flagged out of date."] = "Ten pakiet zostaÅ oznaczony jako nieaktualny.";
+$_t["This package has been flagged out of date"] = "Ten pakiet zostaÅ oznaczony jako nieaktualny";
$_t["Required by"] = "Wymagane przez";
diff --git a/web/lang/ro.po b/web/lang/ro.po
index 0118f24..3a41477 100644
--- a/web/lang/ro.po
+++ b/web/lang/ro.po
@@ -14,7 +14,7 @@ global $_t;
$_t["Search by"] = "CautÄ dupÄ";
-$_t["This package has been flagged out of date."] = "Acest pachet a fost marcat ca Neactualizat.";
+$_t["This package has been flagged out of date"] = "Acest pachet a fost marcat ca Neactualizat";
$_t["Voted"] = "Votat";
diff --git a/web/lang/ru.po b/web/lang/ru.po
index 2382b35..020f230 100644
--- a/web/lang/ru.po
+++ b/web/lang/ru.po
@@ -389,7 +389,7 @@ $_t["You are not allowed to access this area."] = "ÐоÑÑÑп ÑÑда вам
$_t["Unsafe"] = "ÐебезопанÑй";
-$_t["This package has been flagged out of date."] = "ÐÐ°ÐºÐµÑ Ð¾ÑмеÑен как ÑÑÑаÑевÑий.";
+$_t["This package has been flagged out of date"] = "ÐÐ°ÐºÐµÑ Ð¾ÑмеÑен как ÑÑÑаÑевÑий";
$_t["The above files have been verified (by %h%s%h) and are safe to use."] = "Ð¤Ð°Ð¹Ð»Ñ Ð¿ÑовеÑÐµÐ½Ñ %h%s%h и могÑÑ Ð±ÑÑÑ Ð±ÐµÐ·Ð¾Ð¿Ð°Ñно иÑполÑзованÑ.";
diff --git a/web/lang/sr.po b/web/lang/sr.po
index ddd54da..c743728 100644
--- a/web/lang/sr.po
+++ b/web/lang/sr.po
@@ -14,7 +14,7 @@ global $_t;
$_t["Search by"] = "Pretražuje se";
-$_t["This package has been flagged out of date."] = "Paket je oznaÄen kao zastareo";
+$_t["This package has been flagged out of date"] = "Paket je oznaÄen kao zastareo";
$_t["Missing a required field."] = "Nedostaje neophodno polje.";
diff --git a/web/lang/tr.po b/web/lang/tr.po
index 5d41840..df608ac 100644
--- a/web/lang/tr.po
+++ b/web/lang/tr.po
@@ -400,7 +400,7 @@ $_t["Required by"] = "İhtiyaç duyan";
$_t["The above files have been verified (by %h%s%h) and are safe to use."] = "Yukarıdaki dosyalar doÄrulandı (%h%s%h tarafından) ve kullanım için güvenli olarak iÅaretlendi.";
-$_t["This package has been flagged out of date."] = "Bu paket güncel deÄil olarak iÅaretlendi.";
+$_t["This package has been flagged out of date"] = "Bu paket güncel deÄil olarak iÅaretlendi";
$_t["Toggle Notify"] = "Toggle Notify";
diff --git a/web/lang/uk.po b/web/lang/uk.po
index 007c30e..3023f78 100644
--- a/web/lang/uk.po
+++ b/web/lang/uk.po
@@ -170,7 +170,7 @@ $_t["Description"] = "ÐпиÑ";
$_t["unknown"] = "невÑдомо";
-$_t["This package has been flagged out of date."] = "ЦÑÐ¾Ð¼Ñ Ð¿Ð°ÐºÑÐ½ÐºÑ Ð¿ÑизнаÑено мÑÑÐºÑ ÐаÑÑаÑÑлий";
+$_t["This package has been flagged out of date"] = "ЦÑÐ¾Ð¼Ñ Ð¿Ð°ÐºÑÐ½ÐºÑ Ð¿ÑизнаÑено мÑÑÐºÑ ÐаÑÑаÑÑлий";
$_t["No New Comment Notification"] = "ÐÐµÐ¼Ð°Ñ Ð½Ð¾Ð²Ð¸Ñ
ÑповÑÑÐµÐ½Ñ Ð¿Ñо коменÑаÑÑ";
diff --git a/web/lang/zh_CN.po b/web/lang/zh_CN.po
index 19cc4f6..42d0f09 100644
--- a/web/lang/zh_CN.po
+++ b/web/lang/zh_CN.po
@@ -17,7 +17,7 @@ global $_t;
$_t["Search by"] = "æç´¢";
-$_t["This package has been flagged out of date."] = "æ¤å
已被æ 记为è¿æã";
+$_t["This package has been flagged out of date"] = "æ¤å
已被æ 记为è¿æã";
$_t["Missing a required field."] = "缺å°å¿
填项ã";
diff --git a/web/lib/pkgfuncs.inc b/web/lib/pkgfuncs.inc
index 5605daa..02c9c1c 100644
--- a/web/lib/pkgfuncs.inc
+++ b/web/lib/pkgfuncs.inc
@@ -643,7 +643,8 @@ function pkg_flag ($atype, $ids, $action = True) {
}
$ood = $action ? 1 : 0;
- $q = "UPDATE Packages SET OutOfDate = " . $ood;
+ $q = "UPDATE Packages SET OutOfDate = " . $ood . ",";
+ $q.= " OutOfDateTS = UNIX_TIMESTAMP()";
$q.= " WHERE ID IN (" . $flag . ")";
db_query($q, $dbh);
diff --git a/web/template/pkg_details.php b/web/template/pkg_details.php
index 9c76ab3..a0996b9 100644
--- a/web/template/pkg_details.php
+++ b/web/template/pkg_details.php
@@ -35,6 +35,7 @@ $license = empty($row['License']) ? $msg : $row['License'];
# Print the timestamps for last updates
$updated_time = ($row["ModifiedTS"] == 0) ? "(unknown)" : gmdate("r", intval($row["ModifiedTS"]));
$submitted_time = ($row["SubmittedTS"] == 0) ? "(unknown)" : gmdate("r", intval($row["SubmittedTS"]));
+$out_of_date_time = ($row["OutOfDateTS"] == 0) ? "(unknown)" : gmdate("r", intval($row["OutOfDateTS"]));
?>
<div class="pgbox">
@@ -70,7 +71,7 @@ $submitted_time = ($row["SubmittedTS"] == 0) ? "(unknown)" : gmdate("r", intval(
}
if ($row["OutOfDate"] == 1) {
- echo "<br /><span class='f6'>".__("This package has been flagged out of date.")."</span>";
+ echo "<br /><span class='f6'>".__("This package has been flagged out of date")." (".$out_of_date_time.")</span>";
}
?>
</p>
--
1.7.3