How i hide Admin And User with ban from Ranking ?
Printable View
How i hide Admin And User with ban from Ranking ?
Code:<?php $query = odbc_exec($connection,
"SELECT TOP 10 ch.AID, ch.Name, ch.Level, ch.KillCount, ac.UGradeID
FROM character ch INNER JOIN account ac ON ch.AID = ac.AID
WHERE ac.UGradeID != '255' AND ac.UGradeID != '254' AND ac.UGradeID != '252' AND ac.UGradeID != '253' AND ch.Name != '' AND ch.KillCount > 500
order by ch.XP Desc");
Dawson, why have a 500+ kill check on the character?
Where i put it ?Quote:
Originally Posted by DawsonByrd
*i using web IJJI
Replace the query in the ranking page with what Dawson posted.
sorry but i can't .Quote:
Originally Posted by phoenix_147
Top5Player:
so how i do ?Quote:
<?
$res = mssql_query("SELECT TOP 5 * FROM Character WHERE (DeleteFlag=0 OR DeleteFlag=NULL) ORDER BY Level DESC");
$count = 0;
?>
<table width="150" height="112" border="0" cellpadding="0" cellspacing="0" background="img/player_bg.jpg" style="background-repeat:no-repeat; background-position:center">
<tr>
<td height="24" align="center"><table width="135" height="10" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="15"></td>
<td align="right"><a href="index.php?gunz=playerank"><img src="img/btn_more08.gif" width="25" height="14" border="0"></a></td>
</tr>
</table></td>
</tr>
<tr>
<td align="center"><table width="130" cellpadding="0" cellspacing="0">
<tr>
<td width="12"></td>
<td width="89"></td>
<td width="34"></td>
</tr>
<?
if(mssql_num_rows($res) == 0){
?>
<tr>
<td colspan="3" align="center" class="estilo1"><font color="#FFFFFF">- No Data -</font></td>
</tr>
<?
}else{
while($player = mssql_fetch_assoc($res)){
?>
<tr>
<td width="12" height="16" valign="center"></td>
<td width="89" height="10" align="left" class="estilo1"><font color="#FFFFFF"><a href="index.php?gunz=player&info=<?=$player['CID']?>"><?=$player['Name']?></a></font></td>
<td width="34" align="right" class="estilo6">
<font color="#FFFFFF"><?=$player['Level']?></font>
</td>
</tr>
<? }} ?>
</table></td>
</tr>
<tr>
<td align="center" height="5"></td>
</tr>
</table>
Replace:
withCode:SELECT TOP 5 * FROM Character WHERE (DeleteFlag=0 OR DeleteFlag=NULL) ORDER BY Level DESC
Also, read some basic PHP tutorials before posting such things next time.Code:SELECT TOP 10 ch.AID, ch.Name, ch.Level, ch.KillCount, ac.UGradeID FROM character ch INNER JOIN account ac ON ch.AID = ac.AID WHERE ac.UGradeID != '255' AND ac.UGradeID != '254' AND ac.UGradeID != '252' AND ac.UGradeID != '253' AND ch.Name != '' order by ch.XP Desc
it's work , but if i click for Information this do
Quote:
Warning: mssql_query() [function.mssql-query]: message: Incorrect syntax near '='. (severity 15) in C:\AppServ\www\gunz\ijji_player.php on line 4
Warning: mssql_query() [function.mssql-query]: Query failed in C:\AppServ\www\gunz\ijji_player.php on line 4
Warning: mssql_fetch_assoc(): supplied argument is not a valid MS SQL-result resource in C:\AppServ\www\gunz\ijji_player.php on line 5
Warning: mssql_query() [function.mssql-query]: message: Incorrect syntax near '='. (severity 15) in C:\AppServ\www\gunz\ijji_player.php on line 7
Warning: mssql_query() [function.mssql-query]: Query failed in C:\AppServ\www\gunz\ijji_player.php on line 7
Warning: mssql_fetch_assoc(): supplied argument is not a valid MS SQL-result resource in C:\AppServ\www\gunz\ijji_player.php on line 8
Warning: mssql_query() [function.mssql-query]: message: Incorrect syntax near '='. (severity 15) in C:\AppServ\www\gunz\ijji_player.php on line 18
Warning: mssql_query() [function.mssql-query]: Query failed in C:\AppServ\www\gunz\ijji_player.php on line 18
ijji_player.php
Quote:
<? SetTitle("Gunz Online - Player Home"); ?>
<?
$cid = clean($_GET['info']);
$res = mssql_query("SELECT * FROM Character WHERE CID = $cid");
$char = mssql_fetch_assoc($res);
$res2 = mssql_query("SELECT * FROM Character a, Account b WHERE a.AID=b.AID AND CID = $cid");
$char2 = mssql_fetch_assoc($res2);
$res3 = mssql_query("SELECT * FROM ClanMember WHERE CID = '".$char['CID']."'");
$clan = mssql_fetch_assoc($res3);
$res4 = mssql_query("SELECT * FROM Clan WHERE CLID = '".$clan['CLID']."'");
$claninfo = mssql_fetch_assoc($res4);
if($claninfo == "")
$claninfo = "-";
mssql_query("UPDATE Character SET Views = Views + 1 WHERE CID = $cid");
$data = explode("/", $char2['RegDate']);
$mes = $data[1];
$dia = $data[0];
$ano = $data[2];
$data = ( isset($dia) && isset($mes) && isset($ano) ) ? $dia."/".$mes."/".$ano : "";
?>
<style type="text/css">
<!--
.Estilo1 {font-weight: bold}
-->
</style>
<table width="802" height="500" border="0" align="center">
<tr>
<td width="100" align="center" valign="top">
<table width="100" height="10" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="10" align="center"></td>
</tr>
</table></td>
<td width="160" height="26" align="center" valign="top"><? include"other/leftblock.php" ?></td>
<td width="237" align="center" valign="top"><table width="422" height="724" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center" bgcolor="#2f5374" valign="top"><table width="422" border="0">
<tr>
<td align="left" class="estilo2">
<table width="415" height="40" border="0" cellpadding="0" cellspacing="0">
<tr bgcolor="#000000">
<td height="10" colspan="2"></td>
</tr>
<tr>
<td class="estilo2" width="27"><img src="img/mini_detail.gif" width="27" height="25"></td>
<td height="30" class="estilo6"><strong>PLAYER HOME </strong></td>
</tr>
</table></td>
</tr>
<tr>
<td align="center" class="Estilo1"><table width="400" height="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center" class="Estilo1" height="25"></td>
</tr>
<tr>
<td align="center" class="Estilo1" height="25">
<table width="400" height="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center">
<table width="400" border="0" align="center" cellpadding="0" cellspacing="0" class="login3">
<tr>
<td height="5" class="Estilo1" align="center"></td>
</tr>
<tr>
<td height="35" class="Estilo2" align="center">
<?=FormatCharName($char['CID'])?> Information</td>
</tr>
<tr>
<td class="Estilo1" align="center" valign="top"><table width="390" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="top"><table width="190" border="0" align="center">
<tr>
<td colspan="2" align="center" class="estilo1">Personal Info</td>
</tr>
<tr>
<td width="125" align="left" class="estilo1" height="18"></td>
<td width="135" align="left" class="estilo1"></td>
</tr>
<tr>
<td align="left" class="estilo1">Name:</td>
<td align="left" class="estilo1"><?=$char2['Name']?></td>
</tr>
<tr>
<td align="left" class="estilo1">E-Mail:</td>
<td align="left" class="estilo1"><?=$char2['Email']?></td>
</tr>
<tr>
<td align="left" class="estilo1">Sex:</td>
<td align="left" class="estilo1"><?=$char2['Sex']?></td>
</tr>
<tr>
<td align="left" class="estilo1">Age:</td>
<td align="left" class="estilo1"><?=$char2['Age']?></td>
</tr>
<tr>
<td align="left" class="estilo1">Rank:</td>
<td align="left" class="estilo1"><?
switch ( $char2['UGradeID'] ){
case "0";
$ugradeid = "Member";
break;
case "2";
$ugradeid = "Event Winner";
break;
case "104";
$ugradeid = "Chat Banned";
break;
case "252";
$ugradeid = "GM";
break;
case "253";
$ugradeid = "Banned";
break;
case "254";
$ugradeid = "Developer";
break;
case "255";
$ugradeid = "Administrator";
break;
} echo $ugradeid;
?></td>
</tr>
<tr>
<td align="left" class="estilo1">Country:</td>
<td align="left" class="estilo1"><?=$char2['Country']?></td>
</tr>
<tr>
<td align="left" class="estilo1">User Number: </td>
<td align="left" class="estilo1"><?=$char['AID']?></td>
</tr>
<tr>
<td align="left" class="estilo1">Visit:</td>
<td align="left" class="estilo1"><?=$char['Views']?></td>
</tr>
<tr>
<td align="left" class="estilo1">Created: </td>
<td align="left" class="estilo1"><?=$char2['RegDate']?></td>
</tr>
</table></td>
<td align="center" valign="top"><table width="190" border="0" align="center">
<tr>
<td colspan="2" align="center" class="estilo1">Character Info</td>
</tr>
<tr>
<td width="125" align="left" class="estilo1" height="18"></td>
<td width="135" align="left" class="estilo1"></td>
</tr>
<tr>
<td align="left" class="estilo1">Name:</td>
<td align="left" class="estilo1"><?=$char['Name']?></td>
</tr>
<tr>
<td align="left" class="estilo1">Level:</td>
<td align="left" class="estilo1"><?=$char['Level']?></td>
</tr>
<tr>
<td align="left" class="estilo1">Ranking:</td>
<td align="left" class="estilo1"><?=$char['Ranking']?></td>
</tr>
<tr>
<td align="left" class="estilo1">Exp:</td>
<td align="left" class="estilo1"><?=number_format($char['XP'],0,'','.');?></td>
</tr>
<tr>
<td align="left" class="estilo1">Kill/Death:</td>
<td align="left" class="estilo1"><?=GetKDRatio($char['KillCount'], $char['DeathCount'])?></td>
</tr>
<tr>
<td align="left" class="estilo1">Clan:</td>
<td align="left" class="estilo1"><?=$claninfo['Name']?></td>
</tr>
<tr>
<td align="left" class="estilo1">Character Number: </td>
<td align="left" class="estilo1"><?=$char['CID']?></td>
</tr>
<tr>
<td align="left" class="estilo1" height="18">Created: </td>
<td align="left" class="estilo1"><?=$char['RegDate']?></td>
</tr>
<tr>
<td align="left" class="estilo1" height="18">Last Login: </td>
<td align="left" class="estilo1"><?=$char['LastTime']?></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
</td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td height="5" align="center"></td>
</tr>
</table></td>
</tr>
</table></td>
<td width="190" align="center" valign="top"><? include"other/rightblock.php" ?></td>
<td width="100" align="left" valign="top"><? include"mininew/rightnew.php" ?></td>
</tr>
</table>
someone can help ?
Maybe this work
Code:<? SetTitle("Gunz Online - Player Home"); ?>
<?
$cid = clean($_GET['info']);
$res = mssql_query("SELECT * FROM Character WHERE CID = '$cid'");
$char = mssql_fetch_assoc($res);
$res2 = mssql_query("SELECT * FROM Character a, Account b WHERE a.AID=b.AID AND CID = '$cid'");
$char2 = mssql_fetch_assoc($res2);
$res3 = mssql_query("SELECT * FROM ClanMember WHERE CID = '".$char['CID']."'");
$clan = mssql_fetch_assoc($res3);
$res4 = mssql_query("SELECT * FROM Clan WHERE CLID = '".$clan['CLID']."'");
$claninfo = mssql_fetch_assoc($res4);
if($claninfo == "")
$claninfo = "-";
mssql_query("UPDATE Character SET Views = Views + 1 WHERE CID = '$cid'");
$data = explode("/", $char2['RegDate']);
$mes = $data[1];
$dia = $data[0];
$ano = $data[2];
$data = ( isset($dia) && isset($mes) && isset($ano) ) ? $dia."/".$mes."/".$ano : "";
?>
<style type="text/css">
<!--
.Estilo1 {font-weight: bold}
-->
</style>
<table width="802" height="500" border="0" align="center">
<tr>
<td width="100" align="center" valign="top">
<table width="100" height="10" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="10" align="center"></td>
</tr>
</table></td>
<td width="160" height="26" align="center" valign="top"><? include"other/leftblock.php" ?></td>
<td width="237" align="center" valign="top"><table width="422" height="724" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center" bgcolor="#2f5374" valign="top"><table width="422" border="0">
<tr>
<td align="left" class="estilo2">
<table width="415" height="40" border="0" cellpadding="0" cellspacing="0">
<tr bgcolor="#000000">
<td height="10" colspan="2"></td>
</tr>
<tr>
<td class="estilo2" width="27"><img src="img/mini_detail.gif" width="27" height="25"></td>
<td height="30" class="estilo6"><strong>PLAYER HOME </strong></td>
</tr>
</table></td>
</tr>
<tr>
<td align="center" class="Estilo1"><table width="400" height="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center" class="Estilo1" height="25"></td>
</tr>
<tr>
<td align="center" class="Estilo1" height="25">
<table width="400" height="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center">
<table width="400" border="0" align="center" cellpadding="0" cellspacing="0" class="login3">
<tr>
<td height="5" class="Estilo1" align="center"></td>
</tr>
<tr>
<td height="35" class="Estilo2" align="center">
<?=FormatCharName($char['CID'])?> Information</td>
</tr>
<tr>
<td class="Estilo1" align="center" valign="top"><table width="390" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="top"><table width="190" border="0" align="center">
<tr>
<td colspan="2" align="center" class="estilo1">Personal Info</td>
</tr>
<tr>
<td width="125" align="left" class="estilo1" height="18"></td>
<td width="135" align="left" class="estilo1"></td>
</tr>
<tr>
<td align="left" class="estilo1">Name:</td>
<td align="left" class="estilo1"><?=$char2['Name']?></td>
</tr>
<tr>
<td align="left" class="estilo1">E-Mail:</td>
<td align="left" class="estilo1"><?=$char2['Email']?></td>
</tr>
<tr>
<td align="left" class="estilo1">Sex:</td>
<td align="left" class="estilo1"><?=$char2['Sex']?></td>
</tr>
<tr>
<td align="left" class="estilo1">Age:</td>
<td align="left" class="estilo1"><?=$char2['Age']?></td>
</tr>
<tr>
<td align="left" class="estilo1">Rank:</td>
<td align="left" class="estilo1"><?
switch ( $char2['UGradeID'] ){
case "0";
$ugradeid = "Member";
break;
case "2";
$ugradeid = "Event Winner";
break;
case "104";
$ugradeid = "Chat Banned";
break;
case "252";
$ugradeid = "GM";
break;
case "253";
$ugradeid = "Banned";
break;
case "254";
$ugradeid = "Developer";
break;
case "255";
$ugradeid = "Administrator";
break;
} echo $ugradeid;
?></td>
</tr>
<tr>
<td align="left" class="estilo1">Country:</td>
<td align="left" class="estilo1"><?=$char2['Country']?></td>
</tr>
<tr>
<td align="left" class="estilo1">User Number: </td>
<td align="left" class="estilo1"><?=$char['AID']?></td>
</tr>
<tr>
<td align="left" class="estilo1">Visit:</td>
<td align="left" class="estilo1"><?=$char['Views']?></td>
</tr>
<tr>
<td align="left" class="estilo1">Created: </td>
<td align="left" class="estilo1"><?=$char2['RegDate']?></td>
</tr>
</table></td>
<td align="center" valign="top"><table width="190" border="0" align="center">
<tr>
<td colspan="2" align="center" class="estilo1">Character Info</td>
</tr>
<tr>
<td width="125" align="left" class="estilo1" height="18"></td>
<td width="135" align="left" class="estilo1"></td>
</tr>
<tr>
<td align="left" class="estilo1">Name:</td>
<td align="left" class="estilo1"><?=$char['Name']?></td>
</tr>
<tr>
<td align="left" class="estilo1">Level:</td>
<td align="left" class="estilo1"><?=$char['Level']?></td>
</tr>
<tr>
<td align="left" class="estilo1">Ranking:</td>
<td align="left" class="estilo1"><?=$char['Ranking']?></td>
</tr>
<tr>
<td align="left" class="estilo1">Exp:</td>
<td align="left" class="estilo1"><?=number_format($char['XP'],0,'','.');?></td>
</tr>
<tr>
<td align="left" class="estilo1">Kill/Death:</td>
<td align="left" class="estilo1"><?=GetKDRatio($char['KillCount'], $char['DeathCount'])?></td>
</tr>
<tr>
<td align="left" class="estilo1">Clan:</td>
<td align="left" class="estilo1"><?=$claninfo['Name']?></td>
</tr>
<tr>
<td align="left" class="estilo1">Character Number: </td>
<td align="left" class="estilo1"><?=$char['CID']?></td>
</tr>
<tr>
<td align="left" class="estilo1" height="18">Created: </td>
<td align="left" class="estilo1"><?=$char['RegDate']?></td>
</tr>
<tr>
<td align="left" class="estilo1" height="18">Last Login: </td>
<td align="left" class="estilo1"><?=$char['LastTime']?></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
</td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td height="5" align="center"></td>
</tr>
</table></td>
</tr>
</table></td>
<td width="190" align="center" valign="top"><? include"other/rightblock.php" ?></td>
<td width="100" align="left" valign="top"><? include"mininew/rightnew.php" ?></td>
</tr>
</table>
ip put that and this work - i no see error .
but i no see informtion ...
I can't understand what you're saying.Quote:
ip put that and this work - i no see error .
but i no see informtion ...
if i put that its work .Quote:
Originally Posted by razi46
But I do not see the player info