Hello i try to connect my web page to my DB but i have problem
I have already top pvp script like this :
I have already config my script
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title></title>
</head>
<body>
<?php
//---------CONFIGS---------//
$title="Top PvP"; // Page Title Here
$type="1"; //Type 1
$server="already"; // MySQL IP
$user="Already"; //MySQL Username
$password="already"; //MySQL Password
$database="already; //MySQL Database
$top="100";
//-----END OF CONFIGS-----//
if ($title) {
print("<head><title>$title</title></head>");
}
else {
print("<head><title>No Page Title</title></head>");
}
mysql_connect("$server", "$user", "$password") or die(mysql_error());
mysql_select_db("$database") or die(mysql_error());
if($type == '1'){
$result = mysql_query("SELECT char_name,pvpkills FROM characters where pvpkills>0 and accesslevel=0 order by pvpkills desc")
or die(mysql_error());
echo "<center><h3>Top $top PvP Players</h3></center><table border=10 align=center><tr> <th>Character</th> <th>Top Kills</th> </tr>";
$sum1=0;
while($row = mysql_fetch_array( $result )) {
$name = $row['char_name'];
$pvpkills = $row['pvpkills'];
if ($sum1<$top) {
echo "<tr><td align=center>$name</td><td align=center>$pvpkills</td></tr>";
$sum1++;
}
}
}
else {
echo "<center>Please config the variable $type. Make it <b>1</b> for Top Status</center>";
}
?>
</body>
</html>
but when i open this page i got error:
PHP Error Message
Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 in /home/a2349266/public_html/top.php on line 27
Free Web Hosting
Lost connection to MySQL server at 'reading initial communication packet', system error: 111
when i open my phpmyadmin i see...
localhost
* Server version: 5.0.51a-24+lenny3
* Protocol version:
* Server: Localhost via UNIX socket
* User: *****@localhost
* MySQL charset: UTF-8 Unicode (utf8)
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Im trying to find tools for Prelude of War. Im in big need for tools to help me change Interface.u and Interface.xdat. But i need tools for Prelude of War in general. I cant find any.
Question
Bobi
Hello i try to connect my web page to my DB but i have problem
I have already top pvp script like this :
I have already config my script
but when i open this page i got error:
when i open my phpmyadmin i see...
so how to make my top pvp script work ?
Link to comment
Share on other sites
5 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.