Login system

[Anduril]

I'm trying to create a login system and I have got the following:

Code: Select all

{php} 
session_start();
session_id();
if($_GET["logout"] == "yes"){
session_unset();
session_destroy();
}
$dbhost = 'host';
$dbuser = 'user';
$pass = 'pass';
$dbname = 'dbname';
$domein = 'url';
$db = mysql_connect("$dbhost","$dbuser","$pass") or die ("Sorry geen sql connectie:".mysql_error());
mysql_select_db("$dbname", $db) or die ("Database kan niet aangesporken worden:".mysql_error());


if(!isset($_SESSION["username"])){
	if(isset($_POST["loginusername"]) && isset($_POST["loginpassword"])){

	$logincheckpass = md5($_POST["loginpassword"]);
	$loginquery = "SELECT * FROM phpbb_users 
	WHERE username='" .$_POST["loginusername"]."'
	AND user_password='".$logincheckpass."'";
	$loginresult = mysql_query($loginquery) or die ("FOUT: " .mysql_error());
	if(mysql_num_rows($loginresult) > 0){
	$username = $_POST["loginusername"];
	session_register("username");
        if(!isset($_SESSION["username"])){;
}}}}
{/php}

And of course a form, it is only visible when your not logged in:

Code: Select all

{php} if(!isset($_SESSION["username"])){ {/php}
<table width="140" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td class="logintabel" align="center">
        <form name="loginform" method="post" action="{php} echo($_SERVER['PHP_SELF']); {/php}">
	Username:<br>
	<input name="loginusername" type="text"><br>
	Password:<br>
	<input name="loginpassword" type="password"><br>
	<input name="loginsubmit" type="submit" value="Login">
    </form>
	    <h3><a href="phpbb/index.php">Registreren!</a></h3></td>
  </tr>
</table>
{php} } {/php}

But it isn't working... (it works when I put it in a normal php page but not in a template...
What am I doing wrong?

[Ted]

Why not use frontend users and custom content instead?