sgp_features

<script type="text/javascript">
$(document).ready(function() {
$('html head').find('title').text("Features :: S.G. Paste");
});
</script>

<?php
$today = date("Y-m-d h:i:s");
$todayDate = date("Y-m-d");
$todayTime = date("h:i:s");


$sgpfree = mysql_query(SELECT * FROM features WHERE plan=free);
if ($sgpfree) {
$sgpf = mysql_fetch_row($sgpfree);

$date1a = $sgpf['signup_block_date_start'];
$date2a = $sgpf['signup_block_date_end'];

$time1a = $sgpf['signup_block_time_start'];
$time2a = $sgpf['signup_block_time_end'];

$start1 = strtotime('$date1a .$time1a.');
$end1 = strtotime('$date2a .$time2a.');
$fsbr = ceil(abs($start1 - $end1) / 3600);


$start1a = strtotime('$date1a');
$end1a = strtotime('$date2a');
$fsbdr = ceil(abs($start - $end) / 86400);
$start1b = strtotime('$time1a');
$end1b = strtotime('$time2a');
$fsbtr = ceil(abs($start1a - $end1b) / 3600);

if ($fsbr <= 0) {
$freeSignup = "<a href='/sgpaste/register/plan/".$sgpf['plan']."'><img src='/sgpaste/global/images/free_signup.png' alt='Free Signup'/>";
}

}

$sgpremium = mysql_query(SELECT * FROM `features` WHERE plan='premium');
if ($sgpremium) {
$sgpp = mysql_fetch_row($sgpremium);


$date1b = $sgpf['signup_block_date_start'];
$date2b = $sgpf['signup_block_date_end'];

$time1b = $sgpf['signup_block_time_start'];
$time2b = $sgpf['signup_block_time_end'];

$start2 = strtotime('$date1b .$time1b.');
$end2 = strtotime('$date2b .$time2b.');
$fsbr = ceil(abs($start2 - $end2) / 3600);


$start2a = strtotime('$date1b');
$end2a = strtotime('$date2b');
$psbdr = ceil(abs($start2a - $end2a) / 86400);
# echo "Remaining: ".$psbdr."days";

$start2b = strtotime('$time1b');
$end2b = strtotime('$time2b');
$psbtr = ceil(abs($start2a - $end2b) / 3600);
echo "Remaining: ".$psbtr."hours";


if ($psbr <= 0) {
$premiumSignup = "<a href='/sgpaste/register/plan/".$sgpp['plan']."'><img src='/sgpaste/global/images/premium_signup.png' alt='Premium Signup'/>";
}

}

$sgpsuper = mysql_query(SELECT * FROM `features` WHERE plan='super');
if ($sgpsuper) {
$sgps = mysql_fetch_row($sgpsuper);

$date1c = $sgpf['signup_block_date_start'];
$date2c = $sgpf['signup_block_date_end'];

$time1c = $sgpf['signup_block_time_start'];
$time2c = $sgpf['signup_block_time_end'];

$start3 = strtotime('$date1c .$time1c.');
$end3 = strtotime('$date2c .$time2c.');
$ssbr = ceil(abs($start3 - $end3) / 3600);
# echo "Total Remaining: ".$ssbr."hours";

$start3a = strtotime('$date1c');
$end3a = strtotime('$date2c');
$ssbdr = ceil(abs($start3a - $end3a) / 86400);
# echo "Remaining: ".$ssbdr."days";

$start3b = strtotime('$time1c');
$end3b = strtotime('$time2c');
$ssbtr = ceil(abs($start3a - $end3b) / 3600);
# echo "Remaining: ".$ssbtr."hours";


if ($ssbr <= 0) {
$superSignup = "<a href='/sgpaste/register/plan/".$sgps['plan']."'><img src='/sgpaste/global/images/super_signup.png' alt='Super Signup'/>";
}

}
?>

<h1>SGPaste</h1>
<div class="welcome">
Welcome to SGPaste. Notepad is in your hand. Paste anything you want or directly upload your file with Syntax Highlighting. Get a short link to your paste.
</div>
<table cellspacing="3" width="100%">
<tr>
<th>Features</th>
</tr>
<tr class="bold">
<td>&nbsp;</td>
<td colspan="2"><?php echo $sgpf['name'];?></td>
<td colspan="2"><?php echo $sgpp['name'];?></td>
<td colspan="2"><?php echo $sgps['name'];?></td>
</tr>
<tr>
<td>Paste Limit</td>
<td><?php echo $sgpf['paste_limit'];?></td>
<td><?php echo $sgpp['paste_limit'];?></td>
<td><?php echo $sgps['paste_limit'];?></td>
</tr>
<tr>
<td>Available Syntax</td>
<td><?php echo $sgpf['syntax'];?></td>
<td><?php echo $sgpp['syntax'];?></td>
<td><?php echo $sgps['syntax'];?></td>
</tr>

<tr>
<td>Direct File Upload</td>
<td><?php echo $sgpf['upload'];?></td>
<td><?php echo $sgpp['upload'];?></td>
<td><?php echo $sgps['upload'];?></td>
</tr>

<tr>
<td>Paste Edit/Modification Access</td>
<td><?php echo $sgpf['edit'];?></td>
<td><?php echo $sgpp['edit'];?></td>
<td><?php echo $sgps['edit'];?></td>
</tr>

<tr>
<td>Paste Rename Access</td>
<td><?php echo $sgpf['rename'];?></td>
<td><?php echo $sgpp['rename'];?></td>
<td><?php echo $sgps['rename'];?></td>
</tr>

<tr>
<td>Paste Delete Access</td>
<td><?php echo $sgpf['delete'];?></td>
<td><?php echo $sgpp['delete'];?></td>
<td><?php echo $sgps['delete'];?></td>
</tr>

<tr>
<td>Modification Limit</td>
<td><?php echo $sgpf['mlimit'];?></td>
<td><?php echo $sgpp['mlimit'];?></td>
<td><?php echo $sgps['mlimit'];?></td>
</tr>

<tr>
<td>Account Badge</td>
<td><?php echo $sgpf['badge'];?></td>
<td><?php echo $sgpp['badge'];?></td>
<td><?php echo $sgps['badge'];?></td>
</tr>

<tr>
<td>Account Fees</td>
<td><?php echo $sgpf['acfees'];?></td>
<td><?php echo $sgpp['acfees'];?></td>
<td><?php echo $sgps['acfees'];?></td>
</tr>

<tr>
<td>Monthly Fees</td>
<td><?php echo $sgpf['mfees'];?></td>
<td><?php echo $sgpp['mfees'];?></td>
<td><?php echo $sgps['mfees'];?></td>
</tr>

<tr>
<td>Yearly Fees</td>
<td><?php echo $sgpf['yfees'];?></td>
<td><?php echo $sgpp['yfees'];?></td>
<td><?php echo $sgps['yfees'];?></td>
</tr>

<tr>
<td>Upgrade Price</td>
<td><?php echo $sgpf['uprice'];?></td>
<td><?php echo $sgpp['uprice'];?></td>
<td><?php echo $sgps['uprice'];?></td>
</tr>

<tr>
<td>Signup</td>
<td><?php echo $freeSignup;?></td>
<td><?php echo $premiumSignup;?></td>
<td><?php echo $superSignup;?></td>
</tr>
</table>