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
PHP Code:
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";
