<?
$ppp = 3;

require_once("header.inc.php");

$tpl->set_file("content", "proj.tpl", 1);
$tpl->set_var("projbody", "");
if (!isset($_GET["page"]))
  $page = 1;
else
  $page = (int)$_GET["page"];


$backs = array("PRADŽIA", "НАЧАЛО", "BACK", "RETOUR", "ZACZĄĆ");

$tpl->set_var("back", $backs[$lang - 1]);
$ats = mb_strtoupper($glob["atstitle"], "utf-8");
$tpl->set_var("ats", $ats);
$tpl->set_var("ttt", $glob["subtext"]);

$result = mysql_query("SELECT * FROM mon_texts WHERE lang=$lang");
$row = mysql_fetch_array($result, MYSQL_ASSOC); 
$tpl->set_var("text", $row["projtext"]);
$tpl->set_var("image", $row["projimage"]);
$tpl->set_var("title", $row["projtitle"]);
$tpl->set_var("uctitle", mb_strtoupper($row["projtitle"], "utf-8"));
$tpl->set_var("glob", $glob);

$result = mysql_query("SELECT COUNT(*) FROM mon_projects WHERE lang=$lang");
$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_projects WHERE lang=$lang 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_ppictures 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 || $pagecount == 0)
  $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);
    if ($i == $page - 1)
      $tpl->process("pages", "pagenolink", 1, 0, 1);
    else
      $tpl->process("pages", "pagelink", 1, 0, 1);
  }
}

echo $tpl->process("", "content");

?>