<?
$ppp = 300;

require_once("header.inc.php");
  
if (!isset($_GET["cat"]))
  exit;
$cat = (int)$_GET["cat"];
if ($cat < 1 || $cat > 4)
  exit;

$langels = array ("lt", "ru", "en", "fr", "pl");
$langel = $langels[$lang - 1];
$bgimages = array("sit_vamzdziai.jpg", "sit_armatura.jpg", "sit_gelezinkelio.jpg", "sit_spec.jpg");

$ats = mb_strtoupper($glob["atstitle"], "utf-8");
$tpl->set_var("ats", $ats);


$query = "SELECT * FROM mon_texts WHERE lang=$lang";
$result = mysql_query($query);
if (!($row = mysql_fetch_array($result, MYSQL_ASSOC)))
  exit;
$titles = array($row["prod1title"], $row["prod2title"], $row["prod3title"], $row["prod4title"]); 
$imagelogo = $row["prod".$cat."image"];

$tpl->set_file("content", "prod.tpl", 1);
$tpl->set_var("langel", $langel);
$tpl->set_var("projbody", "");
$tpl->set_var("title", $titles[$cat - 1]);
$tpl->set_var("image", $imagelogo);
$tpl->set_var("glob", $glob);
$tpl->set_var("prodtitle", mb_strtoupper($titles[$cat - 1], "utf-8"));

$tpl->set_var("bgimage", $bgimages[$cat - 1]);
if (!isset($_GET["page"]))
  $page = 1;
else
  $page = (int)$_GET["page"];
  
$result = mysql_query("SELECT COUNT(*) FROM mon_products WHERE lang=$lang AND cat_id=$cat");
$row = mysql_fetch_row($result); 
$pagecount = ceil($row[0] / $ppp);

if ($page < 1 || $page > $pagecount)
  $page = 1;

$offset = $ppp * ($page - 1);
$query = "SELECT * FROM mon_products WHERE lang=$lang AND cat_id=$cat ORDER BY pos ASC LIMIT $offset, $ppp";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
  {
    $row["juosta"] = "";
    $subquery = "SELECT * FROM mon_prpictures WHERE proj_id=".$row["id"]." ORDER BY position ASC, pos_type ASC";
    $subresult = mysql_query($subquery);
    while ($subrow = mysql_fetch_array($subresult))
    {
      if ($subrow["pos_type"] == 0)
      {
        $tpl->set_var("image", $subrow);
        $row["juosta"] .= $tpl->process("", "image1");
      }
      if ($subrow["pos_type"] == 1)
      {
        $tpl->set_var("image1", $subrow);
        $tpl->set_var("image2", mysql_fetch_array($subresult));
        $row["juosta"] .= $tpl->process("", "image2");
      }
    }
    $tpl->set_var("item", $row);
    $tpl->process("projbody", "projitem", 1, 0, 1);
  }
/*if ($pagecount == 1)
  $tpl->set_var("pages", "");
else
{
  for ($i = 0; $i < $pagecount; $i++)
  {
    $tpl->set_var("num", $i + 1);
    if ($i > 0)
      $tpl->process("pages", "pageseparator", 1, 0, 1);
    $tpl->process("pages", "pagelink", 1, 0, 1);
  }
}
*/
echo $tpl->process("", "content");

?>