<?php

session_start();

include "../config.php";
include "../header.php";
include "../style.php";

if( session_is_registered("ulogin") )
   	{  // members only stuff!

		include("navigation.php");
        include("../banners.php");
        echo "<font size=2 face='$fonttype' color='$fontcolour'><p><center>";
		echo "<br><H2><center>Redeem Promo Code</H2>";
       
	if($_POST['code']) {
		
		$sql = mysql_query("SELECT * FROM promo_codes WHERE code='".$_POST['code']."'");
		if(@mysql_num_rows($sql)) {
			$offer = mysql_fetch_array($sql);
			if($offer['count'] < $offer['max']) {

				$sql2 = mysql_query("SELECT * FROM promo_used WHERE promoid='".$offer['id']."' AND userid='".$userid."'");
				if(!@mysql_num_rows($sql2)) {
				
				
					mysql_query("INSERT INTO promo_used (promoid,userid) VALUES ('".$offer['id']."','".$userid."')");
					mysql_query("UPDATE promo_codes SET count=count+1 WHERE id='".$offer['id']."'");

					if($offer['upgrade']) {
						upgrade_pro($userid, $offer['upgrade']);
					}
					
					echo "The promo code has been applied to your account. <a href=\"index.php\">Go back</a>";
				
				} else echo "<font color=\"red\">You already used that promo code.</font>";
			} else echo "<font color=\"red\">The promo code has expired.</font>";
		} else echo "<font color=\"red\">Wrong promo code.</font>";
		
	
	
	} else echo"<font color=\"red\">You need to enter a promo code.</font>";
		
		



	echo "<br><br><br>";
  

 }

include "../footer.php";
mysql_close($dblink);
?>