[Mydatabasepilot-cvs] MyDatabasePilot Application.cfm,1.6,1.7 EnvCFServer.cfm,1.2,1.3 EnvDatabase.cf

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Update of /cvsroot/mydatabasepilot/MyDatabasePilot
In directory sc8-pr-cvs1:/tmp/cvs-serv7065

Modified Files:
	Application.cfm EnvCFServer.cfm EnvDatabase.cfm EnvOS.cfm 
	License.cfm MyDatabasePilot.cfm index.cfm 
Log Message:
Internal Structure Changed:
[ 727872 ] Place Repeated Tags in Header File
Also added mainMenuIsVisible Boolean

Index: Application.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/Application.cfm,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** Application.cfm	24 Apr 2003 03:18:13 -0000	1.6
--- Application.cfm	30 Apr 2003 03:39:03 -0000	1.7
***************
*** 29,35 ****
  	--->

! <!---------------------------------->
! <!--- Iniialize Client Variables --->
! <!---------------------------------->
  	<!---Add Client Variables here if any--->

--- 29,35 ----
  	--->

! <!----------------------------------->
! <!--- Initialize Client Variables --->
! <!----------------------------------->
  	<!---Add Client Variables here if any--->

***************
*** 82,88 ****
  </cflock>

! <!-------------------------------------------------->
! <!--- Set Application-Wide Local scope variables --->
! <!-------------------------------------------------->
  <cfset applicationName = "MyDatabase Pilot">
  <cfset applicationVersion = "v0.7.0(Alpha)">
--- 82,88 ----
  </cflock>

! <!--------------------------------------------------------->
! <!--- Initialize Application-Wide Local scope variables --->
! <!--------------------------------------------------------->
  <cfset applicationName = "MyDatabase Pilot">
  <cfset applicationVersion = "v0.7.0(Alpha)">
***************
*** 92,95 ****
--- 92,96 ----
  <cfset currentQueryString = "#cgi.query_string#">
  <cfset currentPage = "#currentPath#?#currentQueryString#">
+ <cfset mainMenuIsVisible = TRUE>

  <!--------------------------------------------------------->

Index: EnvCFServer.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/EnvCFServer.cfm,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** EnvCFServer.cfm	26 Apr 2003 04:40:26 -0000	1.2
--- EnvCFServer.cfm	30 Apr 2003 03:39:03 -0000	1.3
***************
*** 6,34 ****
  ********************************************************************************************--->

! <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
! <html>
! <head>
! <title><cfoutput>#applicationName# #applicationVersion#</cfoutput> - ColdFusion Server Environment Details</title>
! <link rel="STYLESHEET" type="text/css" href="Styles/master.css">
! </head>
! <body>
  <cfinclude template="Include/Header.cfm">
! <table width="100%" border="0" cellspacing="0" cellpadding="0"><tr>
! 	<cfinclude template="Include/MainMenu.cfm">
! 	<td valign="top">
! 		<h2>ColdFusion Server Details</h2>
! 		<table width="100%" border="1" cellspacing="0" cellpadding="2">
! 			<!--- Initiate a Read Only lock to ensure the integrity of Server variables --->
! 			<cflock timeout = "30" throwontimeout="no" type = "readonly" scope = "server">
! 				<!--- Displays ColdFusion Server Environment Details --->
! 				<cfoutput>
! 				<tr><td>Product Name:</td><td>#Server.ColdFusion.ProductName#</td></tr>
! 				<tr><td>Product Version:</td><td>#Server.ColdFusion.ProductVersion#</td></tr>
! 				<tr><td>Product Level:</td><td>#Server.ColdFusion.ProductLevel#</td></tr>
! 				<tr><td>Product SerialNumber:</td><td>#Server.ColdFusion.SerialNumber#</td></tr>
! 				<tr><td>Supported Locales:</td><td>#Server.ColdFusion.SupportedLocales#</td></tr>
! 				</cfoutput>
! 			</cflock>
! 		</table>

  <!---||| Include Footer |||--->
--- 6,30 ----
  ********************************************************************************************--->

! <!---||| Initialize Local Page Variables |||--->
! <cfset title = "ColdFusion Server Environment Details">	<!--- Page Title --->
! 
! <!---||| Include Header |||--->
  <cfinclude template="Include/Header.cfm">
