\n";
global $xoopsDB, $xoopsUser;
OpenTable();
if (!isset($_POST["ord"])) {
$ord = isset($_GET["ord"]) ? $_GET["ord"] : "";
} else {
$ord = $_POST["ord"];
}// if
if ($ord == "") {
$ordre = "visitname";
$sort_ordre = "ASC";
$ord_text = ""._MD_USERVISIT_NAME."";
}
if ($ord == "1") {
$ordre = "nnvisit";
$sort_ordre = "DESC";
$ord_text = ""._MD_USERVISIT_PAGESVIEW."";
}
if ($ord == "2") {
$ordre = "cvisit";
$sort_ordre = "DESC";
$ord_text = ""._MD_USERVISIT_VISITS."";
}
if ($ord == "3") {
$ordre = "tempsf";
$sort_ordre = "DESC";
$ord_text = ""._MD_USERVISIT_LAST_VISITS."";
}
echo ""._MD_USERVISIT_HEADER." ".$xoopsConfig['sitename']."";
echo "
";
$visit = $xoopsDB->query("SELECT tempsf, visitname, Sum(nvisit) as nnvisit, count(nvisit) as cvisit ,nvisit FROM ".$xoopsDB->prefix("visit_user")." GROUP BY visitname ORDER BY $ordre $sort_ordre");
//$visit2 = $xoopsDB->query("SELECT tempsf, visitname, Sum(nvisit) as nnvisit, count(nvisit) as cvisit ,nvisit FROM ".$xoopsDB->prefix("visit_user")." GROUP BY tempsf ORDER BY $ordre $sort_ordre");
$visi=mysql_NumRows($visit);
if($visi == 0)
{
echo ""._MD_USERVISIT_NOVISIT."
";
}
else
{
echo ""._MD_USERVISIT_MEMBERS." $visi
"._MD_USERVISIT_RANKING." $ord_text
";
echo "
| N° |
"._MD_USERVISIT_NAME." |
"._MD_USERVISIT_PAGESVIEWS." |
"._MD_USERVISIT_VISITS." |
"._MD_USERVISIT_OPTIONS." |
";
$i=0;
while ($i < $visi)
{
$nnvisit = mysql_result($visit, $i, "nnvisit");
$ccvisit = mysql_result($visit, $i, "cvisit");
$nom = mysql_result($visit, $i, "visitname");
$nvisite = mysql_result($visit, $i, "nvisit");
// $lastvisit_1 = mysql_result($visit2, $i, "tempsf");
// $lastvisit = date("j-m-Y H:i:s" ,$lastvisit_1);
$i++;
echo "
| $i |
$nom |
$nnvisit |
$ccvisit |
[ "._MD_USERVISIT_DETAILS." | "._MD_USERVISIT_DELET." ] |
";
}
echo "
";
echo "[ "._MD_USERVISIT_DELALLSTATS." ]
";
}
CloseTable();
include("../include/admin_footer.php");
?>