Reset Banner Statistics to Zero?

[thomasw98]

OK, testing is nearly done...any idea how I can reset the banner statistics to zero?

[econcepts]

I don't see anything in the system for that, but could you simply "copy" a banner (create a new one) thus setting that those stats to zero.

Just a thought.

[thomasw98]

I don't see anything in the system for that, but could you simply "copy" a banner (create a new one) thus setting that those stats to zero.

Just a thought.

YEah, I tought of that too. I was just checking to see if there was some cool feature that I did not know about...I'm still learning the ins and outs of zencart.

[bekinky]

update banners_history SET banners_shown="0" where banners_id="1";

run the above code in your admin/sql manager or direct in phpmyadmin to set a particular banner to 0. Just change the banners_id number

or

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

will update them all

[thomasw98]

update banners_history SET banners_shown="0" where banners_id="1";

run the above code in your admin/sql manager or direct in phpmyadmin to set a particular banner to 0. Just change the banners_id number

or

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

will update them all

The first time I tried that command, I got an error:

Table 'uv18g1_db.banners_history' doesn't exist

I then looked at the database and found that my database name has "zen_" attached to the front. So I reran the command as:

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

Worked perfectly! All the displays status numbers returned to zero for all of my banners.

Filled with confidence, I then ran this command:

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

This reset all the click status counters for all banners to zero. Cool!

Thanks for the lesson in sql-ish!