! 
! <!---||| Print ColdFusion Server Details |||--->
! <h2>ColdFusion Server Details</h2>
! <table width="100%" border="1" cellspacing="0" cellpadding="2">
! 	<!--- Initiate a Read Only lock to ensure the integrity of Server variables --->
! 	<cflock timeout = "30" throwontimeout="no" type = "readonly" scope = "server">
! 		<!--- Displays ColdFusion Server Environment Details --->
! 		<cfoutput>
! 		<tr><td>Product Name:</td><td>#Server.ColdFusion.ProductName#</td></tr>
! 		<tr><td>Product Version:</td><td>#Server.ColdFusion.ProductVersion#</td></tr>
! 		<tr><td>Product Level:</td><td>#Server.ColdFusion.ProductLevel#</td></tr>
! 		<tr><td>Product SerialNumber:</td><td>#Server.ColdFusion.SerialNumber#</td></tr>
! 		<tr><td>Supported Locales:</td><td>#Server.ColdFusion.SupportedLocales#</td></tr>
! 		</cfoutput>
! 	</cflock>
! </table>

  <!---||| Include Footer |||--->

Index: EnvDatabase.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/EnvDatabase.cfm,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** EnvDatabase.cfm	26 Apr 2003 04:40:27 -0000	1.2
--- EnvDatabase.cfm	30 Apr 2003 03:39:03 -0000	1.3
***************
*** 6,32 ****
  ********************************************************************************************--->

! <!--- Run dbGeneralInfo Query --->
! <cfinclude template="Query/dbGeneralInfo.cfm">

! <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
! <html>
! <head>
! <title><cfoutput>#applicationName# #applicationVersion#</cfoutput> - Database Environment Details</title>
! <link rel="STYLESHEET" type="text/css" href="Styles/master.css">
! </head>
! <body>
  <cfinclude template="Include/Header.cfm">
! <table width="100%" border="0" cellspacing="0" cellpadding="0"><tr>
! 	<cfinclude template="Include/MainMenu.cfm">
! 	<td valign="top">
! 		<h2>MySQL Data Base Details</h2>
! 		<table width="100%" border="1" cellspacing="0" cellpadding="2">
! 			<!--- Display Database Environment Details --->
! 			<cfoutput query="dbGeneralInfo">
! 			<tr><td>Version:</td><td>#version#</td></tr>
! 			<tr><td>Database Server Time:</td><td>#serverTime#</td></tr>
! 			<tr><td>Database currently in Use:</td><td>#dbInUse#</td></tr>
! 			</cfoutput>
! 		</table>

  <!---||| Include Footer |||--->
--- 6,28 ----
  ********************************************************************************************--->

! 
! <cfinclude template="Query/dbGeneralInfo.cfm">

! <!---||| Initialize Local Page Variables |||--->
! <cfset title = "Database Environment Details">	<!--- Page Title --->
! 
! <!---||| Include Header |||--->
  <cfinclude template="Include/Header.cfm">
! 
! <!---||| Print MySQL Database Server Details |||--->
! <h2>MySQL Database Server Details</h2>
! <table width="100%" border="1" cellspacing="0" cellpadding="2">
! 	<!--- Display Database Environment Details --->
! 	<cfoutput query="dbGeneralInfo">
! 	<tr><td>Version:</td><td>#version#</td></tr>
! 	<tr><td>Database Server Time:</td><td>#serverTime#</td></tr>
! 	<tr><td>Database currently in Use:</td><td>#dbInUse#</td></tr>
! 	</cfoutput>
! </table>

  <!---||| Include Footer |||--->

Index: EnvOS.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/EnvOS.cfm,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** EnvOS.cfm	26 Apr 2003 04:40:27 -0000	1.2
--- EnvOS.cfm	30 Apr 2003 03:39:03 -0000	1.3
***************
*** 6,33 ****
  ********************************************************************************************--->

! <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
! <html>
! <head>
! <title><cfoutput>#applicationName# #applicationVersion#</cfoutput> - Operating System Environment Details</title>
! <link rel="STYLESHEET" type="text/css" href="Styles/master.css">
! </head>
! <body>
  <cfinclude template="Include/Header.cfm">
