//functions.php:

function stats($con, $date, $table) {

	rlog(__FUNCTION__ ." start\r\n");

	rlog(date("Y-m-d H:i:s")." Start...".$date."\r\n");

	$do = "0";

	$statement = $con->prepare('SELECT * FROM msl_'.$table.' WHERE date = ? LIMIT 1');

	$statement->execute([$date]);

	while ($row = $statement->fetch()) { 

		$do += $row["hits"];

	}

	if ($do == "0") {

		$statement = $con->prepare('INSERT INTO msl_'.$table.' (date, hits) VALUES (?, ?)');

		$statement->execute([$date, '1']);

	}

	else {

		$statement = $con->prepare('UPDATE msl_'.$table.' SET hits = hits + 1 WHERE date = ? ');

		$statement->execute([$date]);

	}

	echo "\r\n<span style='color:orange;'>".$do."</span><br>\r\n";

	rlog(date("Y-m-d H:i:s")." UPDATE msl_".$table." SET hits = hits + 1 WHERE date = ".$date."\r\n");

	rlog(date("Y-m-d H:i:s")." Finish...".$date."\r\n");

}

//credentials.php:

//==================================================================================

include "include.php";

// TODAY'S HITS

$xdate = date("n/j/Y");

stats($link, $xdate, "today");

// THIS MONTH'S HITS

$xdate = date("n/Y");

stats($link, $xdate, "month");

// THIS YEAR'S HITS

$xdate = date("Y");

stats($link, $xdate, "year");

// HITS

$ip = $_SERVER["REMOTE_ADDR"];

totalips($link, $ip);

//==================================================================================

//include.php:

session_start();

date_default_timezone_set("America/Los_Angeles");

include "sql.php";

include "functions.php";

include "tables.php";

include "iploc.php";

include "geshi.php";

include "restore.php";

include "ban.php";