<?php

/* ตัวแปรที่ใช้ในการคอนฟิกค่าต่างๆของเว็บ */
$GLOBALS["host"] ="localhost";  // ip เครื่อง Server ไม่ต้องเปลี่ยนถ้าใช้ mysql เครื่องเดียวกัน
$GLOBALS["Uname"] = "root";  // username เข้า mysql
$GLOBALS["Pword"] = "$0mT0yK@";  // password เข้า mysql 
$GLOBALS["DBName"] = "lpg1_web2021";  // ชื่อฐานข้อมูล ถ้าจะให้ดีก็สร้างเหมือนกันนี้เลย


function connect_db(){
    $link = mysqli_connect($GLOBALS["host"],$GLOBALS["Uname"],$GLOBALS["Pword"],$GLOBALS["DBName"]) or die(mysql_error());
    mysqli_query($link, 'SET NAMES UTF8');
    return $link;
}
$link = connect_db();


/*
//เชื่อมต่อฐานข้อมูล MySQL
$con = mysql_connect($GLOBALS[host], $GLOBALS["Uname"], $GLOBALS["Pword"], $GLOBALS["DBName"]) or die('ติดต่อไม่ได้');
//mysql_select_db($db_database)
mysql_select_db(db_database,$con);  
if (!$con){
  echo('can not connect Database: ' . mysql_error());
}
		mysql_query("SET NAMES utf8",$con); 
		mysql_query("SET character_set_results=utf8",$con); 
//สิ้นสุดเชื่อมต่อฐานข้อมูล MySQL
*/


//connect Calendar ****************
try
{
	$bdd = new PDO("mysql:host=$GLOBALS[host];dbname=$GLOBALS[DBName]", $GLOBALS["Uname"] , $GLOBALS["Pword"] );
}
catch(Exception $e)
{
        die('Error : '.$e->getMessage());
}

//connect Calendar *****************


//*************** Useronlie

// Update Stay online
$intUserID = 0;
$strSessionID = session_id();
if(isset($_SESSION['mem_id']))
{
	$intUserID = $_SESSION["mem_id"];
}
$sql = "INSERT INTO online (SID,UserID,OnlineLastTime) VALUES ('$strSessionID','$intUserID',NOW()) ON DUPLICATE KEY UPDATE UserID = '$intUserID',OnlineLastTime = NOW()";
$query = mysqli_query($link,$sql);

//*** Reject user not online
$intRejectTime = 15; // Minute
$sql = "UPDATE tbl_member SET LoginStatus = '0', LastUpdate = '0000-00-00 00:00:00'  WHERE 1 AND DATE_ADD(LastUpdate, INTERVAL $intRejectTime MINUTE) <= NOW() ";
$query = mysqli_query($link,$sql);

$sql = "DELETE FROM online WHERE DATE_ADD(OnlineLastTime, INTERVAL $intRejectTime MINUTE) <= NOW() ";
$query = mysqli_query($link,$sql);

//*** Count Guest Online
$intGuestOnline = 0;
$sql = "SELECT COUNT(SID) AS GuestOnline FROM online WHERE UserID = '0' ";
$query = mysqli_query($link,$sql);
if($query)
{
	$objResult = mysqli_fetch_array($query,MYSQLI_ASSOC);
	$intGuestOnline = $objResult["GuestOnline"];
}

//*** Count Member Online
$intMemberOnline = 0;
$sql = "SELECT COUNT(SID) AS MemberOnline FROM online WHERE UserID != '0' ";
$query = mysqli_query($link,$sql);
if($query)
{
	$objResult = mysqli_fetch_array($query,MYSQLI_ASSOC);
	$intMemberOnline = $objResult["MemberOnline"];
}

//*** Count Member All
$intMemberAll = 0;
$sql = "SELECT COUNT(mem_id) AS MemberAll FROM tbl_member WHERE mem_level = '2' AND mem_status='1' ";
$query = mysqli_query($link,$sql);
//$intMemberAll = mysql_num_rows($sql); //นับจำนวน
if($query)
{
	$objResult = mysqli_fetch_array($query,MYSQLI_ASSOC);
	$intMemberAll = $objResult["MemberAll"];
}

//*** Suspended Member All
$intMemberSuspended = 0;
$sql = "SELECT COUNT(mem_id) AS MemberSuspended FROM tbl_member WHERE mem_status<>'1' ";
$query = mysqli_query($link,$sql);
if($query)
{
	$objResult = mysqli_fetch_array($query,MYSQLI_ASSOC);
	$intMemberSuspended = $objResult["MemberSuspended"];
}

//*** Latest สมาชิกล่าสุด
//$intMemberLatest = 0;
$sql = "SELECT mem_id,mem_user FROM tbl_member WHERE mem_level = '2' AND mem_status='1' ORDER BY mem_id DESC";
$query = mysqli_query($link,$sql);
if($query)
{
	$objResult = mysqli_fetch_array($query,MYSQLI_ASSOC);
	$intMemberLatest = $objResult["mem_user"];
}

//*************** /Useronlie


?>