session_start();

$ecom_link = mysql_connect($DB_Host , $DB_Username , $DB_Password) or die ("Couldn't connect to the ecom server.");
$ecom_db = mysql_select_db($DB_Name,$ecom_link) or die ("Couldn't select the ecom database.");

$myGlobal_Variables = Array();
$qry = "SELECT * FROM ecom_global_variables WHERE Customer='$Customer'";
$result = mysql_query($qry, $ecom_link) or die("Error in selecting global variables<br>" . mysql_error());
if($arow=mysql_fetch_array($result))
	$myGlobal_Variables = $arow;
mysql_free_result($result);//$paypal_url = "https://www.sandbox.paypal.com/cgi-bin/webscr";
$paypal_url = "https://www.paypal.com/cgi-bin/webscr";

function getProductCount($fun_cid)
{
	GLOBAL $myProductCount;
	
	$qry = "SELECT * FROM ecom_product_categories WHERE Category_Id=$fun_cid";
	$result = mysql_query($qry) or die("Error in selecting product categories<br>" . mysql_error());
	$myProductCount += mysql_num_rows($result);
	mysql_free_result($result);
	
	$qry = "SELECT * FROM ecom_categories WHERE Parent_Category_Id=$fun_cid";
	$result = mysql_query($qry) or die("Error in slecting child categories<br>" . mysql_error());
	while($arow=mysql_fetch_array($result))
		getProductCount($arow["Category_Id"]);
	mysql_free_result($result);
}

function getParentCategory($fun_cid)
{
	$qry = "SELECT Parent_Category_Id FROM ecom_categories WHERE Category_Id=$fun_cid";
	$result = mysql_query($qry) or die("Error in slecting parent category ids<br>" . mysql_error());
	if($arow=mysql_fetch_array($result))
		$fun_result = $arow["Parent_Category_Id"];
	else
		$fun_result = 0;
	mysql_free_result($result);
	
	return $fun_result;
}

function isHard($fun_cart)
{
	$myResult = false;
	for($i=0;$i<count($fun_cart["PID"]);$i++)
	{
		$qry = "SELECT Product_Format FROM ecom_products WHERE Product_Id=" . $fun_cart["PID"][$i];
		$result = mysql_query($qry) or die("Error in selecting product format<br>" . mysql_error());
		if($arow=mysql_fetch_array($result))
		{
			if($arow["Product_Format"]=="Hard")
				$myResult = true;
		}
		mysql_free_result($result);
	}
	
	return $myResult;
}

function fsockPost($data)
{ 
	GLOBAL $paypal_url;
	
	$web=parse_url($paypal_url);

	$postdata="";
	foreach($data as $i=>$v)
		$postdata.= $i . "=" . urlencode($v) . "&"; 

	$postdata.="cmd=_notify-validate";

	if($web[scheme] == "https")
	{
		$web[port]="443";
		$ssl="ssl://";
	}
	else
		$web[port]="80";

	$fp=@fsockopen($ssl . $web[host],$web[port],$errnum,$errstr,30); 

	if(!$fp)
		echo "$errnum: $errstr";
	else
	{
		fputs($fp, "POST $web[path] HTTP/1.1\r\n"); 
		fputs($fp, "Host: $web[host]\r\n"); 
		fputs($fp, "Content-type: application/x-www-form-urlencoded\r\n"); 
		fputs($fp, "Content-length: ".strlen($postdata)."\r\n"); 
		fputs($fp, "Connection: close\r\n\r\n"); 
		fputs($fp, $postdata . "\r\n\r\n"); 

		while(!feof($fp))
			$info[]=@fgets($fp, 1024);

		fclose($fp); 

		$info=implode(",",$info); 
	}
	
	return $info; 
}echo "<style>
	.ecom_tblbg {background-color: " . $myGlobal_Variables["Table_Border_Color"] . " } 
	.ecom_tblheader { font-family: " . $myGlobal_Variables["TH_Font_Type"] . "; font-size: " . $myGlobal_Variables["TH_Font_Size"] . "px; font-weight: bold; color: " . $myGlobal_Variables["TH_Font_Color"] . "; background-color: " . $myGlobal_Variables["TH_BG_Color"] . "; line-height: 20px} 
	.ecom_tblrow { font-family: " . $myGlobal_Variables["TR_Font_Type"] . "; font-size: " . $myGlobal_Variables["TR_Font_Size"] . "px; color: " . $myGlobal_Variables["TR_Font_Color"] . "; font-weight: normal; vertical-align: top;background-color:" . $myGlobal_Variables["TR_BG_Color"] . "} 
	.ecom_input {font-family: " . $myGlobal_Variables["Text_Box_Font_Type"] . "; font-size: " . $myGlobal_Variables["Text_Box_Font_Size"] . "px; color: " . $myGlobal_Variables["Text_Box_Font_Color"] . "; border: " . $myGlobal_Variables["Text_Box_Border_Size"] . "px " . $myGlobal_Variables["Text_Box_Border_Color"] . " solid}
	.ecom_but {font-family: " . $myGlobal_Variables["Button_Font_Type"] . "; font-size: " . $myGlobal_Variables["Button_Font_Size"] . "px; color: " . $myGlobal_Variables["Button_Font_Color"] . "; background-color: " . $myGlobal_Variables["Button_BG_Color"] . "; border: " . $myGlobal_Variables["Button_Border_Size"] . "px " . $myGlobal_Variables["Button_Border_Color"] . " solid; font-weight: normal}
	.ecom_font {font-family: Verdana; font-size: 11px;}
	.ecom_large_font {font-family: Verdana; font-size: 12px;}
	.ecom_heading {font-family: " . $myGlobal_Variables["Heading_Font_Type"] . "; font-size: " . $myGlobal_Variables["Heading_Font_Size"] . "px; color: " . $myGlobal_Variables["Heading_Font_Color"] . "; font-weight: bold;text-decoration: underline;}
	.ecom_error {font-family: " . $myGlobal_Variables["Error_Font_Type"] . "; font-size: " . $myGlobal_Variables["Error_Font_Size"] . "px; color: " . $myGlobal_Variables["Error_Font_Color"] . "; font-weight: bold;}
	a:hover {color: " . $myGlobal_Variables["Rollover_Link_Color"] . "}
