You're looking for some 4images templates and styles? Then visit this thread to show websites with 4images templates to download.
0 Members and 1 Guest are viewing this topic.
<?php$cat_match_sql = ($cat_id && check_permission("auth_viewcat", $cat_id)) ? "AND i.cat_id = '$cat_id' " : ""; $register_array = array(); $cat_id_sql = get_auth_cat_sql("auth_viewcat", "NOTIN"); $lang_top_image_hits = $lang['top_image_hits'];// Hits$sql = "SELECT i.image_id, i.user_id, i.cat_id, i.image_name, i.image_hits, c.cat_name".get_user_table_field(", u.", "user_name")."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 NOT IN ($cat_id_sql) AND i.cat_id = c.cat_id$cat_match_sqlORDER BY i.image_hits DESC, i.image_name ASCLIMIT 10";$result = $site_db->query($sql);$top_list = array();$i = 1;while ($row = $site_db->fetch_array($result)) {$top_list[$i] = $row;$i++;}$site_db->free_result();for ($i = 1; $i <= 10; $i++) {if (isset($top_list[$i])) {$image_hits_[$i] = $register_array['image_hits_'.$i] = (check_permission("auth_viewimage", $top_list[$i]['cat_id'])) ? "<a href=\"".$site_sess->url(ROOT_PATH."details.php?".URL_IMAGE_ID."=".$top_list[$i]['image_id'])."\">".htmlspecialchars($top_list[$i]['image_name'])."</a>" : htmlspecialchars($top_list[$i]['image_name']);$register_array['image_hits_openwindow_'.$i] = (check_permission("auth_viewimage", $top_list[$i]['cat_id'])) ? "<a href=\"".$site_sess->url(ROOT_PATH."details.php?".URL_IMAGE_ID."=".$top_list[$i]['image_id'])."\" onclick=\"opendetailwindow()\" target=\"detailwindow\">".htmlspecialchars($top_list[$i]['image_name'])."</a>" : htmlspecialchars($top_list[$i]['image_name']);if (isset($top_list[$i][$user_table_fields['user_name']]) && $top_list[$i]['user_id'] != GUEST) {$user_profile_link = (!empty($url_show_profile)) ? preg_replace("/{user_id}/", $top_list[$i]['user_id'], $url_show_profile) : ROOT_PATH."member.php?action=showprofile&".URL_USER_ID."=".$top_list[$i]['user_id'];$image_hits_user_[$i] = $register_array['image_hits_user_'.$i] = "<a href=\"".$site_sess->url($user_profile_link)."\">".htmlspecialchars($top_list[$i][$user_table_fields['user_name']])."</a>";}else {$image_hits_user_[$i] = $register_array['image_hits_user_'.$i] = $lang['userlevel_guest'];}$image_hits_cat_[$i] = $register_array['image_hits_cat_'.$i] = "<a href=\"".$site_sess->url(ROOT_PATH."categories.php?".URL_CAT_ID."=".$top_list[$i]['cat_id'])."\">".htmlspecialchars($top_list[$i]['cat_name'])."</a>";$image_hits_number_[$i] = $register_array['image_hits_number_'.$i] = "<b>".$top_list[$i]['image_hits']."</b>";}else {$image_hits_[$i] = $register_array['image_hits_'.$i] = "--";$image_hits_user_[$i] = $register_array['image_hits_user_'.$i] = "--";$image_hits_cat_[$i] = $register_array['image_hits_cat_'.$i] = "--";$image_hits_number_[$i] = $register_array['image_hits_number_'.$i] = "--";}}$top_hits_10 = " <table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"1\"><tr> <td class=\"bordercolor\"> <table width=\"100%\" border=\"0\" cellpadding=\"3\" cellspacing=\"0\"><tr> <td class=\"head1\" valign=\"top\" colspan=\"5\">$lang_top_image_hits</td></tr><tr> <td valign=\"top\" class=\"row1\" align=\"center\"><b>1</b></td><td valign=\"top\" class=\"row1\">$image_hits_[1]</td><td valign=\"top\" class=\"row1\">$image_hits_user_[1]</td><td valign=\"top\" class=\"row1\">$image_hits_cat_[1]</td><td valign=\"top\" class=\"row1\" nowrap>$image_hits_number_[1]</td></tr><tr> <td valign=\"top\" class=\"row2\" align=\"center\"><b>2</b></td><td valign=\"top\" class=\"row2\">$image_hits_[2]</td><td valign=\"top\" class=\"row2\">$image_hits_user_[2]</td><td valign=\"top\" class=\"row2\">$image_hits_cat_[2]</td><td valign=\"top\" class=\"row2\" nowrap>$image_hits_number_[2]</td></tr><tr> <td valign=\"top\" class=\"row1\" align=\"center\"><b>3</b></td><td valign=\"top\" class=\"row1\">$image_hits_[3]</td><td valign=\"top\" class=\"row1\">$image_hits_user_[3]</td><td valign=\"top\" class=\"row1\">$image_hits_cat_[3]</td><td valign=\"top\" class=\"row1\" nowrap>$image_hits_number_[3]</td></tr><tr> <td valign=\"top\" class=\"row2\" align=\"center\"><b>4</b></td><td valign=\"top\" class=\"row2\">$image_hits_[4]</td><td valign=\"top\" class=\"row2\">$image_hits_user_[4]</td><td valign=\"top\" class=\"row2\">$image_hits_cat_[4]</td><td valign=\"top\" class=\"row2\" nowrap>$image_hits_number_[4]</td></tr><tr> <td valign=\"top\" class=\"row1\" align=\"center\"><b>5</b></td><td valign=\"top\" class=\"row1\">$image_hits_[5]</td><td valign=\"top\" class=\"row1\">$image_hits_user_[5]</td><td valign=\"top\" class=\"row1\">$image_hits_cat_[5]</td><td valign=\"top\" class=\"row1\" nowrap>$image_hits_number_[5]</td></tr><tr> <td valign=\"top\" class=\"row2\" align=\"center\"><b>6</b></td><td valign=\"top\" class=\"row2\">$image_hits_[6]</td><td valign=\"top\" class=\"row2\">$image_hits_user_[6]</td><td valign=\"top\" class=\"row2\">$image_hits_cat_[6]</td><td valign=\"top\" class=\"row2\" nowrap>$image_hits_number_[6]</td></tr><tr> <td valign=\"top\" class=\"row1\" align=\"center\"><b>7</b></td><td valign=\"top\" class=\"row1\">$image_hits_[7]</td><td valign=\"top\" class=\"row1\">$image_hits_user_[7]</td><td valign=\"top\" class=\"row1\">$image_hits_cat_[7]</td><td valign=\"top\" class=\"row1\" nowrap>$image_hits_number_[7]</td></tr><tr> <td valign=\"top\" class=\"row2\" align=\"center\"><b>8</b></td><td valign=\"top\" class=\"row2\">$image_hits_[8]</td><td valign=\"top\" class=\"row2\">$image_hits_user_[8]</td><td valign=\"top\" class=\"row2\">$image_hits_cat_[8]</td><td valign=\"top\" class=\"row2\" nowrap>$image_hits_number_[8]</td></tr><tr> <td valign=\"top\" class=\"row1\" align=\"center\"><b>9</b></td><td valign=\"top\" class=\"row1\">$image_hits_[9]</td><td valign=\"top\" class=\"row1\">$image_hits_user_[9]</td><td valign=\"top\" class=\"row1\">$image_hits_cat_[9]</td><td valign=\"top\" class=\"row1\" nowrap>$image_hits_number_[9]</td></tr><tr> <td valign=\"top\" class=\"row2\" align=\"center\"><b>10</b></td><td valign=\"top\" class=\"row2\">$image_hits_[10]</td><td valign=\"top\" class=\"row2\">$image_hits_user_[10]</td><td valign=\"top\" class=\"row2\">$image_hits_cat_[10]</td><td valign=\"top\" class=\"row2\" nowrap>$image_hits_number_[10]</td></tr></table></table>";?>
require(ROOT_PATH.'includes/sessions.php');
include(ROOT_PATH.'tophits10.php');
"clickstream" => $clickstream
"clickstream" => $clickstream,"top_hits_10" => $top_hits_10
<tr> <td class="head1">{new_images}</td> </tr>
<tr> <td class="head1">{top_hits_10}</td> </tr>
ORDER BY i.image_hits DESC, i.image_name ASC
ORDER BY i.cat_id DESC, i.image_name ASC
Saludos,,,No te entiendo,, que quieres decir?si te refieres a ordenar por categorias modifica la siguiente línea :Quote ORDER BY i.image_hits DESC, i.image_name ASCPor esta otra : Quote ORDER BY i.cat_id DESC, i.image_name ASCexcitex2
<?php$cat_match_sql = ($cat_id && check_permission("auth_viewcat", $cat_id)) ? "AND i.cat_id = '$cat_id' " : ""; $register_array = array(); $cat_id_sql = get_auth_cat_sql("auth_viewcat", "NOTIN"); // Rating categorìa 2$sql = "SELECT i.image_id, i.user_id, i.cat_id, i.image_name, i.image_rating, c.cat_name 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 = 2 AND i.cat_id NOT IN ($cat_id_sql) AND i.cat_id = c.cat_id $cat_match_sql ORDER BY i.image_rating DESC, i.image_name ASC LIMIT 10"; $result = $site_db->query($sql); $top_list = array(); $i = 1; while ($row = $site_db->fetch_array($result)) { $top_list[$i] = $row; $nombre_categoria_2 = $row['cat_name'];$i++; } $site_db->free_result(); for ($i = 1; $i <= 10; $i++) { if (isset($top_list[$i])) { $image_rating_[$i] = $register_array['image_rating_'.$i] = (check_permission("auth_viewimage", $top_list[$i]['cat_id'])) ? "<a href=\"".$site_sess->url(ROOT_PATH."details.php?".URL_IMAGE_ID."=".$top_list[$i]['image_id'])."\">".htmlspecialchars($top_list[$i]['image_name'])."</a>" : htmlspecialchars($top_list[$i]['image_name']); } else { $image_rating_[$i] = $register_array['image_rating_'.$i] = "--"; } } // Rating categoría 9$sql = "SELECT i.image_id, i.user_id, i.cat_id, i.image_name, i.image_rating, c.cat_name 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 = 9 AND i.cat_id NOT IN ($cat_id_sql) AND i.cat_id = c.cat_id $cat_match_sql ORDER BY i.image_rating DESC, i.image_name ASC LIMIT 10"; $result = $site_db->query($sql); $top_list = array(); $i = 11; while ($row = $site_db->fetch_array($result)) { $top_list[$i] = $row; $nombre_categoria_9 = $row['cat_name'];$i++; } $site_db->free_result(); for ($i = 11; $i <= 20; $i++) { if (isset($top_list[$i])) { $image_rating_[$i] = $register_array['image_rating_'.$i] = (check_permission("auth_viewimage", $top_list[$i]['cat_id'])) ? "<a href=\"".$site_sess->url(ROOT_PATH."details.php?".URL_IMAGE_ID."=".$top_list[$i]['image_id'])."\">".htmlspecialchars($top_list[$i]['image_name'])."</a>" : htmlspecialchars($top_list[$i]['image_name']); } else { $image_rating_[$i] = $register_array['image_rating_'.$i] = "--"; } } $top_rating_10 = " <table border=\"1\" cellspacing=\"0\" cellpadding=\"1\"><tr> <td class=\"bordercolor\"> <table border=\"0\" cellpadding=\"3\" cellspacing=\"0\"><tr> <td class=\"head1\" valign=\"top\" colspan=\"5\">Top Rated $nombre_categoria_2</td></tr><tr><td valign=\"top\" class=\"row1\">$image_rating_[1]</td></tr><tr><td valign=\"top\" class=\"row2\">$image_rating_[2]</td></tr><tr><td valign=\"top\" class=\"row1\">$image_rating_[3]</td></tr><tr><td valign=\"top\" class=\"row2\">$image_rating_[4]</td></tr><tr><td valign=\"top\" class=\"row1\">$image_rating_[5]</td></tr><tr><td valign=\"top\" class=\"row2\">$image_rating_[6]</td></tr><tr><td valign=\"top\" class=\"row1\">$image_rating_[7]</td></tr><tr><td valign=\"top\" class=\"row2\">$image_rating_[8]</td></tr><tr><td valign=\"top\" class=\"row1\">$image_rating_[9]</td></tr><tr><td valign=\"top\" class=\"row2\">$image_rating_[10]</td></tr></table></table></br><table border=\"1\" cellspacing=\"0\" cellpadding=\"1\"><tr> <td class=\"bordercolor\"> <table border=\"0\" cellpadding=\"3\" cellspacing=\"0\"><tr> <td class=\"head1\" valign=\"top\" colspan=\"5\">Top Rated $nombre_categoria_9</td></tr><tr><td valign=\"top\" class=\"row1\">$image_rating_[11]</td></tr><tr><td valign=\"top\" class=\"row2\">$image_rating_[12]</td></tr><tr><td valign=\"top\" class=\"row1\">$image_rating_[13]</td></tr><tr><td valign=\"top\" class=\"row2\">$image_rating_[14]</td></tr><tr><td valign=\"top\" class=\"row1\">$image_rating_[15]</td></tr><tr><td valign=\"top\" class=\"row2\">$image_rating_[16]</td></tr><tr><td valign=\"top\" class=\"row1\">$image_rating_[17]</td></tr><tr><td valign=\"top\" class=\"row2\">$image_rating_[18]</td></tr><tr><td valign=\"top\" class=\"row1\">$image_rating_[19]</td></tr><tr><td valign=\"top\" class=\"row2\">$image_rating_[20]</td></tr></table></table>";?>
include(ROOT_PATH.'top_rating_10.php');
"clickstream" => $clickstream,"top_hits_10" => $top_rating_10
<tr> <td class="head1">{top_rating_10}</td> </tr>
<?php$cat_match_sql = ($cat_id && check_permission("auth_viewcat", $cat_id)) ? "AND i.cat_id = '$cat_id' " : ""; $register_array = array(); $cat_id_sql = get_auth_cat_sql("auth_viewcat", "NOTIN"); $lang_top_image_hits = $lang['top_image_hits'];// Hits$sql = "SELECT i.image_id, i.user_id, i.cat_id, i.image_name, i.image_hits, i.image_thumb_file, i.image_media_file, c.cat_name".get_user_table_field(", u.", "user_name")."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 NOT IN ($cat_id_sql) AND i.cat_id = c.cat_id$cat_match_sqlORDER BY i.image_hits DESC, i.image_name ASCLIMIT 10";$result = $site_db->query($sql);$top_list = array();$i = 1;while ($row = $site_db->fetch_array($result)) {$top_list[$i] = $row;$i++;}$site_db->free_result();for ($i = 1; $i <= 10; $i++) {if (isset($top_list[$i])) {$image_hits_thumb_[$i] = empty($top_list[$i]['image_thumb_file']) ? "<img src=\"".ICON_PATH."/".get_file_extension($top_list[$i]['image_media_file']).".gif".\">" : "<a href=\"".$site_sess->url(ROOT_PATH."details.php?".URL_IMAGE_ID."=".$top_list[$i]['image_id'])."\"><img src=\"".ROOT_PATH.THUMB_DIR."/".$top_list[$i]['cat_id']."/".$top_list[$i]['image_thumb_file']."\">";$image_hits_[$i] = $register_array['image_hits_'.$i] = (check_permission("auth_viewimage", $top_list[$i]['cat_id'])) ? "<a href=\"".$site_sess->url(ROOT_PATH."details.php?".URL_IMAGE_ID."=".$top_list[$i]['image_id'])."\">".htmlspecialchars($top_list[$i]['image_name'])."</a>" : htmlspecialchars($top_list[$i]['image_name']);$register_array['image_hits_openwindow_'.$i] = (check_permission("auth_viewimage", $top_list[$i]['cat_id'])) ? "<a href=\"".$site_sess->url(ROOT_PATH."details.php?".URL_IMAGE_ID."=".$top_list[$i]['image_id'])."\" onclick=\"opendetailwindow()\" target=\"detailwindow\">".htmlspecialchars($top_list[$i]['image_name'])."</a>" : htmlspecialchars($top_list[$i]['image_name']);if (isset($top_list[$i][$user_table_fields['user_name']]) && $top_list[$i]['user_id'] != GUEST) {$user_profile_link = (!empty($url_show_profile)) ? preg_replace("/{user_id}/", $top_list[$i]['user_id'], $url_show_profile) : ROOT_PATH."member.php?action=showprofile&".URL_USER_ID."=".$top_list[$i]['user_id'];$image_hits_user_[$i] = $register_array['image_hits_user_'.$i] = "<a href=\"".$site_sess->url($user_profile_link)."\">".htmlspecialchars($top_list[$i][$user_table_fields['user_name']])."</a>";}else {$image_hits_user_[$i] = $register_array['image_hits_user_'.$i] = $lang['userlevel_guest'];}$image_hits_cat_[$i] = $register_array['image_hits_cat_'.$i] = "<a href=\"".$site_sess->url(ROOT_PATH."categories.php?".URL_CAT_ID."=".$top_list[$i]['cat_id'])."\">".htmlspecialchars($top_list[$i]['cat_name'])."</a>";$image_hits_number_[$i] = $register_array['image_hits_number_'.$i] = "<b>".$top_list[$i]['image_hits']."</b>";}else {$image_hits_thumb_[$i] = $register_array['image_hits_thumb'.$i] = "--";$image_hits_[$i] = $register_array['image_hits_'.$i] = "--";$image_hits_user_[$i] = $register_array['image_hits_user_'.$i] = "--";$image_hits_cat_[$i] = $register_array['image_hits_cat_'.$i] = "--";$image_hits_number_[$i] = $register_array['image_hits_number_'.$i] = "--";}}$top_hits_10 = " <table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"1\"><tr> <td class=\"bordercolor\"> <table width=\"100%\" border=\"0\" cellpadding=\"3\" cellspacing=\"0\"><tr> <td class=\"head1\" valign=\"top\" colspan=\"5\">$lang_top_image_hits</td></tr><tr> <td valign=\"top\" class=\"row1\" align=\"center\"><b>1</b></td><td valign=\"top\" class=\"row1\">$image_hits_thumb_[1]</td><td valign=\"top\" class=\"row1\">$image_hits_[1]</td><td valign=\"top\" class=\"row1\">$image_hits_user_[1]</td><td valign=\"top\" class=\"row1\">$image_hits_cat_[1]</td><td valign=\"top\" class=\"row1\" nowrap>$image_hits_number_[1]</td></tr><tr> <td valign=\"top\" class=\"row2\" align=\"center\"><b>2</b></td><td valign=\"top\" class=\"row2\">$image_hits_thumb_[2]</td><td valign=\"top\" class=\"row2\">$image_hits_[2]</td><td valign=\"top\" class=\"row2\">$image_hits_user_[2]</td><td valign=\"top\" class=\"row2\">$image_hits_cat_[2]</td><td valign=\"top\" class=\"row2\" nowrap>$image_hits_number_[2]</td></tr><tr> <td valign=\"top\" class=\"row1\" align=\"center\"><b>3</b></td><td valign=\"top\" class=\"row1\">$image_hits_thumb_[3]</td><td valign=\"top\" class=\"row1\">$image_hits_[3]</td><td valign=\"top\" class=\"row1\">$image_hits_user_[3]</td><td valign=\"top\" class=\"row1\">$image_hits_cat_[3]</td><td valign=\"top\" class=\"row1\" nowrap>$image_hits_number_[3]</td></tr><tr> <td valign=\"top\" class=\"row2\" align=\"center\"><b>4</b></td><td valign=\"top\" class=\"row2\">$image_hits_thumb_[4]</td><td valign=\"top\" class=\"row2\">$image_hits_[4]</td><td valign=\"top\" class=\"row2\">$image_hits_user_[4]</td><td valign=\"top\" class=\"row2\">$image_hits_cat_[4]</td><td valign=\"top\" class=\"row2\" nowrap>$image_hits_number_[4]</td></tr><tr> <td valign=\"top\" class=\"row1\" align=\"center\"><b>5</b></td><td valign=\"top\" class=\"row1\">$image_hits_thumb_[5]</td><td valign=\"top\" class=\"row1\">$image_hits_[5]</td><td valign=\"top\" class=\"row1\">$image_hits_user_[5]</td><td valign=\"top\" class=\"row1\">$image_hits_cat_[5]</td><td valign=\"top\" class=\"row1\" nowrap>$image_hits_number_[5]</td></tr><tr> <td valign=\"top\" class=\"row2\" align=\"center\"><b>6</b></td><td valign=\"top\" class=\"row2\">$image_hits_thumb_[6]</td><td valign=\"top\" class=\"row2\">$image_hits_[6]</td><td valign=\"top\" class=\"row2\">$image_hits_user_[6]</td><td valign=\"top\" class=\"row2\">$image_hits_cat_[6]</td><td valign=\"top\" class=\"row2\" nowrap>$image_hits_number_[6]</td></tr><tr> <td valign=\"top\" class=\"row1\" align=\"center\"><b>7</b></td><td valign=\"top\" class=\"row1\">$image_hits_thumb_[7]</td><td valign=\"top\" class=\"row1\">$image_hits_[7]</td><td valign=\"top\" class=\"row1\">$image_hits_user_[7]</td><td valign=\"top\" class=\"row1\">$image_hits_cat_[7]</td><td valign=\"top\" class=\"row1\" nowrap>$image_hits_number_[7]</td></tr><tr> <td valign=\"top\" class=\"row2\" align=\"center\"><b>8</b></td><td valign=\"top\" class=\"row2\">$image_hits_thumb_[8]</td><td valign=\"top\" class=\"row2\">$image_hits_[8]</td><td valign=\"top\" class=\"row2\">$image_hits_user_[8]</td><td valign=\"top\" class=\"row2\">$image_hits_cat_[8]</td><td valign=\"top\" class=\"row2\" nowrap>$image_hits_number_[8]</td></tr><tr> <td valign=\"top\" class=\"row1\" align=\"center\"><b>9</b></td><td valign=\"top\" class=\"row1\">$image_hits_thumb_[9]</td><td valign=\"top\" class=\"row1\">$image_hits_[9]</td><td valign=\"top\" class=\"row1\">$image_hits_user_[9]</td><td valign=\"top\" class=\"row1\">$image_hits_cat_[9]</td><td valign=\"top\" class=\"row1\" nowrap>$image_hits_number_[9]</td></tr><tr> <td valign=\"top\" class=\"row2\" align=\"center\"><b>10</b></td><td valign=\"top\" class=\"row2\">$image_hits_thumb_[10]</td><td valign=\"top\" class=\"row2\">$image_hits_[10]</td><td valign=\"top\" class=\"row2\">$image_hits_user_[10]</td><td valign=\"top\" class=\"row2\">$image_hits_cat_[10]</td><td valign=\"top\" class=\"row2\" nowrap>$image_hits_number_[10]</td></tr></table></table>";?>
Saludos,,,ya sale el nombre del usuario y el de la imagen,,, junto con el de la categoría.