<?php

/* Scadoodle (CMS)
 * Development Version
 * Created by Ryan Stewart, 2010
 */

include("core.php");
error_reporting(E_ALL);

if(isset($_POST['install'])) {
   $adminuser = $_POST['ausername'];
   $adminpass = md5($_POST['apassword']);
   $adminmail = $_POST['aemail'];

   $sitename = $_POST['sitename'];
   $siteurl = $_POST['siteurl'];
   $sitehome = $_POST['sitehome'];

   // CREATE ADDON TABLES
   mysql_query("CREATE TABLE ".DBSLUG."addons(folder varchar(150) NOT NULL, title varchar(150) NOT NULL, description varchar(350) NOT NULL, status int(1) NOT NULL)");
   mysql_query("CREATE TABLE ".DBSLUG."addons_admin(addon_id int(11) auto_increment, addon_title varchar(70) NOT NULL, addon_url(70) NOT NULL, PRIMARY KEY(addon_id))");
   mysql_query("CREATE TABLE ".DBSLUG."addons_settings(setting_name varchar(150) NOT NULL, setting_title varchar(150) NOT NULL, setting_desc varchar(350) NOT NULL, setting_value varchar(350) NOT NULL)");

   // CREATE BRICK TABLES
   mysql_query("CREATE TABLE ".DBSLUG."bricks(folder varchar(70), title varchar(70), description varchar(200), status int(1), position varchar(10), sortorder(1))");
   mysql_query("CREATE TABLE ".DBSLUG."bricks_settings(brick_name varchar(150), brick_title varchar(150), brick_desc varchar(350), value varchar(350))");

   // CREATE CONFIGURATION TABLES
   mysql_query("CREATE TABLE ".DBSLUG."config(dbslug varchar(10), sitename varchar(150), sitedesc varchar(350), sitekey varchar (350), sitetheme varchar(150), siteurl varchar(150), sitecopyright varchar(150), sitelocale varchar(100), sitehome varchar(80))");

   // CREATE NAVIGATION TABLES
   mysql_query("CREATE TABLE ".DBSLUG."navigation(linkid int(11) auto_increment, linkorder int(11), linkname varchar(150), linkurl varchar(150), PRIMARY KEY (linkid))");

   // CREATE NEWS TABLE
   mysql_query("CREATE TABLE ".DBSLUG."news(news_id int(11) auto_increment, news_title varchar(100), news_extract varchar(200), news_full varchar(9000), news_author int(11), PRIMARY KEY (news_id))");

   // CREATE PAGE TABLES
   mysql_query("CREATE TABLE ".DBSLUG."pages(page_id int(11) auto_increment, page_title varchar(100), page_content varchar(9000), page_share varchar(3), PRIMARY KEY(page_id))");

   // CREATE USER TABLES
   mysql_query("CREATE TABLE ".DBSLUG."users(userid int(11) auto_increment, username varchar(100), password varchar(100), email varchar(150), group int(1), PRIMARY KEY(userid))");

   echo "<span style='color:green;'>Scadoodle has installed!</span>";
}

echo "<form method='post' name='installform' action='#'>";
echo "Administrator<br />";
echo "<input type='text' name='ausername' value='Username'><br />";
echo "<input type='text' name='apassword' value='Password'><br />";
echo "<input type='text' name='aemail' value='Email'><br /><br />";
echo "Site Config<br />";
echo "<input type='text' name='sitename' value='Site Title'><br />";
echo "<input type='text' name='siteurl' value='Site Url(Dont include trailing slash)'><br />";
echo "<input type='text' name='sitehome' value='home.php'><br />";

echo "<input type='submit' name='install' value='Install Scadoodle!'>";
echo "</form>";
?>