View directory
template_dir = $prefix."smarty/templates";
$smarty->compile_dir = $prefix."smarty/templates_c";
$smarty->cache_dir = $prefix."smarty/cache";
$smarty->config_dir = $prefix."smarty/configs";
// Default action is to display entries in DB
$dblink = connectToSQL("db373.perfora.net", "dbo166284576", "aBRZEJm5", "db166284576");
//print_r("session: ".$_SESSION['dirok']);
if($_POST['validate'])
{
$datetime = date("Y-m-d H:m:s");
//UPDATE `penngaa` SET `helpout` = '1' WHERE `id` =13 LIMIT 1 ;
$q_validate = "SELECT * from penngaa WHERE email='".$_POST['email']."' AND zip='".$_POST['zip']."'";
$valid = query_ASSOC($q_validate, $dblink);
if(count($valid) == 1)
{
// Good to go
$_SESSION['dirok'] = "yep";
//print_r(" 2session: ".$_SESSION['dirok']);
$q_query = "SELECT * from penngaa WHERE 1 ORDER BY `lname` ASC ";
$dir = query_ASSOC($q_query, $dblink);
$smarty->assign('dir',$dir);
$smarty->display('directory.tpl');
}
else
{
$message = "You could not be validated.";
$smarty->assign('message', $message);
$smarty->display('validate_directory.tpl');
}
}
else if (isset($_SESSION['dirok']))
{
$q_query = "SELECT * from penngaa WHERE 1 ORDER BY `lname` ASC ";
$dir = query_ASSOC($q_query, $dblink);
$smarty->assign('dir',$dir);
$smarty->display('directory.tpl');
}
else
{
$smarty->display('validate_directory.tpl');
}
?>