<?php

// PiggyBank Marketplace Plugin
// �2021 Logiscape.com

	require_once "inc/filter.php";
	session_start();
	include "inc/userauth.php";
	$userid = $_SESSION["userid"];
	
	$getuserdata = lfmsql_query("Select email, mtype, lastip, joindate from ".$prefix."members where Id=$userid");
	$useremail = lfmsql_result($getuserdata, 0, "email");
	$mtype = lfmsql_result($getuserdata, 0, "mtype");
	$memip = lfmsql_result($getuserdata, 0, "lastip");
	$joindate = lfmsql_result($getuserdata, 0, "joindate");
	
	$piggybal = lfmsql_result(lfmsql_query("SELECT SUM(amount) from ".$prefix."piggybank where userid=$userid and status='0'"), 0);
	if (!is_numeric($piggybal) || $piggybal < 0) { $piggybal = "0.00"; }
	
	// get member discount
	$getdiscount = lfmsql_query("SELECT discount FROM `".$prefix."pmarket_discounts` WHERE mtype='".$mtype."'") or die(lfmsql_error());
	if($row = lfmsql_fetch_assoc($getdiscount)) {
		$discount = $row['discount'];
	} else {
		$discount = 0;
	}
	
function mp_buy() {
	global $prefix;
	global $userid;
	global $useremail;
	global $mtype;
	global $memip;
	global $piggybal;
	global $discount;
	
	//get product info
	$result = lfmsql_query("SELECT * FROM `".$prefix."pmarket_products` WHERE (available > 0 OR is_permanent=1) AND id = '".$_REQUEST['pid']."'") or die(lfmsql_error());
	if($row = lfmsql_fetch_assoc($result)) {
		
		if (is_numeric($discount) && $discount > 0 && $discount < 100) {
			$row['product_price'] = round( $row['product_price'] - ($row['product_price'] * ($discount/100) )  ,2);
		}
		
		//vip only items
		if($row['upgrademtype'] > 0 && $mtype > 1) {
			header('Location:pmarket.php?mes=You already have an upgraded account');
			exit;
		}
		
		if ($piggybal < $row['product_price']) {
			header('Location:pmarket.php?mes=You do not have enough in your balance to buy this product');
			exit;
		}
		
		//if this is a super deal, then allow only one per member
		if ($row['is_permanent'] < 1) {
			$result2 = lfmsql_query("SELECT * FROM `".$prefix."pmarket_purchased` WHERE user_id = ".$userid." AND product_id = ".$row['id']." ");
			if($row2 = lfmsql_fetch_assoc($result2)) {
				header('Location:pmarket.php?mes=Limited items are limited to 1 per member');
				exit;
			}
		}
		
		if ($row['product_type'] == 'upgrade') {
			$displayname = lfmsql_result(lfmsql_query("SELECT accname FROM `".$prefix."membertypes` WHERE mtid='".$row['upgrademtype']."'"), 0);
			$displayname .= ' - '.$row['product_value'].' day'; if ($row['product_value'] > 0) { $displayname .= 's'; }
		} elseif ($row['product_type'] == 'jetfuel') {
			$displayname = lfmsql_result(lfmsql_query("SELECT name FROM `".$prefix."jetfuel` WHERE id='".$row['product_value']."'"), 0);
		} else {
			$displayname = $row['product_value'].' '.mp_itemtypename($row['product_type']);
		}
		
		//deduct balance
		$subamount = 0-$row['product_price'];
		lfmsql_query("INSERT INTO ".$prefix."piggybank (userid, transdate, descr, amount, status, ipnsaleid) VALUES (".$userid.", NOW(), 'Marketplace Purchase: ".addslashes($displayname)."', ".$subamount.", '0', '0')") or die(lfmsql_error());
		
		
		//sub quantity
		lfmsql_query("UPDATE `".$prefix."pmarket_products` SET available = available - 1 WHERE id = ".$row['id']." ") or die(lfmsql_error());
			
			// add the product
			
			switch ($row['product_type']) {
				case "credits":
				  $prebalance = lfmsql_result(lfmsql_query("SELECT credits FROM ".$prefix."members WHERE Id='$userid'"), 0);
				  lfmsql_query("UPDATE ".$prefix."members SET credits=credits+'".$row['product_value']."' WHERE Id='$userid' ") or die(lfmsql_error());
				  break;
				case "bannerimps":
				  $prebalance = lfmsql_result(lfmsql_query("SELECT bannerimps FROM ".$prefix."members WHERE Id='$userid'"), 0);
				  lfmsql_query("UPDATE ".$prefix."members SET bannerimps=bannerimps+'".$row['product_value']."' WHERE Id='$userid' ") or die(lfmsql_error());
				  break;
				case "textimps":
				  $prebalance = lfmsql_result(lfmsql_query("SELECT textimps FROM ".$prefix."members WHERE Id='$userid'"), 0);
				  lfmsql_query("UPDATE ".$prefix."members SET textimps=textimps+".$row['product_value']." WHERE Id='$userid' ") or die(lfmsql_error());
				  break;
				case "peelads":
				  $prebalance = lfmsql_result(lfmsql_query("SELECT peelimps FROM ".$prefix."members WHERE Id='$userid'"), 0);
				  lfmsql_query("UPDATE ".$prefix."members SET peelimps=peelimps+".$row['product_value']." WHERE Id='$userid' ") or die(lfmsql_error());
				  break;
				case "sqbans":
				  $prebalance = lfmsql_result(lfmsql_query("SELECT sqbanimps FROM ".$prefix."members WHERE Id='$userid'"), 0);
				  lfmsql_query("UPDATE ".$prefix."members SET sqbanimps=sqbanimps+".$row['product_value']." WHERE Id='$userid' ") or die(lfmsql_error());
				  break;
				case "porkyps":
				  if (file_exists("inc/porkyp_funcs.php")) {
					require_once "inc/porkyp_funcs.php";
					$porkytransfer = porkytransferpoints($useremail, $memip, $row['product_value']);
				  }
				  break;
				case "xppoints":
				  lfmsql_query("UPDATE ".$prefix."members SET dailyXP=dailyXP+".$row['product_value']." WHERE Id='$userid' ") or die(lfmsql_error());
				  break;
				  
				case "mbranders":
				  $prebalance = lfmsql_result(lfmsql_query("SELECT mbrandimps FROM ".$prefix."members WHERE Id='$userid'"), 0);
				  lfmsql_query("UPDATE ".$prefix."members SET mbrandimps=mbrandimps+".$row['product_value']." WHERE Id='$userid' ") or die(lfmsql_error());
				  break;
				case "trafficpods":
				  require_once "inc/trafficpods_funcs.php";
				  $getpodfield = lfmsql_query("SELECT id FROM ".$prefix."customfields WHERE name='Pod Points'");
					if (lfmsql_num_rows($getpodfield) > 0) {
						$podfield = lfmsql_result($getpodfield, 0, "id");
				  		$prebalance = lfmsql_result(lfmsql_query("SELECT fieldvalue FROM ".$prefix."customvals WHERE userid='$userid' AND fieldid=".$podfield), 0);
				  	} else {
				  		$prebalance = 0;
				  	}
				  trafficpods_addpoints($userid, $row['product_value']);
				  break;
				case "jetfuel":
				  
				  $getjetfuelpack = lfmsql_query("SELECT * FROM `".$prefix."jetfuel` WHERE id='".$row['product_value']."'");
					
					if (lfmsql_num_rows($getjetfuelpack) > 0) {
						
						$packname = lfmsql_result($getjetfuelpack, 0, "name");
						$duration = lfmsql_result($getjetfuelpack, 0, "duration");
						$multiplier = lfmsql_result($getjetfuelpack, 0, "multiplier");
						
						// Check Existing
						$getexisting = lfmsql_query("SELECT endtime FROM ".$prefix."jetfuel_users WHERE userid='".$userid."' AND active='1' ORDER BY endtime DESC LIMIT 1") or die(lfmsql_error());
						if (lfmsql_num_rows($getexisting) > 0) {
							$existingend = lfmsql_result($getexisting, 0, "endtime");
							$timeleft = $existingend - time();
							if ($timeleft < 1) {
								$timeleft = 0;
							}
						} else {
							$timeleft = 0;
						}
						
						$starttime = time() + $timeleft + 1;
						$endtime = $starttime + round($duration * 3600);
						lfmsql_query("INSERT INTO ".$prefix."jetfuel_users (userid, starttime, endtime, multiplier, active, fromtype) VALUES('".$userid."', '".$starttime."', '".$endtime."', '".$multiplier."', '1', 'Marketplace Purchase')") or die(lfmsql_error());
						
					}
				  
				  break;
				  case "upgrade":
				  
				  $getacctype = lfmsql_query("SELECT accname FROM `".$prefix."membertypes` WHERE mtid='".$row['upgrademtype']."'");
					
					if (lfmsql_num_rows($getacctype) > 0) {
						$today=date("Y-m-d");
						$expdays = $row['product_value'] + 1;
						$exp=strftime("%Y-%m-%d",strtotime("$today + ".$expdays." days"));
						$upg_query = 'update '.$prefix.'members set mtype='.$row['upgrademtype'].', upgend="'.$exp.'" where Id='.$userid.' limit 1';
						lfmsql_query($upg_query) or die(lfmsql_error());
					}
				  
				  break;
			}
			
			// Handle Commissions
			$paycomms = lfmsql_result(lfmsql_query("Select value from `".$prefix."pmarket_settings` where field='paycomms'"), 0);
			if ($paycomms > 0) {
				
				$refid = lfmsql_result(lfmsql_query("SELECT refid FROM ".$prefix."members WHERE Id='$userid'"), 0);
				
				if ($refid > 0) {
				
					$affid = $refid;

				//Process LFM Commission
				    $affqry="SELECT username, email, mtype FROM ".$prefix."members WHERE Id=$affid";
				    $affres=@lfmsql_query($affqry);
				    $affrow=@lfmsql_fetch_array($affres);
				
				$commqry="SELECT comm FROM ".$prefix."membertypes WHERE mtid=".$affrow["mtype"];
				    $commres=@lfmsql_query($commqry);
				    $commrow=@lfmsql_fetch_array($commres);
				    $comper = $commrow["comm"];
				    
				    if($comper > 0) {
				    $affcom=round((($comper/100)*$row['product_price']),2);

				    // Sales table keeps affiliate commission stats
				    $saleqry="INSERT INTO ".$prefix."sales (affid, purchaserid, saledate, itemid, itemname, itemamount, commission, txn_id, salestier) VALUES ($affid, ".$userid.", NOW(), '0', 'Marketplace Sale: ".addslashes($displayname)."', ".$row['product_price'].", $affcom, '', 1)";
				    lfmsql_query($saleqry);
				    
				    }

				    // Check for tier 2 commission
					// Get referrer so we can insert this sale into the database
				    $ul2qry="SELECT refid FROM ".$prefix."members WHERE Id=$affid";
				    $ul2res=@lfmsql_query($ul2qry);

				    if($ul2res)
				    {
					    $ul2row=@lfmsql_fetch_array($ul2res);
					    $aff2id=$ul2row["refid"];

						// Find out the affiliate's member type for commission
						$aff2qry="SELECT mtype FROM ".$prefix."members WHERE Id=$aff2id";
						$aff2res=@lfmsql_query($aff2qry);
						$aff2row=@lfmsql_fetch_array($aff2res);
					
						$comm2qry="SELECT comm2 FROM ".$prefix."membertypes WHERE mtid=".$aff2row["mtype"];
							$comm2res=@lfmsql_query($comm2qry);
							$comm2row=@lfmsql_fetch_array($comm2res);
							$comper2 = $comm2row["comm2"];
						
						if($comper2 > 0)
						{
							$aff2com=round((($comper2/100)*$row['product_price']),2);
	
							// Sales table keeps affiliate commission stats
							$sale2qry="INSERT INTO ".$prefix."sales(affid, purchaserid, saledate, itemid, itemname, itemamount, commission, txn_id, salestier) VALUES ($aff2id, ".$userid.", NOW(), '0', 'Marketplace Sale: ".addslashes($displayname)."', ".$row['product_price'].", $aff2com, '', 2)";
							lfmsql_query($sale2qry);
						}
					
					}
				//End Process LFM Commission

					}
				//End commissions
				
			}
			
			if (isset($prebalance) && is_numeric($prebalance)) {
				$postbalance = $prebalance + $row['product_value'];
			} else {
				$prebalance = 0;
				$postbalance = 0;
			}
			
			// record purchase
			lfmsql_query("INSERT INTO `".$prefix."pmarket_purchased` (user_id, product_type, `descr`, upgrademtype, product_value, product_price, date_purchased, pre_balance, post_balance, product_id, producttype_id) VALUES (".$userid.", '".addslashes($row['product_type'])."', '".addslashes($row['descr'])."', ".$row['upgrademtype'].", ".$row['product_value'].", ".$row['product_price'].", NOW(), '".$prebalance."', '".$postbalance."', ".$row['id'].", ".$row['producttype_id'].") ") or die(lfmsql_error());
		
		//return
		header('Location:pmarket.php?mes=Purchase Successful!');
		
	} else {
		header('Location:pmarket.php?mes=Selected product is expired or sold out');
		exit;
	}
	
}

