function get_fields()
{
global $tbl_users;
global $fields, $field_props;
array_splice($fields, 0);
// clear out any existing field names
array_splice($field_props, 0);
// and properties
$result = sql_query("select * from {$tbl_users} limit 1");
$nfields = sql_num_fields($result);
for ($i = 0; $i < $nfields; $i++) {
$field_name = sql_field_name($result, $i);
$fields[] = $field_name;
$field_props[$field_name]['type'] = sql_field_type($result, $i);
$field_props[$field_name]['istext'] = $field_props[$field_name]['type'] == 'string' ? true : false;
$field_props[$field_name]['isnum'] = preg_match('/(int|real)/', $field_props[$field_name]['type']) ? true : false;
$field_props[$field_name]['isbool'] = $field_props[$field_name]['type'] == 'boolean' ? true : false;
}
sql_free($result);
}
function adminfieldinp($result)
{
$fields = sql_num_fields($result);
$idle = array();
for ($i = 0; $i < $fields; $i++) {
// $field_info = sql_fetch_field_direct($result, $i);
// if ($field_info->type == 'string') {
// $idle[$field_info->name] = $field_info->length;
// }
$idle['b' . $i] = 'a';
}
echo '
<script type="text/javascript">
//<![CDATA[
';
foreach ($idle as $k => $v) {
echo $fields;
echo '
inpandfieldlen("' . $k . '",' . $v . ')';
}
echo '
//]]>
</script>';
}
$query = "";
}
$pagination = "Limit <input type='text' id='dbLimit' value='" . html_safe($limit) . "' style='width:50px;'>\n\t\t\t\t\t\t\t\t<span class='button' onclick=\"db_pagination('prev');\">prev</span>\n\t\t\t\t\t\t\t\t<span class='button' onclick=\"db_pagination('next');\">next</span>\n\t\t\t\t\t\t\t\t<input type='hidden' id='dbDB' value='" . html_safe($db) . "'>\n\t\t\t\t\t\t\t\t<input type='hidden' id='dbTable' value='" . html_safe($table) . "'>\n\t\t\t\t\t\t\t\t<input type='hidden' id='dbStart' value='" . html_safe($start) . "'>\n\t\t\t\t\t\t\t\t";
}
$querys = explode(";", $query);
foreach ($querys as $query) {
if (trim($query) != "") {
$query_query = sql_query($type, $query, $con);
if ($query_query != false) {
$res .= "<p>" . html_safe($query) . "; <span class='strong'>[</span> ok <span class='strong'>]</span></p>";
if (!empty($pagination)) {
$res .= "<p>" . $pagination . "</p>";
}
if (!is_bool($query_query)) {
$res .= "<table class='border dataView sortable tblResult'><tr>";
for ($i = 0; $i < sql_num_fields($type, $query_query); $i++) {
$res .= "<th>" . html_safe(sql_field_name($type, $query_query, $i)) . "</th>";
}
$res .= "</tr>";
while ($rows = sql_fetch_data($type, $query_query)) {
$res .= "<tr>";
foreach ($rows as $r) {
if (empty($r)) {
$r = " ";
}
$res .= "<td>" . html_safe($r) . "</td>";
}
$res .= "</tr>";
}
$res .= "</table>";
}
$nusers = sql_query1("select count(*) from {$tbl_users}");
if ($nusers == -1) {
/* Then create it */
$cmd = "\nCREATE TABLE {$tbl_users}\n(\n /* The first four fields are required. Don't remove or reorder. */\n id int NOT NULL auto_increment,\n name varchar(30),\n password varchar(40),\n email varchar(75),\n\n /* The following fields are application-specific. However only int and varchar are editable. */\n\n\n PRIMARY KEY (id)\n);";
$r = sql_command($cmd);
if ($r == -1) {
// No need to localize this: Only the admin running this for the first time would see it.
print "<p class=\"error\">Error creating the {$tbl_users} table.</p>\n";
print "<p class=\"error\">" . sql_error() . "</p>\n";
exit;
}
$nusers = 0;
}
/* Get the list of fields actually in the table. (Allows the addition of new fields later on) */
$result = sql_query("select * from {$tbl_users} limit 1");
$nfields = sql_num_fields($result);
for ($i = 0; $i < $nfields; $i++) {
$field_name = sql_field_name($result, $i);
$fields[] = $field_name;
$field_props[$field_name]['type'] = sql_field_type($result, $i);
$field_props[$field_name]['istext'] = $field_props[$field_name]['type'] == 'string' ? true : false;
$field_props[$field_name]['isnum'] = preg_match('/(int|real)/', $field_props[$field_name]['type']) ? true : false;
}
sql_free($result);
/* Get localized field name */
function get_loc_field_name($name)
{
global $vocab;
// Search for indexes "user_name", "user_password", etc, in the localization array.
if (isset($vocab["user_" . $name])) {
return get_vocab("user_" . $name);
if (!isset($p['pg'])) {
$p['pg'] = 1;
}
$start = ((int) $p['pg'] - 1) * $config['SQLLimit'];
$oracleLimit = $start + $config['SQLLimit'];
$sBuff = '';
$con = sql_connect($p['type'], $p['host'], $p['user'], $p['pass']);
foreach (explode(';', $p['code']) as $query) {
if (trim($query) !== '') {
$query = str_replace(array('{start}', '{limit}', '{oraclelimit}'), array($start, $config['SQLLimit'], $oracleLimit), $query);
$sBuff .= '<hr /><p><b>' . tText('sq8', 'Executed') . ':</b> ' . hsc($query) . '; ';
$res = sql_query($p['type'], $query, $con);
if ($res !== false && !is_bool($res)) {
$pag = genPaginator($p['pg'], -1, false) . '<br>';
$sBuff .= "<b>[ ok ]</b></p><br>{$pag}<table id='sort' class='explore sortable' style='width:100%;'><tr>";
$t = sql_num_fields($p['type'], $res, $con);
for ($i = 0; $i < $t; $i++) {
$sBuff .= '<th class="touch">' . @hsc(sql_field_name($p['type'], $res, $i)) . '</th>';
}
$sBuff .= '</tr>';
while ($rows = sql_fetch_data($p['type'], $res)) {
$sBuff .= '<tr>';
foreach ($rows as $r) {
$sBuff .= '<td>' . @hsc($r) . '</td>';
}
$sBuff .= '</tr>';
}
$sBuff .= "</table><br>{$pag}";
} else {
$sBuff .= '<b>[ ERROR ]</b></p><br>';
}
$show_form = true;
$show_dbs = true;
if (isset($_REQUEST['connect'])) {
$con = sql_connect($sqltype, $sqlhost, $sqluser, $sqlpass);
$sqlcode = isset($_REQUEST['sqlcode']) ? ssc($_REQUEST['sqlcode']) : "";
if ($con !== false) {
$show_form = false;
$s_result .= "<form action='" . $s_self . "db' method='post'>\n\t\t\t\t\t<input type='hidden' name='sqlhost' value='" . $sqlhost . "' />\n\t\t\t\t\t<input type='hidden' name='sqlport' value='" . $sqlport . "' />\n\t\t\t\t\t<input type='hidden' name='sqluser' value='" . $sqluser . "' />\n\t\t\t\t\t<input type='hidden' name='sqlpass' value='" . $sqlpass . "' />\n\t\t\t\t\t<input type='hidden' name='sqltype' value='" . $sqltype . "' />\n\t\t\t\t\t<input type='hidden' name='connect' value='connect' />\n\t\t\t\t\t<textarea id='sqlcode' name='sqlcode' class='txtarea' style='height:150px;'>" . $sqlcode . "</textarea>\n\t\t\t\t\t<p><input type='submit' name='gogo' class='inputzbut' value='Go !' style='width:120px;height:30px;' />\n\t\t\t\t\t Separate multiple commands with a semicolon <span class='gaya'>[</span> ; <span class='gaya'>]</span></p>\n\t\t\t\t\t</form>";
if (!empty($sqlcode)) {
$querys = explode(";", $sqlcode);
foreach ($querys as $query) {
if (trim($query) != "") {
$hasil = sql_query($sqltype, $query, $con);
if ($hasil != false) {
$s_result .= "<p style='padding:0;margin:6px 10px;font-weight:bold;'>" . $query . "; \n\t\t\t\t\t\t\t\t<span class='gaya'>[</span> ok <span class='gaya'>]</span></p>\n\t\t\t\t\t\t\t\t<table class='explore sortable' style='width:100%;'><tr>";
for ($i = 0; $i < sql_num_fields($sqltype, $hasil); $i++) {
$s_result .= "<th>" . @hss(sql_field_name($sqltype, $hasil, $i)) . "</th>";
}
$s_result .= "</tr>";
while ($rows = sql_fetch_data($sqltype, $hasil)) {
$s_result .= "<tr>";
foreach ($rows as $r) {
if (empty($r)) {
$r = " ";
}
$s_result .= "<td>" . @hss($r) . "</td>";
}
$s_result .= "</tr>";
}
$s_result .= "</table>";
} else {
$s_c_num = substr(md5(time() . rand(0, 100)), 0, 3);
}
setcookie("c[" . $s_c_num . "]", $s_sql_cookie, time() + $s_login_time);
}
$s_show_form = false;
$s_result .= "<form action='" . $s_self . "' method='post'>\n\t\t\t\t\t<input type='hidden' name='sqlhost' value='" . hss($s_sql['host']) . "' />\n\t\t\t\t\t<input type='hidden' name='sqlport' value='" . hss($s_sql['port']) . "' />\n\t\t\t\t\t<input type='hidden' name='sqluser' value='" . hss($s_sql['user']) . "' />\n\t\t\t\t\t<input type='hidden' name='sqlpass' value='" . hss($s_sql['pass']) . "' />\n\t\t\t\t\t<input type='hidden' name='sqltype' value='" . hss($s_sql['type']) . "' />\n\t\t\t\t\t<input type='hidden' name='x' value='db' />\n\t\t\t\t\t<input type='hidden' name='connect' value='connect' />\n\t\t\t\t\t<textarea id='sqlcode' name='sqlcode' class='txtarea' style='height:150px;'>" . hss($s_sqlcode) . "</textarea>\n\t\t\t\t\t<p><input type='submit' name='gogo' class='inputzbut' value='Go !' style='width:120px;height:30px;' />\n\t\t\t\t\t Separate multiple commands with a semicolon <span class='gaya'>[</span> ; <span class='gaya'>]</span></p>\n\t\t\t\t\t</form>";
if (!empty($s_sqlcode)) {
$s_querys = explode(";", $s_sqlcode);
foreach ($s_querys as $s_query) {
if (trim($s_query) != "") {
$s_hasil = sql_query($s_sql['type'], $s_query, $s_con);
if ($s_hasil != false) {
$s_result .= "<hr /><p style='padding:0;margin:6px 10px;font-weight:bold;'>" . hss($s_query) . "; \n\t\t\t\t\t\t\t\t<span class='gaya'>[</span> ok <span class='gaya'>]</span></p>";
if (!is_bool($s_hasil)) {
$s_result .= "<table class='explore sortable' style='width:100%;'><tr>";
for ($s_i = 0; $s_i < sql_num_fields($s_sql['type'], $s_hasil); $s_i++) {
$s_result .= "<th>" . @hss(sql_field_name($s_sql['type'], $s_hasil, $s_i)) . "</th>";
}
$s_result .= "</tr>";
while ($s_rows = sql_fetch_data($s_sql['type'], $s_hasil)) {
$s_result .= "<tr>";
foreach ($s_rows as $s_r) {
if (empty($s_r)) {
$s_r = " ";
}
$s_result .= "<td>" . @hss($s_r) . "</td>";
}
$s_result .= "</tr>";
}
$s_result .= "</table>";
}
/**
* Creates a dump of the table content for one table
*/
function _backup_dump_contents($tablename)
{
//
// Grab the data from the table.
//
$result = sql_query("SELECT * FROM {$tablename}");
if (sql_num_rows($result) > 0) {
echo "\n#\n# " . sprintf(_BACKUP_BACKUPFILE_TABLEDATAFOR, $tablename) . "\n#\n";
}
$num_fields = sql_num_fields($result);
//
// Compose fieldname list
//
$tablename_list = $this->_backup_get_field_names($result, $num_fields);
//
// Loop through the resulting rows and build the sql statement.
//
while ($row = sql_fetch_array($result)) {
// Start building the SQL statement.
echo "INSERT INTO `" . $tablename . "` {$tablename_list} VALUES(";
// Loop through the rows and fill in data for each column
for ($j = 0; $j < $num_fields; $j++) {
if (!isset($row[$j])) {
// no data for column
echo ' NULL';
} elseif ($row[$j] != '') {
// data
echo " '" . sql_real_escape_string($row[$j]) . "'";
} else {
// empty column (!= no data!)
echo "''";
}
// only add comma when not last column
if ($j != $num_fields - 1) {
echo ",";
}
}
echo ");\n";
}
echo "\n";
}
}
return 1;
}
*/
if (isset($p['sqlcode'])) {
$sBuff = '';
$con = sql_connect($p['sqltype'], $p['sqlhost'], $p['sqluser'], $p['sqlpass']);
foreach (explode(';', $p['sqlcode']) as $query) {
if (trim($query) !== '') {
$res = sql_query($p['sqltype'], $query, $con);
if ($res !== false) {
$sBuff .= '<hr /><p style="padding:0;margin:6px 10px;font-weight:bold;">' . hsc($query) . '; <span>[ ok ]</span></p>';
if (!is_bool($res)) {
$sBuff .= '<table id="sort" class="explore sortable" style="width:100%;"><tr>';
for ($i = 0; $i < sql_num_fields($p['sqltype'], $res, $con); $i++) {
$sBuff .= '<th>' . @hsc(sql_field_name($p['sqltype'], $res, $i)) . '</th>';
}
$sBuff .= '</tr>';
while ($rows = sql_fetch_data($p['sqltype'], $res)) {
$sBuff .= '<tr>';
foreach ($rows as $r) {
//if ($r === '') $r = ' ';
$sBuff .= '<td>' . @hsc($r) . '</td>';
}
$sBuff .= '</tr>';
}
$sBuff .= '</table>';
}
} else {
$sBuff .= '<p style="padding:0;margin:6px 10px;font-weight:bold;">' . hsc($query) . '; <span>[ error ]</span></p>';
function query_to_array($query, $conn)
{
$csv = array();
$resource = sql_query($query, $conn);
if ($resource) {
$row = array();
for ($i = 0; $i < sql_num_fields($resource); $i++) {
$row[] = sql_field_name($resource, $i);
}
$csv[] = $row;
}
while ($item = sql_fetch_array($resource)) {
$row = array();
for ($i = 0; $i < sql_num_fields($resource); $i++) {
$row[] = $item[$i];
}
$csv[] = $row;
}
return $csv;
}
function topicedit($topicid)
{
global $hlpfile, $tipath, $NPDS_Prefix, $f_meta_nom, $f_titre, $adminimg, $radminsuper;
include "header.php";
GraphicAdmin($hlpfile);
$result = sql_query("SELECT topicid, topicname, topicimage, topictext, topicadmin FROM " . $NPDS_Prefix . "topics WHERE topicid='{$topicid}'");
list($topicid, $topicname, $topicimage, $topictext, $topicadmin) = sql_fetch_row($result);
adminhead($f_meta_nom, $f_titre, $adminimg);
echo '<h3>' . adm_translate("Editer le Sujet :") . ' ' . aff_langue($topictext) . '</h3>';
if ($topicimage != "") {
echo '
<div class="thumbnail">
<img class="img-fluid " src="' . $tipath . $topicimage . '" alt="" />
</div>';
}
echo '
<form class="form-horizontal" role="form" action="admin.php" method="post">
<fieldset>
<div class="form-group">
<label class="col-sm-4" for="topicname">' . adm_translate("Intitulé") . '</label>
<div class="col-sm-8">
<input id="topicname" class="form-control" type="text" name="topicname" maxlength="20" value="' . $topicname . '" placeholder="' . adm_translate("cesiteestgénial") . '" />
<span class="help-block">' . adm_translate("(un simple nom sans espaces)") . ' - ' . adm_translate("max caractères") . ' : <span id="countcar_topicname"></span></span>
</div>
</div>
<div class="form-group">
<label class="col-sm-4" for="topictext">' . adm_translate("Texte") . '</label>
<div class="col-sm-8">
<textarea id="topictext" class="form-control" rows="3" name="topictext" maxlength="250" placeholder="' . adm_translate("ce site est génial") . '">' . $topictext . '</textarea>
<span class="help-block">' . adm_translate("(description ou nom complet du sujet)") . ' - ' . adm_translate("max caractères") . ' : <span id="countcar_topictext"></span></span>
</div>
</div>
<div class="form-group">
<label class="col-sm-4" for="topicimage">' . adm_translate("Image") . '</label>
<div class="col-sm-8">
<input id="topicimage" class="form-control" type="text" name="topicimage" size="21" maxlength="20" value="' . $topicimage . '" placeholder="genial.png" />
<span class="help-block">' . adm_translate("(nom de l'image + extension)") . ' (' . $tipath . '). - ' . adm_translate("max caractères") . ' : <span id="countcar_topicimage"></span></span>
</div>
</div>
<div class="form-group">
<label class="col-sm-4" for="topicadmin">' . adm_translate("Administrateur(s) du sujet") . '</label>
<div class="col-sm-8">
<div class="input-group">
<span class="input-group-btn">
<button class="btn btn-primary"><i class="fa fa-user fa-lg"></i></button>
</span>
<input id="topicadmin" class="form-control" type="text" name="topicadmin" maxlength="255" value="' . $topicadmin . '" />
</div>
</div>
</div>
</fieldset>
<fieldset>
<h4>' . adm_translate("Ajouter des Liens relatifs au Sujet") . '</h4>
<div class="form-group">
<label class="col-sm-4" for="name">' . adm_translate("Nom du site") . '</label>
<div class="col-sm-8">
<input class="form-control" type="text" name="name" id="name" maxlength="30" />
<span class="help-block">' . adm_translate("max caractères") . ' : <span id="countcar_name"></span></span>
</div>
</div>
<div class="form-group">
<label class="col-sm-4" for="url">' . adm_translate("URL") . '</label>
<div class="col-sm-8">
<input class="form-control" type="url" name="url" id="url" maxlength="200" placeholder="http://www.valideurl.org" />
<span class="help-block">' . adm_translate("max caractères") . ' : <span id="countcar_url"></span></span>
</div>
</div>
</fieldset>
<input type="hidden" name="topicid" value="' . $topicid . '" />
<input type="hidden" name="op" value="topicchange" />
<div class="form-group">
<div class="col-sm-offset-4 col-sm-8">
<div class="btn-group" role="group" aria-label="...">
<button class="btn btn-primary" type="submit"><i class="fa fa-check-square fa-lg"></i> ' . adm_translate("Sauver les modifications") . '</button>
<button class="btn btn-default" onclick="javascript:document.location.href=\'admin.php?op=topicsmanager\'">' . adm_translate("Retour en arrière") . '</button>
<button class="btn btn-danger"><i class="fa fa-trash-o fa-lg"></i> ' . adm_translate("Effacer le Sujet !") . '</button>
</div>
</div>
</div>
</form>
<form id="fad_deltop" action="admin.php" method="post">
<input type="hidden" name="topicid" value="' . $topicid . '" />
<input type="hidden" name="op" value="topicdelete" />
</form>';
echo '<h3>' . adm_translate("Gérer les Liens Relatifs : ") . ' ' . aff_langue($topictext) . '</h3>';
$res = sql_query("SELECT rid, name, url FROM " . $NPDS_Prefix . "related WHERE tid='{$topicid}'");
echo '
<table id="tad_linkrel" data-toggle="table" data-striped="true" data-icons="icons" data-icons-prefix="fa">
<thead>
<th data-sortable="true" >' . adm_translate('Nom') . '</th>
<th data-sortable="true">' . adm_translate('Url') . '</th>
<th>' . adm_translate('Fonctions') . '</th>
</thead>
<tbody>
';
while (list($rid, $name, $url) = sql_fetch_row($res)) {
echo '
<tr>
<td>' . $name . '</td>
<td><a href="' . $url . '" target="_blank">' . $url . '</a></td>
<td>
<a href="admin.php?op=relatededit&tid=' . $topicid . '&rid=' . $rid . '" class="noir"><i class="fa fa-edit fa-lg" data-toggle="tooltip" title="' . adm_translate("Editer") . '"></i></a>
<a href="' . $url . '" target="_blank"><i class="fa fa-external-link fa-lg"></i></a>
<a href="admin.php?op=relateddelete&tid=' . $topicid . '&rid=' . $rid . '" class=""><i class="fa fa-trash-o fa-lg text-danger" data-toggle="tooltip" title="' . adm_translate("Effacer") . '"></i></a>
</td>
</tr>';
}
echo '
</tbody>
</table>';
$fv_parametres = '
topicadmin: {
validators: {
callback: {
message: "Please choose an administrator from the provided list.",
callback: function(value, validator, $field) {
diff="";
var value = $field.val();
if (value === "") {return true;}
function split( n ) {
return n.split( /,\\s*/ );
}
diff = $(split(value)).not(admin).get();
console.log(diff);
if (diff!="") {return false;}
return true;
}
}
}
},
topicimage: {
validators: {
regexp: {
regexp: /^[\\w]+\\.(jpg|jpeg|png|gif)$/,
message: "This must be a valid file name with one of this extension jpg, jpeg, png, gif."
}
}
},
topicname: {
validators: {
regexp: {
regexp: /^[a-z]+$/i,
message: "This must be a simple word without space."
}
}
},
';
$fields = sql_num_fields($result);
echo auto_complete_multi('admin', 'aid', 'authors', 'topicadmin', '');
adminfieldinp($result);
adminfieldinp($res);
adminfoot('fv', $fv_parametres, '', '');
}
function dbSave_tofile($repertoire, $linebyline = 0, $savemysql_size = 256)
{
global $dbname, $name, $MSos, $crlf, $crlf2;
@set_time_limit(600);
$date_jour = date(adm_translate("dateforop"));
$date_op = date("ymd");
$filename = $dbname . "-" . $date_op;
$tables = sql_list_tables($dbname);
$num_tables = sql_num_rows($tables);
if ($num_tables == 0) {
echo " " . adm_translate("Aucune table n'a été trouvée") . "\n";
} else {
if (!isset($repertoire) or $repertoire == "") {
$repertoire = ".";
}
if (!is_dir($repertoire)) {
@umask("0000");
@mkdir($repertoire, 0777);
$fp = fopen($repertoire . "/index.html", 'w');
fclose($fp);
}
$heure_jour = date("H:i");
$data0 = "# ========================================================{$crlf}" . "# {$crlf}" . "# Sauvegarde de la base de données : " . $dbname . " {$crlf}" . "# Effectuée le " . $date_jour . " : " . $heure_jour . " par " . $name . " {$crlf}" . "# {$crlf}" . "# ========================================================{$crlf}";
$data1 = "";
$ifile = 0;
while ($row = sql_fetch_row($tables)) {
$table = $row[0];
$data1 .= "{$crlf}" . "# --------------------------------------------------------{$crlf}" . "# {$crlf}" . "# Structure de la table '" . $table . "' {$crlf}" . "# {$crlf}{$crlf}";
$data1 .= get_table_def($table) . "{$crlf}{$crlf}" . "# {$crlf}" . "# Contenu de la table '" . $table . "' {$crlf}" . "# {$crlf}{$crlf}";
$result = sql_query("SELECT * FROM {$table}");
$count_line = sql_num_fields($result);
while ($row = sql_fetch_row($result)) {
$schema_insert = "INSERT INTO {$table} VALUES (";
for ($j = 0; $j < $count_line; $j++) {
if (!isset($row[$j])) {
$schema_insert .= " NULL";
} else {
if ($row[$j] != "") {
$schema_insert .= " '" . PrepareString($row[$j]) . "'";
} else {
$schema_insert .= " ''";
}
}
if ($j < $count_line - 1) {
$schema_insert .= ",";
}
}
$schema_insert .= ");{$crlf}";
$data1 .= $schema_insert;
if ($linebyline == 1) {
if (strlen($data1) > $savemysql_size * 1024) {
send_tofile($data0 . $data1, $repertoire, $filename . "-" . sprintf("%03d", $ifile), "sql", $MSos);
$data1 = "";
$ifile++;
}
}
}
$data1 .= "{$crlf}{$crlf}" . "# --------------------------------------------------------{$crlf}";
if ($linebyline == 0) {
if (strlen($data1) > $savemysql_size * 1024) {
send_tofile($data0 . $data1, $repertoire, $filename . "-" . sprintf("%03d", $ifile), "sql", $MSos);
$data1 = "";
$ifile++;
}
}
}
if (strlen($data1) > 0) {
send_tofile($data0 . $data1, $repertoire, $filename . "-" . sprintf("%03d", $ifile), "sql", $MSos);
$data1 = "";
$ifile++;
}
}
}
$s_show_form = true;
$s_show_dbs = true;
if (isset($_REQUEST['connect'])) {
$s_con = sql_connect($s_sqltype, $s_sqlhost, $s_sqluser, $s_sqlpass);
$s_sqlcode = isset($_REQUEST['sqlcode']) ? urldecode(ssc($_REQUEST['sqlcode'])) : "";
if ($s_con !== false) {
$s_show_form = false;
$s_result .= "<form action='" . $s_self . "' method='post'>\n\t\t\t\t\t<input type='hidden' name='sqlhost' value='" . $s_sqlhost . "' />\n\t\t\t\t\t<input type='hidden' name='sqlport' value='" . $s_sqlport . "' />\n\t\t\t\t\t<input type='hidden' name='sqluser' value='" . $s_sqluser . "' />\n\t\t\t\t\t<input type='hidden' name='sqlpass' value='" . $s_sqlpass . "' />\n\t\t\t\t\t<input type='hidden' name='sqltype' value='" . $s_sqltype . "' />\n\t\t\t\t\t<input type='hidden' name='x' value='db' />\n\t\t\t\t\t<input type='hidden' name='connect' value='connect' />\n\t\t\t\t\t<textarea id='sqlcode' name='sqlcode' class='txtarea' style='height:150px;'>" . $s_sqlcode . "</textarea>\n\t\t\t\t\t<p><input type='submit' name='gogo' class='inputzbut' value='Go !' style='width:120px;height:30px;' />\n\t\t\t\t\t Separate multiple commands with a semicolon <span class='gaya'>[</span> ; <span class='gaya'>]</span></p>\n\t\t\t\t\t</form>";
if (!empty($s_sqlcode)) {
$s_querys = explode(";", $s_sqlcode);
foreach ($s_querys as $s_query) {
if (trim($s_query) != "") {
$s_hasil = sql_query($s_sqltype, $s_query, $s_con);
if ($s_hasil != false) {
$s_result .= "<p style='padding:0;margin:6px 10px;font-weight:bold;'>" . $s_query . "; \n\t\t\t\t\t\t\t\t<span class='gaya'>[</span> ok <span class='gaya'>]</span></p>\n\t\t\t\t\t\t\t\t<table class='explore sortable' style='width:100%;'><tr>";
for ($s_i = 0; $s_i < sql_num_fields($s_sqltype, $s_hasil); $s_i++) {
$s_result .= "<th>" . @hss(sql_field_name($s_sqltype, $s_hasil, $s_i)) . "</th>";
}
$s_result .= "</tr>";
while ($s_rows = sql_fetch_data($s_sqltype, $s_hasil)) {
$s_result .= "<tr>";
foreach ($s_rows as $s_r) {
if (empty($s_r)) {
$s_r = " ";
}
$s_result .= "<td>" . @hss($s_r) . "</td>";
}
$s_result .= "</tr>";
}
$s_result .= "</table>";
} else {
