coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: empfl on December 08, 2007, 02:54:02 PM

Title: manual set of counter
Post by: empfl on December 08, 2007, 02:54:02 PM
hello,

i had to upload a file oncemore after i have deleted it.

now my question, how can i set the counte rmanually to f. example to 199 ???

Title: Re: manual set of counter
Post by: Joachim Müller on December 08, 2007, 02:59:23 PM
Why did you delete it in the first place?
Anyway: there's no method built into the coppermine user interface to set the counter to a specific value. You'll need to manipulate the database directly, using a tool like phpMyAdmin. I'm pretty sure that this has been discussed in detail already, so please use the search.
Title: Re: manual set of counter
Post by: empfl on December 08, 2007, 04:11:15 PM
Thx GauGau,

i've used the search, i searched von manual counter set.
i've nothing, really, even perhaps i gave up to soon ;-)
sorry
Title: Re: manual set of counter
Post by: Joachim Müller on December 08, 2007, 06:27:17 PM
Something like UPDATE `CPG_pictures` SET `hits` = '199' WHERE `pid` =1234 LIMIT 1 ;should do the trick, where "1234" in the example is the ID of the pic and "CPG" is the table prefix you chose during install. Not recommended for total newbies.