somme de t0 à t# [ log(1 + x)/(1 + log(ny))]
t sur une journée
x ddl ou stream vue par jour unique
n = 1 ou 1.68
y = nombre d'episode
J'ai utilisé log10, test effectué sur 7, 15 et 30j.
Attention c'est indigeste
Stream - 7J - coef : 1
- Code : Tout sélectionner
[2803]Seikon no Qwaser - Jotei no Shouzou (int-16) = 15.064
[2684]Infinite Stratos Encore ? Koi ni kogareru rokujuusou = 12.695
[2636]Boku wa tomodachi ga sukunai OAV = 12.692
[2127]Black Rock Shooter = 12.533
[2765]Ai no Kusabi (2012) = 10.686
[2492]Mirai Nikki = 9.978
[2721]High School DxD = 9.855
[2319]Nichijou TV = 9.463
[2373]Amagami SS OAV = 9.453
[2748]Inu x Boku SS = 9.353
Stream - 7J - coef : 1.68
- Code : Tout sélectionner
[2803]Seikon no Qwaser - Jotei no Shouzou (int-16) = 12.294
[2684]Infinite Stratos Encore ? Koi ni kogareru rokujuusou = 10.361
[2636]Boku wa tomodachi ga sukunai OAV = 10.359
[2127]Black Rock Shooter = 10.229
[2721]High School DxD = 8.783
[2765]Ai no Kusabi (2012) = 8.721
[2319]Nichijou TV = 8.656
[2616]Boku wa tomodachi ga sukunai = 8.355
[2748]Inu x Boku SS = 8.301
[2627]Working?!! = 8.225
Stream - 15J - coef : 1
- Code : Tout sélectionner
[2684]Infinite Stratos Encore ? Koi ni kogareru rokujuusou = 24.106
[2636]Boku wa tomodachi ga sukunai OAV = 23.816
[2127]Black Rock Shooter = 23.612
[2765]Ai no Kusabi (2012) = 18.975
[2681]Dragon Ball: Episode of Bardock = 18.557
[2492]Mirai Nikki = 18.097
[2721]High School DxD = 18.001
[2373]Amagami SS OAV = 17.845
[2319]Nichijou TV = 17.589
[2616]Boku wa tomodachi ga sukunai = 17.22
Stream - 15J - coef : 1.68
- Code : Tout sélectionner
[2684]Infinite Stratos Encore ? Koi ni kogareru rokujuusou = 19.674
[2636]Boku wa tomodachi ga sukunai OAV = 19.437
[2127]Black Rock Shooter = 19.271
[2319]Nichijou TV = 16.088
[2721]High School DxD = 16.042
[2616]Boku wa tomodachi ga sukunai = 15.537
[2765]Ai no Kusabi (2012) = 15.486
[2373]Amagami SS OAV = 15.211
[2627]Working?!! = 15.155
[2681]Dragon Ball: Episode of Bardock = 15.145
Stream - 30J - coef : 1
- Code : Tout sélectionner
[2684]Infinite Stratos Encore ? Koi ni kogareru rokujuusou = 24.106
[2636]Boku wa tomodachi ga sukunai OAV = 23.816
[2127]Black Rock Shooter = 23.612
[2765]Ai no Kusabi (2012) = 18.975
[2681]Dragon Ball: Episode of Bardock = 18.557
[2492]Mirai Nikki = 18.097
[2721]High School DxD = 18.001
[2373]Amagami SS OAV = 17.845
[2319]Nichijou TV = 17.589
[2616]Boku wa tomodachi ga sukunai = 17.22
Stream - 30J - coef : 1.68
- Code : Tout sélectionner
[2684]Infinite Stratos Encore ? Koi ni kogareru rokujuusou = 19.674
[2636]Boku wa tomodachi ga sukunai OAV = 19.437
[2127]Black Rock Shooter = 19.271
[2319]Nichijou TV = 16.088
[2721]High School DxD = 16.042
[2616]Boku wa tomodachi ga sukunai = 15.537
[2765]Ai no Kusabi (2012) = 15.486
[2373]Amagami SS OAV = 15.211
[2627]Working?!! = 15.155
[2681]Dragon Ball: Episode of Bardock = 15.145
DDL - 7J - coef : 1
- Code : Tout sélectionner
[2803]Seikon no Qwaser - Jotei no Shouzou (int-16) = 13.512
[2127]Black Rock Shooter = 9.141
[2721]High School DxD = 7.747
[2394]Highschool of the Dead: Drifters of the Dead = 7.456
[2729]Zero no tsukaima F = 7.165
[2398]Kaichou wa Maid-sama! - Lala special = 7.086
[2749]Papa no Iukoto wo Kikinasai! = 6.831
[2765]Ai no Kusabi (2012) = 6.824
[2681]Dragon Ball: Episode of Bardock = 6.771
[2718]Macross Frontier: Sayonara no Tsubasa = 6.761
DDL - 7J - coef : 1.68
- Code : Tout sélectionner
[2803]Seikon no Qwaser - Jotei no Shouzou (int-16) = 11.028
[2127]Black Rock Shooter = 7.46
[2721]High School DxD = 6.904
[2729]Zero no tsukaima F = 6.385
[2394]Highschool of the Dead: Drifters of the Dead = 6.085
[2749]Papa no Iukoto wo Kikinasai! = 6.063
[2761]Aquarion Evol = 5.983
[2398]Kaichou wa Maid-sama! - Lala special = 5.783
[2748]Inu x Boku SS = 5.719
[2724]Brave 10 = 5.715
DDL - 15J - coef : 1
- Code : Tout sélectionner
[2127]Black Rock Shooter = 20.454
[2681]Dragon Ball: Episode of Bardock = 16.305
[2721]High School DxD = 16.101
[2394]Highschool of the Dead: Drifters of the Dead = 15.397
[2729]Zero no tsukaima F = 14.868
[2724]Brave 10 = 14.614
[2684]Infinite Stratos Encore ? Koi ni kogareru rokujuusou = 13.683
[2803]Seikon no Qwaser - Jotei no Shouzou (int-16) = 13.512
[2689]Hidan No Aria OAV = 13.21
[2749]Papa no Iukoto wo Kikinasai! = 13.177
DDL - 15J - coef : 1.68
- Code : Tout sélectionner
[2127]Black Rock Shooter = 16.693
[2721]High School DxD = 14.349
[2681]Dragon Ball: Episode of Bardock = 13.307
[2729]Zero no tsukaima F = 13.25
[2724]Brave 10 = 12.971
[2394]Highschool of the Dead: Drifters of the Dead = 12.566
[2749]Papa no Iukoto wo Kikinasai! = 11.695
[2761]Aquarion Evol = 11.651
[2748]Inu x Boku SS = 11.428
[2684]Infinite Stratos Encore ? Koi ni kogareru rokujuusou = 11.167
DDL - 30J - coef : 1
- Code : Tout sélectionner
[2127]Black Rock Shooter = 36.256
[2681]Dragon Ball: Episode of Bardock = 31.072
[2721]High School DxD = 30.018
[2729]Zero no tsukaima F = 28.918
[2394]Highschool of the Dead: Drifters of the Dead = 26.04
[2749]Papa no Iukoto wo Kikinasai! = 26.012
[2765]Ai no Kusabi (2012) = 24.953
[2724]Brave 10 = 24.926
[2718]Macross Frontier: Sayonara no Tsubasa = 23.736
[2748]Inu x Boku SS = 23.548
DDL - 30J - coef : 1.68
- Code : Tout sélectionner
[2127]Black Rock Shooter = 29.59
[2721]High School DxD = 26.752
[2729]Zero no tsukaima F = 25.771
[2681]Dragon Ball: Episode of Bardock = 25.359
[2749]Papa no Iukoto wo Kikinasai! = 23.087
[2724]Brave 10 = 22.123
[2394]Highschool of the Dead: Drifters of the Dead = 21.252
[2604]Bakuman saison 2 = 21.192
[2748]Inu x Boku SS = 20.899
[2765]Ai no Kusabi (2012) = 20.365
Histoire de vérifier, voici la requete SQL :
[ log(1 + x)/(1 + log(ny))]
- Code : Tout sélectionner
SELECT LOG10(1 + (SELECT COUNT(DISTINCT(ipadress)) FROM stats_dl WHERE idfrmt=Sf.idfrmt AND (DATE(FROM_UNIXTIME(date)) = ?))) / (1 + LOG10
((SELECT COUNT(DISTINCT(numero)) FROM files WHERE idfrmt=Sf.idfrmt AND actif=1) * ?)) [...]
x = (SELECT COUNT(DISTINCT(ipadress)) FROM stats_dl WHERE idfrmt=Sf.idfrmt AND (DATE(FROM_UNIXTIME(date)) = ?))
n = ? (remplie ultérieurement dans la requete)
y = (SELECT COUNT(DISTINCT(numero)) FROM files WHERE idfrmt=Sf.idfrmt AND actif=1)
Le premier ? correspond à un jour au format : 2012-02-26
Et pour 7j par exemple, ça va faire 7 requete de ce type, avec 2012-02-26, puis 2012-02-25 etc... puis additionner le tout pour chaque série.