function addTeam($team, $p1, $p2 = "", $p3 = "")
{
$sql = "INSERT INTO mad_team(team, register_date) VALUES(:team, NOW())";
$parms = array(':team', $team);
$result = DatabaseHandler::Execute($sql, $parms);
$teamid = getTeamId($team);
if ($p1) {
$sql = "INSERT INTO mad_registrations(user_id, team_id) VALUES(:p1, :teamid)";
$parms = array(':p1' => $p1, ':teamid' => $teamid);
$result = DatabaseHandler::Execute($sql, $parms);
}
if ($p2) {
$sql = "INSERT INTO mad_registrations(user_id, team_id) VALUES(:p2, :teamid)";
$parms = array(':p2' => $p2, ':teamid' => $teamid);
$result = DatabaseHandler::Execute($sql, $parms);
}
if ($p3) {
$sql = "INSERT INTO mad_registrations(user_id, team_id) VALUES(:p3, :teamid)";
$parms = array(':p3' => $p3, ':teamid' => $teamid);
$result = DatabaseHandler::Execute($sql, $parms);
}
return 1;
}
<?php
include_once 'interface.php';
if(isset($_POST['eventid'])) {
echo json_encode(getTeamId($_POST['eventid']));
}
if(isset($_POST['tatid'])){
echo json_encode(partEventList($_POST['tatid']));
}
if(isset($_POST['rgeventid']) &&
isset($_POST['rgteamid']) &&
isset($_POST['rgcaptainid']) &&
isset($_POST['rgpart1']) &&
isset($_POST['rgpart2']) &&
isset($_POST['rgpart3']) &&
isset($_POST['rgpart4']) &&
isset($_POST['rgpart5']) &&
isset($_POST['rgpart6'])){
updateTeam($_POST['rgeventid'],
$_POST['rgteamid'],
$_POST['rgcaptainid'],
$_POST['rgpart1'],
$_POST['rgpart2'],
$_POST['rgpart3'],
$_POST['rgpart4'],
$_POST['rgpart5'],
$_POST['rgpart6']);
}
