Para que las imagenes nuevas vayan rotando en la pagina principal

[mendozak]

Hola me gustaria saber si alguien sabe como hacer ke las imagenes nuevas vayan rotando en la pagina principal.. para que asi se puedan ir viendo todas aunke meta muchas de un tiron.. He estado buscando y no encuentro el mod, me acuerdo que lo hice una vez pero ya no se como volver a hacerlo..

Ayuda porfavor. dios se lo pagara.

[ascanio]

Hola

En index.php:

Busca:

Code: [Select]

$num_new_images = $config['image_cells'];
$sql = "SELECT i.image_id, i.cat_id, i.user_id, i.image_name, 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".$additional_sql.", 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 c.cat_id = i.cat_id AND i.cat_id IN (".get_auth_cat_sql("auth_viewcat").")
       ORDER BY i.image_date DESC
       LIMIT $num_new_images";

Remplaza por:

Code: [Select]

$new_cutoff = time() - 60 * 60 * 24 * $config['new_cutoff'];
$num_new_images = $config['image_cells'];
$sql = "SELECT IF(i.image_date >= $new_cutoff,RAND()+1,1) as random_no, i.image_id, i.cat_id, i.user_id, i.image_name, 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".$additional_sql.", 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 c.cat_id = i.cat_id AND i.cat_id IN (".get_auth_cat_sql("auth_viewcat").")
       ORDER BY random_no DESC, i.image_date DESC
       LIMIT $num_new_images";

Si quieres que hay mas de una fila como en mi pagina:

Busca:

Code: [Select]

$num_new_images = $config['image_cells'];
Remplaza por:

Code: [Select]

$num_new_images = $config['image_cells']*2;

[mendozak]

Perfecto.. muchas gracias... ke rapidez asi da gusto.. ole por ti.

[theolbap]

No funciona en la version 1.7.3

An unexpected error occured. Please try again later.

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /www/docs/ahmira.com.ar/public_html/includes/db_mysql.php on line 116

Como podemos arreglarlo??

Saludos..

[noguero]

con la 1.7.2 va perfecto, excelente

[excitex2]

Saludos,,,

Para la versión 1.7.3 intenta hacer la siguiente modificación :

Localiza en index.php :

$num_new_images = $config['image_cells'];
$sql = "SELECT i.image_id, i.cat_id, i.user_id, i.image_name, 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".$additional_sql.", 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 c.cat_id = i.cat_id AND i.cat_id NOT IN (".get_auth_cat_sql("auth_viewcat", "NOTIN").")
        ORDER BY i.image_date DESC
        LIMIT $num_new_images";

Cambia a :

[qcode]$new_cutoff = time() - 60 * 60 * 24 * $config['new_cutoff'];
$num_new_images = $config['image_cells'];
$sql = "SELECT IF(i.image_date >= $new_cutoff,RAND()+1,1) as random_no, i.image_id, i.cat_id, i.user_id, i.image_name, 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".$additional_sql.", 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 c.cat_id = i.cat_id AND i.cat_id NOT IN (".get_auth_cat_sql("auth_viewcat", "NOTIN").")
        ORDER BY random_no DESC, i.image_date DESC
        LIMIT $num_new_images";
[/qcode]

excitex2

[theolbap]

gracias !!! funciona de 10

le cambie

$num_new_images = $config['image_cells'];

por

$num_new_images = $config['image_cells']*3;

para que se vean la cantidad de imagenes que ya tenia...

[paburmester]

una simple pregunta, este MOD funciona tambien para mostrar imagenes aleatorias que no sean nuevas?

[KaKo_83]

Gracias excitex va de 10 , yo tb tengo la version 1.7.3

Ahhh y tu galeria esta genial, jeje


==================
http://www.solotattoos.net

[tripiyon]

Gracias,

Funcionando en la versión 1.7.6 perfectamente