[RSS Feed/News] Usernames of length 1 are not mentionable

[XenForo]

A username with a length of 1 character is not mentionable as the regex either extracts an additional space or just misses it.

Given the message;

@a @a @cc
Click to expand...

XF will generate the query;
SQL:

SELECT user.user_id, user.username,
IF(user.username LIKE 'a %', 1, 0) AS match_0, 
IF(user.username LIKE 'a %', 1, 0) AS match_1, 
IF(user.username LIKE 'cc%', 1, 0) AS match_2
FROM xf_user AS user
WHERE (user.username LIKE 'a %' OR user.username LIKE 'b %' OR...

Read more

ادامه مطلب...