Fixed User renaming

[Shamil]

Hello,

This may be more of a suggestion, but I'm not sure how you'd tackle this with the overhead of SQL queries, and if it should be done at all.

When a user posts a thread, their username at the time is saved in the post/thread table, hence :

Discussion in 'Suggestions: Bigger Features' started by vrtsolus, Jul 31, 2010.

However, if the principle post username is changed, this is not reflected in the thread.

I am wondering if this has an effect on SEO, or what could be done, or should be - if any at all.

Shamil

 

[Paul B]

Kier's post from August last year: http://xenforo.com/community/thread...not-display-correct-username.1977/#post-29009

Although that thread is related to quotes, it's using the same field so the issue is the same.

 

[Kier]

I have an idea...

 

[Kier]

This code does what you want... but we are concerned about performance.

We generally don't have indexes on those user ID fields, as XenForo doesn't use them for the most part, so each of these update queries, including the on on the xf_post table, could potentially be doing a full table scan.

I'm not sure we actually want to include this in the core code.

 

[Kier]

With a few minor alternations (there is now the ability to choose to disable the denormalised update if you want to) this is now in the core, and will go out with 1.0.2.