-
hi, the number of “plays” for a video are different in different places.
for example, in image, video plays at top say “83” – but graph shows 80 plays on 6 oct, 140 plays on 7 oct, another 80 on 8 oct, etc —– am i reading something wrong?if i look at raw sql db of sum plays for this video, i get a sum of 80 plays.
maybe you can tell us where the graph or the sum plays data is gathered from…?
-
-
lol – “83” is player id, not plays.
but it does say “80” plays in summary stats and db table – so im trying to understand the graph…
Hello Ryan,
Where in summary stats and DB table does it say the player got 80 plays?
The video playback stats are stored in
wp_fv_player_stats.To get a sum of plays for player #83 the SQL query would be:
SELECT sum(play) FROM `wp_fv_player_stats` WHERE id_player = 83;So it’s faily simple and I wonder where is FV Player giving the bad information of 80 plays.
Thanks,
Martin
the result of this query is 110… but the graph shows 120 plays on first day and many other plays after that… is what is confusing to me…
(it was 80 two days ago, 110 today… but graph still shows much more, yes?)
Hello Ryan,
I’m not sure why that query would not show the proper sum of the video plays.
What happens when you run it like this?
select play, date from wp_fv_player_stats where id_player = 732;Will it show proper daily counts of plays?
Please double-check that you are accessing the correct database too.
Thanks,
Martin
I think the stacked style of the graphs was merely confusing to me. You can close this. Thanks.
