[aur-dev] [PATCH] Add timestamp when a package is flagged out-of-date (FS#20848).
Lukas Fleischer
archlinux at cryptocrack.de
Tue Oct 5 22:08:33 EDT 2010
---
UPGRADING | 6 ++++++
support/schema/aur-schema.sql | 3 +--
web/html/pkgsubmit.php | 2 +-
web/lang/ca.po | 2 +-
web/lang/cs.po | 2 +-
web/lang/de.po | 4 ++--
web/lang/el_GR.po | 2 +-
web/lang/es.po | 2 +-
web/lang/fr.po | 4 ++--
web/lang/he.po | 2 +-
web/lang/hr.po | 2 +-
web/lang/hu.po | 2 +-
web/lang/it.po | 4 ++--
web/lang/nb_NO.po | 2 +-
web/lang/pl.po | 2 +-
web/lang/pt.po | 2 +-
web/lang/ro.po | 2 +-
web/lang/ru.po | 4 ++--
web/lang/sr.po | 2 +-
web/lang/tr.po | 2 +-
web/lang/uk.po | 2 +-
web/lang/zh_CN.po | 2 +-
web/lib/aurjson.class.php | 2 +-
web/lib/pkgfuncs.inc | 13 +++++++++----
web/lib/stats.inc | 2 +-
web/template/actions_form.php | 2 +-
web/template/pkg_details.php | 5 +++--
web/template/pkg_search_results.php | 2 +-
28 files changed, 47 insertions(+), 36 deletions(-)
diff --git a/UPGRADING b/UPGRADING
index 743f404..bbf60f0 100644
--- a/UPGRADING
+++ b/UPGRADING
@@ -1,6 +1,12 @@
Upgrading
=========
+From 1.7.0 to 1.8.0
+-------------------
+ALTER TABLE Packages ADD OutOfDateTS BIGINT UNSIGNED NULL DEFAULT NULL;
+UPDATE Packages SET OutOfDateTS = UNIX_TIMESTAMP() WHERE OutOfDate = 1;
+ALTER TABLE Packages DROP OutOfDate;
+
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..93ec9a0 100644
--- a/support/schema/aur-schema.sql
+++ b/support/schema/aur-schema.sql
@@ -119,7 +119,7 @@ CREATE TABLE Packages (
License CHAR(40) NOT NULL DEFAULT '',
LocationID TINYINT UNSIGNED NOT NULL DEFAULT 1,
NumVotes INTEGER UNSIGNED NOT NULL DEFAULT 0,
- OutOfDate TINYINT UNSIGNED DEFAULT 0,
+ OutOfDateTS BIGINT UNSIGNED NULL DEFAULT NULL,
SubmittedTS BIGINT UNSIGNED NOT NULL,
ModifiedTS BIGINT UNSIGNED NOT NULL,
SubmitterUID INTEGER UNSIGNED NOT NULL DEFAULT 0, -- who submitted it?
@@ -130,7 +130,6 @@ CREATE TABLE Packages (
INDEX (CategoryID),
INDEX (LocationID),
INDEX (DummyPkg),
- INDEX (OutOfDate),
INDEX (NumVotes),
INDEX (SubmitterUID),
INDEX (MaintainerUID),
diff --git a/web/html/pkgsubmit.php b/web/html/pkgsubmit.php
index 6f7a669..5ce945d 100644
--- a/web/html/pkgsubmit.php
+++ b/web/html/pkgsubmit.php
@@ -313,7 +313,7 @@ if ($_COOKIE["AURSID"]):
}
# Update package data
- $q = sprintf("UPDATE Packages SET ModifiedTS = UNIX_TIMESTAMP(), Name = '%s', Version = '%s-%s', License = '%s', Description = '%s', URL = '%s', LocationID = 2, FSPath = '%s', URLPath = '%s', OutOfDate = 0 WHERE ID = %d",
+ $q = sprintf("UPDATE Packages SET ModifiedTS = UNIX_TIMESTAMP(), Name = '%s', Version = '%s-%s', License = '%s', Description = '%s', URL = '%s', LocationID = 2, FSPath = '%s', URLPath = '%s', OutOfDateTS = NULL WHERE ID = %d",
mysql_real_escape_string($new_pkgbuild['pkgname']),
mysql_real_escape_string($new_pkgbuild['pkgver']),
mysql_real_escape_string($new_pkgbuild['pkgrel']),
diff --git a/web/lang/ca.po b/web/lang/ca.po
index 72118f6..0f6ee45 100644
--- a/web/lang/ca.po
+++ b/web/lang/ca.po
@@ -367,7 +367,7 @@ $_t["You must be logged in before you can get notifications on comments."] = "He
$_t["You must be logged in before you can vote for packages."] = "Heu d'identificar-vos abans de votar paquets.";
-$_t["The selected packages have been flagged out-of-date."] = "Els paquets seleccionats s'han marcat com No-Actualitzats.";
+$_t["The selected packages have been flagged out-of-date"] = "Els paquets seleccionats s'han marcat com No-Actualitzats";
$_t["The selected packages have been deleted."] = "Els paquets seleccionats s'han esborrat.";
diff --git a/web/lang/cs.po b/web/lang/cs.po
index e430d05..dc2be9d 100644
--- a/web/lang/cs.po
+++ b/web/lang/cs.po
@@ -335,7 +335,7 @@ $_t["Proposal"] = "Návrh";
$_t["Error trying to unpack upload - PKGBUILD does not exist."] = "Došlo k chybě při snaze rozbalit archiv - PKGBUILD nenalezen.";
-$_t["The selected packages have been flagged out-of-date."] = "Zvoleným balíčkům byl nastaven příznak zastaralé.";
+$_t["The selected packages have been flagged out-of-date"] = "Zvoleným balíčkům byl nastaven příznak zastaralé";
$_t["Description"] = "Popis";
diff --git a/web/lang/de.po b/web/lang/de.po
index 929e6f8..ec38876 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.";
@@ -416,7 +416,7 @@ $_t["You must be logged in before you can get notifications on comments."] = "Du
$_t["You must be logged in before you can vote for packages."] = "Du mußt dich anmelden, um für ein Paket stimmen zu können.";
-$_t["The selected packages have been flagged out-of-date."] = "Die gewählten Pakete wurden als \"Veraltet\" markiert.";
+$_t["The selected packages have been flagged out-of-date"] = "Die gewählten Pakete wurden als \"Veraltet\" markiert";
$_t["The selected packages have been deleted."] = "Die gewählten Pakete wurden gelöscht.";
diff --git a/web/lang/el_GR.po b/web/lang/el_GR.po
index 5f5c96c..530bcbe 100644
--- a/web/lang/el_GR.po
+++ b/web/lang/el_GR.po
@@ -406,7 +406,7 @@ $_t["Re-type password"] = "Πληκτρολογήστε ξανά τον κωδι
$_t["Error trying to unpack upload - PKGBUILD does not exist."] = "Σφάλμα κατά το ξεπακετάρισμα του ανεβασμένου αρχείου - δεν υπάρχει PKGBUILD.";
-$_t["The selected packages have been flagged out-of-date."] = "Τα συγκεκριμένα πακέτα έχουν επισημανθεί ως παρωχημένα.";
+$_t["The selected packages have been flagged out-of-date"] = "Τα συγκεκριμένα πακέτα έχουν επισημανθεί ως παρωχημένα";
$_t["Description"] = "Περιγραφή";
diff --git a/web/lang/es.po b/web/lang/es.po
index ee14310..7486bda 100644
--- a/web/lang/es.po
+++ b/web/lang/es.po
@@ -405,7 +405,7 @@ $_t["You must be logged in before you can get notifications on comments."] = "De
$_t["You must be logged in before you can vote for packages."] = "Debe identificarse antes de poder votar paquetes.";
-$_t["The selected packages have been flagged out-of-date."] = "Los paquetes seleccionados han sido marcados como desactualizados.";
+$_t["The selected packages have been flagged out-of-date"] = "Los paquetes seleccionados han sido marcados como desactualizados";
$_t["The selected packages have been deleted."] = "Los paquetes seleccionados se han borrado.";
diff --git a/web/lang/fr.po b/web/lang/fr.po
index 5728947..1280d5d 100644
--- a/web/lang/fr.po
+++ b/web/lang/fr.po
@@ -429,7 +429,7 @@ $_t["You did not select any packages to adopt."] = "Vous n'avez pas sélectionn
$_t["You must be logged in before you can get notifications on comments."] = "Vous devez vous identifier avant de pouvoir recevoir des notifications de commentaires.";
-$_t["The selected packages have been flagged out-of-date."] = "Les paquets sélectionnés ont été marqués comme périmés.";
+$_t["The selected packages have been flagged out-of-date"] = "Les paquets sélectionnés ont été marqués comme périmés";
$_t["The selected packages have been deleted."] = "Les paquets sélectionnés ont été supprimés.";
@@ -481,7 +481,7 @@ $_t["You must be logged in before you can get notifications on comments."] = "Vo
$_t["You must be logged in before you can vote for packages."] = "Vous devez être authentifié avant de pouvoir voter pour des paquets.";
-$_t["The selected packages have been flagged out-of-date."] = "Les paquets sélectionnés ont été marqués comme périmés.";
+$_t["The selected packages have been flagged out-of-date"] = "Les paquets sélectionnés ont été marqués comme périmés";
$_t["The selected packages have been deleted."] = "Les paquets sélectionnés ont été supprimés.";
diff --git a/web/lang/he.po b/web/lang/he.po
index d5c19b7..257c5f7 100644
--- a/web/lang/he.po
+++ b/web/lang/he.po
@@ -344,7 +344,7 @@ $_t["You did not select any packages to flag."] = "לא בחרת שום חביל
$_t["Error trying to unpack upload - PKGBUILD does not exist."] = "שגיאה בניסיון פריסת הקובץ שהועלה - PKGBUILD לא קיים.";
-$_t["The selected packages have been flagged out-of-date."] = "החבילות שנבחרו מסומנות כלא עדכניות.";
+$_t["The selected packages have been flagged out-of-date"] = "החבילות שנבחרו מסומנות כלא עדכניות";
$_t["Description"] = "תיאור";
diff --git a/web/lang/hr.po b/web/lang/hr.po
index 93028b7..527fb72 100644
--- a/web/lang/hr.po
+++ b/web/lang/hr.po
@@ -258,7 +258,7 @@ $_t["You must be logged in before you can get notifications on comments."] = "Mo
$_t["You must be logged in before you can vote for packages."] = "Morate se logirati da bi glasali za pakete.";
-$_t["The selected packages have been flagged out-of-date."] = "Odabrani paketi su obilježeni kao zastarijeli.";
+$_t["The selected packages have been flagged out-of-date"] = "Odabrani paketi su obilježeni kao zastarijeli";
$_t["The selected packages have been deleted."] = "Odabrani paketi su izbrisani.";
diff --git a/web/lang/hu.po b/web/lang/hu.po
index e198ac3..0c05307 100644
--- a/web/lang/hu.po
+++ b/web/lang/hu.po
@@ -324,7 +324,7 @@ $_t["Proposal"] = "Indítvány";
$_t["Error trying to unpack upload - PKGBUILD does not exist."] = "Hiba történt a feltöltes kicsomagolása közben - PKGBUILD nem létezik.";
-$_t["The selected packages have been flagged out-of-date."] = "A kiválasztott csomagok elavultnak lettek jelolve.";
+$_t["The selected packages have been flagged out-of-date"] = "A kiválasztott csomagok elavultnak lettek jelolve";
$_t["Description"] = "Leíras";
diff --git a/web/lang/it.po b/web/lang/it.po
index 4bd0727..e53398d 100644
--- a/web/lang/it.po
+++ b/web/lang/it.po
@@ -437,7 +437,7 @@ $_t["You must be logged in before you can get notifications on comments."] = "De
$_t["Leave the password fields blank to keep your same password."] = "Lascia i campi delle password vuoti per lasciarla inalterata.";
-$_t["The selected packages have been flagged out-of-date."] = "I pacchetti selezionati sono stati contrassegnati come non aggiornati.";
+$_t["The selected packages have been flagged out-of-date"] = "I pacchetti selezionati sono stati contrassegnati come non aggiornati";
$_t["The selected packages have been deleted."] = "I pacchetti selezionati sono stati rimossi.";
@@ -505,7 +505,7 @@ $_t["You must be logged in before you can get notifications on comments."] = "De
$_t["You must be logged in before you can vote for packages."] = "Devi autenticarti prima di poter votare i pacchetti.";
-$_t["The selected packages have been flagged out-of-date."] = "I pacchetti selezionati sono stati contrassegnati come non aggiornati.";
+$_t["The selected packages have been flagged out-of-date"] = "I pacchetti selezionati sono stati contrassegnati come non aggiornati";
$_t["The selected packages have been deleted."] = "I pacchetti selezionati sono stati eliminati.";
diff --git a/web/lang/nb_NO.po b/web/lang/nb_NO.po
index 687e639..040e084 100644
--- a/web/lang/nb_NO.po
+++ b/web/lang/nb_NO.po
@@ -332,7 +332,7 @@ $_t["You did not select any packages to flag."] = "Du valgte ingen pakker å fla
$_t["Error trying to unpack upload - PKGBUILD does not exist."] = "Feil oppstod under forsøk av å pakke ut opplasting - PKGBUILD finnes ikke.";
-$_t["The selected packages have been flagged out-of-date."] = "De valgte pakkene har blitt flagget som utdatert.";
+$_t["The selected packages have been flagged out-of-date"] = "De valgte pakkene har blitt flagget som utdatert";
$_t["Description"] = "Beskrivelse";
diff --git a/web/lang/pl.po b/web/lang/pl.po
index 967ab36..d946c5f 100644
--- a/web/lang/pl.po
+++ b/web/lang/pl.po
@@ -387,7 +387,7 @@ $_t["You do not have access to adopt packages."] = "Nie masz uprawnień do przej
$_t["You must be logged in before you can disown packages."] = "Musisz być zalogowany aby móc porzucać pakiety.";
$_t["Error trying to retrieve package details."] = "Błąd podczas pobierania informacji o pakiecie.";
$_t["You must be logged in before you can adopt packages."] = "Musisz być zalogowany aby móc przejmować pakiety.";
-$_t["The selected packages have been flagged out-of-date."] = "Wybrane pakiety zostały zaznaczone jako nieaktualne.";
+$_t["The selected packages have been flagged out-of-date"] = "Wybrane pakiety zostały zaznaczone jako nieaktualne";
$_t["You did not select any packages to flag."] = "Nie wybrałeś żadnych pakietów do zaznaczenia.";
$_t["The selected packages have been unflagged."] = "Wybrane pakiety zostały odznaczone.";
$_t["You must be logged in before you can unflag packages."] = "Musisz być zalogowany aby móc odznaczać pakiety.";
diff --git a/web/lang/pt.po b/web/lang/pt.po
index 117556c..fe5507e 100644
--- a/web/lang/pt.po
+++ b/web/lang/pt.po
@@ -411,7 +411,7 @@ $_t["You must be logged in before you can get notifications on comments."] = "Vo
$_t["You must be logged in before you can vote for packages."] = "Você deve efetuar o login antes de poder votar nos pacotes.";
-$_t["The selected packages have been flagged out-of-date."] = "Os pacotes selecionados foram marcados como desatualizados.";
+$_t["The selected packages have been flagged out-of-date"] = "Os pacotes selecionados foram marcados como desatualizados";
$_t["The selected packages have been deleted."] = "Os pacotes selecionados foram excluídos.";
diff --git a/web/lang/ro.po b/web/lang/ro.po
index 0118f24..530c276 100644
--- a/web/lang/ro.po
+++ b/web/lang/ro.po
@@ -332,7 +332,7 @@ $_t["You did not select any packages to flag."] = "Nu ai selectat niciun pachet
$_t["Error trying to unpack upload - PKGBUILD does not exist."] = "Eroarea la încercarea de a dezarhiva - PKGBUILD nu există.";
-$_t["The selected packages have been flagged out-of-date."] = "Pachetele selectate au fost marcate ca fiind Neactualizate.";
+$_t["The selected packages have been flagged out-of-date"] = "Pachetele selectate au fost marcate ca fiind Neactualizate";
$_t["Description"] = "Descriere";
diff --git a/web/lang/ru.po b/web/lang/ru.po
index 2382b35..45612dc 100644
--- a/web/lang/ru.po
+++ b/web/lang/ru.po
@@ -417,7 +417,7 @@ $_t["You did not select any packages to adopt."] = "Вы не выбрали н
$_t["You must be logged in before you can get notifications on comments."] = "Необходимо представиться для получения извещений о коментариях.";
-$_t["The selected packages have been flagged out-of-date."] = "Выбранные пакеты помечены как устаревшие.";
+$_t["The selected packages have been flagged out-of-date"] = "Выбранные пакеты помечены как устаревшие";
$_t["The selected packages have been deleted."] = "Выбранные пакеты удалены.";
@@ -471,7 +471,7 @@ $_t["You must be logged in before you can get notifications on comments."] = "В
$_t["You must be logged in before you can vote for packages."] = "Вы должны войти прежде чем голосовать.";
-$_t["The selected packages have been flagged out-of-date."] = "Выбраные пакеты помечены как устаревшие.";
+$_t["The selected packages have been flagged out-of-date"] = "Выбраные пакеты помечены как устаревшие";
$_t["The selected packages have been deleted."] = "Выбраные пакеты удалены.";
diff --git a/web/lang/sr.po b/web/lang/sr.po
index ddd54da..65e3fd1 100644
--- a/web/lang/sr.po
+++ b/web/lang/sr.po
@@ -332,7 +332,7 @@ $_t["Re-type password"] = "Ponovo unesite lozinku";
$_t["Error trying to unpack upload - PKGBUILD does not exist."] = "Greška pri raspakivanju pošiljke — ne postoji PKGBUILD.";
-$_t["The selected packages have been flagged out-of-date."] = "Izabrani paketi su označeni kao zastareli.";
+$_t["The selected packages have been flagged out-of-date"] = "Izabrani paketi su označeni kao zastareli";
$_t["Description"] = "Opis";
diff --git a/web/lang/tr.po b/web/lang/tr.po
index 5d41840..20d202e 100644
--- a/web/lang/tr.po
+++ b/web/lang/tr.po
@@ -423,7 +423,7 @@ $_t["You must be logged in before you can get notifications on comments."] = "Yo
$_t["You must be logged in before you can vote for packages."] = "Paketlere oy vermeden önce giriş yapmalısınız.";
-$_t["The selected packages have been flagged out-of-date."] = "Seçilen paketler güncelliğini yitirmiş olarak işaretlendi.";
+$_t["The selected packages have been flagged out-of-date"] = "Seçilen paketler güncelliğini yitirmiş olarak işaretlendi";
$_t["The selected packages have been deleted."] = "Seçilen paketler silindi.";
diff --git a/web/lang/uk.po b/web/lang/uk.po
index 007c30e..042f801 100644
--- a/web/lang/uk.po
+++ b/web/lang/uk.po
@@ -266,7 +266,7 @@ $_t["You must be logged in before you can get notifications on comments."] = "В
$_t["You must be logged in before you can vote for packages."] = "Ви повинні зайти, щоб мати змогу голосувати за пакунки.";
-$_t["The selected packages have been flagged out-of-date."] = "Для вибраних пакунків призначено мітку Застарілий.";
+$_t["The selected packages have been flagged out-of-date"] = "Для вибраних пакунків призначено мітку Застарілий";
$_t["The selected packages have been deleted."] = "Вибрані пакунки вилучено.";
diff --git a/web/lang/zh_CN.po b/web/lang/zh_CN.po
index 19cc4f6..93eadef 100644
--- a/web/lang/zh_CN.po
+++ b/web/lang/zh_CN.po
@@ -334,7 +334,7 @@ $_t["You did not select any packages to flag."] = "您没有选择要标记的
$_t["Error trying to unpack upload - PKGBUILD does not exist."] = "尝试解压上传的包发生错误 - 没有PKGBUILD文件。";
-$_t["The selected packages have been flagged out-of-date."] = "选择的包已被标记为过期。";
+$_t["The selected packages have been flagged out-of-date"] = "选择的包已被标记为过期";
$_t["Description"] = "描述";
diff --git a/web/lib/aurjson.class.php b/web/lib/aurjson.class.php
index a5b3f9e..ab1bdbf 100644
--- a/web/lib/aurjson.class.php
+++ b/web/lib/aurjson.class.php
@@ -21,7 +21,7 @@ class AurJSON {
private $exposed_methods = array('search','info','msearch');
private $fields = array('Packages.ID','Name','Version','CategoryID',
'Description', 'LocationID', 'URL','URLPath','License','NumVotes',
- 'OutOfDate');
+ '(OutOfDateTS IS NOT NULL) AS OutOfDate');
/**
* Handles post data, and routes the request.
diff --git a/web/lib/pkgfuncs.inc b/web/lib/pkgfuncs.inc
index 5605daa..0f45124 100644
--- a/web/lib/pkgfuncs.inc
+++ b/web/lib/pkgfuncs.inc
@@ -457,7 +457,7 @@ function pkg_search_page($SID="") {
PackageCategories.Category,
PackageLocations.Location,
Packages.Name, Packages.Version, Packages.Description, Packages.NumVotes,
- Packages.ID, Packages.OutOfDate
+ Packages.ID, Packages.OutOfDateTS
FROM Packages
LEFT JOIN Users ON (Packages.MaintainerUID = Users.ID) ";
@@ -510,7 +510,7 @@ function pkg_search_page($SID="") {
}
if (isset($_GET['outdated'])) {
- $q .= "AND OutOfDate = 1 ";
+ $q .= "AND OutOfDateTS IS NOT NULL ";
}
$order = $_GET["SO"] == 'd' ? 'DESC' : 'ASC';
@@ -642,8 +642,13 @@ function pkg_flag ($atype, $ids, $action = True) {
}
}
- $ood = $action ? 1 : 0;
- $q = "UPDATE Packages SET OutOfDate = " . $ood;
+ $q = "UPDATE Packages SET";
+ if ($action) {
+ $q.= " OutOfDateTS = UNIX_TIMESTAMP()";
+ }
+ else {
+ $q.= " OutOfDateTS = NULL";
+ }
$q.= " WHERE ID IN (" . $flag . ")";
db_query($q, $dbh);
diff --git a/web/lib/stats.inc b/web/lib/stats.inc
index 85c7e28..6a76558 100644
--- a/web/lib/stats.inc
+++ b/web/lib/stats.inc
@@ -59,7 +59,7 @@ function user_table($user, $dbh)
$maintainer_unsupported_count = db_cache_value(sprintf($base_q, 'unsupported'), $dbh,
$apc_prefix . 'user_unsupported_count:' . $escuser);
- $q = "SELECT count(*) FROM Packages,Users WHERE Packages.OutOfDate = 1 AND Packages.MaintainerUID = Users.ID AND Users.Username='" . $escuser . "'";
+ $q = "SELECT count(*) FROM Packages,Users WHERE Packages.OutOfDateTS IS NOT NULL AND Packages.MaintainerUID = Users.ID AND Users.Username='" . $escuser . "'";
$flagged_outdated = db_cache_value($q, $dbh,
$apc_prefix . 'user_flagged_outdated:' . $escuser);
diff --git a/web/template/actions_form.php b/web/template/actions_form.php
index d1559f5..41d8df9 100644
--- a/web/template/actions_form.php
+++ b/web/template/actions_form.php
@@ -27,7 +27,7 @@
echo " value='".__("UnNotify")."' title='".__("No New Comment Notification")."'> ";
}
-if ($row["OutOfDate"] == 0) {
+if ($row["OutOfDateTS"] === NULL) {
echo "<input type='submit' class='button' name='do_Flag'";
echo " value='".__("Flag Out-of-date")."'>\n";
} else {
diff --git a/web/template/pkg_details.php b/web/template/pkg_details.php
index 9c76ab3..2c5b666 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">
@@ -69,8 +70,8 @@ $submitted_time = ($row["SubmittedTS"] == 0) ? "(unknown)" : gmdate("r", intval(
print "<a href='$urlpath.tar.gz'>".__("Tarball")."</a> :: <a href='$urlpath'>".__("Files")."</a> :: <a href='$urlpath/PKGBUILD'>PKGBUILD</a></span>";
}
- if ($row["OutOfDate"] == 1) {
- echo "<br /><span class='f6'>".__("This package has been flagged out of date.")."</span>";
+ if ($row["OutOfDateTS"] !== NULL) {
+ echo "<br /><span class='f6'>".__("This package has been flagged out of date")." (".$out_of_date_time.")</span>";
}
?>
</p>
diff --git a/web/template/pkg_search_results.php b/web/template/pkg_search_results.php
index ab49c6b..bf00da5 100644
--- a/web/template/pkg_search_results.php
+++ b/web/template/pkg_search_results.php
@@ -46,7 +46,7 @@
$atype = account_from_sid($_COOKIE['AURSID']);
for ($i = 0; $row = mysql_fetch_assoc($result); $i++) {
(($i % 2) == 0) ? $c = "data1" : $c = "data2";
- if ($row["OutOfDate"]): $c = "outofdate"; endif;
+ if ($row["OutOfDateTS"] !== NULL): $c = "outofdate"; endif;
?>
<tr>
<?php if ($SID): ?>
--
1.7.3.1
More information about the aur-dev
mailing list