Code: Select all
////////////////////for phpBB///////////////////////////////
//generate session id
$query = "SELECT config_value FROM phpbb_config WHERE config_name='rand_seed'";
$return_seed = mysql_query($query) or die(mysql_error());
$seed = mysql_result($return_seed,0);
$val = $seed. microtime();
$val = md5($val);
$seed = md5($seed . $val . 'a');
// put it back in the table..werid
$sql = "UPDATE phpbb_config SET config_value='$seed' WHERE config_name='rand_seed'";
$return = mysql_query($sql) or die(mysql_error());
$session_id = md5(substr($val, 4, 16));
//get IP
$client_ip = ( !empty($HTTP_SERVER_VARS['REMOTE_ADDR']) ) ? $HTTP_SERVER_VARS['REMOTE_ADDR'] : ( ( !empty($HTTP_ENV_VARS['REMOTE_ADDR']) ) ? $HTTP_ENV_VARS['REMOTE_ADDR'] : getenv('REMOTE_ADDR') );
$user_ip = encode_ip($client_ip);
//current time
$current_time = time();
//create entry in sessions table
$sql = "INSERT INTO phpbb_sessions
(session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin)
VALUES ('$session_id', '$clientid', $current_time, $current_time, '$user_ip', '0', '1', '0')";
$return = mysql_query($sql) or die(mysql_error());
// create sessiondata
$sessiondata['userid'] = *your own site ID, i dont know if you use phpBB or ur own sites;
$sessiondata['autologinid'] = false;
setcookie('phpbb2mysql_data', serialize($sessiondata), $current_time + 31536000, "/", ".urwebsite.com");
setcookie('phpbb2mysql_sid', $session_id, 0, "/", ".urwebsite.com");
///////////////////////////////////////////////////////////////
this is my code in my own login.php file...not the phpbb, and of course i got most of the code from PHPBB's functions