$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();
}
}
