[aur-dev] [PATCH] Add timestamp when a package is flagged out-of-date (FS#20848).

Lukas Fleischer Thu, 30 Sep 2010 09:20:02 -0700

---
 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

[aur-dev] [PATCH] Add timestamp when a package is flagged out-of-date (FS#20848).

Reply via email to