Change Data in Database
Posted: Thu May 20, 2010 12:54 pm
Hey guys was wondering if someone could help me, i didnt really know how to go about this hope someone could point me in the right direction. I have created a user login and it stores various information about the user: Name, Username, Email, Password, Date Joined, Is Active etc is there a script where when the admin logges in they will have a link to it maybe called UserActive.php (iknow how to do this haha) when the admin (me) navigates to this page it will show all the users in the database that have been inactive for a certain amount of time and then change IsActive back to a 0.
At the moment when a user registers to my site there account is created and there IsActive is set to 0 if they login then i test to see if its 0 if it is then tell them they have to activate their account via an email my site sends them So is there a way i could test to see if the user has logged in within the past month etc?
Iknow this is a pain but if someone could point me in the right direction it would be greatly appreciated.
At the moment when a user registers to my site there account is created and there IsActive is set to 0 if they login then i test to see if its 0 if it is then tell them they have to activate their account via an email my site sends them So is there a way i could test to see if the user has logged in within the past month etc?
Iknow this is a pain but if someone could point me in the right direction it would be greatly appreciated.