<?php
require'fun.php';
require'f_conectare.php';
conectare('statistici','statistici');
$head[1]='statisticile site-ului '.$adresasite[1];
$titlu='Statistici';
$back[1]='<a href="/extra-meniu">'.img('extra.png',1).'Extra meniu</a>';
require'f_sus.php';
if($de>0)
require'f_nou.php';
require'f_profil.php';
$maxim_conectati=$conn->query('SELECT`nume`,`valoare`FROM`setari`WHERE`id`="2"')->fetch_row();
$tm24=$_SERVER['REQUEST_TIME']-86400;
$maxim_conectati_azi=$conn->query('SELECT`ppl`,`dtm`FROM`maxim_conectati`WHERE`ddt`="'.date('d-m-Y').'"')->fetch_row();
require'f_data.php';
echo$div[4].img('statistici.gif',1).'Statistici'.$div[5].$div[1].'<a href="/membrii-inregistrati">Membrii înregistrați</a> <strong>'.number_format($conn->query('SELECT COUNT(*)FROM`membrii`')->fetch_row()[0]).'</strong>'.$div[0].$div[1].'<a href="/baieti"><img src="'.$domenii_statice[1].'male.png" alt="" width="16" height="16" />Baieti</a> <strong>'.number_format($conn->query('SELECT COUNT(*)FROM`membrii`WHERE`sex`="M"')->fetch_row()[0]).'</strong>'.$div[0].$div[1].'<a href="/fete"><img src="'.$domenii_statice[2].'female.png" alt="" width="16" height="16" />Fete</a> <strong>'.number_format($conn->query('SELECT COUNT(*)FROM`membrii`WHERE`sex`="F"')->fetch_row()[0]).'</strong>'.$div[0].$div[1].'Cel mai nou membru este '.profil($conn->query('SELECT`id`FROM`membrii`ORDER BY`data`DESC LIMIT 1')->fetch_row()[0]).$div[0].$div[1].'Cei mai mulți online: <strong>'.$maxim_conectati[1].'</strong> - '.data($maxim_conectati[0]).$div[0].$div[1].'<a href="/membrii-conectati-zilnic">'.img('statistici.gif',1).'Membrii conectați zilnic</a>'.$div[0].$div[1].'<a href="/statistici-membrii-activi">'.img('statistici.gif',1).'Statistici membrii activi</a>'.$div[0].$div[1].'Vizite totale: <strong>'.$conn->query('SELECT`valoare`FROM`setari`WHERE`nume`="total_vizite"')->fetch_row()[0].'</strong>'.$div[0].$div[1].'<a href="/topuri">'.img('topuri.gif',2).'Topuri</a>'.$div[0].$div[1].'<a href="/simboluri">'.img('simboluri.gif',2).'Simboluri</a>'.$div[0].$div[1].'<a href="/reputatie">'.img('reputatie.gif',1).'Reputatie</a>'.$div[0].$div[1].'<a href="/avatare">'.img('setari.png',2).'Avatare</a> <strong>'.number_format($conn->query('SELECT COUNT(*)FROM`imagini_avatare`')->fetch_row()[0]).'</strong>'.$div[0].$div[1].'<a href="/zambareti">Zambareti</a> <strong>'.number_format($conn->query('SELECT COUNT(*)FROM`imagini_zambareti`WHERE`vizibil`="0"')->fetch_row()[0]).'</strong>'.$div[0].($perm>1?$div[1].'<a href="/zambareti/id/1">Zambareti invizibili</a> <strong>'.number_format($conn->query('SELECT COUNT(*)FROM`imagini_zambareti`WHERE`vizibil`="1"')->fetch_row()[0]).'</strong>'.$div[0]:'').$div[4].img('statistici.gif',1).'Statistici azi'.$div[5].$div[1].'<a href="/membrii-sarbatoriti">'.img('aniversare.gif',2).'Membrii sarbatoriti</a> <strong>'.number_format($conn->query('SELECT COUNT(*)FROM`membrii`WHERE month(`data_nastere`)=month(curdate())&&dayofmonth(`data_nastere`)=dayofmonth(curdate())')->fetch_row()[0]).'</strong>'.$div[0].$div[1].'<a href="/membrii-activi">'.img('statistici.gif',1).'Membrii activi în ultimele 24 de ore</a> <strong>'.number_format($conn->query('SELECT COUNT(*)FROM`membrii`WHERE`activitate`>"'.$tm24.'"')->fetch_row()[0]).'</strong>'.$div[0].$div[1].'Cei mai mulți online: <strong>'.$maxim_conectati_azi[0].'</strong> la ora '.$maxim_conectati_azi[1].$div[0].$div[1].'Membrii înregistrați: <strong>'.number_format($conn->query('SELECT COUNT(*)FROM`membrii`WHERE`data`>"'.$tm24.'"')->fetch_row()[0]).'</strong>'.$div[0].$div[1].'Alerte: <strong>'.number_format($conn->query('SELECT COUNT(*)FROM`alerte`WHERE`data`>"'.$tm24.'"')->fetch_row()[0]).'</strong>'.$div[0].$div[1].'Mesaje: <strong>'.number_format($conn->query('SELECT COUNT(*)FROM`mesaje`WHERE`data`>"'.$tm24.'"')->fetch_row()[0]).'</strong>'.$div[0].$div[1].'Notificări: <strong>'.number_format($conn->query('SELECT COUNT(*)FROM`notificari`WHERE`data`>"'.$tm24.'"')->fetch_row()[0]).'</strong>'.$div[0].$div[1].'Mesaje instant: <strong>'.number_format($conn->query('SELECT COUNT(*)FROM`mesaje_instant`WHERE`data`>"'.$tm24.'"')->fetch_row()[0]).'</strong>'.$div[0].$div[1].'Mesaje instant admini: <strong>'.number_format($conn->query('SELECT COUNT(*)FROM`mesaje_instant_admini`WHERE`data`>"'.$tm24.'"')->fetch_row()[0]).'</strong>'.$div[0].$div[1].'Topicuri: <strong>'.number_format($conn->query('SELECT COUNT(*)FROM`forum_topicuri`WHERE`data`>"'.$tm24.'"')->fetch_row()[0]).'</strong>'.$div[0].$div[1].'Postări: <strong>'.number_format($conn->query('SELECT COUNT(*)FROM`forum_postari`WHERE`data`>"'.$tm24.'"')->fetch_row()[0]).'</strong>'.$div[0].$div[1].'Chestionare: <strong>'.number_format($conn->query('SELECT COUNT(*)FROM`chestionar_intrebari`WHERE`data`>"'.$tm24.'"')->fetch_row()[0]).'</strong>'.$div[0].$div[1].'Membrii în grupuri: <strong>'.number_format($conn->query('SELECT COUNT(*)FROM`grup_membrii`WHERE`data`>"'.$tm24.'"&&`citit`>"0"')->fetch_row()[0]).'</strong>'.$div[0].$div[1].'Prieteni adaugati: <strong>'.number_format($conn->query('SELECT COUNT(*)FROM`prieteni`WHERE`data`>"'.$tm24.'"&&`citit`>"0"')->fetch_row()[0]).'</strong>'.$div[0].$div[1].'Comentarii profil: <strong>'.number_format($conn->query('SELECT COUNT(*)FROM`comentarii_profil`WHERE`data`>"'.$tm24.'"')->fetch_row()[0]).'</strong>'.$div[0].$div[1].'Comentarii poze: <strong>'.number_format($conn->query('SELECT COUNT(*)FROM`galerie_comentarii`WHERE`data`>"'.$tm24.'"')->fetch_row()[0]).'</strong>'.$div[0].$div[1].'Jurnal pentru administratori: <strong>'.number_format($conn->query('SELECT COUNT(*)FROM`jurnal_admini`WHERE`data`>"'.$tm24.'"')->fetch_row()[0]).'</strong>'.$div[0];
require'f_jos.php';