! <table width="100%" border="0" cellspacing="0" cellpadding="0"><tr>
! 	<cfinclude template="Include/MainMenu.cfm">
! 	<td valign="top">
! 		<h2>Operating System Details</h2>
! 		<table width="100%" border="1" cellspacing="0" cellpadding="2">
! 			<!--- Initiate a Read Only lock to ensure the integrity of Server variables --->
! 			<cflock timeout = "30" throwontimeout="no" type = "readonly" scope = "server">
! 				<!--- Displays Operating System Environment Details --->
! 				<cfoutput>
! 				<tr><td>OS Name:</td><td>#Server.OS.Name#</td></tr>
! 				<tr><td>OS Additional Information:</td><td>#Server.OS.AdditionalInformation#</td></tr>
! 				<tr><td>OS Version:</td><td>#Server.OS.Version#</td></tr>
! 				<tr><td>OS Build Number:</td><td>#Server.OS.BuildNumber#</td></tr>
! 				</cfoutput>
! 			</cflock>
! 		</table>

  <!---||| Include Footer |||--->
--- 6,29 ----
  ********************************************************************************************--->

! <!---||| Initialize Local Page Variables |||--->
! <cfset title = "Operating System Environment Details">	<!--- Page Title --->
! 
! <!---||| Include Header |||--->
  <cfinclude template="Include/Header.cfm">
! 
! <!---||| Print Operating System Details |||--->
! <h2>Operating System Details</h2>
! <table width="100%" border="1" cellspacing="0" cellpadding="2">
! 	<!--- Initiate a Read Only lock to ensure the integrity of Server variables --->
! 	<cflock timeout = "30" throwontimeout="no" type = "readonly" scope = "server">
! 		<!--- Displays Operating System Environment Details --->
! 		<cfoutput>
! 		<tr><td>OS Name:</td><td>#Server.OS.Name#</td></tr>
! 		<tr><td>OS Additional Information:</td><td>#Server.OS.AdditionalInformation#</td></tr>
! 		<tr><td>OS Version:</td><td>#Server.OS.Version#</td></tr>
! 		<tr><td>OS Build Number:</td><td>#Server.OS.BuildNumber#</td></tr>
! 		</cfoutput>
! 	</cflock>
! </table>

  <!---||| Include Footer |||--->

Index: License.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/License.cfm,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** License.cfm	26 Apr 2003 04:40:27 -0000	1.2
--- License.cfm	30 Apr 2003 03:39:03 -0000	1.3
***************
*** 2,26 ****
  * Copyright:        MyDatabase Pilot is distributed under the terms of the GNU GPL license     *
  * Template:         License.cfm                                                                *
! * Purpose:          Declares the terms of use of MyDatabase Pilot                              *
  * Requiremets:      None                                                                       *
  ********************************************************************************************--->

! <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
! <html>
! <head>
! <title><cfoutput>#applicationName# #applicationVersion#</cfoutput></title>
! <link rel="STYLESHEET" type="text/css" href="Styles/master.css">
! </head>
! <body>
  <cfinclude template="Include/Header.cfm">
! <table width="100%" border="0" cellspacing="0" cellpadding="0"><tr>
! 	<cfinclude template="Include/MainMenu.cfm">
! 	<td valign="top">
! 		<table width="100%" border="0" cellspacing="0" cellpadding="0">
! 		<tr><td>
! 			<h1>The GNU General Public License (GPL)</h1>
! 			<h2>Version 2, June 1991</h2>
! 			<p class="Plain">Copyright (C) 1989, 1991 Free Software Foundation, Inc.<br>
! 				59 Temple Place, Suite 330, Boston, MA  02111-1307  USA</p>

  <p>Everyone is permitted to copy and distribute verbatim copies of this license document, but changing it is not allowed.</p>
--- 2,21 ----
  * Copyright:        MyDatabase Pilot is distributed under the terms of the GNU GPL license     *
  * Template:         License.cfm                                                                *
! * Purpose:          Declares the terms of use for MyDatabase Pilot                             *
  * Requiremets:      None                                                                       *
  ********************************************************************************************--->

