Snitz Forums 2000 - Find and Replace text in topics?

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: General / Classic ASP versions(v3.4.XX)

Find and Replace text in topics?

New Topic

Topic Locked

Printer Friendly

Author

Topic

sikandar
Junior Member

Pakistan
135 Posts

Posted - 17 November 2009 : 13:23:38

Hi,
I have changed the path of my forums and now interested to replace all url given in the topics with url of other topics.

Like if in a topics it is,

http://forum.snitz.com/forum

change it to,

http://forum.snitz.com/forum_xxx

Thanks

leatherlips
Senior Member

USA
1838 Posts

Posted - 17 November 2009 : 15:26:51

I'm not quite sure what you are trying to do, but perhaps you could use the bad word filter?

Replace the old url with the new url and the bad word filter would automatically change them all.

KC
Junior Member

USA
152 Posts

Posted - 23 November 2009 : 10:43:29

Yes, the Bad Word filer would be perfect.
That way you don't have to find some way to do a global post replace.

Owner of vales.com and Elite Computers.

sikandar
Junior Member

Pakistan
135 Posts

Posted - 20 December 2009 : 11:41:14

Hi,
Here is the solution I did using Mysql query browser as the following can help you like if you want to change the name of your domain or any such thing and you have used that in your topics/replies.

Step 1

update forum_topics f set t_message = insert(t_message, instr(t_message,'http://www.mysite.com/topic.asp'),length('http://wwww.mysite.com/topic.asp'),'http://www.mysite.com/forums/topic.asp')
where t_message like '%http://www.mysite.com/topic.asp%';

Step 2

update forum_reply f set r_message = insert(r_message, instr(r_message,'http://wwww.mysite.com/topic.asp'),length('http://wwww.mysite.com/topic.asp'),'http://wwww.mysite.com/forums/topic.asp')
where r_message like '%http://wwww.mysite.com/topic.asp%';

Note: As the update will update first occurrence of string so execute as many times until it not says zero records updated.

Hope will be of use.

Thanks

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 20 December 2009 : 13:05:01

Using the MySQL replace function would do it more easily.

Snitz 3.4 Readme | Like the support? Support Snitz too

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.34 seconds.