\n"; } require_once($_SERVER["DOCUMENT_ROOT"] . '/include/commontvn.php'); require_once($_SERVER["DOCUMENT_ROOT"] . "/include/initialize.php"); $id = isset($_GET['id']) ? $_GET['id'] : ''; $tagid = isset($_GET['tag']) ? $_GET['tag'] : ''; if (!empty($id)) { $nowymd = date("Ymd"); $nowtime = date("His"); $cntDB = conDB(); if ($cntDB === false) { error_log("DB connection failed in indexlog.html"); } else { $sql_select = "SELECT MIN(dtb04_seq + 1) AS dtb04_seq FROM dtb_04aclog WHERE (dtb04_seq + 1) NOT IN (SELECT dtb04_seq FROM dtb_04aclog)"; $result = $cntDB->query($sql_select); if ($result) { $maxseq = 1; if ($row = $result->fetch_assoc()) { $maxseq = $row["dtb04_seq"] != "" ? $row["dtb04_seq"] : 1; } $sql_insert = "INSERT INTO dtb_04aclog VALUES ("; $sql_insert .= (int)$maxseq . ","; $sql_insert .= "'" . $nowymd . "',"; $sql_insert .= "'" . $nowtime . "',"; $sql_insert .= "'" . $id . "',"; $sql_insert .= "'" . $tagid . "'"; $sql_insert .= ")"; if ($cntDB->query($sql_insert) === false) { error_log("DB INSERT failed in indexlog.html: " . $cntDB->error); } } else { error_log("DB SELECT failed in indexlog.html: " . $cntDB->error); } $cntDB->close(); } if ($tagid == "") { $url = 'https://nordot.app/' . $id; } else { $url = 'https://nordot.app/' . $id . "?c=476913576246887521"; } header('Location: ' . $url); exit; } else { $url = 'https://naratowa.jp/'; exit; } ?>