Jump to the post that solved this thread.
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Solved: 8 Years, 11 Months, 1 Week ago HOW TO REPLACE SOME TEXT IN MYBB FORUMS POST & THREAD TOPICS
#1
Solved: 8 Years, 11 Months, 1 Week ago
HOW TO REPLACE SOME TEXT IN MYBB FORUMS POST & THREAD TOPICS

Yes Friends
Some Text Words Which Are Illegal & Banned By Google..
I want to Replace all these Text Words In my forums post & thread topic name by one click !!!
Can its possible please help me!!!!

Other than word filter method?
bcz its just showing the changed word
but in actual word are still behind the filter words !!!
Its just showing not actual !!!
#2
Solved: 8 Years, 11 Months, 1 Week ago
you have already seen a related topic and posted there.
as a precaution, I'd suggest to take a backup of database before attempting changes to database contents.
#3
Solved: 8 Years, 11 Months, 1 Week ago
thank's dear for quick response !!!!!

UPDATE mybb_posts SET message = REPLACE(message,'OLD TEXT','NEW TEXT')

Can this code in also changed the possible changes in Thread Topic Name also...
#4
Solved: 8 Years, 11 Months, 1 Week ago
^ no. that Query is for changing content of post messages only.
mybb_threads table consists of thread titles (subject). {I'll check it after power resumes}
#5
Solved: 8 Years, 11 Months, 1 Week ago
ok dear i am waiting !!!!!!!!!
#6
Solved: 8 Years, 11 Months, 1 Week ago
try this
UPDATE  `mybb_threads` SET  `subject` = REPLACE(`subject` , 'OLDword' , 'NEWword')
#7
Solved: 8 Years, 11 Months, 1 Week ago
UPDATE mybb_posts SET message = REPLACE(message,'OLD TEXT','NEW TEXT')

When i apply that code
Error coming

#1146 - Table 'myserver_db.mybb_posts' doesn't exist

another time

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '**)' at line 1
#8
Solved: 8 Years, 11 Months, 1 Week ago
what is the table prefix of your forum's database ? you have to replace mybb_ with the database tables prefix.
#9
Solved: 8 Years, 11 Months, 1 Week ago
My database tables prefix is
_db
#10
Solved: 8 Years, 11 Months, 1 Week ago
^ replace mybb_ with _db_ in the SQL queries
Jump to the post that solved this thread.


Forum Jump:


Users browsing this thread: 1 Guest(s)