Advertisement
Guest User

Untitled

a guest
Sep 6th, 2017
160
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.59 KB | None | 0 0
  1. <html>
  2. <head>
  3. <title>Dump DB - Scorpiol</title>
  4. <style type='text/css'>
  5. @import url(https://fonts.googleapis.com/css?family=Ubuntu);
  6. html {
  7. background: #000000;
  8. color: #ffffff;
  9. font-family: 'Ubuntu';
  10. font-size: 13px;
  11. width: 100%;
  12. }
  13. li {
  14. display: inline;
  15. margin: 5px;
  16. padding: 5px;
  17. }
  18. table, th, td {
  19. border-collapse:collapse;
  20. font-family: Tahoma, Geneva, sans-serif;
  21. background: transparent;
  22. font-family: 'Ubuntu';
  23. font-size: 13px;
  24. }
  25. .table_home, .th_home, .td_home {
  26. border: 1px solid #ffffff;
  27. }
  28. th {
  29. padding: 10px;
  30. }
  31. a {
  32. color: #ffffff;
  33. text-decoration: none;
  34. }
  35. a:hover {
  36. color: gold;
  37. text-decoration: underline;
  38. }
  39. b {
  40. color: gold;
  41. }
  42. input[type=text], input[type=password],input[type=submit] {
  43. background: transparent;
  44. color: #ffffff;
  45. border: 1px solid #ffffff;
  46. margin: 5px auto;
  47. padding-left: 5px;
  48. font-family: 'Ubuntu';
  49. font-size: 13px;
  50. }
  51. textarea {
  52. border: 1px solid #ffffff;
  53. width: 100%;
  54. height: 400px;
  55. padding-left: 5px;
  56. margin: 10px auto;
  57. resize: none;
  58. background: transparent;
  59. color: #ffffff;
  60. font-family: 'Ubuntu';
  61. font-size: 13px;
  62. }
  63. select {
  64. width: 152px;
  65. background: #000000;
  66. color: lime;
  67. border: 1px solid #ffffff;
  68. margin: 5px auto;
  69. padding-left: 5px;
  70. font-family: 'Ubuntu';
  71. font-size: 13px;
  72. }
  73. option:hover {
  74. background: lime;
  75. color: #000000;
  76. }
  77. </style>
  78. </head>
  79. <?php
  80. echo $head.'<p align="center">';
  81. echo '
  82. <form action method=post>
  83. <table width=371 class=tabnet>
  84. <tr><th colspan="2">Dump DB</th></tr>
  85. <tr>
  86. <td>Server </td>
  87. <td><input type=text name=server size=52></td></tr><tr>
  88. <td>Username</td>
  89. <td><input type=text name=username size=52></td></tr><tr>
  90. <td>Password</td>
  91. <td><input type=text name=password size=52></td></tr><tr>
  92. <td>DataBase Name</td>
  93. <td><input type=text name=dbname size=52></td></tr>
  94. <tr>
  95. <td>DB Type </td>
  96. <td><form method=post action="'.$me.'">
  97. <select name=method>
  98. <option value="gzip">Gzip</option>
  99. <option value="sql">Sql</option>
  100. </select>
  101. <input type=submit value="Dump!" ></td></tr>
  102. </form></center></table>';
  103. if ($_POST['username'] && $_POST['dbname'] && $_POST['method']){
  104. $date = date("Y-m-d");
  105. $dbserver = $_POST['server'];
  106. $dbuser = $_POST['username'];
  107. $dbpass = $_POST['password'];
  108. $dbname = $_POST['dbname'];
  109. $file = "Dump-$dbname-$date";
  110. $method = $_POST['method'];
  111. if ($method=='sql'){
  112. $file="Dump-$dbname-$date.sql";
  113. $fp=fopen($file,"w");
  114. }else{
  115. $file="Dump-$dbname-$date.sql.gz";
  116. $fp = gzopen($file,"w");
  117. }
  118. function write($data) {
  119. global $fp;
  120. if ($_POST['method']=='ssql'){
  121. fwrite($fp,$data);
  122. }else{
  123. gzwrite($fp, $data);
  124. }}
  125. mysql_connect ($dbserver, $dbuser, $dbpass);
  126. mysql_select_db($dbname);
  127. $tables = mysql_query ("SHOW TABLES");
  128. while ($i = mysql_fetch_array($tables)) {
  129. $i = $i['Tables_in_'.$dbname];
  130. $create = mysql_fetch_array(mysql_query ("SHOW CREATE TABLE ".$i));
  131. write($create['Create Table'].";nn");
  132. $sql = mysql_query ("SELECT * FROM ".$i);
  133. if (mysql_num_rows($sql)) {
  134. while ($row = mysql_fetch_row($sql)) {
  135. foreach ($row as $j => $k) {
  136. $row[$j] = "'".mysql_escape_string($k)."'";
  137. }
  138. write("INSERT INTO $i VALUES(".implode(",", $row).");n");
  139. }
  140. }
  141. }
  142. if ($method=='ssql'){
  143. fclose ($fp);
  144. }else{
  145. gzclose($fp);}
  146. header("Content-Disposition: attachment; filename=" . $file);
  147. header("Content-Type: application/download");
  148. header("Content-Length: " . filesize($file));
  149. flush();
  150.  
  151. $fp = fopen($file, "r");
  152. while (!feof($fp))
  153. {
  154. echo fread($fp, 65536);
  155. flush();
  156. }
  157. fclose($fp);
  158. }
  159. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement