New domains ... automatic update for links?

Moderator: TFF Mods

Post Reply
Tim
Da Tulip Champ II
Posts: 3458
Joined: Wed Oct 16, 2002 4:18 pm
Location: Heidelberg, Germany
Contact:

New domains ... automatic update for links?

Post by Tim »

Ian,

as most of the links in this forum are currently broken, would it be possible to make an automated run through the database of the forum to change part of the links in posts to the new domians enforced by the C&D letters and the change of phpBB?

So change "http://www.talkfantasyfootball.org/" to "http://www.talkfantasyfootball.org/"
and maybe "www.midgardbb.com" to "www.midgardbb.com"
and "www.thenaf.net" to "www.thenaf.net".

I'm not sure if this would work directly via SQL, but a short PHP script could do the job i think.

Reason: ''
Image
"In NUFFLE we trust!" - Retired Inquisitor of Nuffle.
Father of the Halfling Scribe
Admin of the Kurpfalz Cup
User avatar
DoubleSkulls
Da Admin
Posts: 8219
Joined: Wed May 08, 2002 12:55 pm
Location: Back in the UK
Contact:

Re: New domains ... automatic update for links?

Post by DoubleSkulls »

Good idea. I've made this sticky as a "to do" reminder to me since it does require a bit of work.

If anyone knows MySQL and can provide me with the SQL to do a search and replace across a mediumtext column would be appreciated - otherwise I'll have to look it up!

Reason: ''
Ian 'Double Skulls' Williams
User avatar
DoubleSkulls
Da Admin
Posts: 8219
Joined: Wed May 08, 2002 12:55 pm
Location: Back in the UK
Contact:

Re: New domains ... automatic update for links?

Post by DoubleSkulls »

Actually I've done this and am now reindexing the search to see if its okay.

Reason: ''
Ian 'Double Skulls' Williams
Fat_Emrys
Veteran
Veteran
Posts: 231
Joined: Sat Nov 01, 2008 9:27 am
Location: Norfolk, UK
Contact:

Re: New domains ... automatic update for links?

Post by Fat_Emrys »

Given that Tim's post now makes no sense I'd guess that worked then :lol:

Reason: ''
BBoing! is NOT bback! - see here for details
SChWiNG - The Society of Chainsaw Wielding Naughty Goblins - needs you!
Tim
Da Tulip Champ II
Posts: 3458
Joined: Wed Oct 16, 2002 4:18 pm
Location: Heidelberg, Germany
Contact:

Re: New domains ... automatic update for links?

Post by Tim »

lol my post looks stupid now but seems to be a good indication of success. AWESOME, Ian! ;)

Reason: ''
Image
"In NUFFLE we trust!" - Retired Inquisitor of Nuffle.
Father of the Halfling Scribe
Admin of the Kurpfalz Cup
User avatar
purdindas
Super Star
Super Star
Posts: 1058
Joined: Wed Nov 05, 2008 10:19 pm
Location: Scotland

Re: New domains ... automatic update for links?

Post by purdindas »

lol. I was totally confused when I read the first post but it all makes sense now.

Reason: ''
Have you tried my Crispy Pancakes?

Scottish Blood Bowl Captain
Post Reply