xem ở file cập nhật
<?PHP
function updaterank() {
global $db;
$updrank = $db->Execute("SELECT Id, TotalScore FROM game ORDER BY 'TotalScore' DESC");
$rank = 0;
foreach ($updrank->GetArray() as $r => $rankinfo) {
$rank++;
$db->Execute("UPDATE game SET TotalRank=? WHERE Id = ?", array($rank,$rankinfo['Id']));
}
}
function updategrade() {
global $db;
$db->Execute("UPDATE game SET CountryGrade='19' WHERE TotalScore >= 0 and TotalScore < 1099 and CountryGrade != 19 and NoRankUpdate = 0");
$db->Execute("UPDATE game SET CountryGrade='18' WHERE TotalScore >= 1100 and TotalScore < 1199 and CountryGrade !=18 and NoRankUpdate = 0");
$db->Execute("UPDATE game SET CountryGrade='17' WHERE TotalScore >= 1200 and TotalScore < 1499 and CountryGrade !=17 and NoRankUpdate = 0");
$db->Execute("UPDATE game SET CountryGrade='16' WHERE TotalScore >= 1500 and TotalScore < 1799 and CountryGrade !=16 and NoRankUpdate = 0");
$db->Execute("UPDATE game SET CountryGrade='15' WHERE TotalScore >= 1800 and TotalScore < 2299 and CountryGrade !=15 and NoRankUpdate = 0");
$db->Execute("UPDATE game SET CountryGrade='14' WHERE TotalScore >= 2300 and TotalScore < 2799 and CountryGrade !=14 and NoRankUpdate = 0");
$db->Execute("UPDATE game SET CountryGrade='13' WHERE TotalScore >= 2800 and TotalScore < 3499 and CountryGrade !=13 and NoRankUpdate = 0");
$db->Execute("UPDATE game SET CountryGrade='12' WHERE TotalScore >= 3500 and TotalScore <= 4199 and CountryGrade !=12 and NoRankUpdate = 0");
$db->Execute("UPDATE game SET CountryGrade='11' WHERE TotalScore >= 4200 and TotalScore <= 5099 and CountryGrade !=11 and NoRankUpdate = 0");
$db->Execute("UPDATE game SET CountryGrade='10' WHERE TotalScore >= 5100 and TotalScore <= 5999 and CountryGrade !=10 and NoRankUpdate = 0");
$db->Execute("UPDATE game SET CountryGrade='9' WHERE TotalScore >= 6000 and TotalScore <= 6899 and CountryGrade !=9 and NoRankUpdate = 0");
$db->Execute("UPDATE game SET CountryGrade='8' WHERE TotalScore >= 6900 and TotalScore <= 8172 and CountryGrade !=8 and NoRankUpdate = 0");
$db->Execute("UPDATE game SET CountryGrade='7' WHERE TotalScore >= 8173 and TotalScore <= 9939 and CountryGrade !=7 and NoRankUpdate = 0");
$db->Execute("UPDATE game SET CountryGrade='6' WHERE TotalScore >= 9940 and TotalScore <= 13076 and CountryGrade !=6 and NoRankUpdate = 0");
$db->Execute("UPDATE game SET CountryGrade='5' WHERE TotalScore >= 13077 and TotalScore <= 16024 and CountryGrade !=5 and NoRankUpdate = 0");
$db->Execute("UPDATE game SET CountryGrade='4' WHERE TotalScore >= 16025 and TotalScore <= 21984 and CountryGrade != 4 and NoRankUpdate = 0");
$db->Execute("UPDATE game SET CountryGrade='3' WHERE TotalScore >= 21985 and TotalScore <= 27280 and CountryGrade !=3 and NoRankUpdate = 0");
$db->Execute("UPDATE game SET CountryGrade='2' WHERE TotalScore >= 27281 and TotalScore <= 35334 and CountryGrade !=2 and NoRankUpdate = 0");
$db->Execute("UPDATE game SET CountryGrade='1' WHERE TotalScore >= 35335 and TotalScore <= 51221 and CountryGrade !=1 and NoRankUpdate = 0");
$db->Execute("UPDATE game SET CountryGrade='0' WHERE TotalScore >= 51222 and TotalScore <= 107915 and CountryGrade !=0 and NoRankUpdate = 0");
$db->Execute("UPDATE game SET CountryGrade='-1' WHERE TotalScore >= 107916 and TotalScore <= 199628 and CountryGrade !=-1 and NoRankUpdate = 0");
$db->Execute("UPDATE game SET CountryGrade='-2' WHERE TotalScore >= 199629 and TotalScore <= 227294 and CountryGrade !=-2 and NoRankUpdate = 0");
$db->Execute("UPDATE game SET CountryGrade='-3' WHERE TotalScore >= 227295 and TotalScore <= 238203 and CountryGrade !=-3 and NoRankUpdate = 0");
$db->Execute("UPDATE game SET CountryGrade='-4' WHERE TotalScore >= 238204 and CountryGrade !=-4 and NoRankUpdate = 0");
}
function updatecountryrank() {
global $config, $db;
$result = $db->Execute("SELECT DISTINCT Country, count( Id ) as counts, sum(TotalScore) as TotalScores
FROM game
WHERE Country IS NULL
OR Country != ''
GROUP BY Country order by TotalScores desc");
if ($db->Affected_Rows() > 0) {
foreach ($result->GetArray() as $rs => $r) {
$db->Execute('Update game set CountryRank = ? where Country = ?', array($r['counts'], $r['Country']));
$result2 = $db->Execute("Select Id, Country from game where Country=? order by TotalScore desc",array($r['Country']));
if ($db->Affected_Rows() > 0) {
$grank=0;
foreach ($result2->GetArray() as $rs2 => $r) {
$grank++;
$db->Execute('Update game set CountryRank = ? where Country = ? and Id=?', array($grank, $r['Country'],$r['Id']));
}
}
}
}
}
function updateguilds() {
global $config, $db;
$result = $db->Execute("SELECT DISTINCT Guild, count( Id ) as counts, sum(TotalScore) as TotalScores
FROM game
WHERE Guild IS NULL
OR Guild != ''
GROUP BY Guild order by TotalScores desc");
if ($db->Affected_Rows() > 0) {
foreach ($result->GetArray() as $rs => $r) {
$db->Execute('Update game set MemberCount = ? where Guild = ?', array($r['counts'], $r['Guild']));
$result2 = $db->Execute("Select Id, Guild from game where Guild=? order by TotalScore desc",array($r['Guild']));
if ($db->Affected_Rows() > 0) {
$grank=0;
foreach ($result2->GetArray() as $rs2 => $r) {
$grank++;
$db->Execute('Update game set GuildRank = ? where Guild = ? and Id=?', array($grank, $r['Guild'],$r['Id']));
}
}
}
}
}
updaterank();
updategrade();
header('Refresh: 1; url=RANKING.GBVN');
?>
<link href="template/GBVN/images/portal.css" rel="stylesheet" type="text/css" />
<link href="css/gunbound.css" rel="stylesheet" type="text/css" />
<link href="css/gunbound_content.css" rel="stylesheet" type="text/css" />
<link href="css/gunbound_main.css" rel="stylesheet" type="text/css" />
<script language="javascript">
<!--
function SexChange()
{
url ="avatarlist.html?IT=all&page=&SCH=&ODR=6&SX=";
url = url + document.Frm1.SX.options[document.Frm1.SX.selectedIndex].value;
location.href = url
}
//-->
</script>
<script language="JavaScript">
<!--
function bluring(){
if(event.srcElement.tagName=="A"||event.srcElement.tagName=="IMG")
document.body.focus();
}
document.onfocusin=bluring;
// -->
</script>
<script type="text/JavaScript">
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
window.open(theURL,winName,features);
}
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
//-->
</script>
<style type="text/css">
<!--
.parte1 {
font-family: "Trebuchet MS";
font-weight: bold;
font-size: 36px;
color: #999900;
}
.parte2 {
font-size: 16px;
color: #333333;
}
.aguardeservices {color: #666666}
-->
</style>
<body>
<table width="585" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="584" align="center"><br>
<table width="560" border="0" align="left" cellpadding="0" cellspacing="0" bgcolor="#F9F9F9">
<tr>
<td width="12" valign="top"></td>
<td width="545" align="center" valign="top"><p class="parte1"><span class="parte2">[1]</span> <span class="parte1">[2] </span></p>
<p><strong>Nâng cấp RANK! </strong><br>
<span class="aguardeservices">Xin đợi 1 lúc. </span></p></td>
</tr>
</table>
<p> </p></td><td width="1"></td>
<td width="71"><br />
<br />
<br />
<br /> </td>
<td width="23"> </td>
</tr>
</table>