! <!---||| Initialize Local Page Variables |||--->
! <cfset title = "GNU General Public License">	<!--- Page Title --->
! 
! <!---||| Include Header |||--->
  <cfinclude template="Include/Header.cfm">
! 
! <!---||| Print GNU General Public License |||--->
! <div style="margin:5px;">
! <h1>The GNU General Public License (GPL)</h1>
! <h2>Version 2, June 1991</h2>
! <p class="Plain">Copyright (C) 1989, 1991 Free Software Foundation, Inc.<br>
! 	59 Temple Place, Suite 330, Boston, MA  02111-1307  USA</p>

  <p>Everyone is permitted to copy and distribute verbatim copies of this license document, but changing it is not allowed.</p>
***************
*** 396,401 ****
  library.  If this is what you want to do, use the GNU Library General
  Public License instead of this License.</p>
! 		</td></tr>
! 		</table>

  <!---||| Include Footer |||--->
--- 391,395 ----
  library.  If this is what you want to do, use the GNU Library General
  Public License instead of this License.</p>
! </div>

  <!---||| Include Footer |||--->

Index: MyDatabasePilot.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/MyDatabasePilot.cfm,v
retrieving revision 1.8
retrieving revision 1.9
diff -C2 -d -r1.8 -r1.9
*** MyDatabasePilot.cfm	26 Apr 2003 04:40:27 -0000	1.8
--- MyDatabasePilot.cfm	30 Apr 2003 03:39:03 -0000	1.9
***************
*** 43,73 ****
  </cfswitch>

! <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
! <html>
! <head>
! <title><cfoutput>#applicationName# #applicationVersion#</cfoutput></title>
! <link rel="STYLESHEET" type="text/css" href="Styles/master.css">
! </head>
! <body>
  <cfinclude template="Include/Header.cfm">
! <table width="100%" border="0" cellspacing="0" cellpadding="0"><tr>
! 	<cfinclude template="Include/MainMenu.cfm">
! 	<td valign="top">
! 		<!---||| Show Current Database |||--->
! 		<!--- Initiate a readonly lock to ensure the integrity of session variables --->
! 		<cflock timeout = "30" throwontimeout="no" type = "readonly" scope = "session">
! 			<h2>Current Database: <cfoutput>#session.dbName#</cfoutput></h2>
! 		</cflock>
! 		
! 		<!---||| Output the Result of User Requested dbProcess |||--->
! 		<cfswitch expression="#dbProcess#"> 
! 			<cfcase value="ShowTables"><cfinclude template="dbProcessBody/ShowTables.cfm"></cfcase>
! 			<cfcase value="ShowFields"><cfinclude template="dbProcessBody/ShowFields.cfm"></cfcase>
! 			<cfcase value="ShowRecords"><cfinclude template="dbProcessBody/ShowRecords.cfm"></cfcase>
! 			<cfcase value="CreateTable_Step1"><cfinclude template="dbProcessBody/CreateTable_Step1.cfm"></cfcase>
! 			<cfcase value="CreateTable_Step2">Create Table Step two</cfcase>
! 			<cfcase value="SelectRecords"><cfinclude template="dbProcessBody/SelectRecords.cfm"></cfcase>
! 			<cfdefaultcase>Error: No dbProcess was Specified</cfdefaultcase> 
! 		</cfswitch>

  <!---||| Include Footer |||--->
--- 43,65 ----
  </cfswitch>

! <!---||| Include Header |||--->
  <cfinclude template="Include/Header.cfm">
! 
! <!---||| Show Current Database |||--->
! <!--- Initiate a readonly lock to ensure the integrity of session variables --->
! <cflock timeout = "30" throwontimeout="no" type = "readonly" scope = "session">
! 	<h2>Current Database: <cfoutput>#session.dbName#</cfoutput></h2>
! </cflock>
! 
! <!---||| Output the Result of User Requested dbProcess |||--->
! <cfswitch expression="#dbProcess#"> 
! 	<cfcase value="ShowTables"><cfinclude template="dbProcessBody/ShowTables.cfm"></cfcase>
! 	<cfcase value="ShowFields"><cfinclude template="dbProcessBody/ShowFields.cfm"></cfcase>
! 	<cfcase value="ShowRecords"><cfinclude template="dbProcessBody/ShowRecords.cfm"></cfcase>
! 	<cfcase value="CreateTable_Step1"><cfinclude template="dbProcessBody/CreateTable_Step1.cfm"></cfcase>
! 	<cfcase value="CreateTable_Step2">Create Table Step two</cfcase>
! 	<cfcase value="SelectRecords"><cfinclude template="dbProcessBody/SelectRecords.cfm"></cfcase>
! 	<cfdefaultcase>Error: No dbProcess was Specified</cfdefaultcase> 
! </cfswitch>

  <!---||| Include Footer |||--->

