<?php $q = prepare("SELECT * FROM person WHERE dailyTaskEmail = 'yes'"); $db = new db_alloc(); $db->query($q); while ($r = $db->row()) { $person = new person(); $person->set_id($r["personID"]); $person->select(); $person->load_prefs(); $person->prefs["dailyTaskEmail"] = 'yes'; $person->store_prefs(); }
function store_prefs() { $p = new person(); $p->set_id($this->get_id()); $p->select(); $p->load_prefs(); $old_prefs = $p->prefs or $old_prefs = array(); foreach ($old_prefs as $k => $v) { if ($this->prefs[$k] != $v) { $save = true; } } foreach ($this->prefs as $k => $v) { if ($old_prefs[$k] != $v) { $save = true; } } if ($save || (!is_array($old_prefs) || !count($old_prefs))) { $arr = serialize($this->prefs); $p->set_value("sessData", $arr); $p->currency = config::get_config_item('currency'); $p->save(); } }