} } if ($all_ok) { //send email //generate random password $activationcode = mb_strtoupper(mb_substr(md5(uniqid('')), 0, 13)); $country_name = tr($country); $uuid = create_uuid(); if (strtotime("2008-11-01 00:00:00") <= strtotime(date("Y-m-d h:i:s"))) { $rules_conf_req = 1; } else { $rules_conf_req = 0; } //insert the user XDb::xSql("INSERT INTO `user` ( `user_id`, `username`, `password`, `email`, `latitude`,\n `longitude`, `last_modified`, `login_faults`, `login_id`, `is_active_flag`,\n `was_loggedin`, `country`, `date_created`,\n `uuid`, `activation_code`, `node`, `rules_confirmed` )\n VALUES ('', ?, ?, ?, NULL, NULL, NOW(), '0', '0', '0', '0', ?, NOW(), ?, ?, ?, ?)", $username, hash('sha512', md5($password)), $email, $country, $uuid, $activationcode, $oc_nodeid, $rules_conf_req); EmailSender::sendActivationMessage(__DIR__ . '/tpl/stdstyle/email/user_activation.email.html', $username, $country, $activationcode, $email, $uuid); //display confirmationpage $tplname = 'register_confirm'; tpl_set_var('country', htmlspecialchars($country_name, ENT_COMPAT, 'UTF-8')); } else { //set error strings if ($email_not_ok) { tpl_set_var('email_message', $error_email_not_ok); } if ($username_not_ok) { tpl_set_var('username_message', $error_username_not_ok); } if ($email_exists) { tpl_set_var('email_message', $error_email_exists); } if ($username_exists) {