From eab82f4c1b766e0fbf2337125825b75dd22d442d Mon Sep 17 00:00:00 2001 From: Marcel Werk Date: Sat, 1 Jun 2013 23:39:06 +0200 Subject: [PATCH] Fixed issues when using old PCRE library version --- wcfsetup/setup/db/install.sql | 18 +++++++++--------- 1 file changed, 9 insertions(+), 9 deletions(-) diff --git a/wcfsetup/setup/db/install.sql b/wcfsetup/setup/db/install.sql index 26066c9445..50b39e80f6 100644 --- a/wcfsetup/setup/db/install.sql +++ b/wcfsetup/setup/db/install.sql @@ -1646,24 +1646,24 @@ INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('messageSid -- media providers -- Videos -- Youtube - INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('YouTube', 'https?://(?:.+?\\.)?youtu(?:\\.be/|be\\.com/watch\\?(?:.*?&)?v=)(?[a-zA-Z0-9_-]+)(?(?:#a?t=(?:\\d+|(?:\\d+h(?:\\d+m)?(?:\\d+s)?)|(?:\\d+m(?:\\d+s)?)|(?:\\d+s))$)?)', ''); + INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('YouTube', 'https?://(?:.+?\\.)?youtu(?:\\.be/|be\\.com/watch\\?(?:.*?&)?v=)(?P[a-zA-Z0-9_-]+)(?P(?:#a?t=(?:\\d+|(?:\\d+h(?:\\d+m)?(?:\\d+s)?)|(?:\\d+m(?:\\d+s)?)|(?:\\d+s))$)?)', ''); -- Vimeo - INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('Vimeo', 'http://vimeo\\.com/(?\\d+)', ''); + INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('Vimeo', 'http://vimeo\\.com/(?P\\d+)', ''); -- MyVideo - INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('MyVideo', 'http://(?:www\\.)?myvideo\\.de/watch/(?\\d+)', ''); + INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('MyVideo', 'http://(?:www\\.)?myvideo\\.de/watch/(?P\\d+)', ''); -- Clipfish - INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('Clipfish', 'http://(?:www\\.)?clipfish\\.de/(?:.*?/)?video/(?\\d+)/', '
'); + INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('Clipfish', 'http://(?:www\\.)?clipfish\\.de/(?:.*?/)?video/(?P\\d+)/', '
'); -- Veoh - INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('Veoh', 'http://(?:www\\.)?veoh\\.com/watch/v(?\\d+[a-zA-Z0-9]+)', ''); + INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('Veoh', 'http://(?:www\\.)?veoh\\.com/watch/v(?P\\d+[a-zA-Z0-9]+)', ''); -- DailyMotion - INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('DailyMotion', 'https?://(?:www\\.)?dailymotion\\.com/video/(?[a-zA-Z0-9]+)', ''); + INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('DailyMotion', 'https?://(?:www\\.)?dailymotion\\.com/video/(?P[a-zA-Z0-9]+)', ''); -- YouKu - INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('YouKu', 'https?://(?:.+?\\.)?youku\\.com/v_show/id_(?[a-zA-Z0-9_-]+)(?:\\.html)?', ''); + INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('YouKu', 'https?://(?:.+?\\.)?youku\\.com/v_show/id_(?P[a-zA-Z0-9_-]+)(?:\\.html)?', ''); -- Misc -- github gist - INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('github gist', 'https://gist.github.com/(?[^/]+/[0-9a-zA-Z]+)', ''); + INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('github gist', 'https://gist.github.com/(?P[^/]+/[0-9a-zA-Z]+)', ''); -- soundcloud - INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('Soundcloud', 'https?://soundcloud.com/(?[a-zA-Z0-9_-]+)/(?[a-zA-Z0-9_-]+)', ''); + INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('Soundcloud', 'https?://soundcloud.com/(?P[a-zA-Z0-9_-]+)/(?P[a-zA-Z0-9_-]+)', ''); -- default priorities UPDATE wcf1_user_group SET priority = 10 WHERE groupID = 3; -- 2.20.1