}
}
}
drawHeader();
drawPageTitle('Create Predefined List', $errMsg);
?>
<div class="container_mid">
<fieldset class="top">
New List
</fieldset>
<fieldset class="middle">
<table class="input_form">
<?php
drawTextField('List Name', 'List_Name');
drawTextField('Remarks', '', '', 'Textarea');
drawMultiFieldStart('List Items');
if ($numParticulars < 1) {
$numParticulars = 1;
}
for ($a = 0; $a < $numParticulars; $a++) {
init_var($List_Item[$a]);
echo "<li style='margin: 5'><input type='text' name='List_Item[{$a}]' value='{$List_Item[$a]}'>";
}
drawMultiFieldEnd();
?>
</table>
</fieldset>
<fieldset class="bottom">
<?php
drawSubmitCancel();
echo $_SESSION['Project_ID'];
?>
">
<input type="hidden" name="Base_Directory" value="<?php
echo $Base_Directory;
?>
">
<div class="container_mid_huge">
<fieldset class="top">
Delete Project Data and All Files
</fieldset>
<fieldset class="middle">
<table class="input_form">
<?php
drawTextField('Project Name', 'Project_Name', TRUE);
drawTextField('Client Name', 'Client_Name', TRUE);
drawTextField('Base Directory', 'Base_Directory', TRUE);
drawTextField('Database Connection', 'DB_Connection_Name', TRUE);
drawTextField('Description', 'Project_Description', TRUE, 'Textarea');
?>
</table>
</fieldset>
<fieldset class="bottom">
<?php
drawDeleteCancel();
?>
</fieldset>
</div>
<?php
drawFooter();
drawPageTitle('Delete Database Connection', 'Are you sure you want to delete this Database Connection?');
?>
<input type="hidden" name="DB_Connection_ID" value="<?php
echo $DB_Connection_ID;
?>
">
<div class="container_mid">
<fieldset class="top">
Delete Database Connection
</fieldset>
<fieldset class="middle">
<table class="input_form">
<?php
drawTextField('DB Connection Name', 'DB_Connection_Name', TRUE);
drawTextField('Hostname', '', TRUE);
drawTextField('Database', '', TRUE);
drawTextField('Username', '', TRUE);
drawTextField('Password', '', TRUE);
drawTextField('Use as Default', 'Default_Connection', TRUE);
?>
</table>
</fieldset>
<fieldset class="bottom">
<?php
drawDeleteCancel();
?>
</fieldset>
</div>
<?php
drawFooter();
}
drawHeader();
drawPageTitle('Define Relationship', $errMsg);
?>
<div class="container_mid_huge">
<fieldset class="top">
New Relationship
</fieldset>
<fieldset class="middle">
<table class="input_form">
<?php
drawSelectField('drawTableRelationType', 'Relation', 'Relation', TRUE, 'id="relation_field" onChange="toggleChildFieldSubtext()"');
drawSelectField('drawFieldsParent', 'Parent', 'Parent_Field_ID');
drawSelectField('drawFields', 'Child', 'Child_Field_ID');
drawTextField('Child Field Subtext', 'Child_Field_Subtext', FALSE, 'text', TRUE, FALSE, 0, 'size="50"');
?>
</table>
</fieldset>
<fieldset class="bottom">
<?php
drawSubmitCancel();
?>
</fieldset>
<?php
drawSubtextFields($Parent_Field_ID);
?>
</div>
<script>
function toggleChildFieldSubtext()
{
if ($result = $mysqli->use_result()) {
$data = $result->fetch_assoc();
extract($data);
} else {
die($mysqli->error);
}
} elseif (xsrf_guard()) {
init_var($_POST['btnCancel']);
init_var($_POST['btnSubmit']);
if ($_POST['btnCancel']) {
header('location: ListView_Users.php');
exit;
} elseif ($_POST['btnSubmit']) {
queryDeleteUser($_POST);
header("location: /SCV2/success.php?success_tag=DeleteUsers");
exit;
}
}
drawHeader($errMsg);
drawPageTitle('Detail View: User');
?>
<input type="hidden" name="Username" value="<?php
echo $Username;
?>
">
<?php
drawFieldSetStart();
drawTextField('Username', 'Username', TRUE);
drawDeleteCancel();
drawFieldSetEnd();
drawFooter();
}
}
?>
<div class="container_mid">
<fieldset class="top">
New Database Connection
</fieldset>
<fieldset class="middle">
<table class="input_form">
<?php
drawTextField('DB Connection Name', 'DB_Connection_Name');
drawTextField('Hostname');
drawTextField('Database');
drawTextField('Username');
drawTextField('Password', '', '', 'password');
drawTextField('Confirm Password', 'Confirm_Password', '', 'password');
$arrayItems = array('Items' => array('Yes', 'No'), 'Values' => array('Yes', 'No'), 'PerLine' => FALSE);
drawRadioField($arrayItems, 'Use as Default?', 'Default_Connection');
?>
</table>
</fieldset>
<fieldset class="bottom">
<?php
drawSubmitCancel();
?>
</fieldset>
</div>
<?php
drawFooter();
header('location: ListView_Pages.php');
exit;
}
}
drawHeader();
drawPageTitle('Detail View: Page', $errMsg);
?>
<div class="container_mid">
<fieldset class="top">
View Page Generator: <?php
echo $Page_Name;
?>
</fieldset>
<fieldset class="middle">
<table class="input_form">
<?php
drawTextField('Page Name', 'Page_Name', TRUE);
drawTextField('Generator', '', TRUE);
drawTextField('Description', '', TRUE);
?>
</table>
</fieldset>
<fieldset class="bottom">
<?php
drawBackButton();
?>
</fieldset>
</div>
<?php
drawFooter();
drawTextField('Control Type', 'Control_Type', TRUE);
drawTextField('Label', '', TRUE);
drawTextField('Show in list view', 'In_Listview', TRUE);
echo '<tr><td colspan=2 align=center><hr> Secondary Validation Routines: <br><table align=center><tr><td align=left><ol>';
if ($result = $mysqli_validation_routines->store_result()) {
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
echo '<li>' . $row['Validation_Routine'];
}
} else {
echo 'NONE';
}
}
echo '</td></tr></table></ol><hr></td></tr>';
drawTextField('Booklist Generator', 'Book_List_Generator', TRUE);
drawTextField('Predefined List', 'List_Name', TRUE);
echo '<tr><td colspan=2 align=center><hr> List SELECT Parameters: <br><table align=center><tr><td align=left><ol>';
if ($result = $mysqli_select_parameters->store_result()) {
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
echo '<li>' . $row['Field_Name'] . ' - ' . $row['Display'];
}
} else {
echo 'NONE';
}
}
echo '</td></tr></table></ol><hr></td></tr>';
echo '<tr><td colspan=2 align=center><hr> List WHERE Parameters: <br><table align=center><tr><td align=left><ol>';
if ($result = $mysqli_where_parameters->store_result()) {
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
<table width="100%" border="1" class="listView">
<?php
echo '<tr><td colspan="2">
<input type=submit name=BACK value=BACK class=button1>
<input type=button name=CHECK value="CHECK ALL" class=button1 onClick=\'checkAll();\'>
<input type=button name=UNCHECK value="UNCHECK ALL" class=button1 onClick=\'uncheckAll();\'>
</td></tr>';
echo '<tr class="listRowHead"><td> Table </td><td> Folder / Subdirectory </td></tr>';
for ($a = 0; $a < count($tables_found); $a++) {
if ($a % 2 == 0) {
$class = 'listRowEven';
} else {
$class = 'listRowOdd';
}
echo "<tr class=\"{$class}\">\n <td>\n <label style=\"display: block;\" for='checkfield[{$a}]'>\n <input type=\"checkbox\" ID='checkfield[{$a}]' name='checkbox[{$a}]' value='{$tables_found[$a]}' checked>{$tables_found[$a]}\n </label>\n </td>\n <td>";
drawTextField(' ', "folder[{$a}]", FALSE, 'text', FALSE);
echo '</td></tr>' . "\n";
}
?>
</table>
</fieldset>
<fieldset class="bottom">
<?php
drawSubmitCancel();
?>
</fieldset>
</fieldset>
<br>
</div>
<?php
exit;
}
}
drawHeader();
drawPageTitle('Delete Relationship', 'Are you sure you wish to delete this relationship?');
echo '<input type="hidden" name="Relation_ID" value="' . $Relation_ID . '">';
?>
<div class="container_mid_huge">
<fieldset class="top">
Delete Relationship
</fieldset>
<fieldset class="middle">
<table class="input_form">
<?php
drawTextField('Label', '', TRUE);
drawTextField('Relation', '', TRUE);
drawTextField('Parent', 'Parent', TRUE);
drawTextField('Child', 'Child', TRUE);
drawTextField('Child Field Subtext Fields', 'Child_Field_Subtext', TRUE);
?>
</table>
</fieldset>
<fieldset class="bottom">
<?php
drawDeleteCancel();
?>
</fieldset>
</div>
<?php
drawFooter();
?>
<div class="container_mid_huge2">
<fieldset class="top">
New Table Field
</fieldset>
<fieldset class="middle">
<table class="inputForm">
<?php
drawSelectField('drawTable', 'Table', 'Table_ID');
drawTextField('Field Name', 'Field_Name');
drawSelectField('drawDataType', 'Data Type', 'Data_Type');
drawSelectField('drawNullable', 'Nullable', 'Nullable');
drawTextField('Length');
drawSelectField('drawAttribute', 'Attribute');
drawSelectField('drawControlType', 'Control Type', 'Control_Type');
drawTextField('Label');
$arrayItems = array('Items' => array('Yes', 'No'), 'Values' => array('yes', 'no'), 'PerLine' => FALSE);
drawRadioField($arrayItems, 'Show in list view?', 'In_Listview');
$arrayMultiField = array('FieldLabels' => array('VALIDATION ROUTINE'), 'FieldControls' => array('drawValidationRoutine'), 'FieldVariables' => array('Validation_Routine'));
drawMultiFieldAuto('<br>Secondary validation routines for this field<br>', $arrayMultiField);
?>
<tr><td colspan="2">Additional Options<br><br></td></tr>
<tr><td colspan="2">
<ol class="normal">
<li> If Control Type is 'Special Textbox', choose a Book List Generator:<br>
<?php
drawSelectField('drawBookListGenerator', 'Book List Generator: ', 'Book_List_Generator', FALSE);
?>
<br><br>
<li> If Control Type is "Drop-down List", choose the list source type: <br>
require '../Core/SCV2_Core.php';
init_SCV2();
if (xsrf_guard()) {
init_var($_POST['btnCancel']);
init_var($_POST['btnSubmit']);
if ($_POST['btnCancel']) {
header("location: ListView_Users.php");
exit;
}
if ($_POST['btnSubmit']) {
extract($_POST);
$errMsg = scriptCheckIfNull('Username', $Username, 'Password', $Password);
if ($errMsg == "") {
if ($Password == $Password_2) {
queryCreateUser($_POST);
header("location: /SCV2/success.php?success_tag=CreateUsers");
} else {
$errMsg = "Your passwords didn't match, please retype them.";
}
}
}
}
drawHeader($errMsg);
drawPageTitle('Create Users');
drawFieldSetStart();
drawTextField('Username', 'Username');
drawTextField('Password', 'Password', FALSE, 'password');
drawTextField('Confirm password', 'Password_2', FALSE, 'password');
drawSubmitCancel();
drawFieldSetEnd();
drawFooter();
}
}
}
}
drawHeader();
drawPageTitle('Export Project', $errMsg);
if ($export_status == 'success') {
displayMessage('Success! The SQL file can be found in the Exports directory (cobalt/Exports).');
} elseif ($export_status == 'first run') {
displayTip('Export Project creates an SQL file that you can use to copy or transfer your project to another machine. ' . '<br>You can also use this feature to back up this project to a separate location');
}
?>
<div class="container_mid_large">
<fieldset class="top">
Export Project as SQL File
</fieldset>
<fieldset class="middle">
<table class="input_form" width="92%">
<?php
drawTextField('Filename (SQL file)', 'Export_Name', FALSE, 'text', TRUE, FALSE, 0, 'size="40"');
?>
</table>
</fieldset>
<fieldset class="bottom">
<?php
drawSubmitCancel();
?>
</fieldset>
</div>
<?php
drawFooter();
drawSelectField('drawDBConnection', 'DB Connection', 'DB_Connection_ID');
drawTextField('Table Name', 'Table_Name');
drawTextField('Folder / Subdirectory', 'Folder');
drawTextField('Remarks', '', '', 'Textarea');
drawMultiFieldStart('Table Pages');
if ($numParticulars < 1) {
$numParticulars = 1;
}
echo "<table>\n <tr>\n <td> </td>\n <td>Page</td>\n <td>Filename</td>\n </tr>";
for ($a = 0; $a < $numParticulars; $a++) {
echo "<tr><td>" . ($a + 1) . "</td><td>";
init_var($Page_ID[$a]);
drawTablePage($Page_ID[$a], TRUE);
echo " ";
echo "</td><td>";
drawTextField('', 'Filename', FALSE, '', FALSE, TRUE, $a);
echo " ";
echo "</td></tr>";
}
echo "</table>";
drawMultiFieldEnd();
?>
</table>
</fieldset>
<fieldset class="bottom">
<?php
drawSubmitCancel();
?>
</fieldset>
</div>
<?php
queryCreatePage($_POST);
header("location: ../success.php?success_tag=CreatePages");
exit;
}
}
}
drawHeader();
drawPageTitle('Create Page', $errMsg);
?>
<div class="container_mid">
<fieldset class="top">
New Page Generator
</fieldset>
<fieldset class="middle">
<table class="input_form">
<?php
drawTextField('Page Name', 'Page_Name');
drawTextField('Generator');
drawTextField('Description', '', '', 'Textarea');
?>
</table>
</fieldset>
<fieldset class="bottom">
<?php
drawSubmitCancel();
?>
</fieldset>
</div>
<?php
drawFooter();
<?php
require '../Core/SCV2_Core.php';
init_SCV2();
if (isset($_GET['Username'])) {
$Username = rawurldecode($_GET['Username']);
$mysqli = connect_DB();
$mysqli->real_query("SELECT `Username`,`Password` \n FROM `user` \n WHERE `Username`='{$Username}'");
if ($result = $mysqli->use_result()) {
$data = $result->fetch_assoc();
extract($data);
} else {
die($mysqli->error);
}
} elseif (xsrf_guard()) {
init_var($_POST['btnCancel']);
if ($_POST['btnCancel']) {
header('location: ListView_Users.php');
exit;
}
}
drawHeader($errMsg);
drawPageTitle('Detail View: Users');
drawFieldSetStart();
drawTextField('Username', 'Username', TRUE);
drawTextField('Password', 'Password', TRUE);
drawBackButton();
drawFieldSetEnd();
drawFooter();
echo $Orig_DB_Connection_Name;
?>
">
<div class="container_mid">
<fieldset class="top">
Modify Database Connection
</fieldset>
<fieldset class="middle">
<table class="input_form">
<?php
drawTextField('DB Connection Name', 'DB_Connection_Name');
drawTextField('Hostname');
drawTextField('Database');
drawTextField('Username');
drawTextField('Password');
$arrayItems = array('Items' => array('Yes', 'No'), 'Values' => array('Yes', 'No'), 'PerLine' => FALSE);
drawRadioField($arrayItems, 'Use as Default?', 'Default_Connection');
?>
</table>
</fieldset>
<fieldset class="bottom">
<?php
drawSubmitCancel();
?>
</fieldset>
</div>
<?php
drawFooter();
}
drawHeader();
drawPageTitle('Detail View: Predefined Lists', $errMsg);
?>
<div class="container_mid">
<fieldset class="top">
View List: <?php
echo $List_Name;
?>
</fieldset>
<fieldset class="middle">
<table class="input_form">
<?php
drawTextField('List Name', 'List_Name', TRUE);
drawTextField('Remarks', '', TRUE);
echo '<tr><td align=right> <br>List items: </td><td></td></tr>
<tr><td></td><td><ol>';
if ($result = $mysqli->store_result()) {
while ($row = $result->fetch_assoc()) {
echo '<li>' . $row['List_Item'];
}
}
echo '</ol></td></tr>';
?>
</table>
</fieldset>
<fieldset class="bottom">
<?php
drawBackButton();
?>
drawHeader();
drawPageTitle('Detail View: Table', $errMsg);
?>
<div class="container_mid_large">
<fieldset class="top">
View Table: <?php
echo $Table_Name;
?>
</fieldset>
<fieldset class="middle">
<table class="input_form">
<?php
drawTextField('Table Name', 'Table_Name', TRUE);
drawTextField('DB Connection', 'DB_Connection_Name', TRUE);
drawTextField('Remarks', '', TRUE, 'textarea');
echo '<tr><td colspan="2"><hr>Table pages: <br>' . '<table class="listView" border=1><tr class="listRowHead"> <td>#</td> <td>Page</td> <td>Path & Filename</td></tr>';
if ($result = $mysqli->store_result()) {
$a = 1;
while ($row = $result->fetch_assoc()) {
echo '<tr><td>' . $a . '</td>' . '<td>' . $row['Page_Name'] . '</td>' . '<td>' . $row['Path_Filename'] . '</td></tr>';
$a++;
}
}
echo '</table></ol></td></tr>';
?>
</table>
</fieldset>
<fieldset class="bottom">
<?php
drawBackButton();
