$query .= prepare(" AND skillID = %d", $_POST["skillID"][$i]); $db->query($query); if (!$db->next_record()) { $proficiency->save(); } } } } } } } if ($_POST["save"]) { $person->read_globals(); if ($person->can_write_field("perms")) { $_POST["perm_select"] or $_POST["perm_select"] = array(); $person->set_value("perms", implode(",", $_POST["perm_select"])); } if ($_POST["password1"] && $_POST["password1"] == $_POST["password2"]) { $person->set_value('password', encrypt_password($_POST["password1"])); } else { if (!$_POST["password1"] && $personID) { // nothing required here, just don't update the password field } else { alloc_error("Please re-type the passwords"); } } if ($_POST["username"]) { $q = prepare("SELECT personID FROM person WHERE username = '******'", $_POST["username"]); $db = new db_alloc(); $db->query($q); $num_rows = $db->num_rows();
Surname, Password, E-mail, Phone No, Comments */ $cur = config::get_config_item("currency"); $row = 1; if (($handle = fopen("../../David_People.csv", "r")) !== FALSE) { while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { foreach ($data as $key => $val) { # $data[$key] = utf8_encode($data[$key]); } $person = new person(); $person->currency = $cur; $person->set_value("username", $data[0]); $person->set_value("firstName", $data[1]); $person->set_value("surname", $data[2]); $person->set_value("password", encrypt_password($data[3])); $person->set_value("emailAddress", $data[4]); $person->set_value("phoneNo1", $data[5]); $person->set_value("comments", $data[6]); $person->set_value("perms", "employee"); $person->set_value("personActive", 1); $person->set_value("personModifiedUser", $current_user->get_id()); $person->save(); $x++; echo "<br>here: " . $person->get_id() . $data[0]; if ($x > 4) { //die(); }
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(); } }