blog documentation FAQ followers forum marketplace services youtube

Reset Stats for Plays, Views, Etc. in JR 6

The Jamroom Network » Forum » Using Jamroom » Page » Reset Stats for Plays, Views, Etc. in JR 6
JammerPro
JammerPro
@jammerpro
5 years ago
44 posts
In JR 4, we were able to reset the stats for plays, views, etc., and set everything back to 0. Just upgraded to JR 6 and would like to start with a clean slate. Read the post that JR 5 didn't have the feature anymore, and that we would need to empty cells in the DB. Does JR 6 have the reset stats? If not, what tables/rows do I need to set to 0 to start again (I'd use phpmyadmin).
updated by @jammerpro: 03/12/20 08:16:39PM
paul
@paul
5 years ago
4,325 posts
Unfortunately not. Also, in JR6, there is no one table to reset them all in. The various 'stats' for each modue are saved in the modules' datastore tables (jr_jraudio_item_key for example). What you need to look for in these tables are 'key' fields ending in '_count', so in the Audio datastore table, 'audio_file_stream_count' is the number of times that item has been streamed, so in this case you could run the query -

UPDATE jr_jraudio_item_key SET `value` = 0 WHERE `key` = 'audio_file_stream_count'

Standard warning when suggesting users update their databases directly - be careful - its easy to break things :-)


--
Paul Asher - JR Developer and System Import Specialist

Tags