<?php

include("config.php");

?>

                <h2><a href="#">Dashboard</a> &raquo; <a href="#" class="active">Add Demo</a></h2>

                <div id="main">
					<h3>Fill out the form to create a new demo</h3>
                    	<table cellpadding="0" cellspacing="0">
							<tr>
<?php
if($_GET['submit'] == NULL) {
?>


<form action='index.php?page=add&submit=yes' method='post'>

Name: <br><input type='text' name='name' value='' /><br />
SQL File: <br><input type='text' name='sqlfile' value='' /><br />
Zip File: <br><input type='text' name='zipfile' value='' /><br />
Demo Folder: <br><input type='text' name='demofolder' value='' /><br />
File Root: <br><input type='text' name='fileroot' value='' /><br />
Demo Root: <br><input type='text' name='demoroot' value='' /><br />
Database Hostname: <br><input type='text' name='hostname' value='' /><br />
Database Name: <br><input type='text' name='dbname' value='' /><br />
Database Username: <br><input type='text' name='dbuser' value='' /><br />
Database Password: <br><input type='text' name='dbpass' value='' /><br />
<label>Allow SQL file to drop tables?</label>
<select name="drop">
<option value="no">No</option>
<option value="yes">Yes</option>
</select>
<br />
<input type='submit' value='Add Demo' />

</form>


<?php
}

elseif($_GET['submit'] == "yes") {

@mysql_query("INSERT INTO demo SET name = '".$_POST['name']."', sqlfile = '".$_POST['sqlfile']."', zipfile = '".$_POST['zipfile']."', demofolder = '".$_POST['demofolder']."', fileroot = '".$_POST['fileroot']."', demoroot = '".$_POST['demoroot']."', hostname = '".$_POST['hostname']."', dbname = '".$_POST['dbname']."', dbuser = '".$_POST['dbuser']."', dbpass = '".$_POST['dbpass']."', drop = '".$_POST['drop']."'");

echo "Demo Added! Click here to go <a href=\"index.php\">back</a>";

}

elseif($_GET['submit'] != "yes" && $_GET['submit'] != NULL && $_GET['edit'] != NULL) {

echo "You're on a page you shouldn't be. ";

}
?>
			                                </tr>
                        </table>
                        <br>
                      </div>