<?php
$przeznaczenie="";

session_start();

include("admin/config.php");

include( "admin/settings.inc.php");

include( "shoppingcart.php");

include( "header.inc.php");

include("funkcje.php");

$cart = new Cart;

include("subheader.inc.php");
 include("menu.inc.php");
//echo" view_product.php";
// start border
sb("100%",$la_view_prod_info,$colour_1,$bg_colour);

	// make sure product exists/has been selected
	if(empty($product))
		{
			echo "<div align='center'><br>$la_view_prod_sel</div>";
		}
	else
		{
			$select_prod = mysql_query( "SELECT * FROM ".$prefix."store_inventory WHERE product='".$product."'");
			$totalrows = mysql_num_rows($select_prod);

			if($totalrows==0)
				{
					echo"<br><br><p align=\"center\">$la_view_prod_noexist</p>";
				}

	// build page for product
	if($totalrows!==0)
		{
			while ($row = mysql_fetch_array($select_prod))
				{
					$title = $row["title"];
					$image = $row["image"];
					$description = $row["description"];
					$quantity = $row["quantity"];
					$rozmiar = $row["rozmiar"];
					$price = $row["price"];
                                        $sale_price = $row["sale_price"];
					$cat_id = $row["cat_id"];
					$popularity = $row["popularity"];
					$autor = $row["autor"];
				}

	// add 1 to products popularity
	$new_pop = $popularity + 1;
	$sql_update = "update ".$prefix."store_inventory set popularity='$new_pop' where product='".$product."'";
	$result = mysql_query ($sql_update); 

	$title=stripslashes($title);
	$description = stripslashes($description);
	$description = nl2br($description);

	$select_cat = mysql_query( "SELECT * FROM ".$prefix."store_category WHERE cat_id='".$cat_id."'");
	while ($row = mysql_fetch_array($select_cat))
		{
			$category = $row["category"];
			$cat_image = $row["cat_image"];
		}

// navigation if directed from search.php
if($searchlink=="yes")
	{
		echo"<a href=\"index.php\" target=\"_self\">$la_search_home</a> > <a href=\"search.php?search=$search&page=$page\" target=\"_self\">$la_view_prod_search_res</a> > $title<br>";
	}

// navigation if directed from elsewhere
else
	{
		include( "link_navi.php");
	}

// echo "<b><font size=\"5\">asdfasdfafds</font></b><br>";
//if ($cat_image!='catnophoto.gif')
//	{
//		echo"</p><img src='images/$cat_image'><br>";
//	}
	 //    view_cart.php?add=$product\
	extract($_POST);
	extract($_REQUEST);
	if (policz()==0){
	echo"<br><FORM ACTION=\"view_product.php?product=$product\" name=\"view_product\" method=\"post\">";
	} else {
        echo"<br><FORM ACTION=\"view_cart.php?add=$product\" name=\"add_product\" method=\"post\" >";
        }
	
			echo"<table align=\"center\" width=\"90%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
				<tr>
					<td bgcolor=\"$colour_2\">
						<table cellpadding=\"3\" border=\"0\" cellspacing=\"1\" width=\"100%\" align=\"center\">
							<tr bgcolor=\"$colour_1\" valign='top'>	
								<td width=\"33%\"><b>$title</b>
								<p><div align='center'><img src='images/$image'width=\"90%\"></div></p></td>
								<td align='left' valign='top' width=\"66%\" colspan=\"2\"><p><b>$la_store_description:</b></p>$description";
				
								// next line for when stock quanity mod is made
								//<p><b>$la_order_quan:</b> $quantity</p>
					
								if(($sale=="Y")and($sale_price!=="0.00"))
									{
									//	echo"<p><b>$la_normal_price</b> $currency<s>$price</s></p>";
									//	echo"<p><b>$la_sale_price</b> $currency<font color=\"990000\">$sale_price</font></p>";
									}
					
								if(($sale=="Y")and($sale_price=="0.00"))
									{
									//	echo"<p><b>$la_store_price:</b> $currency$price</p>";
									}
					
								if($sale=="N")
									{
									//	echo"<p><b>$la_store_price:</b> $currency$price</p>";
									}
								echo" <p align=\"Center\">";
                                                                echo"<br>";
                                                                echo "<b>Author:</b><br>";
                                                                echo $autor;
                                                                echo"<br>";
                                                                echo"<br>";
                                                                echo "<b>Copyright:</b><br>";
                                                                echo "&copy Tennis Press-Photo Agency <br>";
                                                                echo "ALL RIGHTS RESERVED <br>";
                                                                echo"<br>";
                                                                echo" </p>";
                                                                
                                                                
								echo"<p><img src='images/bullet.gif' border='0'> <a href='tellafriend.php?product=$product&session=$session'>$la_view_prod_tellfriend</a></p>";
								// future link to wishlist.php ;)
								//echo"<p><img src='images/bullet.gif' border='0'> <a href='wishlist.php?product=$product&session=$session'>$la_view_prod_add_wish</a></p></td>
                                                                 $product_cena="aca033004-6110-019";
                                                                 

                                                                 
$select = mysql_query("SELECT * FROM ".$prefix."store_inventory WHERE ( product='".$product."') AND (`p_date` LIKE '%2003%' OR `p_date` LIKE '%2004%' OR `p_date` LIKE '%2005%' OR `p_date` LIKE '%2006%' OR `p_date` LIKE '%2007%')");
$count = mysql_num_rows($select);
    
//echo"roz=$rozmiar<br>";
//criteria.petla($rozmiar);
if($count>0)
{ 
  echo "<br>";
  echo "<br>";
  echo "<br>";
  echo"<H3>For general sales inquiries and pricing please email us at: </H3></p>";
  echo"<H4><a href='mailto:info@tennispress.com?subject=Question regarding picture $product'>info@tennispress.com</a></H4>";
  
}
else
{                                
                                                               
                                                                 
								// START PRODUCT OPTIONS
								$select = mysql_query("SELECT distinct option_id FROM ".$prefix."store_options_bot WHERE product='$product_cena'");
								$count = mysql_num_rows($select);
                                                                $count=0;
                                                                //echo"roz=$rozmiar<br>";
                                                                criteria.petla($rozmiar);
								if($count>0)
									{   
										echo"<b>$la_product_options_view</b><br>";

										//start table
										echo"<table border=\"0\" cellspacing=\"0\" cellpadding=\"5\">";
					
										// find options
					
										$option_number = 0;
					
										while ($row = mysql_fetch_array($select))
											{
												$option_id = $row["option_id"];
		
												$option_number = $option_number + 1;
						
												echo"<tr>
														<td align=\"left\">";
														
														// build option name
														$query = "select * from ".$prefix."store_options_top where option_id = '$option_id'"; 
														$result = mysql_query($query)or die("Error: " . mysql_error()); 
														while ($row = mysql_fetch_array($result))
															{
																$option_name=$row["option_name"];
															}
														
														//echo"$option_name:";
							
														echo"</td><tr>
														<table cellspacing=\"0\" bgcolor=\"#0066FF\" class=\"pricecalc\" id=\"table10\" width=\"60%\">
                                                                                                                                          <tr>
														

														</tr><td align=\"center\">";
							
														// build select
														echo"<select name=\"dyn_opt$option_number\" style=\"width:145 height:60\">
																<option value=\"\">$la_please_choose</option>";
																
																$select_value = mysql_query("SELECT * FROM ".$prefix."store_options_bot WHERE product='$product_cena' and option_id = '$option_id'");

																while ($row_value = mysql_fetch_array($select_value))
																	{
																		$assign_id = $row_value["assign_id"];
																		$value_id = $row_value["value_id"];
																		$option_price = $row_value["option_price"];
																		$option_symbol = $row_value["option_symbol"];
										                                                                $option_price=$option_price+20;
																		// get value name :)
																		$query_name = "select * from ".$prefix."store_options_mid where value_id = '$value_id'"; 
																		$result_name = mysql_query($query_name)or die("Error: " . mysql_error()); 
																		
																		while ($row_name = mysql_fetch_array($result_name))
																			{
																				$value_name=$row_name["value_name"];
																			}
										
															echo"<option value=\"$assign_id\">$value_name";
															if($option_price!=0){
															echo" ( $currency$option_price.00 )";}
															echo"</option>";
									
																	}
							
														echo"</select>";
												echo"</td>
											</tr>";
										}
										
										
                                                                                /////// ============================ wstawka ================================






     //     echo"</td></tr><tr><td>";


 // ======================wstawka po pierwszym




// echo"</tr><br>";

/////// ============================ koniec  wstawki ================================



							echo"</table>";
					} //end if($count>0)
					// END PRODUCT OPTIONS
}					
					
					
					


			echo"</tr>";
			

			
		// z 282 background=\"images/white_button.gif\"
                //   style='cursor:hand;' onClick='add_product.submit();'><a href='#'><font class=\"wht_btn\">$la_add_to_basket</font></a>
		//z 280 <td height=\"30\" align=\"right\" valign=\"middle\" background=\"images/grey_bev.gif\"></td>
			
		echo"	<tr height=\"30\">
				<td width=\"33%\" height=\"30\" background=\"images/grey_bev.gif\">$la_view_prod_code $product</td>

				<td height=\"30\" align=\"center\" background=\"images/grey_bev.gif\" align=\"right\" valign=\"middle\">
                                                &nbsp;</td>
                                   </form>
				</tr>
			</table>
		</td>
	</tr>
</table><br><br>";

	}
}//end if there is a result

// end border
eb($bg_colour,$colour_1);

include("subfooter.inc.php");

include("footer.inc.php");

?>
  


