<?
//this page displays the full story of the report
include "../rcontrol/config.php";
include "$SERVERPATH/rcommon/functions.php";
include "$SERVERPATH/rcommon/stripallslashes.php";
include "$SERVERPATH/rcommon/database.php";
include_once "$SERVERPATH/mis/includes/functions.php";

//..................Member Status........................................
//checking if he has logged in if yes then take him to the respective page
$sql= "SELECT memberlogin, memberexpdate FROM logger WHERE abc='$abc'";
$result = mysql_db_query($DATABASE,$sql);
if(mysql_error()) error("Unexpected Error");
$count = mysql_num_rows($result);

if ($count!=0)
{
	$login=stripslashes(mysql_result($result,0,0));
	//$expdate=mysqltime_to_mktime(stripslashes(mysql_result($result,0,1)));
	$expdate=(stripslashes(mysql_result($result,0,1)));
	$currenttime=time();
	$cdate=substr(mktime_to_mysqltime(time()),0,8);
	
	if($expdate < $cdate)
	{
		header("location:../meregistration/index.php?whichpage=firstpage&gotopage=secondpage&accessedpdservice=n&old=y&var=1&oldmemberlogin=narmada&contactperson=&c_try=India&id=5032&upgrade=y");		
		exit;
	}
	trapuser($login,'Industry Reports');

	  $sql="select plan, id, country from member where login='$login'";
	  $result=mysql_db_query($DATABASE,$sql);

	  $planm=mysql_result($result,0,0);
	  $mid=mysql_result($result,0,1);
	  $mctry=mysql_result($result,0,2);

	if(($planm == '4~6')||($planm == '4~12')||($planm == '4~07')||($planm == '3~6')||($planm == '3~12')||($planm == '3~07')||($planm == '14~6')||($planm == '14~12')||($planm =='14~Grace Period'))
	{
		if($types == "Y")
		{
			$types = "";
		}
		if($types == "F")
		{
			$types = "";
		}  
		else if($types == "T")  
		{
			header("location:../ir/ti_main.php?types=T&hits_per_page=$hits_per_page&from=$from&to=$to&nextpg_from=$nextpg_from&nextpg_to=$nextpg_to&sortby=$sortby&sortorder=$sortorder");
			$types = "";
			exit;
		} 
	}
	else
	{
		if($types == "Y")
		{
			header("location:../meregistration/index.php?whichpage=firstpage&gotopage=secondpage&accessedpdservice=n&old=y&var=1&oldmemberlogin=narmada&contactperson=&c_try=India&id=5032&upgrade=y");
			$types = "";
			exit;
		}
		else if($types == "F")
		{
			$types = "";
		}  
		else if($types == "T")  
		{
			header("location:../ir/ti_main.php?types=T&hits_per_page=$hits_per_page&from=$from&to=$to&nextpg_from=$nextpg_from&nextpg_to=$nextpg_to&sortby=$sortby&sortorder=$sortorder");
			$types = "";
			exit;
		} 
	}
}
else
{
	//echo $_SERVER['REMOTE_ADDR'];
	If
	(
		($_SERVER['REMOTE_ADDR']=="66.249.64.0" ||
		 $_SERVER['REMOTE_ADDR']=="66.249.64.1" ||
		 $_SERVER['REMOTE_ADDR']=="66.249.64.2" ||
		 $_SERVER['REMOTE_ADDR']=="66.249.64.3" ||
		 $_SERVER['REMOTE_ADDR']=="66.249.64.4" ||
		 $_SERVER['REMOTE_ADDR']=="66.249.64.5" ||
		 $_SERVER['REMOTE_ADDR']=="66.249.64.6" ||
		 $_SERVER['REMOTE_ADDR']=="66.249.64.7" ||
		 $_SERVER['REMOTE_ADDR']=="66.249.64.8" ||
		 $_SERVER['REMOTE_ADDR']=="66.249.64.9" ||
		 $_SERVER['REMOTE_ADDR']=="66.249.64.10" ||
		 $_SERVER['REMOTE_ADDR']=="66.249.64.11" ||
		 $_SERVER['REMOTE_ADDR']=="66.249.64.12" ||
		 $_SERVER['REMOTE_ADDR']=="66.249.64.13" ||
		 $_SERVER['REMOTE_ADDR']=="66.249.64.14" ||
		 $_SERVER['REMOTE_ADDR']=="66.249.64.15" ||
		 $_SERVER['REMOTE_ADDR']=="66.249.64.16" ||
		 $_SERVER['REMOTE_ADDR']=="66.249.64.17" ||
		 $_SERVER['REMOTE_ADDR']=="66.249.64.18" ||
		 $_SERVER['REMOTE_ADDR']=="66.249.64.19" ||
		 $_SERVER['REMOTE_ADDR']=="66.249.64.20") 
		and
		($_SERVER['HTTP_USER_AGENT'] == "Googlebot")
	)
	{
	}
	else
	{
		header("location:../mis/ir/index.php");
		exit;	
	}
}
//..................Member Status........................................

