sillsdev / webonary

Source code for Webonary and related applications that support it
https://www.webonary.org
MIT License
5 stars 3 forks source link

Change bibliography menu link for dictionaries #721

Open peteroatley opened 1 month ago

peteroatley commented 1 month ago

Linked to #697.

Existing dictionaries need the following link update in their Menu.

https://www.sil.org/search/node/xxx

to

https://www.sil.org/resources/search/language/xxx

Where xxx is the language code.

The link is under Languages->Bibliography. Not all dictionaries have this menu item. Image

The link will also need changing for other languages e.g. French, Spanish, etc.

Spanish link is under Lengua->Bibliografía Image

I don't know how easy it is to change the link for other languages, so the priority is to change it for English. However, there are several languages used in a number of websites which it would be good to do. If we need menu translations for each language, I can provide these.

Here is a link to the menu:

https://www.webonary.org/komo/wp-admin/nav-menus.php

phillip-hopper commented 1 week ago

Image

phillip-hopper commented 1 week ago
SELECT meta_value,
       REGEXP_REPLACE(meta_value, 'https?://.*sil.org/search/node/([a-zA-Z]+)', 'https://www.sil.org/resources/search/language/\\1')
FROM webonary.wp_490_postmeta
WHERE meta_value LIKE '%sil.org/search/node%'