<?
@session_start();
require_once "config.php";
//require_once "formvalidator.php";
?><?
session_start();
require_once "config.php";
include_once "functions.php";

                         if( isset($_POST['submit'])) {
							$username = $_REQUEST['username'];
							$password = $_REQUEST['password'];
							$referer = $_REQUEST['referer'];
							
							$md5password = md5($password);
							include "opendb.php";
							$logindata = "SELECT `srno`,`fname`,`country` FROM `member` WHERE `login` = '$username' and `password` = '$md5password' limit 1;";
							$logindataexe = @mysql_db_query(DB_NAME, $logindata);
							$logindatarow = @mysql_num_rows($logindataexe);
							$memberregid = @mysql_result($logindataexe, 0, 0);
							$memberfname = @mysql_result($logindataexe, 0, 1);
							$membercountry = @mysql_result($logindataexe, 0, 2);
							
							$activate = "SELECT `emailverify`,	`regpmtid` FROM `memberverify` WHERE `memid`='$memberregid' limit 1;";
							$activateexe = @mysql_db_query(DB_NAME, $activate);
							$emailverify = @mysql_result($activateexe, 0, 0);
							$regpmtid = @mysql_result($activateexe, 0, 1);
							
							$regpayment = "SELECT `amount`, `pymtstatus`, `srno` FROM `payment` WHERE `memid`='$memberregid' limit 1";
							$regpaymentexe = @mysql_db_query(DB_NAME, $regpayment);
						 	$amount = @mysql_result($regpaymentexe, 0, 0);
							$pymtstatus = @mysql_result($regpaymentexe, 0, 1);
							$regpmtid1= @mysql_result($regpaymentexe, 0, 2);
							
							if($regpmtid != $regpmtid1)
							{
								$regpmtid = $regpmtid1;
							}
							include "closedb.php";
							
							if (($logindatarow == 1) && ($emailverify == "Y") && ($pymtstatus == "Y"))
							{
								
								include "opendb.php";
								$logintrack ="INSERT INTO `ynfx_ps`.`logintrack` (`srno`, `memid`, `ipaddress`, `status`, `dtstamp`, `adminstatus`) VALUES (NULL, '$memberregid', 
								'".$_SERVER['REMOTE_ADDR']."', 'successful', NOW(), 'Y');";
								$logintrackexe = @mysql_db_query(DB_NAME, $logintrack); 
								//include "closedb.php";
								$_SESSION["username"] = $username; 
								$_SESSION["md5password"] = $md5password;
								$_SESSION["memberregid"] = $memberregid;
								//header('Location: '.$referer);

								//-------------------------- create cookie for old Ynfx ----------------------------------------------
								
								/*$host="localhost";
								$dbname='ynfx_ps';
								$user='root';
								$password='';
	
								$connection=mysql_connect($host,$user,$password) or die(mysql_error());
								mysql_select_db($dbname,$connection) or die(mysql_error());
								*/
								$queryCookie="select * from ynfx_ps.member_map where ps_memid=".$memberregid;
								$Getcookie=mysql_query($queryCookie);
								$aCookie=mysql_fetch_array($Getcookie);
								$numrows=mysql_num_rows($Getcookie);

								$cookie_country = $aCookie['revamp_country'];
								$cookie_contactperson = $aCookie['revamp_contactperson'];
								$login=$aCookie['revamp_login'];
								
								if($numrows==0)
								{
								$cookie_country = $membercountry;
								$cookie_contactperson = $memberfname;
								$login=$username;
								}


								$TIMEOUT			=	10800;
								$KEYSTRING			=	"Yarn";

								function mktime_to_mysqltime1($string){
								$yyyy	=	date("Y",$string);
								$mm	=	date("m",$string);
								$dd	=	date("d",$string);
								$hh	=	date("H",$string);
								$ii	=	date("i",$string);
								$ss	=	date("s",$string);

								$codedstring =	$yyyy.$mm.$dd.$hh.$ii.$ss;
									return $codedstring;
								}


								srand((double)microtime()*1000000);
								$newabc = (string)rand().crypt($KEYSTRING);
								$_SESSION["newabcabc"] = $newabc;
								$logintime = mktime_to_mysqltime1(time());
								$logouttime= mktime_to_mysqltime1(time()+$TIMEOUT);
								$tmpdate = mktime_to_mysqltime1(time());
															
								$sql_delete="DELETE FROM logger WHERE logouttime < $tmpdate";								mysql_db_query('ynfx_revamp',$sql_delete) or die(mysql_error());
								
								$sql_delete1="DELETE FROM logger WHERE memberlogin = '$login'";
								mysql_db_query('ynfx_revamp',$sql_delete1) or die(mysql_error());	

								$sql_insert1="INSERT INTO logger(abc,memberlogin,logouttime,memberexpdate) VALUES ('$newabc', '$login', $logouttime, '$expdate')";
								mysql_db_query('ynfx_revamp',$sql_insert1) or die(mysql_error());							

								$sql_insert2="INSERT INTO logindata(id,memberlogin,logindate) VALUES (null, '$login', $logintime)";
								mysql_db_query('ynfx_revamp',$sql_insert2) or die(mysql_error());							
								
								
								//mysql('ynfx_revamp', "INSERT INTO logger VALUES ('$newabc', '$login', $logouttime, $expdate)");
								//mysql('ynfx_revamp', "INSERT INTO logindata VALUES (null, '$login', $logintime)");
	

								setcookie("ghi", "$cookie_country", 0, "/","");
								setcookie("def", "$cookie_contactperson", 0, "/","");
								setcookie("abc", "$newabc", 0, "/","");
								//echo $cookie_country;
								//echo $memberregid;
								//exit;
								//------------------------ Create Cookie for Old Ynfx Ends 	------------------------------------------
								// Insert for who's online

								$username=$_SESSION["username"];
								$pawd=$_SESSION["md5password"];
								$ip=$_SERVER['REMOTE_ADDR'];
								include "opendb.php";
								$sql_whosonline="insert into plus_login(srno,id,userid,ip,tm,status) VALUES('','','$username','$ip',NOW(),'ON')";
								$result=mysql_db_query(DB_NAME,$sql_whosonline);
				
								// end of who's online code

								$companyprocheck = checkcompanyprofile($memberregid);
								if ( $companyprocheck == "N")
								{
									//fakhruddin: for redirecting to perticular location if cookie is set i.e IR,IS,IN
									if(isset($_COOKIE['IN_IR_IS'])){
									($ur_l = $_COOKIE['IN_IR_IS']);
									printf('<script type="text/javascript">document.location = "%s";</script>', ($ur_l));
									die();
									}
									header('Location: ./editcompanyprofile.php');
									
								}
								else
								{
									$checkprolist = checkproductlist($memberregid);
									if ($checkprolist == "N")
									{
										header('Location: ./productcreation.php');
										
									}
									else
									{
										header('Location: ./pshome.php');
										
									}
								}
							}
							elseif ($emailverify == "Y")
							{
								include "opendb.php";
								$logindata1 = "SELECT `srno` FROM `member` WHERE `login` = '$username' limit 1;";
								$logindata1exe = @mysql_db_query(DB_NAME, $logindata1);
								$logindata1row = @mysql_num_rows($logindata1exe);
								$memberregid = @mysql_result($logindata1exe, 0, 0);
								include "closedb.php";
								if ($logindata1row == 1)
								{ 
									include "opendb.php";
									$logintrack ="INSERT INTO `ynfx_ps`.`logintrack` (`srno`, `memid`, `ipaddress`, `status`, `dtstamp`, `adminstatus`) VALUES (NULL, '$memberregid', 
									'".$_SERVER['REMOTE_ADDR']."', 'unsuccessful', NOW(), 'Y');";
									$logintrackexe = @mysql_db_query(DB_NAME, $logintrack); 
									include "closedb.php";
								}
								
								if ($pymtstatus == "N")
								{
								
								require_once ("libfuncs.php");
								$key_32bit = "ae943a3e258d31fc51cf900d41786284";
								$MerchantId = "ynfx"; //Merchant ID
								$Amount =	 usd2inr($amount) * 100;  //Amount should be in paisa
								$OrderId = $regpmtid; //Invoice Number
								$URL = "http://www.yarnsandfibers.com/ynfxps/payment.php?memid=$memberregid";
								//$URL = "http://localhost/new/payment.php?memid=$memberregid"; //URL of your response Payment Page
								$WorkingKey = $key_32bit;
								$checksum = getchecksum($MerchantId, $Amount, $OrderId, $URL, $WorkingKey);
								?><form method="post" action="http://www.ezcommwireless.net/icici/payment.php" name="paymentform" id="paymentform">
								<input type=hidden name=MerchantId value="">
								<input type=hidden name=OrderId value="">
								<input type=hidden name=Amount value="">
								<input type=hidden name=URL value="">
								<input type=hidden name=Checksum value="">
								</form>
                                You will now be redirect to payment gateway, as your payment for  USD is pending against registration and leads fees.
								<script language="javascript">
								alert("You will now be redirect to payment gateway, \nas your payment for  USD is pending against registration and leads fees.");						document.paymentform.submit();
                                </script>
                                
								<?
                                exit;
								
								
								}
								
								$error = "true";
								$errormsg = " Invalid Username and Password";
								
								
							}
							elseif ($pymtstatus == "N")
							{
								require_once ("libfuncs.php");
								$key_32bit = "ae943a3e258d31fc51cf900d41786284";
								$MerchantId = "ynfx"; //Merchant ID
								$Amount =	 usd2inr($amount) * 100;  //Amount should be in paisa
								$OrderId = $regpmtid; //Invoice Number
								$URL = "http://www.yarnsandfibers.com/ynfxps/payment.php?memid=$memberregid";
								//$URL = "http://localhost/new/payment.php?memid=$memberregid"; //URL of your response Payment Page
								$WorkingKey = $key_32bit;
								$checksum = getchecksum($MerchantId, $Amount, $OrderId, $URL, $WorkingKey);
								?><form method="post" action="http://www.ezcommwireless.net/icici/payment.php" name="paymentform" id="paymentform">
								<input type=hidden name=MerchantId value="">
								<input type=hidden name=OrderId value="">
								<input type=hidden name=Amount value="">
								<input type=hidden name=URL value="">
								<input type=hidden name=Checksum value="">
								</form>
                                You will now be redirect to payment gateway, as your payment for  USD is pending against registration and leads fees.
								<script language="javascript">
								alert("You will now be redirect to payment gateway, \nas your payment for  USD is pending against registration and leads fees.");						document.paymentform.submit();
                                </script>
                                
								<?
                                exit;
							}
							else  
							{
								$error = "true";
								$errormsg = "Your Account is disabled, please activate. To activate account, click on the link in your e-mail";
								if (($md5password == "") || ($username == ""))
								{
								$error = "true";
								$errormsg = "Invalid username or password";
								}
								
								if (checklogin_username_password($username,$md5password) == "N")
								{
								$error = "true";
								$errormsg = "Invalid username or password";
								}
								
							}
						}
