<?php
	include "incl/config.inc.php";
	
	$rankguildquerycommand = "SELECT * FROM TGUILDTABLE ORDER BY dwPVPTotalPoint DESC";
	$rankguildquery = odbc_exec($TGAMEdatabase, $rankguildquerycommand);
	$currentrank = 1;
	$maxrank = 5;
	

		while($guildrank = odbc_fetch_array($rankguildquery))
		{
			if($currentrank <= $maxrank)
			{
				$guildmasterid = $guildrank['dwChief'];
				$rankguildmastercommand = "SELECT * FROM TCHARTABLE WHERE dwCharID = $guildmasterid";
				$rankguildmaster = odbc_exec($TGAMEdatabase, $rankguildmastercommand);
				$rankguildmasterinfo = odbc_fetch_array($rankguildmaster);
				echo "
				<tr>
					<td class='rank'>".$guildrank['szName']."</td>
					<td class='rank'>".$guildrank['bLevel']."</td>
			        <td class='rank'>".$guildrank['dwPvPTotalPoint']."</td>
					<td class='rank'>".$guildrank['dwPvPUseablePoint']."</td>
				</tr>";
				$currentrank = $currentrank + 1;
			}
		}
		odbc_close($TGAMEdatabase);
	?>