Baldur's Gate : The Sword Coast Chronicles : NWN2 Persistent World

I went ahead and ran the SQL queries:

UPDATE `phpbb_posts` SET `post_text`= REPLACE(post_text, "bgtscc1.com/forum/", "bgtscc.net/")

UPDATE `phpbb_posts` SET `post_text`= REPLACE(post_text, "http://www.bgtscc1.com/forum/", "http://www.bgtscc.net/")

Please let me know if anyone finds any more broken links.

Aspect of Sorrow wrote:You can perform this in one fell swoop by select regex'ing a query in SQL with an update clause under the *_posts table. Don't use Apache's mod_rewrite, it's unnecessary for this.

Make sure you backed up the table first.

Thanks for the advice. I normally make a backup, edit the backup-file and save it under a new name, then import that one again (right after clearing the live-database). Might not be the fastest way, and comes with a bit of downtime, but you have most control over the changes being made, and can check them before they're changed in the live database.

Maecius wrote:^ I love computers. ♡ They are magic in a box.

I think Zanniej is planning on doing exactly this (or something like this) this weekend sometime. Then all our links should point to the right forum.

Yup, planned for this weekend!

Duster47 wrote:

Maecius wrote:^ I love computers. ♡ They are magic in a box.

I think Zanniej is planning on doing exactly this (or something like this) this weekend sometime. Then all our links should point to the right forum.

Sweetness. I am feeling more obsolete every month to these magical boxes and their coding guru's.

You're like the unsung hero of all server-magic that no-one else of us get's. Don't go anywhere!! lol

And then :

Endelyon wrote:I went ahead and ran the SQL queries:

UPDATE `phpbb_posts` SET `post_text`= REPLACE(post_text, "bgtscc1.com/forum/", "bgtscc.net/")

UPDATE `phpbb_posts` SET `post_text`= REPLACE(post_text, "http://www.bgtscc1.com/forum/", "http://www.bgtscc.net/")

Please let me know if anyone finds any more broken links.

Thanks for doing it for me
I might still do my approach, as to solve the issues with old links in signatures, images and all other things that are still hidden somewhere in the database. Otherwise we're bound to lose some links when the old server goes down.

I just tested a couple links at the bottom of people's posts in their signatures.. it goes to the old forum post then quickly goes back to this one's Board index page.

Zanniej wrote:Thanks for doing it for me
I might still do my approach, as to solve the issues with old links in signatures, images and all other things that are still hidden somewhere in the database. Otherwise we're bound to lose some links when the old server goes down.

np Zanniej I tried to follow the same link on some post about eight times in a row and just got irritated enough at my short-term memory to go ahead and run the queries.

For what it's worth, I wouldn't use regexp as AoS suggested but simply replace the `phpbb_posts` and `post_text` references in the above two statements with whatever table and column you want to effect.

LISA100595 wrote:I just tested a couple links at the bottom of people's posts in their signatures.. it goes to the old forum post then quickly goes back to this one's Board index page.

I came here to post this same thing, as I thought I'd make some biography updates. I discovered that all of my links - to other biographies, to RP posts, to screenshots - all do the same thing as described. Is there any way to automate the swap, or will I need to update every. single. link. by hand?

Endelyon wrote:For what it's worth, I wouldn't use regexp as AoS suggested but simply replace the `phpbb_posts` and `post_text` references in the above two statements with whatever table and column you want to effect.

REPLACE won't fix enc errors without first converting to binary, so if you have a broken character, it'll pass over instead because it didn't match.

TarnishedSoul wrote:

LISA100595 wrote:I just tested a couple links at the bottom of people's posts in their signatures.. it goes to the old forum post then quickly goes back to this one's Board index page.

I came here to post this same thing, as I thought I'd make some biography updates. I discovered that all of my links - to other biographies, to RP posts, to screenshots - all do the same thing as described. Is there any way to automate the swap, or will I need to update every. single. link. by hand?

I'll automate this the coming weekend. I'll let you all know when it's done. If after that all of you could do another thorough check of the forum I'd be very glad

http://bgtscc.net/index.php still displays as "under maintenance". It's my favorite button

Fixed, ty.