Changes between Version 8 and Version 9 of WikiStart

Timestamp:

Jun 26, 2013, 3:07:18 PM (11 years ago)

Author:

casties

Comment:

--

WikiStart

@@ -35 +35 @@
     - Also on http://dmd.mpiwg-berlin.mpg.de/admin , go to "File Server" and upload your Filemaker File of the current Database.
 
+
+  * current SQL fix for digilib-Links in Sevilla MS:
+    - {{{update ded set translations = regexp_replace(translations||'\n', '(http:.*?)pn=(\\d{1})&(.*)\\n', '<a href="http://dmd.mpiwg-berlin.mpg.de/dmd/database/dmdlib?id='||picture_id||'&fn=/permanent/library/HNS20WZU/pageimg/000\\2&\\3" target="_blank">Scan No \\2.</a>\n','g') where translations like '%&pn=_&%'}}}
+    - {{{update ded set translations = regexp_replace(translations||'\n', '(http:.*?)pn=(\\d{2})&(.*)\\n', '<a href="http://dmd.mpiwg-berlin.mpg.de/dmd/database/dmdlib?id='||picture_id||'&fn=/permanent/library/HNS20WZU/pageimg/00\\2&\\3" target="_blank">Scan No \\2.</a>\n','g') where translations like '%&pn=__&%'}}}