Person search does not allow search by FirstName + LastName

[BackSH00TER]

If you search by first and last name you will get no results, you have to search by either one

Profiles search appears to support search by first and last, so we just need to borrow the logic from there

[BackSH00TER]

Reference line we use for searchProfiles
local people = MySQL.query.await("SELECT p.citizenid, p.charinfo, md.pfp FROM players p LEFT JOIN mdt_data md on p.citizenid = md.cid WHERE LOWER(CONCAT(JSON_VALUE(p.charinfo, '$.firstname'), ' ', JSON_VALUE(p.charinfo, '$.lastname'))) LIKE :query OR LOWER(charinfo) LIKE :query OR LOWER(citizenid) LIKE :query AND jobtype = :jobtype LIMIT 20", { query = string.lower('%'..sentData..'%'), jobtype = JobType })

[MonkeyWhisper]

If you search by first and last name you will get no results, you have to search by either one

Profiles search appears to support search by first and last, so we just need to borrow the logic from there

I can search by last name, check this out

https://gyazo.com/31f2a1da0f994cb993bf0e5516dc90dd

[BackSH00TER]

@MonkeyWhisper The bug is that if you type FirstName LastName the results will not show.
You can only search if you put ONLY First OR Last. Combined does not work.

[MonkeyWhisper]

@MonkeyWhisper The bug is that if you type FirstName LastName the results will not show. You can only search if you put ONLY First OR Last. Combined does not work.

Ops! Sorry, okay, yup, I was able to duplicate it

Searching for both first AND last name, no results

[MonkeyWhisper]

@MonkeyWhisper The bug is that if you type FirstName LastName the results will not show. You can only search if you put ONLY First OR Last. Combined does not work.

https://gyazo.com/945ee100267fedf00fdc3bbcf2c79313

Check it out :)

[MonkeyWhisper]

#317