[TikiWiki-commits] [Git][tikiwiki/tiki][27.x] [BP][FIX] Improve regex output conversion for feature_file_galleries

ushindi bienvenu pushed to branch 27.x at Tiki Wiki CMS Groupware / Tiki


Commits:
21fc71fe by ushindi bienvenu at 2026-02-19T15:26:46+00:00
[BP][FIX] Improve regex output conversion for feature_file_galleries
---
* [FIX] Improve regex output conversion for feature_file_galleries
---
* [FIX] Improve regex output conversion for feature_file_galleries
---
* [FIX] Improve regex output conversion for feature_file_galleries

See merge request tikiwiki/tiki!9565

See merge request tikiwiki/tiki!9610

See merge request tikiwiki/tiki!9612

- - - - -


2 changed files:

- db/tiki.sql
- + installer/schema/20260212_update_regex_right_column_for_file_type_in_sefurl_tiki.sql


Changes:

=====================================
db/tiki.sql
=====================================
@@ -3438,9 +3438,9 @@ INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES(
 INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-directory_browse.php\\?parent=(\\d+)', 'directory$1', 'directory', 'feature_directory');
 INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-view_faq.php\\?faqId=(\\d+)', 'faq$1', 'faq', 'feature_faqs');
 INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-download_file.php\\?fileId=(\\d+)', 'display$1', 'file', 'feature_file_galleries', 10);
-INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-download_file.php\\?fileId=(\\d+)(?:&|&)thumbnail', 'thumbnail$1', 'thumbnail', 'feature_file_galleries');
-INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-download_file.php\\?fileId=(\\d+)(?:&|&)display', 'display$1', 'display', 'feature_file_galleries');
-INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-download_file.php\\?fileId=(\\d+)(?:&|&)preview', 'preview$1', 'preview', 'feature_file_galleries');
+INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-download_file.php\\?fileId=(\\d+)(?:&|&)thumbnail(?:=[^&]*)?(?=(?:&|&|$))', 'thumbnail$1', 'thumbnail', 'feature_file_galleries');
+INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-download_file.php\\?fileId=(\\d+)(?:&|&)display(?:=[^&]*)?(?=(?:&|&|$))', 'display$1', 'display', 'feature_file_galleries');
+INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-download_file.php\\?fileId=(\\d+)(?:&|&)preview(?:=[^&]*)?(?=(?:&|&|$))', 'preview$1', 'preview', 'feature_file_galleries');
 INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-view_forum.php\\?forumId=(\\d+)', 'forum$1', 'forum', 'feature_forums');
 INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-newsletters.php\\?nlId=(\\d+)', 'newsletter$1', 'newsletter', 'feature_newsletters');
 INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-take_quiz.php\\?quizId=(\\d+)', 'quiz$1', 'quiz', 'feature_quizzes');


=====================================
installer/schema/20260212_update_regex_right_column_for_file_type_in_sefurl_tiki.sql
=====================================
@@ -0,0 +1,12 @@
+UPDATE `tiki_sefurl_regex_out`
+SET `left` = 'tiki-download_file.php\\?fileId=(\\d+)(?:&|&)display(?:=[^&]*)?(?=(?:&|&|$))'
+WHERE `right` = 'display$1' AND `feature` = 'feature_file_galleries';
+
+
+UPDATE `tiki_sefurl_regex_out`
+SET `left` = 'tiki-download_file.php\\?fileId=(\\d+)(?:&|&)thumbnail(?:=[^&]*)?(?=(?:&|&|$))'
+WHERE `right` = 'thumbnail$1' AND `feature` = 'feature_file_galleries';
+
+UPDATE `tiki_sefurl_regex_out`
+SET `left` = 'tiki-download_file.php\\?fileId=(\\d+)(?:&|&)preview(?:=[^&]*)?(?=(?:&|&|$))'
+WHERE `right` = 'preview$1' AND `feature` = 'feature_file_galleries';
\ No newline at end of file



View it on GitLab: https://gitlab.com/tikiwiki/tiki/-/commit/21fc71fed254a693231a6c2f3c3a86ec6954e3f1

-- 
View it on GitLab: https://gitlab.com/tikiwiki/tiki/-/commit/21fc71fed254a693231a6c2f3c3a86ec6954e3f1
You're receiving this email because of your account on gitlab.com. Manage all notifications: https://gitlab.com/-/profile/notifications | Help: https://gitlab.com/help

_______________________________________________
TikiWiki-cvs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-cvs