' . $_SERVER['REMOTE_HOST'] . ' | ' ;
$HOST = $_SERVER['REMOTE_HOST'];
}
else
{
$HOST = 'UNKNOWN';
}
$sql = "CREATE TABLE hp_log (
logins int(6),
last_update timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (last_update)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci";
if ($conn->query($sql) === TRUE)
{
echo "Table hp_log created successfully" . "
";
$logins = 2840;
$sql ="INSERT INTO hp_log (logins) VALUES ('$logins')";
// $conn->query($sql);
if (mysqli_query($conn, $sql))
{
echo "New custlog record created successfully.......................";
}
}
$query = "SELECT * FROM hp_log";
if (mysqli_query($conn, $query))
{
$result = $conn->query($query);
$row_cnt = $result->num_rows;
if ($result->num_rows > 0)
while($row = $result->fetch_assoc())
{
$xlogins = $row['logins'];
$xlogins ++;
$query = "UPDATE hp_log SET logins = '$xlogins'";
if (mysqli_query($conn, $query))
{
}
}
}
$now = new DateTime();
$now = $now->format('Y-m-d H:i:s');
$_SESSION["now"] = $now;
$sql = "CREATE TABLE IF NOT EXISTS hp_all_log (
rem_addr char(20) NOT NULL,
rem_host char(20),
logins int(6),
last_update timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (rem_addr)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci";
if ($conn->query($sql) === TRUE)
{
$logins = 1;
}
$sql = "SELECT * FROM hp_all_log WHERE rem_addr = '$ADDR'";
mysqli_query($conn, $sql);
$result = $conn->query($sql);
$row_cnt = $result->num_rows;
if ($result->num_rows > 0)
{
$row = $result->fetch_assoc();
$ylogins = $row['logins'];
$ylogins ++;
$sql = "UPDATE hp_all_log SET " .
"last_update = '$now', logins = '$ylogins' " .
"WHERE rem_addr = " . "'$ADDR'";
mysqli_query($conn, $sql);
}
else
{
$sql = "INSERT INTO hp_all_log " .
"(rem_addr, rem_host, logins, last_update) " .
"VALUES ('$ADDR', '$HOST', 1, '$now')";
mysqli_query($conn, $sql);
}
/*
$sql = "INSERT INTO hp_all_log " .
"(rem_addr, rem_host, logins, last_update) " .
"VALUES (visitlog.rem_addr, visitlog.rem_host, visitlog.logins, visitlog.last_update) " .
"ON DUPLICATE KEY UPDATE logins = logins + 1";
*/
/*
$sql = "INSERT INTO hp_all_log " .
"(rem_addr, rem_host, logins, last_update) " .
"SELECT visitlog.rem_addr, visitlog.rem_host, visitlog.logins, visitlog.last_update " .
"FROM visitlog";
// "ON DUPLICATE KEY UPDATE logins = logins + 1";
mysqli_query($conn, $sql);
$result = $conn->query($sql);
$row_cnt = $result->num_rows;
// if ($result->num_rows > 0)
if ($row_cnt > 0)
{
ECHO 'GICK BRA';
}
else
{
ECHO 'GICK INTEEEEE BRA';
}
// exit;
// INSERT INTO table (id, name, age) VALUES (1, 'A', 19) ON DUPLICATE KEY UPDATE id = id + 1;
*/
$conn->close();
$conn = null;
// exit;
?>
MicroShip AB