*/ require 'config/configV2.php'; require _TPL_TOP_; // Stats Images $reqImage = maBDD::getInstance()->query("SELECT COUNT(*) AS nb, SUM(nb_view_v4 * size) AS bpv4, SUM(nb_view_v6 * size) AS bpv6, SUM(nb_view_v4 + nb_view_v6) AS nbAff, SUM(size) as totSize FROM images"); /* @var $reqImage PDOStatement */ // Je récupère les valeurs $valImage = $reqImage->fetch(); // Stats Miniatures $reqMiniature = maBDD::getInstance()->query("SELECT COUNT(*) AS nb, SUM(nb_view_v4 * size) AS bpv4, SUM(nb_view_v6 * size) AS bpv6, SUM(nb_view_v4 + nb_view_v6) AS nbAff, SUM(size) as totSize FROM thumbnails"); /* @var $reqMiniature PDOStatement */ // Je récupère les valeurs $valMiniature = $reqMiniature->fetch(); // Stats membres $reqMembre = maBDD::getInstance()->query("SELECT COUNT(*) AS nb FROM membres"); /* @var $reqMembre PDOStatement */ // Je récupère les valeurs $valMembre = $reqMembre->fetch(); // Stats membres -> possède $reqPossede = maBDD::getInstance()->query("SELECT COUNT(*) AS nb FROM possede"); /* @var $reqPossede PDOStatement */ // Je récupère les valeurs $valPossede = $reqPossede->fetch(); // Bande passante $bp_v4 = $valImage->bpv4 + $valMiniature->bpv4; $bp_v6 = $valImage->bpv6 + $valMiniature->bpv6; $bp_all = $bp_v4 + $bp_v6; // Nombre d'affichages $nb_view_all = $valImage->nbAff + $valMiniature->nbAff; // Taille totale $size_all = $valImage->totSize + $valMiniature->totSize; ?>

Statistiques