Determine if first login

[bowers01]

Hi,
Is it possible to determine if its the first time a user has logged in? i want to display a popup if its the first time a user has logged into their account.
Cheers,
Nick

[Lhotch]

do a query against the user database table and check the value of the "lastlogin" field before the actual login, if its set to the default value still then the user has never logged in.

But, keep in mind doing this means that everytime someone accesses your site you are going to have an additional database call which for most people is going to be worthless since it applies only to those who have never logged in before.

[bowers01]

Hi,
I found out that it is already being called from the database.
By placing this in userindex.tpl

{if $lastlogin=='0000-00-00 00:00:00'}
<script type="text/javascript">
 alert("Welcome to yoursite.com")
</script>
{/if}

it doesnt work as the database is updated with the current time because you just logged in before the message will appear.
How could i make it assign $lastlogin before the database is updated?

Cheers,
Nick

[bowers01]

Anyone?


Cheers,
Nick