<?
$getTime= explode(' ', microtime());
$StartTime = $getTime[1] + $getTime[0];
//$url="http://inetman.mikrozoft.com/photos/salsa/060107/";
$OldErr = error_reporting(0);
error_reporting($OldErr);
$html_dir = "/home/coronel/public_html";

$div="photo";
$gid=$_GET["gid"];
$gid=$_GET["gid"];
if (!is_numeric($gid)) $gid=223;
$year=$_GET["year"];
$subdiv=$gid;

include ("servlist.php");

if ($gid == "")
	{
	$s=$_GET["s"];
	$dir=$_GET["gal"];
	$init = $_GET["init"];
	}
else
	{
	@mysql_pconnect ("localhost", "coronel_user", "coronet");
@mysql_select_db ("coronel_photo");
$query = "select * from ph_list where id='$gid'";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
if ($row["id"] == "")
	{
	include($html_dir."/header.php"); //SERVERWIDE TOP
	print "ERROR! NO SUCH GALLERY!";
	include($html_dir."/footer.php"); //SERVERWIDE BOTTOM
	die;
	}
	$gid=$row["id"];
	$gidmonth=date("n",$row["date"]);
	$gidyear=date("Y",$row["date"]);
	$subdiv=$gid;
	$s=$row["server_id"];
	$dir=$row["dirname"];
	}
$start=$_GET["start"];
$perpages = array(2,3,4,5,6,7,8);
$perrow = 4;
if ($_POST["galsize"] and is_numeric($_POST["galsize"]) and is_numeric($_POST["perrow"]))
   {
   $perrow = ceil($_POST["perrow"]);
   if (!$perrow)
      {
      $perrow = 4;
      }
   $galsize = ceil($_POST["galsize"]); //R u too clever? I've got a catch!
   if (!$galsize)
      {
      $galsize = 4;
      }
   settype($galsize,integer);
   settype($perrow,integer);
   setcookie('galsize', $galsize, time()+60*60*24*730, '/');
   setcookie('perrow', $perrow, time()+60*60*24*730, '/');
   $perpage=$galsize*$perrow;
   }
else if ($_COOKIE["galsize"])
   {
   $perrow=$_COOKIE["perrow"];
    if (!$perrow)
      {
      $perrow = 4;
      }
    $galsize=$_COOKIE["galsize"];
   $perpage=$_COOKIE["galsize"]*$perrow;
   }	
else
    {
    $perpage=16;
    $galsize = 4;
    $perrow = 4;
    }

if (!$start)
	{
	$start=0;
	}

//settin' URL and local URL...
$query = "select * from servers where id='$s'";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$url = "http://". $row["path"] . $dir ."/";
//$url = "http://". ${"s".$s} . $dir ."/";
$lurl = $s."/".$dir."/";
$lpath = "/home/coronel/public_html/photo/".$s."/".$dir."/";
if ($s != 0)
   {
   //otherwise there will be errors...
$handle = @file ($url ."dir.desc");
}
if (!$handle and $s != 0)
	{
	include($html_dir."/header.php"); //SERVERWIDE TOP
	print "Извините, галерея была удалена либо сервер, на котором она была размещена, временно недоступен. Список галерей обновлён. Для выяснения причин произошедшего Вы можете связаться с администрацией сайта.";
	$link=@mysql_pconnect ("localhost", "coronel_photo", "salsaphoto") or die("Could not connect to MySQL server!");
@mysql_select_db ("coronel_photo");
	$query="update ph_list set cat='x' where id='$gid'";
	@mysql_query($query); //temporary block blocking
	@mysql_close($link);
	include($html_dir."/footer.php");
	die;
	}
//$file = @fopen ($lpath . "001tn.jpg", "r");
if ($s != 0)
   {
   //otherwise there will be errors...
$handle = @file ($url ."dir.desc");
}
if (!$handle and $init != "y" and $s != 0)
	{
	include($html_dir."/header.php"); //SERVERWIDE TOP
	print "ERROR! NO SUCH GALLERY!";
	include($html_dir."/footer.php");
	die;
	}

