XenForo Delete user, add user, change posts/threads to old user

[Robert9]

User Sam has 12 threads and 99 posts.
User Sam deletes his account.
User Sam registers again with user_id 1234
I do something like

update xf_thread set userid_id = "1234" where username = "Sam";
update xf_post set userid_id = "1234" where username = "Sam";

I also tried the different functions to recalculate counters, threads, forums ...

But it is not done completely. I guess it is the table "user_post_thread" (or equal, I am too lazy to open phpMyAdmin now)

What else I should do to...

Read more

Continue reading...