include_once "functions.php";


require_once "formvalidator.php";

?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>:: YNFX ::</title>
<style type="text/css"></style>
<link type="text/css" href="../script/css/cupertino/jquery-ui-1.8.2.custom.css" rel="stylesheet" />
<SCRIPT type="text/javascript"  src="../script/jquery-latest.js"></SCRIPT>
<script type="text/javascript" src="../script/js/jquery-1.4.2.min.js"></script>
		<script type="text/javascript" src="../script/js/jquery-ui-1.8.2.custom.min.js"></script>
		<script type="text/javascript">
			$(function(){
	
				// Tabs
				$('#tabs').tabs();
				
				//hover states on the static widgets
				$('#dialog_link, ul#icons li').hover(
					function() { $(this).addClass('ui-state-hover'); }, 
					function() { $(this).removeClass('ui-state-hover'); }
				);
				
			});
		</script>


   	<style type="text/css">
			/*demo page css*/
			.demoHeaders { margin-top: 2em; }
			#dialog_link {padding: .4em 1em .4em 20px;text-decoration: none; position: relative;}
			#dialog_link span.ui-icon {margin: 0 5px 0 0;position: absolute;left: .2em;margin-top: 0px;}
			ul#icons {margin: 0;  padding: 0;}
			ul#icons li {margin: 2px;  position: relative; padding: 4px 0; cursor: pointer; float: left;  list-style: none;}
			ul#icons span.ui-icon {float: left; margin: 0 4px;}
		</style>
