· 10 years ago · Mar 19, 2016, 05:27 AM
1<?php
2if (!isset($_POST['db_host'])) {
3 if(file_exists('../database/mysql.php')) {
4 $down_one = "yes";
5 require_once('../database/db.php');
6
7 if (isset($row_Config['installed'])) {
8 if ($row_Config['installed'] == '1') {
9 echo ("<script language=javascript>document.location.href = '../index.php'</script>");
10 }
11 }
12 }
13}
14?>
15<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
16<html>
17<head>
18<title>ZPanel</title>
19<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
20<link href="../default.css" rel="stylesheet" type="text/css">
21</head>
22
23<body bgcolor="#CCCCCC" topmargin="0">
24<div align="center">
25 <table width="780" border="0" align="center" cellpadding="0" cellspacing="0">
26 <!-- fwtable fwsrc="default.png" fwbase="default.gif" fwstyle="Dreamweaver" fwdocid = "742308039" fwnested="0" -->
27 <tr>
28 <td width="188"><img src="../images/templates/spacer.gif" width="188" height="1" border="0" alt=""></td>
29 <td width="243"><img src="../images/templates/spacer.gif" width="243" height="1" border="0" alt=""></td>
30 <td width="349"><img src="../images/templates/spacer.gif" width="349" height="1" border="0" alt=""></td>
31 </tr>
32 <tr>
33 <td rowspan="2"><img name="default_r1_c1" src="../images/templates/default_r1_c1.jpg" width="188" height="208" border="0" alt=""></td>
34 <td><img name="default_r1_c2" src="../images/templates/default_r1_c2.jpg" width="243" height="98" border="0" alt=""></td>
35 <td><img name="default_r1_c3" src="../images/templates/default_r1_c3.jpg" width="349" height="98" border="0" alt=""></td>
36 </tr>
37 <tr>
38 <td><img name="default_r2_c2" src="../images/templates/default_r2_c2.jpg" width="243" height="110" border="0" alt=""></td>
39 <td><img name="default_r2_c3" src="../images/templates/default_r2_c3.jpg" width="349" height="110" border="0" alt=""></td>
40 </tr>
41 <tr>
42 <td height="241" align="left" valign="top" background="../images/templates/default_r3_c1.gif" bgcolor="#FFFFFF" style="background-repeat:no-repeat"><br>
43 <br>
44 <ul>
45 <li><font color="#999999"><strong>Welcome to ZPanel</strong></font></li>
46 <li><strong><font color="#FF0000">Setup Database</font></strong></li>
47 <li><strong>Setup Admin</strong></li>
48 <li><strong>Setup System Info.</strong></li>
49 <li><strong>Customize Packages</strong></li>
50 <li><strong>Final Settings</strong></li>
51 <li><strong>Finished!</strong></li>
52 </ul>
53 <strong>Step 2 of 7</strong><br>
54 <table width="143" border="1" cellpadding="0" cellspacing="0" bordercolor="#000000" bgcolor="#F4F4F4">
55 <tr>
56 <td height="25" align="left" valign="top"><font color="#0000FF"><strong><font color="#FF0000">|||</font></strong></font><font color="#FF0000"><strong>||||||</strong></font><strong><font color="#FF0000">|||||||</font>||||||||||||||||||||||||||||||</strong></td>
57 </tr>
58 </table></td>
59 <td colspan="2" align="left" valign="top" bgcolor="#FFFFFF"><p><font size="4"><strong>Setup
60 2: Setup Database</strong></font></p>
61 <blockquote>
62<?php
63if (isset($_POST['inject'])){
64$host = $_POST['db_host'];
65$user = 'root';
66$pass = $_POST['db_pass'];
67$name = $_POST['db_name'];
68$db_prefix = "";
69$getconn = mysql_connect($host , $user , $pass);
70if (!isset($getconn)){
71 die ("Sorry, an error occured. Your login is incorrect.");
72}
73//Check if database exists
74if(mysql_select_db($name, $getconn)) {
75 echo '<center><font face="Verdana">Uh oh! That database already exists. Please select a new one.<br><br><a href=install2.php>Try Again..</a></font></center>';
76}else{
77
78//If the database doesn't exist then create it.
79$result = mysql_query('CREATE DATABASE ' . $name);
80
81 mysql_select_db($name, $getconn) or die ("Sorry, an error occured. Please check your database info is correct and make sure your database already exists!");
82
83//General secret key for this ZPanel install
84function str_makerand ($minlength, $maxlength) {
85 $charset = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789@#$%^*()+-={}|][";
86 if ($minlength > $maxlength) $length = mt_rand ($maxlength, $minlength);
87 else $length = mt_rand ($minlength, $maxlength);
88 for ($i=0; $i<$length; $i++) $key .= $charset[(mt_rand(0,(strlen($charset)-1)))];
89 return $key;
90}
91$secretkey = str_makerand('30','60');
92
93//Get the security key in place
94 $zpdir = strtolower(str_replace('\\', '/', getcwd()));
95 $zpdir = ereg_replace('/admin', '', $zpdir);
96
97 $fcontents = implode ('', file ($zpdir . '/database/db.php'));
98
99 $fcontents = str_replace('[zpanelpath]', $zpdir, $fcontents);
100 $fcontents = str_replace('[secretkey]', $secretkey, $fcontents);
101
102 $fp1 = fopen ($zpdir . '/database/db.php', "w+");
103 fwrite($fp1,$fcontents);
104 fclose($fp1);
105
106//Load Database
107 $query_Installers = sprintf("SELECT * FROM installers WHERE id = '1'", $colname_Installers);
108 $Installers = mysql_query($query_Installers, $getconn);
109 $row_Installers = mysql_fetch_assoc($Installers);
110 $totalRows_Installers = mysql_num_rows($Installers);
111
112 echo ('Creating Billing Database... ');
113 $query = "CREATE TABLE `billingbase` (
114 `id` int(11) NOT NULL auto_increment,
115 `servicename` varchar(100) NOT NULL default '',
116 `date` date NOT NULL default '0000-00-00',
117 `amount` mediumint(9) NOT NULL default '0',
118 `method` varchar(100) NOT NULL default '',
119 `currentbill` mediumint(9) NOT NULL default '0',
120 `debitorcredit` varchar(100) NOT NULL default '',
121 `service` varchar(100) NOT NULL default '',
122 `txn_id` varchar(100) default '',
123 PRIMARY KEY (`id`)
124 )";
125 $result = mysql_query($query);
126 echo ('Done<br>');
127
128 echo ('Creating Config Database... ');
129 $query = "CREATE TABLE `config` (
130 `server_pop` varchar(100) default '',
131 `server_smtp` varchar(100) default '',
132 `hide_asp` varchar(100) default '',
133 `admin_password` varchar(100) default '',
134 `admin_username` varchar(100) default '',
135 `admin_name` varchar(100) default '',
136 `company` varchar(100) default '',
137 `installed` varchar(100) default '0',
138 `support_link` varchar(100) default '',
139 `support_email` varchar(100) default '',
140 `email_admin` varchar(100) default '',
141 `email_webmail` varchar(100) default '',
142 `installdir` varchar(100) default '',
143 `rootdir` varchar(100) default '',
144 `broadcastmessage` blob default '',
145 `domainname` varchar(100) default '',
146 `language` varchar(100) default 'english.php',
147 `ftpserver` varchar(100) default 'ftp.zee-way.com',
148 `template` varchar(100) default 'ZPanelv25',
149 `paypalemail` varchar(100) default '',
150 `webaddy` varchar(100) default '',
151 `zpftp` varchar(100) default 'Off',
152 `version` varchar(100) default '2.5'
153 )";
154 $result = mysql_query($query);
155 echo ('Done<br>');
156
157 echo ('Creating Customer Database... ');
158 $query = "CREATE TABLE `custumerbase` (
159 `id` int(11) NOT NULL auto_increment,
160 `servicename` varchar(20) NOT NULL default '',
161 `name` varchar(50) default NULL,
162 `resetpass` varchar(50) default NULL,
163 `Rank` varchar(10) NOT NULL default 'User',
164 `email` varchar(100) default NULL,
165 `adminemail` varchar(100) default NULL,
166 `ftppass` varchar(100) NOT NULL default '',
167 `address` varchar(100) default NULL,
168 `city` varchar(20) default NULL,
169 `state` varchar(5) default NULL,
170 `zip` varchar(10) default NULL,
171 `phone` varchar(50) default NULL,
172 `webservice` varchar(50) default NULL,
173 `mailservice` varchar(50) default NULL,
174 `gameservice` varchar(50) default NULL,
175 `stats_installed` varchar(100) default NULL,
176 `status` varchar(20) default NULL,
177 `homedir` varchar(100) default '',
178 `ftpaccounts` varchar(100) default NULL,
179 `mysqluser` varchar(20) default NULL,
180 `mysqlpass` varchar(20) default NULL,
181 `mysqldatabases` varchar(100) default NULL,
182 `notes` longtext,
183 `PaidTill` date default '0000-00-00',
184 `lost_key` varchar(60) default '0',
185 `lost_date` datetime default '0000-00-00 00:00:00',
186 `gameserver` varchar(50) default NULL,
187 `gameserverport` varchar(20) default NULL,
188 `url` varchar(200) default NULL,
189 `unansweredpm` tinyint(1) default '0',
190 `ftpuser` tinyint(1) default '0',
191 `ftpowner` varchar(100) default NULL,
192 `theme` varchar(100) default NULL,
193 PRIMARY KEY (`id`),
194 UNIQUE KEY `servicename` (`servicename`)
195 )";
196 $result = mysql_query($query);
197 echo ('Done<br>');
198
199///////////////////////////////////////////////
200// Commented by kanderson
201// Reason: the new "fantastico" way of installing that was implimented
202// reopened the code for BETA 9, as the "fantastico" coding is not complete
203///////////////////////////////////////////////
204 echo ('Creating Installers Database... ');
205 $query = "CREATE TABLE `installers` (
206 `id` int(11) NOT NULL auto_increment,
207 `name` varchar(100) NOT NULL default '',
208 `shortname` varchar(100) NOT NULL default '',
209 `website` varchar(100) default '',
210 `scripttype` varchar(100) default '',
211 `installer-path` varchar(100) NOT NULL default '',
212 `filepath` varchar(100) NOT NULL default '',
213 `icon` varchar(100) default '',
214 `welcome` varchar(100) default '',
215 `silent` tinyint(1) NOT NULL default '1',
216 `instructions` text,
217 `finalmessage` text,
218 `exampledir` varchar(100) default '',
219 PRIMARY KEY (`id`)
220 )";
221 $result = mysql_query($query);
222 echo ('Done<br>');
223// end commented
224
225 echo ('Creating Packages Database... ');
226 $query = "CREATE TABLE `packages` (
227 `package_name` varchar(100) default '',
228 `package_type` varchar(100) default '',
229 `package_quota` varchar(100) default '',
230 `package_mo_price` varchar(100) default '',
231 `id` int(11) NOT NULL auto_increment,
232 `maxftp` varchar(100) default '',
233 `maxmail` varchar(100) default '',
234 `maxsql` varchar(100) default '',
235 PRIMARY KEY (`id`)
236 )";
237 $result = mysql_query($query);
238 echo ('Done<br>');
239
240 echo ('Creating Private Messages Database... ');
241 $query = "CREATE TABLE `privatemessages` (
242 `messageid` int(11) NOT NULL auto_increment,
243 `whoto` varchar(100) default 'Unknown',
244 `whofrom` varchar(100) default 'Unknown',
245 `message` blob,
246 `subject` varchar(100) default '<i>[No Subject]</i>',
247 `beenread` tinyint(1) default '0',
248 `timestamp` varchar(100) NOT NULL,
249 PRIMARY KEY (`messageid`)
250 )";
251 $result = mysql_query($query);
252 echo ('Done<br>');
253
254 echo ('Creating Buddy List Database... ');
255 $query = "CREATE TABLE `buddylists` (
256 `buddyid` int(11) NOT NULL auto_increment,
257 `listowner` varchar(100) default '',
258 `buddy` varchar(100) default '',
259 PRIMARY KEY (`buddyid`)
260 )";
261 $result = mysql_query($query);
262 echo ('Done<br>');
263
264 echo ('Creating Modules Database... ');
265 $query = "CREATE TABLE `modules` (
266 `name` varchar(100) NOT NULL default '',
267 `active` varchar(100) default '',
268 `permissions` varchar(100) default '',
269 `title` varchar(100) default '',
270 `icon` varchar(100) default '',
271 PRIMARY KEY (`name`)
272 )";
273 $result = mysql_query($query);
274 echo ('Done<br>');
275
276 echo ('Creating Client Tracking Database... ');
277 $query = "CREATE TABLE `execlients` (
278 `sessionid` varchar(100) NOT NULL default '',
279 `username` varchar(100) default '',
280 `browser` varchar(100) default '',
281 `hostname` varchar(100) default '',
282 `os` varchar(100) default '',
283 `viewing` varchar(100) default '',
284 `client` varchar(100) default '',
285 `lastaccess` varchar(100) default '',
286 `ip` varchar(100) default '',
287 PRIMARY KEY (`sessionid`)
288 )";
289 $result = mysql_query($query);
290 echo ('Done<br>');
291
292 echo ('Creating Ticket System Tables... ');
293 $query = "CREATE TABLE `ticket_assign` (
294 `ticketid` int(11) NOT NULL default '0',
295 `post` int(11) NOT NULL default '0',
296 PRIMARY KEY (`post`,`ticketid`)
297 )";
298 $result = mysql_query($query);
299 $query = "CREATE TABLE `ticket_posts` (
300 `id` int(11) NOT NULL auto_increment,
301 `user` varchar(100) NOT NULL default '',
302 `message` blob NOT NULL,
303 `ip` varchar(100) NOT NULL default '',
304 `date` varchar(100) NOT NULL default '',
305 `time` varchar(100) NOT NULL default '',
306 PRIMARY KEY (`id`)
307 )";
308 $result = mysql_query($query);
309 $query = "CREATE TABLE `tickets_tix` (
310 `id` int(11) NOT NULL auto_increment,
311 `user` varchar(100) NOT NULL default '',
312 `assignedto` varchar(100) default '',
313 `origindate` varchar(100) default '',
314 `update` varchar(100) default '',
315 `ipaddress` varchar(100) NOT NULL default '',
316 `status` varchar(100) NOT NULL default 'Open',
317 `message` blob NOT NULL,
318 PRIMARY KEY (`id`)
319 )";
320 $result = mysql_query($query);
321 echo ('Done<br>');
322
323 echo ('Inserting defaults into the database... ');
324 $query = "INSERT INTO `billingbase` VALUES (1, 'demo', '2003-08-10', 15, 'Paypal', 20, 'Basic Web Hosting', NULL)";
325 $result = mysql_query($query);
326 $query = "INSERT INTO `config` VALUES ('mail.zee-way.com', 'mail.zee-way.com', 'yes', '".md5('Admin')."', 'Test', 'Test Admin', 'Zee-Way Services', '0', 'http://www.zee-way.com/contact.php', 'support@zee-way.com', 'http://mail.zee-way.com:1000', 'http://mail.zee-way.com:3000', '".$zpdir."', NULL, NULL, 'zee-way.com', 'english.php', 'ftp.zee-way.com', 'ZPanelv25', '', 'http://yourdomain.com/zpanel', 'Off', '2.5')";
327 $result = mysql_query($query);
328 $query = "INSERT INTO `custumerbase` (servicename,name,resetpass,Rank,email,adminemail,ftppass,address,city,state,zip,phone,webservice,mailservice,gameservice,stats_installed,status,homedir,ftpaccounts,mysqluser,mysqlpass,mysqldatabases,notes,PaidTill,lost_key,lost_date,gameserver,gameserverport,url,unansweredpm,ftpuser,ftpowner,theme) VALUES ('demo', 'Demo User', NULL, 'User', 'demo@zee-way.com', NULL, '".md5('demo')."', NULL, NULL, NULL, NULL, NULL, 'Basic', NULL, NULL, NULL, 'Active', 'd:/wwwroot/hosted/demo', NULL, 'demo', 'demo', 'demo-1,demo-2', NULL, '0000-00-00', '0', '0000-00-00 00:00:00', NULL, NULL, 'http://demo.yourdomain.com', 0, 0, NULL, NULL)";
329 $result = mysql_query($query);
330 $query = "INSERT INTO `installers` VALUES (1, 'PHP-Nuke 7.2', 'PHP-Nuke', 'http://www.phpnuke.org', 'PHP', 'install-phpnuke.php', '%installdir%/installers/phpnuke72/', 'images/icons/addon.gif', 'Already installed PHP-Nuke and need to setup or upgrade your database?', 1, '<ol><li><font size=2>Login to your FTP account and edit config.php, in the PHP-Nuke directory.</font></li><li><font size=2>Login to phpMyAdmin through the MySQL page and use %dir%/nuke.sql to load your database. If you are UPGRADING then please view your %dir/upgrades folder and run the updater for your version.</a></font></li></ol>', 'Great, your PHP-Nuke has been installed!<br><br>Please follow the steps below to finish setting up your PHP-Nuke<br><br><a href=?page=install>Done...</a><br>', 'nuke')";
331 $result = mysql_query($query);
332 $query = "INSERT INTO `installers` VALUES (2, 'paFileDB 3', 'paFileDB', 'http://www.phparena.net/pafiledb.php', 'PHP', '', '%installdir%/installers/pafiledb/', 'images/icons/addon.gif', '', 1, NULL, 'Great, your paFileDB has been installed!<br><br>Administer your downloads at <a href=http://%url%/%dir%/install.php target=_blank>http://%url%/%dir%/install.php</a>', 'downloads')";
333 $result = mysql_query($query);
334 $query = "INSERT INTO `installers` VALUES (3, 'FusionNews 3.6.1', 'FusionNews', 'http://www.fusionphp.net/index.php?id=fnews/fn_features', 'PHP', '', '%installdir%/installers/fusionnews/', 'images/icons/addon.gif', NULL, 1, NULL, 'Great, your FusionNews has been installed!<br><br>Administer your forum at <a href=http://%url%/%dir%/installer.php target=_blank>http://%url%/%dir%/installer.php</a>', 'news')";
335 $result = mysql_query($query);
336 $query = "INSERT INTO `installers` VALUES (4, 'Aardvark TopSites 4.1.1', 'TopSites', 'http://www.aardvarkind.com/index.php?page=topsitesphp', 'PHP', '', '%installdir%/installers/topsitesphp/', 'images/icons/addon.gif', NULL, 1, NULL, 'Great, your Aardvark Topsites has been installed!<br><br>Administer your topsites at <a href=http://%url%/%dir%/install.php target=_blank>http://%url%/%dir%/install.php</a>', 'topsites')";
337 $result = mysql_query($query);
338 $query = "INSERT INTO `installers` VALUES (5, 'phpBB Forums 2.0.8a', 'phpBB', 'http://www.phpbb.com', 'PHP', '', '%installdir%/installers/phpBB2/', 'images/icons/forum.gif', NULL, 1, NULL, 'Great, your phpBB has been installed!<br><br>Administer your forum at <a href=http://%url%/%dir%/ target=_blank>http://%url%/%dir%/</a>', 'forums')";
339 $result = mysql_query($query);
340 $query = "INSERT INTO `installers` VALUES (6, 'MaxWebPortal 1.33', 'MaxWebPortal', 'http://www.maxwebportal.com/', 'ASP', '', '%installdir%/installers/MaxWebPortal/', 'images/icons/addon.gif', 'Already installed MaxWebPortal and need to setup?', 1, '<ol>\n <li><font size=2>Login to your FTP account and open config.asp, in the MaxWebPortal \n directory.</font></li>\n <li><font size=2>On line 42</font></li>\n </ol>\n <ul>\n <li><font size=2><strong>Find:</strong> strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data \n Source=D:\\wwwroot\\hosted\\YOUR-SERVICE-NAME\\MaxWebPortal\\database\\db2000.mdb" \n \'## MS Access 2000</font></li>\n <li><font size=2><strong>Replace with: </strong>strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data \n Source=D:\\wwwroot\\hosted\\%username%\\%dir%\\database\\db2000.mdb" \'## MS Access 2000</font></li>\n </ul>', 'Great, your MaxWebPortal has been installed!<br><br>Please follow the steps below to finish setting up your MaxWebPortal<br><br><a href=page=install>Done...</a>', 'portal')";
341 $result = mysql_query($query);
342 $query = "INSERT INTO `installers` VALUES (7, 'Snitz Forums 2000 3.4.04', 'Snitz', 'http://forum.snitz.com', 'ASP', '', '%installdir%/installers/snitzforums2000/', 'images/icons/forum.gif', NULL, 1, NULL, 'Great, your Snitz Forum has been installed!<br><br>Administer your forum at <a href=http://%url%/%dir%/setup.asp target=_blank>http://%url%/%dir%/setup.asp</a>', 'forums')";
343 $result = mysql_query($query);
344 $query = "INSERT INTO `installers` VALUES (8, 'phpOpenChat', 'phpOpenChat', 'http://phpopenchat.org/', 'PHP', '', '%installdir%/installers/phpopenchat/', 'images/icons/chat.gif', 'Already installed phpOpenChat and just need to set it up?', 1, '1. Import PHPOpenChat\'s database-schema db.schema.txt into your MySQL database.<br>\n<br>\n2. Change configuration settings in config.inc.php<br>\n - the hostname, where the database runs<br>\n define(\'DATABASE_HOST\',\'localhost\');<br>\n - the database user with proper access rights<br>\n define(\'DATABASE_USER\',\'\');<br>\n - the password of this database user<br>\n define(\'DATABASE_PASSWORD\',\'\');<br>\n - the name of your created database which will contain your sql-tables (In other cases than mysql, it may be called \'tablespace\')<br>\n define(\'DATABASE_TABLESPACE\',\'\');<br>', 'Great, your phpOpenChat has been installed!<br><br>Please follow the steps below to finish setting up your phpOpenChat<br><br><a href=page=install>Done...</a>', 'chats')";
345 $result = mysql_query($query);
346 $query = "INSERT INTO `packages` VALUES ('Basic', 'Web', '300', '10', 1, '5', '2', '3')";
347 $result = mysql_query($query);
348 $query = "INSERT INTO `packages` VALUES ('Advanced', 'Web', '800', '35', 2, '10', '5', '10')";
349 $result = mysql_query($query);
350 $query = "INSERT INTO `packages` VALUES ('Unlimited', 'Web', '100000', '100', 3, '100', '100', '100')";
351 $result = mysql_query($query);
352 $query = "INSERT INTO `modules` VALUES ('accountlookup', '1', '3', 'Account Lookup', 'images/icons/passprotection.gif')";
353 $result = mysql_query($query);
354 $query = "INSERT INTO `modules` VALUES ('billinginfo', '1', '4', 'Billing', 'images/icons/cgicenter.gif')";
355 $result = mysql_query($query);
356 $query = "INSERT INTO `modules` VALUES ('diskusage', '1', '4', 'Disk Usage', 'images/icons/usage.gif')";
357 $result = mysql_query($query);
358 $query = "INSERT INTO `modules` VALUES ('email', '1', '4', 'E-Mail', 'images/icons/email.gif')";
359 $result = mysql_query($query);
360 $query = "INSERT INTO `modules` VALUES ('helpfulscripts', '1', '4', 'Helpful Scripts', 'images/icons/webftpstats.gif')";
361 $result = mysql_query($query);
362 $query = "INSERT INTO `modules` VALUES ('mailinglist', '1', '1', 'Mass E-Mail', 'images/icons/email.gif')";
363 $result = mysql_query($query);
364 $query = "INSERT INTO `modules` VALUES ('mysql', '1', '4', 'MySQL', 'images/icons/mysql.gif')";
365 $result = mysql_query($query);
366 $query = "INSERT INTO `modules` VALUES ('nettools', '1', '4', 'Network Tools', 'images/icons/nettools.gif')";
367 $result = mysql_query($query);
368 $query = "INSERT INTO `modules` VALUES ('privatemessage', '1', '4', 'Private Messages', 'images/icons/chat.gif')";
369 $result = mysql_query($query);
370 $query = "INSERT INTO `modules` VALUES ('profile', '1', '4', 'Your Profile', 'images/icons/profile.gif')";
371 $result = mysql_query($query);
372 $query = "INSERT INTO `modules` VALUES ('serverinfo', '1', '4', 'Server Information', 'images/icons/windows.gif')";
373 $result = mysql_query($query);
374 $query = "INSERT INTO `modules` VALUES ('serverstatus', '1', '4', 'Server Status', 'images/icons/status.gif')";
375 $result = mysql_query($query);
376 $query = "INSERT INTO `modules` VALUES ('bulletinboard', '1', '4', 'Bulletin Board', 'images/icons/forum.gif')";
377 $result = mysql_query($query);
378 $query = "INSERT INTO `modules` VALUES ('installchat', '1', '4', 'Install Chat', 'images/icons/addon.gif')";
379 $result = mysql_query($query);
380 $query = "INSERT INTO `modules` VALUES ('install', '1', '4', 'Install', 'images/icons/addon.gif')";
381 $result = mysql_query($query);
382 $query = "INSERT INTO `modules` VALUES ('popularity', '1', '4', 'Site Popularity', 'images/icons/hotlink.gif')";
383 $result = mysql_query($query);
384
385 echo ('Done<br>');
386
387 $filename = '../database/mysql.php'; //your mysql info file
388
389 // clear config file
390 $fp = fopen($filename,"w");
391 fclose($fp);
392
393 // Write out the config file.
394 $config_data = '<?php'."\n\n";
395 $config_data .= "\n// ZPanel auto-generated config file\n// Do not change anything in this file!\n\n";
396 $config_data .= 'if (isset($zpaneldirectory)) {'."\n";
397 $config_data .= 'if ($_SERVER[\'PHP_SELF\'] != \'mysql.php\') {'."\n";
398 $config_data .= '$cwd = strtolower(str_replace(\'\\\\\', \'/\', getcwd()));'."\n";
399 $config_data .= '$zpdir = strtolower(str_replace(\'\\\\\',\'/\',$zpaneldirectory));'."\n";
400 $config_data .= '$zpcount = strlen($zpdir);'."\n";
401 $config_data .= 'if (substr($cwd, 0, $zpcount) == $zpdir) {'."\n\n";
402 $config_data .= '$db_host = \'' . $host . '\';' . "\n";
403 $config_data .= '$db_name = \'' . $name . '\';' . "\n";
404 $config_data .= '$db_user = \'' . $user . '\';' . "\n";
405 $config_data .= '$db_pass = \'' . $pass . '\';' . "\n\n";
406 $config_data .= '}else{'."\n";
407 $config_data .= 'die (\'Hacking Attempt - ID #3\'); }'."\n";
408 $config_data .= '}else{'."\n";
409 $config_data .= 'die (\'Hacking Attempt - ID #2\'); }'."\n";
410 $config_data .= '}else{'."\n";
411 $config_data .= 'die (\'Hacking Attempt - ID #1\');'."\n";
412 $config_data .= "}\n";
413 $config_data .= '?' . '>'; // Done this to prevent highlighting editors getting confused!
414
415 if (is_writable($filename)) {
416 $handle = fopen($filename, 'a');
417
418 if (!$handle = fopen($filename, 'a')) {
419 die ("Cannot open file ($filename)");
420 exit;
421 }
422 if (!fwrite($handle, $config_data)) {
423 die ("Cannot write to file ($filename)");
424 exit;
425 }
426 print "Success, wrote your configs to file ($filename)";
427 fclose($handle);
428 } else {
429 print "The file $filename is not writable";
430 }
431
432 echo ("<script language=javascript>document.location.href = 'install3.php'</script>");
433}
434}else{
435?>
436<form name="form1" method="post" action="install2.php">
437 <div align="right">
438 <table width="100%" border="0" cellspacing="0" cellpadding="3">
439 <tr align="left" valign="top">
440 <td width="19%"><img src="../images/install-welcome.gif" width="118" height="110"></td>
441 <td width="81%"><p align="center">This <strong>MUST </strong>be your root username and password.</p>
442 <table width="291" border="1" align="center" cellpadding="0" cellspacing="0">
443 <tr>
444 <td width="141" bordercolor="#000000"><font color="#000000"><strong>MySQL Information</strong></font></td>
445 <td width="144" bordercolor="#FFFFFF"><font size="2"> </font></td>
446 </tr>
447 <tr>
448 <td bordercolor="#000000" bgcolor="#3399CC"><font color="#FFFFFF" size="2"><strong> Server ($db_host):</strong></font></td>
449 <td bordercolor="#CCCCCC"><font size="2">
450 <input name="db_host" type="text" id="db_host" value="localhost"></font></td>
451 </tr>
452 <tr>
453 <td bordercolor="#000000" bgcolor="#3399CC"><font color="#FFFFFF" size="2"><strong>Username ($db_user): </strong></font></td>
454 <td bordercolor="#CCCCCC"><input name="db_root" type="text" id="db_root"></td>
455 </tr>
456 <tr>
457 <td bordercolor="#000000" bgcolor="#3399CC"><font color="#FFFFFF" size="2"><strong>Password ($db_pass): </strong></font></td>
458 <td bordercolor="#CCCCCC"><input name="db_pass" type="text" id="db_pass"></td>
459 </tr>
460 <tr>
461 <td bordercolor="#000000" bgcolor="#3399CC"><font color="#FFFFFF" size="2"><strong>Database ($db_name): </strong></font></td>
462 <td bordercolor="#CCCCCC"><input name="db_name" type="text" id="db_name"></td>
463 </tr>
464 </table>
465 </td>
466 </tr>
467 </table>
468 <p>
469 <input name="db_user" type="hidden" id="db_user" value="root">
470 <input name="inject" type="hidden" value="NOW">
471 <input class="inputbox" type="submit" name="Submit" value="Continue">
472 </p>
473 </div>
474 </form>
475 </blockquote>
476 <?php }?></td>
477 </tr>
478 <tr align="center" valign="bottom">
479 <td height="43" colspan="3" bgcolor="#FFFFFF" style="background-repeat:no-repeat"><img src="../images/templates/default_footer.gif" width="780" height="35" border="0" usemap="#Map"></td>
480 </tr>
481 </table>
482</div>
483<map name="Map">
484 <area shape="rect" coords="546,5,776,29" href="http://www.zee-way.com" target="_blank">
485</map>
486</body>
487</html>