Updating based on 2 factors

[ldtiw]

I have this piece of code:

if ($row_userInfo['m_usertype'] == 2 && date('Ymd') >= $row_userInfo['m_upgrade_end']) {$new_user_type = "1";} 
else ($row_userInfo['m_usertype'] == 2 && date('Ymd') <= $row_userInfo['m_upgrade_end']) {$new_user_type = "2";} 

The code actually worked with just the first condition:

if usertype = 2 and is pased the expired date, but not when i added the second

if usertype =2 and upgrade_end is still in date.

Also need a third, if usertype = 1 $new_user_type = 1

If someone could help out it would be fantastic!

Cheers,
Danny

[kburger]

You basically already wrote it yourself.

if ($row_userInfo['m_usertype'] == 2 && date('Ymd') >= $row_userInfo['m_upgrade_end']) {$new_user_type = "1";} 
else if ($row_userInfo['m_usertype'] == 2 && date('Ymd') <= $row_userInfo['m_upgrade_end']) {$new_user_type = "2";}
else if ($row_userInfo['m_usertype'] == 1) { $new_user_type = 1; }
else { // what? 
}

[ldtiw]

Thanks for the code, one problem with it is that both valid and expired dates change the usertype to 0. I have nothing in the else as the first three are all i need, so its obviously going strieght to the else.

What would be causing this?? Have i got the date check parts right??

if ($row_userInfo['m_usertype'] == 2 && date('YmdHis') >= $row_userInfo['m_upgrade_end']) {$new_user_type = 1;}  

else if ($row_userInfo['m_usertype'] == 2 && date('YmdHis') <= $row_userInfo['m_upgrade_end']) {$new_user_type = 2;} 
else if ($row_userInfo['m_usertype'] == 1) { $new_user_type = 1; } 
else { 

}

[kburger]

There's an awful lot I don't know about your table structure and exactly what you're trying to accomplish using what logic.

Here's the way I'd do it:

switch ($row_userInfo['m_usertype']) {
	case 1:
		$new_user_type = 1;
		break;
	case 2:
		if (strtotime("now") >= strtotime($row_userInfo['m_upgrade_end'])) $new_user_type = 1;
		else $new_user_type = 2;
		break;
}

[ldtiw]

Its basically a page that a user gets taken to after they login. Then after the canges to the table are made ie update last login and hopefully the usertype if it has expired.

I have my table ipals_members which contains the login info, email and the join date, last login date and upgrade expires date.

It changes the last login date like i need, but i cant get any code to check the users type basic (1) and premium (2) and then change the info acordingly.

If the user is a usertype 2 and the upgrade has expired they get taken down to usertype 1 (Basic). If the upgrade is still valid it stays the same. If they are a basic member there are no changes needed as they dont have an expire date.

Just a simple page to make these changes basically!

That last piece of code didnt work either. hum......

[kburger]

Throw in some echo statements so you can see what's going on.

Did you understand the code I used? If so, it should be a pretty simple matter of editing it to fit whatever logic you're using.

If all else fails, post the code, the database data, and the form entry data and I'll take a look.