[TikiWiki-commits] [Git][tikiwiki/tiki][master] [FIX] Improve regex output conversion for feature_file_galleries

ushindi bienvenu pushed to branch master at Tiki Wiki CMS Groupware / Tiki


Commits:
75c42f5a by ushindi bienvenu at 2026-02-17T14:12:56+00:00
[FIX] Improve regex output conversion for feature_file_galleries
---
* [FIX] Improve regex output conversion for feature_file_galleries

See merge request tikiwiki/tiki!9565

- - - - -


2 changed files:

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


Changes:

=====================================
db/tiki.sql
=====================================
@@ -3455,9 +3455,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/75c42f5a9ac85034f8b8b4e9d51ed028f42df475

-- 
View it on GitLab: https://gitlab.com/tikiwiki/tiki/-/commit/75c42f5a9ac85034f8b8b4e9d51ed028f42df475
You're receiving this email because of your account on gitlab.com.

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