The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
This will work right?
UPDATE thread
SET title = REPLACE(title, '++++','****') UPDATE post SET pagetext = REPLACE(pagetext, '++++','****') Obviously I want to replace the f-word shown as ++++ here, in the database with asterisks, just wanted to have the query checked to be sure. Additional question: can I do this without overloading the page for manual queries in ACP? It's an 8 million post database on an owned server with only this one forum running. |
#2
|
|||
|
|||
That should work yes, but you should always make a backup before doing a risky UPDATE statement.
It's hard to say if the server gets overloaded, it kind of depends on the server specifications and the configuration of the MySQL server. |
#3
|
|||
|
|||
Ok tried it, titles work, posts takes too long (504 error). I've got the backup. Thanks Dave
|
#4
|
|||
|
|||
In case you're on a VPS or dedicated server, login into mysqladmin on the server and execute i t there. That way you will not face a timeout.
|
#5
|
|||
|
|||
Yes works, tnx again
|
#6
|
||||
|
||||
you can make your forum broken by changing like that
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|