Register for your free account! | Forgot your password?

You last visited: Today at 08:35

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



Hey liebe Com,

Discussion on Hey liebe Com, within the Metin2 Private Server forum part of the Metin2 category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: May 2012
Posts: 18
Received Thanks: 0
Red face Hey liebe Com,

Brauch mal eure hilfe,
Ich code schon metin2 board über 1 Jahr.
Homepage hab ich nicht so oft gegemacht.Ich arbeite grade dran mit leuten ein server aufzumachen hab daher webspace bestellt und die sachen hochgeladen so das Problem ist nur das diese Fehlermeldungen kommen.Bitte helft mir
Skype: DJFreak1996

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in
__________________________________________________ _______________
/var/customers/webs/ni250435_1/php/status.php on line 5 Notice: Trying to get property of non-object in /var/customers/webs/ni250435_1/php/status.php on line 5 Es sind 1 Spieler Online
__________________________________________________ ______________
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /var/customers/webs/ni250435_1/php/top10.php on line 59 Notice: Trying to get property of non-object in /var/customers/webs/ni250435_1/php/top10.php on line 60 Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /var/customers/webs/ni250435_1/php/top10.php on line 97 .

Das sind diese fehlermeldungen
MusKos991 is offline  
Old 09/14/2013, 13:31   #2
 
elite*gold: 200
Join Date: Apr 2012
Posts: 577
Received Thanks: 290
Quote:
Ich code schon metin2 board über 1 Jahr.
Dann müsstest du wissen, was da falsch ist....

Bitte poste doch die status.php und die top10.php hier rein, sonst kann dir keiner helfen.
MartPwnS is offline  
Old 09/14/2013, 13:37   #3
 
elite*gold: 0
Join Date: May 2012
Posts: 18
Received Thanks: 0
Wie postet man deas ?
epvp hab ich auch keine ahnung

PHP Code:
<div style="float:left; margin-left:20px;">
<?PHP
mysql_select_db
("player");
$output mysql_query("SELECT COUNT(*) as count FROM player WHERE DATE_SUB(NOW(), INTERVAL 5 MINUTE) < last_play;");
$online_count mysql_fetch_object($output)->count+1;
echo 
"<font style=font-size:12px;>Es sind</font> <font style=font-size:20px; color=yellow>$online_count</font> <font style=font-size:12px;>Spieler Online</font>"
?>
</div>
<div style="font-size:12px; text-transform:uppercase; ">
<?php
        $serverip 
"localhost";
        
$ip gethostbyname($serverip);
        
$portlist=array(1100213000130033306);
        
$status=array("login: ""world: ""char:""mysql:");
        
$i=0;

    foreach  (
$portlist as $port){
        
$online = @fsockopen($ip$port$errno$errstr1);
    if (!
$online)
    {
        echo 
"".$status[$i]." <font color=red>Offline&nbsp;&nbsp;&nbsp;</font>"

    }
    else
    {
        echo 
"".$status[$i]." <font color=#669e33>Online&nbsp;&nbsp;&nbsp;</font>"
    }
        @
fclose($online);
        
$i++;
    }  
    
?>
    <input style="margin-top:5px;" type="submit" onclick="reloadstatus()" class="btn" value="Neuladen" href="#" name="submit">
</div>
__________________________________________________ ___________
PHP Code:
<?PHP
  $CPSeite 
50;
  
$markierteZeile=0;
  if(isset(
$_GET['p'])) {
    if(!
checkInt($_GET['p']) || !($_GET['p']>0)) $aSeite 1;
    else 
$aSeite $_GET['p'];
  }
  else { 
$aSeite 1; }
  
  if(isset(
$_POST['suche']) && $_POST['suche']=='suchen') {
    if(!empty(
$_POST['charakter'])) {
      
$sqlCmd="SELECT id, name, level, exp, empire, guild_name, rang
      FROM (
      
        SELECT id, name, level, exp, empire, guild_name, @num := @num +1 AS rang
        FROM (
        
          SELECT player.id, player.name, player.level, player.exp, player_index.empire, guild.name AS guild_name, @num :=0
          FROM player.player
          LEFT JOIN player.player_index ON player_index.id = player.account_id
          LEFT JOIN player.guild_member ON guild_member.pid = player.id
          LEFT JOIN player.guild ON guild.id = guild_member.guild_id
          INNER JOIN account.account ON account.id=player.account_id
          WHERE player.name NOT LIKE '[%]%' AND account.status!='BLOCK'
          ORDER BY player.level DESC , player.exp DESC
          
        ) AS t1
        
      ) AS t2
      
      WHERE name LIKE '"
.mysql_real_escape_string($_POST['charakter'])."' LIMIT 1";
      
$sqlQry=mysql_query($sqlCmd,$sqlServ);
      if(
mysql_num_rows($sqlQry)>0) {
      
        
$getRang mysql_fetch_object($sqlQry);
        
$aSeite ceil($getRang->rang/$CPSeite);
        
$markierteZeile $getRang->rang;
      }
      
    }
    
  }
  
  