include ("img_resize.php");

	
if	($gid=="")
{
$link=@mysql_pconnect ("localhost", "coronel_user", "coronet");
@mysql_select_db ("coronel_photo");
$query = "select * from ph_list where server_id='$s' and dirname='$dir'";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
if ($row["id"] == "")
	{
	include($html_dir."/header.php"); //SERVERWIDE TOP
	print "ERROR! NO SUCH GALLERY!";
	include($html_dir."/footer.php");
	die;
	}
$gid=$row["id"];
$subdiv=$gid;
}
else
    {
    $query = "select * from ph_list where id='$gid'";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
    
    }
$addc=0;
		if (strpos($row["cat"], "s") !== false)
			{
			$add = "сальса";
			$addc++;
			}
		if (strpos($row["cat"], "t") !== false)
			{
			$add = "танго";
			$addc++;
			}
$title="Фото";
$description = $row["name"]." - фотогалерея";
if ($addc == 1)
   {
   $title .= ": ".$add;
   $description .= " (".$add.")";
   }
$title .= " &gt;&gt; ".$row["name"];
$description .= " на coronel.ru";
$keywords = $row["keywords"];
$galname=$row["name"];
$ename=$row["ext_name"];
$galdate=$row["date"];
if (!$row["name"])
   {
   $title .= $ename;
   }
$owner=$row["owner_id"];
@mysql_close($link);
include($html_dir."/header.php");

$link=@mysql_pconnect ("localhost", "coronel_user", "coronet");
@mysql_select_db ("coronel_photo");
?>
<script>
(function(w, d, s) {
  function go(){
  var js, fjs = d.getElementsByTagName(s)[0], load = function(url, id) {
  if (d.getElementById(id)) {return;}
    js = d.createElement(s); js.src = url; js.id = id;
   fjs.parentNode.insertBefore(js, fjs);
  };
  load('//connect.facebook.net/ru_RU/all.js#xfbml=1&appId=121771584602003', 'fbjssdk');
  load('//platform.twitter.com/widgets.js', 'tweetjs');
  load('//assets.pinterest.com/js/pinit.js', 'pinitjs');
 }
 if (w.addEventListener) { w.addEventListener("load", go, false); }

  else if (w.attachEvent) { w.attachEvent("onload",go); }

 }(window, document, 'script'));


</script>
<center><?
 if ($galname)
    {
?><span class="title"></span>
<span class="subtitle1"><?
if ($galname != $ename)
{
?><?
}
 if (strpos($ename, date("Y",$galdate)) === false and strpos($galname, date("Y",$galdate)) === false)
  {
 if ($galname != $ename) print ", ";
 ?>1970 г.<?
 }
 ?></span><?
 }
 else
 {
 ?><span class="title"></span></a>
 <span class="subtitle1"><?
 if (strpos($ename, date("Y",$galdate)) === false)
  {
 ?>1970 г.<?
 }
 ?></span><?
 }
?><br>
</center>
<div align=left style="float:left; height:27px; margin-top:-15px; margin-bottom:-10px;"><form style="vspace:0px; padding: 0px; margin-top:0px; margin:0px; line-height:27px" method="post" name="galsize" id="galsize" action="?gid=118&year=2007"><p style="vertical-align:bottom; margin:0px; padding:0px;" valign="bottom">Фотографий на странице: <select onchange="document.forms['galsize'].submit()" name="galsize"><?
foreach ($perpages as $anum => $value)
        {
?><option value=""<?
if ($value == $galsize)
{
?> selected<?
}
?>></option><?
}
?></select> рядов по <select onchange="document.forms['galsize'].submit()" name="perrow"><?
for ($i=4;$i<9;$i++)
        {
?><option value=""<?
if ($i == $perrow)
{
?> selected<?
}
?>></option><?
}
?></select> фото</p></form></div><div align=right style="height:27px; margin-top:-15px; margin-bottom:-10px;"><p style="vertical-align:bottom; margin:0px; padding:0px; line-height:27px" valign="bottom">От <?
if ($owner != 0)
   {
@mysql_select_db("coronel_main");
$queryy="select id, login, name, lastname from salseros where id=".$owner;
		   $resulty = mysql_query($queryy) or die ($queryy.mysql_error());
		   $rowy = @mysql_fetch_array($resulty);
?><a href="/~"></a><?		   
@mysql_select_db("coronel_photo");
}
else
    {
    ?>coronel.ru<?
    }
