problem

[HITMAN 17]

when someone buys a house like semi detached house it dosnt change the house and keeps the old house can anyone help plz

[Godhand]

Re: problem

Well check under the sell house portion in the page and make sure that it decreases their house and sets them back to default house.

[HITMAN 17]

Re: problem

well this dont work

{
print "You do not have enough money to buy the {$np['hrNAME']}.";
}
else
{
$db->query("UPDATE users SET money=money-{$np['hPRICE']},will=0,maxwill={$np['hWILL']} WHERE userid=$userid");
print "Congrats, you bought the {$np['hNAME']} for \${$np['hPRICE']}!";
}
}
else if (isset($_GET['sellhouse']))
{
$npq=$db->query("SELECT * FROM houses WHERE hWILL={$ir['maxwill']}");
$np=$db->fetch_row($npq);
if($ir['maxwill'] == 100)
{
print "You already live in the lowest property!";
}
else
{
$db->query("UPDATE users SET money=money+{$np['hPRICE']},will=0,maxwill=100 WHERE userid=$userid");
print "You sold your {$np['hNAME']} and went back to your shed.";
}
}
else
{
print "Your current property: [b]{$mp['hNAME']}[/b]

The houses you can buy are listed below. Click a house to buy it.
";
if($ir['maxwill'] > 100)
{
print "[url='estate.php?sellhouse']Sell Your House[/url]
";
}
$hq=$db->query("SELECT * FROM houses WHERE hWILL>{$ir['maxwill']} ORDER BY hWILL ASC");
while($r=$db->fetch_row($hq))
{

print "[url='estate.php?property={$r[']{$r['hNAME']}[/url] &nbsp - Cost: \${$r['hPRICE']} &nbsp - Will Bar: {$r['hWILL']}
";
}
}
$h->endpage();
?>

[HITMAN 17]

Re: problem

actually i sorted it any way thnx *LOCKED*