[Gesior ACC] Vip List

[anotapreta]

:ninjaemo: http://mundinho.sytes.net:8090/?subtopic=highscores

 

[bok]

Can you make it to VIP'storage' change 'premium account'?

 

[Niebieski]

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?

 

[Aleh]

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.

 

[bok]

$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.

change for premium account

 

[Niebieski]

$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.

Working
Thank you.

 

[LucasFerraz]

I use mock vip system, and it dont work :<

 

[Eazy M]

Where to put the storage id?

 

[Aleh]

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>';

1. AND `key` = HERE;'
2. if($vip[0]['key'] == HERE)

 

[RaikND]

for whoisonline.php

/* 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>';
          		  }
				  }

 

[Eazy M]

Where to put the "Storage ID" of vip?

 

[angelababy]

Thanks so much for the wonderful information you provided us

 

[Aleh]

@Rasmus75
http://otland.net/f118/gesior-acc-vip-list-80526/index3.html#post1053812

 

[Eazy M]

@Aleh

Lol, forget that :O
Thanks ;D

 

[angelababy]

Thanks for sharing this great thread with me, i really glad to visit here.