Resource icon

XF 1 Tip Mass Replacement of Thread Title

ENXF NET

Administrator
Staff member
Administrator
Moderator
+Lifetime VIP+
S.V.I.P.S Member
S.V.I.P Member
V.I.P Member
Collaborate
Registered
Joined
Nov 13, 2018
Messages
19,131
Points
823

Reputation:

LQD submitted a new resource:

Mass Replacement of Thread Title - for xenforo

This tips requires SQL query execution.
So for safety reason, you are advised to backup your database before doing this.

To remove some words from thread titles, and the threads are within certain nodes, you can run this SQL query from phpmyadmin :

Example :
Replace "viagra" into "medicine" from all thread title within nodes : 7, 8, 9, 10, 11.
Code:
UPDATE xf_thread
SET
title = REPLACE(title, 'viagra', 'medicine')
WHERE
node_id IN
(7, 8, 9, 10...

Read more about this resource...
 
Top