$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();
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 . " <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 " <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> ";
} else {
echo " ";
}
$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> <br/>";
} else {
echo " ";
}
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 " <" . $row->user . ">";
}
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 " <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> <br/>\n";
// Display the users to be selected
echo "<b>" . translate("View events of user") . ": </b> ";
// 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> \n";
echo "</div></form>";
echo "</td>";
echo "<td align=right valign=middle width=33%>";
echo "</td></tr></table>";
}
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 " <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> ";
}
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> ";
$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> ";
$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> <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 " <" . $row->user . ">";
}
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> <br/>\n";
// Display the users to be selected
echo "<b>" . translate("View events of user") . ": </b> ";
// 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> \n";
echo "</div></form>";
echo "</td></tr></table>";
}
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();