· 9 years ago · Aug 02, 2017, 09:46 PM
1<?php
2
3/*
4 * FOR THE FOLLOWING, YOU SHOULD ONLY HAVE TO CHANGE
5 * THE DIRECTORY, NOT THE FILE NAMES!
6 */
7//The folder you want the folder to be created in.
8define("APACHE", 'E:\\xampp\\htdocs\\');
9//The folder with Filezilla-Server.exe in it
10define("FILEZILLA", 'E:\\xampp\\FileZillaFTP\\FileZilla Server.xml');
11
12if (isset($_POST['init'])) {
13
14 if (empty($_POST['adminpass'])) {
15 die("You were missing one of the required inputs!");
16 } else if (empty($_POST['folder'])) {
17 die("You were missing one of the required inputs!");
18 } else if (empty($_POST['adminuser'])) {
19 die("You were missing one of the required inputs!");
20 }
21
22 $adminpass = $_POST['adminpass'];
23 $adminuser = $_POST['adminuser'];
24
25 $folder = $_POST['folder'];
26
27 $mysqluser = $_POST['mysqluser'];
28 $mysqlpass = $_POST['mysqlpass'];
29 $fileuser = $_POST['fileuser'];
30 $filepass = $_POST['filepass'];
31
32 if (empty($mysqluser)) {
33 $mysqluser = $folder;
34 } else if (empty($mysqlpass)) {
35 $mysqlpass = $mysqluser;
36 } else if (empty($fileuser)) {
37 $fileuser = $folder;
38 } else if (empty($filepass)) {
39 $filepass = $filepass;
40 }
41
42
43 echo "Checking if the Apache folder is writable:<br/>";
44 if (is_writable(APACHE)) {
45 echo "<span style=\"background-color:green\">" . APACHE . " is writable.</span><br/>";
46 } else {
47 die("<span style=\"background-color:red\">" . APACHE . " wasn't writable!</span>");
48 }
49
50
51 echo "Checking if the Filezilla Server.xml file is writable.<br/>";
52 if (is_writable(FILEZILLA)) {
53 echo "<span style=\"background-color:green\">". FILEZILLA . " is writable.</span><br/>";
54 } else {
55 die("<span style=\"background-color:red\">" . FILEZILLA . " wasn't writable!</span>");
56 }
57
58
59 echo "Creating folder ". APACHE . "$folder<br/>";
60 mkdir(APACHE.$folder);
61 echo "<span style=\"background-color:green\">" . APACHE . "$folder was created!</span><br/>";
62
63
64 echo "Making sure the folder was created<br/>";
65 if (is_dir(APACHE.$folder)) {
66 echo "<span style=\"background-color:green\">Yes, it was.</span><br/>";
67 } else {
68 die("<span style=\"background-color:red\">I thought I created the folder, but it doesn't exist!</span>");
69 }
70
71
72 echo "Connecting to MySQL server `localhost`, with user `$adminuser`<br/>";
73 $link = mysql_connect("localhost", $adminuser, $adminpass);
74 if ($link) {
75 echo "<span style=\"background-color:green\">Successfully connected to MySQL server.</span><br/>";
76 } else {
77 die("<span style=\"background-color:red\">" . mysql_error($link) . "</span>");
78 }
79
80
81 echo "Adding user `$mysqluser` to server, with password `$mysqlpass`:<br/>";
82 $query = "CREATE USER `$mysqluser`@`localhost` IDENTIFIED BY `$mysqlpass`;
83 GRANT USAGE ON * . * TO '$mysqluser'@'localhost' IDENTIFIED BY '$mysqlpass' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;";
84 mysql_query($params);
85
86
87 echo "Creating database `$mysqluser`<br/>";
88 $query = "CREATE DATABASE IF NOT EXISTS `$mysqluser`";
89 mysql_query($query);
90
91
92 echo "Granting user privilages<br/>";
93 //$query = "GRANT ALL PRIVILEGES ON `$mysqluser` . * TO '$mysqluser'@'localhost';";
94 //mysql_query($query);
95
96
97
98 echo "Filezilla requires passwords to be encrypted. Encrypting...<br/>";
99 $filepass = md5($filepass);
100 echo "<span style=\"background-color:green\">Filezilla password is: $filepass</span><br/>";
101
102
103 echo "Now adding the user to " . FILEZILLA . "<br/>";
104
105
106 echo "<h1 style=\"color:blue\">SUCCESS =-]</h1>";
107
108
109 /*
110 echo "<span style=\"background-color:green\"></span><br/>";
111 echo "<span style=\"background-color:green\"></span><br/>";
112 echo "<span style=\"background-color:green\"></span><br/>";
113 echo "<span style=\"background-color:green\"></span><br/>";
114 echo "<span style=\"background-color:green\"></span><br/>";
115 echo "<span style=\"background-color:green\"></span><br/>";
116 echo "<span style=\"background-color:green\"></span><br/>";
117 echo "<span style=\"background-color:green\"></span><br/>";
118 echo "<span style=\"background-color:green\"></span><br/>";
119
120 die("<span style=\"background-color:red\"></span>");
121 die("<span style=\"background-color:red\"></span>");
122 die("<span style=\"background-color:red\"></span>");
123 die("<span style=\"background-color:red\"></span>");
124 die("<span style=\"background-color:red\"></span>");
125 die("<span style=\"background-color:red\"></span>");
126 die("<span style=\"background-color:red\"></span>");
127 die("<span style=\"background-color:red\"></span>");
128 die("<span style=\"background-color:red\"></span>");
129 die("<span style=\"background-color:red\"></span>");
130 die("<span style=\"background-color:red\"></span>");
131 */
132
133} else {
134?>
135<html>
136
137 <head>
138 <title>Script</title>
139 </head>
140
141 <body>
142
143 <form action='script.php' method='POST'>
144 <input type="hidden" name="init" value="1"/>
145 <table>
146
147 <tr>
148 <td>MySQL admin user</td>
149 <td><input name="adminuser" type="text" /></td>
150 </tr>
151
152 <tr>
153 <td>MySQL admin pass</td>
154 <td><input name="adminpass" type="password" /></td>
155 </tr>
156
157 <tr><td colspan="2"> </td></tr>
158
159 <tr>
160 <td>User's Apache folder</td>
161 <td><input name="folder" type="text" /></td>
162 </tr>
163
164 <tr><td colspan="2"> </td></tr>
165
166 <tr>
167 <td>MySQL username*</td>
168 <td><input name="mysqluser" type="text" /></td>
169 </tr>
170
171 <tr>
172 <td>MySQL password*</td>
173 <td><input name="mysqlpass" type="password" /></td>
174 </tr>
175
176 <tr><td colspan="2"> </td></tr>
177
178 <tr>
179 <td>Filezilla username*</td>
180 <td><input name="fileuser" type="text" /></td>
181 </tr>
182
183 <tr>
184 <td>Filezilla password*</td>
185 <td><input name="filepass" type="password" /></td>
186 </tr>
187
188 <tr>
189 <td colspan="2"><center>
190 <input name="submit" type="submit" />
191 </center></td>
192 </tr>
193
194 </table>
195 </form>
196
197 <p style="font-size: 11px;">* Leave blank to use the value of "User's Apache folder"</p>
198
199 </body>
200
201</html>
202<?php
203}