<link href="../style/ynfx.css" rel="stylesheet" type="text/css" />
<script type="text/JavaScript">
<!--
function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}

function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}

function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</script>
<SCRIPT type="text/javascript"  src="../script/mm_menu.js"></SCRIPT>

<SCRIPT type="text/javascript" src="../script/data_int.js"></SCRIPT>
<SCRIPT LANGUAGE="JavaScript">
<!--
	function forgot_pass()
	{
		document.getElementById('login_area').style.display='none'; 
		document.getElementById('forgot_pass_area').style.display='block'; 
		
	}
	var url = "forgotpasswd.php"; 
	function forgot_pwd()
	{

	  new Ajax.Request(url, {
      method: 'get',
      parameters: { username: document.frm.f_username.value },
	  onLoading: function() {
  	  //document.getElementById('forgot_pass_area').innerHTML='<img src="images/loading.gif" id="loadwait" alt="Loading..." />';
	  },
      onSuccess: process,
      onFailure: function() { 
      alert("There was an error with the connection"); } }
		);
	function process(transport) 
	{
		document.getElementById('forgot_pass_area').innerHTML='';
		var response = transport.responseText;
		alert(response);
		if(response=='1')
		{
			document.getElementById('forgot_pass_area').style.display='none'; 
			document.getElementById('fpwd_msg').style.display='block'; 
		}
		else
		{
			document.getElementById('forgot_pass_area').style.display='block'; 
			document.getElementById('fpwd_errormsg').style.display='block'; 
			document.getElementById('fpwd_msg').style.display='none'; 				
		}
		
	}

	return false;
 }

