en esta ocasion tengo un pequeño problema con un codigo php que no lo he logrado traducir bien del todo en php por eso quisiera su ayuda a ver si ustedes pueden dejarlo en VB bien.
el codigo es el siguiente.
Código:
ese es el codigo que quisiera pasarlo en php quisiera alguien me podria ayudar a traducirlo por completo a VB, ya luego ire intendiendo. espero su ayuda gracias. <?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 TotalGrade='19' WHERE TotalScore >= 0 and TotalScore < 1099 and TotalGrade != 19 and NoRankUpdate = 0"); $db->Execute("UPDATE game SET TotalGrade='18' WHERE TotalScore >= 1100 and TotalScore < 1199 and TotalGrade !=18 and NoRankUpdate = 0"); $db->Execute("UPDATE game SET TotalGrade='17' WHERE TotalScore >= 1200 and TotalScore < 1499 and TotalGrade !=17 and NoRankUpdate = 0"); $db->Execute("UPDATE game SET TotalGrade='16' WHERE TotalScore >= 1500 and TotalScore < 1799 and TotalGrade !=16 and NoRankUpdate = 0"); $db->Execute("UPDATE game SET TotalGrade='15' WHERE TotalScore >= 1800 and TotalScore < 2299 and TotalGrade !=15 and NoRankUpdate = 0"); $db->Execute("UPDATE game SET TotalGrade='14' WHERE TotalScore >= 2300 and TotalScore < 2799 and TotalGrade !=14 and NoRankUpdate = 0"); $db->Execute("UPDATE game SET TotalGrade='13' WHERE TotalScore >= 2800 and TotalScore < 3499 and TotalGrade !=13 and NoRankUpdate = 0"); $db->Execute("UPDATE game SET TotalGrade='12' WHERE TotalScore >= 3500 and TotalScore <= 4199 and TotalGrade !=12 and NoRankUpdate = 0"); $db->Execute("UPDATE game SET TotalGrade='11' WHERE TotalScore >= 4200 and TotalScore <= 5099 and TotalGrade !=11 and NoRankUpdate = 0"); $db->Execute("UPDATE game SET TotalGrade='10' WHERE TotalScore >= 5100 and TotalScore <= 5999 and TotalGrade !=10 and NoRankUpdate = 0"); $db->Execute("UPDATE game SET TotalGrade='9' WHERE TotalScore >= 6000 and TotalScore <= 6899 and TotalGrade !=9 and NoRankUpdate = 0"); $db->Execute("UPDATE game SET TotalGrade='8' WHERE TotalScore >= 6900 and TotalScore <= 8172 and TotalGrade !=8 and NoRankUpdate = 0"); $db->Execute("UPDATE game SET TotalGrade='7' WHERE TotalScore >= 8173 and TotalScore <= 9939 and TotalGrade !=7 and NoRankUpdate = 0"); $db->Execute("UPDATE game SET TotalGrade='6' WHERE TotalScore >= 9940 and TotalScore <= 13076 and TotalGrade !=6 and NoRankUpdate = 0"); $db->Execute("UPDATE game SET TotalGrade='5' WHERE TotalScore >= 13077 and TotalScore <= 16024 and TotalGrade !=5 and NoRankUpdate = 0"); $db->Execute("UPDATE game SET TotalGrade='4' WHERE TotalScore >= 16025 and TotalScore <= 21984 and TotalGrade != 4 and NoRankUpdate = 0"); $db->Execute("UPDATE game SET TotalGrade='3' WHERE TotalScore >= 21985 and TotalScore <= 27280 and TotalGrade !=3 and NoRankUpdate = 0"); $db->Execute("UPDATE game SET TotalGrade='2' WHERE TotalScore >= 27281 and TotalScore <= 35334 and TotalGrade !=2 and NoRankUpdate = 0"); $db->Execute("UPDATE game SET TotalGrade='1' WHERE TotalScore >= 35335 and TotalScore <= 51221 and TotalGrade !=1 and NoRankUpdate = 0"); $db->Execute("UPDATE game SET TotalGrade='0' WHERE TotalScore >= 51222 and TotalScore <= 107915 and TotalGrade !=0 and NoRankUpdate = 0"); $db->Execute("UPDATE game SET TotalGrade='-1' WHERE TotalScore >= 107916 and TotalScore <= 199628 and TotalGrade !=-1 and NoRankUpdate = 0"); $db->Execute("UPDATE game SET TotalGrade='-2' WHERE TotalScore >= 199629 and TotalScore <= 227294 and TotalGrade !=-2 and NoRankUpdate = 0"); $db->Execute("UPDATE game SET TotalGrade='-3' WHERE TotalScore >= 227295 and TotalScore <= 238203 and TotalGrade !=-3 and NoRankUpdate = 0"); $db->Execute("UPDATE game SET TotalGrade='-4' WHERE TotalScore >= 238204 and TotalGrade !=-4 and NoRankUpdate = 0"); } updaterank(); updategrade(); ?>