Changing View Count

[Toddyuk]

Hi i was wondering if its possible to manually change the view count for each pic ?

Reason iam asking is , I accidentally dropped the coppermine Tables (Doh!) , I can upload all the pics again no prob , But can i adjust the count views back up etc ?

Thanks for any help

Todd

[Stramm]

you need to edit the mysql pictures table with a tool l ike phpmyadmin (backing up the db before you do so is recommended)

[Toddyuk]

Could you tell which table exactley plz, as i cant find it .

Thanks for your help

Todd

[Stramm]

look into the database you created (you should know how you named it), then find a table with the name CPG_pictures (replace CPG with the prefix you entered whilst the setup). In that table the field 'hits' stores the 'viewcount'