Elxis CMS Forum

Support => Technical support => Topic started by: striker on February 04, 2016, 09:30:38

Title: How to reset all hits counter back to zero for Elxis 4.x?
Post by: striker on February 04, 2016, 09:30:38
Is there a way to reset all the article hits counters with just one click?

Or any php code I need to inject somewhere in the core files?

Thanks!
Title: Re: How to reset all hits counter back to zero for Elxis 4.x?
Post by: striker on February 04, 2016, 09:33:18
I just got an answer from the other thread.

Quote
https://forum.elxis.org/index.php?topic=7371.msg47669#msg47669

Code: [Select]
UPDATE elx_content SET hits=0 WHERE id=xx;
Title: Re: How to reset all hits counter back to zero for Elxis 4.x?
Post by: datahell on February 04, 2016, 21:04:01
If you want to reset hits for ALL articles then you don't need to define the article id in the last part of your query.
Execute this query:
UPDATE elx_content SET hits=0;