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

 

[=:Jack:=]

UPDATE post
SET pagetext = REPLACE(pagetext,'[COLOR=red]OLD TEXT[/COLOR]','[COLOR=red]NEW TEXT[/COLOR]')

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 . 8-)

 

[=:Jack:=]

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

 

[m107]

yes, actually I need a plugin :D

 

[=: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 :D

 

[m107]

yes, it would be appreciated if you upload it

 

[=:Jack:=]

MF : http://www.mediafire.com/?couvvobhi1957em

 

[m107]

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

Oh, unfortunately its not working for signature.

 

[=:Jack:=]

sorry bro this is for threads and posts only
i will try to modify this for signatures too