echo ('Creating Billing Database... ');
$query = "CREATE TABLE `billingbase` (
`id` int(11) NOT NULL auto_increment,
`servicename` varchar(100) NOT NULL default '',
`date` date NOT NULL default '0000-00-00',
`amount` mediumint(9) NOT NULL default '0',
`method` varchar(100) NOT NULL default '',
`currentbill` mediumint(9) NOT NULL default '0',
`debitorcredit` varchar(100) NOT NULL default '',
`service` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`)
)";
$result = mysql_query($query);
echo ('Done<br>');
echo ('Creating Config Database... ');
$query = "CREATE TABLE `config` (
`server_pop` varchar(100) default '',
`server_smtp` varchar(100) default '',
`hide_asp` varchar(100) default '',
`admin_password` varchar(100) default '',
`admin_username` varchar(100) default '',
`admin_name` varchar(100) default '',
`company` varchar(100) default '',
`installed` varchar(100) default '0',
`support_link` varchar(100) default '',
`support_email` varchar(100) default '',
`email_admin` varchar(100) default '',
`email_webmail` varchar(100) default '',
`installdir` varchar(100) default '',
`broadcastmessage` varchar(100) default '',
`domainname` varchar(100) default '',
`language` varchar(100) default 'english.php',
`ftpserver` varchar(100) default 'ftp.zee-way.com',
`template` varchar(100) default 'ZPanelV2'
)";
$result = mysql_query($query);
echo ('Done<br>');
echo ('Creating Customer Database... ');
$query = "CREATE TABLE `custumerbase` (
`id` int(11) NOT NULL auto_increment,
`servicename` varchar(20) NOT NULL default '',
`name` varchar(50) default NULL,
`Rank` varchar(10) NOT NULL default 'User',
`email` varchar(100) default NULL,
`adminemail` varchar(100) default NULL,
`ftppass` varchar(100) NOT NULL default '',
`address` varchar(100) default NULL,
`city` varchar(20) default NULL,
`state` varchar(5) default NULL,
`zip` varchar(10) default NULL,
`phone` varchar(50) default NULL,
`webservice` varchar(50) default NULL,
`mailservice` varchar(50) default NULL,
`gameservice` varchar(50) default NULL,
`stats_installed` varchar(100) default NULL,
`status` varchar(20) default NULL,
`homedir` varchar(100) default '',
`ftpaccounts` varchar(100) default NULL,
`mysqluser` varchar(20) default NULL,
`mysqlpass` varchar(20) default NULL,
`mysqldatabases` varchar(100) default NULL,
`notes` longtext,
`PaidTill` date default '0000-00-00',
`lost_key` varchar(60) default '0',
`lost_date` datetime default '0000-00-00 00:00:00',
`gameserver` varchar(50) default NULL,
`gameserverport` varchar(20) default NULL,
`url` varchar(200) default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `servicename` (`servicename`)
)";
$result = mysql_query($query);
echo ('Done<br>');
echo ('Creating Installers Database... ');
$query = "CREATE TABLE `installers` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`shortname` varchar(100) NOT NULL default '',
`website` varchar(100) default '',
`scripttype` varchar(100) default '',
`installer-path` varchar(100) NOT NULL default '',
`filepath` varchar(100) NOT NULL default '',
`icon` varchar(100) default '',
`welcome` varchar(100) default '',
`silent` tinyint(1) NOT NULL default '1',
`instructions` text,
`finalmessage` text,
`exampledir` varchar(100) default '',
PRIMARY KEY (`id`)
)";
$result = mysql_query($query);
echo ('Done<br>');
echo ('Creating Packages Database... ');
$query = "CREATE TABLE `packages` (
`package_name` varchar(100) default '',
`package_type` varchar(100) default '',
`package_quota` varchar(100) default '',
`package_mo_price` varchar(100) default '',
`id` int(11) NOT NULL auto_increment,
`maxftp` varchar(100) default '',
`maxsql` varchar(100) default '',
PRIMARY KEY (`id`)
)";
$result = mysql_query($query);
echo ('Done<br>');
echo ('Creating Private Messages Database... ');
$query = "CREATE TABLE `privatemessages` (
`messageid` int(11) NOT NULL auto_increment,
`whoto` varchar(100) default NULL,
`whofrom` varchar(100) default NULL,
`message` text,
`timestamp` timestamp(14) NOT NULL,
PRIMARY KEY (`messageid`)
)";
$result = mysql_query($query);
echo ('Done<br>');
echo ('Creating Buddy List Database... ');
$query = "CREATE TABLE `buddylists` (
`buddyid` int(11) NOT NULL auto_increment,
`listowner` varchar(100) default '',
`buddy` varchar(100) default '',
PRIMARY KEY (`buddyid`)
)";
$result = mysql_query($query);
echo ('Done<br>');
echo ('Inserting defaults into the database... ');
$query = "INSERT INTO `billingbase` VALUES (1, 'demo', '2003-08-10', 15, 'Paypal', 20, 'Basic Web Hosting')";
$result = mysql_query($query);
$query = "INSERT INTO `config` VALUES ('mail.zee-way.com', 'mail.zee-way.com', 'yes', 'Admin', 'Test', 'Test Admin', 'Zee-Way Services', '0', 'http://www.zee-way.com/contact.php', 'support@zee-way.com', 'http://mailadmin.zee-way.com', 'http://mail.zee-way.com', 'd:/wwwroot/cpanel', NULL, 'zee-way.com', 'english.php', 'ftp.zee-way.com', 'ZPanelV2')";
$result = mysql_query($query);
$query = "INSERT INTO `custumerbase` VALUES (9, 'demo', 'Demo User', 'User', 'demo@zee-way.com', NULL, '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')";
$result = mysql_query($query);
$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=install.php>Done...</a><br>', 'nuke')";
$result = mysql_query($query);
$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')";
$result = mysql_query($query);
$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')";
$result = mysql_query($query);
$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')";
$result = mysql_query($query);
$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')";
$result = mysql_query($query);
$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=install.php>Done...</a>', 'portal')";
$result = mysql_query($query);
$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')";
$result = mysql_query($query);
$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=install.php>Done...</a>', 'chats')";
$result = mysql_query($query);
$query = "INSERT INTO `packages` VALUES ('Basic', 'Web', '300', '10', 1, '5', '2')";
$result = mysql_query($query);
$query = "INSERT INTO `packages` VALUES ('Advanced', 'Web', '800', '35', 2, '10', '5')";
$result = mysql_query($query);
$query = "INSERT INTO `packages` VALUES ('Expert', 'Web', '1300', '50', 3, '20', '6')";
$result = mysql_query($query);
$query = "INSERT INTO `packages` VALUES ('Unlimited', 'Web', '7000', '0', 4, '1000', '1000')";
$result = mysql_query($query);
echo ('Done<br>');
$filename = '../database/mysql.php'; //your mysql info file
// clear config file
$fp = fopen($filename,"w");
fclose($fp);
// Write out the config file.
$config_data = '<?php'."\n\n";
$config_data .= "\n// ZPanel auto-generated config file\n// Do not change anything in this file!\n\n";
$config_data .= '$db_host = \'' . $host . '\';' . "\n";
$config_data .= '$db_name = \'' . $name . '\';' . "\n";
$config_data .= '$db_user = \'' . $user . '\';' . "\n";
$config_data .= '$db_pass = \'' . $pass . '\';' . "\n\n";
$config_data .= '?' . '>'; // Done this to prevent highlighting editors gettin
query = "CREATE TABLE `privatemessages` (
`messageid` int(11) NOT NULL auto_increment,
`whoto` varchar(100) default NULL,
`whofrom` varchar(100) default NULL,
`message` text,
`timestamp` timestamp(14) NOT NULL,
PRIMARY KEY (`messageid`)
)";
$result = mysql_query($query);
echo ('Done<br>');
echo ('Creating Buddy List Database... ');
$query = "CREATE TABLE `buddylists` (
`buddyid` int(11) NOT NULL auto_increment,
`listowner` varchar(100) default '',
`buddy` varchar(100) default '',
PRIMARY KEY (`buddyid`)
)";
$result = mysql_query($query);
echo ('Done<br>');
echo ('Updating Billing Database... ');
$query = "ALTER TABLE billingbase ADD debitorcredit VARCHAR(100) NOT NULL DEFAULT ''";
$result = mysql_query($query);
echo ('Done<br>');
echo ('Updating Config Database... ');
$query = "ALTER TABLE config ADD language VARCHAR(100) DEFAULT 'english.php'";
$result = mysql_query($query);
$query = "ALTER TABLE config ADD ftpserver VARCHAR(100) DEFAULT 'ftp.zee-way.com'";
$result = mysql_query($query);
$query = "ALTER TABLE config ADD template VARCHAR(100) DEFAULT 'ZPanelV2'";
$result = mysql_query($query);
echo ('Done<br>');
echo ('Updating Packages Database... ');
$query = "ALTER TABLE packages ADD package_mo_price VARCHAR(100) DEFAULT '1'";
$result = mysql_query($query);
$query = "ALTER TABLE packages ADD maxftp VARCHAR(100) DEFAULT '1'";
$result = mysql_query($query);
$query = "ALTER TABLE packages ADD maxsql VARCHAR(100) DEFAULT '1'";
$result = mysql_query($query);
echo ('Done<br>');
