=NOW()");
if(mysqli_num_rows($sql_coupon_dt)>0)
{
$discount_row=mysqli_fetch_array($sql_coupon_dt);
$discount=$discount_row['discount'];
}
else
{
$coupon_error="Invalid Coupon Code or Expired";
}
}
if($_SESSION['country']==99)
{
include('includes/geoip.inc.php');
$gi = geoip_open("includes/GeoIP.dat",GEOIP_STANDARD);
$geoipcountrycode = geoip_country_code_by_addr($gi, $_SERVER['REMOTE_ADDR']);
$geoipcountryname = geoip_country_name_by_addr($gi, $_SERVER['REMOTE_ADDR']);
if($geoipcountrycode=="IN" && $_SESSION['country']==99)
{
$plat_price_dist="465";
$gold_price_dist="326";
$silver_price_dist="155";
$bronze_price_dist="81";
$standard_price_dist="45";
$tplus_price_dist="23";
}
}
$sql_c = "SELECT letter FROM currency WHERE id='".$currency."' LIMIT 1";
$query_c = mysqli_query($conn,$sql_c);
$result_c = mysqli_fetch_assoc($query_c);
$currSym = $result_c['letter'];
$grade=$_GET['grade'];
if ($grade=='5')
{
$advertType = 'GOLD';
$cats='16';
$price = get_price ($currency,$cats)-$gold_price_dist;
$text = 'you get an image (125 x 125 pixels), up to '.GOLD_CHAR_LIMIT.' characters space (about '.GOLD_WORD_LIMIT.' words), links to your full listing and is always shown above silver, bronze and standard listings.';
}
elseif ($grade=='6')
{
$advertType = 'PLATINUM';
$cats='18';
$price = get_price ($currency,$cats)-$plat_price_dist;
$text = 'you get an image (125 x 125 pixels), up to '.GOLD_CHAR_LIMIT.' characters space (about '.GOLD_WORD_LIMIT.' words), links to your full listing and is always shown above silver, bronze and standard listings.';
}
elseif ($grade =='4')
{
$cats='15';
$price = get_price ($currency,$cats)-$silver_price_dist;
$advertType = 'SILVER';
$text = 'you get an image (100 x 100 pixels), up to '.SILVER_CHAR_LIMIT.' characters space (about '.SILVER_WORD_LIMIT.' words), links to your full listing and is always shown above bronze and standard listings.';
}
elseif ($grade=='8')
{
$advertType = 'Therapist_Plus';
$cats='19';
$price = get_price ($currency,$cats)-$tplus_price_dist;
$text = 'you get an image (125 x 125 pixels), up to 1000 characters space (about 1000 words), links to your full listing and is always shown above Free listings.';
}
elseif ($grade == '3')
{
$cats='14';
$price = get_price ($currency,$cats)-$bronze_price_dist;
$advertType = 'BRONZE';
$text = 'you get up to '.BRONZE_CHAR_LIMIT.' characters space (about '.BRONZE_WORD_LIMIT.' words), links to your full listing and is always shown above standard listings.';
}
elseif ($grade == '2')
{
$cats='13';
$price = get_price ($currency,$cats)-$standard_price_dist;
$advertType = 'STANDARD';
$text = 'your company name will link to your full listing';
}
else
{
//header('location:home.php');
//exit();
}
?>