";
echo "Informations";
echo "Adresse relative de ce fichier : $PHP_SELF Racine du script courant : $DOCUMENT_ROOT Nom du serveur : $SERVER_NAME Chaine d'identification du serveur : $SERVER_SOFTWARE ";
echo "Protocole de communication : $SERVER_PROTOCOL Navigateur : $HTTP_USER_AGENT ";
if($SERVER_SIGNATURE==''){
$SERVER_SIGNATURE="Aucune";
}
echo "Signature serveur : $SERVER_SIGNATURE ";
echo " Nombre de forums créés : $nb_forum Nombre de membres inscrits : $nb_user Nombre de messages postés : $nb_postes ";
echo " Quelques listes ";
echo "Connectés en ce moment (Sessions 5 minutes) : ";
$re15=mysql_query("select DISTINCT user from atk_sessions order by user");
$f=mysql_num_rows($re15);
for($y=0;$y<$f;$y++){
$user=mysql_result($re15,$y,"user");
echo "$user ";
};
echo " Liste des Forums : ";
$re=mysql_query("select id,title,filename from atk_forums order by id");
$n=mysql_num_rows($re);
for($i=0;$i<$n;$i++){
$id=mysql_result($re,$i,"id");
$title=mysql_result($re,$i,"title");
$filename=mysql_result($re,$i,"filename");
echo "$title, ";
};
echo " Liste des Membres : ";
$re2=mysql_query("select admin,login from atk_users order by login");
while($var = mysql_fetch_array($re2)){
$login = $var["login"];
$admin = $var["admin"];
if ($admin=='1') {
$login = "$login";
}
elseif ($admin=='63') {
$login = "$login";
}
else {
$login = "$login";
}
echo "$login, ";
};
echo " Administrateurs du Systeme : ";
$re3=mysql_query("select login,admin from atk_users where admin='63' order by login");
$o=mysql_num_rows($re3);
for($k=0;$k<$o;$k++){
$login2=mysql_result($re3,$k,"login");
$admin=mysql_result($re3,$k,"admin");
echo "$login2, ";
};
echo " Administrateurs de Forums : ";
$re4=mysql_query("select login,admin from atk_users where admin='1' order by login");
$p=mysql_num_rows($re4);
for($l=0;$l<$p;$l++){
$login3=mysql_result($re4,$l,"login");
$admin=mysql_result($re4,$l,"admin");
echo "$login3, ";
};
echo " Calculs et Moyennes ";
$moyenneposts = ($nb_postes/$nb_user);
$moyennepostsb = ($nb_postes/$nb_user);
$moyenneposts2 = ($nb_postes/$nb_forum);
$moyenneposts2b = ($nb_postes/$nb_forum);
if ($moyenneposts < 10) {
$moyennepostsb = substr($moyenneposts,0,1);
}
elseif ($moyenneposts < 100) {
$moyennepostsb = substr($moyenneposts,0,2);
}
elseif ($moyenneposts < 1000) {
$moyennepostsb = substr($moyenneposts,0,3);
}
elseif ($moyenneposts < 10000) {
$moyennepostsb = substr($moyenneposts,0,4);
}
elseif ($moyenneposts < 100000) {
$moyennepostsb = substr($moyenneposts,0,5);
}
if ($moyenneposts2 < 10) {
$moyenneposts2b = substr($moyenneposts2,0,1);
}
elseif ($moyenneposts2 < 100) {
$moyenneposts2b = substr($moyenneposts2,0,2);
}
elseif ($moyenneposts2 < 1000) {
$moyenneposts2b = substr($moyenneposts2,0,3);
}
elseif ($moyenneposts2 < 10000) {
$moyenneposts2b = substr($moyenneposts2,0,4);
}
elseif ($moyenneposts2 < 100000) {
$moyenneposts2b = substr($moyenneposts2,0,5);
}
echo " Moyenne de Posts / Membres : $moyennepostsb (Moyenne exacte : $moyenneposts)";
echo " Moyenne de Posts / Forums : $moyenneposts2b (Moyenne exacte : $moyenneposts2) ";
echo "Moyennes des Posts / Membres ";
echo " ";
$re5=mysql_query("select login,nb_post from atk_users where nb_post<>'0' order by nb_post desc");
$q=mysql_num_rows($re5);
for($a=0;$a<$q;$a++){
$login4=mysql_result($re5,$a,"login");
$nb_post=mysql_result($re5,$a,"nb_post");
$moyenneperso = (($nb_post*100)/$nb_postes);
$moyenneperso2 = ($moyenneperso*3.5);
$compteur++;
$pourcentage1 = (($nb_post*100)/$nb_postes);
if (strlen($pourcentage1) > 4) {
$pourcentage1b = substr($pourcentage1,0,4);
}
if ($pourcentage1b < 10) {
$pourcentage1b = "0".$pourcentage1b;
}
if (strlen($pourcentage1b) > 4) {
$pourcentage1c = substr($pourcentage1b,0,4);
}
else {
$pourcentage1c = $pourcentage1b;
}
echo "$compteur | $login4 | $nb_post / $nb_postes | $pourcentage1c% | | ";
};
echo " ";
echo "Moyennes des Posts / Forums ";
echo " ";
$re6=mysql_query("select id,title,nb_post,filename from atk_forums where nb_post!='0' order by nb_post desc");
$r=mysql_num_rows($re6);
for($b=0;$b<$r;$b++){
$title2=mysql_result($re6,$b,"title");
$nb_post=mysql_result($re6,$b,"nb_post");
$id_forum=mysql_result($re6,$b,"id");
$filename=mysql_result($re6,$b,"filename");
$moyenneforum = (($nb_post*100)/$nb_postes);
$moyenneforum2 = ($moyenneforum*3.5);
$compteur2++;
$pourcentage2 = (($nb_post*100)/$nb_postes);
if (strlen($pourcentage2) > 4) {
$pourcentage2b = substr($pourcentage2,0,4);
}
if ($pourcentage2b < 10) {
$pourcentage2b = "0".$pourcentage2b;
}
if (strlen($pourcentage2b) > 4) {
$pourcentage2c = substr($pourcentage2b,0,4);
}
else {
$pourcentage2c = $pourcentage2b;
}
$nb_postforum=dbgetfirst("SELECT count(*) FROM atk_posts where forum='$id_forum'");
echo "$compteur2 | $title2 | $nb_postforum | $pourcentage2c% | | ";
};
echo " ";
echo " ";
echo " Inscription en date ";
echo " ";
$re8=mysql_query("select login,subscribe,nb_post from atk_users where nb_post!='0' order by login");
while($var = mysql_fetch_array($re8)){
$login = $var["login"];
$subscribe = $var["subscribe"];
$nb_post = $var["nb_post"];
$now = time();
$duree = $now - $subscribe;
$jour = $duree / (24*60*60);
$semaine = $jour / 7;
if ($jour < 10) {
$jour2 = substr($jour,0,1);
}
elseif ($jour < 100) {
$jour2 = substr($jour,0,2);
}
elseif ($jour < 1000) {
$jour2 = substr($jour,0,3);
}
elseif ($jour < 10000) {
$jour2 = substr($jour,0,4);
}
elseif ($jour < 100000) {
$jour2 = substr($jour,0,5);
}
if ($semaine < 10) {
$semaine2 = substr($semaine,0,3);
}
elseif ($semaine < 100) {
$semaine2 = substr($semaine,0,4);
}
elseif ($moyenne1 < 1000) {
$semaine2 = substr($semaine,0,5);
}
elseif ($moyenne1 < 10000) {
$semaine2 = substr($semaine,0,6);
}
elseif ($moyenne1 < 100000) {
$semaine2 = substr($semaine,0,7);
}
echo "$login | Inscrit depuis $jour2 jours ($semaine2 semaines) | ";
};
echo " ";
echo " | ";
echo "";
echo " Nombres de messages par jour ";
echo " ";
$re9=mysql_query("select login,subscribe,nb_post from atk_users where nb_post!='0' order by login");
while($var = mysql_fetch_array($re9)){
$login = $var["login"];
$subscribe = $var["subscribe"];
$nb_post = $var["nb_post"];
$now = time();
$duree = $now - $subscribe;
$jour = $duree / (24*60*60);
$moyenne1 = $nb_post / $jour;
if ($moyenne1 < 10) {
$moyenne1b = substr($moyenne1,0,1);
}
elseif ($moyenne1 < 100) {
$moyenne1b = substr($moyenne1,0,2);
}
elseif ($moyenne1 < 1000) {
$moyenne1b = substr($moyenne1,0,3);
}
elseif ($moyenne1 < 10000) {
$moyenne1b = substr($moyenne1,0,4);
}
elseif ($moyenne1 < 100000) {
$moyenne1b = substr($moyenne1,0,5);
}
echo "$login | $moyenne1b messages par jour | ";
};
echo " ";
echo " | ";
echo " | ";
echo "Liste des 5 derniers messages";
echo" ";
$re12=mysql_query("select DISTINCT title,id,forum,sender,num,date,visited,nb_answer from atk_posts where num=0 order by id desc LIMIT 0,5");
$e=mysql_num_rows($re12);
for($x=0;$x<$e;$x++){
$title=mysql_result($re12,$x,"title");
$title2=mysql_result($re12,$x,"title");
$sender=mysql_result($re12,$x,"sender");
$visited=mysql_result($re12,$x,"visited");
$nb_answer=mysql_result($re12,$x,"nb_answer");
$date=mysql_result($re12,$x,"date");
$id_post=mysql_result($re12,$x,"id");
$num=mysql_result($re12,$x,"num");
$forum=mysql_result($re12,$x,"forum");
$re13=mysql_query("select filename from atk_forums where id='$forum'");
$filename=mysql_result($re13,"filename");
$PF["local_time"] = date("H:i");
$date=date($LANG["FORMAT-DATE"],$date+($PF["local_time"]*3600-68400));
if ($nb_answer < 10) {
$nb_answer = "0".$nb_answer;
}
if ($visited < 10) {
$visited = "0".$visited;
}
if (strlen($title) > 25) {
$title = substr($title,0,21);
$title .= "...";
}
$re14=mysql_query("select admin,login from atk_users where login='$sender'");
while($var = mysql_fetch_array($re14)){
$login = $var["login"];
$admin = $var["admin"];
}
if ($admin!='0') {
$sender = "$sender";
}
else {
$sender = "$sender";
}
echo "$title | Posté par $sender | $date | Lu $visited fois | $nb_answer réponses | ";
};
echo " ";
echo "Liste des 5 messages qui comportent le plus de reponse ";
echo" ";
$re12=mysql_query("select DISTINCT title,id,forum,sender,num,date,visited,nb_answer from atk_posts where num=0 order by nb_answer desc LIMIT 0,5");
$e=mysql_num_rows($re12);
for($x=0;$x<$e;$x++){
$title=mysql_result($re12,$x,"title");
$title2=mysql_result($re12,$x,"title");
$sender=mysql_result($re12,$x,"sender");
$visited=mysql_result($re12,$x,"visited");
$nb_answer=mysql_result($re12,$x,"nb_answer");
$date=mysql_result($re12,$x,"date");
$id_post=mysql_result($re12,$x,"id");
$num=mysql_result($re12,$x,"num");
$forum=mysql_result($re12,$x,"forum");
$re13=mysql_query("select filename from atk_forums where id='$forum'");
$filename=mysql_result($re13,"filename");
$PF["local_time"] = date("H:i");
$date=date($LANG["FORMAT-DATE"],$date+($PF["local_time"]*3600-68400));
if ($nb_answer < 10) {
$nb_answer = "0".$nb_answer;
}
if ($visited < 10) {
$visited = "0".$visited;
}
if (strlen($title) > 25) {
$title = substr($title,0,21);
$title .= "...";
}
$re14=mysql_query("select admin,login from atk_users where login='$sender'");
while($var = mysql_fetch_array($re14)){
$login = $var["login"];
$admin = $var["admin"];
}
if ($admin!='0') {
$sender = "$sender";
}
else {
$sender = "$sender";
}
echo "$title | Posté par $sender | $date | Lu $visited fois | $nb_answer réponses | ";
};
echo " ";
echo "Liste des 5 messages les plus visités ";
echo" ";
$re12=mysql_query("select DISTINCT title,id,forum,sender,num,date,visited,nb_answer from atk_posts where num=0 order by visited desc LIMIT 0,5");
$e=mysql_num_rows($re12);
for($x=0;$x<$e;$x++){
$title=mysql_result($re12,$x,"title");
$title2=mysql_result($re12,$x,"title");
$sender=mysql_result($re12,$x,"sender");
$visited=mysql_result($re12,$x,"visited");
$nb_answer=mysql_result($re12,$x,"nb_answer");
$date=mysql_result($re12,$x,"date");
$id_post=mysql_result($re12,$x,"id");
$num=mysql_result($re12,$x,"num");
$forum=mysql_result($re12,$x,"forum");
$re13=mysql_query("select filename from atk_forums where id='$forum'");
$filename=mysql_result($re13,"filename");
$PF["local_time"] = date("H:i");
$date=date($LANG["FORMAT-DATE"],$date+($PF["local_time"]*3600-68400));
if ($nb_answer < 10) {
$nb_answer = "0".$nb_answer;
}
if ($visited < 10) {
$visited = "0".$visited;
}
if (strlen($title) > 25) {
$title = substr($title,0,21);
$title .= "...";
}
$re14=mysql_query("select admin,login from atk_users where login='$sender'");
while($var = mysql_fetch_array($re14)){
$login = $var["login"];
$admin = $var["admin"];
}
if ($admin!='0') {
$sender = "$sender";
}
else {
$sender = "$sender";
}
echo "$title | Posté par $sender | $date | Lu $visited fois | $nb_answer réponses | ";
};
echo " ";
echo "Nombre de membres par Owners ";
echo " ";
$re7=mysql_query("select DISTINCT owner from atk_users order by owner");
$s=mysql_num_rows($re7);
for($c=0;$c<$s;$c++){
$owner2=mysql_result($re7,$c,"owner");
$nb_postuersowner=dbgetfirst("SELECT count(*) FROM atk_users where owner='$owner2'");
if ($owner2=='') {
$owner2 = "Inconnu";
}
echo "$owner2 | $nb_postuersowner | ";
};
echo " ";
echo "
|