how to replace word in vb4

[m107]

Hi,
How can I auto replace some words with another in all parts of vbulletin? for example changing all "referral" to "referral=5" in all parts, even signatures.

Thanks in advance

m107 Reviewed by m107 on 4th Sep 2010. how to replace word in vb4 Hi, How can I auto replace some words with another in all parts of vbulletin? for example changing all "referral" to "referral=5" in all parts, even signatures. Thanks in advance Rating: 5

[=:Jack:=]

UPDATE post
SET pagetext = REPLACE(pagetext,'OLD TEXT','NEW TEXT')

try this bro
this can replace in posts

[m107]

Thank you, but you mean in database? what about further posts?

[=:Jack:=]

bro this is the sql query to be run in phpmyadmin
this will replace all the old text in the page with ur new text

[m107]

bro this is the sql query to be run in phpmyadmin
this will replace all the old text in the page with ur new text

Thank you, but I need something to replace all future posts.

[=:Jack:=]

u mean continuous replacement?

[m107]

u mean continuous replacement?

I didn't understand , I mean to change a specific word(s) in all parts such as posts and signatures. something like censor word but changes specific words to certain word .

[=:Jack:=]

u need a plugin for this?
coz until i kno, sql queries can only do this

[m107]

yes, actually I need a plugin

[=:Jack:=]

here you go bro
http://www.vbulletin.org/forum/showthread.php?t=239234
if you cant download, i can upload it somewhere for u