Sure. They are located in the post_text column of the phpbb3_posts table. This is a text column.
The links are like any URL that is posted in a thread, but as an example, here is a link to this thread:
Lets say that instead of http://www.phpbb.com, the server was changed to forum.phpbb.com. Finding and changing the first occurrence in each row is easy using UPDATETEXT. The big problem comes when a row contains multiple occurences of the text being searched for.
For example, the link above to this thread occurs twice in the database row--once for the link and once for the text being displayed. Some posts may have several such links in a single data row.
I can run my update script repeatedly to get the next occurence of the string, but I have no idea of how many times to run it. With arount 50,000 total posts, this could get to be very time comsuming.
Last edited by stevemaury
on Fri Dec 05, 2008 3:47 pm, edited 1 time in total.
Reason: Make URLs not parse so discussion is clearer.