set_filenames(array("body" => "free_photos.html"));
include_once ("class/photos.class.php");
$photos = new Photos();
//Phan trang
$sortcriteria = isset($_REQUEST["sortcriteria"])?$_REQUEST["sortcriteria"]:1;
$category_name = "Category";
$where = "WHERE `approved` = 1 ";
$where .= (isset($_REQUEST["mod"]) && $_REQUEST["mod"]=="free")?" and `is_free`>=".time():"";//" and `is_free`<".time();
if (isset($_REQUEST["resolu"]) && $_REQUEST["resolu"] != "")
{
$where .= " and `resolution` = '".$_REQUEST["resolu"]."'";
}
if (isset($_REQUEST["cat_sid"]) && $_REQUEST["cat_sid"] != "")
{
$category_name = $cats->GetCatFullName($_REQUEST["cat_sid"]);
$result = $cats->GetChildCat($_REQUEST["cat_sid"]);
$list = "'".$_REQUEST["cat_sid"]."'";
while ($row = mysql_fetch_array($result))
{
$list .= ", '".$row["cat_sid"]."'";
}
$where .= " and `category` in (".$list.")";
}
if (isset($_REQUEST["textfield"]) && $_REQUEST["textfield"] != "ENTER KEYWORD" && $_REQUEST["textfield"] != "")
{
$search_w = "";
if ($_REQUEST["options"] == 1 || $_REQUEST["options"] == "")
{
$search_w .= " and (`photo_title` like '%".$_REQUEST["textfield"]."%'";
}
if ($_REQUEST["options"] == 2 || $_REQUEST["options"] == "")
{
$search_w .= ($search_w=="")?" and ( ":" or ";
$search_w .= " `photo_tag` like '%".$_REQUEST["textfield"]."%'";
}
//category
if ($_REQUEST["options"] == 3 || $_REQUEST["options"] == "")
{
$result = $cats->GetCatSIDWhere(" WHERE `cat_name` like '%".$_REQUEST["textfield"]."%'");
$list = "";
while ($row = mysql_fetch_array($result))
{
$list .= ($list=="")?"":", ";
$list .= "'".$row["cat_sid"]."'";
}
if ($list != "")
{
$search_w .= ($search_w=="")?" and ( ":" or ";
$search_w .= " `category` in (".$list.")";
}
}
$search_w .= ($search_w=="")?"":")";
}
$where .= $search_w;
if (isset($_REQUEST["searchtag"]) && $_REQUEST["searchtag"] != "")
{
$where .= " and `photo_tag` like '%".$_REQUEST["searchtag"]."%'";
}
$n = $photos->GetTotalPhotosWhere($where);
$maxpage = floor($n/$pagesize) == ceil($n/$pagesize)?floor($n/$pagesize)-1:floor($n/$pagesize);
if ($maxpage>1)
{
$minp = ($page>=$pagerange)?$page-$pagerange:0;
$maxp = $maxpage>$minp+$pagerange*2?$minp+$pagerange*2:$maxpage;
if ($minp>0)
$page_list = "« ";
for ($i=$minp; $i<=$maxp; $i++)
{
$j = $i+1;
$page_list .= ($i==$page)?"$j ":"".$j." ";
}
if ($maxpage>$maxp)
{
$maxp ++;
$page_list .= "» ";
}
}
$page = isset($_REQUEST["page"])?$_REQUEST["page"]:0;
switch ($sortcriteria)
{
case 1:
$orderby = "`download` DESC";
break;
case 2:
$orderby = "`download` ASC";
break;
case 3:
$orderby = "`view` DESC";
break;
case 4:
$orderby = "`view` ASC";
break;
case 5:
$orderby = "`photo_id` DESC";
break;
case 6:
$orderby = "`photo_id` ASC";
break;
case 7:
$orderby = "`photo_title` DESC";
break;
case 8:
$orderby = "`photo_title` ASC";
break;
case 9:
$orderby = "`resolution` DESC";
break;
case 10:
$orderby = "`resolution` ASC";
break;
}
$result = $photos->GetPhotosLimitWhere($page*$pagesize, $pagesize, $where, $orderby);
$w = $clsSite_config->sample_size;
$cpage_size = 0;
if (mysql_num_rows($result)>0)
{
$stt = $clsSite_config->col_size;
while ($row = mysql_fetch_array($result))
{
$cpage_size ++;
if ($stt<$clsSite_config->col_size)
{
$stt++;
}else
{
$stt = 1;
$template->assign_block_vars('row', array());
}
$fullname = $cats->GetCatName($row["category"]);
$username = $photos->GetPosterName($row["photo_designer"]);
$h = (double) $w*($row['photo_height']/$row['photo_width']);
$template->assign_block_vars("row.col",array(
"PHOTO_SID" => $row["photo_sid"],
"PHOTO_TITLE" => $row["photo_title"],
"PHOTO_THUMB" => $row["photo_thumb"],
"PHOTO_DESIGNER" => $row["photo_designer"],
"RESOLUTION" => $row["resolution"],
'PHOTO_SIZE' => $row['photo_size']/1000000,
'PHOTO_PWIDTH' => $w,
'PHOTO_PHEIGHT' => $h,
'PHOTO_WIDTH' => $row['photo_width'],
'PHOTO_HEIGHT' => $row['photo_height'],
'PHOTO_DESIGNER' => $row['photo_designer'],
"PHOTO_PRICE" => $photo_level['price'],
"PHOTO_LEVEL" => $photo_level["level_name"],
'PHOTO_POST_DATE' => $row['photo_post_date'],
'FULLNAME' => $fullname,
'CATEGORY' => $row['category'],
'USERNAME' => $username,
"SITENAME" => $clsSite_config->site_title,
'PHOTO_PREVIEW'=> $row['photo_preview'],
"VIEW" => $row["view"],
"DOWNLOAD" => $row["download"],
"ACTION_URL" => $row['photo_designer']== $_SESSION["suserid"]?"![Edit photo information](".$template_dir."/images/edit.png)
" : "![Add to your cart](".$template_dir."/images/cart.png)
",
"FREE_PHOTO" => $row["is_free"]>=time()?"![Free image](".$template_dir."/images/free.gif)
":""
));
}
}else
$page_list = "No images found.
";
$static = mysql_fetch_array($photos->StaticByUser($_SESSION["suserid"]));
$last_upload = mysql_fetch_array($photos->GetInfoByID($static["lastest_upload"]));
$template->assign_vars(array(
"PAGE_LIST" => $page_list,
"TOTAL_PHOTOS" => $cpage_size>0?$cpage_size." of ".$n." photos":"",
"CATEGORY_NAME" => $_REQUEST["mod"]=="free"?$category_name.": free listing":$category_name,
"MOD" => $_REQUEST["mod"],
"CAT_SID" => $_REQUEST["cat_sid"],
"TEXTFIELD" => $_REQUEST["textfield"],
"SEARCHTAG" => $_REQUEST["searchtag"],
"RESOLU1" => $_REQUEST["resolu"]=="Web resolution"?" selected='selected'":"",
"RESOLU2" => $_REQUEST["resolu"]=="Print resolution"?" selected='selected'":"",
"RESOLU3" => $_REQUEST["resolu"]=="Additional format (vector, RAW etc. - if available"?" selected='selected'":"",
"SORTCRITERIA1" => $sortcriteria==1?" selected='selected'":"",
"SORTCRITERIA2" => $sortcriteria==2?" selected='selected'":"",
"SORTCRITERIA3" => $sortcriteria==3?" selected='selected'":"",
"SORTCRITERIA4" => $sortcriteria==4?" selected='selected'":"",
"SORTCRITERIA5" => $sortcriteria==5?" selected='selected'":"",
"SORTCRITERIA6" => $sortcriteria==6?" selected='selected'":"",
"SORTCRITERIA7" => $sortcriteria==7?" selected='selected'":"",
"SORTCRITERIA8" => $sortcriteria==8?" selected='selected'":"",
"SORTCRITERIA9" => $sortcriteria==9?" selected='selected'":"",
"SORTCRITERIA10" => $sortcriteria==10?" selected='selected'":"",
));
$template->pparse("body");
include("footer.php");
?>