forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 miscellaneous => Topic started by: KittyBloom98 on August 30, 2016, 12:34:30 pm

Title: Thumbnails
Post by: KittyBloom98 on August 30, 2016, 12:34:30 pm

I was looking at a old post where someone wanted to edit their thumbnail views and Andre provided them with a code and all. I followed Andre's instructions and it work fine but it edit's all your albums thumbnail views, so is there a way to change the thumbnail views of one specific album not all the thumbnail views of all the albums in your gallery?

Title: Re: Thumbnails
Post by: Αndré on August 30, 2016, 02:04:57 pm

Please post a link of the other thread, so we don't have to re-create everything from scratch.

Title: Re: Re: Thumbnails
Post by: KittyBloom98 on August 30, 2016, 10:21:02 pm

Quote from: Αndré on August 30, 2016, 02:04:57 pm

Please post a link of the other thread, so we don't have to re-create everything from scratch.

Here you go http://forum.coppermine-gallery.net/index.php/topic,78552.20.html

Title: Re: Thumbnails
Post by: Αndré on August 31, 2016, 10:24:15 am

I assume you want to edit this script (http://forum.coppermine-gallery.net/index.php/topic,51863.msg380719.html#msg380719), as I already posted in the other thread (http://forum.coppermine-gallery.net/index.php/topic,78552.msg380631.html#msg380631) how to update the views for a specific album. Right?

Title: Re: Thumbnails
Post by: KittyBloom98 on September 06, 2016, 07:27:50 am

Where exactly did you tell us how to edit a specific album? And yes that is what I meant.

Title: Re: Thumbnails
Post by: Αndré on September 06, 2016, 09:02:43 am

Quote from: KittyBloom98 on September 06, 2016, 07:27:50 am

Where exactly did you tell us how to edit a specific album?

Have you actually clicked the link? It directs you to this post:

Quote from: Αndré on January 13, 2016, 04:32:39 pm

Set number:

Code: [Select]

UPDATE cpg15x_pictures SET hits = 123 WHERE aid = 7(don't forget to adjust the table prefix "cpg15x_" and the values for hits and aid).

Add number:

Code: [Select]

UPDATE cpg15x_pictures SET hits = hits + 123 WHERE aid = 7
Multiply:

Code: [Select]

UPDATE cpg15x_pictures SET hits = hits * 123 WHERE aid = 7

Title: Re: Thumbnails
Post by: KittyBloom98 on October 03, 2016, 11:29:31 am

Sorry, I managed to do the query but I was wondering that script you posted above is there a way to modify/edit where it displays a random number between 1 and 10?

Title: Re: Thumbnails
Post by: Αndré on June 30, 2017, 04:38:57 pm

Quote from: KittyBloom98 on October 03, 2016, 11:29:31 am

is there a way to modify/edit where it displays a random number between 1 and 10?

Yes, in the other link I already posted: http://forum.coppermine-gallery.net/index.php/topic,51863.msg380719.html#msg380719