$query="Select source, header, body, date_ir, id from ynfx_mis_ir WHERE id=$id";
$result=mysql_db_query($DATABASE,$query);
if(mysql_error()) error("Unexpected Error");

if(mysql_num_rows($result))
{
  while($row=mysql_fetch_row($result))
  {
    $source_t=unserialize($row[0]);
    $header=stripslashes($row[1]);
    $body=stripslashes($row[2]);

    $date_ir=date("d M Y",$row[3]);
    $id_i=stripslashes($row[4]);

    $body_t=split("\^",$body);

    // For meta tags
    $header_disp = "YnFx : Textile Industry Report - ".stripslashes($row[1]);
    $body_disp = substr($body_t[0],0,250);
    
    $body_t[1]=ereg_replace("List of contents","<b>List of contents</b>",$body_t[1]);
    $body_t[1]=ereg_replace("List of tables","<b>List of tables</b>",$body_t[1]);
    $body_t[1]=ereg_replace("List of figures","<b>List of figures</b>",$body_t[1]);
    
    $price = $body_t[2];

    //$body_f=$body_t[0]."<br>"."<table border=1 cellspacing=0 cellpadding=0><tr><td><table><tr><td>$body_t[1]</td></tr></table></td></tr></table>";

    $body_h="<table width='100%' border=1 cellspacing=0 cellpadding=0 bordercolor='#f0f0f0'>";
      $body_h.="<tr>";
        $body_h.="<td>";
          $body_h.="<table>";
            $body_h.="<tr>";
              $body_h.="<td><font face='verdana' size='-1'>$body_t[0]</font></td>";
            $body_h.="</tr>";
          $body_h.="</table>";
        $body_h.="</td>";
      $body_h.="</tr>";
    $body_h.="</table>";

    $body_f="<table width='100%' border=1 cellspacing=0 cellpadding=0 bordercolor='#ffffff'>";
      $body_f.="<tr>";
        $body_f.="<td>";
          $body_f.="<table>";
            $body_f.="<tr>";
              $body_f.="<td><font face='verdana' size='-1'>$body_t[1]</font></td>";
            $body_f.="</tr>";
          $body_f.="</table>";
        $body_f.="</td>";
      $body_f.="</tr>";
    $body_f.="</table>";
    
    $price = str_replace("US $ ","",$body_t[1]);
    $price = str_replace("</P>","",$price);
    $price = str_replace("</p>","",$price);

    if($types == "T" || $types == "") 
     {
	    $body_p="<table width='100%' border=1 cellspacing=0 cellpadding=0 bordercolor='#ffffff'>";
	      $body_p.="<tr>";
		$body_p.="<td>";
		  $body_p.="<table>";
		    $body_p.="<tr>";
		      $body_p.="<td><a href='subscribeir.php?id_i=$id_i&price=$price' style='text-decoration: none'><IMG SRC='/images/shop_cart.gif' border='0'><font color='black'>&nbsp;$body_t[2]</font></a></td>";
		    $body_p.="</tr>";
		  $body_p.="</table>";
		$body_p.="</td>";
	      $body_p.="</tr>";
	    $body_p.="</table>";
     }

    $s="";
    $c=0;
    
    for($i=0;$i<count($source_t);$i++)
    {
      if($source_t[$i]!='')
      { 
        $source[$c]=$source_t[$i];
        $c++;
      }//end of if
    }//end of for

    //$s=implode(",",$source);
    
    //keeping a check to see that only the reports of TI are opened from this page
    //$sqlcheck="select id from ynfx_mis_source where name like '%Textiles Intelligence%' and id in ($s)";
    //$resultcheck=mysql_db_query($DATABASE,$sqlcheck);
    //if(mysql_error()) error("Unexpected Error".mysql_error().$sqlcheck);
    //if(mysql_num_rows($resultcheck)) 
    //{
      $table.="<tr>";                
                
                
                if($types == "T" || $types == "")
                $rpt="Textiles Intelligence";
                if($types == "F")
                $rpt="Free";
                if($types == "Y")
                $rpt="Yarns and Fibers";               
               
                $table.="<td width='100%' valign='middle'><font size='-2' face='VERDANA'><b><font size='-1'>$header</font><br><font color='#999999'>".$date_ir.",".$rpt."</font><br></b></font><hr align='center' noshade></td>";
      $table.="</tr>";
      $table.="<tr>";
        $table.="<td><font size='-1' face='VERDANA'><b>Product Overview</b><br><br></font></td>";
      $table.="</tr>";
      $table.="<tr>";
        $table.="<td>";
          $table.="$body_h";
        $table.="</td>";
      $table.="</tr>";
      
      //================= Commented By Tejas ================
      //$table.="<tr>";
      //  $table.="<td><hr align='center' noshade></td>";
      //$table.="</tr>";
      //================= Commented By Tejas ================
      
      
      //$table.="<tr>";
      //  $table.="<td><font size='-1' face='VERDANA'><b>Table of Content</b><br><br></font></td>";
      //$table.="</tr>";
      $table.="<tr>";
        $table.="<td>";
          $table.="$body_f";
        $table.="</td>";
      $table.="</tr>";
      $table.="<tr>";
        $table.="<td><br></td>";
      $table.="</tr>";
      
      if($types == "T")
       {
	      $table.="<tr>";
		$table.="<td><font size='-1' face='VERDANA'><b>Buy Now</b><br><br></font></td>";
	      $table.="</tr>";
       }
      
      
      $table.="<tr>";
        $table.="<td>";
          $table.="$body_p";
        $table.="</td>";
      $table.="</tr>";
    //}
  }//end of while
}//end of if