//-->
</SCRIPT>
<style type="text/css">
<!--
body {
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
}
-->
</style></head>

<body onload="MM_preloadImages('../images/home_on.gif','../images/Priority_on.gif','../images/trading_on.gif','../images/market_on.gif','../images/communities_on.gif','../images/corporate_on.gif')">
<SCRIPT type="text/javascript">mmLoadMenus();</SCRIPT>
 <script type="text/javascript" charset="utf-8">
        window.onload = function () {
            var container = $('div.sliderGallery');
            var ul = $('ul', container);
            
            var itemsWidth = ul.innerWidth() - container.outerWidth();
           
            $('.slider', container).slider({
                min: 0,
                max: itemsWidth,
                handle: '.handle',
                stop: function (event, ui) {
                    ul.animate({'left' : ui.value * -1}, 500);
                },
                slide: function (event, ui) {
                    ul.css('left', ui.value * -1);
                }
            });
        };
    </script>
<table width="1003" height="100%" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
  <tr>
    <td width="11" align="left" valign="top" background="../images/left_border_bg.gif">&nbsp;</td>
    <td align="left" valign="top"><table width="981" border="0" cellspacing="0" cellpadding="0">
      
      <tr>
        <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td><? include "../top_banner.php";?></td>
          </tr>
          <tr>
            <td height="10"></td>
          </tr>
          <tr>
            <td><table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td width="9">&nbsp;</td>
                <td><table width="100%" border="0" cellspacing="0" cellpadding="0">
                    <tr>
                      <td><table width="100%" border="0" cellspacing="0" cellpadding="0">
                          <tr>
                            <td align="left" valign="top"><table width="100%" border="0" align="left" cellpadding="0" cellspacing="0" style="border:#E6E6E6 1px solid; ">
                            <tr>
                              <td align="left" valign="middle"  class="threecolumntitlebg" >Member Login</td>
                            </tr>
                            <tr>
                              <td align="left" valign="top" bgcolor="#F4F6F6" class="verdana11pxgray" height="130">
							  <table id="forgot_pass_area" width="100%" style="display: none;" border="0" cellpadding="0" cellspacing="0">
							  <form name="frm" action="" onsubmit="return forgot_pwd();">
							  <tr>
                                  <td align="left" valign="top" height="15"  colspan="3"></td>
                               </tr>
							   
                               <tr id='fpwd_errormsg' style="display: none;">
                                   <td colspan="3" class=" red11pxerror">Invalid or empty Username</td>
                               </tr>
                               <tr>
                                  <td align="left" valign="top" height="10"  colspan="3"></td>
                               </tr>
							  <tr>
                                      <td colspan="3"><span class="verdana12pxgray">Username:</span></td>
                                    </tr>
                                    <tr>
                                      <td colspan="3"><input name="f_username" type="text" class="login_textfield" id="textfield5" /></td>
                                    </tr>
                                    <tr>
									<tr>
                                  <td align="left" valign="top" height="15"  colspan="3"></td>
								  </tr>
                                  <td colspan="3">
								  <div align="left">
								  <input type="submit" name="submit" id="submit" value="  Submit  " />
								  </form>
								  </div>								  </td>

                                   </tr>
								 </table>

								<!--div id='fpwd_msg' align="center" style="display: none;" class="verdana12pxgray" >Your password is changed successfully</div-->
