$query = mysqli_query($db, "SELECT COUNT(*) FROM news WHERE title='{$title}'");
$item = mysqli_fetch_row($query);
if ($item[0] == 0) {
mysqli_query($db, "INSERT INTO news (title, link, image, description, created_at) VALUES('{$title}', '{$link}', '{$image}', '{$description}', '{$date}')");
}
$query = mysqli_query($db, "SELECT COUNT(*) FROM news");
$item = mysqli_fetch_row($query);
if ($item[0] > 10) {
mysqli_query($db, "DELETE FROM news ORDER BY `id` ASC LIMIT ".($item[0] - 10));
}
if ((new Monitoring())->ping($phone_ip)) {
echo 1; // в сети
if (mysqli_fetch_assoc(mysqli_query($link, "SELECT `ip` FROM `Computer_Check` WHERE `ip`='".mysqli_real_escape_string($link, $phone_ip)."'")) === NULL) {
mysqli_query($link, "INSERT INTO `First_Computer` (`decor`) VALUES ('1')") or die(mysqli_error($link));
mysqli_query($link, "REPLACE INTO `Computer_Check` (`ip`) VALUES ('".mysqli_real_escape_string($link, $phone_ip)."')") or die(mysqli_error($link));
}
} else {
echo 0; // не в сети
if (mysqli_fetch_assoc(mysqli_query($link, "SELECT `ip` FROM `Computer_Check` WHERE `ip`='".mysqli_real_escape_string($link, $phone_ip)."'")) !== NULL) {
mysqli_query($link, "INSERT INTO `First_Computer` (`decor`) VALUES('0')") or die(mysqli_error($link));
mysqli_query($link, "DELETE FROM `Computer_Check` WHERE `ip`='".mysqli_real_escape_string($link, $phone_ip)."'") or die(mysqli_error($link));
}
}
mysqli_close($link);
И куки таки использовать.
Плааа-а-авали, зааа-а-а-аем... (с) мультфильм.