62
« on: December 19, 2008, 09:53:26 AM »
Hello,
I have an additional page with all the images of my gallery from all the categories. I call it: ImagesList.
I already have the imageslist_sort_dropdown_form and it working very fine.
But I have a problem with: {paging} and {paging_stats}. It doesn't work at all.
Because I am not a programmer, I tried to see how the paging on the category page works. This is my code:
<?php
$main_template = 'videolist';
define('GET_CACHES', 1);
define('ROOT_PATH', './');
include(ROOT_PATH.'global.php');
require(ROOT_PATH.'includes/sessions.php');
include(ROOT_PATH.'includes/page_header.php');
include(ROOT_PATH.'includes/stats.php');
//-----------------------------------------VideoList--------------------------------------------------------------------
$additional_sql = "";
$additional_sql_array = array();
if (isset($additional_user_fields) && is_array($additional_user_fields) && !empty($additional_user_fields)) {
foreach ($additional_user_fields as $key => $val) {
$additional_sql = ", u." . $key;
$additional_sql_array[] = $key;
}
}
$additional_sql = "";
if (!empty($additional_image_fields)) {
foreach ($additional_image_fields as $key => $val) {
$additional_sql .= ", i.".$key;
}
}
//+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
$order_by = "image_hits $sort_order";
$sql = "SELECT COUNT(image_id) AS images
FROM (".IMAGES_TABLE." i, ".CATEGORIES_TABLE." c)
WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND i.cat_id IN (".get_auth_cat_sql("auth_viewimage").")
";
$result = $site_db->query_firstrow($sql);
$num_images = $result['images'];
$site_db->free_result();
$num_rows_all = (isset($num_images)) ? $num_images : 0;
$link_arg = $site_sess->url(ROOT_PATH."videolist.php?action=hits");
include_once(ROOT_PATH.'includes/paging.php');
if ($num_images >= $max_picture) {
$num_images = $max_picture;
}
else {
$num_images == $result['images'];
}
$getpaging = new Paging($page, $picture_per_page, $num_images, $link_arg);
$offset = $getpaging->get_offset();
$site_template->register_vars(array(
"paging" => $getpaging->get_paging(),
"paging_stats" => $getpaging->get_paging_stats()
));
//+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
$sql = "SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_speler, i.image_youtube, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits, i.image_postcards".$additional_sql.", c.cat_name".get_user_table_field(", u.", "user_name").get_user_table_field(", u.", "user_email")."
FROM (".IMAGES_TABLE." i, ".CATEGORIES_TABLE." c)
LEFT JOIN ".USERS_TABLE." u ON (".get_user_table_field("u.", "user_id")." = i.user_id)
WHERE i.image_active = 1 AND i.cat_id IN (".get_auth_cat_sql("auth_viewcat").")
GROUP BY i.image_id
ORDER BY ".$config['image_order']." ".$config['image_sort'].", image_id ".$config['image_sort']."
LIMIT $offset, $perpage";
$result = $site_db->query($sql);
$num_rows = $site_db->get_numrows($result);
if (!$num_rows) {
$videolist = "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"4\"><tr><td>".$lang['geen_events']."</td></tr>";
}
else {
$videolist = "<table class=\"head2\" width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"4\">
<tr>
<td></td>
<td><b>Thumb</b></td>
<td><b>Naam</b></td>
<td><b>Speler</b></td>
<td><b>Categorie</b></td>
<td><b>Duur</b></td>
<td><b>Bekeken</b></td>
</tr>
";
$i = 01;
while ($image_row = $site_db->fetch_array($result)){
$videolist .= "<tr>
<td>".$i++."</td>
<td><a href=\"".$site_sess->url(ROOT_PATH."details.php?".URL_IMAGE_ID."=".$image_row['image_id'])."\"><img src=\"data/thumbnails/".$image_row['cat_id']."/".$image_row['image_thumb_file']."\" width=\"48\" height=\"32\" border=\"0\"/></td>
<td><a href=\"".$site_sess->url(ROOT_PATH."details.php?image_id=".$image_row['image_id'])."\">".$image_row['image_name']."</a></td>
<td>".$image_row['image_speler']."</a></td>
<td><a href=\"".$site_sess->url(ROOT_PATH."categories.php?".URL_CAT_ID."=".$image_row['cat_id'])."\">".format_text($cat_cache[$image_row['cat_id']]['cat_name'])."</a></td>
<td><b>".$image_row['image_duration']."</b></td>
<td>".$image_row['image_hits']."</td>
</td></tr>
";
}
}
$videolist .= "</table>\n";
$site_template->register_vars("videolist", $videolist);
unset($videolist);
//----------------------------------------------------------------------------
//-----------------------------------------------------
//--- Clickstream -------------------------------------
//-----------------------------------------------------
$clickstream = "<span class=\"clickstream\"><a href=\"".$site_sess->url(ROOT_PATH."index.php")."\" class=\"clickstream\">".$lang['home']."</a>".$config['category_separator']."Videolist pagina"."</span>";
//-----------------------------------------------------
//--- Print Out ---------------------------------------
//-----------------------------------------------------
$site_template->register_vars(array(
"clickstream" => $clickstream,
"user_name" => $user_row[$user_table_fields['user_id']],
"lang_title_videolist_images" => $lang['title_videolist_images'],
"cat_name" => format_text($cat_cache[$cat_id]['cat_name'], 2),
));
$site_template->print_template($site_template->parse_template($main_template));
include(ROOT_PATH.'includes/page_footer.php');
?>
Could anyone help me please? I really gave it a try for more that 6 hours.
I appreciate any help,