Reset Messages, Likes, Trophy Points

[HDTechVideo]

Is there any way to reset the manually changed message count, likes and Trophy points according to his/her original message count and likes.

 

[Hope]

Edit user in adminCP. No?

 

[HDTechVideo]

Edit user in adminCP. No?

Via AdminCP we can change the value but how will we get the actual value?

 

[Hope]

I do not get exactly what you need. :)

 

[HDTechVideo]

I do not get exactly what you need. :)

Here You have 835 post, 179 Likes. Suppose if you changed to 5000 Post, 500 Likes. and now you want to get back the actual message count and likes but you dont know the actual value. Is there any way to automatically count the total message and likes.

 

[Hope]

Of course not. Such a method does not exist. :)

 

[HDTechVideo]

Of course not. Such a method does not exist. :)

Is there any cron call back for that. Because every time user create a post it is adding by one so there may be a callback for that... If you dont mind to post this on xenforo we may get an answer. :wink:

 

[Hope]

Ask there, I was all the same...

 

[HDTechVideo]

Ask there, I was all the same...

I dont have permission to post there :)...

 

[Hope]

I will not be there to handle. Sorry. :) Maybe someone else.

 

[HDTechVideo]

Found an answer but dont know how to do that

У Вас недостаточно прав для просмотра ссылок. Вход или Регистрация

 

[Hope]

but dont know how to do that

You do not know how to query? Or what?

 

[HDTechVideo]

but dont know how to do that

You do not know how to query? Or what?

I dont know how to do query on xenforo

 

[Hope]

phpMyAdmin. :)

 

[HDTechVideo]

phpMyAdmin. :)

:) Yes working... Message count is updated now Likes :(

Is it possible to grab this. Not sure is it have like update

У Вас недостаточно прав для просмотра ссылок. Вход или Регистрация

 

[Hope]

This is Rebuild user post counts.

This will recalculate and update the post counts for all users at once. This is a large query that may take a while to finish.

UPDATE xf_user AS user
SET message_count = (
    SELECT COUNT(*)
    FROM xf_post AS post
    LEFT JOIN xf_thread AS thread ON (thread.thread_id = post.thread_id)
    WHERE post.user_id = user.user_id
    AND post.message_state = 'visible' AND thread.discussion_state = 'visible'
    GROUP BY post.user_id
);

If you have forums you wish to exclude from the count then use this query, where 1,2,3 is a comma-list of node_ids that are excluded from the count:

UPDATE xf_user AS user
SET message_count = (
    SELECT COUNT(*)
    FROM xf_post AS post
    LEFT JOIN xf_thread AS thread ON (thread.thread_id = post.thread_id)
    WHERE post.user_id = user.user_id
    AND thread.node_id NOT IN (1,2,3)
    AND post.message_state = 'visible' AND thread.discussion_state = 'visible'
    GROUP BY post.user_id
);

Backup first.

Because this query is so large you may encounter errors relating to these MySQL settings:

wait_timeout
innodb_lock_wait_timeout

You need to ask your host or server person to increase these settings if you encounter such errors.

 

[HDTechVideo]

Oops this is same query for message count there is nothing for likes :(

У Вас недостаточно прав для просмотра ссылок. Вход или Регистрация

Could you please get this file... This will recalculate the same...

 

[Hope]

No prob. :)

 

[HDTechVideo]

No prob. :)

Thank you... :)

 

[Hope]

Now all right?