Please, tell me there's a way to import all the old hits that were using this method
http://www.zenphoto.org/support/topic.php?id=332&replies=17
to the new hitcounter function. Otherwise I might cry.
I have almost 7000 images, changing hits manually would take ages. :'(
I can tell you how to set the counter in zenphoto, but you will have to figure out how to retrieve it from wherever it is.
Assuming all your image names are unique and your table prefix is 'zp_':
UPDATE zp_images SET hitcounter = 'value' WHERE filename = 'image name';
value is the new hitcount and image name is the filename of the image to get the counter.
The forum is a bit nasty with the peck marks required by SQL. The green words in the query are all supposed to be enclosed in peck marks.
I don't know very much about mysql or php so I'm doing something wrong.
Here's what I did: I took your code and made it like this http://www.freewebs.com/sf95/junk/sql.txt (first line says