Reset TV values via snippet

Is there a way to set/reset a TV value with a snippet over multiple pages?

I have a TV "counter" for each page that needs to be reset [to 0] every month on every page.

How would I go about doing this?

-thanks
-sean

This should do it if you are using MODx Revolution (untested):



Just put the tag [[ResetCounters]] on a page that is unpublished and/or hidden from menus and preview that page once a month.

Thanks Bob;

I was looking at resetting all the vars using a database query, this is much cleaner... though would have to be scheduled VIA a cron job, which I was hoping to avoid...

-thanks
-sean

Since you want it done on the first of every month, you could store the current month somewhere (e.g. a file or a system setting), then check it in index.php. When the current month doesn’t match the stored month -- run the snippet and reset the stored month. The first person to visit the site after midnight on the 1st of each month would trigger it. I doubt if it would take more than a second or two to run.

Just a note to point out that if you are using a TV to flag the items you want included in each EmailResource mailing, you can adapt Bob's snippet to reset the TV after the mailing. That is, if you have a checkbox labelled "Include in mailing" which can be ticked for all the items in your mailing, then this is a way to set those checkboxes to blank again before your next new mailing.

Bob, one day when you have nothing better to do (!) this would be a nice optional add-on to EmailResource.

Quote from: BobRay at Aug 08, 2011, 05:52 PM

This should do it if you are using MODx Revolution (untested):

<!--?php
/* ResetCounters snippet */

$tvId = ##; // set to the ID of the 'counter' TV.

/* Get the templateVarResource objects */

$tvrs = $modx--->getCollection('modTemplateVarResource', array('tmplvarid' => $tvId));

if (! empty ($tvrs)) {

    foreach($tvrs as $tvr) {
        $tvr->set('value', 0);
        $tvr->save();
   }

} else {

    return 'No templateVarResource objects found';
}

return 'TVs reset';

Just put the tag [[ResetCounters]] on a page that is unpublished and/or hidden from menus and preview that page once a month.

Marvelous, thank you Bob!

Glad I could help.


I should have said to use this tag (with the exclamation point):




If you can set up a cron job (usually possible in cPanel), and the page is published, but not shown in menus, you should be able to create a monthly one that visits the page:



If cPanel doesn't help you fill in the date options, the full line would be:



(0 0 1 * * means: minute 0, hour 0, of day 1, for every month, and every year.)

That will execute just after midnight on the first day of each month. Note that the first two characters are zeros, but the -O is the capital letter O.