FM / Client

/home/techb158/immovalet.ca/Client

Name	Size	Mode	Actions
CVUploadedFiles/	-	0777	rm
img/	-	0777	rm
Inc/	-	0777	rm
stripe-php/	-	0777	rm
alertes_jumelages.php	5657	0666	edit dl rm
archives_cv.php	5738	0666	edit dl rm
authorizedpage.php	1216	0666	edit dl rm
counter.php	3513	0666	edit dl rm
CV_Upload.php	4180	0666	edit dl rm
dashboard.php	10141	0666	edit dl rm
footer.php	2440	0666	edit dl rm
head.php	3319	0666	edit dl rm
header.php	1162	0666	edit dl rm
mes_applications.php	7970	0666	edit dl rm
mes_factures.php	7710	0666	edit dl rm
mes_produits.php	6551	0666	edit dl rm
mes_rapports.php	6239	0666	edit dl rm
modifier_profil.php	22295	0666	edit dl rm
plan_valeurs.php	7572	0666	edit dl rm
plan_valeurs_checkout.php	8612	0666	edit dl rm
print_invoice.php	4583	0666	edit dl rm
removefile.php	1201	0666	edit dl rm
submit_checkout.php	4143	0666	edit dl rm
upload.php	2269	0666	edit dl rm

Edit: /home/techb158/immovalet.ca/Client/counter.php (3513B)

<?php

// Hit counter function.
// Your probably want to remove lines that report errors. If not your website could stop working if, for example, your database is down.

//include("common_M.php");

//include_once '../includes/db_connect.php';
//include_once '../includes/functions.php';
include '../includes/db_connect.php';
include '../includes/psl-config.php';
//sec_session_start();

function addinfo($page)
{ 
	//echo $page;
	//die ("Can't use database $dbname! : " . $page);
// ################################################
// ######### connect + select  database ###########
// ################################################

//global $dbhost, $dbuser, $dbpass, $dbname, $dbtablehits,$dbtableinfo,$maxrows; 
    //
	//$link = mysqli_connect($dbhost, $dbuser, $dbpass); 
	//
	//if (!$link) 
	//{
	//    die('Could not connect: ' . mysqli_error());  // remove ?
	//}	
    //
	//$dbselect=mysqli_select_db($link,$dbname); 
	//if (!$dbselect) 
	//{
    //	die ("Can't use database $dbname! : " . mysqli_error()); // remove ?
	//}
	// ######################
// ### get total hits ###
// ######################
	
	//$query = "SELECT SUM(count) AS totalhits FROM hits WHERE page = '$page'"; 	 
	//$result = mysqli_query($mysqli,$query) or die(mysqli_error());
	//
	//while($row = mysqli_fetch_array($result))
	//{
	//	$totalhits = $row['totalhits']  ;
	//}
	
	$querys = "SELECT SUM(count) AS totalhits FROM hits WHERE page = '".$page."'";		
	$results = $mysqli->query($querys);	
	
	while($row = $results->fetch_assoc())
	{
		$totalhits = $row['totalhits'];
	}
	
// ########################################################
// ######### check if counter exsist and update ###########
// ########################################################

if(mysqli_num_rows(mysqli_query($mysqli,"SELECT page FROM $dbtablehits WHERE page = '$page'")))
	{
		$totalhits++;
	//A counter for this page  already exsists. Now we have to update it.

$updatecounter = mysqli_query($mysqli,"UPDATE $dbtablehits SET count = '$totalhits' WHERE page = '$page'");
		if (!$updatecounter) 
		{
		die ("Can't update the counter : " . mysqli_error()); // remove ?
		}
	
	} 
	else
	{
	// This page did not exsist in the counter database. A new counter must be created for this page.

$insert = mysqli_query($mysqli,"INSERT INTO $dbtablehits (page, count)VALUES ('$page', '1')");
	
		if (!$insert) 
		{
    		die ("Can\'t insert into $dbtablehits : " . mysqli_error()); // remove ?
		}
	}
	
// ####################################################
// ######### add IP and user-agent and time ###########
// ####################################################

// gather user data
$ip= $_SERVER["REMOTE_ADDR"]; 
$agent =$_SERVER["HTTP_USER_AGENT"];
$datetime =date("Y/m/d") . ' ' . date('H:i:s') ;

if(!mysqli_num_rows(mysqli_query($mysqli,"SELECT ip_address FROM info WHERE ip_address = '$ip'"))) // check if the IP is in database
{
	
	// if not , add it.	
	$adddata = mysqli_query($mysqli,"INSERT INTO $dbtableinfo (ip_address, user_agent, datetime) VALUES('$ip' , '$agent','$datetime' ) ") ;
	if (!$adddata) 
	{
	    die('Could not add IP : ' . mysqli_error()); // remove ?
	}
}

// ***************************************************************
// ** delete the first entry in $dbtableinfo if rows > $maxrows **
// ***************************************************************

mysqli_close($mysqli);

}

query($querys); while($row = $results->fetch_assoc()) { $totalhits = $row['totalhits']; } // ######################################################## // ######### check if counter exsist and update ########### // ######################################################## if(mysqli_num_rows(mysqli_query($mysqli,"SELECT page FROM $dbtablehits WHERE page = '$page'"))) { $totalhits++; //A counter for this page already exsists. Now we have to update it. $updatecounter = mysqli_query($mysqli,"UPDATE $dbtablehits SET count = '$totalhits' WHERE page = '$page'"); if (!$updatecounter) { die ("Can't update the counter : " . mysqli_error()); // remove ? } } else { // This page did not exsist in the counter database. A new counter must be created for this page. $insert = mysqli_query($mysqli,"INSERT INTO $dbtablehits (page, count)VALUES ('$page', '1')"); if (!$insert) { die ("Can\'t insert into $dbtablehits : " . mysqli_error()); // remove ? } } // #################################################### // ######### add IP and user-agent and time ########### // #################################################### // gather user data $ip= $_SERVER["REMOTE_ADDR"]; $agent =$_SERVER["HTTP_USER_AGENT"]; $datetime =date("Y/m/d") . ' ' . date('H:i:s') ; if(!mysqli_num_rows(mysqli_query($mysqli,"SELECT ip_address FROM info WHERE ip_address = '$ip'"))) // check if the IP is in database { // if not , add it. $adddata = mysqli_query($mysqli,"INSERT INTO $dbtableinfo (ip_address, user_agent, datetime) VALUES('$ip' , '$agent','$datetime' ) ") ; if (!$adddata) { die('Could not add IP : ' . mysqli_error()); // remove ? } } // *************************************************************** // ** delete the first entry in $dbtableinfo if rows > $maxrows ** // *************************************************************** mysqli_close($mysqli); } ?>