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

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