/functions/rankadjust.php

<?

function update_teamranks($ladderid,$teamid,$newrank){

    mysql_query("LOCK TABLES ladder_$ladderid");

    $ladderinfo=mysql_query("SELECT id,rank FROM ladder_$ladderid WHERE id='$teamid'");

    $linfo=mysql_fetch_array($ladderinfo);

    $oldrank="$linfo[rank]";

    if($linfo[id]){

        if(($newrank < $oldrank) && ($newrank > 0) && ($oldrank > 0)){

            mysql_query("UPDATE ladder_$ladderid SET rank=rank+1 WHERE rank >= '$newrank' AND rank <'$oldrank'");

        }else{



            if(($newrank=="0") && ($oldrank > 0)){

                mysql_query("UPDATE ladder_$ladderid SET rank=rank-1 WHERE rank >= '$oldrank'");

            }



            if(($newrank > 0) && ($oldrank=="0")){

                mysql_query("UPDATE ladder_$ladderid SET rank=rank+1 WHERE rank >= '$newrank'");

            }



            if(($newrank > 0) && ($oldrank > 0)){

                mysql_query("UPDATE ladder_$ladderid SET rank=rank-1 WHERE rank > '$oldrank' AND rank <='$newrank'");

            }



        }



        mysql_query("UPDATE ladder_$ladderid SET rank='$newrank' WHERE id='$teamid'");

    }



    mysql_query("UNLOCK TABLES");

}



//CHECK FOR DUPLICATE RANKS AND ADJUST RANKS

function rank_checkadjust($ladderid){

    $adjustranks="";

    $counter=1;

    $ladderinfo=mysql_query("SELECT rank FROM ladder_$ladderid WHERE rank > '0' ORDER BY rank");

    while(list($rank)=mysql_fetch_row($ladderinfo)){

        if($rank!="$counter"){

            $adjustranks=1;

        }



        $counter++;

    }



    if($adjustranks){

        //mysql_query("LOCK TABLES ladder_$ladderid");

        $countranks=1;

        $updateranks=mysql_query("SELECT id FROM ladder_$ladderid WHERE rank > '0' ORDER by rank");

        while(list($team)=mysql_fetch_row($updateranks)){

            mysql_query("UPDATE ladder_$ladderid SET rank='$countranks' WHERE id='$team'");

            $countranks++;

        }



        $ranksadjusted=1;

        //mysql_query("UNLOCK TABLES");

    }



    return($ranksadjusted);

}



?>