[RSS Feed/News] SQL query in specific forum

[XenForo]

Hi
I wrote a BASH script that searches the forum for specific entries (links to files in the filehoster directory) using a mysql query.
If it finds an entry in the filehoster directory that does not exist in the forum, it will be deleted from the filehoster directory.
Code:

# BASH While loop
SELECT 'message' FROM xf_post WHERE message LIKE \"${search_string}\";

That works good.

Now I want additional, that filehoster entries to be deleted, from which the link is in the "Archive" forum.
How...

Read more

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