Of course don't work becouse column viptime is in table accounts.
BTW. I edited this script but don't works.
BTW. Column viptime is all time fill becouse in column viptime is lastlogin time + viptime...
BTW. I edited this script but don't works.
Code:
$id = $player->getCustomField("id");
$main_content .= '<TR BGCOLOR="'.$config['site']['darkborder'].'"><TD WIDTH=10%>Vip Status:</TD>';
$vip = $SQL->query('SELECT * FROM accounts WHERE id = '.$id.' AND `viptime` > 0;')->fetch();
if($vip == false)
{
$main_content .= '<TD><font color="red"><B>NOT VIP</B></font></TD>';
}
else
{
$main_content .= '<TD><font color="green"><B>VIP</B></font></TD>';
}
$main_content .= '</TABLE></td></tr>';
BTW. Column viptime is all time fill becouse in column viptime is lastlogin time + viptime...