broken gstwin links - suggestion/workaround **FIXED**!!!

[Cannon Fodder]

The easiest way I can think of is to run an update query on the database table that contains the message text.

Something like below would get you the number of records needing to be up dated, I'm assuming it is running on some version of SQL either MySQL or MSSQL.

select * from [sometable] where [somefield] like 'http://www.gstwins.com/forum/viewtopic.php?%';

[skoebl]

Good going!  That seems to work ... for 14 of my 22 pages worth of "viewtopic by Kerry" search results.

But ... wouldn't you know it, I had to get "fancy" at some point in the past and link directly to individual posts?   

I don't suppose there's any help for old links like

http://www.gstwins.com/forum/viewtopic.php?p=75355#75355[/list]
when they resolve to a new-style link like

http://gstwins.com/gsboard/index.php?topic=9151.msg75355#msg75355[/list]
?

Since the topic number is not included in the old link, it looks like I still have some work to do.... 

http://gstwins.com/gsboard/index.php?topic=9151.0

Is that what you were looking for with that link Kerry?

[Kerry]

Not quite.  It's the right topic, but the old link used to go right to my post within the topic.  (The new-style link that I supplied does the same thing.)

As far as I can tell, there's no way in the new system to link directly to a specific post without including the  topic number in the URL.

Can anyone confirm this?

[skoebl]

Not quite.  It's the right topic, but the old link used to go right to my post within the topic.  (The new-style link that I supplied does the same thing.)

As far as I can tell, there's no way in the new system to link directly to a specific post without including the  topic number in the URL.

Can anyone confirm this?

Ah, I understand now.

[john]

Yea.  It isn't looking good.  But that one fix certainly helps!

Pray harder!