need quick php help

alcapone · 03-31-2008, 03:03 PM

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;

????: NamePros.com http://www.namepros.com/programming/451773-need-quick-php-help.html
 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";

????: NamePros.com http://www.namepros.com/showthread.php?t=451773
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";

03-31-2008, 03:03 PM	THREAD STARTER #1 (permalink)
alcapone NamePros Member Join Date: Feb 2005 Posts: 165	need quick php help 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; ????: NamePros.com http://www.namepros.com/programming/451773-need-quick-php-help.html 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"; ????: NamePros.com http://www.namepros.com/showthread.php?t=451773 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"; __________________ Hostile-Territory

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)