exit;
}
if ($_POST['btnSubmit'] || $_POST['particularButton']) {
extract($_POST);
}
if ($_POST['btnSubmit']) {
$errMsg = scriptCheckIfNull('DB Connection', $DB_Connection_ID, 'Table Name', $Table_Name);
for ($a = 0; $a < $particularsCount; $a++) {
$b = $a + 1;
$errMsg .= scriptCheckIfNull("Table page #{$b}", $Page_ID[$a]);
$Path_Filename[$a] = trim($Folder) . '/' . trim(basename($Filename[$a]));
}
if ($errMsg == "") {
$select = "SELECT `Table_Name` FROM `table` WHERE `Table_Name`='{$Table_Name}' AND `Table_Name`!='{$Orig_Table_Name}' AND Project_ID='{$_SESSION['Project_ID']}'";
$error = "The table name '{$Table_Name}' already exists. Please choose a new name. <br>";
$errMsg = scriptCheckIfUnique($select, $error);
if ($errMsg == "") {
//Add additional info needed before passing $_POST
$_POST['Project_ID'] = $_SESSION['Project_ID'];
$_POST['Path_Filename'] = $Path_Filename;
queryCreateTable($_POST);
header("location: ../success.php?success_tag=CreateTables");
exit;
}
}
}
}
init_var($particularsCount);
if ($particularsCount <= 0) {
$numParticulars = 6;
}
require '../Core/SCV2_Core.php';
init_SCV2();
if (xsrf_guard()) {
init_var($Parent_Field_ID);
init_var($_POST['btnCancel']);
init_var($_POST['btnSubmit']);
extract($_POST);
if ($_POST['btnCancel']) {
header("location: ListView_TableRelations.php");
exit;
}
if ($_POST['btnSubmit']) {
$errMsg = scriptCheckIfNull('Relation', $Relation, 'Parent', $Parent_Field_ID, 'Child', $Child_Field_ID);
//Check for duplicate
$errMsg .= scriptCheckIfUnique("SELECT Relation_ID\n FROM table_relations\n WHERE\n `Relation` = '" . $Relation . "' AND\n `Parent_Field_ID` = '" . $Parent_Field_ID . "' AND\n `Child_Field_ID` = '" . $Child_Field_ID . "'", "Cannot add relationship - this relationship already exists!<br />");
if ($Relation == "ONE-to-ONE") {
$errMsg .= scriptCheckIfNull('Child Field Subtext', $Child_Field_Subtext);
if ($errMsg == '') {
//Check if chosen fields actually exist in parent
//--Get Table ID
$Table_ID = '';
$db_handle = connect_DB();
$db_handle->real_query("SELECT Table_ID\n FROM `table_fields`\n WHERE Field_ID = '{$Parent_Field_ID}'");
if ($result = $db_handle->use_result()) {
while ($row = $result->fetch_assoc()) {
$Table_ID = $row['Table_ID'];
}
$result->close();
}
//--Get the fields of this table