anotapreta
New Member
- Joined
- Mar 12, 2010
- Messages
- 104
- Reaction score
- 0
I got storage 21444, and I got it little bugged, cuz in highscores all got word FREE, but they're vipped players, how can I fix it?
$vip = $SQL->query('SELECT `player_storage`.`player_id`, `player_storage`.`key`, `players`.`id` FROM `player_storage`, `players` WHERE `player_storage`.`player_id` = '.$player->getId().' AND `key` = 214441;')->fetchall();
if($vip[0]['key'] == 21444)
$vipp = '<center><font color="green"><b>VIP</b></font></center>';
else
$vipp = '<center><font color="red"><b>FREE</b></font></center>';
It should work.PHP:$vip = $SQL->query('SELECT `player_storage`.`player_id`, `player_storage`.`key`, `players`.`id` FROM `player_storage`, `players` WHERE `player_storage`.`player_id` = '.$player->getId().' AND `key` = 214441;')->fetchall(); if($vip[0]['key'] == 21444) $vipp = '<center><font color="green"><b>VIP</b></font></center>'; else $vipp = '<center><font color="red"><b>FREE</b></font></center>';
It should work.PHP:$vip = $SQL->query('SELECT `player_storage`.`player_id`, `player_storage`.`key`, `players`.`id` FROM `player_storage`, `players` WHERE `player_storage`.`player_id` = '.$player->getId().' AND `key` = 214441;')->fetchall(); if($vip[0]['key'] == 21444) $vipp = '<center><font color="green"><b>VIP</b></font></center>'; else $vipp = '<center><font color="red"><b>FREE</b></font></center>';
Where to put the storage id?
$vip = $SQL->query('SELECT `player_storage`.`player_id`, `player_storage`.`key`, `players`.`id` FROM `player_storage`, `players` WHERE `player_storage`.`player_id` = '.$player->getId().' AND `key` = HERE;')->fetchall();
if($vip[0]['key'] == HERE)
$vipp = '<center><font color="green"><b>VIP</b></font></center>';
else
$vipp = '<center><font color="red"><b>FREE</b></font></center>';
/* vip status - whoisonline.php by raiknd */
if($config['site']['show_vip_status'])
{
if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;
$vip = $SQL->query('SELECT * FROM player_storage WHERE `key` = 11551 AND `player_id` = '.$player['id'])->fetch();
if($vip == false) {
$players_rows .= '<TD width=3% align="center"><font color="red"><B>VIP</B></TD></TR>';
}
else
{
$players_rows .= '<TD width=3% align="center"><font color="green"><B>VIP</B></TD></TR>';
}
}