Login integration: Logging in on an existing site and punBB (Page 1 of 2)

pun_setcookie($user_id, $form_password_hash, $expire);

 
    include "./punbb/include/functions.php"; //Make sure the following code has access to the pun_hash() and pun_setcookie() function definitions
    
    $username = $user->Username;  //Get the username of the logged in user and put it in a variable    
    
    $queryFromPunbb = "SELECT * FROM punbb_users WHERE username='$username'";    //get the id from the logged in user. This id is the primary key of the punbb_users table in the punbb database
    $result = mysql_query($queryFromPunbb, $conn) or die (mysql_error());    //Run the query
    $row = mysql_fetch_array($result) or die(mysql_error());    //Put the result of the query in an array called $row  
    
    $user_id = $row['id'];    //Put the id from the $row array into the variable $user_id
    $hashedPassword = pun_hash($user->Password);    //hash the user's password using the punbb hash function 
    
    pun_setcookie($user_id, $hashedPassword, time()+24*60*60);  //Set the punBB cookie, which is called punbb_cookie

Array
(
    [punbb_cookie] => a:2:{i:0;s:1:"3";i:1;s:32:"5ec70ea77e7b20ef464b8489d391a07b";}
    [__utma] => 37521701.265511199.1199912689.1200091902.1200106214.15
    [__utmz] => 37521701.1199912689.1.1.utmccn=(direct)|utmcsr=(direct)|utmcmd=(none)
    [style_cookie] => printonly
    [__utmc] => 93837953
    [PHPSESSID] => 1c3bd95e6dhrs18pkr7aki8t40
    [phpbb3_2rojj_u] => 1
    [phpbb3_2rojj_k] => 
    [phpbb3_2rojj_sid] => 4e3437741406faee467a71d53f29fb98
    [a:2:{i:0;s:1:\"3\";i:1;s:32:\"09202be3249d1bd81d509b9c9977da5b\";}] => 
    [__utmb] => 37521701
)

3 206c80413b9a96c1312cc346b7d2517b84463edd 1200195464

<? 
define('PUN_ROOT', './punbb/');
include 'punbb/include/common.php';    //Include this file so that $pun_user['is_guest'] can be used and that (some?) functions from punbb/include/functions.php can also be used in this script


if (($websitelogin==true) && ($pun_user['is_guest'])) {
    
    
    include "./punbb/customforumdbconfig.php"; //Custom file which contains and sets the variables for setting up a connection to the punbb database
    include "opendb.php"; //Script that uses the above mentioned variables to open the actual connection with the database
    
    
    $username = $user->Username;  //Get the username of the logged in user and put it in a variable     ($user->Username comes from code from the website which is intended to get login integration with punbb through this script)
    
    $queryFromPunbb = "SELECT * FROM punbb_users WHERE username='$username'";    //get the row with the id from the logged in user. This id is the primary key of the punbb_users table in the punbb database
    $result = mysql_query($queryFromPunbb, $conn) or die (mysql_error());    //Run the query
    $row = mysql_fetch_array($result) or die(mysql_error());    //Put the result of the query in an array called $row  
    
    $user_id = $row['id'];    //Put the id from the $row array into the variable $user_id
    $hashedPassword = pun_hash($user->Password);    //hash the user's password using the punbb hash function 
    $expirationTime = time()+24*60*60;
    
    pun_setcookie($user_id, $hashedPassword, $expirationTime);  //Set the punBB cookie, which is called punbb_cookie
    
    include "closedb.php"; //Include a script which closes the connection with the punbb database

header("Location: ./punbb"); //send the browser to the /punbb directory
}
elseif (($websitelogin==true) && !($pun_user['is_guest'])) {
    header("Location: ./punbb"); //send the browser to the /punbb directory
}
elseif (!($websitelogin) && ($pun_user['is_guest'])) {
    header("Location: ./punbb"); //send the browser to the /punbb directory
}
else {
    exit("Error: website login flag and/or guest flag exception"); //Print error to screen and terminate the execution of the script
} 
?>