blog documentation FAQ followers forum marketplace services youtube

solved Reset stats option

The Jamroom Network » Forum » Using Jamroom » Page » Reset stats option
alt=
@perfectgamestudios
11 years ago
106 posts
Hello is it possible to reset stats from some of the older profiles that were imported from jamroom 4
updated by @perfectgamestudios: 05/02/14 12:09:18AM
paul
@paul
11 years ago
4,335 posts
Not directly. Could maybe do things indirectly on the database.
Which stats do you want to reset? IIRC site visits and media streams are imported from JR4.


--
Paul Asher - JR Developer and System Import Specialist
alt=
@perfectgamestudios
11 years ago
106 posts
was looking at site visits at trying to reset are they in profile table or another table
paul
@paul
11 years ago
4,335 posts
Yeah, they are in the profile table. Something like this should do it -

UPDATE jr_jrprofile_item_key SET `value` = 0 WHERE `key` = 'profile_view_count'

(As always, backup the table first)


--
Paul Asher - JR Developer and System Import Specialist
alt=
@perfectgamestudios
11 years ago
106 posts
thanks that did the trick just wanted to reset some of the old jamroom 4 profiles since I getting lot of new signups as getting average 15 new signups a day since using jamroom 5 :)

Tags