-----------[SQL]----------------------------

CREATE TABLE IF NOT EXISTS `bb_vip_tarif` (
  `vip_tar_id` int(10) unsigned NOT NULL auto_increment,
  `vip_tar_name` varchar(120) NOT NULL,
  `vip_tar_time` int(11) NOT NULL,
  `vip_tar_price` int(11) NOT NULL,
  PRIMARY KEY  (`vip_tar_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=6 ;

INSERT INTO `bb_vip_tarif` (`vip_tar_id`, `vip_tar_name`, `vip_tar_time`, `vip_tar_price`) VALUES
(1, 'Lite', 2592000, 10),
(2, 'Medium', 5184000, 22),
(3, 'Mega', 15552000, 50);

ALTER TABLE `bb_users` ADD `vip_tarif` MEDIUMINT NOT NULL DEFAULT '0',
ADD `vip_ballance` FLOAT NOT NULL DEFAULT '0',
ADD `vip_start_date` INT NOT NULL DEFAULT '0',
ADD `vip_end_date` INT NOT NULL DEFAULT '0',
ADD `vip_lock` TINYINT NOT NULL DEFAULT '0'

--------------------------------------

bt/announce.php

----------------------------------------

// Up/Down addition

----- -----------------------------

// VIP
	$ctime = time();
	$vip = false;
	$vrow = DB()->fetch_row("
		SELECT *
		FROM bb_users
		WHERE user_id = '".$user_id."'
		LIMIT 1
	");
	if ($vrow['vip_tarif'] > 0 AND $vrow['vip_ballance'] >=0 AND $vrow['vip_start_date'] < $ctime AND $vrow['vip_end_date'] > $ctime AND $vrow['vip_lock'] < 1)
	{
		$vip = true;
	}
	else if ($vrow['vip_tarif'] > 0 AND $vrow['vip_ballance'] >=0 AND $vrow['vip_lock'] < 1)
	{
		$tarif = $vrow['vip_tarif'];
		$ballance = $vrow['vip_ballance'];
		$trow = DB()->fetch_row("SELECT * FROM bb_vip_tarif WHERE vip_tar_id = '".$tarif."'");
		$ostatok = $ballance - $trow['vip_tar_price'];
		$time_s = $ctime;
		$time_e = $ctime + $trow['vip_tar_time'];
		if ($ostatok >= 0)
		{
			$sql = "UPDATE bb_users SET vip_ballance = '".$ostatok."', 	vip_start_date = '".$time_s."', vip_end_date = '".$time_e."' WHERE user_id = '".$user_id."'";
			DB()->query($sql);
			$vip = true;
		}
		
	}
	
----------------------------------------

	$sql .= ($down_add) ? ", down_add = down_add + $down_add" : '';

-------------------------------------

	if ($vip == true ) 
	{
	$sql .= ($down_add) ? ", down_add = 0" : '';
	} 
	else
	{
	$sql .= ($down_add) ? ", down_add = down_add + $down_add" : '';
	}
	
--------------------------------------

includes/usercp_viewprofile.php

----------------------------------------

//
// Generate page
//

$signature = ($bb_cfg['allow_sig'] && $profiledata['user_sig']) ? $profiledata['user_sig'] : '';

if(bf($profiledata['user_opt'], 'user_opt', 'allow_sig'))
{
	if($profiledata['user_id'] == $userdata['user_id'])
	{
		$signature = $lang['SIGNATURE_DISABLE'];
	}
	else
	{
		$signature = '';
	}
}
else if ($signature)
{
	$signature = bbcode2html($signature);
}

------ -------------------------

//
//   VIP
//
$vrow = DB()->fetch_row("SELECT * FROM bb_vip_tarif WHERE vip_tar_id = '".$profiledata['vip_tarif']."'");
$cur_date = time();
if ($profiledata['vip_ballance'] >=0 AND $profiledata['vip_tarif'] > 0 AND $profiledata['vip_start_date']<$cur_date AND $profiledata['vip_end_date'] > $cur_date AND $profiledata['vip_lock'] < 1)
{
$template->assign_vars(array(
	'NO_ADD'	=> true
));
}

if ($userdate['user_id'] = $profiledata['user_id'] or $userdate['user_level']=2)
{
if ($profiledata['vip_ballance'] >= 0 )
{
	if ($profiledata['vip_tarif'] > 0 )
	{
		if ($profiledata['vip_start_date'] < $cur_date)
		{
			if ($profiledata['vip_end_date'] > $cur_date)
			{
				if ($profiledata['vip_lock'] < 1)
				{
					$vip_body = '<strong style="color:darkred"><b>VIP</b></strong><tr><th> :</th><td><strong style="color:#009900">'.$vrow['vip_tar_name'].'</strong></td></tr><tr><th>:</th><td>'.$profiledata['vip_ballance'].'</td></tr><tr><th>:</th><td>'.bb_date($profiledata['vip_start_date']).'</td></tr><tr><th>:</th><td>'.bb_date($profiledata['vip_end_date']).'</td></tr>';
				}
				else
				{
					$vip_body = '<strong style="color:darkred"><b>NO VIP</b></strong>&nbsp;   VIP   ,       <a href="profile.php?mode=viewprofile&u=2"><b></b></a>';
				}
			}
			else
			{
				$vip_body = '<strong style="color:darkred"><b>NO VIP</b></strong>&nbsp;    VIP   <b>'.bb_date($profiledata['vip_end_date']).'</b>,       <a href="profile.php?mode=viewprofile&u=2"><b></b></a>';
			}
		}
		else
		{
			$vip_body = '<strong style="color:darkred">NO VIP</strong>&nbsp;   VIP   <b>'.bb_date($profiledata['vip_start_date']).'</b>,       <a href="profile.php?mode=viewprofile&u=2"><b></b></a>';
		}
	}
	else
	{
		$vip_body = '<strong style="color:darkred"><b>NO VIP</b></strong>&nbsp;     VIP,     <a href="profile.php?mode=viewprofile&u=2"><b></b></a>';
	}
}
else
{
	$vip_body = '<strong style="color:darkred"><b>NO VIP</b></strong>&nbsp;             VIP,       <a href="profile.php?mode=viewprofile&u=2"><b></b></a>';
}
}
else
{
$vip_body = '<strong style="color:darkred"><b>VIP</strong>&nbsp;  : <strong style="color:#009900">'.$vrow['vip_tar_name'].'</strong>';
}
// 

---------------------------------------

'S_PROFILE_ACTION'     => "profile.php",

------ ------------------------

'VIP_BODY'			=> $vip_body,
	
-----------------------------------

templates/default/usercp_viewprofile.tpl

----------------------------------------

				<span class="med">{L_IT_WILL_BE_DOWN} <b>{MIN_DL_FOR_RATIO}</b></span>
				<!-- ENDIF -->
			</td>
		</tr>

------ -----------------------

		<tr>
			<th>:</th>
			<td>{VIP_BODY}</td>
		</tr>

---------------------------------------

	<!-- IF IS_ADMIN -->
	<p class="floatR">

------ ------------------------

<a href="add_vip.php?v={PROFILE_USER_ID}" title=" VIP"> VIP   <b>{USERNAME}</b></a>&nbsp;

-------------------------------------

/viewtopic.php

----------------------------------------

	  p.*,
	  
------ ------------------------

	  u.vip_ballance, u.vip_tarif,u.vip_start_date, u.vip_end_date, u.vip_lock,

----------------------------------------

	//
	// Again this will be handled by the templating
	// code at some point
	//

------ -----------------------

	// VIP mod	
	$vip_body = '';
	$cur_date = time();
	
	if ($postrow[$i]['vip_ballance'] >= 0 )
	{
		if ($postrow[$i]['vip_tarif'] > 0 )
		{
			if ($postrow[$i]['vip_start_date'] < $cur_date)
			{
				if ($postrow[$i]['vip_end_date'] > $cur_date)
				{
					if ($postrow[$i]['vip_lock'] < 1)
					{
						$vip_body = '<a href="vip_list.php"><img src="images/vip.png" title="VIP " alt="VIP "/></a>';
					}
					else
					{
						$vip_body = '';
					}
				}
				else
				{
					$vip_body = '';
				}
			}
			else
			{
				$vip_body = '';
			}
		}
		else
		{
			$vip_body = '';
		}
	}

--------------------------------------

		'POSTER_JOINED'      => ($bb_cfg['show_poster_joined']) ? $poster_longevity : '',
		
------ ----------------------

		'VIP'				 => $vip_body,

---------------------------------

templates/default/page_header.tpl

--------------------------------------

<a href="{U_GROUP_CP}"><b>{L_USERGROUPS}</b></a>&#0183;

------ ----------------------

			<a href="vip_list.php"><b style="color:darkred">VIP</b> <b></b></a>&#0183;

---------------------------------

/templates/default/viewtopic.tpl

--------------------------------------

{postrow.POSTER_RANK}</p><!-- ENDIF -->

------, ---------------------

<!-- IF postrow.VIP --><p>{postrow.VIP}</p><!-- ENDIF -->


------------------------------------------

Eom
