[Gesior ACC] Vip List

Aleh · May 2, 2010

Hello!
I wrote this script at the request Lava Titan.
Please don't copy the script to other forums.
Author of script: Aleh

Create a file viplist.php and paste:

PHP:

<?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>Author of script: <a href="http://otland.net/members/aleh/">Aleh</a></b></small></div><br />';

?>

OtLand

Screen:

>> The script for VIP Access, which works with my vip list <<

//////////////////////////////////// ////////////////////////////////////

!!! VIP Status in Hightscores !!!

File hightscores.php Change your file with it
or:
open hightscores.php, find the lines ~92 and paste

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` = 19551;')->fetchall();
if($vip[0]['key'] == 19551)
	$vipp = '<center><font color="green"><b>VIP</b></font></center>';
else
	$vipp = '<center><font color="red"><b>FREE</b></font></center>';

Next find

PHP:

<TD WIDTH=15% CLASS=whites><b><center>Level</center></B></TD>

and after that paste

PHP:

<TD WIDTH=5% CLASS=whites><b><center>Status</center></B></TD>

Now find

PHP:

<td><center>'.$skill['value'].'</center></td>

and after that paste

PHP:

<td>'.$vipp.'</td>

Screen:

Thanks PAXTON to a little help.

//////////////////////////////////// ////////////////////////////////////

!!! VIP Status in Characters !!!
Open characters.php, find the lines ~94

PHP:

                        if($config['site']['show_creationdate'] && $player->getCreated())
                        {
                                $main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD>Created:</TD><TD>'.date("j F Y, g:i a", $player->getCreated()).'</TD></TR>';
                        }

and after that paste

PHP:

                if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;
                    $main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD>Vip Status:</TD>';
                    $vip = $SQL->query('SELECT * FROM `player_storage` WHERE `player_id` = '.$player->getId().' AND `key` = 19551;')->fetch();
						if($vip == false) {
						$main_content .= '<TD><span class="red"><B>NOT VIP</B></TD></TR>';
						}
						else
						{
						$main_content .= '<TD><span class="green"><B>VIP</B></TD></TR>';
						}

If you already have VIP status replace it:

PHP:

$vip = $SQL->query('SELECT * FROM player_storage WHERE player_id = '.$id.' AND `key` = '.$config['site']['show_vip_storage'].';')->fetch();

to

PHP:

$vip = $SQL->query('SELECT * FROM `player_storage` WHERE `player_id` = '.$player->getId().' AND `key` = 19551;')->fetch();

Screen:

Thanks, REP ++!

Donaj · May 2, 2010

NIce, reput.

picachu · May 2, 2010

I want it to Premium players, not to storages.
Can you make one?
if u do i rep++ plx

Samme · May 2, 2010

Easy, but as I see you just beginning so its ok.

My idea for your next script: VIP List of players in the character look up.

president vankk · May 2, 2010

I do not use storange, I use a function.
would look like?
function = if vip.hasVip(cid) == true then

Zonet · May 2, 2010

Beon said:
I do not use storange, I use a function.
would look like?
function = if vip.hasVip(cid) == true then

:huh: ?

president vankk · May 2, 2010

vip my system, and not storange.
he and a function.

Lua:

if vip.hasVip(cid) == true then

Lava Titan · May 3, 2010

@Aleh

Thanks it looks nice!
I already repped you, but could you put it organizated by level?
Like highscores, and after name it would say [VIP].

Example: Aleh [VIP] | 130 | Online
Lava Titan [VIP] | 112 | Online

Zonet · May 3, 2010

Change this:

Code:

$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();

Lava Titan · May 3, 2010

What should i change it to? xD
Im a noob at PHP =/

Aleh · May 3, 2010

@up
Paste it:

PHP:

<?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>Author of script: <a href="http://otland.net/members/aleh/">Aleh</a></b></small></div><br />';

?>

Lava Titan · May 3, 2010

Hmm i found a bug

Staff appears on the scores,
GM+ shouldnt even if vip should appear at the vip list =/

Aleh · May 3, 2010

PHP:

<?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` AND `players`.`group_id` < '.$config['site']['players_group_id_block'].' AND `players`.`name` != "Account Manager" 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> <b>[VIP]</b></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>Author of script: <a href="http://otland.net/members/aleh/">Aleh</a></b></small></div><br />';

?>

???

Lava Titan · May 3, 2010

Hey what should i add on highscores.php to it be like this:

PHP:

http://eternia.vapus.net/news/?subtopic=highscores

Rank Name Level Status Experience
1. Slikest Druid 857 VIP 10451505024

PHP:

[IMG]http://i43.tinypic.com/2dcg5qs.jpg[/IMG]

oh btw:

=/

Lava Titan · May 3, 2010

Sorry for double post:

lisexlca · May 3, 2010

add it in index.php:

case "viplist";
$topic = "Viplist";
$subtopic = "viplist";
include("viplist.php");
break;

and it in your layout:

<a href='?subtopic=viplist'>
<div id='submenu_archive' class='Submenuitem' onMouseOver='MouseOverSubmenuItem(this)' onMouseOut='MouseOutSubmenuItem(this)'>
<div class='LeftChain' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);'></div>
<div id='ActiveSubmenuItemIcon_viplist' class='ActiveSubmenuItemIcon' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);'></div>
<div class='SubmenuitemLabel'>Vip List</div>
<div class='RightChain' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);'></div>
</div>
</a>

Aleh · May 3, 2010

Specially for you:
File hightscores.php Change your file with it
or:
open hightscores.php, find the lines ~92 and paste

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` = 19551;')->fetchall();
if($vip[0]['key'] == 19551)
	$vipp = '<center><font color="green"><b>VIP</b></font></center>';
else
	$vipp = '<center><font color="red"><b>FREE</b></font></center>';

Next find

PHP:

<TD WIDTH=15% CLASS=whites><b><center>Level</center></B></TD>

and after that paste

PHP:

<TD WIDTH=5% CLASS=whites><b><center>Status</center></B></TD>

Now find

PHP:

<td><center>'.$skill['value'].'</center></td>

and after that paste

PHP:

<td>'.$vipp.'</td>

Screen:

Thanks PAXTON to a little help.

Lava Titan · May 3, 2010

Thanks it works fine!
When i be able to rep you again ill do it!
XD
<3

picachu · May 4, 2010

Can you make it to 'premium' unstead 'storage'?

Aleh · May 4, 2010

I added:

The script for VIP Access, which works with my vip list,
VIP Status in Hightscores,
VIP Status in Characters.

[Gesior ACC] Vip List

Active Member

Banned User

Member

.::EmmaS-SammE::.

Web Developer & AuraOT Owner

Web Developer

Web Developer & AuraOT Owner

Developer

Web Developer

Developer

Active Member

Developer

Active Member

Developer

Developer

New Member

Active Member

Developer

Member

Active Member

Similar threads