« previous next »
Pages: 1 [2] 3

Author Topic: Mostrar TOP 10 en la pagina pricinpal  (Read 39918 times)

0 Members and 1 Guest are viewing this topic.

Offline excitex2

  • Addicted member
  • ******
  • Posts: 1.590
  • He desactivado la galería y el buscador
    • View Profile
Re: Mostrar TOP 10 en la pagina pricinpal
« Reply #15 on: March 29, 2006, 01:54:38 AM »
Saludos,,

Como lo quieres ?????
Logged
Lo importante no es saber,,, lo importante es tener el E-Mail de quien sabe

Offline Stoleti

  • Hero Member
  • *****
  • Posts: 574
    • View Profile
Re: Mostrar TOP 10 en la pagina pricinpal
« Reply #16 on: March 29, 2006, 01:57:42 AM »
only :

Top 10 (Rating)

username1
username2
username3
.....

and without borders (sorry for this be in english)  :(
Logged

Offline excitex2

  • Addicted member
  • ******
  • Posts: 1.590
  • He desactivado la galería y el buscador
    • View Profile
Re: Mostrar TOP 10 en la pagina pricinpal
« Reply #17 on: March 29, 2006, 02:10:13 AM »
Saludos,,,

Mira a ver si lo que quieres es esto : http://www.4homepages.de/forum/index.php?topic=7678.msg34844#msg34844

excitex2
Logged
Lo importante no es saber,,, lo importante es tener el E-Mail de quien sabe

Offline Stoleti

  • Hero Member
  • *****
  • Posts: 574
    • View Profile
Re: Mostrar TOP 10 en la pagina pricinpal
« Reply #18 on: March 29, 2006, 02:52:21 AM »
Quote from: excitex2 on March 29, 2006, 02:10:13 AM
Saludos,,,

Mira a ver si lo que quieres es esto : http://www.4homepages.de/forum/index.php?topic=7678.msg34844#msg34844

excitex2

yes and no.

the style its correct, but on this case , we want top 10 by rate (using usernames).

i've 2 categories (1 / 9 ) , i want this show the right top in right category/details.php page :D

http://www.4homepages.de/forum/index.php?topic=11870.msg63353#msg63353  but without table borders.
Logged

Offline ascanio

  • Hero Member
  • *****
  • Posts: 569
    • View Profile
    • http://www.surfourspace.net
Re: Mostrar TOP 10 en la pagina pricinpal
« Reply #19 on: March 29, 2006, 03:21:55 AM »
Muchas Gracias! =)
oye te acuerdas de un mod que hicistes hace bastante tiempo que guardaba todos los emails y nombres de los usuarios en un archivo de texto ??
aun lo tienes? no lo encuentro en el foro :s
Logged

Offline excitex2

  • Addicted member
  • ******
  • Posts: 1.590
  • He desactivado la galería y el buscador
    • View Profile
Re: Mostrar TOP 10 en la pagina pricinpal
« Reply #20 on: March 29, 2006, 03:17:33 PM »
Saludos amigo Ascanio,,,

Lo tenía olvidado por esos rincones de objetos perdidos,, pero lo he recuperado  :P :twisted:

Lo he insertado de nuevo en : http://www.4homepages.de/forum/index.php?topic=12349.msg66149#msg66149

excitex2
Logged
Lo importante no es saber,,, lo importante es tener el E-Mail de quien sabe

Offline ascanio

  • Hero Member
  • *****
  • Posts: 569
    • View Profile
    • http://www.surfourspace.net
Re: Mostrar TOP 10 en la pagina pricinpal
« Reply #21 on: March 29, 2006, 07:52:52 PM »
Logged

Offline Flakkk

  • Jr. Member
  • **
  • Posts: 74
    • View Profile
Re: Mostrar TOP 10 en la pagina pricinpal
« Reply #22 on: May 25, 2006, 04:19:01 AM »
Buenas, he instalado con exito este mod  :wink: y quisiera saber que modifico para que las columnas "autos" "categoria" y numero de visitas" tengan un titulo tal asi como aparece "TOP 5 imagenes mas vistas"

Saludos.

Mi galeria es esta:  www.treneshoy.com.ar/4images
Logged

Offline ccsakuweb

  • Sr. Member
  • ****
  • Posts: 498
  • Patri
    • View Profile
    • My Art
Re: Mostrar TOP 10 en la pagina pricinpal
« Reply #23 on: April 05, 2007, 08:43:20 PM »
hola ^^ muy bueno mod. bueno he puesto para que en home se vean las imagenes pero si la imagen no tiene thumbnail se ve una imagen rota en vez de la correspondiente al icono de media.. como podria arreglarlo?? kizas sea mejor subir un thumbnail..  :roll:

gracias de antemano :)
Logged
:arrow: 4images Paid Mods: Links, Blog, Albums, Subdomains for users, Diferent templates for user profile, Related picture in details, Last pictures in details.
And the mod that you request me.   Demo: http://www.myart.es

A website dedicated to artist people who loves drawing, design, writing and more

Offline ccsakuweb

  • Sr. Member
  • ****
  • Posts: 498
  • Patri
    • View Profile
    • My Art
Re: Mostrar TOP 10 en la pagina pricinpal
« Reply #24 on: April 21, 2007, 01:11:36 PM »
por favor, este fallo tambien pasa en mod mostrar ultima imagen, alguien podria ayudarme?
Logged
:arrow: 4images Paid Mods: Links, Blog, Albums, Subdomains for users, Diferent templates for user profile, Related picture in details, Last pictures in details.
And the mod that you request me.   Demo: http://www.myart.es

A website dedicated to artist people who loves drawing, design, writing and more

Offline excitex2

  • Addicted member
  • ******
  • Posts: 1.590
  • He desactivado la galería y el buscador
    • View Profile
Re: Mostrar TOP 10 en la pagina pricinpal
« Reply #25 on: April 21, 2007, 10:32:38 PM »
Saludos,,,

Puedes poner una dirección donde se pueda visualizar eso de "una imagen rota" ?????

excitex
Logged
Lo importante no es saber,,, lo importante es tener el E-Mail de quien sabe

Offline ccsakuweb

  • Sr. Member
  • ****
  • Posts: 498
  • Patri
    • View Profile
    • My Art
Re: Mostrar TOP 10 en la pagina pricinpal
« Reply #26 on: April 22, 2007, 09:24:32 AM »
perdona, pensaba q ya conocias mi web, es en home de http://www.myart.es voy a comentar una imagen q se veria rota para q veas q no se ve el media si no tiene thumbnail.   bueno, por favor, fijate en ultimas imagenes que pasa exactamente lo mismo que en mostrar TOP 10 (en mi caso 5) visitadas, lo que pasa que como todas las ultimas imagenes visitadas se veian con la imagen rota y quedaba feo lo quite, pero el problema esta en ambos mods

gracias de antemano y disculpa las molestias
« Last Edit: April 22, 2007, 09:52:55 AM by ccsakuweb »
Logged
:arrow: 4images Paid Mods: Links, Blog, Albums, Subdomains for users, Diferent templates for user profile, Related picture in details, Last pictures in details.
And the mod that you request me.   Demo: http://www.myart.es

A website dedicated to artist people who loves drawing, design, writing and more

Offline excitex2

  • Addicted member
  • ******
  • Posts: 1.590
  • He desactivado la galería y el buscador
    • View Profile
Re: Mostrar TOP 10 en la pagina pricinpal
« Reply #27 on: April 22, 2007, 11:27:13 PM »
Saludos,,,

A ver,,, en este MOD no tienes ningun fallo verdad ????????  lo tienes en el de ÚLTIMAS IMAGENES .

Estoy buscando el error que te puede dar en este MOD y no logro verlo.

excitex
Logged
Lo importante no es saber,,, lo importante es tener el E-Mail de quien sabe

Offline ccsakuweb

  • Sr. Member
  • ****
  • Posts: 498
  • Patri
    • View Profile
    • My Art
Re: Mostrar TOP 10 en la pagina pricinpal
« Reply #28 on: April 22, 2007, 11:51:05 PM »
Quote from: excitex2 on March 29, 2006, 01:07:36 AM
Saludos,,,

Cambia el script tophits10.php por este otro :

Quote
<?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_sql
ORDER BY i.image_hits 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;
$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&amp;".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>";


?>


excitex2
esta modificacion seria la que me da la imagen rota en los archivos que no tienen thumbnail. esto mismo pasa en ultimas imagenes ademas de los otros problemas. saldria lo mismo que en megabook de ultima imagen comentada, solo que quite los thumbnail de este mod porque quedaban mal ya q habian mas de 1 rotos
Logged
:arrow: 4images Paid Mods: Links, Blog, Albums, Subdomains for users, Diferent templates for user profile, Related picture in details, Last pictures in details.
And the mod that you request me.   Demo: http://www.myart.es

A website dedicated to artist people who loves drawing, design, writing and more

Offline LuKers

  • Pre-Newbie
  • Posts: 1
    • View Profile
Re: Mostrar TOP 10 en la pagina pricinpal
« Reply #29 on: May 27, 2007, 11:32:57 AM »
Buenas, tengo un problema al instalar este MOD es el siguiente :
Quote
Fatal error: Call to undefined function: get_user_table_field() in /home/Xde5456s/public_html/top_rating_10.php on line 10
el codigo utilizado para top_rating_10.php  es:
Quote
<?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>";
?>

Si me podrian ayudar se lo agredeceria :) :)
 
Logged
Pages: 1 [2] 3
« previous next »