[3.3][DEV] Moderate While Searching

[Toxyy]

Extension Name: Moderate While Searching
Author: toxyy
Special Thanks: urzh
Extension Description: Moderate while searching in phpBB 3.3
Extension Version: 0.1.0

Requirements:

• phpBB 3.3
• PHP 7+
• MySQL Fulltext Search Index

This extension requires a core edit:

Open ./forum/phpbb/search/fulltext_mysql.php

Find $this->db->sql_escape(html_entity_decode($this->search_query, ENT_COMPAT)
Replace with $this->db->sql_escape(html_entity_decode($search_query, ENT_COMPAT)

(We are changing $this->search_query to $search_query)

A pull request will be made for this change by 3.3.9

Extension Download: https://github.com/toxyy/moderatewhiles ... /0.1.0.zip
Github repository: https://github.com/toxyy/moderatewhilesearching
Languages: en
Templates: all
Features:

• Find all duplicate topics
• Delete duplicate topics

Planned features are to extend functionality to include more MCP like features, you can see I've commented these out in the html files. The delete topic functionality should work on any search page with topics, I've just disabled it as I only tested it with duplicate topics.

Will also add support for other search engines and features depending on demand.

Installation/notes:
This extension is in DEV. PLEASE make a backup of your database before using this extension.

Place files into ext/toxyy/moderatewhilesearching

You MUST make the core change as described up above in order for the extension to work properly.

Notes:
Currently this extension only works to find duplicate topics on your forum, and then delete them. The counting query is busted and would require a new event to fix that, so the search page populates with a list of duplicate topics. That list will continue to be populated until you have no more duplicate topics left. The topics listed will be of the highest ID, since we are assuming a higher ID topic would be the duplicate. The originals are not listed. If a topic has more than one duplicate, only the latest one will be listed, but each new one will continue to be in the results until you have deleted all of the duplicates.

Search returning 0 results is an artifact of how I made this extension, it cannot be fixed unless I make a new event for it and I have no plans to.

Usage:

• If no results at first, clear your cache.
• You MUST use keywords to find duplicate topics, these keywords are unused but the search functionality requires it.
• The other settings are overridden - it is automatically set to Topic titles only, display results are Topics, and sort results by is by topic titles, no matter what you set.

Media:
Example usage: https://toxyy.github.io/moderatewhilese ... rking.webm



---

[Toxyy]

reserved

[Jodi-86]

Nice idea and will save a bit of time, thank you.

[ac_roma]

great mod

[spinecki]

Which phpbb version is it for? There is no such string for changing in both 3.3.8 and 3.3.5...

[warmweer]

Which phpbb version is it for? There is no such string for changing in both 3.3.8 and 3.3.5...

A search for the text $this->db->sql_escape(html_entity_decode($this->search_query, ENT_COMPAT) in the phpBB-3.3.8.zip came up with line 600 in the file mentioned (it actually came up before I could take my finger off the ENTER button ).

[spinecki]

you're right, 3.3.8 do have it, 3.3.5 do not.

[warmweer]

you're right, 3.3.8 do have it, 3.3.5 do not.

3.3.8 and 3.3.9 have it.