?> | <a href="/photo/?year=&type=<?
if ($_GET["place"])
     {
     print "&place=".$_GET["place"];
     }
  ?>">Главная страница раздела "Фото"</a></p></div><br>
<? include("top.php");?> 
<table cellspacing=5 cellpadding=5 border=0 align=center>
<tr>
<?
//Legacy code???
if	($gid=="")
{
$query = "select * from ph_list where server_id='$s' and dirname='$dir'";
}
//Legacy ends???
else
{
$query = "select * from ph_list where id='$gid'";
}
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$end = $start+$perpage;
$sstart=$start+1;
$colcount=0;
	$query2 = "select * from ph_".$row["id"]." order by id limit $start,$perpage";
	$result2 = @mysql_query($query2);
	while ($row2 = @mysql_fetch_array($result2))
 	{
 	//while ($start < $end) {
	if ($colcount == $perrow)
		{
		$colcount=0;
		?>
		</tr>
		<tr>
		<?
		}
	$colcount++;
	$start++;
	$fnam=$row2["fname"];
	/*if ($start<10){$fnam = "00".$start;}
	else if ($start<100)
		{
		$fnam = "0".$start;
		}
	else {$fnam = $start;}*/
	$file = @fopen ($lpath . strval($fnam)."tn.jpg", "r");
	if ($file)
		{
		
	$descr = $row2["name"];
	//$descr = str_replace( "&quot;", "\"", $descr );
	//$descr = str_replace( "\"", "\\\"", $descr );
	$descr = str_replace( "\"", "&quot;", $descr);
	$descr = str_replace( "\n", " ", $descr );
	$descr = str_replace( "\r", "", $descr );
	$phurl="view.php?gid=".$row["id"]."&pid=".$row2["id"]."&type=".$_GET["type"]."&year=".$year . $PhototypesQueryAdd;
if ($_GET["place"])
     {
     $phurl .= "&place=".$_GET["place"];
     }
 $size_img = getimagesize($lurl . strval($fnam)."tn.jpg"); 
 	?>	
	<td align=center valign=middle><a href=""><img width="" height="" border=0 src="tn.jpg" alt="" title="" /></a><?
	//Show number of comments
  $query3="select count(*) as num from comments where gid='".$row["id"]."' and pid='".$row2["id"]."' and deleted != 1";
$result3 = mysql_query($query3);
$row3 = mysql_fetch_array($result3);
if ($row3["num"] > 0)
   {
   ?><br><a href="&showcomments=1#comments">Комментарии ()</a><?
   }
  ?></td>
	<?
		}
	else
		{
		?>
		<td></td>
		<?
		}
	}
	
?>
</tr>
</table>
<? include("bot.php"); ?><br><br>
<style>
#fbpdl
 {
 z-index:505;
 }
#subwindow div.content { 
z-index: 0;
}
</style>
<center><div valign="bottom"><div style="display:inline;" class="fb-like" data-send="false" data-layout="button_count" data-width="30" data-show-faces="false" data-href="http://coronel.ru/photo/gals.php?gid=118&year=2007"></div>&nbsp;&nbsp;
   <a class="twitter-share-button" data-count="horizontal" data-url="coronel.ru/photo/gals.php?gid=118&year=2007"></a>&nbsp;&nbsp;