<form action="" name="loginform" id="loginform"  method="post">
                                  <table id="login_area" width="100%" border="0" cellpadding="0" cellspacing="0">
									
                                  
                                    <? if ($error = "true")
									 {?>
                                    <tr>
                                      <td colspan="3" class=" red11pxerror" style="padding-left:10px; padding-right:10px; "></td>
                                    </tr>
                                    <tr>
                                      <td align="left" valign="top" height="5"  colspan="3"></td>
                                    </tr>
                                    <?
									}
									?>
                                    <tr>
                                      <td colspan="3" style="padding-left:10px; padding-right:10px;"><span class="verdana11pxgray">Username:</span></td>
                                    </tr>
                                    <tr>
                                      <td colspan="3" style="padding-left:10px; padding-right:10px; "><input name="username" type="text" class="login_textfield" id="textfield5" /></td>
                                    </tr>
                                    <tr>
                                      <td colspan="3" class="verdana11pxgray" style="padding-left:10px;; ">Example: ynfx@ynfx.com</td>
                                    </tr>
                                    <tr>
                                      <td width="5" height="0"></td>
                                      <td></td>
                                      <td width="5"></td>
                                    </tr>
                                    <tr>
                                      <td colspan="3" style="padding-left:10px; padding-right:10px; "><span class="verdana11pxgray">Password:</span></td>
                                    </tr>
                                    <tr>
                                      <td colspan="3" style="padding-left:10px; padding-right:10px;"><input name="password" type="password" class="login_textfield" id="textfield6" /></td>
                                    </tr>
                                    <tr>
                                      <td height="5"></td>
                                      <td></td>
                                      <td></td>
                                    </tr>
                                    <tr>
                                      <td colspan="3" style="padding-left:10px; padding-right:10px; "><div align="left">
                                          <input type="submit" name="submit" id="submit" value="  Login  " />
                                      </div></td>
                                    </tr>
                                    <tr>
                                      <td height="5"></td>
                                      <td></td>
                                      <td></td>
                                    </tr>
                                    <tr>
                                      <td colspan="3" style="padding-left:10px; padding-right:10px; "><a href="#" class="red11pxlink" onClick="javsscript: forgot_pass();">Forgot Password</a></td>
                                    </tr>
                                    <tr>
                                      <td colspan="3" class="verdana11pxgray" style="padding-left:10px; padding-right:10px; ">Not a member? <a href="registration.php" class="red11pxlink">Register Now</a></td>
                                    </tr>
					
                                  </table>
                              </form></td>
                            </tr>
                        </table>
                        
                        
</td>
                            <td width="10">&nbsp;</td>
                            <td width="693"><img src="../images/services/banner.jpg" width="693" height="218" /></td>
                          </tr>
                      </table></td>
                    </tr>
                    <tr>
                      <td height="10"></td>
                    </tr>
                    <tr>
                      <td><table width="100%" border="0" cellspacing="0" cellpadding="0">
                          <tr>
                            <td width="260" align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                                <tr>
                                  <td align="left" valign="top"><?
include_once 'config.php';
include "opendb.php";
$cdate=mktime();
//fakhruddin: for paid and free in MI page
$status_ = "status ='a' or status='r'"; // r for paid news a for free
$inewsquery = "SELECT id, header, date_news FROM ynfx_mis_news WHERE visibility='1' AND ($status_) AND company !='1' AND date_display_from < '$cdate' AND date_display_to >'$cdate' order by date desc LIMIT 4";
$inewsresult = mysql_db_query("ynfx_revamp",$inewsquery);
//include "closedb.php";
$dispin = "";
if (mysql_error()) echo mysql_error();

$count = mysql_num_rows($inewsresult);

for ($i=0;$i<$count;$i++) 
{
	$id=mysql_result($inewsresult,$i,"id") ;
	$date_news=mysql_result($inewsresult,$i,"date_news");
	$body = mysql_result($inewsresult,$i,"header");
	$dispin.= " <tr>
				<td height=\"10\" align=\"left\" valign=\"top\"></td>
			  </tr>
			  <tr>
                <td class=\"verdana11pxgray\" title=\"$body\">";
		
		$shortbody = substr($body, 0, 40);
		if ($body == $shortbody)
		{
			$dispin.=  $shortbody;
		}
		else
		{
			$dispin.= $shortbody."...";
		}
		
		$dispin.=  "</td>
              </tr>
              <tr>
                <td><table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
                  <tr>
                    <td class=\"verdana11pxorange\">".date("M d, Y", $date_news)."</td>
                    <td width=\"12\" align=\"right\"><img src=\"".IMAGE_PATH."view_more_plus_icon2.gif\" width=\"12\" height=\"10\" /></td>
                    <td width=\"65\" align=\"right\"><a href=\"/preferredsupplier/news_fullstory.php?id=$id\" class=\"bluelink11px\">Full Story</a></td>
                  </tr>
                </table></td>
              </tr>";
} // for loop

?>
<table width="100%" border="0" cellspacing="0" cellpadding="0" >
  <tr>
    <td align="left" valign="middle"  class="threecolumntitlebg" >Industry News</td>
  </tr>
  <tr>
    <td align="left" valign="top" bgcolor="#F1F1F1" style="border:#E6E6E6 1px solid; padding-left:10px; padding-right:10px; padding-bottom:10px">
    <table width="100%" border="0" cellspacing="0" cellpadding="0">
       
    </table></td>
  </tr>
</table>
</td>
                                </tr>
                                <tr>
                                  <td height="10" align="left" valign="top"></td>
                                </tr>
                                <tr>
                                  <td align="left" valign="top"><?
