Forum Moderators: coopster
<?php
/*
CREATE TABLE `servers` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`sname` VARCHAR(30) NOT NULL,
`sip` VARCHAR(16) NOT NULL,
`website` VARCHAR(50),
`lport` INT(5) NOT NULL,
`sport` INT(5) NOT NULL,
`comment` TEXT NOT NULL,
PRIMARY KEY(`id`)
);
*/if(isset($_POST['addServer'])) {
$sql = "INSERT INTO `servers` ( `sname` , `sip` , `website` , `lport` , `sport` , `comment` ) VALUES ('".$_POST['sName']."', '".$_POST['sIP']."', '".$_POST['website']."', '".$_POST['lPort']."', '".$_POST['sPort']."', '".$_POST['comment']."')";
if(!mysql_query($sql)) {
echo "ERROR! Server not added.<br>".mysql_error();
} else {
echo "Server added successfully.";
}
}
echo "<form method=\"post\" action=\""$_SERVER['PHP_SELF']"\">
<strong>Add a Server</strong><br>
Server Name: <input type=\"text\" name=\"sName\"><br>
Server IP: <input type=\"text\" name=\"sIP\"><br>
Server Port: <input type=\"text\" name=\"sPort\" value=\"7002\"><br>
Login Port: <input type=\"text\" name=\"lPort\" value=\"7002\"><br>
Website: <input type=\"text\" name=\"website\"><br>
Comment:
<textarea name=\"comment\" cols=\"50\" rows=\"10\"></textarea><br>
<input type=\"submit\" name=\"addServer\" value=\"Add Server\">
</form>";
echo "<strong>Current Servers:</strong><br>";
$sql = "SELECT * FROM `servers`";
if(!($getServers = mysql_query($sql))) {
echo "ERROR! Cannot retrieve servers.<br>".mysql_error();
} else {
while($s = mysql_fetch_object($getServers)) {
$checkLogin = @fsockopen($s->sip, $s->lport, $errno, $errstr, 3);
if(!$checkLogin) {
echo "Login: <img src=\"/images/offline.gif\"><br>";
} else {
echo "Login: <img src=\"/images/online.gif\"><br>";
}
$checkServer = @fsockopen($s->sip, $s->sport, $errno, $errstr, 3);
if(!$checkServer) {
echo "Server: <img src=\"/images/offline.gif\"><br>";
} else {
echo "Server: <img src=\"/images/online.gif\"><br>";
}
}
}
?>
here is the error:
Parse error: parse error, unexpected T_VARIABLE, expecting ',' or ';' in /home/yukisho/public_html/status/test2.php on line 23 Whats wrong? Also, it was a script a friend made and i cant get a hold of him, if someone could help me and tell how what code to put in to select the database the table is in.
Warning: mysql_query(): Access denied for user: 'yukisho@localhost' (Using password: NO) in /home/yukisho/public_html/status/test2.php on line 17Warning: mysql_query(): A link to the server could not be established in /home/yukisho/public_html/status/test2.php on line 17
ERROR! Cannot retrieve servers.
Access denied for user: 'yukisho@localhost' (Using password: NO)