Need Help - Extra turns for donators

[p_T_s]

I want to give all my donators extra turns in the streets.

so for donators they get 100 turns at new day,

non-donators get 70 turns at new day....

I have tried the following but dosn't work..

 

if($ir['donatordays'])
{
$db->query("UPDATE users SET turns=turns+100");
}
else
{
$db->query("UPDATE users SET turns=turns+70");

 

and

 

$db->query("UPDATE users SET turns=70 where donatordays <=0);
$db->query("UPDATE users SET turns=100 where donatordays > 0);

 

and also

 

if($ir['donatordays'] <= 0)
{
$db->query("UPDATE users SET turns=70");
}
else if($ir['donatordays'] > 0)
{
$db->query("UPDATE users SET turns=70");

 

Can soem one tell me what i've done wrong?

[AlabamaHit]

Re: Need Help - Extra turns for donators

 

mysql_query("UPDATE users SET turns = 70 WHERE donatordays = 0");
mysql_query("UPDATE users SET turns = 100 WHERE donatordays > 0");

[p_T_s]

Re: Need Help - Extra turns for donators

Thx AlabamaHit it was as simple as that! lol

[AlabamaHit]

Re: Need Help - Extra turns for donators

No problem.