With respect to Web - clan ranking
Toda la web b20 funciona perfectamente, pero tengo problemas al mostrar el ranking de los clanes. aqui las fotos:
ImageShack® - Online Photo and Video Hosting
ImageShack® - Online Photo and Video Hosting
ImageShack® - Online Photo and Video Hosting
I put pictures of sql, client, website.
and mod_clanrank php
mod_clanrank.php
PHP Code:
<?
?><table border="0" style="border-collapse: collapse" width="678">
<td width="599" valign="top">
<div align="center">
<table border="0" style="background-position: center top; border-collapse: collapse; background-image:url('images/content_bg.jpg'); background-repeat:repeat-y" width="603">
<tr>
<td style="background-image: url('images/content_title_ranking1.jpg'); background-repeat: no-repeat; background-position: center top" height="25" width="601" colspan="3"> </td>
</tr>
<tr>
<td style="background-repeat: repeat; background-position: center top" width="7" rowspan="5"> <p> </p>
<p> </td>
<td style="background-repeat: repeat; background-position: center top" width="583" valign="top">
</td>
<td style="background-repeat: repeat; background-position: center top" width="7" rowspan="5"> </td>
</tr>
<tr>
<td style="background-repeat: repeat; background-position: center top" width="583" valign="top">
<div align="center">
<table border="0" style="background-position: center top; border-collapse: collapse; background-image: url('images/content_ranking_clan_top4.jpg'); background-repeat:no-repeat" width="563" height="146">
<?
$res = mssql_query("SELECT TOP 4 * FROM Clan(nolock) WHERE (DeleteFlag=0 OR DeleteFlag=NULL) AND Ranking != 0 ORDER BY Ranking ASC");
$Count = 0;
while($resa = mssql_fetch_object($res))
{
$FirstClan[$Count][Name] = $resa->Name;
$FirstClan[$Count][EmblemURL] = ($resa->EmblemUrl == "") ? "http://forum.ragezone.com/images/no_emblem.png" : $resa->EmblemUrl;
if($Count == 4)
break;
else
$Count++;
}
$firstclanemb0 = ($FirstClan[0][EmblemURL] == "") ? "http://forum.ragezone.com/images/no_emblem.png" : $FirstClan[0][EmblemURL];
$firstclanemb1 = ($FirstClan[1][EmblemURL] == "") ? "http://forum.ragezone.com/images/no_emblem.png" : $FirstClan[1][EmblemURL];
$firstclanemb2 = ($FirstClan[2][EmblemURL] == "") ? "http://forum.ragezone.com/images/no_emblem.png" : $FirstClan[2][EmblemURL];
$firstclanemb3 = ($FirstClan[3][EmblemURL] == "") ? "http://forum.ragezone.com/images/no_emblem.png" : $FirstClan[3][EmblemURL];
$firstclanname0 = ($FirstClan[0][Name] == "") ? "No data" : $FirstClan[0][Name];
$firstclanname1 = ($FirstClan[1][Name] == "") ? "No data" : $FirstClan[1][Name];
$firstclanname2 = ($FirstClan[2][Name] == "") ? "No data" : $FirstClan[2][Name];
$firstclanname3 = ($FirstClan[3][Name] == "") ? "No data" : $FirstClan[3][Name];
$toprank = '
<tr>
<td width="144" valign="bottom" height="107">
<div align="center">
<img src="clanemblem/'.$firstclanemb0.'" width="64" height="64" style="border: 1px solid #000000"></td>
<td width="135" valign="bottom" height="107">
<div align="center">
<img src="clanemblem/'.$firstclanemb1.'" width="64" height="64" style="border: 1px solid #000000"></td>
<td width="126" valign="bottom" height="107">
<div align="center">
<img src="clanemblem/'.$firstclanemb2.'" width="64" height="64" style="border: 1px solid #000000"></td>
<td width="151" valign="bottom" height="107">
<div align="center">
<img src="clanemblem/'.$firstclanemb3.'" width="64" height="64" style="border: 1px solid #000000"></td>
</tr>
<tr>
<td width="556" colspan="4" height="40">
<div align="center">
<table border="0" style="border-collapse: collapse" width="556" height="100%">
<tr>
<td width="5"> </td>
<td width="128">
<div align="center">
<font color="#00FF00">
<b>'.$firstclanname0.'</b></font></td>
<td width="10"> </td>
<td width="126">
<div align="center">
<b>'.$firstclanname1.'</b></td>
<td width="7"> </td>
<td width="122">
<div align="center">
<b>'.$firstclanname2.'</b></td>
<td width="11"> </td>
<td width="122">
<div align="center">
<b>'.$firstclanname3.'</b></td>
<td width="7"> </td>
</tr>
<tr>
<td width="5"> </td>
<td width="128"> </td>
<td width="10"> </td>
<td width="126"> </td>
<td width="7"> </td>
<td width="122"> </td>
<td width="11"> </td>
<td width="122"> </td>
<td width="7"> </td>
</tr>
</table>
</div>
</td>
</tr>
</table>
</div>
</td>
</tr>';
echo $toprank;
?>
<tr>
<td style="background-repeat: repeat; background-position: center top" width="583" valign="top">
<form method="GET" name="rnksearch" action="index.php">
<input type="hidden" name="do" value="clanrank" />
<p align="center">
<select name="type">
<option value="1">Clan Name</option>
<option value="2">Master Name</option>
</select>
<input type="text" name="name" />
<input type="submit" value="Search" />
</p>
</form>
</td>
</tr>
<tr>
<td style="background-repeat: repeat; background-position: center top" width="583" valign="top">
<div align="center">
<table border="0" style="border-collapse: collapse; background-image: url('images/content_ranking_data_bg.jpg'); background-repeat: no-repeat; background-position: center top">
<tr>
<td width="14" height="21"> </td>
<td width="60" height="21" valign="bottom">
<div align="center">
<font face="Tahoma"><b>
Ranking</b></font></td>
<td width="44" height="21" valign="bottom">
<div align="center">
<font face="Tahoma"><b>Emblem</b></font></td>
<td width="98" height="21" valign="bottom">
<div align="center">
<font face="Tahoma"><b>Clan
Name</b></font></td>
<td width="93" height="21" valign="bottom">
<div align="center">
<font face="Tahoma"><b>
Leader</b></font></td>
<td width="82" height="21" valign="bottom">
<div align="center">
<font face="Tahoma"><b>Win/Losses</b></font></td>
<td width="92" height="21" valign="bottom">
<div align="center">
<font face="Tahoma"><b>Win %</b></font></td>
<td width="69" height="21" valign="bottom">
<div align="center">
<font face="Tahoma"><b>
Points</b></font></td>
<td width="13" height="21"> </td>
</tr>
<tr>
<td width="14"> <p> </p>
<p> </p>
<p> </td>
<td width="538" colspan="7" valign="top">
<div align="center">
<table border="0" style="border-collapse: collapse" width="102%">
<tr>
<td width="59"> </td>
<td width="43"> </td>
<td width="99"> </td>
<td width="93"> </td>
<td width="82"> </td>
<td width="92"> </td>
<td width="69"> </td>
</tr>
<?
if( isset($_GET['type']) && isset($_GET['name']) )
{
$search = 1;
$type = antisql($_GET['type']);
$name = antisql($_GET['name']);
if($type == 1)
{
$squery = "SELECT * FROM Clan(nolock) WHERE Name = '$name'";
}
elseif($type == 2)
{
$charq = mssql_query("SELECT CID FROM Character(nolock) WHERE Name = '$name'");
if( mssql_num_rows($charq) == 1 )
{
$characterdata = mssql_fetch_row($charq);
$cid = $characterdata[0];
$squery = "SELECT * FROM Clan(nolock) WHERE MasterCID = '$cid' AND DeleteFlag=0 ORDER BY Ranking ASC";
}
else
{
echo '
<tr>
<td width="528" colspan="5">
<p align="center">
No data</td>
</tr>';
}
}
else
{
$search = 0;
}
}
else
{
$search = 0;
}
if( $search == 0 )
{
switch( antisql($_GET['page']) )
{
case "":
$ranks = "Ranking <= 20";
break;
case "2":
$ranks = "Ranking > 20 AND Ranking <= 40";
break;
case "3":
$ranks = "Ranking > 40 AND Ranking <= 60";
break;
case "4":
$ranks = "Ranking > 60 AND Ranking <= 80";
break;
case "5":
$ranks = "Ranking > 80 AND Ranking <= 100";
break;
default:
$ranks = "Ranking <= 20";
break;
}
$res = mssql_query("SELECT TOP 20 * FROM Clan(nolock) WHERE Ranking != 0 AND $ranks AND (DeleteFlag=0 OR DeleteFlag=NULL) AND ((Wins != 0) OR (Losses != 0)) ORDER BY Ranking ASC");
}
else
{
$res = mssql_query($squery);
}
if(mssql_num_rows($res) <> 0)
{
while($clan = mssql_fetch_object($res))
{
$clanemburl = ($clan->EmblemUrl == "") ? "http://forum.ragezone.com/images/no_emblem.png" : $clan->EmblemUrl;
$clanrank .= '
<tr>
<td width="59" align="center">
<b>'.$clan->Ranking.'</b></td>
<td width="43" align="center">
<div align="center">
<img src="clanemblem/'.GetEmblemURL($clan->CLID).'" width="34" height="30" style="border: 1px solid #000000"></td>
<td width="99" align="center">
<a href="index.php?do=claninfo&id='.$clan->CLID.'">'.$clan->Name.'</a></td>
<td width="93" align="center">
<a href="index.php?do=charinfo&id='.$clan->MasterCID.'">'.GetCharNameByCID($clan->MasterCID).'</a></td>
<td width="82" align="center">
'.$clan->Wins . "/" . $clan->Losses.'</td>
<td width="92" align="center">
'.GetClanPercent($clan->Wins, $clan->Losses).'</td>
<td width="69" align="center">
'.$clan->Point.'</td>
</tr>';
}
}else{
$clanrank = '
<tr>
<td width="537" align="center" colspan="7">
No data</td>
</tr>';
}
echo $clanrank;
?>
</table>
</div>
<?
if( $search == 0 )
{
?>
<p align="center"><a href="index.php?do=clanrank">[1-20]</a> - <a href="index.php?do=clanrank&page=2">[21-40]</a> - <a href="index.php?do=clanrank&page=3">[41-60]</a>
- <a href="index.php?do=clanrank&page=4">[61-80]</a> - <a href="index.php?do=clanrank&page=5">[81 - 100]</a></p>
<?
}
?>
</td>
<td width="13"> </td>
</tr>
</table>
</div>
<p> </td>
</tr>
<tr>
<td style="background-repeat: repeat; background-position: center top" width="583" valign="top"> </td>
</tr>
<tr>
<td height="17" style="background-image: url('images/content_top.jpg'); background-repeat: no-repeat; background-position: center bottom" width="601" colspan="3"></td>
</tr>
</table>
</div>
</td>
</tr>
</table>
ps: b20 web use and database phoenix
Re: With respect to Web - clan ranking
Ya I had this too.
Make sure it has a rank in the DB (ranking column) and then make sure the win/lose count is in there.
If that doesn't work you could always delete the part of the statement to make it so that all clans would show.
Re: With respect to Web - clan ranking
Quote:
Originally Posted by
wesman2232
Ya I had this too.
Make sure it has a rank in the DB (ranking column) and then make sure the win/lose count is in there.
If that doesn't work you could always delete the part of the statement to make it so that all clans would show.
see the database I use. and contains no db.clanrank table, be that the reason?
the problem is not that content would take the table to create it manually: (
Re: With respect to Web - clan ranking
No, when I said DB I meant the clan.dbo and set the 'Ranking' column to something other than NULL or 0
