Solved Vip Players

[helflin]

I use VIP Account System By Mock 1.0, which uses the table "vip_time".

I have a page here that is showing vip players vip but that is for storage, would adapt this page to show the players vip system by mock?

<?PHP
$zapytanie = $SQL->query('SELECT `player_storage`.`player_id`, `player_storage`.`key`, `player_storage`.`value`, `players`.`id`, `players`.`name`, `players`.`level`, `players`.`online` FROM `player_storage`, `players` WHERE `key` = 19551 AND `player_storage`.`player_id` = `players`.`id` ORDER BY `players`.`level` DESC;')->fetchall();
foreach($zapytanie as $zap) {
$kolor++;
  if(is_int($kolor / 2))
  $bgcolor = $config['site']['lightborder'];
  else
  $bgcolor = $config['site']['darkborder'];
 
  if($zap['online'] == 0)
  $player_list_status = '<font color="red"><b>Offline</b></font>';
  else
  $player_list_status = '<font color="green"><b>Online</b></font>';
 
$tresc .= '<TR BGCOLOR='.$bgcolor.'><TD><center><a href="?subtopic=characters&name='.urlencode($zap['name']).'">'.$zap['name'].'</a></TD><TD><center>'.$zap['level'].'</TD><TD><center>'.$player_list_status.'</center></TD></TR>';
 
}
$main_content .= '<center><hr/><b>VIP List on '.$config['server']['serverName'].'.</b><hr/><br><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD CLASS=white WIDTH=32%><b><center>Name</center></b></TD><TD class="white" WIDTH=32%><b><center>Level</center></b></TD><TD class="white" WIDTH=32%><b><center>Status</center></b></TD></TR>'.$tresc.'</TABLE>';

$main_content .= '<div align="right"><small><b>OT Server.</b></small></div><br />';

?>

 

[kamilwxx]

<?PHP
$zapytanie = $SQL->query('SELECT `name`, `level`, `online` FROM `players` WHERE `account_id` IN (SELECT `id` FROM `accounts` WHERE `vip_time` > UNIX_TIMESTAMP());')->fetchall();
foreach($zapytanie as $zap) {
$kolor++;
if(is_int($kolor / 2))
$bgcolor = $config['site']['lightborder'];
else
$bgcolor = $config['site']['darkborder'];

if($zap['online'] == 0)
$player_list_status = '<font color="red"><b>Offline</b></font>';
else
$player_list_status = '<font color="green"><b>Online</b></font>';

$tresc .= '<TR BGCOLOR='.$bgcolor.'><TD><center><a href="?subtopic=characters&name='.urlencode($zap['name']).'">'.$zap['name'].'</a></TD><TD><center>'.$zap['level'].'</TD><TD><center>'.$player_list_status.'</center></TD></TR>';

}
$main_content .= '<center><hr/><b>VIP List on '.$config['server']['serverName'].'.</b><hr/><br><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD CLASS=white WIDTH=32%><b><center>Name</center></b></TD><TD class="white" WIDTH=32%><b><center>Level</center></b></TD><TD class="white" WIDTH=32%><b><center>Status</center></b></TD></TR>'.$tresc.'</TABLE>';

$main_content .= '<div align="right"><small><b>OT Server.</b></small></div><br />';

?>

 

[helflin]

Thank you.

Nice.