} else return false;
break;;
case "Sybase":
$row = sybase_fetch_object($res);
return $row;
break;;
}
}
}
/*
* Function Free Result for function free the memory
*/
if (!function_exists("sql_free_result")) {
function sql_free_result($res) {
global $dbtype;
switch ($dbtype) {
case "mysql":
return mysql_free_result($res);
break;;
case "mSQL":
return msql_free_result($res);
break;;
case "postgres":
case "postgres_local":
return pg_FreeResult( $res->get_result() );
break;;
case "ODBC":
case "ODBC_Adabas":
return odbc_free_result($res);
break;;
case "Interbase":
echo( "<BR>Error! PHP dosen't support ibase_free_result!<BR>" );
break;;
case "Sybase":
return sybase_free_result($res);
break;;
}
}
}
/*
* Function Format Size
*/
if (!function_exists("formatsize")) {
function formatsize( $value = false ){
if($value >= 1073741824) {
$value = round($value / 1073741824 * 100) / 100 . "Gb";
} elseif($value >= 1048576) {
$value = round($value / 1048576 * 100) / 100 . "Mb";
} elseif($value >= 1024) {
$value = round($value / 1024 * 100) / 100 . "Kb";
} else {
$value = $value . "b";
}
return $value;
}
}
/*
* Return Alphanumerical chars
*/
if (!function_exists("AlphanumericalClean")) {
function AlphanumericalClean( $str = false ) {
return preg_replace( "/[^а-яА-Яa-zA-Z0-9\-\_\ ]/", "" , $str );
}
}
/*
* Get server info
*/
if (!function_exists("server_info")) {
function server_info() {
global $tmpdir,$baseurl;
if (empty($tmpdir)) {
$tmpdir = ini_get("upload_tmp_dir");
if (is_dir($tmpdir)) {$tmpdir = realpath("./");}
}
$tmpdir = @realpath($tmpdir);
// Safe mod checking
if (@ini_get("safe_mode") or strtolower(@ini_get("safe_mode")) == "on") {
$safemode = "<font color=\"red\">ON (secure)</font>";
} else {
$safemode = "<font color=\"green\">OFF (not secure)</font>";
}
// Open Base dir
if (@ini_get("open_basedir") or strtolower(@ini_get("open_basedir")) == "on") {
$openbasedir = "<font color=\"red\">ON (secure)</font>";
} else {
$openbasedir = "<font color=\"green\">OFF (not secure)</font>";
}
// Return information about server in array
return array
(
"OS" => wordwrap(php_uname(),90,"<BR>",1),
"TMP_DIR" => $tmpdir,
"UID" => getmyuid(),
"GID" => getmygid(),
"Process PID" => getmypid(),
"Server Software" => $_SERVER["SERVER_SOFTWARE"],
"PHP version" => "<a href=\"".$baseurl."&act=14\">".phpversion()."</a>",
"SafeMod" => $safemode,
"Open Base Dir" => $openbasedir,
"SQL version" => get_server_info(),
"Server name" => $_SERVER["SERVER_NAME"],
"Current user" => get_current_user(),
);
}
}
/*
* SQL error reporting
*/
function error($error, $query) {
echo(nl2br( '<script>'."alert('"."\\n\\nThe following query failed\\n\\nSQL error message: \\n".addslashes($error)."\\n\\nFollowing query: `".addslashes($query)."`\\n\\n"."')".'</script>'."<BR><BR><font color=\"red\">Query execute faild</font><BR><hr width=\"400\"><BR>Please click <a href=\"javascript:history.back(-1)\">here</a> to go back\n\n"));
}
/*
* SQL query execute
*/
function query($id, $query) {
global $lang,$language;
$res = '';
if((isset($query)) && (!empty($query))) {
$query = stripslashes($query);
$res = sql_query($query, $id);
if (sql_error()) {
error(sql_error(), $query);
} else {
return $res;
}
} else {
return false;
}
}
/*
* SQL quick launch
*/
function quicklaunch() {
global $lang,$language,$baseurl,$server,$port,$login,$password;
$quicklaunch = array
(
array($lang[$language.'_text1'],$baseurl."&act=11"),
array($lang[$language.'_text2'],$baseurl."&act=09"),
array($lang[$language.'_text3'],$baseurl."&act=01"),
array($lang[$language.'_text4'],$baseurl."&act=00"),
array($lang[$language.'_text5'],$baseurl."&act=08"),
array($lang[$language.'_text30'],$baseurl."&act=13"),
);
$str = "<table border=\"0\" width=\"960\">\n<tr align=\"center\">\n <td rowspan=\"2\" width=\"46\"><a href=\"javascript:history.back(-1)\" title=\"Назад\"><img src=\"".basename(__FILE__)."?image=back\"></a></td>\n <td rowspan=\"2\" width=\"47\"><a href=\"javascript:location.reload();\" title=\"Refresh\"><img src=\"".basename(__FILE__)."?image=reload\"></a></td>\n <td rowspan=\"2\" width=\"48\"><a href=\"".$baseurl."\" title=\"На главную\"><img src=\"".basename(__FILE__)."?image=home\"></a></td>\n <td rowspan=\"2\" width=\"48\"><a href=\"".basename(__FILE__)."?\" title=\"Login page\"><img src=\"".basename(__FILE__)."?image=log_in_off\"></a></td>\n <td colspan=\"".count($quicklaunch)."\" width=\"760\"><hr><img border=\"0\" src=\"".basename(__FILE__)."?image=info\" align=\"absmiddle\"><B>".get_server_info()." running in ".AlphanumericalClean($server).":".AlphanumericalClean($port)." as ".AlphanumericalClean($login)." </B><BR><hr></td>\n</tr>\n<tr>";
if (count($quicklaunch) > 0) {
foreach($quicklaunch as $item) {
$str .= "\n <td align=\"center\">[ <a href=\"".$item[1]."\">".$item[0]."</a> ]</td>";
}
}
$str .= "\n</tr>\n</table>\n<BR>";
return $str;
}
/*
* List Of DB`s
*/
function db_list($id) {
global $lang,$language,$baseurl;
$db_list = query($id, "SHOW DATABASES"); // [-]
$db_count = sql_num_rows($db_list);
$str = "<img border=\"0\" src=\"".basename(__FILE__)."?image=db\" valign=\"middle\"><B>".$lang[$language.'_text6']."</B>\n<table border=\"0\" width=\"200\">\n<tr align=\"center\">\n <td colspan=\"2\"><B>".$lang[$language.'_text7']."</B></td>\n <td colspan=\"2\"><B>".$lang[$language.'_text8']."</B></td>\n</tr>";
while($odj = sql_fetch_object($db_list)) {
//$tbls = sql_num_rows(mysql_list_tables($tmp[1])); [-]
$str .= "\n<tr align=\"center\">\n <td><img border=\"0\" src=\"".basename(__FILE__)."?image=browse_db\" align=\"absmiddle\"></td>\n <td><a href=\"".$baseurl."&act=02&db=".$odj->Database."\">".$odj->Database."</a></td>\n <td><a href=\"".$baseurl."&act=10&dump=db&db=".$odj->Database."\" title=\"Backup Database ".$odj->Database."\"><img src=\"".basename(__FILE__)."?image=save\" align=\"absmiddle\"></a></td>\n <td><a href=\"javascript: confirm_function('".$baseurl."&act=03&db=".$odj->Database."');\" title=\"Drop Database ".$odj->Database."\"><img src=\"".basename(__FILE__)."?image=drop\" align=\"center\"></a>\n</tr>";
}
$str .= "\n<tr align=\"center\">\n <td colspan=\"4\">".$lang[$language.'_text10'].": <B>".$db_count."</B></td>\n</tr>\n<tr align=\"center\">\n <td colspan=\"4\"><a href=\"".$baseurl."&act=04\">[ ".$lang[$language.'_text9']." ]</a></td>\n</tr>\n</table>\n";
return $str;
}
/*
* SQL dump DB
*/
function dump_db($id, $db,& $type) {
global $lang,$language,$baseurl,$dbtype;
$tmp = server_info();
$act_sql = query( $id, "SHOW TABLES FROM `".AlphanumericalClean($db)."`" );
if (sql_num_rows($act_sql) > 0) {
if((isset($type))) {
$file = $tmp["TMP_DIR"]."/db_".$_SERVER["SERVER_NAME"]."_".$dbtype."_".date("Y-m-d-H-i-s").".sql";
$fp = fopen($file, "w");
if (!$fp) {
return "<BR>Dump error! Can't write to ".htmlspecialchars($file);
}
fputs ($fp, "#~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n# [ SQL Client ]\n# Dumped by SQL Client \n#\n# SQL version: (".get_server_info().")\n# Date: ".date("F j, Y, g:i a")."\n# Dump DB: `$db`"."\n#~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n");
}
switch($type) {
case "struct":
while ($tbl = sql_fetch_row($act_sql)) {
fputs($fp, "\n#\n# Dump for table: `".$tbl[0]."`;\n#\n");
fputs($fp, "\nDROP TABLE IF EXISTS `".$tbl[0]."`;\n");
$sql = query( $id, "SHOW CREATE TABLE `$tbl[0]`");
$row = sql_fetch_row($sql);
fputs($fp, $row[1].";\n\n");
}
break;
case "data":
while ($tbl = sql_fetch_row($act_sql)) {
fputs($fp, "\n#\n# Dump for table: `".$tbl[0]."`;\n#\n");
$sql = query( $id, "SELECT * FROM `$tbl[0]`" );
if (sql_num_rows($sql) > 0) {
while ($row = sql_fetch_assoc($sql)) {
$keys = implode("`, `", array_keys($row));
$values = array_values($row);
foreach($values as $key=>$value) {
$values[$key] = addslashes($value);
}
$values = implode("', '", $values);
$sql_dump = "INSERT INTO `$tbl[0]` (`".$keys."`) VALUES ('".$values."');\n";
fputs($fp, $sql_dump);
}
} else {
fputs($fp, "# TABLE `$tbl[0]` IS AMPTY\n\n");
}
}
break;
case "full":
while ($tbl = sql_fetch_row($act_sql)) {
fputs($fp, "\n#\n# Dump for table: `".$tbl[0]."`;\n#\n");
fputs($fp, "\nDROP TABLE IF EXISTS `".$tbl[0]."`;\n");
$sql = query( $id, "SHOW CREATE TABLE `$tbl[0]`");
$row = sql_fetch_row($sql);
fputs($fp, $row[1].";\n\n");
$sql = query( $id, "SELECT * FROM `$tbl[0]`" );
if (sql_num_rows($sql) > 0) {
while ($row = sql_fetch_assoc($sql)) {
$keys = implode("`, `", array_keys($row));
$values = array_values($row);
foreach($values as $key=>$value) {
$values[$key] = addslashes($value);
}
$values = implode("', '", $values);
$sql_dump = "INSERT INTO `$tbl[0]` (`".$keys."`) VALUES ('".$values."');\n";
fputs($fp, $sql_dump);
}
} else {
fputs($fp, "# TABLE `$tbl[0]` IS AMPTY\n\n");
}
}
break;
default:
return "<BR><BR><B>Backup DataBase</B><BR><table><tr> <td><a href=\"".$baseurl."&act=10&dump=db&db=".$db."&type=full\">Full backup (Strukture and Data)</a></td></tr><tr> <td><a href=\"".$baseurl."&act=10&dump=db&db=".$db."&type=struct\">Only Structure</a></td></tr><tr> <td><a href=\"".$baseurl."&act=10&dump=db&db=".$db."&type=data\">Only data info</a></td></tr></table>";
break;
}
fclose($fp);
} else {
return "\n<BR><BR>Database ".AlphanumericalClean($db)." is empty or Database doesn't exist";
}
return "\n<BR><BR><font color=\"green\">Dumped! Dump has been writed to <a href=\"".$baseurl."&act=11&file=".urlencode(realpath($file))."\">".htmlspecialchars(realpath($file))."</a> (".formatsize(@filesize($file)).")</font><BR><BR>\n<img border=\"0\" src=\"".basename(__FILE__)."?image=download\"> <B>".$lang[$language.'_text26']."</B> <a href=\"".$baseurl."&act=12&file=".urlencode($file)."\">Click</a>";
}
/*
* SQL dump table
*/
function dump_tbl($id, $tbl, $type) {
global $lang,$language,$baseurl,$dbtype;
$tmp = server_info();
if((isset($type))) {
$file = $tmp["TMP_DIR"]."/tbl_".$_SERVER["SERVER_NAME"]."_".$dbtype."_".date("Y-m-d-H-i-s").".sql";
$fp = fopen($file, "w");
if (!$fp) {
return "<BR>Dump error! Can't write to ".htmlspecialchars($file);
}
fputs ($fp, "#~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n# [ SQL Client ]\n# Dumped by SQL Client \n#\n# SQL version: (".get_server_info().")\n# Date: ".date("F j, Y, g:i a")."\n# Dump table: `$tbl`"."\n#~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n");
}
switch($type) {
case "struct":
fputs($fp, "\nDROP TABLE IF EXISTS `".$tbl."`;\n");
$sql = query( $id, "SHOW CREATE TABLE `".$tbl."`");
$row = sql_fetch_row($sql);
fputs($fp, $row[1].";\n\n");
break;
case "data":
$sql = query( $id, "SELECT * FROM `".$tbl."`" );
if (sql_num_rows($sql) > 0) {
while ($row = sql_fetch_assoc($sql)) {
$keys = implode("`, `", array_keys($row));
$values = array_values($row);
foreach($values as $key=>$value) {
$values[$key] = addslashes($value);
}
$values = implode("', '", $values);
$sql_dump = "INSERT INTO `$tbl` (`".$keys."`) VALUES ('".$values."');\n";
fputs($fp, $sql_dump);
}
} else {
fputs($fp, "# TABLE `$tbl` IS AMPTY\n\n");
}
break;
case "full":
fputs($fp, "\nDROP TABLE IF EXISTS `".$tbl."`;\n");
$sql = query( $id, "SHOW CREATE TABLE `".$tbl."`");
$row = sql_fetch_row($sql);
fputs($fp, $row[1].";<BR><BR>");
$sql = query( $id, "SELECT * FROM `$tbl`" );
if (sql_num_rows($sql) > 0) {
while ($row = sql_fetch_assoc($sql)) {
$keys = implode("`, `", array_keys($row));
$values = array_values($row);
foreach($values as $key=>$value) {
$values[$key] = addslashes($value);
}
$values = implode("', '", $values);
$sql_dump = "INSERT INTO `$tbl` (`".$keys."`) VALUES ('".$values."');\n";
fputs($fp, $sql_dump);
}
} else {
fputs($fp, "# TABLE `$tbl` IS AMPTY\n\n");
}
break;
default:
return "\n<BR><BR><B>Backup Table</B><BR><table><tr> <td><a href=\"".$baseurl."&act=10&dump=tbl&tbl=".$tbl."&type=full\">Full backup (Strukture and Data)</a></td></tr><tr> <td><a href=\"".$baseurl."&act=10&dump=tbl&tbl=".$tbl."&type=struct\">Only Structure</a></td></tr><tr> <td><a href=\"".$baseurl."&act=10&dump=tbl&tbl=".$tbl."&type=data\">Only data info</a></td></tr></table>";
break;
}
fclose($fp);
return "\n<BR><BR><font color=\"green\">Dumped! Dump has been writed to <a href=\"".$baseurl."&act=11&file=".urlencode(realpath($file))."\">".htmlspecialchars(realpath($file))."</a> (".formatsize(@filesize($file)).")</font><BR><BR>\n<img border=\"0\" src=\"".basename(__FILE__)."?image=download\"> <B>".$lang[$language.'_text26']."</B> <a href=\"".$baseurl."&act=12&file=".urlencode($file)."\">Click</a>";
}
// Check Variables
if(isset($dbtype)) {
if($server) {
$server = AlphanumericalClean($server);
$baseurl .= "&server=".$server;
}
if($port) {
$port = intval($port);
$baseurl .= "&port=".AlphanumericalClean($port);
}
if(empty($login)) {
$login = 'nobody';
}
$login = AlphanumericalClean($login);
$baseurl .= "&login=".$login;
if($passwd) {
$password = AlphanumericalClean($password);
$baseurl .= "&password=".$password;
} else {
$baseurl .= "&password=";
}
if($db) {
$db = AlphanumericalClean($db);
$baseurl .= "&db=".$db;
}
$baseurl .= "&dbtype=".$dbtype;
// Return identificator
$id = sql_connect($server.":".$port, $login, $password, $db) or die("ERROR! Can't connect to SQL server");
} else {
die("<form method=\"post\">\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" height=\"100%\">\n<tr height=\"115\">\n <td height=\"115\" align=\"center\" valign=\"middle\"><center><h1>CL SQL Client Login</h1>\n<table border=\"0\" cellpadding=\"5\" cellspacing=\"3\">\n<tr>\n <td>Username:</td>\n <td><input type=\"text\" name=\"login\" value=\"\" size=\"24\"></td>\n</tr>\n<tr>\n <td>Password:</td>\n <td><input type=\"password\" name=\"password\" size=\"24\"></td>\n</tr>\n<tr>\n <td>Server IP:</td>\n <td><input type=\"text\" name=\"server\" value=\"localhost\" size=\"24\"></td>\n</tr>\n<tr>\n <td>Server Port:</td>\n <td><input type=\"text\" name=\"port\" value=\"3306\" size=\"24\"></td>\n</tr>\n<tr>\n <td>SQL Server (type):</td>\n <td><select name=\"dbtype\"><option value=\"mysql\">mySQL</option><option value=\"msql\">mSQL</option><option value=\"postgres\">PostgresSQL</option><option value=\"Interbase\">Interbase</option><option value=\"Sybase\">Sybase</option><option value=\"Sybase\">ODBC</option></select></td>\n</tr>\n<tr>\n <td colspan=\"2\" align=\"right\" valign=\"middle\"><input type=\"submit\" value=\"Login\"></td>\n</tr>\n</table>\n</center></td>\n</tr>\n</table>\n</form>");
}
//--------------------------------
// HTML header
//--------------------------------
//
echo "<html>\n<head>\n<title>[ CL SQL Client ]</title>\n<meta http-equiv=Content-Type Pragma: no-cache; content=\"text/html; charset=windows-1251\">\n<style>\n* {\n margin: 0;\n padding: 0;\n}\nbody {\n margin-top: 1px;\n margin-right: 1px;\n margin-bottom: 1px;\n margin-left: 1px;\n background-color: #CCCCCC;\n font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;\n font-size:12px;\n}
table {\n padding: 0em;\n font-size: 0.85em;\n background-color: #D7D8DA;\n}\ntr {\n font-size:12px;\n BORDER-RIGHT: #aaaaaa 1px solid;\n BORDER-TOP: #eeeeee 1px solid;\n BORDER-LEFT: #eeeeee 1px solid;\n BORDER-BOTTOM: #aaaaaa 1px solid;\n}\ntd {\n font-size:12px;\n BORDER-RIGHT: #aaaaaa 1px solid;\n BORDER-TOP: #eeeeee 1px solid;\n BORDER-LEFT: #eeeeee 1px solid;\n BORDER-BOTTOM: #aaaaaa 1px solid;\n}\na {\n color: #003366;\n text-decoration: none;\n}\na:hover {\n color: #003366;\n}\na img {\n border: none;\n}\ninput,textarea,select {\n font-family: Verdana, Tahoma, Helvetica, Arial, sans-serif;\n font-size: 1em;\n}\n</style>\n<script language=\"javascript\">function confirm_function(url) {\n if(confirm('Вы уверены?')){\n window.location = ''+url;\n }\n}</script></head>\n<body>\n".quicklaunch()."\n<table border=\"0\" width=\"960\">\n<tr align=\"center\" valign=\"top\">\n <td width=\"200\">".db_list($id)."</td>\n<td width=\"760\">\n<center>\n";
