Counter of people that logim

John,
you can save timestamp of login and increase counter of logins in the AfterSuccessfulLogin event.

Here is a sample:

global $conn;

where DateTimeOfLogin, NumbersOfLogin and UserName are your actual field names, TableName is your actual table name.

Hello: The following is already in my "after successful log-in" event. Where do I add the code you provided; so I will be able to see how many are logged in, etc. Thank you, Janice
global $conn;
$tmpSQL="select from users where Email='" . $username . "' and Password='" . $password . "'";

$rs = db_query($tmpSQL,$conn);

if($data1 = db_fetch_array($rs))

{

$begindate=$data1["Beginpay"];

$enddate=$data1["Endpay"];

$_SESSION["ppuid"]=$data1["ID"];

if($data1["Paypal"]==0)

{

header("Location: login.php?a=pp0");

exit();

}

if(strtotime($enddate)-strtotime($begindate)!=0 && (strtotime($enddate)-strtotime($begindate))/(6060*24)<0)

{

header("Location: login.php?a=pp1");

exit();

}

}

Hi,
add this code in the beginning of your code:

global $conn;

Sorry Jane,
Don't get to work.
I put it just as you said in the "after successful log-in" event, gave the table _klant the extra fields "DateTimeOfLogin" and "NumbersOfLogin".

Now I don't know what to put in 'Username' and in 'UserID'.
So I played with Name and also with clientID. These are the fields in _klant.
But it doesn't count anything.
John

John,
replace Username with your actual field name where login name is stored. Don't change $_SESSION["UserID"] variable.

global $conn;

John,

Hi Jane,
It doesn't work.
I only replaced "TableName" in _klant and "UserName" in Inlognaam. But it doesn't count anything.
I made a seperate View from _klant called LoginMonitor to view what happenes in the fields NumberOfLogin and DateTimeOfLogin (witch are in _klant) but it just gives all the names without output in the two fieldnames.

I tried to post the whole thing in the Demo account but it is bigger then 5 MB so that didn't work as well.
How to go about this?
regards,
John

John,
download and install latest PHPRunner update:

http://www.asprunner.com/files/phprunner-setup.zip
Then rebuild your project and upload it to the Demo Account again. There is no 5MB restriction in the last PHPRunner update.

My dear Jane,
The thing has an maximum of 10MB !!!!!

Hello Again: So after all the comments back and forth, what code do I put where to make the count thing work? The following is already in my "after successful log-in" event. Where do I add the code you provided; so I will be able to see how many are logged in, etc. Thank you, Janice
global $conn;
$tmpSQL="select from users where Email='" . $username . "' and Password='" . $password . "'";

$rs = db_query($tmpSQL,$conn);

if($data1 = db_fetch_array($rs))

{

$begindate=$data1["Beginpay"];

$enddate=$data1["Endpay"];

$_SESSION["ppuid"]=$data1["ID"];

if($data1["Paypal"]==0)

{

header("Location: login.php?a=pp0");

exit();

}

if(strtotime($enddate)-strtotime($begindate)!=0 && (strtotime($enddate)-strtotime($begindate))/(6060*24)<0)

{

header("Location: login.php?a=pp1");

exit();

}

}

mickmouser,
add this code in the beginning of your code:

global $conn;

John,
post your actual code here.

Hi Jane,
Is this what you mean?
global $conn;

$strUpdate = "update _klant set DateTimeOfLogin=Now() and NumberOfLogin=NumberOfLogin+1 where KlantID='".$_SESSION["UserID"]."'";

db_exec($strUpdate,$conn);

Here is the correct code:

global $conn;

Here is the correct code:

Sorry Jane,
I just don't get it to work.
I just let this thing be for a while.
I would like you to answer my other question about the 'CV' file.
regards
John