How do I zero out the banner clicks?

[jottoleivi]

In the banner manager are we able to see Displays / Clicks Status. Is there anyway to zero out the 675/0 so that it says 0/0.

Help appreciated.

[Ajeh]

This information is stored in the banners_history of the database ...

If you want ALL history to restart, you can EMPTY this table via phpMyAdmin ...

Or, you can remove the records for a particular banners_id ...

[atlantisphoto]

This is the little text file I wrote to myself so I didn't forget. Not sure if it will help you. I guess if you use cPanel it should be dead on. If not...uh...sorry.


Go to cPanel. Click MySQL Databases Logo. Click on the bottom link on page "phpMyAdmin" (text).
Click proper website, then click small logo at left top bar that says SQL. Copy and paste the below lines in the box. Hit GO. You Are Done.



update zen_banners_history SET banners_shown="0" where banners_id IS NOT NULL;

update zen_banners_history SET banners_clicked="0" where banners_id IS NOT NULL;