Index: index.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/index.cfm,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** index.cfm	26 Apr 2003 04:40:27 -0000	1.4
--- index.cfm	30 Apr 2003 03:39:03 -0000	1.5
***************
*** 10,37 ****
  ********************************************************************************************--->

! <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
! <html>
! <head>
! <title><cfoutput>#applicationName# #applicationVersion#</cfoutput></title>
! <link rel="STYLESHEET" type="text/css" href="Styles/master.css">
! </head>
! <body>
  <cfinclude template="Include/Header.cfm">
! <table width="100%" border="0" cellspacing="2" cellpadding="0">
! <tr><td class="Warning">Warning: This software is currently under development. It is currently in Alpha release. Which means it is not fully tested and could be unstable.</td></tr>
! <tr>
! 	<td>
! 		<p class="Plain">You can either login to a database by completing the form below, or if you have configured the Application.cfm file for a default database, you can <a href="MyDatabasePilot.cfm?dbProcess=ShowTables">USE DEFAULT DATABASE</a>.</p>
! 		
! 		<cflock timeout = "30" throwontimeout="no" type = "readonly" scope = "session">
! 			
! 			<cfform action="#mainpage#?#session.URLToken#&dbProcess=ShowTables" method="post" name="FORM_LogintoDB" enablecab="yes">
! 				<cfinput name="dataSource" type="text" size="40" required="yes"> Data Source<br>
! 				<cfinput name="userName" type="text" size="40" required="yes"> User Name<br>
! 				<cfinput name="password" type="password" size="40"> Password<br>
! 				<input name="LoginSubmit" type="submit" value="Login to MyDatabase">
! 				<input name="LoginReset" type="reset" value="Clear Login Form">
! 			</cfform>
! 		</cflock>

  <!---||| Include Footer |||--->
--- 10,32 ----
  ********************************************************************************************--->

! 
! <cfset mainMenuIsVisible = FALSE> 
! 
! 
  <cfinclude template="Include/Header.cfm">
! 
! 
! <p class="Plain">You can either login to a database by completing the form below, or if you have configured the Application.cfm file for a default database, you can <a href="MyDatabasePilot.cfm?dbProcess=ShowTables">USE DEFAULT DATABASE</a>.</p>
! 
! <cflock timeout = "30" throwontimeout="no" type = "readonly" scope = "session">
! 	
! 	<cfform action="#mainpage#?#session.URLToken#&dbProcess=ShowTables" method="post" name="FORM_LogintoDB" enablecab="yes">
! 		<cfinput name="dataSource" type="text" size="40" required="yes"> Data Source<br>
! 		<cfinput name="userName" type="text" size="40" required="yes"> User Name<br>
! 		<cfinput name="password" type="password" size="40"> Password<br>
! 		<input name="LoginSubmit" type="submit" value="Login to MyDatabase">
! 		<input name="LoginReset" type="reset" value="Clear Login Form">
! 	</cfform>
! </cflock>

  <!---||| Include Footer |||--->

[Mydatabasepilot-cvs] MyDatabasePilot Application.cfm,1.6,1.7 EnvCFServer.cfm,1.2,1.3 EnvDatabase.cf

[Mydatabasepilot-cvs] MyDatabasePilot Application.cfm,1.6,1.7 EnvCFServer.cfm,1.2,1.3 EnvDatabase.cfm,1.2,1.3 EnvOS.cfm,1.2,1.3 License.cfm,1.2,1.3 MyDatabasePilot.cfm,1.8,1.9 index.cfm,1.4,1.5