Hello,

i have a big problem. I have a login script in php with sessions. Now the PHP script connects to the LUM_user and i can login with my username and my password but the session isn´t stored.

how can i make this.

i have searched in the board and google but didnt find anything.

i read something about saving the session in the VerivicationKey but this dont work too.

i hope somebode from this board can help me

best regards, dominik

no i want use my own login script on mainsite to make the same session then vanilla. I use the Vanilla MySQL Table "LUM_User" to login. but how can i make it with the session?

but i dont know i have to do this? my script is :

<?
function connect()
{
$con= mysql_connect('removed','removed','removed') or die(mysql_error());
mysql_select_db('removed',$con) or die(mysql_error());
}

function check_user($name, $pass)
{
$sql="SELECT UserID
FROM LUM_User
WHERE Name='".$name."' AND Password=MD5('".$pass."')
LIMIT 1";
$result= mysql_query($sql) or die(mysql_error());
if ( mysql_num_rows($result)==1)
{
$user=mysql_fetch_assoc($result);
return $user['UserID'];
}
else
return false;
}

function login($userid)
{
$sql="UPDATE LUM_User
SET VerificationKey='".session_id()."'
WHERE UserID=".$userid;
mysql_query($sql);
}

function logged_in()
{
$sql="SELECT UserID
FROM LUM_User
WHERE VerificationKey='".session_id()."'
LIMIT 1";
$result= mysql_query($sql);
return ( mysql_num_rows($result)==1);
}

function logout()
{
$sql="UPDATE LUM_User
SET VerificationKey=NULL
WHERE VerificationKey='".session_id()."'";
mysql_query($sql);
}

connect();
?>

I think if you do something like

include(./path/to/appg/init_people.php);
if ($Session->UserID > 0) {
They're logged in
} else {
they're not
}

..that's the general concept anyway. You might need to play with $Context->Session->UserID but see what happens...

Well I was working on the basis that you scrapped your script and just used a small snippet like the one above to interface with vanilla..