<?
$post = '<a href="http://www.coronel.ru/photo/view.php?gid='.$gid.'&pid='.$pid.'"><img align="center" border="0" src="http://www.coronel.ru/photo/pics/photos'.$s.'gal'.$gid.'photo'.$pid.'s';
if ($_SESSION["photoexif"])
   {
   $post .='exif';
   }
  $post .= iconv('cp1251','utf-8','.jpg" alt="'.$descr1.'" title="'.$descr1.'" /></a><br />Ещё? На <a href="http://www.coronel.ru/photo/">coronel.ru</a>.'); ?>
<a title="Add to my LJ" href="http://www.livejournal.com/update.bml?event=&amp;subject="><img border="0" style="margin-left:-25px" src="http://s3.amazonaws.com/static.blogfuse.com/images/lj.gif"/></a>&nbsp;&nbsp;&nbsp;

  <!-- Pinterest -->

 <a href="http://pinterest.com/pin/create/button/?url=coronel.ru/photo/gals.php?gid=118&year=2007&media=<? ?>&description=" onclick="javascript:_gaq.push(['_trackEvent','outbound-article','http://pinterest.com']);" class="pin-it-button" count-layout="horizontal"><img border="0" src="http://assets.pinterest.com/images/PinExt.png" style="margin-left:-55px; margin-top:-25px;" title="Pin It" /></a></div></center>
<?
//Linked gals.
$addcount=0;
$queries = array();
$usedgals = array();
$ldecrs = array();
$ldecrsnum = array();
$galcontrol = array();
$tags = split (",", $row["tags"]);

if (count($tags) > 4)
   {
   shuffle($tags);
   }
foreach ($tags as $value)
    {
    $value=trim($value);
    if ($value != "" and $addcount < 4)
      {
      $resulta = @mysql_query("select id from ph_list where lower(tags) REGEXP lower('(,|^)( *)".$value."( *)(,|$)') and cat != 'x' limit 0,1"); //Let's do a little check...
      $rowa = @mysql_fetch_array($resulta);
      if ($rowa["id"] and !in_array($rowa["id"],$galcontrol))
        {
        $galcontrol[$addcount]= $rowa["id"];
    $queryes[$addcount] = "select id from ph_list where lower(tags) REGEXP lower('(,|^)( *)".$value."( *)(,|$)') and cat != 'x'";
    print "<!--".$queryes[$addcount]."-->";
    $ldecrs[$addcount] = $value;
    $addcount++;
        }
      }
    }
if ($addcount < 4) // if we still short on gals...
   {
  
   $ourtypes = array();
   $phototypes=mysql_query($queryPh); //No way to ignore...
   $i=0;
   while ($ptypes=mysql_fetch_array($phototypes))
         {
         if (strpos($row["cat"],$ptypes["def"]) !== false and $ptypes["def"] != "x")
            {
            $ourtypes[$i][$ptypes["def"]]=$ptypes["name"];
            $i++;
            }
         }
   if (count($ourtypes) > 4-$addcount)
      {
      shuffle($ourtypes);
      }
   foreach ($ourtypes as $valu)
    {
     foreach ($valu as $num => $value)
      {
    $resulta = @mysql_query("select id from ph_list where cat like '%".$num."%' limit 0,1"); //Let's do a little check...
      $rowa = @mysql_fetch_array($resulta);
      if ($rowa["id"])
        {
    $queryes[$addcount] = "select id from ph_list where cat like '%".$num."%'";
    $ldecrs[$addcount] = $value;
    $addcount++;
        }
      }
    }
   }
