function finishUnfinishedPersons () {
#----------------------------------------------------------------------
#--- Process all cases.
while( true ){
#--- Get old name and country from the case.
$caseNr++;
$oldNameAndCountry = getRawParamThisShouldBeAnException( "oldNameAndCountry$caseNr" );
#--- If empty, we've reach the end of the list and can stop.
if( ! $oldNameAndCountry )
break;
#--- Separate old name and country, and get the action.
list( $oldName, $oldCountry ) = explode( '|', $oldNameAndCountry );
$action = getRawParamThisShouldBeAnException( "action$caseNr" );
#--- If no action or 'skip' chosen, skip it.
if( ! $action || $action == 'skip' )
continue;
#--- If 'new' chosen, treat the person as new.
if( $action == 'new' ){
#--- First get the new name, country, and semi-id.
$newName = getRawParamThisShouldBeAnException( "name$caseNr" );
$newCountry = getRawParamThisShouldBeAnException( "country$caseNr" );
$newSemiId = getRawParamThisShouldBeAnException( "semiId$caseNr" );
#--- Complete the id.
$newId = completeId( $newSemiId );
#--- Insert the new person into the Persons table.
insertPerson( $oldName, $oldCountry, $newName, $newCountry, $newId );
#--- Adapt the Results table entries.
adaptResults( $oldName, $oldCountry, $newName, $newCountry, $newId );
}
#--- Otherwise adopt another personality.
else {
#--- Scream if error.
if( count( explode( '|', $action )) != 3 ){
showErrorMessage( "invalid action '$action'" );
continue;
}
#--- Get the data from the other person.
list( $newName, $newCountry, $newId ) = explode( '|', $action );
#--- Adapt the Results table entries.
adaptResults( $oldName, $oldCountry, $newName, $newCountry, $newId );
}
#--- Separator after each person.
echo "<hr>";
}
}
{
// Gets the group received from the registration factory.
$group = utf8_decode($_REQUEST['group']);
$query = "SELECT capacity FROM groups WHERE name='{$group}'";
$result = $conn->query($query);
$result = mysqli_fetch_row($result);
echo $result[0];
}
// Try to make the connection with the database.
$connection = new Connection();
$conn = $connection->createConnection();
if ($conn) {
// Get the action from the registration factory.
$action = $_REQUEST['action'];
if ($action === 'insert') {
insertPerson($conn);
} else {
if ($action === 'validateId') {
validateId($conn);
} else {
if ($action === 'validateEmail') {
validateEmail($conn);
} else {
if ($action === 'validateGroup') {
validateGroup($conn);
} else {
if ($action === 'decrement') {
decrementCapacity($conn);
} else {
if ($action === 'capacity') {
isThereCapacity($conn);
