From 3d2d81fbfa571d9473ce203fd8f56809e2ad476b Mon Sep 17 00:00:00 2001
From: Daniel Gustafsson <daniel@yesql.se>
Date: Tue, 25 Jul 2023 10:04:46 +0200
Subject: [PATCH] Fix broken links for book entries

A number of links to books had gone stale, this either replaces the link
with an update working one or removes the link completely leaving the
book entry unlinked.

This was discussed on -www and was also independently reported by
Akshat Jaimini <destrex271@gmail.com>.

Discussion: https://postgr.es/m/548027CC-7FCC-4B60-BB93-69DD7733B921@yesql.se
Discussion: CAMaW3VhyN-VsSyW0pJsDnBQWFeu0uYRb_oORfpp2-c=qKgtofA@mail.gmail.com
---
 templates/pages/docs/books.html | 42 +++++++++++++++------------------
 1 file changed, 19 insertions(+), 23 deletions(-)

diff --git a/templates/pages/docs/books.html b/templates/pages/docs/books.html
index 1c76e3da..a7b4a568 100644
--- a/templates/pages/docs/books.html
+++ b/templates/pages/docs/books.html
@@ -438,7 +438,7 @@
 
     <tr>
         <td>
-            <a href="https://www.lulu.com/shop/anthony-r-sotolongo-le%C3%B3n-and-yudisney-vazquez-ortiz/plpgsql-y-otros-lenguajes-procedurales-en-postgresql/ebook/product-23033430.html"><img
+            <a href="https://www.lulu.com/shop/yudisney-vazquez-ortiz-and-anthony-r-sotolongo-león/plpgsql-y-otros-lenguajes-procedurales-en-postgresql/ebook/product-1665k4d9.html"><img
                         src="/media/img/docs/books/plpgsql_y_otros_lenguajes.jpg"
                         alt="PL/pgSQL y otros lenguajes procedurales en PostgreSQL" /></a>
         </td>
@@ -448,7 +448,7 @@
                  <strong>Language</strong>: Spanish<br />
                  <strong>Current version at publication</strong>: 9.6<br />
                  <strong>Format</strong>: eBook<br />
-                 <strong>Published</strong>: January 2017
+                 <strong>Published</strong>: June 2019
         </td>
     </tr>
 
@@ -534,7 +534,7 @@
 
     <tr>
         <td>
-            <a href="https://www.packtpub.com/big-data-and-business-intelligence/postgresql-data-architects/?utm_source=PoD&utm_medium=referral&utm_campaign=1783288604"><img
+            <a href="https://www.packtpub.com/product/postgresql-for-data-architects/9781783288601"><img
                         src="/media/img/docs/books/packt_for_data_architects.png"
                         alt="PostgreSQL for Data Architects" /></a>
         </td>
@@ -566,9 +566,7 @@
 
     <tr>
         <td>
-            <a href="https://www.packtpub.com/big-data-and-business-intelligence/postgresql-developers-guide/?utm_source=PoD&utm_medium=referral&utm_campaign=1783989025"><img
-                        src="/media/img/docs/books/packt_developers_guide.png"
-                        alt="PostgreSQL Developer's Guide" /></a>
+            <img src="/media/img/docs/books/packt_developers_guide.png" alt="PostgreSQL Developer's Guide" />
         </td>
         <td>
                  <strong>Title</strong>: PostgreSQL Developer's Guide<br />
@@ -598,9 +596,7 @@
 
     <tr>
         <td>
-            <a href="https://www.packtpub.com/big-data-and-business-intelligence/postgresql-cookbook/?utm_source=PoD&utm_medium=referral&utm_campaign=1783555335"><img
-                        src="/media/img/docs/books/packt_postgresql_cookbook.png"
-                        alt="PostgreSQL Cookbook" /></a>
+            <img src="/media/img/docs/books/packt_postgresql_cookbook.png" alt="PostgreSQL Cookbook" />
         </td>
         <td>
                  <strong>Title</strong>: PostgreSQL Cookbook<br />
@@ -690,7 +686,8 @@
 
     <tr>
             <td>
-                <a href="https://www.packtpub.com/how-to-postgresql-backup-and-restore/book"><img src="/media/img/docs/books/pg-backup-restore-packt.jpg" alt="PostgreSQL Backup and Restore How-to" /></a>
+                <a href="https://www.packtpub.com/product/instant-postgresql-backup-and-restore-how-to/9781782169109">
+                <img src="/media/img/docs/books/pg-backup-restore-packt.jpg" alt="PostgreSQL Backup and Restore How-to" /></a>
             </td>
             <td>
                     <strong>Title</strong>: PostgreSQL Backup and Restore How-to<br />
@@ -704,7 +701,7 @@
 
     <tr>
             <td>
