Requested by BanterFace in the support section, this extension adds a convenient search box at the top of mChat's archive page that allows you to search all messages. To be able to use this feature, a user needs the Can search board permission (in the Misc permissions tab; the internal permission name is u_search).
The search functionality is very limited. What this extension basically does is a WHERE message LIKE %keyword% query. This means that, for example, when searching for quote, messages that contain a [quote][/quote] BBCode will be listed in the results.
By default, the collation of mChat's message column in the phpbb_mchat table is utf8_bin and is therefore case sensitive, which affects this extension's search feature. If you prefer the search to be case insensitive, change the collation to utf8_unicode_ci. You can do this in your preferred database management tool such as phpMyAdmin, either manually or by running this query:
The upcoming release will be working with MySQL databases only. If you're using a different database, help me convert this statement to the syntax of your engine.
The query takes a UTC Unix timestamp (in the example below it's 08/31/2018 @ 10:21pm (UTC)), applies a timezone conversion (either ±seconds or ±hh:mm) and formats it as a date. Example output: 2018-10-1
Version 1.1.1 is now available in the first post. Go to the archive to test it.
It adds two date pickers: one is right next to the search field and it allows you to filter search results by day, and another one on the right side next to the pagination which allows you to jump to messages of a certain day in the archive. Note that for second one to work, you need at least mChat 2.1.1 (not yet in the CDB), or you can manually add this PHP event to your mChat.