Mysqldan veri çekerken takıldım:)

15-09-2012, 02:33:26

Kimlik doğrulama veya yönetimden onay bekliyor.

Selam

  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
  WHERE player.name NOT LIKE '[%]%' AND account.status!='BLOCK'
  ORDER BY player.level DESC, player.exp DESC";

Bu şekilde Account status BLOCK Olanları ekrana yazmasını engeliyorum fakat

  $sqlCmd = "SELECT player.id,player.name,player.level,player.exp,player.job,player.playtime,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
  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)) {
    $zF = ($x%2==0) ? "thell" : "tdunkel";
    if(checkInt($markierteZeile) && $markierteZeile==$x) { $zF = "tmarkiert"; }
	
	echo"<tr class='even' height='25px' align='center'>";
	echo"<td>".$x."</td>";
	echo"<td><a href='index.php?sayfa=detay&char=".$getPlayers->id."'>$getPlayers->name</a></td>";
	echo"<td><img height='15' src='template/m2wars/img/job_thub/".$getPlayers->job.".jpg' /></td>";
	echo"<td>".$getPlayers->exp."</td>	";
	echo"<td>".$getPlayers->level."</td>";
	echo"<td>".$getPlayers->playtime." dk.</td>";
	echo"</tr>";
    
    $x++;

Bu şekilde ekrana sorguyu yazdıramıyorum eksik nerededir Teşşekür eder hayırlı geceler dilerim.

15-09-2012, 12:52:12

~~meneleos~~

Üyeliği durduruldu

adopha adlı üyeden alıntı: mesajı görüntüle

Selam

  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
  WHERE player.name NOT LIKE '[%]%' AND account.status!='BLOCK'
  ORDER BY player.level DESC, player.exp DESC";

Bu şekilde Account status BLOCK Olanları ekrana yazmasını engeliyorum fakat

  $sqlCmd = "SELECT player.id,player.name,player.level,player.exp,player.job,player.playtime,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
  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)) {
    $zF = ($x%2==0) ? "thell" : "tdunkel";
    if(checkInt($markierteZeile) && $markierteZeile==$x) { $zF = "tmarkiert"; }
	
	echo"<tr class='even' height='25px' align='center'>";
	echo"<td>".$x."</td>";
	echo"<td><a href='index.php?sayfa=detay&char=".$getPlayers->id."'>$getPlayers->name</a></td>";
	echo"<td><img height='15' src='template/m2wars/img/job_thub/".$getPlayers->job.".jpg' /></td>";
	echo"<td>".$getPlayers->exp."</td>	";
	echo"<td>".$getPlayers->level."</td>";
	echo"<td>".$getPlayers->playtime." dk.</td>";
	echo"</tr>";
    
    $x++;

Bu şekilde ekrana sorguyu yazdıramıyorum eksik nerededir Teşşekür eder hayırlı geceler dilerim.

  $sqlCmd = "SELECT player.id,player.name,player.level,player.exp,player.job,player.playtime,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)) { 
    $zF = ($x%2==0) ? "thell" : "tdunkel"; 
    if(checkInt($markierteZeile) && $markierteZeile==$x) { $zF = "tmarkiert"; } 
     
    echo"<tr class='even' height='25px' align='center'>"; 
    echo"<td>".$x."</td>"; 
    echo"<td><a href='index.php?sayfa=detay&char=".$getPlayers->id."'>$getPlayers->name</a></td>"; 
    echo"<td><img height='15' src='template/m2wars/img/job_thub/".$getPlayers->job.".jpg' /></td>"; 
    echo"<td>".$getPlayers->exp."</td>    "; 
    echo"<td>".$getPlayers->level."</td>"; 
    echo"<td>".$getPlayers->playtime." dk.</td>"; 
    echo"</tr>"; 
     
    $x++;

account.status yapmadan önce join eklemen gerekirdi. Yukarıdaki kodu dene kodları ekledim.

  INNER JOIN account.account 
  ON account.id=player.account_id

Bu arada yukarıda lonca ismini de alıyorsun ama tabloda göstermemişsin, eklemek istiyorsan;

if ($getPlayers->guild_name == "") { $lonca = "Lonca Yok"; } else { $lonca = $getPlayers->guild_name; }

echo"<td>".$lonca." </td>";

25-09-2012, 22:45:03

#3

adopha

Teşekkürler....