fclose($fp);
mysql_connect($db_host, $db_user, $db_pass);
if (mysql_query("create database {$db_name}")) {
if (mysql_select_db($db_name)) {
$q = "CREATE TABLE IF NOT EXISTS `accounts` (\n\t\t\t\t\t\t\t\t\t\t `fname` varchar(30) NOT NULL,\n\t\t\t\t\t\t\t\t\t\t `uname` varchar(30) NOT NULL,\n\t\t\t\t\t\t\t\t\t\t `passwd` varchar(30) NOT NULL,\n\t\t\t\t\t\t\t\t\t\t `gen` varchar(30) NOT NULL,\n\t\t\t\t\t\t\t\t\t\t `dob` varchar(30) NOT NULL,\n\t\t\t\t\t\t\t\t\t\t `edu` varchar(30) NOT NULL,\n\t\t\t\t\t\t\t\t\t\t `add` varchar(30) NOT NULL,\n\t\t\t\t\t\t\t\t\t\t `email` varchar(30) NOT NULL,\n\t\t\t\t\t\t\t\t\t\t `pno` varchar(12) NOT NULL,\n\t\t\t\t\t\t\t\t\t\t `sq` varchar(30) NOT NULL,\n\t\t\t\t\t\t\t\t\t\t `ans` varchar(30) NOT NULL,\n\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`uname`)\n\t\t\t\t\t\t\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=latin1";
$q1 = mysql_query($q) or die(goToDie());
$q = "CREATE TABLE IF NOT EXISTS `exams` (\n\t\t\t\t\t\t\t\t\t\t `id` varchar(30) NOT NULL,\n\t\t\t\t\t\t\t\t\t\t `name` text NOT NULL,\n\t\t\t\t\t\t\t\t\t\t `type` varchar(20) NOT NULL,\n\t\t\t\t\t\t\t\t\t\t `date` date NOT NULL,\n\t\t\t\t\t\t\t\t\t\t `no_questions` int(11) NOT NULL,\n\t\t\t\t\t\t\t\t\t\t `duration` varchar(10) NOT NULL,\n\t\t\t\t\t\t\t\t\t\t `pass` text NOT NULL,\n\t\t\t\t\t\t\t\t\t\t `inv_pass` text NOT NULL,\n\t\t\t\t\t\t\t\t\t\t `paper_status` varchar(50) NOT NULL DEFAULT 'NOT PREPARED',\n\t\t\t\t\t\t\t\t\t\t `results` varchar(30) NOT NULL DEFAULT 'NOT GENARATED',\n\t\t\t\t\t\t\t\t\t\t `key_status` varchar(30) NOT NULL DEFAULT 'NOT UPLOADED',\n\t\t\t\t\t\t\t\t\t\t `exam_active` varchar(30) NOT NULL DEFAULT 'NO',\n\t\t\t\t\t\t\t\t\t\t `reg` varchar(30) NOT NULL DEFAULT 'NOT OPEND',\n\t\t\t\t\t\t\t\t\t\t `ngm` varchar(10) NOT NULL,\n\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`id`)\n\t\t\t\t\t\t\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=latin1";
$q1 = mysql_query($q) or die(goToDie());
$q = "insert into accounts values('{$c_name}', '*****@*****.**', '{$c_pass}', '', '', '', '', '*****@*****.**', '', '', '')";
mysql_query($q);
if (mysql_affected_rows() > 0) {
?>
<script type="text/javascript">
window.location="del.php";
</script>
<?php
} else {
die(goToDie());
}
} else {
die(mysql_error());
}
} else {
die(mysql_error());
}
}
function goToDie()
{
echo mysql_error();
$q = mysql_query("drop DATABASE {$db_name}") or die(mysql_error());
}
$q1 = mysql_query($q) or die(mysql_error() . "<br> Try to choose different Exam ID");
if ($q1) {
if (mysql_select_db("{$e_id}")) {
$q = "CREATE TABLE IF NOT EXISTS `questions` (\n\t\t\t\t\t `qid` int(11) NOT NULL,\n\t\t\t\t\t `sid` int(11) DEFAULT NULL,\n\t\t\t\t\t `q` text,\n\t\t\t\t\t `nop` int(11) DEFAULT NULL,\n\t\t\t\t\t `ans` text,\n\t\t\t\t\t `a` text,\n\t\t\t\t\t `b` text,\n\t\t\t\t\t `c` text,\n\t\t\t\t\t `d` text,\n\t\t\t\t\t `e` text,\n\t\t\t\t\t `f` text,\n\t\t\t\t\t `g` text,\n\t\t\t\t\t `h` text,\n\t\t\t\t\t PRIMARY KEY (`qid`)\n\t\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8";
$q1 = mysql_query($q) or die(goToDie());
$q1 = "CREATE TABLE IF NOT EXISTS `time` (\n\t\t\t\t\t `min` int(11) NOT NULL,\n\t\t\t\t\t `sec` int(11) NOT NULL,\n\t\t\t\t\t `id` varchar(50) NOT NULL,\n\t\t\t\t\t PRIMARY KEY (`id`)\n\t\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=latin1";
mysql_query($q1) or die(goToDie());
if ($e_type == "SR") {
$q1 = "CREATE TABLE IF NOT EXISTS `exam` (\n\t\t\t\t\t\t `id` varchar(50) NOT NULL,\n\t\t\t\t\t\t `sec` int(11) NOT NULL,\n\t\t\t\t\t\t `q` int(11) NOT NULL,\n\t\t\t\t\t\t `ans` text NOT NULL,\n\t\t\t\t\t\t `mark` varchar(11) NOT NULL\n\t\t\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=latin1";
mysql_query($q1) or die(goToDie());
} else {
$q1 = "CREATE TABLE IF NOT EXISTS `exam` (\n\t\t\t\t\t\t `id` varchar(50) NOT NULL,\n\t\t\t\t\t\t `sec` int(11) NOT NULL,\n\t\t\t\t\t\t `q` int(11) NOT NULL,\n\t\t\t\t\t\t `ans` text NOT NULL\n\t\t\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=latin1";
mysql_query($q1) or die(goToDie());
}
$q = "CREATE TABLE IF NOT EXISTS `results` (\n\t\t\t\t\t `id` varchar(50) NOT NULL,\n\t\t\t\t\t `marks` text NOT NULL,\n\t\t\t\t\t PRIMARY KEY (`id`)\n\t\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=latin1";
$q1 = mysql_query($q) or die(goToDie());
if (is_dir("../../Exams/") && mkdir("../../Exams/" . $e_id, 0777, TRUE)) {
mysql_select_db("aoes");
$q = "insert into exams values('{$e_id}', '{$e_name}', '{$e_type}', NOW(), {$no_q}, '{$e_duration}','{$e_pass}', '{$e_inv}', default, default, default, default, default, '{$e_ngm}')";
if ($e_type == "SR") {
$q = "insert into exams values('{$e_id}', '{$e_name}', '{$e_type}', NOW(), {$no_q}, '{$e_duration}','{$e_pass}', '{$e_inv}', default, 'SPOT RESULTS', default, default, default, '{$e_ngm}')";
}
$q1 = mysql_query($q);
if ($q1) {
echo "success";
} else {
echo mysql_error();
$q = mysql_query("drop DATABASE {$e_id}");
}
} else {
echo "Error: Unable to create {$e_id} folder make sure 'es-1' directory writable!";
