forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: Toddyuk on March 24, 2007, 05:03:25 pm

Title: Changing View Count
Post by: Toddyuk on March 24, 2007, 05:03:25 pm

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

Title: Re: Changing View Count
Post by: Stramm on March 24, 2007, 05:57:50 pm

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

Title: Re: Changing View Count
Post by: Toddyuk on March 24, 2007, 11:33:17 pm

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

Thanks for your help

Todd

Title: Re: Changing View Count
Post by: Stramm on March 25, 2007, 10:56:00 am

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'