die($mysqli->error);
}
} elseif (xsrf_guard()) {
init_var($_POST['btnCancel']);
init_var($_POST['btnSubmit']);
if ($_POST['btnCancel']) {
header('location: ListView_Pages.php');
exit;
} elseif ($_POST['btnSubmit']) {
queryDeletePage($_POST);
header("location: ../success.php?success_tag=DeletePages");
exit;
}
}
drawHeader();
drawPageTitle('Delete Page', $errMsg);
?>
<input type="hidden" name="Page_ID" value="<?php
echo $Page_ID;
?>
">
<div class="container_mid">
<fieldset class="top">
Delete Page Generator
</fieldset>
<fieldset class="middle">
<table class="input_form">
<?php
drawTextField('Page Name', 'Page_Name', TRUE);
drawTextField('Generator', '', TRUE);
<?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();
extract($data);
} else {
die($mysqli->error);
}
$mysqli->close();
$mysqli = connect_DB();
$mysqli->real_query("SELECT `List_Item` \n FROM `table_fields_predefined_list_items` \n WHERE `List_ID`='{$List_ID}' \n ORDER BY `Number`");
} elseif (xsrf_guard()) {
init_var($_POST['btnCancel']);
if ($_POST['btnCancel']) {
header('location: ListView_PredefinedLists.php');
exit;
}
}
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>';
$errMsg .= 'Invalid child field subtext: ' . $subtext . '<br/>';
}
}
}
} else {
$Child_Field_Subtext = '';
}
if ($errMsg == "") {
queryDefineTableRelation($_POST);
header("location: ../success.php?success_tag=DefineTableRelations");
exit;
}
}
}
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>
init_var($_POST['btnSubmit']);
if ($_POST['btnCancel']) {
header("location: " . HOME_PAGE);
exit;
} elseif ($_POST['btnSubmit']) {
//If base directory is composed of nested subdirectories, we only need the very first folder.
$subdirectories = explode('/', $_POST['Base_Directory']);
$base_directory = $subdirectories[0];
if (is_dir("../Generator/Projects/" . $base_directory)) {
obliterate_dir("../Generator/Projects/" . $base_directory);
}
queryDeleteProject($_POST, $mysqli);
}
}
drawHeader();
drawPageTitle('DESTROY PROJECT', 'YOU ARE ABOUT TO DESTROY AN ENTIRE PROJECT!<br>Are you sure you wish to permanently delete this project and all of its contents?');
?>
<input type=hidden name=Project_ID value="<?php
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">
}
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 == "") {
$_POST['Path_Filename'] = $Path_Filename;
queryUpdateTable($_POST);
header("location: ../success.php?success_tag=EditTables");
exit;
}
}
}
}
drawHeader();
drawPageTitle('Edit Table', $errMsg);
echo '<input type="hidden" name="Table_ID" value="' . $Table_ID . '">';
echo '<input type="hidden" name="Orig_Table_Name" value="' . $Orig_Table_Name . '">';
?>
<div class="container_mid">
<fieldset class="top">
Modify Table
</fieldset>
<fieldset class="middle">
<table class="input_form">
<?php
drawSelectField('drawDBConnection', 'DB Connection', 'DB_Connection_ID');
drawTextField('Table Name', 'Table_Name');
drawTextField('Folder / Subdirectory', 'Folder');
drawTextField('Remarks', '', '', 'Textarea');
$mysqli = connect_DB();
$mysqli->real_query("SELECT `List_Item` \n FROM `table_fields_predefined_list_items` \n WHERE `List_ID`='{$List_ID}' \n ORDER BY `Number`");
} elseif (xsrf_guard()) {
init_var($_POST['btnCancel']);
init_var($_POST['btnSubmit']);
if ($_POST['btnCancel']) {
header('location: ListView_PredefinedLists.php');
exit;
} elseif ($_POST['btnSubmit']) {
queryDeletePredefinedList($_POST);
header("location: ../success.php?success_tag=DeletePredefinedLists");
exit;
}
}
drawHeader();
drawPageTitle('Delete Predefined List', 'Are you sure you wish to delete this predefined list?');
echo '<input type="hidden" name="List_ID" value="' . $List_ID . '">';
?>
<div class="container_mid">
<fieldset class="top">
Delete List
</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()) {
}
$mysqli->close();
} elseif (xsrf_guard()) {
init_var($_POST['btnCancel']);
init_var($_POST['btnSubmit']);
if ($_POST['btnCancel']) {
header('location: ListView_TableRelations.php');
exit;
} elseif ($_POST['btnSubmit']) {
queryDeleteTableRelation($_POST);
header("location: ../success.php?success_tag=DeleteTableRelations");
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);
$mysqli->real_query("SELECT `Page_Name`, `Generator`, `Description` \n FROM `page` \n WHERE `Page_ID`='{$Page_ID}'");
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_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);
?>
<?php
require '../Core/SCV2_Core.php';
init_SCV2();
if (xsrf_guard()) {
if ($_POST['btnCancel']) {
header("location: " . HOME_PAGE);
exit;
}
}
$mysqli = connect_DB();
$Project_ID = $mysqli->real_escape_string($_SESSION['Project_ID']);
$mysqli->real_query("SELECT List_ID, List_Name, Remarks FROM table_fields_predefined_list WHERE Project_ID='{$Project_ID}' ORDER BY List_Name");
drawHeader();
drawPageTitle('List View: Predefined Lists', $errMsg);
?>
<fieldset class="container">
<?php
drawButton('CANCEL');
?>
<a class='blue' href='CreatePredefinedLists.php'> Create New List </a>
<table border=1 width=100% class="listView">
<tr class="listRowHead">
<td width="140">Operations</td>
<td>List Name</td>
<td>Remarks</td>
</tr>
<?php
if ($result = $mysqli->use_result()) {
$a = 0;
$class = '';
<?php
require 'Core/SCV2_Core.php';
init_SCV2();
if (!isset($_SESSION['Project_ID'])) {
$_SESSION['Project_ID'] = 'TEMP';
}
if (!isset($_SESSION['Project_Name'])) {
$_SESSION['Project_Name'] = '(NO PROJECT)';
}
drawHeader(FALSE);
drawPageTitle("JV Roig", "Cobalt Creator", 'message');
if ($_SESSION['Project_ID'] == 'TEMP') {
unset($_SESSION['Project_ID']);
}
if ($_SESSION['Project_Name'] == '(NO PROJECT)') {
unset($_SESSION['Project_Name']);
}
?>
<table border=0 cellpadding=2 cellspacing=2>
<tr>
<td valign=top>
<fieldset class="container">
<span class="graytext">
Jesus Vicente "JV" Roig is the first ever <i> summa cum laude </i> of Asia Pacific College. During his May 2006 graduation JV
also received the <i> Internship Award </i> and <i>Outstanding Project Award</i> for his internship stint at Don Bosco College, Canlubang
which resulted in a Linux / Apache / MySQL / PHP-based ERP system for schools which he christened "SYNERGY".
<br><br>
JV likewise graduated top of his class in his post-grad studies (Master in Information Management), also at Asia Pacific College. Some of his friends
jokingly refer to him now as <i>"Double"</i> - short for <i>"Double summa cum laude"</i>.
function createPage($name, $type, $title, $tab_title, $contents, $image = null)
{
global $output_pages, $tempdir;
$page = $output_pages->createElement('draw:page');
$page->setAttribute("draw:name", $name);
$page->setAttribute("draw:style-name", "dp1");
$page->setAttribute("draw:master-page-name", $type);
$page->setAttribute("presentation:presentation-page-layout-name", "AL2T1");
$page->setAttribute("presentation:use-footer-name", "ftr1");
$page->setAttribute("presentation:use-date-time-name", "dtd1");
//Title
$page->appendChild(drawPageTitle($title));
//Tab title
$page->appendChild(drawTabTitle($tab_title));
//Image positioning
if ($image) {
//Default dimensions and positioning for SVG images
$x = 0.15;
$y = 2.5;
$width = 26.457;
$height = 15.874;
if (substr($image, -3) == "png") {
$ratio = 0.023291;
//(ratio px <=> cm)
//Get image dimensions
$size = getimagesize($tempdir . "/" . $image);
$width = $size[0] * $ratio;
$height = $size[1] * $ratio;
$y = 3.5;
$x = (28 - $size[0] * $ratio) / 2;
//28cm is page width (minus left border) in ODP template, so we center image
//If image height is not very big, put somme space around it
if ($height <= 7) {
$y += (7 - $height) / 2;
$Yoffset = 7 + 3.5;
} else {
$Yoffset = $y + $height;
}
//If image height is too big, position image on the right side
if ($height >= 13) {
$Yoffset = 5.2;
$x = 28 - $width;
$Xoffset = $x;
$y = 4 + (16 - $height) / 2;
//20cm is the approx useable height in ODP template, so we center image
} else {
$Xoffset = 25;
}
}
$frame = $output_pages->createElement('draw:frame');
$frame->setAttribute("draw:style-name", "gr15");
$frame->setAttribute("draw:text-style-name", "P4");
$frame->setAttribute("draw:layer", "layout");
$frame->setAttribute("svg:width", $width . "cm");
$frame->setAttribute("svg:height", $height . "cm");
$frame->setAttribute("svg:x", $x . "cm");
$frame->setAttribute("svg:y", $y . "cm");
$svg = $output_pages->createElement('draw:image');
$svg->setAttribute("xlink:href", "Pictures/{$image}");
$svg->setAttribute("xlink:type", "simple");
$svg->setAttribute("xlink:show", "embed");
$svg->setAttribute("xlink:actuate", "onLoad");
$frame->appendChild($svg);
$page->appendChild($frame);
}
$frame = $output_pages->createElement('draw:frame');
$frame->setAttribute("presentation:style-name", "pr6");
$frame->setAttribute("draw:layer", "layout");
$frame->setAttribute("svg:x", "1.5cm");
$frame->setAttribute("presentation:class", "outline");
$frame->setAttribute("presentation:user-transformed", "true");
//Text outline positioning depending on image positioning
if ($image) {
if (substr($image, -3) == "png") {
$yc = $Yoffset + 0.4;
$heightc = 19 - $yc;
//20cm is the approx useable height in ODP template
$widthc = $Xoffset;
} else {
$yc = 13;
$heightc = 7;
$widthc = 25;
}
} else {
$yc = 5;
$heightc = 15;
$widthc = 25;
}
$frame->setAttribute("svg:width", $widthc . "cm");
$frame->setAttribute("svg:height", $heightc . "cm");
$frame->setAttribute("svg:y", $yc . "cm");
$textbox = $output_pages->createElement('draw:text-box');
if ($contents) {
foreach ($contents as $element) {
$textbox->appendChild(getList($element, "L6"));
}
}
$frame->appendChild($textbox);
$page->appendChild($frame);
return $page;
}
extract($_POST);
$errMsg = scriptCheckIfNull('Page Name', $Page_Name, 'Generator', $Generator, 'Description', $Description);
if ($errMsg == "") {
$select = "SELECT `Page_ID` FROM `page` WHERE `Page_Name`='{$Page_Name}' AND `Page_ID`!='{$Orig_Page_ID}'";
$error = "The page name '{$Page_Name}' already exists. Please choose a new one. <br>";
$errMsg = scriptCheckIfUnique($select, $error);
if ($errMsg == "") {
queryUpdatePage($_POST);
header("location: ../success.php?success_tag=EditPages");
exit;
}
}
}
}
drawHeader();
drawPageTitle('Edit Page', $errMsg);
?>
<input type="hidden" name="Orig_Page_ID" value="<?php
echo $Orig_Page_ID;
?>
">
<div class="container_mid">
<fieldset class="top">
Modify Page Generator
</fieldset>
<fieldset class="middle">
<table class="input_form">
<?php
drawTextField('Page Name', 'Page_Name');
drawTextField('Generator');
<input type=submit name=BACK value=BACK>', 'system');
if ($errMsg != '') {
displayInfo('<b>Table Import Notes:</b> <br />' . $errMsg);
}
drawFooter();
die;
}
}
}
}
drawHeader();
if ($errMsg == '') {
$errMsg = 'Cobalt will import all tables it can find using the database connection you specify.';
$msgType = 'info';
}
drawPageTitle('Import Tables', $errMsg, $msgType);
?>
<script language="JavaScript" type="text/JavaScript">
function checkAll()
{
var checkboxes = document.getElementsByTagName('input');
for (var i = 0; i < checkboxes.length; i++)
{
if (checkboxes[i].type == 'checkbox')
{
checkboxes[i].checked = true;
}
}
<?php
require 'Core/SCV2_Core.php';
init_SCV2();
if (!isset($_SESSION['Project_ID'])) {
$_SESSION['Project_ID'] = 'TEMP';
}
if (!isset($_SESSION['Project_Name'])) {
$_SESSION['Project_Name'] = '(NO PROJECT)';
}
drawHeader(FALSE);
drawPageTitle("Cobalt", "Created by <a href=About_JV_Roig.php class=blue>JV Roig</a>", 'message');
if ($_SESSION['Project_ID'] == 'TEMP') {
unset($_SESSION['Project_ID']);
}
if ($_SESSION['Project_Name'] == '(NO PROJECT)') {
unset($_SESSION['Project_Name']);
}
?>
<table border=0 cellpadding=2 cellspacing=2>
<tr>
<td valign=top>
<fieldset class="container">
<span class="graytext">
Cobalt is a web-based code generator and framework using PHP and Oracle Database, created by JV Roig. <br><br>
It is a code generator, so it is capable of producing a complete working system
based on the information you feed it (data dictionary and a few miscellaneous data for
certain special cases).<br><br>
It is also a framework. This means it contains functions that allow you to create
$mysqli_where_parameters = connect_DB();
$mysqli_where_parameters->real_query("SELECT b.Field_Name, a.Where_Field_Operand, a.Where_Field_Value, a.Where_Field_Connector \n FROM `table_fields_list_source_where` a, \n `table_fields` b \n WHERE a.Field_ID='{$Field_ID}' AND a.Where_Field_ID = b.Field_ID");
} elseif (xsrf_guard()) {
init_var($_POST['btnCancel']);
init_var($_POST['btnSubmit']);
if ($_POST['btnCancel']) {
header('location: ListView_TableFields.php');
exit;
} elseif ($_POST['btnSubmit']) {
queryDeleteTableField($_POST);
header("location: ../success.php?success_tag=DeleteTableFields");
exit;
}
}
drawHeader();
drawPageTitle('Delete Table Field', 'Are you sure you wish to delete this table field?');
echo '<input type="hidden" name="Field_ID" value="' . $Field_ID . '">';
?>
<div class="container_mid">
<fieldset class="top">
Delete Table Field
</fieldset>
<fieldset class="middle">
<table class="input_form">
<?php
drawTextField('Table', 'Table_Name', TRUE);
drawTextField('Field Name', 'Field_Name', TRUE);
drawTextField('Data Type', 'Data_Type', TRUE);
drawTextField('Nullable', 'Nullable', TRUE);
drawTextField('Length', '', TRUE);
$mysqli->close();
$result->close();
} elseif (xsrf_guard()) {
init_var($_POST['btnCancel']);
init_var($_POST['btnSubmit']);
if ($_POST['btnCancel']) {
header("location: ListView_DBConnections.php");
exit;
} elseif ($_POST['btnSubmit']) {
queryDeleteDBConnection($_POST);
header("location: ../success.php?success_tag=DeleteDBConnections");
exit;
}
}
drawHeader();
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);
if ($_POST['btnCancel']) {
header("location: ListView_Pages.php");
exit;
}
if ($_POST['btnSubmit']) {
extract($_POST);
$errMsg = scriptCheckIfNull('Page Name', $Page_Name, 'Generator', $Generator, 'Description', $Description);
if ($errMsg == "") {
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>
$mysqli = connect_DB();
$mysqli->real_query("SELECT c.`Page_Name`, b.Path_Filename\n FROM `table` a, `table_pages` b, `page` c\n WHERE a.`Table_ID` = b.`Table_ID` AND\n b.`Page_ID` = c.`Page_ID` AND\n a.`Table_ID` = '{$Table_ID}'");
} elseif (xsrf_guard()) {
init_var($_POST['btnCancel']);
init_var($_POST['btnSubmit']);
if ($_POST['btnCancel']) {
header('location: ListView_Tables.php');
exit;
} elseif ($_POST['btnSubmit']) {
queryDeleteTable($_POST);
header("location: ../success.php?success_tag=DeleteTables");
exit;
}
}
drawHeader();
drawPageTitle('Delete Table', 'Are you sure you wish to delete this table?');
echo '<input type="hidden" name="Table_ID" value="' . $Table_ID . '">';
?>
<div class="container_mid_large">
<fieldset class="top">
Delete Table
</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);
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()) {
init_var($Database_Connection_ID);
$errMsg = scriptCheckIfNull('Project Name', $Project_Name, 'Client Name', $Client_Name, 'Description', $Project_Description, 'Base Directory', $Base_Directory, 'Database Connection', $Database_Connection_ID);
if ($errMsg == "") {
$select = "SELECT `Project_ID` FROM `project` WHERE `Project_Name`='{$Project_Name}' AND `Project_ID`!='{$Orig_Project_ID}'";
$error = "The project name '{$Project_Name}' already exists. Please choose a new one. <br>";
$errMsg = scriptCheckIfUnique($select, $error);
if ($errMsg == "") {
queryUpdateProject($_POST);
header("location: ../success.php?success_tag=EditProject");
exit;
}
}
}
}
drawHeader();
drawPageTitle('Edit Project', $errMsg);
?>
<input type="hidden" name="Orig_Project_ID" value="<?php
echo $_SESSION['Project_ID'];
?>
">
<div class="container_mid_huge">
<fieldset class="top">
Modify Project Data
</fieldset>
<fieldset class="middle">
<table class="input_form">
<?php
drawTextField('Project Name', 'Project_Name');
drawTextField('Client Name', 'Client_Name');
<?php
require '../Core/SCV2_Core.php';
init_SCV2();
if (xsrf_guard()) {
if ($_POST['btnCancel']) {
header("location: " . HOME_PAGE);
exit;
}
}
$mysqli = connect_DB();
$mysqli->real_query("SELECT DB_Connection_ID, DB_Connection_Name, Hostname, Username FROM database_connection WHERE Project_ID='{$_SESSION['Project_ID']}'");
drawHeader();
drawPageTitle('List View: Database Connections', $errMsg);
?>
<fieldset class="container">
<?php
drawButton('CANCEL');
?>
<a href='CreateDBConnections.php'> Create New Connection </a>
<table border="1" width="100%" cellspacing="1" class="listView">
<tr class="listRowHead">
<td width="140">Operations</td>
<td>DB Connection Name</td>
<td>Hostname</td>
<td>Username</td>
</tr>
<?php
if ($result = $mysqli->use_result()) {
$a = 0;
extract($_POST);
$errMsg = scriptCheckIfNull('DB Connection Name', $DB_Connection_Name, 'Hostname', $Hostname, 'Database', $Database, 'Username', $Username);
if ($errMsg == "") {
$select = "SELECT DB_Connection_ID FROM database_connection WHERE DB_Connection_Name='{$DB_Connection_Name}' AND DB_Connection_ID!='{$Orig_DB_Connection_ID}' AND DB_Connection_Name!='{$Orig_DB_Connection_Name}'";
$error = "The database connection name '{$DB_Connection_Name}' already exists. Please choose a new one. <br>";
$errMsg = scriptCheckIfUnique($select, $error);
if ($errMsg == "") {
queryUpdateDBConnection($_POST);
header("location: ../success.php?success_tag=EditDBConnections");
exit;
}
}
}
}
drawHeader();
drawPageTitle('Edit Database Connection', $errMsg);
?>
<input type="hidden" name="Orig_DB_Connection_ID" value="<?php
echo $Orig_DB_Connection_ID;
?>
">
<input type="hidden" name="Orig_DB_Connection_Name" value="<?php
echo $Orig_DB_Connection_Name;
?>
">
<div class="container_mid">
<fieldset class="top">
Modify Database Connection
</fieldset>
$b = $a + 1;
$errMsg .= scriptCheckIfNull("List Item #{$b}", $List_Item[$a]);
}
$mysqli = connect_DB();
$select = "SELECT `List_ID` FROM `table_fields_predefined_list` WHERE `List_Name`='" . $mysqli->real_escape_string($List_Name) . "' AND `Project_ID`='" . $mysqli->real_escape_string($_SESSION['Project_ID']) . "'";
$error = "The list name '{$List_Name}' already exists. Please choose a new one. <br>";
$errMsg .= scriptCheckIfUnique($select, $error);
if ($errMsg == "") {
queryCreatePredefinedList($_POST);
header("location: ../success.php?success_tag=CreatePredefinedLists");
exit;
}
}
}
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;
}
if ($errMsg == "") {
//Add additional info needed before passing $_POST
$_POST['Project_ID'] = $_SESSION['Project_ID'];
$DB_ID = rawurlencode(queryCreateDBConnection($_POST));
header("location: ../success.php?success_tag=CreateDBConnections&DB_ID={$DB_ID}");
exit;
}
}
}
drawHeader();
if ($errMsg == '') {
$errMsg = 'COMMON SENSE WARNING:<br>
Please do not put the credentials of your real production server(s) here. <br>
Use only your test server(s) credentials.';
}
drawPageTitle('Create Database Connection', $errMsg);
//********************************************************************************************
//Populate connection info with default information that is probably correct for 99% of users:
// -Connection label should be 'con1' if no connection has been made yet
// -Hostname should be 'localhost'
// -Username should be 'root'
// -Use as Default should be 'Yes' if there are no default connections made yet.
//********************************************************************************************
//Check if there is already an existing connection
$mysqli = connect_DB();
$mysqli->real_query("SELECT DB_Connection_ID, DB_Connection_Name, Hostname, Username FROM database_connection WHERE Project_ID='{$_SESSION['Project_ID']}'");
if ($result = $mysqli->use_result()) {
while ($row = $result->fetch_assoc()) {
$Hostname = $row['Hostname'];
$Username = $row['Username'];
}
//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;
}
drawHeader();
drawPageTitle('Create Table', $errMsg);
?>
<div class="container_mid">
<fieldset class="top">
New Table
</fieldset>
<fieldset class="middle">
<table class="input_form">
<?php
drawSelectField('drawDBConnection', 'DB Connection', 'DB_Connection_ID');
drawTextField('Table Name', 'Table_Name');
drawTextField('Folder / Subdirectory', 'Folder');
drawTextField('Remarks', '', '', 'Textarea');
drawMultiFieldStart('Table Pages');
}
} else {
die($mysqli->error);
}
$result->close();
$mysqli->close();
}
if (xsrf_guard()) {
init_var($_POST['btnCancel']);
if ($_POST['btnCancel']) {
header("location: ListView_DBConnections.php");
exit;
}
}
drawHeader();
drawPageTitle('Detail View: Database Connection', $errMsg);
?>
<div class="container_mid">
<fieldset class="top">
View DB Connection: <?php
echo $DB_Connection_Name;
?>
</fieldset>
<fieldset class="middle">
<table class="input_form">
<?php
drawTextField('DB Connection Name', 'DB_Connection_Name', TRUE);
drawTextField('Hostname', '', TRUE);
drawTextField('Database', '', TRUE);
$mysqli->close();
$mysqli_validation_routines = connect_DB();
$mysqli_validation_routines->real_query("SELECT Validation_Routine \n FROM `table_fields_secondary_validation` \n WHERE Field_ID='{$Field_ID}'");
$mysqli_select_parameters = connect_DB();
$mysqli_select_parameters->real_query("SELECT b.Field_Name, a.Display \n FROM `table_fields_list_source_select` a, \n `table_fields` b \n WHERE a.Field_ID='{$Field_ID}' AND a.Select_Field_ID = b.Field_ID");
$mysqli_where_parameters = connect_DB();
$mysqli_where_parameters->real_query("SELECT b.Field_Name, a.Where_Field_Operand, a.Where_Field_Value, a.Where_Field_Connector \n FROM `table_fields_list_source_where` a, \n `table_fields` b \n WHERE a.Field_ID='{$Field_ID}' AND a.Where_Field_ID = b.Field_ID");
} elseif (xsrf_guard()) {
init_var($_POST['btnCancel']);
if ($_POST['btnCancel']) {
header('location: ListView_TableFields.php');
exit;
}
}
drawHeader();
drawPageTitle('Detail View: Table Field', $errMsg);
?>
<div class="container_mid">
<fieldset class="top">
View Table Field: <?php
echo $Field_Name;
?>
</fieldset>
<fieldset class="middle">
<table class="input_form">
<?php
drawTextField('Table', 'Table_Name', TRUE);
drawTextField('Field Name', 'Field_Name', TRUE);
drawTextField('Data Type', 'Data_Type', TRUE);
drawTextField('Nullable', 'Nullable', TRUE);
header("location: /cobalt/Screens/DefineTableRelations.php");
exit;
} elseif ($_POST['ImportDBConnection']) {
$DB_ID = rawurlencode($_POST['DB_ID']);
header("location: /cobalt/Screens/Import_Tables.php?DB_ID={$DB_ID}");
exit;
}
exit;
}
if (!isset($_GET['success_tag'])) {
header("location: " . HOME_PAGE);
} else {
$success_tag = $_GET['success_tag'];
}
drawHeader();
drawPageTitle('Success');
echo '<div class="container_mid_prompt">';
echo '<div class="messageSystem">';
echo '<table width="100%">';
echo '<tr><td width="60"><img src="/cobalt/images/icons/ok.png"></td><td>';
echo '<table width="100%">';
if ($success_tag == "CreateDBConnections") {
echo '<tr><td align="left">Cobalt has successfully added the database connection. </td></tr>' . '<input type=hidden name=location value="/cobalt/Screens/ListView_DBConnections.php">' . '<input type=hidden name=DB_ID value="' . rawurldecode($_GET['DB_ID']) . '">';
drawSuccessContinue('<input type=submit name=CreateDBConnections value="ADD ANOTHER CONNECTION" class=button1>', '<input type=submit name=ImportDBConnection value="IMPORT TABLES" class=button1>');
} elseif ($success_tag == "CreatePages") {
echo '<tr><td align="left">Cobalt has successfully added the page. </td></tr>' . '<input type=hidden name=location value="/cobalt/Screens/ListView_Pages.php">';
drawSuccessContinue('<input type=submit name=CreatePages value="ADD ANOTHER PAGE" class=button1>');
} elseif ($success_tag == "CreatePredefinedLists") {
echo '<tr><td align="left">Cobalt has successfully added the predefined list. </td></tr>' . '<input type=hidden name=location value="/cobalt/Screens/ListView_PredefinedLists.php">';
drawSuccessContinue('<input type=submit name=CreatePredefinedLists value="ADD ANOTHER LIST" class=button1>');
} elseif ($success_tag == "CreateTables") {
<?php
require '../Core/SCV2_Core.php';
init_SCV2();
if (xsrf_guard()) {
if ($_POST['btnCancel']) {
header("location: " . HOME_PAGE);
exit;
}
}
$mysqli = connect_DB();
$mysqli->real_query("SELECT Table_ID, Table_Name, Remarks FROM `table` WHERE `Project_ID`='{$_SESSION['Project_ID']}' ORDER BY `Table_Name`");
drawHeader();
drawPageTitle('List View: Tables', $errMsg);
?>
<fieldset class="container">
<?php
drawButton('CANCEL');
?>
<a class='blue' href='CreateTables.php'>Create New Table</a> :: <a class=blue href=Import_Tables.php>Import Tables</a>
<table border=1 width=100% class="listView">
<tr class="listRowHead">
<td width="140">Operations</td>
<td>Table Name</td>
<td>Remarks</td>
</tr>
<?php
if ($result = $mysqli->use_result()) {
$a = 0;
$class = '';
while ($row = $result->fetch_assoc()) {
<input type=submit name=BACK value=BACK>', 'system');
drawFooter();
die;
}
}
} else {
$Data_Abstraction = TRUE;
$HTML_Class = TRUE;
$Validation_Class = TRUE;
$Character_Set_Class = TRUE;
$Paged_Result_Class = TRUE;
}
drawHeader();
drawPageTitle('Generate Project', 'All checked files will be generated when you click the "GENERATE!" button. <br> You may uncheck files as necessary.', 'info');
?>
<script language="JavaScript" type="text/JavaScript">
function checkAll(field)
{
if(field.length > 1)
{
for (i = 0; i < field.length; i++)
field[i].checked = true ;
}
else field.checked = true;
}
function uncheckAll(field)
{
if(field.length > 1)