-                <a href="https://www.packtpub.com/instant-postgresql-starter/book"><img src="/media/img/docs/books/instant-pg-starter-packt.jpg" alt="Instant PostgreSQL Starter" /></a>
+                <img src="/media/img/docs/books/instant-pg-starter-packt.jpg" alt="Instant PostgreSQL Starter" />
             </td>
             <td>
                     <strong>Title</strong>: Instant PostgreSQL Starter<br />
@@ -744,7 +741,7 @@
     </tr>
     <tr>
             <td>
-                <a href="https://www.pearson.fr/livre/?GCOI=27440100863920"><img src="/media/img/docs/books/pearson_9782744024832.png" alt="Bases de données PostgreSQL, Gestion des performances" /></a>
+                <img src="/media/img/docs/books/pearson_9782744024832.png" alt="Bases de données PostgreSQL, Gestion des performances" />
             </td>
             <td>
             <strong>Title</strong>: Bases de donn&eacute;es PostgreSQL, Gestion des performances<br />
@@ -757,7 +754,7 @@
     </tr>
     <tr>
             <td>
-                    <a href="https://www.network-theory.co.uk/postgresql/vol1/"><img src="/media/img/docs/books/0954612027.92.jpg" alt="PostgreSQL Reference Manual - Volume 1" /></a>
+                    <img src="/media/img/docs/books/0954612027.92.jpg" alt="PostgreSQL Reference Manual - Volume 1" />
                     </td>
             <td>
                     <strong>Title</strong>: PostgreSQL Reference Manual - Volume 1-3<br />
@@ -797,7 +794,7 @@
     </tr>
     <tr>
             <td>
-    		<a href="http://www.digitbooks.fr/catalogue/9782815001984.html"><img src="/media/img/docs/books/9782815001984.jpg" alt="Utiliser PostgreSQL" /></a>
+            <img src="/media/img/docs/books/9782815001984.jpg" alt="Utiliser PostgreSQL" />
             </td>
             <td>
     		<strong>Title</strong>: Utiliser PostgreSQL<br />
@@ -810,7 +807,7 @@
     </tr>
     <tr>
             <td>
-    		<a href="http://www.digitbooks.fr/catalogue/9782815001809.html"><img src="/media/img/docs/books/9782815001809.png" alt="Installer et débuter avec PostgreSQL" /></a>
+            <img src="/media/img/docs/books/9782815001809.png" alt="Installer et débuter avec PostgreSQL" />
             </td>
             <td>
             <strong>Title</strong>: Installer et d&eacute;buter avec PostgreSQL<br />
@@ -835,8 +832,8 @@
     	</td>
     </tr>
     <tr>
-    	<td>
-    		<a href="https://www.amazon.com/PostgreSQL-French-Fran%C3%83%C2%A7ois-Marie-Colonna/dp/2746043815"><img src="/media/img/docs/books/51im2FLd-IL._SL500_AA300_.jpg" alt="PostgreSQL" /></a>
+        <td>
+            <img src="/media/img/docs/books/51im2FLd-IL._SL500_AA300_.jpg" alt="PostgreSQL" />
             </td>
             <td>
                     <strong>Title</strong>: PostgreSQL<br />
@@ -862,8 +859,8 @@
     </tr>
     <tr>
             <td>
-    		<a href="https://www.editions-eni.fr/Livres/PostgreSQL---administration-et-exploitation-d-rsquoune-base-de-donnees-2eme-edition-/.4_3a6222cf-b921-41f5-886c-c989f77ba994_710d51ac-760b-4aeb-a66a-55d146b69983_1_0_d9bd8b5e-f324-473f-b1fc-b41b421c950f.html"><img src="/media/img/docs/books/seblbook_ed2.jpg" alt="PostgreSQL - Administration et exploitation d’une base de donn&eacute;es (2&egrave;me &eacute;dition)" /></a>
-    		</td>
+            <img src="/media/img/docs/books/seblbook_ed2.jpg" alt="PostgreSQL - Administration et exploitation d’une base de donn&eacute;es (2&egrave;me &eacute;dition)" />
+            </td>
             <td>
     		<strong>Title</strong>: PostgreSQL - Administration et exploitation d’une base de donn&eacute;es (2&egrave;me &eacute;dition)<br />
     		<strong>Author</strong>: S&eacute;bastien LARDIERE<br />
@@ -1026,10 +1023,9 @@
         <strong>Author</strong>: Command Prompt Inc (Editor) et al<br />
     		<strong>Language</strong>: English<br />
             <strong>Current version at publication</strong>: &lt;7.4<br />
-    		<strong>Format</strong>: Paperback<br />
-    		<strong>Published</strong>: January 2002
-    		<a href="https://www.commandprompt.com/ppbook/">Available online</a><br />
-    	</td>
+            <strong>Format</strong>: Paperback<br />
+            <strong>Published</strong>: January 2002
+        </td>
     </tr>
     <tr>
             <td>
-- 
2.39.5