function CreateOp($FCID, $OPName)
{
global $mysqli;
$query = " Insert into LiveOps (LiveOp_FC_ID,LiveOp_Start,LiveOp_Name,LiveOp_Active) Values(" . $FCID . ",Now(),'" . $OPName . "',1);";
echo $query;
mysqli_query($mysqli, $query);
$NewOpID = mysqli_insert_id($mysqli);
JoinOp($NewOpID, $FCID);
mysqli_close($mysqli);
header("Location: ./TDSinLiveOpFC.php");
}
$OPArray[] = $row;
}
$result->free();
echo "<select name = 'selOp'>";
foreach ($OPArray as $oplist) {
echo "<option value=" . $oplist['LiveOp_ID'];
echo ">" . $oplist['LiveOp_Name'];
echo "</option>";
}
echo "</select>";
echo "</br>";
echo "<a href = './TDSinCreateLiveOp.php'><input type = 'button' value = 'Create New Op' /></a>";
echo "<input type = 'submit' value = 'Join' />";
if (isset($_POST['selOp'])) {
//code to join op
JoinOp($_POST['selOp'], $_SESSION['userID']);
header('Location: ./TDSinLiveOp.php');
}
}
} else {
echo "<p> You are not logged in as anyone, thus you cannot see this page </p>";
}
?>
</fieldset>
</form>
</div>
<!-- InstanceEndEditable -->
<!-- Add Footer -->
<?php
include 'footer.html';
