<?php session_start(); if (isset($_SESSION['step1'])) { header('location: step2.php'); } else { if (isset($_POST['host']) && isset($_POST['user']) && isset($_POST['pass']) && isset($_POST['db'])) { $db = verifyConnection($_POST['host'], $_POST['user'], $_POST['pass'], $_POST['db']); if ($db) { $file = '../includes/config.php'; $data = file_get_contents($file); //data conversion $old = array('{host}', '{user}', '{name}', '{pass}'); $new = array($_POST['host'], $_POST['user'], $_POST['db'], $_POST['pass']); $written = str_replace($old, $new, $data); $f = fopen($file, 'w'); fwrite($f, $written); fclose($f); //IMPLEMENT SQL TABLES & ROWS & DATA //banned_ips $db->query("CREATE TABLE `banned_ips` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `ip` varchar(20) COLLATE latin1_german2_ci NOT NULL,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci AUTO_INCREMENT=1 ;"); //cats $db->query("CREATE TABLE `cats` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `title` varchar(40) COLLATE latin1_german2_ci NOT NULL,\n `type` int(11) NOT NULL,\n `pos` int(11) NOT NULL,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci AUTO_INCREMENT=2 ;"); $db->query("INSERT INTO `cats` VALUES(1, 'Staff', 1, 1)"); $db->query("INSERT INTO `cats` VALUES(2, 'General', 0, 2)"); //config $db->query("CREATE TABLE `config` (\n `maintenance` int(11) NOT NULL DEFAULT '0',\n `floodlimit` int(11) NOT NULL DEFAULT '0',\n `lastset` int(11) NOT NULL,\n `postcount` int(11) NOT NULL,\n `reportforum` int(11) NOT NULL\n ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci;"); $db->query("INSERT INTO `config` VALUES(0, 15, 1340316455, 0, 2);"); //dailyscreenshots $db->query("CREATE TABLE `dailyscreenshots` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `filename` varchar(54) NOT NULL,\n `caption` text NOT NULL,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;"); //forums
/** * i5_output() returns variables from i5_program_call, i5_userspace_get, and sometimes i5_command. * * @return bool */ function i5_output() { // get connection if (!($connection = verifyConnection())) { return false; } // return array of variables. Calling routine can do extract() with it. return $connection->getOutputVarsToExport(); }