Flyff Privat Server Homepage (Ranking) ?

Sanjez · 06/16/2011, 14:20

Wenn ich auf meiner Homepage auf Ranking klicke kommt dies :

Quote:

Warning: mysql_connect() [function.mysql-connect]: Host 'Josh-PC' is not allowed to connect to this MySQL server in C:\xampp\htdocs\inc\config.inc.php on line 19

Notice: Undefined variable: Database in C:\xampp\htdocs\inc\config.inc.php on line 20

Warning: mysql_select_db() expects parameter 2 to be resource, boolean given in C:\xampp\htdocs\inc\config.inc.php on line 20

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\ranking.php on line 146

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\ranking.php on line 150

Und unten darutner mein Ranking ohne Spieler ..

No

Level

Name

Classe

Status

ZenZen.Kwaii · 06/16/2011, 14:22

Quote:

Notice: Undefined variable: Database in C:\xampp\htdocs\inc\config.inc.php on line 20

Dann sieh nach was in line 20 steht bzw. was davor steht.

マリブ · 06/16/2011, 14:22

Du hast kein MySQL connection, welche Homepage wilsst du denn usen ?
Eigene oder eine Releaste ?
Oder ist das nur ein Script Oo

ZenZen.Kwaii · 06/16/2011, 14:23

~lol wurde 2 mal gepostet <.<~

Sanjez · 06/16/2011, 14:31

Das ist Zeile 19&20:

Quote:

$myConnect = mysql_connect( $sHost, $sLogin, $sPass );
$myDatabase = mysql_select_db( $Database , $myConnect );

Was da umstellen ?

マリブ · 06/16/2011, 14:39

Er versucht zu MySQL zu Connecten, hast du MySQL aufm Root oder PC Installiert ?

Sanjez · 06/16/2011, 14:44

Auf dem PC von mir.

マリブ · 06/16/2011, 14:49

Dann Installier mal MySQL, oder versuch eine andere Homepage.

Sanjez · 06/16/2011, 14:51

Hab ich schon, ranking ist ja sogar da nur unten, aber wie mache ich diese fehlermeldung weg ?

マリブ · 06/16/2011, 14:54

MySQL Daten richtig angegeben ?

Sanjez · 06/16/2011, 16:47

config.inc

Quote:

<?php
/**
* @desc Config include.
*
* @company Web-Développez
* @Property public
* @author plop
* @contact
* @version 1.0.0
* @date 16/09/2008
* @access public
**/

$sHost = '5.181.250.70'; // Default: 127.0.0.1 EN:Host/IP FR:HOST/IP
$sLogin = 'JOSH-PC\SQLEXPRESS'; // Default: root EN:Login FR: Identifiant
$sPass = ''; // Default: EN:Password FR: Mot de passe
$sDatabase = 'flyff'; // Default: flyff ENatabase Name FR: Nom de la base de donnée

$myConnect = mysql_connect( $sHost, $sLogin, $sPass );
$myDatabase = mysql_select_db( $Database , $myConnect );
?>

ranking.inc

Quote:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>United Flyff</title>
<meta name="keywords" content="" />
<meta name="Gestured" content="" />
<link href="default.css" rel="stylesheet" type="text/css" media="screen" />
</head>
<body>
<div id="wrapper">

<div id="header">
<div id="menu">
<ul id="main">
<li class="current_page_item"><a href="index.php">Startseite</a></li>
<li><a href="http://impulzefly.im.funpic.de/Forum">Forum</a></li>
<li><a href="Register.php">Registrieren</a></li>
<li><a href="Ranking.php">Ranking</a></li>
<li><a href="team.php">Team</a></li>
<li><a href="eventsys.php">EventSystem</a></li>
<li><a href="regeln.php">Regeln</a></li>
<li><a href="Downloads.php">Downloads</a></li>
</ul>
</div>
<div id="logo">
<img src="images/header.png">
</div>
</div>


<div id="page">
<div id="sidebar1" class="sidebar">
<ul>
<li>
<h2>Server Stats</h2>
<ul>
<li>Exp: 200</li>
<li>Drop: 200</li>
<li>Penya: 250</li>
<li>Raining Event: X2 exp</li>

<h2>Vote</h2>

<li><br>
<a href="http://topofgames.com/index.php?do=votes&id=14535"><img border="0" src="http://pics.livejournal.com/samaritanyn/pic/0006xbhs.gif" alt="topofgames.com" /></a>
 </ul>
</li>
<li>
<h2>Status</h2>
<ul>

<br><li>Login Server:
<?php
$online = @fsockopen("127.0.0.1", 23000, $errno, $errstr, 1);
if($online >= 1) {
echo'<b> <font color=#00FF00>Online</font></b>';
}
else {
echo '<b><font color=#FF0000>Offline</font></b>';
}
?></li>

<br><li>Char Server:
<?php
$online = @fsockopen("127.0.0.1", 28000, $errno, $errstr, 1);
if($online >= 1) {
echo '<b><font color=#00FF00>Online</font></b>';
}
else {
echo '<b><font color=#FF0000>Offline</font></b>';
}
?></li>

