使用PHP和Mysql取得了银行业的成就

Question

好吧，我为我的游戏做了一个成就系统。我对银行业务有一定的成就。好吧，当他们的账户达到一定的金额时，你就会把成果发布在你的用户墙上。但当你提取现金时，成就就会消失。下面是代码。那么，我如何才能确定即使用户的银行账户中的现金消失了，成果也会留在哪里呢？

<?php 
if ( $userp['bank_account'] >= 100000 )
{
    echo 
    '<img src="achievements/Diamond-Bank.png"  hspace="5" width="65" height="65" title="Diamond Banker: Made a deposit of $100,000 or more!"">';
} 
elseif ( $userp['bank_account'] >= 50000  )
{
    echo 
    '<img src="achievements/Gold-Bank.png"  hspace="5" width="65" height="65" title="Golden Banker: Made a deposit of $50,000 of more."">';
}
elseif ( $userp['bank_account'] >= 1000 )
{
    echo 
    '<img src="achievements/Silver-Bank.png"  hspace="5" width="65" height="65" title="Silver Banker: Made a deposit of $1,000 or more."">';
}
elseif ( $userp['bank_account'] >= 1 )
{
    echo 
    '<img src="achievements/Bronze-Bank.png"  hspace="5" width="65" height="65" title="Bronze Banker: Opened a bank account!"">';
}
?>          

Answer 1

我会通过在mysql表中再添加一列来完成这项工作-- achievement with DEFAULT = 0。然后使用您的标准添加achievement徽章-

<?php 
if ( $userp['bank_account'] >= 100000 )
{
   "UPDATE table SET `achievement` = 4"
} 
elseif ( $userp['bank_account'] >= 50000  )
{
   "UPDATE table SET `achievement` = 3";
}
elseif ( $userp['bank_account'] >= 1000 )
{
   "UPDATE table SET `achievement` = 2";
}
elseif ( $userp['bank_account'] >= 1 )
{
   "UPDATE table SET `achievement` = 1";
}
?>      

然后查看achievement徽章-

<?php 
if ( $userp['achievement'] = 4 )
{
   echo 
   '<img src="achievements/Diamond-Bank.png"  hspace="5" width="65" height="65" title="Diamond Banker: Made a deposit of $100,000 or more!"">';
} 
elseif ( $userp['achievement'] = 3  )
{
   echo 
   '<img src="achievements/Gold-Bank.png"  hspace="5" width="65" height="65" title="Golden Banker: Made a deposit of $50,000 of more."">';
}
elseif ( $userp['achievement'] = 2 )
{
   echo 
   '<img src="achievements/Silver-Bank.png"  hspace="5" width="65" height="65" title="Silver Banker: Made a deposit of $1,000 or more."">';
}
elseif ( $userp['achievement'] = 1 )
{
   echo 
   '<img src="achievements/Bronze-Bank.png"  hspace="5" width="65" height="65" title="Bronze Banker: Opened a bank account!"">';
}
?>      

Answer 2

好吧，有几种可能的方法来解决这个问题。您可以将用户的所有成就存储在数据库中，并插入/选择它们。这样，即使余额下降，也不会丢失任何东西。

您还可以将“总”银行帐户相加，如果用户提取现金，该帐户不会减少。这样，您就可以使用$userp['bank_account_total']进行“成就检测”。