function regacc($fname, $lname, $phone, $email, $pwd, $dob, $streetname, $postalcode, $country, $city)
{
global $db;
if (isset($fname) && isset($lname) && isset($phone) && isset($email) && isset($pwd) && isset($dob) && isset($streetname) && isset($postalcode) && isset($country) && isset($city)) {
$id = get_newid("ms_member", "id");
$strsql = "\n\t\t\tINSERT INTO ms_member(id,password,firstname,lastname,phone,email,hash,referral,active,cretime,creby) \n\t\t\tVALUES\n\t\t\t(\n\t\t\t\t" . $db->escape($id) . ",\n\t\t\t\t'" . $db->escape(sha1($pwd)) . "',\t\t\t\t\t\t\n\t\t\t\t'" . $db->escape($fname) . "',\t\t\t\t\n\t\t\t\t'" . $db->escape($lname) . "',\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t'" . $db->escape($phone) . "',\t\t\t\t\t\t\t\t\n\t\t\t\t'" . $db->escape($email) . "',\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t'abc',\n\t\t\t\t'',\n\t\t\t\t0,\n\t\t\t\tNOW(),\t\t\t\t\t\t\t\t\n\t\t\t\t'" . $db->escape($email) . "'\t\t\t\t\t\n\t\t\t)\n\t\t";
$register = $db->query($strsql);
if ($register) {
return true;
} else {
return false;
}
} else {
return false;
}
}
exit;
}
if ($f_save) {
if (!$f_name) {
echo "<script language=\"javascript\">WinOpen('request.php?&msg=0','request',520,40)</script>";
} else {
if (!is_null($f_pos)) {
update_data("referenz","pos=pos+1","pos>=".$f_pos);
$pos = $f_pos;
}
if (!$pos) {
$pos = 0;
}
if (!$id) {
$id = get_newid("referenz");
}
for ($x = 0; $x < 6; $x++) {
if (${"f_pic_title_".$x}) {
$pic_tits[$x] = ${"f_pic_title_".$x};
} else {
$pic_tits[$x] = "---";
}
}
$pic_titstr = implode("#",$pic_tits);
$fields = implode(",",get_field_names("referenz"));
$vals = "'".$id."','".addslashes($f_name)."','".addslashes($f_txt)."','".addslashes($pic_titstr)."','".$picstr."','".$pos."'";
replace_data("referenz",$fields,$vals);
echo "<script language=\"javascript\">self.location.href='list.php'</script>";
exit;
}