Kanibal 
Master
Posts: 257
Likes Given: 6
Likes Received: 30 in 28 posts
Joined: Jun 2012
Reputation: 0
![]()
|
RE: [TUTORIAL] Sphere web status
Create somewhere (not in www directory) php script, and launch it every N hours/minutes/seconds from command line
Code:
<?php
$link = mysqli_connect("127.0.0.1", "user", "password", "db_name");
if (!$link) {
echo "Error: Unable to connect to MySQL." . PHP_EOL;
echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL;
echo "Debugging error: " . mysqli_connect_error() . PHP_EOL;
exit;
}
$fp = @fsockopen("127.0.0.1", 2593, $errno, $errstr, 10);
if (!$fp) {
$result = mysqli_query($link, "UPDATE `server_status` SET online='Offline'");
}else{
$result = mysqli_query($link, "UPDATE `server_status` SET online='Online'");
fclose($fp);
}
mysqli_close($link);
?>
P.S. You can use crontab (see attachment) or use .bat file
Code:
start "C:\PHP\php.exe" -f C:\scripts\sphere_status_update.php
P.P.S. I cant add attachment something is wrong with forum? 
Grandmaster Localhost Admin
(This post was last modified: 12-27-2016 11:57 PM by Kanibal.)
|
|
| 12-27-2016 11:04 PM |
|
![[+]](images/collapse_collapsed.gif)
|
Home
Forum
Downloads
GitHub
SphereWiki
Search
Discord Channel
Facebook
Twitter
