1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39

<?php 
header('Access-Control-Allow-Origin:*');
include_once("./_common2.php"); 
?>
<?php
include("../../manage/category/common.php");


@extract($_POST);

$mode_ok = "Y";

if($mode_ok == "Y") {

    $page_kr = iconv("utf-8","euckr",$page_kr);

    // 몇명이 이 페이지에 들어왔는지 카운팅
    $today = date("Y-m-d"); // 오늘날짜
    $time = date("H");
    $sql = "SELECT * FROM mBoard_page_count WHERE inflow_date = '{$today}' AND page = '{$page}' AND page_kr = '{$page_kr}' ORDER BY inflow_time DESC";
    $res = mysql_query($sql);
    $row = mysql_fetch_array($res);

    if(!$row || $row['inflow_time'] != $time){ // 데이터가 없을 때
        $insertsql = "INSERT INTO mBoard_page_count(inflow_date, inflow_time, count, page, page_kr) VALUES ('{$today}', '{$time}', 1, '{$page}', '{$page_kr}')";
        mysql_query($insertsql);
    } else { // 데이터가 있을 때
        $updatesql = "UPDATE mBoard_page_count SET count = count+1 WHERE inflow_date = '{$today}' AND inflow_time = '{$time}' AND page = '{$page}'";
        mysql_query($updatesql);
    }
}


echo "<?php xml version='1.0' encoding='utf-8'?><output>";
echo "<mode>".$mode."</mode>";
echo "<mode_ok>".$mode_ok."</mode_ok>";
echo "<msg>".$msg."</msg>";
echo "</output>";
?>