Change Thread ID.

[SaN-DeeP]

Hi,
I need to urgently change thread id of few threads which got deleted accidentally from one our forums.

I am ready to do direct database alterations at my risk, please guide me how to do the same. We have recovered content of this threads via googles index (since this threads are very important for us) we need to restore them back to there original IDs, for search engine rankings.


Thanks and Regards,

[Chroder]

It is quite involved. I think there are about a dozen tables that require threadid to be consistent (thread, post, threadread, threadrate -- and more).

I don't know what they all are, so I can't provide a query. But I would suggest just using some method of a permanent redirect (sending the 301 response). I believe most search engines won't fault you for these kinds of redirects. For example, something like this htaccess (untested):

RewriteEngine On
RewriteCond showthread\.php?t=123 /showthread.php?t=789 [L,301]

[SaN-DeeP]

thanks chroder, thats the last option I have, since there where many important threads which got deleted I tried to avoid redirection.

I am only concerned about a change in thread id, doesnt matters if postids are new. (unsure if this can be acheived)

[SaN-DeeP]

Bumping back seeking a solution.

[zCarot [RU]]

backup and close forum before do that

SQL: (NTid = your new thread ID, OTid = your old thread ID, TP_ = your table prefix (if you use it))

UPDATE TP_infraction SET threadid = NTid WHERE threadid = OTid
UPDATE TP_moderation SET threadid = NTid WHERE threadid = OTid
UPDATE TP_moderatorlog SET threadid = NTid WHERE threadid = OTid
UPDATE TP_post SET threadid = NTid WHERE threadid = OTid
UPDATE TP_posthash SET threadid = NTid WHERE threadid = OTid
UPDATE TP_subscribethread SET threadid = NTid WHERE threadid = OTid
UPDATE TP_tachythreadpost SET threadid = NTid WHERE threadid = OTid
UPDATE TP_thread SET threadid = NTid WHERE threadid = OTid
UPDATE TP_threadrate SET threadid = NTid WHERE threadid = OTid
UPDATE TP_threadread SET threadid = NTid WHERE threadid = OTid
UPDATE TP_threadredirect SET threadid = NTid WHERE threadid = OTid
UPDATE TP_threadviews SET threadid = NTid WHERE threadid = OTid

after that update counters