<br><li>World Server:
<?php
$online = @fsockopen("127.0.0.1", 15400, $errno, $errstr, 1);
if($online >= 1) {
echo '<b><font color=#00FF00>Online</font></b>';
}
else {
echo '<b><font color=#FF0000>Offline</font></b>';
}
?></li>

<br><li>Datenbank Server:
<?php
$online = @fsockopen("127.0.0.1", 3306, $errno, $errstr, 1);
if($online >= 1) {
echo '<b><font color=#00FF00>Online</font></b>';
}
else {
echo '<b><font color=#FF0000>Offline</font></b>';
}
?></li>
</ul>

</ul>
</div>

<div id="content">
<div class="post">

<div class="entry">
<p <?php
/**
* @desc Ranking module.
*
* @company Web-Développez
* @Property public
* @author plop
* @contact
* @version 1.0.0
* @date 16/09/2008
* @access public
**/

/* Include configurations files */
require_once('inc/config.inc.php');
require_once('inc/functions.inc.php');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>Ranking</title>
<link href="style.css" rel="stylesheet" type="text/css"/>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
</head>
<body>
<?php
$sQuery = "SELECT t2.channelnum, t2.charname, t2.level, t2.class FROM accounts AS t1 INNER JOIN characters AS t2 ON t1.username = t2.accountname WHERE t1.accesslevel = 100";
$rExecute = mysql_query( $sQuery );
$iNbOfResult = mysql_num_rows( $rExecute );

$ctr = 0;

while( $aRowData = mysql_fetch_assoc( $rExecute ) )
{
$aData['channelnum'][$ctr] = $aRowData['channelnum'];
$aData['charname'][$ctr] = $aRowData['charname'];
$aData['level'][$ctr] = $aRowData['level'];
$aData['level2'][$ctr] = RealLevel( $aRowData['level'], $aRowData['class'] );
$aData['class'][$ctr] = $aRowData['class'];
$ctr++;
}

if( 1 < $iNbOfResult )
{
array_multisort( $aData['level2'], SORT_NUMERIC, SORT_DESC, $aData['channelnum'], $aData['charname'], $aData['level'], $aData['class']);
}

echo'
<table style="border: 0px solid blue; font-size: 12px;" cellpadding="0" cellspacing="0">
<tr>
<td style="width: 20px;"></td>
<td style="background-color: #4074bf; width: 450px; height: 5px;" colspan="5"></td>
<td style="width: 20px;"></td>
</tr>
<tr style="color: #062a5e;">
<td style="width: 20px;"></td>
<td style="border-right: 1px solid #2a5eaa; background-color: #4074bf; width: 50px; height: 30px;" align="center">No</td>
<td style="border-right: 1px solid #2a5eaa; background-color: #4074bf; width: 100px; height: 30px;" align="center">Level</td>
<td style="border-right: 1px solid #2a5eaa; background-color: #4074bf; width: 100px; height: 30px;" align="center">Name</td>
<td style="border-right: 1px solid #2a5eaa; background-color: #4074bf; width: 100px; height: 30px;" align="center">Classe</td>
<td style="background-color: #4074bf; width: 100px; height: 30px;" align="center">Status</td>
<td style="width: 20px;"></td>
</tr>
<tr>
<td style="width: 20px;"></td>
<td style="background-color: #4074bf; width: 450px; height: 5px;" colspan="5"></td>
<td style="width: 20px;"></td>
</tr>
';

$iNo = 1;

while( $iNo <= $iNbOfResult )
{
echo '
<tr>
<td style="width: 20px;"></td>
<td style="width: 450px; height: 5px;" colspan="5"></td>
<td style="width: 20px;"></td>
</tr>
<tr>
<td style="width: 20px;"></td>
<td style="border-right: 1px solid #4074bf; width: 50px; height: 30px;" align="center">'.$iNo.'</td>
<td style="border-right: 1px solid #4074bf; width: 100px; height: 30px;" align="center">'.RealLevel2( $aData['level'][$iNo-1], $aData['class'][$iNo-1] ).'</td>
<td style="border-right: 1px solid #4074bf; width: 100px; height: 30px;" align="center">'.$aData['charname'][$iNo-1].'</td>
<td style="border-right: 1px solid #4074bf; width: 100px; height: 30px;" align="center">'.Job($aData['class'][$iNo-1]).'</td>
<td style="width: 100px; height: 30px;" align="center">'.Statu($aData['channelnum'][$iNo-1]).'</td>
<td style="width: 20px;"></td>
</tr>
<tr>
<td style="width: 20px;"></td>
<td style="border-bottom: 1px solid #4074bf; width: 450px; height: 5px;" colspan="5"></td>
<td style="width: 20px;"></td>
</tr>
';
$iNo++;
}

echo'
</table>
';
?>
</body>
</html>

Was ist falsch eingestellt ?