function mp_itemtypename($itemtype) {
	$itemtypename = '';
	switch ($itemtype) {
		case "credits":
		  $itemtypename = 'Credits';
		  break;
		case "bannerimps":
		  $itemtypename = 'Banner Impressions';
		  break;
		case "textimps":
		  $itemtypename = 'Text Impressions';
		  break;
		case "peelads":
		  $itemtypename = 'Peel Ads';
		  break;
		case "sqbans":
		  $itemtypename = 'Square Banners';
		  break;
		case "porkyps":
		  $itemtypename = 'Porky Points';
		  break;
		case "xppoints":
		  $itemtypename = 'XP Points';
		  break;
		case "mbranders":
		  $itemtypename = 'Mini Branders';
		  break;
		case "trafficpods":
		  $itemtypename = 'Pod Points';
		  break;
	}
	return $itemtypename;
}
	
	$enablepayxfer = lfmsql_result(lfmsql_query("Select value from `".$prefix."pmarket_settings` where field='enabled'"), 0);
	if ($enablepayxfer < 1) {
		echo("The marketplace is not enabled");
		exit;
	}
	
	if (isset($_GET['b']) && $_GET['b'] == 'buy') {
		mp_buy();
	}
	
	include "inc/theme.php";
	
	load_template ($theme_dir."/header.php");
	load_template ($theme_dir."/mmenu.php");
	
	if (isset($_GET['mes'])) {
		$page_content .= '<h4 style="color:darkred; text-align:center;">'.$_GET['mes'].'</h4><br>';
	}
	
	$headercontent = lfmsql_result(lfmsql_query("SELECT template_data FROM `".$prefix."templates` WHERE template_name='pmarket_header'"), 0);
	if (function_exists('html_entity_decode')) {
		$headercontent = html_entity_decode($headercontent);
	} else {
		$headercontent = unhtmlentities($headercontent);
	}
	$headercontent = translate_site_tags($headercontent);
	$headercontent = translate_user_tags($headercontent, $useremail);
	
	$page_content .= $headercontent;
	
	if (isset($_GET['viewhistory']) && $_GET['viewhistory'] > 0) {
		
		$page_content .= '<center>
		<div>
		<h2>Purchase History</h2>
		<p><a href="pmarket.php">Return to the marketplace</a></p>
		<table cellpadding="0" cellspacing="0" class="table_mp">
		<tr>
			<td>Product</td>
			<td nowrap>Pre-balance</td>
			<td nowrap>Post-balance</td>
			<td>Price</td>
			<td>Date Purchased</td>
		</tr>
			';
		$found = 0;
		$result = lfmsql_query("SELECT * FROM `".$prefix."pmarket_purchased` WHERE user_id = ".$userid." ORDER BY date_purchased DESC ");
		while($row = lfmsql_fetch_assoc($result)) {
			$found = 1;
			if($row['product_type'] != 'upgrade' && $row['product_type'] != 'jetfuel') {
				$pre = number_format($row['pre_balance'],2,'.',',');
				$post = number_format($row['post_balance'],2,'.',',');
				
				if($pre == 0) $pre = 'N/A';
				if($post == 0) $post = 'N/A';
			} else {
				$pre = '-';
				$post = '-';
			}
			
			if ($row['product_type'] == 'upgrade') {
				$displayname = lfmsql_result(lfmsql_query("SELECT accname FROM `".$prefix."membertypes` WHERE mtid='".$row['upgrademtype']."'"), 0);
				$displayname .= ' - '.$row['product_value'].' day'; if ($row['product_value'] > 0) { $displayname .= 's'; }
			} elseif ($row['product_type'] == 'jetfuel') {
				$displayname = lfmsql_result(lfmsql_query("SELECT name FROM `".$prefix."jetfuel` WHERE id='".$row['product_value']."'"), 0);
			} else {
				$displayname = $row['product_value'].' '.mp_itemtypename($row['product_type']);
			}
			
			$page_content .= '
			<tr>
				<td><strong>'.$displayname.'</strong></td>
				<td>'.$pre.'</td>
				<td>'.$post.'</td>
				<td>'.$row['product_price'].'</td>
				<td>'.$row['date_purchased'].'</td>
			</tr>';
		}
	if($found == 0) {
		$page_content .= '<tr><td colspan="4"> no recent purchases </td></tr>';
	}
	$page_content .= '
		</table>
		</div>';
 		
		
		load_template ($theme_dir."/content.php");
		load_template ($theme_dir."/footer.php");
		exit;
		
	}	
	
	if($_REQUEST['b'] == 'prod_details') {
		
		//get product info
		$result = lfmsql_query("SELECT *, 24 - round((unix_timestamp(NOW()) - unix_timestamp(date_active))/3600) as expires FROM `".$prefix."pmarket_products` WHERE (available > 0 OR is_permanent=1) AND id = '".$_REQUEST['pid']."'");
		if($row = lfmsql_fetch_assoc($result)) {
			if($row['expires'] < 1) $row['expires'] = 1;
			$expires = $row['expires'].' hours';
			
			if($row['expires'] == 1) $expires = '<span style="font-weight:bold;color:#FF0000;">'.(60-date("i")).' mins';
			$prod = $row;
		} else {
			header('Location:pmarket.php?mes=Selected product is expired or sold out');
			exit;
		}
		
		$disabled = '';
		$buy_now = 'Buy Now';
		
		if ($row['product_type'] == 'upgrade') {
			$displayname = lfmsql_result(lfmsql_query("SELECT accname FROM `".$prefix."membertypes` WHERE mtid='".$row['upgrademtype']."'"), 0);
			$displayname .= ' - '.$row['product_value'].' day'; if ($row['product_value'] > 0) { $displayname .= 's'; }
		} elseif ($row['product_type'] == 'jetfuel') {
			$displayname = lfmsql_result(lfmsql_query("SELECT name FROM `".$prefix."jetfuel` WHERE id='".$row['product_value']."'"), 0);
		} else {
			$displayname = $row['product_value'].' '.mp_itemtypename($row['product_type']);
		}
		
		$page_content .= '
		
		<div id="mp_details">
			<h3>'.$displayname.'</h3>
			<br><br>
			<h4>Price: $'.$prod['product_price'].'</h4><br>';
			
			if (is_numeric($discount) && $discount > 0 && $discount < 100) {
				$discountprice = round( $row['product_price'] - ($row['product_price'] * ($discount/100) )  ,2);
				$discountprice = number_format((float)$discountprice, 2, '.', '');
				$page_content .= '<h4><b>Your Discount Price: $'.$discountprice.'</b></h4><br>';
			}
			
			$page_content .= '<form action="pmarket.php?b=buy&pid='.$prod['id'].'" method="post">
				<input type="submit" name="submit" '.$disabled.' value="'.$buy_now.'">
				<br><br>
			</form>
		</div>	
		<br><br>
		
		';
		
	}

	
	// limited time items
	
	if($_REQUEST['ob']) {
		$order_by = $_REQUEST['ob'];
	} else {
		$order_by = 'date_active DESC';
	}
	
	$page_content .= '
	<a name="all"></a>
	<div id="mp_all">
	<br>
	<h3>Limited Items</h3><p>These items are only available for a limited time and may sell out quickly!</p>
		<table cellpadding="0" cellspacing="0" class="table_mp">
		<tr>
			<td><a href="pmarket.php?ob=product_type#all">Product</a></td>
			<td><a href="pmarket.php?ob=available#all">Qty Remaining</a></td>
			<td><a href="pmarket.php?ob=date_active#all">Expires in</a>&nbsp;&nbsp;</td>
			<td><a href="pmarket.php?ob=product_price#all">Price</a></td>';
			
			if (is_numeric($discount) && $discount > 0 && $discount < 100) {
				$page_content .= '<td><a href="pmarket.php?ob=product_price#all"><b>Your Discount Price</b></a></td>';
			}
			
		$page_content .= '<td>&nbsp;</td>
		</tr>
			';
	
		$result = lfmsql_query("SELECT *, 24 - round((unix_timestamp(NOW()) - unix_timestamp(date_active))/3600) as expires FROM `".$prefix."pmarket_products` WHERE is_permanent=0 AND date_active >= date_sub(NOW(), INTERVAL 23 HOUR) ORDER BY ".$order_by."");
		while($row = lfmsql_fetch_assoc($result)) {
			
			if ($row['product_type'] == 'upgrade') {
				$displayname = lfmsql_result(lfmsql_query("SELECT accname FROM `".$prefix."membertypes` WHERE mtid='".$row['upgrademtype']."'"), 0);
				$displayname .= ' - '.$row['product_value'].' day'; if ($row['product_value'] > 0) { $displayname .= 's'; }
			} elseif ($row['product_type'] == 'jetfuel') {
				$displayname = lfmsql_result(lfmsql_query("SELECT name FROM `".$prefix."jetfuel` WHERE id='".$row['product_value']."'"), 0);
			} else {
				$displayname = $row['product_value'].' '.mp_itemtypename($row['product_type']);
			}
			
			if (is_numeric($discount) && $discount > 0 && $discount < 100) {
				$discountprice = round( $row['product_price'] - ($row['product_price'] * ($discount/100) )  ,2);
				$discountprice = number_format((float)$discountprice, 2, '.', '');
				$payprice = $discountprice;
			} else {
				$payprice = $row['product_price'];
			}
			
			if($row['expires'] < 1) $row['expires'] = 1;
			$expires = $row['expires'].' hours';
			$available = $row['available'];
			$link = '<a class="btn buybutton" href="pmarket.php?b=prod_details&pid='.$row['id'].'"><span style="color:rgb(100, 246, 0)">Buy now for $'.$payprice.'</a>';
			if($available <= 0) {
				$available = '<i><span style="color:#666;">sold out</span></i>';
				$link = '<button disabled class="btn buybutton" style="background-color:#666;">Sold Out</button>';
			}
			if($row['expires'] == 1) $expires = '<span style="font-weight:bold;color:#F6FF00;">'.(60-date("i")).' mins';

			$page_content .= '<tr>
				<td><strong><a href="pmarket.php?b=prod_details&pid='.$row['id'].'">'.$displayname.'</a></strong> '.$row['descr'].'</td>
				<td style="text-align:center;">'.$available.'</td>
				<td>'.$expires.'</td>
				<td>$'.$row['product_price'].'</td>';
				
				if (is_numeric($discount) && $discount > 0 && $discount < 100) {
					$page_content .= '<td>$'.$payprice.'</td>';
				}
				
				$page_content .= '<td>'.$link.'</td>
				</tr>';
		}
	
	$page_content .= '
		</table><br><br>
		
	</div>';
	
	
	// Other items
	
	if($_REQUEST['ob']) {
		$order_by = $_REQUEST['ob'];
	} else {
		$order_by = 'date_active DESC';
	}
	
	$page_content .= '
	<a name="all"></a>
	<div id="mp_all">
	<br>
	<h3>Other Items</h3><p>These items are always available for purchase</p>
		<table cellpadding="0" cellspacing="0" class="table_mp">
		<tr>
			<td><a href="pmarket.php?ob=product_type#all">Product</a></td>
			<td><a href="pmarket.php?ob=product_price#all">Price</a></td>';
			
			if (is_numeric($discount) && $discount > 0 && $discount < 100) {
				$page_content .= '<td><a href="pmarket.php?ob=product_price#all"><b>Your Discount Price</b></a></td>';
			}
			
		$page_content .= '<td>&nbsp;</td>
		</tr>
			';
	
		$result = lfmsql_query("SELECT * FROM `".$prefix."pmarket_products` WHERE is_permanent=1 ORDER BY ".$order_by."");
		while($row = lfmsql_fetch_assoc($result)) {
			
			if ($row['product_type'] == 'upgrade') {
				$displayname = lfmsql_result(lfmsql_query("SELECT accname FROM `".$prefix."membertypes` WHERE mtid='".$row['upgrademtype']."'"), 0);
				$displayname .= ' - '.$row['product_value'].' day'; if ($row['product_value'] > 0) { $displayname .= 's'; }
			} elseif ($row['product_type'] == 'jetfuel') {
				$displayname = lfmsql_result(lfmsql_query("SELECT name FROM `".$prefix."jetfuel` WHERE id='".$row['product_value']."'"), 0);
			} else {
				$displayname = $row['product_value'].' '.mp_itemtypename($row['product_type']);
			}
			
			if (is_numeric($discount) && $discount > 0 && $discount < 100) {
				$discountprice = round( $row['product_price'] - ($row['product_price'] * ($discount/100) )  ,2);
				$discountprice = number_format((float)$discountprice, 2, '.', '');
				$payprice = $discountprice;
			} else {
				$payprice = $row['product_price'];
			}
			
			$link = '<a class="btn buybutton" href="pmarket.php?b=prod_details&pid='.$row['id'].'">Buy now for $'.$payprice.'</a>';
			
			if ($row['upgrademtype'] == 0 || $mtype == 1) { // Only show upgrade products to free members
				
				$page_content .= '<tr>
					<td><strong><a href="pmarket.php?b=prod_details&pid='.$row['id'].'">'.$displayname.'</a></strong> '.$row['descr'].'</td>
					<td>$'.$row['product_price'].'</td>';
					
					if (is_numeric($discount) && $discount > 0 && $discount < 100) {
						$page_content .= '<td>$'.$payprice.'</td>';
					}
					
					$page_content .= '<td>'.$link.'</td>
					</tr>';
			}
		}
	
	$page_content .= '
		</table><br><br>
		
	</div>';
  
	load_template ($theme_dir."/content.php");
	load_template ($theme_dir."/footer.php");
	exit;

?>