<?php
function ctcounter ($company,$myip,$area,$country,$sn,$CT){
//echo "fuc com:".$area;

 $servername = "127.0.0.1";
$username = "root";
$password = "fredsql";
$DBNAME = "tvicheck-st";

// Create connection
$conn = new mysqli($servername, $username, $password);

// Check connection
if ($conn->connect_error) {
  die("Connection failed: " . $conn->connect_error);
}
//echo "Connected successfully";


if( !mysqli_select_db($conn, $DBNAME)) {
  die ("無法選擇資料庫");
}
// 設定連線編碼
mysqli_query( $conn, "SET NAMES 'utf8'");	
	
date_default_timezone_set("Asia/Taipei");
$time = date('Y/m/d H:i:s', time());
//echo $time;	


///////////////////////////////////////////////////////////////////////////////////pbncounter		
$querys="select * from pbncounter where id='1'";	

$results =  mysqli_query($conn, $querys);

		$num = mysqli_num_rows( $results);
		//$obj = mysqli_fetch_object($results);
		
		
	if ($num > 0)
	{
		$row = mysqli_fetch_object($results);
		//$row = mysql_fetch_object($results);
		${$CT}=($row->$CT+1);
		$total=($row->CT1)+($row->CT9)+($row->CT12)+($row->CT23)+($row->CT21)+($row->CT84)+($row->CT18)+($row->CT18p)+($row->SCCA)+($row->CT60)+($row->DL)+($row->CT125)+($row->DP6)+($row->DP16)+1;
		
		}
		
		
$query = "update pbncounter set $CT='${$CT}', Total='$total' , lDate=Now() , lTool='$CT' where id='1'";
//echo "<br>".$query."<br>";
$result = mysqli_query($conn, $query);
 ////////////////////////////////////////////////////////////////////////////////////////ipcounter
 $queryIP="select * from ipcounter where ip='$myip'";	

 $resulIP =mysqli_query($conn, $queryIP);
 
 $numIP = mysqli_num_rows( $resulIP);

	if ( $numIP > 0)
	{
		$row = mysqli_fetch_object($resulIP);
		$count=($row->count)+1;
		$queryIPi = "update ipcounter set count='$count', area='$area', country='$country',sn='$sn', company='$company',   lTool='$CT' ,lDate=Now() where ip='$myip' " ;
$resultIPi =mysqli_query($conn, $queryIPi);
		}
	else {
		$queryIPi = "insert into ipcounter (ip,count,area, country,company,sn, lDate) values ('$myip', '1','$area','$country','$company','$sn', Now())";
		$resultIPi = mysqli_query($conn, $queryIPi);
	}
	/////////////////////////////////////////////////////////////////pbnTrack/////////////////////////////////////////

		
		//$queryT = "insert into pbnTrack (ip,count,area, company, lDate,lTool,CT1,CT9,CT12,CT23,CT21,CT84,Total) values ('$myip', '1','$area','$company', Now(), '$CT','$CT1','$CT9','$CT12','$CT23','$CT21','$CT84','$total')";
		
		$queryT = "insert into pbnTrack (ip,count,area, country, company,sn, lDate,lTool,$CT) values ('$myip', '1','$area','$country','$company','$sn', Now(), '$CT','1')";
		$resultT = mysqli_query($conn, $queryT);



	$queryTU="select * from pbnTrack where company='$company' order by id desc limit 1,1";		
	$resulTU = mysqli_query($conn, $queryTU);
	 $numTU = mysqli_num_rows( $resulTU);
	if ($numTU > 0)
	{
	$row = mysqli_fetch_object($resulTU);
	$CT1=($row->CT1);$CT9=($row->CT9);$CT12=($row->CT12);$CT23=($row->CT23);$CT21=($row->CT21);$CT60=($row->CT60);$CT125=($row->CT125);$CT84=($row->CT84);$SCCA=($row->SCCA);$DP=($row->DP6);$DP=($row->DP16);
	${$CT}=($row->$CT)+1;
	$total=($row->CT1)+($row->CT9)+($row->CT12)+($row->CT23)+($row->CT21)+($row->CT84)+($row->CT60)+($row->CT125)+($row->SCCA)+($row->DP)+($row->DP6)+($row->DP16)+1;

		$queryTU2="select * from pbnTrack where company='$company' order by id desc limit 1 ";		
		
		$resulTU2 =mysqli_query($conn, $queryTU2);
		 $numTU2 = mysqli_num_rows( $resulTU2);
			if ($numTU2 > 0)
			{
			$row2 =mysqli_fetch_object($resulTU2);
			$id=($row2->id);
			}
		$queryIPiU =  "update pbnTrack set CT1='$CT1',CT9='$CT9',CT12='$CT12',CT23='$CT23',CT21='$CT21',CT60='$CT60', CT125='$CT125',CT84='$CT84',SCCA='$SCCA',DP6='$DP6',DP16='$DP16',$CT='${$CT}',Total='$total'   where id='$id'";
		
		$resultIPiU = mysqli_query($conn, $queryIPiU);  
		//$resultIPiU = mysql_query($queryIPiU) or die ("Error in query: $queryIPiU. " . mysql_error());
	
	
	}
	else {

		$queryIPiU =  "update pbnTrack set CT1='0',CT9='0',CT12='0',CT23='0',CT21='0', CT84='0', CT60='0', CT125='0',$CT='1', SCCA='0',  DL='0', DP6='0',DP16='0',Total='1' where company='$company'";
		
		$resultIPiU = mysqli_query($conn, $queryIPiU);
		//$resultIPiU = mysql_query($queryIPiU) or die ("Error in query: $queryIPiU. " . mysql_error());
	}

		//}
	 
mysqli_close($conn);
}
?>