include 'inc/config.inc.php'; if (isset($_GET['p'])): $page = $_GET['p']; else: $page = 1; endif; if (isset($_GET['cat'])) $cat = mysql_real_escape_string($_GET['cat']); else $cat = 0; $per_page = 24; $sql = " SELECT SQL_CALC_FOUND_ROWS contentgroup . * , contentgroup.AppearDate AS DTE, contentgroup.PointsRank AS plg_ratings_rank, contentgroup.PointsTot AS plg_ratings_total, contentgroupthumbs.Id as imageId, sc.siteid FROM contentgroup JOIN contentgroupthumbs ON contentgroup.Id = contentgroupthumbs.contentgroup AND contentgroupthumbs.priority = 101 LEFT JOIN sites_contentgroup sc ON sc.contentgroup=contentgroup.Id LEFT JOIN sites as ss ON sc.siteid = ss.Id WHERE ( contentgroup.AppearDate <= '" . date('Y-m-d') . "' AND contentgroup.Id IN ( SELECT contentgroup FROM sites_contentgroup WHERE siteid!='16' and siteid!='9' ) "; # AND siteid # IN ( ".$site_id." ) if($cat > 0) $sql .= " AND contentgroup.Id IN ( select contentgroup from category_contentgroup WHERE websiteid=17 AND category = '$cat') "; $sql .= " ) GROUP BY contentgroup.Id, contentgroup.Id ORDER BY DTE DESC LIMIT " . (($page - 1) * $per_page) . ', ' . $per_page . " "; $updates = $mc->get($memcache_key.md5($sql)); $updates_all = $mc->get($memcache_key."_all".md5($sql)); if(empty($updates) or empty($updates_all)){ $updates = array(); $res = mysql_query($sql) or die(mysql_error()); while ($row = mysql_fetch_assoc($res)) { list($row['photos'], $row['movie_length']) = get_photo_movie_info($row['PreviewXML_PHP']); $updates[] = $row; } $mc->set($memcache_key.md5($sql), $updates, MEMCACHE_COMPRESSED, 3600*24); $sql1 = $sql; $sql = 'SELECT FOUND_ROWS()'; $maxrows = mysql_fetch_row(mysql_query($sql)); $updates_all = $maxrows[0]; $mc->set($memcache_key."_all".md5($sql1), $updates_all, MEMCACHE_COMPRESSED, 3600*24); } $paging_line = cool_paging('tour.php?cat='.$cat.'&p=', $page, $per_page, $updates_all); ?>