</style>\n";

echo "
<script language=\"Javascript\">
function ecom_preloadImages() {
  var d=document; if(d.images){ if(!d.ecom_p) d.ecom_p=new Array();
    var i,j=d.ecom_p.length,a=ecom_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf(\"#\")!=0){ d.ecom_p[j]=new Image; d.ecom_p[j++].src=a[i];}}
}

function ecom_swapImgRestore() { //v3.0
  var i,x,a=document.ecom_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}

function ecom_findObj(n, d) {
  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=ecom_findObj(n,d.layers[i].document);
  if(!x && document.getElementById) x=document.getElementById(n); return x;
}

function ecom_swapImage() {
  var i,j=0,x,a=ecom_swapImage.arguments; document.ecom_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=ecom_findObj(a[i]))!=null){document.ecom_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}

</script>\n\n";

echo "
<script language=\"Javascript\">
function goCategory(cid,cpage,product_cpage)
{
	document.frmTemp_Category.action = \"ecom_category.php\";
	document.frmTemp_Category.CID.value = cid;
	document.frmTemp_Category.CPage.value = cpage;
	document.frmTemp_Category.Product_CPage.value = product_cpage;
	document.frmTemp_Category.target = \"" . $myGlobal_Variables["Category_Link_Target"] . "\";
	document.frmTemp_Category.submit();
}

function goProduct(cid,pid)
{
	document.frmTemp_Product.action = \"ecom_product.php\";
	document.frmTemp_Product.CID.value = cid;
	document.frmTemp_Product.PID.value = pid;
	document.frmTemp_Product.submit();
}
</script>

<form name=\"frmTemp_Category\" method=\"post\">
	<input type=\"hidden\" name=\"CID\">
	<input type=\"hidden\" name=\"CPage\">
	<input type=\"hidden\" name=\"Product_CPage\">
</form>

<form name=\"frmTemp_Product\" method=\"post\">
	<input type=\"hidden\" name=\"CID\">
	<input type=\"hidden\" name=\"PID\">
</form>";
<html>
<head>
<title>Template Garden</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="JavaScript" type="text/JavaScript" src="js/js.js"></script>
<link href="css/css.css" rel="stylesheet" type="text/css">
</head>

<body bgcolor="#EAEAEA" link="#666666" vlink="#666666" alink="#666666" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="777" height="100%" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td width="777" align="left" valign="top"><table width="777" height="100%"  border="0" cellpadding="0" cellspacing="0">
        <tr align="left" valign="top">
          <td width="11" background="images/left_bg.gif"><img src="images/left_bg.gif" width="11" height="1"></td>
          <td width="755"><table width="755" height="100%"  border="0" cellpadding="0" cellspacing="0">
              <tr>
                <td width="755" height="52" align="left" valign="top"><table width="755"  border="0" cellspacing="0" cellpadding="0">
                    <tr align="left" valign="top">
                      <td width="550" bgcolor="#FFFFFF"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                          <tr align="left" valign="middle">
                            <td width="200"><img src="images/templategarden.gif" alt="Template Garden" width="200" height="52"></td>
                            <td align="right"><table width="280"  border="0" cellspacing="0" cellpadding="0">
                                <tr align="left" valign="middle">
                                  <td width="90" align="center" class="bodytext"><a href="index.php">Home</a></td>
                                  <td width="1"><img src="images/doted.gif" width="1" height="22"></td>
                                  <td width="290" align="center" class="bodytext"><a href="login.php">Developers Area</a></td>
                                  <td width="1"><img src="images/doted.gif" width="1" height="22"></td>
                                  <td width="290" align="center" class="bodytext"><a href="ecom_viewcart.php">Check Out</a></td>
                                  <td width="1"><img src="images/doted.gif" width="1" height="22"></td>
                                  <td width="90" align="center"><span class="bodytext"><a href="contact.php">Contact</a></span></td>
                                  <td width="30">&nbsp;</td>
                                </tr>
                            </table></td>
                          </tr>
                      </table></td>
                      <td width="205"><img src="images/select_category.gif" alt="SELECT A CATEGORY THAT BEST DESCRIBES YOUR BUSINESS:" width="205" height="52"></td>
                    </tr>
                </table></td>
              </tr>
              <tr>
                <td align="left" valign="top"><table width="755" height="100%"  border="0" cellpadding="0" cellspacing="0">
                    <tr align="left" valign="top">
                      <td width="550" bgcolor="#FFFFFF"><table width="550" height="100%"  border="0" cellpadding="0" cellspacing="0">
                          <tr>
                            <td width="550" height="180" align="left" valign="top"><img src="images/img.jpg" alt="High performance LOW COST" width="550" height="180"></td>
                          </tr>
                          <tr>
                            <td height="14" align="left" valign="top"><img src="images/belt.gif" width="550" height="14"></td>
                          </tr>
                          <tr>
                            <td height="15" align="left" valign="top">&nbsp;</td>
                          </tr>
                          <tr>
                            <td align="left" valign="top">

	<script language="Javascript">
	function check()
	{
	    frm = document.frm1;
	    if(!validateEmail(frm.Email))
	        return false;
	    else if(frm.Password.value.split(" ").join("").length<=0)
	    {
	        alert("Please enter password");
	        frm.Password.focus();
	        frm.Password.select();
	        return false;
	    }
	    else
	        return true;
	}

	function validateEmail(fld)
	{
	    var my=fld.value;
	    var attherate=my.indexOf("@");
	    var lastattherate = my.lastIndexOf("@")
	    var dotpos=my.lastIndexOf(".");
	    var posspace = my.indexOf(" ");
	    var totallen = my.length;
	    
	    if (attherate<=0 || dotpos<=0 || attherate > dotpos || (dotpos-attherate)<=1 || (dotpos == totallen-1) || posspace > -1 || attherate!=lastattherate)
	        {
	            alert("Inavalid Email.");
	            fld.focus();
	            fld.select();
	            return false;
	        }
	    else
	        return true;
	}
	</script>

	<form name="frm1" method="post" action="login_db.php" onsubmit="return check();">
	
	  <table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
	    <tr>
	      <td class="ecom_tblbg"><table width="100%"  border="0" cellspacing="0" cellpadding="2">
	        <tr>
	          <td class="ecom_tblheader">
	          Email: <input name="Email" type="text" class="ecom_input" size="15" maxlength="100"> 
	          Password: <input name="Password" type="password" class="ecom_input" size="15" maxlength="20"> <input class="ecom_but" type="submit" value="Login">
	            </td>
	          <td class="ecom_tblrow" align="right"><a href="signup.php">New User?</a><br><a href="forgotpass.php">Forgot Password</a></td>
	        </tr>
	      </table></td>
	    </tr>
	  </table>
	</form>
	
	<script language="Javascript">
		document.frm1.Email.focus();
	</script>
<table width="80%" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td class="ecom_tblbg">
     <table width="100%"  border="0" cellspacing="0" cellpadding="2" align="center">
      <tr>
          <td class="ecom_tblrow"><font color=BLUE><div align="justify">

				<br />
<b>Warning</b>:  mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (13) in <b>/mounted-storage/home36a/sub001/sc28965-YOKW/templategarden.com/login.php</b> on line <b>94</b><br />
<br />
<b>Warning</b>:  mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: A link to the server could not be established in <b>/mounted-storage/home36a/sub001/sc28965-YOKW/templategarden.com/login.php</b> on line <b>94</b><br />
Error in selecting developers home page content