include_once 'config.php';
include "opendb.php";

$cdate=mktime();
$inewsquery = "select `id`, `header`, `small_desc`, `date_ir` from ynfx_mis_ir WHERE visibility='1'  AND status ='a' and `special_type` = 'Y' order by date_display_from desc limit 4";

$inewsresult = mysql_db_query("ynfx_revamp",$inewsquery);
include "closedb.php";
$dispin = "";
if (mysql_error()) echo mysql_error();

$count = mysql_num_rows($inewsresult);

for ($i=0;$i<$count;$i++) 
{
	$id=mysql_result($inewsresult,$i,"id") ;
	$date_news=mysql_result($inewsresult,$i,"date_ir");
	$body = mysql_result($inewsresult,$i,"header");
	
	$dispin.= "<tr>
        <td height=\"10\" align=\"left\" valign=\"top\"></td>
      </tr>
      <tr>
        <td align=\"left\" valign=\"top\" class=\"spreport_orangelink\" title=\"$body\">";
		
		$shortbody = substr($body, 0, 40);
		if ($body == $shortbody)
		{
			$dispin.=  "<div class = \"special_rep_title\"><a href=\"/preferredsupplier/spreports_fullstory.php?id=".$id." target=\"_blank\">".$shortbody."</a></div>";
		}
		else
		{
			$dispin.= "<div class = \"special_rep_title\"><a href=\"/preferredsupplier/spreports_fullstory.php?id=".$id." target=\"_blank\">".$shortbody."...</a></div>";
		}
		
		$dispin.=  "</td>
      </tr>
      <tr>
        <td align=\"left\" valign=\"top\"><table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
          <tr>
            <td class=\"spreport_font\">".date("d-M-Y h:s", $date_news)."</td>
			
           
          </tr>
        </table></td>
      </tr>";
	
} // for loop


?><table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td align="left" valign="middle"  class="threecolumntitlebg" >Special Reports</td>
  </tr>
  <tr>
    <td align="left" valign="top" bgcolor="#F1F1F1" style="border:#E6E6E6 1px solid; padding-left:10px; padding-right:10px; padding-bottom:10px"><table width="100%" border="0" cellspacing="0" cellpadding="0">
       
    </table></td>
  </tr>
</table>
</td>
                                </tr>
                                <tr>
                                  <td height="10" align="left" valign="top"></td>
                                </tr>
                                <tr>
                                  <td align="left" valign="top"><?
include_once 'config.php';
include "opendb.php";
$cdate=mktime();
//fakhruddin: for including status a or r in MI page
$status_ = "status ='a' or status='r'"; // r for paid news a for free
$inewsquery = "select `id`, `header`, `small_desc`, `date_ir` from ynfx_mis_ir WHERE visibility='1'  AND ($status_) and `special_type` = 'N' order by date_display_from desc limit 4";

$inewsresult = mysql_db_query("ynfx_revamp",$inewsquery);
//include "closedb.php";
$dispin = "";
if (mysql_error()) echo mysql_error();

$count = mysql_num_rows($inewsresult);

for ($i=0;$i<$count;$i++) 
{
	$id=mysql_result($inewsresult,$i,"id") ;
	$date_news=mysql_result($inewsresult,$i,"date_ir");
	$body = mysql_result($inewsresult,$i,"header");
	
	$dispin.= "<tr>
        <td height=\"10\" align=\"left\" valign=\"top\"></td>
      </tr>
      <tr>
        <td align=\"left\" valign=\"top\" class=\"verdana11pxgray\" title=\"$body\">";
		
		$shortbody = substr($body, 0, 40);
		if ($body == $shortbody)
		{
			$dispin.=  $shortbody;
		}
		else
		{
			$dispin.= $shortbody."...";
		}
		
		$dispin.=  "</td>
      </tr>
      <tr>
        <td align=\"left\" valign=\"top\"><table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
          <tr>
            <td class=\"verdana11pxorange\">".date("M d, Y", $date_news)."</td>
			<td width=\"12\" align=\"right\"><img src=\"".IMAGE_PATH."view_more_plus_icon2.gif\" width=\"12\" height=\"10\" /></td>
            <td width=\"65\" align=\"right\"><a href=\"/preferredsupplier/reports_fullstory.php?id=$id\" class=\"bluelink11px\" target=\"_blank\"> Full Story</a></td>
          </tr>
        </table></td>
      </tr>";
	
} // for loop


?><table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td align="left" valign="middle"  class="threecolumntitlebg" >Industry Reports</td>
  </tr>
  <tr>
        <td align="left" valign="top" bgcolor="#F1F1F1" style="border:#E6E6E6 1px solid; padding-left:10px; padding-right:10px; padding-bottom:10px">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
       
    </table></td>
  </tr>
