3 require_once('classes/gnucomo_config.php');
4 include "functions.php";
6 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
9 <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
10 <link rel='stylesheet' href='gnucomo.css' type='text/css'>
11 <title>GNUCoMo login</title>
16 if (empty($_SESSION["username"]))
19 if( isset($_POST["username"]) and isset($_POST["password"]) and isset($_SESSION['login']) )
21 $name = $_POST["username"]; // PostgreSQL username
22 $passw = $_POST["password"]; // PostgreSQL user password
24 $config = new gnucomo_config;
26 $config->read("gnucomo");
28 // connect to the database
29 //echo "Database connection = " . $config->Database($name, $passw) . "<br>";
30 $conn = pg_connect($config->Database($name, $passw));
34 echo "Error connecting, try again.";
39 $sql = "SELECT * FROM usr WHERE username='$name'";
40 $res = pg_exec( $conn, $sql );
41 if ($res && pg_numrows($res) == 1)
43 echo "<br> Database login OK.<br>";
44 session_register('username');
45 $_SESSION["username"] = $name;
46 session_register('password');
47 $_SESSION["password"] = $passw;
51 // User not found in database. Check if we have any users at all.
53 $res = pg_exec($conn, "SELECT count(username) FROM usr");
54 $nusers = pg_fetch_object($res, 0);
55 $nusers = $nusers->count;
58 echo "<br>No users in database. Authentication granted.<br>";
59 session_register('username');
60 $_SESSION["username"] = $name;
61 session_register('password');
62 $_SESSION["password"] = $passw;
66 echo "<br>User $name not found in database.<br>";
74 $_SESSION["login"] = true;
79 echo "Logged in as " . $_SESSION['username'] . "<br>";