query($sql);
$num_rows = $DB_site->num_rows($data_arr);
$DB_site->free_result($data_arr);
$sql1 = ($cfg['lang_special'])? " SELECT * FROM ". TBL_SUB_CAT ." WHERE cat_id='$cat_id' ORDER BY sub_cat_id" : " SELECT * FROM ". TBL_SUB_CAT ." WHERE cat_id='$cat_id' ORDER BY sub_cat_name";
$data_arr1 = $DB_site->query($sql1);
$num_rows1 = $DB_site->num_rows($data_arr1);
if ($num_rows1 != 0) {
while ($row_sub_cat = $DB_site->fetch_array($data_arr1)) {
$option_sub_cat[$row_sub_cat['sub_cat_id']] = $row_sub_cat['sub_cat_name'];
}
$FORM_SELECT_SUB_CAT = "";
}
if( $num_rows<=$cfg['browse_per_page'] ) {
$num_pages = 1;
}
elseif( ($num_rows % $cfg['browse_per_page']) == 0 ) {
$num_pages = ($num_rows / $cfg['browse_per_page']);
}
else {
$num_pages = ($num_rows / $cfg['browse_per_page']) + 1;
}
$num_pages = (int) $num_pages;
//$page_sector = (((int) ($page / 10)) * 10);
$page_sector_start = ($page < 10) ? 1 : $page - 9;
$page_sector_end = ($page > $num_pages - 9) ? $num_pages : $page + 9;
if( ($page > $num_pages) || ($page < 0) ) {
message_die(GENERAL_ERROR, $msg['error_invalide_page']);
}
$sql = $sql . " LIMIT $page_start,". $cfg['browse_per_page'];
$data_arr = $DB_site->query($sql);
if($num_rows==0)
{
message_die(GENERAL_ERROR,$msg['error_no_cards']);
}
else {
$t->set_file(array('body' => 'browse.html'));
text_on_image_cat();
card_cat();
top_list($cfg['toplist_entries_browse'],3,$cat_id);
$i = 0;
$t->set_block('body','table_row','table_rows');
$t->set_block('table_row', 'card','cards');
$j = null;
while ($row = $DB_site->fetch_array($data_arr)) {
$sql_count = "SELECT COUNT(*) AS count FROM ". TBL_STATS ." WHERE card_id='". $row['card_id'] ."' GROUP BY card_id ORDER BY count DESC";
$data_arr_count = $DB_site->query($sql_count);
$row_count = $DB_site->fetch_array($data_arr_count);
$count_card = !isset($row_count['count']) ? 0 : $row_count['count'];
$_f = !empty($row['card_image'])? 'f='. $row['card_image'] : '';
$_and = ( !empty($row['card_template']) && !empty($row['card_image']) )? '&' : '';
$_t = !empty($row['card_template'])? 'template='.$row['card_template'] : '';
$_link = $_f . $_and . $_t;
$_img = empty($row['card_thm'])? $row['card_image'] : $row['card_thm'];
$resize = resize($cfg['path_images'].$_img, $cfg['thm_size']);
// $_img = eregi(".jpg", $_img)? '
' : '
';
$_img = '
';
$attribute = get_file_w_h($row['card_image']);
$t->set_var(array(
'CARD_WIDTH' => $attribute['width'],
'CARD_HEIGHT' => $attribute['height'],
'U_COMPOSE_CARD' => $cfg['url_site'].'create.php?' . $_link,
'U_CARD_THUMB' => $cfg['url_images']. $row['card_thm'],
'HTML_THUMBNAIL' => $_img,
'CARD_ID' => $row['card_id'],
'ICON_NEW' => gethml_newbutton($row['card_date']),
'COUNT' => $count_card,
'CARD_CAPTION' => safe_text(nl2br($row['card_caption'])),
'THM_SIZE' => $cfg['thm_size']
));
$t->parse('cards', 'card', true);
$i++;
if($i >= $cfg['browse_columns']) {
$t->parse('table_rows', 'table_row',true);
$t->set_var('cards','');
$i = 0;
}
$j++;
if($j >= $cfg['browse_per_page']) {
break;
}
}
$row = array();
$t->set_var(array(
'U_COMPOSE_CARD' => '#',
'U_CARD_THUMB' => '',
'HTML_THUMBNAIL' => '
',
'CARD_ID' => '',
'ICON_NEW' => ''
));
if(($i > 0) && ($i != $cfg['browse_columns'])) {
$t->set_block('body','table_none_card','table_none_cards');
$t->set_block('table_none_card', 'card','cards');
while(($i > 0) && ($i != $cfg['browse_columns'])) {
$t->parse('cards', 'card', true);
$i++;
}
$t->parse('table_none_cards', 'table_none_card',true);
}
else{
$t->set_block('body', 'table_none_card','section');
$t->set_var('section','');
$t->parse('table_none_card','section');
}
$t->set_var('cards','');
$t->parse('out','body');
}
// NAV BAR LINKS
/////////////////////////////////////////////////////////////////
// Previous Link
$_navbar_1 = null;
if ($page > 10) {
$_navbar_1 = "1 ...\n";
}
$_navbar_2 = null;
for ($i = $page_sector_start; $i <= $page_sector_end; $i++) {
$_navbar_2 .= ($i != $page)? " $i\n" : " [ $i ]\n";
}
// Next Link
$_navbar_3 = null;
if ($page < $num_pages - 9) {
$_navbar_3 = " ... ".$num_pages."\n";
}
$sql = "SELECT * FROM ". TBL_CAT ." WHERE cat_id='". $cat_id ."' ";
$cat_info = $DB_site->query_first($sql);
$sql = "SELECT * FROM ". TBL_SUB_CAT ." WHERE sub_cat_id='". $sub_cat_id ."' ";
$sub_cat_info = $DB_site->query_first($sql);
$t->set_var(array(
'NUM_CARD' => $num_rows,
'CAT_NAME' => stripslashes($cat_info['cat_name']),
'NAV_BAR' => $_navbar_1 . $_navbar_2 . $_navbar_3,
'FORM_SELECT_SUB_CAT' => $FORM_SELECT_SUB_CAT,
// 'SUB_CAT_NAME' => stripslashes($sub_cat_info['sub_cat_name'])
));
include(ROOT_DIR . 'include/page_header.php');
$t->parse("output", 'body');
$t->p("output");
include(ROOT_DIR . 'include/page_footer.php');