Exemple #1
0
        $champ_id = urlvar("champ_id");
        $db->set_session_picked_champion_id($session_id, $role, $champ_id);
        break;
    case "setpickedplayerid":
        $session_id = urlvar("session_id");
        $role = urlvar("role");
        $player_id = urlvar("player_id");
        $db->set_session_picked_player_id($session_id, $role, $player_id);
        break;
    case "setstarterid":
        $session_id = urlvar("session_id");
        $role = urlvar("role");
        $starter_id = urlvar("starter_id");
        $starter_number = urlvar("starter_number");
        $db->set_session_starter_id($session_id, $role, $starter_id, $starter_number);
        break;
    case "setenemychampid":
        $session_id = urlvar("session_id");
        $enemy_champion_id = urlvar("enemy_champion_id");
        $champion_number = urlvar("champion_number");
        $db->set_session_enemy_champion_id($session_id, $enemy_champion_id, $champion_number);
        break;
    case "setbanid":
        $session_id = urlvar("session_id");
        $ban_champ_id = urlvar("ban_champ_id");
        $teamban = urlvar("teamban");
        $ban_number = urlvar("ban_number");
        $db->set_session_ban_id($session_id, $ban_champ_id, $teamban, $ban_number);
        break;
}
$db->disconnect();
    case "retrieveall":
        $champ_ids = $db->get_champ_ids();
        $champions = array();
        foreach ($champ_ids as $champ_id) {
            $champions[] = new Champion($champ_id);
        }
        echo json_encode($champions);
        break;
    case "retrieve":
        $champ_id = urlvar("champ_id");
        $champion_player_ids = $db->get_champion_player_ids($champ_id);
        $champion_players = array("Top Lane" => array(), "Jungle" => array(), "Mid Lane" => array(), "AD Carry" => array(), "Support" => array());
        foreach ($champion_player_ids as $role => $player_ids) {
            foreach ($player_ids as $player_id) {
                $champion_players[$role][] = new Player($champ_id);
            }
        }
        echo json_encode(array("champion" => new Champion($champ_id), "players" => $champion_players));
        break;
    case "new":
        $champ_name = urlvar("champ_name");
        $db->add_champ($comp_type);
        break;
    case "update_strength":
        $champ_id = urlvar("champ_id");
        $comp_id = urlvar("comp_id");
        $strength = urlvar("strength");
        $db->update_champions_comp_type_strength($champ_id, $comp_id, $strength);
        break;
}
$db->disconnect();
Exemple #3
0
function day($ask, $date)
{
    global $EVENTS_TB, $CAT_TB, $USER_TB, $uname, $mth, $week, $language, $m, $d, $y, $calstartyear, $caladvanceyear, $unapprovedclr, $shortdesclen, $showuserentry, $notimeentry;
    // View events for specific user
    if (!isset($_POST['huser'])) {
        $huser = '';
    } else {
        $huser = $_POST['huser'];
    }
    if (!isset($yda)) {
        $yda = '';
    }
    if (!$date) {
        $year = $y;
        $month = $m;
        $day = $d;
    } else {
        $year = substr($date, 0, 4);
        $month = substr($date, 5, 2);
        $day = substr($date, 8, 2);
    }
    $we = mktime(0, 0, 0, $month, $day, $year);
    $we = strftime("%w", $we);
    $we++;
    // variables with exact digit without the leading 0 used for query and accessing array
    $vdm = $month;
    if (substr($vdm, 0, 1) == "0") {
        $vdm = str_replace("0", "", $vdm);
    }
    $vda = $day;
    if (substr($vda, 0, 1) == "0") {
        $vda = str_replace("0", "", $vda);
    }
    $weeknumber = weekNumber($day, $month, $year);
    if ($year > $y + $caladvanceyear) {
        $weeknumber = 53;
    }
    // to ensure weeks cannot go beyond restricted dates
    if ($year < $calstartyear) {
        $weeknumber = 1;
    }
    // to ensure weeks cannot go beyond restricted dates
    echo "<table class=headerfont border=0 width=100% cellspacing=0><tr><td align=left>" . translate("Events for day");
    echo ": " . $week[$we] . " " . $day;
    if ($year <= $y + $caladvanceyear && $year >= $calstartyear) {
        echo " <a class=headerfont href=calendar.php?op=cal&month=" . $vdm . "&year=" . $year;
        urlvar($uname);
        echo " >";
    } else {
        echo " ";
    }
    echo $mth[$vdm];
    if ($year <= $y + $caladvanceyear && $year >= $calstartyear) {
        echo "</a> ";
    } else {
        echo " ";
    }
    echo $year . " &nbsp; &nbsp; <a href=cal_adminweek.php?op=week&date=" . date("Y-m-d", mktime(0, 0, 0, $month, $day, $year));
    urlvar($uname);
    echo " ><img src=\"../images/week.gif\" border=0 alt='" . translate("View week") . " {$weeknumber}" . "' width=16 height=16/></a>";
    echo " &nbsp; <a href='cal_event.php?op=eventform&add_day={$day}&add_month={$month}&add_year={$year}'><img src='../images/plus.gif' border=0 valign=middle alt='" . translate("Add Event") . "' width=11 height=11/></a>";
    echo "</td>";
    echo "<td align=right><div class=menufont>";
    // display previous day and next day navigation
    if ($year > $calstartyear || $vdm > 1 && $year == $calstartyear || $vdm == 1 && $year == $calstartyear && $vda > 1) {
        echo "<a href=\"cal_adminday.php?op=day&date=" . date("Y-m-d", mktime(0, 0, 0, $month, $day - 1, $year));
        urlvar($uname);
        echo "\"><< " . translate("Previous day") . "</a> &nbsp; ";
    } else {
        echo "&nbsp;";
    }
    $calendyear = $y + $caladvanceyear;
    if ($year < $calendyear || $vdm < 12 && $year == $calendyear || $vdm == 12 && $year == $calendyear && $vda < 31) {
        echo "<a href=\"cal_adminday.php?op=day&date=" . date("Y-m-d", mktime(0, 0, 0, $month, $day + 1, $year));
        urlvar($uname);
        echo "\">" . translate("Next day") . " >></a> &nbsp; &nbsp;<br/>";
    } else {
        echo "&nbsp;";
    }
    echo "</div></td></tr></table>";
    $query = "select id,user,title,description,url,email,cat_name,starttime,endtime,day,month,year,approved from " . $EVENTS_TB . " left join " . $CAT_TB . " on " . $EVENTS_TB . ".cat=" . $CAT_TB . ".cat_id where day='{$vda}' and month='{$vdm}' and year='{$year}' ";
    if ($uname != "" && $uname != "-") {
        $query = $query . " and " . $EVENTS_TB . ".user='******' ";
    }
    $query = $query . " order by starttime,title ASC";
    $result = mysql_query($query);
    echo "<table class=dayevent width=100% border=0 class=dayevent cellspacing=0><tr><td align=left>";
    if (mysql_num_rows($result) != 0) {
        while ($row = mysql_fetch_object($result)) {
            if ($row->approved == '0') {
                echo "<table class=dayevent width=100% border=0 ><tr><td bgcolor='{$unapprovedclr}'>";
            }
            if ($notimeentry == 0) {
                if ($row->starttime == '') {
                    echo "<li>";
                } else {
                    showtime($row->starttime, $row->endtime, 0);
                }
            } else {
                echo "<li>";
            }
            echo "<b>" . stripslashes($row->title);
            if ($showuserentry == 1) {
                echo " &nbsp;&lt;" . $row->user . "&gt;";
            }
            echo "</b>";
            if ($notimeentry == 1 || $row->starttime == '') {
                echo "</li>";
            } else {
                echo "<br/>";
            }
            echo translate("Category") . " : " . stripslashes($row->cat_name) . "<br/>";
            $de = $row->description;
            //$de = str_replace("<br />","",$row->description);
            echo substr(stripslashes($de), 0, $shortdesclen);
            if ($row->email != "" || $row->url != "" || strlen($de) > $shortdesclen) {
                echo " ...\n";
            } else {
                echo "\n";
            }
            echo "<div class=menufont><a href=cal_event.php?op=view&id=" . $row->id . ">" . translate("View event") . "</a>\n";
            echo " - <a href=cal_event.php?op=edit&id=" . $row->id . ">" . translate("Edit event") . "</a>\n";
            echo " - <a href=cal_event.php?op=delev&id=" . $row->id . ">" . translate("Delete event") . "</a>\n";
            if ($row->approved == '0') {
                echo " - <a href=calendar.php?op=approve&id=" . $row->id . ">" . translate("Approve") . "</a>\n";
            }
            echo "</div>\n";
            echo "<hr/>";
            if ($row->approved == '0') {
                echo "</td></tr></table>";
            }
        }
    } else {
        echo "&nbsp;<br/>";
    }
    echo "</td></tr></table>";
    // this is for the goto day redirection javascript
    echo "<script language=\"JavaScript\" type=\"text/JavaScript\">\n";
    echo "\tfunction gotoday(selectopt) {\n";
    echo "var geti = '1' ;\n";
    echo "for (i=0;i<selectopt.options.length;i++) {\n";
    echo "\tif (selectopt.options[i].selected) {\n";
    echo "\t\tgeti = selectopt.options[i].value ;\n";
    echo "\t\tbreak ;\n";
    echo "\t}\n";
    echo "}\n\n";
    echo "\t\tswitch (geti) { \n";
    $dateinmonth = date("t", mktime(0, 0, 0, $month, $day, $year));
    for ($i = 1; $i <= $dateinmonth; ++$i) {
        $jstr = "cal_adminday.php?op=day&date=";
        $jstr = $jstr . date("Y-m-d", mktime(0, 0, 0, $month, $i, $year));
        if ($uname != "" && $uname != "-") {
            $jstr = $jstr . "&uname={$uname}";
        }
        echo "case \"" . $i . "\" : { window.location.href='" . $jstr . "' ; break ;} \n";
    }
    echo "default : { window.location.href='cal_adminday.php?op=day&date=" . date("Y-m-d", mktime(0, 0, 0, $month, $day, $year)) . "' ; break;} \n";
    echo "\t\t}\n";
    echo "\t}\n";
    echo "</script>";
    // display form functions
    echo "<table border=0 width=100%><tr><td align=left width=50%>";
    echo "<table width=100 cellspacing=0 cellpadding=2 align=left class=txtbox><tr><td bgcolor='{$unapprovedclr}' align=center><div class=normalfont>" . translate("Unapproved events") . "</div></td></tr></table>\n</td>";
    echo "<td align=right valign=middle width=50%>";
    echo "<form><div class=menufont>\n";
    echo "<b>" . translate("Go to day") . " </b>";
    // get week number
    echo "<select name=goday onchange=\"javascript:gotoday(this);\"";
    if ($year > $y + $caladvanceyear || $year < $calstartyear) {
        echo " disabled";
    }
    echo ">\n";
    for ($i = 1; $i <= $dateinmonth; $i++) {
        echo "\t<option value=" . $i;
        if ($day == $i) {
            echo " selected ";
        }
        echo ">" . $i . "\n";
    }
    echo "</select>\n";
    echo "<b>" . translate("or week") . " </b>";
    // get week number
    echo "<select name=goweek onchange=\"javascript:gotoweek(this);\">\n";
    for ($i = 1; $i < 53; $i++) {
        echo "\t<option value=" . $i;
        if ($weeknumber == $i) {
            echo " selected ";
        }
        echo ">" . $i . "\n";
    }
    if (showWeek53($year) > 52) {
        for ($i = 53; $i <= showWeek53($year); $i++) {
            echo "\t<option value=" . $i;
            if ($weeknumber == $i) {
                echo " selected ";
            }
            echo ">" . $i . "\n";
        }
    }
    echo "</select>&nbsp;&nbsp;<br/>\n";
    // Display the users to be selected
    echo "<b>" . translate("View events of user") . ": </b> &nbsp;";
    // get users
    $uquery = "select username,user_id from " . $USER_TB;
    $uresult = mysql_query($uquery);
    echo "<select name=huser onchange=\"Javascript:seeuser(this);\">\n";
    echo "\t<option value='-'";
    if ($uname == "-" || $uname == "") {
        echo " selected ";
    }
    echo ">--\n";
    while ($urow = mysql_fetch_object($uresult)) {
        echo "\t<option value='{$urow->username}'";
        if ($uname == "{$urow->username}") {
            echo " selected ";
        }
        echo ">" . $urow->username . "\n";
    }
    echo "</select>&nbsp;&nbsp;\n";
    echo "</div></form>";
    echo "</td>";
    echo "<td align=right valign=middle width=33%>";
    echo "</td></tr></table>";
}
Exemple #4
0
function week($week, $date)
{
    global $EVENTS_TB, $CAT_TB, $USER_TB, $mth, $week, $m, $d, $y, $ld, $fd, $weekstartday, $calstartyear, $caladvanceyear, $unapprovedclr, $shortdesclen, $showuserentry, $uname, $notimeentry;
    // View events for specific user
    if (!isset($_POST['huser'])) {
        $huser = '';
    } else {
        $huser = $_POST['huser'];
    }
    if (!$date) {
        $year = $y;
        $month = $m;
        $day = $d;
    } else {
        $year = substr($date, 0, 4);
        $month = substr($date, 5, 2);
        $day = substr($date, 8, 2);
    }
    // offset to get correct day calculation when "date" is sent
    $day_offset = date("w", mktime(0, 0, 0, $month, $day, $year));
    $dayoff = 0;
    // use to get back original url "date"
    while ($day_offset > date("w")) {
        $day--;
        $day_offset = date("w", mktime(0, 0, 0, $month, $day, $year));
        $dayoff++;
    }
    while ($day_offset < date("w")) {
        $day++;
        $day_offset = date("w", mktime(0, 0, 0, $month, $day, $year));
        $dayoff--;
    }
    // get first day of the week based on "$weekstartday"
    function firstDayOfWeek($year, $month, $day)
    {
        global $fd, $weekstartday;
        $dayOfWeek = date("w");
        $sunday_offset = $dayOfWeek * 60 * 60 * 24;
        $startday_offset = ($weekstartday - 1) * 60 * 60 * 24;
        $fd = date("Y-m-d", mktime(0, 0, 0, $month, $day + 1, $year) - $sunday_offset + $startday_offset);
        return $fd;
    }
    firstDayOfWeek($year, $month, $day);
    // get last day of the week based on "$weekstartday"
    function lastDayOfWeek($year, $month, $day)
    {
        global $ld, $weekstartday;
        $dayOfWeek = date("w");
        $saturday_offset = (6 - $dayOfWeek) * 60 * 60 * 24;
        $startday_offset = ($weekstartday - 1) * 60 * 60 * 24;
        $ld = date("Y-m-d", mktime(0, 0, 0, $month, $day + 1, $year) + $saturday_offset + $startday_offset);
        return $ld;
    }
    lastDayOfWeek($year, $month, $day);
    // display header with week number
    echo "<table class=headerfont border=0 width=100% cellspacing=0><tr><td>" . translate("Events from ");
    $fdy = substr($fd, 0, 4);
    $fdm = substr($fd, 5, 2);
    if (substr($fdm, 0, 1) == "0") {
        $fdm = str_replace("0", "", $fdm);
    }
    $fdd = substr($fd, 8, 2);
    echo $fdd . " " . $mth[$fdm] . " " . $fdy;
    echo " " . translate("till") . " ";
    $ldy = substr($ld, 0, 4);
    $ldm = substr($ld, 5, 2);
    if (substr($ldm, 0, 1) == "0") {
        $ldm = str_replace("0", "", $ldm);
    }
    $ldd = substr($ld, 8, 2);
    echo $ldd . " " . $mth[$ldm] . " " . $ldy;
    $weeknumber = weekNumber($day + $dayoff, $month, $year);
    if ($ldy > $y + $caladvanceyear) {
        $weeknumber = 53;
    }
    // to ensure weeks cannot go beyond restricted dates
    if ($fdy < $calstartyear) {
        $weeknumber = 1;
    }
    // to ensure weeks cannot go beyond restricted dates
    echo " (" . translate("week number") . " : " . $weeknumber . ")\n";
    $gdy = $ldy;
    $gdm = $ldm;
    if ($gdy > $y + $caladvanceyear) {
        $gdy = $fdy;
        $gdm = $fdm;
    }
    echo " &nbsp; &nbsp; <a href=calendar.php?op=cal&month={$gdm}&year={$gdy}";
    urlvar($uname);
    echo " ><img src=\"../images/month.gif\" border=0 alt='" . translate("View month") . " " . $mth[$gdm] . "'/></a>";
    echo "<br/>(" . translate("Week starts") . " " . $week[$weekstartday + 1] . ")\n";
    echo "</td></tr></table>";
    // display hyperlinks to previous and next week
    $calendyear = $y + $caladvanceyear;
    echo "<table width=100% border=0><tr><td align=left><div class=menufont>";
    if ($year > $calstartyear || $fdm >= 1 && $fdy == $calstartyear) {
        echo "<a href=cal_adminweek.php?op=week&date=" . date("Y-m-d", mktime(0, 0, 0, $month, $day - 7, $year));
        urlvar($uname);
        echo " ><< " . translate("Previous week") . "</a> &nbsp; ";
    }
    if ($ldy <= $calendyear) {
        echo "<a href=cal_adminweek.php?op=week&date=" . date("Y-m-d", mktime(0, 0, 0, $month, $day + 7, $year));
        urlvar($uname);
        echo " >" . translate("Next week") . " >> </a>\n";
    }
    // display the hyperlinks to each day
    echo "</div></td><td align=right><div class=menufont><b>" . translate("Go to") . ": </b>  &nbsp; ";
    $afd = $fd;
    $ald = date("Y-m-d", mktime(0, 0, 0, $ldm, $ldd + 1, $ldy));
    while ($afd != $ald) {
        $fdy = substr($afd, 0, 4);
        $fdm = substr($afd, 5, 2);
        if (substr($fdm, 0, 1) == "0") {
            $fdm = str_replace("0", "", $fdm);
        }
        $fdd = substr($afd, 8, 2);
        $weekday = date("w", mktime(12, 0, 0, $fdm, $fdd, $fdy));
        $weekday++;
        echo "<a href='#{$week[$weekday]}' >";
        echo ucfirst($week[$weekday]) . " - " . $fdd;
        echo "</a> &nbsp; ";
        $afd = date("Y-m-d", mktime(0, 0, 0, $fdm, $fdd + 1, $fdy));
    }
    echo "</div></td></tr></table>";
    $ld = date("Y-m-d", mktime(0, 0, 0, $ldm, $ldd + 1, $ldy));
    while ($fd != $ld) {
        $fdy = substr($fd, 0, 4);
        $fdm = substr($fd, 5, 2);
        if (substr($fdm, 0, 1) == "0") {
            $fdm = str_replace("0", "", $fdm);
        }
        $fdd = substr($fd, 8, 2);
        // display the day header
        echo "<table class=titlefont width=100% border=0 cellspacing=0><tr><td valign=middle align=left><div class=titlefont>";
        $weekday = date("w", mktime(12, 0, 0, $fdm, $fdd, $fdy));
        $weekday++;
        echo "<a class=none name='{$week[$weekday]}'>";
        echo ucfirst($week[$weekday]) . " ";
        echo "<a class=titlefont href='cal_adminday.php?op=day&date=" . date("Y-m-d", mktime(0, 0, 0, $fdm, $fdd, $fdy));
        urlvar($uname);
        echo "'>" . $fdd . "</a>" . " " . ucfirst($mth[$fdm]) . " " . $fdy;
        echo "</a> &nbsp; <a href='cal_event.php?op=eventform&add_day={$fdd}&add_month={$fdm}&add_year={$fdy}'><img src='../images/plus.gif' alt='" . translate("Add Event") . "' border=0 valign=middle width=11 height=11/></a>";
        echo "</div></td></tr></table>";
        // query and display events
        echo "<table class=weekevent width=100% border=0 cellspacing=0><tr><td>";
        $query = "select id,user,title,description,url,email,cat_name,starttime,endtime,day,month,year,approved from " . $EVENTS_TB . " left join " . $CAT_TB . " on " . $EVENTS_TB . ".cat=" . $CAT_TB . ".cat_id where day='{$fdd}' and month='{$fdm}' and year='{$fdy}' ";
        if ($uname != "" && $uname != "-") {
            $query = $query . " and " . $EVENTS_TB . ".user='******' ";
        }
        $query = $query . " order by starttime,title ASC";
        $result = mysql_query($query);
        if (mysql_num_rows($result) == 0) {
            echo "<br/>";
        }
        while ($row = mysql_fetch_object($result)) {
            if ($row->approved == '0') {
                echo "<table class=weekevent width=100% border=0><tr><td bgcolor='{$unapprovedclr}'>";
            }
            if ($notimeentry == 0) {
                if ($row->starttime == '') {
                    echo "<div><li>";
                } else {
                    showtime($row->starttime, $row->endtime, 0);
                }
            } else {
                echo "<div><li>";
            }
            echo "<b>" . stripslashes($row->title);
            if ($showuserentry == 1) {
                echo " &nbsp;&lt;" . $row->user . "&gt;";
            }
            echo "</b>";
            if ($notimeentry == 1 || $row->starttime == '') {
                echo "</li></div>";
            } else {
                echo "<br/>\n";
            }
            echo "<b>" . translate("Category") . " : " . "</b>" . stripslashes($row->cat_name) . "<br/>";
            $de = $row->description;
            //$de = str_replace("<br />","",$row->description);
            echo substr(stripslashes($de), 0, $shortdesclen);
            if ($row->email != "" || $row->url != "" || strlen($de) > $shortdesclen) {
                echo " ...\n";
            } else {
                echo "\n";
            }
            echo "<br/>";
            echo "<div class=menufont><a href=cal_event.php?op=view&id=" . $row->id . ">" . translate("View event") . "</a>\n";
            echo " - <a href=cal_event.php?op=edit&id=" . $row->id . ">" . translate("Edit event") . "</a>\n";
            echo " - <a href=cal_event.php?op=delev&id=" . $row->id . ">" . translate("Delete event") . "</a>\n";
            if ($row->approved == '0') {
                echo " - <a href=calendar.php?op=approve&id=" . $row->id . ">" . translate("Approve") . "</a>\n";
            }
            echo "</div>\n";
            echo "<hr/>";
            if ($row->approved == '0') {
                echo "</td></tr></table>\n";
            }
        }
        $fd = date("Y-m-d", mktime(0, 0, 0, $fdm, $fdd + 1, $fdy));
        echo "</td></tr></table>";
    }
    // display form functions
    echo "<table border=0 width=100%><tr><td align=left width=50%>";
    echo "<table width=100 cellspacing=0 cellpadding=2 align=left class=txtbox><tr><td bgcolor='{$unapprovedclr}' align=center><div class=normalfont>" . translate("Unapproved events") . "</div></td></tr></table>\n</td>";
    echo "<td align=right valign=middle width=50%>";
    echo "<form><div class=menufont>\n";
    echo "<b>" . translate("Go to week") . " </b>";
    // get week number
    echo "<select name=goweek onchange=\"javascript:gotoweek(this);\">\n";
    for ($i = 1; $i < 53; $i++) {
        echo "\t<option value=" . $i;
        if ($weeknumber == $i) {
            echo " selected ";
        }
        echo ">" . $i . "\n";
    }
    if (showWeek53($year) > 52) {
        for ($i = 53; $i <= showWeek53($year); $i++) {
            echo "\t<option value=" . $i;
            if ($weeknumber == $i) {
                echo " selected ";
            }
            echo ">" . $i . "\n";
        }
    }
    echo "</select>\n";
    echo "<b>" . translate("or month") . " </b>";
    // get months
    echo "<select name=gomonth onchange=\"javascript:gotomonth(this);\">\n";
    for ($i = 1; $i < 13; $i++) {
        echo "\t<option value=" . $i;
        if ($ldm == $i) {
            echo " selected ";
        }
        echo ">" . ucfirst($mth[$i]) . "\n";
    }
    echo "</select>&nbsp;&nbsp;<br/>\n";
    // Display the users to be selected
    echo "<b>" . translate("View events of user") . ": </b> &nbsp;";
    // get users
    $uquery = "select username,user_id from " . $USER_TB;
    $uresult = mysql_query($uquery);
    echo "<select name=huser onchange=\"Javascript:seeuser(this);\">\n";
    echo "\t<option value='-'";
    if ($uname == "-" || $uname == "") {
        echo " selected ";
    }
    echo ">--\n";
    while ($urow = mysql_fetch_object($uresult)) {
        echo "\t<option value='{$urow->username}'";
        if ($uname == "{$urow->username}") {
            echo " selected ";
        }
        echo ">" . $urow->username . "\n";
    }
    echo "</select>&nbsp;&nbsp;\n";
    echo "</div></form>";
    echo "</td></tr></table>";
}
Exemple #5
0
    case "retrieve":
        $player_id = urlvar("player_id");
        echo json_encode(new Player($player_id));
        break;
    case "new":
        $player_name = urlvar("player_name");
        $db->add_player($player_name);
        break;
    case "rename":
        $player_id = urlvar("player_id");
        $player_name = urlvar("player_name");
        $db->change_player_name($player_id, $player_name);
        break;
    case "delete":
        $player_id = urlvar("player_id");
        $db->remove_player($player_id);
        break;
    case "addchamp":
        $player_id = urlvar("player_id");
        $champ_id = urlvar("champ_id");
        $role = urlvar("role");
        $db->add_player_champion($player_id, $role, $champ_id);
        break;
    case "removechamp":
        $player_id = urlvar("player_id");
        $champ_id = urlvar("champ_id");
        $role = urlvar("role");
        $db->remove_player_champion($player_id, $role, $champ_id);
        break;
}
$db->disconnect();
<?php

include_once '../common.php';
include_once '../objects/db.php';
include_once '../objects/comp_type_object.php';
$method = urlvar("method");
$db = new DB();
$db->connect();
switch ($method) {
    case "retrieveall":
        $comp_ids = $db->get_comp_type_ids();
        $comp_types = array();
        foreach ($comp_ids as $comp_id) {
            $comp_types[] = new CompType($comp_id);
        }
        echo json_encode($comp_types);
        break;
    case "retrieve":
        $comp_id = urlvar("comp_id");
        echo json_encode(new CompType($comp_id));
        break;
    case "new":
        $comp_type = urlvar("comp_type");
        $db->add_comp_type($comp_type);
        break;
    case "delete":
        $comp_id = urlvar("comp_id");
        $db->remove_comp_type($comp_id);
        break;
}
$db->disconnect();