have levels i use in a game of mine it goes per credits added and supporter status in the game everything is working except for level 3 when they added more then 99999 credits addeding more then 99999 credits gives you level 4 in the game but they cant reach level 4 unless they are a supporter so i need to keep them in level 3 level 3 works but only if they didnt add 99999 credit hope you under stand
any help would be great
here is the code im working with
any help would be great
here is the code im working with
PHP:
if(!$l)
{
if($creditz[0]==0||$tmp_rows==0)
$lvl=1;
else if($creditz[0]<40001&&$creditz[0]>0)
$lvl=2;
else if($creditz[0]<100000&&$creditz[0]>40000)
$lvl=3;
else if($creditz[0]>99999)
$lvl=4;
}
else
{
$lvl=$l;
}
if($lvl==1)
$lvlstring="stats.credits=0";
else if($lvl==2)
$lvlstring="stats.credits<40001 AND stats.credits>0";
else if($lvl==3)
$lvlstring="stats.credits<100000 AND stats.credits>40000";
else if($lvl==4)
$lvlstring="stats.credits>99999 AND $tab[pimp].status='Supporter'";
$sSQL = "SELECT count(*) FROM users, stats,$tab[pimp] WHERE users.username = stats.user AND $tab[pimp].code=users.code AND $tab[pimp].networth>'$pmpz[1]' AND stats.round='$round' AND $lvlstring";













