- //////////////////////////////
- // Create user's account... //
- //////////////////////////////
- //
- $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_user_data (sex, surname, family, street_nr, %s, zip, city, email, birth_day, birth_month, birth_year, password, max_mails, receive_mails, refid, status, user_hash, REMOTE_ADDR, joined, last_update".$ADD1.")
-VALUES ('%s', '%s', '%s', '%s', '%s', %d, '%s', '%s', %d, %d, %d, '%s', %d, %d, %d, 'UNCONFIRMED', '%s', '%s', UNIX_TIMESTAMP(), UNIX_TIMESTAMP()".$ADD2.")",
-array(
- $countryRow,
- SQL_ESCAPE(substr($_POST['sex'], 0, 1)),
- SQL_ESCAPE($_POST['surname']),
- SQL_ESCAPE($_POST['family_name']),
- SQL_ESCAPE($_POST['street_nr']),
- $countryData,
- bigintval($_POST['zip']),
- SQL_ESCAPE($_POST['city']),
- SQL_ESCAPE($_POST['addy']),
- bigintval($_POST['day']),
- bigintval($_POST['month']),
- bigintval($_POST['year']),
- generateHash($_POST['pass1']),
- bigintval($_POST['max_mails']),
- bigintval($_POST['max_mails']),
- bigintval($_POST['refid']),
- $hash,
- getenv('REMOTE_ADDR'),
-), __FILE__, __LINE__);
-
- // Get his userid
- $result = SQL_QUERY_ESC("SELECT userid FROM "._MYSQL_PREFIX."_user_data WHERE user_hash='%s' LIMIT 1",
- array($hash), __FILE__, __LINE__);
- list($userid) = SQL_FETCHROW($result);
-
- // Secure userid (we have a little paranoia ;-) )
- $userid = bigintval($userid);
-
- // Write his welcome-points
- $result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_user_points WHERE userid=%d AND ref_depth=0 LIMIT 1",
- array(bigintval($userid)), __FILE__, __LINE__);
- if (SQL_NUMROWS($result) == 0)
- {
- // Add only when the line was not found (maybe some more secure?)
- $locked = "points";
- if ($_CONFIG['ref_payout'] > 0) $locked = "locked_points"; // Pay him later. First he has to confirm some mails!
- $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_user_points (userid, ref_depth, ".$locked.") VALUES(%d, 0, '%s')",
- array(bigintval($userid), $_CONFIG['points_register']), __FILE__, __LINE__);
-
- // Update mediadata as well
- if ((GET_EXT_VERSION("mediadata") >= "0.0.4") && ($locked == "points")) {
- // Update database
- MEDIA_UPDATE_ENTRY(array("total_points"), "add", $_CONFIG['points_register']);
+ // Output success registration
+ displayMessage('{--REGISTRATION_DONE--}');
+} else {
+ // Do this only if form is sent
+ if (isFormSent()) {
+ if (postRequestParameter('agree') == '!') {
+ registerOutputFailedMessage('HAVE_TO_AGREE');
+ } // END - if
+
+ if (postRequestParameter('email') == '!') {
+ registerOutputFailedMessage('ENTER_EMAIL');
+ setPostRequestParameter('email', '');
+ } elseif (postRequestParameter('email') == '?') {
+ registerOutputFailedMessage('GUEST_EMAIL_ALREADY_DB');
+ setPostRequestParameter('email', '');