$sqlCmd "SELECT COUNT(*) as summeChars  
  FROM player.player 
  LEFT JOIN player.player_index 
  ON player_index.id=player.account_id 
  LEFT JOIN player.guild_member 
  ON guild_member.pid=player.id 
  LEFT JOIN player.guild 
  ON guild.id=guild_member.guild_id
  INNER JOIN account.account 
  ON account.id=player.account_id
  WHERE player.name NOT LIKE '[%]%' AND account.status!='BLOCK'
  ORDER BY player.level DESC, player.exp DESC"
;
  
  
$sqlQry mysql_query($sqlCmd,$sqlServ);
  
  
$getSum mysql_fetch_object($sqlQry);
  
$cSeite calcPages($getSum->summeChars,$aSeite,$CPSeite);
  
?>
<?PHP
  $maxRange 
10;
  
$maxStep 15;
  if((
$aSeite-$maxRange)>0$sStart $aSeite-$maxRange;
  else 
$sStart 1;
  if((
$aSeite+$maxRange)<=$cSeite[0]) $sEnde $aSeite+$maxRange;
  else 
$sEnde $cSeite[0];
  
?>
<table style="width:180px; font-size:12px;">
<tr>
  <th width=75 align=center>Platz</th>
  <th width=75 align=center>Name</th>
  <th width=75 align=center>Level</th>
</tr>

<?PHP
  $sqlCmd 
"SELECT player.id,player.name,player.level,player.exp,player_index.empire,guild.name AS guild_name 
  FROM player.player 
  LEFT JOIN player.player_index 
  ON player_index.id=player.account_id 
  LEFT JOIN player.guild_member 
  ON guild_member.pid=player.id 
  LEFT JOIN player.guild 
  ON guild.id=guild_member.guild_id
  INNER JOIN account.account 
  ON account.id=player.account_id
  WHERE player.name NOT LIKE '[%]%' AND account.status!='BLOCK'
  ORDER BY player.level DESC, player.exp DESC 
  LIMIT "
.$cSeite[1].",".$CPSeite;
  
  
//echo $sqlCmd;
  
$sqlQry mysql_query($sqlCmd,$sqlServ);
  
$x=$cSeite[1]+1;
  while(
$getPlayers mysql_fetch_object($sqlQry)) {

if(
$x == "1")
{
    echo 
"<tr>";
    echo 
'<td width=75 align=center><img src="./bilder/'.$x.'_platz.png" title="Gold" alt="Gold"/></td>';
    echo 
"<td width=75 align=center><a style='color:#d5aa00' href=\"index.php?s=view_char&id=".$getPlayers->id."\">".$getPlayers->name."</a></td>";    
    echo 
"<td width=75 align=center><a style='color:#d5aa00'>".$getPlayers->level."</a></td>";    
}
elseif(
$x == "2")
{
    echo 
"<tr>";
    echo 
'<td width=75 align=center><img src="./bilder/'.$x.'_platz.png" title="Silber" alt="Silber"/></td>';
    echo 
"<td width=75 align=center><a style='color:#999999' href=\"index.php?s=view_char&id=".$getPlayers->id."\">".$getPlayers->name."</a></td>";    
    echo 
"<td width=75 align=center><a style='color:#999999'>".$getPlayers->level."</a></td>";    
}
elseif(
$x == "3")
{
    echo 
"<tr>";
    echo 
'<td width=75 align=center><img src="./bilder/'.$x.'_platz.png" title="Bronze" alt="Bronze"/></td>';
    echo 
"<td width=75 align=center><a style='color:#663300' href=\"index.php?s=view_char&id=".$getPlayers->id."\">".$getPlayers->name."</a></td>";    
    echo 
"<td width=75 align=center><a style='color:#663300'>".$getPlayers->level."</a></td>";    
}
elseif(
$x == "4")
{
    echo 
"<tr>";
    echo 
"<td width=75 align=center>".$x."</td>";
    echo 
"<td width=75 align=center><a href=\"index.php?s=view_char&id=".$getPlayers->id."\">".$getPlayers->name."</a></td>";    
    echo 
"<td width=75 align=center>".$getPlayers->level."</td>";    
}    
elseif(
$x == "5")
{
    echo 
"<tr>";
    echo 
"<td width=75 align=center>".$x."</td>";
    echo 
"<td width=75 align=center><a href=\"index.php?s=view_char&id=".$getPlayers->id."\">".$getPlayers->name."</a></td>";    
    echo 
"<td width=75 align=center>".$getPlayers->level."</td>";    
}
elseif(
$x == "6")
{
    echo 
"<tr>";
    echo 
"<td width=75 align=center>".$x."</td>";
    echo 
"<td width=75 align=center><a href=\"index.php?s=view_char&id=".$getPlayers->id."\">".$getPlayers->name."</a></td>";    
    echo 
"<td width=75 align=center>".$getPlayers->level."</td>";    
}
elseif(
$x == "7")
{
    echo 
"<tr>";
    echo 
"<td width=75 align=center>".$x."</td>";
    echo 
"<td width=75 align=center><a href=\"index.php?s=view_char&id=".$getPlayers->id."\">".$getPlayers->name."</a></td>";    
    echo 
"<td width=75 align=center>".$getPlayers->level."</td>";    
}
elseif(
$x == "8")
{
    echo 
"<tr>";
    echo 
"<td width=75 align=center>".$x."</td>";
    echo 
"<td width=75 align=center><a href=\"index.php?s=view_char&id=".$getPlayers->id."\">".$getPlayers->name."</a></td>";    
    echo 
"<td width=75 align=center>".$getPlayers->level."</td>";    
}
elseif(
$x == "9")
{
    echo 
"<tr>";
    echo 
"<td width=75 align=center>".$x."</td>";
    echo 
"<td width=75 align=center><a href=\"index.php?s=view_char&id=".$getPlayers->id."\">".$getPlayers->name."</a></td>";    
    echo 
"<td width=75 align=center>".$getPlayers->level."</td>";    
}
elseif(
$x == "10")
{
    echo 
"<tr>";
    echo 
"<td width=75 align=center>".$x."</td>";
    echo 
"<td width=75 align=center><a href=\"index.php?s=view_char&id=".$getPlayers->id."\">".$getPlayers->name."</a></td>";    
    echo 
"<td width=75 align=center>".$getPlayers->level."</td>";    
}
    
    
$x++;
    
  }
?>
</table>
.

Was mus ich jetz da dran ändern?
MusKos991 is offline  
Old 09/14/2013, 19:26   #4
 
elite*gold: 200
Join Date: Apr 2012
Posts: 577
Received Thanks: 290
um das zu beheben fehlt mir die definition von calcPages()
MartPwnS is offline  
Old 09/14/2013, 20:11   #5
 
elite*gold: 0
Join Date: May 2012
Posts: 18
Received Thanks: 0
Kannst du mich in skype adden bitte mus.mek1 wehre echt super
MusKos991 is offline  
Old 09/14/2013, 20:16   #6
 
elite*gold: 0
Join Date: Sep 2013
Posts: 506
Received Thanks: 177
ADD mich mal in Skype.
Ich helf dir

mfg Incredible.
.In¢redible´ is offline  
Old 09/14/2013, 21:33   #7
 
elite*gold: 0
Join Date: May 2012
Posts: 18
Received Thanks: 0
#push

Keiner der mit helfen kann?
MusKos991 is offline  
Reply

Tags
hilfe fehler hp


Similar Threads Similar Threads
Liebe Scammer! Liebe Opfer! Betrug ist kein Kavaliersdelikt! Reopen
12/08/2011 - Off Topic - 6 Replies
Vorab, ich hab die erlaubniss von dem Publisher dies hier neu zu veröffentlichen. Damit auch in Zukunft leuten bei scamms geholfen werden kann !!! Liebe Community von epvp, da sich ja die Zahl der Scammer stetig erhöht, habe ich nun mal ein paar strafrechtliche Punkte zusammen gefaßt, um den Scammern und auch den Opfern mal die Augen zu öffnen! Ständig lese ich in den Threads der Opfer irgendwelche Kommis von Noobs bzw. anderen Scammern, dass man Pech gehabt hat, wenn man z.B. in einem...



All times are GMT +1. The time now is 08:35.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.