diff options
| -rw-r--r-- | lib/VNDBUtil.pm | 3 | ||||
| -rw-r--r-- | util/updates/update_2.25.sql | 4 |
2 files changed, 6 insertions, 1 deletions
diff --git a/lib/VNDBUtil.pm b/lib/VNDBUtil.pm index 7bec05b2..d65c2c3f 100644 --- a/lib/VNDBUtil.pm +++ b/lib/VNDBUtil.pm @@ -195,8 +195,9 @@ sub normalize { s/\pM//g; # remove some characters that have no significance when searching use utf8; - tr/\r\n\t ,_\-.~:[]()%+!?&#$"'`♥★☆♪†「」『』【】・”//d; + tr/\r\n\t ,_\-.~:[]()%+!?#$"'`♥★☆♪†「」『』【】・‟”‛’‘‚„«‹»›//d; tr/@/a/; + s/&/and/; # remove commonly used release titles ("x Edition" and "x Version") # this saves some space and speeds up the search s/(?: diff --git a/util/updates/update_2.25.sql b/util/updates/update_2.25.sql index 138ec7a0..07275ae7 100644 --- a/util/updates/update_2.25.sql +++ b/util/updates/update_2.25.sql @@ -63,3 +63,7 @@ CREATE OR REPLACE FUNCTION strip_spoilers(t text) RETURNS text AS $$ -- The website doesn't require the [spoiler] tag to be closed, the outer replace catches that case. SELECT regexp_replace(regexp_replace(t, '\[spoiler\].*?\[/spoiler\]', ' ', 'ig'), '\[spoiler\].*', ' ', 'i'); $$ LANGUAGE sql IMMUTABLE; + + +-- Changes to search normalization +UPDATE vn SET c_search = NULL; |