How to reset all hits counter back to zero for Elxis 4.x?

[striker]

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!

[striker]

I just got an answer from the other thread.

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

Code: [Select]

UPDATE elx_content SET hits=0 WHERE id=xx;

[datahell]

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;