Changes between Version 9 and Version 10 of WikiStart


Ignore:
Timestamp:
Jun 26, 2013, 3:07:36 PM (11 years ago)
Author:
casties
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • WikiStart

    v9 v10  
    3636
    3737
    38   * current SQL fix for digilib-Links in Sevilla MS:
     38  * current (26.6.2013) SQL fix for digilib-Links in Sevilla MS:
    3939    - {{{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=_&%'}}}
    4040    - {{{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=__&%'}}}