include "$SERVERPATH/meregistration/includes/includefornonregfiles.php";
$colorofpopupbg="#D7F4FF";
?>

<HTML>
  <HEAD>
    <TITLE><? echo $header_disp; ?></TITLE>
    <META name="Description" content="YnFx Textile Industry Report : <? echo $body_disp; ?>...">
    <META name="Keywords" content="YnFx Textile Industry Report : <? echo $body_disp; ?>... YarnsandFibers, yarnsandfibers, YnFx, ynfx, yarns, fibers, fibres, fabrics, industry reports, reports, e-marketplace, e-marketplaces,  B2B, business to business, e-commerce, ecommerce, solutions, e-solutions, esolutions, textiles, POY, PTY, DMT, MEG, ACN, VSF, VFY, caprolactum, polyester chips, spun yarn, filament yarn, pricewatch, trends, pricetrends, statistics, export, import, EXIM, auctions, news, storefronts, webdevelopment, online, ynfx, buy, sell, newsletter, archives, policies, features, articles, discussion forums, Ezcomm trade technologies limited, industry, industry news, trade association, poll, Texwatch, Textrade, Textileweb, Itextile, texworld, fiberbuys, fiberserv, India, channel, trade association, SGS, e-library, websites, marketsite, purchasing, bobbin thread, synthetic fibers, polyester, Mumbai, Bombay, India, textile associations, asian, polyester, polyester filament yarns, conversion tools, E tools, classifieds, quiz, glossary, clothing, country, design, Asiapolytex">
    <META name="ROBOTS" content="INDEX, FOLLOW">
    <META name="Revisit-After" content="7 Days">

    <? include "$SERVERPATH/rssi/head.php" ?>
    <LINK REL="SHORTCUT ICON" HREF="/images/ynfx.ico">

    <STYLE TYPE="text/css">
      <!--
      #dek {POSITION:absolute;VISIBILITY:hidden;Z-INDEX:200;}
      //-->
    </STYLE>
  </HEAD>

  <BODY BGCOLOR="#EFEFEF" BACKGROUND="/images/bg.gif" LINK="#0000FF" VLINK="#151880" MARGINHEIGHT="0" MARGINWIDTH="0" TOPMARGIN="0" LEFTMARGIN="0">
    <? include "../rssi/topbanner.php" ;?>
    
    <TABLE WIDTH="60%" CELLPADDING="0" CELLSPACING="0" BORDER="0">
      <TR VALIGN="TOP" ALIGN="LEFT">
        <?
        // the first td begins here 
        ?>
        <TD><IMG SRC="/images/spacer.gif" WIDTH="10" HEIGHT="2"></TD>
        <?
        // the first td end here and the second td which is the left banner begins here 
        // NESTED LEFT CONTENT BEGINS HERE
        // the left banner contents begins here 
        include "$SERVERPATH/$contactus_dir/leftbanner_main_regpg.php" ;
        // the left banner contents ends here 
        // NESTED LEFT CONTENT ENDS HERE-->
        ?>

        <TD><IMG SRC="/images/spacer.gif" WIDTH="20" HEIGHT="2"></TD>
        <TD height="5"><FONT FACE="VERDANA" SIZE="-2"> 
          <!--NESTED CENTER CONTENT BEGINS HERE-->
          <TABLE WIDTH="100%" CELLSPACING="0" CELLPADDING="0" BORDER="0">
            <TR>
              <TD COLSPAN="1"><A HREF="index.php"><IMG SRC="../images/title_features.gif" WIDTH="575" HEIGHT="23" ALT="Industry Reports" BORDER="0"></A><BR></TD>
            </TR>
            <TR><TD COLSPAN="1">&nbsp;</TD></TR>
            <!-- ======================= Added by Tejas to display the links for three reports ============ -->            
	    <TR><TD COLSPAN="1">              <TABLE WIDTH="100%" CELLSPACING="1" CELLPADDING="0" BORDER="0" bgcolor='#666666' height='22'>
                <tr>
                  <?
                       if($types == "Y")
                       print "<td bgcolor='#e7e7e7' align='center'>YarnsandFibers Reports</td>";
                       else
                       print "<td bgcolor='#cccccc' align='center'><a href='/ir/ynfr_main.php?types=Y'><b>YarnsandFibers Reports</b></a></td>";

                       if($types == "F")
                       print "<td bgcolor='#e7e7e7' align='center'>Free Reports</td>";
                       else
                       print "<td bgcolor='#cccccc' align='center'><b><a href='/ir/free_main.php?types=F'>Free Reports</a></b></td>";


                       if($types == "T" || $types == "")
                       print "<td bgcolor='#e7e7e7' align='center'>Textile Intelligence Reports</td>";
                       else
                       print "<td bgcolor='#cccccc' align='center'><b><a href='/ir/ti_main.php?types=T'>Textile Intelligence Reports</b></a></td>";
                   ?>
                </tr>
              </table>
</TD></TR>
            <!-- ======================= Added by Tejas to display the links for three reports ============ -->
            
            <TR>
              <TD>
                <table width="100%" border="0" cellspacing="0" cellpadding="0">
                  <tr> 
                    <td>&nbsp;</td>
                  </tr>
             
                  <? echo $table ?>
                </table>
              </TD>
            </TR>
          </TABLE>
        </TD>
      </TR>
    </TABLE>
    <? include "$SERVERPATH/rssi/bottombanner.php" ?>
  </BODY>
</html>

<!--<table width='100%'>
  <tr>
    <td align="right">
      <script language="JavaScript">
        function goBack()
        {
          history.back()
        }
      </script>
      <font size="-2" face="verdana"><a href="#" onClick="goBack()">Back</a></font>
    </td>
  </tr>
</table>-->