blog documentation FAQ followers forum marketplace services youtube

solved Resetting Jamroom 5 stats

The Jamroom Network » Forum » Using Jamroom » Page » Resetting Jamroom 5 stats
johnchansa
@johnchansa
10 years ago
195 posts
How do I go about resetting stats on youtube,audio and soundcloud plays?
The stats were imported from my JR4 site.I feel they are affecting my music and video charts as those with the highest number of plays(the oldest tracks) are still in the top 10.
Any help is welcome.
updated by @johnchansa: 10/07/14 04:34:17PM
brian
@brian
10 years ago
10,148 posts
You will need to run these SQL queries (1 at a time) from the Developer Module -> Browse Database tool:

DELETE FROM jr_jryoutube_item_key WHERE `key` = 'youtube_stream_count';

DELETE FROM jr_jraudio_item_key WHERE `key` = 'audio_stream_count';

DELETE FROM jr_jrsoundcloud_item_key WHERE `key` = 'soundcloud_stream_count';

Hope this helps!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
johnchansa
@johnchansa
10 years ago
195 posts
The SQL queries worked for youtube and soundcloud.There was no change with the audio files.Could this modification work?
.....'key' = 'audio_file_stream_count';....
paul
@paul
10 years ago
4,326 posts
Yeah - That'll do it.

DELETE FROM jr_jraudio_item_key WHERE `key` = 'audio_file_stream_count';


--
Paul Asher - JR Developer and System Import Specialist
brian
@brian
10 years ago
10,148 posts
Ahh sorry - yes that is the correct key for the audio module.

Thanks!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
johnchansa
@johnchansa
10 years ago
195 posts
Great!!....All plays have been reset to zero

Thanks a million...
brian
@brian
10 years ago
10,148 posts
johnchansa:
Great!!....All plays have been reset to zero

Thanks a million...

Glad to hear it - thanks!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

Tags