//Now to galchoosing...
$NoMoreRows=0;
$addgal=0;
$addgals=array();
if ($queryes)
{
while ($addgal < 4 and $NoMoreRows < 2)
{
foreach ($queryes as $num => $value)
    {
    unset ($mysqlrows);
    $mysqlrows = array();
    $i=0;
    $resulta = @mysql_query($value);
    while ($rowa = @mysql_fetch_array($resulta))
          {
          if (!in_array($rowa["id"], $addgals) and $rowa["id"] != $gid) //aren't we using this already?
             {
          $mysqlrows[$i] = $rowa["id"];
          $i++;
             }
          }
    if (count($mysqlrows)>0 and $addgal < 4)
       {
       $NoMoreRows=0;
       $adding=rand(0,count($mysqlrows)-1);
    $addgals[$addgal] = $mysqlrows[$adding];
    $addgal++;
    $ldecrsnum[$mysqlrows[$adding]] = $ldecrs[$num];
       }
    else
       {
       $NoMoreRows++;
       }
    }
}
//And to displaying
?><center><table cellspacing="0" cellpadding="0" border="0" align="center" valign="middle"><tr valign="middle"><?
shuffle ($addgals); //Just once more...
foreach ($addgals as $gal)
    {
    ?>
    
    <?
    $query2="select * from ph_list where id=$gal";
$result2=mysql_query($query2);
$row2=@mysql_fetch_array($result2);
   $rgid=$row2["id"];
   $s=$row2["server_id"];
   $dir=$row2["dirname"];
   $glurl = $s."/".$dir."/";
   $queryx="select max(id) from ph_$rgid";
$resultx=mysql_query($queryx);
$rowx=@mysql_fetch_row($resultx);
$pmid=$rowx[0];
while (!$pend)
      {
      
   $rpid=rand(1,$pmid);
   $rpid=round($rpid);
   $queryy="select * from ph_".$rgid." where id=".$rpid;
		   $resulty = mysql_query($queryy);
		   $rowy = @mysql_fetch_array($resulty);
		   if ($rowy["id"])
       {
       $pend=1;
   $filename=$rowy["fname"];
	$gal_year=date('Y',$row2["date"]);
		 $size_img = @getimagesize($glurl . strval($filename)."tn.jpg");
	?>
	<td align="center" width="25%"><div id="subcontainerw" style="margin:4px; padding-left:5px;padding-right:5px; max-width:<?
  if ($size_img[0]+20 > 160) print $size_img[0]+20;  else print "160";
  ?>px;">
  <!--SUBWINDOW-->
<div id="subwindow">
<div class="header" width=100%>Смотрите также:<br></div>
<div class="body"><div class="content" style="text-align:center;">
  <a href="?gid=118&pid=&year=&type=<?
  if ($_GET["place"])
     {
     print "&place=".$_GET["place"];
     }
  ?>"> год</a>.<br><?
  if ($row2["name"])
  {
  $namex = str_replace( "\n", "<br />", $row2["name"] );
  }
  else
  {
  $namex = str_replace( "\n", "<br />", $row2["ext_name"] );
  }
	$namex = str_replace( "\r", "", $namex );
	$namex = str_replace( "\"", "&quot;", $namex );
 
  ?><a href="//gals.php?gid=&type=&year=<?
  if ($_GET["place"])
     {
     print "&place=".$_GET["place"];
     }
  ?>""><img width="" height="" align="center" src="///tn.jpg" alt="" title="" border=0 /></a><br>
<?
  if ($row2["name"])
  {
  $namey = str_replace( "\n", "<br>", $row2["name"] );
  }
  else
  {
  $namey = str_replace( "\n", "<br>", $row2["ext_name"] );
  }
	$namey = str_replace( "\r", "", $namey );
?><a href="//gals.php?gid=&type=&year=<?
  if ($_GET["place"])
     {
     print "&place=".$_GET["place"];
     }
  ?>"></a><br>От <?
if ($row2["owner_id"] != '0')
   {
@mysql_select_db("coronel_main");
$queryz="select id, login, name, lastname from salseros where id=".$row2["owner_id"];
		   $resultz = mysql_query($queryz);
		   $rowz = @mysql_fetch_array($resultz);
?><a href="/~"></a><?		   
@mysql_select_db("coronel_photo");
}

else
    {
    ?>coronel.ru<?
    }
?><?
             
             
      }
   }
unset ($pend);
//print_r($addgals);
?></div></div></div>
<!--END SUBWINDOW-->

</div></td><?

    }
}
?></table></center>
<?
$getTime= explode(' ', microtime());
print "<!--SET: ".(($getTime[1] + $getTime[0])-$StartTime )."-->";
include($html_dir."/footer.php"); ?>