</table>
</td>
                                </tr>
                                <tr>
                                  <td align="left" valign="top">&nbsp;</td>
                                </tr>
                            </table></td>
                            <td width="10" align="left" valign="top">&nbsp;</td>
                            <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                              <tr>
                                <td width="15">&nbsp;</td>
                                <td><table width="100%" border="0" cellspacing="0" cellpadding="0">
                                  <tr>
                                    <td></td>
                                  </tr>
                                  <tr>
                                    <td class="verdana11pxgray">Launched in 1998, YnFx.com is acknowledged as a leading provider of Textile Market Intelligence and Market Development, servicing members from across 150 countries. With an aspiration to be the one-stop-shop for the textile industry, YarnsandFibers.com has evolved to YnFx.com. It encompasses the entire textile chain from Fiber to Fabric. With changing business patterns, YnFx focuses on using online and offline mechanisms to bring people closer and deliver maximum value to members. YnFx has worked relentlessly to pursue its belief that effective Market Intelligence is the right information reaching the right person at the right time.</td>
                                  </tr>
                                  <tr>
                                    <td>&nbsp;</td>
                                  </tr>
                                
                                  <tr>
                                    <td height="10"></td>
                                  </tr>
                                  <tr>
                                    <td><table width="100%" border="0" cellspacing="0" cellpadding="0">
                                        <tr>
                                          <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                                             <tr>
                                    <td height="22" class="verdana12pxredbold">What's more, Registration is absolutely FREE!</td>
                                  </tr>
                                             <tr>
                                               <td height="10"></td>
                                             </tr>
                                             <tr>
                                              <td><table width="100%" border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                  <td width="20" height="25" align="center"><img src="../images/news_reports/black_bullet_tab.gif" width="5" height="5" /></td>
                                                  <td class="verdana11pxgray">Post your sell offers on the YnFx Preferred Supplier Program</td>
                                                </tr>
                                                <tr>
                                                  <td height="25" align="center"><img src="../images/news_reports/black_bullet_tab.gif" width="5" height="5" /></td>
                                                  <td class="verdana11pxgray">Buyers contact you directly</td>
                                                </tr>
                                                <tr>
                                                  <td height="25" align="center"><img src="../images/news_reports/black_bullet_tab.gif" width="5" height="5" /></td>
                                                  <td class="verdana11pxgray">Get Free Storefront thus enhancing online visibility for your company</td>
                                                </tr>
                                                <tr>
                                                  <td height="25" align="center"><img src="../images/news_reports/black_bullet_tab.gif" width="5" height="5" /></td>
                                                  <td class="verdana11pxgray">Get brief summary of Textile Market Intelligence from all across the world</td>
                                                </tr>
                                                <tr>
                                                  <td height="25" align="center"><img src="../images/news_reports/black_bullet_tab.gif" width="5" height="5" /></td>
                                                  <td class="verdana11pxgray">And much more&hellip;</td>
                                                </tr>
                                              </table></td>
                                            </tr>
                                          </table></td>
                                          <td width="200" align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                                              <tr>
                                                <td valign="top"><a href="http://www.yarnsandfibers.com/preferredsupplier/registration.php" target="_blank"><img src="../images/services/btn_register_now.png" width="149" height="30" border="0" /></a></td>
                                              </tr>
                                              <tr>
                                                <td height="2"></td>
                                              </tr>
                                              <tr>
                                                <td><a href="#" onClick="window.print()"><img src="../images/services/btn_print.png" width="149" height="30" border="0" /></a></td>
                                              </tr>
                                              <tr>
                                                <td height="2"></td>
                                              </tr>
                                              <tr>
                                                <td><a href="http://www.yarnsandfibers.com/services/emailfriend.php?site=/services/index.php"><img src="../images/services/btn_refer.png" width="149" height="30" border="0" /></a></td>
                                              </tr>
                                              <tr>
                                                <td height="2"></td>
                                              </tr>
                                              <tr>
                                                <td><a href="http://www.yarnsandfibers.com/services/customise_product.htm" target="_blank"><img src="../images/services/btn_view_rate.png" width="149" height="30" border="0" /></a></td>
                                              </tr>
                                              <tr>
                                                <td height="2"></td>
                                              </tr>
                                              <tr>
                                                <td><a href="http://www.yarnsandfibers.com/corporate/helpdesk/index.php" target="_blank"><img src="../images/services/btn_contactus.png" width="149" height="30" border="0" /></a></td>
                                              </tr>
                                          </table></td>
                                        </tr>
                                    </table></td>
                                  </tr>
                                  <tr>
                                    <td>&nbsp;</td>
                                  </tr>
                                  <tr>
                                    <td class="verdana12pxredbold">What is Preferred Membership Plan?</td>
                                  </tr>
                                  <tr>
                                    <td>&nbsp;</td>
                                  </tr>
                                  <tr>
                                    <td class="verdana11pxgray">YnFx Preferred Supplier Program offers a platform to the Suppliers who showcase their offerings on YnFx to interact with new and potential Buyers.<br />
                                        <br />
                                      It acts as a cost effective marketing tool for business house to enhance their market reach to an international level.<br />
                                      <br />
                                      More than 5000 visitors visit YnFx.com every day which helps you with more and more visibility to compete with national and international markets.</td>
                                  </tr>
                                  <tr>
                                    <td>&nbsp;</td>
                                  </tr>
                                  <tr>
                                    <td class="verdana12pxredbold">What are the features?</td>
                                  </tr>
                                  <tr>
                                    <td height="10"></td>
                                  </tr>
                                  <tr>
                                    <td><table width="100%" border="0" cellspacing="0" cellpadding="0">
                                        <tr>
                                          <td width="20" height="25" align="center"><img src="../images/news_reports/black_bullet_tab.gif" width="5" height="5" /></td>
                                          <td class="verdana11pxgray">Make your company Visible free of cost with YnFx&rsquo;s Preferred Supplier Program</td>
                                        </tr>
                                        <tr>
                                          <td height="25" align="center"><img src="../images/news_reports/black_bullet_tab.gif" width="5" height="5" /></td>
                                          <td class="verdana11pxgray">Get a storefront displaying your company profile, products from where Buyers can contact you directly</td>
                                        </tr>
                                        <tr>
                                          <td height="25" align="center"><img src="../images/news_reports/black_bullet_tab.gif" width="5" height="5" /></td>
                                          <td class="verdana11pxgray">Upload number of products in no time and simple process</td>
                                        </tr>
                                        <tr>
                                          <td height="25" align="center"><img src="../images/news_reports/black_bullet_tab.gif" width="5" height="5" /></td>
                                          <td class="verdana11pxgray">Get authenticate buyer contacting you for your product</td>
                                        </tr>
                                    </table></td>
                                  </tr>
                                  <tr>
                                    <td>&nbsp;</td>
                                  </tr>
                                  <tr>
                                    <td class="verdana12pxredbold">What are the benefits? </td>
                                  </tr>
                                  <tr>
                                    <td height="10"></td>
                                  </tr>
                                  <tr>
                                    <td><table width="100%" border="0" cellspacing="0" cellpadding="0">
                                        <tr>
                                          <td width="20" height="25" align="center"><img src="../images/news_reports/black_bullet_tab.gif" width="5" height="5" /></td>
                                          <td class="verdana11pxgray">Fast and economical way to get new buyers through out the globe</td>
                                        </tr>
                                        <tr>
                                          <td height="25" align="center"><img src="../images/news_reports/black_bullet_tab.gif" width="5" height="5" /></td>
                                          <td class="verdana11pxgray">Benefit from the highly visited and used sourcing platform</td>
                                        </tr>
                                        <tr>
                                          <td height="25" align="center"><img src="../images/news_reports/black_bullet_tab.gif" width="5" height="5" /></td>
                                          <td class="verdana11pxgray">Develop new regions and end usages</td>
                                        </tr>
                                        <tr>
                                          <td height="25" align="center"><img src="../images/news_reports/black_bullet_tab.gif" width="5" height="5" /></td>
                                          <td class="verdana11pxgray">No start up cost</td>
                                        </tr>
                                        <tr>
                                          <td height="25" align="center"><img src="../images/news_reports/black_bullet_tab.gif" width="5" height="5" /></td>
                                          <td class="verdana11pxgray">Pay per lead</td>
                                        </tr>
                                    </table></td>
                                  </tr>
                                </table></td>
                                <td width="15">&nbsp;</td>
                              </tr>
                            </table></td>
                          </tr>
                      </table></td>
                    </tr>
                    
                    <tr>
                      <td>&nbsp;</td>
                    </tr>
                </table></td>
                <td width="9">&nbsp;</td>
              </tr>
            </table></td>
          </tr>
          <tr>
            <td><? include "../bottom_banner.php";?></td>
          </tr>
          <tr>
            <td height="10"></td>
          </tr>
        </table></td>
      </tr>
      
    </table></td>
    <td width="11" align="left" valign="top" background="../images/right_border_bg.gif">&nbsp;</td>
  </tr>
</table>

</body>
</html>