set_filenames(array("body" => "free_photos.html")); }else $template->set_filenames(array("body" => "cindex.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"] != "") { $where .= " and `photo_title` like '%".$_REQUEST["textfield"]."%'"; } 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>0) { $minp = ($page>=$pagerange)?$page-$pagerange:0; $maxp = $maxpage>$minp+$pagerange*2?$minp+$pagerange*2:$maxpage; if ($minp>0) $page_list = "« Previous - "; $page_list .= "Page "; for ($i=$minp; $i<=$maxp; $i++) { $j = $i+1; $page_list .= ($i==$page)?"$j ":"".$j." "; } if ($maxpage>$maxp) { $maxp ++; $page_list .= "- Next » "; } } $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); $cpage_size = 0; if (mysql_num_rows($result)>0) { $w = $clsSite_config->sample_size; /* for ($i = 0; $i < $rowcount-1; $i++) { $template->assign_block_vars('some_row', array()); for ($j = 0; $j < $colcount; $j++) { $template->assign_block_vars('some_row.some_col', array( 'DATA' => $yourarray[$i][$j]) ); } } */ $stt = $clsSite_config->col_size; while ($row = mysql_fetch_array($result)) { 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"]); $cpage_size ++; $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" : "Add to your cart", "FREE_PHOTO" => $row["is_free"]>=time()?"Free image":"" )); } }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"); ?>